SCH_EPP_CHANGE_ORDER_HEADERS
SCH_EPP_CHANGE_ORDER_HEADERS stores the changes to External Purchase Prices header. This table contains both the proposed draft changes not yet implemented and also past approved changes to the external purchase prices.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SCH_EPP_CHANGE_ORD_HEADERS_PK |
HEADER_CHANGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| HEADER_CHANGE_ID | NUMBER | 18 | Yes | Value that uniquely identifies the external purchase prices change order. | |
| REQ_BU_ID | NUMBER | 18 | Requisitioning Business Unit identifier. Indicates the business unit to which this external purchase price header applies to. | ||
| REQ_GROUP_ID | NUMBER | 18 | Value that uniquely identifies the group of requisitioning business units assigned to the source organization. | ||
| BU_ID | NUMBER | 18 | Yes | Value that uniquely identifies the procurement business unit. | |
| SOURCE_REFERENCE_ID | VARCHAR2 | 30 | Yes | Unique identifier for the header record in the source system. | |
| SOURCE_REFERENCE_NUMBER | NUMBER | 18 | Internally generated number for each external purchase price. | ||
| ACTION | VARCHAR2 | 25 | Yes | Indicates if the interface action is for creation of a new record or update to existing record. Values can be either CREATE or UPDATE. | |
| CHANGE_ORDER_NUMBER | NUMBER | 18 | Yes | Sequence generated Change Order Number unique for a Contract. | |
| CHANGE_ORDER_TYPE | VARCHAR2 | 30 | Indicates whether its CHANGE or CANCEL. | ||
| SOURCE_CONTRACT_NUMBER | VARCHAR2 | 120 | Unique number to identify the External Purchase Prices. | ||
| SOURCE_CONTRACT_DESCRIPTION | VARCHAR2 | 2000 | Free text where user can provide the details about the External Purchase Prices. | ||
| SOURCE_CONTRACT_TYPE | VARCHAR2 | 30 | Yes | Abbreviation that identifies the type of the source contract. | |
| SOURCE_TYPE | VARCHAR2 | 60 | Indicates the sub-classification of the external contract type in case of local contracts. | ||
| SOURCE | VARCHAR2 | 60 | Name of the person or organization in the source contract. | ||
| BPM_APPROVAL_STATUS | VARCHAR2 | 30 | Status of the external purchase price approval workflow. | ||
| MANUFACTURER_NAME | VARCHAR2 | 700 | Yes | Name of the Trading Partner of type MANUFACTURER. | |
| VENDOR_ID | NUMBER | 18 | Yes | Value that uniquely identifies the supplier. | |
| VENDOR_SITE_ID | NUMBER | 18 | Yes | The field is mandatory if the parent field for CM indication is selected. It has no default value. | |
| CURRENCY_CODE | VARCHAR2 | 15 | Currency Code of the External Purchase Prices. | ||
| SOURCE_CONTRACT_START_DATE | DATE | Effective start date of the External Purchase Prices. | |||
| SOURCE_CONTRACT_END_DATE | DATE | Effective end date of the External Purchase Prices. | |||
| APPROVAL_STATUS | VARCHAR2 | 30 | Approval Status for External Purchase Prices Agreement. Valid values are APPROVED,CANCELLED. | ||
| SOURCE_CONTRACT_REVIEW_DATE | DATE | Target date to review the terms of the contract. | |||
| SOURCE_CONTRACT_OWNER | VARCHAR2 | 200 | Name of the person assigned to the External Purchase Prices. | ||
| SOURCE_CONTRACT_STATE | VARCHAR2 | 30 | Status of the source contract for the external purchase price. | ||
| TIER_LEVEL | NUMBER | 18 | Indicates the classification of the supplier based on tier level. | ||
| TIER_DESCRIPTION | VARCHAR2 | 2000 | A free text to describe the tier level of the supplier. | ||
| SOURCE_REP_CONTRACT_NUMBER | VARCHAR2 | 120 | CONTRACT replaces an older agreement. | ||
| ADMINISTRATIVE_FEE | NUMBER | Administrative fee of the source contract. | |||
| NOTES | VARCHAR2 | 2000 | General notes or comments about the source contract. | ||
| PRICE_PROTECTED_DATE | DATE | The date until when the price of the External Purchase Prices will not change. | |||
| SOURCE_GPO_CONTRACT_REF | VARCHAR2 | 60 | Reference field to track a related GPO CONTRACT number. | ||
| LEASE_PAYMENT_TERMS | VARCHAR2 | 30 | Payment terms when the source contract is of type lease. | ||
| REBATE_FREQUENCY | VARCHAR2 | 30 | Frequency that a rebate is to be paid. | ||
| REBATE_AMOUNT | NUMBER | Amount of the rebate for the contract. | |||
| DATE_REBATE_EXPECTED | DATE | The date on which the rebate is expected to be paid. | |||
| PAYMENT_METHOD | VARCHAR2 | 60 | Payment method when the source contract is of type lease. | ||
| OTHER_SOURCE_CONTRACT_DETAILS | VARCHAR2 | 200 | General information and notes about the rebate. | ||
| REBATE_BASIS | VARCHAR2 | 30 | Terms of the rebate when the source contract is of type lease. | ||
| COMMITMENT_TERMS | VARCHAR2 | 200 | Terms of commitment when the source contract is of type lease. | ||
| COMMITMENT_MEASURE | VARCHAR2 | 60 | Information about the commitment and rebate. | ||
| KNOWN_COMPETITORS | VARCHAR2 | 60 | Names of known competitors for the product or service. | ||
| PROCESSED_FLAG | VARCHAR2 | 1 | Y indicates this header is processed by the 1st ESS job. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | 1 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER4 | NUMBER | 1 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER5 | NUMBER | 1 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| sch_epp_change_order_lines | sch_epp_change_order_headers | HEADER_CHANGE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SCH_EPP_CHANGE_ORD_HEADERS_N1 | Non Unique | Default | APPROVAL_STATUS |
| SCH_EPP_CHANGE_ORD_HEADERS_N2 | Non Unique | Default | SOURCE_REFERENCE_ID |
| SCH_EPP_CHANGE_ORD_HEADERS_U1 | Unique | Default | HEADER_CHANGE_ID |