| id |
integer |
Yes |
Yes |
nextval('gl_history_accounts_id_seq'::regclass) |
Unique identifier |
| division |
character varying(3) |
No |
No |
|
Division code for Geneal Ledger account as per divisions in a company; 000 = non divisionalized company or consoldated division for multi division company - links to gl_history_divisions.code |
| account_no |
character varying(24) |
No |
No |
|
General Ledger account number |
| currency |
character varying(3) |
No |
No |
|
General Ledger account currency; blank = base currency - links to currencies.code |
| gl_group |
character varying(3) |
No |
No |
|
Group for General Ledger account - links to gl_history_groups.gl_group |
| subgroup |
character varying(6) |
No |
No |
|
Subgroup for General Ledger account - links to gl_history_subgroups.subgroup |
| name |
character varying(60) |
No |
No |
|
General Ledger account name |
| dr_cr_desig |
character varying(1) |
No |
No |
|
Normal balance for the account; C = Credit D = Debit |
| sales_acct |
boolean |
No |
No |
|
Sales account flag; FALSE = No TRUE = Yes |
| browse |
character varying(60) |
No |
No |
|
General Ledger account name in uppercase |
| gifi_acct_no |
character varying(4) |
No |
No |
|
General Ledger account 4 digit GIFI code |
| opening_balance |
numeric(15,2) |
No |
No |
|
The opening balance for the beginnig of the year, of the GL account. Income and expense accounts have a zero open balance. |
| foreign_opening_balance |
numeric(15,2) |
No |
No |
|
Opening balance in foreign currency if this is a foreign account |
| next_cheque_no |
bigint |
No |
No |
|
Next cheque number, only used when this General Ledger account is a bank account |
| bank_acct |
boolean |
No |
No |
|
Bank account flag; FALSE = No TRUE = Yes |
| mc_revalue_acct |
boolean |
No |
No |
|
Multi-currency revaluation flag; FALSE = No TRUE = Yes |
| type |
character varying(1) |
No |
No |
|
Type of account; A = Asset L = Liability and Equity R = Revenue X = Expense |
| allocation_flag |
boolean |
No |
No |
|
General Ledger account allocation flag; FALSE = Is not an allocation account TRUE = Is an allocation account |
| inactive |
boolean |
No |
No |
|
General Ledger account inactive flag; FALSE = Account is active TRUE = Account is inactive and cannot be posted to |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that modified this record |
| segments |
character varying(24)[] |
No |
No |
|
Account segments; segments [1] =Segment 1 segments [2] =Segment 2 segments [3] =Segment 3 segments [4] =Segment 4 |
| this_year |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Account change per period 1 - 13, this year; this_year [1] = this year period 1 net change this_year [2] = this year period 2 net change |
| this_year_budget |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Account budget per period 1 - 13, this year; this_year_budget [1] = this year budget period 1 this_year_budget [2] = this year budget period 2 |
| foreign_this_year |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Foreign account change per period 1 - 13, next year; foreign_next_year [1] = next year period 1 net change foreign_next_year [2] = next year period 2 net change |
| foreign_this_year_budget |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Foreign account budget per period 1 - 13, this year; foreign_this_year_budget [1] = this year budget period 1 foreign_this_year_budget [2] = this year budget period 2 |
| year_end |
date |
No |
No |
|
Fiscal Year End for this history record |