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 |