project QadFinancials > class BJournalEntry > dataset tPostingPostingLineInfo

table tPostingPostingLineInfo

Description

temp-table with all fields needed for method GetPostingInfoByPostingLineIDTT

field namedata typedescription
tiPostingLine_IDinteger
ttPostingDatedateThe 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).
tiPostingYearPeriodintegerThe GL calendar year/period for the posting. This field is determined by "PostingPeriod" and "PostingYear".
api annotation:If Partial Update is true, the value defaults using PostingPeriod and PostingYear.
tiPeriod_IDinteger
tcJournalCodecharacterA daybook code (maximum eight characters).
tcLayerTypeCodecharacter
tcJournalTypeCodecharacterA daybook type code.
api annotation:Value for this field defaults to "Journal Entries".
tiCostCentre_IDinteger
tiDivision_IDinteger
tiGL_IDinteger
tdPostingLineCreditCCdecimal(4)
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
tdPostingLineCreditLCdecimal(4)
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.
tdPostingLineCreditTCdecimal(4)
tdPostingLineDebitCCdecimal(4)
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.
tdPostingLineDebitLCdecimal(4)
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.
tdPostingLineDebitTCdecimal(4)
tiProject_IDinteger
tiJournal_IDinteger


Internal usage


QadFinancials
method BJournalEntry.GetPostingInfoByPostingLineIDTT
method BJournalEntry.UpdatePostinglineCCAmts