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 |