PON_AUCTION_HEADERS_ALL
PON_AUCTION_HEADERS stores auctions, RFQs, and RFIs header information. Each row includes general negotiation information such as type, style, business terms and conditions, response controls, et cetera. The DOCTYPE_ID column indicates whether the transaction is an auction, RFQ, or RFI.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
PON_AUCTION_HEADERS_ALL_PK |
AUCTION_HEADER_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
AUCTION_HEADER_ID | NUMBER | 18 | Yes | System-generated unique Identifier | |
SUBMIT_PO_DATE | TIMESTAMP | Date on which the purchasing document is submitted | |||
ACCEPT_TERMS_BEFORE_NEG_FLAG | VARCHAR2 | 1 | Flag to indicate if "Accept terms before view negotiaion" is enabled or not. | ||
SHARE_AWD_DECISION_DATE | DATE | Date on which Share award decision was taken | |||
AUCTION_TITLE | VARCHAR2 | 80 | Auction title | ||
AUCTION_STATUS | VARCHAR2 | 25 | Status of auction | ||
AWARD_STATUS | VARCHAR2 | 25 | Award status of auction | ||
CONTRACT_TYPE | VARCHAR2 | 25 | Type of contract. Spot buy or Long Term Buy | ||
OPEN_BIDDING_DATE | DATE | Date that auction is open for bidding | |||
CLOSE_BIDDING_DATE | DATE | Current date that auction closes for bidding (Bids will not be accepted from this date onward) | |||
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 | |||
ORIGINAL_CLOSE_BIDDING_DATE | DATE | Original date for which auction was setup to close for bidding | |||
VIEW_BY_DATE | DATE | Date negotiation will be available to view by authorized suppliers | |||
AWARD_BY_DATE | DATE | Date by which the winning bids are scheduled for awarding by the auctioneer | |||
PUBLISH_DATE | DATE | Date negotiation is published | |||
CANCEL_DATE | DATE | Date of auction cancellation | |||
BID_VISIBILITY_CODE | VARCHAR2 | 25 | Code specifying who in the system can view the bids. For OPEN_BIDDING the bid are visible to every authorized user, SEALED_BIDDING only the auctioneer can view the bids, SEALED_AUCTION the auctioneer can view the bids after he has unlocked the negotiation and suppliers could view the bids after the auctioneer has unsealed the negotiation. | ||
BID_LIST_TYPE | VARCHAR2 | 25 | Bid List Type to indicate whether bidders are by invitation only or public bidders | ||
BID_FREQUENCY_CODE | VARCHAR2 | 25 | Bid Frequency Code to indicate if only one bid per bidder can be entered or multiple bids are allowed. Possible values are MULTIPLE_BIDS_ALLOWED , SINGLE_BID_ONLY. | ||
BID_SCOPE_CODE | VARCHAR2 | 25 | Code specifying whether bidder can bid on individual items or must bid on all items | ||
AUTO_EXTEND_FLAG | VARCHAR2 | 1 | Y or N flag to indicate that auction can be automatically extended | ||
AUTO_EXTEND_NUMBER | NUMBER | Allowable number of automatic extensions | |||
NUMBER_OF_EXTENSIONS | NUMBER | Number of extensions made | |||
NUMBER_OF_BIDS | NUMBER | Number of bids received | |||
MIN_BID_DECREMENT | NUMBER | Minimum allowable bid decrement in a bidders bid if multiple bids are allowed | |||
PRICE_DRIVEN_AUCTION_FLAG | VARCHAR2 | 1 | Y or N flag for auction being price-driven | ||
PAYMENT_TERMS_ID | NUMBER | 18 | Identifier for payment terms | ||
FREIGHT_TERMS_CODE | VARCHAR2 | 30 | Freight terms code | ||
FOB_CODE | VARCHAR2 | 30 | Free on board code | ||
CURRENCY_CODE | VARCHAR2 | 15 | Base Currency code in which the auction will be conducted | ||
RATE_TYPE | VARCHAR2 | 30 | Currency rate type(CORPORATE,USER) | ||
RATE_DATE | DATE | Currency Conversion rate date. Applicable only if the RATE TYPE is CORPORATE. | |||
LANGUAGE_CODE | VARCHAR2 | 4 | Language negotiation is created in | ||
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. | |
WF_ITEM_KEY | VARCHAR2 | 240 | Not currently used. Workflow Item Key for the main AUCTION workflow. | ||
WF_ROLE_NAME | VARCHAR2 | 30 | Not currently used. Workflow Role name created to hold the invited bidders as well as active bidders. | ||
AUTO_EXTEND_ALL_LINES_FLAG | VARCHAR2 | 1 | Y or N flag to indicate if all auction items are automatically extended if one item qualifies for auto-extension | ||
ALLOW_OTHER_BID_CURRENCY_FLAG | VARCHAR2 | 1 | Y or N flag to indicate if other bid currencies are allowed | ||
AUTO_EXTEND_DURATION | NUMBER | Duration to be added in each automatic extension of the auction (in minutes) | |||
PUBLISH_RATES_TO_BIDDERS_FLAG | VARCHAR2 | 1 | Y or N flag to indicate if currency exchange rates are allowed to be published to bidders | ||
ATTRIBUTES_EXIST | VARCHAR2 | 20 | Development only flag to indicate existence of item attributes | ||
EVENT_ID | NUMBER | Auction Event Identifier for a group of auctions to be monitored | |||
EVENT_TITLE | VARCHAR2 | 80 | Title of the event the auction is associated with | ||
SEALED_AUCTION_STATUS | VARCHAR2 | 30 | Status of sealed auction | ||
SEALED_ACTUAL_UNLOCK_DATE | DATE | Date on which sealed auction was unlocked | |||
SEALED_ACTUAL_UNSEAL_DATE | DATE | Date on which sealed auction was unsealed | |||
PO_START_DATE | DATE | Purchase order start date. Applicable only for long term Buyer's auction. | |||
PO_END_DATE | DATE | Purchase order end date. Applicable only for long term Buyer's auction. | |||
PO_AGREED_AMOUNT | NUMBER | Purchase order agreed amount. Applicable only for long term Buyer's auction. | |||
MIN_BID_CHANGE_TYPE | VARCHAR2 | 25 | Minimum bid change type | ||
FULL_QUANTITY_BID_CODE | VARCHAR2 | 25 | Y or N flag to indicate if full quanitty bid are required. | ||
NUMBER_PRICE_DECIMALS | NUMBER | Required precision of bid price | |||
AUTO_EXTEND_TYPE_FLAG | VARCHAR2 | 25 | Flag to denote base date to use to calculate the new auction close time if the autoextend trigger is on for the auction | ||
AUCTION_ORIGINATION_CODE | VARCHAR2 | 50 | Code for origin of auction | ||
AUCTION_HEADER_ID_ORIG_ROUND | NUMBER | 18 | Auction Header Identifier for the Original Round | ||
AUCTION_HEADER_ID_PREV_ROUND | NUMBER | 18 | Auction Header Identifier for the previous round | ||
AUCTION_ROUND_NUMBER | NUMBER | Number of rounds for this auction | |||
AUTOEXTEND_CHANGED_FLAG | VARCHAR2 | 1 | Y or N flag to indicate that autoextension details are changed by the auctioneer | ||
DOCTYPE_ID | NUMBER | 18 | Identifier for document type associated with this auction | ||
SHOW_BIDDER_NOTES | VARCHAR2 | 1 | Flag indicating if bidder notes and attachments are visible to other bidders | ||
DRAFT_LOCKED | VARCHAR2 | 1 | Y or N flag for if negotiation is locked | ||
DRAFT_LOCKED_DATE | DATE | date the draft was locked | |||
DRAFT_UNLOCKED_DATE | DATE | date the draft was unlocked | |||
PROJECT_ID | NUMBER | Unique identifier of the project in Oracle Projects which governs the negotiation | |||
BID_RANKING | VARCHAR2 | 25 | Bid evaluation method for this negotiation | ||
RANK_INDICATOR | VARCHAR2 | 25 | Rank indicator for this negotiation | ||
SHOW_BIDDER_SCORES | VARCHAR2 | 25 | whether scoring model is show to bidders | ||
OPEN_AUCTION_NOW_FLAG | VARCHAR2 | 1 | open auction now flag | ||
PUBLISH_AUCTION_NOW_FLAG | VARCHAR2 | 1 | publish auction now flag | ||
TEMPLATE_ID | NUMBER | 18 | FK to pon_auction_headers_all for the template that was applied | ||
REMINDER_DATE | DATE | reminder date that reminder e-mail should be sent out if invited bidder has not acknowledged partcipation | |||
PRC_BU_ID | NUMBER | 18 | Yes | Procurement BU id | |
WF_PONCOMPL_ITEM_KEY | VARCHAR2 | 240 | Not currently used. Workflow item key for PO creation process | ||
HAS_PE_FOR_ALL_ITEMS | VARCHAR2 | 1 | Flag to indicate if all the items in the negotiation doc has Price Elements defined. | ||
HAS_PRICE_ELEMENTS | VARCHAR2 | 1 | Flag to indicate if any item in the negotiation doc has Price Elements defined. | ||
PO_MIN_REL_AMOUNT | NUMBER | Blanket Minimum Release Amount | |||
OUTCOME_STATUS | VARCHAR2 | 30 | Status to indicate outcome creation | ||
SOURCE_REQS_FLAG | VARCHAR2 | 1 | Indicates whether to source requisitions against blanket agreements | ||
AWARD_COMPLETE_DATE | DATE | Date the negotiation award process was Completed. | |||
WF_PONCOMPL_CURRENT_ROUND | NUMBER | Not currently used. Current Workflow round kicked off to create outcome documents | |||
WF_APPROVAL_ITEM_KEY | VARCHAR2 | 240 | Not currently used. Approval workflow key identifier | ||
NEG_APPROVAL_STATUS | VARCHAR2 | 30 | Approval status of a negotiation. The possible values are : APPROVAL_IN_PROCES, APPROVED, REJECTED, WITHDRAWN and APPROVED_NOT_PUBLISHED. | ||
SOURCE_DOC_ID | NUMBER | 18 | Source Document Id | ||
SOURCE_DOC_NUMBER | VARCHAR2 | 30 | Source document number display | ||
SOURCE_DOC_MSG | VARCHAR2 | 30 | Source doc. display message name | ||
SOURCE_DOC_LINE_MSG | VARCHAR2 | 30 | Souce doc. line display message name | ||
SOURCE_DOC_MSG_APP | VARCHAR2 | 3 | Message application short name | ||
SHARE_AWARD_DECISION | VARCHAR2 | 1 | Share award decision with suppliers? | ||
INCLUDE_PDF_IN_EXTERNAL_PAGE | VARCHAR2 | 1 | Not currently used. Whether to Include Pdf In External Page? | ||
ABSTRACT_DETAILS | VARCHAR2 | 4000 | Not currently used. Abstract Details | ||
ABSTRACT_STATUS | VARCHAR2 | 20 | Not currently used. Abstract Status | ||
DESCRIPTION | VARCHAR2 | 250 | Template description | ||
TEMPLATE_SCOPE | VARCHAR2 | 25 | Scope of template. Private or Public. | ||
TEMPLATE_STATUS | VARCHAR2 | 25 | Template status. Active or inactive. | ||
IS_TEMPLATE_FLAG | VARCHAR2 | 1 | Flag that identifies if the row represents a template or negotiation. The value 'Y' implies this is a template. | ||
AWARD_APPROVAL_FLAG | VARCHAR2 | 1 | Flag to indicate if award approval is required for this negotiation before the award process can be completed. | ||
AWARD_APPROVAL_STATUS | VARCHAR2 | 30 | Award Approval Status | ||
AWARD_APPR_AME_TRANS_ID | VARCHAR2 | 80 | Not currently used. Current AME approval transaction id. | ||
AWARD_APPR_AME_TRANS_PREV_ID | VARCHAR2 | 80 | Not currently used. Previous AME approval transaction id. | ||
WF_AWARD_APPROVAL_ITEM_KEY | VARCHAR2 | 240 | Not currently used. Award Approval Workflow Item Key. | ||
AMENDMENT_NUMBER | NUMBER | Amendment Number. | |||
AMENDMENT_DESCRIPTION | VARCHAR2 | 4000 | Amendment description. | ||
AUCTION_HEADER_ID_ORIG_AMEND | NUMBER | 18 | Auction header id corresponding to the first amendment for this negotiation. | ||
AUCTION_HEADER_ID_PREV_AMEND | NUMBER | 18 | Previous amendment auction header id. | ||
DOCUMENT_NUMBER | VARCHAR2 | 240 | Negotiation number. | ||
AWARD_APPR_AME_TXN_DATE | DATE | Not currently used. Date and time at which the Award Approval was initiated. | |||
HDR_ATTR_ENABLE_WEIGHTS | VARCHAR2 | 1 | Denotes whether weights are enabled on Header Attributes | ||
HDR_ATTR_DISPLAY_SCORE | VARCHAR2 | 1 | Denotes whether to show header attribute scoring criteria to suppliers | ||
HDR_ATTR_MAXIMUM_SCORE | NUMBER | Stores the default maximum score on the header attributes | |||
ATTRIBUTE_LINE_NUMBER | NUMBER | Not currently used. Internal column - will always store a value of -1 to denote the line number for header attributes. Change it to nullable. | |||
CONTERMS_EXIST_FLAG | VARCHAR2 | 1 | Indicates if the negotiation has contract terms | ||
CONTERMS_ARTICLES_UPD_DATE | DATE | Last update date for the negotiation's contract articles | |||
CONTERMS_DELIV_UPD_DATE | DATE | Last update date for the negotiation's contract deliverables | |||
AWARD_MODE | VARCHAR2 | 30 | Stores the mode in which the last award was saved | ||
HAS_HDR_ATTR_FLAG | VARCHAR2 | 1 | Flag that denotes whether any header attributes exists for this negotiation | ||
AWARD_DATE | DATE | Date the latest Award was saved | |||
MAX_INTERNAL_LINE_NUM | NUMBER | Holds the maximum LINE_NUMBER throughout all the rounds/amendments | |||
MAX_BID_COLOR_SEQUENCE_ID | NUMBER | Maximum color sequence number allotted to the responses for this negotiation. For negotiations created before this column existed, the value will be upgraded to -1. When the user tries to view the live console for the negotiation, the value will be recalculated and populated. For new negotiations, the value is initially 0. | |||
HAS_ITEMS_FLAG | VARCHAR2 | 1 | Flag that indicates if there are any line items for this negotiation. This flag is set to 'Y' for templates. | ||
INT_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Internal Descriptive Flexfield context. This flexfield is not visible to suppliers. | ||
INT_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
INT_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | External Descriptive Flexfield context. This flexfield is visible to anyone who has access to the negotiation. | ||
EXT_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield Segment | ||
EXT_ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield Segment | |||
EXT_ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield Segment | |||
PF_TYPE_ALLOWED | VARCHAR2 | 30 | Indicates the combination of buyer/supplier price factors. Stored as lookup values. | ||
SUPPLIER_VIEW_TYPE | VARCHAR2 | 30 | Indicates whether suppliers will see their quotes transformed. Stored as lookup values. | ||
IS_PAUSED | VARCHAR2 | 1 | Indicates whether the negotiation is Paused or not. | ||
PAUSE_REMARKS | VARCHAR2 | 2000 | Reason for which the Negotiation is paused. | ||
LAST_PAUSE_DATE | TIMESTAMP | Date on which the negotiation is paused. | |||
MAX_DOCUMENT_LINE_NUM | NUMBER | Maximum parent DOCUMENT_DISP_LINE_NUMBER throughout rounds/amendments | |||
PROGRESS_PAYMENT_TYPE | VARCHAR2 | 10 | Not currently used. Indicates whether the negotiation is used for complex services and the type. 'NONE' indicates that the negotiation is not used for complex services, 'FINANCE' indicates financing will be provided and 'ACTUAL' indicates that payments will be made against actuals | ||
ADVANCE_NEGOTIABLE_FLAG | VARCHAR2 | 1 | Not currently used. Indicates whether the Supplier can negotiate the amount of advance on a line | ||
RECOUPMENT_NEGOTIABLE_FLAG | VARCHAR2 | 1 | Not currently used. Indicates whether the recoupment rate on the line is negotiable | ||
PROGRESS_PYMT_NEGOTIABLE_FLAG | VARCHAR2 | 1 | Not currently used. Indicates whether the progress payment rate is negotiable | ||
RETAINAGE_NEGOTIABLE_FLAG | VARCHAR2 | 1 | Indicates whether the retainage rate on the line is negotiable | ||
MAX_RETAINAGE_NEGOTIABLE_FLAG | VARCHAR2 | 1 | Indicates whether the maximum retainage amount on the line is negotiable | ||
SUPPLIER_ENTERABLE_PYMT_FLAG | VARCHAR2 | 1 | Not currently used. Indicates whether the supplier is allowed to create or modify pay items on negotiations with complex services. If not, the supplier can only respond to the pay items as proposed by the buyer | ||
TEAM_SCORING_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if the style applied to this negotiation has team scoring enabled. The team scoring portion will be shown in the negotiation creation and review screens only if this flag is set. If team scoring is enabled, the value will be "E". Otherwise, the value will be "D". | ||
HAS_SCORING_TEAMS_FLAG | VARCHAR2 | 1 | Indicates if this negotiation has been enabled for Team Scoring. 'Y' indicates negotiation is enabled and is set such when editor creates scoring teams for this negotiation. The flag will be set to NULL or 'N' when team scoring is not enabled for this negotiation. | ||
SCORING_LOCK_DATE | DATE | Date on which this negotiation was closed for team scoring. Beyond this date a scorer will not be able to enter scores to evaluate the responses unless scoring is unlocked. An editor may manually lock the scores or implicitly do so when the negotiation is submitted for award approval or the award is completed. | |||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
REQUEST_DATE | DATE | Date/time when concurrent request was submitted for creation/award flow | |||
REQUESTED_BY | NUMBER | The user id of the person who made the concurrent request. | |||
IMPORT_FILE_NAME | VARCHAR2 | 255 | The spreadsheet file name that is used for importing. | ||
NUMBER_OF_LINES | NUMBER | Number of lines in the negotiation. | |||
LAST_LINE_NUMBER | NUMBER | Maximum line, lot, or group number in the negotiation. | |||
STYLE_ID | NUMBER | 18 | Style id | ||
COVER_PAGE_ENABLED_FLAG | VARCHAR2 | 1 | 15 | Y/N flag to indicate whether cover page is enabled. | |
TWOSTAGE_EVAL_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether two stage evaluation is enabled. | ||
GENERAL_INTRO_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether general introduction section is enabled. | ||
TERMS_INSTR_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether terms instruction is enabled. | ||
STAG_CLOSE_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether staggered closing is enabled. | ||
ABSTRACT_ENABLED_FLAG | VARCHAR2 | 1 | E/D flag to indicate whether abstract is enabled. If the abstract is enabled, the value is "E". Otherwise, the value is "D". | ||
REQMNTS_INSTR_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether requirements instruction is enabled. | ||
LINES_INSTR_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether lines instruction is enabled. | ||
CONTERMS_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether contract terms is enabled. | ||
LINE_ATTRIBUTE_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if the attribute is enabled. | ||
LINE_MAS_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if MAS is enabled. | ||
PRICE_ELEMENT_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if price element is enabled. | ||
RFI_LINE_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if line is enabled, applicable to RFI. | ||
LOT_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if lot is enabled. | ||
GROUP_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if group is enabled. | ||
LARGE_NEG_ENABLED_FLAG | VARCHAR2 | 1 | E/D flag to indicate if large negotiation is enabled. | ||
HDR_ATTRIBUTE_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if header attribute is enabled. | ||
NEG_TEAM_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if collaboration team is enabled. | ||
PROXY_BIDDING_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if proxy bidding is enabled. | ||
POWER_BIDDING_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if power bidding is enabled. | ||
AUTO_EXTEND_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if auto-extension is enabled. | ||
PO_STYLE_ID | NUMBER | 18 | Part of the unique key of PO style for the negotiation. The other part, PO document type, is stored in contract_type. | ||
GLOBAL_TEMPLATE_FLAG | VARCHAR2 | 1 | Stores whether the template is global or not | ||
CONTRACT_TEMPLATE_ID | NUMBER | Contract template id for the template row | |||
COMPLETE_FLAG | VARCHAR2 | 1 | Indicates whether all batches finish successfully | ||
BID_DECREMENT_METHOD | VARCHAR2 | 15 | Indicates the method used for bid decrement for open auctions. 'BEST_PRICE' indicates bid should be decremented based on best response price. 'PREVIOUS_PRICE' indicates bid should be decremented based on suppliers previous active response. | ||
DISPLAY_BEST_PRICE_BLIND_FLAG | VARCHAR2 | 1 | This column specifies whether the best price on blind negotiations can be displayed to suppliers. | ||
FIRST_LINE_CLOSE_DATE | DATE | Date at which the first line is schedueld to close in a staggered closing scenerio. | |||
STAGGERED_CLOSING_INTERVAL | NUMBER | Staggered line closing interval. | |||
ENFORCE_PREVRND_BID_PRICE_FLAG | VARCHAR2 | 1 | When this flag is set, each supplier user sees his previous active bid's quoted price as the start price of each line. This flag can only be set by the buyer when creating a new round. It cannot be set for the first round. For example, if the start price of a line is $100 in the first round, the supplier bids $95 and this control is set in the second round, then the supplier will see a start price of $95 for this line in the second round. | ||
PRICE_TIERS_INDICATOR | VARCHAR2 | 30 | Stores NONE, PRICE_BREAKS or QUANTITY_TIERS | ||
AUTO_EXTEND_MIN_TRIGGER_RANK | NUMBER | The minimum rank that will trigger auto extension. Null means any bid. | |||
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. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program | ||
PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the application name spawning the concurrent request. | ||
QTY_PRICE_TIERS_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if quantity based price tiers is enabled. | ||
TWO_PART_FLAG | VARCHAR2 | 1 | Y/N to indicate if this is a two-part RFQ | ||
TECHNICAL_LOCK_STATUS | VARCHAR2 | 30 | Used to store the technical part's lock status for a 2part RFQ. | ||
TECHNICAL_EVALUATION_STATUS | VARCHAR2 | 30 | Stores the technical evaluation completion status. | ||
TECHNICAL_ACTUAL_UNLOCK_DATE | DATE | Date when the technical unlock was done | |||
TECHNICAL_ACTUAL_UNSEAL_DATE | DATE | Date when the technical unseal was done | |||
CARRIER_ID | NUMBER | 18 | Carrier ID | ||
VERSION_NUM | NUMBER | Version number of contract | |||
HAS_LINE_CURRENT_PRICE | VARCHAR2 | 1 | Indicates whether at least one line has a current price defined | ||
NEGOTIATION_LAYOUT_ID | NUMBER | Negotiation Layout Id (Negotiation Control) | |||
RESPONSE_LAYOUT_ID | NUMBER | Response Layout Id (Negotiation Control) | |||
CONTRACT_LAYOUT_ID | NUMBER | Contract Terms Layout Id (Negotiation Control) | |||
REQ_BU_ID | NUMBER | 18 | Requisition BU Id (Negotiation Control: Lines) | ||
BID_LIST_TYPE_DSP_FLAG | VARCHAR2 | 1 | Display to Supplier Flag (Response Rule: Restrict to invited suppliers) | ||
SHOW_BIDDER_NOTES_DSP_FLAG | VARCHAR2 | 1 | Display to Supplier Flag (Response Rule: Allow supplier to see other supplier's notes and attachments) | ||
BID_SCOPE_CODE_DSP_FLAG | VARCHAR2 | 1 | Display to Supplier Flag (Response Rule: Allow supplier to select lines on which to respond) | ||
FULL_QUANTITY_BID_DSP_FLAG | VARCHAR2 | 1 | Display to Supplier Flag (Response Rule: Require full quantity) | ||
BID_FREQUENCY_CODE_DSP_FLAG | VARCHAR2 | 1 | Display to Supplier Flag (Response Rule: Allow multiple responses) | ||
DISPLAY_BEST_PRICE_DSP_FLAG | VARCHAR2 | 1 | Display to Supplier Flag (Response Rule: Display best price to suppliers) | ||
ENFORCE_PREVRND_BID_DSP_FLAG | VARCHAR2 | 1 | Display to Supplier Flag (Response Rule: Enforce supplier's previous round price as start price for this round) | ||
AUTO_EXTEND_TRIGGER_PERIOD | NUMBER | Triggering Period (Schedule : Auto Extend Settings) | |||
STAGGERED_CLOSING_FLAG | VARCHAR2 | 1 | Flag that indicates whether staggered closing is enabled. | ||
SYNOPSIS | VARCHAR2 | 4000 | Negotiation synopsis. | ||
COVER_PAGE_TEXT | CLOB | Cover page content text. | |||
GENERAL_INTRO_TEXT | CLOB | General introduction rich text | |||
TERMS_INSTR_TEXT | CLOB | Terms instruction rich text | |||
REQMNTS_INSTR_TEXT | CLOB | Requirements instruction rich text | |||
LINES_INSTR_TEXT | CLOB | Lines instruction rich text | |||
CREATION_DATE_ORIG_AMEND | DATE | Creation date of the original amendment. | |||
PUBLISH_DATE_ORIG_AMEND | DATE | Publish date of the original amendment | |||
PERSON_ID | NUMBER | 18 | The person id of the auction creator. | ||
DRAFT_LOCKED_BY_PERSON_ID | NUMBER | 18 | Person id of the person who locked the draft | ||
DRAFT_UNLOCKED_BY_PERSON_ID | NUMBER | 18 | Person id of the person who unlocked the draft | ||
SEALED_UNLOCK_PERSON_ID | NUMBER | 18 | Person id of the person who unlocks the sealed auction | ||
SEALED_UNSEAL_PERSON_ID | NUMBER | 18 | Person id of the person who unseals the sealed auction | ||
SCORING_LOCK_PERSON_ID | NUMBER | 18 | Person id of the person who locked down team scoring | ||
TECHNICAL_UNLOCK_PERSON_ID | NUMBER | 18 | Person id of the person who unlocked the technical part of the RFQ. | ||
TECHNICAL_UNSEAL_PERSON_ID | NUMBER | 18 | Person id of the person who unsealed the technical part of the RFQ | ||
NEGOTIATION_LAYOUT_NAME | VARCHAR2 | 240 | Negotiation Layout Template Name (Negotiation Control) | ||
RESPONSE_LAYOUT_NAME | VARCHAR2 | 240 | Response Layout Template Name (Negotiation Control) | ||
CONTRACT_LAYOUT_NAME | VARCHAR2 | 240 | Contract Layout Template Name (Negotiation Control) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ALTERNATE_LINES_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether allow alternate lines is enabled. | ||
ALLOW_ALTERNATE_LINES | VARCHAR2 | 30 | Value of allow alternate lines. Possible values are YES, NO and CONDITIONALLY. | ||
BID_REVISION_TYPE | VARCHAR2 | 30 | Bid Revision Type to indicate whether response revision is allowed. Possible values are ALLOW_BID_REVISION and NO_BID_REVISION. | ||
BID_REVISION_TYPE_DSP_FLAG | VARCHAR2 | 1 | Flag to indicate whether showing bid revision type to supplier. | ||
MODE_OF_TRANSPORT | VARCHAR2 | 30 | Type of transportation used to ship the product, such as truck, air or boat. | ||
SERVICE_LEVEL | VARCHAR2 | 30 | Priority of transportation that affects how quickly goods are transported . | ||
NEG_APPROVAL_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether negotiation approval is enabled. | ||
APPROVAL_AMOUNT | NUMBER | Negotiation Approval Amount. If negotiation is created from requisitions, approval amount will be defauled from requisition amount. | |||
CLOSE_DATE_TYPE | VARCHAR2 | 30 | Indicate the type of close date with value coming from lookup PON_CLOSE_DATE_TYPE. Possible values are FIXED and DAYS_AFTER_OPEN_DATE. | ||
DAYS_AFTER_OPEN_DATE | NUMBER | Specify close date by number of days after open date. | |||
NEG_APPR_IDENTIFICATION_KEY | VARCHAR2 | 80 | Identification key of the most recent negotiation approval request. | ||
NEG_APPROVAL_NOTE | VARCHAR2 | 1000 | Stores the Note to Approvers field value entered on Manage Negotiation Approval page. | ||
NEG_APPROVAL_DATE | DATE | The date when the approval/reject decision is made. | |||
AWARD_APPR_IDENTIFICATION_KEY | VARCHAR2 | 80 | Identificaiton key for the most recent award approval for the negotitiation | ||
AWARD_APPROVAL_NOTE | VARCHAR2 | 1000 | This field records the "Note to Approvers" field entered in the "Manage Award Approval" page | ||
AWARD_APPROVAL_DATE | DATE | Date on which the award approval decision was made | |||
APPROVAL_STATUS | VARCHAR2 | 30 | Approval status of a negotiation. The possible values are : APPROVAL_IN_PROCES, APPROVED, REJECTED, WITHDRAWN and APPROVED_NOT_PUBLISHED. | ||
BUYER_TRANSPORT_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether buyer managed transportation is enabled. | ||
BUYER_TRANSPORT_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether buyer will manage transportation. | ||
PROJECTS_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether projects is enabled. | ||
PO_CREATION_PROCESS | VARCHAR2 | 30 | Indicates whether purchasing document creation process for the negotiation is through web service or Fusion Purchasing. | ||
EXTERNAL_PO_CREATION_STATUS | VARCHAR2 | 30 | Status of purchasing document creation process when the purchasing document is created through external service. | ||
SCORING_OPEN_PERSON_ID | NUMBER | 18 | Most recent person who opened the team scoring. | ||
SCORING_OPEN_DATE | DATE | Most recent date on which a negotiation was opened for team scoring. | |||
SCORING_STATUS | VARCHAR2 | 30 | Status of Scoring. The values are from lookup and could be OPEN, CLOSED and NOT_STARTED. For 2 part RFQ, this will be used for commercial stage. | ||
TECHNICAL_SCORING_STATUS | VARCHAR2 | 30 | Status of Scoring of technical stage of 2 part RFQ. The values are from lookup and could be OPEN, CLOSED and NOT_STARTED. | ||
RESP_TABULATION_LAYOUT_NAME | VARCHAR2 | 240 | Response Tabulation Layout Template Name. | ||
AWARD_NOTICE_LAYOUT_NAME | VARCHAR2 | 240 | Award Notice Layout Template Name. | ||
REBUILD_INDEX | VARCHAR2 | 80 | This column has an Oracle Text Domain Index defined to support Keyword Search. | ||
LINE_DEFAULTS_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if line defaults is enabled. | ||
LINE_DEFAULTS_EXIST_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if the user has defined line attribute defaults or not. | ||
RESP_SPSHET_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether Response by Spreadsheet is enabled. | ||
RESP_XML_SPSHET_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether XML Response spreadsheet with Requirements and Lines is enabled. | ||
RESP_LINES_SPSHET_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether Linear Response Line spreadsheet is enabled. | ||
RESP_REQT_SPSHET_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether XML Response spreadsheet with Requirements only is enabled. | ||
IS_CREATED_FROM_REST | VARCHAR2 | 1 | Y/N flag to indicate whether this negotiation is created from REST Service. | ||
ALLOW_CONTRACT_CRT_FLAG | VARCHAR2 | 1 | Y or N flag to indicate whether negotiation is created with contracts | ||
CONTRACT_ID | NUMBER | 18 | identifier for contracts | ||
INTERNAL_CF_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether Internal cost factors is enabled | ||
OVERALL_RESP_RANK_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether Overall response rank is enabled | ||
DISPLAY_TRANS_AMOUNT_SUPP_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether display transformed amount to suppliers. | ||
DISPLAY_BID_RANK_TO_SUPP_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether display overall response rank to suppliers. | ||
CONTRACT_ERROR_MSG | VARCHAR2 | 2000 | Error code along with message returned by contracts createorupdate API | ||
INTERNAL_CF_LINES_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether Line level Internal Cost Factors is enabled | ||
DISPLAY_TRANS_RANK_SUPP_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether display rank based on transformed price to suppliers. | ||
LINE_DEFAULT_ICF_EXIST_FLAG | VARCHAR2 | 1 | Y/N flag to indicate if the user has defined default line internal cost factors or not. | ||
RETAINAGE_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether Retainage is enabled from Purchasing style | ||
PREBID_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether prebid is enabled in negotiation style. If prebid is enabled, the value will be "Y". Otherwise, the value will be "N". | ||
PREBID_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether prebid is enabled for this negotiation. | ||
LINE_DECREMENT_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether line level decrement is enabled in the style. | ||
LINE_DECREMENT_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether line level decrement is enabled for this negotiation. | ||
SPLIT_NEG_PDF_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether to split the negotiation document. | ||
OVERALL_RANKING_METHOD | VARCHAR2 | 30 | Stores RESPONSE_AMOUNT_ONLY,COMPOSITE_SCORE or NONE | ||
NEG_SUBMITTED_PERSON_ID | NUMBER | 18 | Person id of the person who published negotiation or submitted negotiation for approval | ||
COMPOSITE_SCORE_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether composite scoring is enabled for selection in the negotiation. | ||
NOTIFY_CONTACTS_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether notify all contacts is enabled in the style. | ||
TOTAL_SAVINGS_AMOUNT | NUMBER | Total amount saved for the negotiation | |||
SUPP_ITEM_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether supplier item and manufacturer part number option is enabled in the negotiation. | ||
SUPP_MSG_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether allow supplier messaging option is enabled in the negotiation. | ||
CAPTURE_SUPP_ITEM_ENABLED_FLAG | VARCHAR2 | 1 | This column is applicable only if SUPP_ITEM_ENABLED_FLAG is Y. If this flag is enabled, it allows the supplier to propose a New Supplier Item for a given Line. | ||
REQ_TO_NEG_HDR_ATTACH_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether copy attachments from requistion header to negotiation header instead of negotiation lines optin is enabled in the negotiation. | ||
REOPEN_AWARD_NUMBER | NUMBER | 5 | Number of times award has been reopened. | ||
REOPEN_AWARD_DATE | DATE | Last Award reopen date. | |||
REOPEN_AWARD_NOTE | VARCHAR2 | 2000 | This field records latest reason entered while reopening award. | ||
ALLOW_ZERO_RESPONSE_PRICE_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether zero response price is allowed or not. This value is set based on opt-in. | ||
LAST_BID_ACTIVITY_DATE | DATE | This column stores the timestamp of latest response submitted/disqualified. | |||
COVER_TEXT_GEN_AI_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether to enable GenAI assist for negotiation cover text. | ||
BUYER_BIP_LAYOUT_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether to use BIP data model based layout or VO based layout for generating Buyer PDF. | ||
SUPP_BIP_LAYOUT_ENABLED_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether to use BIP data model based layout or VO based layout for generating Supplier PDF. | ||
NEG_BUYER_PDF_LAYOUT_NAME | VARCHAR2 | 240 | Data Model Based Negotiation Buyer Layout Pdf Template Name (Negotiation Control) | ||
NEG_SUPPLIER_PDF_LAYOUT_NAME | VARCHAR2 | 240 | Data Model Based Negotiation Supplier Layout Pdf Template Name (Negotiation Control) |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PON_AUCTION_HEADERS_ALL | per_persons | PERSON_ID |
PON_AUCTION_HEADERS_ALL | pon_auc_doctypes_b | DOCTYPE_ID |
PON_AUCTION_HEADERS_ALL | per_persons | DRAFT_LOCKED_BY_PERSON_ID |
PON_AUCTION_HEADERS_ALL | per_persons | DRAFT_UNLOCKED_BY_PERSON_ID |
PON_AUCTION_HEADERS_ALL | pon_auction_headers_all | TEMPLATE_ID |
PON_AUCTION_HEADERS_ALL | pon_auction_headers_all | AUCTION_HEADER_ID_ORIG_AMEND |
PON_AUCTION_HEADERS_ALL | pon_auction_headers_all | AUCTION_HEADER_ID_PREV_AMEND |
PON_AUCTION_HEADERS_ALL | per_persons | SCORING_LOCK_PERSON_ID |
PON_AUCTION_HEADERS_ALL | pon_negotiation_styles_b | STYLE_ID |
PON_AUCTION_HEADERS_ALL | po_doc_style_headers | PO_STYLE_ID |
PON_AUCTION_HEADERS_ALL | okc_terms_templates_all | CONTRACT_TEMPLATE_ID |
PON_AUCTION_HEADERS_ALL | per_persons | TECHNICAL_UNLOCK_PERSON_ID |
PON_AUCTION_HEADERS_ALL | per_persons | TECHNICAL_UNSEAL_PERSON_ID |
PON_AUCTION_HEADERS_ALL | gl_daily_conversion_types | RATE_TYPE |
PON_AUCTION_HEADERS_ALL | per_persons | SEALED_UNLOCK_PERSON_ID |
PON_AUCTION_HEADERS_ALL | per_persons | SEALED_UNSEAL_PERSON_ID |
PON_AUCTION_HEADERS_ALL | pon_auction_headers_all | AUCTION_HEADER_ID_ORIG_ROUND |
PON_AUCTION_HEADERS_ALL | pon_auction_headers_all | AUCTION_HEADER_ID_PREV_ROUND |
pon_negotiation_abstracts | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_requirement_sections | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_acknowledgements | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_po_numbers | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_requirements | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_po_numbers_history | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_requirement_scores_int | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_scoring_team_members | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_award_allocations | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_threads | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_attribute_values | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_requirements | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_po_org_assignments | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_po_lines | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_auction_headers_all | pon_auction_headers_all | TEMPLATE_ID |
pon_auction_headers_all | pon_auction_headers_all | AUCTION_HEADER_ID_ORIG_AMEND |
pon_auction_headers_all | pon_auction_headers_all | AUCTION_HEADER_ID_PREV_AMEND |
pon_auction_headers_all | pon_auction_headers_all | AUCTION_HEADER_ID_ORIG_ROUND |
pon_auction_headers_all | pon_auction_headers_all | AUCTION_HEADER_ID_PREV_ROUND |
pon_acceptances | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_sections | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_requirements_int | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_scoring_teams | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_requirement_scores | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_buyer_activities | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_shipments | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_supplier_icf_values | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_team_requirement_scores | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_requirement_values | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_requirement_sections_int | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_auction_currency_rates | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_price_elements | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_award_allocations_history | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_po_lines_history | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_neg_team_members | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_line_icf_summary | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_neg_terms_acceptance | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_bid_headers | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_supplier_access | pon_auction_headers_all | AUCTION_HEADER_ID_ORIG_AMEND |
pon_supplier_access | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_auction_item_prices_all | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_supplier_activities | pon_auction_headers_all | AUCTION_HEADER_ID |
pon_supplier_activities | pon_auction_headers_all | AUCTION_HEADER_ID_ORIG_AMEND |
pon_team_bid_scores | pon_auction_headers_all | AUCTION_HEADER_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PON_AUC_HEADERS_ALL_N11 | Non Unique | Default | PO_STYLE_ID |
PON_AUC_HEADERS_ALL_N12 | Non Unique | Default | PRC_BU_ID, PERSON_ID |
PON_AUC_HEADERS_ALL_N13 | Non Unique | Default | PERSON_ID |
PON_AUC_HEADERS_ALL_N14 | Non Unique | Default | TRUNC("OPEN_BIDDING_DATE") |
PON_AUC_HEADERS_ALL_N15 | Non Unique | Default | TRUNC("PUBLISH_DATE") |
PON_AUC_HEADERS_ALL_N16 | Non Unique | Default | TRUNC("CLOSE_BIDDING_DATE") |
PON_AUC_HEADERS_ALL_N17 | Non Unique | Default | TRUNC("AWARD_COMPLETE_DATE") |
PON_AUC_HEADERS_ALL_N18 | Non Unique | Default | UPPER("DOCUMENT_NUMBER") |
PON_AUC_HEADERS_ALL_N19 | Non Unique | Default | AUCTION_STATUS |
PON_AUC_HEADERS_ALL_N2 | Non Unique | Default | AUCTION_HEADER_ID_ORIG_ROUND, AUCTION_ROUND_NUMBER |
PON_AUC_HEADERS_ALL_N20 | Non Unique | Default | CLOSE_DATE_PAUSE_ADJUSTED |
PON_AUC_HEADERS_ALL_N21 | Non Unique | Default | CONTRACT_ID |
PON_AUC_HEADERS_ALL_N22 | Non Unique | Default | AUCTION_HEADER_ID_PREV_ROUND, AUCTION_HEADER_ID |
PON_AUC_HEADERS_ALL_N5 | Non Unique | Default | AUCTION_HEADER_ID_ORIG_AMEND, AUCTION_HEADER_ID_PREV_AMEND |
PON_AUC_HEADERS_ALL_N9 | Non Unique | Default | UPPER("AUCTION_TITLE") |
PON_AUC_HEADERS_ALL_U1 | Unique | Default | AUCTION_HEADER_ID |
PON_AUC_HEADERS_ALL_U2 | Unique | Default | DOCUMENT_NUMBER, PRC_BU_ID |