Table Detail Report

MM_RECEIPT_DOC_LOT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Receipt Document Line
Definition: This table stores the EDI lot details for the T3 documentation. A new line is created for each lot.
Table Type: ACTIVITY





Column Detail - MM_RECEIPT_DOC_LOT


Column Name Type Null? Definition
EXP_DT_TM DATETIME Y The date/time the lot expires.
LOT_NUMBER_ID DOUBLE Y FK reference of the lot_number table.
LOT_NUMBER_TXT VARCHAR(100) Y Character description of the lot number as defined by the manufacturer of the lot.
LOT_QTY DOUBLE Y The quantity of the item on the line item in the particular lot.
MFR_ADDR VARCHAR(300) Y Stores the address of the manufacturer who has manufactured the supply item.
MFR_NAME VARCHAR(60) Y The manufacturer of the item.
MM_RECEIPT_DOC_LINE_ID DOUBLE Y The line item that this lot is a part of.
MM_RECEIPT_DOC_LOT_ID DOUBLE N Unique generated number that identifies a single row on the MM_RECEIPT_DOC_LOT table.
NDC_TXT VARCHAR(255) Y The National Drug Identifier for a medication definition 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_RECEIPT_DOC_LOT


Child Column in MM_RECEIPT_DOC_LOT(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID
MM_RECEIPT_DOC_LINE_ID MM_RECEIPT_DOC_LINE MM_RECEIPT_DOC_LINE_ID


MM_XFI_ASN_HEADER



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI ASN HEADER
Definition: Table used to store incoming Advance Ship Notice interface header transactions. Data is moved from this table to PO_RECEIPT.
Table Type: ACTIVITY





Column Detail - MM_XFI_ASN_HEADER


Column Name Type Null? Definition
ASN_DT_TM DATETIME Y The date of notice.
ASN_NBR VARCHAR(40) Y The number assigned to this ASN.
BATCH_PROCESSED_DT_TM DATETIME Y The date and time the record was processed.
CONTRIBUTOR_CD DOUBLE N Contributor Source Code value
CREATE_DT_TM DATETIME Y The date and time the record was created
CREATE_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
END_TRANS_ID DOUBLE N The ending transaction identifier for this ASN. For internal use only.
ERROR_EMAIL VARCHAR(100) Y The email address to notify in case an error occurs.
INVOICE_NBR_TXT VARCHAR(40) Y Stores the vendor invoice number from EDI 856
JOB_EXECUTION_ID DOUBLE Y The job execution that processed this record.
LOGICAL_DOMAIN_ID DOUBLE Y 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.
LOGIC_DETERMINE_FLAG DOUBLE Y Indicates what logic to apply to resolve the PO line item.
PACKING_LIST_NBR VARCHAR(40) Y The Packing List Number assigned by the vendor.
PO_NBR VARCHAR(40) Y PO Number
PROCESS_FLAG DOUBLE Y Process flag
PURCHASE_ORDER_ID DOUBLE N Foreign key to the purchase order table.
SHIPMENT_DT_TM DATETIME Y The date that the package will be shipped.
SHIP_FROM_ADDR VARCHAR(300) Y vendor address wher the item is shipped from.
SHIP_FROM_NAME VARCHAR(60) Y Vendor name, where the item is shipped from.
SHIP_TO_ADDR VARCHAR(300) Y Address of the facility to which the item is shipped
SHIP_TO_NAME VARCHAR(60) Y Facility to which the item is shipped;
TRANSACTION_ID DOUBLE N Primary Key
TRANSACTION_STATEMENT_IND DOUBLE Y This column is to denote that the vendor has acceptance against the comment. 1 = the vendor agrees to the comment made.
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.
VENDOR VARCHAR(100) Y The vendor name or number.
VENDOR_CD DOUBLE N The codevalue assigned to this vendor.
VENDOR_COMMENT_TXT VARCHAR(300) Y Records the vendor instructions that is made for the purchse order;



Relationship Detail - MM_XFI_ASN_HEADER


Child Column in MM_XFI_ASN_HEADER(FK) Parent Table Name Parent Column Name
Parents: JOB_EXECUTION_ID JOB_EXECUTION JOB_EXECUTION_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
CREATE_ID PRSNL PERSON_ID


MM_XFI_ASN_LINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI ASN LINE
Definition: Table used to store incoming Advance Ship Notice interface line transactions. Data is moved from this table to RECEIPT_LINE_ITEM and LINE_ITEM_QUANTITY.
Table Type: ACTIVITY





Column Detail - MM_XFI_ASN_LINE


Column Name Type Null? Definition
ASN_COMMENT VARCHAR(255) Y The Vendor's comments
CONTRIBUTOR_CD DOUBLE N Contributor Source Code value
ITEM_MASTER_DESC VARCHAR(255) Y Stores the item description that the vendor passes from EDI.
ITEM_MASTER_NBR VARCHAR(40) Y The clients Item Master number.
LINE_ITEM_ID DOUBLE N Foreign key to the line_item table.
LINE_NBR DOUBLE Y The Purchase Order line number.
LOGICAL_DOMAIN_ID DOUBLE Y 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 VARCHAR(100) Y The manufacturer of the product.
MFR_ADDR VARCHAR(300) Y Stores the address of the manufacturer who has manufactured the supply item.
MFR_CD DOUBLE Y Stores the manufacturer cd for the given manufacturer
MFR_ITEM_NBR VARCHAR(40) Y The manufacturers catalog number.
NDC_TXT VARCHAR(255) Y Stores the NDC that is passed from the third party vendor.;
PACK_FACTOR DOUBLE Y The ordered/shipped packaging pack factor.
PROCESS_FLAG DOUBLE Y Process flag
QTY_ORDERED DOUBLE Y The ordered quantity.
QTY_SHIPPED DOUBLE Y The shipped quantity.
TRANSACTION_ID DOUBLE N Primary Key
TRANS_HEADER_ID DOUBLE N Foreign key to mm_xfi_asn_header.
UOM VARCHAR(100) Y The ordered/shipped unit of measure.
UOM_CD DOUBLE N The Unit of Measure
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 The products UPN.
UPN_TXT VARCHAR(255) Y Stores the text version of the UPN that is passed from the third party vendor.;
VENDOR_ITEM_NBR VARCHAR(40) Y The vendors catalog number.
VENDOR_PACK_FACTOR DOUBLE Y Stores the pack factor that the vendor has passed from the EDI specification file
VENDOR_UOM VARCHAR(100) Y Stores the UOM that the vendor has passed from the EDI specification file



Relationship Detail - MM_XFI_ASN_LINE


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




Parent Column in MM_XFI_ASN_LINE (PK) Child Table Name Child Column Name
Children: TRANSACTION_ID MM_XFI_ASN_LOT TRANS_LINE_ID


MM_XFI_ASN_LOT



Column Section Relationship Section Top of Page


Table-level Detail

Description: ADVANCED SHIPMENT NOTIFICATION LOT
Definition: To store the advanced shipment notification for lot information
Table Type: ACTIVITY





Column Detail - MM_XFI_ASN_LOT


Column Name Type Null? Definition
EXP_DT_TM DATETIME Y The date/time an item will expire.
LOT_NUMBER_ID DOUBLE N Identifies the existing lot in the system. If the value is zero, then a new lot is being passed for the asn line item item. Originates on LOT_NUMBER_INFO. LOT_NUMBER_ID.
LOT_NUMBER_TXT VARCHAR(100) Y Character description of the lot number as defined by the manufacturer of the lot.
LOT_QTY DOUBLE Y Numeric value of units shipped in manufacturer's shipping units for the corresponding lot number.
MANF_DT_TM DATETIME Y Date and time this item in the lot was manufactured.
MANUFACTURER_CD DOUBLE N The code value(Code set 221) representing the manufacturer for the lot
MANUFACTURER_NAME VARCHAR(100) Y Manufacturer¿s name for the respective lot number that is being passed as the part of asn line item.
NDC_TXT VARCHAR(255) Y Drug Identifier for medication definition item. Drug Identifier is mandatory for medication definition items having lot tracking set as Incoming lot level and ;Lot level.
TRANSACTION_ID DOUBLE N Unique generated number that identifies a single row on the MM_XFI_ASN_LOT table.
TRANS_LINE_ID DOUBLE N Maps a lot to the respective asn line item. Originates on MM_XFI_ASN_LINE.transaction_id.
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_ASN_LOT


Child Column in MM_XFI_ASN_LOT(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID
TRANS_LINE_ID MM_XFI_ASN_LINE TRANSACTION_ID


MM_XFI_PAYMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interface Payment
Definition: Interface staging table to store the payment information for the Purchase orders. Data is moved from this table to MM_PAYMENT.
Table Type: ACTIVITY





Column Detail - MM_XFI_PAYMENT


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y Determines the action to be taken for this row. (1-Update/Insert,...)
AMOUNT DOUBLE Y amount value
BATCH_REF VARCHAR(100) Y BATCH REFERENCE
CHECK_NBR VARCHAR(40) Y Cheque number for the payment.
CREATE_APPLCTX DOUBLE N The application context responsible for inserting this row on the table
CREATE_DT_TM DATETIME N The date and time the record was created
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 Task which created this row
FOREIGN_VOUCHER_NBR VARCHAR(40) Y foreign voucher number
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.
MM_PAYMENT_ID DOUBLE N ID from mm_payment table to fetch the existing record for update.
MM_XFI_PAYMENT_COMMENT VARCHAR(255) Y mm xfi payment comment
PAYMENT_DT_TM DATETIME Y Determines the dt_tm when the payment occurred.
PAYMENT_METHOD VARCHAR(60) Y Identifies the method of payment (i.e. Cash, Check and Electronic Fund Transfer, etc.).
PAYMENT_TYPE VARCHAR(60) Y PAYMENT TYPE
PROCESS_FLAG DOUBLE Y Defines the state of the row in the upload process.
PRSNL_NAME VARCHAR(100) Y Name of the person who is processed the payment.
PURCHASE_ORDER_ID DOUBLE N The purchase order this payment is applied to.
REFERENCE_NBR VARCHAR(60) Y reference number
SEGMENT_IDENTIFIER VARCHAR(10) Y Indicates the upload type (item upload, item location upload, etc.)
SEGMENT_VERSION VARCHAR(10) Y Identifies the version of the upload interface
TRANSACTION_ID DOUBLE N Unique, generated number that identifies a single row on the MM_XFI_PAYMENT 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_XFI_PAYMENT


Child Column in MM_XFI_PAYMENT(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PURCHASE_ORDER_ID PURCHASE_ORDER PURCHASE_ORDER_ID