| id |
integer |
Yes |
Yes |
nextval('gl_reconciliation_items_id_seq'::regclass) |
Unique identifier |
| division |
character varying(3) |
No |
No |
''::character varying |
Division of transaction being reconciled - links to gl_reconciliations.division |
| account_no |
character varying(24) |
No |
No |
''::character varying |
General Ledger account number of transaction being reconciled - links to gl_reconciliations.account_no |
| currency |
character varying(3) |
No |
No |
''::character varying |
Currency of the transaction being reconciled - links to gl_reconciliations.currency |
| trans_no |
character varying(10) |
No |
No |
''::character varying |
General Ledger transaction number being reconciled |
| trans_recno |
integer |
No |
No |
0 |
Sequencial record number |
| reconciled |
boolean |
No |
No |
false |
Previously reconciled flag; FALSE = No TRUE = Yes |
| reconcile |
boolean |
No |
No |
false |
Reconcile flag for this session; FALSE = No TRUE = Yes |