TB.One > Order Data and Order Processing > Order Processing via CSV > Files and Naming Conventions for Orders and Messages (CSV)

Files and Naming Conventions for Orders and Messages (CSV)

Schaubild_AuftragMeldung_EN

1. ORDER DATA

The names of order files you can retrieve from TB.One are structured in the following way:

 

TIP:
Naming convention: "ORDER_yyyymmdd_hhmmss_ID.csv"

 

CONVENTION

MEANING

ORDER_

Identifies the file as an order file

yyyymmdd_hhmmss_

Timestamp: YearMonthDay_HourMinuteSecond
Example:
3rd of January 2021, 03.30 PM - "20210103_153000_"

ID

Unique ID; created automatically

.csv

File extension

2. MESSAGES

Message files you send to TB.One (dispatch advices, return or cancellation messages) must be named in the following way:

 

TIP:
Naming convention: "DESADV_[POS/ORD]_yyyymmdd_hhmmss.csv"
Choose one of the two values for "[POS/ORD]" (explanation below). Do not include the square brackets or the slash in the file name!

 

CONVENTION

MEANING

DESADV_

Identifies the file as a message file

POS_ or ORD_

Shows whether the file relates to individual items (messages at item level) or to orders as a whole (messages at order level).

yyyymmdd_hhmmss_

Timestamp: YearMonthDay_HourMinuteSecond
Example:
3rd of January 2021, 03.30 PM - "20210103_153000_"

.csv

File extension


For further information, see also:

Order processing and messages via CSV - overview

Files and naming conventions for providing master data via CSV