MM_PAR_DEVICE_LOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MM PAR DEVICE LOG |
Definition: | Log information for the device, user and route. |
Table Type: | ACTIVITY |
Column Detail - MM_PAR_DEVICE_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
CHECK_IN_DT_TM | DATETIME | Y | The date/time the user checked the device in. |
CHECK_OUT_DT_TM | DATETIME | Y | The date/time the user checked the device out. |
CREATE_APPLCTX | DOUBLE | Y | Application which created this row |
CREATE_DT_TM | DATETIME | Y | The date/time this entry was created. |
CREATE_ID | DOUBLE | N | ID of user who created this row |
CREATE_TASK | DOUBLE | Y | Task which created this row |
DEVICE_CD | DOUBLE | N | The device used to do the par counting for this route. |
PAR_DEVICE_LOG_ID | DOUBLE | N | The unique id for this device log. |
PAR_ROUTE_ID | DOUBLE | N | The unique identifier for the route. |
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. |
USER_ID | DOUBLE | N | The unique id of the person who is using the device on a route. |
Relationship Detail - MM_PAR_DEVICE_LOG
Parent Column in MM_PAR_DEVICE_LOG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PAR_DEVICE_LOG_ID | MM_PAR_ROUTE_LOG | PAR_DEVICE_LOG_ID |
MM_PAR_EXCEPTION_LOG
Column Section | Top of Page |
Table-level Detail
Description: | MM PAR EXCEPTION LOG |
Definition: | Log information for exceptions on a route. |
Table Type: | ACTIVITY |
Column Detail - MM_PAR_EXCEPTION_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
CREATE_APPLCTX | DOUBLE | Y | Application which created this row |
CREATE_DT_TM | DATETIME | Y | The date/time this entry was created. |
CREATE_ID | DOUBLE | N | ID of user who created this row |
CREATE_TASK | DOUBLE | Y | Task which created this row |
EXCEPTION_FLAG | DOUBLE | Y | The exception type of this entry. |
ITEM_ID | DOUBLE | N | The unique id for the item master. |
LOCATION_CD | DOUBLE | N | The unique id of the asset location where the exception occurred. |
PAR_EXCEPTION_LOG_ID | DOUBLE | N | The unique id of this exception entry. |
PAR_ROUTE_LOG_ID | DOUBLE | N | The unique id on which route log this exception occurred. |
PKG_TYPE_ID | DOUBLE | N | The unique id for the package type for this exception. |
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. |
MM_PAR_LOCATION
Column Section | Top of Page |
Table-level Detail
Description: | MM PAR LOCATION |
Definition: | Information about the asset locations on a route. |
Table Type: | REFERENCE |
Column Detail - MM_PAR_LOCATION
Column Name | Type | Null? | Definition |
---|---|---|---|
COUNT_ALL_IND | DOUBLE | Y | count all indicator |
CREATE_APPLCTX | DOUBLE | Y | Application which created this row |
CREATE_DT_TM | DATETIME | Y | The date/time this entry was created. |
CREATE_ID | DOUBLE | N | ID of user who created this row |
CREATE_TASK | DOUBLE | Y | Task which created this row |
LOCATION_CD | DOUBLE | N | The unique id of the asset location for a route. |
PAR_LOCATION_ID | DOUBLE | N | The unique id for an entry on this table. |
PAR_ROUTE_ID | DOUBLE | N | The unique id of the route. |
REPL_WINDOW | DOUBLE | Y | The number of hours that must pass before the asset location may be counted again. |
REQ_MODE_IND | DOUBLE | Y | The indicator will be used to determine if the quantity entered is the counted quantity (0) or the quantity to be requisitioned (1) |
SEQUENCE | DOUBLE | Y | The order in which the asset locations should be counted. |
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. |
MM_PAR_ROUTE
Column Section | Top of Page |
Table-level Detail
Description: | MM PAR ROUTE |
Definition: | Information about the route. |
Table Type: | REFERENCE |
Column Detail - MM_PAR_ROUTE
Column Name | Type | Null? | Definition |
---|---|---|---|
CREATE_APPLCTX | DOUBLE | Y | Application which created this row |
CREATE_DT_TM | DATETIME | Y | The date/time this entry was created. |
CREATE_ID | DOUBLE | N | ID of user who created this row |
CREATE_TASK | DOUBLE | Y | Task which created this row |
DEF_REPL_WINDOW | DOUBLE | Y | The default amount of hours which must pass before an asset location may be counted again. This value may be overridden by at a specific asset location. |
FACILITY_CD | DOUBLE | N | The unique id of the facility. |
OPEN_LOC_EX_PRINTER | VARCHAR(60) | Y | The printer que where the open location exception reports will print. |
PAR_ROUTE_ID | DOUBLE | N | The unique id of an entry on this table. |
PICK_LIST_PRINTER | VARCHAR(60) | Y | The printer que where the pick list will print. |
QOH_EX_PRINTER | VARCHAR(60) | Y | The printer que where the stock out exception will print. |
ROOT_LOC_CD | DOUBLE | N | The inventory view for this route. |
ROUTE_DESC | VARCHAR(100) | Y | The description of the route. |
UOM_EX_PRINTER | VARCHAR(60) | Y | The printer que where unit of measure change exceptions will print. |
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. |
MM_PAR_ROUTE_LOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MM PAR ROUTE LOG |
Definition: | Log information about the route and locations visited. |
Table Type: | ACTIVITY |
Column Detail - MM_PAR_ROUTE_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
CREATE_APPLCTX | DOUBLE | Y | Application which created this row |
CREATE_DT_TM | DATETIME | Y | The date/time this entry was created. |
CREATE_ID | DOUBLE | N | ID of user who created this row |
CREATE_TASK | DOUBLE | Y | Task which created this row |
END_DT_TM | DATETIME | Y | The date/time the last item at the asset location on the route was counted. |
LOCATION_CD | DOUBLE | N | The unique id of the asset location on the route. |
PAR_DEVICE_LOG_ID | DOUBLE | N | The unique device log id associated with the routes asset locations. |
PAR_ROUTE_LOG_ID | DOUBLE | N | The unique id of this entry. |
START_DT_TM | DATETIME | Y | The date/time the first item at the asset location is displayed. |
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 - MM_PAR_ROUTE_LOG
Child Column in MM_PAR_ROUTE_LOG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PAR_DEVICE_LOG_ID | MM_PAR_DEVICE_LOG | PAR_DEVICE_LOG_ID |