Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 | Segment 6 | Segment 7 | Segment 8 |
---|---|---|---|---|---|---|---|---|
rtx_idx0 | por_s | com_s | reg_s | off_s | lse_s | d_run_s | t_run_s | trn_count_s |
Columns | |||
---|---|---|---|
Name | Description | Datatype ¿? | Allow Null |
por_s | Portfolio |
||
com_s | Company |
||
reg_s | Region |
||
off_s | Office |
||
lse_s | Lease |
||
d_run_s | Run date |
||
t_run_s | Run time |
||
trn_count_s | Transaction counter |
||
Record modification stamp |
|||
d_eff_s | Effective date |
||
d_indu_s | Invoice due date |
||
trn_s | Transaction code |
||
ptrn_s | Payoff transaction code |
||
skip_c | Skip transfer to historical (Y/N) |
||
ar_typ_c | A/R type flag (I/J/M/P/Q) I - Invoice J - Overlapped due dates M - Credit memo P - Off Lease Billing of asset payoff Q - Off Lease Billing of lease payoff |
||
late_c | Late charges calculated (Y/N) |
||
opr_s | Operator initials |
||
invo_s | Invoice number |
||
unit_s | Asset |
||
num_s | Suspense number |
||
chk_num_s | Check number |
||
crdt_l | Account credit vector |
||
dbt_l | Account debit vector |
||
chg_d | Amount of money change |
||
trn_rsn_s | Transaction reason code (TRN.RSN code) |
||
comments_s | Comments |
||
waive_c | Waived Principal/payment interest record (Y/N) |