project QadFinancials > class BCompanyProperty > dataset BCompanyProperty

class dataset

object identification

primary key
CompanyProperty_ID
object identity
CompanyProperty_ID

table tCompanyProperty

Description

Entity

field namedata typemnd.description
CompanyProperty_IDintegeryesRecord ID
Company_IDintegeryesLink to Company
BusinessRelation_IDintegeryesMandatory
Currency_IDintegeryesBase Currency
Unit_IDintegernoTime Unit of Measure
ActCostPostingJournal_IDintegernoDaybook Code
ActSalaryPostingJournal_IDintegernoDaybook Code
CostSafStructure_IDintegernoStructure Code
SalarySafStructure_IDintegernoStructure Code
SafConcept_IDintegernoSAF Concept Code
SharedAddNrCompany_IDintegernoEntity Code
CompPropIntercoAPDbGL_IDintegernoLink to GL
CompPropIntercoAPCrGL_IDintegernoLink to GL
CompPropIntercoARDbGL_IDintegernoAccount
CompPropIntercoARDbDiv_IDintegernoSub-Account
CompPropIntercoARDbCc_IDintegernoCost Center
CompPropIntercoICDbGL_IDintegernoAccount
CompPropIntercoICDbDiv_IDintegernoSub-Account
CompPropIntercoICDbCc_IDintegernoCost Center
CompPropIntercoICCrGL_IDintegernoAccount
CompPropIntercoICCrDiv_IDintegernoSub-Account
CompPropIntercoICCrCc_IDintegernoCost Center
CompPropIntercoARCrGL_IDintegernoAccount
CompPropIntercoARCrDiv_IDintegernoSub-Account
CompPropIntercoARCrCc_IDintegernoCost Center
CompPropIntercoFADbGL_IDintegernoAccount
CompPropIntercoFADbDiv_IDintegernoSub-Account
CompPropIntercoFADbCc_IDintegernoCost Center
CompPropIntercoFACrGL_IDintegernoAccount
CompPropIntercoFACrDiv_IDintegernoSub-Account
CompPropIntercoFACrCc_IDintegernoCost Center
CompanyPropertyCodecharacter(20)noEntity Code
CompanyPropertyIsActivelogicalnoActive
CompanyPropertyIsBudOverChlogicalyesCheck Budgets on Overlap
CompanyPropertyPriceNumDecintegernoDecimals for Price
CompanyPropertyQtyNumDecintegernoDecimals for Qty
CompanyPropertyRevRecMinimdecimal(2)noMinimum Percentage of Completion
CompanyPropertyRevRecTreshdecimal(4)noForecasted Revenue Threshold
CompanyPropertyIsActDuratlogicalnoAllow Duration
CompanyPropertyActCheckpcharacter(20)noActivity Sheets Checkpoint
value list:{&COMPANYASCHECKPOINTS}
CompanyPropertyActConvFactdecimal(8)noConversion Factor to Minutes
CompanyPropertyIsPrintRemlogicalyesPrint Remittance
CompanyPropertyIsGlobalTaxlogicalyesGlobal Tax
CompanyPropertyIsPLReverselogicalyesReverse P&L Revaluations
CompanyPropertyIsSalPostlogicalyesSalary Posting
CompanyPropertyIsStockMgtlogicalyesStock Management
CompanyPropertyIsDocPerInvlogicalyesCreate Payment per Invoice
CompanyPropertyIsPrimarylogicalyesPrimary Entity
CompanyPropertyUppLimitdecimal(4)noInvoice Upper Limit
CompanyPropertyExchTolAPdecimal(10)noAP Exchange Tolerance %
CompanyPropertyExchTolARdecimal(10)noAR Exchange Tolerance %
CompanyPropertyIsAddNrYrlylogicalyesYearly Additional JE Numbering
CompanyPropertyIsAddGLNbrlogicalyesAdditional GL Numbering
CompanyPropertyIsConsolidlogicalyesConsolidation Entity
CompanyPropertyMirrorSetupcharacter(20)yesMirror Setup
value list:{&COMPANYPROPERTYMIRRORSETUPS}
CompanyPropertySuspTaxcharacter(20)noSuspended Tax
value list:{&SUSPDELAYTAXS}
CompanyPropertySusTaxDateTypecharacter(20)noSuspended Date Type
value list:{&TAXDATETYPES}
CompanyPropertyDelTaxDateTypecharacter(20)noDelayed Date Type
value list:{&TAXDATETYPES}
CompanyPropertyDelTaxcharacter(20)noDelayed Tax
value list:{&SUSPDELAYTAXS}
CompanyPropertyOINetRestrcharacter(20)yesOpen Item Netting Restriction
value list:{&COMPANYPROPERTYOINETRESTRS}
CompanyPropertyIsOICrossCylogicalyesOpen Item Cross Entity Allowed
CompanyPropertyIsCompenslogicalyesCustomer/Supplier Compensation allowed
CompanyPropertyIsWHTlogicalyesUse Withholding Tax
CompanyPropertyWHTNextNbrintegernoNext WHT Number
CompanyPropertyIsDelPaidlogicalyesDelay Until Paid Status
CompanyPropertyIsSuspPaidlogicalyesSuspend Until Paid Status
CompanyPropertyIsGrIncAcclogicalyesGross Income Accounting
CompanyPropertyAutoBalYEFailAccharacter(20)noAuto-balance Action
value list:{&YECLOSEAUTOBALANCECHECKS}
CompanyPropertyIsAPTaxExcludedlogicalyesAP Tax Excluded
CompanyPropertyIsARTaxExcludedlogicalyesAR Tax Excluded
CompanyPropertyIsAPUseInvDatelogicalyesAP Exchange Rate - Use Invoice Date
CompanyPropertyIsARUseTaxDatelogicalyesAR Exchange Rate - Use Taxpoint Date
CompanyPropertyIsShowSEPAMsglogicalyesShow SEPA Messages
CompanyPropertyIsARDiscInInvCylogicalyesApply AR-Discounts in invoicing Entity
tcCurrencyCodecharacter(3)yesBase Currency
tcSafConceptCodecharacter(20)noSAF Concept Code
tcUnitCodecharacter(20)noTime Unit of Measure
tcActCostPostingJournalCodecharacter(8)noDaybook Code
tcCompPropIntercoARDbGLCodecharacter(8)noAccount
tcCompPropIntercoARDbDivCodecharacter(8)noSub-Account
tcCompPropIntercoARDbCcCodecharacter(4)noCost Center
tcCompPropIntercoICDbGLCodecharacter(8)noAccount
tcCompPropIntercoICDbDivCodecharacter(8)noSub-Account
tcCompPropIntercoICDbCcCodecharacter(4)noCost Center
tcCompPropIntercoICCrGLCodecharacter(8)noAccount
tcCompPropIntercoICCrDivCodecharacter(8)noSub-Account
tcCompPropIntercoICCrCcCodecharacter(4)noCost Center
tcActSalaryPostingJournalCodecharacter(8)noDaybook Code
tcSalarySafStructureCodecharacter(20)noStructure Code
tcCompPropIntercoARCrGLCodecharacter(8)noAccount
tcBusinessRelationCodecharacter(20)yesBusiness Relation
tcCostSafStructureCodecharacter(20)noStructure Code
tcCompPropIntercoARCrDivCodecharacter(8)noSub-Account
tlManhourSurchargeExistslogicalnoManhour Surcharge
tcCompPropIntercoFADbCcCodecharacter(4)noCost Center
tcCompPropIntercoFACrGLCodecharacter(8)noAccount
tcCompPropIntercoFACrDivCodecharacter(8)noSub-Account
tcCompPropIntercoFADbGLCodecharacter(8)noAccount
tcCompPropIntercoARCrCcCodecharacter(4)noCost Center
tcCompPropIntercoFADbDivCodecharacter(8)noSub-Account
tcCompPropIntercoFACrCcCodecharacter(4)noCost Center
tcDomainCodecharacter(8)noDomain
tcSharedAddNrCompanyCodecharacter(20)noEntity Code
CompanyPropertyIsAPDiscInInvCylogicalyesApply AP-Discounts in invoicing Entity
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
CustomShort10character(20)noCustom Short Field
CustomShort11character(20)noCustom Short Field
CustomShort12character(20)noCustom Short Field
CustomShort13character(20)noCustom Short Field
CustomShort14character(20)noCustom Short Field
CustomCombo10character(20)noCustom Combo Field
CustomCombo11character(20)noCustom Combo Field
CustomCombo12character(20)noCustom Combo Field
CustomCombo13character(20)noCustom Combo Field
CustomCombo14character(20)noCustom Combo Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
QADC01character(40)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter