SVC_Contract_Line (SVC00601)

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

Product: FieldService (949)
Series: Project

Display Name: SVC_Contract_Line
Physical Name: SVC00601
Technical Name: SVC_Contract_Line

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CONSTS SearchContract Record TypeDDL_Contract_StatusInteger20
2CONTNBR SearchContract NumberSTR11String1211
3LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
4Contract_Transfer_Status SearchContract Transfer StatusDDL_Transfer_StatusInteger20
5Contract_Transfer_Date SearchContract Transfer DateDATE_LDate40
6CNTPRCOVR SearchContract Price OverriddenCBBoolean20
7NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SVC_Contract_Line'].NOTEINDX AS 'SVC_Contract_Line-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC00601 AS ['SVC_Contract_Line']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SVC_Contract_Line'].NOTEINDX = ['Record Notes Master'].NOTEINDX
8ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
9QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency1017
10ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SVC_Contract_Line'].ITEMNMBR AS 'SVC_Contract_Line-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC00601 AS ['SVC_Contract_Line']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SVC_Contract_Line'].ITEMNMBR = ['Item Master'].ITEMNMBR
11CONFGREF SearchConfig ReferenceSTR20_LBAUString2220
12EQUIPID SearchEquipment IDLong IntLong Integer48
13SERLNMBR SearchSerial NumberSTR20_LBAUString2220
14FRZEND SearchFrozen EndDATEDate46
15FRXSTRT SearchFrozen StartDATEDate46
16BLKTIM SearchBlocked TimeCURR_TIMECurrency1010
17VALTIM SearchValue of TimeCURR_TIMECurrency1010
18DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer25
19COMDLRAM SearchCommission Dollar AmountDLR17_RBSO_STR$Currency1017
20COUNTRY SearchCountrySTR60String6260
21PRCSTAT SearchStatus of PriceSTR1String21
22PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
23DSCRIPTN SearchDescriptionSTR30String3230
24PARTPCT SearchPart PctDLR5_%2Currency108
25LABPCT SearchLabor PctDLR5_%2Currency108
26MISCPCT SearchMisc PctDLR5_%2Currency108
27PMMSCPCT SearchPM Misc PctDLR5_%2Currency108
28PMPRTPCT SearchPM Part PctDLR5_%2Currency108
29PMLABPCT SearchPM Labor PctDLR5_%2Currency108
30VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SVC_Contract_Line'].VENDORID AS 'SVC_Contract_Line-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       SVC00601 AS ['SVC_Contract_Line']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SVC_Contract_Line'].VENDORID = ['PM Vendor Master File'].VENDORID
31RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency1017
32RTNBILLD SearchRetainage BilledDLR11_RBS0_UTR$Currency1011
33SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SVC_Contract_Line'].SLPRSNID AS 'SVC_Contract_Line-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SVC00601 AS ['SVC_Contract_Line']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SVC_Contract_Line'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
34COMMCODE SearchCommission CodeSTR15_LBAUString1615
35COMPRCNT SearchCommission PercentINT5_%2Integer25
36BILSTRT SearchBill StartDATEDate46
37BILEND SearchBill EndDATEDate46
38BILLNGTH SearchBill LengthINT3Integer23
39BILPRD SearchBill PeriodDDL_Bill_PeriodInteger20
40FRSTBLDTE SearchFirst Bill DateDATEDate46
41Last_Amount_Billed SearchLast Amount BilledDLR11_RBS0_UTR$Currency1011
42LSTBLDTE SearchLast Bill DateDATEDate46
43NBRCAL SearchMax Number of CallsINT5Integer24
44TOTAL SearchTotalDollar19Currency1019
45ACTCAL SearchActual Number of CallsINT5Integer24
46TOTVALCAL SearchTotal Value of CallsDLR19_RBSO_UTR$Currency1019
47CONTACT SearchContactSTR60String6260
48CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SVC_Contract_Line'].CURNCYID AS 'SVC_Contract_Line-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       SVC00601 AS ['SVC_Contract_Line']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SVC_Contract_Line'].CURNCYID = ['Currency Setup'].CURNCYID
49NXTBLDTE SearchNext Bill DateDATEDate46
50CNTTYPE SearchContract TypeSTR10_LBAUString1210
51PRICSHED SearchPrice ScheduleSTR10_ScheduleString1210
52CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SVC_Contract_Line'].CUSTNMBR AS 'SVC_Contract_Line-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVC00601 AS ['SVC_Contract_Line']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SVC_Contract_Line'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
53ENTDTE SearchEntry DateDT_DateDate46
54MINBIL SearchMin Billable CallDLR19_RBS0_UTR$Currency1019
55MAXBIL SearchMax Billable CallDLR19_RBS0_UTR$Currency1019
56MAXBILL SearchMax BillableDLR19_RBS0_UTR$Currency1019
57AUTOREN SearchAuto RenewingCBBoolean20
58priorityLevel SearchpriorityLevelINT4Integer24
59MSTCNTRCT SearchMaster Contract NumberSTR10String1210
60SRVTYPE SearchService TypeSTR10_LBAUString1210
61BILFRRET SearchBill For RetainerCBBoolean20
62TOTBIL SearchTotal BilledDLR19_RBSO_UTR$Currency1019
63PREPAID SearchPre PaidCBBoolean20
64BILONDY SearchBill On DayINT2_U0Integer22
65BILCYC SearchBilling CycleSVC_DDL_Billing_CycleInteger20
66UOFM SearchU Of MU_Of_MString108
67BILSTAT SearchBilling StatusDDL_Bill_Status_SVCInteger20
68ENTTME SearchEntry TimeTM6Time46
69STRTDATE SearchStart DateDTDate48
70ENDDATE SearchEnd DateDTDate48
71CNTCOVPD SearchContract Coverage Periods StartTM6Time46
72CNTCOVPD_1 SearchContract Coverage Periods Start[1]TM6Time46
73CNTCOVPD_2 SearchContract Coverage Periods Start[2]TM6Time46
74CNTCOVPD_3 SearchContract Coverage Periods Start[3]TM6Time46
75CNTCOVPD_4 SearchContract Coverage Periods Start[4]TM6Time46
76CNTCOVPD_5 SearchContract Coverage Periods Start[5]TM6Time46
77CNTCOVPD_6 SearchContract Coverage Periods Start[6]TM6Time46
78CNTCOVPD_7 SearchContract Coverage Periods Start[7]TM6Time46
79Contract_Coverage_Period SearchContract Coverage Periods EndTM6Time46
80Contract_Coverage_Period_1 SearchContract Coverage Periods End[1]TM6Time46
81Contract_Coverage_Period_2 SearchContract Coverage Periods End[2]TM6Time46
82Contract_Coverage_Period_3 SearchContract Coverage Periods End[3]TM6Time46
83Contract_Coverage_Period_4 SearchContract Coverage Periods End[4]TM6Time46
84Contract_Coverage_Period_5 SearchContract Coverage Periods End[5]TM6Time46
85Contract_Coverage_Period_6 SearchContract Coverage Periods End[6]TM6Time46
86Contract_Coverage_Period_7 SearchContract Coverage Periods End[7]TM6Time46
87USECVPD SearchUse Coverage PeriodCB_DayBoolean20
88USECVPD_1 SearchUse Coverage Period[1]CB_DayBoolean20
89USECVPD_2 SearchUse Coverage Period[2]CB_DayBoolean20
90USECVPD_3 SearchUse Coverage Period[3]CB_DayBoolean20
91USECVPD_4 SearchUse Coverage Period[4]CB_DayBoolean20
92USECVPD_5 SearchUse Coverage Period[5]CB_DayBoolean20
93USECVPD_6 SearchUse Coverage Period[6]CB_DayBoolean20
94USECVPD_7 SearchUse Coverage Period[7]CB_DayBoolean20
95TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SVC_Contract_Line'].TAXSCHID AS 'SVC_Contract_Line-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SVC00601 AS ['SVC_Contract_Line']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SVC_Contract_Line'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
96CNFGLVL SearchConfig LevelINT4Integer24
97CNFGSEQ SearchConfig SequenceINT4Integer24
98Contract_Length SearchContract LengthINT3Integer23
99Contract_Period SearchContract PeriodDDL_Bill_PeriodInteger20
100Invoiced_Amount SearchInvoiced AmountDLR19_$U2Currency1019
101Amount_To_Invoice SearchAmount To InvoiceSVCDLR19_$U2Currency1019
102Liabiltiy_Reduction SearchLiability ReductionCBBoolean20
103Liability_Amount SearchLiability AmountDLR17_$U2Currency1017
104Total_Liability_Amount SearchTotal Liability AmountDLR19_$U2Currency1019
105NUMOFINV SearchNumber of InvoicesLI6_U0Long Integer46
106New_Invoice_Amount SearchNew Invoice AmountDLR19_$U2Currency1019
107Contract_Line_Status SearchContract Line StatusSTR1String21
108Contract_Renewal_Contact SearchContract Renewal ContactSTR30String3230
109Contract_Response_Time SearchContract Response TimeSTR_Bill_TimeString86
110Liability_Months SearchLiability MonthsINT3Integer23
111Next_Liability_Date SearchNext Liability DateDATEDate46
112Last_Liability_Date SearchLast Liability DateDATEDate46
113Total_Liability_Billed SearchTotal Liability BilledDLR19_$U2Currency1019
114TAXEXMT1 SearchTax Exempt 1STR25String2625
115TAXEXMT2 SearchTax Exempt 2STR25String2625
116Total_Unit SearchTotal UnitDollar19Currency1019
117UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
118Unit_Cost_Total SearchUnit Cost TotalDLR19_$U2Currency1019
119SVC_Liability_Type SearchSVC_Liability_TypeDDL_Liability_TypeInteger20
120SVC_Contract_Signed SearchSVC_Contract_SignedDATE_LDate40
121RETTYPE SearchSVC Return TypeSTR10_LBAUString1210
122SVC_Monthly_Price SearchSVC Monthly_PriceDLR17_RBS0_UTR$Currency1017
123Location_Segment SearchLocation SegmentSTR66_Site_SEGString6866
124Bill_To_Customer SearchBill To CustomerSTR15_RM_Customer_NumberString1615
125SVC_Bill_To_Address_Code SearchSVC Bill To Address CodeSTR15_Address_CodeString1615
126DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
127SVC_Invoiced_Discount SearchSVC Invoiced DiscountDLR19_$U2Currency1019
128SVC_Discount_Recognized SearchSVC Discount RecognizedDLR19_$U2Currency1019
129SVC_Discount_Remaining SearchSVC Discount RemainingDLR19_$U2Currency1019
130SVC_Discount_Next SearchSVC Discount NextDLR19_$U2Currency1019
131SVC_PM_Date SearchSVC PM MonthSVC_DDL_MonthInteger20
132SVC_PM_Day SearchSVC PM DaySVC_PM_DayInteger22
133CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['SVC_Contract_Line'].EXGTBLID AS 'SVC_Contract_Line-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       SVC00601 AS ['SVC_Contract_Line']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['SVC_Contract_Line'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
136XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
137EXCHDATE SearchExchange DateDT_DateDate46
138DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger20
139TIME1 SearchTimeTM6Time46
140RATECALC SearchRate Calc MethodINTInteger20
141VIEWMODE SearchView ModeINTInteger20
142ISMCTRX SearchIS MC TrxINTInteger20
143EXPNDATE SearchExpiration DateDT_DateDate46
144DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
145MCTRXSTT SearchMC Transaction StateINT1Integer21
146ORIGVALTIM SearchOriginating Value of TimeCURR_TIMECurrency1010
147ORCOMAMT SearchOriginating Commission Dollar AmountDLR17_RBSO_STR$Currency1017
148ORIGRETNAGAM SearchOriginating Retainage AmountDLR17_RBS0_UTR$Currency1017
149ORIGRTNBILLD SearchOriginating Retainage BilledDLR17_RBS0_UTR$Currency1017
150ORIGLASTAmountBilled SearchOriginating Last Amount BilledDLR11_RBS0_UTR$Currency1011
151ORIGTOTAL SearchOriginating Service TotalDollar19Currency1019
152ORIGTOTVALCAL SearchOriginating Total Value of CallsDLR19_RBSO_UTR$Currency1019
153ORIGMINBIL SearchOriginating Min Billable CallDLR19_RBSO_UTR$Currency1019
154ORIGMAXBIL SearchOriginating Max Billable CallDLR19_RBSO_UTR$Currency1019
155Originating_Max_Billable SearchOriginating Max BillableDLR19_RBSO_STR$Currency1019
156ORIGTOTBIL SearchOriginating Total BilledDLR19_RBSO_UTR$Currency1019
157Orig_Invoiced_Amount SearchOriginating Invoiced AmountDLR19_$U2Currency1019
158Orig_Amount_To_Invoice SearchOriginating Amount To InvoiceSVCDLR19_$U2Currency1019
159Orig_Liability_Amount SearchOriginating Liability AmountDLR19_$U2Currency1019
160OrigTotLiabilityAmount SearchOriginating Total Liability AmountDLR19_$U2Currency1019
161OrigTotLiabBilled SearchOriginating Total Liability BilledDLR19_$U2Currency1019
162Originating_Total_Unit SearchOriginating Total UnitDollar19Currency1019
163ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency1017
164ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency1011
165OrigDiscountReceived SearchOriginating Discount RecognizedDLR19_$U2Currency1019
166OrigDiscountRemaining SearchOriginating Discount RemainingDLR19_$U2Currency1019
167OrigDiscountNext SearchOriginating Discount NextDLR19_$U2Currency1019
168ORIGUNITCOSTTOTAL SearchOriginating Unit Cost TotalDLR19_$U2Currency1019
169ORIGMONTHPRICE SearchOriginating Monthly PriceDLR17_RBS0_UTR$Currency1017
170ORIGINVOICEDDISC SearchOriginating Invoiced DiscountDLR19_$U2Currency1019
171OrigNewInvoiceAmount SearchOriginating New Invoice AmountDLR19_$U2Currency1019
172TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
173ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
174SVC_FO_ID SearchSVC FO IDSTR50String5250
175MovedRevenue SearchMoved RevenueDLR17_$U2Currency1017
176OriginalTotal SearchOriginal TotalDollar19Currency1019
177OrigMovedRevenue SearchOriginating Moved RevenueDLR17_$U2Currency1017
178OrigOriginalTotal SearchOriginating Original TotalDollar19Currency1019
179Credit_Hold SearchCredit HoldCBBoolean20
180ITEMDESC SearchItem DescriptionSTR100String102100
181DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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