SVC_Contract_Line_HIST (SVC30601)

azurecurveProductsFieldService (949)ProjectSVC_Contract_Line_HIST (SVC30601)

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

Product: FieldService (949)
Series:

Display Name: SVC_Contract_Line_HIST
Physical Name: SVC30601
Technical Name: SVC_Contract_Line_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
3LNSEQNBR SearchLine SEQ NumberCurrencySequence_Number19
4Contract_Transfer_Status SearchContract Transfer StatusIntegerDDL_Transfer_Status0
5Contract_Transfer_Date SearchContract Transfer DateDateDATE_L0
6CNTPRCOVR SearchContract Price OverriddenBooleanCB0
7NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SVC_Contract_Line_HIST'].NOTEINDX AS 'SVC_Contract_Line_HIST-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SVC_Contract_Line_HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX
8ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
9QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
10ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SVC_Contract_Line_HIST'].ITEMNMBR AS 'SVC_Contract_Line_HIST-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SVC_Contract_Line_HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR
11CONFGREF SearchConfig ReferenceStringSTR20_LBAU20
12EQUIPID SearchEquipment IDLong IntegerLong Int8
13SERLNMBR SearchSerial NumberStringSTR20_LBAU20
14FRZEND SearchFrozen EndDateDATE6
15FRXSTRT SearchFrozen StartDateDATE6
16BLKTIM SearchBlocked TimeCurrencyCURR_TIME10
17VALTIM SearchValue of TimeCurrencyCURR_TIME10
18DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
19COMDLRAM SearchCommission Dollar AmountCurrencyDLR17_RBSO_STR$17
20COUNTRY SearchCountryStringSTR6060
21PRCSTAT SearchStatus of PriceStringSTR11
22PORDNMBR SearchPurchase Order NumberStringPurchase Order Number20
23DSCRIPTN SearchDescriptionStringSTR3030
24PARTPCT SearchPart PctCurrencyDLR5_%28
25LABPCT SearchLabor PctCurrencyDLR5_%28
26MISCPCT SearchMisc PctCurrencyDLR5_%28
27PMMSCPCT SearchPM Misc PctCurrencyDLR5_%28
28PMPRTPCT SearchPM Part PctCurrencyDLR5_%28
29PMLABPCT SearchPM Labor PctCurrencyDLR5_%28
30VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['SVC_Contract_Line_HIST'].CUSTNMBR AS 'SVC_Contract_Line_HIST-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SVC_Contract_Line_HIST'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
53ENTDTE SearchEntry DateDateDT_Date6
54MINBIL SearchMin Billable CallCurrencyDLR19_RBS0_UTR$19
55MAXBIL SearchMax Billable CallCurrencyDLR19_RBS0_UTR$19
56MAXBILL SearchMax BillableCurrencyDLR19_RBS0_UTR$19
57AUTOREN SearchAuto RenewingBooleanCB0
58priorityLevel SearchpriorityLevelIntegerINT44
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 SearchContract Coverage Periods StartTM6Time6
72CNTCOVPD_1 SearchContract Coverage Periods Start[1]TimeTM66
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_3 SearchUse Coverage Period[3]BooleanCB_Day0
90USECVPD SearchUse Coverage PeriodCB_DayBoolean0
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
95TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SVC_Contract_Line_HIST'].TAXSCHID AS 'SVC_Contract_Line_HIST-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SVC_Contract_Line_HIST'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
96CNFGLVL SearchConfig LevelIntegerINT44
97CNFGSEQ SearchConfig SequenceIntegerINT44
98Contract_Length SearchContract LengthIntegerINT33
99Contract_Period SearchContract PeriodIntegerDDL_Bill_Period0
100Invoiced_Amount SearchInvoiced AmountCurrencyDLR19_$U219
101Amount_To_Invoice SearchAmount To InvoiceCurrencySVCDLR19_$U219
102Liabiltiy_Reduction SearchLiability ReductionBooleanCB0
103Liability_Amount SearchLiability AmountCurrencyDLR17_$U217
104Total_Liability_Amount SearchTotal Liability AmountCurrencyDLR19_$U219
105NUMOFINV SearchNumber of InvoicesLong IntegerLI6_U06
106New_Invoice_Amount SearchNew Invoice AmountCurrencyDLR19_$U219
107Contract_Line_Status SearchContract Line StatusStringSTR11
108Contract_Renewal_Contact SearchContract Renewal ContactStringSTR3030
109Contract_Response_Time SearchContract Response TimeStringSTR_Bill_Time6
110Liability_Months SearchLiability MonthsIntegerINT33
111Next_Liability_Date SearchNext Liability DateDateDATE6
112Last_Liability_Date SearchLast Liability DateDateDATE6
113Total_Liability_Billed SearchTotal Liability BilledCurrencyDLR19_$U219
114TAXEXMT1 SearchTax Exempt 1StringSTR2525
115TAXEXMT2 SearchTax Exempt 2StringSTR2525
116Total_Unit SearchTotal UnitCurrencyDollar1919
117UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
118Unit_Cost_Total SearchUnit Cost TotalCurrencyDLR19_$U219
119SVC_Liability_Type SearchSVC_Liability_TypeIntegerDDL_Liability_Type0
120SVC_Contract_Signed SearchSVC_Contract_SignedDateDATE_L0
121RETTYPE SearchSVC Return TypeStringSTR10_LBAU10
122SVC_Monthly_Price SearchSVC Monthly_PriceCurrencyDLR17_RBS0_UTR$17
123Location_Segment SearchLocation SegmentStringSTR66_Site_SEG66
124Bill_To_Customer SearchBill To CustomerStringSTR15_RM_Customer_Number15
125SVC_Bill_To_Address_Code SearchSVC Bill To Address CodeStringSTR15_Address_Code15
126DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
127SVC_Invoiced_Discount SearchSVC Invoiced DiscountCurrencyDLR19_$U219
128SVC_Discount_Recognized SearchSVC Discount RecognizedCurrencyDLR19_$U219
129SVC_Discount_Remaining SearchSVC Discount RemainingCurrencyDLR19_$U219
130SVC_Discount_Next SearchSVC Discount NextCurrencyDLR19_$U219
131SVC_PM_Date SearchSVC PM MonthIntegerSVC_DDL_Month0
132SVC_PM_Day SearchSVC PM DayIntegerSVC_PM_Day2
133CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['SVC_Contract_Line_HIST'].EXGTBLID AS 'SVC_Contract_Line_HIST-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       SVC30601 AS ['SVC_Contract_Line_HIST']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['SVC_Contract_Line_HIST'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
136XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
137EXCHDATE SearchExchange DateDateDT_Date6
138DECPLACS SearchDecimal PlacesIntegerDDL_Decimal_Places0
139TIME1 SearchTimeTimeTM66
140RATECALC SearchRate Calc MethodIntegerINT0
141VIEWMODE SearchView ModeIntegerINT0
142ISMCTRX SearchIS MC TrxIntegerINT0
143EXPNDATE SearchExpiration DateDateDT_Date6
144DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
145MCTRXSTT SearchMC Transaction StateIntegerINT11
146ORIGVALTIM SearchOriginating Value of TimeCurrencyCURR_TIME10
147ORCOMAMT SearchOriginating Commission Dollar AmountCurrencyDLR17_RBSO_STR$17
148ORIGRETNAGAM SearchOriginating Retainage AmountCurrencyDLR17_RBS0_UTR$17
149ORIGRTNBILLD SearchOriginating Retainage BilledCurrencyDLR17_RBS0_UTR$17
150ORIGLASTAmountBilled SearchOriginating Last Amount BilledCurrencyDLR11_RBS0_UTR$11
151ORIGTOTAL SearchOriginating Service TotalCurrencyDollar1919
152ORIGTOTVALCAL SearchOriginating Total Value of CallsCurrencyDLR19_RBSO_UTR$19
153ORIGMINBIL SearchOriginating Min Billable CallCurrencyDLR19_RBSO_UTR$19
154ORIGMAXBIL SearchOriginating Max Billable CallCurrencyDLR19_RBSO_UTR$19
155Originating_Max_Billable SearchOriginating Max BillableCurrencyDLR19_RBSO_STR$19
156ORIGTOTBIL SearchOriginating Total BilledCurrencyDLR19_RBSO_UTR$19
157Orig_Invoiced_Amount SearchOriginating Invoiced AmountCurrencyDLR19_$U219
158Orig_Amount_To_Invoice SearchOriginating Amount To InvoiceCurrencySVCDLR19_$U219
159Orig_Liability_Amount SearchOriginating Liability AmountCurrencyDLR19_$U219
160OrigTotLiabilityAmount SearchOriginating Total Liability AmountCurrencyDLR19_$U219
161OrigTotLiabBilled SearchOriginating Total Liability BilledCurrencyDLR19_$U219
162Originating_Total_Unit SearchOriginating Total UnitCurrencyDollar1919
163ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
164ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
165OrigDiscountReceived SearchOriginating Discount RecognizedCurrencyDLR19_$U219
166OrigDiscountRemaining SearchOriginating Discount RemainingCurrencyDLR19_$U219
167OrigDiscountNext SearchOriginating Discount NextCurrencyDLR19_$U219
168ORIGUNITCOSTTOTAL SearchOriginating Unit Cost TotalCurrencyDLR19_$U219
169ORIGMONTHPRICE SearchOriginating Monthly PriceCurrencyDLR17_RBS0_UTR$17
170ORIGINVOICEDDISC SearchOriginating Invoiced DiscountCurrencyDLR19_$U219
171OrigNewInvoiceAmount SearchOriginating New Invoice AmountCurrencyDLR19_$U219
172TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
173ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
174SVC_FO_ID SearchSVC FO IDStringSTR5050
175SVC_Contract_Version SearchSVC_Contract_VersionIntegerINT33
176MovedRevenue SearchMoved RevenueCurrencyDLR17_$U217
177OriginalTotal SearchOriginal TotalCurrencyDollar1919
178OrigMovedRevenue SearchOriginating Moved RevenueCurrencyDLR17_$U217
179OrigOriginalTotal SearchOriginating Original TotalCurrencyDollar1919
180Credit_Hold SearchCredit HoldBooleanCB0
181ITEMDESC SearchItem DescriptionStringSTR100100
azurecurveProductsFieldService (949)ProjectSVC_Contract_Line_HIST (SVC30601)

Leave a Reply

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