Table Detail Report

MM_XFI_INSTANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interface Instance
Definition: This table will hold item's instance data sent from 3rd party system. Data in this table is moved to MM_INSTANCE.
Table Type: REFERENCE





Column Detail - MM_XFI_INSTANCE


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N Determines instance upload action -- create / update / delete.1 for create or update, 2 for create only, 3 for update only and 5 for delete."
BATCH_GROUP_ID DOUBLE Y Grouper TRANSACTION_ID for a set of MM_XFI_INSTANCE rows in order to perform batch processing on a subset of rows.
CONTRIBUTOR_CD DOUBLE N Foreign contributor code value for instance sync interface.
CONTRIBUTOR_TXT VARCHAR(40) Y Contributor can be the foreign system name if being used as an interface. Used to populate IDENTIFIER.Contributor_cd
CONTROL_IDENT VARCHAR(400) N Identifier assigned to an individual occurrence of an item.Used to populate MM_INSTANCE.control_ident and IDENTIFIER.value
CREATE_DT_TM DATETIME N Contains the date and time the instance was created.
INSTANCE_IDENT VARCHAR(400) N Identifier assigned to an individual occurrence of an item.
INSTANCE_IDENT_ID DOUBLE N Identifier assigned to an individual occurrence of an item.
ITEM_ID DOUBLE N This column represents the item that this occurrence is a part of.
ITEM_IDENTIFIER VARCHAR(255) Y Item identifier passed through the interface or upload to identify an item.Used to populate MM_INSTANCE.item_id
ITEM_IDENTIFIER_TYPE_CD DOUBLE N Identifies the type of identifier passed in.
ITEM_IDENTIFIER_TYPE_TXT VARCHAR(40) Y Item identifier type passed through the interface or upload to identify an item. String in this column will be resolved to a corresponding code value.
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.
MFR_CD DOUBLE N Codified value of the resolved manufacturer.
MFR_NAME VARCHAR(60) Y The manufacturer of the item.Used to populate MM_INSTANCE.mfr_cd
MM_INSTANCE_ID DOUBLE N An ID identifier assigned to an individual occurrence of an item.
MODEL_NBR_TXT VARCHAR(60) Y The model number of this occurrence of an item. Used to populate MM_INSTAINCE.model_nbr_txt
ORGANIZATION_ID DOUBLE N The identifier for the organization where the object is stored.
ORGANIZATION_NAME VARCHAR(100) N The organization where the instance is stored.
PART_NBR_TXT VARCHAR(60) Y The model number of this occurrence of an item. Used to populate MM_INSTANCE.part_nbr_txt
PROCESS_FLAG DOUBLE N Defines the state of the row in the upload process.
SEGMENT_IDENTIFIER VARCHAR(10) N Identifies type of upload. Enter EII for equipment item instance upload.
SEGMENT_VERSION VARCHAR(10) N Identifies version of the upload interface.
SERIAL_NBR_ID DOUBLE N Identifier id for the serial number
SERIAL_NBR_TXT VARCHAR(255) Y Identifier assigned to an instance of an item. Used to populate IDENTIFIER.value
STATUS_CD DOUBLE N Code value that indicates the current status of the instance. Examples: Available, In use, Out of service.
STATUS_DISPLAY_TXT VARCHAR(100) Y The status as displayed to the user.
STORAGE_LOCATION_CD DOUBLE N An instance has a location where it is kept when not in use. This location represents that storage location.
STORAGE_LOCATION_TXT VARCHAR(100) Y An instance has a location where it is kept when not in use. This location represents that storage location. Used to populate MM_INSTANCE.storage_location_cd
TRANSACTION_ID DOUBLE N Unique, generated number that identifies a single row on the MM_XFI_INSTANCE 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_INSTANCE


