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