wsiMobilePurchaseOrderWork
Table Name: WS20003
Description:
Describe what the WSI procedure does in regards to a business goal.
Element Name | Data Type | Length | Required | Default | Description |
---|---|---|---|---|---|
@I_vServiceCallID | char | 17 | Yes |
|
|
@I_vTechnician | char | 11 | Yes |
|
|
@I_vPONumber | char | 17 | Yes |
|
|
@I_vOrd | int | 10 | Yes |
|
|
@I_vWSTransactionDate | datetime |
| No |
|
|
@I_vVendorID | char | 15 | No |
|
|
@I_vVendorName | char | 65 | No |
|
|
@I_vItemNumber | char | 31 | No |
|
|
@I_vItemDescription | char | 101 | No |
|
|
@I_vUOfM | char | 9 | No |
|
|
@I_vQTYOrdered | numeric | 19,5 | No |
|
|
@I_vUnitCost | numeric | 19,5 | No |
|
|
@I_vBillableAmount | numeric | 19,5 | No |
|
|
@I_vInvoiced | tinyint | 3 | No |
|
|
@I_vLocationCode | char | 11 | No |
|
|
@I_vWSCostCode | int | 10 | No |
|
|
@I_vProductIndicator | smallint | 5 | No |
|
|
@I_veConnectErrorCode | int | 10 | No |
|
|
@I_vDEXROWID | int | 10 | No |
|
|
@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 |
|
|