business logic query VoucherInvoiceHistoryForERSExp

Parameters

icDomainCode	character
icEDIBatchNumber	character
iiCompanyId	integer	Company id
icAddressTypeRemmitance	character

query condition

each vph_hist where

vph_hist.vph_domain = icDomainCode AND
vph_hist.vph__qadc02 = icEDIBatchNumber

first CInvoice (inner-join) where

CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = vph_hist.vph_cinvoice_id AND

first Address1 (inner-join) where

Address1.Address_ID = CInvoice.ShipToAddress_ID AND

first Creditor (inner-join) where

Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = CInvoice.Creditor_ID AND

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Creditor.BusinessRelation_ID AND

each Address2 (outer-join) where

Address2.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND

first AddressType (outer-join) where

AddressType.AddressType_ID = Address2.AddressType_ID AND
AddressType.AddressTypeCode = icAddressTypeRemmitance

first Currency (inner-join) where

Currency.Currency_ID = CInvoice.CInvoiceCurrency_ID AND

first Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = CInvoice.Journal_ID AND

first PaymentCondition (inner-join) where

PaymentCondition.PaymentCondition_ID = CInvoice.NormalPaymentCondition_ID AND

first Period (inner-join) where

Period.Company_Id = iiCompanyId AND
Period.Period_ID = CInvoice.Period_ID AND

first Reason (inner-join) where

Reason.Reason_ID = CInvoice.Reason_ID AND

query resultset tqVoucherInvoiceHistoryForERSExp

field name	data type	db field	description
tcAddressName	character	Address1.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.
tcAddressTypeCode	character	AddressType.AddressTypeCode	Address Type
tiCInvoice_ID	integer	CInvoice.CInvoice_ID	Record ID
tdCInvoiceBalanceCreditLC	decimal	CInvoice.CInvoiceBalanceCreditLC	BC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency. This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
tdCInvoiceBalanceCreditTC	decimal	CInvoice.CInvoiceBalanceCreditTC	TC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
tdCInvoiceBalanceDebitLC	decimal	CInvoice.CInvoiceBalanceDebitLC	BC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency. This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
tdCInvoiceBalanceDebitTC	decimal	CInvoice.CInvoiceBalanceDebitTC	TC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency.
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.
ttCInvoiceDiscountDueDate	date	CInvoice.CInvoiceDiscountDueDate	Discount Due Date.This field indicates the last date a discount applies, calculated by the system based on the credit terms and the invoice date. User can modify this field without affecting the credit terms.
ttCInvoiceDueDate	date	CInvoice.CInvoiceDueDate	Due Date.This field indicates the date when payment become due. This field can be modified without affecting the credit terms. This field is calculated by the system based on the credit terms and the invoice date.
tdCInvoiceExchangeRate	decimal	CInvoice.CInvoiceExchangeRate	Exchange Rate. The exchange rate used by the invoice. The BC Invoice Amount is calculated based on the exchange rate. If user modify the TC Invoice Amount, the BC invoice amount is automatically adjusted.
tdCInvoiceHoldAmountTC	decimal	CInvoice.CInvoiceHoldAmountTC	TC Hold Amount. This field displays the amount of the invoice total that is not to be paid. If this field is not blank, the hold amount is taken into account during payment processing. Hold amounts must be: For invoices or correction invoices: Less than the invoice total and greater than zero. For credit notes or correction credit notes: Greater than the document total and less than zero. The hold amount for a negative payment must always be set to zero.
tlCInvoiceIsInitialStatus	logical	CInvoice.CInvoiceIsInitialStatus	Initial Status. This field indicates if the invoice is in initial status.
	api annotation:		This field defaults from the Initial Status field of the Invoice status code.
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.
tlCInvoiceIsTaxable	logical	CInvoice.CInvoiceIsTaxable	Taxable. This field indicates if the invoice is taxable. This field defaults to true if the supplier is taxable.
tdCInvoiceNonDiscAmtLC	decimal	CInvoice.CInvoiceNonDiscAmtLC	BC Non-discount Amount. This field display the invoice amount without discount in base currency. This field is calculated by the system using the TC Non-discount Amount and the Exchange rate.
tdCInvoiceNonDiscAmtTC	decimal	CInvoice.CInvoiceNonDiscAmtTC	TC Non-discount Amount. This field display the invoice amount without discount in base currency.
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.
tdCInvoiceRateScale	decimal	CInvoice.CInvoiceRateScale	Scale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments.
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.
ttCInvoiceTaxPointDate	date	CInvoice.CInvoiceTaxPointDate	Tax Point Date.This field indicates the date to be used in tax calculations.
	api annotation:		This field defaults from the posting date.
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.
tiCompany_ID	integer	CInvoice.Company_ID	Link to Company
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcPaymentConditionCode	character	PaymentCondition.PaymentConditionCode	Credit Terms Code
tiPeriodPeriod	integer	Period.PeriodPeriod	GL Period
tiPeriodYear	integer	Period.PeriodYear	GL Calendar Year
tcReasonAllocationStatus	character	Reason.ReasonAllocationStatus	Allocation Status
tcRemitToAddressName	character	Address2.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.
tcvph__qadc02	character	vph_hist.vph__qadc02
tcvph_domain	character	vph_hist.vph_domain	Domain

Internal usage

QadFinancials

method BCInvoiceAPMatching.ApiGetCInvoiceAPMatchingDetails