Exporting Invoices

Internal Deal ID

dealId

This is a unique internal string for the Deal ID that appears with the API and data stream.

12-byte hexadecimal or use string (e.g., varchar(50))

Line Item Name

deallineName

This is the name of the line item.

varchar(250)

Is Cancelled

isCancelled

This shows TRUE only if the Sales module cancel feature was used on the line item in a revision and that revision completed its workflow.  It does not indicate when the cancellation occurred though. Whether to bill the value or not is up to your internal processes. A cancelled line may still have delivered before being cancelled. If you exported when this was FALSE, but it was later cancelled, subsequent exports will show TRUE when the Sales workflow completes as this field reflects Sales values rather than Finance values. The Finance module treats cancelled lines as modifications and does not do anything special with them.

boolean

Line Item Net Cost

deallineNetCost

This is the Net Cost as it appears in the Sales module. It does not reflect delivery or invoice data. 

decimal(15,4)

Line Item Net Unit Cost

deallineNetUnitCost

This is the line item Net Unit Cost as it appears in the Sales module.

decimal(15,4)

Line Item Quantity

deallineQuantity

This is the line item Quantity as it appears in the Sales module. It does not reflect delivery or invoice data.

bigint(20)

Line Item Start Date

deallineStartDate

This is the line item Start Date, not the invoice line date.

date

Line Item End Date

deallineEndDate

This is the line item End Date, not the invoice line date.

date

Unit Type

deallineUnitType

This is the Unit Type that will reflect what the Primary Performance and Third-Party Performance correspond to.

varchar(100)

Cost Method

deallineCostMethod

This is the Cost Method that determines how values are calculated along with the Invoice Terms, Net Unit Cost, Net Cost, Quantity, delivery, and other considerations.

varchar(100)

Line Item Unit Cost Without Discounts

unitCostBeforeDiscounts

This is the Unit Cost Before Discounts as it appears for the line item in the Sales module.

decimal(15,4)

Line Item Gross Unit Cost

deallineGrossUnitCost

This is the Gross Unit Cost as it appears for the line item in the Sales module.

decimal(15,4)

Line Item Gross Cost

deallineGrossLineItemCost

This is the Gross Cost as it appears in the Sales module.  It does not reflect delivery or invoice data.

decimal(15,4)

Line Item Net Bonus

deallineNetBonus

This shows the Line Item Value only when Bonus is True based on the Line Class. When Bonus is False, this shows 0. It is not based on the invoice line and delivery information, This is the Sales bonus value for the entire line item that sometimes is referred to as the Added Value Amount as sold.

decimal(15,4)

Forecast Category

deallineForecast

This is the forecast category that Sales chose based on the context of the deal and line.

varchar(100)

Billable Third Party Server

deallineThirdPartyPSDefinitionName

This shows which Third-Party system's data is used for Third-Party performance numbers. A Sales user can set this on a line item. No Third-Party data appears for a line item unless this is set.

decimal(15,4)

Makegood Links

makeGoodDone

For a line item using a Makegood Line Class, this reflects the Makegood Done field, which a Sales user can set on the Advanced Edit pane on the digital Workspace of a deal. The Sales user can set this to one or more IDs for other Deal Lines on any deal with the same advertiser. When there is more than one ID set in Sales, they are separated by a semicolon in the Finance export.

Each ID is no more than 25 characters. varchar(255) is probably safe depending in your usage patterns.

Line Class

deallineClassName

This is the line class that can determine if a line is a bonus, makegood, or regular line. The actual names are configurable in the System Configuration module. Based on how the line class is configured within the System Configuration module, it may always show the Net Cost as zero. A user chooses this on a line item within Sales.

decimal(15,4)

Makegood

makegood

This shows if the line item is a makegood. The system does not calculate amounts for makegood lines, but it does calculate units and revenue. This is based on the Line Class and reflects its Makegood checkbox in the System Configuration module when the deal went active.

boolean

