| field name | data type | description |
|---|---|---|
| tcCurrencyCode | character | Currency Code |
| tcDebtorCode | character | Customer 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. | |
| 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. | |
| 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). |
| tiDInvoiceVoucher | integer | Voucher of debtor invoice |
| 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. | |
| tcDDocumentType | character | Payment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank. |
| tdDDocumentRateScale | decimal(10) | Scale Factor. This field indicates the scaling factor applying to the transaction currency. |
| tdDDocumentExchangeRate | decimal(10) | Exchange Rate. This field holds the exchange rate applying to the transaction currency. |
| tiDDocumentYear | integer | Year/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year. |
| tiDDocumentNumber | integer | Document Number. This field hold a unified number for report use. |
| ttDDocumentCreationDate | date | Creation Date.This field indicate the payment creation date. This field is read-only. |
| tdDDocumentInvoiceXrefDiscTC | decimal(4) | TC Discount Amount. This field indicates the discount amount of the invoice already allocated by transaction currency. |
| tdDDocumentInvoiceXrefAlloTC | decimal(4) | TC Allocated Amount. This field indicates the invocie amount already Allocated in transaction currency. |
| tcDInvoiceOpInfoCode | character | Identifier. This field identifies an opinfo record. |
| tdDInvoiceOriginalDebitTC | decimal(4) | Original Debit TC Amount |
| tdDInvoiceOriginalCreditTC | decimal(4) | Original Credit TC Amount |
| 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 | |
| tcJournalCode | character | Daybook Code |
| tdDInvoiceExchangeRateScale | decimal(10) | |
| tdDInvoiceExchangeRate | decimal(10) | Exchange Rate of Debtor Invoice |
| tcCurrencyCode2 | character |
QadFinancials