SVC00675 - svcContractLineMoveWork | Prospr - Dynamics GP Table Reference

SVC00675 - svcContractLineMoveWork

Query Builder

Select * from SVC00675

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
CNTTYPE	Contract Type	String	12	View
STRTDATE	Start Date	Date	4	View
ENDDATE	End Date	Date	4	View
ITEMNMBR	Item Number	String	32	View
SERLNMBR	Serial Number	String	22	View
EQUIPID	Equipment ID	Long Integer	4	View
DSCRIPTN	Description	String	32	View
QUANTITY	QTY	Currency	10	View
Effective_Date	Effective Date	Date	4	View
CMXFRNUM	Transfer Number	String	22	View
To_Customer_Number	To Customer Number	String	16	View
ADRSCODE	Address Code	String	16	View
PRICSHED	Price Schedule	String	12	View
CNTPRCOVR	Contract Price Overridden	Boolean	2	View
TOTAL	Total	Currency	10	View
SVC_Monthly_Price	SVC Monthly_Price	Currency	10	View
DEDCAMNT_1	Deduction Amount[1]	Currency	10	View
DEDCAMNT_2	Deduction Amount[2]	Currency	10	View
DEDCAMNT_3	Deduction Amount[3]	Currency	10	View
DEDCAMNT_4	Deduction Amount[4]	Currency	10	View
DEDCAMNT_5	Deduction Amount[5]	Currency	10	View
RETNAGAM	Retainage Amount	Currency	10	View
RTNBILLD	Retainage Billed	Currency	10	View
NBRCAL	Max Number of Calls	Integer	2	View
ACTCAL	Actual Number of Calls	Integer	2	View
BLKTIM	Blocked Time	Currency	10	View
VALTIM	Value of Time	Currency	10	View
MKDTOPST	Marked To Post	Boolean	2	View
POSTDATE	Post Date	Date	4	View