|
Element Name |
Data Type |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
|
@I_vAccountAmount |
numeric |
19,5 |
|
|
|
|
@I_vActEquipmentCostTTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vActLaborCostTTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vActMaterialsCostTTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vActMiscOtherCostTTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vActSubsCostTTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vActUserDefined1TTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vActUserDefined2TTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vActUserDefined3TTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vActUserDefined4TTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vAddressCode |
char |
15 |
|
|
|
|
@I_vAmountReceived |
numeric |
19,5 |
|
|
|
|
@I_vBatchNumber |
char |
15 |
|
|
|
|
@I_vBatchSource |
char |
15 |
|
|
|
|
@I_vBill |
tinyint |
|
|
|
|
|
@I_vBilledAmountTTD |
numeric |
19,5 |
|
|
|
|
@I_vBilledEquipmentCostTTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vBilledLaborCostTTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vBilledMaterialsCostTTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vBilledMisc1TTD |
numeric |
19,5 |
|
|
|
|
@I_vBilledMisc2TTD |
numeric |
19,5 |
|
|
|
|
@I_vBilledMisc3TTD |
numeric |
19,5 |
|
|
|
|
@I_vBilledMisc4TTD |
numeric |
19,5 |
|
|
|
|
@I_vBilledMisc5TTD |
numeric |
19,5 |
|
|
|
|
@I_vBilledMiscOtherCostTTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vBilledSubsCostTTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vBilledUserDefined1TTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vBilledUserDefined2TTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vBilledUserDefined3TTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vBilledUserDefined4TTDMarkup |
numeric |
19,5 |
|
|
|
|
@I_vCashAmount |
numeric |
19,5 |
|
|
|
|
@I_vCashRemainingAmount |
numeric |
19,5 |
|
|
|
|
@I_vChangedSincePrintingFlag |
tinyint |
|
|
|
|
|
@I_vCommentID |
char |
15 |
|
|
|
|
@I_vCommissionEarnings |
numeric |
19,5 |
|
|
|
|
@I_vCommissionPercent |
smallint |
|
|
|
|
|
@I_vCurrencyID |
char |
15 |
|
|
|
|
@I_vCurrentBillEquipment |
numeric |
19,5 |
|
|
|
|
@I_vCurrentBillLabor |
numeric |
19,5 |
|
|
|
|
@I_vCurrentBillMaterials |
numeric |
19,5 |
|
|
|
|
@I_vCurrentBillMiscOther |
numeric |
19,5 |
|
|
|
|
@I_vCurrentBillSubs |
numeric |
19,5 |
|
|
|
|
@I_vCurrentBillUserDefined1 |
numeric |
19,5 |
|
|
|
|
@I_vCurrentBillUserDefined2 |
numeric |
19,5 |
|
|
|
|
@I_vCurrentBillUserDefined3 |
numeric |
19,5 |
|
|
|
|
@I_vCurrentBillUserDefined4 |
numeric |
19,5 |
|
|
|
|
@I_vCurrentDueEquipment |
numeric |
19,5 |
|
|
|
|
@I_vCurrentDueLabor |
numeric |
19,5 |
|
|
|
|
@I_vCurrentDueMaterials |
numeric |
19,5 |
|
|
|
|
@I_vCurrentDueMiscOther |
numeric |
19,5 |
|
|
|
|
@I_vCurrentDueSubs |
numeric |
19,5 |
|
|
|
|
@I_vCurrentDueUserDefined1 |
numeric |
19,5 |
|
|
|
|
@I_vCurrentDueUserDefined2 |
numeric |
19,5 |
|
|
|
|
@I_vCurrentDueUserDefined3 |
numeric |
19,5 |
|
|
|
|
@I_vCurrentDueUserDefined4 |
numeric |
19,5 |
|
|
|
|
@I_vCustomerNumber |
char |
15 |
|
|
|
|
@I_vCustomerPONumber |
char |
21 |
|
|
|
|
@I_vDatePaid |
datetime |
|
|
|
|
|
@I_vDiscountDate |
datetime |
|
|
|
|
|
@I_vDocumentAmount |
numeric |
19,5 |
|
|
|
|
@I_vDocumentDate |
datetime |
|
|
|
|
|
@I_vDocumentNumber |
char |
21 |
|
|
|
|
@I_vDocumentType |
smallint |
|
|
|
|
|
@I_vDueDate |
datetime |
|
|
|
|
|
@I_vDynamicsStatus |
char |
5 |
|
|
|
|
@I_vFreightTaxAmount |
numeric |
19,5 |
|
|
|
|
@I_vGLPostingDate |
datetime |
|
|
|
|
|
@I_vInvoiceDescription |
text |
|
|
|
|
|
@I_vInvoiceStyle |
smallint |
|
|
|
|
|
@I_vMiscTaxAmount |
numeric |
19,5 |
|
|
|
|
@I_vNoTimesPrinted |
smallint |
|
|
|
|
|
@I_vOnlyValidate |
tinyint |
|
|
|
|
|
@I_vOriginatingBilledAmountTTD |
numeric |
19,5 |
|
|
|
|
@I_vOriginatingDocumentAmount |
numeric |
19,5 |
|
|
|
|
@I_vOriginatingMiscTaxAmount |
numeric |
19,5 |
|
|
|
|
@I_vOriginatingRetentionAmountTTD |
numeric |
19,5 |
|
|
|
|
@I_vOriginatingRetentionBilledTTD |
numeric |
19,5 |
|
|
|
|
@I_vOriginatingSubtotal |
numeric |
19,5 |
|
|
|
|
@I_vOriginatingTaxAmount |
numeric |
19,5 |
|
|
|
|
@I_vOriginatingTradeDiscountAmount |
numeric |
19,5 |
|
|
|
|
@I_vPaymentTermsID |
char |
21 |
|
|
|
|
@I_vPostDate |
datetime |
|
|
|
|
|
@I_vPostingStatus |
smallint |
|
|
|
|
|
@I_vPostUserID |
char |
15 |
|
|
|
|
@I_vPrintedDate |
datetime |
|
|
|
|
|
@I_vReimbursable |
tinyint |
|
|
|
|
|
@I_vRetentionAmountTTD |
numeric |
19,5 |
|
|
|
|
@I_vRetentionBilledTTD |
numeric |
19,5 |
|
|
|
|
@I_vReturnErrorText |
tinyint |
|
|
|
|
|
@I_vRMDocumentNumberWORK |
char |
17 |
|
|
|
|
@I_vRMDocumentTypeAll |
smallint |
|
|
|
|
|
@I_vSalespersonID |
char |
15 |
|
|
|
|
@I_vSalesTerritory |
char |
15 |
|
|
|
|
@I_vSubtotal |
numeric |
19,5 |
|
|
|
|
@I_vSVLanguageID |
smallint |
|
|
|
|
|
@I_vTaxAmount |
numeric |
19,5 |
|
|
|
|
@I_vTaxAmount1 |
numeric |
19,5 |
|
|
|
|
@I_vTaxAmount2 |
numeric |
19,5 |
|
|
|
|
@I_vTaxAmount3 |
numeric |
19,5 |
|
|
|
|
@I_vTaxAmount4 |
numeric |
19,5 |
|
|
|
|
@I_vTaxDate |
datetime |
|
|
|
|
|
@I_vTaxDetailID |
char |
15 |
|
|
|
|
@I_vTaxDetailID1 |
char |
15 |
|
|
|
|
@I_vTaxDetailID2 |
char |
15 |
|
|
|
|
@I_vTaxDetailID3 |
char |
15 |
|
|
|
|
@I_vTaxDetailID4 |
char |
15 |
|
|
|
|
@I_vTaxScheduleID |
char |
15 |
|
|
|
|
@I_vTimeZone |
char |
3 |
|
|
|
|
@I_vTradeDiscountAmount |
numeric |
19,5 |
|
|
|
|
@I_vTRXSource |
char |
13 |
|
|
|
|
@I_vUpdateIfExists |
tinyint |
|
|
|
|
|
@I_vUserDefine1 |
char |
31 |
|
|
|
|
@I_vUserDefine2 |
char |
31 |
|
|
|
|
@I_vUserDefined1 |
char |
21 |
|
|
|
|
@I_vUserDefined2 |
char |
21 |
|
|
|
|
@I_vUserDefinedCB1 |
tinyint |
|
|
|
|
|
@I_vUserDefinedCB2 |
tinyint |
|
|
|
|
|
@I_vUserDefinedCB3 |
tinyint |
|
|
|
|
|
@I_vUserDefinedCB4 |
tinyint |
|
|
|
|
|
@I_vUserDefinedDate1 |
datetime |
|
|
|
|
|
@I_vUserDefinedDate2 |
datetime |
|
|
|
|
|
@I_vUserDefinedDollar1 |
numeric |
19,5 |
|
|
|
|
@I_vUserDefinedDollar2 |
numeric |
19,5 |
|
|
|
|
@I_vUserDefinedDollar3 |
numeric |
19,5 |
|
|
|
|
@I_vUserDefinedDollar4 |
numeric |
19,5 |
|
|
|
|
@I_vUserDefinedInteger1 |
int |
|
|
|
|
|
@I_vUserDefinedInteger2 |
int |
|
|
|
|
|
@I_vUserDefinedInteger3 |
int |
|
|
|
|
|
@I_vUserDefinedInteger4 |
int |
|
|
|
|
|
@I_vUserID |
char |
15 |
|
|
|
|
@I_vUSRDEFND1 |
char |
50 |
|
|
|
|
@I_vUSRDEFND2 |
char |
50 |
|
|
|
|
@I_vUSRDEFND3 |
char |
50 |
|
|
|
|
@I_vUSRDEFND4 |
varchar |
8000 |
|
|
|
|
@I_vUSRDEFND5 |
varchar |
8000 |
|
|
|
|
@I_vWennsoftAffiliate |
char |
15 |
|
|
|
|
@I_vWennsoftBranch |
char |
15 |
|
|
|
|
@I_vWennsoftRegion |
char |
15 |
|
|
|
|
@I_vWennSoftTablesOnly |
tinyint |
|
|
|
|
|
@I_vWSApplicationNumber |
char |
5 |
|
|
|
|
@I_vWSJobNumber |
char |
17 |
|
|
|
|
@I_vWSProjectNumber |
char |
17 |
|
|
|
|
@I_vWSReservedCB1 |
tinyint |
|
|
|
|
|
@I_vWSReservedCB2 |
tinyint |
|
|
|
|
|
@I_vWSReservedCB3 |
tinyint |
|
|
|
|
|
@I_vWSReservedCB4 |
tinyint |
|
|
|
|
|
@I_vWSReservedCB5 |
tinyint |
|
|
|
|
|
@I_vWSReservedSTR1 |
char |
11 |
|
|
|
|
@I_vWSReservedSTR2 |
char |
11 |
|
|
|
|
@I_vWSUserDefinedDate3 |
datetime |
|
|
|
|
|
@I_vWSUserDefinedDate4 |
datetime |
|
|
|
|
|
@O_iErrorState |
int |
|
|
|
|
|
@oErrString |
varchar |
255 |
|
|
|