| id |
integer |
Yes |
Yes |
nextval('gl_reconciliations_id_seq'::regclass) |
Unique identifier |
| division |
character varying(3) |
No |
No |
''::character varying |
Division of account being reconciled - links to gl_accounts.division |
| account_no |
character varying(24) |
No |
No |
''::character varying |
Account number being reconciled - links to gl_accounts.account_no |
| currency |
character varying(3) |
No |
No |
''::character varying |
Currency of account being reconciled - links to gl_accounts.currency |
| open_bal |
numeric(15,2) |
No |
No |
0 |
Opening balance for reconcilation sesison. Can carried forward from last reconciliation of this account but is editable. |
| close_bal |
numeric(15,2) |
No |
No |
0 |
Closong balance for reconcilation sesison, usually taken from bank statement |
| start_date |
date |
No |
No |
|
Not used |
| end_date |
date |
No |
No |
|
End date to filter out transactions past this date |
| _dbversion |
integer |
No |
No |
|
Program version that last 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 |
| _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 |