project QadFinancials > class BPosting > business logic query PostingPrim

Description

PostingPrim; query that converts the physical prim-key (postingID) into the logical prim-key () and vice-versa


Parameters


iiCompanyIdintegerCompany id
icJournalCodecharacter
iiPeriodYearinteger
iiPostingVoucherinteger
iiPostingIDinteger


query condition


  each Posting where
Posting.PostingVoucher = iiPostingVoucher AND
Posting.Company_ID = iiCompanyId AND
Posting.Posting_ID = iiPostingID And
Posting.PostingYear = iiPeriodYear

      first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND
Journal.JournalCode = icJournalCode

      first Period (inner-join) where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = Posting.Period_ID AND
Period.PeriodYear = iiPeriodYear


query resultset tqPostingPrim


field namedata typedb fielddescription
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
tiPostingPeriodintegerPosting.PostingPeriodThe GL period for the posting. The period must be open.
tiPostingYearintegerPosting.PostingYearThe GL calendar year for the posting.
tiPosting_IDintegerPosting.Posting_IDRecord ID
tiPostingCompanyIDintegerPosting.Company_IDLink to Company
tiJournal_IDintegerPosting.Journal_IDDaybook Code
tcPostingJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tiPeriod_IDintegerPosting.Period_IDLink to Period
tiPostingAccYearintegerPeriod.PeriodYearGL Calendar Year
tiPostingVoucherintegerPosting.PostingVoucherVoucher 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.
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Posting),rowid(Journal),rowid(Period)


Internal usage


QadFinancials
method BBankEntry.CalculateBankState
method BCompanyProperty.ValidateComponent
method BGLReport.ReversedReplacedGLReport
method BPosting.ValidateComponentPreAssignPosting1
method BJournalEntry.DumpJEForConsolid
method BJournalEntry.GrossIncomeAccountingPosting
method BQCrossCyPosting.ApiProcessQCrossCyPostingForReverse
method BSystemProperty.ValidateComponent
read related business field(s) on tAPMatching.Posting_ID
read related business field(s) on tBankStateLine.Posting_ID
read related business field(s) on tConsolid.Posting_ID
read related business field(s) on tFADepreciationPosting.Posting_ID
read related business field(s) on tFARevalPosting.Posting_ID
read related business field(s) on tReval.TCRevalPosting_ID
read related business field(s) on tReval.TCReversePosting_ID
read related business field(s) on tReval.TCUndoPosting_ID
read related business field(s) on tReval.TCUndoReversePosting_ID
read related business field(s) on tReval.CCRevalPosting_ID
read related business field(s) on tReval.CCUndoPosting_ID
read related business field(s) on tReval.CCReversePosting_ID
read related business field(s) on tReval.CCUndoReversePosting_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tReval.TCRevalPosting_ID
validate related business field(s) on tReval.TCReversePosting_ID
validate related business field(s) on tReval.TCUndoPosting_ID
validate related business field(s) on tReval.TCUndoReversePosting_ID
validate related business field(s) on tReval.CCRevalPosting_ID
validate related business field(s) on tReval.CCUndoPosting_ID
validate related business field(s) on tReval.CCReversePosting_ID
validate related business field(s) on tReval.CCUndoReversePosting_ID