SCH_EPP_HEADERS_INT
SCH_EPP_HEADERS_INTERFACE is the interface table that holds header information for the external purchase prices. The Import External Purchase Prices scheduled process validates your data, derives or defaults additional information and writes an error message for every validation that fails into the SCH_EPP_ERRORS table.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
SCH_EPP_HEADERS_INT_PK |
INTERFACE_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_HEADER_ID | NUMBER | 18 | Yes | Unique ID for the header interface table. System generated. | |
| INTERFACE_HEADER_KEY | VARCHAR2 | 30 | Yes | Header record identifier, unique within LOAD_REQUEST_ID. | |
| SOURCE_REFERENCE_ID | VARCHAR2 | 30 | Yes | Unqiue identifier for the header record in the source system. | |
| 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. | |
| APPROVAL_ACTION | VARCHAR2 | 25 | Yes | Indicates if the External Purchase Price needs to be submitted for approval. The values can be either SUBMIT or BYPASS. | |
| SOURCE_ORGANIZATION | VARCHAR2 | 240 | Unique identifier or code or name of the organization in the source system. | ||
| REQ_BU_ID | NUMBER | 18 | Value that uniquely identifies the requisitioning business unit. | ||
| REQ_BU_NAME | VARCHAR2 | 240 | Name that uniquely identifies the requisitioning business unit. | ||
| SOURCE_CONTRACT_NUMBER | VARCHAR2 | 120 | Yes | The source contract number for the external purchase price. | |
| SOURCE_CONTRACT_DESCRIPTION | VARCHAR2 | 2000 | The description of the source contract for the external purchase price. | ||
| SOURCE_CONTRACT_TYPE | VARCHAR2 | 30 | 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. | ||
| SOURCE_CONTRACT_TYPE_MEANING | VARCHAR2 | 80 | Indicates the type of source of the External Purchase Prices. | ||
| MANUFACTURER_NAME | VARCHAR2 | 700 | Name of the manufacturer of the item. | ||
| MANUFACTURER_PARTY_ID | NUMBER | 18 | Value that uniquely identifies the manufacturer. | ||
| SOURCE_VENDOR | VARCHAR2 | 360 | Unique identifier or code or name of the Supplier in the source system. | ||
| VENDOR_NUMBER | VARCHAR2 | 30 | Number that uniquely identifies the supplier. | ||
| VENDOR_ID | NUMBER | 18 | Value that uniquely identifies the supplier. | ||
| VENDOR_SITE_CODE | VARCHAR2 | 240 | Abbreviation that identifies the supplier address. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Value that uniquely identifies the supplier. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency Code of the external purchase price. | ||
| SOURCE_CONTRACT_START_DATE | DATE | Effective start date of the external purchase price. | |||
| SOURCE_CONTRACT_END_DATE | DATE | Effective end date of the external purchase price. | |||
| SOURCE_CONTRACT_OWNER | VARCHAR2 | 200 | The name of the contact person for the external purchase price. | ||
| SOURCE_CONTRACT_REVIEW_DATE | DATE | The date when the terms of the External Purchase Price will be reviewed. | |||
| SOURCE_CONTRACT_STATE | VARCHAR2 | 30 | Indicates the status of the External Purchase Prices in the source system. | ||
| TIER_LEVEL | NUMBER | 18 | Indicates the classification of the supplier based on tier level. | ||
| TIER_DESCRIPTION | VARCHAR2 | 2000 | Describes the tier level of the supplier. | ||
| SOURCE_REP_CONTRACT_NUMBER | VARCHAR2 | 120 | The number of the older source contract which is replaced by the current source contract for the external purchase price. | ||
| 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 External Purchase Price will not change. | |||
| SOURCE_GPO_CONTRACT_REF | VARCHAR2 | 60 | Source group purchasing contract reference. | ||
| LEASE_PAYMENT_TERMS | VARCHAR2 | 30 | Lease payment terms for the source contract. | ||
| 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. | ||
| ADDITIONAL_INFORMATION | VARCHAR2 | 200 | Additional information about the rebate. | ||
| OTHER_SOURCE_CONTRACT_DETAILS | VARCHAR2 | 200 | General information and notes about the rebate. | ||
| REBATE_BASIS | VARCHAR2 | 30 | Indicates the type of the rebate. | ||
| COMMITMENT_TERMS | VARCHAR2 | 200 | Commitment terms of the source contract. | ||
| COMMITMENT_MEASURE | VARCHAR2 | 60 | A description of the commitment measures of the source contract. | ||
| KNOWN_COMPETITORS | VARCHAR2 | 60 | Name of the competitors who sell products in this category. | ||
| ERROR_FLAG | VARCHAR2 | 1 | This flag indicates the status of the Import External Purchase Prices scheduled process. | ||
| BATCH_ID | NUMBER | Unique identifier of the import batch. | |||
| 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_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. | ||
| LOAD_REQUEST_ID | NUMBER | Enterprise Service Scheduler: indicates the request ID of the job that has populated the record in the interface table. | |||
| 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. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| sch_epp_lines_int | sch_epp_headers_int | INTERFACE_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SCH_EPP_HEADERS_INT_N1 | Non Unique | Default | BATCH_ID, ERROR_FLAG |
| SCH_EPP_HEADERS_INT_U1 | Unique | Default | INTERFACE_HEADER_ID |