PON_ITEM_PRICES_INTERFACE
PON_ITEM_PRICES_INTERFACE temporarily stores negotiation item information that the negotiation owner is uploading from a spreadsheet. Once the information is uploaded the interface is processed and the errors are reported in PON_INTERFACE_ERRORS It is used by auctions and RFQs
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PON_ITEM_PRICES_INTERFACE_PK |
BATCH_ID, INTERFACE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Batch ID of interface | |
| INTERFACE_LINE_ID | NUMBER | 18 | Yes | Interface line ID | |
| INTERFACE_TYPE | VARCHAR2 | 30 | Interface type | ||
| AUCTION_HEADER_ID | NUMBER | 18 | Yes | Auction Header Identifier | |
| AUCTION_LINE_NUMBER | NUMBER | Auction Line Item | |||
| REQ_BU_ID | NUMBER | 18 | Identifies the Requisitioning Business Unit for this item | ||
| ITEM_DESCRIPTION | VARCHAR2 | 2500 | Item description | ||
| CATEGORY_ID | NUMBER | 18 | Unique Identifier for category | ||
| CATEGORY_NAME | VARCHAR2 | 250 | Category name | ||
| MANUFACTURER_NAME | VARCHAR2 | 4000 | Manufacturer name of the item | ||
| MFR_PART_NUMBER | VARCHAR2 | 4000 | Manufacturer part number of item that is being bid | ||
| BID_MANUFACTURER_NAME | VARCHAR2 | 4000 | Manufacturer name of item that is being bid | ||
| BID_MFR_PART_NUMBER | VARCHAR2 | 4000 | Manufacturer part number of item that is being bid | ||
| UNIT_OF_MEASURE | VARCHAR2 | 25 | Unit of Measure of item | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Code for currency | ||
| QUANTITY | NUMBER | Quantity | |||
| UOM_CODE | VARCHAR2 | 3 | Code for unit of measure | ||
| PRICE | NUMBER | Price | |||
| PROMISED_DATE | DATE | Date the items are promised to be delivered by bidder | |||
| NEED_BY_DATE | DATE | Date the items are needed to be delivered | |||
| TARGET_PRICE | NUMBER | Target price of auctioneer | |||
| BID_START_PRICE | NUMBER | Start price of bidding | |||
| NOTE_TO_BIDDERS | VARCHAR2 | 4000 | Note to bidders | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Location Identifier to which auction items will be shipped | ||
| SHIP_TO_ADDRESS1 | VARCHAR2 | 240 | Ist line for shipping to address | ||
| SHIP_TO_ADDRESS2 | VARCHAR2 | 240 | 2nd line for shipping to address | ||
| SHIP_TO_ADDRESS3 | VARCHAR2 | 240 | 3rd line for shipping to address | ||
| SHIP_TO_ADDRESS4 | VARCHAR2 | 240 | 4th line for shipping to address | ||
| SHIP_TO_CITY | VARCHAR2 | 60 | City of shipping to address | ||
| SHIP_TO_STATE | VARCHAR2 | 60 | State of shipping to address | ||
| SHIP_TO_PROVINCE | VARCHAR2 | 60 | Province of shipping to address | ||
| SHIP_TO_POSTAL_CODE | VARCHAR2 | 60 | Postal code of shipping to address | ||
| SHIP_TO_COUNTRY | VARCHAR2 | 60 | Country of shipping to address | ||
| CURRENT_PRICE | NUMBER | Current price being paid by purchaser | |||
| DISPLAY_TARGET_FLAG | VARCHAR2 | 1 | Y or N flag to indicate that target price should be displayed to bidders | ||
| PO_MIN_REL_AMOUNT | NUMBER | Purchase order minimum release amount | |||
| SHIP_TO_LOCATION | VARCHAR2 | 240 | Name of address location for shipping items | ||
| SHIP_FROM_LOCATION | VARCHAR2 | 240 | Location for shipping from address | ||
| SHIP_FROM_LOCATION_ID | NUMBER | 18 | Identifier for location of shipping from address | ||
| SHIP_FROM_ADDRESS1 | VARCHAR2 | 240 | 1st line of shipping from address | ||
| SHIP_FROM_ADDRESS2 | VARCHAR2 | 240 | 2nd line of shipping from address | ||
| SHIP_FROM_ADDRESS3 | VARCHAR2 | 240 | 3rd line of shipping from address | ||
| SHIP_FROM_ADDRESS4 | VARCHAR2 | 240 | 4th line of shipping from address | ||
| SHIP_FROM_CITY | VARCHAR2 | 60 | City of shipping from address | ||
| SHIP_FROM_STATE | VARCHAR2 | 60 | State of shipping from address | ||
| SHIP_FROM_PROVINCE | VARCHAR2 | 60 | Province of shipping from address | ||
| SHIP_FROM_POSTAL_CODE | VARCHAR2 | 60 | Postal code of shipping from address | ||
| SHIP_FROM_COUNTRY | VARCHAR2 | 60 | Country of shipping from address | ||
| PROJECT_ID | NUMBER | Identifier of the Project corresponding to the PROJECT_NUMBER entered. This is derived here and used for populating the transaction table. | |||
| PROJECT_NUMBER | VARCHAR2 | 25 | Number of the project in Oracle Projects to which the cost of this payment/shipment will be charged | ||
| TASK_ID | NUMBER | Task Identifier | |||
| TASK_NUMBER | VARCHAR2 | 25 | Task Number | ||
| DISPLAY_TARGET_PRICE_FLAG | VARCHAR2 | 1 | whether to display target price to bidders | ||
| PROJECT_NAME | VARCHAR2 | 30 | project name | ||
| ATTACHMENT_URL | VARCHAR2 | 255 | URL type attachment | ||
| ATTACHMENT_DESC | VARCHAR2 | 255 | Description for URL attachment | ||
| ACTION | VARCHAR2 | 2 | action code used for multi round to add, delete or modify | ||
| NEED_BY_START_DATE | DATE | need by start date | |||
| LINE_TYPE | VARCHAR2 | 30 | Line Type for the upload item | ||
| LINE_TYPE_ID | NUMBER | 18 | PK to PO_LINE_TYPES | ||
| LINE_ORIGINATION_CODE | VARCHAR2 | 50 | source of line | ||
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Line type for line, services or quantity | ||
| ITEM_NUMBER | VARCHAR2 | 820 | Item Number | ||
| ITEM_REVISION | VARCHAR2 | 18 | Item Revision | ||
| ITEM_ID | NUMBER | 18 | Unique item identifier | ||
| ALLOW_ITEM_DESC_UPDATE_FLAG | VARCHAR2 | 1 | Indicates if the item description can be modified | ||
| PRICE_AND_QUANTITY_APPLY | VARCHAR2 | 1 | Indicates whether price and quantity apply | ||
| DISP_LINE_NUMBER | NUMBER | Negotiation Item's Display Line Number | |||
| ADDITIONAL_JOB_DETAILS | VARCHAR2 | 2000 | Additional Job Details | ||
| PO_AGREED_AMOUNT | NUMBER | Purchasing Agreed Amount | |||
| DIFFERENTIAL_RESPONSE_TYPE | VARCHAR2 | 20 | Price Differential Response Type | ||
| PURCHASE_BASIS | VARCHAR2 | 30 | Purchase Basis for the line type | ||
| JOB_ID | NUMBER | Job Id | |||
| UNIT_TARGET_PRICE | NUMBER | The target price for auction item unit price. | |||
| UNIT_DISPLAY_TARGET_FLAG | VARCHAR2 | 1 | Indicates whether display target price of unit price to suppliers | ||
| GROUP_TYPE | VARCHAR2 | 25 | Yes | Type of Line | |
| PARENT_LINE_NUMBER | NUMBER | Line Number of Parent Lot/Group | |||
| DOCUMENT_DISP_LINE_NUMBER | VARCHAR2 | 25 | Document Line Number to display (e.g. 2.1) | ||
| ADVANCE_AMOUNT | NUMBER | Amount that may be paid in advance for this line | |||
| RECOUPMENT_RATE_PERCENT | NUMBER | Percentage of the amount of each invoice for this line that can be recouped when financing or advances are provided to the supplier. | |||
| PROGRESS_PYMT_RATE_PERCENT | NUMBER | Percentage of the amount that will be due to the Supplier upon fulfillment of a pay item for each invoice for this line | |||
| RETAINAGE_RATE_PERCENT | NUMBER | Percentage of the invoice line amount that will be retained until the work is completed and accepted. | |||
| MAX_RETAINAGE_AMOUNT | NUMBER | Maximum amount that can be retained across all invoices for this line | |||
| WORK_APPROVER_USER_NAME | VARCHAR2 | 100 | User name of the person who is responsible for confirming that the supplier has performed work as agreed. | ||
| WORK_APPROVER_USER_ID | NUMBER | Work approver user id | |||
| PROJECT_TASK_NUMBER | VARCHAR2 | 25 | Number of the task in Oracle Projects to which the cost of this payment/shipment will be charged | ||
| PROJECT_TASK_ID | NUMBER | Identifier of the Task corresponding to the PROJECT_TASK_NUMBER entered. This is derived here and used for populating the transaction table. | |||
| PROJECT_AWARD_NUMBER | VARCHAR2 | 15 | Number of the Award which is association with this payment/shipment. This may be populated only if integration with Oracle Grants is enabled | ||
| PROJECT_AWARD_ID | NUMBER | Identifier of the Award corresponding to the PROJECT_AWARD_NUMBER entered. This is derived here and used for populating the transaction table. | |||
| PROJECT_EXPENDITURE_TYPE | VARCHAR2 | 30 | Code for the Expenditure type in Oracle Projects associated with this payment/shipment | ||
| PROJECT_EXP_ORGANIZATION_NAME | VARCHAR2 | 240 | Name of the expenditure organization associated with this payment/shipment | ||
| PROJECT_EXP_ORGANIZATION_ID | NUMBER | Identifier of the Expenditure Organization corresponding to the PROJECT_EXP_ORGANIZATION_NAME entered. This is derived here and used for populating the transaction table. | |||
| PROJECT_EXPENDITURE_ITEM_DATE | DATE | Date used for accounting the transaction for this line in Oracle Projects | |||
| IP_CATEGORY_NAME | VARCHAR2 | 250 | iP category name. | ||
| IP_CATEGORY_ID | NUMBER | iP category id. | |||
| OUTSIDE_OPERATION_FLAG | VARCHAR2 | 1 | Stores whether the line type is for Outside Processing items | ||
| SUB_LINE_SEQUENCE_NUMBER | NUMBER | sub line sequence number | |||
| 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. | |
| 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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. | ||
| REQ_BU_NAME | VARCHAR2 | 240 | Requisition BU Name | ||
| CARRIER_ID | NUMBER | 18 | The carrier id of shipping method. | ||
| MODE_OF_TRANSPORT | VARCHAR2 | 30 | Type of transportation used to ship the product, such as truck, air or boat. | ||
| SERVICE_LEVEL | VARCHAR2 | 30 | Priority of transportation that affects how quickly goods are transported. | ||
| SHIPPING_METHOD | VARCHAR2 | 600 | The display name of shipping method. | ||
| REQUESTED_SHIP_DATE | DATE | The date when the buyer company wants the supplier to ship out the designated product that the buyer company intends to buy. | |||
| REQUESTED_DELIVERY_DATE | DATE | The date when the designated product that the procurement organization intends to buy is needed. | |||
| ALLOW_ALTERNATE_LINES | VARCHAR2 | 30 | Value of allow alternate lines. Possible values are YES and NO. | ||
| PRICE_BREAK_TYPE | VARCHAR2 | 25 | Price Break Type: Cumulative or Non-Cumulative. | ||
| PRICE_BREAK_NEG_FLAG | VARCHAR2 | 1 | Flag to indicate whether supplier can modify price breaks. | ||
| MIN_BID_LINE_DECREMENT | NUMBER | Minimum allowable bid line decrement in a bidders bid line if multiple bids are allowed |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_ITEM_PRICES_INT_N1 | Non Unique | Default | BATCH_ID, CATEGORY_NAME |
| PON_ITEM_PRICES_INT_N2 | Non Unique | Default | BATCH_ID, ITEM_DESCRIPTION |
| PON_ITEM_PRICES_INT_N3 | Non Unique | Default | BATCH_ID, UNIT_OF_MEASURE |
| PON_ITEM_PRICES_INT_N4 | Non Unique | Default | BATCH_ID, ACTION |
| PON_ITEM_PRICES_INT_N6 | Non Unique | Default | BATCH_ID, SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION |
| PON_ITEM_PRICES_INT_U1 | Unique | Default | BATCH_ID, INTERFACE_LINE_ID |