business logic query CInvoiceForMatchedReceipt

Parameters

icFromCreditorCode	character
icToCreditorCode	character
icFromInvoiceJournal	character
icToInvoiceJournal	character
iiInvoiceVoucher	integer
iiToInvoiceVoucher	integer
itFromPostingDate	date
itToPostingDate	date
icInvoiceReference	character
ilIsLogisticMatching	logical
itFromMatchingDate	date
itToMatchingDate	date
iiCompanyId	integer
itPostingDate	date
iiFromInvoiceVoucher	integer
iiCreditorID	integer
iiPeriod_ID	integer
iiJournal_ID	integer

query condition

each CInvoice where

CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoiceVoucher >= iiFromInvoiceVoucher AND
CInvoice.CInvoiceVoucher <= iiToInvoiceVoucher AND
CInvoice.CInvoicePostingDate >= itFromPostingDate AND
CInvoice.CInvoicePostingDate <= itToPostingDate AND
CInvoice.CInvoiceIsLogisticMatching = ilIsLogisticMatching AND
CInvoice.CInvoiceReference can-do icInvoiceReference AND
CInvoice.CInvoicePostingDate = itPostingDate AND
CInvoice.CInvoiceVoucher = iiInvoiceVoucher AND
CInvoice.Creditor_ID = iiCreditorID AND
CInvoice.Journal_ID = iiJournal_ID AND
CInvoice.Period_ID = iiPeriod_ID

each APMatching (conditional-join) where

APMatching.CInvoice_ID = CInvoice.CInvoice_ID AND
APMatching.APMatchingStatus = {&APMATCHINGSTATUS-FINISHED} AND
APMatching.Company_ID = CInvoice.Company_ID

each APMatchingLn (conditional-join) where

APMatchingLn.APMatching_ID = APMatching.APMatching_ID AND

each CInvoicePosting (inner-join) where

CInvoicePosting.CInvoice_ID = CInvoice.CInvoice_ID AND
CInvoicePosting.CInvoicePostingType = {&INVOICEPOSTINGTYPE-ALLOCATION}

first Posting (inner-join) where

Posting.Posting_ID = CInvoicePosting.Posting_ID AND
Posting.Company_ID = CInvoice1.Company_ID AND
Posting.PostingDate >= itFromMatchingDate AND
Posting.PostingDate <= itToMatchingDate

first Journal1 (inner-join) where

Journal1.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal1.Journal_ID = Posting.Journal_ID AND

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = CInvoice.Company_ID AND

each CompanyProperty (inner-join) where

CompanyProperty.Company_Id = iiCompanyId AND
CompanyProperty.Company_ID = Company.Company_ID AND

first Creditor (inner-join) where

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

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Creditor.BusinessRelation_ID AND

each Address (inner-join) where

Address.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND

first AddressType (inner-join) where

AddressType.AddressType_ID = Address.AddressType_ID AND
AddressType.AddressTypeCode = {&ADDRESSTYPECODESYSTEM-HEADOFFICE}

first Country (inner-join) where

Country.Country_ID = Address.Country_ID AND

first Currency (inner-join) where

Currency.Currency_ID = CInvoice.CInvoiceCurrency_ID AND

first Journal2 (inner-join) where

Journal2.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal2.Journal_ID = CInvoice.Journal_ID AND
Journal2.JournalCode >= icFromInvoiceJournal AND
Journal2.JournalCode <= icToInvoiceJournal

query resultset tqCInvoiceForMatchedReceipt

field name	data type	db field	description
tcAddressCity	character	Address.AddressCity	City. The city for this address. This field can be used to decide the tax zone of the address.
tcAddressCounty	character	Address.AddressCounty	Obsolete field
tcAddressName	character	Address.AddressName	Name. The full name of this particular address. The name of a headoffice address is the same as the name of the business relationship and can not be modified.
	api annotation:		PartialUpdate = yes - defaults to the name of the businessRelation.
