| iiCompanyId | integer | Company id |
| iiCInvoiceID | integer |
each CInvoice where
first CostCentre (outer-join) where
first Currency (inner-join) where
first Division (outer-join) where
first GL (inner-join) where
first Journal (inner-join) where
first Project (outer-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tdCInvoiceBalanceTC | decimal | CInvoice.CInvoiceBalanceTC | Balance. This field displays the sum of the debit and credit amounts of all posting lines in transaction currency. |
| tlCInvoiceIsERS | logical | CInvoice.CInvoiceIsERS | ERS: This field indicates if the invoice is created using Evaluated Receipts Settlement (ERS) functions. |
| tiCreditor_ID | integer | CInvoice.Creditor_ID | Link to Creditor |
| tiCInvoice_ID | integer | CInvoice.CInvoice_ID | Record ID |
| 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. |
| tcCInvoiceBatchNumber | character | CInvoice.CInvoiceBatchNumber | Batch Number. This field is used to identify a group of supplier invoices created at one time using Evaluated Receipts Settlement (ERS) functions. |
| 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. | ||
| tiCInvoicePostingPeriod | integer | CInvoice.CInvoicePostingPeriod | GL Period.This field indicates the period when the invoice to be posted. If this field is modified, the posting and tax dates are changed correspondingly. |
| api annotation: | This field defaults to the period associated with the posting date. | ||
| tcCInvoiceAllocationStatus | character | CInvoice.CInvoiceAllocationStatus | Allocation Status.This field indicates whether postings occur and if they affect transient or official layers. User can not delete an invoice which has a non-initial invoice status code. |
| tlCInvoiceIsLogisticMatching | logical | CInvoice.CInvoiceIsLogisticMatching | Receiver Matching.This field indicates If the Receiver Matching function is enabled. This field is calculated by the system using the invoice status code. |
| tcCInvoiceType | character | CInvoice.CInvoiceType | Invoice Type. This field identifies the invoice type. The value can be Invoice Correction and Credit Note Correction type only when the appropriate daybook types have already been defined. |
| 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. |
| tdCInvoiceRateScale | decimal | CInvoice.CInvoiceRateScale | Scale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. |
| tcCInvoiceReference | character | CInvoice.CInvoiceReference | Reference. An alphanumeric reference to help identify the invoice in the system. This reference is typically the ID number of the invoice received from the supplier. |
| tiJournal_ID | integer | CInvoice.Journal_ID | Daybook Code |
| tiDivision_ID | integer | CInvoice.Division_ID | Sub-Account |
| tiCInvoiceCurrency_ID | integer | CInvoice.CInvoiceCurrency_ID | Currency Code |
| tiControlGL_ID | integer | CInvoice.ControlGL_ID | Account |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tcDivisionCode | character | Division.DivisionCode | Sub-Account |
| tcCostCentreCode | character | CostCentre.CostCentreCode | Cost Center: A code that identifies the cost center. |
| tcGLCode | character | GL.GLCode | A code identifying the GL account. |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tcProjectCode | character | Project.ProjectCode | Project |
| tiProject_ID | integer | Project.Project_ID | Record ID |
QadFinancials