SV_Equipment_Contract_Coverage_VIEW (SV99403)

azurecurveProductsWennSoft Products (131)3rd PartySV_Equipment_Contract_Coverage_VIEW (SV99403)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV99403

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_Equipment_Contract_Coverage_VIEW
Physical Name: SV99403
Technical Name: SV_Equipment_Contract_Coverage_VIEW

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_Equipment_Contract_Coverage_VIEW'].CUSTNMBR AS 'SV_Equipment_Contract_Coverage_VIEW-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SV99403 AS ['SV_Equipment_Contract_Coverage_VIEW']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Equipment_Contract_Coverage_VIEW'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
3Contract_Number SearchWS Contract NumberSTR10String1210
4WSCONTSQ SearchWS Contract Number SequenceLI_Sequence_NumberLong Integer410
5Contract_Internal_Name SearchContract Internal NameSTR15_LBAUString1615
6Contract_Start_Date SearchWS Contract Start DateDTDate48
7Contract_Expiration_Date SearchContract Experation DateDTDate48
8Equipment_ID SearchEquipment IDSTR30String3230
9Wennsoft_Master_Equip_ID SearchWennsoft Master Equipment IDSTR30String3230
10Equipment_Type SearchEquipment TypeSTR30String3230
11Location_Equipment SearchLocation EquipmentSTR50_LBUString5250
12Wennsoft_Serial_Number SearchWennsoft Serial NumberSTR40String4240
13Manufacturer_ID SearchManufacturer IDSTR15_LBAUString1615
14Wennsoft_Model_Number SearchWennsoft Model NumberSTR20String2220
15Warranty_Expiration SearchWarranty ExperationDTDate48
16Extended_Warr_Expiration SearchExtended Warranty ExperationDTDate48
17User_Define_1a SearchUser Define 1aSTR30String3230
18User_Define_2a SearchUser Define 2aSTR30String3230
19User_Define_3a SearchUser Define 3aSTR30String3230
20User_Define_4a SearchUser Define 4aSTR30String3230
21User_Define_5a SearchUser Define 5aSTR30String3230
22Out_of_Service_Flag SearchOut of Service FlagCB_Out_Of_Service_FlagBoolean20
23Inactive_Retired_Flag SearchInactive/Retired FlagCB_Inactive/RetiredBoolean20
24CMPTFLAG SearchComponent FlagCB_Component_ItemBoolean20
25WSReserved_CB1 SearchWSReserved CB1CBBoolean20
26Component_Qty SearchComponent QtyINT5Integer24
azurecurveProductsWennSoft Products (131)3rd PartySV_Equipment_Contract_Coverage_VIEW (SV99403)

Leave a Reply

Your email address will not be published. Required fields are marked *