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 |