Sales & Returns Report (ZFS)

TIP:
Sales & Returns Reports are named according to the following scheme:

The file contains all orders/returns crated in TB.One since the last report. The file is created even if there is no new data to display. In that case, the file contains only the column headers.

UTF-8

Semicolon (;)

Quote (")

MESSAGE_DATE

DATE(yyyy-mm-dd)

The date of the event referenced in this message (e.g. the shipping date or the return date)

DATE_CREATED

DATE

Shows when TB.One received the message

CHANNEL_SIGN

CHAR(12)

The channel sign

CHANNEL_ORDER_ID

CHAR(50)

The channel's unique order number

CHANNEL_ORDER_SHIPMENT_ID

CHAR(30)

The channel's shipment ID

CHANNEL_ORDER_ITEM_ID

CHAR(50)

The channel's item number

CHANNEL_MESSAGE_ID

CHAR(50)

Unique ID of the channel message that created this order item. If it cannot be identified, this field is empty

TB_MESSAGE_ID

INT(20)

Unique ID of the message that created this item

TB_ORDER_ITEM_ID

INT

Unique number of an item within an order, assigned by TB.One

TB_ORDER_ID

INT

Unique order number, assigned by TB.One

TYPE

CHAR(20)

Message type (ORDER_ACKNOWLEDGE, SHIP, NO_INVENTORY, CUST_CANCEL, RETURN, DEDUCT_SHIPPING_COSTS, DEDUCT_SERVICE_PRICE, DEDUCT_PAYMENT_COSTS, DELIVERED, PAYMENT_STATE_OPEN, PAYMENT_STATE_PAID, PAYMENT_STATE_SHORTFALL)

QUANTITY

INT

Shipped/returned quantity (depending on TYPE)

P_NR

CHAR(50)

Product number of the article's parent product

A_NR

CHAR(50)

Article Number

A_NR2

CHAR(50)

Article number 2

A_PROD_NR

CHAR(50)

Manufacturer's article number

A_EAN

EAN13

EAN

POS_ANR_CHANNEL

CHAR(50)

Channel article number (if available)

BILLING_TEXT

CHAR(255)

Invoice text of the order item as provided by the channel

ITEM_PRICE

FLOAT

Gross article price (retail price)

TRANSFER_PRICE

FLOAT

Net article price per piece (quantity 1) after deduction of the channel's commission (if applicable), if no value is provided, the calculation is done in TB.One

POS_CONDITION

CHAR(50)

Condition of the article (if provided by the channel);

For returns: shows whether the article is still sellable, dirty, etc.; mainly used by Amazon FBA

SERVICES

CHAR(100)

Item-related SERVICES.

Note: NOT order-related services! Those are listed in the order-related fields

CARRIER_PARCEL_TYPE

CHAR(50)

Information about the shipment

CARRIER_TYPE

CHAR(300)

Carrier/delivery agency or shipping type

IDCODE

CHAR(50)

Tracking code

EST_SHIP_DATE

DATE

Estimated delivery date; only provided in order acknowledgments (otherwise empty)

MESSAGE_COMMENT

TEXT

Item-related comment

CUSTOMER_COMMENT

TEXT

Customer comment; order-level comments are repeated for each item

ORDER_DATE

DATE(yyyy-mm-dd)

The channel's order date; if the channel does not provide a date, the order's creation date from TB.One is used

INVOICE_NUMBER

CHAR(25)

The invoice number; if no invoice number is provided, the field remains empty

TIP:
Need to know where each article is located at any time?

You can include Intra Community Trade (ICT) information in your Sales & Returns Reports. The respective fields will be enabled for you on request.

In some countries it is mandatory to provide this information to comply with tax regulations.