wsiSMSEquipmentContract
Table Name: SV00403
Other stored procedures called: wsiSMSEquipmentContractPre, wsiSMSEquipmentContractPost
Description:
This procedure will allow you to insert/update records into the SV00403 equipment contract coverage table. This table establishes the relationship between contracts and the equipment that is assigned to them.
Element Name | Data Type | Length | Required | Default | Description |
|---|---|---|---|---|---|
@I_vCustomerNumber | char | 15 | Yes |
| Validated - RM00101 |
@I_vAddressCode | char | 15 | Yes |
| Validated - RM00102 |
@I_vWSContractNumber | char | 11 | Yes |
| Validated - SV00500 |
@I_vWSContractNumberSequence | int | 10 | Yes |
| Validated - SV00500 |
@I_vEquipmentID | char | 31 | Yes |
| Validated - SV00400 |
@I_vServiceUserDefine1 | char | 21 | No | ' |
|
@I_vServiceUserDefine2 | char | 21 | No | ' |
|
@I_vServiceUserDefine3 | char | 31 | No | ' |
|
@I_vServiceUserDefine4 | char | 31 | No | ' |
|
@I_vServiceUserDefine5 | int | 10 | No | 0 |
|
@I_vServiceUserDefine6 | int | 10 | No | 0 |
|
@I_vServiceUserDefine7 | int | 10 | No | 0 |
|
@I_vServiceUserDefine8 | int | 10 | No | 0 |
|
@I_vServiceUserDefine9 | datetime |
| No | 1/1/1900' |
|
@I_vServiceUserDefine10 | datetime |
| No | 1/1/1900' |
|
@I_vServiceUserDefine11 | datetime |
| No | 1/1/1900' |
|
@I_vServiceUserDefine12 | datetime |
| No | 1/1/1900' |
|
@I_vServiceUserDefine18 | tinyint | 3 | No | 0 |
|
@I_vServiceUserDefine19 | tinyint | 3 | No | 0 |
|
@I_vServiceUserDefine20 | tinyint | 3 | No | 0 |
|
@I_vServiceUserDefine21 | tinyint | 3 | No | 0 |
|
@I_vServiceUserDefine22 | numeric | 19,5 | No | 0 |
|
@I_vServiceUserDefine23 | numeric | 19,5 | No | 0 |
|
@I_vServiceUserDefine24 | numeric | 19,5 | No | 0 |
|
@I_vServiceUserDefine25 | numeric | 19,5 | No | 0 |
|
@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_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 |
|
|