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 |