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 |
|
|