wsiWSCreateUpdatePurchaseOrderIntegration
Tables: WS10101, SV00300, JC00102, JC00701, PM00200, IV00101, POP10100, POP10110
Description: Integrate Purchase Order Processing to Signature Job Cost or Service Management
Element Name | Data Type | Length | Required | Default | Description |
---|---|---|---|---|---|
@I_vCost_Code_Number_1 | char | 7 | |||
@I_vCost_Code_Number_2 | char | 7 | |||
@I_vCost_Code_Number_3 | char | 7 | |||
@I_vCost_Code_Number_4 | char | 7 | |||
@I_vCost_Element | smallint |
| |||
@I_vCOSTTYPE | smallint |
| |||
@I_vEquipment_ID | char | 31 | |||
@I_vJOBNUMBR | char | 17 | |||
@I_vOnlyValidate | tinyint |
| |||
@I_vORD | int |
| |||
@I_vPONUMBER | char | 17 | |||
@I_vProduct_Indicator | smallint |
| |||
@I_vQTYRTRND | numeric | 19,5 | |||
@I_vRetention_Amount_TTD | numeric | 19,5 | |||
@I_vRetention_Pct | numeric | 19,5 | |||
@I_vRetTotalCost | numeric | 19,5 | |||
@I_vRetUnitCost | numeric | 19,5 | |||
@I_vReturnErrorText | tinyint |
| |||
@I_vTask_Code | char | 11 | |||
@I_vTXTFIELD | varchar | 8000 | |||
@I_vUpdateIfExists | tinyint |
| |||
@I_vUSRDEFND1 | char | 50 | |||
@I_vUSRDEFND2 | char | 50 | |||
@I_vUSRDEFND3 | char | 50 | |||
@I_vUSRDEFND4 | varchar | 8000 | |||
@I_vUSRDEFND5 | varchar | 8000 | |||
@I_vWennSoftTablesOnly | tinyint |
| |||
@I_vWSPOText | char | 15 | |||
@O_iErrorState | int |
| |||
@oErrString | varchar | 305 |
Error Codes
Error Code | Description |
---|---|
51013 |
|
51016 | Service Call does not exist |
51018 | Cost code does not exist for the job |
51052 | Unable to insert into Signature PO Integration table. |
51054 | Retention percent cannot be greater than 100%. |
51094 | Job is inactive. |
51095 | Not Unbilled, Service or Job Cost. |
51096 | Cost code type cannot be labor |
51097 | The Account for this Cost Code is Inactive and cannot be using on Purchasing Transactions. |
51098 | Purchase Order does not exist in MBS |
51099 | Purchase Order Line does not exist in MBS |
51104 | Service Call has been posted |
51430 | Error updating table: WS10101.*/ |
52015 | Option to update existing record is set to false. |
52017 | Job does not exist. |
591 | Line status is Closed, Canceled, or Received |
591 | PO Line Status must of type New, Released, Change Order or Cancelled |