In EDI (Electronic Data Interchange), the DTM (Date/Time Reference) segment is used to specify dates, times, or date/time periods relevant to the transaction.
Each DTM segment includes a qualifier
that indicates the type of date or time being referenced.
Here’s a list of some common DTM qualifiers
used in ANSI X12 and EDIFACT standards, along with their
descriptions:
Common DTM
Qualifiers (X12 Standard)
Qualifier |
Description |
002 |
Delivery Requested on This Date |
010 |
Requested Ship Date |
011 |
Shipped |
017 |
Estimated Delivery Date |
037 |
Ship Not Before Date |
038 |
Ship No Later Than Date |
050 |
Received |
063 |
Do Not Deliver Before |
064 |
Do Not Deliver After |
066 |
Requested Pickup Date |
067 |
Actual Pickup Date |
097 |
Transaction Creation Date |
150 |
Service Period Start |
151 |
Service Period End |
175 |
Appointment Date |
198 |
Cycle Start Date |
199 |
Cycle End Date |
200 |
Last Activity Date |
Common DTM
Qualifiers (EDIFACT Standard)
Qualifier |
Description |
2 |
Delivery Requested Date/Time |
7 |
Effective Date/Time |
10 |
Shipment Date/Time |
35 |
Delivery Date/Time, Latest |
36 |
Expiry Date/Time |
50 |
Goods Receipt Date/Time |
63 |
Do Not Deliver Before Date |
64 |
Do Not Deliver After Date |
203 |
Start Date/Time |
263 |
Arrival Date/Time |
281 |
Release Date/Time |
Key Points
- Structure of DTM Segment in X12:
DTM*Qualifier*Date*Time*Time
Code
- Example: DTM*002*20240115 (Requested Delivery Date: January 15, 2024)
- Structure of DTM Segment in EDIFACT:
DTM+Qualifier:Date:Format
- Example: DTM+2:20240115:102 (Delivery Requested Date: January 15, 2024 in CCYYMMDD format)
- Format Codes in EDIFACT:
- 102: CCYYMMDD (Year, Month,
Day)
- 203: CCYYMMDDHHMM (Year,
Month, Day, Hour, Minute)
Practical
Use in EDI Transactions:
- Purchase Orders (850 / ORDERS): Used
to specify requested ship/delivery dates.
- Invoices (810 / INVOIC): Used
for invoice creation or due dates.
- Advanced Shipping Notices (856 / DESADV): Includes shipment and estimated delivery dates.