Table Data dictionary report - gl_reconciliations

Generated: 2018-10-17 1:08:15 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Reconciliations saved, not yet posted

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('gl_reconciliations_id_seq'::regclass) Unique identifier
division character varying(3) No No ''::character varying Division of account being reconciled - links to gl_accounts.division
account_no character varying(24) No No ''::character varying Account number being reconciled - links to gl_accounts.account_no
currency character varying(3) No No ''::character varying Currency of account being reconciled - links to gl_accounts.currency
open_bal numeric(15,2) No No 0 Opening balance for reconcilation sesison. Can carried forward from last reconciliation of this account but is editable.
close_bal numeric(15,2) No No 0 Closong balance for reconcilation sesison, usually taken from bank statement
start_date date No No Not used
end_date date No No End date to filter out transactions past this date
_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

Constraints

Name Type Definition Comment
bve_recon_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL