Name | Segment 1 |
---|---|
rlr_idx0 | dlr_s |
Columns | |||
---|---|---|---|
Name | Description | Datatype ¿? | Allow Null |
dlr_s | Vendor |
char(9) | no |
timestamp | Record modification stamp |
timestamp | yes |
def_app_s | Default application |
char(10) | yes |
d_agr_s | Vendor agreement date |
datetime | yes |
d_fin_s | Financial statement date |
datetime | yes |
part_s | Vendor participation code |
char(4) | yes |
sales_s | Salesperson number |
char(4) | yes |
stat_s | Activity status |
char(4) | yes |
vend_type_s | Vendor type |
char(4) | yes |
plan_s | Rate plan group |
char(4) | yes |
remit_type_s | Remittance type code |
char(4) | yes |
rec_s | Recourse type |
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 |
rmt_nam_s | Remittance name |
char(36) | yes |
rmt_add_s | Remittance address |
char(36) | yes |
rmt_add2_s | Remittance address 2 |
char(36) | yes |
rmt_cty_s | Remittance city |
char(25) | yes |
rmt_st_s | Remittance state |
char(2) | yes |
rmt_zip_s | Remittance zip code |
char(9) | yes |
cont_nam1_s | Contact name 1 |
char(36) | yes |
cont_title1_s | Contact title 1 |
char(25) | yes |
cont_nam2_s | Contact name 2 |
char(36) | yes |
cont_title2_s | Contact title 2 |
char(25) | yes |
own_s | Owner or manager name |
char(36) | yes |
auth_sign_s | Authorization signature name |
char(36) | yes |
bad_debt_d | Bad debt percentage |
double precision | yes |
gl_only_c | Default GL only (Y/N) |
char(1) | yes |
lt_version_s | Letter version code |
char(4) | yes |
inst_id_s | PAP institution/ACH transit ID |
char(9) | yes |
payer_acct_s | PAP account number |
char(17) | 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 |
dlr_tax_id_s | Dealer tax identification number |
char(36) | yes |
holdback_d | Holdback amount allow |
double precision | yes |
holdback_bal_d | Actual holdback amount |
double precision | yes |
alrt_s | Alert switches (Y/N) |
char(6) | yes |
alrt_amt1_d | Alert amount [1] |
double precision | yes |
alrt_amt2_d | Alert amount [2] |
double precision | yes |
alrt_amt3_d | Alert amount [3] |
double precision | yes |
alrt_amt4_d | Alert amount [4] |
double precision | yes |
alrt_amt5_d | Alert amount [5] |
double precision | yes |
alrt_amt6_d | Alert amount [6] |
double precision | yes |
d_alrt_susp_ovr_s | Alert suspense override date |
datetime | yes |
alrt_note_s | Alert note |
char(255) | yes |
p_ins_d | Insurance percentage |
double precision | yes |
ins_bank_s | Insurance bank code |
char(3) | yes |
email_s | Email address |
char(50) | yes |
ml_team_s | Maturing lease team |
char(4) | yes |
new_own_s | New application owner |
char(3) | yes |
vtx_taid_s | Vertex tax area id |
char(10) | yes |
cnty_s | County |
char(60) | yes |
d_lup_s | Date of last update |
datetime | yes |
t_lup_s | Time of last update |
char(6) | yes |
txp_s | Tax payment code (TXP code) |
char(4) | yes |