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 TypeLength
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_LBAUString20
3WSMSTRCONTSQ SearchWS Master Contract Seq NumberLI_Sequence_NumberLong Integer10
4Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
5Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
6Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
7USERID SearchUser IDSTR15_User_IDString15
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_IDString15
9Technician_Team SearchTechnician TeamSTR15_LBAUString15
10Customer_Contract_Type SearchCustomer Contract TypeSTR15String15
11Customer_Contract_Desc SearchCustomer Contract DescriptionSTR30String30
12Customer_Contract_Amount SearchCustomer Contract AmountDLR14_RBS0_STR$Currency14
13Cust_Contract_Start_Date SearchCustomer Contract Start DateDTDate8
14Customer_Contract_End_Dt SearchCustomer Contract End DateDTDate8
15Contract_Service_Date SearchContract Service DateINT2_U0Integer2
16SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
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 ToGBInteger0
18PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString15
19Bill_Freq SearchBill FreqDDL_Bill_FreqInteger0
20Wennsoft_Close_Date SearchWennsoft Close DateDTDate8
21Annual_Contract_Value SearchAnnual Contract ValueDLR14_RBS0_STR$Currency14
22Revenue_Rec_Method_ID SearchRevenue Recognition Method IDINT2Integer2
23Invoice_Style SearchInvoice StyleINT2Integer2
24Multiyear_Contract_Flag SearchMultiyear Contract FlagBooleanBoolean0
25PORDNMBR SearchPurchase Order NumberPurchase Order NumberString20
26Current_Billing_Amount SearchCurrent Billing AmountDLR14_RBS0_STR$Currency14
27Billing_Control SearchBilling ControlCB_Billing_ControlBoolean0
28Billing_Equipment SearchBilling EquipmentDLR14_RBS0_STR$Currency14
29Billing_Material SearchBilling MaterialDLR14_RBS0_STR$Currency14
30Billing_Labor SearchBilling LaborDLR14_RBS0_STR$Currency14
31Billing_Subs SearchBilling SubsDLR14_RBS0_STR$Currency14
32Billing_Other SearchBilling OtherDLR14_RBS0_STR$Currency14
33Billing_Percentage_Equip SearchBilling Percentage EquipDLR5_%2Currency8
34Billing_Pct_Material SearchBilling Percentage MaterialDLR5_%2Currency8
35Billing_Percentage_Labor SearchBilling Percentage LaborDLR5_%2Currency8
36Billing_Percentage_Subs SearchBilling Percentage SubsDLR5_%2Currency8
37Billing_Percentage_Other SearchBilling Percentage OtherDLR5_%2Currency8
38WSUserDefined1ID SearchWSUserDefined1IDSTR15_LBAUString15
39WSUserDefined2ID SearchWSUserDefined2IDSTR15_LBAUString15
40Customer_User_Define1a SearchCustomer User Define1aSTR15String15
41Customer_User_Define2a SearchCustomer User Define2aSTR15String15
42Customer_User_Define3a SearchCustomer User Define3aSTR15String15
43Customer_User_Define4a SearchCustomer User Define4aSTR15String15
44Customer_User_Define5a SearchCustomer User Define5aSTR15String15
45Customer_User_Define6a SearchCustomer User Define6aSTR15String15
46Customer_User_Define7a SearchCustomer User Define7aSTR15String15
47Customer_User_Define8a SearchCustomer User Define8aSTR15String15
48Customer_User_Define9a SearchCustomer User Define9aSTR15String15
49Customer_User_Define10a SearchCustomer User Define10aSTR15String15
50Service_User_Define_3 SearchService User Define 3STR30String30
51Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer6
52Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer6
53Service_User_Define_9 SearchService User Define 9DTDate8
54Service_User_Define_10 SearchService User Define 10DTDate8
55Service_User_Define_18 SearchService User Define 18CBBoolean0
56Service_User_Define_19 SearchService User Define 19CBBoolean0
57Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency14
58Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency14
59Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency14
60Contract_Billing_Date SearchContract Billing DateINT2_U0Integer2
61WS_Closed SearchWS ClosedTrue/FalseBoolean0
62Auto_Bill SearchAuto BillCB_Auto_BillBoolean0
63LSTFSCDY SearchLast Fiscal DayDT_DateDate6
64Auto_Date SearchAuto DateDATEDate6
65Cancel_Box SearchCancel BoxCB_CancelBoolean0
66HOLD SearchHoldCB_HoldBoolean0
67Hold_Reason_ID SearchHold Reason IDINT5Integer4
68MODIFDT SearchModified DateDTDate8
69Modified_Time SearchModified TimeTM6Time6
70MDFUSRID SearchModified User IDSTR15String15
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 ZoneSTR3String3
72SV_Language_ID SearchSV Language IDINT2Integer2
73Escalation_Frequency SearchEscalation FrequencySTR15_LBAUString15
74Escalation_Date SearchEscalation DateDATEDate6
75Escal_Notify_Days SearchEscalation Notification DaysINT3_U0Integer3
76Next_Escalation_Date SearchNext Escalation DateDATEDate6
77Begin_Date_CY SearchBegin Date CYDATEDate6
78Anniversary_Date SearchAnniversary DateDTDate8
79Evergreen_Contract_Flag SearchEvergreen Contract FlagBooleanBoolean0
80Contract_Units_Measure SearchContract Units MeasureSTR15_LBAUString15
81Last_Review_Date SearchLast Review DateDATEDate6
82Last_Review_User_ID SearchLast Review User IDSTR15_User_IDString15
83Contract_Internal_Name SearchContract Internal NameSTR15_LBAUString15
84Auto_Escalation_Flag SearchAutomatic Escalation FlagCBBoolean0
85Leave_Open_Flag SearchLeave Open FlagCB_Leave_OpenBoolean0
86Bill_Customer_Number SearchBill Customer NumberSTR15_RM_Customer_NumberString15
87Bill_Address_Code SearchBill Address CodeSTR15_Address_CodeString15
88WSReserved_CB1 SearchWSReserved CB1CBBoolean0
89WSReserved_CB2 SearchWSReserved CB2CBBoolean0
90WSReserved_CB3 SearchWSReserved CB3CBBoolean0
91WSReserved_CB4 SearchWSReserved CB4CBBoolean0
92WSReserved_CB5 SearchWSReserved CB5CBBoolean0
93WSReserved_CB6 SearchWSReserved CB6CBBoolean0
94WSReserved_CB7 SearchWSReserved CB7CBBoolean0
95WSReserved_CB8 SearchWSReserved CB8CBBoolean0
96WSReserved_CB9 SearchWSReserved CB9CBBoolean0
97WSReserved_CB10 SearchWSReserved CB10CBBoolean0
98WSReserved_STR1 SearchWSReserved STR1STR10String10
99WSReserved_STR2 SearchWSReserved STR2STR10String10

Leave a Reply

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