rbk Table: Broker
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rbk Table: Broker

Indexes

Name Segment 1
rbk_idx0 brk_s


Columns
Name DescriptionDatatype ¿? Allow Null
brk_s
Broker
Record modification stamp
stat_s
Activity status
remit_type_s
Remittance type code
gl_only_c
Default GL only (Y/N)
def_por_s
Default portfolio
def_com_s
Default company
def_reg_s
Default region
def_off_s
Default office
nam_s
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
cont_nam_s
Contact name
cont_title_s
Contact title
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
lt_version_s
Letter version code
email_s
Email address
d_lup_s
Date of last update
t_lup_s
Time of last update
txp_s
Tax payment code (TXP code)
cnty_s
County
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
prenote_sent_c
Prenotification sent (Y/N)
d_prenote_sent_on_s
Date prenotification sent on