MM_CNTRCT_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM CNTRCT ACTION
Definition: Contract Action
Table Type: REFERENCE





Column Detail - MM_CNTRCT_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y Action date/time
ACTION_ID DOUBLE N action identifier
CNTRCT_ID DOUBLE N Contract number key
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 inserted.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) who inserted the row in to the table.
CREATE_TASK DOUBLE Y Task which created this row
NOTIFICATION_IND DOUBLE Y notification indicator
PERIOD_CD DOUBLE N %etc
PRSNL_ID DOUBLE N Foreign key, the prsnl_id of the person from the personnel table (prsnl)
REASON_CD DOUBLE N Reason 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_CNTRCT_ACTION


Child Column in MM_CNTRCT_ACTION(FK) Parent Table Name Parent Column Name
Parents: CNTRCT_ID MM_CNTRCT_HDR CNTRCT_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in MM_CNTRCT_ACTION (PK) Child Table Name Child Column Name
Children: ACTION_ID MM_XFI_CNTRCT_ACTION ACTION_ID


MM_CNTRCT_HDR



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM CNTRCT HDR
Definition: Table used to store contract header information
Table Type: REFERENCE





Column Detail - MM_CNTRCT_HDR


Column Name Type Null? Definition
AGREEMENT_INFO VARCHAR(100) Y agreement information
CAPITAL_CD DOUBLE N Capital code code value
CATALOG_NAME VARCHAR(100) Y Catalog name
CLASS_NODE_ID DOUBLE N Class Node ID value.
CNTRCT_ID DOUBLE N Contract number key
CNTRCT_MGR_ID DOUBLE N Contract manager key
CNTRCT_NAME VARCHAR(100) Y Contract name
CNTRCT_NBR VARCHAR(40) N Contract number
CNTRCT_NBR_KEY VARCHAR(40) N contract number key
CNTRCT_NBR_KEY_A_NLS VARCHAR(160) Y CNTRCT_NBR_KEY_A_NLS column
CNTRCT_NBR_KEY_NLS VARCHAR(40) N contract number key nls
CNTRCT_SRC_TYPE_CD DOUBLE N Contract source type code value
CNTRCT_TERM_CD DOUBLE N Contract term code value
CNTRCT_TYPE_CD DOUBLE N Contract type code value
COST_CENTER_CD DOUBLE N Cost center code value
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 inserted.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) who inserted the row in to the table.
CREATE_TASK DOUBLE Y Task which created this row
DESCRIPTION VARCHAR(255) Y Contract description
EFFECTIVE_DT_TM DATETIME Y Effective Date and Time value
EXCEED_PRICE_IND DOUBLE Y Exceed price indicator
EXECUTED_BY_ORG VARCHAR(100) Y Executed by organization
EXECUTED_BY_VENDOR VARCHAR(100) Y Executed by vendor
EXECUTED_DT_TM DATETIME Y Executed date/time
EXPIRATION_DT_TM DATETIME Y Expiration date/time
EXT_CNTRCT_IND DOUBLE Y Extend contract indicator
EXT_END_DT_TM DATETIME Y Extension end date/time
EXT_NOTE VARCHAR(255) Y Extension notes
EXT_PERIOD_CD DOUBLE N Extension period code value
EXT_REASON_CD DOUBLE N Extension reason code value
EXT_START_DT_TM DATETIME Y extension start date and time
FILL_RATE DOUBLE Y Fill rate
FREIGHT_TERMS_CD DOUBLE N Freight Terms
GPO_BID_NBR VARCHAR(100) Y Group purchasing organization bid number
GPO_CD DOUBLE N Group purchasing organization code value
GPO_DESCRIPTION VARCHAR(255) Y Group purchasing organization description
GPO_EST_DOLLAR_VALUE DOUBLE Y Group purchasing organization estimated dollar value
GPO_ID_NBR VARCHAR(100) Y Group purchasing organization identification number
GPO_REF_NBR VARCHAR(100) Y Group purchasing organization reference number
HOSPITAL_CONTACT_ID DOUBLE N Hospital contact key
LEAD_TIME DOUBLE Y Lead time
LOCATION_CD DOUBLE N Code value for the location on the contract line
MFR VARCHAR(60) Y manufacturer
MFR_ADDRESS VARCHAR(255) Y manufacturer address
MIN_ORDER_COST DOUBLE Y Minimum ordering cost
MSTR_AGREEMENT_ID DOUBLE N Master agreement key
MSTR_AGREEMENT_IND DOUBLE Y Master agreement indicator
PAYMENT_TERMS_CD DOUBLE N Payment Terms
PRODUCT_LEVEL DOUBLE Y Header price tier product level
PROJECT_CD DOUBLE N Contract line project code, code value
PURCHASE_ORDER_ID DOUBLE N Foreign key to the purchase order table.
REF_CNTRCT_ID DOUBLE N Reference contract number key
SCNDRY_VENDOR VARCHAR(60) Y Secondary vendor
SCNDRY_VENDOR_MARKUP DOUBLE Y Secondary vendor markup
SHIP_VIA_CD DOUBLE N Ship Via Code
SIGNED_BY_ORG VARCHAR(100) Y Signed by organization
SIGNED_BY_VENDOR VARCHAR(100) Y Signed by vendor
SIGNED_DT_TM DATETIME Y This indicated the date n time at which the document is signed.
START_DT_TM DATETIME Y Start date/time
STATUS_CD DOUBLE N Status 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.
VENDOR VARCHAR(60) Y Vendor.
VENDOR_ADDRESS VARCHAR(255) Y vendor address
VENDOR_KEY VARCHAR(60) Y vendor key
VENDOR_MARKUP DOUBLE Y vendor markup
VENDOR_TYPE_CD DOUBLE N Type of vendor



