Table Data dictionary report - gl_accounts

Generated: 2018-10-17 8:09:37 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for General Ledger Accounts

Columns

Name Data type Not Null? Primary key? Default Comment
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

Constraints

Name Type Definition Comment
gl_chart_of_accounts_pkey Primary key (id)
zero_allocation_balance Check (this_year = '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] AND this_year = '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] AND next_year = '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] OR allocation_flag = false)

Report generated by pgAdmin3 LTS by BigSQL