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 |