wsiSMSContractQuote
Table: SV00502
Element Name | Data Type | Length | Required | Default | Description |
---|---|---|---|---|---|
@I_vAddressCode | char | 15 | |||
@I_vAnnualContractValue | numeric | 19,5 | |||
@I_vAutoBill | tinyint |
| |||
@I_vBaseCurrencyID | char | 15 | |||
@I_vBillFreq | smallint |
| |||
@I_vBillingCurrencyID | char | 15 | |||
@I_vBillingEquipment | numeric | 19,5 | |||
@I_vBillingLabor | numeric | 19,5 | |||
@I_vBillingLabor1 | numeric | 19,5 | |||
@I_vBillingLabor1Hours | int |
| |||
@I_vBillingLabor2 | numeric | 19,5 | |||
@I_vBillingLabor2Hours | int |
| |||
@I_vBillingLabor3 | numeric | 19,5 | |||
@I_vBillingLabor3Hours | int |
| |||
@I_vBillingLabor4 | numeric | 19,5 | |||
@I_vBillingLabor4Hours | int |
| |||
@I_vBillingLabor5 | numeric | 19,5 | |||
@I_vBillingLabor5Hours | int |
| |||
@I_vBillingLaborHours | int |
| |||
@I_vBillingMaterial | numeric | 19,5 | |||
@I_vBillingOther | numeric | 19,5 | |||
@I_vBillingPercentageEquip | numeric | 19,5 | |||
@I_vBillingPercentageLabor | numeric | 19,5 | |||
@I_vBillingPercentageMaterial | numeric | 19,5 | |||
@I_vBillingPercentageOther | numeric | 19,5 | |||
@I_vBillingPercentageSubs | numeric | 19,5 | |||
@I_vBillingPercentageTotal | numeric | 19,5 | |||
@I_vBillingSubs | numeric | 19,5 | |||
@I_vBillingTotal | numeric | 19,5 | |||
@I_vCancelBox | tinyint |
| |||
@I_vContractActualUnits | int |
| |||
@I_vContractAmount | numeric | 19,5 | |||
@I_vContractBillingDate | smallint |
| |||
@I_vContractExpirationDate | datetime |
| |||
@I_vContractInternalName | char | 15 | |||
@I_vContractNTEUnits | int |
| |||
@I_vContractUnitsMeasure | char | 15 | |||
@I_vCustomerNumber | char | 15 | |||
@I_vEstimateEquipment | numeric | 19,5 | |||
@I_vEstimateHours | int |
| |||
@I_vEstimateLabor | numeric | 19,5 | |||
@I_vEstimateLabor1 | numeric | 19,5 | |||
@I_vEstimateLabor1Hours | int |
| |||
@I_vEstimateLabor2 | numeric | 19,5 | |||
@I_vEstimateLabor2Hours | int |
| |||
@I_vEstimateLabor3 | numeric | 19,5 | |||
@I_vEstimateLabor3Hours | int |
| |||
@I_vEstimateLabor4 | numeric | 19,5 | |||
@I_vEstimateLabor4Hours | int |
| |||
@I_vEstimateLabor5 | numeric | 19,5 | |||
@I_vEstimateLabor5Hours | int |
| |||
@I_vEstimateMaterial | numeric | 19,5 | |||
@I_vEstimateOther | numeric | 19,5 | |||
@I_vEstimateSubs | numeric | 19,5 | |||
@I_vEstimateTotalCost | numeric | 19,5 | |||
@I_vEstimateTotalLabor | numeric | 19,5 | |||
@I_vEstimateTotalLaborHrs | int |
| |||
@I_vEvergreenContractFlag | tinyint |
| |||
@I_vExcessCost | numeric | 19,5 | |||
@I_vForecastEquipment | numeric | 19,5 | |||
@I_vForecastLabor | numeric | 19,5 | |||
@I_vForecastLabor1 | numeric | 19,5 | |||
@I_vForecastLabor1Hours | int |
| |||
@I_vForecastLabor2 | numeric | 19,5 | |||
@I_vForecastLabor2Hours | int |
| |||
@I_vForecastLabor3 | numeric | 19,5 | |||
@I_vForecastLabor3Hours | int |
| |||
@I_vForecastLabor4 | numeric | 19,5 | |||
@I_vForecastLabor4Hours | int |
| |||
@I_vForecastLabor5 | numeric | 19,5 | |||
@I_vForecastLabor5Hours | int |
| |||
@I_vForecastMaterial | numeric | 19,5 | |||
@I_vForecastOriginalEquipment | numeric | 19,5 | |||
@I_vForecastOriginalLabor | numeric | 19,5 | |||
@I_vForecastOriginalMaterial | numeric | 19,5 | |||
@I_vForecastOriginalOther | numeric | 19,5 | |||
@I_vForecastOriginalSubs | numeric | 19,5 | |||
@I_vForecastOrigLabor1 | numeric | 19,5 | |||
@I_vForecastOrigLabor1Hours | int |
| |||
@I_vForecastOrigLabor2 | numeric | 19,5 | |||
@I_vForecastOrigLabor2Hours | int |
| |||
@I_vForecastOrigLabor3 | numeric | 19,5 | |||
@I_vForecastOrigLabor3Hours | int |
| |||
@I_vForecastOrigLabor4 | numeric | 19,5 | |||
@I_vForecastOrigLabor4Hours | int |
| |||
@I_vForecastOrigLabor5 | numeric | 19,5 | |||
@I_vForecastOrigLabor5Hours | int |
| |||
@I_vForecastOrigTotalLabor | numeric | 19,5 | |||
@I_vForecastOrigTotalLaborHrs | int |
| |||
@I_vForecastOther | numeric | 19,5 | |||
@I_vForecastSubs | numeric | 19,5 | |||
@I_vForecastTotalCost | numeric | 19,5 | |||
@I_vForecastTotalLabor | numeric | 19,5 | |||
@I_vForecastTotalLaborHrs | int |
| |||
@I_vHold | tinyint |
| |||
@I_vHoldReasonID | smallint |
| |||
@I_vInvoiceStyle | smallint |
| |||
@I_vLastReviewDate | datetime |
| |||
@I_vLastReviewUserID | char | 15 | |||
@I_vLocalCurrencyID | char | 15 | |||
@I_vMultiyearContractFlag | tinyint |
| |||
@I_vOnlyValidate | tinyint |
| |||
@I_vPricingMatrixName | char | 15 | |||
@I_vQuoteDate | datetime |
| |||
@I_vQuoteExpirationDate | datetime |
| |||
@I_vQuoteNumber | char | 11 | |||
@I_vQuoteType | smallint |
| |||
@I_vReturnErrorText | tinyint |
| |||
@I_vRevenueRecognitionMethodID | smallint |
| |||
@I_vSalespersonID | char | 15 | |||
@I_vServiceDay | tinyint |
| |||
@I_vServiceUserDefine10 | datetime |
| |||
@I_vServiceUserDefine18 | tinyint |
| |||
@I_vServiceUserDefine19 | tinyint |
| |||
@I_vServiceUserDefine22 | numeric | 19,5 | |||
@I_vServiceUserDefine23 | numeric | 19,5 | |||
@I_vServiceUserDefine24 | numeric | 19,5 | |||
@I_vServiceUserDefine3 | char | 31 | |||
@I_vServiceUserDefine5 | int |
| |||
@I_vServiceUserDefine6 | int |
| |||
@I_vServiceUserDefine9 | datetime |
| |||
@I_vSVServiceLevelID | char | 11 | |||
@I_vTimeZone | char | 3 | |||
@I_vUpdateIfExists | tinyint |
| |||
@I_vUserDefine1a | char | 31 | |||
@I_vUserDefine2a | char | 31 | |||
@I_vUserDefine3a | char | 31 | |||
@I_vUserDefine4a | char | 31 | |||
@I_vUserID | char | 15 | |||
@I_vUSRDEFND1 | char | 50 | |||
@I_vUSRDEFND2 | char | 50 | |||
@I_vUSRDEFND3 | char | 50 | |||
@I_vUSRDEFND4 | varchar | 8000 | |||
@I_vUSRDEFND5 | varchar | 8000 | |||
@I_vWarrantyCheckbox | tinyint |
| |||
@I_vWennsoftAffiliate | char | 15 | |||
@I_vWennsoftBranch | char | 15 | |||
@I_vWennsoftRegion | char | 15 | |||
@I_vWennSoftTablesOnly | tinyint |
| |||
@I_vWSContractNumber | char | 11 | |||
@I_vWSContractStartDate | datetime |
| |||
@I_vWSReservedCB1 | tinyint |
| |||
@I_vWSReservedCB10 | tinyint |
| |||
@I_vWSReservedCB2 | tinyint |
| |||
@I_vWSReservedCB3 | tinyint |
| |||
@I_vWSReservedCB5 | tinyint |
| |||
@I_vWSReservedCB6 | tinyint |
| |||
@I_vWSReservedCB7 | tinyint |
| |||
@I_vWSReservedCB8 | tinyint |
| |||
@I_vWSReservedCB9 | tinyint |
| |||
@I_vWSReservedSTR1 | char | 11 | |||
@O_iErrorState | int |
| |||
@oErrString | varchar | 255 |
Error Codes
Error Code | Description |
---|---|
51112 | The Customer Number does not exist. |
52022 | The Salesperson ID is invalid. |
52027 | The Address Code does not exist. |
52144 | The Bill Frequency is invalid. |
52147 | The Expiration Date is before the Start Date. |
52148 | Fiscal periods for contract dates must be set up. |
52162 | The Contract Type does not exist. |
52310 | Error inserting/updating the quote master table (SV00502). |
52416 | The Billing Day cannot exceed 28. |
52417 | The Service Day cannot exceed 28. |