ADU

adu

This shows if the line item is a ADU (Audience Deficienty Units). The system does not calculate either amounts or revenue for ADU lines. This is based on the Line Class and reflects its ADU checkbox in the System Configuration module when the deal went active.

boolean

Bonus

bonus

This shows if the line item is a Bonus (Added Value). The system does not calculate either amounts or revenue for bonus lines. This is based on the Line Class and reflects its Bonus checkbox in the System Configuration module when the deal went active.

boolean

Can Invoice

canInvoice

This is always True unless you are reviewing a child line item within a package that is not directly billed. Those Can Invoice False records only appear in special invoice exports that expose additional package details.

boolean

Line Item Total Discounts

deallineTotalDiscount

This is the total discount % as it was set on a line item’s pricing tab.  Discounts are set at the line item level and how they apply depends on the discount profile configured in the System Configuration module. This is expressed as a % value rather than a decimal. For example, 10% appears as 10 instead of .1.

decimal(15,4)

Line Item Production Buffer

deallineProductionBuffer

This is the Production Buffer percentage as it appears for the line item in Sales. It reflects the variation between the Quantity and Production Quantity in the Sales module.

decimal(15,4)

Line Item Production Quantity

deallineProductionQuantity

This is the Production Quantity from the line item, which can be different than the Quantity in some cases. The Quantity is the number used by Finance and the Production Quantity is the number you actually traffic. In some cases, it is necessary to traffic a higher buffered number to ensure an actual Quantity goal is met.

bigint(20)

Line Item Value

deallineValue

This is typically the same as the Net Cost, but for Makegood or Bonus lines when the Net Cost is zero, this shows what the Net Cost would have been if the line was not a Makegood or Bonus. The Line Class can set whether the line is a Makegood or Bonus depending on how the Line Class is configured in the System Configuration module.

decimal(15,4)

Station

station.stationMarketName

This shows the Station and Market as they appears within the Invoices UI.

In addition to this field, a custom export can also include additional details about the station if they are populated within the System Configuration module (MRD).  However, the System Configuration module (MRD) does not always populate them as expected. The following keys are supported:

• station.affiliation

• station.comscoreCallLetter

• station.comscoreDistributorCode

• station.displayCallLetter

• station.displayName

• station.id

• station.marketComscoreCode

• station.marketId

• station.marketName

• station.marketNielsenCode

• station.name

• station.nielsenCallLetter

• station.nielsenDistributorCode

varchar(100)

Sales Targeting

salesTargetingSummary

This is a string showing details about the targets set in the Sales module in the form:

target1=option1;option2 | target2=option3

Note: Embedded targets are in the Product Embedded Targeting field instead.

Text (This is variable length and there is effectively no limit. It will concatenate as much targeting as is set on the line.)

Product Embedded Targeting

productEmbeddedTargettingSummary

This is a string showing details about the targets embedded in the product from  the Product  module in the form:

target1=option1;option2 | target2=option3

Note: This reflects the product's targeting at the time the line item was created and NOT the current published state.  The other product related field reflect current published state or for unpublished products, the current state.

Text (This is variable length and there is effectively no limit. It will concatenate as much targeting as is set on the product.)

Package Type

deallinePackageType

This is the package type (group type) for a line item that is the parent or child within a package product. For example:

• BottomUp

• TopDown

• RunOf

• Freeform.

Information on packages is in the Products module documentation.

varchar(25)

Standard or Package

deallineItemType

This shows if the invoice line corresponds directly to a package or not. It can be one of the following values:

• PACKAGE means the invoice line is for a parent of a package. The parent is billed. The Can Invoice box is checked in Sales for the parent.

• STANDARD means the invoice line is not for the parent.  This can mean the line is a child within a package where that child line has its Can Invoice box checked. It can also mean the child is not part of a package at all, in which case the Package Type column is empty.

varchar(25)

Internal Product ID

internalProductID

