Skip to main content
Skip table of contents

wsiJCInvoiceSchedule

Table: JC10503

Element NameData TypeLengthRequiredDefaultDescription

@I_vAccountIndex

int

 




@I_vBatchNumber

char

15




@I_vBatchSource

char

15




@I_vBillCodeNumber

char

27




@I_vBilledAmount

numeric

19,5




@I_vBillPct

smallint

 




@I_vCommentID

char

15




@I_vCostElement

smallint

 




@I_vCurrentBill

numeric

19,5




@I_vCurrentDue

numeric

19,5




@I_vLineSEQNumber

numeric

19,5




@I_vOnlyValidate

tinyint

 




@I_vOriginatingBilledAmount

numeric

19,5




@I_vOriginatingCurrentBill

numeric

19,5




@I_vOriginatingCurrentDue

numeric

19,5




@I_vOriginatingRetentionAmount

numeric

19,5




@I_vOriginatingScheduleValue

numeric

19,5




@I_vOriginatingWorkInPlace

numeric

19,5




@I_vRetentionAmount

numeric

19,5




@I_vRetentionBilled

numeric

19,5




@I_vReturnErrorText

tinyint

 




@I_vRMDocumentNumberWORK

char

17




@I_vRMDocumentTypeAll

smallint

 




@I_vScheduleValue

numeric

19,5




@I_vStoredMaterials

numeric

19,5




@I_vSVLanguageID

smallint

 




@I_vTimeZone

char

3




@I_vUnitsBillable

numeric

19,5




@I_vUnitsBilledTTD

numeric

19,5




@I_vUnitsBillingRate

numeric

19,5




@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_vWorkInPlace

numeric

19,5




@I_vWSJobNumber

char

17




@I_vWSReservedCB1

tinyint

 




@I_vWSReservedCB10

tinyint

 




@I_vWSReservedCB2

tinyint

 




@I_vWSReservedCB3

tinyint

 




@I_vWSReservedCB4

tinyint

 




@I_vWSReservedCB5

tinyint

 




@I_vWSReservedCB6

tinyint

 




@I_vWSReservedCB7

tinyint

 




@I_vWSReservedCB8

tinyint

 




@I_vWSReservedCB9

tinyint

 




@I_vWSReservedSTR1

char

11




@I_vWSReservedSTR2

char

11




@I_vWSUserDefinedDate3

datetime

 




@I_vWSUserDefinedDate4

datetime

 




@O_iErrorState

int

 




@oErrString

varchar

255




Error Codes

Error CodeDescription

51013

The Job Number parameter is missing or blank.

51112

Customer number does not exist.

52017

Job Number not found.

52482

Unable to enter bill codes for TRX Level billing type

52483

Unable to enter bill codes for Standard Billing type

52484

The Bill Code Number parameter is missing or blank.

52485

This bill code is completely billed

52486

Insert appropriate error description here

52487

Bill Code was not found for this Job Number

52488

The Document Number cannot be found

52489

The Document Type parameter does not match the Document Type.

52489

Cost element parameter does not match the Bill Code cost element.

52490

Cost element parameter does not match the Bill Code cost element.

52491

Batch number parameter does not match the Document number batch number

52492

Batch source parameter does not match the Document number batch source

52493

Originating Billed Amount parameter does not match the bill code Originating Billed Amount TTD.

52494

Originating Schedule Value does not equal the Originating Total Billable Amount of the Bill Code

52495

Schedule Value does not match the Bill Code Total Billable Amount.

52496

Billed Amount parameter does not match the bill code Billed Amount TTD.

52497

Originating Scheduled Value cannot be greater than Current Bill.

52498

Current Bill cannot be greater than Schedule Value.

52499

Please enter current due

JavaScript errors detected

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

If this problem persists, please contact our support.