Table Detail Report

MM_XFI_REQ_FILL



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI REQ FILL
Definition: Table used to store incoming Requisition Fill interface line transactions. Data is moved from this table to DISTRIBUTION and REQUISITION.
Table Type: REFERENCE





Column Detail - MM_XFI_REQ_FILL


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y Action flag indicating the action to take place on the transaction.
AUTO_COMMIT_IND DOUBLE Y This field indicates whether to commit the distribution or not.
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.
CONTRIBUTOR VARCHAR(40) Y Contributor used to resolve code value alias
CONTRIBUTOR_CD DOUBLE N Contributor used to resolve code value alias
CREATE_APPLCTX DOUBLE Y Application which created this row
CREATE_DT_TM DATETIME Y The date/time this entry was created.
CREATE_ID DOUBLE N ID of user who created this row
CREATE_TASK DOUBLE Y Task which created this row
EXTENDED_COST DOUBLE Y Extended cost of the item quantity.
FILL_PACK_FACTOR DOUBLE Y The filled packaging pack factor.
FILL_QTY DOUBLE Y The filled quantity.
FILL_UOM VARCHAR(20) Y The filled unit of measure.
FILL_UOM_CD DOUBLE N The code value for the fill unit of measure.
FOREIGN_DIST_NBR VARCHAR(20) Y The distribution number from the foreign system.
FROM_LOCATION VARCHAR(60) Y Holds the fill location specified on the requisition.
FROM_LOCATION_CD DOUBLE N Code for the fill location on the requisition.
ITEM_IDENTIFIER VARCHAR(255) Y Identifier used to resolve to an item_id.
ITEM_IDENTIFIER_TYPE VARCHAR(40) Y Type of Identifier being used to resolve an item.
ITEM_IDENTIFIER_TYPE_CD DOUBLE N Code Value of the item identifier type used to resolve an item.
ITEM_MASTER_ID DOUBLE N Foreign key to the item_master table.
LINE_ITEM_ID DOUBLE N Foreign key to the line_item table.
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.
MISC_CD DOUBLE N Miscellaneous Account Codes
MISC_CODE VARCHAR(40) Y Unused at this time.
ORGANIZATION VARCHAR(100) Y The name of the organization on the requisition.
ORGANIZATION_ID DOUBLE N The identifier of the organization on the requisition.
PACKAGE_TYPE_ID DOUBLE N Foreign key to the package_type table.
PROCESS_FLAG DOUBLE Y Process flag indicating the stage of the interface process.
PROJECT_CD DOUBLE N Project Code Value
PROJECT_CODE VARCHAR(60) Y Unused at this time.
REQUISITION_ID DOUBLE N Foreign key to the requisition table.
REQ_IDENTIFIER VARCHAR(40) Y The requisition number or requisition alias number. Used to resolve to a requisition_id.
REQ_LINE_NBR DOUBLE Y The line number from the requisition.
SEGMENT_IDENTIFIER VARCHAR(10) Y Identifies the type of interface
SEGMENT_VERSION VARCHAR(10) Y The segment version of the upload
SERIAL_NUMBER VARCHAR(40) Y Serial Number.
TO_LOCATION VARCHAR(60) Y The requesting location on the requisition.
TO_LOCATION_CD DOUBLE N The requesting location code on the requisition.
TRANSACTION_ID DOUBLE N Primary Key
TRANSFER_FLAG DOUBLE N Used to determine whether an average cost is calculated at the fill location.
UNIT_COST DOUBLE Y Unit cost of the item.
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_REQ_FILL


