rlr Table: Vendor

Database Reference

rlr Table: Vendor

Indexes

Name	Segment 1
rlr_idx0	dlr_s

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