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