| iiCompanyId | integer | Company id |
| iiDInvoice_ID | integer |
each DInvoice where
| field name | data type | db field | description |
|---|---|---|---|
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| tdDInvoiceCCRate | decimal | DInvoice.DInvoiceCCRate | SC Rate. The statutory exchange rate used by the invoice. The SC Invoice Amount is calculated based on the SC rate. |
| tdDInvoiceCCScale | decimal | DInvoice.DInvoiceCCScale | Scale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments. |
| tdDInvoiceExchangeRate | decimal | DInvoice.DInvoiceExchangeRate | Exchange Rate. The accounting exchange rate used by the invoice. The BC Invoice Amount is calculated based on the exchange rate. If user modify the TC Invoice Amount, the BC invoice amount is automatically adjusted. |
| tdDInvoiceOriginalCreditCC | decimal | DInvoice.DInvoiceOriginalCreditCC | SC Invoice Amount (CR). This field displays the credit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate. |
| tdDInvoiceOriginalCreditLC | decimal | DInvoice.DInvoiceOriginalCreditLC | BC Invoice Amount(CR). This field displays the credit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(CR) and the Exchange rate. |
| tdDInvoiceOriginalCreditTC | decimal | DInvoice.DInvoiceOriginalCreditTC | TC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same. |
| tdDInvoiceOriginalDebitCC | decimal | DInvoice.DInvoiceOriginalDebitCC | SC Invoice Amount (DR). This field displays the debit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate. |
| tdDInvoiceOriginalDebitLC | decimal | DInvoice.DInvoiceOriginalDebitLC | BC Invoice Amount(DR). This field displays the debit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(DR) and the Exchange rate. |
| tdDInvoiceOriginalDebitTC | decimal | DInvoice.DInvoiceOriginalDebitTC | TC AP Amount. This field displays the debit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same. |
| tdDInvoiceRateScale | decimal | DInvoice.DInvoiceRateScale | Scale Factor.This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. The exchange rate is multiplied by the scale factor to determine the actual exchange rate. |
| api annotation: | The value for the scale factor defaults from the exchange rate definition, but it can be modified. |
QadFinancials