Relationship Detail - MM_CNTRCT_HDR




Parent Column in MM_CNTRCT_HDR (PK) Child Table Name Child Column Name
Children: CNTRCT_ID MM_CNTRCT_ACTION CNTRCT_ID
MM_CNTRCT_HDR_TIER CNTRCT_ID
MM_CNTRCT_LINE CNTRCT_ID
MM_CNTRCT_ORG CNTRCT_ID
MM_CNTRCT_PRICE_ADJ CNTRCT_ID
MM_CNTRCT_REBATE CNTRCT_ID
MM_CNTRCT_SIGNATURE CNTRCT_ID
MM_XFI_CNTRCT_HDR CNTRCT_ID
MM_XFI_CNTRCT_HDR REF_CNTRCT_ID


MM_CNTRCT_HDR_TIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contract Header Tier
Definition: Contract Header Tier
Table Type: REFERENCE





Column Detail - MM_CNTRCT_HDR_TIER


Column Name Type Null? Definition
CLASS_NODE_ID DOUBLE N Class Node ID value.
CNTRCT_ID DOUBLE N Contract number key
CREATE_APPLCTX DOUBLE Y Application which created this row
CREATE_DT_TM DATETIME Y The date and time when the row was inserted
CREATE_ID DOUBLE N User id of person which created this row
CREATE_TASK DOUBLE Y The task responsible for inserting this row.
METRIC_CD DOUBLE N metric code
ORGANIZATION_ID DOUBLE N Header price tier organization key
PRICE_TIER_ID DOUBLE N key to mm_cntrc_hdr_tier
PRODUCT_LEVEL DOUBLE Y Header price tier product level
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_CNTRCT_HDR_TIER


Child Column in MM_CNTRCT_HDR_TIER(FK) Parent Table Name Parent Column Name
Parents: CNTRCT_ID MM_CNTRCT_HDR CNTRCT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in MM_CNTRCT_HDR_TIER (PK) Child Table Name Child Column Name
Children: PRICE_TIER_ID MM_CNTRCT_LINE_TIER HDR_PRICE_TIER_ID
MM_XFI_CNTRCT_HDR_TIER PRICE_TIER_ID


MM_CNTRCT_LINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contract Line
Definition: Used to store the line itetm detail of a contract.
Table Type: REFERENCE





Column Detail - MM_CNTRCT_LINE