This is a unique internal string for the Product ID that appears with the API and data stream. When billing a package parent line, this reflects the package.

12-byte hexadecimal or use string (e.g., varchar(50))

Product ID

deallineProductId

This is the unique integer for the product as it appears within the Products module. When billing a package parent line, this reflects the package.

bigint(20)

Product Name

deallineProductName

This is the name of the line item’s product. When billing a package parent line, this reflects the package.

varchar(250)

Internal Package ID

internalPackageID

When billing a package parent line or when a line is within a package, this is a unique internal string for the Package ID that appears with the API and data stream.

12-byte hexadecimal or use string (e.g., varchar(50))

Package ID

packageID

When billing a package parent line or when a line is within a package, this is the unique integer for the package as it appears within the Products module.

bigint(20)

Package Name

packageName

When billing a package parent line or when a line is within a package, this is the name of the line item’s package.

varchar(250)

Internal Parent Line Item ID

internalParentLineItemID

When a line is a child within a package, this is a unique internal string for the parent line item ID that appears with the API and data stream.

12-byte hexadecimal or use string (e.g., varchar(50))

Parent Line Item ID

parentLineItemID

When a line is a child within a package, this is the Line Item ID for its parent.

bigint

Parent Line Item Number

parentLineItemNumber

When a line is a child within a package, this is the Line Item Number of its parent line item.

decimal(10,4)

Parent Line Item Name

parentLineItemName

When a line is a child within a package, this is the name of the parent line item.

varchar(250)

Product Tags

productTagNames

This shows the product tags set in the Products module.

Text (This is variable length and will concatenate the multi-select field from the product.)

Product Billing ID

productBillingId

This shows the Billing ID from the Finance Settings pane in the Products module.

varchar(255)

Product Category

productCategoryNames

This shows the Product Categories set in the Products module.

Text (This is variable length and will concatenate the multi-select field from the product.)

Product Genre

productGenreNames

This shows the Genres chosen in the Products module.

Text (This is variable length and will concatenate the multi-select field from the product.)

Product Forecast Category

productOperativeForecastCategoryName

This is the Forecast Category field as was set in the Products module.

varchar(100)

Product External Forecast Category

productExternalForecastCategoryName

This is the External Forecast Category field as it was set in the Products module.

varchar(100)

Product Type

productType

At this time, this always says DIGITAL. However, in the future, it will also support LINEAR.

varchar(50)

Product Template

productTemplateName

This is the Template that defines which fields appear within the Product module itself. It is NOT the Targeting Template. In many environments, this will always say Digital, but if users choose a different name from a Template drop-down list when they first enter the Product module, this reflects that choice.

varchar(100)

Creative Specifications

productCreativeSpecProfileName

This is the Creative Specifications set on the product.

varchar(100)

Invoice Name

invoiceName

This is the invoice name, which is typically in the form:

Deal_Name - Billing_Period_Name

varchar(300)

Total Net Invoice Amount

totalNetInvoiceAmount

This is the sum of the Net Invoice Amount for all invoice lines within the same invoice. It includes adjustments if any are applied.

decimal(15,4)

Total Net Invoice Amount Adjustment

totalInvoiceAmountAdjustments

This is the sum of all Net Invoice Amount Adjustments across all lines in the invoice.

decimal(15,4)

Total Gross Invoice Amount

totalGrossInvoiceAmount

This is the sum of the Adjusted Gross Invoice Amount for all invoice lines within the same invoice. It includes adjustments if any are applied.

decimal(15,4)

Total Gross Invoice Amount Adjustment

totalGrossInvoiceAmountAdjustments

This is the sum of all Gross Invoice Amount Adjustments across all lines in the invoice. A user cannot enter a gross adjustment but one is calculated based on any Net Invoice Amount Adjustment.

decimal(15,4)

Total Gross Less Net

totalGrossLessNet

This shows the difference between the Total Gross Invoice Amount and Total Net Invoice Amount at the invoice level. Depending on how your discount profiles are set up, this may be considered the Total Agency Discount and the column header can be renamed on request if needed.

