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 |