84.4.4.36 STANDARD > MEDIAOCEAN INVOICE TXT

Export Scope:

The Standard MediaOcean TXT Export is in charge to extract a text file with all the data regarding invoiced contracts.

- The selection of the invoices to export is taken from the given data range;
- Different types of record to export are in place;
- Data is strauctured as semi-column separated values;
- Not all the data are mandatory. Mandatory data only are eventually exported.
- Amounts are all exported with 2 decimals and without separator. The last 2 digits of the amount will be taken as decimals. For example, 84.00 will be exported as 8400.

export_txt_mediaocean

Export Path:

- define where to export the text file (mandatory field);

Issued Invoices:

- select a Date range from where to export the wanted invoices (mandatory field);

Agency:

- select the agency for which you want to export the invoiced contracts;

Parameters:

- Call letters: 4-characters alphanumeric text, used to identify the station. Allow to insert information manually into record 22 field 2 (CALL_LETTERS).

- Media Type: Possible choices: TV, R, LC, NC, N, X. Allow to insert information manually into record 22 field 3 (MEDIA_TYPE).

- Band: Possible choices: AM, FM, X, TV , SM, DV. Allow to insert information manually into record 22 field 4 (BAND).

- Client: Allow to insert information manually into record 31 field 25 (AGENCY_ADVERTISER_CODE).

- Product: Allow to insert information manually into record 31 field 27 (AGENCY_PRODUCT_CODE).

- Estimate: Allow to insert information manually into record 31 field 8 (AGENCY_ESTIMATE_CODE).

Export File and Fields

Each row is marked by a record type as:

21: Agency in the invoice header;
NB: From Etere version 33.2.146.6663, in this record is inserted also the address. In field 2 will be exported the data contained in anagraf.cod_fisc.

22: Station in the invoice header;

23: Payee in the invoice header;
NB: From Etere version 33.2.146.6663, the fields in this record are forced to these values:
Field 2: "Crossings TV"
Field 4: "901 H Street, Ste 120 PMB 81"
Field 5: "Sacramento, CA"
Field 6: "95814"

24: Upper Standard Comment, which is located above the program section;

25: Lower Standard Comment which is located below the program section;

31: Invoice receipt.
NB: From Etere version 33.2.146.6663, the name of the contract agent is exported too in field 2.

32: Upper Invoice Comment which is located above the program section;
NB: From Etere version 33.2.146.6663, this record is exported after the record 31 with data written in contrattitestata_note.

41: Scheduled Line. One for each schedule line within an invoice;
NB: From Etere version 33.2.133.6650, this record contains the data written in id_contrattirighe.

51: Transmission details. One for each effective point;
NB: From Etere version 33.2.133.6650, the follwoing fields of this record are filled with these information:
Field 7: cod_progra
Field 18: traffic_block

52: Reconciliation Comment. If necessary for each transmission detail;

42: Program Comment which is associated with a single program line.

33: Lower Invoice Comment which is located below the program section. Will be printed before any lower standard comment;

34: Total Invoice. One for each invoice;

12: Total Transmission. At the end of each transmission.

The sequence of lines has its own value.

The lines must be ordered by: Agency , Station , Payee, invoices

(12) Total transmission MANDATORY

(21) Agency MANDATORY

(22) Station MANDATORY

(23) Payee MANDATORY

(24) Standard comment (top) NOT MANDATORY

(25) Standard comment (below) NOT MANDATORY

(31) Invoice header MANDATORY

(32) Invoice comment (top) NOT MANDATORY

(33) Invoice comment (bottom) NOT MANDATORY

(34) Total invoice MANDATORY

(41) Programmed line NOT MANDATORY

(42) Comment program NOT MANDATORY

(51) transmission detail MANDATORY

(52) Reconciliatory comment NOT MANDATORY

export_txt_mediaocean_example

For more information about the records and the fields managed by this export, check the following web page:
https://support-na.mediaocean.com/hc/en-us/articles/1500012350821-Electronic-Invoices-Technical-Specs