Marketplaces > Marketplaces T-Z > Zalando > ZFS Reports > Cross Border Movements Report (ZFS)

Cross Border Movements Report (ZFS)

Cross Border Movements Reports (CBM reports) are relevant if you use Zalando's international warehousing. They document cross-border movements of articles within the Zalando logistics network. Use it to find out when you need to make Intrastat declarations.

TIP:
The reports are named according to the following scheme:

[channel sign]_zfs_stock_cbm_report_ddmmyyyy_hhmmss_[merchant-id]_[file-id].csv

CSV Configuration

The separator, text qualifier, and character set correspond to your settings under "Admin > Export > List exports" in the section "CSV Settings".

These Columns are Included in the CSV File

TIP:
You can find an example for a Cross Border Movements Report here.

FIELD

DATA TYPE

DESCRIPTION

dispatch_date

DATE (yyyy-mm-dd)

Date when the shipment was dispatched from the source location.

product_sku

STRING (UUID)

The product's unique identifier (Zalando ID).

ean

INT(13)

The article's EAN.

arrival_date

DATE (yyyy-mm-dd)

Date when the shipment arrived at the target location.

destination_stock_location_location_id

STRING (UUID)

Unique identifier of the target stock location.

destination_stock_location_name

STRING

Name of the target stock location.

destination_stock_location_country_code

STRING

Country code of the target stock location.

source_stock_location_location_id

STRING (UUID)

Unique identifier of the source stock location.

source_stock_location_name

STRING

Name of the source stock location.

source_stock_location_country_code

STRING

Country code of the source stock location.

order_number

STRING

Order number causing the movement (if applicable).

movement_type

STRING

One of 4 Movement Types.
 

movement_id

STRING (UUID)

Unique identifier of the movement.

report_date

DATE (yyyy-mm-dd)

Report date of the movement

source_stock_location_inbound_active

BOOL

Shows whether the source stock location is active for inbound.

source_stock_location_outbound_active

BOOL

Shows whether the source stock location is active for outbound.

destination_stock_location_inbound_active

BOOL

Shows whether the target stock location is active for inbound.

destination_stock_location_outbound_active

BOOL

Shows whether the target stock location is active for outbound.

merchant_sku

STRING

Your article number.

Movement Types

Movement Type

Explanation

relocation_inbound

Movement between warehouses in different countries. This may be due to different reasons, including:

•Stock replenishment to optimize article availability

•Fulfillment of orders that require package consolidation in a single location before shipment

•Merchant requests to move items to a particular location for pickup

customer_return_inbound

An article returned by a customer that arrived at a warehouse in a different country than the facility from which the item was shipped to the customer. The source location of the movement is the country from which it was originally shipped to the customer.

reconciliation_inbound

An article that was unexpectedly received in a warehouse in a different country than its last known location in the network. This can happen due to operational errors, for example, missed scan on outbound from the previous location.

external_treatment_inbound

An article that underwent external treatment (for example, refurbishment) and arrived at a warehouse in a different country than the previous facility it was stored at.