tcAddressZip	character	Address.AddressZip	Zip. The postal code or US zip code associated with this address. This field is used to decide the tax zone for the address. This field can be blank.
ttAPMatchingDate	date	APMatching.APMatchingDate	Date
tiAPMatchingLn_ID	integer	APMatchingLn.APMatchingLn_ID	Record ID
tdAPMatchingLnMatchAmtLC	decimal	APMatchingLn.APMatchingLnMatchAmtLC	BC Matched Amount
tdAPMatchingLnMatchAmtTC	decimal	APMatchingLn.APMatchingLnMatchAmtTC	TC Matched Amount
tdAPMatchingLnMatchQty	decimal	APMatchingLn.APMatchingLnMatchQty	Matched Quantity
tdAPMatchingLnMatchUnitPrice	decimal	APMatchingLn.APMatchingLnMatchUnitPrice	Matched Unit Price
tcAPMatchingLnPvodCompCode	character	APMatchingLn.APMatchingLnPvodCompCode	APMatchingLnPvodCompCode
tcAPMatchingLnPvodGLCode	character	APMatchingLn.APMatchingLnPvodGLCode	Account (Pinv)
tcAPMatchingLnPvodIntRef	character	APMatchingLn.APMatchingLnPvodIntRef	Internal Ref
tcAPMatchingStatus	character	APMatching.APMatchingStatus	Status
tcBusinessRelationCode	character	BusinessRelation.BusinessRelationCode	Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tcBusinessRelationName	character	BusinessRelation.BusinessRelationName1	Name: The full name of the business relation. This field sets the default name for linked addresses such as customers and suppliers.
	api annotation:		PartialUpdate = yes - defaults to the BusinessRelationCode.
tiCInvoice_ID	integer	CInvoice.CInvoice_ID	Record ID
tcCInvoiceAllocationStatus	character	CInvoice.CInvoiceAllocationStatus	Allocation Status.This field indicates whether postings occur and if they affect transient or official layers. User can not delete an invoice which has a non-initial invoice status code.
tcCInvoiceCurrency	character	Currency.CurrencyCode	Currency Code
ttCInvoiceDate	date	CInvoice.CInvoiceDate	Invoice Date. This field indicates the invoice creation date. The system uses this field with the credit terms to calculate due date and discount date.
	api annotation:		This field defaults from the system date.
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.
tcCinvoiceJournal	character	Journal2.JournalCode	A daybook code (maximum eight characters).
tdCInvoiceOriginalCreditCC	decimal	CInvoice.CInvoiceOriginalCreditCC	SC Invoice Amount (CR). This field displays the credit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate.
tdCInvoiceOriginalCreditLC	decimal	CInvoice.CInvoiceOriginalCreditLC	BC Invoice Amount(CR). This field displays the credit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(CR) and the Exchange rate.
tdCInvoiceOriginalCreditTC	decimal	CInvoice.CInvoiceOriginalCreditTC	TC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same.
tdCInvoiceOriginalDebitCC	decimal	CInvoice.CInvoiceOriginalDebitCC	SC Invoice Amount (DR). This field displays the debit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate.
tdCInvoiceOriginalDebitLC	decimal	CInvoice.CInvoiceOriginalDebitLC	BC Invoice Amount(DR). This field displays the debit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(DR) and the Exchange rate.
tdCInvoiceOriginalDebitTC	decimal	CInvoice.CInvoiceOriginalDebitTC	TC AP Amount. This field displays the debit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same.
tcCInvoicePostingType	character	CInvoicePosting.CInvoicePostingType	Invoice 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.
tiCInvoicePostingYear	integer	CInvoice.CInvoicePostingYear	Year.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.
tcCInvoiceReference	character	CInvoice.CInvoiceReference	Reference. An alphanumeric reference to help identify the invoice in the system. This reference is typically the ID number of the invoice received from the supplier.
tiCInvoiceVoucher	integer	CInvoice.CInvoiceVoucher	Voucher. This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is changed (after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field.
tcCompanyCode	character	Company.CompanyCode	Entity Code
tiCompanyPropertyQtyNumDec	integer	CompanyProperty.CompanyPropertyQtyNumDec	Decimals for Qty
tiCountry_ID	integer	Country.Country_ID	Record ID
tcCountryCode	character	Country.CountryCode	Country Code
tcCountryDescription	character	Country.CountryDescription	Description
tcCreditorCode	character	Creditor.CreditorCode	Supplier Code
tiCurrencyNumberOfDecimals	integer	Currency.CurrencyNumberOfDecimals	Number of Decimals
tcMatchingType	character	calculated
ttPostingDate	date	Posting.PostingDate	The accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod).
tcPostingJournal	character	Journal1.JournalCode	A daybook code (maximum eight characters).
tiPostingVoucher	integer	Posting.PostingVoucher	Voucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code).
	api annotation:		In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record.
tiPostingYear	integer	Posting.PostingYear	The GL calendar year for the posting.
tiPvodLineID	integer	APMatchingLn.PvodLineID	Pinv Line ID
tcPvoDomain	character	APMatchingLn.PvoDomain	Domain
tiPvoID	integer	APMatchingLn.PvoID	Pinv ID

Internal usage

QadFinancials

method BAPMatchingReport.InvoiceMatching