Table Detail Report

LINE_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Line Item
Definition: Table used to store requisition and purchase order line activity information, and template reference info.
Table Type: ACTIVITY





Column Detail - LINE_ITEM


Column Name Type Null? Definition
ACK_MANUF_ITEM_DESC VARCHAR(100) Y Acknowledgement Manufacturer Item Description
ACK_MANUF_ITEM_NBR VARCHAR(40) Y Acknowledgement Manufacturer Item Number
ACK_PKG_TYPE_QTY DOUBLE Y Acknowledgement Package Type Quantity
ACK_UOM VARCHAR(40) Y Acknowledgement Unit of Measure
ACK_VENDOR_ITEM_DESC VARCHAR(100) Y Acknowledgement Vendor Item Description
ACK_VENDOR_ITEM_NBR VARCHAR(40) Y Acknowledgement Vendor Item Number
APPROVAL_STATUS_DT_TM DATETIME Y Date of an approved or rejected action..
ATTENTION VARCHAR(100) Y Attention
AUTO_DISTRIBUTE_IND DOUBLE Y Indicator used to determine if requisition line has been distributed.
AUTO_RECEIVE_IND DOUBLE Y Automatically receive
BILL_ONLY_IND DOUBLE Y Bill only indicator
BUYER_ID DOUBLE N Buyer ID of the Buyer
CHARGE_FLAG DOUBLE N charge flag
CONSIGNMENT_IND DOUBLE Y Consignment Indicator
COST_CENTER_CD DOUBLE N Cost Center
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 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 N The registered (assigned) task number for the process that inserted the row.
DELIVER_TO_LOCATION_CD DOUBLE N Deliver to location.
DUE_DT_TM DATETIME Y Date this item is due.
ENCNTR_ID DOUBLE N encounter identifier value
FILL_LOCATION_CD DOUBLE N Location this item is picked from.
ITEM_MASTER_ID DOUBLE N Foreign key to item master
LINE_ACK_STATUS_CD DOUBLE N Line Acknowledgement Status
LINE_ITEM_ID DOUBLE N Primary key
LINE_ITEM_VERSION DOUBLE Y Line Item Version
LOCKED_BY_PRSNL_ID DOUBLE N locked by personnel identifier
LOCKED_DT_TM DATETIME Y locked date and time
MANUF_CD DOUBLE N Manufacturer Code Value
MANUF_ITEM_ID DOUBLE N Foreign key to manufacturer_item table.
MISC_CD DOUBLE N Miscellaneous codes defined by the user.
MM_PROJECT_NBR_TRACKING_ID DOUBLE N The project that this line item is associated to.
NC_855_IND DOUBLE Y This field is to know the source of the non-catalog item - if the non-catalog item is created from EDI855 workflow - the indicator is set to 1 else it will be 0
NC_DESCRIPTION VARCHAR(255) Y Non-Cataloged Description
NC_MFR VARCHAR(60) Y Non-catalog manufacturer
NC_MFR_CD DOUBLE N If the non-catalog manufacturer exists in our current system. This is the code value for the corresponding manufacturer (code set 221)
NC_MFR_ITEM_NBR VARCHAR(20) Y Non-catalog manufacturer item number
NC_NDC_VALUE VARCHAR(50) Y This filed is to store the NDC values for the medication non catalog item
NC_VENDOR_ITEM_NBR VARCHAR(20) Y Non-catalog vendor item number
NEXT_VERSION_NBR DOUBLE Y The next version number (used for versioning).
NON_CATALOG_IND DOUBLE Y Indicator used to determine if the line is a non-catalog item
ORIGINAL_MANUF_ITEM_ID DOUBLE N Original Manufacturer Item
ORIGINAL_VENDOR_ITEM_ID DOUBLE N Original Vendor Item
PERSON_ID DOUBLE N person identifier
PO_LINE_NBR DOUBLE Y PO Number
PO_LINE_STATUS_CD DOUBLE N Status of line item
PRIORITY_CD DOUBLE N priority code value
PROJECT_CD DOUBLE N Project code code value
PURCHASE_ORDER_ID DOUBLE N Foreign key to purchase order
PURCHASING_SVC_RES_CD DOUBLE N Purchasing service resource
REAL_TIME_OUTBOUND_IND DOUBLE N Indicates if the line item is to be processed through the real-time outbound requisition interface.
REFERENCE VARCHAR(40) Y Reference
REQUESTOR VARCHAR(100) Y Requesting person
REQUISITION_ID DOUBLE N Foreign key to requisition
REQ_ALLOW_MOD_IND DOUBLE Y Indicator used to determine if the requisition line can be modified.
REQ_LINE_NBR DOUBLE Y Requisition line number
REQ_LINE_STATUS_CD DOUBLE N Status
REQ_TRANSMIT_DT_TM DATETIME Y Field used to store the requisition transmit date/time for the line item. It will specify whether or not the requisition line item has been transmitted to a foreign MMIS system.
SHIP_TO_LOCATION_CD DOUBLE N Ship to location
SUBSTITUTION_IND DOUBLE Y Indicator used to see if the item is being substituted.
SUB_ACCOUNT_CD DOUBLE N Sub account
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.
VALID_PO_LINE_IND DOUBLE Y Valid PO line indicator
VALID_REQ_LINE_IND DOUBLE Y Valid requisition line indicator
VENDOR_CD DOUBLE N Vendor associated with this account
VENDOR_ITEM_ID DOUBLE N Foreign key to vendor item



