Broadcast Order Data

Address 1

Address 2

Address 3

Address City

Address Country

Address Postal Code

Address State

Adjustment Number

Amount Billed

Applied Invoices

Approved Date

Billed Difference

Campaign Name

Class ID

Class Name

Client ID

Client Name

Closed

Commission

Company ID

Company Name

Date Created

Department

Downloaded

Flight End Date

Flight Interval

Flight Start Date

Gross Amount

Item ID

Item Name

Line Closed

Line Comments

Line Number

Market ID

Market Name

Media Estimate Full Name

Media Estimate ID

Media Estimate Name

Net Amount

Number Spots

Office ID

Office Name

Open Amount

Order Date

Order End Date

Order Number

Order Start Date

Ordered By

Program

Project Full Name

Project Name

Project Number

Revision Number

Special Instructions

Spot Days

Spot Length

Spot Rate

Spot Time

Station Full Name

Station ID

Station Name

Status

Task Full Name

Task ID
Task Name

Traffic Instructions

User Defined Date 1

User Defined Date 2

User Defined Date 3

User Defined Date 4

User Defined Date 5 

User Defined Date 6

Vendor Contact

Vendor Full Name

Vendor ID

Vendor Name

 

Credit Card Charge Application Data

AP Account Full Name

AP Account Name

AP Account Number

Applied Amount

Approval Comments

Approver Name

Billable

Billable Cost

Billing Invoice Number

Campaign ID

Campaign Name

Charge Amount

Charge Amount Paid

Charge Date

Charge Reference

Charge Reference Number

Charge Status

Class ID

Class Name

Client Division

Client Division ID

Client Product

Client Product ID

CurrencyID

Date Credit Card Used

Date Paid By Client

Date Received

Detail Line Number

Discount Date
Downloaded

Due Date

Expense Account 

Expense Account Name

Full Project Name

GL_Company

Markup

Open Amount

PCurrencyID

PO Applied Cost

PO Line Number

PO Total Cost

Posted 

Posting Date

Project Name

Project Number

Purchased By Name

Purchased From

PurchaseOrder Number

Quantity

Short Description

Task ID 

Task Name

Total Cost

Unapplied Amount

Unit Cost

Unit Description

Vendor Due Date

Vendor Full Name

Vendor ID

Vendor Invoice Date

Vendor Invoice Number

Vendor Invoice Posted

Vendor Invoice Total 

Vendor Name

Voucher Description

Write Off

Credit Card Connector Detail Data

Amount 

Approval Status

Approved By Name

Billable 

Charged By

Class Full Name

Class ID

Class Name

Client Division

Client Division ID

Client Product

Client Product ID

Company 

Department Name

Expense Account Name

FITID

GL Account Name

GL Account Name Full

GL Account Number

Invoice Number

Item Full Name

Item ID

Item Name

Memo

Office Full Name

Office ID

Office Name

Original Memo

Overhead

Payee Name

Processed Status

Project Full Name

Project Name

Project Number

Receipt

Sales Tax Full Name

Sales Tax ID

Sales Tax Name 

Sales Tax2 Full Name

Sales Tax2 ID

Sales Tax2 Name

Task Full Name

Task ID

Task Name

Transaction Cleared

Transaction Date

Transaction Type

Transfer Out

Vendor Full Name

Vendor ID

Vendor Name

Expense Envelope Detail Data

Actual Quantity

Actual Total Cost

Actual Unit Cost

Amount Billed

Approval Comments

Approved By

Billable

Campaign Name

Class ID

Class Name

Client ID
Client Name

Company ID

Company Name

Date Approved

Date Created

Date Submitted

Department

End Date

Envelope Number

Expense Approver

Expense Date

Expense Description

Expense Receipt Comments

Expense Receipt Description

Expense Type

Invoice Number

Markup

Office ID

Office Name

Posted Into WIP

Posted Out Of WIP

Project Name

Project Number

Start Date

Task Description

Task ID
Unit Rate

User First Name

User Full Name

User Last Name

User System ID

Voucher Created

 

Insertion Order Data

Address 1

Address 2

Address 3

Address City

Address Country

Address Postal Code

Address State

Amount Billed

Applied Invoices

Approved Date

Campaign Name

Caption

Class ID

Class Name

Client ID

Client Name

Closed

Commission

Company ID

Company Name

Date Created

Department

Downloaded

Gross Amount

Insertion Date

Item ID
Item Name

Line Closed

Line Comments

Line Number

Market ID

Market Name

Media Estimate Full Name

Media Estimate ID

Media Estimate Name

Net Amount

Office ID

Office Name

Open Amount

Order Date

Order Number

Ordered By

Project Full Name

Project Name

Project Number

Publication Full Name

Publication ID
Publication Name

Revision Number

Special Instructions

Status

Task Full Name

Task ID
Task Name

Traffic Instructions

User Defined Date 1

User Defined Date 2

User Defined Date 3

User Defined Date 4

