SCH_EPP_HEADERS
SCH_EPP_HEADERS contains the current header information of your external purchase prices. You need one row for each external purchase price reference you create. Each row contains, the external contract number, the manufacturer and supplier information, requisitioning business unit, currency code, effective start and end dates, status and other terms and conditions.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SCH_EPP_HEADERS_PK |
HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| HEADER_ID | NUMBER | 18 | Yes | External Purchase Price Header Unique identifier. | |
| 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 | Procurement Business Unit identifier. Indicates the procurement business unit of the requisitioning 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 agreement. | ||
| SOURCE_CONTRACT_NUMBER | VARCHAR2 | 120 | Yes | Unique number to identify the Pricing Agreement. | |
| SOURCE_CONTRACT_DESCRIPTION | VARCHAR2 | 2000 | Free text where user can provide the details about the Pricing Agreement. | ||
| 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. | ||
| 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 | The date when the terms of the Pricing Agreement will be reviewed. | |||
| SOURCE_CONTRACT_END_DATE | DATE | Free text to enter the status of the Pricing Agreement in the source system. | |||
| APPROVAL_STATUS | VARCHAR2 | 30 | Approval Status for External Purchase Prices Agreement. Valid values are APPROVED,CANCELLED. | ||
| SOURCE_CONTRACT_REVIEW_DATE | DATE | The date when the terms of the Pricing Agreement will be reviewed. | |||
| SOURCE_CONTRACT_OWNER | VARCHAR2 | 200 | Name of the person assigned to the Pricing Agreement. | ||
| SOURCE_CONTRACT_STATE | VARCHAR2 | 30 | Free text to enter the status of the Pricing Agreement in the source system. | ||
| 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 | Indicates the older Pricing Agreement number which is replaced by the current agreement. | ||
| ADMINISTRATIVE_FEE | NUMBER | Administrative fee of the source contract. | |||
| NOTES | VARCHAR2 | 2000 | Notes to the source contract for the external purchase price. | ||
| PRICE_PROTECTED_DATE | DATE | The date until when the price of the Pricing Agreement will not change. | |||
| SOURCE_GPO_CONTRACT_REF | VARCHAR2 | 60 | Free text to indicate the Group Purchasing Contract Reference. | ||
| LEASE_PAYMENT_TERMS | VARCHAR2 | 30 | Free text to enter the lease payment terms. | ||
| REBATE_FREQUENCY | VARCHAR2 | 30 | The frequency in which the rebate will be paid. | ||
| REBATE_AMOUNT | NUMBER | The rebate amount for the External Purchase Prices. | |||
| DATE_REBATE_EXPECTED | DATE | The date when the rebate is expected to be paid. | |||
| PAYMENT_METHOD | VARCHAR2 | 60 | The mode of payment of the rebate amount. | ||
| OTHER_SOURCE_CONTRACT_DETAILS | VARCHAR2 | 200 | General information and notes about the rebate. | ||
| REBATE_BASIS | VARCHAR2 | 30 | Free text to indicate the type of the rebate. | ||
| COMMITMENT_TERMS | VARCHAR2 | 200 | Free text to enter the commitment terms of the Pricing Agreement. | ||
| COMMITMENT_MEASURE | VARCHAR2 | 60 | Free text to enter the scale of commitment. | ||
| KNOWN_COMPETITORS | VARCHAR2 | 60 | Free text to specify the name of the competitors who sell products in this category. | ||
| 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_lines | sch_epp_headers | HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SCH_EPP_HEADERS_N1 | Non Unique | Default | BU_ID |
| SCH_EPP_HEADERS_U1 | Unique | Default | HEADER_ID |
| SCH_EPP_HEADERS_U2 | Unique | Default | SOURCE_REFERENCE_ID |