Table Detail Report

MM_XFI_CNTRCT_HDR



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI CNTRCT HDR
Definition: Table used to store contract header upload information. Data is moved from this table to MM_CNTRCT_HDR.
Table Type: REFERENCE





Column Detail - MM_XFI_CNTRCT_HDR


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N Action flag for the action
AGREEMENT_INFO VARCHAR(100) Y Agreement information stored at
CAPITAL_CD DOUBLE N Capital code code value
CAPITAL_CODE VARCHAR(60) Y Capital code
CATALOG_NAME VARCHAR(100) Y Catalog name
CLASS_NODE VARCHAR(100) Y Class node value
CLASS_NODE_ID DOUBLE N Class Node ID value.
CNTRCT_ID DOUBLE N Contract number key
CNTRCT_MGR VARCHAR(60) Y Contract manager
CNTRCT_MGR_ID DOUBLE N Contract manager key
CNTRCT_NAME VARCHAR(100) Y Contract name
CNTRCT_NBR VARCHAR(40) N Contract number
CNTRCT_SRC_TYPE VARCHAR(60) Y Contract source type
CNTRCT_SRC_TYPE_CD DOUBLE N Contract source type code value
CNTRCT_TERM VARCHAR(60) Y Contract term
CNTRCT_TERM_CD DOUBLE N Contract term code value
CNTRCT_TYPE VARCHAR(60) Y Contract type
CNTRCT_TYPE_CD DOUBLE N Contract type code value
CONTRIBUTOR_CD DOUBLE N Contributor Source Code value
COST_CENTER VARCHAR(60) Y Cost center 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 record was created
CREATE_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.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
DESCRIPTION VARCHAR(255) Y Contract description
EFFECTIVE_DT_TM DATETIME Y Effective Date and Time value
END_TRANSACTION_ID DOUBLE N end transaction id
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 VARCHAR(60) Y Extension period
EXT_PERIOD_CD DOUBLE N Extension period code value
EXT_REASON VARCHAR(60) Y Extension reason
EXT_REASON_CD DOUBLE N Extension reason code value
FILL_RATE DOUBLE Y Fill rate
GPO VARCHAR(60) Y Group purchasing organization
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 VARCHAR(60) Y Hospital contact
HOSPITAL_CONTACT_ID DOUBLE N Hospital contact key
LEAD_TIME DOUBLE Y Lead time
LOCATION VARCHAR(60) Y Location
LOCATION_CD DOUBLE N Location code value
MFR VARCHAR(60) Y Manufacturer
MSTR_AGREEMENT_ID DOUBLE N Master agreement key
MSTR_AGREEMENT_IND DOUBLE Y Master agreement indicator
MSTR_AGREEMENT_NBR VARCHAR(40) Y Master agreement number
PO_ID DOUBLE N Purchase order key
PO_NBR VARCHAR(40) Y Purchase order number
PROCESS_FLAG DOUBLE N Process flag
PROJECT_CD DOUBLE N Project code code value
PROJECT_CODE VARCHAR(60) Y project code
REF_CNTRCT_ID DOUBLE N Reference contract number key
REF_CNTRCT_NBR VARCHAR(40) Y Reference contract number
SCNDRY_VENDOR VARCHAR(60) Y Secondary vendor
SCNDRY_VENDOR_MARKUP DOUBLE Y Secondary vendor markup
SIGNED_BY_ORG VARCHAR(100) Y Signed by organization
SIGNED_BY_VENDOR VARCHAR(100) Y Signed by vendor
START_DT_TM DATETIME Y Start date/time
STATUS VARCHAR(60) Y Status
STATUS_CD DOUBLE N Status code value
TRANSACTION_ID DOUBLE N Primary key
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_KEY VARCHAR(60) Y vendor key
VENDOR_MARKUP DOUBLE Y vendor markup



Relationship Detail - MM_XFI_CNTRCT_HDR


Child Column in MM_XFI_CNTRCT_HDR(FK) Parent Table Name Parent Column Name
Parents: CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
CNTRCT_ID MM_CNTRCT_HDR CNTRCT_ID
REF_CNTRCT_ID MM_CNTRCT_HDR CNTRCT_ID
CNTRCT_MGR_ID PRSNL PERSON_ID
HOSPITAL_CONTACT_ID PRSNL PERSON_ID
PO_ID PURCHASE_ORDER PURCHASE_ORDER_ID




Parent Column in MM_XFI_CNTRCT_HDR (PK) Child Table Name Child Column Name
Children: TRANSACTION_ID MM_XFI_CNTRCT_ACTION TRANS_PARENT_ID
MM_XFI_CNTRCT_HDR_TIER TRANS_PARENT_ID
MM_XFI_CNTRCT_LINE TRANS_PARENT_ID
MM_XFI_CNTRCT_ORG TRANS_PARENT_ID
MM_XFI_CNTRCT_PRICE_ADJ TRANS_PARENT_ID
MM_XFI_CNTRCT_REBATE TRANS_PARENT_ID


MM_XFI_CNTRCT_HDR_TIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI CNTRCT HDR TIER
Definition: Table used to store relationships between contracts and header price tiers. Data is moved from this table to MM_CNTRCT_HDR_TIER.
Table Type: REFERENCE





