project QadFinancials > class BCompanyProperty > business logic query CompanyPropertyForAllData

Description

Get company data


Parameters


iiCompanyIdintegercompany id


query condition


  each CompanyProperty where
CompanyProperty.Company_ID = iiCompanyId

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

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

          first DomainProperty (inner-join) where
DomainProperty.Domain_ID = Company.Domain_ID AND

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

      first Journal1 (conditional-join) where
Journal1.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal1.Journal_ID = CompanyProperty.ActSalaryPostingJournal_ID AND

      first Journal2 (conditional-join) where
Journal2.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal2.Journal_ID = CompanyProperty.ActCostPostingJournal_ID AND

      first SafStructure1 (conditional-join) where
SafStructure1.SafStructure_ID = CompanyProperty.SalarySafStructure_ID AND

      first SafStructure2 (conditional-join) where
SafStructure2.SafStructure_ID = CompanyProperty.CostSafStructure_ID AND

      first Unit (outer-join) where
Unit.Unit_ID = CompanyProperty.Unit_ID AND


query resultset tqCompanyPropertyForAllData


field namedata typedb fielddescription
tiActSalaryPostingJournal_IDintegerCompanyProperty.ActSalaryPostingJournal_IDDaybook Code
tcCompanyPropertyActCheckpcharacterCompanyProperty.CompanyPropertyActCheckpActivity Sheets Checkpoint
tdCompanyPropertyActConvFactdecimalCompanyProperty.CompanyPropertyActConvFactConversion Factor to Minutes
tcCompanyPropertyAutoBalYEFailAccharacterCompanyProperty.CompanyPropertyAutoBalYEFailAcAuto-balance Action
tlCompanyPropertyIsActDuratlogicalCompanyProperty.CompanyPropertyIsActDuratAllow Duration
tlCompanyPropertyIsAddGLNbrlogicalCompanyProperty.CompanyPropertyIsAddGLNbrAdditional GL Numbering
tlCompanyPropertyIsConsolidlogicalCompanyProperty.CompanyPropertyIsConsolidConsolidation Entity
tlCompanyPropertyIsGlobalTaxlogicalCompanyProperty.CompanyPropertyIsGlobalTaxGlobal Tax
tlCompanyPropertyIsSalPostlogicalCompanyProperty.CompanyPropertyIsSalPostSalary Posting
tdCompanyPropertyRevRecMinimdecimalCompanyProperty.CompanyPropertyRevRecMinimMinimum Percentage of Completion
tdCompanyPropertyRevRecTreshdecimalCompanyProperty.CompanyPropertyRevRecTreshForecasted Revenue Threshold
tlDomainPropertyIsMaskCClogicalDomainProperty.DomainPropertyIsMaskCCCost Center COA Mask
tlDomainPropertyIsMaskDivlogicalDomainProperty.DomainPropertyIsMaskDivSub-Account COA Mask
tlDomainPropertyIsMaskProjlogicalDomainProperty.DomainPropertyIsMaskProjProject COA Mask
tcJournalCodecharacterJournal1.JournalCodeA daybook code (maximum eight characters).
tcJournalCode2characterJournal2.JournalCodeA daybook code (maximum eight characters).
tcSafStructureCodecharacterSafStructure1.SafStructureCodeStructure Code
tcSafStructureCode2characterSafStructure2.SafStructureCodeStructure Code
tiSalarySafStructure_IDintegerCompanyProperty.SalarySafStructure_IDStructure Code
tiUnit_IDintegerCompanyProperty.Unit_IDTime Unit of Measure
tcUnitCodecharacterUnit.UnitCodeUnit of Measure
tiCompanyProperty_IDintegerCompanyProperty.CompanyProperty_IDRecord ID
tiCompany_IDintegerCompanyProperty.Company_IDLink to Company
tiCurrency_IDintegerCompanyProperty.Currency_IDBase Currency
tiBusinessRelation_IDintegerCompanyProperty.BusinessRelation_IDMandatory
tlCompanyPropertyIsBudOverChlogicalCompanyProperty.CompanyPropertyIsBudOverChCheck Budgets on Overlap
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
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.
tcCompanyPropertyCodecharacterCompanyProperty.CompanyPropertyCodeEntity Code
tlCompanyPropertyIsActivelogicalCompanyProperty.CompanyPropertyIsActiveActive
tiCompanyPropertyPriceNumDecintegerCompanyProperty.CompanyPropertyPriceNumDecDecimals for Price
tiCompanyPropertyQtyNumDecintegerCompanyProperty.CompanyPropertyQtyNumDecDecimals for Qty


Internal usage


QadFinancials
method BBudget.AdditionalUpdValBudgetFDSOverlap
method BBudget.BudgetCheckOverlapSetting
method BCreditor.ValBankNumberAndPayCodeRef
method BDebtor.ValBankNumberandPayCodeRef
method BDebtorReport.DebtorAccountState
method BDebtorReport.DebtorReminders
method BExchangeRate.ApiCalculateDerivedExchangeRates
method BExchangeRate.GetDefaultDerivedExchangeRateValues
method BExchangeRate.GetSharedSetCompanyCurrencyIDs
method BGLReport.BalanceSheetReport
method BGLReport.ChineseBalanceSheet
method BGLReport.IncomeStatement
method BGLReport.MultiColBalanceSheet
method BGLReport.MultiColIncomeStatement
method BGLReport.SetReportCurrency
method BPosting.PreSaveValidate
method BPaymentSelection.ExportBEInland
method BPaymentSelection.ExportNLInland
method BYearClosing.ValidateComponentAll
method Session.SwitchCompany
method TConvertInstalNETXML.SetOutputData