Credit Balance Adjustment

Credit Balance Adjustment > Amount

Credit Balance Adjustment > Adjustment Date

Account > Currency

Discount Applied Metrics

Discount Applied Metrics > MRR

Discount Applied Metrics > TCV

The earlier of:

• Discount Applied Metrics > Created Date

• Discount Applied Metrics > Start Date

Account > Currency

Invoice

Currency conversion data is provided for posted invoices only.

Invoice > Amount Without Tax

Invoice > Amount

The earlier of:

• Invoice > Posted Date

• Invoice > Invoice Date

Invoice > Currency

Invoice Adjustment

Invoice Adjustment > Impact Amount

Invoice Adjustment > Amount

The earlier of:

• Invoice Adjustment > Created Date

• Invoice Adjustment > Adjustment Date

Invoice > Currency

Invoice Item

Currency conversion data is provided for items in posted invoices only.

Invoice Item > Charge Amount

The earlier of:

• Invoice > Posted Date

• Invoice > Invoice Date

Invoice > Currency

Invoice Item Adjustment

Invoice Item Adjustment > Amount

The earlier of:

• Invoice > Posted Date

• Invoice > Invoice Date

Invoice > Currency

Invoice Payment

Invoice Payment > Amount

The earlier of:

• Payment > Created Date

• Payment > Effective Date

Payment > Currency

Order Line Item

OrderLineItem > Amount OrderLineItem > AmountWithoutTax OrderLineItem > AmountPerUnit OrderLineItem > ListPricePerUnit OrderLineItem > ListPrice

Order Line Item > Original Order Date

Account > Currency

Payment

Payment > Amount

The earlier of:

• Payment > Created Date

• Payment > Effective Date

Payment > Currency

Refund

Refund > Amount

The earlier of:

• Refund > Created Date

• Refund > Refund Date

Refund > Currency

Rate Plan Charge

Rate Plan Charge > DMRC Rate Plan Charge > DTCV Rate Plan Charge > MRR Rate Plan Charge > TCV

If Rate Plan Charge > Original Order Date exists, use the original order date.

or,

Use the earlier of:

• Rate Plan Charge > Created Date

• Rate Plan Charge > Effective Start Date

Subscription > Currency

Refund Invoice Payment

Refund Invoice Payment > Refund Amount

The earlier of:

• Refund > Created Date

• Refund > Refund Date

Refund > Currency

Revenue Schedule Item

Revenue Schedule Item > Amount

Revenue Schedule > Exchange Rate Date

Revenue Schedule Item > Currency

Revenue Schedule Item Invoice Item

Revenue Schedule Item Invoice Item > Amount

• For auto-created revenue schedules from invoices, it is the earlier of:

  • Invoice > Invoice Date

  • Invoice > Created Date

• For manually created revenue schedules from transactions (via REST API or Mass Updater), it is the earlier of:

  • Invoice > Invoice Date

  • Revenue Schedule Invoice Item > Created Date

Revenue Schedule Item Invoice Item > Currency

Revenue Schedule Item Invoice Item Adjustment

Revenue Schedule Invoice Item Adjustment > Amount

• For auto-created revenue schedules from invoices, it is the earlier of:

  • Invoice Item Adjustment > Adjustment Date

  • Invoice Item Adjustment > Created Date

• For manually created revenue schedules from transactions (via REST API or Mass Updater), it is the earlier of:

  • Invoice > Invoice Date

  • Revenue Schedule Invoice Item Adjustment > Created Date

Revenue Schedule Item Invoice Item Adjustment > Currency

Revenue Schedule Item Credit Memo Item

Revenue Schedule Item Credit Memo Item > Amount

• For auto-created revenue schedules from credit memos from invoices, it is the earlier of invoice date and invoice posted date.

• For auto-created revenue schedules from credit memos from charges and bill runs, it is the earlier of credit memo date and credit memo posted date.

• For manually created revenue schedules from transactions (via REST API or Mass Updater), it is the earlier of:

  • Revenue Schedule Credit Memo Item > Linked Transaction Date

  • Revenue Schedule Credit Memo Item > Created Date

Revenue Schedule Item Credit Memo Item > Currency

Revenue Schedule Item Debit Memo Item

Revenue Schedule Item Debit Memo Item > Amount

• For auto-created revenue schedules from debit memos from invoices, it is the earlier of invoice date and invoice posted date.

• For auto-created revenue schedules from debit memos from charges and bill runs, it is the earlier of credit memo date and debit memo posted date.

