| 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 |