decimal(15,4)

Total Recognized Revenue

totalRecognizedRevenue

This is the sum of the Recognized Revenue for all invoice lines within the same invoice. It includes adjustments if any are applied.

decimal(15,4)

Total Recognized Revenue Adjustment

totalRecognizedRevenueAdjustments

This is the sum of all Recognized Revenue Adjustments across all lines in the invoice.

decimal(15,4)

Total Invoice Units

totalInvoiceUnits

This is the sum of the Invoice Units for all invoice lines within the same invoice, regardless of unit types. This may not make sense for deals that sell a mix of different units (impressions, clicks, flat rate lines, etc.). It includes adjustments if any are applied.

bigint(20)

Total Invoice Units Adjustment

totalInvoiceUnitsAdjustments

This is the sum of all Invoice Units Adjustments across all lines in the invoice.

bigint(20)

Lock Status

lockStatus

This is the lock status of the invoice which can be one of the following:

• unlocked

• locked

• prior_locked

• reset

varchar(25)

First Lock Date

firstLockDate

This is the date and time when the invoice was first locked. This is never updated if the invoice is unlocked and then locked again. It shows in the time zone of the user who triggered the export.

timestamp

Latest Lock Date

lastLockDate

This is the date and time when the invoice was last locked. If the invoice is only locked one time, it matches the First Lock Date. It shows in the time zone of the user who triggered the export.

timestamp

First Lock User

firstLockUser

This is the user login of the user who first locked the invoice.

varchar(50)

Latest Lock User

lastLockUser

This is the user login of the user who last locked the invoice.

varchar(50)

Billing Period Name

billingPeriodDisplayName

This is the Billing Period Name within the calendar.

varchar(100)

Billing Period Start Date

billingPeriodStartDate

This is the Start Date for the Billing Period.

date

Billing Period End Date

billingPeriodEndDate

This is the End Date for the Billing Period.

date

Invoice Status

invoiceStatus

This is the Finance workflow status that can be set in a number of different ways depending on how your system is configured.

varchar(100)

Processed Date

processedDate

If you use the Invoice Pull operation to have AOS import information from your Financial System after exporting, this shows the Process Date set by the Financial System.

timestamp

Export Process Details

exportProcessDetails

If you use the Invoice Pull operation to have AOS import information from your Financial System after exporting, this shows any details sent from that system back into AOS, up to 255 characters.

varchar(255)

Payment Amount

paymentAmount

If you use the Invoice Pull operation to have AOS import information from your Financial System after exporting, this shows any payment amount sent from that system back into AOS, as a monetary value up to four decimal places.

decimal(15,2)

Invoice Start Date

invoiceStartDate

This shows the first date for the invoice, which can be later than the Billing Period Start Date if the earliest line item starts after the period begins.

date

Invoice End Date

invoiceEndDate

This shows the last date for the invoice, which can be earlier than the Billing Period End Date if the latest line item ends before the period ends.

date

First Exported Date

firstExportedDate

This shows the date and time when the specific invoice was exported to a financial system. This is stored by AOS after the invoice is first exported to a financial system. Therefore, it will not have a value in that first export file.

timestamp

First Exported By

firstExportedBy

This shows the login of the user who first triggered the export to a financial system. This is stored by AOS after the invoice is first exported to a financial system. Therefore, it will not have a value in that first export file.

varchar(50)

Previous Exported Date

lastExportedDate

This shows the date and time when the specific invoice was last exported to a financial system. This is stored by AOS after the invoice is exported to a financial system. Therefore, it will not reflect the date and time of that export itself. The date and time of that export itself are available as the Export Time, which has a common value across all rows. The actual time stamp for export is also reflected in the file name using a common UTC time zone.

timestamp

Previous Exported By

lastExportedBy

