Name | Description |
---|---|
rarb | Accounts Receivable Assessment |
Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 | Segment 6 | Segment 7 |
---|---|---|---|---|---|---|---|
rar_idx0 | por_s | com_s | reg_s | off_s | lse_s | d_pmtdu_s | ar_typ_c |
rar_idx1 | invo_s |
Columns | |||
---|---|---|---|
Name | Description | Datatype ¿? | Allow Null |
por_s | Portfolio |
CHAR(2) | no |
com_s | Company |
CHAR(2) | no |
reg_s | Region |
CHAR(2) | no |
off_s | Office |
CHAR(3) | no |
lse_s | Lease |
CHAR(10) | no |
d_pmtdu_s | Payment due date |
DATE | no |
ar_typ_c | A/R type flag (I/J/H/M/P/Q) I - Invoice J - Overlapped due dates H - Advance invoice M - Credit memo P - Off Lease Billing of asset payoff Q - Off Lease Billing of lease payoff |
CHAR(1) | no |
stamp_l | Record modification stamp |
NUMBER(10) | no |
invo_s | Invoice number |
CHAR(8) | no |
d_last_s | Date of last update |
DATE | yes |
bank_s | Bank account GL vector ' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased |
CHAR(3) | yes |
ptax_desc_s | Property tax description code |
CHAR(4) | yes |
fhut_desc_s | Federal highway use tax (FHUT) description code |
CHAR(4) | yes |
grp_c | Group switch (Y/N) |
CHAR(1) | yes |
prin_bill_c | Principal bill switch (B/N) |
CHAR(1) | yes |
int_bill_c | Interest bill switch (B/N) |
CHAR(1) | yes |
a_pmt_c | Assumed payment (Y/N) |
CHAR(1) | yes |
auto_ltch_assessed_c | Automatic late charges assessed (Y/N) |
CHAR(1) | yes |
car_d | Interest carryover |
NUMBER(15,2) | yes |
tamt_b_d | Total amount billed |
NUMBER(15,2) | yes |
tamt_p_d | Total amount paid |
NUMBER(15,2) | yes |
pamt_b_d | Payment amount billed |
NUMBER(15,2) | yes |
pamt_p_d | Payment amount paid |
NUMBER(15,2) | yes |
iamt_b_d | Interest amount billed |
NUMBER(15,2) | yes |
iamt_p_d | Interest amount paid |
NUMBER(15,2) | yes |
int_d | Interest portion - memo account |
NUMBER(15,2) | yes |
int_adj_d | Interest adjustment |
NUMBER(15,2) | yes |
income_accrued_c | Income accrued (Y/N) |
CHAR(1) | yes |
prin_stax_c | Principal sales tax (Y/N) |
CHAR(1) | yes |
int_stax_c | Interest sales tax (Y/N) |
CHAR(1) | yes |
org_iamt_b_d | Interest amount billed when invoice 1st created |
NUMBER(15,2) | yes |
delq_category_l | Current delinquency category |
NUMBER(10) | yes |
late_int_d | Interest paid after due date |
NUMBER(15,2) | yes |
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 |
CHAR(1) | yes |
d_prin_bill_s | Date principal billed |
DATE | yes |
d_int_bill_s | Date interest billed |
DATE | yes |
tamt_p_after_payoff_d | Total amount paid after payoff |
NUMBER(15,2) | yes |
pamt_p_after_payoff_d | Payment amount paid after payoff |
NUMBER(15,2) | yes |
iamt_p_after_payoff_d | Interest amount paid after payoff |
NUMBER(15,2) | yes |
vtx_o_c | Use Vertex O (Y/N/NULL) Y - Vertex O is used N or NULL - Vertex O is not used |
CHAR(1) | yes |
paid_off_ck_c | Lease change-keyed after payoff (Y/' ') Y - Lease was change-keyed ' ' - Lease was not change-keyed |
CHAR(1) | yes |