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 |