PON_SELLER_AUC_BID_HEADERS
This table stores header level data for Seller Auction's responses.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PON_SELLER_AUC_BID_HEADER_PK |
BID_NUMBER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BID_NUMBER | NUMBER | 18 | Yes | System-generated unique identifier for response. | |
| AWARD_DATE | DATE | Awarded Date | |||
| TOTAL_AWARD_AMOUNT | NUMBER | Stores the calculated award amount for the Bidder | |||
| AWARD_STATUS | VARCHAR2 | 25 | Award status of Bid | ||
| NOTE_TO_BIDDER | VARCHAR2 | 4000 | Stores the note to Bidder entered during the award process | ||
| SHORTLIST_FLAG | VARCHAR2 | 1 | Flag indicating whether a bid has been shortlisted for award | ||
| SELLER_AUCTION_HEADER_ID | NUMBER | 18 | Yes | Auction header identifier for a seller's auction | |
| BIDDER_REFERENCE_NUMBER | VARCHAR2 | 25 | This is the bidder's bid number | ||
| TRADING_PARTNER_CONTACT_ID | NUMBER | 18 | Identifier for contact person of bidder trading partner | ||
| TRADING_PARTNER_ID | NUMBER | 18 | Identifier for bidder trading partner | ||
| VENDOR_SITE_ID | NUMBER | 18 | stores vendor site id used to create the po | ||
| BID_STATUS | VARCHAR2 | 25 | Status of the bid | ||
| BID_EXPIRATION_DATE | DATE | Date until which the bid is valid | |||
| PUBLISH_DATE | DATE | Date on which bid is published | |||
| DISQUALIFY_REASON | VARCHAR2 | 4000 | Disqualify reason given by auctioneer if auctioneer disqualifies bid. | ||
| NOTE_TO_AUCTION_OWNER | VARCHAR2 | 4000 | Note to owner of the seller auction | ||
| PROXY_BID_FLAG | VARCHAR2 | 1 | Y or N flag to indicate that proxy bid is allowed | ||
| DRAFT_LOCKED_FLAG | VARCHAR2 | 1 | Y or N flag to indicate if the draft is locked by a user. | ||
| DRAFT_LOCKED_BY_CONTACT_ID | NUMBER | 18 | Trading partner contact id of the lock owner | ||
| DRAFT_LOCKED_DATE | DATE | Date and Time when the draft was locked | |||
| DRAFT_UNLOCKED_BY_CONTACT_ID | NUMBER | 18 | Trading partner contact id of the person who unlocked the draft | ||
| DRAFT_UNLOCKED_DATE | DATE | Date and Time when the draft was unlocked | |||
| PARTIAL_RESPONSE_FLAG | VARCHAR2 | 1 | 'Y' if the supplier has bid partial quantities or on partial lines | ||
| NEG_CURRENCY_BID_TOTAL | NUMBER | Bid total in negotiations currency. | |||
| OLD_NOTE_TO_AUCTION_OWNER | VARCHAR2 | 4000 | Note to negotiation owner from source bid. | ||
| OLD_BIDDER_REFERENCE_NUMBER | VARCHAR2 | 25 | Reference number from source bid | ||
| OLD_BID_EXPIRATION_DATE | DATE | Expiration date from source bid. | |||
| OLD_BID_NUMBER | NUMBER | 18 | The bid number where the old values are populated from | ||
| 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_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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| pon_seller_auc_bid_lines | pon_seller_auc_bid_headers | BID_NUMBER |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_SELLER_AUC_BID_HEADE_N1 | Non Unique | Default | SELLER_AUCTION_HEADER_ID |
| PON_SELLER_AUC_BID_HEADE_U1 | Unique | Default | BID_NUMBER |