project QadFinancials > class BPosting > business logic query PostingLineByLineID


Parameters


iiCompanyIdintegerCompany id
iiPostingLine_IDinteger


query condition


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

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


query resultset tqPostingLineByLineID


field namedata typedb fielddescription
tiCostCentre_IDintegerPostingLine.CostCentre_IDCost Center Code
tiDivision_IDintegerPostingLine.Division_IDSub-Account Code
tiGL_IDintegerPostingLine.GL_IDGL Description
tiPeriod_IDintegerPosting.Period_IDLink to Period
tiPostingLine_IDintegerPostingLine.PostingLine_IDRecord ID
tdPostingLineCCRatedecimalPostingLine.PostingLineCCRateThe exchange rate used to convert between transaction (TC) and statutory(SC) amounts.
api annotation:Default value for this field depends on the exchangerate shared set specified for the current domain.
tdPostingLineCCScaledecimalPostingLine.PostingLineCCScaleA decimal number that must be multiplied by the exchange rate to get the real exchange rate. Its format is 9999999.9999999 and it was introduced to extend the accuracy of the exchange rate.
api annotation:The default value is 1.
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.
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.
tdPostingLineDebitTCdecimalPostingLine.PostingLineDebitTCTC Debit
tdPostingLineExchangeRatedecimalPostingLine.PostingLineExchangeRateExchange Rate
api annotation:Default value for this field depends on the exchang erate shared set specified for the current domain.
tdPostingLineQTYdecimalPostingLine.PostingLineQTYQuantity
api annotation:Value for this field defaults to 0.0000.
tdPostingLineRateScaledecimalPostingLine.PostingLineRateScaleScale Factor
api annotation:The default value is 1.
tiProject_IDintegerPostingLine.Project_IDDescription
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(PostingLine),rowid(Posting)


Internal usage


QadFinancials
method BQBudgetActual.AdditonalUpdatesDeleteSub