| id |
integer |
Yes |
Yes |
nextval('gl_history_accounts_id_seq'::regclass) |
|
| division |
character varying(3) |
No |
No |
|
Division code defining divisions in a company. 000 is used for the complete company and if not divisionalized then 000 is the only division. |
| account_no |
character varying(24) |
No |
No |
|
|
| currency |
character varying(3) |
No |
No |
|
|
| gl_group |
character varying(3) |
No |
No |
|
|
| subgroup |
character varying(6) |
No |
No |
|
|
| name |
character varying(60) |
No |
No |
|
|
| dr_cr_desig |
character varying(1) |
No |
No |
|
|
| sales_acct |
boolean |
No |
No |
|
|
| browse |
character varying(60) |
No |
No |
|
|
| gifi_acct_no |
character varying(4) |
No |
No |
|
|
| opening_balance |
numeric(15,2) |
No |
No |
|
|
| foreign_opening_balance |
numeric(15,2) |
No |
No |
|
|
| next_cheque_no |
bigint |
No |
No |
|
|
| bank_acct |
boolean |
No |
No |
|
|
| mc_revalue_acct |
boolean |
No |
No |
|
|
| type |
character varying(1) |
No |
No |
|
|
| allocation_flag |
boolean |
No |
No |
|
|
| prompt_for_job |
boolean |
No |
No |
|
|
| inactive |
boolean |
No |
No |
|
|
| _dbversion |
integer |
No |
No |
|
|
| _created |
timestamp without time zone |
No |
No |
|
|
| _created_by |
character varying(3) |
No |
No |
|
|
| _modified |
timestamp without time zone |
No |
No |
|
|
| _modified_by |
character varying(3) |
No |
No |
|
|
| segments |
character varying(24)[] |
No |
No |
|
|
| this_year |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
|
| this_year_budget |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
|
| foreign_this_year |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
|
| foreign_this_year_budget |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
|
| year_end |
date |
No |
No |
|
|