project QadFinancials > class BJournal > business logic query JournalPrim

Description

JournalPrim


Parameters


iiCompanyIdintegerCompany id
icJournalCodecharacter
iiJournalIDintegerJournalId


query condition


  each Journal where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = iiJournalID and
Journal.JournalCode = icJournalCode

      first Layer (inner-join) where
Layer.Layer_ID = Journal.Layer_ID AND


query resultset tqJournalPrim


field namedata typedb fielddescription
tiJournal_IDintegerJournal.Journal_IDRecord ID
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcJournalControlcharacterJournal.JournalControlA type of daybook control: Financial/Operational/External-used to clearly separate postings based on their source.
tcJournalDescriptioncharacterJournal.JournalDescriptionA brief description of the daybook.
api annotation:Value for this field defaults to null.
tcLayerCodecharacterLayer.LayerCodeLayer Code
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type
tiSharedSet_IDintegerJournal.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BAPMatching.GetJournalSequenceNumber
method BAPMatchingReport.SetDataItemsBasedOnFilterTT
method BBankEntry.CreatePostingHeader
method BCashBoxReport.CashPaid
method BCashBoxReport.CashReceived
method BCInvoice.ReplaceCInvoice
method BCMask.DataLoadByInputCMaskJournal
method BDDocument.ApiGetDInvoiceIdByUniqueIndexFields
method BDeductionCat.ValidateComponent
method BDInvoice.CreateDIPostingValidate
method BDInvoice.ValidateComponentAllSlspsn
method BDomain.AdditionalUpdatesReplication
method BFixedAssetDisposal.AdditionalUpdatesPosting
method BFRWAnalysisCode.ValidateComponentPreFRWAnCodeElemDet
method BGLOpenItemProcessor.GetPossibleOpenItemTransactions
method BJournal.ApiReplicateFromDaemon
method BJournal.ApiStdMaintainTT
method BPosting.AddPostingHeader
method BPosting.DataLoadByInput
method BPosting.GetPostingIDsForXLSIntegration
method BPosting.GetPostingNumber
method BPosting.MassReversePeriodicCostingPostings
method BJournalEntry.CreateRecEntryPosting
method BJournalEntry.CreateRecEntryPostingTemplate
method BJournalEntry.GetPostingAmountByPostingLineId
method BJournalEntryMultiCy.ApiCreateJournalEntryPostingsApplyValidations
method BPaymentSelection.FillProDataSetPayment
method BQCrossCyPosting.ValidateComponent
method BRecurringEntry.ApiPostRecEntryApplyFilter
method BRecurringEntry.ValidateComponent
method BTaxRegister.DataLoadByInput
method BVATReport.VATRegisterTran
method TJournalRole.CheckJournalRole
read related business field(s) on tAllocation.Journal_ID
read related business field(s) on tAPMatching.Journal_ID
read related business field(s) on tCDocumentStatus.Journal_ID
read related business field(s) on tCInvoice.Journal_ID
read related business field(s) on tCompanyProperty.ActCostPostingJournal_ID
read related business field(s) on tCompanyProperty.ActSalaryPostingJournal_ID
read related business field(s) on tConsolidCycleCompany.OfficialJournal_ID
read related business field(s) on tConsolidCycleCompany.ManagementJournal_ID
read related business field(s) on tConsolidCycleCompany.TransientJournal_ID
read related business field(s) on tDDocumentStatus.Journal_ID
read related business field(s) on tDeductionCatLine.ExpenseJournal_ID
read related business field(s) on tDeductionCatLine.RechargeJournal_ID
read related business field(s) on tDInvoice.Journal_ID
read related business field(s) on tFABookType.DepreciationJournal_ID
read related business field(s) on tFABookType.DisposalJournal_ID
read related business field(s) on tFABookType.RevaluationJournal_ID
read related business field(s) on tGrossIncAcc.Journal_ID
read related business field(s) on tPosting.ReportingJournal_ID
read related business field(s) on tRecEntry.Journal_ID
read related business field(s) on tYearClosing.ClosingTransferJournal_ID
read related business field(s) on tYearClosing.ClosingPLJournal_ID
read related business field(s) on tYearClosing.ClosingBalanceJournal_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
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 tAllocation.Journal_ID
validate related business field(s) on tAPMatching.Journal_ID
validate related business field(s) on tCDocumentStatus.Journal_ID
validate related business field(s) on tCInvoice.Journal_ID
validate related business field(s) on tCompanyProperty.ActCostPostingJournal_ID
validate related business field(s) on tCompanyProperty.ActSalaryPostingJournal_ID
validate related business field(s) on tConsolidCycleCompany.OfficialJournal_ID
validate related business field(s) on tConsolidCycleCompany.ManagementJournal_ID
validate related business field(s) on tConsolidCycleCompany.TransientJournal_ID
validate related business field(s) on tDDocumentStatus.Journal_ID
validate related business field(s) on tDeductionCatLine.ExpenseJournal_ID
validate related business field(s) on tDeductionCatLine.RechargeJournal_ID
validate related business field(s) on tDInvoice.Journal_ID
validate related business field(s) on tFABookType.DepreciationJournal_ID
validate related business field(s) on tFABookType.DisposalJournal_ID
validate related business field(s) on tFABookType.RevaluationJournal_ID
validate related business field(s) on tGrossIncAcc.Journal_ID
validate related business field(s) on tPosting.ReportingJournal_ID
validate related business field(s) on tRecEntry.Journal_ID
validate related business field(s) on tYearClosing.ClosingTransferJournal_ID
validate related business field(s) on tYearClosing.ClosingPLJournal_ID
validate related business field(s) on tYearClosing.ClosingBalanceJournal_ID