project QadFinancials > class BPosting > business logic query PostingLineByPostingLineId

Description

PostingLineByPostingLineId


Parameters


iiCompanyIdintegerCompany id
iiPostingLineIdintegerPosting Line ID
icJournalTypeCodecharacterDaybook Type Code


query condition


  each PostingLine where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = iiPostingLineId

      first Posting (inner-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = PostingLine.Posting_ID AND

          first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = Posting.Company_ID AND

          first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND
Journal.JournalTypeCode matches icJournalTypeCode

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


query resultset tqPostingLineByPostingLineId


field namedata typedb fielddescription
tiCompany_IDintegerPosting.Company_IDLink to Company
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tiCostCentre_IDintegerPostingLine.CostCentre_IDCost Center Code
tiCurrency_IDintegerPostingLine.Currency_IDCurrency Code
tcCustomCombo0characterPostingLine.CustomCombo0Custom Combo Field
tcCustomCombo1characterPostingLine.CustomCombo1Custom Combo Field
tcCustomCombo2characterPostingLine.CustomCombo2Custom Combo Field
tcCustomCombo3characterPostingLine.CustomCombo3Custom Combo Field
tcCustomCombo4characterPostingLine.CustomCombo4Custom Combo Field
tcCustomCombo5characterPostingLine.CustomCombo5Custom Combo Field
tcCustomCombo6characterPostingLine.CustomCombo6Custom Combo Field
tcCustomCombo7characterPostingLine.CustomCombo7Custom Combo Field
tcCustomCombo8characterPostingLine.CustomCombo8Custom Combo Field
tcCustomCombo9characterPostingLine.CustomCombo9Custom Combo Field
ttCustomDate0datePostingLine.CustomDate0Custom Date Field
ttCustomDate1datePostingLine.CustomDate1Custom Date Field
ttCustomDate2datePostingLine.CustomDate2Custom Date Field
ttCustomDate3datePostingLine.CustomDate3Custom Date Field
ttCustomDate4datePostingLine.CustomDate4Custom Date Field
tdCustomDecimal0decimalPostingLine.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalPostingLine.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalPostingLine.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalPostingLine.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalPostingLine.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerPostingLine.CustomInteger0Custom Integer Field
tiCustomInteger1integerPostingLine.CustomInteger1Custom Integer Field
tiCustomInteger2integerPostingLine.CustomInteger2Custom Integer Field
tiCustomInteger3integerPostingLine.CustomInteger3Custom Integer Field
tiCustomInteger4integerPostingLine.CustomInteger4Custom Integer Field
tcCustomLong0characterPostingLine.CustomLong0Custom Long Field
tcCustomLong1characterPostingLine.CustomLong1Custom Long Field
tcCustomNotecharacterPostingLine.CustomNoteCustom Note Field
tcCustomShort0characterPostingLine.CustomShort0Custom Short Field
tcCustomShort1characterPostingLine.CustomShort1Custom Short Field
tcCustomShort2characterPostingLine.CustomShort2Custom Short Field
tcCustomShort3characterPostingLine.CustomShort3Custom Short Field
tcCustomShort4characterPostingLine.CustomShort4Custom Short Field
tcCustomShort5characterPostingLine.CustomShort5Custom Short Field
tcCustomShort6characterPostingLine.CustomShort6Custom Short Field
tcCustomShort7characterPostingLine.CustomShort7Custom Short Field
tcCustomShort8characterPostingLine.CustomShort8Custom Short Field
tcCustomShort9characterPostingLine.CustomShort9Custom Short Field
tiDivision_IDintegerPostingLine.Division_IDSub-Account Code
tiGL_IDintegerPostingLine.GL_IDGL Description
tiIntercoBusinessRelation_IDintegerPostingLine.IntercoBusinessRelation_IDIntercompany Code
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcJournalTypeCodecharacterJournal.JournalTypeCodeA daybook type code.
api annotation:Value for this field defaults to "Journal Entries".
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type
tiPosting_IDintegerPostingLine.Posting_IDLink to Posting
ttPostingDatedatePosting.PostingDateThe accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod).
tiPostingLine_IDintegerPostingLine.PostingLine_IDRecord ID
tcPostingLineCostCentreTextcharacterPostingLine.PostingLineCostCentreTextCost Center
api annotation:Value for this field defaults to blank.
tdPostingLineCreditCCdecimalPostingLine.PostingLineCreditCCSC Credit
api annotation:Partial Update = yes - it will get a default value depending on the value of PostingLinCreditTC, PostingLineCCRate & PostingLineCCScale.
SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, you should enter the correct value for this field
tdPostingLineCreditLCdecimalPostingLine.PostingLineCreditLCBC Credit
api annotation:Partial Update = yes - it will get a default value depends on the value of PostingLineCreditTC, PostingLineExchangeRate & PostingLineRateScale.
BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update is false, enter a value for this field.
tdPostingLineCreditPCdecimalPostingLine.PostingLineCreditPCPC Credit
api annotation:This field is obsolete and can be left blank.
tdPostingLineCreditTCdecimalPostingLine.PostingLineCreditTCTC Credit
tdPostingLineDebitCCdecimalPostingLine.PostingLineDebitCCSC Debit
api annotation:Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineCCRate & PostingLineCCScale.
SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, enter the correct value for this field.
tdPostingLineDebitLCdecimalPostingLine.PostingLineDebitLCBC Debit
api annotation:Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineExchangeRate and PostingLineRateScale.
BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update = false, enter the correct value into this field.
tdPostingLineDebitPCdecimalPostingLine.PostingLineDebitPCPC Debit
api annotation:This field is obsolete.
tdPostingLineDebitTCdecimalPostingLine.PostingLineDebitTCTC Debit
tlPostingLineIsProjPostinglogicalPostingLine.PostingLineIsProjPostingProject Posting
tiPostingLineMaster_IDintegerPostingLine.PostingLineMaster_IDLink to Master
tcPostingLineProjectTextcharacterPostingLine.PostingLineProjectTextProject
api annotation:Value for this field defaults to blank.
tdPostingLineQTYdecimalPostingLine.PostingLineQTYQuantity
api annotation:Value for this field defaults to 0.0000.
tcPostingLineSafTextcharacterPostingLine.PostingLineSafTextSAF
api annotation:Value for this field defaults to blank.
tiPostingLineSequenceintegerPostingLine.PostingLineSequenceSequence
tcPostingLineTextcharacterPostingLine.PostingLineTextDescription
api annotation:Value for this field defaults to blank. Note: if a new record is created through the user interface, the default value is as same as the value of "PostingText" of tPosting.
tiPostingLineTransaction_IDintegerPostingLine.PostingLineTransaction_IDLink to Transaction
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.
tiProject_IDintegerPostingLine.Project_IDDescription


Internal usage


QadFinancials
method BCInvoice.Calculate
method BDInvoice.Calculate
method BGLOpenItem.ValidateComponent
method BJournalEntry.CreateReplaceEntry
method BJournalEntry.CreateReverseEntry