Transaction Analysis Groups (DTA10100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DTA10100

Display Name: Transaction Analysis Groups
Physical Name: DTA10100
Technical Name: DTA_Transaction_Groups_WORK

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	DTASERIES	DTA_Series	Integer	INT2_U0	2
2	DTAREF	DTA_Reference	String	STR25	25
3	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Transaction Analysis Groups'].ACTINDX AS 'Transaction Analysis Groups-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM DTA10100 AS ['Transaction Analysis Groups'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Transaction Analysis Groups'].ACTINDX = ['Account Index Master'].ACTINDX
4	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
5	GROUPID	DTA_Group_ID	String	STR15_LBAU	15
6	DTA_GL_Reference	DTA_GL_Reference	String	STR25	25
7	DOCNUMBR	Document Number	String	STR20_Document_Number	20
8	RMDTYPAL	RM Document Type-All	Integer	INT2	2
	Document Type records the type of document. Click to show/hide the Document Types 0 Balance Carried Forward 1 Sales / Invoice 2 Scheduled Payments 3 Debit Memo 4 Finance Charge 5 Service Repairs 6 Warranties 7 Credit Memo 8 Returns 9 Payments
9	GROUPAMT	DTA_Group_Amount	Currency	DLR17_RBS0_STR$	17
10	JRNENTRY	Journal Entry	Long Integer	LI8_U0	8
11	TRXDATE	TRX Date	Date	DT_Date	6
12	PSTGSTUS	Posting Status	Integer	INT	0