project QadFinancials > class BCompanyProperty > business logic query CompanyPropertyByBusRelSimple

Description

CompanyPropertyByBusRelSimple


Parameters


iiCompanyIdintegerCompany id
icCompanyCodecharacterEntity Code
icBusinessRelationCodecharacterBusiness Relation Code


query condition


  each CompanyProperty where
CompanyProperty.Company_Id = iiCompanyId AND

      first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelation_ID = CompanyProperty.BusinessRelation_ID AND
BusinessRelation.BusinessRelationCode = icBusinessRelationCode

      first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanyProperty.Company_ID AND
Company.CompanyCode = icCompanyCode

      first Currency (inner-join) where
Currency.Currency_ID = CompanyProperty.Currency_ID AND


query resultset tqCompanyPropertyByBusRelSimple


field namedata typedb fielddescription
tiBusinessRelation_IDintegerCompanyProperty.BusinessRelation_IDMandatory
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.
tiCompany_IDintegerCompanyProperty.Company_IDLink to Company
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tlCompanyIsActivelogicalCompany.CompanyIsActiveActive
tiCompanyProperty_IDintegerCompanyProperty.CompanyProperty_IDRecord ID
tcCompanyPropertyCodecharacterCompanyProperty.CompanyPropertyCodeEntity Code
tlCompanyPropertyIsActivelogicalCompanyProperty.CompanyPropertyIsActiveActive
tiCurrency_IDintegerCompanyProperty.Currency_IDBase Currency
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code


Internal usage


QadFinancials
method BCInvoice.CreateCInvoiceMovementsCrossCy
method BDInvoice.CreateDInvoiceMovementsCrossCy
method BDInvoice.UpdateDeductionDetailPosting
method TConvertInstalNETXML.LoadXMLRepresentation