PON_SELLER_AUCTION_HEADERS
Table for seller auction's header level details
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PON_SELLER_AUCTION_HEADER_PK |
SELLER_AUCTION_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SELLER_AUCTION_HEADER_ID | NUMBER | 18 | Yes | System-generated unique Identifier | |
| SHARE_AWARD_DECISION | VARCHAR2 | 1 | Flag indicating whether the award decision was shared with the bidders | ||
| SHARE_AWARD_DECISION_DATE | DATE | Date on which Share award decision was taken | |||
| NOTE_TO_ACCEPTED_BIDDERS | VARCHAR2 | 4000 | Note sent to bidders whose Bid has been accepted by Auctioneer | ||
| NOTE_TO_REJECTED_BIDDERS | VARCHAR2 | 4000 | Note sent to bidders whose Bid has been rejected by Auctioneer | ||
| AUCTION_STATUS | VARCHAR2 | 25 | Status of auction | ||
| AWARD_STATUS | VARCHAR2 | 25 | Award status of auction | ||
| PERSON_ID | NUMBER | 18 | The person id of the auction owner. | ||
| DRAFT_LOCKED | VARCHAR2 | 1 | Y or N flag for if negotiation is locked | ||
| DRAFT_LOCKED_DATE | DATE | Date when the draft was locked | |||
| DRAFT_LOCKED_BY_PERSON_ID | NUMBER | 18 | Person id of the person who locked the draft | ||
| DRAFT_UNLOCKED_DATE | DATE | Date when the draft was unlocked | |||
| DRAFT_UNLOCKED_BY_PERSON_ID | NUMBER | 18 | Person id of the person who unlocked the draft | ||
| DOCUMENT_NUMBER | VARCHAR2 | 240 | Auction number. | ||
| PRC_BU_ID | NUMBER | 18 | Yes | Procurement BU id | |
| AUCTION_TITLE | VARCHAR2 | 80 | Auction title | ||
| SYNOPSIS | VARCHAR2 | 4000 | Auction synopsis. | ||
| PREVIEW_AUCTION_NOW_FLAG | VARCHAR2 | 1 | Preview Immediately flag | ||
| PREVIEW_DATE | DATE | Date that auction will be available to preview by bidders | |||
| OPEN_AUCTION_NOW_FLAG | VARCHAR2 | 1 | Open Immediately flag | ||
| OPEN_DATE | DATE | Date that auction is open for bidding | |||
| CLOSE_DATE | DATE | Date that auction closes for bidding (Bids will not be accepted from this date onward) | |||
| AWARD_BY_DATE | DATE | Date by which the winning bids are scheduled for awarding by the auctioneer | |||
| AUTO_EXTEND_FLAG | VARCHAR2 | 1 | Y or N flag to indicate that auction can be automatically extended | ||
| MAX_NUM_OF_AUTO_EXTENSIONS | NUMBER | Allowable number of automatic extensions | |||
| AUTO_EXTEND_TRIGGER_PERIOD | NUMBER | Triggering Period (Schedule : Auto Extend Settings) | |||
| AUTO_EXTEND_DURATION | NUMBER | Duration to be added in each automatic extension of the auction (in minutes) | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Base Currency code in which the auction will be conducted | ||
| INSTRUCTION_TEXT | CLOB | Instruction rich text | |||
| PUBLISH_DATE | DATE | Date negotiation is published | |||
| IS_PAUSED | VARCHAR2 | 1 | Indicates whether the auction is Paused or not. | ||
| PAUSE_DATE | DATE | Date on which the auction is paused. | |||
| CLOSE_DATE_PAUSE_ADJUSTED | DATE | This column stores the value of close bidding date, except when the negotiation is in paused status. When the negotiation is paused, this value is incremented by 30000 | |||
| CANCEL_DATE | DATE | Date of auction cancellation | |||
| NUMBER_OF_AUTO_EXTENSIONS | NUMBER | Number of extensions made | |||
| NUMBER_OF_BIDS | NUMBER | Number of bids received | |||
| AWARD_SAVED_DATE | DATE | Date the latest Award was saved | |||
| AWARD_COMPLETE_DATE | DATE | Date the negotiation award process was Completed. | |||
| 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. | |
| PAUSE_REMARKS | VARCHAR2 | 2000 | Reason for which the negotiation is paused. | ||
| RESUME_REMARKS | VARCHAR2 | 2000 | Reason for which the negotiation is resumed. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| pon_seller_auction_bidders | pon_seller_auction_headers | SELLER_AUCTION_HEADER_ID |
| pon_seller_auction_lines | pon_seller_auction_headers | SELLER_AUCTION_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_SELLER_AUC_HEADERS_N1 | Non Unique | Default | UPPER("AUCTION_STATUS") |
| PON_SELLER_AUC_HEADERS_N2 | Non Unique | Default | TRUNC("OPEN_DATE") |
| PON_SELLER_AUC_HEADERS_U1 | Unique | Default | SELLER_AUCTION_HEADER_ID |
| PON_SELLER_AUC_HEADERS_U2 | Unique | Default | DOCUMENT_NUMBER, PRC_BU_ID |