| Description | Column | Datatype |
|---|---|---|
| Batch date | d_batch_s | datetime |
| Batch number | batch_num_s | char (6) |
| Batch sequence number | batch_seq_num_s | char (8) |
| Sybase timestamp | timestamp | timestamp |
| Lease | lse_s | char (10) |
| Lessee number | les_s | char (9) |
| Posting date | d_post_s | datetime |
| Effective date of payment | d_eff_s | datetime |
| Bank account G/L vector
' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased. |
bank_s | char (3) |
| Operator initials | opr_s | char (3) |
| Check number | chk_num_s | char (10) |
| Amount | amt_d | double precision |
| Batch payment reversed (Y/N) | batch_rev_c | char (1) |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 |
|---|---|---|---|---|
| rpm_idx0 | d_batch_s | batch_num_s | batch_seq_num_s | |
| rpm_idx1 | lse_s | d_batch_s | batch_num_s | batch_seq_num_s |
| rpm_idx2 | les_s | d_batch_s | batch_num_s | batch_seq_num_s |