ERP Vendor Billing Table

Advantage Software - Vendor Billing Report Template
File name format	Advantage_VendorBilling_AllCampaigns_YYYYMMDD_2400_Timezone.csv (or zip) Advantage_VendorBilling_<CampaignID>_YYYYMMDD_2400_Timezone.csv (or zip) Advantage_VendorBilling_SelectedCampaigns_YYYYMMDD_2400_Timezone.csv (or zip) Example of zip file includes VendorBilling_Selected Campaigns and ERP_ClientOrders_Selected campaigns directory. INTERNET_Advantage_VendorBilling_PreAllCampaigns_20190222_1029_CST.csv INTERNET_Advantage_VendorBilling_PostAllCampaigns_20190222_1029_CST.csv
Field Columns
VN_CODE*	A	External vendor code (Maximum characters: 6) Select Advantage ID on the directory vendor page Select Advantage ad serving ID under the Setup Advantage Account page
VN_NAME	B	Title or name of the vendor payee (Maximum characters: 30) or service provider Ad serving: Vendor name
INV_NUMBER*	C	Unique number by vendor invoice (Maximum characters: 20)
INV_DESC	D	Invoice summary/description (Maximum characters: 30)
INV_DATE*	E	Vendor invoice date
INV_TOTAL_NET*	F	Vendor invoice net value (net spend)
INV_TOTAL_TAX	G	Invoice tax value payable to the vendor
OFFICE_CODE	H	Accounts payable header office
CLIENT*	I	Client (entity or organization responsible for payment ) code or campaign ID (Maximum characters: 6) Select Advantage ID in client details page
CLIENT_NAME	J	Client name or title (Maximum characters: 30)
DIVISION*	K	Division ID code (Maximum characters: 6) Select ID in Basis campaign details
DIVISION_NAME	L	Division name or title (Maximum characters: 30)
PRODUCT*	M	Product ID code (Maximum characters: 6) Select ID in campaign details
PRODUCT_NAME	N	Product name/title (Maximum characters: 30)
MEDIA_TYPE*	O	Format/media type For example, I = Internet
ORDER_ID	P	Unique campaign order number generated based on campaign and vendor (Invoice number) The Order ID matches with the reports for a buyer organization. For client orders with ad serving, the order ID represents a single line per flight
ORDER_NUMBER*	Q	ERP campaign order line number
MONTH*	R	Billing period (MM) of the campaign
YEAR*	S	Billing period (YYYY) of the campaign
SALES_CLASS*	T	Campaign order sales class ID code for billing (Maximum characters: 6) Select ID in campaign details Confirm sales class at media plan approval
ORDER_LINE_ID	U	Unique campaign order number generated based on campaign and vendor (Invoice number) The Order ID matches with the reports for a buyer organization. For client orders with ad serving, the order ID represents a single line per flight
ORDER_LINE_NBR*	V	ERP campaign order line number Ad serving is displayed as a line per flight corresponding with the order ID.
LINE_DATE*	W	Campaign order start date
MEDIA_QTY	X	Billable number of units, such as impressions, for the month/year
MEDIA_NET*	Y	Billable net campaign value for the month/year If your DSP line item has a tactic add-on applied, it is excluded from this value.
MEDIA_VN_TAX	Z	Net vendor tax value
MEDIA_NET_CHARGE	AA	Net campaign charge
MEDIA_MARKUP_PCT	AB	Net campaign markup percentage
MEDIA_ADD_AMT	AC	Additional campaign value
DAYPART_CODE	AD	Standard broadcast daypart code for R and T media types (Maximum characters: 6)
LENGTH	AE	Length (height) R and T media types
PO_NBR	AF	Production purchase order number
PO_LINE	AG	Production purchase order line item number
JOB_NBR	AH	Job number linking to the order ID/Name
COMP_NBR	AI	Job component number
FNC_CODE	AJ	Function code (vendor)
JOB_QTY	AK	Job quantity
JOB_NET	AL	Job net value
JOB_VN_TAX	AM	Job vendor tax value
JOB_COMMENT	AN	Accounts payable line comment for the job (Maximum characters; 255)
GL_ACCOUNT	AO	General ledger account
GL_NET	AP	General ledger net value
GL_COMMENT	AQ	General ledger comment (Maximum characters: 255)
SOURCE_CODE	AR	Campaigns with media system layout, such as N1 = Tribune (Maximum characters: 2)

