SVC06131 - SVC_Depot_MSTR_Line_Distribution | Prospr - Dynamics GP Table Reference

SVC06131 - SVC_Depot_MSTR_Line_Distribution

Query Builder

Select * from SVC06131

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
WORECTYPE	Work Order Record Type	Integer	2	View
WORKORDNUM	Work Order Number	String	12	View
LINITMTYP	Line Item Type	String	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
SEQNUMBR	Sequence Number	Long Integer	4	View
SVC_Distribution_Type	SVC Distribution Type	Integer	2	View
DistRef	Distribution Reference	String	32	View
ACTINDX	Account Index	Long Integer	4	View
DEBITAMT	Debit Amount	Currency	10	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
CURRNIDX	Currency Index	Integer	2	View
TRXSORCE	TRX Source	String	14	View
POSTED	Posted	Boolean	2	View
POSTEDDT	Posted Date	Date	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View