Columns |
Name |
Description |
Datatype ¿? |
Allow Null |
les_s |
Lessee number |
char(9) |
no |
timestamp |
Record modification stamp |
timestamp |
yes |
cus_s |
Customer number |
char(9) |
no |
ym_bus_est_s |
Year and month when business was established (YYYYMM) |
char(6) |
yes |
d_drawdown_exp_s |
Drawdown credit limit expiration date |
datetime |
yes |
d_inco_s |
Business incorporated date |
datetime |
yes |
ym_cur_own_s |
Year and month when current owners took ownership (YYYYMM) |
char(6) |
yes |
d_birth_s |
Date of birth |
datetime |
yes |
d_lst_mod_s |
Last modification date |
datetime |
yes |
d_othr_lst_mod_s |
Other address last modification date |
datetime |
yes |
d_bill_lst_mod_s |
Billing address last modification date |
datetime |
yes |
d_lcus_s |
Date custom outstanding last updated
For use only by collection module |
datetime |
yes |
d_fin_stmt_s |
Financial statement date |
datetime |
yes |
bus_typ_s |
Type of business |
char(4) |
yes |
remit_s |
Remittance address |
char(4) |
yes |
res_stat_s |
Residence status (RES.STAT code) |
char(4) |
yes |
sic_s |
SIC code |
char(4) |
yes |
sal_s |
Salutation |
char(4) |
yes |
add_inc_src_s |
Additional income source code |
char(4) |
yes |
marital_s |
Marital status |
char(4) |
yes |
col_team_s |
Collection team |
char(4) |
yes |
def_por_s |
Default portfolio |
char(2) |
yes |
def_com_s |
Default company |
char(2) |
yes |
def_reg_s |
Default region |
char(2) |
yes |
def_off_s |
Default office |
char(3) |
yes |
nam_long_s |
Long name |
char(125) |
yes |
bus_phn_s |
Business phone |
char(10) |
yes |
hom_phn_s |
Home phone |
char(10) |
yes |
add_s |
Address |
char(36) |
yes |
add2_s |
Address 2 |
char(36) |
yes |
cty_s |
City |
char(25) |
yes |
st_s |
State code (RST.ST_S code) |
char(2) |
yes |
zip_s |
Zip code |
char(9) |
yes |
bus_desc_s |
Business description |
char(36) |
yes |
short_cont_nam_s |
Contact name |
char(25) |
yes |
cont_title_s |
Contact title |
char(25) |
yes |
sig_nam_s |
Signer name |
char(25) |
yes |
sig_title_s |
Signer title |
char(25) |
yes |
bus_st_s |
State where business incorporated |
char(2) |
yes |
tx_exempt_s |
Tax exempt number |
char(20) |
yes |
lst_mod_init_s |
Last modification initials |
char(3) |
yes |
othr_nam_s |
Other address name |
char(36) |
yes |
othr_add_s |
Other address |
char(36) |
yes |
othr_add2_s |
Other address 2 |
char(36) |
yes |
othr_cty_s |
Other address city |
char(25) |
yes |
othr_st_s |
Other address state |
char(2) |
yes |
othr_zip_s |
Other address zip code |
char(9) |
yes |
othr_bus_phn_s |
Other address business phone |
char(10) |
yes |
othr_home_phn_s |
Other address home phone |
char(10) |
yes |
othr_note1_s |
Other address note 1 |
char(36) |
yes |
othr_note2_s |
Other address note 2 |
char(36) |
yes |
othr_id_s |
Other address ID |
char(9) |
yes |
othr_lst_mod_init_s |
Other address last modification initials |
char(3) |
yes |
bill_nam_s |
Billing address name |
char(36) |
yes |
bill_add_s |
Billing address |
char(36) |
yes |
bill_add2_s |
Billing address 2 |
char(36) |
yes |
bill_cty_s |
Billing address city |
char(25) |
yes |
bill_st_s |
Billing address state |
char(2) |
yes |
bill_zip_s |
Billing address zip code |
char(9) |
yes |
bill_lst_mod_init_s |
Billing address last modification initials |
char(3) |
yes |
col_init_s |
Collector when removed from collection tracking |
char(3) |
yes |
age_l |
Age |
integer |
yes |
res_yrs_l |
Length of residence in years |
integer |
yes |
res_mon_l |
Length of residence in months |
integer |
yes |
dependents_l |
Number of dependents |
integer |
yes |
del_lse_l |
Total # of delinquent leases
See notes for col_gr_rec_d field |
integer |
yes |
othr_res_yrs_l |
Other address years residing |
integer |
yes |
othr_res_mon_l |
Other address months residing |
integer |
yes |
mon_pmt_d |
Monthly payment |
double precision |
yes |
drawdown_limit_d |
Drawdown credit limit |
double precision |
yes |
auto_lim_d |
Auto-approval limit |
double precision |
yes |
add_inc_d |
Additional income source amount |
double precision |
yes |
col_gr_rec_d |
Custom gross receivable
Notes:
1. Used only by the collection module
2. Calculated only for delinquent lessees
3. Only accurate as of the last time EOP Sequential Updates
and EOP Collection Initialization was run with the
U1121 Collection switch on
4. Set to 0 for non-delinquent lessees
5. These notes also apply to the col_net_out_d,
col_gr_out_d, del_amt_d, and del_lse_l fields. |
double precision |
yes |
col_net_out_d |
Custom net outstanding
See notes for col_gr_rec_d field |
double precision |
yes |
col_gr_out_d |
Custom gross outstanding
See notes for col_gr_rec_d field |
double precision |
yes |
del_amt_d |
Total delinquent amount
See notes for col_gr_rec_d field |
double precision |
yes |
appr_app_d |
Acquisition cost - approved applications |
double precision |
yes |
lt_version_s |
Letter version code |
char(4) |
yes |
col_stat_s |
Collection status |
char(4) |
yes |
d_revolving_exp_s |
Revolving credit limit expiration date |
datetime |
yes |
revolving_limit_d |
Revolving credit limit |
double precision |
yes |
prenote_sent_c |
Prenotification sent (Y/N) |
char(1) |
yes |
d_prenote_sent_on_s |
Date prenotification sent on |
datetime |
yes |
ach_type_s |
ACH type (ACH.TYP code)
PPD - Consumer
CCD - Corporate
AUS - Australian WDE
400 - Rent/lease (Canada) |
char(4) |
yes |
inst_id_s |
PAP institution/ACH transit ID |
char(9) |
yes |
payer_acct_s |
PAP account number |
char(17) |
yes |
d_crd_exp_upd_s |
Credit exposure, date last updated |
datetime |
yes |
t_crd_exp_upd_s |
Credit exposure, time last updated |
char(6) |
yes |
crd_exp_tot_app_l |
Credit exposure, total # of approved applications |
integer |
yes |
crd_exp_tot_lse_l |
Credit exposure, total # of leases |
integer |
yes |
crd_exp_tot_del_l |
Credit exposure, total # of delinquent leases |
integer |
yes |
crd_exp_gr_rec_d |
Credit exposure, custom gross receivable |
double precision |
yes |
crd_exp_gr_outs_d |
Credit exposure, custom gross outstanding balance |
double precision |
yes |
crd_exp_net_outs_d |
Credit exposure, custom net outstanding balance |
double precision |
yes |
crd_exp_tot_apprv_d |
Credit exposure, total approved acquisition cost |
double precision |
yes |
crd_exp_tot_exposure_d |
Credit exposure, total exposure |
double precision |
yes |
crd_exp_tot_del_d |
Credit exposure, total delinquent |
double precision |
yes |
crd_exp_del_cat1_d |
Credit exposure, delinquent category 1 |
double precision |
yes |
crd_exp_del_cat2_d |
Credit exposure, delinquent category 2 |
double precision |
yes |
crd_exp_del_cat3_d |
Credit exposure, delinquent category 3 |
double precision |
yes |
crd_exp_del_cat4_d |
Credit exposure, delinquent category 4 |
double precision |
yes |
d_co_crd_exp_upd_s |
Co-lessee credit exposure, date last updated |
datetime |
yes |
t_co_crd_exp_upd_s |
Co-lessee credit exposure, time last updated |
char(6) |
yes |
co_crd_exp_tot_app_l |
Co-lessee credit exposure, total # of approved applications |
integer |
yes |
co_crd_exp_tot_lse_l |
Co-lessee credit exposure, total # of leases |
integer |
yes |
co_crd_exp_tot_del_l |
Co-lessee credit exposure, total # of delinquent leases |
integer |
yes |
co_crd_exp_gr_rec_d |
Co-lessee credit exposure, custom gross receivable |
double precision |
yes |
co_crd_exp_gr_outs_d |
Co-lessee credit exposure, custom gross outstanding balance |
double precision |
yes |
co_crd_exp_net_outs_d |
Co-lessee credit exposure, custom net outstanding balance |
double precision |
yes |
co_crd_exp_tot_apprv_d |
Co-lessee credit exposure, total approved acquisition cost |
double precision |
yes |
co_crd_exp_tot_exposure_d |
Co-lessee credit exposure, total exposure |
double precision |
yes |
co_crd_exp_tot_del_d |
Co-lessee credit exposure, total delinquent |
double precision |
yes |
co_crd_exp_del_cat1_d |
Co-lessee credit exposure, delinquent category 1 |
double precision |
yes |
co_crd_exp_del_cat2_d |
Co-lessee credit exposure, delinquent category 2 |
double precision |
yes |
co_crd_exp_del_cat3_d |
Co-lessee credit exposure, delinquent category 3 |
double precision |
yes |
co_crd_exp_del_cat4_d |
Co-lessee credit exposure, delinquent category 4 |
double precision |
yes |
hom_phn_type_s |
Home phone type |
char(4) |
yes |
bus_phn_type_s |
Business phone type |
char(4) |
yes |
last_phn_used_c |
Last phone used |
char(1) |
yes |
delq_l |
Number of times delinquent |
integer |
yes |
contract_st_s |
Contract state |
char(2) |
yes |
pap_acct_type_s |
PAP bank account type |
char(4) |
yes |
email_s |
Email address |
char(50) |
yes |
stax_exempt_s |
Sales/use tax exempt code |
char(4) |
yes |
tot_asm1_b_d |
Total client assessment 1 billed |
double precision |
yes |
tot_asm1_p_d |
Total client assessment 1 paid |
double precision |
yes |
tot_asm2_b_d |
Total client assessment 2 billed |
double precision |
yes |
tot_asm2_p_d |
Total client assessment 2 paid |
double precision |
yes |
tot_asm3_b_d |
Total client assessment 3 billed |
double precision |
yes |
tot_asm3_p_d |
Total client assessment 3 paid |
double precision |
yes |
due_l |
Payment due day |
integer |
yes |
d_lup_s |
Date of last update |
datetime |
yes |
t_lup_s |
Time of last update |
char(6) |
yes |
act_stat_s |
Activity status (STAT code) |
char(4) |
yes |
addr_type_c |
Address type (B/D/M/P/S/Y/Z)
B - Business address
D - Data reporter default address
M - Military address
P - Bill payer service
S - Secondary address
Y - Consumer address
Z - Unknown type |
char(1) |
yes |
addr_stat_c |
Address status (C/N/U/Z)
C - Confirmed/verified address
N - Not confirmed address
U - Undeliverable address/returned mail
Z - Unknown status |
char(1) |
yes |
d_addr_conf_s |
Address confirmation date |
datetime |
yes |
t_addr_conf_s |
Address confirmation time |
char(6) |
yes |
cb_business_c |
Credit bureau business indicator (Y/N)
Y - Report lessee to CB as a business
N - Report lessee to CB as a non-business |
char(1) |
yes |