SVC00614 - svc Contract Line Revenue Audit | Prospr - Dynamics GP Table Reference

SVC00614 - svc Contract Line Revenue Audit

Query Builder

Select * from SVC00614

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
TRXSORCE	TRX Source	String	14	View
CONSTS	Contract Record Type	Integer	2	View
CONTNBR	Contract Number	String	12	View
LNSEQNBR	Line SEQ Number	Currency	10	View
YEAR1	Year	Integer	2	View
PERIODID	Period ID	Integer	2	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
Status	Status	Integer	2	View
POSTEDDT	Posted Date	Date	4	View
Transaction_Date	Transaction Date	Date	4	View
PSTDAMNT	Posted Amount	Currency	10	View
Source_Trx_Document_Type	Source Trx Document Type	String	4	View
SourceTrxDocumentNumber	Source Trx Document Number	String	256	View
Transaction_Amount	Transaction Amount	Currency	10	View
SVC_Coverage_Start_Date	SVC_Coverage_Start_Date	Date	4	View
SVC_Coverage_End_Date	SVC_Coverage_End_Date	Date	4	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
Net_Transaction_Amount	Net Transaction Amount	Currency	10	View
ERMSGNUM	Error MSG Number	Long Integer	4	View
ERRDESCR	Error Description	String	132	View