project QadFinancials > class BPosting > business logic query PostingLineByLineIDCrossCy

Description

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


Parameters


iiCompanyIdintegerCompany id
iiPostingLineIDintegerPostingLineId
iiSharedSetIdinteger


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 namedata typedb fielddescription
tcBusinessRelationCodecharacterBusinessRelation.BusinessRelationCodeBusiness 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.
tcBusinessRelationICCodecharacterBusinessRelation.BusinessRelationICCodeIntercompany 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.
tlBusinessRelationIsActivelogicalBusinessRelation.BusinessRelationIsActiveActive: This field indicates if this is an active record.
api annotation:PartialUpdate = yes - defaults to true.
tiCompany_IDintegerPosting.Company_IDLink to Company
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tlCurrencyIsActivelogicalCurrency.CurrencyIsActiveActive
tiGLSharedSet_IDintegerGL.SharedSet_IDLink to SharedSet
tiCurrency_IDintegerPostingLine.Currency_IDCurrency Code
tiGL_IDintegerPostingLine.GL_IDGL Description
tiIntercoBusinessRelation_IDintegerPostingLine.IntercoBusinessRelation_IDIntercompany Code
tiPostingLine_IDintegerPostingLine.PostingLine_IDRecord ID
tiPosting_IDintegerPostingLine.Posting_IDLink to Posting
tiBusinessRelation_IDintegerGL.BusinessRelation_IDLink to BusinessRelation
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tlGLIsActivelogicalGL.GLIsActiveActive: Indicate if this is an active account.
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(PostingLine),rowid(Currency),rowid(GL),rowid(Posting),rowid(Company),rowid(CompanyProperty),rowid(BusinessRelation)


Internal usage


QadFinancials
method BPosting.CalculateCrossCy