complexType "manufacturerTYPE"
Namespace:
Content:
complex, 32 attributes, 1 element
Defined:
globally in CRIS_Complete_V3-2-1_[31-Dec-2008].xsd, see XML source
Includes:
definitions of 32 attributes and 1 element
Used:
XML Representation Summary
<...
    mf_db_site
 = 
xsd:hexBinary
    mf_db_id
 = 
xsd:unsignedInt
    manuf_code
 = 
xsd:unsignedInt
    user_tag_ident
 = 
xsd:string
    manuf_trade_name
 = 
xsd:string
    company_name
 = 
xsd:string
    phys_addr
 = 
xsd:string
    phys_city_name
 = 
xsd:string
    phys_state_abbr
 = 
xsd:string
    phys_postal_code
 = 
xsd:string
    phys_country_abbr
 = 
xsd:string
    mail_addr
 = 
xsd:string
    mail_city_name
 = 
xsd:string
    mail_state_abbr
 = 
xsd:string
    mail_postal_code
 = 
xsd:string
    mail_country_abbr
 = 
xsd:string
    us_ph_number
 = 
xsd:string
    int_ph_country_no
 = 
xsd:string
    int_ph_city_no
 = 
xsd:string
    int_ph_local_no
 = 
xsd:string
    us_fax_number
 = 
xsd:string
    int_fax_country_no
 = 
xsd:string
    int_fax_city_no
 = 
xsd:string
    int_fax_local_no
 = 
xsd:string
    business_desc
 = 
xsd:string
    primary_sic
 = 
xsd:string
    gmt_last_updated
 = 
xsd:dateTime
    last_upd_db_site
 = 
xsd:hexBinary
    last_upd_db_id
 = 
xsd:unsignedInt
    rstat_type_code
 = 
xsd:unsignedShort
    lc_alt_sic1
 = 
xsd:string
    lc_alt_sic2
 = 
xsd:string
    >
   
Content: 
lcinfo?
</...>
Content Elements (1):
lcinfo (type lcinfo)
Known Usage Locations
Annotation
Manufacturer Entity. This entity provides basic contact information for the manufacturers list.
Note: The optional field primary_sic relates to the primary Standard Industry Code (SIC) for the site. This code is linked in a SIC reference book to the type of industry the site is associated with.
Note: MIMOSA populates and maintains the enterprise zero, site zero (mf_db_site = “0000000000000000”) entries in this table.
Note: On address lines, line breaks are denoted by a backslash (“\”) character.
XML Source (w/o annotations (33))
<xsd:complexType name="manufacturerTYPE">
<xsd:sequence>
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>
</xsd:sequence>
<xsd:attribute name="mf_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="mf_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="manuf_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="user_tag_ident" type="varchar254" use="optional"/>
<xsd:attribute name="manuf_trade_name" type="varchar254" use="required"/>
<xsd:attribute name="company_name" type="varchar254" use="required"/>
<xsd:attribute name="phys_addr" type="varchar254" use="optional"/>
<xsd:attribute name="phys_city_name" type="varchar254" use="optional"/>
<xsd:attribute name="phys_state_abbr" type="varchar254" use="optional"/>
<xsd:attribute name="phys_postal_code" type="varchar254" use="optional"/>
<xsd:attribute name="phys_country_abbr" type="varchar254" use="optional"/>
<xsd:attribute name="mail_addr" type="varchar254" use="optional"/>
<xsd:attribute name="mail_city_name" type="varchar254" use="optional"/>
<xsd:attribute name="mail_state_abbr" type="varchar254" use="optional"/>
<xsd:attribute name="mail_postal_code" type="varchar254" use="optional"/>
<xsd:attribute name="mail_country_abbr" type="varchar254" use="optional"/>
<xsd:attribute name="us_ph_number" type="varchar254" use="optional"/>
<xsd:attribute name="int_ph_country_no" type="varchar254" use="optional"/>
<xsd:attribute name="int_ph_city_no" type="varchar254" use="optional"/>
<xsd:attribute name="int_ph_local_no" type="varchar254" use="optional"/>
<xsd:attribute name="us_fax_number" type="varchar254" use="optional"/>
<xsd:attribute name="int_fax_country_no" type="varchar254" use="optional"/>
<xsd:attribute name="int_fax_city_no" type="varchar254" use="optional"/>
<xsd:attribute name="int_fax_local_no" type="varchar254" use="optional"/>
<xsd:attribute name="business_desc" type="varchar254" use="optional"/>
<xsd:attribute name="primary_sic" type="varchar254" use="optional"/>
<xsd:attribute name="gmt_last_updated" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="last_upd_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="last_upd_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="rstat_type_code" type="xsd:unsignedShort" use="optional"/>
<xsd:attribute name="lc_alt_sic1" type="varchar254" use="optional"/>
<xsd:attribute name="lc_alt_sic2" type="varchar254" use="optional"/>
</xsd:complexType>
Attribute Detail (defined in this component only; 32/32)
mf_db_site
Type:
Use:
required
Foreign key reference to Site_Database.db_site, Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="mf_db_site" type="site_codeSimpleType" use="required"/>

