project QadFinancials > class BDDocument > business logic query DDocumentXrefByDPaySelID


Parameters


iiCompanyIdintegerCompany id
iiDPaySel_IDinteger


query condition


  each DDocument where
DDocument.Company_Id = iiCompanyId AND
DDocument.DPaySel_ID = iiDPaySel_ID

      each DDocumentInvoiceXref (inner-join) where
DDocumentInvoiceXref.DDocument_ID = DDocument.DDocument_ID AND


query resultset tqDDocumentXrefByDPaySelID


field namedata typedb fielddescription
ttDDocumentDueDatedateDDocument.DDocumentDueDateDue Date. The date on which the payment is receivable.
tiDDocumentInvoiceXref_IDintegerDDocumentInvoiceXref.DDocumentInvoiceXref_IDRecord ID
tdDDocumentInvoiceXrefAlloTCdecimalDDocumentInvoiceXref.DDocumentInvoiceXrefAlloTCTC Allocated Amount. This field indicates the invocie amount already Allocated in transaction currency.
tdDDocumentInvoiceXrefDiscTCdecimalDDocumentInvoiceXref.DDocumentInvoiceXrefDiscTCTC Discount Amount. This field indicates the discount amount of the invoice already allocated by transaction currency.
tdDDocumentInvoiceXrefIntTCdecimalDDocumentInvoiceXref.DDocumentInvoiceXrefIntTCTC Interest Amount
tdDDocumentInvoiceXrefPaidAmtTCdecimalDDocumentInvoiceXref.DDocumentInvoiceXrefPaidAmtTCTC Paid Amount
tdDDocumentOriginalCreditBCdecimalDDocument.DDocumentOriginalCreditBCBC Original Credit
tdDDocumentOriginalCreditCCdecimalDDocument.DDocumentOriginalCreditCCSC Original Credit. This field hold the amount of the payment in management currency.
tdDDocumentOriginalCreditLCdecimalDDocument.DDocumentOriginalCreditLCBC Original Credit.This field holds the amount of the Payment in baisc currency.
tdDDocumentOriginalCreditTCdecimalDDocument.DDocumentOriginalCreditTCTC Original Credit. This field holds the debit value of the payment in transaction currency.
tdDDocumentOriginalDebitBCdecimalDDocument.DDocumentOriginalDebitBCBC Original Debit
tdDDocumentOriginalDebitCCdecimalDDocument.DDocumentOriginalDebitCCTC Original Debit. This field holds the debit value of the payment in management currency.
tdDDocumentOriginalDebitLCdecimalDDocument.DDocumentOriginalDebitLCTC Original Debit. This field holds the debit value of the payment in base currency.
tdDDocumentOriginalDebitTCdecimalDDocument.DDocumentOriginalDebitTCAmount.This field hold the value of the payment in the transaction currency. This field must be positive and can be entered manually or automatically by linking the payment to an open item.
tcDDocumentStatuscharacterDDocument.DDocumentStatusStatus. The payment status. The default value for a new record is Initial.
tcDDocumentTypecharacterDDocument.DDocumentTypePayment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank.
tiDDocumentYearintegerDDocument.DDocumentYearYear/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year.
tiDInvoice_IDintegerDDocumentInvoiceXref.DInvoice_IDLink to DInvoice


Internal usage


QadFinancials
method BDPaymentSelection.GetDDocumentInfo