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 |
|
|