SCH_EPP_LINES_INT
SCH_EPP_LINES_INTERFACE is the interface table that holds line 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_LINES_INT_PK |
INTERFACE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_LINE_ID | NUMBER | 18 | Yes | Unique ID for the line interface table. System generated. | |
| INTERFACE_LINE_KEY | VARCHAR2 | 30 | Yes | Line record identifier, unique within LOAD_REQUEST_ID. | |
| INTERFACE_HEADER_KEY | VARCHAR2 | 30 | Yes | Header record identifier, unique within LOAD_REQUEST_ID. | |
| INTERFACE_HEADER_ID | NUMBER | 18 | Unique ID for the line interface table. System generated. | ||
| SOURCE_REFERENCE_ID | VARCHAR2 | 30 | Yes | Unique identifier for the header record in the source system. | |
| LINE_NUMBER | NUMBER | 18 | Unique number to identify the External Purchase Prices line. | ||
| 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. | |
| VENDOR_PART_NUMBER | VARCHAR2 | 300 | Number that uniquely identifies the supplier part. | ||
| VENDOR_TP_ITEM_ID | NUMBER | 18 | Value that uniquely identifies the supplier part. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Number that uniquely identifies the item. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Value that uniquely identifies the item. | ||
| MANUFACTURER_PART_NUMBER | VARCHAR2 | 700 | Number that uniquely identifies the manufacturer part. | ||
| MANUFACTURER_TP_ITEM_ID | NUMBER | 18 | Value that uniquely identifies the manufacturer part. | ||
| PRICE | NUMBER | Base price for the external purchase price line. | |||
| ADJUSTED_PRICE | NUMBER | Yes | Adjusted final price for the external purchase price line. | ||
| UOM | VARCHAR2 | 25 | Unit of measure name for the external purchase price line. | ||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code for the external purchase price line. | ||
| QOE | NUMBER | Quantity of each. Used to derive the unit of measure from the UOM mappings. If null, default to 1. | |||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Description of the item or service for which the external purchase price applies to. | ||
| PURCHASING_CATEGORY_CODE | VARCHAR2 | 820 | Abbreviation that uniquely identifies the purchasing category. | ||
| SOURCE_PURCHASING_CATEGORY | VARCHAR2 | 700 | Name that uniquely identifies the purchasing category. | ||
| PURCHASING_CATEGORY_ID | NUMBER | 18 | Value that uniquely identifies the purchasing category. | ||
| ITEM_PRICE_START_DATE | DATE | Effective date of the price for this item. | |||
| ITEM_PRICE_END_DATE | DATE | Expiration date of the price for this item. | |||
| ERROR_FLAG | VARCHAR2 | 1 | Indicates whether it is a errored record. Valid values are Y , N. | ||
| BATCH_ID | NUMBER | Unique identifier of the import batch. | |||
| ADJUSTMENT_PERCENTAGE | NUMBER | Markup adjustment percentage applied to the line. | |||
| IS_MY_ITEM | VARCHAR2 | 1 | Indicates if the item is already purchased by the buyer's organization. | ||
| 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. | ||
| 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. |
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_LINES_INT_N1 | Non Unique | Default | INTERFACE_HEADER_KEY, LOAD_REQUEST_ID |
| SCH_EPP_LINES_INT_U1 | Unique | Default | INTERFACE_LINE_ID |