| iiCompanyId | integer | Company id |
| iiDInvoiceId | integer | ID of the Customer Invoice |
each DInvoice where
first Company (inner-join) where
each CompanySharedSet (inner-join) where
first SharedSet (inner-join) where
first DomainProperty (inner-join) where
first Currency (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCompany_ID | integer | DInvoice.Company_ID | Link to Company |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| 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. |
| tiDInvoiceCurrency_ID | integer | DInvoice.DInvoiceCurrency_ID | Currency Code |
| 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. |
| ttDInvoicePostingDate | date | DInvoice.DInvoicePostingDate | Posting Date. This field displays the date the sales-related invoice was generated by Invoice Post and Print. This field is updated when the invoice is validated and saved. |
| api annotation: | This field defaults from the invoice creation date. | ||
| tiDInvoicePostingYear | integer | DInvoice.DInvoicePostingYear | Year.This field indicates the accounting year for the invoice. If you modify these fields, the posting and tax dates are changed correspondingly. |
| api annotation: | This field defaults to the accounting year associated with the posting date. | ||
| 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. | ||
| tiDInvoiceVoucher | integer | DInvoice.DInvoiceVoucher | Voucher.This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is charged(after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field. |
| tiDivision_ID | integer | DInvoice.Division_ID | Sub-Account |
| tiExchangeRateSharedSet_ID | integer | SharedSet.SharedSet_ID | Record ID |
| tiLCCurrency_ID | integer | DomainProperty.Currency_ID | Base Currency |
| tcSharedSetTypeCode | character | SharedSet.SharedSetTypeCode | Shared Set Type |
| tiStatutoryCurrency_ID | integer | DomainProperty.StatutoryCurrency_ID | Statutory Currency |
QadFinancials