Table Detail Report

MM_PROFILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM PROFILE
Definition: Contains the different user profiles used by multiple ProCure applications.
Table Type: REFERENCE





Column Detail - MM_PROFILE


Column Name Type Null? Definition
ACK_VAR_AMT DOUBLE Y The currency amount in which the acknowledged can vary compared to the purchased.
ACK_VAR_IND DOUBLE Y Indicates whether or not to check for this type of variance.
ACK_VAR_PCT DOUBLE Y The percent in which the acknowledged can vary compared to the purchased.
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALLOW_BACKORDER_IND DOUBLE Y Indicates whether or not this profile will allow backorders.
ALLOW_OVERSHIPMENT_IND DOUBLE Y Indicates whether or not this profile will allow overshipments.
ALLOW_REMAINING_SHELF_LIFE_IND DOUBLE N Indicates that the user wants to activate the remaining shelf life functionality.
AUTO_PAY_IND DOUBLE Y Determines whether the option is selected or not in mmprofile.exe. 0 = Auto pay option is not selected for the Invoicing profile, 1 = Auto pay option is selected for the invoicing profile.
BLANK_INV_DATE_IND DOUBLE N Indicates if the invoice date should be blank by default while creating a new invoice.
BLIND_RECEIPT_IND DOUBLE Y Indicates whether or not this profile institutes blind receiving.
CONTRACT_VAR_AMT DOUBLE Y The currency amount in which the contract can vary compared to the invoiced.
CONTRACT_VAR_IND DOUBLE Y Indicates whether or not to check for contract price variance.
CONTRACT_VAR_PCT DOUBLE Y The percent amount in which the contract can vary compared to the invoiced.
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y 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 Y The registered (assigned) task number for the process that inserted the row.
DEFAULT_FROM_RECEIVING_IND DOUBLE Y If true then invoice matching will automatically pull the cost center and subaccount information from the cost center and subaccount defined in transacctmaintenance for a given purchase receipt.
DESCRIPTION VARCHAR(60) Y The description of this profile.
DISPLAY VARCHAR(40) Y The display (short description) for this profile.
EXCEPTION_EMAIL VARCHAR(255) Y Contains the email address defined in mmprofilebuild.exe
EXCEPTION_PRINTER VARCHAR(60) Y Contains the printer name defined in mmprofilebuild
INV_ADDL_AMT_VAR_AMT DOUBLE Y invoice additional amount variable amount
INV_ADDL_AMT_VAR_IND DOUBLE Y determines whether the variance has to calculated for Additional amount0 - Variance will not be calculated for additional amount1 - Variance will be calculated for additional amount
INV_SAVE_MISMATCH_IND DOUBLE N Indicates whether to save the invoice in PAY status if voucher and invoice amounts are not matched.
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.
MANUAL_RECEIPT_IND DOUBLE Y Indicates whether or not this profile institutes manual receiving.
ORGANIZATION_ID DOUBLE N This is the organization that the profile is tied too.
PO_INVOICE_LESS_VAR_AMT DOUBLE N Stores the lesser variance limit amount for invoice line amount.
PO_INVOICE_LESS_VAR_PCT DOUBLE N Stores the lesser variance limit percentage for invoice line amount.
PO_INVOICE_VAR_AMT DOUBLE Y PO / Invoice Variance Amount
PO_INVOICE_VAR_PCT DOUBLE Y PO / Invoice Variance Percent
PO_MAX_LINES DOUBLE Y The maximum allowed lines per purchase order.
PROFILE_ID DOUBLE N Primary key
PROFILE_TYPE_CD DOUBLE N The type of profile.
RCV_LOC_CD DOUBLE N The location at which shipments are received for this profile.
REMAINING_SHELF_LIFE_PCT DOUBLE N The acceptable remaining shelf life for the item under the specific profile.
UNIT_PRICE_IND DOUBLE Y *** OBSOLETE ***
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_PRICE_IND DOUBLE Y Used to determine if the user can view the price in the receiving application.



Relationship Detail - MM_PROFILE


