wsiJobCostInvoiceScheduleOPEN

@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

51013

The Job Number parameter is missing or blank.

51017

The Job does not exist in Signature.

51089

The Cost Element must be in the range of 1 to 9.

51094

Job is inactive.

52322

The batch source must be RM_Sales.

52484

The bill code number parameter is missing or blank.

52561

Parameter @I_vRMDocumentTypeAll must be 1 (Invoice) or 7 (Credit Memo).

52572

Parameter @I_vRMDocumentNumberWORK is empty and must contain a value.

52575

Parameter @I_vBatchNumber must contain a non-empty string value.

52615

An invoice does not exist in table JC_Invoice_OPEN (JC20501).

52615

An invoice does not exist in table JC_Invoice_OPEN (JC20501).

52616

A credit memo does not exist in table JC_Invoice_OPEN (JC20501).

52617

The job billing type must be 2 (User Defined) or 3 (Cost Code) to import into table JC_Invoice_Schedule_OPEN (JC20503).

52618

The bill code number does not exist in table JC_Billing_Codes_MSTR (JC00601).

52619

The line sequence number must be a multiple of 16384.

52620

The line sequence number is already used in table JC_Invoice_Schedule_OPEN (JC20503) for the job and document number.

52621

Parameter @I_vScheduleValue does not equal the total billable amount in table JC_Billing_Codes_MSTR (JC00601).

52622

Parameter @I_vBilledAmount does not equal the bill amount in table JC_Billing_Codes_MSTR (JC00601).

52623

Parameter @I_vCurrentDue does not equal the total billable amount minus the billed amount total to date in table JC_Billing_Codes_MSTR (JC00601).

52624

Document does not exist in table JC_Invoice_OPEN (JC20501).

52625

Parameter @I_vCurrentBill plus current billing in table JC_Invoice_Schedule_OPEN (JC20503) exceeds the current billable labor amount in table JC_Invoice_OPEN (JC20501).

52626

Parameter @I_vCurrentBill plus current billing in table JC_Invoice_Schedule_OPEN (JC20503) exceeds the current billable materials amount in table JC_Invoice_OPEN (JC20501).

52627

Parameter @I_vCurrentBill plus current billing in table JC_Invoice_Schedule_OPEN (JC20503) exceeds the current billable equipment amount in table JC_Invoice_OPEN (JC20501).

52628

Parameter @I_vCurrentBill plus current billing in table JC_Invoice_Schedule_OPEN (JC20503) exceeds the current billable subcontractor amount in table JC_Invoice_OPEN (JC20501).

52629

Parameter @I_vCurrentBill plus current billing in table JC_Invoice_Schedule_OPEN (JC20503) exceeds the current billable miscellaneous amount in table JC_Invoice_OPEN (JC20501).

52630

Parameter @I_vCurrentBill plus current billing in table JC_Invoice_Schedule_OPEN (JC20503) exceeds the current billable user defined 1 amount in table JC_Invoice_OPEN (JC20501).

52631

Parameter @I_vCurrentBill plus current billing in table JC_Invoice_Schedule_OPEN (JC20503) exceeds the current billable user defined 2 amount in table JC_Invoice_OPEN (JC20501).

52632

Parameter @I_vCurrentBill plus current billing in table JC_Invoice_Schedule_OPEN (JC20503) exceeds the current billable user defined 3 amount in table JC_Invoice_OPEN (JC20501).

52633

Parameter @I_vCurrentBill plus current billing in table JC_Invoice_Schedule_OPEN (JC20503) exceeds the current billable user defined 4 amount in table JC_Invoice_OPEN (JC20501).

52634

Parameters @I_vWorkInPlace plus @I_vStoredMaterials must equal @I_vCurrentBill.

52635

Parameter @I_vRetentionAmount plus the sum of retention withheld in table JC_Invoice_Schedule_OPEN (JC20503) exceeds the retention amount total to date in table JC_Invoice_OPEN (JC20501).

52636

'Error updating record in table JC_Invoice_Schedule_OPEN (JC20503).'

52637

'Error inserting record in table JC_Invoice_Schedule_OPEN (JC20503).'