business logic query CompanyPropertyForAllData

Description

Get company data

Parameters

iiCompanyId

integer

company 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 name	data type	db field	description
tiActSalaryPostingJournal_ID	integer	CompanyProperty.ActSalaryPostingJournal_ID	Daybook Code
tcCompanyPropertyActCheckp	character	CompanyProperty.CompanyPropertyActCheckp	Activity Sheets Checkpoint
tdCompanyPropertyActConvFact	decimal	CompanyProperty.CompanyPropertyActConvFact	Conversion Factor to Minutes
tcCompanyPropertyAutoBalYEFailAc	character	CompanyProperty.CompanyPropertyAutoBalYEFailAc	Auto-balance Action
tlCompanyPropertyIsActDurat	logical	CompanyProperty.CompanyPropertyIsActDurat	Allow Duration
tlCompanyPropertyIsAddGLNbr	logical	CompanyProperty.CompanyPropertyIsAddGLNbr	Additional GL Numbering
tlCompanyPropertyIsConsolid	logical	CompanyProperty.CompanyPropertyIsConsolid	Consolidation Entity
tlCompanyPropertyIsGlobalTax	logical	CompanyProperty.CompanyPropertyIsGlobalTax	Global Tax
tlCompanyPropertyIsSalPost	logical	CompanyProperty.CompanyPropertyIsSalPost	Salary Posting
tdCompanyPropertyRevRecMinim	decimal	CompanyProperty.CompanyPropertyRevRecMinim	Minimum Percentage of Completion
tdCompanyPropertyRevRecTresh	decimal	CompanyProperty.CompanyPropertyRevRecTresh	Forecasted Revenue Threshold
tlDomainPropertyIsMaskCC	logical	DomainProperty.DomainPropertyIsMaskCC	Cost Center COA Mask
tlDomainPropertyIsMaskDiv	logical	DomainProperty.DomainPropertyIsMaskDiv	Sub-Account COA Mask
tlDomainPropertyIsMaskProj	logical	DomainProperty.DomainPropertyIsMaskProj	Project COA Mask
tcJournalCode	character	Journal1.JournalCode	A daybook code (maximum eight characters).
tcJournalCode2	character	Journal2.JournalCode	A daybook code (maximum eight characters).
tcSafStructureCode	character	SafStructure1.SafStructureCode	Structure Code
tcSafStructureCode2	character	SafStructure2.SafStructureCode	Structure Code
tiSalarySafStructure_ID	integer	CompanyProperty.SalarySafStructure_ID	Structure Code
tiUnit_ID	integer	CompanyProperty.Unit_ID	Time Unit of Measure
tcUnitCode	character	Unit.UnitCode	Unit of Measure
tiCompanyProperty_ID	integer	CompanyProperty.CompanyProperty_ID	Record ID
tiCompany_ID	integer	CompanyProperty.Company_ID	Link to Company
tiCurrency_ID	integer	CompanyProperty.Currency_ID	Base Currency
tiBusinessRelation_ID	integer	CompanyProperty.BusinessRelation_ID	Mandatory
tlCompanyPropertyIsBudOverCh	logical	CompanyProperty.CompanyPropertyIsBudOverCh	Check Budgets on Overlap
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
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.
tcCompanyPropertyCode	character	CompanyProperty.CompanyPropertyCode	Entity Code
tlCompanyPropertyIsActive	logical	CompanyProperty.CompanyPropertyIsActive	Active
tiCompanyPropertyPriceNumDec	integer	CompanyProperty.CompanyPropertyPriceNumDec	Decimals for Price
tiCompanyPropertyQtyNumDec	integer	CompanyProperty.CompanyPropertyQtyNumDec	Decimals 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