File name format

Advantage_VendorBilling_AllCampaigns_YYYYMMDD_2400_Timezone.csv (or zip)

Advantage_VendorBilling_<CampaignID>_YYYYMMDD_2400_Timezone.csv (or zip)

Advantage_VendorBilling_SelectedCampaigns_YYYYMMDD_2400_Timezone.csv (or zip)

Example of zip file includes VendorBilling_Selected Campaigns and ERP_ClientOrders_Selected campaigns directory.

INTERNET_Advantage_VendorBilling_PreAllCampaigns_20190222_1029_CST.csv

INTERNET_Advantage_VendorBilling_PostAllCampaigns_20190222_1029_CST.csv

Field Columns

VN_CODE*

A

External vendor code (Maximum characters: 6)

Select Advantage ID on the directory vendor page

Select Advantage ad serving ID under the Setup Advantage Account page

VN_NAME

B

Title or name of the vendor payee (Maximum characters: 30) or service provider

Ad serving: Vendor name

INV_NUMBER*

C

Unique number by vendor invoice (Maximum characters: 20)

INV_DESC

D

Invoice summary/description (Maximum characters: 30)

INV_DATE*

E

Vendor invoice date

INV_TOTAL_NET*

F

Vendor invoice net value (net spend)

INV_TOTAL_TAX

G

Invoice tax value payable to the vendor

OFFICE_CODE

H

Accounts payable header office

CLIENT*

I

Client (entity or organization responsible for payment ) code or campaign ID (Maximum characters: 6)

Select Advantage ID in client details page

CLIENT_NAME

J

Client name or title (Maximum characters: 30)

DIVISION*

K

Division ID code (Maximum characters: 6)

Select ID in Basis campaign details

DIVISION_NAME

L

Division name or title (Maximum characters: 30)

PRODUCT*

M

Product ID code (Maximum characters: 6)

Select ID in campaign details

PRODUCT_NAME

N

Product name/title (Maximum characters: 30)

MEDIA_TYPE*

O

Format/media type

For example, I = Internet

ORDER_ID

P

Unique campaign order number generated based on campaign and vendor (Invoice number)

The Order ID matches with the reports for a buyer organization.

For client orders with ad serving, the order ID represents a single line per flight

ORDER_NUMBER*

Q

ERP campaign order line number

MONTH*

R

Billing period (MM) of the campaign

YEAR*

S

Billing period (YYYY) of the campaign

SALES_CLASS*

T

Campaign order sales class ID code for billing (Maximum characters: 6)

Select ID in campaign details

Confirm sales class at media plan approval

ORDER_LINE_ID

U

Unique campaign order number generated based on campaign and vendor (Invoice number)

The Order ID matches with the reports for a buyer organization.

For client orders with ad serving, the order ID represents a single line per flight

ORDER_LINE_NBR*

V

ERP campaign order line number

Ad serving is displayed as a line per flight corresponding with the order ID.

LINE_DATE*

W

Campaign order start date

MEDIA_QTY

X

Billable number of units, such as impressions, for the month/year

MEDIA_NET*

Y

Billable net campaign value for the month/year

If your DSP line item has a tactic add-on applied, it is excluded from this value.

MEDIA_VN_TAX

Z

Net vendor tax value

MEDIA_NET_CHARGE

AA

Net campaign charge

MEDIA_MARKUP_PCT

AB

Net campaign markup percentage

MEDIA_ADD_AMT

AC

Additional campaign value

DAYPART_CODE

AD

Standard broadcast daypart code for R and T media types (Maximum characters: 6)

LENGTH

AE

Length (height) R and T media types

PO_NBR

AF

Production purchase order number

PO_LINE

AG

Production purchase order line item number

JOB_NBR

AH

Job number linking to the order ID/Name

COMP_NBR

AI

Job component number

FNC_CODE

AJ

Function code (vendor)

JOB_QTY

AK

Job quantity

JOB_NET

AL

Job net value

JOB_VN_TAX

AM

Job vendor tax value

JOB_COMMENT

AN

Accounts payable line comment for the job (Maximum characters; 255)

GL_ACCOUNT

AO

General ledger account

GL_NET

AP

General ledger net value

GL_COMMENT

AQ

General ledger comment (Maximum characters: 255)

SOURCE_CODE

AR

Campaigns with media system layout, such as N1 = Tribune (Maximum characters: 2)

