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