| iiCompanyId | integer | Company id |
| iiCInvoicePostingYear | integer | Posting Year |
| iiCInvoiceVoucher | integer | Invoice Voucher |
| icJournalCode | character | Daybook code |
each CInvoice where
first Currency (inner-join) where
first Journal (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCInvoice_ID | integer | CInvoice.CInvoice_ID | Record ID |
| tdCInvoiceCCRate | decimal | CInvoice.CInvoiceCCRate | SC Rate. The statutory exchange rate used by the invoice. The SC Invoice Amount is calculated based on the SC rate. |
| tdCInvoiceCCScale | decimal | CInvoice.CInvoiceCCScale | Scale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments. |
| tdCInvoiceExchangeRate | decimal | CInvoice.CInvoiceExchangeRate | Exchange Rate. The 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. |
| tlCInvoiceIsExternal | logical | CInvoice.CInvoiceIsExternal | External. This field indicates if the daybook used is external. This field is calculated by the system using the daybook code. |
| ttCInvoicePostingDate | date | CInvoice.CInvoicePostingDate | Posting Date. This filed indicates the date on which the invoice is to be posted. |
| api annotation: | This field defaults from the invoice creation date. | ||
| tiCInvoicePostingYear | integer | CInvoice.CInvoicePostingYear | 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. | ||
| tdCInvoiceRateScale | decimal | CInvoice.CInvoiceRateScale | Scale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. |
| tiCInvoiceVoucher | integer | CInvoice.CInvoiceVoucher | Voucher. This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is changed (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. |
| tiCompany_ID | integer | CInvoice.Company_ID | Link to Company |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
QadFinancials
QadFitnesse