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.