SVC_Contract_Line_HIST (SVC30601)

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

Product: FieldService (949)
Series: Project

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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	CONSTS	Contract Record Type	DDL_Contract_Status	Integer	2	0
2	CONTNBR	Contract Number	STR11	String	12	11
3	LNSEQNBR	Line SEQ Number	Sequence_Number	Currency	10	19
4	Contract_Transfer_Status	Contract Transfer Status	DDL_Transfer_Status	Integer	2	0
5	Contract_Transfer_Date	Contract Transfer Date	DATE_L	Date	4	0
6	CNTPRCOVR	Contract Price Overridden	CB	Boolean	2	0
7	NOTEINDX	Note Index	DLR14	Currency	10	14
	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
8	ADRSCODE	Address Code	STR15_Address_Code	String	16	15
9	QUANTITY	QTY	DLR17_QTY_RBS0_STR	Currency	10	17
10	ITEMNMBR	Item Number	STR30_Item_Number	String	32	30
	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
11	CONFGREF	Config Reference	STR20_LBAU	String	22	20
12	EQUIPID	Equipment ID	Long Int	Long Integer	4	8
13	SERLNMBR	Serial Number	STR20_LBAU	String	22	20
14	FRZEND	Frozen End	DATE	Date	4	6
15	FRXSTRT	Frozen Start	DATE	Date	4	6
16	BLKTIM	Blocked Time	CURR_TIME	Currency	10	10
17	VALTIM	Value of Time	CURR_TIME	Currency	10	10
18	DSCPCTAM	Discount Percent Amount	INT5_%2	Integer	2	5
19	COMDLRAM	Commission Dollar Amount	DLR17_RBSO_STR$	Currency	10	17
20	COUNTRY	Country	STR60	String	62	60
21	PRCSTAT	Status of Price	STR1	String	2	1
22	PORDNMBR	Purchase Order Number	Purchase Order Number	String	22	20
23	DSCRIPTN	Description	STR30	String	32	30
24	PARTPCT	Part Pct	DLR5_%2	Currency	10	8
25	LABPCT	Labor Pct	DLR5_%2	Currency	10	8
26	MISCPCT	Misc Pct	DLR5_%2	Currency	10	8
27	PMMSCPCT	PM Misc Pct	DLR5_%2	Currency	10	8
28	PMPRTPCT	PM Part Pct	DLR5_%2	Currency	10	8
29	PMLABPCT	PM Labor Pct	DLR5_%2	Currency	10	8
30	VENDORID	Vendor ID	STR_15_Vendor_ID	String	16	15
	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
31	RETNAGAM	Retainage Amount	DLR17_RBS0_UTR$	Currency	10	17
32	RTNBILLD	Retainage Billed	DLR11_RBS0_UTR$	Currency	10	11
33	SLPRSNID	Salesperson ID	STR15_Salesperson_ID	String	16	15
	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
34	COMMCODE	Commission Code	STR15_LBAU	String	16	15
35	COMPRCNT	Commission Percent	INT5_%2	Integer	2	5
36	BILSTRT	Bill Start	DATE	Date	4	6
37	BILEND	Bill End	DATE	Date	4	6
38	BILLNGTH	Bill Length	INT3	Integer	2	3
39	BILPRD	Bill Period	DDL_Bill_Period	Integer	2	0
40	FRSTBLDTE	First Bill Date	DATE	Date	4	6
41	Last_Amount_Billed	Last Amount Billed	DLR11_RBS0_UTR$	Currency	10	11
42	LSTBLDTE	Last Bill Date	DATE	Date	4	6
43	NBRCAL	Max Number of Calls	INT5	Integer	2	4
44	TOTAL	Total	Dollar19	Currency	10	19
45	ACTCAL	Actual Number of Calls	INT5	Integer	2	4
46	TOTVALCAL	Total Value of Calls	DLR19_RBSO_UTR$	Currency	10	19
47	CONTACT	Contact	STR60	String	62	60
48	CURNCYID	Currency ID	STR15_Currency_ID	String	16	15
	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
