| 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) |
||