| iiCompanyId | integer | Company id |
| itDInvoiceDate | date | DInvoice Date |
| icDInvoiceType | character | DInvoice Type |
| iiDebtorId | integer | Debtor ID |
| iiCurrencyId | integer | |
| idDInvoiceOriginalCreditTC | decimal | DInvoice Original Credit TC |
| idDInvoiceOriginalDebitTC | decimal | DInvoice Original Debit TC |
| iiDInvoiceId | integer | DInvoice ID |
| icSkipRowId | character | Skip Row ID |
| icDebtorCode | character | Customer Code |
| icCurrencyCode | character | Currency Code |
each DInvoice where
first Currency (inner-join) where
first Debtor (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| 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 |
| ttDInvoiceDate | date | DInvoice.DInvoiceDate | Invoice Date. This field indicates the invoice creation date.This field is normallly prior to the posting date and within the same accounting period as the posting date. The date must be within the upper and lower date limits of an open GL period. The system uses the invoice date with the credit terms to calculate due date and discount date. |
| api annotation: | This field defaults to the DInvoicePostingDate. | ||
| 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. |
| 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 |
QadFinancials