mf_db_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Site_Database.db_id, Included in composite primary key Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="mf_db_id" type="xsd:unsignedInt" use="required"/>

manuf_code
Type:
xsd:unsignedInt, predefined
Use:
required
Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="manuf_code" type="xsd:unsignedInt" use="required"/>

user_tag_ident
Type:
Use:
optional
Short user-defined tag/identifier
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="user_tag_ident" type="varchar254" use="optional"/>

manuf_trade_name
Type:
Use:
required
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="manuf_trade_name" type="varchar254" use="required"/>

company_name
Type:
Use:
required
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="company_name" type="varchar254" use="required"/>

phys_addr
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="phys_addr" type="varchar254" use="optional"/>

phys_city_name
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="phys_city_name" type="varchar254" use="optional"/>

phys_state_abbr
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="phys_state_abbr" type="varchar254" use="optional"/>

phys_postal_code
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="phys_postal_code" type="varchar254" use="optional"/>

phys_country_abbr
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="phys_country_abbr" type="varchar254" use="optional"/>

mail_addr
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="mail_addr" type="varchar254" use="optional"/>

mail_city_name
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="mail_city_name" type="varchar254" use="optional"/>

mail_state_abbr
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="mail_state_abbr" type="varchar254" use="optional"/>

mail_postal_code
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="mail_postal_code" type="varchar254" use="optional"/>

mail_country_abbr
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="mail_country_abbr" type="varchar254" use="optional"/>

us_ph_number
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="us_ph_number" type="varchar254" use="optional"/>

int_ph_country_no
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="int_ph_country_no" type="varchar254" use="optional"/>

int_ph_city_no
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="int_ph_city_no" type="varchar254" use="optional"/>

int_ph_local_no
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="int_ph_local_no" type="varchar254" use="optional"/>

us_fax_number
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="us_fax_number" type="varchar254" use="optional"/>

int_fax_country_no
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="int_fax_country_no" type="varchar254" use="optional"/>

int_fax_city_no
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="int_fax_city_no" type="varchar254" use="optional"/>

int_fax_local_no
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="int_fax_local_no" type="varchar254" use="optional"/>

business_desc
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="business_desc" type="varchar254" use="optional"/>

primary_sic
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="primary_sic" type="varchar254" use="optional"/>

gmt_last_updated
Type:
Use:
optional
UTC/GMT timestamp for the last change to this record
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="gmt_last_updated" type="dateTimeWithoutTimezone" use="optional"/>

last_upd_db_site
Type:
Use:
optional
Foreign key reference to Site_Database.db_site which identifies the database creating/updating/soft deleting this entry
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="last_upd_db_site" type="site_codeSimpleType" use="optional"/>

last_upd_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Site_Database.db_id which identifies the database creating/updating/soft deleting this entry
XML Source (w/o annotations (1))
<xsd:attribute name="last_upd_db_id" type="xsd:unsignedInt" use="optional"/>

rstat_type_code
Type:
xsd:unsignedShort, predefined
Use:
optional
Foreign key reference to Row_Status_Type.rstat_type_cod which determines the status of this entry
XML Source (w/o annotations (1))
<xsd:attribute name="rstat_type_code" type="xsd:unsignedShort" use="optional"/>

lc_alt_sic1
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="lc_alt_sic1" type="varchar254" use="optional"/>

lc_alt_sic2
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="lc_alt_sic2" type="varchar254" use="optional"/>
Content Element Detail (defined in this component only; 1/1)
lcinfo
Type:
lcinfo, complex content
XML Source
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>

XML schema documentation generated with DocFlex/XML 1.7.2b using DocFlex/XML | XSDDoc 2.1.0b template set