Columns |
Name |
Description |
Datatype ¿? |
Allow Null |
app_s |
Application |
|
|
unique_l |
Record number (value is always 1) |
|
|
|
Record modification stamp |
|
|
stg_eqty_d |
Staged equity amount |
|
|
lvr_c |
Leveraged (Y/N) |
|
|
d_lvr_com_s |
Leveraged commencement date |
|
|
d_lst_lvr_s |
Date of last leveraged table download |
|
|
lvr_trm_l |
Leveraged term |
|
|
stg_eqty_pay_to_s |
Staged equity fund payable to |
|
|
npyr_min_d |
Non-pyramiding late charge minimum payment due |
|
|
note_follow_up_l |
Notebook follow-up days |
|
|
d_fasb13_test_s |
FASB 13 test date |
|
|
fasb13_test_c |
FASB 13 test result (P/F/' ')
P - Pass
F - Fail
' ' - Untested |
|
|
orig_intfc_s |
Originating interface
MBT - Microbilt
MPR - mPower
STM - SuperTrump |
|
|
metro2_s |
Metro2 file format code |
|
|
invo_format_s |
Invoice format code |
|
|
non_comm_d |
Non commission amount |
|
|
opt_res_d |
Optional residual |
|
|
p_opt_res_d |
Optional residual percentage |
|
|
revolving_drawdown_c |
Revolving drawdown credit (Y/N) |
|
|
stax_exempt_s |
Sales/use tax exempt code |
|
|
oper_drawdown_d |
Operating lease application drawdown amount |
|
|
dlr_rec_pmts_d |
Dealer-received payments |
|
|
prn_write_down_c |
Principal write down (Y/N) |
|
|
float_bus_or_cal_c |
Set float rate on business or calendar day (P/F/C)
P - previous business day
F - following business day
C - calendar day |
|
|
float_frq_s |
Frequency of float rate setting
DAY - daily
MON - monthly
QTR - quarterly
SEMI - semiannually
ANNL - annually
NONE - rate setting functionality is disabled |
|
|
float_day_l |
Day of month on which float rate is set (1-31 or 0)
A value of zero indicates that the rate setting
functionality has been disabled. |
|
|
float_mon_l |
Month in which float rate is set (1-12 or 0)
0 - if frequency is NONE, MON or DAY
1 to 3 - if frequency is QTR
1 to 6 - if frequency is SEMI
1 to 12 - if frequency is ANNL |
|
|
p_float_base_d |
Float base rate percentage |
|
|
calendar_s |
Calendar to use for determining business days |
|
|
dlr_pmt_bank_code_s |
Dealer payment bank code |
|
|
d_cntr_end_s |
Contract end date |
|
|
dlr_pmt_applied_c |
Dealer payments applied (Y/N) |
|
|
rcr_pmt_sched_c |
Has recurring charge payment schedule (Y/N) |
|
|
rcr_synch_c |
Recurring charge payment schedule in synch with lease (Y/N) |
|
|
asset_lvl_c |
Has asset level payment schedule (Y/N) |
|
|
assmt_desc_c |
Has assessment description (Y/N) |
|
|
p_unused_fee_d |
Unused drawdown fee rate |
|
|
unused_fee_thresh_d |
Unused drawdown fee threshold |
|
|
d_unused_fee_start_s |
Start date of unused drawdown fee assessment |
|
|
d_unused_fee_next_s |
Next date of unused drawdown fee assessment |
|
|
unused_fee_frq_s |
Unused drawdown fee frequency (NONE/DAY/MON/QTR/SEMI/ANNL) |
|
|
pmt_hier_s |
Payment hierarchy |
|
|
pool_id_s |
Pool ID |
|
|
inst_id_s |
PAP institution/ACH transit ID |
|
|
payer_acct_s |
PAP account number |
|
|
payer_acct_nam_s |
PAP bank account name |
|
|
d_pap_eff_s |
PAP effective date |
|
|
vtx_o_c |
Use Vertex O (Y/N/NULL)
Y - Vertex O is used
N or NULL - Vertex O is not used |
|
|
int_free_mths_l |
Interest free months |
|
|
prepaid_c |
Prepaid lease (Y/N) |
|
|
auto_pay_interval_l |
Auto-pay interval frequency (0/1/2/4)
0 - defined in rjp (Automatic Payment Interval Schedule)
1 - once per billing cycle
2 - twice per billing cycle
4 - four times per billing cycle |
|
|
idc8_d |
Guaranteed reserves IDC8 |
|
|
idc9_d |
Guaranteed reserves IDC9 |
|
|
idca_d |
Guaranteed reserves IDCA |
|
|
idcb_d |
Guaranteed reserves IDCB |
|
|
idcc_d |
Guaranteed reserves IDCC |
|
|
idcd_d |
Guaranteed reserves IDCD |
|
|
idce_d |
Guaranteed reserves IDCE |
|
|
idcf_d |
Guaranteed reserves IDCF |
|
|
idcg_d |
Guaranteed reserves IDCG |
|
|
idch_d |
Guaranteed reserves IDCH |
|
|
idc_asc842_d |
Total IDC ASC 842 initial direct cost amount |
|
|
accrual_cycle_c |
Accrual/billing cycle (M/S/B/W)
M - Monthly (12 per year)
S - Semi-monthly (24 per year)
B - Bi-weekly (26 per year)
W - Weekly (52 per year) |
|
|
idc_book_accting_c |
IDC book accounting method (I/A/B)
I - Income
A - Amortization
B - Alternative amortization |
|
|
pmt_source_s |
Payment source |
|
|
auto_pay_c |
Auto-pay through a Payment Service (Y/N) |
|
|
d_auto_pay_start_s |
Auto-pay start date |
|
|
d_auto_pay_stop_s |
Auto-pay stop date |
|
|
auto_pay_amt_type_c |
Auto-pay amount type (A/B/C/D/T/P/O/' ')
A - Total outstanding on current invoice (apply lease)
B - Total outstanding on current invoice (apply invoice)
C - Payment and tax outstanding on current invoice (apply
lease)
D - Payment and tax outstanding on current invoice (apply
invoice)
T - Total outstanding on lease
P - Payment and tax outstanding on lease
O - Other specified amount
' ' - n/a |
|
|
auto_pay_other_amt_d |
Auto-pay other amount |
|
|