| iiCompanyId | integer | Company id |
| iiFromPeriodYearPeriod | integer | |
| icCompanyCode | character | |
| iiDebtorID | integer | |
| icDebtorCode | character | |
| iiCurrencyID | integer | |
| icCurrencyCode | character |
each DInvoice where
first Company (inner-join) where
first Currency (inner-join) where
first Debtor (inner-join) where
each DInvoiceMovement (inner-join) where
first PostingLine (inner-join) where
first Posting (inner-join) where
first Journal (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 |
| tiCostCentre_ID | integer | PostingLine.CostCentre_ID | Cost Center Code |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiDebtor_ID | integer | DInvoice.Debtor_ID | Link to Debtor |
| tcDebtorCode | character | Debtor.DebtorCode | A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation. |
| api annotation: | If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create. | ||
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| tiDInvoiceCurrency_ID | integer | DInvoice.DInvoiceCurrency_ID | Currency Code |
| tcDInvoiceDescription | character | DInvoice.DInvoiceDescription | Description. A brief description of the invoice. This field is mandatory. |
| 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. |
| tcDInvoiceMovementType | character | DInvoiceMovement.DInvoiceMovementType | 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). |
| tiDInvoiceMovementYearPeriod | integer | DInvoiceMovement.DInvoiceMovementYearPeriod | Year/GL Period. This field indicates the accounting year and period for the invoice's movement. |
| 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. | ||
| ttDInvoiceTaxPointDate | date | DInvoice.DInvoiceTaxPointDate | Tax Point Date. The date to be used in tax calculations. For sales-related invoices, this field displays the tax calculation date on the associated order. |
| api annotation: | This field defaults to DInvoicePostingDate. | ||
| tcDInvoiceType | character | DInvoice.DInvoiceType | Invoice Type. This field displays the invoice type. Invoice Correction and Credit Note Correction display as choices only when the appropriate daybook types have already been defined. |
| api annotation: | PartialUpdate = yes - defaults to Invoice | ||
| tdDInvoiceVatCreditTC | decimal | DInvoice.DInvoiceVatCreditTC | 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. |
| tdDInvoiceVatDebitTC | decimal | DInvoice.DInvoiceVatDebitTC | 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. |
| 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 |
| tcJournalCode1 | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tiPeriod_ID | integer | DInvoiceMovement.Period_ID | Link to Period |
| tiPosting_ID | integer | PostingLine.Posting_ID | Link to Posting |
| tiPostingLine_ID | integer | DInvoiceMovement.PostingLine_ID | Link to PostingLine |
| tiPostingLine_ID2 | integer | PostingLine.PostingLine_ID | Record ID |
| 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