id |
integer |
Yes |
Yes |
nextval('sales_order_payments_id_seq'::regclass) |
Unique identifier |
order_no |
character varying(10) |
No |
No |
|
Sales Order number that payment was for - link to sales_orders.order_no |
sequence |
smallint |
No |
No |
|
Sequential number for payments, used when more than one payment exists on a Sales Order |
payment_method |
integer |
Yes |
No |
|
Payment method for this record - links to payment_methods.id |
currency |
character varying(3) |
Yes |
No |
''::character varying |
Payment method currency; blank = base currency - links to currencies.code |
division |
character varying(3) |
Yes |
No |
''::character varying |
General Ledger Division for payment |
gl_account |
character varying(24) |
Yes |
No |
''::character varying |
General Ledger account for payment |
amount |
numeric(15,2) |
Yes |
No |
|
Payment amount |
auth_code |
character varying(20) |
No |
No |
|
Credit card authorization recorded at payment time |
ccard_postal_code |
character varying(16) |
No |
No |
|
Credit card postal code |
cust_no |
character varying(20) |
No |
No |
|
Customer numberfor payment - links to customers.cust_no |
payment_date |
date |
No |
No |
|
Date payment was made |
layaway_flag |
boolean |
No |
No |
|
This payment is a deposit on the Sales Order; FALSE = No TRUE = Yes |
trans_no |
character varying(10) |
No |
No |
|
General Ledger transaction number for payment - links to gl_transactions.trans_no |
_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 |
change |
numeric(15,2) |
Yes |
No |
|
Change given on payment |
last_four |
character varying(4) |
No |
No |
|
Last four characters of the credit card number |
_deleted |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was deleted by user, blank if not deleted |
_deleted_by |
character varying(3) |
No |
No |
|
User initials that deleted this Sales Order, blank if not deleted |