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 |