DTA10100 - Transaction Analysis Groups | Prospr

DTA10100 - Transaction Analysis Groups

Select * from DTA10100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DTASERIES	DTA_Series	Integer	2	View
DTAREF	DTA_Reference	String	26	View
ACTINDX	Account Index	Long Integer	4	View
SEQNUMBR	Sequence Number	Long Integer	4	View
GROUPID	DTA_Group_ID	String	16	View
DTA_GL_Reference	DTA_GL_Reference	String	26	View
DOCNUMBR	Document Number	String	22	View
RMDTYPAL	RM Document Type-All 0 = Reserved for balance carried forward records 1 = Sales / Invoice 2 = Reserved for schedule payments 3 = Debit Memos 4 = Finance Charges 5 = Service Repairs 6= Warranties 7 = Credit Memos 8 = Returns 9 = Payments	Integer	2	View
GROUPAMT	DTA_Group_Amount	Currency	10	View
JRNENTRY	Journal Entry	Long Integer	4	View
TRXDATE	TRX Date	Date	4	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View