Table Detail Report

MM_BUYER_ROUTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Buyer Routing
Definition: Allows for system generated purchase orders to be routed to the appropriate buyer.
Table Type: REFERENCE





Column Detail - MM_BUYER_ROUTING


Column Name Type Null? Definition
BUYER_ID DOUBLE N This denotes the buyer that the purchase order will be routed to.
BUYER_ROUTING_ID DOUBLE N Primary key column.
COST_CENTER_CD DOUBLE N Cost center code value
ORGANIZATION_ID DOUBLE N This denotes the organization (or company) that this record applies to.
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_BUYER_ROUTING


Child Column in MM_BUYER_ROUTING(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
BUYER_ID PRSNL PERSON_ID


MM_EXT_SRC_Q



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores requisition line items that need to be externally sourced and are waiting
Definition: Stores requisition line items that need to be externally sourced and are waiting to be placed on a purchase order.
Table Type: ACTIVITY





Column Detail - MM_EXT_SRC_Q


Column Name Type Null? Definition
LINE_ITEM_ID DOUBLE N The primary identifier into the line_item table.
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_EXT_SRC_Q


Child Column in MM_EXT_SRC_Q(FK) Parent Table Name Parent Column Name
Parents: LINE_ITEM_ID LINE_ITEM LINE_ITEM_ID


MM_MP_WORKLIST_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Supply CHain MPages Worklist Filter
Definition: Stores the filters for Supply Chain Mpage Worklist. Filters are stored based off User + View/Workflow.
Table Type: REFERENCE





Column Detail - MM_MP_WORKLIST_FILTER


Column Name Type Null? Definition
CREATE_PRSNL_ID DOUBLE N Refers PERSON_ID from PRSNL table. Stores the ID of User who define the filter template details.
FILTER_TEMPLATE_NAME VARCHAR(255) N Name of the Filter Template
GLOBAL_FILTER_IND DOUBLE N Indicator value would be set to 1 for the filters that are available for all the users per view. Indicator value would be set to 0 for the user's personal filters.
LONG_TEXT_ID DOUBLE N LONG_TEXT_ID from long_text_reference table that refers to the filter details stored
MM_MP_WORKLIST_FILTER_ID DOUBLE N Unique generated number that identifies a single row on the MM_MP_WORKLIST_FILTER table.
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.
VIEW_IDENTIFIER_TXT VARCHAR(30) N View Identifier created in Bedrock for the Mpages view



Relationship Detail - MM_MP_WORKLIST_FILTER


Child Column in MM_MP_WORKLIST_FILTER(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
CREATE_PRSNL_ID PRSNL PERSON_ID


MM_OMF_INVOICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM OMF INVOICE
Definition: Invoice Header : (Summary Table)
Table Type: ACTIVITY





Column Detail - MM_OMF_INVOICE


Column Name Type Null? Definition
BUYER_ID DOUBLE N Buyer ID of the Buyer
CHECKED_RCV_CNT DOUBLE Y Checked Received Count
CITY_TAX DOUBLE Y City Tax
COMPANY_NBR VARCHAR(20) Y Company Number
FREIGHT_TAX DOUBLE Y Freight Tax
INVOICE_AMOUNT DOUBLE Y Invoice Amount
INVOICE_COUNT DOUBLE Y Invoice Count
INVOICE_DT_NBR DOUBLE Y Invoice Date
INVOICE_DT_TM DATETIME Y Invoice Date and Time
INVOICE_ID DOUBLE N Invoice ID : Primary Key
INVOICE_MIN_NBR DOUBLE Y Invoice Minimum Number
INVOICE_NBR VARCHAR(20) Y Invoice Number
INV_CREATE_APPLCTX DOUBLE Y Invoice Create Application Context Number
INV_CREATE_DT_NBR DOUBLE Y Invoice Create Date
INV_CREATE_DT_TM DATETIME Y Invoice Create Date and Time
INV_CREATE_ID DOUBLE N Invoice Create ID
INV_CREATE_MIN_NBR DOUBLE Y Invoice Create Minimum Number
INV_CREATE_TASK DOUBLE Y Invoice Create Task
INV_UPDT_APPLCTX DOUBLE Y Invoice Update Application Context Number
INV_UPDT_CNT DOUBLE Y Invoice Update Count
INV_UPDT_DT_NBR DOUBLE Y Invoice Update Date
INV_UPDT_DT_TM DATETIME Y Invoice Update Date and Time
INV_UPDT_ID DOUBLE N Invoice Update Date ID
INV_UPDT_MIN_NBR DOUBLE Y Invoice Update Minimum Number
INV_UPDT_TASK DOUBLE Y Invoice Update Task
MATCHED_IND DOUBLE Y Matched Indicator
ORDER_DT_NBR DOUBLE Y Order Date Number value
ORDER_DT_TM DATETIME Y Order Date and Time value
ORDER_MIN_NBR DOUBLE Y Order Minute
ORGANIZATION_ID DOUBLE N Organization ID
OTHER_TAX DOUBLE Y Other Tax
PO_NBR VARCHAR(20) Y Purchase Order Number
PO_RCV_STATUS_CD DOUBLE N Purchase Order Receive Status Code
PO_STATUS_CD DOUBLE N Purchase Order Status Code
PURCHASE_ORDER_ID DOUBLE N Purchase Order ID
REMIT_ADDRESS_ID DOUBLE N Remit Address ID
SEQUENCE DOUBLE Y Sequence value
STATE_TAX DOUBLE Y State Tax
STATUS_CD DOUBLE N Status code value
SYSTEM_GENERATED_IND DOUBLE Y system generated indicator
TAX DOUBLE Y Tax
TERMS_CD DOUBLE N Payment Terms Code
TOTAL_INVOICE_PRICE DOUBLE Y Total Invoice Price
TOTAL_ORDER_PRICE DOUBLE Y Total Order Price
TOTAL_RCV_CNT DOUBLE Y Total Receive Count
TOTAL_RECEIPT_PRICE DOUBLE Y Total Receive Price
TOTAL_VOUCHER_PRICE DOUBLE Y Total Voucher Price
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.
VAT_TAX DOUBLE Y Vat Tax
VENDOR_CD DOUBLE N Vendor associated with this account
VENDOR_PO_REF VARCHAR(20) Y Vendor Purchase Order Preference
VENDOR_SITE_ID DOUBLE N Vendor Site ID
VOUCHER_DT_NBR DOUBLE Y Voucher Date
VOUCHER_DT_TM DATETIME Y Voucher Date and Time
VOUCHER_EFFECTIVE_DT_NBR DOUBLE Y Voucher Effective Date
VOUCHER_EFFECTIVE_DT_TM DATETIME Y Voucher Effective Date and Time
VOUCHER_EFFECTIVE_MIN_NBR DOUBLE Y Voucher Effective Minimum Number
VOUCHER_MIN_NBR DOUBLE Y Voucher Minimum Number
VOUCHER_STATUS_CD DOUBLE N Voucher Status
VOUCHER_USER_ID DOUBLE N Voucher User ID



Relationship Detail - MM_OMF_INVOICE


Child Column in MM_OMF_INVOICE(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


MM_OMF_INVOICE_LINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM OMF INVOICE LINE
Definition: Invoice Line : (Summary Table)
Table Type: ACTIVITY





Column Detail - MM_OMF_INVOICE_LINE


Column Name Type Null? Definition
BASE_ACCEPTED_QTY DOUBLE Y Base Accepted Quantity
BASE_BACK_ORDER_QTY DOUBLE Y Base Back Order Quantity
BASE_CANCEL_QTY DOUBLE Y Base Cancel Quantity
BASE_INVOICE_QTY DOUBLE Y Base Invoice Quantity
BASE_ORDER_QTY DOUBLE Y Base Order Quantity
BASE_PRICE DOUBLE Y Base Price
BASE_RECEIPT_QTY DOUBLE Y Base Receipt Quantity
BUYER_ID DOUBLE N Buyer ID of the Buyer
CHECKED_IND DOUBLE Y Checked Indicator
COMPANY_NBR VARCHAR(20) Y Company Number
COST_CENTER_CD DOUBLE N Cost center code value
DELIVER_TO_LOCATION_CD DOUBLE N Deliver to Location
EXTENDED_PRICE DOUBLE Y Extended Price
INVOICE_AMOUNT DOUBLE Y Invoice Amount
INVOICE_ID DOUBLE N Invoice ID
INVOICE_LINE_ITEM_ID DOUBLE N Invoice Line Item ID : (Primary Key)
INVOICE_NBR VARCHAR(20) Y Invoice Number
INV_MATCHED_IND DOUBLE Y Invoice Matched Indicator
ITEM_MASTER_ID DOUBLE N Item Master ID
LINE_COUNT DOUBLE Y Line Count
LINE_CREATE_DT_NBR DOUBLE Y Line Create Date
LINE_CREATE_DT_TM DATETIME Y Line Create Date and Time
LINE_CREATE_ID DOUBLE N Line Create Date ID
LINE_CREATE_MIN_NBR DOUBLE Y Line Create Minute
LINE_UPDT_DT_NBR DOUBLE Y Line Update Date
LINE_UPDT_DT_TM DATETIME Y Line Update Date and Time
LINE_UPDT_ID DOUBLE N Line Update ID
LINE_UPDT_MIN_NBR DOUBLE Y Line Update Minute
MFG_ITEM_ID DOUBLE N Foreign Key to Manufacturer Item
NC_DESCRIPTION VARCHAR(255) Y Non-catalog description
NC_MFR VARCHAR(60) Y Non-catalog manufacturer
NC_MFR_CD DOUBLE N If the non-catalog manufacturer exists in our current system. This is the code value for the corresponding manufacturer
NC_MFR_ITEM_NBR VARCHAR(20) Y Non-catalog manufacturer item number
NC_VENDOR_ITEM_NBR VARCHAR(20) Y Non-catalog vendor item number
NON_CATALOG_IND DOUBLE Y Indicator used to determine if the line is a non-catalog item
ORDER_DT_NBR DOUBLE Y Order Date Number value
ORDER_DT_TM DATETIME Y Order Date and Time value
ORDER_EXTENDED_PRICE DOUBLE Y Order Extended Price
ORDER_MIN_NBR DOUBLE Y Order Minimum Number
ORDER_PKG_DESC VARCHAR(40) Y Order Package Description
ORDER_PKG_ID DOUBLE N Order Package ID
ORDER_PKG_QTY DOUBLE Y Order Package Quantity
ORDER_PKG_UOM_CD DOUBLE N Order Package unit of Measure Code
ORDER_PRICE DOUBLE Y Order Price
ORDER_PRICE_TYPE_CD DOUBLE N Order Price Type Code
ORDER_QTY DOUBLE Y Order Quantity
ORGANIZATION_ID DOUBLE N Organization ID
PKG_DESC VARCHAR(40) Y Package Description
PKG_ID DOUBLE N Package ID
PKG_QTY DOUBLE Y Package Quantity
PKG_UOM_CD DOUBLE N Package Unit of Measure
PO_COST_CENTER_CD DOUBLE N Purchase Order Cost Center Code
PO_LINE_NBR DOUBLE Y Purchase Order Line Number
PO_NBR VARCHAR(20) Y Purchase Order Number
PO_RCV_STATUS_CD DOUBLE N Purchase Order Receive Status Code
PO_STATUS_CD DOUBLE N Purchase Order Status Code
PO_SUB_ACCOUNT_CD DOUBLE N Purchase Order Sub Account Code
PO_VENDOR_CD DOUBLE N Purchase Order Vendor Code
PRICE DOUBLE Y Price
PURCHASE_ORDER_ID DOUBLE N Purchase Order ID
QTY DOUBLE Y Quantity
REMIT_ADDRESS_ID DOUBLE N Remit Address ID
STATUS_CD DOUBLE N Status code value
SUBSTITUTION_IND DOUBLE Y Indicator used to see if the item is being substituted.
SUB_ACCOUNT_CD DOUBLE N Sub Account Code
TOTAL_ORDER_PRICE DOUBLE Y Total Order Price
TOTAL_RECEIPT_PRICE DOUBLE Y Total Receipt Price
TOTAL_VOUCHER_AMOUNT DOUBLE Y Total Voucher Amount
TRANSMIT_CD DOUBLE N Transmit Code
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 Vendor associated with this account
VENDOR_ITEM_ID DOUBLE N Foreign Key for the Vendor Item
VENDOR_SITE_ID DOUBLE N Vendor Site ID



Relationship Detail - MM_OMF_INVOICE_LINE


Child Column in MM_OMF_INVOICE_LINE(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID