business logic query 1099Invoices (distinct)

Parameters

iiCompanyId	integer	Company id
iiPaymentYear	integer
iiCreditorID	integer
iiLiableCompanyID	integer

query condition

each CInvoice where

CInvoice.Company_Id = iiCompanyId AND
CInvoice.Creditor_ID = iiCreditorID

each CDocumentInvoiceXref (inner-join) where

CDocumentInvoiceXref.CInvoice_ID = CInvoice.CInvoice_ID AND

first CDocument (inner-join) where

CDocument.CDocument_ID = CDocumentInvoiceXref.CDocument_ID AND
CDocument.CDocumentYear = iiPaymentYear and
CDocument.CDocumentStatus = 'PAID' and
CDocument.Company_ID = iiLiableCompanyID

first PurchaseType (conditional-join) where

PurchaseType.PurchaseType_ID = CInvoice.PurchaseType_ID AND

query resultset tq1099Invoices

field name	data type	db field	description
tiCCollection_ID	integer	CDocument.CCollection_ID	Link to CCollection
tiCDocument_ID	integer	CDocumentInvoiceXref.CDocument_ID	Link to CDocument
tdCDocumentOriginalCreditLC	decimal	CDocument.CDocumentOriginalCreditLC	BC Original Credit.This field holds the amount of the Payment in baisc currency.
tcCDocumentStatus	character	CDocument.CDocumentStatus	Status. The payment status. The default value for a new record is Initial.
tiCDocumentYear	integer	CDocument.CDocumentYear	Year/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year.
tiCInvoice_ID	integer	CInvoice.CInvoice_ID	Record ID
tiCompany_ID	integer	CInvoice.Company_ID	Link to Company
tiCreditor_ID	integer	CInvoice.Creditor_ID	Link to Creditor
tiPurchaseType_ID	integer	CInvoice.PurchaseType_ID	Purchase Type
tiPurchaseType_ID2	integer	PurchaseType.PurchaseType_ID	Record ID
tcPurchaseTypeCode	character	PurchaseType.PurchaseTypeCode	Purchase Type

Internal usage

QadFinancials

method B1099MiscellaneousReport.GetReportData