| iiCompanyId | integer | Company id |
| iiDInvoiceId | integer | |
| ilDInvoiceVatIsSuspDel | logical |
each DInvoice where
first CostCentre (conditional-join) where
each DInvoiceVat (inner-join) where
first Division (conditional-join) where
first Project (conditional-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCompany_ID | integer | DInvoice.Company_ID | Link to Company |
| tcCostCentreCode | character | CostCentre.CostCentreCode | Cost Center: A code that identifies the cost center. |
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| tdDInvoiceBalanceCreditTC | decimal | DInvoice.DInvoiceBalanceCreditTC | TC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency. |
| tdDInvoiceBalanceDebitTC | decimal | DInvoice.DInvoiceBalanceDebitTC | TC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency. |
| 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. |
| tdDInvoiceOriginalCreditTC | decimal | DInvoice.DInvoiceOriginalCreditTC | TC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same. |
| tdDInvoiceOriginalDebitTC | decimal | DInvoice.DInvoiceOriginalDebitTC | TC AP Amount. This field displays the debit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same. |
| 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. | ||
| 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 | ||
| tiDInvoiceVat_ID | integer | DInvoiceVat.DInvoiceVat_ID | Record ID |
| tdDInvoiceVatBaseCreditTC | decimal | DInvoice.DInvoiceVatBaseCreditTC | TC Base Amount CR. This field displays the credit base amount in the transaction currency. This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| tdDInvoiceVatBaseDebitTC | decimal | DInvoice.DInvoiceVatBaseDebitTC | TC Base Amount DR. This field displays the debit base amount in the transaction currency. This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| 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. |
| tlDInvoiceVatIsSuspDel | logical | DInvoiceVat.DInvoiceVatIsSuspDel | CInvoiceVatIsSuspDel Tax line is for Suspended or Delayed tax. This is a parameter of the tax rate code in GTM. |
| api annotation: | PartialUpdate = yes - defaults to false | ||
| tlDInvoiceVatIsTaxable | logical | DInvoiceVat.DInvoiceVatIsTaxable | Taxable. This field indicates if the invoice is taxable. |
| api annotation: | This field defaults to true if the customer is taxable. | ||
| tdDInvoiceVatSuspDelTaxAmtTC | decimal | DInvoiceVat.DInvoiceVatSuspDelTaxAmtTC | Tax Amount on Delayed Account TC. This field display the tax amount in the delayed account of the invoice in Transaction currency. |
| tcDivisionCode | character | Division.DivisionCode | Sub-Account |
| tcProjectCode | character | Project.ProjectCode | Project |
QadFinancials