|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Company Info
Table Name: CINF
Table Description: Company Info
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Version | Version | Int | 11 | - | Â | Â | Â |
| CompnyName | Company Name | nVarChar | 200 | - | Â | Â | Â |
| Flags | Flags | nVarChar | 50 | - | NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN | Â | Â |
| InfoL1 | InfoL1 | Int | 11 | - | Â | Â | Â |
| InfoL2 | InfoL2 | Int | 11 | - | Â | Â | Â |
| InfoA1 | InfoA1 | nVarChar | 128 | - | Â | Â | Â |
| InfoA2 | InfoA2 | nVarChar | 50 | - | Â | Â | Â |
| ACTStamp | ACT Stamp | Int | 11 | - | 0 | Â | Â |
| ADMStamp | ADM Stamp | Int | 11 | - | 0 | Â | Â |
| RTTStamp | RTT Stamp | Int | 11 | - | 0 | Â | Â |
| CINFStamp | CINF Stamp | Int | 11 | - | 0 | Â | Â |
| LawsSet | Laws Set | nVarChar | 3 | - | Â | Â | Â |
| EnblVatGrp | Tax System | VarChar | 1 | - | Â | O | One Tax |
| Â | Â | Â | Â | Â | Â | L | Tax per Row |
| Â | Â | Â | Â | Â | Â | C | Tax per BP |
| EnblVTGPmn | Use Tax Groups in Payments | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| VatOOS_O | Tax Definition | nVarChar | 8 | - | Â | Â | Â |
| VatOOS_I | Tax Exempt Revenue Account | nVarChar | 8 | - | Â | Â | Â |
| VatStnd_O | Tax Standard O | nVarChar | 8 | - | Â | Â | Â |
| VatStnd_I | Tax Standard I | nVarChar | 8 | - | Â | Â | Â |
| VatExmpt_O | Tax Exempt O | nVarChar | 8 | - | Â | Â | Â |
| VatExmpt_I | Tax Exempt I | nVarChar | 8 | - | Â | Â | Â |
| VatHalf_O | Tax Definition | nVarChar | 8 | - | Â | Â | Â |
| VatHalf_I | Tax Definition | nVarChar | 8 | - | Â | Â | Â |
| VatZrRt_O | Tax Zero Rate O | nVarChar | 8 | - | Â | Â | Â |
| VatZrRt_I | Tax Zero Rate I | nVarChar | 8 | - | Â | Â | Â |
| MaxActGrps | Max. No. of Account Groups | Int | 11 | - | Â | Â | Â |
| EnblDctSrc | Enable Deduction at Source | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblRCN | Enable Retail Chain Stores | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblCorINV | Enable Correction Invoice | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblCshRep | Enable Cash Report | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblIRTRep | Enable Interest Report | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblTrnRep | Enable Turnover Report | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblVPMRep | Enable Payments Report | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblACTRep | Enable Adv. Corp. Tax Report | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblFTZ | Enable Free Trade Zone | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblSlfPCH | Enable Self A/P Invoice | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblPCHUpd | Enable Purchase Trans. Update | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblRsvINV | Enable Reserve Invoice | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblRTDnld | Enable Rates Download | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RTTDnldAdr | Rates Download Web Address | nVarChar | 254 | - | Â | Â | Â |
| ZPrcCode | Zero Center Code | nVarChar | 8 | - | Â | Â | Â |
| EnblExpns | Enable Freight Management | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblRtrRep | Enable Returns Report | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| IsEC | European Countries | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblCshDsc | Enable Cash Discount | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Â | Â | Â | Â | Â | Â | V | No Tax Adjustment |
| EnblLostCD | Enable Lost Cash Discount | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| NumActLvls | No. of Account Group Levels | Int | 11 | - | Â | Â | Â |
| EnblRealRD | Enable Realized Rate Diff. | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblVTGNoD | Enable Tax on Down Payment | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblGLManP | Enable Manual Postings in Control Account | VarChar | 1 | - | Â | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| EnblOptVIP | Enable Optional Tax in Payments | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblActCrC | Enable Account Currency Change | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblFrnAct | Enable Foreign Item Account | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblECAct | Enable EU Item Account | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblECRpt | Enable 349 Report | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblRound | Enable Rounding | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblPrVatS | Enable Print Tax Amount | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblYrTrns | Enable Year Transfer | VarChar | 1 | - | Â | Y | Year Transfer |
| Â | Â | Â | Â | Â | Â | N | No |
| Â | Â | Â | Â | Â | Â | A | Data Archive |
| EnblActTtl | Enable Account Title | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblDocWrn | Enable No Base Doc. Alert | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ActSegNum | No. of Segments | Int | 6 | - | 0 | Â | Â |
| EnbSgmnAct | Enable Account Segmentation | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SizeOfSeg0 | Size of Segment 0 | Int | 6 | - | 0 | Â | Â |
| SizeOfSeg1 | Size of Segment 1 | Int | 6 | - | 0 | Â | Â |
| SizeOfSeg2 | Size of Segment 2 | Int | 6 | - | 0 | Â | Â |
| SizeOfSeg3 | Size of Segment 3 | Int | 6 | - | 0 | Â | Â |
| SizeOfSeg4 | Size of Segment 4 | Int | 6 | - | 0 | Â | Â |
| SizeOfSeg5 | Size of Segment 5 | Int | 6 | - | 0 | Â | Â |
| SizeOfSeg6 | Size of Segment 6 | Int | 6 | - | 0 | Â | Â |
| SizeOfSeg7 | Size of Segment 7 | Int | 6 | - | 0 | Â | Â |
| SizeOfSeg8 | Size of Segment 8 | Int | 6 | - | 0 | Â | Â |
| SizeOfSeg9 | Size of Segment 9 | Int | 6 | - | 0 | Â | Â |
| Rprt1099 | 1099 Report | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| MultiAddss | Multi Address | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnbDunning | Enable Dunning | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnbQtyEDln | Allow Qty in Delivery Note to Exceed Base Doc. Qty | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Itw1Date | Next Alert Date | Date | 8 | - | Â | Â | Â |
| Itw1Time | Next Alert Time | Int | 11 | - | Â | Â | Â |
| Itw1Count | ITW1 Counter | Int | 11 | - | Â | Â | Â |
| EnbPayRef | Calculate Payment Ref. No. | VarChar | 1 | - | Â | Y | Payment Reference No. |
| Â | Â | Â | Â | Â | Â | N | No |
| Â | Â | Â | Â | Â | Â | I | ISR Reference |
| EnblDfrTax | Enable Deferred Tax | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblClsPr | Enable Period-End Closing | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblTaxEL | Enable Tax Exemption Letter | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnableBOE | Enable Bill of Exchange | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnableWHT | Enable WTax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblEquVat | Enable Equalization Tax | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblFAsset | Enable Fixed Assets | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblDoubt | Enable Doubtful Debts | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RateBase | Base Date for Exchange Rate | VarChar | 1 | - | P | P | Posting Date |
| Â | Â | Â | Â | Â | Â | T | Document Date |
| BOEStatClo | Allow Closed Status for Bill of Exchange | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ARDocsInWT | Enable WTax in A/R Docs | VarChar | 1 | - | Â | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| BISBnkCnt | BISR Bank Country/Region | nVarChar | 3 | - | Â | Â | Â |
| BISRBnkCd | BISR Bank No. | nVarChar | 30 | - | Â | Â | Â |
| BISRBnkAc | BISR Bank Account | nVarChar | 50 | - | Â | Â | Â |
| BISRBranch | BISR Branch | nVarChar | 50 | - | Â | Â | Â |
| EnblBPConn | Enable BP Cards Connection | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblVATDat | Enable VAT Date | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblStAgRp | Enable Stock Aging Report | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblCARepo | Enable Control Account Repost | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblMatRev | Enable Inventory Revaluation | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblMBPRec | Enable Multiple BPs Reconcil. | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CshDscGros | Cash Discount Flag For CN, HK | VarChar | 1 | - | N | Â | Â |
| EnblTaxInv | Enable Tax Invoices | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblCorAct | Enable Correspondence of Accts | VarChar | 1 | - | Â | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| EnblRuDIP | Enable RU Delivery & Invoice | VarChar | 1 | - | Y | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| EnblCurDec | Enable Decimal Places | VarChar | 1 | - | Â | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| EnblPayMtd | Enable Payment Method on Inv. | VarChar | 1 | - | Â | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| EnblBaseUn | Enable UoM on Invoice | VarChar | 1 | - | Â | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| EnblVATAna | Enable VAT Analytics Report | VarChar | 1 | - | Â | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| EnblExREnh | Enable Frgn. Curr. Valuation | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| VATGrpCal | Enable VAT Calculation by Grp | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| MaxChoose | No. of Choose from List Rows | Int | 11 | - | Â | Â | Â |
| EnblInfla | Enable Inflation | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblLAWHT | Enable Latin America WHT | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblRTWHT | Enable Rounding Type WHT | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ChkQunty | Enable Check Quantity In RDR | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SriMngSys | SRI Management System | VarChar | 1 | - | R | A | On Every Transaction |
| Â | Â | Â | Â | Â | Â | R | On Release Only |
| BtchMngSys | Batch Management System | VarChar | 1 | - | R | A | On Every Transaction |
| Â | Â | Â | Â | Â | Â | R | On Release Only |
| SriCreatIn | Auto SRI creation on receipt | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| EnblFolio | Enable Folio Numbers | nVarChar | 2 | - | Â | N | No |
| Â | Â | Â | Â | Â | Â | CL | Chile |
| Â | Â | Â | Â | Â | Â | MX | Mexico |
| EnblDocSbT | Enable Document Sub-type | nVarChar | 2 | - | Â | N | No |
| Â | Â | Â | Â | Â | Â | CL | Chile |
| Â | Â | Â | Â | Â | Â | AR | Argentina |
| Â | Â | Â | Â | Â | Â | CR | Costa Rica |
| Â | Â | Â | Â | Â | Â | GT | Guatemala |
| Â | Â | Â | Â | Â | Â | PA | Panama |
| Â | Â | Â | Â | Â | Â | MX | Mexico |
| Â | Â | Â | Â | Â | Â | IN | India |
| IepsPayer | IEPS Payer | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DaysOrdCnc | Default Days for Ord. Canc. | Int | 11 | - | 30 | Â | Â |
| EnblLATaxS | Enable Latin America Tax Sys | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PercOfAcq | Percent of Total Acquisition | Num | 19.6 | - | Â | Â | Â |
| MinBaseDoc | Minimum Base Amount per Doc | Num | 19.6 | - | Â | Â | Â |
| EnblDpmJdt | Create JE rows in Down Pmnt | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblDownP | Down Payment | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblNDdctC | Enable Non Deduct VAT Per Card | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DocNmMtd | Enable Sharing Series | VarChar | 1 | - | Â | Y | YES |
| Â | Â | Â | Â | Â | Â | N | No. |
| DoFilter | Data Ownership Indication | VarChar | 1 | - | N | Y | YES |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblOnPDCh | Enable Opened Postdated Checks | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblOnWnCr | Open Window for Credit Voucher | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblDefInx | Enable Define Indexes | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblMxComm | Enable Max Commitment | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblIndxOp | Enable Index Option | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblSbtCVo | Enable Submit Credit Voucher | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| MinAmntOAP | Minimum Amount for Appndix O&P | Num | 19.6 | - | Â | Â | Â |
| CredSumm | Credit Card Summary | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PostdChk | Postdated Check | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PostdCred | Postdated Credit Voucher | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CredVend | Credit Vendors | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| WkoStatus | Old Work Order Status | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DispTrByDf | Display Transactions by Dflt | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| stampTax | Default Stamp Tax | nVarChar | 8 | OVTG | Â | Â | Â |
| MinAmntAL | Minimum Amount for Annual List | Num | 19.6 | - | Â | Â | Â |
| BlockZeroQ | Block Stock Negative Quantity | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AutoCrIns | Auto Create Customer Eq Card | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnbRepomo | Enable Inflation for Cash Act | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RFCValidat | Enable RFC Validations | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| MxDcsInPmt | Max. Number of Documents in Payment | Int | 11 | - | 0 | Â | Â |
| RelStkNoPr | Enable Stock Release without Item Cost | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CashDisc | Cash Discount In Document | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnableSMS | Enable SMS | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblIndic | Enable Indicator | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnbFedTax | Enable Federal Tax ID | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblCounty | Enable County | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Language | Language on Create Company | Int | 11 | - | Â | Â | Â |
| ChkIntgUpd | Check Data Integrity On Update | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ChkIntgCre | Check Data Integrity On Create | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BisBnkAcKy | BISR Bank Account Key | Int | 11 | DSC1 | Â | Â | Â |
| EnbZeroDec | Enable Print Check Show Zero Decimal | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnbDecWord | Show Check Decimal in Words | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ChkWrdOnly | Add the word Only in checks | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnBnkStmnt | Bank Statement Processing | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CalcVatGrp | Group Lines in VAT Calculation | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TaxSysType | Defines Tax Calculation System | VarChar | 1 | - | Â | A | Preconfigured Formula with Jurisdiction Support |
| Â | Â | Â | Â | Â | Â | B | User-Defined Formula |
| Â | Â | Â | Â | Â | Â | C | Preconfigured Formula |
| Â | Â | Â | Â | Â | Â | M | Fixed implementation with jurisdiction support |
| Â | Â | Â | Â | Â | Â | S | Fixed implementation |
| ESEnabled | Is Event Sender enabled? | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Â | Â | Â | Â | Â | Â | C | Customize |
| RateTotal | Use rate for minor total calc. | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| CompanyHis | Create/Upgrade History | Text | 16 | - | Â | Â | Â |
| EnblAssVal | Enable Assessable Value | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CompanySta | Company Status | VarChar | 1 | - | U | V | Valid |
| Â | Â | Â | Â | Â | Â | I | Invalid |
| Â | Â | Â | Â | Â | Â | U | Upgrading |
| Â | Â | Â | Â | Â | Â | A | Archived |
| Â | Â | Â | Â | Â | Â | S | Inventory Valuation Utility |
| Â | Â | Â | Â | Â | Â | P | Upgrade Simulation |
| Â | Â | Â | Â | Â | Â | C | Master Data Cleanup |
| Â | Â | Â | Â | Â | Â | L | Locked |
| eFRTActLvs | No. of Levels in Elect. FRT | Int | 11 | - | Â | Â | Â |
| TaxGrpType | Defines Tax Grouping Type | VarChar | 1 | - | C | C | Code |
| Â | Â | Â | Â | Â | Â | J | Jurisdiction |
| InstallNo | Installation Number | nVarChar | 30 | - | Â | Â | Â |
| IsOldPA | Is Old for PA | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| EnbNegDoc | Enable Negative Total in Doc | VarChar | 1 | - | Â | Â | Â |
| Algo | Encryption Algorithm | Int | 6 | - | Â | Â | Â |
| ArcComp | Archived Company | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| UpdatedTF | Is Updated Tax Formula | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| DARDBGUID | Readonly DB GUID for Archiving | nVarChar | 32 | - | Â | Â | Â |
| NegStoLv | Negative Stock: Check Level | VarChar | 1 | - | I | C | Company |
| Â | Â | Â | Â | Â | Â | W | Warehouse |
| Â | Â | Â | Â | Â | Â | I | Item Setting |
| SPNEnabled | Enable Transact. Notification | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PrsWkCntEb | Personal Work Center Enabled | VarChar | 1 | - | N | N | No Cockpit |
| Â | Â | Â | Â | Â | Â | Y | Normal Style Cockpit |
| Â | Â | Â | Â | Â | Â | F | Fiori Style Cockpit |
| DashbdEb | Dashboard Enabled | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BoxEffDate | Box Effective From Date | Date | 8 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| SnapShotId | Snapshot ID | Int | 11 | - | 0 | Â | Â |
| CreatedBy | Created By | VarChar | 1 | - | N | N | Â |
| Â | Â | Â | Â | Â | Â | P | Solution Packager |
| Â | Â | Â | Â | Â | Â | W | Express Configuration Wizard |
| B1SgtEb | B1 Suggest: Enable | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| IsHConEnv | Is in High Concurrency Env | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Â | Â | Â | Â | Â | Â | H | HANA |
| B1BuzzEb | Enable Streamwork Widget | VarChar | 1 | - | N | Â | Â |
| IMCEEnable | IMCE Enable | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DKeyId | Current Dynamic Key ID | nVarChar | 128 | - | Â | Â | Â |
| ResetDData | Reset Dyn. Key Data to Default | VarChar | 1 | - | N | Â | Â |
| ConvDifAct | Enable Conversion Diff. Acct | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BasEffDate | Base Effective From Date | Date | 8 | - | Â | Â | Â |
| oldFxAss | Has Used Old Fixed Assets | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| MaxRowsCFL | Max. Rows for Choose from List | Int | 11 | - | 0 | 0 | Unlimited |
| Â | Â | Â | Â | Â | Â | 5000 | 5000 |
| Â | Â | Â | Â | Â | Â | 10000 | 10000 |
| Â | Â | Â | Â | Â | Â | 50000 | 50000 |
| Â | Â | Â | Â | Â | Â | 100000 | 100000 |
| ColSel | Column Selection | Text | 16 | - | Â | Â | Â |
| EnblSPEDUF | Enable SPED Related UDFs | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DpmAffTot | Down Payment Affects Total | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AliasUpd | Installation Date | nVarChar | 254 | - | Â | Â | Â |
| TrailDays | Trial Days | Int | 6 | - | Â | Â | Â |
| TestComp | Test Comp. | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DashConf | Enable Side Bar | Text | 16 | - | Â | Â | Â |
| SideEnable | Enable Side Bar | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| IsPALInit | Is PAL Init. or Not | VarChar | 1 | - | N | Â | Â |
| PANAVer | Pervasive Version | Int | 11 | - | 0 | Â | Â |
| ExpEnable | Enable Expense Claim | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LastSsrDat | Last SSR upload date | Date | 8 | - | Â | Â | Â |
| LastSsrHsh | Last SSR upload date hash | nVarChar | 33 | - | Â | Â | Â |
| B1iTimeOut | B1i Request Timeout | Int | 11 | - | 30 | Â | Â |
| CpRfshEnbl | Enable Cockpit Auto Refresh | VarChar | 1 | - | N | Â | Â |
| CpRfshIntv | Cockpit Refresh Interval | Int | 11 | - | 300 | Â | Â |
| EnbMBFilt | Enable Filtering Mechanism by Branch | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CompnyGUID | Company GUID | nVarChar | 40 | - | Â | Â | Â |
| ShutTime | SAP Business One Shutdown Time | Int | 11 | - | Â | Â | Â |
| Migrated | Migrated DB | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Code | Code | Int | 11 | - | 1 | Â | Â |
| LastSsrTim | Last SSR Upload Time | Int | 11 | - | 0 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Version |
| OBJECT | Yes | Code |