project QadFinancials > class BPosting > business logic query PostingLineByPostingId

Description

Give all amounts for the lines for a certain posting


Parameters


iiCompanyIdintegerCompany id
iiPostingIdintegerPosting ID
icGLSystemTypeCodecharacterGL System Type Code
icGLTypeCodecharacterGL type code


query condition


  each PostingLine where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.Posting_ID = iiPostingId

      first Currency (inner-join) where
Currency.Currency_ID = PostingLine.Currency_ID AND

      first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = PostingLine.GL_ID AND
GL.GLSystemTypeCode matches icGLSystemTypeCode AND
GL.GLTypeCode matches icGLTypeCode

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


query resultset tqPostingLineByPostingId


field namedata typedb fielddescription
tiCompany_IDintegerPosting.Company_IDLink to Company
tiCurrency_IDintegerCurrency.Currency_IDRecord ID
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiGL_IDintegerPostingLine.GL_IDGL Description
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tcGLSystemTypeCodecharacterGL.GLSystemTypeCodeSystem Type: A code identifying the type of system account.
tcGLTypeCodecharacterGL.GLTypeCodeA code identifying the type of account.
tiPosting_IDintegerPostingLine.Posting_IDLink to Posting
tiPostingLine_IDintegerPostingLine.PostingLine_IDRecord ID
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.
tdPostingLineCreditTCdecimalPostingLine.PostingLineCreditTCTC Credit
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.
tdPostingLineDebitTCdecimalPostingLine.PostingLineDebitTCTC Debit


Internal usage


QadFinancials
method BBankEntry.CalculateAll
method BBankEntry.GetPostingAmount
method BBankEntry.GetPostingAmountLC
method BCInvoice.Calculate