Dictionary >  Module Financials >  Table EOFY aged overdue invoice list  

Display all Hide all

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