| id |
integer |
Yes |
Yes |
nextval('gl_history_transactions_id_seq'::regclass) |
|
| division |
character varying(3) |
No |
No |
|
|
| account_no |
character varying(24) |
No |
No |
|
|
| currency |
character varying(3) |
No |
No |
|
|
| date |
date |
No |
No |
|
|
| trans_no |
character varying(10) |
No |
No |
|
|
| recno |
integer |
No |
No |
|
|
| where_from |
character varying(4) |
No |
No |
|
|
| gl_user |
character varying(12) |
No |
No |
|
|
| gl_memo |
character varying(60) |
No |
No |
|
|
| mf_who |
character varying(10) |
No |
No |
|
|
| mf_key |
character varying(20) |
No |
No |
|
|
| mf_tran |
character varying(25) |
No |
No |
|
|
| reconcile_date |
date |
No |
No |
|
|
| reconcile_flag |
boolean |
No |
No |
|
|
| post_date |
date |
No |
No |
|
|
| debit_amt |
numeric(15,2) |
No |
No |
|
|
| credit_amt |
numeric(15,2) |
No |
No |
|
|
| source_dept |
character varying(3) |
No |
No |
|
|
| rate_method |
character varying(1) |
No |
No |
|
|
| rate |
numeric(13,7) |
No |
No |
|
|
| frn_debit_amt |
numeric(15,2) |
No |
No |
|
|
| frn_credit_amt |
numeric(15,2) |
No |
No |
|
|
| job_cost_flag |
boolean |
No |
No |
|
|
| recurr_entry |
boolean |
No |
No |
|
|
| _dbversion |
integer |
No |
No |
|
|
| _created |
timestamp without time zone |
No |
No |
|
|
| _created_by |
character varying(3) |
No |
No |
|
|
| _modified |
timestamp without time zone |
No |
No |
|
|
| _modified_by |
character varying(3) |
No |
No |
|
|
| year_end |
date |
No |
No |
|
|
| job_no |
character varying(10) |
No |
No |
|
|
| job_acct_no |
character varying(10) |
No |
No |
|
|