rck Table: Cashier Check
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rck Table: Cashier Check

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rck_idx0 por_s dck_flag_c dck_seg3_s dck_seg4_s chk_s
rck_idx1 chk_s        
rck_idx2 dck_flag_c dck_seg3_s chk_s    
rck_idx3 client_chk_s chk_s      
rck_idx4 lse_pcro_s chk_s      


Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
dck_flag_c
Cashier's check flag
  '0'/ lease(10)/ blank(2)/ chk num(6)
     or
  flag(1)/ client(9)/ grp(3)/ chk num(6)
  (Flag: client relationship
    1 - Customer
    2 - Vendor                Note: grp = blank(3)
    3 - Broker or Investor    Note: grp = blank(3)
    4 - Investor Settlement   Note: grp = blank(3)
   Key #0 overlay (alternate key #2):
   flag(1)/ client(9)
   (Flag: client relationship
     1 - Customer
     2 - Vendor
     3 - Broker or Investor)
dck_seg3_s
RCK segment 3 (refer to dck_flag_c description)
dck_seg4_s
RCK segment 4 (refer to dck_flag_c description)
chk_s
Check number
Record modification stamp
client_chk_s
Client assigned check number
d_dis_s
Disbursement date
cash_check_typ_s
Type of cashier's check
s_status_c
Status of check (' '/P/V)
  ' ' - Ready to print
  P  - Printed
  V  - Void
nam_s
Payee name
add_s
Address
add2_s
Address 2
cty_s
City
st_s
State code (RST.ST_S code)
zip_s
Zip code
ref_s
Reference
lse_pcro_s
Lease number or por/com/reg/off
unit_s
Asset
bank_s
Bank account GL vector
  '  1' - If multiple banks module is purchased
  '   ' - multiple banks module is not purchased
amt_d
Amount
d_printed_s
Date cashier's check was printed
t_printed_s
Time cashier's check was printed
t_dis_s
Disbursement time
d_run_s
Run date
t_run_s
Run time
trn_rsn_s
Transaction reason code (TRN.RSN code)