This shows the login of the user who last triggered the export to a financial system. This is stored by AOS after the invoice is exported to a financial system. Therefore, it will not reflect the user exporting the invoice itself. The Export User field reflects the export itself. This shows the Latest Export Date from the Invoices Grid at the time the export is requested, which can change when the export completes.

varchar(50)

Number of Previous Exports

totalExportCount

This is a count of the number of times an invoice was previously exported to a Financial System. This is incremented by AOS after the invoice is exported to a financial system.

int(11)

Assignees

assignedUsers

This shows the first and last names of users assigned to an invoice. Multiple users are separated by semicolons.

String. This concatenates if there are multiple users. A single contact will not exceed 101 characters, but this can contain n users. Practically speaking this is unlikely to exceed 400 to 1000 characters

Finance Team

assignedTeam

This is an invoice specific Finance Team that can vary from the Sales team depending on the needs of your Finance department. By defaults, it is the same as the Sales Team. However, assignment rules or manual selection within the Finance module can set a separate team per invoice.

varchar(50)

CLI Units Ratio

invoiceUnitsRatio

By default, this is empty unless you enable the Non-Invoice CLIs feature for the export template. When Can Invoice=False, this can contain the ratio reflecting the child's weight in its package's Invoice Units. This is multiplied against the parent Invoice Units to derive the child value.

decimal(9,8)

CLI Uncapped Invoice Units

uncappedInvoicUnits

This shows the units used to calculate the CLI Units Ratio within the package. It only has a value for Can Invoice False lines within packages with the Non-Invoice CLIs feature.

bigint(20)

Adjustment Category

categoryName

This is the predefined category for why an adjustment is made. Administrators define the categories in the System Configuration module under System Configuration > System > Finance Adjustment Category.

varchar(255)

Adjustment Comments

adjustmentComments

This is a free text description about the adjustment.

varchar(255)

Last Adjusted By

lastAdjustedBy

This shows the login of the user who last saved an adjustment number, category, or comment.

varchar(125)

Last Adjusted Date

lastAdjustedDate

This shows the most recent date when a user saved an adjustment number, category, or comment.

date time

Invoice Units

units

This is the quantity you show on the invoice based on the Invoice Terms and Unit Type.

bigint(20)

Invoice Units Adjustment

invoiceUnitsAdjustment

This is a positive or negative whole number that is the adjustment to apply to the Invoice Units.

bigint(20)

Adjusted Invoice Units

adjustedInvoiceUnits

This is:

Invoice Units + Invoice Units Adjustment

bigint(20)

Cumulative Invoice Units

cumulativeInvoiceUnits

This is the total Invoice Units for the deal line up to and including the row’s invoice. It is the sum of the row’s Invoice Units plus those for any invoice lines for the same deal line for billing periods earlier than that period. For example, if the line item runs from July through December and the row’s invoice line is for September, it reflects July, August, and September. It includes adjustments if any are applied.

bigint(20)

CLI Amount Ratio

netInvoiceAmountRatio

By default, this is empty unless you enable the Non-Invoice CLIs feature for the export template. When Can Invoice=False, this can contain the ratio reflecting the child's weight in its package's Net Invoice Amount. This is multiplied against the parent Net Invoice Amount and Gross Invoice Amount to derive the child values.

decimal(9,8)

Invoice Amount without Discounts

amountBeforeDiscount

This converts the Net Invoice Amount to reflect a value without any discounts applied using the ratio of Net Unit Cost to Unit Cost Before Discounts (UCBD):

( UCBD / Net Unit Cost ) * Net Invoice Amount

At this time, this field is calculated by the export itself, so is not available within the user interface. Cumulative and invoice total versions of this field are also not available. This field has no value when there are no Unit Costs available, such as when packages have the Various Cost Method.

decimal(15,4)

Gross Invoice Amount

grossInvoiceAmt

