Tuesday, 31 December 2024

Different Qualifiers in Date/Time/Period (DTM) Segment

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

  1. Structure of DTM Segment in X12:

DTM*Qualifier*Date*Time*Time Code

    • Example: DTM*002*20240115 (Requested Delivery Date: January 15, 2024)
  1. Structure of DTM Segment in EDIFACT:

DTM+Qualifier:Date:Format

    • Example: DTM+2:20240115:102 (Delivery Requested Date: January 15, 2024 in CCYYMMDD format)
  1. 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.

No comments:

Post a Comment

Comparison Between EDI and API

Comparison between  EDI (Electronic Data Interchange) and API (Application Programming Interface) in the context of B2B data exchange: ...