Name | Description |
---|---|
rhab | Historical Accounts Receivable Assessment |
Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 | Segment 6 | Segment 7 |
---|---|---|---|---|---|---|---|
rha_idx0 | por_s | com_s | reg_s | off_s | lse_s | d_pmtdu_s | ar_typ_c |
rha_idx1 | invo_s |
Columns | |||
---|---|---|---|
Name | Description | Datatype ¿? | Allow Null |
por_s | Portfolio |
||
com_s | Company |
||
reg_s | Region |
||
off_s | Office |
||
lse_s | Lease |
||
d_pmtdu_s | Payment due date |
||
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 |
||
Record modification stamp |
|||
invo_s | Invoice number |
||
d_last_s | Date of last update |
||
bank_s | Bank account GL vector ' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased |
||
ptax_desc_s | Property tax description code |
||
fhut_desc_s | Federal highway use tax (FHUT) description code |
||
grp_c | Group switch (Y/N) |
||
pay_c | A/R payoff switch (Y/N) |
||
prin_bill_c | Principal bill switch (B/N) |
||
int_bill_c | Interest bill switch (B/N) |
||
auto_ltch_assessed_c | Automatic late charges assessed (Y/N) |
||
car_d | Interest carryover |
||
tamt_p_d | Total amount paid |
||
pamt_b_d | Payment amount billed |
||
pamt_p_d | Payment amount paid |
||
iamt_b_d | Interest amount billed |
||
iamt_p_d | Interest amount paid |
||
int_d | Interest portion - memo account |
||
int_adj_d | Interest adjustment |
||
prin_stax_c | Principal sales tax (Y/N) |
||
int_stax_c | Interest sales tax (Y/N) |
||
org_iamt_b_d | Interest amount billed when invoice 1st created |
||
delq_category_l | Current delinquency category |
||
late_int_d | Interest paid after due date |
||
olb_payoff_c | Off lease billing payoff/termination flag (T/P/' ') T - Termination and off lease billing P or Q invoice P - Payoff and off lease billing P or Q invoice ' ' - not off lease billing P or Q invoice |
||
tamt_p_after_payoff_d | Total amount paid after payoff |
||
pamt_p_after_payoff_d | Payment amount paid after payoff |
||
iamt_p_after_payoff_d | Interest amount paid after payoff |
||
vtx_o_c | Use Vertex O (Y/N/' ') Y - Vertex O is used N or ' ' - Vertex O is not used |
||
paid_off_ck_c | Lease change-keyed after payoff (Y/' ') Y - Lease was change-keyed ' ' - Lease was not change-keyed |