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. |