Name | Segment 1 | Segment 2 |
---|---|---|
rcu_idx0 | cus_s | |
rcu_idx1 | par_cus_s | cus_s |
Columns | |||
---|---|---|---|
Name | Description | Datatype ¿? | Allow Null |
cus_s | Customer number |
char(9) | no |
timestamp | Record modification stamp |
timestamp | yes |
def_app_s | Default application |
char(10) | yes |
par_cus_s | Parent customer |
char(9) | no |
d_fin_s | Financial statement date |
datetime | yes |
d_drawdown_exp_s | Drawdown credit limit expiration date |
datetime | 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 |
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 |
phn_s | Phone number |
char(10) | yes |
cont_nam_s | Contact name |
char(36) | yes |
cont_title_s | Contact title |
char(25) | 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 |
drawdown_limit_d | Drawdown credit limit |
double precision | yes |
appr_app_d | Acquisition cost - approved applications |
double precision | yes |
first_cus_lse_s | First lease in customer |
char(10) | yes |
last_cus_lse_s | Last lease in customer |
char(10) | yes |
lt_version_s | Letter version code |
char(4) | yes |
d_revolving_exp_s | Revolving credit limit expiration date |
datetime | yes |
revolving_limit_d | Revolving credit limit |
double precision | 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 |
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 |
bus_phn_s | Business phone |
char(10) | yes |
email_s | Email address |
char(50) | yes |
pmt_hier_s | Payment hierarchy |
char(4) | yes |
d_lup_s | Date of last update |
datetime | yes |
t_lup_s | Time of last update |
char(6) | yes |