| Description |
Column |
Datatype |
| Customer number
|
cus_s |
char (9) |
| Sybase timestamp
|
timestamp |
timestamp |
| Default application
|
def_app_s |
char (10) |
| Parent customer
|
par_cus_s |
char (9) |
| Financial statement date
|
d_fin_s |
datetime |
| Drawdown credit limit expiration date
|
d_drawdown_exp_s |
datetime |
| Collection team
|
col_team_s |
char (4) |
| Default portfolio
|
def_por_s |
char (2) |
| Default company
|
def_com_s |
char (2) |
| Default region
|
def_reg_s |
char (2) |
| Default office
|
def_off_s |
char (3) |
| Long name
|
nam_long_s |
char (125) |
| Address
|
add_s |
char (36) |
| Address 2
|
add2_s |
char (36) |
| City
|
cty_s |
char (25) |
| State
|
st_s |
char (2) |
| Zip code
|
zip_s |
char (9) |
| Phone number
|
phn_s |
char (10) |
| Contact name
|
cont_nam_s |
char (36) |
| Contact title
|
cont_title_s |
char (25) |
| Billing address name
|
bill_nam_s |
char (36) |
| Billing address
|
bill_add_s |
char (36) |
| Billing address 2
|
bill_add2_s |
char (36) |
| Billing address city
|
bill_cty_s |
char (25) |
| Billing address state
|
bill_st_s |
char (2) |
| Billing address zip code
|
bill_zip_s |
char (9) |
| Drawdown credit limit
|
drawdown_limit_d |
double precision |
| Acquisition cost - approved applications
|
appr_app_d |
double precision |
| First lease in customer
|
first_cus_lse_s |
char (10) |
| Last lease in customer
|
last_cus_lse_s |
char (10) |
| Letter version code
|
lt_version_s |
char (4) |
| Revolving credit limit expiration date
|
d_revolving_exp_s |
datetime |
| Revolving credit limit
|
revolving_limit_d |
double precision |
| Credit exposure, date last updated
|
d_crd_exp_upd_s |
datetime |
| Credit exposure, time last updated
|
t_crd_exp_upd_s |
char (6) |
| Credit exposure, total # of approved applications
|
crd_exp_tot_app_l |
integer |
| Credit exposure, total # of leases
|
crd_exp_tot_lse_l |
integer |
| Credit exposure, total # of delinquent leases
|
crd_exp_tot_del_l |
integer |
| Credit exposure, custom gross receivable
|
crd_exp_gr_rec_d |
double precision |
| Credit exposure, custom gross outstanding balance
|
crd_exp_gr_outs_d |
double precision |
| Credit exposure, custom net outstanding balance
|
crd_exp_net_outs_d |
double precision |
| Credit exposure, total approved acquisition cost
|
crd_exp_tot_apprv_d |
double precision |
| Credit exposure, total exposure
|
crd_exp_tot_exposure_d |
double precision |
| Credit exposure, total delinquent
|
crd_exp_tot_del_d |
double precision |
| Credit exposure, delinquent category 1
|
crd_exp_del_cat1_d |
double precision |
| Credit exposure, delinquent category 2
|
crd_exp_del_cat2_d |
double precision |
| Credit exposure, delinquent category 3
|
crd_exp_del_cat3_d |
double precision |
| Credit exposure, delinquent category 4
|
crd_exp_del_cat4_d |
double precision |
| Home phone type
|
hom_phn_type_s |
char (4) |
| Business phone type
|
bus_phn_type_s |
char (4) |
| Last phone used
|
last_phn_used_c |
char (1) |
| Business phone
|
bus_phn_s |
char (10) |
| Email address
|
email_s |
char (50) |