ServiceCallWarehouse (SVINTER1)

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

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

Display Name: ServiceCallWarehouse
Physical Name: SVINTER1
Technical Name: ServiceCallWarehouse

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Service_Call_ID SearchService Call IDSTR17_LBAUString1817
2Service_Description SearchService DescriptionSTR30_LBAUString3230
3ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
4CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['ServiceCallWarehouse'].CUSTNMBR AS 'ServiceCallWarehouse-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVINTER1 AS ['ServiceCallWarehouse']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['ServiceCallWarehouse'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
5CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
6Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
7Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
8Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
9USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['ServiceCallWarehouse'].USERID AS 'ServiceCallWarehouse-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVINTER1 AS ['ServiceCallWarehouse']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['ServiceCallWarehouse'].USERID = ['Users Master'].USERID
10Technician_ID SearchTechnician IDSTR15_Employee_IDString1615
11Technician_Team SearchTechnician TeamSTR15_LBAUString1615
12Service_Area SearchService AreaSTR15_LBAUString1615
13Route SearchRouteSTR15_LBAUString1615
14CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
15LOCATNNM SearchLocation NameSTR30String3230
16Technician SearchTechnicianSTR10_LBAUString1210
17Technician_ID2 SearchTechnician ID2STR15_Employee_IDString1615
18Type_of_Problem_ID SearchType of Problem IDSTR3_LBAUString43
19Type_of_Problem SearchType of ProblemSTR30String3230
20Resolution_ID SearchResolution IDSTR3_LBAUString43
21Resolution_Description SearchResolution DescriptionSTR30String3230
22Equipment_Type SearchEquipment TypeSTR30String3230
23Type_Call_Short SearchType Call ShortSTR3_LBAUString43
24Type_of_Call SearchType of CallSTR15String1615
25User_Define_1a SearchUser Define 1aSTR30String3230
26User_Define_2a SearchUser Define 2aSTR30String3230
27User_Define_3a SearchUser Define 3aSTR30String3230
28User_Define_4a SearchUser Define 4aSTR30String3230
29Purchase_Order SearchPurchase OrderSTR15String1615
30Date_of_Service_Call SearchDate of Service CallDTDate48
31SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['ServiceCallWarehouse'].SLPRSNID AS 'ServiceCallWarehouse-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SVINTER1 AS ['ServiceCallWarehouse']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['ServiceCallWarehouse'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
32Priority_of_Call SearchPriority of CallSTR1String21
33Status_of_Call SearchStatus of CallSTR10_LBAUString1210
34Call_Invoice_Number SearchCall Invoice NumberSTR17_LBAUString1817
35Invoice_Style SearchInvoice StyleINT2Integer22
36Completion_Date SearchSV Completion DateDTDate48
37Time_1 SearchTime 1TM6Time46
38Time_String_1_1 SearchTime String 1[1]STR10String1210
39Time_String_1_2 SearchTime String 1[2]STR10String1210
40Time_String_1_3 SearchTime String 1[3]STR10String1210
41Time_String_1_4 SearchTime String 1[4]STR10String1210
42Time_String_1_5 SearchTime String 1[5]STR10String1210
43Time_String_1_6 SearchTime String 1[6]STR10String1210
44Service_Date_1 SearchService Date 1DATEDate46
45Service_Date_2 SearchService Date 2DATEDate46
46Service_Date_3 SearchService Date 3DATEDate46
47Service_Date_4 SearchService Date 4DATEDate46
48Service_Date_5 SearchService Date 5DATEDate46
49Service_Date_6 SearchService Date 6DATEDate46
50Service_Time_1 SearchService Time 1TM6Time46
51Service_Time_2 SearchService Time 2TM6Time46
52Service_Time_3 SearchService Time 3TM6Time46
53Service_Time_4 SearchService Time 4TM6Time46
54Service_Time_5 SearchService Time 5TM6Time46
55Service_Time_6 SearchService Time 6TM6Time46
56Time_Zone_Tag SearchTime Zone TagSTR4String64
57DATE1 SearchDateDT6Date46
58Division SearchDivisionDDL_DivisionInteger20
59Divisions SearchDivisionsSTR15_LBAUString1615
60Call_Time SearchCall TimeLI6_S2Long Integer46
61Corporate_Contract_Nbr SearchCorporate Contract NumberSTR20_LBAUString2220
62WSMSTRCONTSQ SearchWS Master Contract Seq NumberLI_Sequence_NumberLong Integer410
63Contract_Number SearchWS Contract NumberSTR10String1210
64WSCONTSQ SearchWS Contract Number SequenceLI_Sequence_NumberLong Integer410
65Invoice_Type SearchInvoice TypeDDL_Invoice_TypeInteger20
66POSTED SearchPostedTrue/FalseBoolean20
67Billing_Amount_Fixed SearchBilling Amount FixedDLR11_$S2Currency1014
68Billing_Amount_NTE SearchBilling Amount NTEDLR14_RBS0_STR$Currency1014
69Billable_All SearchBillable AllDLR14_RBS0_STR$Currency1014
70Cost_All SearchCost AllDLR14_RBS0_STR$Currency1014
71Tax_Amount1 SearchTax Amount1DLR14_RBS0_STR$Currency1014
72Tax_Amount2 SearchTax Amount2DLR14_RBS0_STR$Currency1014
73Tax_Amount3 SearchTax Amount3DLR14_RBS0_STR$Currency1014
74Labor_Billing_Catagory_1 SearchLabor Billing Catagory 1DLR14_RBS0_STR$Currency1014
75Labor_Billing_Catagory_2 SearchLabor Billing Catagory 2DLR14_RBS0_STR$Currency1014
76Labor_Billing_Catagory_3 SearchLabor Billing Catagory 3DLR14_RBS0_STR$Currency1014
77Labor_Billing_Catagory_4 SearchLabor Billing Catagory 4DLR14_RBS0_STR$Currency1014
78Labor_Billing_Catagory_5 SearchLabor Billing Catagory 5DLR14_RBS0_STR$Currency1014
79Billable_Equipment SearchBillable EquipmentDLR14_RBS0_STR$Currency1014
80Billable_Labor SearchBillable LaborDLR14_RBS0_STR$Currency1014
81Billable_Material SearchBillable MaterialDLR14_RBS0_STR$Currency1014
82Billable_Other SearchBillable OtherDLR14_RBS0_STR$Currency1014
83Billable_Subs SearchBillable SubsDLR14_RBS0_STR$Currency1014
84Billable_Tax SearchBillable TaxDLR14_RBS0_STR$Currency1014
85Labor_Cost_Catagory_1 SearchLabor Cost Catagory 1DLR14_RBS0_STR$Currency1014
86Labor_Cost_Catagory_2 SearchLabor Cost Catagory 2DLR14_RBS0_STR$Currency1014
87Labor_Cost_Catagory_3 SearchLabor Cost Catagory 3DLR14_RBS0_STR$Currency1014
88Labor_Cost_Catagory_4 SearchLabor Cost Catagory 4DLR14_RBS0_STR$Currency1014
89Labor_Cost_Catagory_5 SearchLabor Cost Catagory 5DLR14_RBS0_STR$Currency1014
90Cost_Equipment SearchCost EquipmentDLR14_RBS0_STR$Currency1014
91Cost_Labor SearchCost LaborDLR14_RBS0_STR$Currency1014
92Cost_Material SearchCost MaterialDLR14_RBS0_STR$Currency1014
93Cost_Other SearchCost OtherDLR14_RBS0_STR$Currency1014
94Cost_Subs SearchCost SubsDLR14_RBS0_STR$Currency1014
95Cost_Tax SearchCost TaxDLR14_RBS0_STR$Currency1014
96Service_User_Define_1 SearchService User Define 1STR20String2220
97Service_User_Define_2 SearchService User Define 2STR20String2220
98Service_User_Define_3 SearchService User Define 3STR30String3230
99Service_User_Define_4 SearchService User Define 4STR30String3230
100Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer46
101Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer46
102Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer46
103Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer46
104Service_User_Define_9 SearchService User Define 9DTDate48
105Service_User_Define_10 SearchService User Define 10DTDate48
106Service_User_Define_11 SearchService User Define 11DTDate48
107Service_User_Define_12 SearchService User Define 12DTDate48
108Service_User_Define_18 SearchService User Define 18CBBoolean20
109Service_User_Define_19 SearchService User Define 19CBBoolean20
110Service_User_Define_20 SearchService User Define 20CBBoolean20
111Service_User_Define_21 SearchService User Define 21CBBoolean20
112Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency1014
113Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency1014
114Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency1014
115Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency1014
116MODIFDT SearchModified DateDTDate48
117Modified_Time SearchModified TimeTM6Time46
118MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['ServiceCallWarehouse'].MDFUSRID AS 'ServiceCallWarehouse-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVINTER1 AS ['ServiceCallWarehouse']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['ServiceCallWarehouse'].MDFUSRID = ['Users Master'].USERID
119SV_Language_ID SearchSV Language IDINT2Integer22
120Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString1615
121Base_Curr_Conv_Factor SearchBase Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)1014
122Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString1615
123Billing_Curr_Conv_Factor SearchBilling Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)1014
124Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString1615
125Track_In_Job_Cost SearchTrack In Job CostBooleanBoolean20
126WSReserved_CB1 SearchWSReserved CB1CBBoolean20
127WSReserved_CB2 SearchWSReserved CB2CBBoolean20
128WSReserved_CB3 SearchWSReserved CB3CBBoolean20
129WSReserved_CB4 SearchWSReserved CB4CBBoolean20
130WSReserved_CB5 SearchWSReserved CB5CBBoolean20
131WSReserved_STR1 SearchWSReserved STR1STR10String1210
132WSReserved_STR2 SearchWSReserved STR2STR10String1210

Leave a Reply

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