| id |
integer |
Yes |
Yes |
nextval('payment_methods_id_seq'::regclass) |
Unique identifier |
| code |
character varying(10) |
Yes |
No |
|
User set payment code |
| description |
character varying(60) |
Yes |
No |
|
Payment description |
| payment_type |
character varying(1) |
Yes |
No |
|
Payment type; C = Cash D = Debit O = Other Q - Cheque R = Credit Card |
| account_no |
character varying(24) |
Yes |
No |
|
General Ledger Account number to post |
| display |
boolean |
Yes |
No |
|
Display payment method in payment dialog; FALSE = No TRUE = Yes |
| sequence |
smallint |
No |
No |
|
Sequence to display in payment dialog; 1 = at the top 99 = at the bottom |
| icon |
character varying(30) |
No |
No |
|
Icon selected to display in payment dialog |
| _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 |
| shortcut |
character varying(12) |
No |
No |
|
Keyboard shortcut for payment method |
| integrated |
boolean |
Yes |
No |
false |
Integration flag for payment gateway; FALSE = No TRUE = Yes |