Line Item Data Table

Field Name Description Data Type Size Sample Data Notes
LineNumber*

Numbering of line items within an order. Required if Sale is provided.

String 100 Identifies line items in this transaction. If unavailable in the client’s data feed, this can be defaulted to a sequence number.
ItemSKU*

Stock Keeping Unit – unique number to identify the product purchased. Required, if Sale is provided.

String “ABC123456” Unique identifier for the item being purchased. Must match exactly the SKU in the product data feed.
Quantity* Quantity of units sold. Required, if Sale is provided. Decimal “1”, “16.00” Should contain a negative value if this line item represents a return sale. The value should be positive if this is a purchase. Quantity and ExtendedAmount must both be positive or both be negative.
ExtendedAmount* Total amount spent on this item. Decimal “1”, “16.00”

Should contain a negative value if this line item represents a return sale. The value should be positive if this is a purchase. Quantity and ExtendedAmount must both be positive or both be negative. A positive Quantity and negative ExtendedAmount is treated as a discount.

ShipDateTime

The date and time stamp of when this item shipped.

Datetime

“2012-05-07T13:00:00” By changing pipeline configuration, the awarding process can be overridden to use ShipDateTime instead of ReceiptDateTime for award eligibility.

*Required