business logic query MatchedReceiptaByCreditor

Parameters

iiCompanyId	integer	Company id
ilCInvoiceIsOpen	logical
icCreditorType	character
icCurrencyCode	character
icFromCreditorCode	character
icToCreditorCode	character
itFromPostingDate	date
itToPostingDate	date
icPurchaseType	character

query condition

each Creditor where

Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.CreditorCode >= icFromCreditorCode AND
Creditor.CreditorCode <= icToCreditorCode

each CInvoice (inner-join) where

CInvoice.Company_Id = iiCompanyId AND
CInvoice.Creditor_ID = Creditor.Creditor_ID AND
CInvoice.CInvoicePostingDate >= itFromPostingDate AND
CInvoice.CInvoicePostingDate <= itToPostingDate AND
CInvoice.CInvoiceIsLogisticMatching = true AND
CInvoice.CInvoiceIsOpen = ilCInvoiceIsOpen AND
CInvoice.CInvoiceType <> {&INVOICETYPE-ADJUSTMENT} AND
CInvoice.CInvoiceType <> {&INVOICEtYPE-PREPAYMENT}

each APMatching (inner-join) where

APMatching.Company_Id = iiCompanyId AND
APMatching.CInvoice_ID = CInvoice.CInvoice_ID AND

each APMatchingLn (inner-join) where

APMatchingLn.APMatching_ID = APMatching.APMatching_ID AND

first pvod_det (inner-join) where

pvod_det.pvod_domain = APMatchingLn.PvoDomain AND
pvod_det.pvod_id = APMatchingLn.PvoID AND
pvod_det.pvod_id_line = APMatchingLn.PvodLineID AND

first pod_det (inner-join) where

pod_det.pod_domain = pvod_det.pvod_domain AND
pod_det.pod_line = pvod_det.pvod_order_line AND
pod_det.pod_nbr = pvod_det.pvod_order AND

each prh_hist (inner-join) where

prh_hist.prh_domain = pod_det.pod_domain AND
prh_hist.prh_line = pod_det.pod_line AND
prh_hist.prh_nbr = pod_det.pod_nbr AND
prh_hist.prh_receiver = APMatchingLn1.APMatchingLnPvodIntRef

first Currency (inner-join) where

Currency.Currency_ID = CInvoice.CInvoiceCurrency_ID AND
Currency.CurrencyCode = icCurrencyCode

first PurchaseType (conditional-join) where

PurchaseType.PurchaseType_ID = CInvoice.PurchaseType_ID AND
PurchaseType.PurchaseTypeCode can-do icPurchaseType

first CreditorType (conditional-join) where

CreditorType.CreditorType_ID = Creditor.CreditorType_ID AND
CreditorType.CreditorTypeCode can-do icCreditorType

query resultset tqMatchedReceiptaByCreditor

field name	data type	db field	description
tdAPMatchingLnMatchQty	decimal	APMatchingLn.APMatchingLnMatchQty	Matched Quantity
tdAPMatchingLnMatchUnitPrice	decimal	APMatchingLn.APMatchingLnMatchUnitPrice	Matched Unit Price
tcAPMatchingLnPvodIntRef	character	APMatchingLn.APMatchingLnPvodIntRef	Internal Ref
tiCInvoice_ID	integer	CInvoice.CInvoice_ID	Record ID
tlCInvoiceIsLogisticMatching	logical	CInvoice.CInvoiceIsLogisticMatching	Receiver Matching.This field indicates If the Receiver Matching function is enabled. This field is calculated by the system using the invoice status code.
tlCInvoiceIsOpen	logical	CInvoice.CInvoiceIsOpen	Open.This field indicates if the invoice has been completely paid. This field is updated automatically when complete payment is confirmed. This field is read-only.
	api annotation:		PartialUpdate = yes - defaults to true
ttCInvoicePostingDate	date	CInvoice.CInvoicePostingDate	Posting Date. This filed indicates the date on which the invoice is to be posted.
	api annotation:		This field defaults from the invoice creation date.
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.
tcCreditorCode	character	Creditor.CreditorCode	Supplier Code
tcCreditorTypeCode	character	CreditorType.CreditorTypeCode	Code
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcprh_curr	character	prh_hist.prh_curr	Currency
tdprh_curr_amt	decimal	prh_hist.prh_curr_amt	Currency Amt
tdprh_ex_rate	decimal	prh_hist.prh_ex_rate	Exch Rate
tdprh_ex_rate2	decimal	prh_hist.prh_ex_rate2	Exch Rate 2
tcprh_nbr	character	prh_hist.prh_nbr	Order
tcprh_part	character	prh_hist.prh_part	Item Number
tdprh_pur_cost	decimal	prh_hist.prh_pur_cost	PO Cost
tdprh_rcvd	decimal	prh_hist.prh_rcvd	Receipt Qty
tcprh_um	character	prh_hist.prh_um	UM
tcPurchaseTypeCode	character	PurchaseType.PurchaseTypeCode	Purchase Type

Internal usage

QadFinancials

method BCreditorReport.CInvoiceRegister