| id |
integer |
Yes |
Yes |
nextval('sales_history_payments_id_seq'::regclass) |
Unique identifier |
| invoice_no |
character varying(10) |
No |
No |
|
Invoice number that payment was for - link to sales_history.invoice_no |
| 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 |
| amount |
numeric(15,2) |
Yes |
No |
|
Payment amount |
| 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 |
| auth_code |
character varying(20) |
No |
No |
|
Credit card authorization recorded at payment time |
| _dbversion |
integer |
No |
No |
|
UTC Date and time record was created |
| _created |
timestamp without time zone |
No |
No |
|
User initials that created this record |
| _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 |
| sequence |
smallint |
No |
No |
|
Sequential number for payments, used when more than one payment exists on an Invoice |
| payment_date |
date |
No |
No |
|
Date payment was made |
| 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 |