wsiSMSEquipment

Table Name: SV00400

Other tables affected: SV00403, SV00055

Other stored procedures called: wsiSMSEquipmentPre, wsiSMSEquipmentPost, wsiSMSEquipmentContract
Description:
This procedure allows the insert/update of records into the equipment master table. The corresponding record in the equipment quick search table (SV00055) will also be created/updated. A contract number can be specified and the wsiSMSEquipmentContract procedure will be called to populate the equipment contract coverage table (SV00403) - if the equipment needs to be attached to multiple contracts then the wsiSMSEquipmentContract procedure can be called as a separate import.

Element Name	Data Type	Length	Default	Description
@I_vAddressCode	char	15		Validated - RM00102
@I_vCustomerNumber	char	15		Validated - RM00101
@I_vEquipmentID	char	31		Validated as not empty
@I_vUserID	char	15
@I_vWennsoftMasterEquipID	char	31
@I_vComponentFlag	tinyint	1
@I_vComponentQty	smallint	2
@I_vCorporateCustomerNumber	char	15
@I_vManufacturerID	char	15		Validated - SV00410
@I_vEquipmentType	char	31		Validated - SV00405
@I_vWennsoftModelNumber	char	21		Validated - SV00411
@I_vWennsoftSerialNumber	char	41
@I_vInstalledByLongDescription	char	41
@I_vExtendedWarrantyType	char	31
@I_vExtendedWarrantyExpiration	datetime	8
@I_vWarrantyExpiration	datetime	8
@I_vInstallDate	datetime	8
@I_vLocationEquipment	char	51
@I_vWSContractNumber	char	11		Validated - SV00500 When provided wsiSMSEquipmentContract procedure will be called
@I_vWSBarCodeID	char	51
@I_vUserDefine1a	char	31
@I_vUserDefine2a	char	31
@I_vUserDefine3a	char	31
@I_vUserDefine4a	char	31
@I_vUserDefine5a	char	31
@I_vUserDefine9a	datetime	8
@I_vStartUpDate	datetime	8
@I_vShutdownMonth	smallint	2
@I_vStartupMonth	smallint	2
@I_vOperatingHoursPerMonth	smallint	2
@I_vTotalControlsPerUnit	smallint	2
@I_vTotalControlsQty	smallint	2
@I_vShutdownJan	smallint	2
@I_vShutdownFeb	smallint	2
@I_vShutdownMar	smallint	2
@I_vShutdownApr	smallint	2
@I_vShutdownMay	smallint	2
@I_vShutdownJun	smallint	2
@I_vShutdownJul	smallint	2
@I_vShutdownAug	smallint	2
@I_vShutdownSep	smallint	2
@I_vShutdownOct	smallint	2
@I_vShutdownNov	smallint	2
@I_vShutdownDec	smallint	2
@I_vAutoDate	datetime	8
@I_vPMGroup	char	3
@I_vID1	char	11
@I_vID2	char	11
@I_vStartupBy	char	51
@I_vStartupJobNumber	char	17
@I_vShippedDate	datetime	8
@I_vVibrationDate	datetime	8
@I_vOverhaulDate	datetime	8
@I_vECTDate	datetime	8
@I_vConversionDate	datetime	8
@I_vBlanketPOCheckbox	tinyint	1
@I_vBlanketPONumber	char	17
@I_vOriginalBlanketPOAmount	numeric	9
@I_vBlanketPOAmountSpent	numeric	9
@I_vBlanketPOAmountRemainin	numeric	9
@I_vBlanketPOExpirationDate	datetime	8
@I_vServiceUserDefine1	char	21
@I_vServiceUserDefine2	char	21
@I_vServiceUserDefine3	char	31
@I_vServiceUserDefine4	char	31
@I_vServiceUserDefine5	int	4
@I_vServiceUserDefine6	int	4
@I_vServiceUserDefine7	int	4
@I_vServiceUserDefine8	int	4
@I_vServiceUserDefine9	datetime	8
@I_vServiceUserDefine10	datetime	8
@I_vServiceUserDefine11	datetime	8
@I_vServiceUserDefine12	datetime	8
@I_vServiceUserDefine18	tinyint	1
@I_vServiceUserDefine19	tinyint	1
@I_vServiceUserDefine20	tinyint	1
@I_vServiceUserDefine21	tinyint	1
@I_vServiceUserDefine22	numeric	9
@I_vServiceUserDefine23	numeric	9
@I_vServiceUserDefine24	numeric	9
@I_vServiceUserDefine25	numeric	9
@I_vTimeZone	char	3
@I_vWSReservedCB1	tinyint	1
@I_vWSReservedCB2	tinyint	1
@I_vWSReservedCB3	tinyint	1
@I_vWSReservedCB4	tinyint	1
@I_vWSReservedCB5	tinyint	1
@I_vWSReservedCB6	tinyint	1
@I_vWSReservedCB7	tinyint	1
@I_vWSReservedCB8	tinyint	1
@I_vWSReservedCB9	tinyint	1
@I_vWSReservedCB10	tinyint	1
@I_vWSReservedSTR1	char	11
@I_vWSReservedSTR2	char	11
@I_vOutofServiceFlag	tinyint	1
@I_vOutofServiceDate	datetime	8
@I_vOutofServiceTime	datetime	8
@I_vOutofServiceBy	char	15
@I_vOutofServiceReason	char	31
@I_vInactiveRetiredFlag	tinyint	1		Validated - Cannot be 1 when open contract is specified
@I_vEquipmentDescription2	char	51
@I_vItemNumber	char	31
@I_vSerialNumber	char	21
@I_vUpdateIfExists	tinyint	1
@I_vWennSoftTablesOnly	tinyint	1
@I_vOnlyValidate	tinyint	1
@I_vUSRDEFND1	char	50
@I_vUSRDEFND2	char	50
@I_vUSRDEFND3	char	50
@I_vUSRDEFND4	varchar	8000
@I_vUSRDEFND5	varchar	8000
@I_vReturnErrorText	tinyint	1
@O_iErrorState	int	4
@oErrString	varchar	255
@I_vEquip_Description_Long	char	255
@I_vOptimalCharge	numeric	9
@I_vRefrigerantTypeID	int	4
@I_vRefrigerantEquipmentType	smallint	2	0	Must match record in SV40181 table
@I_vLatitude	numeric	9
@I_vLongitude	numeric	9
@I_vBuildingID	char	30
@I_vBuildingRoom	char	30