NetSuite — Expense Report
These metrics will be used in the Analytics Currency (AC) fact folder, Base Currency (BC) fact folder and Transaction Currency (TC) fact folder in Subject Areas. Analytics currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be work order date to convert to analytics currency. Metrics in these folders will show amounts in their respective currencies.
Metrics
| Metric | Metric Definition |
|---|---|
| Accounting Book Credit Amount | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Accounting Book Credit Amount. |
| Accounting Book Debit Amount | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Accounting Book Debit Amount. |
| Accounting Line Credit Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Accounting Line Credit Amount in Transaction Currency. |
| Accounting Line Debit Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Accounting Line Debit Amount in Transaction Currency. |
| Credit Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Credit Amount in Analytics Currency. |
| Credit Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Credit Amount in Base Currency. |
| Credit Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Credit Amount in Transaction Currency. |
| Debit Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Debit Amount in Analytics Currency. |
| Debit Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Debit Amount in Base Currency. |
| Debit Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Debit Amount in Transaction Currency. |
| Gross Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Gross Amount in Analytics Currency. |
| Gross Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Gross Amount in Base Currency. |
| Gross Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Gross Amount in Transaction Currency. |
| Line Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Line Amount in Analytics Currency. |
| Line Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Line Amount in Base Currency. |
| Line Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Line Amount in Transaction Currency. |
| Linked Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Linked Amount in Analytics Currency. |
| Linked Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Linked Amount in Base Currency. |
| Linked Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Linked Amount in Transaction Currency. |
| Net Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Net Amount in Analytics Currency. |
| Net Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Net Amount in Base Currency. |
| Net Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Net Amount in Transaction Currency. |
| Paid Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Paid Amount in Analytics Currency. |
| Paid Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Paid Amount in Base Currency. |
| Paid Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Paid Amount in Transaction Currency. |
| Paid Line Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Paid Line Amount in Analytics Currency. |
| Paid Line Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Paid Line Amount in Base Currency. |
| Paid Line Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Paid Line Amount in Transaction Currency. |
| Tax Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Tax Amount in Analytics Currency. |
| Tax Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Tax Amount in Base Currency. |
| Tax Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Tax Amount in Transaction Currency. |
| Tax Line Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Tax Line Amount in Analytics Currency. |
| Tax Line Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Tax Line Amount in Base Currency. |
| Tax Line Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Tax Line Amount in Transaction Currency. |
| Total Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Total Amount in Analytics Currency. |
| Total Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Total Amount in Base Currency. |
| Total Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Total Amount in Transaction Currency. |
| Unpaid Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Unpaid Amount in Analytics Currency. |
| Unpaid Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Unpaid Amount in Base Currency. |
| Unpaid Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by Unpaid Amount in Transaction Currency. |
| Unpaid Line Amount in Analytics Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Unpaid Line Amount in Analytics Currency. |
| Unpaid Line Amount in Base Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Unpaid Line Amount in Base Currency. |
| Unpaid Line Amount in Transaction Currency | This derived metric describes a transaction under the NetSuite - Expense Report subject area. This specific attribute is derived by count of the Unpaid Line Amount in Transaction Currency. |