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 |