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 |