Child Column in MM_XFI_INSTANCE(FK) Parent Table Name Parent Column Name
Parents: INSTANCE_IDENT_ID IDENTIFIER IDENTIFIER_ID
SERIAL_NBR_ID IDENTIFIER IDENTIFIER_ID
ITEM_ID ITEM_DEFINITION ITEM_ID
STORAGE_LOCATION_CD LOCATION LOCATION_CD
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
MM_INSTANCE_ID MM_INSTANCE MM_INSTANCE_ID
BATCH_GROUP_ID MM_XFI_INSTANCE TRANSACTION_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
MFR_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in MM_XFI_INSTANCE (PK) Child Table Name Child Column Name
Children: TRANSACTION_ID MM_XFI_INSTANCE BATCH_GROUP_ID
MM_XFI_INSTANCE_BATCH BATCH_GROUP_ID


MM_XFI_INSTANCE_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interface Instance Batch
Definition: Used to group a set of MM_XFI_INSTANCE rows for batch processing.
Table Type: ACTIVITY





Column Detail - MM_XFI_INSTANCE_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_INSTANCE_BATCH_ID DOUBLE N Unique generated number that identifies a single row on the MM_XFI_INSTANCE_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_INSTANCE_BATCH


Child Column in MM_XFI_INSTANCE_BATCH(FK) Parent Table Name Parent Column Name
Parents: BATCH_GROUP_ID MM_XFI_INSTANCE TRANSACTION_ID


MM_XFI_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI ITEM
Definition: Intermediate inbound interface table for importing an item. Data is moved from this table to the following tables: ITEM_DEFINITION, ITEM_MASTER,OBJECT_IDENTIFIER, IDENTIFIER, OBJECT_IDENTIFIER_INDEX
Table Type: REFERENCE





