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 |