| Columns | 
| Name | 
Description | 
Datatype ¿? | 
Allow Null | 
| por_s | 
Portfolio  | 
CHAR(2) | 
no | 
| stamp_l | 
Record modification stamp  | 
NUMBER(10) | 
no | 
| 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  | 
DATE | 
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)  | 
VARCHAR2(31) | 
yes | 
| cyc_bil_s | 
Billing cycle (Y/N)  | 
VARCHAR2(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)  | 
VARCHAR2(80) | 
yes | 
| net_out_s | 
Net outstanding balance (Y/N)  | 
VARCHAR2(80) | 
yes | 
| grs_out_s | 
Gross outstanding balance (Y/N)  | 
VARCHAR2(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/' ')  | 
VARCHAR2(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  | 
VARCHAR2(36) | 
yes | 
| add_s | 
Portfolio address  | 
VARCHAR2(36) | 
yes | 
| cty_s | 
Portfolio city  | 
VARCHAR2(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  | 
VARCHAR2(80) | 
yes | 
| doc_lett_s | 
Default document letter  | 
CHAR(6) | 
yes | 
| batch_que_s | 
Batch queue name  | 
VARCHAR2(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  | 
NUMBER(10) | 
yes | 
| lse_str_l | 
Number of months to wait before deleting lease structures  | 
NUMBER(10) | 
yes | 
| cln_lse_l | 
Days before cleaning up lease/asset records  | 
NUMBER(10) | 
yes | 
| last_day_mth_l | 
Last day of the month  | 
NUMBER(10) | 
yes | 
| grc_l | 
Grace period in days  | 
NUMBER(10) | 
yes | 
| grc_invoice_l | 
Invoice deferral days for monthly accrual cycle  | 
NUMBER(10) | 
yes | 
| grc_accrual_l | 
Accrual deferral days for monthly accrual cycle  | 
NUMBER(10) | 
yes | 
| sus_l | 
Suspense limit in days  | 
NUMBER(10) | 
yes | 
| delq1_l | 
Delinquency category boundaries [1]  | 
NUMBER(10) | 
yes | 
| delq2_l | 
Delinquency category boundaries [2]  | 
NUMBER(10) | 
yes | 
| delq3_l | 
Delinquency category boundaries [3]  | 
NUMBER(10) | 
yes | 
| b_lsd_l | 
Maximum days before current date for lease date  | 
NUMBER(10) | 
yes | 
| a_lsd_l | 
Maximum days after current date for lease date  | 
NUMBER(10) | 
yes | 
| b_dis_l | 
Maximum days before current date for disbursement date  | 
NUMBER(10) | 
yes | 
| a_dis_l | 
Maximum days after current date for disbursement date  | 
NUMBER(10) | 
yes | 
| a_com_l | 
Maximum days after current date for commencement date  | 
NUMBER(10) | 
yes | 
| oc_l | 
Days after lease date to begin certificate ownership tracking  | 
NUMBER(10) | 
yes | 
| ucc_l | 
Days after lease date to begin UCC tracking  | 
NUMBER(10) | 
yes | 
| matls_l | 
Days before maturity to begin Matured Lease tracking  | 
NUMBER(10) | 
yes | 
| h_trm_l | 
Maximum lease term  | 
NUMBER(10) | 
yes | 
| l_trm_l | 
Minimum lease term  | 
NUMBER(10) | 
yes | 
| exp_l | 
Approval expiration days  | 
NUMBER(10) | 
yes | 
| cln_app_l | 
Months after booking to delete application  | 
NUMBER(10) | 
yes | 
| cln_dcln_l | 
Months after rejection/withdrawal to move
  application to ROA table  | 
NUMBER(10) | 
yes | 
| cln_dps_l | 
Months before deleting RPS records  | 
NUMBER(10) | 
yes | 
| cln_doa_l | 
Months before deleting ROA records  | 
NUMBER(10) | 
yes | 
| lse_ltr_l | 
Number of days to wait before writing lease letters  | 
NUMBER(10) | 
yes | 
| bad_debt_d | 
Bad debt percentage  | 
NUMBER(15,5) | 
yes | 
| comm_rate_d | 
Commission rate  | 
NUMBER(15,5) | 
yes | 
| port_tax_d | 
Tax rate  | 
NUMBER(15,5) | 
yes | 
| idc_pct_d | 
Initial direct cost percentage  | 
NUMBER(15,5) | 
yes | 
| h_disc_d | 
Maximum discount rate  | 
NUMBER(15,5) | 
yes | 
| l_disc_d | 
Minimum discount rate  | 
NUMBER(15,5) | 
yes | 
| p_max_por_d | 
Portfolio maximum interest rate  | 
NUMBER(15,5) | 
yes | 
| p_min_por_d | 
Mininum interest rate  | 
NUMBER(15,5) | 
yes | 
| p_cca_paddon_d | 
CCA prescribed rate add-on percentage  | 
NUMBER(15,5) | 
yes | 
| grc_d | 
Grace amount  | 
NUMBER(15,2) | 
yes | 
| tol_d | 
Tolerance amount  | 
NUMBER(15,2) | 
yes | 
| max_poff_d | 
Maximum shortage on short payoff  | 
NUMBER(15,2) | 
yes | 
| idc_amt_d | 
Initial direct cost amount  | 
NUMBER(15,2) | 
yes | 
| h_org_d | 
Maximum original acquisition cost  | 
NUMBER(15,2) | 
yes | 
| l_org_d | 
Mininum original acquisition cost  | 
NUMBER(15,2) | 
yes | 
| h_up_d | 
Maximum documentation fee  | 
NUMBER(15,2) | 
yes | 
| l_up_d | 
Minimum documentation fee  | 
NUMBER(15,2) | 
yes | 
| l_ext_calc_meth_c | 
Lease extension calculation method (A/C)  | 
CHAR(1) | 
yes | 
| ins_fee_d | 
Insurance fee rate  | 
NUMBER(15,5) | 
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  | 
NUMBER(10) | 
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  | 
NUMBER(10) | 
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 |