This is the gross value for how much you bill. How this calculates depends on the Amount Terms. If the Amount Terms are NOT Manual, then it uses the same calculation as the Net Invoice Amount but substitutes the Line Item Gross Unit Cost for the Line Item Net Unit Cost and substitutes the Gross Cost for the Net Cost to determine the cap. However, if the Amount Terms are Manual, the system calculates the Gross Invoice Amount using a ratio applied to the Net Invoice Amount:

(Line Item Gross Unit Cost * Net Invoice Amount)
/ Line Item Net Unit Cost

decimal(15,4)

Gross Invoice Amount Adjustment

grossAdjustment

A Gross Invoice Amount Adjustment is calculated whenever there is a Net Invoice Amount Adjustment as:

(Gross Unit Cost * Net Invoice Amount Adjustment) / Net Unit Cost

However, if Unit Costs are zero then Gross Cost and Net Cost are used, which is the case for a Package with the Various Cost Method.

decimal(15,4)

Adjusted Gross Invoice Amount

adjustedGross

This is calculated as:

Gross Invoice Amount + Gross Invoice Amount Adjustment

decimal(15,4)

Cumulative Gross Invoice Amount

cumulativeGrossInvoiceAmount

This is the sum of the row’s Gross Invoice Amount plus those for any invoice lines for the same deal line for billing periods earlier than that period. For example, if the line item runs from July through December and the row’s invoice line is for September, it reflects July, August, and September. It includes adjustments if any are applied.

decimal(15,4)

CLI Uncapped Net Invoice Amount

uncappedNetInvoiceamount

This shows the monetary value used to calculate the CLI Amount Ratio within the package. It only has a value for Can Invoice False lines within packages with the Non-Invoice CLIs feature.

decimal(15,4)

Net Invoice Amount

amount

This is the monetary value you bill the customer on the invoice based on the Invoice Terms.

decimal(15,4)

Net Invoice Amount Adjustment

invoiceAmountAdjustment

This is a positive or negative number that is the adjustment to apply to the Net Invoice Amount.

decimal(15,4)

Adjusted Net Invoice Amount

adjustedInvoiceAmount

This is calculated as:

Net Invoice Amount + Net Invoice Amount Adjustment

decimal(15,4)

Cumulative Net Invoice Amount

cumulativeNetInvoiceAmount

This is the total Net Invoice Amount for the deal line up to and including the row’s invoice. It is the sum of the row’s Net Invoice Amount plus those for any invoice lines for the same deal line for billing periods earlier than that period.   For example, if the line item runs from July through December and the row’s invoice line is for September, it reflects July, August, and September. It includes adjustments if any are applied.

decimal(15,4)

Gross Less Net

grossLessNet

This shows the difference between the Gross Invoice Amount and Net Invoice Amount at the invoice line level.  Depending on how your discount profiles are set up, this may be considered the Agency Discount and the column header can be renamed on request if needed.

decimal(15,4)

CLI Revenue Ratio

recognizedRevenueRatio

By default, this is empty unless you enable the Non-Invoice CLIs feature for the export template. When Can Invoice=False, this can contain the ratio reflecting the child's weight in its package's Recognized Revenue. This is multiplied against the parent Recognized Revenue derive the child value.

decimal(9,8)

CLI Uncapped Recognized Revenue

uncappedRecognizedRevenue

This shows the monetary value used to calculate the CLI Revenue Ratio within the package. It only has a value for Can Invoice False lines within packages with the Non-Invoice CLIs feature.

decimal(15,4)

Recognized Revenue

recognizedRevenue

This is the monetary value you internally recognize as revenue for the invoice based on the Invoice Terms.

decimal(15,4)

Recognized Revenue Adjustment

recognizedRevenueAdjustment

This is a positive or negative number that is applied to the Recognized Revenue as an adjustment.

decimal(15,4)

Adjusted Recognized Revenue

adjustedRecognizedRevenue

This is:

Recognized Revenue + Recognized Revenue Adjustment

decimal(15,4)

Cumulative Recognized Revenue

cumulativeRecognizedRevenue