Child Column in MM_PROFILE(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in MM_PROFILE (PK) Child Table Name Child Column Name
Children: PROFILE_ID INVOICE INV_PROFILE_ID
MM_PROFILE_GROUP PROFILE_ID
MM_REQ_FILL_ROUTE PUR_PROFILE_ID
MM_REQ_FILL_ROUTE RCV_PROFILE_ID
PURCHASE_ORDER PUR_PROFILE_ID
PURCHASE_ORDER RCV_PROFILE_ID
VENDOR_SITE RCV_PROFILE_ID


MM_PROFILE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM PROFILE GROUP
Definition: A generic relationship table for the mm_profile table.
Table Type: REFERENCE





Column Detail - MM_PROFILE_GROUP


Column Name Type Null? Definition
PARENT_ENTITY_ID DOUBLE N Parent Entity ID
PARENT_ENTITY_NAME CHAR(32) N The name of the table in which the parent_entity_id field originated.
PROFILE_ID DOUBLE N Foreign key to mm_profile 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_PROFILE_GROUP


Child Column in MM_PROFILE_GROUP(FK) Parent Table Name Parent Column Name
Parents: PROFILE_ID MM_PROFILE PROFILE_ID


MM_PROJECT_NBR_TRACKING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Project Number Tracking
Definition: Stores information about Purchasing projects.
Table Type: REFERENCE





Column Detail - MM_PROJECT_NBR_TRACKING


Column Name Type Null? Definition
BEGIN_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is considered valid as active current data. This may be valued with the date that the row became active.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
INVOICED_BUDGET_AMT DOUBLE N Total amount invoiced against the budget.
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.
MM_PROJECT_NBR_TRACKING_ID DOUBLE N Unique generated number that identifies a single row on the MM_PROJECT_NBR_TRACKING table.
PREV_MM_PROJECT_NBR_TRACK_ID DOUBLE N Contains the unique ID of the previous version of the current effective row.
PROJECT_BUDGET_AMT DOUBLE N The total budget allocated for the project.
PROJECT_BUDGET_UPDT_IND DOUBLE N Indicates if the project budget amount was updated on this row.
PROJECT_DESC VARCHAR(60) N Long description of the project.
PROJECT_DESC_KEY VARCHAR(60) N Upper case version of the project long description.
PROJECT_DESC_KEY_A_NLS VARCHAR(240) N Stores the corresponding non-English character set values for the PROJECT_DESC_KEY column. Used to sort correctly internationally.
PROJECT_END_DT_TM DATETIME Y The scheduled ending date and time for the project.
PROJECT_NUMBER_TXT VARCHAR(40) N Character representation of the identifying project number.
PROJECT_NUMBER_TXT_KEY VARCHAR(40) N Character representation of the identifying project number.
PROJECT_NUMBER_TXT_KEY_A_NLS VARCHAR(160) N Stores the corresponding non-English character set values for the project_number_txt column. Used to sort correctly internationally.
PROJECT_SHORT_DESC VARCHAR(40) N A short version of the description of the project.
PROJECT_SHORT_DESC_KEY VARCHAR(40) N Uppercase standardized version of the PROJECT_SHORT_DESC.
PROJECT_SHORT_DESC_KEY_A_NLS VARCHAR(160) N Stores the corresponding non-English character set values for the project_short_desc_key column. Used to sort correctly internationally.
PROJECT_START_DT_TM DATETIME N The date and time that a project begins.
PURCHASED_BUDGET_AMT DOUBLE N Total amount purchased against the budget.
PURCHASE_ALERT_EMAIL VARCHAR(255) Y The email addresses to alert when a single purchase order commit exceeds the limit set in purchase_amt.
PURCHASE_AMT DOUBLE N The limit set for notification when the value of a single PO committed is exceeded.
RECEIVED_BUDGET_AMT DOUBLE N Total amount received against the budget.
TOTAL_INVOICE_ALERT_EMAIL VARCHAR(255) Y The email addresses to alert when the sum of all invoices committed exceeds the limit set in total_invoice_amt.
TOTAL_INVOICE_AMT DOUBLE N The limit set for notification when the sum value of all invoices is exceeded.
TOTAL_PURCHASE_ALERT_EMAIL VARCHAR(255) Y The email addresses to alert when the sum of all purchases committed exceeds the limit set in total_purchase_amt.
TOTAL_PURCHASE_AMT DOUBLE N The limit set for notification when the sum value of all purchases is exceeded.
TOTAL_RECEIVE_ALERT_EMAIL VARCHAR(255) Y The email addresses to alert when the sum of all receipts committed exceeds the limit set in total_receive_amt.
TOTAL_RECEIVE_AMT DOUBLE N The limit set for notification when the sum value of all receipts is exceeded.
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_PROJECT_NBR_TRACKING


Child Column in MM_PROJECT_NBR_TRACKING(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PREV_MM_PROJECT_NBR_TRACK_ID MM_PROJECT_NBR_TRACKING MM_PROJECT_NBR_TRACKING_ID




Parent Column in MM_PROJECT_NBR_TRACKING (PK) Child Table Name Child Column Name
Children: MM_PROJECT_NBR_TRACKING_ID ADDITIONAL_AMOUNT MM_PROJECT_NBR_TRACKING_ID
LINE_ITEM MM_PROJECT_NBR_TRACKING_ID
MM_PROJECT_NBR_TRACKING PREV_MM_PROJECT_NBR_TRACK_ID
MM_TRANS_GL MM_PROJECT_NBR_TRACKING_ID
MM_TRANS_LINE MM_PROJECT_NBR_TRACKING_ID


MM_RECEIPT_DOC_HEADER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Receipt Document Header
Definition: Used to store the header information of the T3 data that was passed from EDI 856 workflow. ;
Table Type: ACTIVITY





Column Detail - MM_RECEIPT_DOC_HEADER


Column Name Type Null? Definition
INVOICE_NBR_TXT VARCHAR(40) Y stores the invoice number passed by the vendor for historical reference.
MM_RECEIPT_DOC_HEADER_ID DOUBLE N Unique generated number that identifies a single row on the MM_RECEIPT_DOC_HEADER table.
PO_NBR_TXT VARCHAR(40) Y Stores the purchsae order number that the vendor passes for the historical reference.
PURCHASE_ORDER_ID DOUBLE Y The identifier of the purchase order associated to the po_nbr on this row.
SHIPMENT_DT_TM DATETIME Y The date and time the shipment was sent.
SHIP_FROM_ADDR VARCHAR(300) Y Vendor address where the item was shipped from.
SHIP_FROM_NAME VARCHAR(60) Y Vendor name, where the item was shipped from.
SHIP_TO_ADDR VARCHAR(300) Y Address of the facility to which the item was shipped
SHIP_TO_NAME VARCHAR(60) Y Facility to which the item was shipped;
TRANSACTION_STATEMENT_IND DOUBLE Y Indicates if the vendor accepted the transaction.
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VENDOR_COMMENT_TXT VARCHAR(300) Y The vendor comments that were made for the purchase order.



Relationship Detail - MM_RECEIPT_DOC_HEADER


Child Column in MM_RECEIPT_DOC_HEADER(FK) Parent Table Name Parent Column Name
Parents: PURCHASE_ORDER_ID PURCHASE_ORDER PURCHASE_ORDER_ID




Parent Column in MM_RECEIPT_DOC_HEADER (PK) Child Table Name Child Column Name
Children: MM_RECEIPT_DOC_HEADER_ID MM_RECEIPT_DOC_LINE MM_RECEIPT_DOC_HEADER_ID


MM_RECEIPT_DOC_LINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Receipt Documen Line
Definition: An EDI 856 transaction can contain the receipt information of multiple PO lines, this table will store the item details of each line. ;
Table Type: ACTIVITY





Column Detail - MM_RECEIPT_DOC_LINE


Column Name Type Null? Definition
ITEM_MASTER_DESC VARCHAR(255) Y Stores the item description that the vendor passes from EDI.
ITEM_MASTER_NBR_TXT VARCHAR(255) Y Stores item number for T3 documentation purpose.
LINE_ITEM_ID DOUBLE Y FK reference to the line_item table.
MFR_ADDR VARCHAR(300) Y Stores the address of the manufacturer who has manufactured the supply item.
MFR_CD DOUBLE Y The manufacturer of the item. From the MANUFACTURER_ITEM table.
MFR_NAME VARCHAR(100) Y The manufacturer of the item.
MM_RECEIPT_DOC_HEADER_ID DOUBLE Y The header that this line is a part of.
MM_RECEIPT_DOC_LINE_ID DOUBLE N Unique generated number that identifies a single row on the MM_RECEIPT_DOC_LINE table.
PACK_FACTOR_NBR DOUBLE Y FK reference to the line_item table.
SHIPPED_QTY DOUBLE Y The quantity of the item on this line that was shipped.
UOM_CD DOUBLE Y The Unit of Measure for this item.
UOM_DESC VARCHAR(100) Y UOM description for the T3 documentation purpose.
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VENDOR_ITEM_NBR_TXT VARCHAR(40) Y Stores vendor catalog for T3 documentation purpose.



Relationship Detail - MM_RECEIPT_DOC_LINE


Child Column in MM_RECEIPT_DOC_LINE(FK) Parent Table Name Parent Column Name
Parents: LINE_ITEM_ID LINE_ITEM LINE_ITEM_ID
MM_RECEIPT_DOC_HEADER_ID MM_RECEIPT_DOC_HEADER MM_RECEIPT_DOC_HEADER_ID




Parent Column in MM_RECEIPT_DOC_LINE (PK) Child Table Name Child Column Name
Children: MM_RECEIPT_DOC_LINE_ID MM_RECEIPT_DOC_LOT MM_RECEIPT_DOC_LINE_ID