Table Detail Report

MM_APPROVAL_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM APPROVAL LOG
Definition: Approvals DB update logging table.
Table Type: ACTIVITY





Column Detail - MM_APPROVAL_LOG


Column Name Type Null? Definition
APPROVAL_STATUS DOUBLE Y Set to Rejected or Approved depending on the action taken by the approver.
ITEM_DESC VARCHAR(100) Y Item description.
ITEM_ID DOUBLE N Foreign key to Item definition table.
ITEM_NBR VARCHAR(40) Y Item number.
LINE_ITEM_ID DOUBLE N Foreign key to Line item table.
MM_APPROVAL_LOG_ID DOUBLE N Primary Key.
PACKAGE_TYPE_ID DOUBLE N Foreign key to Package type table.
PRSNL_ID DOUBLE N Foreign key, the prsnl_id of the person from the personnel table (prsnl)
REQUISITION_ID DOUBLE N Foreign key to Requisition table.
REQ_LINE_COST DOUBLE Y Cost of the requisition line.
REQ_LINE_PKG VARCHAR(40) Y Package of the Requisition line.
REQ_LINE_QTY DOUBLE Y Requisition line quantity.
REQ_LOC_CD DOUBLE N Requisition Location Code Value
REQ_NBR VARCHAR(40) Y Requisition 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.



Relationship Detail - MM_APPROVAL_LOG


