SVC_Contract_HDR_HIST (SVC30600)

azurecurveProductsFieldService (949)ProjectSVC_Contract_HDR_HIST (SVC30600)

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

Product: FieldService (949)
Series:

Display Name: SVC_Contract_HDR_HIST
Physical Name: SVC30600
Technical Name: SVC_Contract_HDR_HIST

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CONSTS SearchContract Record TypeIntegerDDL_Contract_Status0
2CONTNBR SearchContract NumberStringSTR1111
3Contract_Transfer_Status SearchContract Transfer StatusIntegerDDL_Transfer_Status0
4Contract_Transfer_Date SearchContract Transfer DateDateDATE_L0
5TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SVC_Contract_HDR_HIST'].TAXSCHID AS 'SVC_Contract_HDR_HIST-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SVC30600 AS ['SVC_Contract_HDR_HIST']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SVC_Contract_HDR_HIST'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
6priorityLevel SearchpriorityLevelIntegerINT44
7ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
8NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SVC_Contract_HDR_HIST'].NOTEINDX AS 'SVC_Contract_HDR_HIST-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC30600 AS ['SVC_Contract_HDR_HIST']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SVC_Contract_HDR_HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX
9TIMEZONE SearchTimeZoneStringSTR3_LBU3
10CONTPRC SearchContract PriceCurrencyDLR19_RBSO_UTR$19
11RENCNTTYP SearchRenewing Contract TypeIntegerDDL_Contract_Status0
12RENPRCSCHD SearchRenewing Price ScheduleStringSTR10_Schedule10
13PCTCRYFWD SearchPercentage Carried ForwardCurrencyDLR5_%28
14FRZEND SearchFrozen EndDateDATE6
15FRXSTRT SearchFrozen StartDateDATE6
16MXINCPCT SearchMax Increase PercentatgeCurrencyDLR5_%28
17BLKTIM SearchBlocked TimeCurrencyCURR_TIME10
18VALTIM SearchValue of TimeCurrencyCURR_TIME10
19DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
20COMDLRAM SearchCommission Dollar AmountCurrencyDLR17_RBSO_STR$17
21COUNTRY SearchCountryStringSTR6060
22PRCSTAT SearchStatus of PriceStringSTR11
23PORDNMBR SearchPurchase Order NumberStringPurchase Order Number20
24DSCRIPTN SearchDescriptionStringSTR3030
25PARTPCT SearchPart PctCurrencyDLR5_%28
26LABPCT SearchLabor PctCurrencyDLR5_%28
27MISCPCT SearchMisc PctCurrencyDLR5_%28
28PMMSCPCT SearchPM Misc PctCurrencyDLR5_%28
29PMPRTPCT SearchPM Part PctCurrencyDLR5_%28
30PMLABPCT SearchPM Labor PctCurrencyDLR5_%28
31VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SVC_Contract_HDR_HIST'].VENDORID AS 'SVC_Contract_HDR_HIST-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       SVC30600 AS ['SVC_Contract_HDR_HIST']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SVC_Contract_HDR_HIST'].VENDORID = ['PM Vendor Master File'].VENDORID
32RETNAGAM SearchRetainage AmountCurrencyDLR17_RBS0_UTR$17
33RTNBILLD SearchRetainage BilledCurrencyDLR11_RBS0_UTR$11
34SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SVC_Contract_HDR_HIST'].SLPRSNID AS 'SVC_Contract_HDR_HIST-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SVC30600 AS ['SVC_Contract_HDR_HIST']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SVC_Contract_HDR_HIST'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
35COMMCODE SearchCommission CodeStringSTR15_LBAU15
36COMPRCNT SearchCommission PercentIntegerINT5_%25
37BILSTRT SearchBill StartDateDATE6
38BILEND SearchBill EndDateDATE6
39BILLNGTH SearchBill LengthIntegerINT33
40BILPRD SearchBill PeriodIntegerDDL_Bill_Period0
41TOTAL SearchTotalCurrencyDollar1919
42FRSTBLDTE SearchFirst Bill DateDateDATE6
43Last_Amount_Billed SearchLast Amount BilledCurrencyDLR11_RBS0_UTR$11
44LSTBLDTE SearchLast Bill DateDateDATE6
45NBRCAL SearchMax Number of CallsIntegerINT54
46ACTCAL SearchActual Number of CallsIntegerINT54
47TOTVALCAL SearchTotal Value of CallsCurrencyDLR19_RBSO_UTR$19
48CONTACT SearchContactStringSTR6060
49CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SVC_Contract_HDR_HIST'].CURNCYID AS 'SVC_Contract_HDR_HIST-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       SVC30600 AS ['SVC_Contract_HDR_HIST']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SVC_Contract_HDR_HIST'].CURNCYID = ['Currency Setup'].CURNCYID
50NXTBLDTE SearchNext Bill DateDateDATE6
51CNTTYPE SearchContract TypeStringSTR10_LBAU10
52PRICSHED SearchPrice ScheduleStringSTR10_Schedule10
53CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SVC_Contract_HDR_HIST'].CUSTNMBR AS 'SVC_Contract_HDR_HIST-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVC30600 AS ['SVC_Contract_HDR_HIST']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SVC_Contract_HDR_HIST'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
54ENTDTE SearchEntry DateDateDT_Date6
55MINBIL SearchMin Billable CallCurrencyDLR19_RBS0_UTR$19
56MAXBIL SearchMax Billable CallCurrencyDLR19_RBS0_UTR$19
57MAXBILL SearchMax BillableCurrencyDLR19_RBS0_UTR$19
58AUTOREN SearchAuto RenewingBooleanCB0
59MSTCNTRCT SearchMaster Contract NumberStringSTR1010
60SRVTYPE SearchService TypeStringSTR10_LBAU10
61BILFRRET SearchBill For RetainerBooleanCB0
62TOTBIL SearchTotal BilledCurrencyDLR19_RBSO_UTR$19
63PREPAID SearchPre PaidBooleanCB0
64BILONDY SearchBill On DayIntegerINT2_U02
65BILCYC SearchBilling CycleIntegerSVC_DDL_Billing_Cycle0
66UOFM SearchU Of MStringU_Of_M8
67BILSTAT SearchBilling StatusIntegerDDL_Bill_Status_SVC0
68ENTTME SearchEntry TimeTimeTM66
69STRTDATE SearchStart DateDateDT8
70ENDDATE SearchEnd DateDateDT8
71CNTCOVPD_1 SearchContract Coverage Periods Start[1]TimeTM66
72CNTCOVPD SearchContract Coverage Periods StartTM6Time6
73CNTCOVPD_2 SearchContract Coverage Periods Start[2]TimeTM66
74CNTCOVPD_3 SearchContract Coverage Periods Start[3]TimeTM66
75CNTCOVPD_4 SearchContract Coverage Periods Start[4]TimeTM66
76CNTCOVPD_5 SearchContract Coverage Periods Start[5]TimeTM66
77CNTCOVPD_6 SearchContract Coverage Periods Start[6]TimeTM66
78CNTCOVPD_7 SearchContract Coverage Periods Start[7]TimeTM66
79Contract_Coverage_Period_1 SearchContract Coverage Periods End[1]TimeTM66
80Contract_Coverage_Period_2 SearchContract Coverage Periods End[2]TimeTM66
81Contract_Coverage_Period SearchContract Coverage Periods EndTM6Time6
82Contract_Coverage_Period_3 SearchContract Coverage Periods End[3]TimeTM66
83Contract_Coverage_Period_4 SearchContract Coverage Periods End[4]TimeTM66
84Contract_Coverage_Period_5 SearchContract Coverage Periods End[5]TimeTM66
85Contract_Coverage_Period_6 SearchContract Coverage Periods End[6]TimeTM66
86Contract_Coverage_Period_7 SearchContract Coverage Periods End[7]TimeTM66
87USECVPD_1 SearchUse Coverage Period[1]BooleanCB_Day0
88USECVPD_2 SearchUse Coverage Period[2]BooleanCB_Day0
89USECVPD SearchUse Coverage PeriodCB_DayBoolean0
90USECVPD_3 SearchUse Coverage Period[3]BooleanCB_Day0
91USECVPD_4 SearchUse Coverage Period[4]BooleanCB_Day0
92USECVPD_5 SearchUse Coverage Period[5]BooleanCB_Day0
93USECVPD_6 SearchUse Coverage Period[6]BooleanCB_Day0
94USECVPD_7 SearchUse Coverage Period[7]BooleanCB_Day0
95Contract_Length SearchContract LengthIntegerINT33
96Contract_Period SearchContract PeriodIntegerDDL_Bill_Period0
97Invoiced_Amount SearchInvoiced AmountCurrencyDLR19_$U219
98Liabiltiy_Reduction SearchLiability ReductionBooleanCB0
99Amount_To_Invoice SearchAmount To InvoiceCurrencySVCDLR19_$U219
100Liability_Amount SearchLiability AmountCurrencyDLR17_$U217
101Total_Liability_Amount SearchTotal Liability AmountCurrencyDLR19_$U219
102NUMOFINV SearchNumber of InvoicesLong IntegerLI6_U06
103Quote_Status SearchQuote StatusIntegerDDL0
104QUOEXPDA SearchQuote Expiration DateDateDT8
105Credit_Hold SearchCredit HoldBooleanCB0
106TAXEXMT1 SearchTax Exempt 1StringSTR2525
107TAXEXMT2 SearchTax Exempt 2StringSTR2525
108New_PO_Required SearchNew PO RequiredBooleanCB0
109Contract_Renewal_Contact SearchContract Renewal ContactStringSTR3030
110Source_Contract_Number SearchSource Contract NumberStringSTR20_LBAU20
111Source_Contract_Type SearchSource Contract TypeIntegerDDL_Contract_Status0
112Contract_Response_Time SearchContract Response TimeStringSTR_Bill_Time6
113Liability_Months SearchLiability MonthsIntegerINT33
114Next_Liability_Date SearchNext Liability DateDateDATE6
115Last_Liability_Date SearchLast Liability DateDateDATE6
116Total_Liability_Billed SearchTotal Liability BilledCurrencyDLR19_$U219
117Total_Unit SearchTotal UnitCurrencyDollar1919
118Created_User_ID SearchSVC_Created User IDStringSTR15_User_ID15
119Source_User_ID SearchSource User IDStringSTR15_User_ID15
120SVC_Contract_Signed SearchSVC_Contract_SignedDateDATE_L0
121SVC_Liability_Type SearchSVC_Liability_TypeIntegerDDL_Liability_Type0
122RETTYPE SearchSVC Return TypeStringSTR10_LBAU10
123Location_Segment SearchLocation SegmentStringSTR66_Site_SEG66
124Bill_To_Customer SearchBill To CustomerStringSTR15_RM_Customer_Number15
125SVC_Invoice_Detail SearchSVC Invoice DetailBooleanCB_Invoice_Detail0
126USERDEF1 SearchUser Defined 1StringSTR2020
127USERDEF2 SearchUser Defined 2StringSTR2020
128USRDEF03 SearchUser Defined 3StringSTR2020
129USRDEF04 SearchUser Defined 4StringSTR2020
130USRDEF05 SearchUser Defined 5StringSTR2020
131SVC_Bill_To_Address_Code SearchSVC Bill To Address CodeStringSTR15_Address_Code15
132DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
133SVC_Paid_Contract SearchSVC Paid ContractBooleanCB0
134SVC_Discount_Recognized SearchSVC Discount RecognizedCurrencyDLR19_$U219
135SVC_Discount_Remaining SearchSVC Discount RemainingCurrencyDLR19_$U219
136SVC_Discount_Next SearchSVC Discount NextCurrencyDLR19_$U219
137CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SVC_Contract_HDR_HIST'].CURRNIDX AS 'SVC_Contract_HDR_HIST-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SVC30600 AS ['SVC_Contract_HDR_HIST']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SVC_Contract_HDR_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX
138RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['SVC_Contract_HDR_HIST'].RATETPID AS 'SVC_Contract_HDR_HIST-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       SVC30600 AS ['SVC_Contract_HDR_HIST']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['SVC_Contract_HDR_HIST'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
139EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['SVC_Contract_HDR_HIST'].EXGTBLID AS 'SVC_Contract_HDR_HIST-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       SVC30600 AS ['SVC_Contract_HDR_HIST']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['SVC_Contract_HDR_HIST'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
140XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
141EXCHDATE SearchExchange DateDateDT_Date6
142DECPLACS SearchDecimal PlacesIntegerDDL_Decimal_Places0
143TIME1 SearchTimeTimeTM66
144RATECALC SearchRate Calc MethodIntegerINT0
145VIEWMODE SearchView ModeIntegerINT0
146ISMCTRX SearchIS MC TrxIntegerINT0
147EXPNDATE SearchExpiration DateDateDT_Date6
148DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
149MCTRXSTT SearchMC Transaction StateIntegerINT11
150ORIGVALTIM SearchOriginating Value of TimeCurrencyCURR_TIME10
151ORCOMAMT SearchOriginating Commission Dollar AmountCurrencyDLR17_RBSO_STR$17
152ORIGRETNAGAM SearchOriginating Retainage AmountCurrencyDLR17_RBS0_UTR$17
153ORIGRTNBILLD SearchOriginating Retainage BilledCurrencyDLR17_RBS0_UTR$17
154ORIGTOTAL SearchOriginating Service TotalCurrencyDollar1919
155ORIGLASTAmountBilled SearchOriginating Last Amount BilledCurrencyDLR11_RBS0_UTR$11
156ORIGTOTVALCAL SearchOriginating Total Value of CallsCurrencyDLR19_RBSO_UTR$19
157ORIGMINBIL SearchOriginating Min Billable CallCurrencyDLR19_RBSO_UTR$19
158ORIGMAXBIL SearchOriginating Max Billable CallCurrencyDLR19_RBSO_UTR$19
159Originating_Max_Billable SearchOriginating Max BillableCurrencyDLR19_RBSO_STR$19
160ORIGTOTBIL SearchOriginating Total BilledCurrencyDLR19_RBSO_UTR$19
161Orig_Invoiced_Amount SearchOriginating Invoiced AmountCurrencyDLR19_$U219
162Orig_Amount_To_Invoice SearchOriginating Amount To InvoiceCurrencySVCDLR19_$U219
163Orig_Liability_Amount SearchOriginating Liability AmountCurrencyDLR19_$U219
164OrigTotLiabilityAmount SearchOriginating Total Liability AmountCurrencyDLR19_$U219
165OrigTotLiabBilled SearchOriginating Total Liability BilledCurrencyDLR19_$U219
166Originating_Total_Unit SearchOriginating Total UnitCurrencyDollar1919
167ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
168OrigDiscountReceived SearchOriginating Discount RecognizedCurrencyDLR19_$U219
169OrigDiscountRemaining SearchOriginating Discount RemainingCurrencyDLR19_$U219
170OrigDiscountNext SearchOriginating Discount NextCurrencyDLR19_$U219
171SmoothInvoiceCalc SearchSmooth Invoice CalculationBooleanCB_Smooth_Billing0
172SmoothRevenueCalc SearchSmooth Revenue CalculationBooleanCB_Smooth_Revenue0
173SVC_Use_Same_Number SearchSVC Use Same NumberBooleanCB0
174SVC_FO_ID SearchSVC FO IDStringSTR5050
175SVC_Invoiced_Cost SearchSVC Invoiced CostCurrencyDLR19_RBS0_UTR$19
176Orig_SVC_Invoiced_Cost SearchOriginating SVC Invoiced CostCurrencyDLR19_RBS0_UTR$19
177SVC_Contract_Version SearchSVC_Contract_VersionIntegerINT33
178SVC_Evergreen_Contract SearchSVC Evergreen ContractBooleanCB0
179SVC_Evergreen_RenewLimit SearchSVC Evergreen RenewLimitIntegerINT44
180SVC_Evergreen_Renewals SearchSVC Evergreen RenewalsIntegerINT44
181SVC_New_Contract_Number SearchSVC New Contract NumberStringSTR1111
182SVC_New_PO_Number SearchSVC New PO NumberStringSTR2020
183Workflow_Approval_Status SearchWorkflow Approval StatusIntegerDDL_WorkflowApprovalStatus0
184Workflow_Priority SearchWorkflow PriorityIntegerDDL_WorkflowPriority0
185svcBillingFrequency SearchsvcBillingFrequencyIntegersvcAtEvery0
186svcFrequencyQty SearchsvcFrequencyQtyIntegerINT33
azurecurveProductsFieldService (949)ProjectSVC_Contract_HDR_HIST (SVC30600)

Leave a Reply

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