project QadFinancials > class BCompanyProperty > business logic query CompanyPropertyByIDAllInfo

Description

query that returns a lot of fields of CompanyProperty Based on companyid


Parameters


iiCompanyIdintegerCompany id


query condition


  each CompanyProperty where
CompanyProperty.Company_Id = iiCompanyId AND


query resultset tqCompanyPropertyByIDAllInfo


field namedata typedb fielddescription
tiActCostPostingJournal_IDintegerCompanyProperty.ActCostPostingJournal_IDDaybook Code
tiActSalaryPostingJournal_IDintegerCompanyProperty.ActSalaryPostingJournal_IDDaybook Code
tiBusinessRelation_IDintegerCompanyProperty.BusinessRelation_IDMandatory
tiCompany_IDintegerCompanyProperty.Company_IDLink to Company
tiCompanyProperty_IDintegerCompanyProperty.CompanyProperty_IDRecord ID
tcCompanyPropertyActCheckpcharacterCompanyProperty.CompanyPropertyActCheckpActivity Sheets Checkpoint
tdCompanyPropertyActConvFactdecimalCompanyProperty.CompanyPropertyActConvFactConversion Factor to Minutes
tcCompanyPropertyCodecharacterCompanyProperty.CompanyPropertyCodeEntity Code
tlCompanyPropertyIsActDuratlogicalCompanyProperty.CompanyPropertyIsActDuratAllow Duration
tlCompanyPropertyIsActivelogicalCompanyProperty.CompanyPropertyIsActiveActive
tlCompanyPropertyIsAddGLNbrlogicalCompanyProperty.CompanyPropertyIsAddGLNbrAdditional GL Numbering
tlCompanyPropertyIsAddNrYrlylogicalCompanyProperty.CompanyPropertyIsAddNrYrlyYearly Additional JE Numbering
tlCompanyPropertyIsAPUseInvDatelogicalCompanyProperty.CompanyPropertyIsAPUseInvDateAP Exchange Rate - Use Invoice Date
tlCompanyPropertyIsARUseTaxDatelogicalCompanyProperty.CompanyPropertyIsARUseTaxDateAR Exchange Rate - Use Taxpoint Date
tlCompanyPropertyIsBudOverChlogicalCompanyProperty.CompanyPropertyIsBudOverChCheck Budgets on Overlap
tlCompanyPropertyIsCompenslogicalCompanyProperty.CompanyPropertyIsCompensCustomer/Supplier Compensation allowed
tlCompanyPropertyIsGlobalTaxlogicalCompanyProperty.CompanyPropertyIsGlobalTaxGlobal Tax
tlCompanyPropertyIsOICrossCylogicalCompanyProperty.CompanyPropertyIsOICrossCyOpen Item Cross Entity Allowed
tlCompanyPropertyIsPLReverselogicalCompanyProperty.CompanyPropertyIsPLReverseReverse P&L Revaluations
tlCompanyPropertyIsPrimarylogicalCompanyProperty.CompanyPropertyIsPrimaryPrimary Entity
tlCompanyPropertyIsPrintRemlogicalCompanyProperty.CompanyPropertyIsPrintRemPrint Remittance
tlCompanyPropertyIsSalPostlogicalCompanyProperty.CompanyPropertyIsSalPostSalary Posting
tlCompanyPropertyIsShowSEPAMsglogicalCompanyProperty.CompanyPropertyIsShowSEPAMsgShow SEPA Messages
tlCompanyPropertyIsStockMgtlogicalCompanyProperty.CompanyPropertyIsStockMgtStock Management
tlCompanyPropertyIsWHTlogicalCompanyProperty.CompanyPropertyIsWHTUse Withholding Tax
tcCompanyPropertyOINetRestrcharacterCompanyProperty.CompanyPropertyOINetRestrOpen Item Netting Restriction
tiCompanyPropertyPriceNumDecintegerCompanyProperty.CompanyPropertyPriceNumDecDecimals for Price
tiCompanyPropertyQtyNumDecintegerCompanyProperty.CompanyPropertyQtyNumDecDecimals for Qty
tdCompanyPropertyRevRecMinimdecimalCompanyProperty.CompanyPropertyRevRecMinimMinimum Percentage of Completion
tdCompanyPropertyRevRecTreshdecimalCompanyProperty.CompanyPropertyRevRecTreshForecasted Revenue Threshold
tiCompanyPropertyWHTNextNbrintegerCompanyProperty.CompanyPropertyWHTNextNbrNext WHT Number
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
tiCostSafStructure_IDintegerCompanyProperty.CostSafStructure_IDStructure Code
tiCurrency_IDintegerCompanyProperty.Currency_IDBase Currency
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
tiSalarySafStructure_IDintegerCompanyProperty.SalarySafStructure_IDStructure Code
tiSharedAddNrCompany_IDintegerCompanyProperty.SharedAddNrCompany_IDEntity Code
tiUnit_IDintegerCompanyProperty.Unit_IDTime Unit of Measure
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(CompanyProperty)


Internal usage


QadFinancials
method BCInvoice.ValidateComponentPostTSM
method BDCollection.FillProDataSetCompany
method BDInvoice.ValidateComponentAllPostTSMNumber
method BPosting.AdditionalUpdatesPre
method BPosting.AdditionalUpdatesPreAddGLNumberDet
method BOpenItemAdjustment.GetCompanySetting
method BOpenItemAdjustment.OIAdjApplyFilter
method BOpenItemAdjustment.OIAdjCommitValidateThree
method BOpenItemAdjustment.OIAdjNewOpenItem
method BPaymentSelection.FillProDataSetCompany