id |
integer |
Yes |
Yes |
nextval('sales_order_payments_id_seq'::regclass) |
|
order_no |
character varying(10) |
No |
No |
|
Order number |
sequence |
smallint |
No |
No |
|
Sequence starting from 1 to number of payments |
payment_method |
smallint |
No |
No |
|
Payment method from 1 - 8 |
currency |
character varying(3) |
Yes |
No |
''::character varying |
Currency of payment |
division |
character varying(3) |
Yes |
No |
''::character varying |
Division of payment |
gl_account |
character varying(24) |
Yes |
No |
''::character varying |
GL account for payment |
amount |
numeric(15,2) |
Yes |
No |
|
Amount of payment |
auth_code |
character varying(20) |
No |
No |
|
Credit card authorization |
ccard_postal_code |
character varying(16) |
No |
No |
|
Credit card postal code |
cust_no |
character varying(20) |
No |
No |
|
Customer number |
payment_date |
date |
No |
No |
|
Payment date |
layaway_flag |
boolean |
No |
No |
|
Is this a deposit on sale order TRUE = Yes FALSE = No |
trans_no |
character varying(10) |
No |
No |
|
GL transaction number for payment |
_dbversion |
integer |
No |
No |
|
|
_created |
timestamp without time zone |
No |
No |
|
|
_created_by |
character varying(3) |
No |
No |
|
|
_modified |
timestamp without time zone |
No |
No |
|
|
_modified_by |
character varying(3) |
No |
No |
|
|