project QadFinancials > class BPeriod > business logic query PeriodPrim

Description

query that can be used find period based on the prim-key or based on the logical, unique key


Parameters


iiCompanyIdintegerCompany id
iiPeriodIdinteger
iiPeriodYearintegerYear of the period
iiPeriodPeriodinteger


query condition


  each Period where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = iiPeriodId AND
Period.PeriodYear = iiPeriodYear AND
Period.PeriodPeriod = iiPeriodPeriod


query resultset tqPeriodPrim


field namedata typedb fielddescription
tiCompany_IDintegerPeriod.Company_IDLink to Company
tiPeriod_IDintegerPeriod.Period_IDRecord ID
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period


Internal usage


QadFinancials
method BBankEntry.CalculateBankState
method BBankEntry.CreatePostingHeader
method BCInvoice.ValidateComponentPre
method BClosingPostingsReport.HistoryPostingsCheck
method BClosingPostingsReport.IsGLAutoBalClear
method BConCheck.AdditionalUpdates
method BConCheck.ValidateComponentPost
method BConsolid.CreateConsolidation
method BConsolidPeriodXref.ApiSetConsolidPeriods
method BConsolidPeriodXref.ValidateComponent
method BCreditorBalance.RebuildHistoryValidateInputCheckDaemon
method BCreditorBalance.UpdateCBalanceAndCHist
method BDebtorBalance.RebuildHistoryValidateInputCheckDaemon
method BDebtorBalance.UpdateDBalanceAndDHist
method BDInvoice.CreateDIPostingValidate
method BDInvoice.ValidateComponentPre
method BPosting.AdditionalUpdatesCreateQPostingLineN
method BJournalEntry.CreateRecEntryPosting
method BJournalEntry.CreateRecEntryPostingReverse
method BJournalEntry.CreateReplaceEntry
method BJournalEntry.CreateReverseEntry
method BJournalEntry.GetPostingInfoByPostingLineID
method BJournalEntry.GetPostingInfoByPostingLineIDTT
method BJournalEntryMultiCy.ApiCreateCrossCyPostingsApplyCCyValidations
method BJournalEntryMultiCy.ApiCreateJournalEntryPostingsApplyValidations
method BPeriod.ApiStdMaintainTT
method BPeriod.ApiUpdatePeriodStatus
method BPeriod.ApiValidateAccYear
method BPeriod.DataLoadByInput
method BPeriod.LoadAndUpdateInstanceData
method BPeriod.YearClosingClosePeriods
method BPeriod.YearClosingCreatePeriods
method BQPosting.ApiCreateQPostingLineSaf
read related business field(s) on tAPMatching.Period_ID
read related business field(s) on tBankState.Period_ID
read related business field(s) on tBankStateLine.Period_ID
read related business field(s) on tCashReport.TillPeriod_ID
read related business field(s) on tConCheck.Period_ID
read related business field(s) on tConsolid.FromPeriod_ID
read related business field(s) on tConsolid.ToPeriod_ID
read related business field(s) on tConsolidDump.FromPeriod_ID
read related business field(s) on tConsolidDump.ToPeriod_ID
read related business field(s) on tConsolidDump.OpeningPeriod_ID
read related business field(s) on tConsolidPeriodXref.Period_ID
read related business field(s) on tConsolidPeriodXref.ConsolidationPeriod_ID
read related business field(s) on tFAAsset.Period_ID
read related business field(s) on tRecEntryLine.Period_ID
read related business field(s) on tRevalHeader.Period_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tAPMatching.Period_ID
validate related business field(s) on tBankState.Period_ID
validate related business field(s) on tBankStateLine.Period_ID
validate related business field(s) on tCashReport.TillPeriod_ID
validate related business field(s) on tConCheck.Period_ID
validate related business field(s) on tConsolid.FromPeriod_ID
validate related business field(s) on tConsolid.ToPeriod_ID
validate related business field(s) on tConsolidDump.FromPeriod_ID
validate related business field(s) on tConsolidDump.ToPeriod_ID
validate related business field(s) on tConsolidDump.OpeningPeriod_ID
validate related business field(s) on tConsolidPeriodXref.Period_ID
validate related business field(s) on tFAAsset.Period_ID
validate related business field(s) on tRecEntryLine.Period_ID
validate related business field(s) on tRevalHeader.Period_ID