business logic query PostingLineByLineIDCrossCy

Description

PostingLineByLineIDCrossCy; query used to get cross-company information on a PostingLine

Parameters

iiCompanyId	integer	Company id
iiPostingLineID	integer	PostingLineId
iiSharedSetId	integer

query condition

each PostingLine where

PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = iiPostingLineID

first Currency (inner-join) where

Currency.Currency_ID = PostingLine.Currency_ID AND

first GL (inner-join) where

GL.GL_ID = PostingLine.GL_ID AND
GL.SharedSet_ID = iiSharedSetId

first Posting (inner-join) where

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

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = Posting.Company_ID AND

each CompanyProperty (inner-join) where

CompanyProperty.Company_Id = iiCompanyId AND
CompanyProperty.Company_ID = Company.Company_ID AND

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = CompanyProperty.BusinessRelation_ID AND

query resultset tqPostingLineByLineIDCrossCy

field name	data type	db field	description
tcBusinessRelationCode	character	BusinessRelation.BusinessRelationCode	Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tcBusinessRelationICCode	character	BusinessRelation.BusinessRelationICCode	Intercompany Code. When Intercompany is true, this field is mandatory. The code entered here must match the intercompany code entered for GL accounts in order to generate intercompany reports. The intercompany code must be unique for this business relation.
tlBusinessRelationIsActive	logical	BusinessRelation.BusinessRelationIsActive	Active: This field indicates if this is an active record.
	api annotation:		PartialUpdate = yes - defaults to true.
tiCompany_ID	integer	Posting.Company_ID	Link to Company
tcCompanyCode	character	Company.CompanyCode	Entity Code
tlCurrencyIsActive	logical	Currency.CurrencyIsActive	Active
tiGLSharedSet_ID	integer	GL.SharedSet_ID	Link to SharedSet
tiCurrency_ID	integer	PostingLine.Currency_ID	Currency Code
tiGL_ID	integer	PostingLine.GL_ID	GL Description
tiIntercoBusinessRelation_ID	integer	PostingLine.IntercoBusinessRelation_ID	Intercompany Code
tiPostingLine_ID	integer	PostingLine.PostingLine_ID	Record ID
tiPosting_ID	integer	PostingLine.Posting_ID	Link to Posting
tiBusinessRelation_ID	integer	GL.BusinessRelation_ID	Link to BusinessRelation
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tlGLIsActive	logical	GL.GLIsActive	Active: Indicate if this is an active account.
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(PostingLine),rowid(Currency),rowid(GL),rowid(Posting),rowid(Company),rowid(CompanyProperty),rowid(BusinessRelation)

Internal usage

QadFinancials

method BPosting.CalculateCrossCy