project QadFinancials > class BDInvoice > dataset tSalespersonPayments

table tSalespersonPayments


field namedata typedescription
tcCurrencyCodecharacterCurrency Code
tcDebtorCodecharacterCustomer Code
tcDInvoiceSlsPsn4characterSalesperson 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.
tcDInvoiceSlsPsn3characterSalesperson 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.
tcDInvoiceSlsPsn2characterSalesperson 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.
tcDInvoiceSlsPsn1characterSalesperson 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.
tdDInvoiceComm4decimal(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.
tdDInvoiceComm3decimal(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.
tdDInvoiceComm2decimal(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.
tdDInvoiceComm1decimal(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.
tdDInvoiceSalesAmtdecimal(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.
tdDInvoiceMarginAmountTCdecimal(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).
tiDInvoiceVoucherintegerVoucher of debtor invoice
tiDInvoicePostingYearintegerYear.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.
tcDDocumentTypecharacterPayment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank.
tdDDocumentRateScaledecimal(10)Scale Factor. This field indicates the scaling factor applying to the transaction currency.
tdDDocumentExchangeRatedecimal(10)Exchange Rate. This field holds the exchange rate applying to the transaction currency.
tiDDocumentYearintegerYear/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year.
tiDDocumentNumberintegerDocument Number. This field hold a unified number for report use.
ttDDocumentCreationDatedateCreation Date.This field indicate the payment creation date.
This field is read-only.
tdDDocumentInvoiceXrefDiscTCdecimal(4)TC Discount Amount. This field indicates the discount amount of the invoice already allocated by transaction currency.
tdDDocumentInvoiceXrefAlloTCdecimal(4)TC Allocated Amount. This field indicates the invocie amount already Allocated in transaction currency.
tcDInvoiceOpInfoCodecharacterIdentifier. This field identifies an opinfo record.
tdDInvoiceOriginalDebitTCdecimal(4)Original Debit TC Amount
tdDInvoiceOriginalCreditTCdecimal(4)Original Credit TC Amount
tcDInvoiceTypecharacterInvoice 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
tcJournalCodecharacterDaybook Code
tdDInvoiceExchangeRateScaledecimal(10)
tdDInvoiceExchangeRatedecimal(10)Exchange Rate of Debtor Invoice
tcCurrencyCode2character


Internal usage


QadFinancials
method BDInvoice.ApiGetSalespersonPayments