| 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 |