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