SVC_Contract_HDR (SVC00600)

azurecurve Products FieldService (949)ProjectSVC_Contract_HDR (SVC00600)

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

Display Name: SVC_Contract_HDR
Physical Name: SVC00600
Technical Name: SVC_Contract_HDR

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CONSTS	Contract Record Type	Integer	DDL_Contract_Status	0
2	CONTNBR	Contract Number	String	STR11	11
3	Contract_Transfer_Status	Contract Transfer Status	Integer	DDL_Transfer_Status	0
4	Contract_Transfer_Date	Contract Transfer Date	Date	DATE_L	0
5	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SVC_Contract_HDR'].TAXSCHID AS 'SVC_Contract_HDR-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM SVC00600 AS ['SVC_Contract_HDR'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SVC_Contract_HDR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
6	priorityLevel	priorityLevel	Integer	INT4	4
7	ADRSCODE	Address Code	String	STR15_Address_Code	15
8	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SVC_Contract_HDR'].NOTEINDX AS 'SVC_Contract_HDR-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SVC00600 AS ['SVC_Contract_HDR'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SVC_Contract_HDR'].NOTEINDX = ['Record Notes Master'].NOTEINDX
9	TIMEZONE	TimeZone	String	STR3_LBU	3
10	CONTPRC	Contract Price	Currency	DLR19_RBSO_UTR$	19
11	RENCNTTYP	Renewing Contract Type	Integer	DDL_Contract_Status	0
12	RENPRCSCHD	Renewing Price Schedule	String	STR10_Schedule	10
13	PCTCRYFWD	Percentage Carried Forward	Currency	DLR5_%2	8
14	FRZEND	Frozen End	Date	DATE	6
15	FRXSTRT	Frozen Start	Date	DATE	6
16	MXINCPCT	Max Increase Percentatge	Currency	DLR5_%2	8
17	BLKTIM	Blocked Time	Currency	CURR_TIME	10
18	VALTIM	Value of Time	Currency	CURR_TIME	10
19	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
20	COMDLRAM	Commission Dollar Amount	Currency	DLR17_RBSO_STR$	17
21	COUNTRY	Country	String	STR60	60
22	PRCSTAT	Status of Price	String	STR1	1
23	PORDNMBR	Purchase Order Number	String	Purchase Order Number	20
24	DSCRIPTN	Description	String	STR30	30
25	PARTPCT	Part Pct	Currency	DLR5_%2	8
26	LABPCT	Labor Pct	Currency	DLR5_%2	8
27	MISCPCT	Misc Pct	Currency	DLR5_%2	8
28	PMMSCPCT	PM Misc Pct	Currency	DLR5_%2	8
29	PMPRTPCT	PM Part Pct	Currency	DLR5_%2	8
30	PMLABPCT	PM Labor Pct	Currency	DLR5_%2	8
31	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['SVC_Contract_HDR'].VENDORID AS 'SVC_Contract_HDR-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM SVC00600 AS ['SVC_Contract_HDR'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['SVC_Contract_HDR'].VENDORID = ['PM Vendor Master File'].VENDORID
32	RETNAGAM	Retainage Amount	Currency	DLR17_RBS0_UTR$	17
33	RTNBILLD	Retainage Billed	Currency	DLR11_RBS0_UTR$	11
34	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['SVC_Contract_HDR'].SLPRSNID AS 'SVC_Contract_HDR-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM SVC00600 AS ['SVC_Contract_HDR'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['SVC_Contract_HDR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
35	COMMCODE	Commission Code	String	STR15_LBAU	15
36	COMPRCNT	Commission Percent	Integer	INT5_%2	5
37	BILSTRT	Bill Start	Date	DATE	6
38	BILEND	Bill End	Date	DATE	6
39	BILLNGTH	Bill Length	Integer	INT3	3
40	BILPRD	Bill Period	Integer	DDL_Bill_Period	0
41	TOTAL	Total	Currency	Dollar19	19
42	FRSTBLDTE	First Bill Date	Date	DATE	6
43	Last_Amount_Billed	Last Amount Billed	Currency	DLR11_RBS0_UTR$	11
44	LSTBLDTE	Last Bill Date	Date	DATE	6
45	NBRCAL	Max Number of Calls	Integer	INT5	4
46	ACTCAL	Actual Number of Calls	Integer	INT5	4
47	TOTVALCAL	Total Value of Calls	Currency	DLR19_RBSO_UTR$	19
48	CONTACT	Contact	String	STR60	60
49	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SVC_Contract_HDR'].CURNCYID AS 'SVC_Contract_HDR-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM SVC00600 AS ['SVC_Contract_HDR'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SVC_Contract_HDR'].CURNCYID = ['Currency Setup'].CURNCYID
50	NXTBLDTE	Next Bill Date	Date	DATE	6
51	CNTTYPE	Contract Type	String	STR10_LBAU	10
52	PRICSHED	Price Schedule	String	STR10_Schedule	10
53	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SVC_Contract_HDR'].CUSTNMBR AS 'SVC_Contract_HDR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVC00600 AS ['SVC_Contract_HDR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SVC_Contract_HDR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
54	ENTDTE	Entry Date	Date	DT_Date	6
55	MINBIL	Min Billable Call	Currency	DLR19_RBS0_UTR$	19
56	MAXBIL	Max Billable Call	Currency	DLR19_RBS0_UTR$	19
57	MAXBILL	Max Billable	Currency	DLR19_RBS0_UTR$	19
58	AUTOREN	Auto Renewing	Boolean	CB	0
59	MSTCNTRCT	Master Contract Number	String	STR10	10
60	SRVTYPE	Service Type	String	STR10_LBAU	10
61	BILFRRET	Bill For Retainer	Boolean	CB	0
62	TOTBIL	Total Billed	Currency	DLR19_RBSO_UTR$	19
63	PREPAID	Pre Paid	Boolean	CB	0
64	BILONDY	Bill On Day	Integer	INT2_U0	2
65	BILCYC	Billing Cycle	Integer	SVC_DDL_Billing_Cycle	0
66	UOFM	U Of M	String	U_Of_M	8
67	BILSTAT	Billing Status	Integer	DDL_Bill_Status_SVC	0
68	ENTTME	Entry Time	Time	TM6	6
69	STRTDATE	Start Date	Date	DT	8
70	ENDDATE	End Date	Date	DT	8
71	CNTCOVPD	Contract Coverage Periods Start	TM6	Time	6
72	CNTCOVPD_1	Contract Coverage Periods Start[1]	Time	TM6	6
73	CNTCOVPD_2	Contract Coverage Periods Start[2]	Time	TM6	6
74	CNTCOVPD_3	Contract Coverage Periods Start[3]	Time	TM6	6
75	CNTCOVPD_4	Contract Coverage Periods Start[4]	Time	TM6	6
76	CNTCOVPD_5	Contract Coverage Periods Start[5]	Time	TM6	6
77	CNTCOVPD_6	Contract Coverage Periods Start[6]	Time	TM6	6
78	CNTCOVPD_7	Contract Coverage Periods Start[7]	Time	TM6	6
79	Contract_Coverage_Period_1	Contract Coverage Periods End[1]	Time	TM6	6
80	Contract_Coverage_Period_2	Contract Coverage Periods End[2]	Time	TM6	6
81	Contract_Coverage_Period	Contract Coverage Periods End	TM6	Time	6
82	Contract_Coverage_Period_3	Contract Coverage Periods End[3]	Time	TM6	6
83	Contract_Coverage_Period_4	Contract Coverage Periods End[4]	Time	TM6	6
84	Contract_Coverage_Period_5	Contract Coverage Periods End[5]	Time	TM6	6
85	Contract_Coverage_Period_6	Contract Coverage Periods End[6]	Time	TM6	6
86	Contract_Coverage_Period_7	Contract Coverage Periods End[7]	Time	TM6	6
87	USECVPD_1	Use Coverage Period[1]	Boolean	CB_Day	0
88	USECVPD_2	Use Coverage Period[2]	Boolean	CB_Day	0
89	USECVPD	Use Coverage Period	CB_Day	Boolean	0
90	USECVPD_3	Use Coverage Period[3]	Boolean	CB_Day	0
91	USECVPD_4	Use Coverage Period[4]	Boolean	CB_Day	0
92	USECVPD_5	Use Coverage Period[5]	Boolean	CB_Day	0
93	USECVPD_6	Use Coverage Period[6]	Boolean	CB_Day	0
94	USECVPD_7	Use Coverage Period[7]	Boolean	CB_Day	0
95	Contract_Length	Contract Length	Integer	INT3	3
96	Contract_Period	Contract Period	Integer	DDL_Bill_Period	0
97	Invoiced_Amount	Invoiced Amount	Currency	DLR19_$U2	19
98	Liabiltiy_Reduction	Liability Reduction	Boolean	CB	0
99	Amount_To_Invoice	Amount To Invoice	Currency	SVCDLR19_$U2	19
100	Liability_Amount	Liability Amount	Currency	DLR17_$U2	17
101	Total_Liability_Amount	Total Liability Amount	Currency	DLR19_$U2	19
102	NUMOFINV	Number of Invoices	Long Integer	LI6_U0	6
103	Quote_Status	Quote Status	Integer	DDL	0
104	QUOEXPDA	Quote Expiration Date	Date	DT	8
105	Credit_Hold	Credit Hold	Boolean	CB	0
106	TAXEXMT1	Tax Exempt 1	String	STR25	25
107	TAXEXMT2	Tax Exempt 2	String	STR25	25
108	New_PO_Required	New PO Required	Boolean	CB	0
109	Contract_Renewal_Contact	Contract Renewal Contact	String	STR30	30
110	Source_Contract_Number	Source Contract Number	String	STR20_LBAU	20
111	Source_Contract_Type	Source Contract Type	Integer	DDL_Contract_Status	0
112	Contract_Response_Time	Contract Response Time	String	STR_Bill_Time	6
113	Liability_Months	Liability Months	Integer	INT3	3
114	Next_Liability_Date	Next Liability Date	Date	DATE	6
115	Last_Liability_Date	Last Liability Date	Date	DATE	6
116	Total_Liability_Billed	Total Liability Billed	Currency	DLR19_$U2	19
117	Total_Unit	Total Unit	Currency	Dollar19	19
118	Created_User_ID	SVC_Created User ID	String	STR15_User_ID	15
119	Source_User_ID	Source User ID	String	STR15_User_ID	15
120	SVC_Contract_Signed	SVC_Contract_Signed	Date	DATE_L	0
121	SVC_Liability_Type	SVC_Liability_Type	Integer	DDL_Liability_Type	0
122	RETTYPE	SVC Return Type	String	STR10_LBAU	10
123	Location_Segment	Location Segment	String	STR66_Site_SEG	66
124	Bill_To_Customer	Bill To Customer	String	STR15_RM_Customer_Number	15
125	SVC_Invoice_Detail	SVC Invoice Detail	Boolean	CB_Invoice_Detail	0
126	USERDEF1	User Defined 1	String	STR20	20
127	USERDEF2	User Defined 2	String	STR20	20
128	USRDEF03	User Defined 3	String	STR20	20
129	USRDEF04	User Defined 4	String	STR20	20
130	USRDEF05	User Defined 5	String	STR20	20
131	SVC_Bill_To_Address_Code	SVC Bill To Address Code	String	STR15_Address_Code	15
132	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
133	SVC_Paid_Contract	SVC Paid Contract	Boolean	CB	0
134	SVC_Discount_Recognized	SVC Discount Recognized	Currency	DLR19_$U2	19
135	SVC_Discount_Remaining	SVC Discount Remaining	Currency	DLR19_$U2	19
136	SVC_Discount_Next	SVC Discount Next	Currency	DLR19_$U2	19
137	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SVC_Contract_HDR'].CURRNIDX AS 'SVC_Contract_HDR-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM SVC00600 AS ['SVC_Contract_HDR'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SVC_Contract_HDR'].CURRNIDX = ['Currency Setup'].CURRNIDX
138	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['SVC_Contract_HDR'].RATETPID AS 'SVC_Contract_HDR-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM SVC00600 AS ['SVC_Contract_HDR'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['SVC_Contract_HDR'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
139	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['SVC_Contract_HDR'].EXGTBLID AS 'SVC_Contract_HDR-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM SVC00600 AS ['SVC_Contract_HDR'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['SVC_Contract_HDR'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
140	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
141	EXCHDATE	Exchange Date	Date	DT_Date	6
142	DECPLACS	Decimal Places	Integer	DDL_Decimal_Places	0
143	TIME1	Time	Time	TM6	6
144	RATECALC	Rate Calc Method	Integer	INT	0
145	VIEWMODE	View Mode	Integer	INT	0
146	ISMCTRX	IS MC Trx	Integer	INT	0
147	EXPNDATE	Expiration Date	Date	DT_Date	6
148	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
149	MCTRXSTT	MC Transaction State	Integer	INT1	1
150	ORIGVALTIM	Originating Value of Time	Currency	CURR_TIME	10
151	ORCOMAMT	Originating Commission Dollar Amount	Currency	DLR17_RBSO_STR$	17
152	ORIGRETNAGAM	Originating Retainage Amount	Currency	DLR17_RBS0_UTR$	17
153	ORIGRTNBILLD	Originating Retainage Billed	Currency	DLR17_RBS0_UTR$	17
154	ORIGTOTAL	Originating Service Total	Currency	Dollar19	19
155	ORIGLASTAmountBilled	Originating Last Amount Billed	Currency	DLR11_RBS0_UTR$	11
156	ORIGTOTVALCAL	Originating Total Value of Calls	Currency	DLR19_RBSO_UTR$	19
157	ORIGMINBIL	Originating Min Billable Call	Currency	DLR19_RBSO_UTR$	19
158	ORIGMAXBIL	Originating Max Billable Call	Currency	DLR19_RBSO_UTR$	19
159	Originating_Max_Billable	Originating Max Billable	Currency	DLR19_RBSO_STR$	19
160	ORIGTOTBIL	Originating Total Billed	Currency	DLR19_RBSO_UTR$	19
161	Orig_Invoiced_Amount	Originating Invoiced Amount	Currency	DLR19_$U2	19
162	Orig_Amount_To_Invoice	Originating Amount To Invoice	Currency	SVCDLR19_$U2	19
163	Orig_Liability_Amount	Originating Liability Amount	Currency	DLR19_$U2	19
164	OrigTotLiabilityAmount	Originating Total Liability Amount	Currency	DLR19_$U2	19
165	OrigTotLiabBilled	Originating Total Liability Billed	Currency	DLR19_$U2	19
166	Originating_Total_Unit	Originating Total Unit	Currency	Dollar19	19
167	ORDDLRAT	Originating Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
168	OrigDiscountReceived	Originating Discount Recognized	Currency	DLR19_$U2	19
169	OrigDiscountRemaining	Originating Discount Remaining	Currency	DLR19_$U2	19
170	OrigDiscountNext	Originating Discount Next	Currency	DLR19_$U2	19
171	SmoothInvoiceCalc	Smooth Invoice Calculation	Boolean	CB_Smooth_Billing	0
172	SmoothRevenueCalc	Smooth Revenue Calculation	Boolean	CB_Smooth_Revenue	0
173	SVC_Use_Same_Number	SVC Use Same Number	Boolean	CB	0
174	SVC_FO_ID	SVC FO ID	String	STR50	50
175	SVC_Invoiced_Cost	SVC Invoiced Cost	Currency	DLR19_RBS0_UTR$	19
176	Orig_SVC_Invoiced_Cost	Originating SVC Invoiced Cost	Currency	DLR19_RBS0_UTR$	19
177	SVC_Evergreen_Contract	SVC Evergreen Contract	Boolean	CB	0
178	SVC_Evergreen_RenewLimit	SVC Evergreen RenewLimit	Integer	INT4	4
179	SVC_Evergreen_Renewals	SVC Evergreen Renewals	Integer	INT4	4
180	SVC_New_Contract_Number	SVC New Contract Number	String	STR11	11
181	SVC_New_PO_Number	SVC New PO Number	String	STR20	20
182	Workflow_Approval_Status	Workflow Approval Status	Integer	DDL_WorkflowApprovalStatus	0
183	Workflow_Priority	Workflow Priority	Integer	DDL_WorkflowPriority	0
184	svcBillingFrequency	svcBillingFrequency	Integer	svcAtEvery	0
185	svcFrequencyQty	svcFrequencyQty	Integer	INT3	3

azurecurve Products FieldService (949)ProjectSVC_Contract_HDR (SVC00600)

Leave a Reply Cancel reply