| id |
integer |
Yes |
Yes |
nextval('ap_batch_items_id_seq'::regclass) |
Unique identifier |
| batch_id |
integer |
No |
No |
|
Batch identifier - links to ap_batches.id |
| transaction_id |
integer |
No |
No |
|
AP transaction identifier - links to ap_transactions.id |
| pay |
boolean |
No |
No |
|
Payment flag; FALSE = No TRUE = Yes |
| take_discount |
boolean |
No |
No |
|
Discount flag; FALSE = No TRUE = Yes |
| discount |
numeric(15,2) |
No |
No |
|
Discount amount |
| total |
numeric(15,2) |
No |
No |
|
Total payment |
| _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 this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |