PON_BID_SHIPMENTS_INT
PON_BID_SHIPMENTS_INT is the interface table for price breaks for spreadsheet upload during bidding.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PON_BID_SHIPMENTS_INT_PK |
INTERFACE_BID_SHIPMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Batch ID | |
| INTERFACE_LINE_ID | NUMBER | Yes | The spreadsheet row id. | ||
| AUCTION_HEADER_ID | NUMBER | 18 | Yes | Auction Header ID | |
| LINE_NUMBER | NUMBER | Reference to Negotiation Line Number | |||
| BID_NUMBER | NUMBER | 18 | Yes | Bid Number | |
| AUCTION_SHIPMENT_NUMBER | NUMBER | Auction Shipment Number | |||
| BID_SHIPMENT_NUMBER | NUMBER | Bid Shipment Number | |||
| SHIP_TO_ORGANIZATION_ID | NUMBER | 18 | Ship TO organization id | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Ship To location Id | ||
| QUANTITY | NUMBER | Quantity | |||
| PRICE_TYPE | VARCHAR2 | 25 | PRICE / PRICE DISCOUNT | ||
| PRICE_DISCOUNT | NUMBER | Price discount | |||
| BID_CURRENCY_UNIT_PRICE | NUMBER | Bid currency unit 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. | |||
| ACTION | NUMBER | 1: Required 2: Existing Optional PB 3. New 4. Delete 5. Changed to Supplier Owned | |||
| WORKSHEET_NAME | VARCHAR2 | 80 | Name of the XML Worksheet in which the error occurred. | ||
| WORKSHEET_SEQUENCE_NUMBER | NUMBER | Sequence number of the worksheet. This is used to sort the errors from middle tier and pl/sql layer. | |||
| 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. | ||
| MAX_QUANTITY | NUMBER | Used during Price Tier. It stores the maximum quantity and minimum quantity. | |||
| SHIP_TO_LOCATION | VARCHAR2 | 240 | Name of the Location where the supplier ships the item. | ||
| BID_LINE_NUMBER | NUMBER | Reference to Bid Line Number | |||
| INTERFACE_BID_SHIPMENT_ID | NUMBER | Yes | Unique Identifier for the row |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_BID_SHIPMENTS_INT_N1 | Non Unique | Default | BATCH_ID, LINE_NUMBER, AUCTION_SHIPMENT_NUMBER |
| PON_BID_SHIPMENTS_INT_N2 | Non Unique | Default | BATCH_ID, LINE_NUMBER, BID_SHIPMENT_NUMBER, INTERFACE_LINE_ID |
| PON_BID_SHIPMENTS_INT_N3 | Non Unique | Default | BATCH_ID, AUCTION_HEADER_ID, BID_NUMBER |
| pon_bid_shipments_int_U1 | Unique | Default | INTERFACE_BID_SHIPMENT_ID |