wsiMobileInventoryWork
Table Name: WS20002
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 | No |
| |
@I_vWSTransactionDate | datetime |
| No |
| |
@I_vEquipmentID | char | 31 | No |
| |
@I_vWSCostCode | int | 10 | No |
| |
@I_vWSOtherCostSubCode | int | 10 | No |
| |
@I_vItemNumber | char | 31 | No |
| |
@I_vItemDescription | char | 101 | No |
| |
@I_vTRXQTY | numeric | 19,5 | No |
| |
@I_vCostPerUnit | numeric | 19,5 | No |
| |
@I_vBillableAmount | numeric | 19,5 | No |
| |
@I_vInvoiced | tinyint | 3 | No |
| |
@I_vUOfM | char | 9 | No |
| |
@I_vLocationCode | char | 11 | No |
| |
@I_veConnectErrorCode | int | 10 | No |
| |
@I_vSerialNumber | char | 21 | No |
| |
@I_vDEXROWID | int | 10 | Yes |
| |
@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 |
|