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. 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. |