wsiJCInvoiceSchedule
Table: JC10503
Element Name | Data Type | Length | Required | Default | Description |
---|---|---|---|---|---|
@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 Code | Description |
---|---|
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 |