Column Detail - MM_XFI_CNTRCT_HDR_TIER


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y Header price tier action flag
CLASS_NODE VARCHAR(60) Y Header price tier class node
CLASS_NODE_ID DOUBLE N Class Node ID value.
CONTRIBUTOR_CD DOUBLE N Contributor Source 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 record was created
CREATE_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.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
ORGANIZATION VARCHAR(100) Y Header price tier organization
ORGANIZATION_ID DOUBLE N Header price tier organization key
PRICE_TIER_ID DOUBLE N Foreign key to mm_cntrc_hdr_tier
PROCESS_FLAG DOUBLE Y process flag
PRODUCT_LEVEL DOUBLE Y Header price tier product level
TIER_METRIC VARCHAR(60) Y Header price tier metric
TIER_METRIC_CD DOUBLE N Header price tier metric code value
TRANSACTION_ID DOUBLE N Primary key
TRANS_PARENT_ID DOUBLE N transaction parent identifier
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_XFI_CNTRCT_HDR_TIER


Child Column in MM_XFI_CNTRCT_HDR_TIER(FK) Parent Table Name Parent Column Name
Parents: CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
PRICE_TIER_ID MM_CNTRCT_HDR_TIER PRICE_TIER_ID
TRANS_PARENT_ID MM_XFI_CNTRCT_HDR TRANSACTION_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


MM_XFI_CNTRCT_LINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI CNTRCT LINE
Definition: Table used to store contract line upload information. Data is moved from this table to MM_CNTRCT_LINE.
Table Type: REFERENCE





Column Detail - MM_XFI_CNTRCT_LINE


Column Name Type Null? Definition
ACQ_PRICE DOUBLE Y Acquisition price
ACTION_FLAG DOUBLE Y Contract line action flag
ADJ_EXCEMPT_IND DOUBLE Y Adjustment exception indicator
BASE_UOM VARCHAR(20) Y base unit of measure value
BASE_UOM_CD DOUBLE N Base unit of measure code
CAPITAL_CD DOUBLE N Contract line capital code, code value
CAPITAL_CODE VARCHAR(60) Y capital code
CLASS_NODE VARCHAR(60) Y class node value
CLASS_NODE_ID DOUBLE N Class Node ID value.
CNTRCT_LINE_ID DOUBLE N contract line identifier
CNTRCT_MGR VARCHAR(60) Y Contract line contract manager
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 VARCHAR(40) Y Contract unit of measure
CNTRCT_UOM_CD DOUBLE N Contract unit of measure code value
CONTRIBUTOR_CD DOUBLE N Contributor Source Code value
COST_CENTER VARCHAR(60) Y Contract line cost center
COST_CENTER_CD DOUBLE N Contract line 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 record was created
CREATE_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.
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 VARCHAR(60) Y Location on the contract line
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
PROCESS_FLAG DOUBLE Y process flag
PROJECT_CD DOUBLE N Contract line project code, code value
PROJECT_CODE VARCHAR(60) Y project code
REBATE_EXCEMPT_IND DOUBLE Y Rebate exception indicator
SERIAL_NBR VARCHAR(200) Y Serial number
SHORT_DESC VARCHAR(200) Y Short description
TRANSACTION_ID DOUBLE N Primary key
TRANS_PARENT_ID DOUBLE N Transaction parent identifier
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.
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_XFI_CNTRCT_LINE


Child Column in MM_XFI_CNTRCT_LINE(FK) Parent Table Name Parent Column Name
Parents: CNTRCT_LINE_ID MM_CNTRCT_LINE CNTRCT_LINE_ID
TRANS_PARENT_ID MM_XFI_CNTRCT_HDR TRANSACTION_ID
CNTRCT_MGR_ID PRSNL PERSON_ID




Parent Column in MM_XFI_CNTRCT_LINE (PK) Child Table Name Child Column Name
Children: TRANSACTION_ID MM_XFI_CNTRCT_LINE_TIER TRANS_PARENT_ID


MM_XFI_CNTRCT_LINE_TIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI CNTRCT LINE TIER
Definition: Table used to store relationships between contracts and line price tiers. Data is moved from this table to MM_CNTRCT_LINE_TIER.
Table Type: REFERENCE





Column Detail - MM_XFI_CNTRCT_LINE_TIER


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y Flag used to determine how the tier will be processed
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the record was created
CREATE_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.
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
PROCESS_FLAG DOUBLE Y process flag
TRANSACTION_ID DOUBLE N Primary key
TRANS_PARENT_ID DOUBLE N transaction parent identifier
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_XFI_CNTRCT_LINE_TIER


Child Column in MM_XFI_CNTRCT_LINE_TIER(FK) Parent Table Name Parent Column Name
Parents: PRICE_TIER_ID MM_CNTRCT_LINE_TIER PRICE_TIER_ID
TRANS_PARENT_ID MM_XFI_CNTRCT_LINE TRANSACTION_ID


MM_XFI_CNTRCT_ORG



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI CNTRCT ORG
Definition: Table used to store relationships between contracts and organizations. Data is moved from this table to MM_CNTRCT_ORG.
Table Type: REFERENCE





Column Detail - MM_XFI_CNTRCT_ORG


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y Organization action flag
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the record was created
CREATE_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.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
ORG VARCHAR(100) Y Organization
ORG_ID DOUBLE N Organization key
PROCESS_FLAG DOUBLE Y Flag used to determine the processing status of the line
TRANSACTION_ID DOUBLE N Transaction primary key
TRANS_PARENT_ID DOUBLE N Transaction Parent Identifier
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_XFI_CNTRCT_ORG


Child Column in MM_XFI_CNTRCT_ORG(FK) Parent Table Name Parent Column Name
Parents: TRANS_PARENT_ID MM_XFI_CNTRCT_HDR TRANSACTION_ID
ORG_ID ORGANIZATION ORGANIZATION_ID