Mediaocean AR import file specification

Accountability’s integration with Mediaocean automates the import of client media invoices

Overview

Accountability’s integration with Mediaocean automates the import of client media. This document describes the file import process and specification for Mediaocean’s media AR data.

SFTP details will be provided by Accountability to your Mediaocean representative. Accountability will check and retrieve files from your SFTP folder intra-day every 15 minutes, unless otherwise specified.

MEDIAOCEAN IGNITIA

Mediaocean's Ignitia product is available in pilot with some agencies. Ignitia files are generated daily. Due to the limited scope of the pilot, Ignitia files can are manually imported into Accountability through the Mediaocean Configuration page. Contact your Accountability representative for details.

File format and validation

Each file must adhere to a pre-defined file format in CSV (Comma Separated Value) or XLSX (MS Excel Open XML Spreadsheet).

File name guidelines:

Prepend AR to the file name and use the ISO date and 24-hour time format, e.g. AR12345_20221214_135135.csv

The import process will first validate that all required master data records exist in Accountability, then check that the file format is valid.

Error messages are sent to the Default Administrator email address entered on the Mediaocean Configuration page.

Data columns

The Mediaocean AR Import File needs to have the following columns. Each Column Header label needs to be exact for the file to pass validation.

Col	Spectra OX Column Header	Ignitia Column Header	Required?	Details \| Notes
A	Invoice Number	Invoice Number	Yes	Media Client Invoice Number
B	Client	Client	Yes	Client Code Needs to have a corresponding Accountability Client
C	Prod	Prod	Yes	Product Code Needs to have a corresponding Product within a valid Accountability Client
D	Est	Est	Yes	Estimate Number
E	Inv Date	Inv Date	Yes	Invoice Date in the format MM/DD/YY
F	MOS	MOS	Yes	Media Month of Service in the format MMM-YY
G	Due Date	Due Date	Optional	Invoice Due Date If left blank, the system will automatically calculate the Invoice Due Date based on the Client Payment Terms.
H	Media	Media	Yes	Media Type Name Needs to have a corresponding Media Type record in Accountability
I	Sta/Net/Pub	Sta/Net/Pub	Yes	Station, Network, or Pub assigned to the buyline Media Cost Control (aka Media WIP) reporting within Accountability requires this data on both the Media AR and Media AP files
J	Sys	Sys	Optional	Media System initial, e.g., P for Print and Digital
K	Invoice	Inv# No	Optional	Internal MO Invoice ID.
L	Bill Type	Bill Type	Optional	Indicates whether the invoice is an original or revised invoice
M	Rev	Rever	Conditional	For invoice reversals.
N	Loc	Location	Required	Media Offices Needs to be mapped to a valid Accountability Office
O	Client Name	Client Name	Conditional	Client Name Required if the option to automatically create new clients is enabled.
P	Product Name	Product Name	Conditional	Product Name Required if the option to automatically create new products is enabled.
Q	Estimate Name	Estimate Name	Optional	Estimate Name
R	Sta/Net/Pub Nam	Sta/Net/Pub Nam	Optional	Station, Network, or Pub name
S	Actual	Actual	Required	Total Invoice Amount
T	Commission	Commission	Optional	Commission Amount
U	Gross	Gross	Conditional	Gross Invoice Amount Required if the Commission is based on the Client Gross Amount
V	Net	Net	Conditional	Net Invoice Amount Required if the Commission is based on the Client Net Amount
W	Tax	Tax	Optional	Tax amount if applicable
X	PO #	Estimate Bill Ref 2	Optional	Agency User Defined Field at the Estimate level. This is mapped to the Client Order field on the Media Schedule header created in Accountability.
Y	Job #	Estimate Bill Ref 3	Optional	Agency User Defined Field at the Estimate level This is mapped to the Job No. field on the Media Schedule header created in Accountability. The Job # needs to be a valid Job No.