SCH_EPP_CHANGE_ORDER_LINES
SCH_EPP_CHANGE_ORDER_LINES stores the changes to External Purchase Prices lines. 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_ORDER_LINES_PK |
LINE_CHANGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LINE_CHANGE_ID | NUMBER | 18 | Yes | External Purchase Price Header Interface Unique identifier. | |
| HEADER_CHANGE_ID | NUMBER | 18 | Yes | External Purchase Price Header CHANGE Unique identifier. | |
| 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. | |
| 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 | External Purchase Price Line Number entered by the user. | ||
| VENDOR_PART_NUMBER | VARCHAR2 | 300 | Trading partner item number with relationship type as Supplier or master item number which does not have any manufacturer item relationship. | ||
| 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 | Unit landed price for the external purchase price line. | |||
| ADJUSTED_PRICE | NUMBER | Yes | Adjusted final price for the external purchase price line. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Unit of measure for the external purchase price line. | |
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Description of the item or service for which the external purchase price applies to. | ||
| PURCHASING_CATEGORY_ID | NUMBER | 18 | Unique identifier of 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. | |||
| CANCELLED_FLAG | VARCHAR2 | 1 | Indicates whether the record is cancelled and no more avaiable for processing. | ||
| ERROR_FLAG | VARCHAR2 | 1 | This flag indicates error if any for processing the epp_change_order_lines record. | ||
| 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 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. | ||
| SOURCE_REFERENCE_ID | VARCHAR2 | 30 | Yes | Unique identifier for the header record in the source system. | |
| 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_LINES_N1 | Non Unique | Default | HEADER_CHANGE_ID |
| SCH_EPP_CHANGE_ORD_LINES_N2 | Non Unique | Default | REQ_BU_ID, UOM_CODE, MANUFACTURER_PART_NUMBER, ITEM_NUMBER |
| SCH_EPP_CHANGE_ORD_LINES_N3 | Non Unique | Default | MANUFACTURER_PART_NUMBER |
| SCH_EPP_CHANGE_ORD_LINES_N4 | Non Unique | Default | ITEM_NUMBER |
| SCH_EPP_CHANGE_ORD_LINES_U1 | Unique | Default | LINE_CHANGE_ID |