wsiSMSContractQuote | WennSoft Documentation

/*<![CDATA[*/ div.rbtoc1765575922320 {padding: 0px;} div.rbtoc1765575922320 ul {list-style: disc;margin-left: 0px;} div.rbtoc1765575922320 li {margin-left: 0px;padding-left: 0px;} /*]]>*/ Table: SV00502 Error Codes

Table: SV00502

Element Name	Data Type	Length
@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.