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: Project

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 TypeDDL_Contract_StatusInteger0
2CONTNBR SearchContract NumberSTR11String11
3Contract_Transfer_Status SearchContract Transfer StatusDDL_Transfer_StatusInteger0
4Contract_Transfer_Date SearchContract Transfer DateDATE_LDate0
5TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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 SearchpriorityLevelINT4Integer4
7ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
8NOTEINDX SearchNote IndexDLR14Currency14
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 SearchTimeZoneSTR3_LBUString3
10CONTPRC SearchContract PriceDLR19_RBSO_UTR$Currency19
11RENCNTTYP SearchRenewing Contract TypeDDL_Contract_StatusInteger0
12RENPRCSCHD SearchRenewing Price ScheduleSTR10_ScheduleString10
13PCTCRYFWD SearchPercentage Carried ForwardDLR5_%2Currency8
14FRZEND SearchFrozen EndDATEDate6
15FRXSTRT SearchFrozen StartDATEDate6
16MXINCPCT SearchMax Increase PercentatgeDLR5_%2Currency8
17BLKTIM SearchBlocked TimeCURR_TIMECurrency10
18VALTIM SearchValue of TimeCURR_TIMECurrency10
19DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer5
20COMDLRAM SearchCommission Dollar AmountDLR17_RBSO_STR$Currency17
21COUNTRY SearchCountrySTR60String60
22PRCSTAT SearchStatus of PriceSTR1String1
23PORDNMBR SearchPurchase Order NumberPurchase Order NumberString20
24DSCRIPTN SearchDescriptionSTR30String30
25PARTPCT SearchPart PctDLR5_%2Currency8
26LABPCT SearchLabor PctDLR5_%2Currency8
27MISCPCT SearchMisc PctDLR5_%2Currency8
28PMMSCPCT SearchPM Misc PctDLR5_%2Currency8
29PMPRTPCT SearchPM Part PctDLR5_%2Currency8
30PMLABPCT SearchPM Labor PctDLR5_%2Currency8
31VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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 AmountDLR17_RBS0_UTR$Currency17
33RTNBILLD SearchRetainage BilledDLR11_RBS0_UTR$Currency11
34SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
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 CodeSTR15_LBAUString15
36COMPRCNT SearchCommission PercentINT5_%2Integer5
37BILSTRT SearchBill StartDATEDate6
38BILEND SearchBill EndDATEDate6
39BILLNGTH SearchBill LengthINT3Integer3
40BILPRD SearchBill PeriodDDL_Bill_PeriodInteger0
41TOTAL SearchTotalDollar19Currency19
42FRSTBLDTE SearchFirst Bill DateDATEDate6
43Last_Amount_Billed SearchLast Amount BilledDLR11_RBS0_UTR$Currency11
44LSTBLDTE SearchLast Bill DateDATEDate6
45NBRCAL SearchMax Number of CallsINT5Integer4
46ACTCAL SearchActual Number of CallsINT5Integer4
47TOTVALCAL SearchTotal Value of CallsDLR19_RBSO_UTR$Currency19
48CONTACT SearchContactSTR60String60
49CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 TypeSTR10_LBAUString10
52PRICSHED SearchPrice ScheduleSTR10_ScheduleString10
53CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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 DateDT_DateDate6
55MINBIL SearchMin Billable CallDLR19_RBS0_UTR$Currency19
56MAXBIL SearchMax Billable CallDLR19_RBS0_UTR$Currency19
57MAXBILL SearchMax BillableDLR19_RBS0_UTR$Currency19
58AUTOREN SearchAuto RenewingCBBoolean0
59MSTCNTRCT SearchMaster Contract NumberSTR10String10
60SRVTYPE SearchService TypeSTR10_LBAUString10
61BILFRRET SearchBill For RetainerCBBoolean0
62TOTBIL SearchTotal BilledDLR19_RBSO_UTR$Currency19
63PREPAID SearchPre PaidCBBoolean0
64BILONDY SearchBill On DayINT2_U0Integer2
65BILCYC SearchBilling CycleSVC_DDL_Billing_CycleInteger0
66UOFM SearchU Of MU_Of_MString8
67BILSTAT SearchBilling StatusDDL_Bill_Status_SVCInteger0
68ENTTME SearchEntry TimeTM6Time6
69STRTDATE SearchStart DateDTDate8
70ENDDATE SearchEnd DateDTDate8
71CNTCOVPD SearchContract Coverage Periods StartTM6Time6
72CNTCOVPD_1 SearchContract Coverage Periods Start[1]TM6Time6
73CNTCOVPD_2 SearchContract Coverage Periods Start[2]TM6Time6
74CNTCOVPD_3 SearchContract Coverage Periods Start[3]TM6Time6
75CNTCOVPD_4 SearchContract Coverage Periods Start[4]TM6Time6
76CNTCOVPD_5 SearchContract Coverage Periods Start[5]TM6Time6
77CNTCOVPD_6 SearchContract Coverage Periods Start[6]TM6Time6
78CNTCOVPD_7 SearchContract Coverage Periods Start[7]TM6Time6
79Contract_Coverage_Period SearchContract Coverage Periods EndTM6Time6
80Contract_Coverage_Period_1 SearchContract Coverage Periods End[1]TM6Time6
81Contract_Coverage_Period_2 SearchContract Coverage Periods End[2]TM6Time6
82Contract_Coverage_Period_3 SearchContract Coverage Periods End[3]TM6Time6
83Contract_Coverage_Period_4 SearchContract Coverage Periods End[4]TM6Time6
84Contract_Coverage_Period_5 SearchContract Coverage Periods End[5]TM6Time6
85Contract_Coverage_Period_6 SearchContract Coverage Periods End[6]TM6Time6
86Contract_Coverage_Period_7 SearchContract Coverage Periods End[7]TM6Time6
87USECVPD SearchUse Coverage PeriodCB_DayBoolean0
88USECVPD_1 SearchUse Coverage Period[1]CB_DayBoolean0
89USECVPD_2 SearchUse Coverage Period[2]CB_DayBoolean0
90USECVPD_3 SearchUse Coverage Period[3]CB_DayBoolean0
91USECVPD_4 SearchUse Coverage Period[4]CB_DayBoolean0
92USECVPD_5 SearchUse Coverage Period[5]CB_DayBoolean0
93USECVPD_6 SearchUse Coverage Period[6]CB_DayBoolean0
94USECVPD_7 SearchUse Coverage Period[7]CB_DayBoolean0
95Contract_Length SearchContract LengthINT3Integer3
96Contract_Period SearchContract PeriodDDL_Bill_PeriodInteger0
97Invoiced_Amount SearchInvoiced AmountDLR19_$U2Currency19
98Liabiltiy_Reduction SearchLiability ReductionCBBoolean0
99Amount_To_Invoice SearchAmount To InvoiceSVCDLR19_$U2Currency19
100Liability_Amount SearchLiability AmountDLR17_$U2Currency17
101Total_Liability_Amount SearchTotal Liability AmountDLR19_$U2Currency19
102NUMOFINV SearchNumber of InvoicesLI6_U0Long Integer6
103Quote_Status SearchQuote StatusDDLInteger0
104QUOEXPDA SearchQuote Expiration DateDTDate8
105Credit_Hold SearchCredit HoldCBBoolean0
106TAXEXMT1 SearchTax Exempt 1STR25String25
107TAXEXMT2 SearchTax Exempt 2STR25String25
108New_PO_Required SearchNew PO RequiredCBBoolean0
109Contract_Renewal_Contact SearchContract Renewal ContactSTR30String30
110Source_Contract_Number SearchSource Contract NumberSTR20_LBAUString20
111Source_Contract_Type SearchSource Contract TypeDDL_Contract_StatusInteger0
112Contract_Response_Time SearchContract Response TimeSTR_Bill_TimeString6
113Liability_Months SearchLiability MonthsINT3Integer3
114Next_Liability_Date SearchNext Liability DateDATEDate6
115Last_Liability_Date SearchLast Liability DateDATEDate6
116Total_Liability_Billed SearchTotal Liability BilledDLR19_$U2Currency19
117Total_Unit SearchTotal UnitDollar19Currency19
118Created_User_ID SearchSVC_Created User IDSTR15_User_IDString15
119Source_User_ID SearchSource User IDSTR15_User_IDString15
120SVC_Contract_Signed SearchSVC_Contract_SignedDATE_LDate0
121SVC_Liability_Type SearchSVC_Liability_TypeDDL_Liability_TypeInteger0
122RETTYPE SearchSVC Return TypeSTR10_LBAUString10
123Location_Segment SearchLocation SegmentSTR66_Site_SEGString66
124Bill_To_Customer SearchBill To CustomerSTR15_RM_Customer_NumberString15
125SVC_Invoice_Detail SearchSVC Invoice DetailCB_Invoice_DetailBoolean0
126USERDEF1 SearchUser Defined 1STR20String20
127USERDEF2 SearchUser Defined 2STR20String20
128USRDEF03 SearchUser Defined 3STR20String20
129USRDEF04 SearchUser Defined 4STR20String20
130USRDEF05 SearchUser Defined 5STR20String20
131SVC_Bill_To_Address_Code SearchSVC Bill To Address CodeSTR15_Address_CodeString15
132DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency11
133SVC_Paid_Contract SearchSVC Paid ContractCBBoolean0
134SVC_Discount_Recognized SearchSVC Discount RecognizedDLR19_$U2Currency19
135SVC_Discount_Remaining SearchSVC Discount RemainingDLR19_$U2Currency19
136SVC_Discount_Next SearchSVC Discount NextDLR19_$U2Currency19
137CURRNIDX SearchCurrency IndexINT3Integer3
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 IDSTR15_Rate_Type_IDString15
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 IDSTR15_Exchange_Table_IDString15
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 RateDLR14_Exchange_RateCurrency (Variable)14
141EXCHDATE SearchExchange DateDT_DateDate6
142DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger0
143TIME1 SearchTimeTM6Time6
144RATECALC SearchRate Calc MethodINTInteger0
145VIEWMODE SearchView ModeINTInteger0
146ISMCTRX SearchIS MC TrxINTInteger0
147EXPNDATE SearchExpiration DateDT_DateDate6
148DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
149MCTRXSTT SearchMC Transaction StateINT1Integer1
150ORIGVALTIM SearchOriginating Value of TimeCURR_TIMECurrency10
151ORCOMAMT SearchOriginating Commission Dollar AmountDLR17_RBSO_STR$Currency17
152ORIGRETNAGAM SearchOriginating Retainage AmountDLR17_RBS0_UTR$Currency17
153ORIGRTNBILLD SearchOriginating Retainage BilledDLR17_RBS0_UTR$Currency17
154ORIGTOTAL SearchOriginating Service TotalDollar19Currency19
155ORIGLASTAmountBilled SearchOriginating Last Amount BilledDLR11_RBS0_UTR$Currency11
156ORIGTOTVALCAL SearchOriginating Total Value of CallsDLR19_RBSO_UTR$Currency19
157ORIGMINBIL SearchOriginating Min Billable CallDLR19_RBSO_UTR$Currency19
158ORIGMAXBIL SearchOriginating Max Billable CallDLR19_RBSO_UTR$Currency19
159Originating_Max_Billable SearchOriginating Max BillableDLR19_RBSO_STR$Currency19
160ORIGTOTBIL SearchOriginating Total BilledDLR19_RBSO_UTR$Currency19
161Orig_Invoiced_Amount SearchOriginating Invoiced AmountDLR19_$U2Currency19
162Orig_Amount_To_Invoice SearchOriginating Amount To InvoiceSVCDLR19_$U2Currency19
163Orig_Liability_Amount SearchOriginating Liability AmountDLR19_$U2Currency19
164OrigTotLiabilityAmount SearchOriginating Total Liability AmountDLR19_$U2Currency19
165OrigTotLiabBilled SearchOriginating Total Liability BilledDLR19_$U2Currency19
166Originating_Total_Unit SearchOriginating Total UnitDollar19Currency19
167ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
168OrigDiscountReceived SearchOriginating Discount RecognizedDLR19_$U2Currency19
169OrigDiscountRemaining SearchOriginating Discount RemainingDLR19_$U2Currency19
170OrigDiscountNext SearchOriginating Discount NextDLR19_$U2Currency19
171SmoothInvoiceCalc SearchSmooth Invoice CalculationCB_Smooth_BillingBoolean0
172SmoothRevenueCalc SearchSmooth Revenue CalculationCB_Smooth_RevenueBoolean0
173SVC_Use_Same_Number SearchSVC Use Same NumberCBBoolean0
174SVC_FO_ID SearchSVC FO IDSTR50String50
175SVC_Invoiced_Cost SearchSVC Invoiced CostDLR19_RBS0_UTR$Currency19
176Orig_SVC_Invoiced_Cost SearchOriginating SVC Invoiced CostDLR19_RBS0_UTR$Currency19
177SVC_Contract_Version SearchSVC_Contract_VersionINT3Integer3
178SVC_Evergreen_Contract SearchSVC Evergreen ContractCBBoolean0
179SVC_Evergreen_RenewLimit SearchSVC Evergreen RenewLimitINT4Integer4
180SVC_Evergreen_Renewals SearchSVC Evergreen RenewalsINT4Integer4
181SVC_New_Contract_Number SearchSVC New Contract NumberSTR11String11
182SVC_New_PO_Number SearchSVC New PO NumberSTR20String20
183Workflow_Approval_Status SearchWorkflow Approval StatusDDL_WorkflowApprovalStatusInteger0
184Workflow_Priority SearchWorkflow PriorityDDL_WorkflowPriorityInteger0
185svcBillingFrequency SearchsvcBillingFrequencysvcAtEveryInteger0
186svcFrequencyQty SearchsvcFrequencyQtyINT3Integer3
187DEX_ROW_ID Searchintint10

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.

azurecurveProductsFieldService (949)ProjectSVC_Contract_HDR_HIST (SVC30600)

Leave a Reply

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