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