business logic query PostingLineByPostingId

Description

Give all amounts for the lines for a certain posting

Parameters

iiCompanyId	integer	Company id
iiPostingId	integer	Posting ID
icGLSystemTypeCode	character	GL System Type Code
icGLTypeCode	character	GL 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 name	data type	db field	description
tiCompany_ID	integer	Posting.Company_ID	Link to Company
tiCurrency_ID	integer	Currency.Currency_ID	Record ID
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiGL_ID	integer	PostingLine.GL_ID	GL Description
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tcGLSystemTypeCode	character	GL.GLSystemTypeCode	System Type: A code identifying the type of system account.
tcGLTypeCode	character	GL.GLTypeCode	A code identifying the type of account.
tiPosting_ID	integer	PostingLine.Posting_ID	Link to Posting
tiPostingLine_ID	integer	PostingLine.PostingLine_ID	Record ID
tdPostingLineCreditLC	decimal	PostingLine.PostingLineCreditLC	BC 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.
tdPostingLineCreditTC	decimal	PostingLine.PostingLineCreditTC	TC Credit
tdPostingLineDebitLC	decimal	PostingLine.PostingLineDebitLC	BC 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.
tdPostingLineDebitTC	decimal	PostingLine.PostingLineDebitTC	TC Debit

Internal usage

QadFinancials

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