Table Data dictionary report - gl_reconciliations

Generated: 9/23/2016 2:39:53 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('gl_reconciliations_id_seq'::regclass)
division character varying(3) No No ''::character varying Division of account being reconciled
account_no character varying(24) No No ''::character varying Account number being reconciled
currency character varying(3) No No ''::character varying Currency of account being reconciled
open_bal numeric(15,2) No No 0 Opening balance carried forward from last reconciliation of this account. Is editabale.
close_bal numeric(15,2) No No 0 Closing balance of of account being reconciled. Usually taken from bank statement.
start_date date No No No longer used
end_date date No No Ending date filters out all transactions past this date.
_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

Constraints

Name Type Definition Comment
bve_recon_pkey Primary key (id)

Report generated by pgAdmin III