Table Detail Report

QUANTITY_ON_HAND



Column Section Relationship Section Top of Page


Table-level Detail

Description: QUANTITY ON HAND
Definition: Stores quantity on hand for an item at a location.
Table Type: REFERENCE





Column Detail - QUANTITY_ON_HAND


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.
ACTIVE_STATUS_APPLCTX DOUBLE N The registered (assigned) application number for the process that updated the row.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ACTIVE_STATUS_TASK DOUBLE N The registered (assigned) task number for the process that updated the row.
CREATE_APPLCTX DOUBLE N The registered (assigned) application number for the process that created the 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
ITEM_ID DOUBLE N ID value of the Item
LOCATION_CD DOUBLE N Location
LOCATOR_CD DOUBLE N Locator
PACKAGE_TYPE_ID DOUBLE N Foreign key to package type table.
QOH_TYPE_CD DOUBLE N The type of quantity.
QTY DOUBLE N The item quantity.
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 - QUANTITY_ON_HAND


Child Column in QUANTITY_ON_HAND(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID


QUANTITY_REQUIREMENT_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: QUANTITY REQUIREMENT INFO
Definition: Quantity info for an item at a location.
Table Type: REFERENCE





Column Detail - QUANTITY_REQUIREMENT_INFO


Column Name Type Null? Definition
ACC_STOCKOUT_FREQ_CD DOUBLE N The acceptable stockout frequency which is allowed at this location
AVERAGE_DAILY_USAGE DOUBLE Y The average item usage per day at this location
AVERAGE_WEEKS_ORDER_QTY DOUBLE Y The average order quantity per week
DEMAND_BUFFER_IND DOUBLE N Demand Buffer Indicator: Indicates whether demand_buffer_pct will be used(1) or not used(0).
DEMAND_BUFFER_PCT DOUBLE N Demand Buffer Percentage: Defines percentage to increase or decrease the system calculated item demand
DEMAND_CALC_DT_TM DATETIME Y Demand Calculated Date Time : The time demand was calculated by the worklist specified in demand_worklist_id
DEMAND_REFILL_LVL_FLAG DOUBLE N Demand Refill Level Flag: Indicates whether the system will calculate and use the system calculated item_demandl (1) or system will calculate the demand but use user entered refill level(2) or will not calculate and will use the user entered refill level (0) when determining items to refill
DEMAND_WORKLIST_ID DOUBLE N Id of the worklist that calculated the system demand.
FIXED_ORDER_QTY DOUBLE N Replenishment quantity will be created in increments of the fixed order quantity.
ITEM_ID DOUBLE N ID value of the Item
LAST_SYSCALC_DT_TM DATETIME Y The last time the system calculated the reorder attributes.
LOCATION_CD DOUBLE N Location code
LOCATOR_QTY DOUBLE N The quantity that can be stored in an individual locator.
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.
MAXIMUM_LEVEL DOUBLE Y Maximum quantity of the item at the location
MAX_DAYS_ADU DOUBLE Y Maximum number of days that the average daily usage is based upon
MINIMUM_LEVEL DOUBLE Y minimum quantity of the item at the location
MIN_DAYS_ADU DOUBLE Y Minimum number of days that the average daily usage is based upon
REORDER_METHOD_CD DOUBLE N Method used to reorder the item
REORDER_POINT DOUBLE Y The inventory level that will qualify an item to be reordered
REORDER_TYPE_CD DOUBLE N The type of reorder method being utilized.
SAFETY_STOCK_QTY DOUBLE Y The quantity of safety stock specified at this location
SEASONAL_ITEM_IND DOUBLE Y Indicator used to flag the item as being seasonal
SYSCALC_ABC_CLASS_IND DOUBLE Y Indicator to determine if the ABC classification will be calculated by the system.
SYSCALC_FREQ_NBR_DAYS DOUBLE Y Indicator to determine if the frequency number of days will be calculated by the system
SYSCALC_PAR_LEVEL_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
SYS_CALC_DEMAND_QTY DOUBLE N System calculated demand for the item
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 - QUANTITY_REQUIREMENT_INFO


Child Column in QUANTITY_REQUIREMENT_INFO(FK) Parent Table Name Parent Column Name
Parents: DEMAND_WORKLIST_ID RXS_WORKLIST RXS_WORKLIST_ID


STORED_AT



Column Section Relationship Section Top of Page


Table-level Detail

Description: STORED AT
Definition: Item / Location relationship detirmining physical storage.
Table Type: REFERENCE





Column Detail - STORED_AT


Column Name Type Null? Definition
EXP_DT_TM DATETIME Y The date/time an item will expire.
ITEM_ID DOUBLE N Inventory item.
LOCATION_CD DOUBLE N Location
PACKAGE_TYPE_ID DOUBLE N Foreign key to package type 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 - STORED_AT


Child Column in STORED_AT(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID


VENDOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Vendor
Definition: Vendors table
Table Type: REFERENCE





Column Detail - VENDOR


Column Name Type Null? Definition
ACKNOWLEDGEMENT_IND DOUBLE N Used to determine if the EDI 855 acknowledgement will create a line level comment or update the purchase order and vendor information automatically. 0 = Line level comment will be created. 1 = Purchase order and vendor information will be updated automatically.
ACTIVE_DT_TM DATETIME Y Date and time the record became active
ACTIVE_IND DOUBLE Y 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.
ACTIVE_TYPE_CD DOUBLE Y Active type code value
APPROVED_VENDOR_STATUS_CD DOUBLE Y Approved vendor status code value
AUTO_COMMIT_PO_IND DOUBLE Y If true then the req-to-po process will automatically commit the purchase order.
AUTO_COMMIT_RECEIPT_IND DOUBLE Y If true then the EDI 856 (Advanced Ship Notice) process will automatically commit the receipt.
BACKORDER_IND DOUBLE Y Indicates if the vendor allows backorders
CONSOLIDATE_RQSTN_IND DOUBLE N Indicates whether all requisitions for a particular vendor will be grouped on a single Purchase Order or whether a Purchase Order will be generated for each requisition item. 0 - not consolidated, 1 - consolidated onto one P.O.
DESCRIPTION VARCHAR(60) Y The vendor's long description
DESCRIPTION_KEY VARCHAR(60) Y Indexed key for description field
DESCRIPTION_KEY_A_NLS VARCHAR(240) Y DESCRIPTION_KEY_A_NLS column
DESCRIPTION_KEY_NLS VARCHAR(122) Y Indexed key for description field
DISPLAY VARCHAR(40) Y Short description of vendor
DISPLAY_KEY VARCHAR(40) Y Indexed key for display field
DISPLAY_KEY_A_NLS VARCHAR(160) Y DISPLAY_KEY_A_NLS column
DISPLAY_KEY_NLS VARCHAR(82) Y Indexed key for display field - NLS support
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.
MIN_ORDER_COST DOUBLE Y Minimum ordering cost from vendor
OUTPUT_DEST_ID DOUBLE N Identifier for the The Output destination
SERVICE_RESOURCE_CD DOUBLE N Vendor code value
TAX_EXEMPT_IND DOUBLE N This indicator indicates whether the vendor is a tax exempt vendor.
TAX_PAYER_NBR VARCHAR(50) Y The tax payers number
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.
VENDOR_NUMBER DOUBLE Y Vendor number
VENDOR_TYPE_CD DOUBLE Y Code for the Type of vendor



Relationship Detail - VENDOR


Child Column in VENDOR(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
OUTPUT_DEST_ID STATION OUTPUT_DEST_CD


VENDOR_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: VENDOR ITEM
Definition: Child of Item Definition
Table Type: REFERENCE





Column Detail - VENDOR_ITEM


Column Name Type Null? Definition
ITEM_ID DOUBLE N Primary key inherited from item_definition
LEAD_TIME DOUBLE Y The vendors lead time for this item
LEAD_TIME_UOM_CD DOUBLE N The vendor's lead time unit of measure for this item
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.
PRICE_REVIEW_IND DOUBLE Y Indicates that this item has one or more prices in need of review
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.
VENDOR_CD DOUBLE N Code Value for vendor



Relationship Detail - VENDOR_ITEM




Parent Column in VENDOR_ITEM (PK) Child Table Name Child Column Name
Children: ITEM_ID ACQUIREMENT_INFO PRIMARY_VENDOR_ITEM_ID
LINE_ITEM ORIGINAL_VENDOR_ITEM_ID
LINE_ITEM VENDOR_ITEM_ID
RECEIPT_LINE_ITEM ACTUAL_VENDOR_ITEM_ID