| id |
integer |
Yes |
Yes |
nextval('ap_batches_id_seq'::regclass) |
Uniique identifier |
| currency |
character varying(3) |
No |
No |
|
Currency code for batch - links to currencies.code |
| date |
date |
No |
No |
|
Batch payment date |
| due_by |
date |
No |
No |
|
Date due by filter used for batch |
| total |
numeric(15,2) |
No |
No |
|
Batch total |
| payment_account |
character varying(24) |
No |
No |
|
General Ledger account for payments |
| note |
character varying(60) |
No |
No |
|
User added note |
| _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 intitals that created the record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User intitals that last modified the record |
| payment_method |
integer |
No |
No |
|
Payment method identified - Links to payments_methods.id |
| terms_code |
character varying(10) |
No |
No |
|
Payment terms filter used |