DVC_IEEE_NM |
Base Object | BARCD_ASGN |
Attribute Name | Dvc IEEE Nm |
ColumnName | DVC_IEEE_NM |
Logical Rolename | |
RoleName | |
Domain | Asset Identifier |
Physical Only | NO |
Definition | Asset Identifier: The Datastream/Infor asset identifier also often referred to as the Barcode Id. |
Note |
DVC_IEEE_NM Column Properties |
Datatype | VARCHAR2(30) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
DVC_IEEE_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 11 |
Percent Null | 0 |
DVC_IEEE_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DVC_IEEE_NM Security Types |
Name | Current Value |
DVC_IEEE_NM Bound Attachments |
Name | Current Value |
DVC_IEEE_NM Data Movement Rules |
Name | Type | Rule Text/Value |
DVC_IEEE_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Barcode Assignment Dvc IEEE Nm |
NO | ||
EQUIP (Oracle) BARCD_ASGN DVC_IEEE_NM |
NO |
DVC_IEEE_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_IEEE_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_IEEE_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_IEEE_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_TYPE_ID |
Base Object | BARCD_ASGN |
Attribute Name | Dvc Type Id |
ColumnName | DVC_TYPE_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Device Type Identifier: The unique identifier for a device type. |
Note |
DVC_TYPE_ID Column Properties |
Datatype | VARCHAR2(25) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
DVC_TYPE_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
DVC_TYPE_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DVC_TYPE_ID Security Types |
Name | Current Value |
DVC_TYPE_ID Bound Attachments |
Name | Current Value |
DVC_TYPE_ID Data Movement Rules |
Name | Type | Rule Text/Value |
DVC_TYPE_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Barcode Assignment Dvc Type Id |
NO | ||
EQUIP (Oracle) BARCD_ASGN DVC_TYPE_ID |
NO |
DVC_TYPE_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_TYPE_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_TYPE_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_TYPE_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_ID |
Base Object | BARCD_ASGN |
Attribute Name | Cmpnt ID |
ColumnName | CMPNT_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Component Identifier: The unique identifier for the IEEE component type. |
Note |
CMPNT_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
CMPNT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
CMPNT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CMPNT_ID Security Types |
Name | Current Value |
CMPNT_ID Bound Attachments |
Name | Current Value |
CMPNT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
CMPNT_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Barcode Assignment Cmpnt ID |
NO | ||
EQUIP (Oracle) BARCD_ASGN CMPNT_ID |
NO |
CMPNT_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MAXVAL |
Base Object | BARCD_ASGN |
Attribute Name | Maxval |
ColumnName | MAXVAL |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Maximum Value: The last barcode number assigned. This number is used to generate new numbers. |
Note |
MAXVAL Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
MAXVAL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
MAXVAL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MAXVAL Security Types |
Name | Current Value |
MAXVAL Bound Attachments |
Name | Current Value |
MAXVAL Data Movement Rules |
Name | Type | Rule Text/Value |
MAXVAL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Barcode Assignment Maxval |
NO | ||
EQUIP (Oracle) BARCD_ASGN MAXVAL |
NO |
MAXVAL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MAXVAL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MAXVAL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MAXVAL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |