business logic query PostingLineByCrossExternRef

Parameters

iiNotCompanyId	integer	Company id
icPostingLineCrossExternRef	character	Posting Line Cross Company External Reference
icPostingLineRowid	character	Rowid of PostingLine (The selected records should have a different rowid.)
iiCrossCompanyPostingLineID	integer	Cross Company Posting Line ID: -999999 is used to look for 0.
iiCompanyId	integer	Company id

query condition

each PostingLine where

PostingLine.PostingLineCrossExternRef = icPostingLineCrossExternRef AND
PostingLine.CrossCompanyPostingLine_ID = (if iiCrossCompanyPostingLineID = -999999 then 0 else iiCrossCompanyPostingLineID) AND
rowid(PostingLine) <> icPostingLineRowid AND
PostingLine.Company_ID <> iiNotCompanyId

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = PostingLine.Company_ID AND

first Currency (inner-join) where

Currency.Currency_ID = PostingLine.Currency_ID AND

first Posting (inner-join) where

Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = PostingLine.Posting_ID AND

first Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND

query resultset tqPostingLineByCrossExternRef

field name	data type	db field	description
tiCompany_ID	integer	PostingLine.Company_ID	Link to Company
tcCompanyCode	character	Company.CompanyCode	Entity Code
tiCostCentre_ID	integer	PostingLine.CostCentre_ID	Cost Center Code
tiCrossCompany_ID	integer	PostingLine.CrossCompany_ID	Link to Company
tiCrossCompanyPosting_ID	integer	PostingLine.CrossCompanyPosting_ID	Posting (Cross-Cy)
tiCrossCompanyPostingLine_ID	integer	PostingLine.CrossCompanyPostingLine_ID	Posting line (Cross-Cy)
tiCurrency_ID	integer	PostingLine.Currency_ID	Currency Code
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiDivision_ID	integer	PostingLine.Division_ID	Sub-Account Code
tiGL_ID	integer	PostingLine.GL_ID	GL Description
tiIntercoBusinessRelation_ID	integer	PostingLine.IntercoBusinessRelation_ID	Intercompany Code
tiJournal_ID	integer	Posting.Journal_ID	Daybook Code
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcJournalTypeCode	character	Journal.JournalTypeCode	A daybook type code.
	api annotation:		Value for this field defaults to "Journal Entries".
tiLayer_ID	integer	Journal.Layer_ID	Link to Layer
tiPeriod_ID	integer	PostingLine.Period_ID	Link to Period
tiPosting_ID	integer	PostingLine.Posting_ID	Link to Posting
tiPostingLine_ID	integer	PostingLine.PostingLine_ID	Record ID
tdPostingLineCreditCC	decimal	PostingLine.PostingLineCreditCC	SC 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
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
tcPostingLineCrossExternRef	character	PostingLine.PostingLineCrossExternRef	Ext Reference (Cross-Cy) - must be filled when create a cross-company posting.
	api annotation:		Value for this field defaults to blank.
tdPostingLineDebitCC	decimal	PostingLine.PostingLineDebitCC	SC 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.
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
tdPostingLineQTY	decimal	PostingLine.PostingLineQTY	Quantity
	api annotation:		Value for this field defaults to 0.0000.
tiPostingPeriod	integer	Posting.PostingPeriod	The GL period for the posting. The period must be open.
tiPostingVoucher	integer	Posting.PostingVoucher	Voucher 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.
tiPostingYear	integer	Posting.PostingYear	The GL calendar year for the posting.
tiPostingYearPeriod	integer	Posting.PostingYearPeriod	The 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.
tiProject_ID	integer	PostingLine.Project_ID	Description
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(PostingLine),rowid(Company),rowid(Currency),rowid(Posting),rowid(Journal)

Internal usage

QadFinancials

method BPosting.ValidateComponentPreAssignPostingLineCross