EDI (Technical Details)

As of the time of this writing, we currently support the following fields:

INVOICE HEADER RECORD (Record Code 31)

• Sales Person Name -> SALESPERSON (optional)
• Customer Name -> ADVERTISER NAME (required)
• Product -> PRODUCT NAME (required)
• Invoice End Date -> INVOICE DATE (required)
• Est/Adv/Prod Code (special) -> When an agency with an EDI number is attached to a contract, three fields are provided for AGENCY ESTIMATE NUMBER, AGENCY ADVERTISER CODE and AGENCY PRODUCT CODE (optional); in most cases, all three fields are required. Check with your clearing house provider for further details.
• Invoice Number -> INVOICE NUMBER (required)
• Invoice End Date YY and MM -> BROADCAST MONTH (required)
• Order Tax Percent -> SALES TAX PERCENT (optional)
• Purchase Order Number (special) -> In TrafficXP -> STATION ORDER NUMBER (optional); In Essentials/Premier -> REP ORDER NUMBER and STATION ORDER NUMBER (optional). Note that this can be two different numbers combined into the purchase order field by separating the two numbers with the pipe (|) symbol. If using the pipe symbol, the first number is the rep order number and the second number is the station order number; otherwise, without the pipe symbol, the number entered will be used for both rep order number and station order number.
• Invoice Start Date -> INVOICE PERIOD START DATE (optional) formatted as YYMMDD. (Currently available in Premier 2014.)
• Invoice End Date -> INVOICE PERIOD END DATE (optional) formatted as YYMMDD. (Currently available in Premier 2014.)

SCHEDULE LINE RECORD (Record Code 41)

• Order Item Line Number -> LINE NUMBER (optional)
• Order Item Days Of Week formatted as MTWTFSS -> DAYS OF WEEK (optional)
• Order Item Start Time formatted as HHMM -> START TIME (optional)
• Order Item End Time formatted as HHMM -> END TIME (optional)
• Order Item Rate -> RATE PER SPOT (optional)
• Invoice Spot Count -> NUMBER OF SPOTS SCHEDULED FOR THIS INVOICE (optional)
• Order Item Start Date formatted as YYMMDD -> LINE START DATE (optional)
• Order Item End Date formatted as YYMMDD -> LINE END DATE (optional)
• Order Item Comment -> PACKAGE CODE (optional)

BROADCAST DETAIL (Record Code 51)

• "Y" = RUN CODE (required)
• Spot Aired Date formatted AS YYMMDD = RUN DATE (required)
• Spot Aired Day of Week = DAY OF WEEK (required)
• Spot Aired Time formatted as HHMM = TIME OF DAY (required)
• Spot Length = TYPE (SPOT LENGTH) (required)
• Copy Ad-ID (Essentials/Premier) or Tape Code (TrafficXP) = COPY ID (required)
• Invoice Item Amount = RATE (required)

INVOICE TOTAL (Record Code 34)

• Actual Gross Billing -> ACTUAL GROSS BILLING (required)
• Agency Commission -> AGENCY COMMISSION (required)
• Net -> NET DUE (required)
• Tax -> STATE TAX (optional)
• Number Of Spots -> NUMBER OF SPOTS (optional)

If Ad-ID (Essentials/Premier) or Tape Code (TrafficXP) is missing (not provided), "NOT AVAILABLE" will be used.

Samples

4A's (.edi renamed .txt)
4As exported from RT (and then zipped).

Specifications

Donovan Data Systems, Inc. 4A May 2009
Harris SpotData 4A Oct 2008

Additional Information

See EDI.