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