Column Name Type Null? Definition
ACQ_PRICE DOUBLE Y Acquisition price
ADJ_EXEMPT_IND DOUBLE Y Adjustment exempt identifier
BASE_UOM_CD DOUBLE N Base unit of measure code
CAPITAL_CD DOUBLE N Capital Code
CLASS_NODE_ID DOUBLE N Class Node ID value.
CNTRCT_ID DOUBLE N Contract number key
CNTRCT_LINE_ID DOUBLE N contract line identifier
CNTRCT_MGR_ID DOUBLE N Contract line contract manager key
CNTRCT_PACK_FACTOR DOUBLE Y Contract unit of measure package factor
CNTRCT_PRICE DOUBLE Y Contract unit of measure price
CNTRCT_UOM_CD DOUBLE N Contract unit of measure code value
COST_CENTER_CD DOUBLE N Cost center code value
CREATE_APPLCTX DOUBLE Y Application which created this row
CREATE_DT_TM DATETIME Y The date and time when the row was inserted
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) who inserted the row in to the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
DIST_MARKUP_IND DOUBLE Y Distribution markup indicator
EST_USAGE DOUBLE Y Estimated usage
ITEM_DESC VARCHAR(200) Y Item description
ITEM_NBR VARCHAR(200) Y Item number
LOCATION_CD DOUBLE N Code value for the location on the contract line
MARKUP_PERCENT DOUBLE Y Markup percent
MFR VARCHAR(60) Y manufacturer
MFR_CATALOG_DESC VARCHAR(200) Y Manufacturer catalog description
MFR_CATALOG_NBR VARCHAR(200) Y Manufacturer catalog number
MIN_ORDER_QTY DOUBLE Y Minimum order quantity
MODEL_NBR VARCHAR(200) Y Model number
PROJECT_CD DOUBLE N Contract line project code, code value
REBATE_EXEMPT_IND DOUBLE Y Rebate exempt identifier
SERIAL_NBR VARCHAR(200) Y Serial number
SHORT_DESC VARCHAR(200) Y Short description
UPDT_APPLCTX DOUBLE N 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 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. 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 N 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 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. 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 N 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.
UPN VARCHAR(200) Y Universal product number
VENDOR_CATALOG_DESC VARCHAR(200) Y Vendor catalog description
VENDOR_CATALOG_NBR VARCHAR(200) Y Vendor catalog number



Relationship Detail - MM_CNTRCT_LINE


Child Column in MM_CNTRCT_LINE(FK) Parent Table Name Parent Column Name
Parents: CNTRCT_ID MM_CNTRCT_HDR CNTRCT_ID




Parent Column in MM_CNTRCT_LINE (PK) Child Table Name Child Column Name
Children: CNTRCT_LINE_ID ITEM_PRICE CONTRACT_LINE_ID
ITEM_PRICE_HIST CONTRACT_LINE_ID
MM_CNTRCT_LINE_TIER CNTRCT_LINE_ID
MM_XFI_CNTRCT_LINE CNTRCT_LINE_ID


MM_CNTRCT_LINE_TIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contract line tier
Definition: Contract line tier
Table Type: REFERENCE





Column Detail - MM_CNTRCT_LINE_TIER


Column Name Type Null? Definition
CNTRCT_LINE_ID DOUBLE N contract line identifier
CREATE_APPLCTX DOUBLE Y Application which created this row
CREATE_DT_TM DATETIME Y The date and time when the row was inserted
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) who inserted the row in to the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
DISCOUNT DOUBLE Y discount
HDR_PRICE_TIER_ID DOUBLE N header price tier identifier
PRICE_TIER_ID DOUBLE N price tier identifier 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_CNTRCT_LINE_TIER


Child Column in MM_CNTRCT_LINE_TIER(FK) Parent Table Name Parent Column Name
Parents: HDR_PRICE_TIER_ID MM_CNTRCT_HDR_TIER PRICE_TIER_ID
CNTRCT_LINE_ID MM_CNTRCT_LINE CNTRCT_LINE_ID




Parent Column in MM_CNTRCT_LINE_TIER (PK) Child Table Name Child Column Name
Children: PRICE_TIER_ID MM_XFI_CNTRCT_LINE_TIER PRICE_TIER_ID