Fields in the Accounts Receivable detail report
The fields that are included in the Accounts Receivable detail report
The following table describes the fields that are included in the Accounts Receivable detail report.
|
Field |
Description |
|---|---|
|
Customer Account Number |
Customer account number associated with the transaction. |
|
Customer Account Name |
Customer account name associated with the transaction. |
|
Customer Account Currency |
Currency of the customer account. Each customer account has only one currency. |
|
<Customer Account Segments> |
If you have configured any segments related to customer accounts, the segment names appear here as column headings. The segments are arranged in alphabetical order. See Fields supported by segments for information about which customer account fields are supported on segments. |
|
Home Currency |
Home currency used. |
|
Exchange Rate Date |
The date of the exchange rate used. |
|
Exchange Rate |
The exchange rate used. |
|
Transaction Date |
Date when the transaction occurred. |
|
Transaction Type |
Type of transaction, such as an invoice item or invoice item adjustment. |
|
Transaction Subtype |
Subtype of the transaction. See Transaction subtypes for more information. |
|
Transaction Number |
Transaction number, such as INV-00000001 for an invoice item. |
|
Transaction ID |
Unique system ID for the transaction. |
|
Transaction Amount |
Amount of the transaction. |
|
Transaction Amount (Home Currency) |
Transaction amount in your home currency. |
|
Transaction Amount Currency Rounding |
The discrepancy caused by rounding the transaction amount during currency conversion. Accurate to nine decimal places. |
|
Debit Accounting Code |
Accounting code that was debited. |
|
Debit Amount |
Amount that was debited. |
|
Debit Amount (Home Currency) |
Debit amount in your home currency. |
|
Debit Amount Currency Rounding |
The discrepancy caused by rounding the debit amount during currency conversion. Accurate to nine decimal places. |
|
Credit Accounting Code |
Accounting code that was credited. |
|
Credit Amount |
Amount that was credited. |
|
Credit Amount (Home Currency) |
Credit amount in your home currency. |
|
Credit Amount Currency Rounding |
The discrepancy caused by rounding the credit amount during currency conversion. Accurate to nine decimal places. |
|
Accounts Receivable Accounting Code |
Accounting code for Accounts Receivable. |
|
Accounts Receivable Accounting Code Balance Impact |
Impact on the balance of your Accounts Receivable accounting code. |
|
Accounts Receivable Accounting Code Balance Impact (Home Currency) |
Accounts Receivable Accounting Code Balance Impact in your home currency. |
|
Accounts Receivable Accounting Code Balance Impact Currency Rounding |
The discrepancy caused by rounding the Accounts Receivable Accounting Code Balance Impact amount during currency conversion. Accurate to nine decimal places. |
|
Credit Balance Accounting Code |
Accounting code for Credit Balance. |
|
Credit Balance Accounting Code Balance Impact |
Impact on the balance of your Credit Balance accounting code. |
|
Credit Balance Accounting Code Balance Impact (Home Currency) |
Credit Balance Accounting Code Balance Impact in your home currency. |
|
Credit Balance Accounting Code Balance Impact Currency Rounding |
The discrepancy caused by rounding the Credit Balance Accounting Code Balance Impact amount during currency conversion. Accurate to nine decimal places. |
|
Account Balance Impact |
Impact on the balance of the customer account. Account Balance Impact in your home currency. |
|
Account Balance Impact (Home Currency) | |
|
Account Balance Impact Currency Rounding |
The discrepancy caused by rounding the Account Balance Impact amount during currency conversion. Accurate to nine decimal places. |
|
Transaction Service Period Start |
The Transaction Service Period Start and End dates are based on the transaction type. For example, for an invoice item, the dates are based on the service start and end dates of that invoice item. |
|
Transaction Service Period End | |
|
Associated Transaction Type |
Type of the associated transaction. See Associated transaction types and Associated transaction types: Invoice Settlement for more information. |
|
Associated Transaction Subtype |
Subtype of the associated transaction. See Transaction subtypes for more information. |
|
Associated Transaction ID |
ID of the associated transaction. |
|
Associated Transaction Number |
Number of the associated transaction. |
|
<Transaction Segments> |
If you have configured any segments related to transactions, the segment names appear here as column headings. The segments are arranged in alphabetical order. See Fields supported by segments for information about which fields are supported on segments. |
|
Container Transaction Type |
Type of the container transaction. See Transaction types for more information. |
|
Container Transaction Subtype |
Subtype of the container transaction. See Transaction types for more information. |
|
Container Transaction ID |
ID of the container transaction. |
|
Container Transaction Number |
Number of the container transaction. |
|
Product |
Name of the product. |
|
Product Rate Plan |
Name of the product rate plan. |
|
Product Rate Plan Charge |
Name of the product rate plan charge. |
|
<Product Segments> |
If you have configured any segments related to products, the segment names appear here as column headings. The segments are arranged in alphabetical order. See Fields supported by segments for information about which product fields are supported on segments. |
|
Subscription Name |
Name of the subscription. |
|
Subscription Rate Plan Charge ID |
ID of the subscription rate plan charge. |
|
<Subscription Segments> |
If you have configured any segments related to subscriptions, the segment names appear here as column headings. The segments are arranged in alphabetical order. See Fields supported by segments for information about which subscription fields are supported on segments. |