project QadFinancials > class BCompanyProperty > business logic query CompanyPropertyForCalculate

Description

Get company-property data based on the company-id. This query has to return all db-field of the table and ALL JOINS IN THIS QUERY SHOULD BE DEFINED AS OUTER-JIONS (for mandatory relations this will be covered by using calculated fields).
The reason for this is that we need to retrieve the company-record even if it is corrupted (e.g. no business-relation).

Parameters


iiCompanyIdintegercompany id

query condition


  each CompanyProperty where
CompanyProperty.Company_ID = iiCompanyId

      first Company (conditional-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanyProperty.SharedAddNrCompany_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.ActCostPostingJournal_ID AND

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

      first SafConcept (conditional-join) where
SafConcept.SafConcept_ID = CompanyProperty.SafConcept_ID AND

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

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

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

query resultset tqCompanyPropertyForCalculate


field namedata typedb fielddescription
tiActSalaryPostingJournal_IDintegerCompanyProperty.ActSalaryPostingJournal_IDDaybook Code
tcActSalaryPostingJournalCodecharacterJournal2.JournalCodeA daybook code (maximum eight characters).
tcCompanyPropertyAutoBalYEFailAccharacterCompanyProperty.CompanyPropertyAutoBalYEFailAcAuto-balance Action
tcCompanyPropertyDelTaxcharacterCompanyProperty.CompanyPropertyDelTaxDelayed Tax
tcCompanyPropertyDelTaxDateTypecharacterCompanyProperty.CompanyPropertyDelTaxDateTypeDelayed Date Type
tdCompanyPropertyExchTolAPdecimalCompanyProperty.CompanyPropertyExchTolAPAP Exchange Tolerance %
tdCompanyPropertyExchTolARdecimalCompanyProperty.CompanyPropertyExchTolARAR Exchange Tolerance %
tlCompanyPropertyIsAddGLNbrlogicalCompanyProperty.CompanyPropertyIsAddGLNbrAdditional GL Numbering
tlCompanyPropertyIsAddNrYrlylogicalCompanyProperty.CompanyPropertyIsAddNrYrlyYearly Additional JE Numbering
tlCompanyPropertyIsAPTaxExcludedlogicalCompanyProperty.CompanyPropertyIsAPTaxExcludedAP Tax Excluded
tlCompanyPropertyIsAPUseInvDatelogicalCompanyProperty.CompanyPropertyIsAPUseInvDateAP Exchange Rate - Use Invoice Date
tlCompanyPropertyIsARTaxExcludedlogicalCompanyProperty.CompanyPropertyIsARTaxExcludedAR Tax Excluded
tlCompanyPropertyIsARUseTaxDatelogicalCompanyProperty.CompanyPropertyIsARUseTaxDateAR Exchange Rate - Use Taxpoint Date
tlCompanyPropertyIsCompenslogicalCompanyProperty.CompanyPropertyIsCompensCustomer/Supplier Compensation allowed
tlCompanyPropertyIsConsolidlogicalCompanyProperty.CompanyPropertyIsConsolidConsolidation Entity
tlCompanyPropertyIsDelPaidlogicalCompanyProperty.CompanyPropertyIsDelPaidDelay Until Paid Status
tlCompanyPropertyIsGlobalTaxlogicalCompanyProperty.CompanyPropertyIsGlobalTaxGlobal Tax
tlCompanyPropertyIsGrIncAcclogicalCompanyProperty.CompanyPropertyIsGrIncAccGross Income Accounting
tlCompanyPropertyIsOICrossCylogicalCompanyProperty.CompanyPropertyIsOICrossCyOpen Item Cross Entity Allowed
tlCompanyPropertyIsPLReverselogicalCompanyProperty.CompanyPropertyIsPLReverseReverse P&L Revaluations
tlCompanyPropertyIsPrimarylogicalCompanyProperty.CompanyPropertyIsPrimaryPrimary Entity
tlCompanyPropertyIsSalPostlogicalCompanyProperty.CompanyPropertyIsSalPostSalary Posting
tlCompanyPropertyIsShowSEPAMsglogicalCompanyProperty.CompanyPropertyIsShowSEPAMsgShow SEPA Messages
tlCompanyPropertyIsStockMgtlogicalCompanyProperty.CompanyPropertyIsStockMgtStock Management
tlCompanyPropertyIsSuspPaidlogicalCompanyProperty.CompanyPropertyIsSuspPaidSuspend Until Paid Status
tlCompanyPropertyIsWHTlogicalCompanyProperty.CompanyPropertyIsWHTUse Withholding Tax
tcCompanyPropertyMirrorSetupcharacterCompanyProperty.CompanyPropertyMirrorSetupMirror Setup
tcCompanyPropertyOINetRestrcharacterCompanyProperty.CompanyPropertyOINetRestrOpen Item Netting Restriction
tcCompanyPropertySuspTaxcharacterCompanyProperty.CompanyPropertySuspTaxSuspended Tax
tcCompanyPropertySusTaxDateTypecharacterCompanyProperty.CompanyPropertySusTaxDateTypeSuspended Date Type
tdCompanyPropertyUppLimitdecimalCompanyProperty.CompanyPropertyUppLimitInvoice Upper Limit
tiCompanyPropertyWHTNextNbrintegerCompanyProperty.CompanyPropertyWHTNextNbrNext WHT Number
tiCompPropIntercoAPCrGL_IDintegerCompanyProperty.CompPropIntercoAPCrGL_IDLink to GL
tiCompPropIntercoAPDbGL_IDintegerCompanyProperty.CompPropIntercoAPDbGL_IDLink to GL
tiCompPropIntercoARCrCc_IDintegerCompanyProperty.CompPropIntercoARCrCc_IDCost Center
tiCompPropIntercoARCrDiv_IDintegerCompanyProperty.CompPropIntercoARCrDiv_IDSub-Account
tiCompPropIntercoARCrGL_IDintegerCompanyProperty.CompPropIntercoARCrGL_IDAccount
tiCompPropIntercoARDbCc_IDintegerCompanyProperty.CompPropIntercoARDbCc_IDCost Center
tiCompPropIntercoARDbDiv_IDintegerCompanyProperty.CompPropIntercoARDbDiv_IDSub-Account
tiCompPropIntercoARDbGL_IDintegerCompanyProperty.CompPropIntercoARDbGL_IDAccount
tiCompPropIntercoFACrCc_IDintegerCompanyProperty.CompPropIntercoFACrCc_IDCost Center
tiCompPropIntercoFACrDiv_IDintegerCompanyProperty.CompPropIntercoFACrDiv_IDSub-Account
tiCompPropIntercoFACrGL_IDintegerCompanyProperty.CompPropIntercoFACrGL_IDAccount
tiCompPropIntercoFADbCc_IDintegerCompanyProperty.CompPropIntercoFADbCc_IDCost Center
tiCompPropIntercoFADbDiv_IDintegerCompanyProperty.CompPropIntercoFADbDiv_IDSub-Account
tiCompPropIntercoFADbGL_IDintegerCompanyProperty.CompPropIntercoFADbGL_IDAccount
tiCompPropIntercoICCrCc_IDintegerCompanyProperty.CompPropIntercoICCrCc_IDCost Center
tiCompPropIntercoICCrDiv_IDintegerCompanyProperty.CompPropIntercoICCrDiv_IDSub-Account
tiCompPropIntercoICCrGL_IDintegerCompanyProperty.CompPropIntercoICCrGL_IDAccount
tiCompPropIntercoICDbCc_IDintegerCompanyProperty.CompPropIntercoICDbCc_IDCost Center
tiCompPropIntercoICDbDiv_IDintegerCompanyProperty.CompPropIntercoICDbDiv_IDSub-Account
tiCompPropIntercoICDbGL_IDintegerCompanyProperty.CompPropIntercoICDbGL_IDAccount
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tcCustomCombo0characterCompanyProperty.CustomCombo0Custom Combo Field
tcCustomCombo1characterCompanyProperty.CustomCombo1Custom Combo Field
tcCustomCombo2characterCompanyProperty.CustomCombo2Custom Combo Field
tcCustomCombo3characterCompanyProperty.CustomCombo3Custom Combo Field
tcCustomCombo4characterCompanyProperty.CustomCombo4Custom Combo Field
tcCustomCombo5characterCompanyProperty.CustomCombo5Custom Combo Field
tcCustomCombo6characterCompanyProperty.CustomCombo6Custom Combo Field
tcCustomCombo7characterCompanyProperty.CustomCombo7Custom Combo Field
tcCustomCombo8characterCompanyProperty.CustomCombo8Custom Combo Field
tcCustomCombo9characterCompanyProperty.CustomCombo9Custom Combo Field
ttCustomDate0dateCompanyProperty.CustomDate0Custom Date Field
ttCustomDate1dateCompanyProperty.CustomDate1Custom Date Field
ttCustomDate2dateCompanyProperty.CustomDate2Custom Date Field
ttCustomDate3dateCompanyProperty.CustomDate3Custom Date Field
ttCustomDate4dateCompanyProperty.CustomDate4Custom Date Field
tdCustomDecimal0decimalCompanyProperty.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalCompanyProperty.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalCompanyProperty.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalCompanyProperty.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalCompanyProperty.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerCompanyProperty.CustomInteger0Custom Integer Field
tiCustomInteger1integerCompanyProperty.CustomInteger1Custom Integer Field
tiCustomInteger2integerCompanyProperty.CustomInteger2Custom Integer Field
tiCustomInteger3integerCompanyProperty.CustomInteger3Custom Integer Field
tiCustomInteger4integerCompanyProperty.CustomInteger4Custom Integer Field
tcCustomLong0characterCompanyProperty.CustomLong0Custom Long Field
tcCustomLong1characterCompanyProperty.CustomLong1Custom Long Field
tcCustomNotecharacterCompanyProperty.CustomNoteCustom Note Field
tcCustomShort0characterCompanyProperty.CustomShort0Custom Short Field
tcCustomShort1characterCompanyProperty.CustomShort1Custom Short Field
tcCustomShort2characterCompanyProperty.CustomShort2Custom Short Field
tcCustomShort3characterCompanyProperty.CustomShort3Custom Short Field
tcCustomShort4characterCompanyProperty.CustomShort4Custom Short Field
tcCustomShort5characterCompanyProperty.CustomShort5Custom Short Field
tcCustomShort6characterCompanyProperty.CustomShort6Custom Short Field
tcCustomShort7characterCompanyProperty.CustomShort7Custom Short Field
tcCustomShort8characterCompanyProperty.CustomShort8Custom Short Field
tcCustomShort9characterCompanyProperty.CustomShort9Custom Short Field
ttLastModifiedDatedateCompanyProperty.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerCompanyProperty.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterCompanyProperty.LastModifiedUserLast Modified User
tiSafConcept_IDintegerCompanyProperty.SafConcept_IDSAF Concept Code
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code
tcSafStructureCodecharacterSafStructure1.SafStructureCodeStructure Code
tiSalarySafStructure_IDintegerCompanyProperty.SalarySafStructure_IDStructure Code
tcSalarySafStructureCodecharacterSafStructure2.SafStructureCodeStructure Code
tiSharedAddNrCompany_IDintegerCompanyProperty.SharedAddNrCompany_IDEntity Code
tcSharedAddNrCompanyCodecharacterCompany.CompanyCodeEntity Code
tdCompanyPropertyActConvFactdecimalCompanyProperty.CompanyPropertyActConvFactConversion Factor to Minutes
tlCompanyPropertyIsActDuratlogicalCompanyProperty.CompanyPropertyIsActDuratAllow Duration
tiUnit_IDintegerCompanyProperty.Unit_IDTime Unit of Measure
tiCostSafStructure_IDintegerCompanyProperty.CostSafStructure_IDStructure Code
tiActCostPostingJournal_IDintegerCompanyProperty.ActCostPostingJournal_IDDaybook Code
tlCompanyPropertyIsPrintRemlogicalCompanyProperty.CompanyPropertyIsPrintRemPrint Remittance
tcBusinessRelationCodecharactercalculatedBusiness Relation Code
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
tcCompanyPropertyCodecharacterCompanyProperty.CompanyPropertyCodeEntity Code
tlCompanyPropertyIsActivelogicalCompanyProperty.CompanyPropertyIsActiveActive
tiCompanyPropertyPriceNumDecintegerCompanyProperty.CompanyPropertyPriceNumDecDecimals for Price
tiCompanyPropertyQtyNumDecintegerCompanyProperty.CompanyPropertyQtyNumDecDecimals for Qty
tdCompanyPropertyRevRecMinimdecimalCompanyProperty.CompanyPropertyRevRecMinimMinimum Percentage of Completion
tdCompanyPropertyRevRecTreshdecimalCompanyProperty.CompanyPropertyRevRecTreshForecasted Revenue Threshold
tcCompanyPropertyActCheckpcharacterCompanyProperty.CompanyPropertyActCheckpActivity Sheets Checkpoint
tcUnitCodecharacterUnit.UnitCodeUnit of Measure
tcJournalCodecharacterJournal1.JournalCodeA daybook code (maximum eight characters).

Internal usage


QadFinancials
method BCompany.Calculate