mf_db_site
Base Entity manufacturer
Attribute Name site_code
Definition

mf_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable NO


mf_db_id
Base Entity manufacturer
Attribute Name db_id
Definition

mf_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable NO


manuf_code
Base Entity manufacturer
Attribute Name manuf_code
Definition

manuf_code Logical Attribute Properties
Logical Attribute Name manuf_code
Datatype INTEGER
Nullable NO


user_tag_ident
Base Entity manufacturer
Attribute Name user_tag_ident
Definition

user_tag_ident Logical Attribute Properties
Logical Attribute Name user_tag_ident
Datatype VARCHAR(254)
Nullable YES


manuf_trade_name
Base Entity manufacturer
Attribute Name manuf_trade_name
Definition

manuf_trade_name Logical Attribute Properties
Logical Attribute Name manuf_trade_name
Datatype VARCHAR(254)
Nullable NO


company_name
Base Entity manufacturer
Attribute Name company_name
Definition

company_name Logical Attribute Properties
Logical Attribute Name company_name
Datatype VARCHAR(254)
Nullable NO


phys_addr
Base Entity manufacturer
Attribute Name phys_addr
Definition

phys_addr Logical Attribute Properties
Logical Attribute Name phys_addr
Datatype VARCHAR(254)
Nullable YES


phys_city_name
Base Entity manufacturer
Attribute Name phys_city_name
Definition

phys_city_name Logical Attribute Properties
Logical Attribute Name phys_city_name
Datatype VARCHAR(254)
Nullable YES


phys_state_abbr
Base Entity manufacturer
Attribute Name phys_state_abbr
Definition

phys_state_abbr Logical Attribute Properties
Logical Attribute Name phys_state_abbr
Datatype VARCHAR(254)
Nullable YES


phys_postal_code
Base Entity manufacturer
Attribute Name phys_postal_code
Definition

phys_postal_code Logical Attribute Properties
Logical Attribute Name phys_postal_code
Datatype VARCHAR(254)
Nullable YES


phys_country_abbr
Base Entity manufacturer
Attribute Name phys_country_abbr
Definition

phys_country_abbr Logical Attribute Properties
Logical Attribute Name phys_country_abbr
Datatype VARCHAR(254)
Nullable YES


mail_addr
Base Entity manufacturer
Attribute Name mail_addr
Definition

mail_addr Logical Attribute Properties
Logical Attribute Name mail_addr
Datatype VARCHAR(254)
Nullable YES


mail_city_name
Base Entity manufacturer
Attribute Name mail_city_name
Definition

mail_city_name Logical Attribute Properties
Logical Attribute Name mail_city_name
Datatype VARCHAR(254)
Nullable YES


mail_state_abbr
Base Entity manufacturer
Attribute Name mail_state_abbr
Definition

mail_state_abbr Logical Attribute Properties
Logical Attribute Name mail_state_abbr
Datatype VARCHAR(254)
Nullable YES


mail_postal_code
Base Entity manufacturer
Attribute Name mail_postal_code
Definition

mail_postal_code Logical Attribute Properties
Logical Attribute Name mail_postal_code
Datatype VARCHAR(254)
Nullable YES


mail_country_abbr
Base Entity manufacturer
Attribute Name mail_country_abbr
Definition

mail_country_abbr Logical Attribute Properties
Logical Attribute Name mail_country_abbr
Datatype VARCHAR(254)
Nullable YES


us_ph_number
Base Entity manufacturer
Attribute Name us_ph_number
Definition

us_ph_number Logical Attribute Properties
Logical Attribute Name us_ph_number
Datatype VARCHAR(254)
Nullable YES


int_ph_country_no
Base Entity manufacturer
Attribute Name int_ph_country_no
Definition

int_ph_country_no Logical Attribute Properties
Logical Attribute Name int_ph_country_no
Datatype VARCHAR(254)
Nullable YES


int_ph_city_no
Base Entity manufacturer
Attribute Name int_ph_city_no
Definition

int_ph_city_no Logical Attribute Properties
Logical Attribute Name int_ph_city_no
Datatype VARCHAR(254)
Nullable YES


int_ph_local_no
Base Entity manufacturer
Attribute Name int_ph_local_no
Definition

int_ph_local_no Logical Attribute Properties
Logical Attribute Name int_ph_local_no
Datatype VARCHAR(254)
Nullable YES


us_fax_number
Base Entity manufacturer
Attribute Name us_fax_number
Definition

us_fax_number Logical Attribute Properties
Logical Attribute Name us_fax_number
Datatype VARCHAR(254)
Nullable YES


int_fax_country_no
Base Entity manufacturer
Attribute Name int_fax_country_no
Definition

int_fax_country_no Logical Attribute Properties
Logical Attribute Name int_fax_country_no
Datatype VARCHAR(254)
Nullable YES


int_fax_city_no
Base Entity manufacturer
Attribute Name int_fax_city_no
Definition

int_fax_city_no Logical Attribute Properties
Logical Attribute Name int_fax_city_no
Datatype VARCHAR(254)
Nullable YES


int_fax_local_no
Base Entity manufacturer
Attribute Name int_fax_local_no
Definition

int_fax_local_no Logical Attribute Properties
Logical Attribute Name int_fax_local_no
Datatype VARCHAR(254)
Nullable YES


business_desc
Base Entity manufacturer
Attribute Name business_desc
Definition

business_desc Logical Attribute Properties
Logical Attribute Name business_desc
Datatype VARCHAR(254)
Nullable YES


primary_sic
Base Entity manufacturer
Attribute Name primary_sic
Definition

primary_sic Logical Attribute Properties
Logical Attribute Name primary_sic
Datatype VARCHAR(254)
Nullable YES


gmt_last_updated
Base Entity manufacturer
Attribute Name gmt_last_updated
Definition

gmt_last_updated Logical Attribute Properties
Logical Attribute Name gmt_last_updated
Datatype DATETIME
Nullable YES


last_upd_db_site
Base Entity manufacturer
Attribute Name site_code
Definition

last_upd_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


last_upd_db_id
Base Entity manufacturer
Attribute Name db_id
Definition

last_upd_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable YES


rstat_type_code
Base Entity manufacturer
Attribute Name rstat_type_cod
Definition

rstat_type_code Logical Attribute Properties
Logical Attribute Name rstat_type_cod
Datatype SMALLINT
Nullable YES


lc_alt_sic1
Base Entity manufacturer
Attribute Name lc_alt_sic1
Definition

lc_alt_sic1 Logical Attribute Properties
Logical Attribute Name lc_alt_sic1
Datatype VARCHAR(254)
Nullable YES


lc_alt_sic2
Base Entity manufacturer
Attribute Name lc_alt_sic2
Definition

lc_alt_sic2 Logical Attribute Properties
Logical Attribute Name lc_alt_sic2
Datatype VARCHAR(254)
Nullable YES