User Defined Date 5

User Defined Date 6

Vendor Contact

Vendor Full Name

Vendor ID
Vendor Name

 

Miscellaneous Costs Data

Amount Billed

Billable

Campaign Name

Class ID

Class Name

Client ID

Client Name

Comments

Date Entered

Department

Description

Expense Date

Gross Amount

Invoice Date

Invoice Number

Item Expense Account

Item ID

Item Name

Markup

Net Amount

Posted Into WIP

Posted Out Of WIP

Project Closed

Project Full Name

Project Name

Project Number

Quantity

Task Full Name

Task ID

Task Name

Transferred Out

Unit Cost

Unit Description

WriteOff

 

Order Detail Accrual Data

Accruing Client Invoice Posted

Address 1

Address 2

Address 3

Address City

Address Country

Address Postal Code

Address State

Amount Accrued

Amount Unaccrued

Applied Invoices

Approved By

Approved Date

Billable

Billing Item ID

Billing Item Name

Campaign Name

Class ID

Class Name

Client ID

Client Name

Closed

Company ID

Company Name

Date Accrued

Date Created

Date Unaccrued

Deliver To 1

Deliver To 2

Deliver To 3

Deliver To 4

Delivery Instructions

Department

Downloaded

Due Date

Invoice Billed On

Item Expense Account

Line Accrued Cost

Line Accrued Cost Difference

Line Item ID

Line Item Name

Line Long Description

Line Number

Line Project Number

Line Quantity

Line Short Description

Line Task Full Name

Line Task ID

Line Task Name

Line Total Amount Billable

Line Total Cost

Line Unit Cost

Line Unit Description

Markup

Office ID

Office Name

Ordered By

Parent Company

PO Date

PO Number

PO Revision Number

Pub or Station Name

Remaining PO Amount

Special Instructions

Status

Transferred Out

Unaccruing Vendor Invoice Posted

Vendor Contact

Vendor Full Name

Vendor ID

Vendor Invoice AP Account

Vendor Invoice Date

Vendor Invoice Line GL Account

Vendor Invoice Line Quantity

Vendor Invoice Line Total Cost

Vendor Invoice Number

Vendor Invoice Total

Vendor Line Date Billed

Vendor Line Payed by Client

Vendor Line Short Description

Vendor Line Total Amount Billable

Vendor Name

 

Order Detail Data

Address 1

Address 2

Address 3

Address City

Address Country

Address Postal Code

Address State

Adjustment Number

Amount Billed

Amount Billed On Vendor Invoices

Applied Invoices

Approved Date

Billed Differences 

Campaign ID 

Campaign Name

Caption

Class ID

Class Name

Client Division

Client Division ID

Client ID

Client Name

Client Product

Client Product ID

Closed

Commission

Company ID

Company Name

Currency

Date Created

Department

Downloaded 

Gross Amount

Insertion Date

Invoice Open Amount

Invoice Comment

Invoice Date

Invoice Non Tax Total 

Invoice Number

Invoice Sales Tax Total

Invoice Total

Item Expense Account

Item ID

Item Name

Line Accrued Cost 

Line Accrued Cost Difference

Line Amount Left to Unaccrue

Line Amount Unaccrued

Line Closed

Line Comments

Line Date Billed

Line Invoice Number

Line Number

Market ID

Market Name

Markup Percent

Materials Due

Media Estimate Full Name

Media Estimate ID

Media Estimate Name

Net Amount 

Office ID

Office Name

Open Amount 

Order Date

Order Description

Order Number

Order Type

Ordered By

Project Full Name

Project Name

Project Number

Publication Full Name

Publication ID

Publication Name

Revision Number

Sales Person

Space Close 

Special Instructions

Status

Task Full Name

Task ID

Task Name

Total Billed 

Traffic Instructions

Transferred Out

User Defined Date 1

User Defined Date 2

User Defined Date 3

User Defined Date 4

User Defined Date 5

User Defined Date 6

Vendor Contact

Vendor Full Name

Vendor ID

Vendor Name

Purchase Order Accrued Amounts

Accrued Amount

Billable

Client Division

Client Division ID

Client ID

Client Name

Client Product

Client Product ID

Company ID

Company Name

CustomFieldKey

Date Accrued

Date Created

Date Unaccrued

Invoice Billed On

Invoice Number

Line Adjustment Number 

Line Number 

Line Project Full Name

Line Project Name

Line Project Number

Line Short Description

Line Total Cost 

Line Unit Description

Month Accrued

Month Unaccrued

Order Invoice Date Posted

Parent Company 

PO Number

Project Account Manager

Vendor Full Name

Vendor ID

Vendor Invoice Amount Paid

Vendor Invoice Date

Vendor Invoice Line Total Cost

Vendor Invoice Total

Vendor Line Short Description

Vendor Name

Year Accrued

Year Unaccrued

Purchase Order Data

Address 1

Address 2

Address 3

Address City

Address Country

Address Postal Code

