Table Detail Report

STORAGE_GROUP



Column Section Top of Page


Table-level Detail

Description: Storage Group
Definition: PathNet Storage Tracking reference table that stores relationships between trays and racks and shelves.
Table Type: ACTIVITY





Column Detail - STORAGE_GROUP


Column Name Type Null? Definition
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_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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CHILD_LOC_CD DOUBLE N Either a tray or a rack.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PARENT_LOC_CD DOUBLE N Either a tray or a rack.
STORAGE_TYPE_CD DOUBLE N Either storage tray or storage rack.
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.


STORAGE_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Storage Tracking reference table storing trays and racks.
Definition: Storage Item
Table Type: REFERENCE





Column Detail - STORAGE_ITEM


Column Name Type Null? Definition
EMPTY_IND DOUBLE N An indicator set to 1 if the given rack or tray is empty.
STORAGE_ITEM_CD DOUBLE N Unique identifier for the given rack or tray.
STORAGE_ITEM_DESCRIPTION_CD DOUBLE N Determines what type of tray or what type of rack.
STORAGE_TYPE_CD DOUBLE N Location type (either tray or rack)
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 - STORAGE_ITEM


Child Column in STORAGE_ITEM(FK) Parent Table Name Parent Column Name
Parents: STORAGE_ITEM_CD CODE_VALUE CODE_VALUE




Parent Column in STORAGE_ITEM (PK) Child Table Name Child Column Name
Children: STORAGE_ITEM_CD STORAGE_CONTENT STORAGE_ITEM_CD
STORAGE_CONTENT_EVENT STORAGE_ITEM_CD


STORAGE_ITEM_CELL



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Storage Tracking activity table. The actual storage locations.
Definition: Storage Item Cell
Table Type: ACTIVITY





Column Detail - STORAGE_ITEM_CELL


Column Name Type Null? Definition
STORAGE_CHILD_CD DOUBLE Y Obsolete, No longer being used. Indicates the child id of this cell. Racks are children of trays and containers are children of racks.
STORAGE_ITEM_CD DOUBLE N The parent storage item of this cell.
STORAGE_ITEM_CELL_ID DOUBLE N The unique id of a particular cell.
STORAGE_ITEM_COL DOUBLE Y Column of the cell. The storage_item_col and storage_item_row determines the cell's location.
STORAGE_ITEM_ROW DOUBLE Y Row of the cell. The storage_item_col and storage_item_row determines the cell's location.
STORAGE_TYPE_CD DOUBLE N Obsolete. No longer being used. rack or tray
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 - STORAGE_ITEM_CELL




Parent Column in STORAGE_ITEM_CELL (PK) Child Table Name Child Column Name
Children: STORAGE_ITEM_CELL_ID CONTAINER STORAGE_RACK_CELL_ID
CONTAINER_EVENT STORAGE_RACK_CELL_ID
STORAGE_CONTENT STORAGE_ITEM_CELL_ID
STORAGE_CONTENT_EVENT STORAGE_ITEM_CELL_ID


STORAGE_ITEM_DESCRIPTION



Column Section Top of Page


Table-level Detail

Description: PathNet Storage Tracking reference table containing the properties of trays/rack
Definition: Storage Item Description
Table Type: REFERENCE





Column Detail - STORAGE_ITEM_DESCRIPTION


Column Name Type Null? Definition
BACK_FRONT_IND DOUBLE N Indicates whether to fill from back to front or front to back.
COLS_ALPHA_IND DOUBLE Y Indicates whether to use numbers or letters for the columns.
CONTENT_TYPE_CD DOUBLE N Contains the type of inventory content a storage item with this description can hold.
DEFAULT_IND DOUBLE N Indicates if this particular tray or rack is used as the default tray or rack type.
LEFT_RIGHT_IND DOUBLE N Indicates whether to fill the tray or rack left to right or right to left.
MAX_COLUMNS DOUBLE N The total number of columns of a tray or rack.
MAX_ROWS DOUBLE N The total number of rows of a tray or rack.
ROWS_ALPHA_IND DOUBLE Y Indicates whether the rows are numbered or lettered.
ROW_COL_IND DOUBLE N Indicates whether to fill up a whole row or column first.
STORAGE_ITEM_DESCRIPTION_CD DOUBLE N Unique system id for a tray or rack description. A description is the attrributes of a particular tray or rack.
STORAGE_TYPE_CD DOUBLE N Indicates if the description is a tray or rack.
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.


TRANSFER_LIST_AUTO_BUILD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transfer List Auto Build
Definition: Contains the parameters for auto-building transfer lists from robotics messages.
Table Type: REFERENCE





Column Detail - TRANSFER_LIST_AUTO_BUILD


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FROM_LOCATION_CD DOUBLE N Indicates the starting location to be used for the transfer lists.
MAX_CONTAINER_NBR DOUBLE N The maximum number of containers that an auto-built transfer list based off of this configuration will accept.
ROUTE_CODE_TXT VARCHAR(40) N The route code text for which the parameters apply.
SERVICE_RESOURCE_CD DOUBLE N The unique identifier for the service resource for which the parameters apply.
TO_LOCATION_CD DOUBLE N Indicates the location the containers will be sent to.
TRANSFER_LIST_AUTO_BUILD_ID DOUBLE N Uniquely identifies parameters for auto-building transfer lists from robotics messages.
TRANSFER_TEMP_CD DOUBLE N Indicates the transfer temperature the transfer list will use.
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 - TRANSFER_LIST_AUTO_BUILD




Parent Column in TRANSFER_LIST_AUTO_BUILD (PK) Child Table Name Child Column Name
Children: TRANSFER_LIST_AUTO_BUILD_ID COLLECTION_LIST TRANSFER_LIST_AUTO_BUILD_ID