[Home] [Help] [Dependency Information]
Object Name: | PON_BID_HEADERS_ARCH |
---|---|
Object Type: | TABLE |
Owner: | PON |
FND Design Data: | PON.PON_BID_HEADERS_ARCH |
Subobject Name: | |
Status: | VALID |
no longer used.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PON_BID_HEADERS_ARCH_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
AUCTION_HEADER_ID
BID_NUMBER BID_REVISION_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LATEST_EXTERNAL_FLAG | VARCHAR2 | (1) | Yes | Y or N flag to indicate if this is the latest archived row |
AUCTION_HEADER_ID | NUMBER | Yes | Auction Header Identifier | |
BID_NUMBER | NUMBER | Yes | Bid Number | |
BID_REVISION_NUMBER | NUMBER | Yes | Bid revision number | |
BIDDERS_BID_NUMBER | VARCHAR2 | (25) | Bidder provided bid number | |
BID_TYPE | VARCHAR2 | (25) | Bid type | |
CONTRACT_TYPE | VARCHAR2 | (25) | Contract type either Sport Buy or Long Term agreement | |
TRADING_PARTNER_CONTACT_NAME | VARCHAR2 | (255) | Name of contact person for bidder trading partner | |
TRADING_PARTNER_CONTACT_ID | NUMBER | Identifier for contact person of bidder trading partner | ||
TRADING_PARTNER_NAME | VARCHAR2 | (255) | Name of bidder trading partner | |
TRADING_PARTNER_ID | NUMBER | Identifier for bidder trading partner | ||
BID_STATUS | VARCHAR2 | (25) | Bid status | |
BID_EFFECTIVE_DATE | DATE | Bid effective date | ||
BID_EXPIRATION_DATE | DATE | Number of days from the Auction Close date on which bid expires | ||
PUBLISH_DATE | DATE | Date on which bid is published | ||
CANCELLED_DATE | DATE | Date on which bid is cancelled | ||
PAYMENT_TERMS_ID | NUMBER | Unique Identifier for payment terms | ||
FREIGHT_TERMS_CODE | VARCHAR2 | (25) | Freight terms code | |
CARRIER_CODE | VARCHAR2 | (25) | Carrier code | |
FOB_CODE | VARCHAR2 | (25) | Free on board code | |
NOTE_TO_AUCTION_OWNER | VARCHAR2 | (4000) | Note to auction owner | |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
AUCTION_CREATION_DATE | DATE | Date of auction creation | ||
ATTACHMENTS_FLAG | VARCHAR2 | (1) | Y or N flag to indicate attachments | |
DISQUALIFY_REASON | VARCHAR2 | (240) | Disqualify reason given by auctioneer if auctioneer disqualifies bid | |
PAYMENT_TERMS | VARCHAR2 | (80) | No longer used | |
FREIGHT_TERMS | VARCHAR2 | (80) | No longer used | |
CARRIER | VARCHAR2 | (80) | No longer used | |
FOB | VARCHAR2 | (80) | No longer used | |
BID_STATUS_NAME | VARCHAR2 | (80) | No longer used | |
LANGUAGE_CODE | VARCHAR2 | (4) | No longer used | |
AWARD_STATUS | VARCHAR2 | (25) | Award status | |
AWARD_STATUS_NAME | VARCHAR2 | (80) | No longer used | |
PAYMENT_TERMS_CODE | VARCHAR2 | (80) | Payment terms code | |
PHONE | VARCHAR2 | (100) | Phone number | |
FAX | VARCHAR2 | (100) | Fax number | |
VARCHAR2 | (100) | Email address | ||
BID_CURRENCY_CODE | VARCHAR2 | (15) | Currency code of bid | |
RATE | NUMBER | Currency conversion rate | ||
RATE_TYPE | VARCHAR2 | (25) | Currency conversion rate type | |
RATE_DATE | DATE | Date of currency conversion rate | ||
MIN_BID_CHANGE | NUMBER | Minimum bid change if proxy bidding is allowed | ||
ORDER_NUMBER | VARCHAR2 | (20) | Purchase order number | |
PO_TXN_FLAG | VARCHAR2 | (1) | Y or N flag to indicate whether purchase order transaction was requested by the auctioneer during the auction completion | |
DOCUMENT_TRACKING_ID | NUMBER | Identifier for purchase order document tracking | ||
PROXY_BID_FLAG | VARCHAR2 | (1) | Y or N flag to indicate that proxy bid is allowed | |
NUMBER_PRICE_DECIMALS | NUMBER | Precision in bid price | ||
PO_AGREED_AMOUNT | NUMBER | Purchase order agreed amount | ||
ORIGINAL_BID_NUMBER | NUMBER | Original Bid number for this round before revisions | ||
ORIGINAL_REVISION_NUMBER | NUMBER | Original revision number for this round | ||
BID_NUMBER_ORIGINAL_ROUND | NUMBER | Bid Number for this Bidder 's original round | ||
BID_NUMBER_PREV_ROUND | NUMBER | Bid Number for this Bidder 's previous round | ||
DOCTYPE_ID | NUMBER | Identifier for document type | ||
CANCEL_REASON | VARCHAR2 | (240) | Reason for cancelling bid | |
MODE_OF_TRANSPORT_CODE | VARCHAR2 | (25) | Code for mode of transport | |
VENDOR_ID | NUMBER | Vendor id of the bidder | ||
VENDOR_SITE_ID | NUMBER | Vendor Site id used to create the PO | ||
UPDATE_SOURCING_RULES | VARCHAR2 | (1) | 'Y' if existing sourcing rule should be updated | |
AGENT_ID | NUMBER | Buyer used to create the PO | ||
CREATE_SOURCING_RULES | VARCHAR2 | (1) | 'Y' if sourcing rules should be created | |
RELEASE_METHOD | VARCHAR2 | (25) | Release Method for sourcing rule | |
PO_HEADER_ID | NUMBER | unique identifier for the PO that was created for this bid | ||
PO_ERROR_CODE | NUMBER | stores any error which occurs during PO genreation | ||
PO_WF_CREATION_RND | NUMBER | Workflow round number in which the PO is created | ||
RATE_DSP | NUMBER | Display value of rate shown to bidders. |
Cut, paste (and edit) the following text to query this object:
SELECT LATEST_EXTERNAL_FLAG
, AUCTION_HEADER_ID
, BID_NUMBER
, BID_REVISION_NUMBER
, BIDDERS_BID_NUMBER
, BID_TYPE
, CONTRACT_TYPE
, TRADING_PARTNER_CONTACT_NAME
, TRADING_PARTNER_CONTACT_ID
, TRADING_PARTNER_NAME
, TRADING_PARTNER_ID
, BID_STATUS
, BID_EFFECTIVE_DATE
, BID_EXPIRATION_DATE
, PUBLISH_DATE
, CANCELLED_DATE
, PAYMENT_TERMS_ID
, FREIGHT_TERMS_CODE
, CARRIER_CODE
, FOB_CODE
, NOTE_TO_AUCTION_OWNER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, AUCTION_CREATION_DATE
, ATTACHMENTS_FLAG
, DISQUALIFY_REASON
, PAYMENT_TERMS
, FREIGHT_TERMS
, CARRIER
, FOB
, BID_STATUS_NAME
, LANGUAGE_CODE
, AWARD_STATUS
, AWARD_STATUS_NAME
, PAYMENT_TERMS_CODE
, PHONE
, FAX
, EMAIL
, BID_CURRENCY_CODE
, RATE
, RATE_TYPE
, RATE_DATE
, MIN_BID_CHANGE
, ORDER_NUMBER
, PO_TXN_FLAG
, DOCUMENT_TRACKING_ID
, PROXY_BID_FLAG
, NUMBER_PRICE_DECIMALS
, PO_AGREED_AMOUNT
, ORIGINAL_BID_NUMBER
, ORIGINAL_REVISION_NUMBER
, BID_NUMBER_ORIGINAL_ROUND
, BID_NUMBER_PREV_ROUND
, DOCTYPE_ID
, CANCEL_REASON
, MODE_OF_TRANSPORT_CODE
, VENDOR_ID
, VENDOR_SITE_ID
, UPDATE_SOURCING_RULES
, AGENT_ID
, CREATE_SOURCING_RULES
, RELEASE_METHOD
, PO_HEADER_ID
, PO_ERROR_CODE
, PO_WF_CREATION_RND
, RATE_DSP
FROM PON.PON_BID_HEADERS_ARCH;
PON.PON_BID_HEADERS_ARCH does not reference any database object
PON.PON_BID_HEADERS_ARCH is referenced by following:
|
|
|