wsiJCForecastCostRevisionMSTR
Table Name: JC00201
Other tables affected: Table JC40401 (Transaction_Doc_Number is updated for primary key Document_Number_Type "3")
Other stored procedures called: wsiJCForecastCostRevisionMSTRPre, wsiJCForecastCostRevisionMSTRPost
Description:
This procedure allows the insert or update of records into the Job Cost Forecast Cost Revision Master table.
| Element Name | Data Type | Length | Required | Default | Description |
|---|---|---|---|---|---|
@I_vWSJobNumber | char | 17 | Yes |
| I_vWSJobNumber must be an existing/active job. |
@I_vProjectNumber | char | 17 | No | ' | I_vProjectNumber, if left blank or NULL, will default in from the Job. Otherwise I_vProjectNumber must match the project number assigned to Job. The project must be active. |
@I_vCUSTNMBR | char | 15 | No | ' | I_vCUSTNMBR must be blank. |
@I_vTransactionDocNumber | numeric | 19,5 | Yes |
| For new records pass in NULL as this field will be set by the main stored procedure wsiJCForecastCostRevisionMSTR. Pass in the "Transaction Document Number" when doing an update on an existing record. |
@I_vCostElement | smallint | 5 | Yes |
| The combination of Cost Element and Cost Code Numbers 1, 2, 3, and 4 must exist for the Job in table JC00701. |
@I_vCostCodeNumber1 | char | 7 | Yes |
| The combination of Cost Element and Cost Code Numbers 1, 2, 3, and 4 must exist for the Job in table JC00701. |
@I_vCostCodeNumber2 | char | 7 | Yes |
| The combination of Cost Element and Cost Code Numbers 1, 2, 3, and 4 must exist for the Job in table JC00701. |
@I_vCostCodeNumber3 | char | 7 | Yes |
| The combination of Cost Element and Cost Code Numbers 1, 2, 3, and 4 must exist for the Job in table JC00701. |
@I_vCostCodeNumber4 | char | 7 | Yes |
| The combination of Cost Element and Cost Code Numbers 1, 2, 3, and 4 must exist for the Job in table JC00701. |
@I_vTransactionDate | datetime |
| Yes |
| The transaction date cannot be NULL. Year cannot be 1900, historical, or closed. The transaction date must fall within an open period in JC40602. |
@I_vCostCodeEstUnit | numeric | 19,5 | No | 0 |
|
@I_vEstimatedAmtUnits | numeric | 19,5 | No | 0 |
|
@I_vTransactionAmount | numeric | 19,5 | No | 0 |
|
@I_vWSManagerID | char | 15 | No | ' |
|
@I_vUSERID | char | 15 | No | ' |
|
@I_vShortDescription | char | 31 | Yes |
| I_vShortDescription must not be empty. |
@I_vUserDefine1 | char | 31 | No | ' |
|
@I_vUserDefine2 | char | 31 | No | ' |
|
@I_vUSERDEF1 | char | 21 | No | ' |
|
@I_vUSERDEF2 | char | 21 | No | ' |
|
@I_vUserDefInteger1 | int | 10 | No | 0 |
|
@I_vUserDefInteger2 | int | 10 | No | 0 |
|
@I_vUserDefinedInteger3 | int | 10 | No | 0 |
|
@I_vUserDefinedInteger4 | int | 10 | No | 0 |
|
@I_vUserDefinedDollar1 | numeric | 19,5 | No | 0 |
|
@I_vUserDefinedDollar2 | numeric | 19,5 | No | 0 |
|
@I_vUserDefinedDollar3 | numeric | 19,5 | No | 0 |
|
@I_vUserDefinedDollar4 | numeric | 19,5 | No | 0 |
|
@I_vUSRDAT01 | datetime |
| No | 01/01/1900' |
|
@I_vUSRDAT02 | datetime |
| No | 01/01/1900' |
|
@I_vUserDefinedDate3 | datetime |
| No | 01/01/1900' |
|
@I_vUserDefinedDate4 | datetime |
| No | 01/01/1900' |
|
@I_vUserDefinedCB1 | tinyint | 3 | No | 0 |
|
@I_vUserDefinedCB2 | tinyint | 3 | No | 0 |
|
@I_vUserDefinedCB3 | tinyint | 3 | No | 0 |
|
@I_vUserDefinedCB4 | tinyint | 3 | No | 0 |
|
@I_vWennsoftAffiliate | char | 15 | No | ' |
|
@I_vWennsoftBranch | char | 15 | No | ' |
|
@I_vWennsoftRegion | char | 15 | No | ' |
|
@I_vSVLanguageID | smallint | 5 | No | 0 |
|
@I_vTimeZone | char | 3 | No | ' |
|
@I_vWSReservedCB1 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB2 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB3 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB4 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB5 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB6 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB7 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB8 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB9 | tinyint | 3 | No | 0 |
|
@I_vWSReservedCB10 | tinyint | 3 | No | 0 |
|
@I_vWSReservedSTR1 | char | 11 | No | ' |
|
@I_vWSReservedSTR2 | char | 11 | No | ' |
|
@I_vDEXROWID | int | 10 | No | 0 |
|
@I_vUpdateIfExists | tinyint | 3 | Yes | 0 |
|
@I_vWennSoftTablesOnly | tinyint | 3 | Yes | 0 |
|
@I_vOnlyValidate | tinyint | 3 | Yes | 0 |
|
@I_vUSRDEFND1 | char | 50 | No | ' |
|
@I_vUSRDEFND2 | char | 50 | No | ' |
|
@I_vUSRDEFND3 | char | 50 | No | ' |
|
@I_vUSRDEFND4 | varchar | 8000 | No | ' |
|
@I_vUSRDEFND5 | varchar | 8000 | No | ' |
|
@I_vReturnErrorText | tinyint | 3 | No | 1 |
|
@O_iErrorState | int | 10 | No | 0 |
|
@oErrString | varchar | 255 | No | ' |
|
Error Codes
| Error Code | Description |
|---|---|
51017 | The Job does not exist in Signature. |
51094 | Job is inactive. |
51090 | The Project Number does not exist. |
51234 | Project Number must be for an Active project. |
52279 | The project number is not assigned to the job. |
52301 | Customer Number must be empty. |
51018 | Cost Code does not exist for this Job. |
51064 | Procedure jcVerifyTRXDate failed on invalid date. Year cannot be 1900. |
52306 | The Transaction Date falls within a closed period in Job Cost. |
51066 | Unable to post to historical or closed year. |
52111 | The Transaction Date cannot be before the created date of the job. |