Service Call Master History (SVC30200)

azurecurveProductsFieldService (949)ProjectService Call Master History (SVC30200)

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

Product: FieldService (949)
Series:

Display Name: Service Call Master History
Physical Name: SVC30200
Technical Name: SVC_Service_MSTR_HIST

Group Display Name: Service History Table Group
Group Technical Name: Service History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CALLNBR SearchService Call NumberStringSTR10_LBAU10
2SRVRECTYPE SearchService Record TypeIntegerDDL_Service_Record_Type0
3SRVSTAT SearchService Call StatusStringSTR3_LBU3
4SRVTYPE SearchService TypeStringSTR10_LBAU10
5SVCDESCR SearchService DescriptionStringSTR6060
6priorityLevel SearchpriorityLevelIntegerINT44
7CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Service Call Master History'].CUSTNMBR AS 'Service Call Master History-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVC30200 AS ['Service Call Master History']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Service Call Master History'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
8Customer_Reference SearchCustomer ReferenceStringSTR2020
9ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
10CUSTNAME SearchCustomer NameStringSTR64_Customer_Name64
11ADDRESS1 SearchAddress 1StringSTR6060
12ADDRESS2 SearchAddress 2StringSTR6060
13CITY SearchCityStringSTR3535
14STATE SearchStateStringSTR30_State29
15ZIP SearchZipStringSTR1010
16CNTCPRSN SearchContact PersonStringSTR6060
17PHONE1 SearchPhone 1StringPhone_Number14
18OFFID SearchOffice IDStringSTR10_LBAU10
19SVCAREA SearchService AreaStringSTR10_LBAU10
20TECHID SearchTech IDStringSTR10_LBAU10
21TIMEZONE SearchTimeZoneStringSTR3_LBU3
22ENTDTE SearchEntry DateDateDT_Date6
23ENTTME SearchEntry TimeTimeTM66
24Notify_Date SearchNotify DateDateDATE_L0
25Notify_Time SearchNotify TimeTimeTM66
26ETADTE SearchETA DateDateDT_Date6
27ETATME SearchETA TimeTimeTM66
28DISPDTE SearchDispatch DateDateDT_Date6
29DISPTME SearchDispatch TimeTimeTM66
30ARRIVDTE SearchArrival DateDateDT_Date6
31ARRIVTME SearchArrival TimeTimeTM66
32COMPDTE SearchComplete DateDateDT_Date6
33COMPTME SearchComplete TimeTimeTM66
34Response_Date SearchResponse DateDateDT_Date6
35Response_Time SearchResponse TimeTimeTM66
36PRICELVL SearchPrice LevelStringSTR15_LBAU15
37PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['Service Call Master History'].PYMTRMID AS 'Service Call Master History-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       SVC30200 AS ['Service Call Master History']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['Service Call Master History'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
38SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['Service Call Master History'].SLPRSNID AS 'Service Call Master History-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SVC30200 AS ['Service Call Master History']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Service Call Master History'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
39LABSTOTPRC SearchLabor Sub Total PriceCurrencyDLR17_RBS0_STR$17
40LABPCT SearchLabor PctCurrencyDLR5_%28
41LABSTOTCST SearchLabor Sub Total CostCurrencyDLR17_RBS0_STR$17
42PARSTOTPRC SearchPart Sub Total PriceCurrencyDLR17_RBS0_STR$17
43PARTPCT SearchPart PctCurrencyDLR5_%28
44PARSTOTCST SearchPart Sub Total CostCurrencyDLR17_RBS0_STR$17
45MSCSTOTPRC SearchMisc Sub Total PriceCurrencyDLR17_RBS0_STR$17
46MISCPCT SearchMisc PctCurrencyDLR5_%28
47MISSTOTCST SearchMisc Sub Total CostCurrencyDLR17_RBS0_STR$17
48TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Service Call Master History'].TAXSCHID AS 'Service Call Master History-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SVC30200 AS ['Service Call Master History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Service Call Master History'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
49TAXEXMT1 SearchTax Exempt 1StringSTR2525
50TAXEXMT2 SearchTax Exempt 2StringSTR2525
51PRETAXTOT SearchPreTax TotalCurrencyDLR17_RBS0_STR$17
52TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
53TOTAL SearchTotalCurrencyDollar1919
54Invoiced_Amount SearchInvoiced AmountCurrencyDLR19_$U219
55METER1 SearchMeter 1Long IntegerLI_Meter_Reading8
56METER2 SearchMeter 2Long IntegerLI_Meter_Reading8
57METER3 SearchMeter 3Long IntegerLI_Meter_Reading8
58PORDNMBR SearchPurchase Order NumberStringPurchase Order Number20
59NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Service Call Master History'].NOTEINDX AS 'Service Call Master History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC30200 AS ['Service Call Master History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Service Call Master History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
60NOTFYFLAG SearchNotify FlagBooleanCB0
61USERDEF1 SearchUser Defined 1StringSTR2020
62USERDEF2 SearchUser Defined 2StringSTR2020
63USRDEF03 SearchUser Defined 3StringSTR2020
64USRDEF04 SearchUser Defined 4StringSTR2020
65USRDEF05 SearchUser Defined 5StringSTR2020
66MSTRRECTYPE SearchMaster Service Record TypeIntegerDDL_Service_Record_Type0
67MSTRCALLNBR SearchMaster Service Call NumberStringSTR1010
68ESCDATE SearchEscalation DateDateDT_Date6
69ESCTIME SearchEscalation TimeTimeTM66
70Escalation_Level SearchEscalation LevelLong IntegerLI_Sequence_Number10
71SPLTTERMS SearchSplit Terms CodeStringSTR10_LBAU10
72Callback SearchCallbackBooleanCB0
73PROJCTID SearchProject IDStringSTR1515
74ProjectRef1_1 SearchProjectRef1[1]StringSTR1515
75ProjectRef1 SearchProjectRef1STR15String15
76ProjectRef1_2 SearchProjectRef1[2]StringSTR1515
77ProjectRef1_3 SearchProjectRef1[3]StringSTR1515
78ProjectRef1_4 SearchProjectRef1[4]StringSTR1515
79CONSTS SearchContract Record TypeIntegerDDL_Contract_Status0
80CONTNBR SearchContract NumberStringSTR1111
81SVC_Contract_Line_SEQ SearchSVC_Contract_Line_SEQ_NumberCurrencySequence_Number19
82ETTR SearchETTRCurrencyCURR_MTTR10
83SVC_On_Hold SearchSVC On HoldBooleanSVC On Hold0
84Print_to_Web SearchPrint to WebBooleanCB0
85Meters_1 SearchMeters[1]Long IntegerLI_Meter_Reading8
86Meters_2 SearchMeters[2]Long IntegerLI_Meter_Reading8
87Meters SearchMetersLI_Meter_ReadingLong Integer8
88Meters_3 SearchMeters[3]Long IntegerLI_Meter_Reading8
89Meters_4 SearchMeters[4]Long IntegerLI_Meter_Reading8
90Meters_5 SearchMeters[5]Long IntegerLI_Meter_Reading8
91Meter_Internal_Uses_1 SearchMeter Internal Uses[1]Long IntegerLI_Meter_Reading8
92Meter_Internal_Uses_2 SearchMeter Internal Uses[2]Long IntegerLI_Meter_Reading8
93Meter_Internal_Uses SearchMeter Internal UsesLI_Meter_ReadingLong Integer8
94Meter_Internal_Uses_3 SearchMeter Internal Uses[3]Long IntegerLI_Meter_Reading8
95Meter_Internal_Uses_4 SearchMeter Internal Uses[4]Long IntegerLI_Meter_Reading8
96Meter_Internal_Uses_5 SearchMeter Internal Uses[5]Long IntegerLI_Meter_Reading8
97Bill_To_Customer SearchBill To CustomerStringSTR15_RM_Customer_Number15
98CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Service Call Master History'].CURNCYID AS 'Service Call Master History-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       SVC30200 AS ['Service Call Master History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Service Call Master History'].CURNCYID = ['Currency Setup'].CURNCYID
99SVC_Bill_To_Address_Code SearchSVC Bill To Address CodeStringSTR15_Address_Code15
100CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Service Call Master History'].CURRNIDX AS 'Service Call Master History-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SVC30200 AS ['Service Call Master History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Service Call Master History'].CURRNIDX = ['Currency Setup'].CURRNIDX
101RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Service Call Master History'].RATETPID AS 'Service Call Master History-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       SVC30200 AS ['Service Call Master History']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Service Call Master History'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
102EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Service Call Master History'].EXGTBLID AS 'Service Call Master History-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       SVC30200 AS ['Service Call Master History']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Service Call Master History'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
103XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
104EXCHDATE SearchExchange DateDateDT_Date6
105DECPLACS SearchDecimal PlacesIntegerDDL_Decimal_Places0
106TIME1 SearchTimeTimeTM66
107RATECALC SearchRate Calc MethodIntegerINT0
108VIEWMODE SearchView ModeIntegerINT0
109ISMCTRX SearchIS MC TrxIntegerINT0
110EXPNDATE SearchExpiration DateDateDT_Date6
111DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
112MCTRXSTT SearchMC Transaction StateIntegerINT11
113ORIGMISSTOTCST SearchOriginating Misc Sub Total CostCurrencyDLR17_RBS0_STR$17
114ORIGMSCSTOTPRC SearchOriginating Misc Sub Total PriceCurrencyDLR17_RBS0_STR$17
115ORIGLABSUBTOTCOST SearchOriginating Labor Sub Total CostCurrencyDLR17_RBS0_STR$17
116ORIGLABSTOTPRC SearchOriginating Labor Sub Total PriceCurrencyDLR17_RBS0_STR$17
117ORIGPARSTOTCST SearchOriginating Part Sub Total CostCurrencyDLR17_RBS0_STR$17
118ORIGPARSTOTPRC SearchOriginating Part Sub Total PriceCurrencyDLR17_RBS0_STR$17
119ORIGPRETAXTOT SearchOriginating PreTax TotalCurrencyDLR17_RBS0_STR$17
120ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
121ORIGTOTAL SearchOriginating Service TotalCurrencyDollar1919
122Orig_Invoiced_Amount SearchOriginating Invoiced AmountCurrencyDLR19_$U219
123ADDRESS3 SearchAddress 3StringSTR6060
124COUNTRY SearchCountryStringSTR6060
125SVC_Pre600 SearchSVC_Pre600BooleanCB0
126SVC_FO_ID SearchSVC FO IDStringSTR5050
127Replaces_1 SearchReplaces[1]BooleanCB0
128Replaces_2 SearchReplaces[2]BooleanCB0
129Replaces_3 SearchReplaces[3]BooleanCB0
130Replaces_4 SearchReplaces[4]BooleanCB0
131Replaces SearchReplacesCBBoolean0
132Replaces_5 SearchReplaces[5]BooleanCB0
133Workflow_Approval_Status SearchWorkflow Approval StatusIntegerDDL_WorkflowApprovalStatus0
134Workflow_Priority SearchWorkflow PriorityIntegerDDL_WorkflowPriority0
azurecurveProductsFieldService (949)ProjectService Call Master History (SVC30200)

Leave a Reply

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