complexType "materiel_itemTYPE"
Namespace:
Content:
complex, 21 attributes, 1 element
Defined:
globally in CRIS_Complete_V3-2-1_[31-Dec-2008].xsd, see XML source
Includes:
definitions of 21 attributes and 1 element
Used:
XML Representation Summary
<...
    resource_db_site
 = 
xsd:hexBinary
    resource_db_id
 = 
xsd:unsignedInt
    resource_id
 = 
xsd:unsignedInt
    mat_conn_type_code
 = 
xsd:unsignedShort
    as_db_site
 = 
xsd:hexBinary
    as_db_id
 = 
xsd:unsignedInt
    as_type_code
 = 
xsd:unsignedInt
    model_db_site
 = 
xsd:hexBinary
    model_db_id
 = 
xsd:unsignedInt
    model_id
 = 
xsd:unsignedInt
    asset_org_site
 = 
xsd:hexBinary
    asset_id
 = 
xsd:unsignedInt
    mm_resource_db_site
 = 
xsd:hexBinary
    mm_resource_db_id
 = 
xsd:unsignedInt
    mm_resource_id
 = 
xsd:unsignedInt
    user_tag_ident
 = 
xsd:string
    name
 = 
xsd:string
    gmt_last_updated
 = 
xsd:dateTime
    last_upd_db_site
 = 
xsd:hexBinary
    last_upd_db_id
 = 
xsd:unsignedInt
    rstat_type_code
 = 
xsd:unsignedShort
    >
   
Content: 
lcinfo?
</...>
Content Elements (1):
lcinfo (type lcinfo)
Known Usage Locations
Annotation
Materiel Item (Consummable, Part, Tool, Document, Form) Entity:
XML Source (w/o annotations (22))
<xsd:complexType name="materiel_itemTYPE">
<xsd:sequence>
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>
</xsd:sequence>
<xsd:attribute name="resource_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="resource_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="resource_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="mat_conn_type_code" type="xsd:unsignedShort" use="required"/>
<xsd:attribute name="as_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="as_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="as_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="model_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="model_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="model_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="asset_org_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="asset_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="mm_resource_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="mm_resource_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="mm_resource_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="user_tag_ident" type="varchar254" use="optional"/>
<xsd:attribute name="name" 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:complexType>
Attribute Detail (defined in this component only; 21/21)
resource_db_site
Type:
Use:
required
Foreign key reference to Logistic_Resource.resource_db_site, Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="resource_db_site" type="site_codeSimpleType" use="required"/>

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

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

mat_conn_type_code
Type:
xsd:unsignedShort, predefined
Use:
required
Foreign key reference to Mat_Item_Conn_Type.mat_con_type_code
Table which contains the type of connection this material item refers to: "Asset_Type", "Model", "Asset", or ("Material_Master_Item") which is used to identify which FK reference to use. One and only one FK matching this resource connection must be specified.
mat_conn_type_code -> Foreign Key
1. (Asset_Type) -> as_db_site, as_db_id, as_type_code
OR 2. (Model) -> model_db_site, model_db_id, model_id
OR 3. (Asset) -> asset_org_site, asset_id
4. (Materiel_Master_Item) -> mm_resource_db_site, mm_resource_db_id, mm_resource_id
XML Source (w/o annotations (1))
<xsd:attribute name="mat_conn_type_code" type="xsd:unsignedShort" use="required"/>

as_db_site
Type:
Use:
optional
Foreign key reference to Asset_Type.as_db_site
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="as_db_site" type="site_codeSimpleType" use="optional"/>

as_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Asset_Type.as_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="as_db_id" type="xsd:unsignedInt" use="optional"/>

as_type_code
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Asset_Type.as_type_code
XML Source (w/o annotations (1))
<xsd:attribute name="as_type_code" type="xsd:unsignedInt" use="optional"/>

model_db_site
Type:
Use:
optional
Foreign key reference to Model.model_db_site
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="model_db_site" type="site_codeSimpleType" use="optional"/>

model_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Model.model_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="model_db_id" type="xsd:unsignedInt" use="optional"/>

model_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Model.model_id
XML Source (w/o annotations (1))
<xsd:attribute name="model_id" type="xsd:unsignedInt" use="optional"/>

asset_org_site
Type:
Use:
optional
Foreign key reference to Asset.asset_org_site
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="asset_org_site" type="site_codeSimpleType" use="optional"/>

asset_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Asset.asset_id
XML Source (w/o annotations (1))
<xsd:attribute name="asset_id" type="xsd:unsignedInt" use="optional"/>

mm_resource_db_site
Type:
Use:
optional
Foreign key reference to Material_Master_Item.mm_resource_db_site
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="mm_resource_db_site" type="site_codeSimpleType" use="optional"/>

mm_resource_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Material_Master_Item.mm_resource_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="mm_resource_db_id" type="xsd:unsignedInt" use="optional"/>

mm_resource_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Material_Master_Item.mm_resource_id
XML Source (w/o annotations (1))
<xsd:attribute name="mm_resource_id" type="xsd:unsignedInt" use="optional"/>

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"/>

name
Type:
Use:
optional
Full user-defined name/description
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="name" 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"/>
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