SVC30601 - SVC_Contract_Line_HIST | Prospr - Dynamics GP Table Reference

SVC30601 - SVC_Contract_Line_HIST

Query Builder

Select * from SVC30601

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CONSTS	Contract Record Type	Integer	2	View
CONTNBR	Contract Number	String	12	View
LNSEQNBR	Line SEQ Number	Currency	10	View
Contract_Transfer_Status	Contract Transfer Status	Integer	2	View
Contract_Transfer_Date	Contract Transfer Date	Date	4	View
CNTPRCOVR	Contract Price Overridden	Boolean	2	View
NOTEINDX	Note Index	Currency	10	View
ADRSCODE	Address Code	String	16	View
QUANTITY	QTY	Currency	10	View
ITEMNMBR	Item Number	String	32	View
CONFGREF	Config Reference	String	22	View
EQUIPID	Equipment ID	Long Integer	4	View
SERLNMBR	Serial Number	String	22	View
FRZEND	Frozen End	Date	4	View
FRXSTRT	Frozen Start	Date	4	View
BLKTIM	Blocked Time	Currency	10	View
VALTIM	Value of Time	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
COMDLRAM	Commission Dollar Amount	Currency	10	View
COUNTRY	Country	String	62	View
PRCSTAT	Status of Price	String	2	View
PORDNMBR	Purchase Order Number	String	22	View
DSCRIPTN	Description	String	32	View
PARTPCT	Part Pct	Currency	10	View
LABPCT	Labor Pct	Currency	10	View
MISCPCT	Misc Pct	Currency	10	View
PMMSCPCT	PM Misc Pct	Currency	10	View
PMPRTPCT	PM Part Pct	Currency	10	View
PMLABPCT	PM Labor Pct	Currency	10	View
VENDORID	Vendor ID	String	16	View
RETNAGAM	Retainage Amount	Currency	10	View
RTNBILLD	Retainage Billed	Currency	10	View
SLPRSNID	Salesperson ID	String	16	View
COMMCODE	Commission Code	String	16	View
COMPRCNT	Commission Percent	Integer	2	View
BILSTRT	Bill Start	Date	4	View
BILEND	Bill End	Date	4	View
BILLNGTH	Bill Length	Integer	2	View
BILPRD	Bill Period	Integer	2	View
FRSTBLDTE	First Bill Date	Date	4	View
Last_Amount_Billed	Last Amount Billed	Currency	10	View
LSTBLDTE	Last Bill Date	Date	4	View
NBRCAL	Max Number of Calls	Integer	2	View
TOTAL	Total	Currency	10	View
ACTCAL	Actual Number of Calls	Integer	2	View
TOTVALCAL	Total Value of Calls	Currency	10	View
CONTACT	Contact	String	62	View
CURNCYID	Currency ID	String	16	View
NXTBLDTE	Next Bill Date	Date	4	View
CNTTYPE	Contract Type	String	12	View
PRICSHED	Price Schedule	String	12	View
CUSTNMBR	Customer Number	String	16	View
ENTDTE	Entry Date	Date	4	View
MINBIL	Min Billable Call	Currency	10	View
MAXBIL	Max Billable Call	Currency	10	View
MAXBILL	Max Billable	Currency	10	View
AUTOREN	Auto Renewing	Boolean	2	View
priorityLevel	priorityLevel	Integer	2	View
MSTCNTRCT	Master Contract Number	String	12	View
SRVTYPE	Service Type	String	12	View
BILFRRET	Bill For Retainer	Boolean	2	View
TOTBIL	Total Billed	Currency	10	View
PREPAID	Pre Paid	Boolean	2	View
BILONDY	Bill On Day	Integer	2	View
BILCYC	Billing Cycle	Integer	2	View
UOFM	U Of M	String	10	View
BILSTAT	Billing Status	Integer	2	View
ENTTME	Entry Time	Time	4	View
STRTDATE	Start Date	Date	4	View
ENDDATE	End Date	Date	4	View
CNTCOVPD_1	Contract Coverage Periods Start[1]	Time	4	View
CNTCOVPD_2	Contract Coverage Periods Start[2]	Time	4	View
CNTCOVPD_3	Contract Coverage Periods Start[3]	Time	4	View
CNTCOVPD_4	Contract Coverage Periods Start[4]	Time	4	View
CNTCOVPD_5	Contract Coverage Periods Start[5]	Time	4	View
CNTCOVPD_6	Contract Coverage Periods Start[6]	Time	4	View
CNTCOVPD_7	Contract Coverage Periods Start[7]	Time	4	View
Contract_Coverage_Period_1	Contract Coverage Periods End[1]	Time	4	View
Contract_Coverage_Period_2	Contract Coverage Periods End[2]	Time	4	View
Contract_Coverage_Period_3	Contract Coverage Periods End[3]	Time	4	View
Contract_Coverage_Period_4	Contract Coverage Periods End[4]	Time	4	View
Contract_Coverage_Period_5	Contract Coverage Periods End[5]	Time	4	View
Contract_Coverage_Period_6	Contract Coverage Periods End[6]	Time	4	View
Contract_Coverage_Period_7	Contract Coverage Periods End[7]	Time	4	View
USECVPD_1	Use Coverage Period[1]	Boolean	2	View
USECVPD_2	Use Coverage Period[2]	Boolean	2	View
USECVPD_3	Use Coverage Period[3]	Boolean	2	View
USECVPD_4	Use Coverage Period[4]	Boolean	2	View
USECVPD_5	Use Coverage Period[5]	Boolean	2	View
USECVPD_6	Use Coverage Period[6]	Boolean	2	View
USECVPD_7	Use Coverage Period[7]	Boolean	2	View
TAXSCHID	Tax Schedule ID	String	16	View
CNFGLVL	Config Level	Integer	2	View
CNFGSEQ	Config Sequence	Integer	2	View
Contract_Length	Contract Length	Integer	2	View
Contract_Period	Contract Period	Integer	2	View
Invoiced_Amount	Invoiced Amount	Currency	10	View
Amount_To_Invoice	Amount To Invoice	Currency	10	View
Liabiltiy_Reduction	Liability Reduction	Boolean	2	View
Liability_Amount	Liability Amount	Currency	10	View
Total_Liability_Amount	Total Liability Amount	Currency	10	View
NUMOFINV	Number of Invoices	Long Integer	4	View
New_Invoice_Amount	New Invoice Amount	Currency	10	View
Contract_Line_Status	Contract Line Status	String	2	View
Contract_Renewal_Contact	Contract Renewal Contact	String	32	View
Contract_Response_Time	Contract Response Time	String	8	View
Liability_Months	Liability Months	Integer	2	View
Next_Liability_Date	Next Liability Date	Date	4	View
Last_Liability_Date	Last Liability Date	Date	4	View
Total_Liability_Billed	Total Liability Billed	Currency	10	View
TAXEXMT1	Tax Exempt 1	String	26	View
TAXEXMT2	Tax Exempt 2	String	26	View
Total_Unit	Total Unit	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
Unit_Cost_Total	Unit Cost Total	Currency	10	View
SVC_Liability_Type	SVC_Liability_Type	Integer	2	View
SVC_Contract_Signed	SVC_Contract_Signed	Date	4	View
RETTYPE	SVC Return Type	String	12	View
SVC_Monthly_Price	SVC Monthly_Price	Currency	10	View
Location_Segment	Location Segment	String	68	View
Bill_To_Customer	Bill To Customer	String	16	View
SVC_Bill_To_Address_Code	SVC Bill To Address Code	String	16	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
SVC_Invoiced_Discount	SVC Invoiced Discount	Currency	10	View
SVC_Discount_Recognized	SVC Discount Recognized	Currency	10	View
SVC_Discount_Remaining	SVC Discount Remaining	Currency	10	View
SVC_Discount_Next	SVC Discount Next	Currency	10	View
SVC_PM_Date	SVC PM Month	Integer	2	View
SVC_PM_Day	SVC PM Day	Integer	2	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
DECPLACS	Decimal Places	Integer	2	View
TIME1	Time	Time	4	View
RATECALC	Rate Calc Method	Integer	2	View
VIEWMODE	View Mode	Integer	2	View
ISMCTRX	IS MC Trx	Integer	2	View
EXPNDATE	Expiration Date	Date	4	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
ORIGVALTIM	Originating Value of Time	Currency	10	View
ORCOMAMT	Originating Commission Dollar Amount	Currency	10	View
ORIGRETNAGAM	Originating Retainage Amount	Currency	10	View
ORIGRTNBILLD	Originating Retainage Billed	Currency	10	View
ORIGLASTAmountBilled	Originating Last Amount Billed	Currency	10	View
ORIGTOTAL	Originating Service Total	Currency	10	View
ORIGTOTVALCAL	Originating Total Value of Calls	Currency	10	View
ORIGMINBIL	Originating Min Billable Call	Currency	10	View
ORIGMAXBIL	Originating Max Billable Call	Currency	10	View
Originating_Max_Billable	Originating Max Billable	Currency	10	View
ORIGTOTBIL	Originating Total Billed	Currency	10	View
Orig_Invoiced_Amount	Originating Invoiced Amount	Currency	10	View
Orig_Amount_To_Invoice	Originating Amount To Invoice	Currency	10	View
Orig_Liability_Amount	Originating Liability Amount	Currency	10	View
OrigTotLiabilityAmount	Originating Total Liability Amount	Currency	10	View
OrigTotLiabBilled	Originating Total Liability Billed	Currency	10	View
Originating_Total_Unit	Originating Total Unit	Currency	10	View
ORUNTCST	Originating Unit Cost	Currency	10	View
ORDDLRAT	Originating Discount Dollar Amount	Currency	10	View
OrigDiscountReceived	Originating Discount Recognized	Currency	10	View
OrigDiscountRemaining	Originating Discount Remaining	Currency	10	View
OrigDiscountNext	Originating Discount Next	Currency	10	View
ORIGUNITCOSTTOTAL	Originating Unit Cost Total	Currency	10	View
ORIGMONTHPRICE	Originating Monthly Price	Currency	10	View
ORIGINVOICEDDISC	Originating Invoiced Discount	Currency	10	View
OrigNewInvoiceAmount	Originating New Invoice Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
SVC_FO_ID	SVC FO ID	String	52	View
SVC_Contract_Version	SVC_Contract_Version	Integer	2	View
MovedRevenue	Moved Revenue	Currency	10	View
OriginalTotal	Original Total	Currency	10	View
OrigMovedRevenue	Originating Moved Revenue	Currency	10	View
OrigOriginalTotal	Originating Original Total	Currency	10	View
Credit_Hold	Credit Hold	Boolean	2	View
ITEMDESC	Item Description	String	102	View

SVC30601 - SVC_Contract_Line_HIST

Query Builder

Customer Service

Information

My Account

Contact Us