Skip to main content
Skip table of contents

wsiJobInvoiceUpdateJCJobMSTRRecord

Element NameData TypeLengthRequiredDefaultDescription

@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




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.