Skip to main content
Skip table of contents

wsiSMSContractQuote

Table: SV00502

Element NameData TypeLengthRequiredDefaultDescription

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

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.