Table Detail Report

MM_TRANS_ERROR_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM TRANS ERROR LOG
Definition: Mat Mgmt Transaction Error Log
Table Type: ACTIVITY





Column Detail - MM_TRANS_ERROR_LOG


Column Name Type Null? Definition
CREATE_APPLCTX DOUBLE N Application which created this row
CREATE_DT_TM DATETIME N 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
ERROR_LOG_ID DOUBLE N Unique, generated key for MM_TRANS_ERROR_LOG.
MM_TRANS_GL_ID DOUBLE N Transaction General Ledger ID
MM_TRANS_LINE_ID DOUBLE N Transaction Line ID
TRANSACTION_ID DOUBLE N Transaction ID
TRANS_COMMENT VARCHAR(255) Y Transaction Comment
TRANS_ERROR_CD DOUBLE N Transaction Error 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_TRANS_ERROR_LOG


Child Column in MM_TRANS_ERROR_LOG(FK) Parent Table Name Parent Column Name
Parents: MM_TRANS_GL_ID MM_TRANS_GL MM_TRANS_GL_ID
TRANSACTION_ID MM_TRANS_HEADER TRANSACTION_ID
MM_TRANS_LINE_ID MM_TRANS_LINE MM_TRANS_LINE_ID


MM_TRANS_GL



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM TRANS GL
Definition: Mat Mgmt General Ledger Transaction
Table Type: ACTIVITY





Column Detail - MM_TRANS_GL


Column Name Type Null? Definition
ADDITIONAL_TYPE_CD DOUBLE N The type of additional amount from the ADDITIONAL_AMOUNT table.
AMOUNT DOUBLE Y Additional Amount
CREATE_APPLCTX DOUBLE N Application which created this row
CREATE_DT_TM DATETIME N The date/time this entry was created.
CREATE_ID DOUBLE N User id of person which created this row
CREATE_TASK DOUBLE N Task which created this row
FROM_COMPANY_CODE VARCHAR(16) Y The company code defined in the Org tool while defining the organization alias.
FROM_COST_CENTER_CD DOUBLE N The cost center from which the transaction originated.
FROM_COST_CENTER_DESC VARCHAR(60) Y The description of the cost center from which the transaction originated.
FROM_COST_CENTER_DISP VARCHAR(40) Y The display value of the cost center from which the transaction originated.
FROM_ORG_ID DOUBLE N The organization from which the transaction originated.
FROM_ORG_NAME VARCHAR(100) Y The name of the organization from which the transaction originated.
FROM_SUB_ACCOUNT_CD DOUBLE N The sub account from which the transaction originated.
FROM_SUB_ACCOUNT_DESC VARCHAR(60) Y The description of the sub account from which the transaction originated.
FROM_SUB_ACCOUNT_DISP VARCHAR(40) Y The display value of the sub account from which the transaction originated.
MM_PROJECT_NBR_TRACKING_ID DOUBLE N The project associated to this group of transactions.
MM_TRANS_GL_ID DOUBLE N Unique, generated key for MM_TRANS_GL.
MM_TRANS_LINE_ID DOUBLE N Transaction Line ID
TO_COMPANY_CODE VARCHAR(16) Y The target company code defined in the Org tool while defining the organization alias.
TO_COST_CENTER_CD DOUBLE N The target cost center for the transaction.
TO_COST_CENTER_DESC VARCHAR(60) Y The description of the target cost center for the transaction.
TO_COST_CENTER_DISP VARCHAR(40) Y The display value of the target cost center for the transaction.
TO_ORG_ID DOUBLE N The target organization for the transaction.
TO_ORG_NAME VARCHAR(100) Y The name of the target organization for the transaction.
TO_SUB_ACCOUNT_CD DOUBLE N The target sub account for the transaction.
TO_SUB_ACCOUNT_DESC VARCHAR(60) Y The description of the target sub account for the transaction.
TO_SUB_ACCOUNT_DISP VARCHAR(40) Y The display value for the target sub account for the transaction.
TRANSACTION_ID DOUBLE N The identifier for the transaction.
TRANS_STATUS_CD DOUBLE N Code which specifies the status of the transaction.
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_TRANS_GL


