Table Data dictionary report - gl_history_accounts

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

Table for historical General Ledger Accounts as they were when the Year End Close was performed for the Fiscal Year ending as stated in year_end.

Columns

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

Constraints

Name Type Definition Comment
gl_history_accounts_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL