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

Database Reference Oracle DBMS

rac Table: Preauthorized Payments Control

Indexes

Name Segment 1
rac_idx0 por_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
CHAR(2) no
stamp_l
Record modification stamp
NUMBER(10) no
d_scratch_s
Last physical scratch file create date
DATE yes
d_bank_s
Last physical bank file create date
DATE yes
d_last_s
Last physical PAP-ACH run end date
DATE yes
d_last_vach_s
Last physical vendor ACH run end date
DATE yes
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(6) yes
char_code_s
Bank file character code
  "ASCII " - American Standard Code for Information
             Interchange
  "EBCDIC" - Extended Binary Coded Decimal Interchange Code
CHAR(6) yes
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
CHAR(3) yes
cur_type_s
Currency type code
  CAD - Canadian dollars
  USD - US dollars
CHAR(3) yes
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 #.
CHAR(1) yes
pap_current_only_c
PAP-ACH current payment only
CHAR(1) yes
use_lease_for_cust_no_c
Use lease number instead of lessee number for
  customer number in Royal Bank format.
CHAR(1) yes
load_effective_date_c
PAP-ACH load primary due date into effective date
  field in ACH format only
CHAR(1) yes
o_inst_id_s
Originator PAP institution id for returns
  (Canadian formats only)
CHAR(9) yes
o_acct_num_s
Originator account number for returns
  (Canadian formats only)
CHAR(12) yes
o_cust_no_s
Originator customer number for returns
  (Canadian formats only)
CHAR(5) yes
o_cust_s_nam_s
Originator customer short name
CHAR(15) yes
o_id_num_s
Originator identification number
CHAR(10) yes
data_ctr_s
Data center number (Canadian formats only)
CHAR(5) yes
password_s
Password
CHAR(17) yes
dest_id_num_s
Destination identification number / transmit
  routing number (US formats only)
CHAR(10) yes
company_id_s
Company identification number (US formats only)
CHAR(10) yes
file_no_l
Next logical bank file control number
NUMBER(10) yes
grace_days_l
PAP-ACH grace days
NUMBER(10) yes
fin_inst_s
Financial institution
CHAR(4) yes
bank_file_after_due_c
Generate bank file after due date (Y/N)
CHAR(1) yes
pap_to_lse_c
Copy PAP (Preauthorized payment) information to lease when
  booking (Y/N)
CHAR(1) yes