Table Detail Report
MM_XFI_LOCATOR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Interface Item Locator |
Definition: | Interface Item Locator table. Data is moved from this table to the LOCATOR_ROLLUP table. |
Table Type: | REFERENCE |
Column Detail - MM_XFI_LOCATOR
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_FLAG | DOUBLE | N | Action flag for the action |
BATCH_GROUP_ID | DOUBLE | Y | Grouper TRANSACTION_ID for a set of MM_XFI_LOCATOR rows in order to perform batch processing on a subset of rows. |
BATCH_REF | VARCHAR(100) | Y | Batch Reference |
CONTRIBUTOR | VARCHAR(40) | Y | Contributor value |
CONTRIBUTOR_CD | DOUBLE | N | Contributor CD |
CREATE_APPLCTX | DOUBLE | Y | The application context number from the record info block. |
CREATE_DT_TM | DATETIME | Y | The date and time the row was last inserted |
CREATE_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert of the row in the table. |
CREATE_TASK | DOUBLE | Y | The registered (assigned) task number for the process that inserted the row |
ITEM_ID | DOUBLE | N | ID value of the Item |
ITEM_IDENTIFIER | VARCHAR(255) | N | Item Identifier |
ITEM_IDENTIFIER_TYPE | VARCHAR(40) | Y | Item Identifier Type |
ITEM_IDENTIFIER_TYPE_CD | DOUBLE | N | Item Identifier Type CD |
LOCATION | VARCHAR(100) | N | Location where the item exists. |
LOCATION_CD | DOUBLE | N | Location CD |
LOCATOR | VARCHAR(60) | N | Locator |
LOCATOR_CD | DOUBLE | N | Locator CD |
LOC_VIEW | VARCHAR(100) | Y | Location View |
LOC_VIEW_CD | DOUBLE | N | Location View CD |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
ORGANIZATION | VARCHAR(100) | Y | Organization |
ORGANIZATION_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. |
PKG_TYPE_CONV | DOUBLE | Y | Package type Conversion |
PKG_TYPE_ID | DOUBLE | N | Package Type ID |
PKG_TYPE_UOM | VARCHAR(40) | Y | Package type Unit of Measure |
PKG_TYPE_UOM_CD | DOUBLE | N | Package type Unit of Measure CD |
PROCESS_FLAG | DOUBLE | N | Process Flag |
SEGMENT_IDENTIFIER | VARCHAR(10) | N | Segment Identifier |
SEGMENT_VERSION | VARCHAR(10) | N | Segment Version |
TRANSACTION_ID | DOUBLE | N | Primary Key |
UPDATE_RULE_FLAG | DOUBLE | Y | Update Rule Flag |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - MM_XFI_LOCATOR
Child Column in MM_XFI_LOCATOR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ITEM_ID | ITEM_DEFINITION | ITEM_ID |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID | |
BATCH_GROUP_ID | MM_XFI_LOCATOR | TRANSACTION_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PKG_TYPE_ID | PACKAGE_TYPE | PACKAGE_TYPE_ID |
Parent Column in MM_XFI_LOCATOR (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TRANSACTION_ID | MM_XFI_LOCATOR | BATCH_GROUP_ID |
MM_XFI_LOCATOR_BATCH | BATCH_GROUP_ID |
MM_XFI_LOCATOR_BATCH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Interface Locator Batch |
Definition: | Used to group a set of MM_XFI_LOCATOR rows for batch processing. |
Table Type: | ACTIVITY |
Column Detail - MM_XFI_LOCATOR_BATCH
Column Name | Type | Null? | Definition |
---|---|---|---|
BATCH_GROUP_ID | DOUBLE | Y | Stores the batch_id for a set of transactions |
BATCH_PROCESS_FLAG | DOUBLE | N | Stores the status of the batch, if the batch is processed the indicator will be set to 1 else it will be 0. |
MM_XFI_LOCATOR_BATCH_ID | DOUBLE | N | Unique generated number that identifies a single row on the MM_XFI_LOCATOR_BATCH table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - MM_XFI_LOCATOR_BATCH
Child Column in MM_XFI_LOCATOR_BATCH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BATCH_GROUP_ID | MM_XFI_LOCATOR | TRANSACTION_ID |
MM_XFI_QOH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MM XFI QOH |
Definition: | Inbound interface table for Quantity On Hand. Data is moved from this table to QUANTITY_ON_HAND. |
Table Type: | REFERENCE |
Column Detail - MM_XFI_QOH
Column Name | Type | Null? | Definition |
---|---|---|---|
ABS_LOT_EXP_DT_TM | DATETIME | Y | Expiration Date as determined at place of origin. |
ABS_LOT_EXP_TZ | DOUBLE | Y | Time zone associated with the ABS_LOT_EXP_DT_TM column. |
ACTION_FLAG | DOUBLE | N | Determines what action to take -- Add / Change / Delete. |
BATCH_REF | VARCHAR(100) | Y | This is a user defined field; allows a reference number/string to be passed in as part of an interface/upload. |
CONTRIBUTOR | VARCHAR(40) | Y | This indicates the Contributor Source to be used for code value aliasing. |
CONTRIBUTOR_CD | DOUBLE | N | The code value for the contributor that was passed in. |
CREATE_APPLCTX | DOUBLE | Y | The application context responsible for inserting the row. |
CREATE_DT_TM | DATETIME | Y | The date/time the row was created. |
CREATE_ID | DOUBLE | N | Person responsible for inserting the row |
CREATE_TASK | DOUBLE | Y | The task responsible for creating the row. |
ITEM_ID | DOUBLE | N | The internal item key for the item to be uploaded. |
ITEM_IDENTIFIER | VARCHAR(255) | N | The value passed through the interface to identify an item. |
ITEM_IDENTIFIER_TYPE | VARCHAR(40) | Y | The type of identifier that was passed in through the ITEM_IDENTIFIER field. Should be a valid display value from codeset 11000. |
ITEM_IDENTIFIER_TYPE_CD | DOUBLE | N | The code value for the identifier type. |
LOCATION | VARCHAR(100) | N | The display/alias value for the location. |
LOCATION_CD | DOUBLE | N | The code value for the location. |
LOCATOR | VARCHAR(60) | Y | The display/alias for the locator. |
LOCATOR_CD | DOUBLE | N | The code value for the locator. |
LOC_VIEW | VARCHAR(100) | Y | Refers to the HNAM Materials Mgmt location view to be used when validating locator names. |
LOC_VIEW_CD | DOUBLE | N | Location View CD |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
LOT_EXP_DT_TM | DATETIME | Y | The date/time a lot will expire. |
LOT_MANUF_DT_TM | DATETIME | Y | The date/time an item in the lot was manufactured. |
LOT_NUMBER_ID | DOUBLE | N | The lot this row relates to. |
LOT_NUMBER_TXT | VARCHAR(40) | Y | Character description of the lot number as defined by the manufacturer of the lot. |
MANUF_CD | DOUBLE | N | The manufacturer of the item. |
MANUF_NAME | VARCHAR(255) | Y | The manufacturer Name. |
ORGANIZATION | VARCHAR(100) | Y | The name of the organization. |
ORGANIZATION_ID | DOUBLE | N | The primary key for the organization. |
PKG_TYPE_CONV | DOUBLE | Y | The conversion factor for the package type. |
PKG_TYPE_ID | DOUBLE | N | The primary key for the package type. |
PKG_TYPE_UOM | VARCHAR(40) | Y | The unit-of-measure for the package type. |
PKG_TYPE_UOM_CD | DOUBLE | N | The code value for the unit-of-measure. |
PROCESS_FLAG | DOUBLE | N | This flag indicates the status of the current row. |
QOH_QTY | DOUBLE | Y | The amount of quantity on-hand to upload. |
QOH_TYPE | VARCHAR(40) | Y | Defaults to UNRESTRICTED |
QOH_TYPE_CD | DOUBLE | N | Defaults to UNRESTRICTED |
SEGMENT_IDENTIFIER | VARCHAR(10) | N | Identifies the type of upload. For QOH, it is ILQ. |
SEGMENT_VERSION | VARCHAR(10) | N | Identifies the version of the upload interface |
TRANSACTION_ID | DOUBLE | N | Primary Key |
UPDATE_RULE_FLAG | DOUBLE | Y | Future Functionality |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - MM_XFI_QOH
Child Column in MM_XFI_QOH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
LOT_NUMBER_ID | LOT_NUMBER_INFO | LOT_NUMBER_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
MANUF_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
MM_XF_ERROR_LOG
Column Section | Top of Page |
Table-level Detail
Description: | Item Location / Locator Interface Error Log |
Definition: | Contains errors for all Interface Transactions. |
Table Type: | ACTIVITY |
Column Detail - MM_XF_ERROR_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
ERROR_CD | DOUBLE | N | Code which specifies the error type of the Interface Transaction Error. |
ERROR_ID | DOUBLE | N | Primary Key |
FIELD_NAME | VARCHAR(40) | Y | Field Name |
INTERFACE_TYPE_CD | DOUBLE | N | Interface Type CD |
MSG | VARCHAR(400) | Y | Error Message |
PARENT_ENTITY_ID | DOUBLE | N | PARENT ENTITY ID |
PARENT_ENTITY_NAME | VARCHAR(40) | Y | PARENT ENTITY NAME |
SCRIPT_NAME | VARCHAR(40) | Y | Script Name |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
OBJECT_IDENTIFIER
Column Section | Top of Page |
Table-level Detail
Description: | OBJECT IDENTIFIER |
Definition: | Ties an object with its' identifiers. |
Table Type: | REFERENCE |
Column Detail - OBJECT_IDENTIFIER
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
IDENTIFIER_ID | DOUBLE | N | Foreign key to the identifier table. |
OBJECT_ID | DOUBLE | N | The value of the primary key of the table to which the row is related (i.e. item_id, instance_id) |
OBJECT_TYPE_CD | DOUBLE | N | The code value for the type of object. |
PARENT_ENTITY_ID | DOUBLE | Y | The value of the primary key of the table to which the row is related (i.e., item_id, instance_id, etc.) |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | The upper case name of the table to which this row is related (i.e., ITEM_DEFINITION, ITEM_INSTANCE) |
PRIMARY_IND | DOUBLE | Y | Indicates this identifier, for a specific identifier type, is primary. |
PRIMARY_NBR_IND | DOUBLE | Y | Indicates the primary number (ITEM_NBR or ITEM_NBR_SYS) for an item_master item. |
SEQUENCE | DOUBLE | Y | Used to prioritize vendor items. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VENDOR_MANF_CD | DOUBLE | N | Vendor or Manufacturer code, depending on the type of item. |