Relationship Detail - LINE_ITEM


Child Column in LINE_ITEM(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ITEM_MASTER_ID ITEM_MASTER ITEM_ID
ORIGINAL_MANUF_ITEM_ID MANUFACTURER_ITEM ITEM_ID
MM_PROJECT_NBR_TRACKING_ID MM_PROJECT_NBR_TRACKING MM_PROJECT_NBR_TRACKING_ID
PERSON_ID PERSON PERSON_ID
LOCKED_BY_PRSNL_ID PRSNL PERSON_ID
REQUISITION_ID REQUISITION REQUISITION_ID
ORIGINAL_VENDOR_ITEM_ID VENDOR_ITEM ITEM_ID
VENDOR_ITEM_ID VENDOR_ITEM ITEM_ID




Parent Column in LINE_ITEM (PK) Child Table Name Child Column Name
Children: LINE_ITEM_ID DIST_LINE_ITEM_R LINE_ITEM_ID
INVOICE_LINE_ITEM LINE_ITEM_ID
LINE_SCHEDULED_QTY LINE_ITEM_ID
MM_APPROVAL_LOG LINE_ITEM_ID
MM_APPROVAL_QUEUE LINE_ITEM_ID
MM_APPROVAL_STG LINE_ITEM_ID
MM_ASN_LINE_DISCREPANCY LINE_ITEM_ID
MM_EXT_SRC_Q LINE_ITEM_ID
MM_RECEIPT_DOC_LINE LINE_ITEM_ID
MM_TRANS_LINE LINE_ITEM_ID
RECEIPT_LINE_ITEM LINE_ITEM_ID


LINE_ITEM_QUANTITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: LINE ITEM QUANTITY
Definition: Quantity for a line item
Table Type: ACTIVITY





Column Detail - LINE_ITEM_QUANTITY


Column Name Type Null? Definition
BASE_PKG_TYPE_DESC VARCHAR(100) Y Vendors package description
BASE_PKG_TYPE_ID DOUBLE N Foreign key to package_type
BASE_PKG_TYPE_QTY DOUBLE Y Quantity of the package type in base units
BASE_PKG_TYPE_UOM_CD DOUBLE N Package type unit of measure
CREATE_APPLCTX DOUBLE N Application which created this row
CREATE_DT_TM DATETIME N The date/time this entry was created.
CREATE_ID DOUBLE N ID of user who created this row
CREATE_TASK DOUBLE N Task which created this row
EXTENDED_AMOUNT DOUBLE Y The total dollar amount ( qty X unit price ).
EXTENDED_PRICE DOUBLE Y The price multiplied by the quantity.
ITEM_PRICE_ID DOUBLE N Foreign key to item_price table
LINE_ITEM_QTY_TYPE_CD DOUBLE N The type of quantity this row refers to
PACKAGE_TYPE_DESC VARCHAR(100) Y Package type description
PACKAGE_TYPE_ID DOUBLE N Foreign key to package type table
PACKAGE_TYPE_PRICE DOUBLE Y Price of the item
PACKAGE_TYPE_QTY DOUBLE Y The quantity of base packages contained in this package. For example, if this item comes packed individually, a box might contain multiple individual packages.
PACKAGE_TYPE_UOM_CD DOUBLE N Unit of measure for this package
PARENT_ENTITY_ID DOUBLE N Foreign key to a table designated by parent_entity_name
PARENT_ENTITY_NAME VARCHAR(40) N Defines the parent table for parent_entity_id
PRICE_TYPE_CD DOUBLE N Type of price code value
QTY DOUBLE N Quantity value
REASON_CD DOUBLE N No fill reason
SEL_PKG_TYPE_DESC VARCHAR(100) Y Description of the package type that the user selected.
SEL_PKG_TYPE_ID DOUBLE N The internal id of the package
SEL_PKG_TYPE_QTY DOUBLE Y The quantity in base units of the package type the user selected.
SEL_PKG_TYPE_UOM_CD DOUBLE N The uom code value of the package type the user selected.
TO_PKG_TYPE_DESC VARCHAR(100) Y To Package Type Description
TO_PKG_TYPE_ID DOUBLE N To Package Type Id
TO_PKG_TYPE_QTY DOUBLE Y To Package Type Quantity
TO_PKG_TYPE_UOM_CD DOUBLE N To Package Type UoM Cd
UNIT_TAX DOUBLE Y Unit Tax for the Line 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.
VEND_SHIP_DT_TM DATETIME Y Vendor Ship Date/Time



Relationship Detail - LINE_ITEM_QUANTITY


Child Column in LINE_ITEM_QUANTITY(FK) Parent Table Name Parent Column Name
Parents: BASE_PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID


LINE_SCHEDULED_QTY



Column Section Relationship Section Top of Page


Table-level Detail

Description: LINE SCHEDULED QTY
Definition: The quantity of an item that is schedule for future procurement
Table Type: ACTIVITY





Column Detail - LINE_SCHEDULED_QTY


Column Name Type Null? Definition
CREATE_APPLCTX DOUBLE N Application which created this row
CREATE_DT_TM DATETIME N The date/time this entry was created.
CREATE_ID DOUBLE N ID of user who created this row
CREATE_TASK DOUBLE N Task which created this row
LINE_ITEM_ID DOUBLE N Foreign key to line_item table
LINE_SCHEDULED_QTY_ID DOUBLE N Primary Key
SCHEDULED_DT_TM DATETIME N Scheduled date for order/shipment
SCHEDULED_QTY DOUBLE N Quantity to be ordered/shipped
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 - LINE_SCHEDULED_QTY


Child Column in LINE_SCHEDULED_QTY(FK) Parent Table Name Parent Column Name
Parents: LINE_ITEM_ID LINE_ITEM LINE_ITEM_ID


MM_ASN_LINE_DISCREPANCY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Advanced Shipment Notification Line Discrepancy
Definition: To log the quantity discrepancy between the ASN and physically received quantity for the line item.
Table Type: ACTIVITY





Column Detail - MM_ASN_LINE_DISCREPANCY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ASN_QTY DOUBLE Y The numeric value of the units mentioned in the advanced shipment notification for the line item.
DISCREPANCY_DT_TM DATETIME Y Date and time when the discrepancy occurred either via ASN or manual receiving.
DISCREPANCY_IND DOUBLE N This column identifies whether the line item is having the discrepancy or not. Includes discrepancy in the lot.
DISCREPANCY_REASON_CD DOUBLE N The reason for the purchase order discrepancy
LINE_ITEM_ID DOUBLE N
MM_ASN_LINE_DISCREPANCY_ID DOUBLE N Unique generated number that identifies a single row on the MM_ASN_LINE_DISCREPANCY table.
RECEIVED_QTY DOUBLE Y The numeric value of units physically received for the line 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_ASN_LINE_DISCREPANCY


Child Column in MM_ASN_LINE_DISCREPANCY(FK) Parent Table Name Parent Column Name
Parents: LINE_ITEM_ID LINE_ITEM LINE_ITEM_ID




Parent Column in MM_ASN_LINE_DISCREPANCY (PK) Child Table Name Child Column Name
Children: MM_ASN_LINE_DISCREPANCY_ID MM_ASN_LOT_DISCREPANCY MM_ASN_LINE_DISCREPANCY_ID


MM_ASN_LOT_DISCREPANCY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Advanced Shipment Notification Lot Discrepancy
Definition: To log the quantity discrepancy between the ASN and physically received lot for the line item.
Table Type: ACTIVITY





Column Detail - MM_ASN_LOT_DISCREPANCY


Column Name Type Null? Definition
ASN_LOT_IND DOUBLE Y This field will say whether the given lot exists in ASN (Advanced Shipping Notification)
ASN_LOT_QTY DOUBLE Y Numeric value of units mentioned in the advanced shipment notification for the corresponding lot number.
LOT_NBR_TEXT VARCHAR(255) N Identifies the lot number of the line item which is having either lot number or lot quantity discreapncy.
MANUFACTURER_CD DOUBLE N The code value(Code set 221) representing the manufacturer for the lot. This can be 0.
MM_ASN_LINE_DISCREPANCY_ID DOUBLE N Used to map a lot to the respective line item. Originates on MM_ASN_LINE_DISCREPANCY.MM_ASN_LINE_DISCREPANCY_ID.
MM_ASN_LOT_DISCREPANCY_ID DOUBLE N Unique generated number that identifies a single row on the MM_ASN_LOT_DISCREPANCY table.
RECEIVED_LOT_QTY DOUBLE Y Numeric value of units physically recevied for the corresponding lot number.
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_ASN_LOT_DISCREPANCY


Child Column in MM_ASN_LOT_DISCREPANCY(FK) Parent Table Name Parent Column Name
Parents: MM_ASN_LINE_DISCREPANCY_ID MM_ASN_LINE_DISCREPANCY MM_ASN_LINE_DISCREPANCY_ID