| Here is a description of the columns contained in the Bids Information extract, in the order contained in the extract file. |
Pos |
Column |
Column Type |
Description |
1 |
Item_id | DECIMAL 18,0 | The unique ebay item id for the transaction (the same as those in the items extract (efficacy or value guide), if that has been purchased) |
2 |
transaction_id | DECIMAL 12,0 | A unique ID for this bid (integer) |
3 |
bid_date | TIMESTAMP | The date and time of the bid ("DD-MON-YY HH24:MI:SS" ) |
4 |
bdr_id | DECIMAL 12,0 | A unique ID for the user making the bid |
5 |
bid_type_code | DECIMAL 9,0 | The type of the bid. See lookup file : Bid Type Codes |
6 |
qty_bid | DECIMAL 9,0 | The quantity of items bid on |
7 |
bid_amt_total_usd | DECIMAL 15,2 | Total bid amount (in USD) |
8 |
bid_amt_unit_usd | DECIMAL 12,0 | Per unit bid amount (relevant for dutch auctions) (in USD) |
9 |
bid_success_yn | CHAR 1 | (Y/N) A flag indicating if the bid was successful |
10 |
final_extd_price_usd | DECIMAL 15,2 | Final price extended to bidder (could be lower than bid amount) (in USD) |
11 |
final_unit_price_usd | DECIMAL 15,2 | Final unit price extended to the bidder (in USD) |
12 |
winning_qty | DECIMAL 9,0 | The quantity of items won |
13 |
bdr_feedback_score | DECIMAL 18,0 | The bidder's feedback score |
14 |
slr_feedback_score | DECIMAL 18,0 | The seller's feedback score |
| Example Row: |
|