49	NXTBLDTE	Next Bill Date	DATE	Date	4	6
50	CNTTYPE	Contract Type	STR10_LBAU	String	12	10
51	PRICSHED	Price Schedule	STR10_Schedule	String	12	10
52	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	16	15
	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
53	ENTDTE	Entry Date	DT_Date	Date	4	6
54	MINBIL	Min Billable Call	DLR19_RBS0_UTR$	Currency	10	19
55	MAXBIL	Max Billable Call	DLR19_RBS0_UTR$	Currency	10	19
56	MAXBILL	Max Billable	DLR19_RBS0_UTR$	Currency	10	19
57	AUTOREN	Auto Renewing	CB	Boolean	2	0
58	priorityLevel	priorityLevel	INT4	Integer	2	4
59	MSTCNTRCT	Master Contract Number	STR10	String	12	10
60	SRVTYPE	Service Type	STR10_LBAU	String	12	10
61	BILFRRET	Bill For Retainer	CB	Boolean	2	0
62	TOTBIL	Total Billed	DLR19_RBSO_UTR$	Currency	10	19
63	PREPAID	Pre Paid	CB	Boolean	2	0
64	BILONDY	Bill On Day	INT2_U0	Integer	2	2
65	BILCYC	Billing Cycle	SVC_DDL_Billing_Cycle	Integer	2	0
66	UOFM	U Of M	U_Of_M	String	10	8
67	BILSTAT	Billing Status	DDL_Bill_Status_SVC	Integer	2	0
68	ENTTME	Entry Time	TM6	Time	4	6
69	STRTDATE	Start Date	DT	Date	4	8
70	ENDDATE	End Date	DT	Date	4	8
71	CNTCOVPD	Contract Coverage Periods Start	TM6	Time	4	6
72	CNTCOVPD_1	Contract Coverage Periods Start[1]	TM6	Time	4	6
73	CNTCOVPD_2	Contract Coverage Periods Start[2]	TM6	Time	4	6
74	CNTCOVPD_3	Contract Coverage Periods Start[3]	TM6	Time	4	6
75	CNTCOVPD_4	Contract Coverage Periods Start[4]	TM6	Time	4	6
76	CNTCOVPD_5	Contract Coverage Periods Start[5]	TM6	Time	4	6
77	CNTCOVPD_6	Contract Coverage Periods Start[6]	TM6	Time	4	6
78	CNTCOVPD_7	Contract Coverage Periods Start[7]	TM6	Time	4	6
79	Contract_Coverage_Period	Contract Coverage Periods End	TM6	Time	4	6
80	Contract_Coverage_Period_1	Contract Coverage Periods End[1]	TM6	Time	4	6
81	Contract_Coverage_Period_2	Contract Coverage Periods End[2]	TM6	Time	4	6
82	Contract_Coverage_Period_3	Contract Coverage Periods End[3]	TM6	Time	4	6
83	Contract_Coverage_Period_4	Contract Coverage Periods End[4]	TM6	Time	4	6
84	Contract_Coverage_Period_5	Contract Coverage Periods End[5]	TM6	Time	4	6
85	Contract_Coverage_Period_6	Contract Coverage Periods End[6]	TM6	Time	4	6
86	Contract_Coverage_Period_7	Contract Coverage Periods End[7]	TM6	Time	4	6
87	USECVPD	Use Coverage Period	CB_Day	Boolean	2	0
88	USECVPD_1	Use Coverage Period[1]	CB_Day	Boolean	2	0
89	USECVPD_2	Use Coverage Period[2]	CB_Day	Boolean	2	0
90	USECVPD_3	Use Coverage Period[3]	CB_Day	Boolean	2	0
91	USECVPD_4	Use Coverage Period[4]	CB_Day	Boolean	2	0
92	USECVPD_5	Use Coverage Period[5]	CB_Day	Boolean	2	0
93	USECVPD_6	Use Coverage Period[6]	CB_Day	Boolean	2	0
94	USECVPD_7	Use Coverage Period[7]	CB_Day	Boolean	2	0
95	TAXSCHID	Tax Schedule ID	STR15_Tax_Schedule_ID	String	16	15
	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
