Table Detail Report

MM_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Supply Chain Template
Definition: Generic header information about a group of items that will need to be counted during an inventory.
Table Type: REFERENCE





Column Detail - MM_TEMPLATE


Column Name Type Null? Definition
ADU_OP_FLAG DOUBLE N The criteria to use on ADU quantity when retrieving an item.
ADU_QTY DOUBLE N The threshold ADU to be retrieved.
CYCLE_CNT_TYPE_CD DOUBLE N The type of cycle count (random/reorder/custom).
ITEM_DISTRIBUTION_FLAG DOUBLE N Method used to distribute items into logical sheets.
ITEM_TEMPLATE_ID DOUBLE N The related template that contains a list of items.
LOCATION_CD DOUBLE N The location this template was created for.
LOOKBACK_DAYS DOUBLE N Number of days the system should look back to determine whether the item has been counted in past X days. Based off the number of days defined in this column, system would determine whether the items needs to be counted or not..
MAX_ITEM_QTY DOUBLE N Maximum number of items to be included in this count.
MM_TEMPLATE_ID DOUBLE N Unique, generated number that identifies a single row on the MM_TEMPLATE table.
SHEET_QTY DOUBLE N If item_distribution_flag = 2, this will determine the number of logical sheets created.
TEMPLATE_NAME VARCHAR(255) N The name of the inventory template.
TEMPLATE_NAME_KEY VARCHAR(255) N The alphanumeric uppercase value of template name.
TEMPLATE_NAME_KEY_A_NLS VARCHAR(1020) Y TEMPLATE_NAME_KEY_A_NLS column
TEMPLATE_NAME_KEY_NLS VARCHAR(512) N The NLS value associated with the column template_name_key.
TEMPLATE_TYPE_CD DOUBLE N The type of template that this row contains information about.
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.



Relationship Detail - MM_TEMPLATE


Child Column in MM_TEMPLATE(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
ITEM_TEMPLATE_ID MM_TEMPLATE MM_TEMPLATE_ID




Parent Column in MM_TEMPLATE (PK) Child Table Name Child Column Name
Children: MM_TEMPLATE_ID MM_CYCLE_CNT_FILTER MM_TEMPLATE_ID
MM_TEMPLATE ITEM_TEMPLATE_ID
MM_TEMPLATE_ITEM MM_TEMPLATE_ID


MM_TEMPLATE_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Supply Chain Template Item
Definition: An item that needs to be counted in an inventory cycle.
Table Type: REFERENCE





Column Detail - MM_TEMPLATE_ITEM


Column Name Type Null? Definition
ITEM_ID DOUBLE N An inventory item contained within a template.
ITEM_SEQ DOUBLE N The order of the item in the template.
MM_TEMPLATE_ID DOUBLE N The template that an item is defined for.
MM_TEMPLATE_ITEM_ID DOUBLE N Unique, generated number that identifies a single row on the MM_TEMPLATE_ITEM table.
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.



Relationship Detail - MM_TEMPLATE_ITEM


Child Column in MM_TEMPLATE_ITEM(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
MM_TEMPLATE_ID MM_TEMPLATE MM_TEMPLATE_ID


MM_TRANS_IDENTIFIER_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Identifier Relationship
Definition: Holds the barcode information for the performed transaction.
Table Type: ACTIVITY





Column Detail - MM_TRANS_IDENTIFIER_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
BARCODE_TXT VARCHAR(255) Y The text for the item read from the barcode.
LOT_NUMBER_ID DOUBLE Y The lot number that the trans_line is related to.
MM_TRANS_IDENTIFIER_RELTN_ID DOUBLE N Unique generated number that defines a single row on the MM_TRANS_IDENTIFIER_RELTN table.
MM_TRANS_LINE_ID DOUBLE Y The transaction line associated to this serial number, lot number, or item identifier.
SERIAL_NBR_TXT VARCHAR(255) Y Serial number of the item.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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_TRANS_IDENTIFIER_RELTN


Child Column in MM_TRANS_IDENTIFIER_RELTN(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID
MM_TRANS_LINE_ID MM_TRANS_LINE MM_TRANS_LINE_ID


MM_XFI_COST



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI COST
Definition: Intermediate inbound interface table for importing item cost. Data is moved from this table to ITEM_LOCATION_COST.
Table Type: REFERENCE





Column Detail - MM_XFI_COST


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N Determines the action to be taken for this row. (1-Update/Insert,...)
BATCH_GROUP_ID DOUBLE Y Grouper TRANSACTION_ID for a set of MM_XFI_COST rows in order to perform batch processing on a subset of rows.
BATCH_REF VARCHAR(100) Y User defined field to identify this particular upload batch.
CONTRIBUTOR VARCHAR(40) Y The contributor
CONTRIBUTOR_CD DOUBLE N The contributor
COST DOUBLE Y The cost of the item.
COST_TYPE VARCHAR(40) Y The cost type (Average,Last,...)
COST_TYPE_CD DOUBLE N The cost type.
CREATE_APPLCTX DOUBLE Y The application context responsible for inserting the row.
CREATE_DT_TM DATETIME Y The Date/Time this row was inserted.
CREATE_ID DOUBLE N The ID of the person responsible for inserting this row.
CREATE_TASK DOUBLE Y The task responsible for inserting this row.
ITEM_ID DOUBLE N The internal item identifier. Primary Key
ITEM_IDENTIFIER VARCHAR(255) Y The identifier that will be used to validate against (item number, upn, ndc,...)
ITEM_IDENTIFIER_TYPE VARCHAR(40) Y Identifies the type of identifier passed in.
ITEM_IDENTIFIER_TYPE_CD DOUBLE N Identifies the type of identifier passed in.
LOCATION VARCHAR(100) Y The location name to build the record for.
LOCATION_CD DOUBLE N The codevalue for the location
LOC_VIEW VARCHAR(100) Y Currently not used.
LOC_VIEW_CD DOUBLE N Currently not used.
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 The name of the organization in which the location resides.
ORGANIZATION_ID DOUBLE N Primary key for organization
PKG_TYPE_CONV DOUBLE Y The pack factor for the package type.
PKG_TYPE_ID DOUBLE N Primary key for package type
PKG_TYPE_UOM VARCHAR(40) Y The package type unit-of-measure.
PKG_TYPE_UOM_CD DOUBLE N The code value for the unit-of-measure.
PROCESS_FLAG DOUBLE N Indicates the import status of the row.
SEGMENT_IDENTIFIER VARCHAR(10) N Identifies the type of interface -- ILC
SEGMENT_VERSION VARCHAR(10) N The interface version
TRANSACTION_ID DOUBLE N Primary Key
UPDATE_RULE_FLAG DOUBLE Y Future use.
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_COST


Child Column in MM_XFI_COST(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_COST TRANSACTION_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID




Parent Column in MM_XFI_COST (PK) Child Table Name Child Column Name
Children: TRANSACTION_ID MM_XFI_COST BATCH_GROUP_ID
MM_XFI_COST_BATCH BATCH_GROUP_ID


MM_XFI_COST_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interface CostBatch
Definition: Used to group a set of MM_XFI_COST rows for batch processing.
Table Type: ACTIVITY





Column Detail - MM_XFI_COST_BATCH


Column Name Type Null? Definition
BATCH_GROUP_ID DOUBLE N 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_COST_BATCH_ID DOUBLE N Unique generated number that identifies a single row on the MM_XFI_COST_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_COST_BATCH


Child Column in MM_XFI_COST_BATCH(FK) Parent Table Name Parent Column Name
Parents: BATCH_GROUP_ID MM_XFI_COST TRANSACTION_ID