Advantage Software - Vendor Billing Report Template
Name	Column	Description
File name format		Advantage_VendorBilling_AllCampaigns_YYYYMMDD_2400_Timezone.csv (or zip) Advantage_VendorBilling_<CampaignID>_YYYYMMDD_2400_Timezone.csv (or zip) Advantage_VendorBilling_SelectedCampaigns_YYYYMMDD_2400_Timezone.csv (or zip) Example of zip file includes VendorBilling_Selected Campaigns and ERP_ClientOrders_Selected campaigns directory. INTERNET_Advantage_VendorBilling_PreAllCampaigns_20190222_1029_CST.csv INTERNET_Advantage_VendorBilling_PostAllCampaigns_20190222_1029_CST.csv
Field Columns
VN_CODE*	A	External vendor code (Maximum characters: 6) Select Advantage ID on the directory vendor page Select Advantage ad serving ID under the Setup Advantage Account page
VN_NAME	B	Title or name of the vendor payee (Maximum characters: 30) or service provider Ad serving: Vendor name
INV_NUMBER*	C	Unique number by vendor invoice (Maximum characters: 20)
INV_DESC	D	Invoice summary/description (Maximum characters: 30)
INV_DATE*	E	Vendor invoice date
INV_TOTAL_NET*	F	Vendor invoice net value (net spend)
INV_TOTAL_TAX	G	Invoice tax value payable to the vendor
OFFICE_CODE	H	Accounts payable header office
CLIENT*	I	Client (entity or organization responsible for payment ) code or campaign ID (Maximum characters: 6) Select Advantage ID in client details page
CLIENT_NAME	J	Client name or title (Maximum characters: 30)
DIVISION*	K	Division ID code (Maximum characters: 6) Select ID in Basis campaign details
DIVISION_NAME	L	Division name or title (Maximum characters: 30)
PRODUCT*	M	Product ID code (Maximum characters: 6) Select ID in campaign details
PRODUCT_NAME	N	Product name/title (Maximum characters: 30)
MEDIA_TYPE*	O	Format/media type For example, I = Internet
ORDER_ID	P	Unique campaign order number generated based on campaign and vendor (Invoice number) The Order ID matches with the reports for a buyer organization. For client orders with ad serving, the order ID represents a single line per flight
ORDER_NUMBER*	Q	ERP campaign order line number
MONTH*	R	Billing period (MM) of the campaign
YEAR*	S	Billing period (YYYY) of the campaign
SALES_CLASS*	T	Campaign order sales class ID code for billing (Maximum characters: 6) Select ID in campaign details Confirm sales class at media plan approval
ORDER_LINE_ID	U	Unique campaign order number generated based on campaign and vendor (Invoice number) The Order ID matches with the reports for a buyer organization. For client orders with ad serving, the order ID represents a single line per flight
ORDER_LINE_NBR*	V	ERP campaign order line number Ad serving is displayed as a line per flight corresponding with the order ID.
LINE_DATE*	W	Campaign order start date
MEDIA_QTY	X	Billable number of units, such as impressions, for the month/year
MEDIA_NET*	Y	Billable net campaign value for the month/year If your DSP line item has a tactic add-on applied, it is excluded from this value.
MEDIA_VN_TAX	Z	Net vendor tax value
MEDIA_NET_CHARGE	AA	Net campaign charge
MEDIA_MARKUP_PCT	AB	Net campaign markup percentage
MEDIA_ADD_AMT	AC	Additional campaign value
DAYPART_CODE	AD	Standard broadcast daypart code for R and T media types (Maximum characters: 6)
LENGTH	AE	Length (height) R and T media types
PO_NBR	AF	Production purchase order number
PO_LINE	AG	Production purchase order line item number
JOB_NBR	AH	Job number linking to the order ID/Name
COMP_NBR	AI	Job component number
FNC_CODE	AJ	Function code (vendor)
JOB_QTY	AK	Job quantity
JOB_NET	AL	Job net value
JOB_VN_TAX	AM	Job vendor tax value
JOB_COMMENT	AN	Accounts payable line comment for the job (Maximum characters; 255)
GL_ACCOUNT	AO	General ledger account
GL_NET	AP	General ledger net value
GL_COMMENT	AQ	General ledger comment (Maximum characters: 255)
SOURCE_CODE	AR	Campaigns with media system layout, such as N1 = Tribune (Maximum characters: 2)