_1548.patients_payments_ledger_map

Field Type Null Default Key Extra Comment
pplm_id int(11) NO PRI auto_increment
pplm_patpm_id int(11) YES MUL Saved payment method id
pplm_cus_id int(11) NO MUL
pplm_cli_id int(11) NO MUL
pplm_pat_id int(11) NO MUL
pplm_led_id int(11) NO MUL
pplm_ext_id varchar(55) NO MUL
pplm_ext_transfirst_id varchar(55) NO
pplm_psv_id int(11) NO Payment Service Vendor ID
pplm_pdt_id int(11) YES 0 Payment Device Type identifier. Types are maintained in codebase.
pplm_pps_id int(11) YES ID of payment schedule payment was made from
pplm_cardholder_name varchar(50) YES
pplm_authcode varchar(15) YES
pplm_date varchar(8) NO MUL
pplm_notes text NO
pplm_modified datetime YES CURRENT_TIMESTAMP
pplm_created datetime YES CURRENT_TIMESTAMP

References

Local Column References