Child Column in MM_TRANS_GL(FK) Parent Table Name Parent Column Name
Parents: MM_PROJECT_NBR_TRACKING_ID MM_PROJECT_NBR_TRACKING MM_PROJECT_NBR_TRACKING_ID
TRANSACTION_ID MM_TRANS_HEADER TRANSACTION_ID
MM_TRANS_LINE_ID MM_TRANS_LINE MM_TRANS_LINE_ID




Parent Column in MM_TRANS_GL (PK) Child Table Name Child Column Name
Children: MM_TRANS_GL_ID MM_TRANS_ERROR_LOG MM_TRANS_GL_ID


MM_TRANS_HEADER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Header
Definition: mm trans header
Table Type: ACTIVITY





Column Detail - MM_TRANS_HEADER


Column Name Type Null? Definition
BATCH_ID DOUBLE N batch identifier value
BATCH_SUBMIT_DT_TM DATETIME Y identifies the date and time that the batch was submitted to FSI
CREATE_APPLCTX DOUBLE N Application which created this row
CREATE_DT_TM DATETIME N 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
DISTRIBUTION_ID DOUBLE N Foreign key to distribution table
DIST_NBR VARCHAR(40) Y Distribution Number
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PARENT_ENTITY_ID DOUBLE N Foreign key to the parent table that caused the inventory transaction
PARENT_ENTITY_NAME VARCHAR(32) Y Table name of the foreign key referenced in the parent_entity_id attribute.
PARENT_ENTITY_REF VARCHAR(40) Y A description of the type of data stored in the PARENT_ENTITY_ID/PARENT_ENTITY_NAME columns.
PO_NBR VARCHAR(40) Y PO Number
PO_RECEIPT_ID DOUBLE N Foreign key to po_receipt table
PO_RECEIPT_NBR VARCHAR(10) Y The receipt sequence number.
PURCHASE_ORDER_ID DOUBLE N Purchase Order ID
REQUISITION_ID DOUBLE N Foreign key to requisition table
REQ_NBR VARCHAR(40) Y Requisition Number
TRANSACTION_ID DOUBLE N Transaction ID
TRANS_APP_NAME VARCHAR(60) Y Application which created this transaction.
TRANS_DT_TM DATETIME N Date this transaction was created.
TRANS_NUMBER VARCHAR(40) Y Transaction Number.
TRANS_PERSON_ID DOUBLE N User id of person who created this transaction
TRANS_PERSON_NAME VARCHAR(100) Y User name of person who created this transaction.
TRANS_REQ_NAME VARCHAR(40) Y Request which created this transaction.
TRANS_TASK_NAME VARCHAR(60) Y Task which created this transaction.
TRANS_TYPE_CD DOUBLE N Transaction type code value
TRANS_TYPE_DESC VARCHAR(60) Y Description of the Transaction Type.
TRANS_TYPE_DISP VARCHAR(40) Y Display of the Transaction Type.
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_TRANS_HEADER