Child Column in MM_APPROVAL_LOG(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
LINE_ITEM_ID LINE_ITEM LINE_ITEM_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
PRSNL_ID PRSNL PERSON_ID
REQUISITION_ID REQUISITION REQUISITION_ID


MM_APPROVAL_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains the requisition lines set for an approval process.
Definition: Contains the requisition lines routed for an approval process.
Table Type: ACTIVITY





Column Detail - MM_APPROVAL_QUEUE


Column Name Type Null? Definition
APPROVAL_AMOUNT DOUBLE Y Approval amount.
APPROVAL_QUEUE_ID DOUBLE N Primary key.
CLASS_NODE_ID DOUBLE N Foreign key to class node table.
COST_CENTER_CD DOUBLE N Cost center code value
CREATE_APPLCTX DOUBLE N The application context number from the record info block.
CREATE_DT_TM DATETIME N The date and time the row was was inserted.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
CREATE_TASK DOUBLE N The registered (assigned) task number for the process that inserted the row.
CUR_LEVEL DOUBLE Y % curent %
DESCRIPTION VARCHAR(40) Y Description of the approval.
FILL_LOCATION_CD DOUBLE N Internal or external location of the item.
FILL_LOC_COST DOUBLE Y Fill location cost.
IN_PROCESS_IND DOUBLE Y Indicator used to determine which lines are currently being processed
ITEM_DESC VARCHAR(255) Y Item description.
ITEM_ID DOUBLE N Foreign key to item master
ITEM_NBR VARCHAR(40) Y Item number.
LINE_ITEM_ID DOUBLE N Foreign Key.
MIN_APPROVAL_AMOUNT DOUBLE Y Minimum approval amount.
MM_APPROVAL_ID DOUBLE N foreign key to mm_approval table.
MM_APPROVAL_IND DOUBLE Y Set to 1 as an approval default. Set to 0 otherwise. Used to recognize a regular approval from a default one.
NON_CATALOG_IND DOUBLE Y Indicator used to determine if the line is a non-catalog item
ORGANIZATION_ID DOUBLE N The organization that the approval is tied too. Foreign key to organization table.
ORG_NAME VARCHAR(100) Y Organization_Name of the organization tied to the document
PACKAGE_TYPE_DESC VARCHAR(40) Y Package type description.
PACKAGE_TYPE_ID DOUBLE N This is the value of the unique primary identifier of the package type table. It is an internal system assigned number.
PRICE DOUBLE Y %requisito
PRSNL_ID DOUBLE N Foreign key, the prsnl_id of the person from the personnel table (prsnl)
QTY DOUBLE Y %requisito
REQUISITION_ID DOUBLE N Foreign key to requisition
REQ_AMOUNT DOUBLE Y %requisito
REQ_CREATE_BY VARCHAR(40) Y Person who created the requisition.
REQ_LINE_NBR DOUBLE Y Requisition line number.
REQ_LOCATION_CD DOUBLE N Requisition Location Code Value
REQ_NBR VARCHAR(40) Y Requisition number.
SYSTEM_ITEM_NBR VARCHAR(40) Y Internal system assigned 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_CD DOUBLE N Internal or external source of the item.



Relationship Detail - MM_APPROVAL_QUEUE


Child Column in MM_APPROVAL_QUEUE(FK) Parent Table Name Parent Column Name
Parents: CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
LINE_ITEM_ID LINE_ITEM LINE_ITEM_ID
FILL_LOCATION_CD LOCATION LOCATION_CD
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRSNL_ID PRSNL PERSON_ID
REQUISITION_ID REQUISITION REQUISITION_ID


MM_APPROVAL_STG



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM APPROVAL STG
Definition:
Table Type: ACTIVITY





Column Detail - MM_APPROVAL_STG


Column Name Type Null? Definition
CREATE_APPLCTX DOUBLE N The application context number from the record info block.
CREATE_DT_TM DATETIME N The date and time the row was was inserted.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
CREATE_TASK DOUBLE N The registered (assigned) task number for the process that inserted the row.
LINE_ITEM_ID DOUBLE N Primary key for the requsition line.
REQUISITION_ID DOUBLE N Primary key for the requsition header.



Relationship Detail - MM_APPROVAL_STG


Child Column in MM_APPROVAL_STG(FK) Parent Table Name Parent Column Name
Parents: LINE_ITEM_ID LINE_ITEM LINE_ITEM_ID
REQUISITION_ID REQUISITION REQUISITION_ID


MM_REQ_FILL_ROUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Materials Management Requisition Fill Route
Definition: stores the association of requesting location and its fill location (for internal fill) as well as its purchasing and receiving profile (for external fill).
Table Type: REFERENCE





Column Detail - MM_REQ_FILL_ROUTE


Column Name Type Null? Definition
CLASS_NODE_ID DOUBLE N Class Node ID value.
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 User id of person which created this row
CREATE_TASK DOUBLE Y Task which created this row
FILL_LOC_CD DOUBLE N The internal location from where the requisition is to be filled.
FILL_LOC_SEQ DOUBLE Y The sequence of the fill location, the smaller sequence will be chosen first if it qualifies.
IN_TRANSIT_IND DOUBLE N In-Transit functionality tracks that ordered goods/items have been received in the requesting location but still not delivered to the delivery location. This column indicates if this functionality in mmreqrouting.exe is supported for the specified location.
ITEM_ID DOUBLE N ID value of the Item
ITEM_TYPE_CD DOUBLE N The type of item that is being requisitioned. Can be item master, equipment master, medication definition or all 3 types.
LOC_HIERARCHY_FLAG DOUBLE N Indicates which workflow this location hierarchy was built for.
MM_REQ_FILL_ROUTE_ID DOUBLE N Unique, generated number that uniquely identifies a single row on the MM_REQ_FILL_ROUTE table.
POINT_OF_USE_IND DOUBLE N Identifies rows that belong to the POU workflow.
PUR_PROFILE_ID DOUBLE N The Purchase Profile associated to the requisition location.
RCV_PROFILE_ID DOUBLE N Receiving Profile associated to the requisition location.
REQ_LOC_CD DOUBLE N Requisition Location Code Value
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_REQ_FILL_ROUTE


Child Column in MM_REQ_FILL_ROUTE(FK) Parent Table Name Parent Column Name
Parents: CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
ITEM_ID ITEM_DEFINITION ITEM_ID
PUR_PROFILE_ID MM_PROFILE PROFILE_ID
RCV_PROFILE_ID MM_PROFILE PROFILE_ID


MM_ROL_TEMPLATE



Column Section Top of Page


Table-level Detail

Description: MM Role Template
Definition: Contains all of the templates created for Recommended Order List so user can load previously created template and execute the application using the template.
Table Type: REFERENCE





Column Detail - MM_ROL_TEMPLATE


Column Name Type Null? Definition
CLASS_NODE1_ID DOUBLE N The first of up to 5 class nodes in the template used as filters for the item.
CLASS_NODE2_ID DOUBLE N % noded %
CLASS_NODE3_ID DOUBLE N % noded %
CLASS_NODE4_ID DOUBLE N The fourth of up to 5 class nodes in the template used as filters for the item.
CLASS_NODE5_ID DOUBLE N The last of up to 5 class nodes in the template used as filters for the item.
COMMIT_IND DOUBLE Y Indicator to commit internally sourced requisition.
CREATE_ES_IND DOUBLE Y Indicator to create externally sourced requisition.
CREATE_IS_IND DOUBLE Y Indicator to create internally sourced requisition.
EXT_COMMIT_IND DOUBLE N Commit indicator for externally-sourced requisition.
FILL_LOCATION1_CD DOUBLE N The first of up to 5 fill locations for the ordering location.
FILL_LOCATION2_CD DOUBLE N The second of up to 5 fill locations for the ordering location.
FILL_LOCATION3_CD DOUBLE N The third of up to 5 fill locations for the ordering location.
FILL_LOCATION4_CD DOUBLE N The fourth of up to 5 fill locations for the ordering location.
FILL_LOCATION5_CD DOUBLE N The last of up to 5 fill locations for the ordering location.
FROM_DT_TM DATETIME Y The beginning date for this period.
ITEM_A_IND DOUBLE Y Indicator to only retrieve item under 'A' classification (based on the price).
ITEM_B_IND DOUBLE Y Indicator to only retrieve item under 'B' classification (based on the price).
ITEM_C_IND DOUBLE Y Indicator to only retrieve item under 'C' classification (based on the price).
ITEM_TYPE_CD DOUBLE N The type of items that should be retrieved. Can be item master, equipment master, medication definition or all 3 types.
ORDER_LOCATION_CD DOUBLE N The location where the order was placed.
OUTPUT_DIST VARCHAR(100) Y Where the ROL report should print.
RECALC_TYPE_CD DOUBLE N How ROL will recalculate the reorder quantity. Can be PAR method, economic quantity method or all reorder types method.
REPORT_TYPE_CD DOUBLE N The coded identifier for the scheduling report type.
ROOT_LOC_CD DOUBLE N The inventory view for this route.
TEMPLATE_ID DOUBLE N Unique, generated number that identifies a single row on the MM_ROL_TEMPLATE table.
TEMPLATE_NAME VARCHAR(60) Y The name of the template.
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.
VENDOR1_CD DOUBLE N The first of up to 5 vendors designated to fill the ordering location.
VENDOR2_CD DOUBLE N The second of up to 5 vendors designated to fill the ordering location.
VENDOR3_CD DOUBLE N The third of up to 5 vendors designated to fill the ordering location.
VENDOR4_CD DOUBLE N The fourth of up to 5 vendors designated to fill the ordering location.
VENDOR5_CD DOUBLE N The last of up to 5 vendors designated to fill the ordering location.