Bid Information

Here is a description of the columns contained in the Bids Information extract, in the order contained in the extract file.
  • Bids Ended references the bids lookup file.
  • Each field is delimited by chr(127). (DEL)
Pos Column Column Type Description
1 item_id Integer, up to 18 digits long A unique ID for the item, the same as one from the item extract.
2 transaction_id Integer, up to 12 Digits Long A unique ID for this bid
3 bid_date A timestamp in the form, (FILLMEIN) The date and time of the bid
4 bidder_id Integer, up to 12 digits A unique ID for the user making the bid
5 bid_type_code Integer, up to 12 digits The type of bid performed
6 quantity_bid Integer, up to 12 digits The quantity of items bid on
7 bid_amount_total_usd A monetary value less than 10 trillion dollars Total bid amount
8 bid_amount_unit_usd A monetary value less than 10 trillion dollars Per unit bid amount, relevant for dutch auctions.
9 bid_success_flag Character, one of 'Y' or 'N' A flag indicating if the bid was successful
10 final_extended_price_usd A monetary value less than 10 trillion dollars Final price extended to bidder, could be lower than bid amount, such as in a Dutch auciton.
11 final_unit_price_usd A monetary value less than 10 trillion dollars Final unit price extended to the bidder
12 winning_quantity Integer, up to 9 digits The quantity of items won.
13 bidder_feedback_score Integer, up to 18 digits The feedback score given to the bidder
14 seller_feedback_score Integer, up to 18 digits The feedback score given to the seller