Columns |
Name |
Description |
Datatype ¿? |
Allow Null |
por_s |
Portfolio |
|
|
|
Record modification stamp |
|
|
def_app_s |
Default application |
|
|
md_fis_s |
Fiscal year end (MMDD) |
|
|
md_tax_s |
Tax reporting deadline for year end (MMDD) |
|
|
md_itc_cut_s |
ITC cutoff date (MMDD) |
|
|
md_prev_fis_s |
Previous fiscal year end (MMDD) |
|
|
d_eff_fis_s |
Effective fiscal year end |
|
|
port_typ_s |
Portfolio interest type |
|
|
inv_hdg_s |
Invoice heading code |
|
|
invo_format_s |
Invoice format code |
|
|
remit_asg_s |
Remittance address code |
|
|
idc_amt_s |
Initial direct cost amount code |
|
|
idc_method_s |
Initial direct cost method |
|
|
col_team_s |
Collection team |
|
|
kol_team_s |
Collateral team |
|
|
ml_team_s |
Maturing lease team |
|
|
col_supr_s |
Collection supervisor |
|
|
kol_supr_s |
Collateral supervisor |
|
|
ml_supr_s |
Maturing lease supervisor |
|
|
clone_to_status_s |
Clone to application status |
|
|
master_appl_status_s |
Master application status |
|
|
ind_inv_laser_s |
Individual invoice laser form code |
|
|
grp_inv_laser_s |
Group invoice laser form code |
|
|
comm_stat_s |
Commission access status code
Used by Bell Atlantic - do not delete. |
|
|
credit_apprv_stat_s |
Credit approval status code |
|
|
prim_num_s |
Prime rate bank number |
|
|
itc_accrue_c |
Book ITC accrue (Y/N) |
|
|
pro_rate_c |
Interim rent (Y/N) |
|
|
idc_c |
Exclude initial direct cost from yield (Y/N) |
|
|
bad_debt_c |
Bad debt included in initial direct cost (Y/N) |
|
|
sh_pyof_c |
Short payoffs accepted (Y/N) |
|
|
ck_lse_d_c |
Lease date after other dates (Y/N) |
|
|
dlnq_back_c |
Backdated new leases appear on delinquency report (Y/N) |
|
|
delq_inv_c |
Warning message for payment for non-delinquent invoice (Y/N) |
|
|
auto_opt_c |
Track automobile options (Y/N) |
|
|
cyc_acc_s |
Cycle accruals (Y/N) |
|
|
cyc_bil_s |
Billing cycle (Y/N) |
|
|
ofc_c |
Activate approval officer security (Y/N) |
|
|
latch_60_c |
Assess late charges to leases less than 60 days old (Y/N) |
|
|
calc_idc_c |
Calculate IDC w/o broker fees or bad debt (Y/N) |
|
|
stub_int_c |
Use stub interest (Y/N) |
|
|
insf1_c |
Special insurance follow up (Y/N) |
|
|
dlnq1_c |
Special delinquency (Y/N) |
|
|
cl_rec_c |
Client receives advance money (R/I/A) |
|
|
udf_app_c |
User defined lease application fields used (Y/N) |
|
|
udf_lse_c |
User defined lease fields used (Y/N) |
|
|
udf_ass_c |
User defined asset fields used (Y/N) |
|
|
udf_cus_c |
User defined customer fields used (Y/N) |
|
|
udf_les_c |
User defined lessee fields used (Y/N) |
|
|
udf_dlr_c |
User defined vendor fields used (Y/N) |
|
|
udt_app_c |
User defined lease application table used (Y/N) |
|
|
udt_lse_c |
User defined lease table used (Y/N) |
|
|
udt_ass_c |
User defined asset table used (Y/N) |
|
|
udt_cus_c |
User defined customer Table used (Y/N) |
|
|
udt_les_c |
User defined lessee table used (Y/N) |
|
|
udt_dlr_c |
User defined vendor table used (Y/N) |
|
|
eop_s_subtl_c |
EOP subtotals (Y/N) |
|
|
eop_s_grnd_c |
EOP grand totals (Y/N) |
|
|
eop_s_por_grnd_c |
EOP portfolio on grand total (Y/N) |
|
|
eop_s_com_grnd_c |
EOP company on grand total (Y/N) |
|
|
eop_s_reg_grnd_c |
EOP region on grand total (Y/N) |
|
|
eop_s_off_grnd_c |
EOP office on grand total (Y/N) |
|
|
eop_s_cus_grnd_c |
EOP customer on grand total (Y/N) |
|
|
eop_s_les_grnd_c |
EOP lessee on grand total (Y/N) |
|
|
eop_s_por_sub_c |
EOP portfolio on subtotal (Y/N) |
|
|
eop_s_com_sub_c |
EOP company on subtotal (Y/N) |
|
|
eop_s_reg_sub_c |
EOP region on subtotal (Y/N) |
|
|
eop_s_off_sub_c |
EOP office on subtotal (Y/N) |
|
|
eop_s_cus_sub_c |
EOP customer on subtotal (Y/N) |
|
|
eop_s_les_sub_c |
EOP lessee on subtotal (Y/N) |
|
|
s_por_gbrk_c |
Portfolio page on grand total (Y/N) |
|
|
s_com_gbrk_c |
Company page on grand total (Y/N) |
|
|
s_reg_gbrk_c |
Region page on grand total (Y/N) |
|
|
s_cus_gbrk_c |
Customer page on grand total (Y/N) |
|
|
s_indent_c |
Grand total indentation (Y/N) |
|
|
s_heading_c |
Print heading above keys (Y/N) |
|
|
s_titles_c |
Print row titles or names (T/N) |
|
|
tx_xfer_c |
Transfer payment transaction to historical file (Y/N) |
|
|
lst_pmt_inv_c |
Print payment amount on invoice (Y/N) |
|
|
cus_inv_c |
Sort invoices by customer (Y/N) |
|
|
nveh_info_c |
Track auxiliary non-vehicle information (Y/N) |
|
|
veh_info_c |
Track auxiliary vehicle information (Y/N) |
|
|
res_inc_c |
Residual income separated (Y/N) |
|
|
calc_ast_yld_c |
Calculate asset yield (Y/N) |
|
|
reset_c |
Reset time outstanding when application status changes (Y/N) |
|
|
lse_fac_c |
Lease factor - Payment/Rental (P/R) |
|
|
tar_prn_c |
IBL target principal levels used (Y/N) |
|
|
grs_rec_s |
Gross receivable balance (Y/N) |
|
|
net_out_s |
Net outstanding balance (Y/N) |
|
|
grs_out_s |
Gross outstanding balance (Y/N) |
|
|
port_wtch_c |
Portfolio status report watch or grace (W/G) |
|
|
col_wtch_c |
Collection module watch or grace (W/G) |
|
|
del_i_wtch_c |
Delinquency report interactive watch code or grace (W/G) |
|
|
del_e_wtch_c |
Delinquency report EOP watch code or grace period (W/G) |
|
|
lse_dsct_c |
Lease discounting used (Y/N) |
|
|
upd_lck_c |
Updates locked (Y/N) |
|
|
d_inc_c |
Vendor participating in income (Y/N) |
|
|
ses_c |
Session update used (Y/N) |
|
|
ses_disb_c |
Assign cash disbursements through session (Y/N) |
|
|
idc_int_adj_c |
IDC interest adjustment switch (Y/N) |
|
|
ver_s |
Verify field (X/' ') |
|
|
eop_s_grp_grnd_c |
EOP group on grand total (Y/N) |
|
|
eop_s_grp_sub_c |
EOP group on subtotal (Y/N) |
|
|
ptax_desc_use_c |
Use property tax description code (Y/N) |
|
|
fhut_desc_use_c |
Use FHUT description code (Y/N) |
|
|
clone_appl_his_c |
Clone application status history (Y/N) |
|
|
drawdown_tracking_c |
Drawdown history tracking (Y/N) |
|
|
appl_first_last_c |
First or last occurrence (F/L/' ')
For cloning application status history through
first or last occurrence of rpa::clone_to_status_s.
This field will be initialized to blank if the
history/client cloning module is not purchased |
|
|
cca_c |
CCA module used (Y/N) |
|
|
cl_s |
Portfolio name |
|
|
add_s |
Portfolio address |
|
|
cty_s |
Portfolio city |
|
|
st_s |
Portfolio state |
|
|
zip_s |
Portfolio zip code |
|
|
phn_s |
Phone number |
|
|
cl_div_s |
Division name |
|
|
doc_lett_s |
Default document letter |
|
|
batch_que_s |
Batch queue name |
|
|
cca_def_ent_s |
CCA default tax entity |
|
|
invst_req_c |
Investor input required for lease discounting (Y/N) |
|
|
dsb_upfrnt_tax_c |
Disburse Upfront sales tax through [U0449] (Y/N) |
|
|
incl_sec_dep_yld_c |
Include security deposit in yield (Y/N) |
|
|
ach_prenote_used_c |
ACH prenotes used (Y/N) |
|
|
prenote_ccd_c |
Corporate standard entry class code is to be prenoted (Y/N) |
|
|
incl_idc_npv_sb_c |
Include IDC in NPV and SB payoffs (Y/N) |
|
|
take_incm_susp_inv_c |
Take income on INV payoff for suspended lease (Y/N) |
|
|
net_cost_calc_meth_c |
Net cost calculation method (A/C) |
|
|
app_str_l |
Number of months to wait before deleting booked
application structures |
|
|
lse_str_l |
Number of months to wait before deleting lease structures |
|
|
cln_lse_l |
Days before cleaning up lease/asset records |
|
|
last_day_mth_l |
Last day of the month |
|
|
grc_l |
Grace period in days |
|
|
grc_invoice_l |
Invoice deferral days for monthly accrual cycle |
|
|
grc_accrual_l |
Accrual deferral days for monthly accrual cycle |
|
|
sus_l |
Suspense limit in days |
|
|
delq1_l |
Delinquency category boundaries [1] |
|
|
delq2_l |
Delinquency category boundaries [2] |
|
|
delq3_l |
Delinquency category boundaries [3] |
|
|
b_lsd_l |
Maximum days before current date for lease date |
|
|
a_lsd_l |
Maximum days after current date for lease date |
|
|
b_dis_l |
Maximum days before current date for disbursement date |
|
|
a_dis_l |
Maximum days after current date for disbursement date |
|
|
a_com_l |
Maximum days after current date for commencement date |
|
|
oc_l |
Days after lease date to begin certificate ownership tracking |
|
|
ucc_l |
Days after lease date to begin UCC tracking |
|
|
matls_l |
Days before maturity to begin Matured Lease tracking |
|
|
h_trm_l |
Maximum lease term |
|
|
l_trm_l |
Minimum lease term |
|
|
exp_l |
Approval expiration days |
|
|
cln_app_l |
Months after booking to delete application |
|
|
cln_dcln_l |
Months after rejection/withdrawal to move
application to ROA table |
|
|
cln_dps_l |
Months before deleting RPS records |
|
|
cln_doa_l |
Months before deleting ROA records |
|
|
lse_ltr_l |
Number of days to wait before writing lease letters |
|
|
bad_debt_d |
Bad debt percentage |
|
|
comm_rate_d |
Commission rate |
|
|
port_tax_d |
Tax rate |
|
|
idc_pct_d |
Initial direct cost percentage |
|
|
h_disc_d |
Maximum discount rate |
|
|
l_disc_d |
Minimum discount rate |
|
|
p_max_por_d |
Portfolio maximum interest rate |
|
|
p_min_por_d |
Mininum interest rate |
|
|
p_cca_paddon_d |
CCA prescribed rate add-on percentage |
|
|
grc_d |
Grace amount |
|
|
tol_d |
Tolerance amount |
|
|
max_poff_d |
Maximum shortage on short payoff |
|
|
idc_amt_d |
Initial direct cost amount |
|
|
h_org_d |
Maximum original acquisition cost |
|
|
l_org_d |
Mininum original acquisition cost |
|
|
h_up_d |
Maximum documentation fee |
|
|
l_up_d |
Minimum documentation fee |
|
|
l_ext_calc_meth_c |
Lease extension calculation method (A/C) |
|
|
ins_fee_d |
Insurance fee rate |
|
|
check_cred_bal_c |
Check credit balance on asset add-on (Y/N) |
|
|
calc_dd_30_360_c |
Calculate days delinquent 30/360 (Y/N) |
|
|
allow_taxable_asset_on_ibl_c |
Allow taxable asset on IBL (Y/N) |
|
|
pay_tax_with_item_c |
Pay tax along with item (Y/N) |
|
|
upf_vat_c |
Upfront value added tax (IVA) (Y/N) |
|
|
ern_mth_c |
Lease date affects yield (Y/N) |
|
|
ignore_assmt_for_prepay_c |
Ignore assessments for prepayments (Y/N) |
|
|
cred_rpt_note_type_s |
Note type used in credit approval report |
|
|
rev_bank_s |
Reversal bank code |
|
|
appl_pay_to_note_c |
Apply payment to note attached to lease (Y/N) |
|
|
cln_trx_l |
Number of months before cleaning up GL transactions |
|
|
def_sec_por_s |
Default securitization portfolio |
|
|
def_sec_com_s |
Default securitization company |
|
|
def_sec_reg_s |
Default securitization region |
|
|
def_sec_off_s |
Default securitization office |
|
|
ins_exp_l |
Number of days before tracking insurance |
|
|
ins_team_s |
Insurance team |
|
|
ins_supr_s |
Insurance supervisor |
|
|
aggregator_s |
Portfolio aggregator
Groups or distinguishes portfolios across environments |
|
|