wsiJCJobEstimates
Table: JC00401
Element Name | Data Type | Length | Required | Default | Description |
---|---|---|---|---|---|
@I_vCostCodeEstimatedUnits | numeric | 19,5 | |||
@I_vCostElement | smallint |
| |||
@I_vCostElementDescription | char | 15 | |||
@I_vCustomerNumber | char | 15 | |||
@I_vEstimatedAmtUnits | numeric | 19,5 | |||
@I_vOnlyValidate | tinyint |
| |||
@I_vReturnErrorText | tinyint |
| |||
@I_vScheduleDate | datetime |
| |||
@I_vShortDescription | char | 31 | |||
@I_vSVLanguageID | smallint |
| |||
@I_vTimeZone | char | 3 | |||
@I_vTransactionAmount | numeric | 19,5 | |||
@I_vTransactionDate | datetime |
| |||
@I_vTransactionDocNumber | 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_vWSCostCodeNumber1 | char | 7 | |||
@I_vWSCostCodeNumber2 | char | 7 | |||
@I_vWSCostCodeNumber3 | char | 7 | |||
@I_vWSCostCodeNumber4 | char | 7 | |||
@I_vWSJobNumber | char | 17 | |||
@I_vWSManagerID | char | 15 | |||
@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. |
51090 | The Project Number does not exist. |
51118 | The project manager does not exist in the payroll master table. |
51200 | The cost code number is blank. |
51202 | The job is blank. |
51203 | The cost element is blank. |
51204 | The cost element does not exist in the cost element setup table. |
51300 | The Transaction Date field is blank. |
51301 | Cannot import estimates because the cost code number does not exist. |
51302 | Cannot import estimates because a password is setup for Revise Estimate Cost. |
51412 | Database error inserting records into table JC00401. |
52100 | The description field is blank. |
52418 | Error updating record in the JC00401 table. |
52481 | The Transaction Amount cannot be zero. |