| Description | Column | Datatype |
|---|---|---|
| Portfolio | por_s | char (2) |
| 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_flag_c | char (1) |
| RCK segment 3 (refer to dck_flag_c description) | dck_seg3_s | char (9) |
| RCK segment 4 (refer to dck_flag_c description) | dck_seg4_s | char (3) |
| Check number | chk_s | char (6) |
| Sybase timestamp | timestamp | timestamp |
| Client assigned check number | client_chk_s | char (8) |
| Disbursement date | d_dis_s | datetime |
| Type of cashier's check | cash_check_typ_s | char (4) |
| Status of check (' '/P/V)
' ' - Ready to print P - Printed V - Void |
s_status_c | char (1) |
| Payee name | nam_s | char (36) |
| Address | add_s | char (36) |
| Address 2 | add2_s | char (36) |
| City | cty_s | char (25) |
| State | st_s | char (2) |
| Zip code | zip_s | char (9) |
| Reference | ref_s | char (36) |
| Lease number or por/com/reg/off | lse_pcro_s | char (10) |
| Asset | unit_s | char (10) |
| Bank account G/L vector
' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased. |
bank_s | char (3) |
| Amount | amt_d | double precision |
| Date cashier's check was printed | d_printed_s | datetime |
| Time cashier's check was printed | t_printed_s | char (6) |
| Disbursement time | t_dis_s | char (6) |
| Run date | d_run_s | datetime |
| Run time | t_run_s | char (6) |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 | Piece 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 |