Attribute Definition

Table Name Att_AttDtl_Attribute_Dtl

Table Comment Attributes are certain characteristics or properties or traits of a Part which help in tracing the quality of a part

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

AttDtl_OUInstance

decimal(38)

NOT NULL

OUInstance ID

Yes

No

AttDtl_Attrib_Code

varchar(10)

NOT NULL

Unique code defined for each attribute.

Yes

No

AttDtl_Desc

varchar(80)

NULL

Brief description of the Attribute

No

No

ATTDTL_DESC_UP

varchar(80)

NULL

Description in Upper

No

No

AttDtl_Status

varchar(15)

NULL

Attribute status can be ’Active’ Or ’Inactive’ Codes & Values: ’A’            - ’Active’ ’I’             - ’InActive’

No

No

AttDtl_Type

varchar(25)

NULL

Specifies whether attribute is Quantitative or Qualitative List of Codes & Values: QT             - Quantitative QL             - Qualitative

No

No

AttDtl_Uom

varchar(10)

NULL

Standard UOM for measurement of attribute value

No

No

AttDtl_Created_By

varchar(30)

NULL

Created Username

No

No

AttDtl_Created_Date

datetime

NULL

Created Date

No

No

AttDtl_Modified_By

varchar(30)

NULL

Modified UserName

No

No

AttDtl_Modified_Date

datetime

NULL

Modified Date

No

No

AttDtl_Timestamp

decimal(38)

NULL

An integer value which maintains the count of updates which is used for concurrent checks

No

No

Table Name AttDef_parameter_details

Table Comment Stores Parameter detail information. In this component, this table needs to store only search criteria message

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

AttDef_ComponentName

varchar(80)

NOT NULL

Component Code

Yes

No

AttDef_ParamCategory

varchar(10)

NOT NULL

This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.

Yes

No

AttDef_ParamType

varchar(25)

NOT NULL

Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.

Yes

No

AttDef_ParamCode

varchar(5)

NOT NULL

Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component

Yes

No

AttDef_Langid

decimal(38)

NOT NULL

Language id. This is the language id of the record.

Yes

No

AttDef_ParamDesc

varchar(80)

NULL

Description of the parameter code

No

No

AttDef_CreationDate

datetime

NULL

Date at which details are created.

No

No

AttDef_Sort_By

decimal(38)

NULL

Sort By

No

No