SV_Service_MSTR_Archive (SVA0300)

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

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

Display Name: SV_Service_MSTR_Archive
Physical Name: SVA0300
Technical Name: SV_Service_MSTR_Archive

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Service_Call_ID SearchService Call IDSTR17_LBAUString17
2Service_Description SearchService DescriptionSTR30_LBAUString30
3ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
4CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_Service_MSTR_Archive'].CUSTNMBR AS 'SV_Service_MSTR_Archive-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVA0300 AS ['SV_Service_MSTR_Archive']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Service_MSTR_Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
5CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
6Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
7Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
8Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
9USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Service_MSTR_Archive'].USERID AS 'SV_Service_MSTR_Archive-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVA0300 AS ['SV_Service_MSTR_Archive']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Service_MSTR_Archive'].USERID = ['Users Master'].USERID
10Technician_ID SearchTechnician IDSTR15_Employee_IDString15
11Technician_Team SearchTechnician TeamSTR15_LBAUString15
12Service_Area SearchService AreaSTR15_LBAUString15
13Route SearchRouteSTR15_LBAUString15
14CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
15LOCATNNM SearchLocation NameSTR30String30
16Technician SearchTechnicianSTR10_LBAUString10
17Technician_ID2 SearchTechnician ID2STR15_Employee_IDString15
18Type_of_Problem_ID SearchType of Problem IDSTR3_LBAUString3
19Type_of_Problem SearchType of ProblemSTR30String30
20Resolution_ID SearchResolution IDSTR3_LBAUString3
21Resolution_Description SearchResolution DescriptionSTR30String30
22Equipment_Type SearchEquipment TypeSTR30String30
23Type_Call_Short SearchType Call ShortSTR3_LBAUString3
24Type_of_Call SearchType of CallSTR15String15
25User_Define_1a SearchUser Define 1aSTR30String30
26User_Define_2a SearchUser Define 2aSTR30String30
27User_Define_3a SearchUser Define 3aSTR30String30
28User_Define_4a SearchUser Define 4aSTR30String30
29Purchase_Order SearchPurchase OrderSTR15String15
30Date_of_Service_Call SearchDate of Service CallDTDate8
31SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SV_Service_MSTR_Archive'].SLPRSNID AS 'SV_Service_MSTR_Archive-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SVA0300 AS ['SV_Service_MSTR_Archive']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SV_Service_MSTR_Archive'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
32Priority_of_Call SearchPriority of CallSTR1String1
33Status_of_Call SearchStatus of CallSTR10_LBAUString10
34Call_Invoice_Number SearchCall Invoice NumberSTR17_LBAUString17
35Invoice_Style SearchInvoice StyleINT2Integer2
36Completion_Date SearchSV Completion DateDTDate8
37WS_Time_1 SearchWS Time 1TM6Time6
38Time_String_1_1 SearchTime String 1[1]STR10String10
39Time_String_1_2 SearchTime String 1[2]STR10String10
40Time_String_1_3 SearchTime String 1[3]STR10String10
41Time_String_1_4 SearchTime String 1[4]STR10String10
42Time_String_1_5 SearchTime String 1[5]STR10String10
43Time_String_1_6 SearchTime String 1[6]STR10String10
44Service_Date_1 SearchService Date 1DATEDate6
45Service_Date_2 SearchService Date 2DATEDate6
46Service_Date_3 SearchService Date 3DATEDate6
47Service_Date_4 SearchService Date 4DATEDate6
48Service_Date_5 SearchService Date 5DATEDate6
49Service_Date_6 SearchService Date 6DATEDate6
50Service_Time_1 SearchService Time 1TM6Time6
51Service_Time_2 SearchService Time 2TM6Time6
52Service_Time_3 SearchService Time 3TM6Time6
53Service_Time_4 SearchService Time 4TM6Time6
54Service_Time_5 SearchService Time 5TM6Time6
55Service_Time_6 SearchService Time 6TM6Time6
56Time_Zone SearchTime ZoneSTR3String3
57DATE1 SearchDateDT6Date6
58Division SearchDivisionDDL_DivisionInteger0
59Divisions SearchDivisionsSTR15_LBAUString15
60Call_Time SearchCall TimeLI6_S2Long Integer6
61Corporate_Contract_Nbr SearchCorporate Contract NumberSTR20_LBAUString20
62WSMSTRCONTSQ SearchWS Master Contract Seq NumberLI_Sequence_NumberLong Integer10
63Contract_Number SearchWS Contract NumberSTR10String10
64WSCONTSQ SearchWS Contract Number SequenceLI_Sequence_NumberLong Integer10
65Invoice_Type SearchInvoice TypeDDL_Invoice_TypeInteger0
66POSTED SearchPostedTrue/FalseBoolean0
67Added_Rate SearchAdded RateYNBoolean0
68Billing_Amount_Fixed SearchBilling Amount FixedDLR11_$S2Currency14
69Billing_Amount_NTE SearchBilling Amount NTEDLR14_RBS0_STR$Currency14
70Billable_All SearchBillable AllDLR14_RBS0_STR$Currency14
71Cost_All SearchCost AllDLR14_RBS0_STR$Currency14
72Tax_Amount1 SearchTax Amount1DLR14_RBS0_STR$Currency14
73Tax_Amount2 SearchTax Amount2DLR14_RBS0_STR$Currency14
74Tax_Amount3 SearchTax Amount3DLR14_RBS0_STR$Currency14
75Labor_Billing_Catagory_1 SearchLabor Billing Catagory 1DLR14_RBS0_STR$Currency14
76Labor_Billing_Catagory_2 SearchLabor Billing Catagory 2DLR14_RBS0_STR$Currency14
77Labor_Billing_Catagory_3 SearchLabor Billing Catagory 3DLR14_RBS0_STR$Currency14
78Labor_Billing_Catagory_4 SearchLabor Billing Catagory 4DLR14_RBS0_STR$Currency14
79Labor_Billing_Catagory_5 SearchLabor Billing Catagory 5DLR14_RBS0_STR$Currency14
80Billable_Equipment SearchBillable EquipmentDLR14_RBS0_STR$Currency14
81Billable_Labor SearchBillable LaborDLR14_RBS0_STR$Currency14
82Billable_Material SearchBillable MaterialDLR14_RBS0_STR$Currency14
83Billable_Other SearchBillable OtherDLR14_RBS0_STR$Currency14
84Billable_Subs SearchBillable SubsDLR14_RBS0_STR$Currency14
85Billable_Tax SearchBillable TaxDLR14_RBS0_STR$Currency14
86Labor_Cost_Catagory_1 SearchLabor Cost Catagory 1DLR14_RBS0_STR$Currency14
87Labor_Cost_Catagory_2 SearchLabor Cost Catagory 2DLR14_RBS0_STR$Currency14
88Labor_Cost_Catagory_3 SearchLabor Cost Catagory 3DLR14_RBS0_STR$Currency14
89Labor_Cost_Catagory_4 SearchLabor Cost Catagory 4DLR14_RBS0_STR$Currency14
90Labor_Cost_Catagory_5 SearchLabor Cost Catagory 5DLR14_RBS0_STR$Currency14
91Cost_Equipment SearchCost EquipmentDLR14_RBS0_STR$Currency14
92Cost_Labor SearchCost LaborDLR14_RBS0_STR$Currency14
93Cost_Material SearchCost MaterialDLR14_RBS0_STR$Currency14
94Cost_Other SearchCost OtherDLR14_RBS0_STR$Currency14
95Cost_Subs SearchCost SubsDLR14_RBS0_STR$Currency14
96Cost_Tax SearchCost TaxDLR14_RBS0_STR$Currency14
97Caller_Email_Address SearchCaller Email AddressSTR40_LBUString40
98Caller_Name SearchCaller NameSTR30String30
99Caller_Phone SearchCaller PhoneSTR14_PhoneString14
100Callback SearchCallbackCBBoolean0
101WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
102SVSLARES SearchSV Service Level IDSTR10_LBAUString10
103PO_Outstanding_Status SearchPO Outstanding StatusSTR15_RM_Customer_NumberString15
104WCA_Originating_Call SearchWCA Originating CallSTR17_LBAUString17
105WCA_Technician SearchWCA TechnicianSTR15_Employee_IDString15
106Service_User_Define_1 SearchService User Define 1STR20String20
107Service_User_Define_2 SearchService User Define 2STR20String20
108Service_User_Define_3 SearchService User Define 3STR30String30
109Service_User_Define_4 SearchService User Define 4STR30String30
110Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer6
111Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer6
112Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer6
113Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer6
114Service_User_Define_9 SearchService User Define 9DTDate8
115Service_User_Define_10 SearchService User Define 10DTDate8
116Service_User_Define_11 SearchService User Define 11DTDate8
117Service_User_Define_12 SearchService User Define 12DTDate8
118Service_User_Define_18 SearchService User Define 18CBBoolean0
119Service_User_Define_19 SearchService User Define 19CBBoolean0
120Service_User_Define_20 SearchService User Define 20CBBoolean0
121Service_User_Define_21 SearchService User Define 21CBBoolean0
122Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency14
123Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency14
124Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency14
125Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency14
126MODIFDT SearchModified DateDTDate8
127Modified_Time SearchModified TimeTM6Time6
128MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Service_MSTR_Archive'].MDFUSRID AS 'SV_Service_MSTR_Archive-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVA0300 AS ['SV_Service_MSTR_Archive']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Service_MSTR_Archive'].MDFUSRID = ['Users Master'].USERID
129SV_Language_ID SearchSV Language IDINT2Integer2
130Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString15
131Base_Curr_Conv_Factor SearchBase Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)14
132Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString15
133Billing_Curr_Conv_Factor SearchBilling Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)14
134Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString15
135Track_In_Job_Cost SearchTrack In Job CostBooleanBoolean0
136TransferToWSJob SearchTransferToWSJobSTR17_LBAUString17
137BilledToJobEquipment SearchBilledToJobEquipmentDLR14_RBS0_STR$Currency14
138BilledToJobMaterial SearchBilledToJobMaterialDLR14_RBS0_STR$Currency14
139BilledToJobLabor SearchBilledToJobLaborDLR14_RBS0_STR$Currency14
140BilledToJobSubcontractor SearchBilledToJobSubcontractorDLR14_RBS0_STR$Currency14
141BilledToJobOther SearchBilledToJobOtherDLR14_RBS0_STR$Currency14
142Bill_Customer_Number SearchBill Customer NumberSTR15_RM_Customer_NumberString15
143Bill_Address_Code SearchBill Address CodeSTR15_Address_CodeString15
144WSReserved_CB1 SearchWSReserved CB1CBBoolean0
145WSReserved_CB2 SearchWSReserved CB2CBBoolean0
146WSReserved_CB3 SearchWSReserved CB3CBBoolean0
147WSReserved_CB4 SearchWSReserved CB4CBBoolean0
148WSReserved_CB5 SearchWSReserved CB5CBBoolean0
149WSReserved_STR1 SearchWSReserved STR1STR10String10
150WSReserved_STR2 SearchWSReserved STR2STR10String10

Leave a Reply

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