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 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
       ['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_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
       ['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_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
       ['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 CallSTR1String1
33Status_of_Call SearchStatus of CallSTR10_LBAUString10
34Call_Invoice_Number SearchCall Invoice NumberSTR17_LBAUString17
35Invoice_Style SearchInvoice StyleINT2Integer2
36Completion_Date SearchSV Completion DateDTDate8
37Time_1 SearchTime 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_Tag SearchTime Zone TagSTR4String4
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
67Billing_Amount_Fixed SearchBilling Amount FixedDLR11_$S2Currency14
68Billing_Amount_NTE SearchBilling Amount NTEDLR14_RBS0_STR$Currency14
69Billable_All SearchBillable AllDLR14_RBS0_STR$Currency14
70Cost_All SearchCost AllDLR14_RBS0_STR$Currency14
71Tax_Amount1 SearchTax Amount1DLR14_RBS0_STR$Currency14
72Tax_Amount2 SearchTax Amount2DLR14_RBS0_STR$Currency14
73Tax_Amount3 SearchTax Amount3DLR14_RBS0_STR$Currency14
74Labor_Billing_Catagory_1 SearchLabor Billing Catagory 1DLR14_RBS0_STR$Currency14
75Labor_Billing_Catagory_2 SearchLabor Billing Catagory 2DLR14_RBS0_STR$Currency14
76Labor_Billing_Catagory_3 SearchLabor Billing Catagory 3DLR14_RBS0_STR$Currency14
77Labor_Billing_Catagory_4 SearchLabor Billing Catagory 4DLR14_RBS0_STR$Currency14
78Labor_Billing_Catagory_5 SearchLabor Billing Catagory 5DLR14_RBS0_STR$Currency14
79Billable_Equipment SearchBillable EquipmentDLR14_RBS0_STR$Currency14
80Billable_Labor SearchBillable LaborDLR14_RBS0_STR$Currency14
81Billable_Material SearchBillable MaterialDLR14_RBS0_STR$Currency14
82Billable_Other SearchBillable OtherDLR14_RBS0_STR$Currency14
83Billable_Subs SearchBillable SubsDLR14_RBS0_STR$Currency14
84Billable_Tax SearchBillable TaxDLR14_RBS0_STR$Currency14
85Labor_Cost_Catagory_1 SearchLabor Cost Catagory 1DLR14_RBS0_STR$Currency14
86Labor_Cost_Catagory_2 SearchLabor Cost Catagory 2DLR14_RBS0_STR$Currency14
87Labor_Cost_Catagory_3 SearchLabor Cost Catagory 3DLR14_RBS0_STR$Currency14
88Labor_Cost_Catagory_4 SearchLabor Cost Catagory 4DLR14_RBS0_STR$Currency14
89Labor_Cost_Catagory_5 SearchLabor Cost Catagory 5DLR14_RBS0_STR$Currency14
90Cost_Equipment SearchCost EquipmentDLR14_RBS0_STR$Currency14
91Cost_Labor SearchCost LaborDLR14_RBS0_STR$Currency14
92Cost_Material SearchCost MaterialDLR14_RBS0_STR$Currency14
93Cost_Other SearchCost OtherDLR14_RBS0_STR$Currency14
94Cost_Subs SearchCost SubsDLR14_RBS0_STR$Currency14
95Cost_Tax SearchCost TaxDLR14_RBS0_STR$Currency14
96Service_User_Define_1 SearchService User Define 1STR20String20
97Service_User_Define_2 SearchService User Define 2STR20String20
98Service_User_Define_3 SearchService User Define 3STR30String30
99Service_User_Define_4 SearchService User Define 4STR30String30
100Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer6
101Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer6
102Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer6
103Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer6
104Service_User_Define_9 SearchService User Define 9DTDate8
105Service_User_Define_10 SearchService User Define 10DTDate8
106Service_User_Define_11 SearchService User Define 11DTDate8
107Service_User_Define_12 SearchService User Define 12DTDate8
108Service_User_Define_18 SearchService User Define 18CBBoolean0
109Service_User_Define_19 SearchService User Define 19CBBoolean0
110Service_User_Define_20 SearchService User Define 20CBBoolean0
111Service_User_Define_21 SearchService User Define 21CBBoolean0
112Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency14
113Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency14
114Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency14
115Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency14
116MODIFDT SearchModified DateDTDate8
117Modified_Time SearchModified TimeTM6Time6
118MDFUSRID SearchModified User IDSTR15String15
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 IDINT2Integer2
120Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString15
121Base_Curr_Conv_Factor SearchBase Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)14
122Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString15
123Billing_Curr_Conv_Factor SearchBilling Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)14
124Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString15
125Track_In_Job_Cost SearchTrack In Job CostBooleanBoolean0
126WSReserved_CB1 SearchWSReserved CB1CBBoolean0
127WSReserved_CB2 SearchWSReserved CB2CBBoolean0
128WSReserved_CB3 SearchWSReserved CB3CBBoolean0
129WSReserved_CB4 SearchWSReserved CB4CBBoolean0
130WSReserved_CB5 SearchWSReserved CB5CBBoolean0
131WSReserved_STR1 SearchWSReserved STR1STR10String10
132WSReserved_STR2 SearchWSReserved STR2STR10String10

Leave a Reply

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