96	CNFGLVL	Config Level	INT4	Integer	2	4
97	CNFGSEQ	Config Sequence	INT4	Integer	2	4
98	Contract_Length	Contract Length	INT3	Integer	2	3
99	Contract_Period	Contract Period	DDL_Bill_Period	Integer	2	0
100	Invoiced_Amount	Invoiced Amount	DLR19_$U2	Currency	10	19
101	Amount_To_Invoice	Amount To Invoice	SVCDLR19_$U2	Currency	10	19
102	Liabiltiy_Reduction	Liability Reduction	CB	Boolean	2	0
103	Liability_Amount	Liability Amount	DLR17_$U2	Currency	10	17
104	Total_Liability_Amount	Total Liability Amount	DLR19_$U2	Currency	10	19
105	NUMOFINV	Number of Invoices	LI6_U0	Long Integer	4	6
106	New_Invoice_Amount	New Invoice Amount	DLR19_$U2	Currency	10	19
107	Contract_Line_Status	Contract Line Status	STR1	String	2	1
108	Contract_Renewal_Contact	Contract Renewal Contact	STR30	String	32	30
109	Contract_Response_Time	Contract Response Time	STR_Bill_Time	String	8	6
110	Liability_Months	Liability Months	INT3	Integer	2	3
111	Next_Liability_Date	Next Liability Date	DATE	Date	4	6
112	Last_Liability_Date	Last Liability Date	DATE	Date	4	6
113	Total_Liability_Billed	Total Liability Billed	DLR19_$U2	Currency	10	19
114	TAXEXMT1	Tax Exempt 1	STR25	String	26	25
115	TAXEXMT2	Tax Exempt 2	STR25	String	26	25
116	Total_Unit	Total Unit	Dollar19	Currency	10	19
117	UNITCOST	Unit Cost	DLR17_RBS0_UTR$	Currency	10	17
118	Unit_Cost_Total	Unit Cost Total	DLR19_$U2	Currency	10	19
119	SVC_Liability_Type	SVC_Liability_Type	DDL_Liability_Type	Integer	2	0
120	SVC_Contract_Signed	SVC_Contract_Signed	DATE_L	Date	4	0
121	RETTYPE	SVC Return Type	STR10_LBAU	String	12	10
122	SVC_Monthly_Price	SVC Monthly_Price	DLR17_RBS0_UTR$	Currency	10	17
123	Location_Segment	Location Segment	STR66_Site_SEG	String	68	66
124	Bill_To_Customer	Bill To Customer	STR15_RM_Customer_Number	String	16	15
125	SVC_Bill_To_Address_Code	SVC Bill To Address Code	STR15_Address_Code	String	16	15
126	DSCDLRAM	Discount Dollar Amount	DLR11_RBS0_UTR$	Currency	10	11
127	SVC_Invoiced_Discount	SVC Invoiced Discount	DLR19_$U2	Currency	10	19
128	SVC_Discount_Recognized	SVC Discount Recognized	DLR19_$U2	Currency	10	19
129	SVC_Discount_Remaining	SVC Discount Remaining	DLR19_$U2	Currency	10	19
130	SVC_Discount_Next	SVC Discount Next	DLR19_$U2	Currency	10	19
131	SVC_PM_Date	SVC PM Month	SVC_DDL_Month	Integer	2	0
132	SVC_PM_Day	SVC PM Day	SVC_PM_Day	Integer	2	2
133	CURRNIDX	Currency Index	INT3	Integer	2	3
	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
134	RATETPID	Rate Type ID	STR15_Rate_Type_ID	String	16	15
	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
135	EXGTBLID	Exchange Table ID	STR15_Exchange_Table_ID	String	16	15
	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
