| iiCompanyId | integer | Company id |
| iiCreditorID | integer | |
| iiFromPeriodYearPeriod | integer | |
| iiCurrencyID | integer | |
| icCompanyCode | character | |
| icCreditorCode | character | |
| icCurrencyCode | character |
each CInvoice where
each CInvoiceMovement (inner-join) where
first PostingLine (inner-join) where
first Posting (inner-join) where
first Journal (inner-join) where
first Company (inner-join) where
first Creditor (inner-join) where
first Currency (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCInvoiceCurrency_ID | integer | CInvoice.CInvoiceCurrency_ID | Currency Code |
| ttCInvoiceDate | date | CInvoice.CInvoiceDate | Invoice Date. This field indicates the invoice creation date. The system uses this field with the credit terms to calculate due date and discount date. |
| api annotation: | This field defaults from the system date. | ||
| 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. |
| tcCInvoiceMovementType | character | CInvoiceMovement.CInvoiceMovementType | CInvoiceMovementType. "Initial" indicates that the movement represents the initial creation of the invoice, "movement" stands for all subsequent modifications of the invoice balance (payments, adjustments etc). |
| tiCInvoiceMovementYearPeriod | integer | CInvoiceMovement.CInvoiceMovementYearPeriod | Year/GL Period. This field indicates the accounting year and period for the invoice's movement. |
| 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. |
| ttCInvoiceTaxPointDate | date | CInvoice.CInvoiceTaxPointDate | Tax Point Date.This field indicates the date to be used in tax calculations. |
| api annotation: | This field defaults from the posting date. | ||
| 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. |
| tdCInvoiceVatCreditTC | decimal | CInvoice.CInvoiceVatCreditTC | TC Tax Amount CR. This field displays the credit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| tdCInvoiceVatDebitTC | decimal | CInvoice.CInvoiceVatDebitTC | TC Tax Amount DR. This field displays the debit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| tiCompany_ID | integer | CInvoice.Company_ID | Link to Company |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiCostCentre_ID | integer | PostingLine.CostCentre_ID | Cost Center Code |
| tiCreditor_ID | integer | CInvoice.Creditor_ID | Link to Creditor |
| tcCreditorCode | character | Creditor.CreditorCode | Supplier Code |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiDivision_ID | integer | PostingLine.Division_ID | Sub-Account Code |
| tiGL_ID | integer | PostingLine.GL_ID | GL Description |
| tiJournal_ID1 | integer | Posting.Journal_ID | Daybook Code |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tiPeriod_ID | integer | CInvoiceMovement.Period_ID | Link to Period |
| tiPosting_ID | integer | PostingLine.Posting_ID | Link to Posting |
| tiPostingLine_ID | integer | CInvoiceMovement.PostingLine_ID | Link to PostingLine |
| tdPostingLineCreditCC | decimal | PostingLine.PostingLineCreditCC | SC Credit |
| api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLinCreditTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, you should enter the correct value for this field | ||
| tdPostingLineCreditLC | decimal | PostingLine.PostingLineCreditLC | BC Credit |
| api annotation: | Partial Update = yes - it will get a default value depends on the value of PostingLineCreditTC, PostingLineExchangeRate & PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update is false, enter a value for this field. | ||
| tdPostingLineCreditTC | decimal | PostingLine.PostingLineCreditTC | TC Credit |
| tdPostingLineDebitCC | decimal | PostingLine.PostingLineDebitCC | SC Debit |
| api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, enter the correct value for this field. | ||
| tdPostingLineDebitLC | decimal | PostingLine.PostingLineDebitLC | BC Debit |
| api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineExchangeRate and PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update = false, enter the correct value into this field. | ||
| tdPostingLineDebitTC | decimal | PostingLine.PostingLineDebitTC | TC Debit |
| tiPostingVoucher | integer | Posting.PostingVoucher | Voucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code). |
| api annotation: | In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record. | ||
| tiProject_ID | integer | PostingLine.Project_ID | Description |
QadFinancials