/*<![CDATA[*/ div.rbtoc1765575921942 {padding: 0px;} div.rbtoc1765575921942 ul {list-style: disc;margin-left: 0px;} div.rbtoc1765575921942 li {margin-left: 0px;padding-left: 0px;} /*]]>*/ Table: JC10201 Error Codes
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. |