SCH_EPP_LINES
SCH_EPP_LINES contains line current information of your external purchase price lines. Each row contains, the external manufacturer part number, unit of measure, price 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_LINES_PK |
LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LINE_ID | NUMBER | 18 | Yes | External Purchase Price Workbench Lines Interface Unique identifier. | |
| 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. | ||
| LINE_NUMBER | NUMBER | 18 | Yes | External Purchase Price Workbench Line Number entered by the user. | |
| VENDOR_PART_NUMBER | VARCHAR2 | 300 | Item part number assigned by the vendor. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Master Item number in the buyer's organization. | ||
| USER_SELECTED_FLAG | VARCHAR2 | 1 | Indicates whether the line is manually selected by user to be added to a purchase agreement. | ||
| MANUFACTURER_PART_NUMBER | VARCHAR2 | 700 | Item part number assigned by the manufacturer. | ||
| PRICE | NUMBER | Base price for the external purchase price line. | |||
| ADJUSTED_PRICE | NUMBER | Yes | Landed price for the external purchase price line. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Unit of measure code for the line. | |
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Description of the item to which the externl purchase price pertains to. | ||
| PURCHASING_CATEGORY_ID | NUMBER | 18 | Unique identifier for the purchasing category of the item. | ||
| 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. | |||
| UPDATE_FLAG | VARCHAR2 | 1 | Y - The External Purchase Price Line is new or updated and the details are not processed else N Indicates the External Purchase Price Line and any updates to it have been processed. | ||
| VALIDATED_FLAG | VARCHAR2 | 1 | Y indicates the import BPA process has completed Sucessfully. N indicates any failure. | ||
| BPA_FLAG | VARCHAR2 | 1 | Y indicates the External Purchase Price exists as a Blanket Purchase Agreement in Procurement. | ||
| CANCELLED_FLAG | VARCHAR2 | 1 | Indicates whether the record is cancelled and no more avaiable for processing. | ||
| ADJUSTMENT_PERCENTAGE | NUMBER | Markup adjustment percentage applied to the item. | |||
| IS_MY_ITEM | VARCHAR2 | 1 | Indicates if the item is already purchased by the buyer's organization. | ||
| PARTY_TYPE_CODE | VARCHAR2 | 30 | Indicates whether it is a distributor or Manufacturer agreement. | ||
| SELECTION_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether the record is available for selection to be added to a purchase agreement. | ||
| 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 | Status |
|---|---|---|---|---|
| SCH_EPP_LINES_N1 | Non Unique | Default | HEADER_ID | |
| SCH_EPP_LINES_N2 | Non Unique | Default | ITEM_PRICE_START_DATE, ITEM_PRICE_END_DATE | |
| SCH_EPP_LINES_N3 | Non Unique | Default | VALIDATED_FLAG | |
| SCH_EPP_LINES_N4 | Non Unique | Default | REQ_BU_ID, UOM_CODE, MANUFACTURER_PART_NUMBER, ITEM_NUMBER | Obsolete |
| SCH_EPP_LINES_N5 | Non Unique | Default | MANUFACTURER_PART_NUMBER | |
| SCH_EPP_LINES_N6 | Non Unique | Default | ITEM_NUMBER | |
| SCH_EPP_LINES_N7 | Non Unique | Default | UOM_CODE, MANUFACTURER_PART_NUMBER, ITEM_NUMBER | |
| SCH_EPP_LINES_U1 | Unique | Default | LINE_ID |