| 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/' ')
  Y - Vertex O is used
  N or ' ' - 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)  | 
 | 
 |