| Columns |
| Name |
Description |
Datatype ¿? |
Allow Null |
| por_s |
Portfolio |
|
|
| unique_l |
Record number (value is always 1) |
|
|
|
Record modification stamp |
|
|
| grs_rec1_s |
Gross receivable balance (Y/N) |
|
|
| net_out1_s |
Net outstanding balance (Y/N) |
|
|
| grs_out1_s |
Gross outstanding balance (Y/N) |
|
|
| rev_def_c |
Reversed deferment fee to suspense (Y/N) |
|
|
| extdef_c |
Extension/deferment fee required (Y/N) |
|
|
| def_res_c |
Allow deferment residual update (Y/N) |
|
|
| dlr_rem_bank_s |
Dealer remittance bank code |
|
|
| auto_susp_l |
Automatic suspended days |
|
|
| auto_unsusp_l |
Automatic unsuspended days |
|
|
| susp_inc_c |
Recognize suspended income at payment (Y/N) |
|
|
| batch_app_stat_s |
Batch application status |
|
|
| max_mths_add_fin_l |
Maximum months that may be added via payment def/ext FIN |
|
|
| max_mths_add_opr_l |
Maximum months that may be added via payment def/ext OPR |
|
|
| rev_susp_l |
Reversal suspense limit in days |
|
|
| payoff_invo_rcr_l |
Recurring charge for payoff invoice |
|
|
| ins_fin_c |
Insurance finance (Y/N) |
|
|
| ins_pol_fee_d |
Insurance policy fee |
|
|
| idc_idr_in_irr_c |
Include IDC and IDR in calculating IRR (Y/N) |
|
|
| open_comm_in_irr_c |
Include open commission in calculating IRR (Y/N) |
|
|
| chg_acct_bkd_c |
Change book accounting and depreciation methods (Y/N) |
|
|
| prn_write_down_c |
Principal write down (Y/N) |
|
|
| auto_payo_csa_c |
Automatic payoff of CSA leases (Y/N) |
|
|
| susp_bkd_c |
Calculate book depreciation on suspended leases (Y/N) |
|
|
| eom_pre_acc_c |
EOM pre-accrual and invoicing (Y/N) |
|
|
| prorate_inc_idc_depr_c |
Prorate income, IDC/IDR and depreciation (Y/N) |
|
|
| take_incm_susp_prn_c |
Take income on PRN payoff for suspended simple interest
lease (Y/N) |
|
|
| take_incm_susp_opr_c |
Take income on OPR payoff for suspended operating
lease (Y/N) |
|
|
| take_incm_susp_inv_o_c |
Take income on INV termination for suspended operating
lease (Y/N) |
|
|
| use_quote_c |
Use third-party payoff quote (Y/N) |
|
|
| refund_bank_s |
Default refund bank |
|
|
| refund_defr_l |
Refund check date deferral |
|
|
| unit_pct_calc_c |
Asset percentage calculation method |
|
|
| ver_sum_pmt_c |
Verify sum of payments (Y/N) |
|
|
| olb_rent_base_c |
Off lease billing apply rent amount to base payoff (Y/N) |
|
|
| nsf_assmt_code_s |
NSF assessment code |
|
|
| post_unb_gnls_c |
Post unbilled income to gain/loss (Y/N) |
|
|
| unrec_opr_inc_payo_c |
Take unrecognized OPR income at payoff (Y/N) |
|
|
| note_follow_up_l |
Notebook follow-up days |
|
|
| doc_path_s |
Document directory |
|
|
| crd_rpt_path_s |
Credit report directory |
|
|
| fasb13_irr_c |
FASB 13 IRR for NPV calculation (A/B/C)
A - use p_con_d
B - use p_irr_d
C - use p_irr_nr_d |
|
|
| calc_pmt_hist_c |
Calculate payment history (Y/N) |
|
|
| cpu_assmt_code_s |
Cost per use assessment code |
|
|
| rcr_ali_s |
Recurring charge code for American Lease Insurance |
|
|
| cc_sec_bank_s |
Default bank code for security deposit disbursal |
|
|
| hold_sec_c |
Hold security deposit in payoff/termination (Y/N) |
|
|
| hold_sec_days_l |
Period in days to hold security deposit before disbursal |
|
|
| cash_control_used_c |
Cash Control used (Y/N) |
|
|
| lse_cpu_assmt_code_s |
Lease level cost per use assessment code |
|
|
| batch_app_disb_bank_comm_s |
Batch application disbursal bank account GL vector
for COMM type |
|
|
| rcr_idr6_s |
IDR6 offsetting account (OFFSET.IDR code) |
|
|
| rcr_idrb_s |
IDRB offsetting account (OFFSET.IDR code) |
|
|
| auto_calc_app_interim_rent_c |
Automatically calculate interim rent on applications (Y/N) |
|
|
| ibl_int_after_mat_c |
Accrue IBL interest after maturity (Y/N) |
|
|
| d_last_paynet_export_s |
Date of last Paynet export |
|
|
| client_asm_name1_s |
Client assessment name 1 |
|
|
| client_asm_name2_s |
Client assessment name 2 |
|
|
| client_asm_name3_s |
Client assessment name 3 |
|
|
| invo_unit_detl_c |
Invoice asset detail (N/P/T)
N - None
P - Prorate
T - Top Down |
|
|
| unused_fee_assmt_code_s |
Unused drawdown fee assessment code |
|
|
| allow_prepay_on_susp_c |
Allow prepayment on 'N***' suspended earnings leases (Y/N) |
|
|
| allow_prepay_on_mat_c |
Allow prepayment on matured leases (Y/N) |
|
|
| allow_res_ext_on_susp_c |
Allow '*RES' accrual extension on 'N***'
suspended earnings leases (Y/N) |
|
|
| auto_bpayo_ibl_bpmt_susp_c |
Automatic Batch Payoff for IBL Batch Payment Suspense (Y/N) |
|
|
| s_idrd_s |
IDRD alias - 21 characters |
|
|
| s_idre_s |
IDRE alias - 21 characters |
|
|
| s_idrf_s |
IDRF alias - 21 characters |
|
|
| s_idrg_s |
IDRG alias - 21 characters |
|
|
| s_idrh_s |
IDRH alias - 21 characters |
|
|
| ss_idrd_s |
IDRD alias - 9 characters |
|
|
| ss_idre_s |
IDRE alias - 9 characters |
|
|
| ss_idrf_s |
IDRF alias - 9 characters |
|
|
| ss_idrg_s |
IDRG alias - 9 characters |
|
|
| ss_idrh_s |
IDRH alias - 9 characters |
|
|
| s_idc6_s |
IDC6 alias - 21 characters |
|
|
| ss_idc6_s |
IDC6 alias - 9 characters |
|
|
| dlr_bonus_c |
Dealer bonus (Y/N) |
|
|
| dlr_reserve_c |
Allow dealer reserve (Y/N) |
|
|
| pool_init_c |
General ledger pools initialized (Y/N) |
|
|
| s_idc7_s |
IDC7 alias - 21 characters |
|
|
| ss_idc7_s |
IDC7 alias - 9 characters |
|
|
| cln_dck_l |
Months before deleting RCK records |
|
|
| vtx_o_c |
Use Vertex O (Y/N/NULL)
Y - Vertex O is used
N or NULL - Vertex O is not used |
|
|
| pmt_rsc_assmt_code_s |
Payment reschedule assessment code (ASM.TYP.L code) |
|
|
| pxt_assmt_code_s |
Payment extension assessment code (ASM.TYP.L code) |
|
|
| lxt_assmt_code_s |
Lease extension assessment code (ASM.TYP.L code) |
|
|
| due_assmt_code_s |
Payment due day change assessment code (ASM.TYP.L code) |
|
|
| adj_idc_ibl_c |
Adjust Unamortized IDC and IDR for IBL (Y/N) |
|
|
| deficiency_por_c |
Deficiency portfolio (Y/N) |
|
|
| days_mat_full_l |
Days before maturity for full term |
|
|
| delq_pmt_perc_paid_off_l |
Delinquency payment percentage for terminated/paid off leases |
|
|
| delq_past_due_c |
Use delinquency settings for amount past due (Y/N) |
|
|
| cmemo_pmt_hier_c |
Credit memo uses payment hierarchy (Y/N) |
|
|
| cmemo_apply_freq_c |
Frequency of applying credit memos to payments (D/M/O)
D - Daily
M - Monthly
O - Turn off credit memo processing |
|
|
| s_idc8_s |
IDC8 alias - 21 characters |
|
|
| s_idc9_s |
IDC9 alias - 21 characters |
|
|
| s_idca_s |
IDCA alias - 21 characters |
|
|
| s_idcb_s |
IDCB alias - 21 characters |
|
|
| s_idcc_s |
IDCC alias - 21 characters |
|
|
| s_idcd_s |
IDCD alias - 21 characters |
|
|
| s_idce_s |
IDCE alias - 21 characters |
|
|
| s_idcf_s |
IDCF alias - 21 characters |
|
|
| s_idcg_s |
IDCG alias - 21 characters |
|
|
| s_idch_s |
IDCH alias - 21 characters |
|
|
| ss_idc8_s |
IDC8 alias - 9 characters |
|
|
| ss_idc9_s |
IDC9 alias - 9 characters |
|
|
| ss_idca_s |
IDCA alias - 9 characters |
|
|
| ss_idcb_s |
IDCB alias - 9 characters |
|
|
| ss_idcc_s |
IDCC alias - 9 characters |
|
|
| ss_idcd_s |
IDCD alias - 9 characters |
|
|
| ss_idce_s |
IDCE alias - 9 characters |
|
|
| ss_idcf_s |
IDCF alias - 9 characters |
|
|
| ss_idcg_s |
IDCG alias - 9 characters |
|
|
| ss_idch_s |
IDCH alias - 9 characters |
|
|
| delq_method_paid_off_c |
Delinquency determination method after payoff (A/B/C)
A - principal and interest
B - principal, interest, and sales tax
C - principal, interest, and charges included by column
rpar.chrg_delq_paid_off_c |
|
|
| idc_asc842_accting_c |
IDC ASC 842 accounting method (I/A/B)
I - Income
A - Amortization
B - Alternative amortization |
|
|
| idc_book_accting_c |
IDC book accounting method (I/A/B)
I - Income
A - Amortization
B - Alternative amortization |
|
|
| idc_accting_s |
IDC1-9, IDCA-H accounting method (I/A/B)
I - Income
A - Amortization
B - Alternative amortization |
|
|
| idr_accting_s |
IDR1-9, IDRA-H accounting method (I/A/B)
I - Income
A - Amortization
B - Alternative amortization |
|
|
| grc_accrual_wk_l |
Accrual deferral days for weekly accrual cycle |
|
|
| grc_invoice_wk_l |
Invoice deferral days for weekly accrual cycle |
|
|
| auto_pay_days_before_l |
Number of days before due date to process auto-pay |
|
|
| auto_pay_wkend_holid_c |
Auto-pay before or after weekends and holidays (A/B)
A - After
B - Before |
|
|
| def_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
' ' - No default |
|
|
| currency_type_s |
Currency type (ACH.CURTYP code)
AUD - Australian dollars
CAD - Canadian dollars
USD - US dollars |
|
|
| grc_accrual_biw_l |
Accrual deferral days for bi-weekly accrual cycle |
|
|
| grc_invoice_biw_l |
Invoice deferral days for bi-weekly accrual cycle |
|
|
| grc_accrual_smo_l |
Accrual deferral days for semi-monthly accrual cycle |
|
|
| grc_invoice_smo_l |
Invoice deferral days for semi-monthly accrual cycle |
|
|
| prorate_depr_c |
Prorate depreciation (Y/N) |
|
|
| batch_app_disb_bank_idc1_s |
Batch application disbursal bank account GL vector
for IDC1 type |
|
|
| batch_app_disb_bank_idc2_s |
Batch application disbursal bank account GL vector
for IDC2 type |
|
|
| batch_app_disb_bank_newa_s |
Batch application disbursal bank account GL vector
for NEWA type |
|
|
| batch_app_disb_bank_newd_s |
Batch application disbursal bank account GL vector
for NEWD type |
|
|
| allow_perm_tax_rate_change_c |
Allow tax rate changes for PERM use tax code |
|
|
| copy_lp_chk_to_bank_chk_c |
Copy LeasePak check number to bank check number (Y/N) |
|
|