business logic query GetAmountByPayment

Description

Get Discount and Allocated Amout by payment

iiCompanyId	integer	Company id
iiCDocumentID	integer

each CDocument where

CDocument.CDocument_ID = iiCDocumentID AND
CDocument.Company_ID > 0

each CDocumentInvoiceXref (inner-join) where

CDocumentInvoiceXref.CDocument_ID = CDocument.CDocument_ID AND

first CInvoice (inner-join) where

CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = CDocumentInvoiceXref.CInvoice_ID AND

field name	data type	db field	description
tiCDocumentInvoiceXref_ID	integer	CDocumentInvoiceXref.CDocumentInvoiceXref_ID	Record ID
tdCDocumentInvoiceXrefAlloTC	decimal	CDocumentInvoiceXref.CDocumentInvoiceXrefAlloTC	TC Allocated Amount. This field indicates the invocie amount already Allocated in transaction currency.
tdCDocumentInvoiceXrefDiscTC	decimal	CDocumentInvoiceXref.CDocumentInvoiceXrefDiscTC	TC Discount Amount. This field indicates the discount amount of the invoice already allocated by transaction currency.
tcCInvoiceType	character	CInvoice.CInvoiceType	Invoice Type. This field identifies the invoice type. The value can be Invoice Correction and Credit Note Correction type only when the appropriate daybook types have already been defined.

QadFinancials