field name | data type | mnd. | description |
CompanyProperty_ID | integer | yes | Record ID |
Company_ID | integer | yes | Link to Company |
BusinessRelation_ID | integer | yes | Mandatory |
Currency_ID | integer | yes | Base Currency |
Unit_ID | integer | no | Time Unit of Measure |
ActCostPostingJournal_ID | integer | no | Daybook Code |
ActSalaryPostingJournal_ID | integer | no | Daybook Code |
CostSafStructure_ID | integer | no | Structure Code |
SalarySafStructure_ID | integer | no | Structure Code |
SafConcept_ID | integer | no | SAF Concept Code |
SharedAddNrCompany_ID | integer | no | Entity Code |
CompPropIntercoAPDbGL_ID | integer | no | Link to GL |
CompPropIntercoAPCrGL_ID | integer | no | Link to GL |
CompPropIntercoARDbGL_ID | integer | no | Account |
CompPropIntercoARDbDiv_ID | integer | no | Sub-Account |
CompPropIntercoARDbCc_ID | integer | no | Cost Center |
CompPropIntercoICDbGL_ID | integer | no | Account |
CompPropIntercoICDbDiv_ID | integer | no | Sub-Account |
CompPropIntercoICDbCc_ID | integer | no | Cost Center |
CompPropIntercoICCrGL_ID | integer | no | Account |
CompPropIntercoICCrDiv_ID | integer | no | Sub-Account |
CompPropIntercoICCrCc_ID | integer | no | Cost Center |
CompPropIntercoARCrGL_ID | integer | no | Account |
CompPropIntercoARCrDiv_ID | integer | no | Sub-Account |
CompPropIntercoARCrCc_ID | integer | no | Cost Center |
CompPropIntercoFADbGL_ID | integer | no | Account |
CompPropIntercoFADbDiv_ID | integer | no | Sub-Account |
CompPropIntercoFADbCc_ID | integer | no | Cost Center |
CompPropIntercoFACrGL_ID | integer | no | Account |
CompPropIntercoFACrDiv_ID | integer | no | Sub-Account |
CompPropIntercoFACrCc_ID | integer | no | Cost Center |
CompanyPropertyCode | character(20) | no | Entity Code |
CompanyPropertyIsActive | logical | no | Active |
CompanyPropertyIsBudOverCh | logical | yes | Check Budgets on Overlap |
CompanyPropertyPriceNumDec | integer | no | Decimals for Price |
CompanyPropertyQtyNumDec | integer | no | Decimals for Qty |
CompanyPropertyRevRecMinim | decimal(2) | no | Minimum Percentage of Completion |
CompanyPropertyRevRecTresh | decimal(4) | no | Forecasted Revenue Threshold |
CompanyPropertyIsActDurat | logical | no | Allow Duration |
CompanyPropertyActCheckp | character(20) | no | Activity Sheets Checkpoint |
| value list: | | {&COMPANYASCHECKPOINTS} |
CompanyPropertyActConvFact | decimal(8) | no | Conversion Factor to Minutes |
CompanyPropertyIsPrintRem | logical | yes | Print Remittance |
CompanyPropertyIsGlobalTax | logical | yes | Global Tax |
CompanyPropertyIsPLReverse | logical | yes | Reverse P&L Revaluations |
CompanyPropertyIsSalPost | logical | yes | Salary Posting |
CompanyPropertyIsStockMgt | logical | yes | Stock Management |
CompanyPropertyIsDocPerInv | logical | yes | Create Payment per Invoice |
CompanyPropertyIsPrimary | logical | yes | Primary Entity |
CompanyPropertyUppLimit | decimal(4) | no | Invoice Upper Limit |
CompanyPropertyExchTolAP | decimal(10) | no | AP Exchange Tolerance % |
CompanyPropertyExchTolAR | decimal(10) | no | AR Exchange Tolerance % |
CompanyPropertyIsAddNrYrly | logical | yes | Yearly Additional JE Numbering |
CompanyPropertyIsAddGLNbr | logical | yes | Additional GL Numbering |
CompanyPropertyIsConsolid | logical | yes | Consolidation Entity |
CompanyPropertyMirrorSetup | character(20) | yes | Mirror Setup |
| value list: | | {&COMPANYPROPERTYMIRRORSETUPS} |
CompanyPropertySuspTax | character(20) | no | Suspended Tax |
| value list: | | {&SUSPDELAYTAXS} |
CompanyPropertySusTaxDateType | character(20) | no | Suspended Date Type |
| value list: | | {&TAXDATETYPES} |
CompanyPropertyDelTaxDateType | character(20) | no | Delayed Date Type |
| value list: | | {&TAXDATETYPES} |
CompanyPropertyDelTax | character(20) | no | Delayed Tax |
| value list: | | {&SUSPDELAYTAXS} |
CompanyPropertyOINetRestr | character(20) | yes | Open Item Netting Restriction |
| value list: | | {&COMPANYPROPERTYOINETRESTRS} |
CompanyPropertyIsOICrossCy | logical | yes | Open Item Cross Entity Allowed |
CompanyPropertyIsCompens | logical | yes | Customer/Supplier Compensation allowed |
CompanyPropertyIsWHT | logical | yes | Use Withholding Tax |
CompanyPropertyWHTNextNbr | integer | no | Next WHT Number |
CompanyPropertyIsDelPaid | logical | yes | Delay Until Paid Status |
CompanyPropertyIsSuspPaid | logical | yes | Suspend Until Paid Status |
CompanyPropertyIsGrIncAcc | logical | yes | Gross Income Accounting |
CompanyPropertyAutoBalYEFailAc | character(20) | no | Auto-balance Action |
| value list: | | {&YECLOSEAUTOBALANCECHECKS} |
CompanyPropertyIsAPTaxExcluded | logical | yes | AP Tax Excluded |
CompanyPropertyIsARTaxExcluded | logical | yes | AR Tax Excluded |
CompanyPropertyIsAPUseInvDate | logical | yes | AP Exchange Rate - Use Invoice Date |
CompanyPropertyIsARUseTaxDate | logical | yes | AR Exchange Rate - Use Taxpoint Date |
CompanyPropertyIsShowSEPAMsg | logical | yes | Show SEPA Messages |
CompanyPropertyIsARDiscInInvCy | logical | yes | Apply AR-Discounts in invoicing Entity |
tcCurrencyCode | character(3) | yes | Base Currency |
tcSafConceptCode | character(20) | no | SAF Concept Code |
tcUnitCode | character(20) | no | Time Unit of Measure |
tcActCostPostingJournalCode | character(8) | no | Daybook Code |
tcCompPropIntercoARDbGLCode | character(8) | no | Account |
tcCompPropIntercoARDbDivCode | character(8) | no | Sub-Account |
tcCompPropIntercoARDbCcCode | character(4) | no | Cost Center |
tcCompPropIntercoICDbGLCode | character(8) | no | Account |
tcCompPropIntercoICDbDivCode | character(8) | no | Sub-Account |
tcCompPropIntercoICDbCcCode | character(4) | no | Cost Center |
tcCompPropIntercoICCrGLCode | character(8) | no | Account |
tcCompPropIntercoICCrDivCode | character(8) | no | Sub-Account |
tcCompPropIntercoICCrCcCode | character(4) | no | Cost Center |
tcActSalaryPostingJournalCode | character(8) | no | Daybook Code |
tcSalarySafStructureCode | character(20) | no | Structure Code |
tcCompPropIntercoARCrGLCode | character(8) | no | Account |
tcBusinessRelationCode | character(20) | yes | Business Relation |
tcCostSafStructureCode | character(20) | no | Structure Code |
tcCompPropIntercoARCrDivCode | character(8) | no | Sub-Account |
tlManhourSurchargeExists | logical | no | Manhour Surcharge |
tcCompPropIntercoFADbCcCode | character(4) | no | Cost Center |
tcCompPropIntercoFACrGLCode | character(8) | no | Account |
tcCompPropIntercoFACrDivCode | character(8) | no | Sub-Account |
tcCompPropIntercoFADbGLCode | character(8) | no | Account |
tcCompPropIntercoARCrCcCode | character(4) | no | Cost Center |
tcCompPropIntercoFADbDivCode | character(8) | no | Sub-Account |
tcCompPropIntercoFACrCcCode | character(4) | no | Cost Center |
tcDomainCode | character(8) | no | Domain |
tcSharedAddNrCompanyCode | character(20) | no | Entity Code |
CompanyPropertyIsAPDiscInInvCy | logical | yes | Apply AP-Discounts in invoicing Entity |
CustomShort0 | character(20) | no | Custom Short Field |
CustomShort1 | character(20) | no | Custom Short Field |
CustomShort2 | character(20) | no | Custom Short Field |
CustomShort3 | character(20) | no | Custom Short Field |
CustomShort4 | character(20) | no | Custom Short Field |
CustomShort5 | character(20) | no | Custom Short Field |
CustomShort6 | character(20) | no | Custom Short Field |
CustomShort7 | character(20) | no | Custom Short Field |
CustomShort8 | character(20) | no | Custom Short Field |
CustomShort9 | character(20) | no | Custom Short Field |
CustomCombo0 | character(20) | no | Custom Combo Field |
CustomCombo1 | character(20) | no | Custom Combo Field |
CustomCombo2 | character(20) | no | Custom Combo Field |
CustomCombo3 | character(20) | no | Custom Combo Field |
CustomCombo4 | character(20) | no | Custom Combo Field |
CustomCombo5 | character(20) | no | Custom Combo Field |
CustomCombo6 | character(20) | no | Custom Combo Field |
CustomCombo7 | character(20) | no | Custom Combo Field |
CustomCombo8 | character(20) | no | Custom Combo Field |
CustomCombo9 | character(20) | no | Custom Combo Field |
CustomLong0 | character(255) | no | Custom Long Field |
CustomLong1 | character(255) | no | Custom Long Field |
CustomNote | character(2000) | no | Custom Note Field |
CustomDate0 | date | no | Custom Date Field |
CustomDate1 | date | no | Custom Date Field |
CustomDate2 | date | no | Custom Date Field |
CustomDate3 | date | no | Custom Date Field |
CustomDate4 | date | no | Custom Date Field |
CustomInteger0 | integer | no | Custom Integer Field |
CustomInteger1 | integer | no | Custom Integer Field |
CustomInteger2 | integer | no | Custom Integer Field |
CustomInteger3 | integer | no | Custom Integer Field |
CustomInteger4 | integer | no | Custom Integer Field |
CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
CustomShort10 | character(20) | no | Custom Short Field |
CustomShort11 | character(20) | no | Custom Short Field |
CustomShort12 | character(20) | no | Custom Short Field |
CustomShort13 | character(20) | no | Custom Short Field |
CustomShort14 | character(20) | no | Custom Short Field |
CustomCombo10 | character(20) | no | Custom Combo Field |
CustomCombo11 | character(20) | no | Custom Combo Field |
CustomCombo12 | character(20) | no | Custom Combo Field |
CustomCombo13 | character(20) | no | Custom Combo Field |
CustomCombo14 | character(20) | no | Custom Combo Field |
LastModifiedDate | date | no | Last Modified Date |
LastModifiedTime | integer | no | Last Modified Time |
LastModifiedUser | character(20) | no | Last Modified User |
QADC02 | character | no | unused QAD reserved field |
QADT01 | date | no | unused QAD reserved field |
QADD01 | decimal(10) | no | unused QAD reserved field |
QADC01 | character(40) | no | unused QAD reserved field |
tc_Rowid | character | yes | primary index |
tc_ParentRowid | character | no | empty string |
tc_Status | character | no | update status |