DTA10200 - Transaction Analysis Codes | Prospr

DTA10200 - Transaction Analysis Codes

Select * from DTA10200

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
CODEID	DTA_Code_ID	String	16	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
POSTDESC	DTA_Posting_Descr	String	52	View
DTAQNTY	DTA_Quantity	Currency	10	View
CODEAMT	DTA_Amount	Currency	10	View
TRXDATE	TRX Date	Date	4	View