Skip to main content
Skip table of contents

Rep_InvoiceDetailInfoView

New columns added to the view Rep_InvoiceDetailInfoView.

Column Name

Description

TRANSACTION_CURRENCY_COST

Line-level cost of Item, Misc, or Labor in Transaction Currency. If multi-currency is disabled, the value is displayed in the base currency as stored in R2.

TRANSACTION_CURRENCY_DISCOUNTED_AMOUNT

Line level discounted amount (post-discount and pre-tax) for item/labor lines from invoice, shown in Transaction Currency. If the invoice is a credit memo, the value appears as negative. If multi-currency is disabled, the value is displayed in the base currency as stored in R2.

TRANSACTION_CURRENCY_ID

Transaction Currency ID from Invoice Header. If multi-currency is false, the Currency ID will appear as blank.

TRANSACTION_TO_SITE_CURRENCY_RATE 

Currency conversion rate from Transaction to Site.
Transaction to Site Currency Conversion Rate
The currency conversion rate from Transaction to Site currency is pulled from the Order , where it is originally stored. The rate selected corresponds to the current date with the maximum effective date.
Example:
Site Currency: EUR
Transaction Currency: USD
Scenario 1:
If the Site to Transaction rate (EUR to USD) is defined as 0.40000000,
then the Transaction to Site rate is calculated as:
Transaction to Site Rate=1/0.40000000=2.5
Scenario 2:
If the Transaction to Site rate (USD to EUR) is directly defined as 2.5,
then the Transaction to Site rate remains:
Transaction to Site Rate=2.5

 If multi-currency is false, value is 1.

ORDER_HEADER_DEPARTMENT

Department tagged at Order level

TRANSACTION_CURRENCY_UNDISCOUNTED_AMOUNT

Line level undiscounted amount (pre-tax) for item/labor lines from invoice, shown in Transaction Currency. Credit memo values appear negative. If multi-currency is disabled, the value is displayed in the base currency as stored in R2.

TRANSACTION_CURRENCY_DISCOUNT_AMOUNT 

Line level discount amount for item/labor lines from invoice in Transaction Currency. Credit memo values appear negative. If multi-currency is disabled, the value is displayed in the base currency as stored in R2.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.