Columns |
Name |
Description |
Datatype ¿? |
Allow Null |
por_s |
Portfolio |
char(2) |
no |
unique_l |
Record number (value is always 1) |
integer |
no |
timestamp |
Record modification stamp |
timestamp |
yes |
app_stat_list_s |
List of application statuses |
char(148) |
yes |
app_ent_s |
Entry requirements |
char(148) |
yes |
disp1_s |
Display field (X/' ') |
char(200) |
yes |
disp2_s |
Display field (X/' ') |
char(200) |
yes |
disp3_s |
Display field (X/' ') |
char(200) |
yes |
fmv_trm1_l |
FMV term [1] |
integer |
yes |
fmv_trm2_l |
FMV term [2] |
integer |
yes |
fmv_trm3_l |
FMV term [3] |
integer |
yes |
fmv_trm4_l |
FMV term [4] |
integer |
yes |
fmv_trm5_l |
FMV term [5] |
integer |
yes |
h_cntr1_d |
Maximum lease rate - precomputed simple |
double precision |
yes |
h_cntr2_d |
Maximum lease rate - simple interest |
double precision |
yes |
h_cntr3_d |
Maximum lease rate - level yield |
double precision |
yes |
h_cntr4_d |
Maximum lease rate - rule of 12/78ths |
double precision |
yes |
h_cntr5_d |
Maximum lease rate - straight line |
double precision |
yes |
l_cntr1_d |
Minimum lease rate - precomputed simple |
double precision |
yes |
l_cntr2_d |
Minimum lease rate - simple interest |
double precision |
yes |
l_cntr3_d |
Minimum lease rate - level yield |
double precision |
yes |
l_cntr4_d |
Minimum lease rate - rule of 12/78ths |
double precision |
yes |
l_cntr5_d |
Minimum lease rate - straight line |
double precision |
yes |
h_dlr1_d |
Maximum vendor rate - precomputed simple |
double precision |
yes |
h_dlr2_d |
Maximum vendor rate - simple interest |
double precision |
yes |
h_dlr3_d |
Maximum vendor rate - level yield |
double precision |
yes |
h_dlr4_d |
Maximum vendor rate - rule of 12/78ths |
double precision |
yes |
h_dlr5_d |
Maximum vendor rate - straight line |
double precision |
yes |
l_dlr1_d |
Minimum vendor rate - precomputed simple |
double precision |
yes |
l_dlr2_d |
Minimum vendor rate - simple interest |
double precision |
yes |
l_dlr3_d |
Minimum vendor rate - level yield |
double precision |
yes |
l_dlr4_d |
Minimum vendor rate - rule of 12/78ths |
double precision |
yes |
l_dlr5_d |
Minimum vendor rate - straight line |
double precision |
yes |
h_inv1_d |
Maximum investor rate - precomputed simple |
double precision |
yes |
h_inv2_d |
Maximum investor rate - simple interest |
double precision |
yes |
h_inv3_d |
Maximum investor rate - level yield |
double precision |
yes |
h_inv4_d |
Maximum investor rate - rule of 12/78ths |
double precision |
yes |
h_inv5_d |
Maximum investor rate - straight line |
double precision |
yes |
l_inv1_d |
Minimum investor rate - precomputed simple |
double precision |
yes |
l_inv2_d |
Minimum investor rate - simple interest |
double precision |
yes |
l_inv3_d |
Minimum investor rate - level yield |
double precision |
yes |
l_inv4_d |
Minimum investor rate - rule of 12/78ths |
double precision |
yes |
l_inv5_d |
Minimum investor rate - straight line |
double precision |
yes |
fmv_per1_d |
FMV percentage [1] |
double precision |
yes |
fmv_per2_d |
FMV percentage [2] |
double precision |
yes |
fmv_per3_d |
FMV percentage [3] |
double precision |
yes |
fmv_per4_d |
FMV percentage [4] |
double precision |
yes |
fmv_per5_d |
FMV percentage [5] |
double precision |
yes |
dflt_displ_pmt_c |
Default display payment amount (Y/N) |
char(1) |
yes |
add_com_trn_c |
Add comment to transaction (Y/N) |
char(1) |
yes |
past_due_priority_c |
Priority settings affect application of payments to past-due
items in (A/B/N):
A - all payment processing
B - batch payment processing only
N - no payment processing |
char(1) |
yes |
waive_bank_s |
Principal/payment interest bank code |
char(3) |
yes |
s_idc1_s |
IDC1 alias - 21 characters |
char(21) |
yes |
s_idc2_s |
IDC2 alias - 21 characters |
char(21) |
yes |
s_idc3_s |
IDC3 alias - 21 characters |
char(21) |
yes |
s_idc4_s |
IDC4 alias - 21 characters |
char(21) |
yes |
s_idc5_s |
IDC5 alias - 21 characters |
char(21) |
yes |
s_idr1_s |
IDR1 alias - 21 characters |
char(21) |
yes |
s_idr2_s |
IDR2 alias - 21 characters |
char(21) |
yes |
s_idr3_s |
IDR3 alias - 21 characters |
char(21) |
yes |
s_idr4_s |
IDR4 alias - 21 characters |
char(21) |
yes |
s_idr5_s |
IDR5 alias - 21 characters |
char(21) |
yes |
s_idr6_s |
IDR6 alias - 21 characters |
char(21) |
yes |
s_idr7_s |
IDR7 alias - 21 characters |
char(21) |
yes |
s_idr8_s |
IDR8 alias - 21 characters |
char(21) |
yes |
s_idr9_s |
IDR9 alias - 21 characters |
char(21) |
yes |
s_idra_s |
IDRA alias - 21 characters |
char(21) |
yes |
s_idrb_s |
IDRB alias - 21 characters |
char(21) |
yes |
s_idrc_s |
IDRC alias - 21 characters |
char(21) |
yes |
ss_idc1_s |
IDC1 alias - 9 characters |
char(9) |
yes |
ss_idc2_s |
IDC2 alias - 9 characters |
char(9) |
yes |
ss_idc3_s |
IDC3 alias - 9 characters |
char(9) |
yes |
ss_idc4_s |
IDC4 alias - 9 characters |
char(9) |
yes |
ss_idc5_s |
IDC5 alias - 9 characters |
char(9) |
yes |
ss_idr1_s |
IDR1 alias - 9 characters |
char(9) |
yes |
ss_idr2_s |
IDR2 alias - 9 characters |
char(9) |
yes |
ss_idr3_s |
IDR3 alias - 9 characters |
char(9) |
yes |
ss_idr4_s |
IDR4 alias - 9 characters |
char(9) |
yes |
ss_idr5_s |
IDR5 alias - 9 characters |
char(9) |
yes |
ss_idr6_s |
IDR6 alias - 9 characters |
char(9) |
yes |
ss_idr7_s |
IDR7 alias - 9 characters |
char(9) |
yes |
ss_idr8_s |
IDR8 alias - 9 characters |
char(9) |
yes |
ss_idr9_s |
IDR9 alias - 9 characters |
char(9) |
yes |
ss_idra_s |
IDRA alias - 9 characters |
char(9) |
yes |
ss_idrb_s |
IDRB alias - 9 characters |
char(9) |
yes |
ss_idrc_s |
IDRC alias - 9 characters |
char(9) |
yes |
dwn_pmt_inf_c |
Down payment is informational only (Y/N) |
char(1) |
yes |
auto_payo_loss_tol_d |
Automatic payoff loss tolerance |
double precision |
yes |
auto_payo_gain_tol_d |
Automatic payoff gain tolerance |
double precision |
yes |
rev_cat1_s |
Reversal reason code/bank code [1] |
char(5) |
yes |
rev_cat2_s |
Reversal reason code/bank code [2] |
char(5) |
yes |
rev_cat3_s |
Reversal reason code/bank code [3] |
char(5) |
yes |
rev_cat4_s |
Reversal reason code/bank code [4] |
char(5) |
yes |
rev_cat5_s |
Reversal reason code/bank code [5] |
char(5) |
yes |
cc_auto_sus_bank_s |
Default bank code for auto suspense |
char(3) |
yes |
cc_auto_sus_cro_s |
Default C/R/O for auto suspense |
char(7) |
yes |
del_pmt_perc_l |
Delinquency payment percentage |
integer |
yes |
delq4_l |
Delinquency category boundaries [4] |
integer |
yes |
delq5_l |
Delinquency category boundaries [5] |
integer |
yes |
delq6_l |
Delinquency category boundaries [6] |
integer |
yes |
sec_bank_s |
Default securitization bank code |
char(3) |
yes |
delq_method_c |
Delinquency determination method before 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_c |
char(1) |
yes |
pmt_frst_extdef_l |
Number of payments for first extension/deferment eligibility |
integer |
yes |
pmt_btw_extdef_l |
Number of payments between for next extension/deferment |
integer |
yes |