Address State

Applied Invoices

Approved By

Approved Date

Billable

Billing Item ID

Billing Item Name

Campaign Name

Class ID

Class Name

Client ID

Client Name

Closed

Company Id

Company Name

Date Created

Deliver To 1

Deliver To 2

Deliver To 3

Deliver To 4

Delivery Instructions

Department

Downloaded

Due Date

Item Expense Account

Line Accrued Cost

Line Accrued Cost Difference

Line Item ID

Line Item Name

Line Long Description

Line Number

Line Project Full Name

Line Project Name

Line Project Number

Line Quantity

Line Short Description

Line Task Full Name

Line Task ID

Line Task Name

Line Total Amount Billable

Line Total Cost

Line Unit Cost

Line Unit Description

Markup

Office ID

Office Name

Opportunity Name

Ordered By

Parent Company

PO Date

PO Number

PO Revision Number

Remaining PO Amount

Special Instructions

Status

Transferred Out

Vendor Contact

Vendor Full Name

Vendor ID

Vendor Name

 

Quote Details

  

Vendor Invoice Data

Amount Unaccrued

AP Account Number

Approver Name

Billable

Billing Item ID

Billing Item Name

Billing Status

Campaign Name

Class ID

Class Name

Client Full Name

Client ID

Client Name

Client Project Number

Company ID

Company Name

Date Approved

Date Billed

Date Paid by Client

Date Received

Expense Account Name

Expense Account Number

Invoice Date

Invoice Due Date

Invoice Number

Invoice Status

Item Department

Last Invoice for Order

Line Amount Billed

Line Amount Billed Approved

Line Department

Line Description

Line Gross Amount

Line Invoice Number

Line Item ID

Line Item Name

Line Net Cost

Line Quantity

Line Sales 1 Tax Amount

Line Sales 2 Tax Amount

Line Sales Tax 1 Applied

Line Sales Tax 2 Applied

Line Sales Tax Total Amount

Line Unit Cost

Line Unit Description

Markup

Media Estimate ID

Media Estimate Name

Non Billable Project

Office ID

Office Name

Opening Transaction

Order Line Amt Billed

Order Line End Date

Order Line Gross

Order Line Net

Order Line Number

Order Line Start Date

Parent Company

Posted

Posted Out of WIP

Posting Date

Project Full Name

Project Name

Project Number

Project Primary Contact

Purchase Order Number

Purchased By

Purchased From

Task Full Name

Task ID

Transferred Out

Type of Voucher

Vendor ID

Vendor Name

WriteOff

 

Vendor Payments Detail

_x0031_099 Box

_x0031_099 From

Applied as a Prepayment

Cash Account Full Name

Cash Account Name

Cash Account Number

Check Amount

Check Date

Check Memo

Check Number

Class ID

Class Name

Cleared

Client ID

Client Name

Company ID

Company Name

Company Type

EIN Number

Invoice Posting Date

Line 1099 Amount

Line Amount

Line Class ID

Line Class Name

Line Department

Line Description

Line Discount Amount

Line Exclude From 1099

Line Expense Account

Line Expense Account Name

Line Expense Account Number

Line Invoice Number

Line Office

Line Quantity

Line Unit Amount

Pay To Address 1

Pay To Address 2

Pay To Address 3

Pay To Address 4

Pay To Address 5

Pay To Name

Posted

Posting Count

Posting Date

Printed

Project Number

Unapplied Payment Account Full Name

Unapplied Payment Account Name

Unapplied Payment Account Number

Vendor 1099 Type

Vendor ID

Vendor Name

Vendor Payments and Credit Card Charges

Amount Charged

Applied as a Prepayment

Cash Account Full Name

Cash Account Name

Cash Account Number

Charge Date

Check Memo

Check Number

City

Class ID

Class Name

Cleared

Client Division

Client Division ID

Client ID

Client Name

Client Product

Client Product ID

Company ID

Company Name

Company Type

Credit Card

Credit Card Name

Credit Card Number

Currency

EIN Number

Exchange Rate

Invoice Date

Invoice Due Date

Invoice Posting Date

Line 1099 Amount

Line Amount

Line Class ID

Line Class Name

Line Department 

Line Description

Line Discount Amount

Line Exclude from 1099

Line Expense Account

Line Expense Account Name

Line Expense Account Number

Line Invoice Number

Line Office

Line Quantity

Line Unit Amount

Pay To Address1

Pay To Address2

Pay To Address3

Pay To Address4

Pay To Address5

Pay To Name

Posted

Posting Count

Posting Date

Printed

Project Number

Purchased By

Purchased From

State

Unapplied Payment Account Full Name

Unapplied Payment Account Name

Unapplied Payment Account Number

Unique Auto Number 

Vendor 1099 Box

Vendor 1099 Form

Vendor 1099 Type

Vendor Accepts Credit Cards

Vendor ID

Vendor Invoice Memo

Vendor Name

Vendor Phone

Zip Code