Child Column in MM_XFI_REQ_FILL(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in MM_XFI_REQ_FILL (PK) Child Table Name Child Column Name
Children: TRANSACTION_ID MM_XFI_REQ_FILL_LOT TRANS_HEADER_ID


MM_XFI_REQ_FILL_LOT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interface Requisition Fill Lot
Definition: Interface staging table to store the lot information associated to a fill interface transaction. Data is moved from this table to LOT_NUMBER_INFO and LOT_NUMBER_LOCATION_INFO.
Table Type: REFERENCE





Column Detail - MM_XFI_REQ_FILL_LOT


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.
ACTION_FLAG DOUBLE N Used to determine if the system should create lots that don't already exist.
CONTRIBUTOR_CD DOUBLE N Contributor Source Code Value
EXP_DT_TM DATETIME Y The date/time the lot expires.
INCREASE_IND DOUBLE N Used to determine if the lot quantity is an increase or decrease. 0 = decrease, 1 = increase
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_NUMBER VARCHAR(40) N A string value that will be used to resolve against a lot number in Millennium
LOT_NUMBER_ID DOUBLE N Associated lot number information
LOT_QTY DOUBLE N Number of items in the lot.
MFR_CD DOUBLE N Codified value of the resolved manufacturer.
MFR_DT_TM DATETIME Y Date/time the lot was manufactured.
MFR_TXT VARCHAR(60) N A string value that will be resolved to a manufacturer in Millennium.
PROCESS_FLAG DOUBLE N Defines the state of the row in the upload process.
TRANSACTION_ID DOUBLE N Primary key to the table.
TRANS_HEADER_ID DOUBLE N Foreign key to the MM_XFI_REQ_FILL table. Used to link the parent record on MM_XFI_REQ_FILL to the child lots.
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_REQ_FILL_LOT


Child Column in MM_XFI_REQ_FILL_LOT(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
TRANS_HEADER_ID MM_XFI_REQ_FILL TRANSACTION_ID


REQUISITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Requisition Header/ Template Header
Definition: Table used to hold requisition header and template header information
Table Type: REFERENCE





Column Detail - REQUISITION


Column Name Type Null? Definition
ATTENTION VARCHAR(100) Y A string passed as an attention while creating a requisition.
COMMIT_DT_TM DATETIME Y Date/Time when the requisition was committed.
COMPLETE_DT_TM DATETIME Y Date and time the requisition was completed.
CONFIRMED_BY VARCHAR(100) Y *** OBSOLETE ***
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 inserted.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
DELIVERY_DT_TM DATETIME Y Date and time the requisition was created.
DELIVER_TO_LOCATION_CD DOUBLE N *** OBSOLETE ***
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.
OMF_SUCCESS_IND DOUBLE N The value of 0 or 1 indicates the success or failure of the respective OMF table update. 1 indicates update to OMF table was successful and 0 indicates failure.
PICK_LIST_PRINT_DT_TM DATETIME Y Date/Time when the pick list (report) was printed.
REFERENCE VARCHAR(40) Y *** OBSOLETE ***
REQUISITION_ID DOUBLE N Unique, generated number that identifies a single row on the REQUISITION table.
REQ_ALIAS_ID DOUBLE N Requisition alias number is used to identify the MMIS matching requisition number with the one in the Procure system.
REQ_LOCATION_CD DOUBLE N The location which is requesting replenishment.
REQ_NBR VARCHAR(40) Y Requisition Number (e.g. 12345-6789)
REQ_NBR_KEY VARCHAR(40) Y Key format field associated to the Requisition Number.
REQ_NBR_KEY_A_NLS VARCHAR(160) Y Stores the corresponding non-English character set values for the req_nbr_Key column. Used to sort correctly internationally.
REQ_NBR_KEY_NLS VARCHAR(82) Y Internationalized Requisition Nbr Key
REQ_TYPE_CD DOUBLE N Holds the code for different requisition types.
RUSH_IND DOUBLE Y This indicator will allow for us to filter on rush requisitions and distributions.
SERVICE_RESOURCE_CD DOUBLE N *** OBSOLETE ***
SHIP_TO_LOCATION_CD DOUBLE N *** OBSOLETE ***
STATUS_CD DOUBLE N Indicates the requisition status. Possible values: Closed, Pendapproval, Committed, Pendcommit, Open, Rejected.
STATUS_DT_TM DATETIME Y The status date and time is used to identify the date and time when the requisition header status is set to "OPEN".
TEMPLATE_ID DOUBLE N *** OBSOLETE ***
TEMPLATE_NAME VARCHAR(100) Y Name of the requisition template.
TEMPLATE_NAME_KEY VARCHAR(100) Y Contains a uppercase equivalent of template name
TEMPLATE_NAME_KEY_A_NLS VARCHAR(400) Y Stores the corresponding non-English character set values for the Template_name_key column. Used to sort correctly internationally.
TEMPLATE_NAME_KEY_NLS VARCHAR(202) Y Contains a uppercase equivalent of template name for internationalization.
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 - REQUISITION


Child Column in REQUISITION(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in REQUISITION (PK) Child Table Name Child Column Name
Children: REQUISITION_ID DIST_REQ_R REQUISITION_ID
LINE_ITEM REQUISITION_ID
MM_APPROVAL_LOG REQUISITION_ID
MM_APPROVAL_QUEUE REQUISITION_ID
MM_APPROVAL_STG REQUISITION_ID
MM_TRANS_HEADER REQUISITION_ID