136	XCHGRATE	Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
137	EXCHDATE	Exchange Date	DT_Date	Date	4	6
138	DECPLACS	Decimal Places	DDL_Decimal_Places	Integer	2	0
139	TIME1	Time	TM6	Time	4	6
140	RATECALC	Rate Calc Method	INT	Integer	2	0
141	VIEWMODE	View Mode	INT	Integer	2	0
142	ISMCTRX	IS MC Trx	INT	Integer	2	0
143	EXPNDATE	Expiration Date	DT_Date	Date	4	6
144	DENXRATE	Denomination Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
145	MCTRXSTT	MC Transaction State	INT1	Integer	2	1
146	ORIGVALTIM	Originating Value of Time	CURR_TIME	Currency	10	10
147	ORCOMAMT	Originating Commission Dollar Amount	DLR17_RBSO_STR$	Currency	10	17
148	ORIGRETNAGAM	Originating Retainage Amount	DLR17_RBS0_UTR$	Currency	10	17
149	ORIGRTNBILLD	Originating Retainage Billed	DLR17_RBS0_UTR$	Currency	10	17
150	ORIGLASTAmountBilled	Originating Last Amount Billed	DLR11_RBS0_UTR$	Currency	10	11
151	ORIGTOTAL	Originating Service Total	Dollar19	Currency	10	19
152	ORIGTOTVALCAL	Originating Total Value of Calls	DLR19_RBSO_UTR$	Currency	10	19
153	ORIGMINBIL	Originating Min Billable Call	DLR19_RBSO_UTR$	Currency	10	19
154	ORIGMAXBIL	Originating Max Billable Call	DLR19_RBSO_UTR$	Currency	10	19
155	Originating_Max_Billable	Originating Max Billable	DLR19_RBSO_STR$	Currency	10	19
156	ORIGTOTBIL	Originating Total Billed	DLR19_RBSO_UTR$	Currency	10	19
157	Orig_Invoiced_Amount	Originating Invoiced Amount	DLR19_$U2	Currency	10	19
158	Orig_Amount_To_Invoice	Originating Amount To Invoice	SVCDLR19_$U2	Currency	10	19
159	Orig_Liability_Amount	Originating Liability Amount	DLR19_$U2	Currency	10	19
160	OrigTotLiabilityAmount	Originating Total Liability Amount	DLR19_$U2	Currency	10	19
161	OrigTotLiabBilled	Originating Total Liability Billed	DLR19_$U2	Currency	10	19
162	Originating_Total_Unit	Originating Total Unit	Dollar19	Currency	10	19
163	ORUNTCST	Originating Unit Cost	DLR17_RBS0_UTR$	Currency	10	17
164	ORDDLRAT	Originating Discount Dollar Amount	DLR11_RBS0_UTR$	Currency	10	11
165	OrigDiscountReceived	Originating Discount Recognized	DLR19_$U2	Currency	10	19
166	OrigDiscountRemaining	Originating Discount Remaining	DLR19_$U2	Currency	10	19
167	OrigDiscountNext	Originating Discount Next	DLR19_$U2	Currency	10	19
168	ORIGUNITCOSTTOTAL	Originating Unit Cost Total	DLR19_$U2	Currency	10	19
169	ORIGMONTHPRICE	Originating Monthly Price	DLR17_RBS0_UTR$	Currency	10	17
170	ORIGINVOICEDDISC	Originating Invoiced Discount	DLR19_$U2	Currency	10	19
171	OrigNewInvoiceAmount	Originating New Invoice Amount	DLR19_$U2	Currency	10	19
172	TAXAMNT	Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
173	ORTAXAMT	Originating Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
174	SVC_FO_ID	SVC FO ID	STR50	String	52	50
175	SVC_Contract_Version	SVC_Contract_Version	INT3	Integer	2	3
176	MovedRevenue	Moved Revenue	DLR17_$U2	Currency	10	17
177	OriginalTotal	Original Total	Dollar19	Currency	10	19
178	OrigMovedRevenue	Originating Moved Revenue	DLR17_$U2	Currency	10	17
179	OrigOriginalTotal	Originating Original Total	Dollar19	Currency	10	19
180	Credit_Hold	Credit Hold	CB	Boolean	2	0
181	ITEMDESC	Item Description	STR100	String	102	100
182	DEX_ROW_ID		int	int	10	10
	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.

azurecurve Products FieldService (949)ProjectSVC_Contract_Line_HIST (SVC30601)

Leave a Reply Cancel reply