SVC30600 - SVC_Contract_HDR_HIST | Prospr - Dynamics GP Table Reference

SVC30600 - SVC_Contract_HDR_HIST

Query Builder

Select * from SVC30600

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
Contract_Transfer_Status	Contract Transfer Status	Integer	2	View
Contract_Transfer_Date	Contract Transfer Date	Date	4	View
TAXSCHID	Tax Schedule ID	String	16	View
priorityLevel	priorityLevel	Integer	2	View
ADRSCODE	Address Code	String	16	View
NOTEINDX	Note Index	Currency	10	View
TIMEZONE	TimeZone	String	4	View
CONTPRC	Contract Price	Currency	10	View
RENCNTTYP	Renewing Contract Type	Integer	2	View
RENPRCSCHD	Renewing Price Schedule	String	12	View
PCTCRYFWD	Percentage Carried Forward	Currency	10	View
FRZEND	Frozen End	Date	4	View
FRXSTRT	Frozen Start	Date	4	View
MXINCPCT	Max Increase Percentatge	Currency	10	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
TOTAL	Total	Currency	10	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
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
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
Contract_Length	Contract Length	Integer	2	View
Contract_Period	Contract Period	Integer	2	View
Invoiced_Amount	Invoiced Amount	Currency	10	View
Liabiltiy_Reduction	Liability Reduction	Boolean	2	View
Amount_To_Invoice	Amount To Invoice	Currency	10	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
Quote_Status	Quote Status	Integer	2	View
QUOEXPDA	Quote Expiration Date	Date	4	View
Credit_Hold	Credit Hold	Boolean	2	View
TAXEXMT1	Tax Exempt 1	String	26	View
TAXEXMT2	Tax Exempt 2	String	26	View
New_PO_Required	New PO Required	Boolean	2	View
Contract_Renewal_Contact	Contract Renewal Contact	String	32	View
Source_Contract_Number	Source Contract Number	String	22	View
Source_Contract_Type	Source Contract Type	Integer	2	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
Total_Unit	Total Unit	Currency	10	View
Created_User_ID	SVC_Created User ID	String	16	View
Source_User_ID	Source User ID	String	16	View
SVC_Contract_Signed	SVC_Contract_Signed	Date	4	View
SVC_Liability_Type	SVC_Liability_Type	Integer	2	View
RETTYPE	SVC Return Type	String	12	View
Location_Segment	Location Segment	String	68	View
Bill_To_Customer	Bill To Customer	String	16	View
SVC_Invoice_Detail	SVC Invoice Detail	Boolean	2	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
USRDEF03	User Defined 3	String	22	View
USRDEF04	User Defined 4	String	22	View
USRDEF05	User Defined 5	String	22	View
SVC_Bill_To_Address_Code	SVC Bill To Address Code	String	16	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
SVC_Paid_Contract	SVC Paid Contract	Boolean	2	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
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
ORIGTOTAL	Originating Service Total	Currency	10	View
ORIGLASTAmountBilled	Originating Last Amount Billed	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
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
SmoothInvoiceCalc	Smooth Invoice Calculation	Boolean	2	View
SmoothRevenueCalc	Smooth Revenue Calculation	Boolean	2	View
SVC_Use_Same_Number	SVC Use Same Number	Boolean	2	View
SVC_FO_ID	SVC FO ID	String	52	View
SVC_Invoiced_Cost	SVC Invoiced Cost	Currency	10	View
Orig_SVC_Invoiced_Cost	Originating SVC Invoiced Cost	Currency	10	View
SVC_Contract_Version	SVC_Contract_Version	Integer	2	View
SVC_Evergreen_Contract	SVC Evergreen Contract	Boolean	2	View
SVC_Evergreen_RenewLimit	SVC Evergreen RenewLimit	Integer	2	View
SVC_Evergreen_Renewals	SVC Evergreen Renewals	Integer	2	View
SVC_New_Contract_Number	SVC New Contract Number	String	12	View
SVC_New_PO_Number	SVC New PO Number	String	22	View
Workflow_Approval_Status	Workflow Approval Status 1 – Not Submitted 2 – Submitted 3 – No Approval Needed 4 – Pending Approval 5 – Pending Changes 6 – Approved 7 – Rejected 8 – Workflow Ended 9 – Workflow Not Activated 10 – Workflow Deactivated	Integer	2	View
Workflow_Priority	Workflow Priority	Integer	2	View
svcBillingFrequency	svcBillingFrequency	Integer	2	View
svcFrequencyQty	svcFrequencyQty	Integer	2	View

SVC30600 - SVC_Contract_HDR_HIST

Query Builder

Customer Service

Information

My Account

Contact Us