Custom Reports Datasets Cheat Sheet: Purchasing
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