wsiJobInvoiceUpdateJCJobMSTRRecord
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 |