Table Data dictionary report - gl_allocations

Generated: 9/23/2016 2:34:49 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_allocations_id_seq'::regclass)
alloc_account_no character varying(24) No No Pseudo account to name the allocation
rec_no integer No No Numbered from 1 to the number of accounts the allocation will post to
account_no character varying(24) No No One of the GL accounts the allocation will post to
alloc numeric(19,4) No No The percentage that the allocation will post to this account
_dbversion integer No No
_modified timestamp without time zone No No
_modified_by character varying(3) No No
_created timestamp without time zone No No
_created_by character varying(3) No No

Constraints

Name Type Definition Comment
gl_allocations_pkey Primary key (id)

Report generated by pgAdmin III