Child Column in MM_TRANS_HEADER(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID DISTRIBUTION DISTRIBUTION_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
TRANS_PERSON_ID PERSON PERSON_ID
PO_RECEIPT_ID PO_RECEIPT PO_RECEIPT_ID
PURCHASE_ORDER_ID PURCHASE_ORDER PURCHASE_ORDER_ID
REQUISITION_ID REQUISITION REQUISITION_ID
BATCH_ID SI_BATCH BATCH_ID




Parent Column in MM_TRANS_HEADER (PK) Child Table Name Child Column Name
Children: TRANSACTION_ID MM_LOT_RELTN TRANSACTION_ID
MM_TRANS_ERROR_LOG TRANSACTION_ID
MM_TRANS_GL TRANSACTION_ID


MM_TRANS_LINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM Transaction Line
Definition: MM Trans Line Table
Table Type: ACTIVITY





Column Detail - MM_TRANS_LINE


Column Name Type Null? Definition
ACTUAL_FROM_PKG_TYPE_ID DOUBLE N ACTUAL PACKAGE TYPE passed for FROM LOCATION. column
ACTUAL_FROM_QTY_UNIT_COST DOUBLE Y ACTUAL UNIT COST for the PACKAGE TYPE passed for FROM LOCATION. column
ACTUAL_FROM_TRANS_QTY DOUBLE Y ACTUAL QUANTITY of packages passed for FROM LOCATION. column
ACTUAL_TO_PKG_TYPE_ID DOUBLE N ACTUAL PACKAGE TYPE passed for TO LOCATION. column
ACTUAL_TO_TRANS_QTY DOUBLE Y ACTUAL QUANTITY of packages passed for TO LOCATION. column
BASE_PKG_DESC VARCHAR(100) Y Description of base package type column
BASE_PKG_QTY DOUBLE Y Base package type quantity column
BASE_PKG_TYPE_ID DOUBLE N Foreign key to package type column
BASE_PKG_UOM_CD DOUBLE N Base package type unit of measure code value column
BASE_PKG_UOM_DESC VARCHAR(60) Y Base package type unit of measure description column
BASE_PKG_UOM_DISP VARCHAR(40) Y Base package type unit of measure display column
BASE_QTY DOUBLE Y The transaction quantity expressed in base units column
BATCH_ID DOUBLE N batch identifier value column
BATCH_SUBMIT_DT_TM DATETIME Y identifies the date and time that the batch was submitted to FSI column
BILL_ONLY_IND DOUBLE Y Bill Only Indicator column
CONSIGN_IND DOUBLE Y If 1, then the item is consigned either at from location or to location. column
CONSIGN_PROCESS_FLAG DOUBLE Y If 1, then it means that the line is already been processed and an extract is already been created for that transaction line. For now, we are NOT USING this flag. column
CONTROL_NBR VARCHAR(40) Y The items control number column
COST_OVERRIDE_IND DOUBLE Y If 1, the user manually entered a cost instead of accepting the default. column
CREATE_APPLCTX DOUBLE N Application which created this row column
CREATE_DT_TM DATETIME N The date/time this entry was created. column
CREATE_ID DOUBLE N User id of person which created this row column
CREATE_TASK DOUBLE N Task which created this row column
DB_AVG_COST DOUBLE Y The difference between old average cost and new average cost. column
DB_LAST_COST DOUBLE Y The difference between old last cost and new last cost. column
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. column
FROM_AVERAGE_COST_NEW DOUBLE Y The new average cost for the "from" location column
FROM_AVERAGE_COST_OLD DOUBLE Y The old average cost for the "from" location column
FROM_LAST_COST_NEW DOUBLE Y The from locations new last-cost column
FROM_LAST_COST_OLD DOUBLE Y The from locations old last-cost column
FROM_LOCATION_CD DOUBLE N The From location"s code value column
FROM_LOCATION_DESC VARCHAR(60) Y The From locations description column
FROM_LOCATION_DISP VARCHAR(40) Y The From locations display column
FROM_LOCATOR_CD DOUBLE N locator column
FROM_LOCATOR_DESC VARCHAR(60) Y locator description column
FROM_LOCATOR_DISP CHAR(40) Y Locator Display column
FROM_PKG_DESC VARCHAR(100) Y The From locations package description column
FROM_PKG_QTY DOUBLE Y Quantity of the From Package Type. column
FROM_PKG_TYPE_ID DOUBLE N ID value of the From Package Type column
FROM_PKG_UOM_CD DOUBLE N From package type unit of measure code value column
FROM_PKG_UOM_DESC VARCHAR(60) Y From package type unit of measure description column
FROM_PKG_UOM_DISP VARCHAR(40) Y From package type unit of measure display column
FROM_QOH_NEW DOUBLE Y New Quantity of Hand at From Location column
FROM_QOH_OLD DOUBLE Y Old Quantity of Hand at From Location column
FROM_QOH_TYPE_CD DOUBLE N Quantity of Hand Type Code Value at From Location column
FROM_QOH_TYPE_DESC VARCHAR(60) Y Quantity of Hand Type Description at From Location column
FROM_QOH_TYPE_DISP VARCHAR(40) Y Quantity of Hand Type Display at From Location column
FROM_QTY_UNIT_COST DOUBLE Y Each unit cost of the From Qty. column
FROM_TRANS_QTY DOUBLE Y From Transaction Quantity column
HOLD_IND DOUBLE Y Hold Indicator column
IMPACT_USAGE_IND DOUBLE Y Impact Usage Indicator column
INIT_DISP_TRANS_LINE_ID DOUBLE N In POU workflow, if the user does a return or waste transaction against a dispensed item, this column will store the transaction id of initial dispensed row
ITEM_DESC VARCHAR(255) Y Item Description column
ITEM_DESC_ID DOUBLE N ID value of the Item Description column
ITEM_ID DOUBLE N ID value of the Item column
ITEM_NBR VARCHAR(255) Y Item Number column
ITEM_NBR_ID DOUBLE N ID value of the Item Number column
ITEM_TYPE_CD DOUBLE N Item Type Code Value column
ITEM_TYPE_DESC VARCHAR(60) Y Item Type Description column
ITEM_TYPE_DISP VARCHAR(40) Y Item Type Display column
LINE_ITEM_ID DOUBLE N Foreign key to the line_item table. column
LOT_PARENT_ENTITY_ID DOUBLE N Unique identifier from the tables that appear in column parent_entity_name.
LOT_PARENT_ENTITY_NAME VARCHAR(32) N The uppercase name of the table to which this row is related.
MANUFACTURER_CD DOUBLE N In POU workflow, if the user dispenses an item, this field will hold the manufacturer cd of the dispensed item.
MFR_CATALOG_NBR_ID DOUBLE N To store identifier_id of dispensed manufacturer catalog number.
MFR_CATALOG_NBR_TXT VARCHAR(200) Y In POU workflow, if the user dispenses an item, this field will hold the manufacturer catalog number of the dispensed item.
MISC_CODE VARCHAR(40) Y Misc. Code column
MM_PROJECT_NBR_TRACKING_ID DOUBLE N The project for this transaction line.
MM_TRANS_LINE_ID DOUBLE N Transaction Line ID column
OFFSET_LOCATION_CD DOUBLE N This location, if specified, will be used to determine the offsetting cost center and subaccount for the specified transaction.
PATIENT_ID DOUBLE N The person_id of the person from the person table. column
PCB_AVG_COST DOUBLE Y The percent change between old average cost and new average cost. column
PCB_LAST_COST DOUBLE Y The percent change between old last cost and new last cost. column
PERFORMING_LOC_CD DOUBLE N In POU workflow, the user can dispense an item from a fill location to a performing location. This column is used to record the performing location to which the supply item is supplied to.
PO_LINE_NBR DOUBLE Y PO Line Number column
PRICE_CHANGED_QTY DOUBLE Y Price Changed Quantity. column
PRICE_COST_NEW DOUBLE Y New Price Cost. column
PRICE_COST_OLD DOUBLE Y Old Price Cost. column
PRICE_ORIGINAL_TRANS_DT_TM DATETIME Y Price Original Transaction Date. column
PRICE_ORIGINAL_TRANS_ID DOUBLE N x column
PRICE_PO_ID DOUBLE N x column
PRICE_PO_NBR VARCHAR(40) Y x column
PRICE_VENDOR_CD DOUBLE N Price Vendor Code Value column
PRICE_VENDOR_DESC VARCHAR(60) Y Price Vendor Description column
PRICE_VENDOR_DISP VARCHAR(40) Y Price Vendor Display column
PROJECT_CODE_CD DOUBLE N Project Code Value column
PROJECT_CODE_DESC VARCHAR(60) Y Project Code Description column
PROJECT_CODE_DISP VARCHAR(40) Y Project Code Display column
QOH_FLAG DOUBLE N This flag will determine which solution is updating the quantity on hand record. column
REASON_CD DOUBLE N Reason Code Value column
REASON_DESC VARCHAR(60) Y Reason Description column
REASON_DISP VARCHAR(40) Y Reason Display column
RECEIPT_LINE_ITEM_ID DOUBLE N Foreign key to receipt_line_item table column
REQ_LINE_NBR DOUBLE Y Requisition Line Number column
SCANNED_ITEM_BARCODE VARCHAR(255) Y Barcode text that is scanned to identify the item.
TO_AVERAGE_COST_NEW DOUBLE Y New To Average Cost column
TO_AVERAGE_COST_OLD DOUBLE Y Old To Average Cost column
TO_LAST_COST_NEW DOUBLE Y New To Last Cost column
TO_LAST_COST_OLD DOUBLE Y Old To Last Cost column
TO_LOCATION_CD DOUBLE N To Location Code Value column
TO_LOCATION_DESC VARCHAR(60) Y To Location Code Description column
TO_LOCATION_DISP VARCHAR(40) Y To Location Code Display column
TO_LOCATOR_CD DOUBLE N To Locator Code Value column
TO_LOCATOR_DESC VARCHAR(60) Y To Locator Description column
TO_LOCATOR_DISP VARCHAR(40) Y To Locator Display column
TO_PKG_DESC VARCHAR(100) Y To Package Type Description column
TO_PKG_QTY DOUBLE Y To Package Type Quantity column
TO_PKG_TYPE_ID DOUBLE N To Package Type ID column
TO_PKG_UOM_CD DOUBLE N To package type unit of measure code value column
TO_PKG_UOM_DESC VARCHAR(60) Y To package type unit of measure description column
TO_PKG_UOM_DISP VARCHAR(40) Y To package type unit of measure display column
TO_QOH_NEW DOUBLE Y New Quantity of Hand at To Location column
TO_QOH_OLD DOUBLE Y Old Quantity of Hand at To Location column
TO_QOH_TYPE_CD DOUBLE N Quantity of Hand Type Code Value at To Location column
TO_QOH_TYPE_DESC VARCHAR(60) Y Quantity of Hand Type Description at To Location column
TO_QOH_TYPE_DISP VARCHAR(40) Y Quantity of Hand Type Display at To Location column
TO_QTY_UNIT_COST DOUBLE Y Each unit cost of theTo Qty. column
TO_TRANS_QTY DOUBLE Y To Transaction Quantity column
TRANSACTION_ID DOUBLE N ID value of the Transaction column
TRANSFER_FLAG DOUBLE N Used to determine whether an average cost is calculated at the fill location.
TRANS_PARENT_TRANS_ID DOUBLE N Transaction Id column
TRANS_STATUS_CD DOUBLE N Code which specifies the status of the transaction. column
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_TRANS_LINE


Child Column in MM_TRANS_LINE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ITEM_DESC_ID IDENTIFIER IDENTIFIER_ID
ITEM_NBR_ID IDENTIFIER IDENTIFIER_ID
MFR_CATALOG_NBR_ID IDENTIFIER IDENTIFIER_ID
ITEM_ID ITEM_MASTER ITEM_ID
LINE_ITEM_ID LINE_ITEM LINE_ITEM_ID
PERFORMING_LOC_CD LOCATION LOCATION_CD
MM_PROJECT_NBR_TRACKING_ID MM_PROJECT_NBR_TRACKING MM_PROJECT_NBR_TRACKING_ID
INIT_DISP_TRANS_LINE_ID MM_TRANS_LINE MM_TRANS_LINE_ID
PRICE_ORIGINAL_TRANS_ID MM_TRANS_LINE MM_TRANS_LINE_ID
BASE_PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
FROM_PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
TO_PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
PATIENT_ID PERSON PERSON_ID
RECEIPT_LINE_ITEM_ID RECEIPT_LINE_ITEM RECEIPT_LINE_ITEM_ID
BATCH_ID SI_BATCH BATCH_ID




Parent Column in MM_TRANS_LINE (PK) Child Table Name Child Column Name
Children: MM_TRANS_LINE_ID MM_INSTANCE_TRANS_LINE_R MM_TRANS_LINE_ID
MM_TRANS_ERROR_LOG MM_TRANS_LINE_ID
MM_TRANS_GL MM_TRANS_LINE_ID
MM_TRANS_IDENTIFIER_RELTN MM_TRANS_LINE_ID
MM_TRANS_LINE INIT_DISP_TRANS_LINE_ID
MM_TRANS_LINE PRICE_ORIGINAL_TRANS_ID