SVC_Contract_Site_HDR_HIST (SVC30608)

azurecurve Products FieldService (949)ProjectSVC_Contract_Site_HDR_HIST (SVC30608)

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

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

azurecurve Products FieldService (949)ProjectSVC_Contract_Site_HDR_HIST (SVC30608)

Leave a Reply Cancel reply