Table Detail Report

MM_DISCREPANCY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Materials Management Discrepancy
Definition: Stores discrepencies between system calculated quantity on hand values and actual counts.
Table Type: ACTIVITY





Column Detail - MM_DISCREPANCY


Column Name Type Null? Definition
CLUSTER_CD DOUBLE N Cluster where the discrepancy was logged.
CREATE_DT_TM DATETIME N Date and time the discrepancy was generated.
CREATE_TZ DOUBLE N Time zone associated with CREATE_DT_TM.
FACILITY_CD DOUBLE N Facility where the discrepancy was logged.
LOCATION_CD DOUBLE N Location where the discrepancy was logged.
LOCATOR_CD DOUBLE N Locator where the discrepancy was logged.
MM_DISCREPANCY_ID DOUBLE N Unique, generated number that identifies a single row on the MM_DISCREPANCY table.
RESOLVED_COMMENT_TEXT_ID DOUBLE N Textual explanation of the resolution. May be 0.
RESOLVED_DT_TM DATETIME Y Date and time the discrepancy was resolved.
RESOLVED_PARENT_ENTITY_ID DOUBLE N Identifier of the inventory transaction line, item countback, or physical countback which was identified during resolution as causing the discrepancy.
RESOLVED_PARENT_ENTITY_NAME VARCHAR(32) N RESOLVED_PARENT_ENTITY_IDs associated table.
RESOLVED_PRSNL_ID DOUBLE N Personnel documenting the resolution of the discrepancy.
RESOLVED_REASON_CD DOUBLE N The reason identified that caused the discrepancy.
RESOLVED_TZ DOUBLE N The time zone associated with RESOLVED_DT_TM.
RXS_ITEM_COUNTBACK_ID DOUBLE N The countback that had a discrepancy.
STATUS_CD DOUBLE N The status of the discrepancy.
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.
WITNESS_PRSNL_ID DOUBLE N The Personnel that witnessed the documentation of the resolution of the discrepancy.



Relationship Detail - MM_DISCREPANCY


Child Column in MM_DISCREPANCY(FK) Parent Table Name Parent Column Name
Parents: CLUSTER_CD LOCATION LOCATION_CD
FACILITY_CD LOCATION LOCATION_CD
LOCATION_CD LOCATION LOCATION_CD
LOCATOR_CD LOCATION LOCATION_CD
RESOLVED_COMMENT_TEXT_ID LONG_TEXT LONG_TEXT_ID
RESOLVED_PRSNL_ID PRSNL PERSON_ID
WITNESS_PRSNL_ID PRSNL PERSON_ID
RXS_ITEM_COUNTBACK_ID RXS_ITEM_COUNTBACK RXS_ITEM_COUNTBACK_ID


MM_EXTRACT_DATA



Column Section Top of Page


Table-level Detail

Description: Supply Chain Extract Data
Definition: This table stores the data of several extracts that are performed in Upload manager (mmuploadmanager.exe)
Table Type: ACTIVITY





Column Detail - MM_EXTRACT_DATA


Column Name Type Null? Definition
EXTRACT_CONTENT_CLOB LONGTEXT Y The exact content that got qualified by performing data extracts in upload manager.
EXTRACT_TYPE_TXT VARCHAR(3) N Stores the type of extract that the user performs in upload manager. The extract types are IMM, QOH, ILC, ILS, ILL and IRT.
FILE_NAME VARCHAR(255) N Stores file names that gets created while extracting process is in place.
MM_EXTRACT_DATA_ID DOUBLE N Unique generated number that identifies a single row onthe MM_EXTRACT_DATA 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.


MM_INSTANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Instance
Definition: Stores item and equipment instance information for Supply Chain.
Table Type: REFERENCE





Column Detail - MM_INSTANCE


