rso Table: Electronic Payment Source
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rso Table: Electronic Payment Source

Indexes

Name Segment 1 Segment 2
rso_idx0 client_id_s pmt_source_s

  
Columns
Name DescriptionDatatype ¿? Allow Null
client_id_s
Client
char(9) no
pmt_source_s
Payment source
char(2) no
timestamp
Record modification stamp
timestamp yes
source_type_c
Payment source type (B/C/D)
  B - Bank account
  C - Credit card
  D - Debit card
char(1) yes
source_desc_s
Payment source description
char(36) yes
name_on_source_s
Name on payment source account
char(50) yes
last_four_digits_s
Last four digits of account number
char(4) yes
ym_card_expiration_s
Credit card expiration year and month (YYYYMM)
char(6) yes
bank_routing_s
Bank routing number (bank accounts only)
char(9) yes
pmt_service_acct_s
Payment Service account code
char(4) yes
vault_token_s
Token used for payments instead of actual credit card number
  or bank account number
char(36) yes