This is the total Recognized Revenue for the deal line up to and including the row’s invoice. It is the sum of the Recognized Revenue plus those for any invoice lines for the same deal line for billing periods earlier than that period. For example, if the line item runs from July through December and the row’s invoice line is for September, it reflects July, August, and September. It includes adjustments if any are applied.

decimal(15,4)

Primary Performance

primaryPerformance

This is the uncapped delivery data for the invoice line’s dates from the first-party publisher system when available within AOS.

bigint(20)

Primary Gross

primaryGross

This reflects Gross Unit Cost applied to Primary Performance without capping. It is not calculated when the Cost Method is Flat Rate or SOV Flat Rate or for a Makegood, Bonus, or ADU line.

decimal(15,4)

Primary Net

primaryAmount

This reflects Net Unit Cost applied to Primary Performance without capping. It is not calculated when the Cost Method is Flat Rate or SOV Flat Rate or for a Makegood, Bonus, or ADU line.

decimal(15,4)

Third Party Performance

thirdPartyPerformanceNumber

This is the uncapped delivery data for the invoice line’s dates from the deal line’s Billable Third-Party Server when that data is available within AOS.

bigint(20)

Third Party Gross

thirdPartyGross

This reflects Gross Unit Cost applied to Third Party Performance Delivery without capping. It is not calculated when the Cost Method is Flat Rate or SOV Flat Rate or for a Makegood, Bonus, or ADU line.

decimal(15,4)

Third Party Net

thirdPartyAmount

This reflects Net Unit Cost applied to Third Party Performance Delivery without capping. It is not calculated when the Cost Method is Flat Rate or SOV Flat Rate or for a Makegood, Bonus, or ADU line.

decimal(15,4)

Performance Discrepancy

performanceDiscrepancy

This shows the difference between Primary and Third-Party Performance during the row’s period, calculated as.

Primary Performance

- Third-Party Performance

bigint(20)

Performance Discrepancy Percentage

discrepancyPercent

This is the percentage discrepancy  between Primary and Third-Party Performance during the row’s period, calculated as:

(( primaryPerformance  –  thirdPartyPerformance  ) / primaryPerformance ) * 100

However, if one of the two performance numbers is zero and the other is not zero, this is always 100% discrepant. If neither has delivery, this is always zero.

decimal(15,6)

Cumulative Primary Performance

cumulativePrimaryPerformance

This is the uncapped Primary Performance for the deal line up to and including the row’s invoice.

bigint(20)

Cumulative Third Party Performance

cumulativeThirdPartyPerformance

This is the uncapped Third-Party Performance for the deal line up to and including the row’s invoice.

bigint(20)

Cumulative Performance Discrepancy

cumulativePerformanceDiscrepancy

This shows the difference between Cumulative Primary and Third-Party Performance for the row’s period and all previous periods, calculated as:

Cumulative Primary Performance - Cumulative Third-Party Performance

bigint(20)

Cumulative Performance Discrepancy Percentage

cumulativePerformanceDiscrepancyPercentage

This is the percentage discrepancy  between Cumulative Primary and Third-Party Performance, calculated as:

(Cumulative Primary Performance - Cumulative Third-Party Performance )  / Cumulative Primary Performance

If both are 0, it will be 0%. If only Primary is 0, it is 100%.

decimal(15,6)

Remaining Amount

remainingInvoiceAmount

This is calculated as:

Line Item Net Cost – Cumulative Net Invoice Amount

decimal(15,4)

Remaining Units

remainingInvoiceUnits

This is calculated as:

Line Item Quantity – Cumulative Invoice Units

bigint(20)

Unrecognized Revenue

unrecognizedRevenue

This is calculated as:

Line Item Net Cost
– Cumulative Recognized Revenue

decimal(15,4)

Deferred Revenue

cumulativeDeferredRevenue

This is calculated as:

Cumulative Net Invoice Amount – Cumulative Recognized Revenue

