Table Data dictionary report - gl_allocations

Generated: 2018-10-17 8:11:01 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for General Ledger Allocation posting control

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('gl_allocations_id_seq'::regclass) Unique identifier
alloc_account_no character varying(24) No No Pseudo account number assigned to the allocation
rec_no integer No No Record number, to order the accounts the allocation will post to
account_no character varying(24) No No General Ledger account that the allocation will redirect to - links to gl_accounts.account_no
alloc numeric(19,4) No No Allocation percentage that will post to this account
_dbversion integer No No Program version that last modified 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
_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

Constraints

Name Type Definition Comment
gl_allocations_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL