PON_LINES_INT
This interface table holds negotiation line information which is loaded by the user for import. The FBDI process uses this information to create, update or delete negotiation lines. The process also validates this data, derives or defaults additional information and writes an error message for every validation that fails into the PON_FBDI_INT_ERRORS table.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
PON_LINES_INT_PK |
INTERFACE_LINE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INTERFACE_LINE_ID | NUMBER | 18 | Yes | Value that uniquely identifies the interface line. | |
INV_ORG_ID | NUMBER | 18 | Inventory Organization Identifier for the item. | ||
ATTRIBUTE_LIST_ID | NUMBER | 18 | Unique identifier for attribute list. | ||
CHUNK_ID | NUMBER | 18 | Value that uniquely identifies a set of lines grouped for the sake of parallel processing. | ||
BATCH_ID | VARCHAR2 | 100 | An optional identifier, if provided while scheduling an import process is used to identify which interface table records will be picked up for processing. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Identifier of the scheduled process that populates the interface table from user uploaded data. | ||
IMPORT_STATUS | VARCHAR2 | 30 | Status of the import. Values include NEW, PROCESSED or REJECTED. | ||
IMPORT_ACTION | VARCHAR2 | 30 | Yes | Name of the import action. Values include ADD, UPDATE, or DELETE. | |
DOCUMENT_NUMBER | VARCHAR2 | 240 | Yes | Number that uniquely identifies the negotiation. | |
AUCTION_HEADER_ID | NUMBER | 18 | Value that uniquely identifies the negotiation. | ||
DOCUMENT_DISP_LINE_NUMBER | VARCHAR2 | 25 | Yes | Indicates document line number to display. | |
PARENT_DISP_LINE_NUMBER | VARCHAR2 | 25 | Indicates document display parent line number to display. | ||
PRC_BU | VARCHAR2 | 240 | Yes | Name of the procurement business unit that owns the negotiation. | |
PRC_BU_ID | NUMBER | 18 | Value of the procurement business unit that owns the negotiation. | ||
GROUP_TYPE_NAME | VARCHAR2 | 30 | Type of negotiation line, such as line, group, group line, lot, or lot line. | ||
GROUP_TYPE | VARCHAR2 | 25 | Value of type of negotiation line, such as LINE, GROUP, GROUP_LINE, LOT or LOT_LINE. | ||
LINE_DESCRIPTION | VARCHAR2 | 2500 | Description of the negotiation line. | ||
REQ_BU | VARCHAR2 | 240 | Name of the requisition business unit that is a client of the procurement business unit. | ||
REQ_BU_ID | NUMBER | 18 | Value of the requisition business unit that is a client of the procurement business unit. | ||
LINE_TYPE_NAME | VARCHAR2 | 30 | Name of the line type that indicates whether the line is for items or services. | ||
LINE_TYPE_ID | NUMBER | 18 | Value of the line type that indicates whether the line is for items or services. | ||
ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Value of the line type basis look up code that indicates whether the line is for items or services. | ||
ITEM | VARCHAR2 | 300 | Name of the inventory item on the negotiation line. | ||
ITEM_ID | NUMBER | 18 | Identifier of the inventory item on the negotiation line. | ||
ITEM_REVISION | VARCHAR2 | 18 | Revision of the inventory item on the negotiation line. | ||
CATEGORY_NAME | VARCHAR2 | 250 | Name of the purchasing category for the negotiation line. | ||
CATEGORY_ID | NUMBER | 18 | Value of the purchasing category for the negotiation line. | ||
QUANTITY | NUMBER | Quantity of the item in the negotiation. | |||
UOM | VARCHAR2 | 25 | Name of the unit of measure for the item in the negotiation. | ||
UOM_CODE | VARCHAR2 | 3 | Value of the unit of measure for the item in the negotiation. | ||
SHIP_TO_LOCATION_NAME | VARCHAR2 | 240 | Name of the location where the supplier ships the item. | ||
SHIP_TO_LOCATION_ID | NUMBER | 18 | Value of the location where the supplier ships the item. | ||
REQUESTED_DELIVERY_DATE | DATE | Date when the application requests to deliver the item that the negotiation line references. | |||
REQUESTED_SHIP_DATE | DATE | Date when the application requests to ship the item that the negotiation line references. | |||
CURRENT_PRICE | NUMBER | Price that the procurement organization pays for the item or service. | |||
START_PRICE | NUMBER | Highest price that the application allows the supplier to enter in response to a negotiation line. | |||
TARGET_PRICE | NUMBER | Price that the procurement organization prefers pay for the negotiation line. | |||
DISPLAY_TARGET_PRICE_FLAG | VARCHAR2 | 1 | Contains one of the following values: Y or N. If Y, then allow the supplier to view the target price. If false, then do not allow. If the negotiation is a RFI (request for information), or if the application does not enable Allow Price and enable Quantity, then the default value for DisplayTargetPriceFlag is empty. If the line resides in a group, then the default value is empty, else the default value is N. | ||
NOTE_TO_BIDDERS | VARCHAR2 | 4000 | Note for the negotiation line for the supplier. | ||
LINE_TARGET_PRICE | NUMBER | Indicates target price for auction item unit price. | |||
LINE_TARGET_PRICE_FLAG | VARCHAR2 | 1 | Contains one of the following values: Y or N. If Y, then allow the supplier to view the line target price. If N, then do not allow. | ||
PRICE_BREAK_TYPE | VARCHAR2 | 25 | Type of price break. It specifies whether the application calculates the price break according to a single purchase order or across all purchase orders for the agreement. | ||
PRICE_BREAK_TYPE_NAME | VARCHAR2 | 80 | Name of price break type. It specifies whether the application calculates the price break according to a single purchase order or across all purchase orders for the agreement. | ||
PRICE_BREAK_NEG_FLAG | VARCHAR2 | 1 | Contains one of the following values: Y or N. If Y, then allow the supplier to modify price breaks that the procurement organization set up. If false, then do not allow. If the application does not enable price breaks, then the default value is empty. If the line resides in a group, then the value empty, else the default value is Y. | ||
ATTRIBUTE_LIST_NAME | VARCHAR2 | 80 | Name for attribute list on the negotiation line. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE20 | VARCHAR2 | 150 | 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. | |||
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 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | 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_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of 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. | ||
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. | |
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. | ||
PRICE_AND_QUANTITY_APPLY_FLAG | VARCHAR2 | 1 | Indicates whether price and quantity apply | ||
ALLOW_ITEM_DESC_UPDATE_FLAG | VARCHAR2 | 1 | Indicates if the item description can be modified | ||
PO_MIN_REL_AMOUNT | NUMBER | Purchase order minimum release amount | |||
PO_AGREED_AMOUNT | NUMBER | Purchasing Agreed Amount for the line | |||
PURCHASE_BASIS | VARCHAR2 | 30 | Purchase Basis for the line type | ||
DISP_LINE_NUMBER | NUMBER | Negotiation Item's Display Line Number | |||
REQUISITION_NUMBER | VARCHAR2 | 64 | Requisition number | ||
REQUISITION_LINE_NUMBER | NUMBER | Requisition line number | |||
REQUISITION_HEADER_ID | NUMBER | 18 | Requisition header unique identifier | ||
REQUISITION_LINE_ID | NUMBER | 18 | Requisition line unique identifier |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PON_LINES_INT_N1 | Non Unique | Default | REQUEST_ID, CHUNK_ID, IMPORT_ACTION |
PON_LINES_INT_N2 | Non Unique | Default | REQUEST_ID, IMPORT_STATUS |
PON_LINES_INT_U1 | Unique | Default | INTERFACE_LINE_ID |