Column Detail - MM_XFI_ITEM


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y Action flag for the type of action to take
ACTIVATE_ITEM_IND DOUBLE Y Indicator used to determine if the item should be reactivated if it is currently inactive. 0 = Do not reactivate, 1= reactivate item
ADDITIONAL_AMOUNT_ACTION_FLAG DOUBLE N This flag indicates whether to create, update, or delete the additional amount of an item.
ADDITIONAL_AMOUNT_TYPE VARCHAR(40) N Contains the display, description or CDF_Meaning for additional amount_type_cd
ADDITIONAL_AMOUNT_TYPE_CD DOUBLE N The code value for additional amount
BASE_PKG_CONV DOUBLE Y Base Package Qty. It is always assumed to be "1".
BASE_PKG_TYPE_ID DOUBLE N The primary key for the base package type.
BASE_PKG_UOM VARCHAR(40) Y The unit-of-measure for the base package type.
BASE_PKG_UOM_CD DOUBLE N The code value for the base pkg type unit-of-measure.
BATCH_GROUP_ID DOUBLE Y Grouper TRANSACTION_ID for a set of MM_XFI_ITEM rows in order to perform batch processing on a subset of rows.
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.
CHARGEABLE_IND DOUBLE N Indicates whether the item is chargeable or not.
CHARGE_NUMBER_ID DOUBLE N The category of the charge for the item. This identifier would be utilized by the charge services team on the price schedule setup to charge the item.
CHARGE_NUMBER_TXT VARCHAR(40) N Additional identifier for the item. Used by the charge services team on the price schedule setup.
CLASS_INSTANCE_CD DOUBLE N The code value for this particular instance of a classification.
CLASS_INSTANCE_MEAN VARCHAR(50) N The Type of Class Instance and stores the cdf_meaning value of class.
CLASS_NODE_DESC VARCHAR(100) N The description of the Class.
CLASS_NODE_ID DOUBLE N The class node for this item
CLASS_RELTN_ACTION_FLAG DOUBLE N Stores the type of relation between class and item.0 - No relation Action; 1 - Create class relation; 3 - Update class relation; 5 - Delete class relation
COMPONENT_IND DOUBLE Y Indicates whether or not this item contains components. From ITEM_DEFINITION
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.
COST_CENTER VARCHAR(40) Y Cost center value
COST_CENTER_CD DOUBLE N The Code Value of the cost center associated with the item.
COUNTABLE_IND DOUBLE Y Countable Indicator.
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time when the row was inserted
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) who inserted the row in to the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
CRITICAL_IND DOUBLE Y Indicates if this item is critical in order for a procedure to be performed. From ITEM_MASTER
EQUIPMENT_IND DOUBLE Y Indicates if this item is a piece of equipment.
FDA_REPORTABLE_IND DOUBLE Y Indicates this item is reportable to the FDA. From ITEM_MASTER
IMPLANT_TYPE_CD DOUBLE N If this item is an implant, indicates the type of implant.
IMPLANT_TYPE_TXT VARCHAR(100) Y If this item is an implant, contains the textual description of the implant type.
ITEM_ALIAS VARCHAR(40) Y The name the item is known by outside of Millennium.
ITEM_ALIAS_ID DOUBLE N Identifier ID for the Item Alias Identifier.
ITEM_CLINICAL_DESC VARCHAR(255) Y The clinical description for the item
ITEM_CLINICAL_DESC_ID DOUBLE N Reference to the IDENTIFIER table where the clinical description of the item is stored.
ITEM_DESC VARCHAR(255) Y Item Description Identifier.
ITEM_DESC_ID DOUBLE N %Descritio
ITEM_IDENTIFIER VARCHAR(255) Y A string value that will be resolved to an Item in Millennium.
ITEM_IDENTIFIER_TYPE VARCHAR(40) Y This is a string that will be converted to a corresponding code value. For example, if "Item Number" is entered, then item_identifier_type_cd will be resolved to a code value with CDF meaning = "Item Number".
ITEM_IDENTIFIER_TYPE_CD DOUBLE N Item Identifier Type CD.
ITEM_MASTER_ID DOUBLE N Item Master ID.
ITEM_NBR VARCHAR(255) Y Item Number Identifier.
ITEM_NBR_ID DOUBLE N Identifier ID for the Item Number.
ITEM_ORG_RELTN_FLAG DOUBLE N Identifies the action necessary for relating the item to an organization.
ITEM_SHORT_DESC VARCHAR(255) Y Item Short Description Identifier.
ITEM_SHORT_DESC_ID DOUBLE N Identifier ID for the Item Short Description.
LATEX_IND DOUBLE Y Indicator which specifies whether the item is latex or not.
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_TRACKING_IND DOUBLE N Indicates if the item quantity is tracked at lot level.
MAX_TEMP_AMT_TXT VARCHAR(50) N %tempratur
MFR VARCHAR(60) Y Manufacturer Name
MFR_CD DOUBLE N The manufacturer of the item. From the MANUFACTURER_ITEM table.
MFR_ITEM_BRAND_NAME VARCHAR(255) Y Manufacturer Item Brand Name Identifier.
MFR_ITEM_BRAND_NAME_ID DOUBLE N Identifier ID for the Manufacturer Item Brand Name.
MFR_ITEM_DESC VARCHAR(255) Y Manufacturer Item Description Identifier.
MFR_ITEM_DESC_ID DOUBLE N Identifier ID for the Manufacturer Item Description Identifier.
MFR_ITEM_ID DOUBLE N Manufacturer Item ID.
MFR_ITEM_NBR VARCHAR(40) Y Manufacturer Item Number Identifier.
MFR_ITEM_NBR_ID DOUBLE N Identifier ID for the Manufacturer Item Number Identifier.
MFR_ITEM_TRADE_NAME VARCHAR(255) Y Manufacturer Item Trade Name Identifier.
MFR_ITEM_TRADE_NAME_ID DOUBLE N Identifier ID for the Manufacturer Item Trade Name Identifier.
MIN_TEMP_AMT_TXT VARCHAR(50) N %tempratur
MULTI_LOT_TRANSFER_IND DOUBLE N Indicates if the a transfer is for one lot or multiple lots. 0 - single lot, 1 - multiple lots
ORGANIZATION VARCHAR(100) N Free text organization name
ORGANIZATION_ID DOUBLE N Organization associated to the price.
PKG_TYPE_ACTION_FLAG DOUBLE Y Package Action Flag. Defaults to 2.
PKG_TYPE_CONV DOUBLE Y Package Type Qty.
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 package type unit-of-measure.
PRE_EXP_DATE_PERIOD_NBR DOUBLE N When to alert the user that the product should be used before expiring.
PRE_EXP_DATE_UOM_CD DOUBLE N The unit of measure associated to PRE_EXP_DATE_PERIOD_NBR.
PRE_EXP_DATE_UOM_TXT VARCHAR(40) Y Text value of unit of measure.
PRICE DOUBLE Y Price for the Vendor Item package type.
PRICE_CONTRACT_DESC VARCHAR(100) Y A free text description field that may be used to describe the associated contract. From ITEM_PRICE
PRICE_EFF_DT_TM DATETIME Y Date & Time when that Price will be Effective .
PRICE_EXP_DT_TM DATETIME Y Date & Time when that Price will be Expired.
PRICE_ID DOUBLE N The primary key for the price..
PRICE_RULE_FLAG DOUBLE Y Price Rule Flag value
PRICE_TYPE VARCHAR(40) Y Price Type value.
PRICE_TYPE_CD DOUBLE N Price Type Code Value.
PROCESS_FLAG DOUBLE Y Defines the state of the row in the upload process.
QUICKADD_IND DOUBLE Y % proces %
RELATION_ACTION_FLAG DOUBLE Y Used to create/delete the relationship between item master and its vendor and manufacturer item.
REPLACEMENT_UPN VARCHAR(40) Y Replacement UPN Identifier.
REPLACEMENT_UPN_ID DOUBLE N %Replacmen
REUSABLE_IND DOUBLE Y Indicates if this item is reusable or disposable.
SAFETY_CHECK_IND DOUBLE Y Does this item require a safety check prior to use? Yes/No
SCHEDUABLE_IND DOUBLE Y Indicates that this item can be scheduled as a resource from the scheduling application.
SEGMENT_IDENTIFIER VARCHAR(10) Y Indicates the upload type (item upload, item location upload, etc.)
SEGMENT_VERSION VARCHAR(10) Y The version of the upload.
SHELF_LIFE DOUBLE Y Shelf Life of an Item.
SHELF_LIFE_UOM VARCHAR(40) Y The unit of measure for the shelf life.
SHELF_LIFE_UOM_CD DOUBLE N The unit of measure code value for the Shelf Life.
STERILIZATION_REQUIRED_IND DOUBLE Y Indicates if this item needs sterilization prior to use. From ITEM_MASTER.
STORAGE_REQUIREMENT VARCHAR(40) Y Describes how to store an item. From code set 11020.
STORAGE_REQUIREMENT_CD DOUBLE N The code value for the Storage Requirement.
SUBSTITUTION_IND DOUBLE Y Indicator which specifies whether the item is under substitution.
SUB_ACCOUNT VARCHAR(40) Y Identifies, along with cost_center, which department in the organization is incurring the expense.
SUB_ACCOUNT_CD DOUBLE N The number of the sub account.
TAX_VALUE DOUBLE N The percent or amount value for the tax
TAX_VALUE_FLAG DOUBLE N Indicates whether the tax value is a percentage or fixed amount
TEMP_UOM_CD DOUBLE N The unit of measure the temperature columns represent.
TEMP_UOM_TXT VARCHAR(100) Y The unit of measure the temperature columns represent.
TRACK_COMPONENT_USAGE_IND DOUBLE Y Defines whether or not usage is captured for each component in a pack/set. From ITEM_DEFINITION
TRANSACTION_ID DOUBLE N Unique,generated number that identifies a single row on the MM_XFI_ITEM table.
UDI_EXP_DATE_IND DOUBLE N Indicates whether the UDI is tracked by expiration date
UDI_LOT_NBR_IND DOUBLE N Indicates whether the UDI is tracked by lot number
UDI_MFR_DATE_IND DOUBLE N Indicates whether the UDI is tracked by manufacturer date
UDI_SERIAL_NBR_IND DOUBLE N Indicates whether the UDI is tracked by serial number
UPDATE_RULE_FLAG DOUBLE Y Update Rule Flag. (For 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.
UPN VARCHAR(40) Y UPN Identifier.
UPN_ID DOUBLE N Identifier ID for the UPN.
UPN_SALABLE_BY_DIST_IND DOUBLE Y Indicates whether or not this UPN specific item & package is salable by the vendor. From IDENTIFIER
UPN_SALABLE_BY_MFR_IND DOUBLE Y Indicates whether or not this UPN specific item & package is salable by the manufacturer. From IDENTIFIER
USAGE_UOM_CD DOUBLE N Holds CD value for the usage unit of measurement text.
USAGE_UOM_TXT VARCHAR(250) Y Holds the usage unit of measurement text
VENDOR VARCHAR(60) Y Name of the vendor for this item.
VENDOR_CD DOUBLE N The code value for the Vendor.
VENDOR_ITEM_DESC VARCHAR(255) Y Vendor Item Description Identifier.
VENDOR_ITEM_DESC_ID DOUBLE N Identifier ID for the Vendor Item Description.
VENDOR_ITEM_ID DOUBLE N Foreign Key for the Vendor Item
VENDOR_ITEM_NBR VARCHAR(40) Y Vendor Item Number Identifier.
VENDOR_ITEM_NBR_ID DOUBLE N Identifier ID for the Vendor Item Number.



Relationship Detail - MM_XFI_ITEM


Child Column in MM_XFI_ITEM(FK) Parent Table Name Parent Column Name
Parents: CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
CHARGE_NUMBER_ID IDENTIFIER IDENTIFIER_ID
ITEM_ALIAS_ID IDENTIFIER IDENTIFIER_ID
ITEM_CLINICAL_DESC_ID IDENTIFIER IDENTIFIER_ID
ITEM_DESC_ID IDENTIFIER IDENTIFIER_ID
ITEM_NBR_ID IDENTIFIER IDENTIFIER_ID
ITEM_SHORT_DESC_ID IDENTIFIER IDENTIFIER_ID
MFR_ITEM_BRAND_NAME_ID IDENTIFIER IDENTIFIER_ID
MFR_ITEM_DESC_ID IDENTIFIER IDENTIFIER_ID
MFR_ITEM_NBR_ID IDENTIFIER IDENTIFIER_ID
MFR_ITEM_TRADE_NAME_ID IDENTIFIER IDENTIFIER_ID
REPLACEMENT_UPN_ID IDENTIFIER IDENTIFIER_ID
UPN_ID IDENTIFIER IDENTIFIER_ID
VENDOR_ITEM_DESC_ID IDENTIFIER IDENTIFIER_ID
VENDOR_ITEM_NBR_ID IDENTIFIER IDENTIFIER_ID
ITEM_MASTER_ID ITEM_DEFINITION ITEM_ID
MFR_ITEM_ID ITEM_DEFINITION ITEM_ID
VENDOR_ITEM_ID ITEM_DEFINITION ITEM_ID
PRICE_ID ITEM_PRICE ITEM_PRICE_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
BATCH_GROUP_ID MM_XFI_ITEM TRANSACTION_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
BASE_PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID




Parent Column in MM_XFI_ITEM (PK) Child Table Name Child Column Name
Children: TRANSACTION_ID MM_XFI_ITEM BATCH_GROUP_ID
MM_XFI_ITEM_BATCH BATCH_GROUP_ID


MM_XFI_ITEMLOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interface Item Location
Definition: Interface Item Location table. Data is moved from this table to these tables: ITEM_CONTROL_INFO, AQUIREMENT_INFO, QUANTITY_REQUIREMENTS, STORED_AT
Table Type: REFERENCE





Column Detail - MM_XFI_ITEMLOC


Column Name Type Null? Definition
ABC_CLASS CHAR(1) Y The ABC classification for this item at this location.
ABC_CLASS_CD DOUBLE N The ABC classification for this item at this location.
ACC_STOCKOUT_FREQ DOUBLE Y The acceptable stockout frequency which is allowed at this location
ACTION_FLAG DOUBLE Y Action flag for the action
AVG_DAILY_USAGE DOUBLE Y The average quantity utilized for the item/location
AVG_LEAD_TIME DOUBLE Y The average number of days it takes the vendor to ship the item
AVG_WEEKS_ORDER_QTY DOUBLE Y %Avearge%
BATCH_REF VARCHAR(100) Y The batch reference for the upload
CONSIGNMENT_IND DOUBLE Y Indicator utilized to depict if the item is stored as consignment at the location
CONTRIBUTOR VARCHAR(40) Y Foreign contributor can be the foreign system name if being used as an interface
CONTRIBUTOR_CD DOUBLE N The foreign contributor for the item/location upload.
COST_CENTER VARCHAR(40) Y The cost center associated with the item.
COST_CENTER_CD DOUBLE N The cost center associated with the item.
CREATE_APPLCTX DOUBLE N The application context number from the record info block.
CREATE_DT_TM DATETIME N 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 N The registered (assigned) task number for the process that inserted the row.
ECONOMIC_ORDER_QTY DOUBLE Y The economic order quantity for the item at this location
FILL_LOCATION_CD DOUBLE N The location where the item will be replenished (filled) from.
FILL_LOCATION_NAME VARCHAR(100) Y The name of the location where the item will be replenished (filled) from.
FIXED_ORDER_QTY DOUBLE N %Replemish
ITEM_ID DOUBLE N ID value of the Item
ITEM_IDENTIFIER VARCHAR(255) Y Identifier used to resolve to an item in millennium
ITEM_IDENTIFIER_TYPE VARCHAR(40) Y The type of identifier being resolved too
ITEM_IDENTIFIER_TYPE_CD DOUBLE N Item Identifier Type CD
LOCATION VARCHAR(100) Y Location where the item exists.
LOCATION_CD DOUBLE N The location the item is being assigned
LOCATOR_QTY DOUBLE N The quantity that can be stored in an individual locator.
LOCATOR_TYPE VARCHAR(40) N Free text description of the type of locator where the item is being stored.
LOCATOR_TYPE_CD DOUBLE N The type of locator where the item is being stored.
LOCK_IND DOUBLE N Indicator used to determine if the item can be removed from the location. this only applies to RxStation locations.
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_TRACKING_LEVEL VARCHAR(40) Y The level at which lots are tracked at this location.
LOT_TRACKING_LEVEL_CD DOUBLE N The level at which lots are tracked at this location.
MAX_DAYS_ADU DOUBLE Y Maximum number of days that the average daily usage is based upon
MAX_LEVEL DOUBLE Y Maximum quantity of the item at the location
MIN_DAYS_ADU DOUBLE Y Minimum number of days that the average daily usage is based upon
MIN_LEVEL DOUBLE Y minimum quantity of the item at the location
ORGANIZATION VARCHAR(100) Y The organization for the location
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PRIMARY_VENDOR VARCHAR(100) Y The vendor that this item is usually ordered from.
PRIMARY_VENDOR_CD DOUBLE N The vendor that this item is usually ordered from.
PRIMARY_VENDOR_ITEM_ID DOUBLE N Primary vendor item that will be used to order the item
PRIMARY_VENDOR_ITEM_TXT VARCHAR(255) N Primary vendor catalog number for a location that will be used to order the item (text representation of number)
PROCESS_FLAG DOUBLE Y The process flag will reflect the status of the upload record
PRODUCT_ORIGIN VARCHAR(40) Y The free text description of the origin of the product
PRODUCT_ORIGIN_CD DOUBLE N The code value for the origin of the product
RECALC_METHOD VARCHAR(40) Y Method used to calculate reorder quantities
RECALC_METHOD_CD DOUBLE N Method used to calculate reorder quantities
REORDER_PKG_TYPE_CONV DOUBLE Y The reorder package type pack factor
REORDER_PKG_TYPE_ID DOUBLE N The primary key for the reorder package type ID
REORDER_PKG_TYPE_UOM VARCHAR(40) Y The free text for the reorder package type unit of measure
REORDER_PKG_TYPE_UOM_CD DOUBLE N The code value for the reorder package type unit of measure
REORDER_POINT DOUBLE Y Quantity when the item will qualify to be reordered
REPLENISHMENT_TYPE VARCHAR(40) Y The free text for the method of replenishment used for this item/location
REPLENISHMENT_TYPE_CD DOUBLE N The code value for the method of replenishment used for this item/location
SAFETY_STOCK_QTY DOUBLE Y The quantity of safety stock defined for the item at this location
SEASONAL_ITEM_IND DOUBLE Y Indicator used to determine if the item is considered seasonal
SEGMENT_IDENTIFIER VARCHAR(10) Y The segment identifier of the upload
SEGMENT_VERSION VARCHAR(10) Y The segment version of the upload
STOCK_PKG_TYPE_CONV DOUBLE Y The stock package type pack factor
STOCK_PKG_TYPE_ID DOUBLE N The package type in which this item is stocked.
STOCK_PKG_TYPE_UOM VARCHAR(40) Y Free text of the items stock package type
STOCK_PKG_TYPE_UOM_CD DOUBLE N The item's stock package type code value
STOCK_TYPE_IND DOUBLE Y Indicates the stock type for an item.
SUB_ACCOUNT VARCHAR(40) Y Free text of the items sub account
SUB_ACCOUNT_CD DOUBLE N The item's sub account code value
SYSCALC_ABC_IND DOUBLE Y Indicator to determine if the ABC classification will be calculated by the system.
SYSCALC_EOQ_IND DOUBLE Y Indicator to determine if the economic order quantity will be calculated by the system
SYSCALC_PARLEVEL_IND DOUBLE Y Indicator to determine if the PAR level will be calculated by the system
SYSCALC_REORDER_POINT_IND DOUBLE Y Indicator to determine if the reorder point will be calculated by the system
SYSCALC_SAFETY_STOCK_IND DOUBLE Y Indicator to determine if the safety stock will be calculated by the system
TRACK_INSTANCE_IND DOUBLE Y Indicates whether or not this location tracks instances of the item. Stored permanently in ITEM_CONTROL_INFO.INSTANCE_IND.
TRANSACTION_ID DOUBLE N Primary Key
UPDATE_RULE_FLAG DOUBLE Y The flag used to determine updating rules
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_XFI_ITEMLOC


Child Column in MM_XFI_ITEMLOC(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
PRIMARY_VENDOR_ITEM_ID ITEM_DEFINITION ITEM_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
REORDER_PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
STOCK_PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID


MM_XFI_ITEM_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interface Item Batch
Definition: Used to group a set of MM_XFI_ITEM rows for batch processing.
Table Type: ACTIVITY





Column Detail - MM_XFI_ITEM_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_ITEM_BATCH_ID DOUBLE N Unique generated number that identifies a single row on the MM_XFI_ITEM_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_ITEM_BATCH


Child Column in MM_XFI_ITEM_BATCH(FK) Parent Table Name Parent Column Name
Parents: BATCH_GROUP_ID MM_XFI_ITEM TRANSACTION_ID