| field name | data type | description |
|---|---|---|
| ttDInvoiceDate | date | 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(4) | Original Credit TC Amount |
| tdDInvoiceOriginalDebitTC | decimal(4) | Original Debit TC Amount |
| tdDInvoiceExchangeRate | decimal(10) | Exchange Rate of Debtor Invoice |
| tdDInvoiceExchangeRateScale | decimal(10) | |
| tcCurrencyCode | character | Currency Code |
| tcDInvoiceSlsPsn4 | character | Salesperson 4.This field displays the salesperson specified on the order to receive commission and quota credit for the order. |
| api annotation: | The commission percentage defaults from the salesperson record. | |
| tcDInvoiceSlsPsn3 | character | Salesperson 3.This field displays the salesperson specified on the order to receive commission and quota credit for the order. |
| api annotation: | The commission percentage defaults from the salesperson record. | |
| tcDInvoiceSlsPsn2 | character | Salesperson 2.This field displays the salesperson specified on the order to receive commission and quota credit for the order. |
| api annotation: | The commission percentage defaults from the salesperson record. | |
| tcDInvoiceSlsPsn1 | character | Salesperson 1.This field displays the salesperson specified on the order to receive commission and quota credit for the order. |
| api annotation: | The commission percentage defaults from the salesperson record. | |
| tdDInvoiceComm4 | decimal(2) | Salesperson Commission. This field displays the commission percentage each salesperson receives. |
| api annotation: | For invoices posted from sales orders, this field defaults from the associated sales order. For manually created invoices, commission defaults from Salesperson Commission Detail, if rates have been defined for the customer; otherwise, from the salesperson record. | |
| tdDInvoiceComm3 | decimal(2) | Salesperson Commission. This field displays the commission percentage each salesperson receives. |
| api annotation: | For invoices posted from sales orders, this field defaults from the associated sales order. For manually created invoices, commission defaults from Salesperson Commission Detail, if rates have been defined for the customer; otherwise, from the salesperson record. | |
| tdDInvoiceComm2 | decimal(2) | Salesperson Commission. This field displays the commission percentage each salesperson receives. |
| api annotation: | For invoices posted from sales orders, this field defaults from the associated sales order. For manually created invoices, commission defaults from Salesperson Commission Detail, if rates have been defined for the customer; otherwise, from the salesperson record. | |
| tdDInvoiceComm1 | decimal(2) | Salesperson Commission. This field displays the commission percentage each salesperson receives. |
| api annotation: | For invoices posted from sales orders, this field defaults from the associated sales order. For manually created invoices, commission defaults from Salesperson Commission Detail, if rates have been defined for the customer; otherwise, from the salesperson record. | |
| tdDInvoiceMarginAmountTC | decimal(4) | Margin Amount. This field is not used in Financial's module. It is updated in Operational (Invoice post and print and is equal to Line total + discount amount - total extended cost). |
| tdDInvoiceSalesAmt | decimal(4) | Sales Amount. This field indicates the amount for which the salespersons should receive commission credit. This is normally the invoice total minus any non-commissioned charges such as freight or tax. |
| api annotation: | This defaults from the order and is the only field that can be modified in this tab. | |
| tcDInvoiceOpInfoCode | character | Identifier. This field identifies an opinfo record. |
| tcDebtorCode | character | Customer Code |
| tcDInvoiceType | character | 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 | |
| tiDInvoiceVoucher | integer | Voucher of debtor invoice |
| tcJournalCode | character | Daybook Code |
| tiDInvoicePostingYear | integer | 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. |
QadFinancials