decimal(15,4)

Actual Invoice Units Term Source

unitSource

This shows how Invoice Units derived their Invoice Terms. It is one of the following:

• invoice_schedule meaning Invoice Terms were set based on the organization or a Sales user.

• manual meaning that a Finance user either manually set a value for the Invoice Units or manually changed the Invoice Terms.

varchar(50)

Actual Invoice Units Term Used

unitTermApplied

This shows which Invoice Terms were used to calculate the Invoice Units for the row.

varchar(50)

Actual Net Invoice Amount Term Source

amountSource

This shows how Net Invoice Amount derived its Invoice Terms.  It is one of the following:

• invoice_schedule meaning Invoice Terms were set based on the organization or a Sales user.

• manual meaning that a Finance user either manually set a value for the Net Invoice Amount or manually changed the Invoice Terms.

varchar(50)

Actual Net Invoice Amount Term Used

amountTermApplied

This shows which Invoice Terms were used to calculate the Net Invoice Amount for the row.

varchar(50)

Actual Revenue Recognition Term Source

recognizedRevenueSource

This shows how the Recognized Revenue derived its Invoice Terms.  It is one of the following:

• invoice_org meaning Invoice Terms were set based on the organization.

• product meaning Invoice Terms were set based on the product overrides.

• manual meaning that a Finance user either manually set a value for the Recognized Revenue or manually changed the Invoice Terms.

varchar(50)

Actual Revenue Recognition Term Used

recognizedRevenueTermApplied

This shows which Invoice Terms were used to calculate the Recognized Revenue for the row.

varchar(50)

Suggested Invoice Amount

suggestedAmount

For contracted terms (prorated or straightline), this is the contracted amount for the period, which matches the Net Invoice Amount unless values were manually changed within the Finance module. This has no value for performance terms.

decimal(15,4)

Cumulative Suggested Invoice Amount

cumulativeSuggestedAmount

For contracted terms (prorated or straightline), this is the contracted amount for the period and any earlier ones, which matches the Cumulative Net Invoice Amount unless values were manually changed within the Finance module. This has no value for performance terms or for non-invoice child lines.

decimal(15,4)

Suggested Amount Terms

suggestedAmountTerm

This shows the Invoice Terms that appeared on the Finance Summary tab in Sales when the deal last went active. It lets you review the terms that were sold in comparison with the Actual Net Invoice Amount Term Used. For non-invoice child lines, it reflects the parent terms.

varchar(50)

Suggested Invoice Units

suggestedUnits

For contracted terms (prorated or straightline), these are the contracted units for the period, which matches Invoice Units unless values were manually changed within the Finance module. This has no value for performance terms.

bigint(20)

Cumulative Suggested Invoice Units

cumulativeSuggestedUnits

For contracted terms (prorated or straightline), these are the contracted units for the period and any earlier periods, which matches Cumulative Invoice Units unless values were manually changed within the Finance module. This has no value for performance terms or for non-invoice child lines.

bigint(20)

Suggested Unit Terms

suggestedUnitTerm

This shows the Invoice Terms that appeared on the Finance Summary tab in Sales when the deal last went active. It lets you review the terms that were sold in comparison with the Actual Invoice Unit Term Used. For non-invoice child lines, it reflects the parent terms.

varchar(50)

Comments

invoiceObjectComments

This supports up to 255 characters of free text that a Finance user can optionally leave for other users to see or for exporting with the lines. When an invoice is locked, if you use adjustments, you can use the Adjustment Comments field instead.

varchar(255)

Last Billing Period

lastBillingPeriod

This is a Boolean flag reflecting whether the row is the last invoice line for a deal line.

• true means no invoice lines exist for the deal lines that are later in time than this row.

• false means invoice lines exist for the same deal line for periods after this row.

boolean

Export User

exportUser

This is the login of the user who requested the export. It does not get saved onto the invoice, does not appear in the interface, and is written directly onto the export file

varchar(50)