Column Name Type Null? Definition
ABS_EXP_DT_TM DATETIME Y Expiration Date as determined at place of origin.
ABS_EXP_TZ DOUBLE Y Time zone associated with the ABS_EXP_DT_TM column.
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.
CONTROL_IDENT VARCHAR(400) N Identifier assigned to an individual occurrence of an Item.
EXP_DT_TM DATETIME Y Stores the expiration date for the serial number
ITEM_ID DOUBLE N This column represents the item that this occurrence is a part of.
LOT_NUMBER_ID DOUBLE N Relevant lot number for a serial number.
MFR_CD DOUBLE N The manufacturer of the item. From the MANUFACTURER_ITEM table.
MFR_DT_TM DATETIME Y Stores the manufacturer date for the serial number
MM_INSTANCE_ID DOUBLE N Unique, generated number that identifies a single row on the MM_INSTANCE table.
MODEL_NBR_TXT VARCHAR(60) N %occurrent
ORGANIZATION_ID DOUBLE N The organization that owns this item instance.
PART_NBR_TXT VARCHAR(60) N The part number for this instance of an item.
STATUS_CD DOUBLE N The codified value that indicates the current status of the instance. Examples would be: Available, In Use, Out of Service.
STORAGE_LOCATION_CD DOUBLE N An instance has a location where it is kept when not in use. This location represents that storage location.
TRANS_INSTANCE_IND DOUBLE N Indicates whether the instance was created manually or was created by a transaction. If an instance was created manually the indicator will be set to "0". If an instance was created by a transaction then the indicator will be set to "1".
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_INSTANCE


Child Column in MM_INSTANCE(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
MFR_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in MM_INSTANCE (PK) Child Table Name Child Column Name
Children: MM_INSTANCE_ID MM_INSTANCE_TRANS_LINE_R MM_INSTANCE_ID
MM_XFI_INSTANCE MM_INSTANCE_ID
SN_PICKLIST_ITEM_DETAIL MM_INSTANCE_ID


MM_INSTANCE_TRANS_LINE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Instance Trans Line Relation
Definition: In MM_INSTANCE, the user can dispense the equipment master item with its serial number. This table can track all items that are dispensed with the serial number so it maintains the relationship between MM_INSTANCE and MM_TRANS_LINE.
Table Type: ACTIVITY





Column Detail - MM_INSTANCE_TRANS_LINE_R


Column Name Type Null? Definition
MM_INSTANCE_ID DOUBLE N The Instance that is related to this MM_TRANS_LINE row.
MM_INSTANCE_TRANS_LINE_R_ID DOUBLE N Unique, generated number that identifies a single row on the MM_INSTANCE_TRANS_LINE_R table.
MM_TRANS_LINE_ID DOUBLE N Identifies the row on MM_TRANS_LINE that is associated to this MM_INSTANCE value.
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_INSTANCE_TRANS_LINE_R


Child Column in MM_INSTANCE_TRANS_LINE_R(FK) Parent Table Name Parent Column Name
Parents: MM_INSTANCE_ID MM_INSTANCE MM_INSTANCE_ID
MM_TRANS_LINE_ID MM_TRANS_LINE MM_TRANS_LINE_ID


MM_ITEM_ORG_COST_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Organization Cost History
Definition: Stores history of costs that have been manually updated in the ITEM_LOCATION_COST table.
Table Type: REFERENCE





Column Detail - MM_ITEM_ORG_COST_HIST


Column Name Type Null? Definition
COST_TYPE_CD DOUBLE N The cost type code allows differentiation between average cost, current cost, last cost, etc.
CREATE_DT_TM DATETIME N The date and time that this row was created.
ITEM_ID DOUBLE N The item that had a cost changed.
LAST_UPDT_PRSNL_ID DOUBLE N The person that last updated this row.
MM_ITEM_ORG_COST_HIST_ID DOUBLE N Unique generated number that identifies a single row on the MM_ITEM_ORG_COST_HIST table.
ORG_LOCATION_CD DOUBLE N The location code for the organization that had a cost change.
ORIG_ORG_COST_AMT DOUBLE N The cost before the change.
PACKAGE_TYPE_ID DOUBLE N The base package type for the item.
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_MANUAL_ORG_COST_AMT DOUBLE N The changed cost amount.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MM_ITEM_ORG_COST_HIST


Child Column in MM_ITEM_ORG_COST_HIST(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
ORG_LOCATION_CD LOCATION LOCATION_CD
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID