wsiJCInventoryWork
Table: JC10201
Description: Used to create Job Cost Inventory Transactions
Element Name | Data Type | Length | Required | Default | Description |
---|---|---|---|---|---|
@I_vAccountIndexArray21 | int |
| |||
@I_vAccountIndexArray22 | int |
| |||
@I_vAccountIndexArray23 | int |
| |||
@I_vAccountIndexArray24 | int |
| |||
@I_vAccountIndexArray25 | int |
| |||
@I_vBatchNumber | char | 15 | |||
@I_vBatchSource | char | 15 | |||
@I_vCostCodeActualCostTTD | numeric | 19,5 | |||
@I_vCostCodeDescription | char | 31 | |||
@I_vCostElement | smallint |
| |||
@I_vDocumentAmount | numeric | 19,5 | |||
@I_vDocumentDate | datetime |
| |||
@I_vDocumentSource | char | 3 | |||
@I_vGLPostingDate | datetime |
| |||
@I_vItemDescription | char | 101 | |||
@I_vItemNumber | char | 31 | |||
@I_vIVDocumentType | smallint |
| |||
@I_vJobTRXNumber | char | 21 | |||
@I_vJobType | char | 7 | |||
@I_vLineSEQNumber | numeric | 19,5 | |||
@I_vOnlyValidate | tinyint |
| |||
@I_vPostingStatus | smallint |
| |||
@I_vProfitAmount | numeric | 19,5 | |||
@I_vProfitTypeNumber | smallint |
| |||
@I_vReturnErrorText | tinyint |
| |||
@I_vSVLanguageID | smallint |
| |||
@I_vTaxDate | datetime |
| |||
@I_vTimeZone | char | 3 | |||
@I_vTransactionDescription | char | 31 | |||
@I_vTRXLocation | char | 11 | |||
@I_vTRXQTY | numeric | 19,5 | |||
@I_vUnitCost | numeric | 19,5 | |||
@I_vUOfM | char | 9 | |||
@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_vVendorID | char | 15 | |||
@I_vWennsoftAffiliate | char | 15 | |||
@I_vWennsoftBranch | char | 15 | |||
@I_vWennsoftRegion | char | 15 | |||
@I_vWennSoftTablesOnly | tinyint |
| |||
@I_vWSCostCodeNumber1 | char | 7 | |||
@I_vWSCostCodeNumber2 | char | 7 | |||
@I_vWSCostCodeNumber3 | char | 7 | |||
@I_vWSCostCodeNumber4 | char | 7 | |||
@I_vWSJobNumber | char | 17 | |||
@I_vWSProjectNumber | 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 |
---|---|
10004 | Transaction date is not within an open fiscal year. |
51017 | The Job does not exist in Signature. |
51018 | Cost Code does not exist for this Job. |
51050 | An error occurred during an update or insert into a Signature table. |
51050 | An error occurred during an update or insert into a Signature table. |
51089 | The Cost Element must be in the range of 1 to 9. |
51091 | The Inventory Item does not exist. |
51094 | Job is inactive. |
52234 | Transaction Quantity is invalid. |
52236 | Unit of Measure is invalid. |