| id |
integer |
Yes |
Yes |
nextval('ar_batches_id_seq'::regclass) |
Unique 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 |
| terms_code |
character varying(10) |
No |
No |
|
Payment terms filter used for batch |
| total |
numeric(15,2) |
No |
No |
|
Batch total |
| payment_method |
integer |
No |
No |
|
Payment method selected for batch |
| 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 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 |