Table Data dictionary report - gl_reconciliation_items

Generated: 9/23/2016 2:39:27 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_reconciliation_items_id_seq'::regclass)
division	character varying(3)	No	No	''::character varying	Division of the GL transaction being reconciled
account_no	character varying(24)	No	No	''::character varying	GL account of transaction being reconciled. Links to table gl_reconciliations.account_no
currency	character varying(3)	No	No	''::character varying	Currency of the GL transaction being reconciled
trans_no	character varying(10)	No	No	''::character varying	GL transaction number being reconciled
trans_recno	integer	No	No	0	Record number starting from 1 of the GL trans being reconciled
reconciled	boolean	No	No	false	Reconciled TRUE = Yes FALSE = No
reconcile	boolean	No	No	false

Constraints

Name	Type	Definition	Comment
bve_recon_detail_pkey	Primary key	(id)

Report generated by pgAdmin III