id |
integer |
Yes |
Yes |
nextval('gl_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_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_groups.gl_group |
subgroup |
character varying(6) |
No |
No |
|
Subgroup for General Ledger account - links to gl_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; TRUE = Yes FALSE = No |
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 period 1 of last year, of the GL account, as posted by the Year End Close function. 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; TRUE = Yes FALSE = No |
mc_revalue_acct |
boolean |
No |
No |
|
Multicurrency revaluation flag; TRUE = Yes FALSE = No |
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; TRUE = Is an allocation account FALSE = Is not an allocation account |
inactive |
boolean |
No |
No |
|
General Ledger account inactive flag; TRUE = Account is inactive and cannot be posted to FALSE = Account is active |
_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 |
last_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, last year; last_year [1] = last year period 1 net change last_year [2] = last year period 2 net change |
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 |
next_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, next year; next_year [1] = next year period 1 net change next_year [2] = next year period 2 net change |
last_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, last year; last_year_budget [1] = last year budget period 1 last_year_budget [2] = last year budget period 2 |
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 |
next_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, next year; next_year_budget [1] = next year budget period 1 next_year_budget [2] = next year budget period 2 |
this_year_forecast |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Account forecast per period 1-13, this year; this_year_forecast [1] = this year forecast period 1 this_year_forecast [2] = this year forecast period 2 |
foreign_last_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, last year; foreign_last_year [1] = last year period 1 net change foreign_last_year [2] = last year period 2 net change |
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, this year; foreign_this_year [1] = this year period 1 net change foreign_this_year [2] = this year period 2 net change |
foreign_next_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_last_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, last year; foreign_last_year_budget [1] = last year budget period 1 foreign_last_year_budget [2] = last year budget period 2 |
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 |
foreign_next_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, next year; foreign_next_year_budget [1] = next year budget period 1 foreign_next_year_budget [2] = next year budget period 2 |
foreign_last_year_forecast |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Foreign account forecast per period 1-13, last year; foreign_last_year_forecast [1] = last year forecast period 1 foreign_last_year_forecast [2] = last year forecast period 2 |
foreign_this_year_forecast |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Foreign account forecast per period 1-13, this year; foreign_this_year_forecast [1] = this year forecast period 1 foreign_this_year_forecast [2] = this year forecast period 2 |
foreign_next_year_forecast |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Foreign account forecast per period 1-13, next year; foreign_next_year_forecast [1] = next year forecast period 1 foreign_next_year_forecast [2] = next year forecast period 2 |
last_stmt_end_date |
date |
No |
No |
|
Last bank statement end date. Only used for bank accounts. |
last_stmt_balance |
numeric(15,2) |
No |
No |
|
Last bank statement end balance. Only used for bank accounts. |
udf_data |
hstore |
No |
No |
''::hstore |
User Defined Fields data |