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 | Description | Datatype ¿? | 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) |