• For manually created revenue schedules from transactions (via REST API or Mass Updater), it is the earlier of:

  • Revenue Schedule Debit Memo Item > Linked Transaction Date

  • Revenue Schedule Debit Memo Item > Created Date

Revenue Schedule Item Debit Memo Item > Currency

Taxation Item

Currency conversion data is provided for items in posted invoices only.

Taxation Item > Tax Amount

Taxation Item > Exempt Amount

The earlier of:

• Taxation Item > Created Date

• Taxation Item > Tax Date

Invoice > Currency

The following transaction types are only available if you enable the Invoice Settlement feature.

Credit Memo

Credit Memo > Total Amount

Credit Memo > Total Amount Without Tax

• For credit memos created from invoices: Invoice > Invoice Exchange Rate Date

• For credit memos created from charges and bill runs: The earlier of:

  • Credit Memo > Posted Date

  • Credit Memo > Memo Date

Credit Memo > Currency

Credit Memo Item

Credit Memo Item > Amount Without Tax

• For credit memos created from invoices: Invoice > Invoice Exchange Rate Date

• For credit memos created from charges and bill runs: The earlier of:

  • Credit Memo > Posted Date

  • Credit Memo > Memo Date

Credit Memo > Currency

Credit Memo Application

Credit Memo Application > Amount

• For credit memos created from invoices: Invoice > Invoice Exchange Rate Date

• For credit memos created from charges and bill runs: The earlier of:

  • Credit Memo > Posted Date

  • Credit Memo > Memo Date

Credit Memo > Currency

Credit Memo Application Item

Credit Memo Application Item > Amount

• For credit memos created from invoices: Invoice > Invoice Exchange Rate Date

• For credit memos created from charges and bill runs: The earlier of:

  • Credit Memo > Posted Date

  • Credit Memo > Memo Date

Credit Memo > Currency

Credit Memo Part

Credit Memo Part > Amount

• For credit memos created from invoices: Invoice > Invoice Exchange Rate Date

• For credit memos created from charges and bill runs: The earlier of:

  • Credit Memo > Posted Date

  • Credit Memo > Memo Date

Credit Memo > Currency

Credit Memo Part Item

Credit Memo Part Item > Amount

• For credit memos created from invoices: Invoice > Invoice Exchange Rate Date

• For credit memos created from charges and bill runs: The earlier of:

  • Credit Memo > Posted Date

  • Credit Memo > Memo Date

Credit Memo > Currency

Credit Taxation Item

Credit Taxation Item > Tax Amount

Credit Taxation Item > Exempt Amount

• For credit memos created from invoices: Invoice > Invoice Exchange Rate Date

• For credit memos created from charges and bill runs: The earlier of:

  • Credit Memo > Posted Date

  • Credit Memo > Memo Date

Credit Memo > Currency

Debit Memo

Debit Memo > Total Amount

Debit Memo > Total Amount Without Tax

For debit memos created from charges and bill runs: The earlier of:

• Debit Memo > Posted Date

• Debit Memo > Memo Date

Debit Memo > Currency

Debit Memo Item

Debit Memo Item > Amount Without Tax

For debit memos created from charges and bill runs: The earlier of:

• Debit Memo > Posted Date

• Debit Memo > Memo Date

Debit Memo > Currency

Debit Taxation Item

Debit Taxation Item > Tax Amount

Debit Taxation Item > Exempt Amount

For debit memos created from charges and bill runs: The earlier of:

• Debit Memo > Posted Date

• Debit Memo > Memo Date

Debit Memo > Currency

Payment Application

Payment Application > Apply Amount

The earlier of:

• Payment > Effective Date

• Payment > Created Date

Payment > Currency

Payment Application Item

Payment Application Item > Amount

The earlier of:

• Payment > Effective Date

• Payment > Created Date

Payment > Currency

Payment Part

Payment Part > Amount

The earlier of:

• Payment > Effective Date

• Payment > Created Date

Payment > Currency

Payment Part Item

Payment Part Item > Amount

The earlier of:

• Payment > Effective Date

• Payment > Created Date

Payment > Currency

Refund Application

Refund Application > Apply Amount

The earlier of:

• Refund > Refund Date

• Refund > Created Date

Refund > Currency

Refund Application Item

Refund Application Item > Amount

The earlier of:

• Refund > Refund Date

• Refund > Created Date

Refund > Currency

Refund Part

Refund Part > Refund Amount

The earlier of:

• Refund > Refund Date

• Refund > Created Date

Refund > Currency

Refund Part Item

Refund Part Item > Amount

The earlier of:

• Refund > Refund Date

• Refund > Created Date

Refund > Currency