Table
a_method_of_payment
Description:
Media types of money received. Eg: Cash, Check Credit Card
PRIMARY KEY
a_method_of_payment_code_c
varchar (16)
NOT NULL
This is how the partner paid. EgCash, Cheque etc
a_method_of_payment_desc_c
varchar (64)
NOT NULL
This is a short description which is 32 charcters long
a_method_of_payment_type_c
varchar (16)
a_process_to_call_c
varchar (80)
The filename of the process to call
a_special_method_of_pmt_l
boolean
default: '0'
NOT NULL
a_active_l
boolean
default: '1'
Shows whether this code is active
s_date_created_d
date
default: CURRENT_DATE
The date the record was created.
s_created_by_c
varchar (20)
User ID of who created this record.
s_user
s_date_modified_d
date
The date the record was modified.
s_modified_by_c
varchar (20)
User ID of who last modified this record.
s_user
s_modification_id_t
timestamp
default: CURRENT_TIMESTAMP
This identifies the current version of the record.
FOREIGN KEY
a_method_of_payment_fkcr: s_created_by_c =>
s_user
a_method_of_payment_fkmd: s_modified_by_c =>
s_user
REFERENCED BY
a_ep_match
,
a_recurring_journal
,
a_recurring_transaction
,
a_recurring_gift
,
a_gift