project QadFinancials > class BCurrency > business logic query CurrencyPrim

Description

Prim query
= query that can be used to find the logical key based on the prim-key and vice-versa.


Parameters


icCurrencyCodecharacterCurrency Code
iiCurrency_IDintegerCurrency ID


query condition


  each Currency where
Currency.Currency_ID = iiCurrency_ID AND
Currency.CurrencyCode = icCurrencyCode


query resultset tqCurrencyPrim


field namedata typedb fielddescription
tiCurrency_IDintegerCurrency.Currency_IDRecord ID
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code


Internal usage


QadFinancials
method BCDocument.AdditionalUpdatesPostingCrossCy
method BCInvoice.DefaultValuesGeneralInfo
method BCInvoice.DefaultValuesWHTFees
method BCInvoice.GetWHTDescriptionAndCCExch
method BCompany.ApiSynchroniseCustom
method BCompanyProperty.PreValidateComponent
method BCompanyProperty.UpdateCompanyProperty
method BCountry.ApiLoadCountryCurrencyCode
method BCreditor.ApiLoadCreditor
method BCreditor.ApiLoadCreditorCalcCurrencyCode
method BCreditor.ApiLoadCreditorV01
method BCreditorBalance.RebuildHistoryValidateInputCheckDaemon
method BCreditorReport.CreditorWHTCertificate
method BCreditorReport.CreditorWithholdingTax
method BCreditorReport.SetDataItemsBasedOnFilterTT
method BCurrency.ApiStdMaintainTT
method BCurrency.ApiSynchronise
method BDDocument.CreateDDocumentHeader
method BDebtor.ApiLoadDebtor
method BDebtor.ApiLoadDebtorCalcCurrencyCode
method BDebtor.CalculateBalanceOpenItems
method BDebtorBalance.RebuildHistoryValidateInputCheckDaemon
method BDebtorReport.SetDataItemsBasedOnFilterTT
method BDInvoice.CreateDIPostingValidate
method BDInvoice.DefaultValuesGeneralInfo
method BDInvoice.DefaultValuesOwnVatNumber
method BDInvoice.ValidateComponentPre
method BDInvoice.ValidateComponentPreValidateVat
method BEmployee.ApiLoadEmployee
method BEmployee.ApiLoadEmployeeCalcCurrencyCode
method BExchangeRate.ApiGetAverageExchangeRate
method BExchangeRate.DataLoadByInput
method BExchangeRate.PreValidateComponent
method BFRWAnalysisCode.ValidateComponentPreFRWAnCodeElemDet
method BGL.ApiLoadGL
method BGL.ApiLoadGLCalcCurrencyCode
method BGLOpenItem.CreateUpdateGLOpenItemMov
method BGLOpenItemProcessor.GetPossibleOpenItemTransactions
method BGLOpenItemProcessor.GLOpenItemInitialization
method BPosting.AddPostingSub
method BJournalEntry.PostingLineGLUpdate
method BOpenItemAdjustment.OIAdjNewOpenItem
method BPaymentSelection.ApiGetPaySelInfo
method BPaymentSelection.ExportBEAbroad
method BPrepayment.PreValidateComponent
method BProject.ApiLoadProject
method BProject.ApiLoadProjectCalcCurrencyCode
method BProject.DataLoadByInput
method BProject.InitialValues
method BProjectReport.SetDataItemsBasedOnFilterTT
method BQCrossCyPosting.ApiProcessQCrossCyPosting
method BRevaluation.GetRevExchangeRateType
method BVATExportListing.ApiExportQuarterSum
method BVATExportListing.ApiExportYearlyVatBE
method BVATExportListing.ApiOmzetBelastingNL
method TConvertInstalNETXML.SetOutputData
method TExchangeRate.ApiGetExchangeRate
ApiGetAlternateKeyValues
read related business field(s) on tAPMatching.Currency_ID
read related business field(s) on tBankNumber.Currency_ID
read related business field(s) on tBankState.Currency_ID
read related business field(s) on tBankStateAlloc.Currency_ID
read related business field(s) on tBill.Currency_ID
read related business field(s) on tBudget.Currency_ID
read related business field(s) on tCashReport.Currency_ID
read related business field(s) on tCDocument.Currency_ID
read related business field(s) on tCInvoice.CInvoiceCurrency_ID
read related business field(s) on tCInvoice.VatCurrency_ID
read related business field(s) on tCompanyProperty.Currency_ID
read related business field(s) on tConsolidDump.Currency_ID
read related business field(s) on tCountry.Currency_ID
read related business field(s) on tCreditor.Currency_ID
read related business field(s) on tDDocument.Currency_ID
read related business field(s) on tDebtor.Currency_ID
read related business field(s) on tDInvoice.DInvoiceCurrency_ID
read related business field(s) on tDInvoice.VatCurrency_ID
read related business field(s) on tDomainProperty.Currency_ID
read related business field(s) on tDomainProperty.StatutoryCurrency_ID
read related business field(s) on tEmployee.Currency_ID
read related business field(s) on tExchangeRate.FromCurrency_ID
read related business field(s) on tExchangeRate.ToCurrency_ID
read related business field(s) on tExpNote.Currency_ID
read related business field(s) on tExpNoteLine.Currency_ID
read related business field(s) on tFACapital.Currency_ID
read related business field(s) on tGL.Currency_ID
read related business field(s) on tPayFormatType.Currency_ID
read related business field(s) on tPaySelPrepay.Currency_ID
read related business field(s) on tPostingLine.Currency_ID
read related business field(s) on tPostingVat.Currency_ID
read related business field(s) on tPostingVatDelay.Currency_ID
read related business field(s) on tProject.Currency_ID
read related business field(s) on tRevalGL.Currency_ID
read related business field(s) on tRevalRate.FromCurrency_ID
read related business field(s) on tRevalRate.ToCurrency_ID
read related business field(s) on tSysProperty.Currency_ID
read related business field(s) on tWHT.Currency_ID
read related business field(s) on tPostingWHT.Currency_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tCompanyProperty.Currency_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tAPMatching.Currency_ID
validate related business field(s) on tBankNumber.Currency_ID
validate related business field(s) on tBankState.Currency_ID
validate related business field(s) on tBankStateAlloc.Currency_ID
validate related business field(s) on tBill.Currency_ID
validate related business field(s) on tBudget.Currency_ID
validate related business field(s) on tCashReport.Currency_ID
validate related business field(s) on tCDocument.Currency_ID
validate related business field(s) on tCInvoice.CInvoiceCurrency_ID
validate related business field(s) on tCInvoice.VatCurrency_ID
validate related business field(s) on tFACapital.Currency_ID
validate related business field(s) on tConsolidDump.Currency_ID
validate related business field(s) on tCountry.Currency_ID
validate related business field(s) on tCreditor.Currency_ID
validate related business field(s) on tDDocument.Currency_ID
validate related business field(s) on tDebtor.Currency_ID
validate related business field(s) on tDInvoice.DInvoiceCurrency_ID
validate related business field(s) on tDInvoice.VatCurrency_ID
validate related business field(s) on tDomainProperty.Currency_ID
validate related business field(s) on tDomainProperty.StatutoryCurrency_ID
validate related business field(s) on tEmployee.Currency_ID
validate related business field(s) on tExchangeRate.FromCurrency_ID
validate related business field(s) on tExchangeRate.ToCurrency_ID
validate related business field(s) on tExpNote.Currency_ID
validate related business field(s) on tExpNoteLine.Currency_ID
validate related business field(s) on tProject.Currency_ID
validate related business field(s) on tGL.Currency_ID
validate related business field(s) on tPayFormatType.Currency_ID
validate related business field(s) on tPaySelPrepay.Currency_ID
validate related business field(s) on tPostingLine.Currency_ID
validate related business field(s) on tPostingVat.Currency_ID
validate related business field(s) on tPostingVatDelay.Currency_ID
validate related business field(s) on tRevalGL.Currency_ID
validate related business field(s) on tRevalRate.FromCurrency_ID
validate related business field(s) on tRevalRate.ToCurrency_ID
validate related business field(s) on tSysProperty.Currency_ID
validate related business field(s) on tWHT.Currency_ID
validate related business field(s) on tPostingWHT.Currency_ID

QadFitnesse
method BCompanyProperty.ApiUpdateARAPTaxDateProperties