PON_LINE_COST_FACTORS_INT
This interface table holds negotiation line external cost factors information which is loaded by the user for import. The FBDI process uses this information to create, update or delete line external cost factors. 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_LINE_COST_FACTORS_INT_PK |
INTERFACE_LINE_CF_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_LINE_CF_ID | NUMBER | 18 | Yes | Value that uniquely identifies the cost factor. | |
| SEQUENCE_NUMBER | NUMBER | 18 | Number denoting sequence in which price element is added to line or list. | ||
| DOCUMENT_DISP_LINE_NUMBER | VARCHAR2 | 25 | Yes | Indicates document line number to display. | |
| DOCUMENT_NUMBER | VARCHAR2 | 240 | Yes | Number that uniquely identifies the negotiation. | |
| AUCTION_HEADER_ID | NUMBER | 18 | Value that uniquely identifies the negotiation. | ||
| 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. | ||
| 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 | ||
| CHUNK_ID | NUMBER | 18 | Value that uniquely identifies a set of lines grouped for the sake of parallel processing. | ||
| IMPORT_STATUS | VARCHAR2 | 30 | Status of the record load from the interface table to the database. Valid values are SUBMITTED, PROCESSING, SUCCESS and ERROR. | ||
| IMPORT_ACTION | VARCHAR2 | 30 | Yes | Name of the import action. Valid values include ADD, UPDATE, or DELETE. | |
| PRICE_ELEMENT_TYPE_NAME | VARCHAR2 | 80 | Name of the cost factor on the negotiation line. | ||
| PRICE_ELEMENT_TYPE_ID | NUMBER | 18 | Identifier of the cost factor on the negotiation line. | ||
| PRICING_BASIS_NAME | VARCHAR2 | 80 | Basis that the application uses to calculate the cost factor. Values include Per unit, Fixed amount, Percentage of line price. | ||
| PRICING_BASIS | VARCHAR2 | 30 | Basis Value that the application uses to calculate the cost factor. Values include Per unit, Fixed amount, Percentage of line price. | ||
| VALUE | NUMBER | Target value of the cost factor. | |||
| DISPLAY_TARGET_FLAG | VARCHAR2 | 1 | Contains one of the following values: Y or N. If Y, then allow the supplier to view the value for the cost factor target. If N, then do not allow. The default value is N. | ||
| 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_LINE_COST_FACTORS_INT_N1 | Non Unique | Default | REQUEST_ID, CHUNK_ID, IMPORT_ACTION |
| PON_LINE_COST_FACTORS_INT_N2 | Non Unique | Default | REQUEST_ID, IMPORT_STATUS |
| PON_LINE_COST_FACTORS_INT_U1 | Unique | Default | INTERFACE_LINE_CF_ID |