PON_LINE_PRICE_TIERS_INT
PON_LINE_PRICE_TIERS_INT is the interface table that holds line shipment or price tier information for the FBDI program to create negotiations. The FBDI program validates the 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_PRICE_TIERS_INT_PK |
INTERFACE_LINE_PT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INTERFACE_LINE_PT_ID | NUMBER | 18 | Yes | Value that uniquely identifies a price tier or a shipment. | |
DOCUMENT_DISP_LINE_NUMBER | VARCHAR2 | 25 | Yes | Line record identifier. Document line number to display (e.g. 2.1). | |
DOCUMENT_NUMBER | VARCHAR2 | 240 | Yes | Header record identifier. Negotiation number. | |
AUCTION_HEADER_ID | NUMBER | 18 | Header record identifier. Internal negotiation number. | ||
PRC_BU | VARCHAR2 | 240 | Yes | Procurement business unit name. | |
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. | |
SHIPMENT_NUMBER | NUMBER | 18 | Shipment Number | ||
SHIPMENT_TYPE | VARCHAR2 | 25 | Type of Shipment. For Price tiers, the value is "QUANTITY BASED". For Shipments, the value is "PRICE BREAK". | ||
SHIP_TO_ORGANIZATION | VARCHAR2 | 240 | Ship-to Organization Name | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | 18 | Ship-to Organization Id | ||
SHIP_TO_LOCATION | VARCHAR2 | 240 | Ship-to Location Name | ||
SHIP_TO_LOCATION_ID | NUMBER | 18 | Ship-to Location Id | ||
QUANTITY | NUMBER | Minimum quantity of a price tier. | |||
MAX_QUANTITY | NUMBER | Maximum quantity of a price tier. | |||
TARGET_PRICE | NUMBER | Price tier target price. | |||
EFFECTIVE_START_DATE | DATE | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | |||
EFFECTIVE_END_DATE | DATE | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | |||
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. | ||
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_PRICE_TIERS_INT_N1 | Non Unique | Default | REQUEST_ID, CHUNK_ID, IMPORT_ACTION |
PON_LINE_PRICE_TIERS_INT_N2 | Non Unique | Default | REQUEST_ID, IMPORT_STATUS |
PON_LINE_PRICE_TIERS_INT_U1 | Unique | Default | INTERFACE_LINE_PT_ID |