SV_Master_Contract_MSTR (SV00650)

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

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

Display Name: SV_Master_Contract_MSTR
Physical Name: SV00650
Technical Name: SV_Master_Contract_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

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_Master_Contract_MSTR'].CUSTNMBR AS 'SV_Master_Contract_MSTR-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SV00650 AS ['SV_Master_Contract_MSTR']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Master_Contract_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2Corporate_Contract_Nbr SearchCorporate Contract NumberSTR20_LBAUString2220
3WSMSTRCONTSQ SearchWS Master Contract Seq NumberLI_Sequence_NumberLong Integer410
4Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
5Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
6Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
7USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Master_Contract_MSTR'].USERID AS 'SV_Master_Contract_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00650 AS ['SV_Master_Contract_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Master_Contract_MSTR'].USERID = ['Users Master'].USERID
8Technician_ID SearchTechnician IDSTR15_Employee_IDString1615
9Technician_Team SearchTechnician TeamSTR15_LBAUString1615
10Customer_Contract_Type SearchCustomer Contract TypeSTR15String1615
11Customer_Contract_Desc SearchCustomer Contract DescriptionSTR30String3230
12Customer_Contract_Amount SearchCustomer Contract AmountDLR14_RBS0_STR$Currency1014
13Cust_Contract_Start_Date SearchCustomer Contract Start DateDTDate48
14Customer_Contract_End_Dt SearchCustomer Contract End DateDTDate48
15Contract_Service_Date SearchContract Service DateINT2_U0Integer22
16SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SV_Master_Contract_MSTR'].SLPRSNID AS 'SV_Master_Contract_MSTR-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SV00650 AS ['SV_Master_Contract_MSTR']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SV_Master_Contract_MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
17COMAPPTO SearchCommission Applied ToGBInteger20
18PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString1615
19Bill_Freq SearchBill FreqDDL_Bill_FreqInteger20
20Wennsoft_Close_Date SearchWennsoft Close DateDTDate48
21Annual_Contract_Value SearchAnnual Contract ValueDLR14_RBS0_STR$Currency1014
22Revenue_Rec_Method_ID SearchRevenue Recognition Method IDINT2Integer22
23Invoice_Style SearchInvoice StyleINT2Integer22
24Multiyear_Contract_Flag SearchMultiyear Contract FlagBooleanBoolean20
25PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
26Current_Billing_Amount SearchCurrent Billing AmountDLR14_RBS0_STR$Currency1014
27Billing_Control SearchBilling ControlCB_Billing_ControlBoolean20
28Billing_Equipment SearchBilling EquipmentDLR14_RBS0_STR$Currency1014
29Billing_Material SearchBilling MaterialDLR14_RBS0_STR$Currency1014
30Billing_Labor SearchBilling LaborDLR14_RBS0_STR$Currency1014
31Billing_Subs SearchBilling SubsDLR14_RBS0_STR$Currency1014
32Billing_Other SearchBilling OtherDLR14_RBS0_STR$Currency1014
33Billing_Percentage_Equip SearchBilling Percentage EquipDLR5_%2Currency108
34Billing_Pct_Material SearchBilling Percentage MaterialDLR5_%2Currency108
35Billing_Percentage_Labor SearchBilling Percentage LaborDLR5_%2Currency108
36Billing_Percentage_Subs SearchBilling Percentage SubsDLR5_%2Currency108
37Billing_Percentage_Other SearchBilling Percentage OtherDLR5_%2Currency108
38WSUserDefined1ID SearchWSUserDefined1IDSTR15_LBAUString1615
39WSUserDefined2ID SearchWSUserDefined2IDSTR15_LBAUString1615
40Customer_User_Define1a SearchCustomer User Define1aSTR15String1615
41Customer_User_Define2a SearchCustomer User Define2aSTR15String1615
42Customer_User_Define3a SearchCustomer User Define3aSTR15String1615
43Customer_User_Define4a SearchCustomer User Define4aSTR15String1615
44Customer_User_Define5a SearchCustomer User Define5aSTR15String1615
45Customer_User_Define6a SearchCustomer User Define6aSTR15String1615
46Customer_User_Define7a SearchCustomer User Define7aSTR15String1615
47Customer_User_Define8a SearchCustomer User Define8aSTR15String1615
48Customer_User_Define9a SearchCustomer User Define9aSTR15String1615
49Customer_User_Define10a SearchCustomer User Define10aSTR15String1615
50Service_User_Define_3 SearchService User Define 3STR30String3230
51Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer46
52Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer46
53Service_User_Define_9 SearchService User Define 9DTDate48
54Service_User_Define_10 SearchService User Define 10DTDate48
55Service_User_Define_18 SearchService User Define 18CBBoolean20
56Service_User_Define_19 SearchService User Define 19CBBoolean20
57Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency1014
58Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency1014
59Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency1014
60Contract_Billing_Date SearchContract Billing DateINT2_U0Integer22
61WS_Closed SearchWS ClosedTrue/FalseBoolean20
62Auto_Bill SearchAuto BillCB_Auto_BillBoolean20
63LSTFSCDY SearchLast Fiscal DayDT_DateDate46
64Auto_Date SearchAuto DateDATEDate46
65Cancel_Box SearchCancel BoxCB_CancelBoolean20
66HOLD SearchHoldCB_HoldBoolean20
67Hold_Reason_ID SearchHold Reason IDINT5Integer24
68MODIFDT SearchModified DateDTDate48
69Modified_Time SearchModified TimeTM6Time46
70MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Master_Contract_MSTR'].MDFUSRID AS 'SV_Master_Contract_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00650 AS ['SV_Master_Contract_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Master_Contract_MSTR'].MDFUSRID = ['Users Master'].USERID
71Time_Zone SearchTime ZoneSTR3String43
72SV_Language_ID SearchSV Language IDINT2Integer22
73Escalation_Frequency SearchEscalation FrequencySTR15_LBAUString1615
74Escalation_Date SearchEscalation DateDATEDate46
75Escal_Notify_Days SearchEscalation Notification DaysINT3_U0Integer23
76Next_Escalation_Date SearchNext Escalation DateDATEDate46
77Begin_Date_CY SearchBegin Date CYDATEDate46
78Anniversary_Date SearchAnniversary DateDTDate48
79Evergreen_Contract_Flag SearchEvergreen Contract FlagBooleanBoolean20
80Contract_Units_Measure SearchContract Units MeasureSTR15_LBAUString1615
81Last_Review_Date SearchLast Review DateDATEDate46
82Last_Review_User_ID SearchLast Review User IDSTR15_User_IDString1615
83Contract_Internal_Name SearchContract Internal NameSTR15_LBAUString1615
84Auto_Escalation_Flag SearchAutomatic Escalation FlagCBBoolean20
85Leave_Open_Flag SearchLeave Open FlagCB_Leave_OpenBoolean20
86Bill_Customer_Number SearchBill Customer NumberSTR15_RM_Customer_NumberString1615
87Bill_Address_Code SearchBill Address CodeSTR15_Address_CodeString1615
88WSReserved_CB1 SearchWSReserved CB1CBBoolean20
89WSReserved_CB2 SearchWSReserved CB2CBBoolean20
90WSReserved_CB3 SearchWSReserved CB3CBBoolean20
91WSReserved_CB4 SearchWSReserved CB4CBBoolean20
92WSReserved_CB5 SearchWSReserved CB5CBBoolean20
93WSReserved_CB6 SearchWSReserved CB6CBBoolean20
94WSReserved_CB7 SearchWSReserved CB7CBBoolean20
95WSReserved_CB8 SearchWSReserved CB8CBBoolean20
96WSReserved_CB9 SearchWSReserved CB9CBBoolean20
97WSReserved_CB10 SearchWSReserved CB10CBBoolean20
98WSReserved_STR1 SearchWSReserved STR1STR10String1210
99WSReserved_STR2 SearchWSReserved STR2STR10String1210

Leave a Reply

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