rac Table: Preauthorized Payments Control
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rac Table: Preauthorized Payments Control

Indexes

Name Segment 1
rac_idx0 por_s


Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
Record modification stamp
d_scratch_s
Last physical scratch file create date
d_bank_s
Last physical bank file create date
d_last_s
Last physical PAP-ACH run end date
d_last_vach_s
Last physical vendor ACH run end date
map_type_s
Bank file map type
  "ACH   " - Automated Clearing House electronic only
  "BM1   " - Bank of Montreal 1 electronic
  "BM2   " - Bank of Montreal 2 tape
  "RB1   " - Royal Bank 1 electronic
  "RB2   " - Royal Bank 2 tape
  "TD1   " - Toronto Dominion 1 electronic
  "TD2   " - Toronto Dominion 2 tape
  "WDE   " - Australia Westpac Direct Entry
char_code_s
Bank file character code
  "ASCII " - American Standard Code for Information
             Interchange
  "EBCDIC" - Extended Binary Coded Decimal Interchange Code
tran_type_s
Payment transaction type code. (In Canada) service class
  code. (In USA) Possible values:
  In Cananda  400 - Lease payments
  In USA      CCD - Corporate Lessees
              PPD - Private Lessees
cur_type_s
Currency type code
  CAD - Canadian dollars
  USD - US dollars
invert_inst_id_c
Invert lessee PAP institute ID when written to bank file.
  " " - Do not invert, write exactly as is.
  I - Invert. Normally, the lessee institute ID is
      entered in [U0203] in the following format:
      "0" / 3-char branch # / 5-char transit #.
       However, some users enter it differently:
       "0" / 5-char transit # / 3-char branch #.
       If this is the case, one may want to invert
       the branch and transit numbers when the
       institute ID is written to the bank file by
       setting this switch to "I", in which case it
       will be written as:
       "0" / 3-char branch # / 5-char transit #.
pap_current_only_c
PAP-ACH current payment only
use_lease_for_cust_no_c
Use lease number instead of lessee number for
  customer number in Royal Bank format.
load_effective_date_c
PAP-ACH load primary due date into effective date
  field in ACH format only
o_inst_id_s
Originator PAP institution id for returns
  (Canadian formats only)
o_acct_num_s
Originator account number for returns
  (Canadian formats only)
o_cust_no_s
Originator customer number for returns
  (Canadian formats only)
o_cust_s_nam_s
Originator customer short name
o_id_num_s
Originator identification number
data_ctr_s
Data center number (Canadian formats only)
password_s
Password
dest_id_num_s
Destination identification number / transmit
  routing number (US formats only)
company_id_s
Company identification number (US formats only)
file_no_l
Next logical bank file control number
grace_days_l
PAP-ACH grace days
fin_inst_s
Financial institution
bank_file_after_due_c
Generate bank file after due date (Y/N)
pap_to_lse_c
Copy PAP (Preauthorized payment) information to lease when
  booking (Y/N)