Table > Module Financials > Table EOFY aged overdue invoice list

Table BALAGEEOY

Table	Abbreviation	Description	Module	Activity code
BALAGEEOY	BGY	EOFY aged overdue invoice list	Financials

Key	Description	Duplicates	Activity code
BGY0	USR+NUMREQ+CPY+CODBLK+BPR+ACCDAT+DUDDAT+TYP+NUM+DUDLIG	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ACC	Account		GAC			[GAC]GAC0=COA;ACC	Delete
ACCDAT	Accounting date		D
AMTNOT	Remaining ex-tax amt.		MD1
AMTNOTDUD	Amount - tax		MD1
AMTNOTDUD1	Open item amount 1		MD1
AMTNOTDUD2	Open item amount 2		MD1
AMTNOTDUD3	Open item amount 3		MD1
AMTNOTDUD4	Open item amount 4		MD1
AMTNOTDUD5	Open item amount 5		MD1
AMTNOTDUDEXD	Excluded OI amt.		MD1
AMTNOTDUDTOT	Total amount		MD1
AMTNOTINV	Turnover		MD1
AMTTAX	Remaining tax amt.		MD1
AMTTAXDUD	Tax amount		MD1
AUUID	Single identifier		AUUID
BPR	BP		BPR			[BPR]BPR0=[BGY]BPR	Delete
COA	Chart code		COA			[COA]COA0=[BGY]COA	Delete
CODBLK	Block		L	8
CPY	Company		CPY			[CPY]CPY0=[BGY]CPY	Delete
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[BGY]CREUSR	Delete
CURLED	Ledger currency		CUR			[TCU]TCU0=[BGY]CURLED	Delete
DUDDAT	Due date		D
DUDLIG	Due date number		C	3
FCY	Site		FCY			[FCY]FCY0=[BGY]FCY	Delete
FLGTOTPURSAL	Total flag		M	4	1
NBRDAYWAI	Late		L	8
NBRDUD1	Open item number 1		L	8
NBRDUD2	Open item number 2		L	8
NBRDUDEXD	Excluded OI no.		L	8
NUM	Document no.		VCR
NUMREQ	Query no.		L	8
TYP	Entry type		GTE			[GTE]GTE0=TYP;[V]GSUPCLE	Delete
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[BGY]UPDUSR	Delete
USR	Operator		AUS			[AUS]CODUSR=[BGY]USR	Delete