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 |