biuan SAP® BUSINESS ONE SDK
SQL Administration / Company Info
DTW Administration / Setup / Inventory / Item Properties
API Company Service / Company Info
CINF - Company Info Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Version KEY UNIQUEVersionInt
11
PRIMARYYes
CompnyNameCompany NamenVarChar
100
FlagsFlagsnVarChar
50
NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
InfoL1InfoL1Int
11
InfoL2InfoL2Int
11
InfoA1InfoA1nVarChar
127
InfoA2InfoA2nVarChar
50
ACTStampACT StampInt
11
0
ADMStampADM StampInt
11
0
RTTStampRTT StampInt
11
0
CINFStampCINF StampInt
11
0
LawsSetLaws SetnVarChar
3
EnblVatGrpTax SystemVarChar
O) One Tax
L) Tax per Row
C) Tax per BP
1
EnblVTGPmnUse Tax Groups in PaymentsVarChar
Y) Yes
N) No
1
VatOOS_OTax DefinitionnVarChar
8
VatOOS_ITax Exempt Revenue AccountnVarChar
8
VatStnd_OTax Standard OnVarChar
8
VatStnd_ITax Standard InVarChar
8
VatExmpt_OTax Exempt OnVarChar
8
VatExmpt_ITax Exempt InVarChar
8
VatHalf_OTax DefinitionnVarChar
8
VatHalf_ITax DefinitionnVarChar
8
VatZrRt_OTax Zero Rate OnVarChar
8
VatZrRt_ITax Zero Rate InVarChar
8
MaxActGrpsMax. No. of Account GroupsInt
11
EnblDctSrcEnable Deduction at SourceVarChar
Y) Yes
N) No
1
EnblRCNEnable Retail Chain StoresVarChar
Y) Yes
N) No
1
EnblCorINVEnable Correction InvoiceVarChar
Y) Yes
N) No
1
EnblCshRepEnable Cash ReportVarChar
Y) Yes
N) No
1
EnblIRTRepEnable Interest ReportVarChar
Y) Yes
N) No
1
EnblTrnRepEnable Turnover ReportVarChar
Y) Yes
N) No
1
EnblVPMRepEnable Payments ReportVarChar
Y) Yes
N) No
1
EnblACTRepEnable Adv. Corp. Tax ReportVarChar
Y) Yes
N) No
1
EnblFTZEnable Free Trade ZoneVarChar
Y) Yes
N) No
1
EnblSlfPCHEnable Self A/P InvoiceVarChar
Y) Yes
N) No
1
EnblPCHUpdEnable Purchase Trans. UpdateVarChar
Y) Yes
N) No
1
EnblRsvINVEnable Reserve InvoiceVarChar
Y) Yes
N) No
1
EnblRTDnldEnable Rates DownloadVarChar
Y) Yes
N) No
1
RTTDnldAdrRates Download Web AddressnVarChar
127
ZPrcCodeZero Center CodenVarChar
8
EnblExpnsEnable Freight ManagementVarChar
Y) Yes
N) No
1
EnblRtrRepEnable Returns ReportVarChar
Y) Yes
N) No
1
IsECEuropean CountriesVarChar
Y) Yes
N) No
1
EnblCshDscEnable Cash DiscountVarChar
Y) Yes
N) No
V) No Tax Adjustment
1
EnblLostCDEnable Lost Cash DiscountVarChar
Y) Yes
N) No
1
NumActLvlsNo. of Account Group LevelsInt
11
EnblRealRDEnable Realized Rate Diff.VarChar
Y) Yes
N) No
1
EnblVTGNoDEnable Tax on Down PaymentVarChar
Y) Yes
N) No
1
Y
EnblGLManPEnable Manual Postings in Control AccounVarChar
N) No
Y) Yes
1
EnblOptVIPEnable Optional Tax in PaymentsVarChar
Y) Yes
N) No
1
EnblActCrCEnable Account Currency ChangeVarChar
Y) Yes
N) No
1
EnblFrnActEnable Foreign Item AccountVarChar
Y) Yes
N) No
1
EnblECActEnable EU Item AccountVarChar
Y) Yes
N) No
1
EnblECRptEnable 349 ReportVarChar
Y) Yes
N) No
1
EnblRoundEnable RoundingVarChar
Y) Yes
N) No
1
EnblPrVatSEnable Print Tax AmountVarChar
Y) Yes
N) No
1
EnblYrTrnsEnable Year TransferVarChar
Y) Year Transfer
N) No
A) Data Archive
1
EnblActTtlEnable Account TitleVarChar
Y) Yes
N) No
1
EnblDocWrnEnable No Base Doc. AlertVarChar
Y) Yes
N) No
1
ActSegNumNo. of SegmentsInt
6
0
EnbSgmnActEnable Account SegmentationVarChar
Y) Yes
N) No
1
SizeOfSeg0Size of Segment 0Int
6
0
SizeOfSeg1Size of Segment 1Int
6
0
SizeOfSeg2Size of Segment 2Int
6
0
SizeOfSeg3Size of Segment 3Int
6
0
SizeOfSeg4Size of Segment 4Int
6
0
SizeOfSeg5Size of Segment 5Int
6
0
SizeOfSeg6Size of Segment 6Int
6
0
SizeOfSeg7Size of Segment 7Int
6
0
SizeOfSeg8Size of Segment 8Int
6
0
SizeOfSeg9Size of Segment 9Int
6
0
Rprt10991099 ReportVarChar
Y) Yes
N) No
1
MultiAddssMulti AddressVarChar
Y) Yes
N) No
1
EnbDunningEnable DunningVarChar
Y) Yes
N) No
1
Y
EnbQtyEDlnAllow Qty in Delivery Note to Exceed BasVarChar
Y) Yes
N) No
1
Itw1DateNext Alert DateDate
8
Itw1TimeNext Alert TimeInt
11
Itw1CountITW1 CounterInt
11
EnbPayRefCalculate Payment Ref. No.VarChar
Y) Payment Reference No.
N) No
I) ISR Reference
1
EnblDfrTaxEnable Deferred TaxVarChar
Y) Yes
N) No
1
EnblClsPrEnable Period-End ClosingVarChar
Y) Yes
N) No
1
EnblTaxELEnable Tax Exemption LetterVarChar
Y) Yes
N) No
1
EnableBOEEnable Bill of ExchangeVarChar
Y) Yes
N) No
1
N
EnableWHTEnable WTaxVarChar
Y) Yes
N) No
1
N
EnblEquVatEnable Equalization TaxVarChar
Y) Yes
N) No
1
EnblFAssetEnable Fixed AssetsVarChar
Y) Yes
N) No
1
EnblDoubtEnable Doubtful DebtsVarChar
Y) Yes
N) No
1
RateBaseBase Date for Exchange RateVarChar
P) Posting Date
T) Document Date
1
P
BOEStatCloAllow Closed Status for Bill of ExchangeVarChar
Y) Yes
N) No
1
ARDocsInWTEnable WTax in A/R DocsVarChar
N) No
Y) Yes
1
BISBnkCntBISR Bank CountrynVarChar
3
BISRBnkCdBISR Bank No.nVarChar
30
BISRBnkAcBISR Bank AccountnVarChar
50
BISRBranchBISR BranchnVarChar
50
EnblBPConnEnable BP Cards ConnectionVarChar
Y) Yes
N) No
1
EnblVATDatEnable VAT DateVarChar
Y) Yes
N) No
1
EnblStAgRpEnable Stock Aging ReportVarChar
Y) Yes
N) No
1
EnblCARepoEnable Control Account RepostVarChar
Y) Yes
N) No
1
EnblMatRevEnable Inventory RevaluationVarChar
Y) Yes
N) No
1
EnblMBPRecEnable Multiple BPs Reconcil.VarChar
Y) Yes
N) No
1
CshDscGrosCash Discount Flag For CN, HKVarChar
1
N
EnblTaxInvEnable Tax InvoicesVarChar
Y) Yes
N) No
1
EnblCorActEnable Correspondence of AcctsVarChar
N) No
Y) Yes
1
EnblRuDIPEnable RU Delivery & InvoiceVarChar
N) No
Y) Yes
1
EnblCurDecEnable Decimal PlacesVarChar
N) No
Y) Yes
1
EnblPayMtdEnable Payment Method on Inv.VarChar
N) No
Y) Yes
1
EnblBaseUnEnable UoM on InvoiceVarChar
N) No
Y) Yes
1
EnblVATAnaEnable VAT Analytics ReportVarChar
N) No
Y) Yes
1
EnblExREnhEnable Frgn. Curr. ValuationVarChar
Y) Yes
N) No
1
VATGrpCalEnable VAT Calculation by GrpVarChar
Y) Yes
N) No
1
MaxChooseNo. of Choose from List RowsInt
11
0
EnblInflaEnable InflationVarChar
Y) Yes
N) No
1
EnblLAWHTEnable Latin America WHTVarChar
Y) Yes
N) No
1
EnblRTWHTEnable Rounding Type WHTVarChar
Y) Yes
N) No
1
ChkQuntyEnable Check Quantity In RDRVarChar
Y) Yes
N) No
1
N
SriMngSysSRI Management SystemVarChar
A) On Every Transaction
R) On Release Only
1
R
BtchMngSysBatch Management SystemVarChar
A) On Every Transaction
R) On Release Only
1
R
SriCreatInAuto SRI creation on receiptVarChar
N) No
Y) Yes
1
N
EnblFolioEnable Folio NumbersnVarChar
N) No
CL) Chile
MX) Mexico
2
EnblDocSbTEnable Document Sub-typenVarChar
N) No
CL) Chile
MX) Mexico
2
IepsPayerIEPS PayerVarChar
Y) Yes
N) No
1
N
DaysOrdCncDefault Days for Ord. Canc.Int
11
30
EnblLATaxSEnable Latin America Tax SysVarChar
Y) Yes
N) No
1
PercOfAcqPercent of Total AcquisitionNum
20
MinBaseDocMinimum Base Amount per DocNum
20
EnblDpmJdtCreate JE rows in Down PmntVarChar
Y) Yes
N) No
1
EnblDownPDown PaymentVarChar
Y) Yes
N) No
1
EnblNDdctCEnable Non Deduct VAT Per CardVarChar
Y) Yes
N) No
1
DocNmMtdEnable Sharing SeriesVarChar
Y) YES
N) No.
1
DoFilterData Ownership IndicationVarChar
Y) YES
N) No.
1
N
EnblOnPDChEnable Opened Postdated ChecksVarChar
Y) Yes
N) No
1
EnblOnWnCrOpen Window for Credit VoucherVarChar
Y) Yes
N) No
1
EnblDefInxEnable Define IndexesVarChar
Y) Yes
N) No
1
EnblMxCommEnable Max CommitmentVarChar
Y) Yes
N) No
1
EnblIndxOpEnable Index OptionVarChar
Y) Yes
N) No
1
EnblSbtCVoEnable Submit Credit VoucherVarChar
Y) Yes
N) No
1
MinAmntOAPMinimum Amount for Appndix O&PNum
20
CredSummCredit Card SummaryVarChar
Y) Yes
N) No
1
PostdChkPostdated CheckVarChar
Y) Yes
N) No
1
PostdCredPostdated Credit VoucherVarChar
Y) Yes
N) No
1
CredVendCredit VendorsVarChar
Y) Yes
N) No
1
WkoStatusOld Work Order StatusVarChar
Y) Yes
N) No
1
DispTrByDfDisplay Transactions by DfltVarChar
Y) Yes
N) No
1
Y
stampTaxDefault Stamp TaxnVarChar
8OVTG
Tax Definition
MinAmntALMinimum Amount for Annual ListNum
20
BlockZeroQBlock Stock Negative QuantityVarChar
Y) Yes
N) No
1
Y
AutoCrInsAuto Create Customer Eq CardVarChar
Y) Yes
N) No
1
N
EnbRepomoEnable Inflation for Cash ActVarChar
Y) Yes
N) No
1
RFCValidatEnable RFC ValidationsVarChar
Y) Yes
N) No
1
MxDcsInPmtMax. Number of Documents in PaymentInt
11
0
RelStkNoPrEnable Stock Release without Item CostVarChar
Y) Yes
N) No
1
N
CashDiscCash Discount In DocumentVarChar
Y) Yes
N) No
1
EnableSMSEnable SMSVarChar
Y) Yes
N) No
1
EnblIndicEnable IndicatorVarChar
Y) Yes
N) No
1
EnbFedTaxEnable Federal Tax IDVarChar
Y) Yes
N) No
1
EnblCountyEnable CountyVarChar
Y) Yes
N) No
1
LanguageLanguage on Create CompanyInt
6
ChkIntgUpdCheck Data Integrity On UpdateVarChar
Y) Yes
N) No
1
Y
ChkIntgCreCheck Data Integrity On CreateVarChar
Y) Yes
N) No
1
Y
BisBnkAcKyBISR Bank Account KeyInt
11DSC1
House Bank Accounts
EnbZeroDecEnable Print Check Show Zero DecimalVarChar
Y) Yes
N) No
1
N
EnbDecWordShow Check Decimal in WordsVarChar
Y) Yes
N) No
1
Y
ChkWrdOnlyAdd the word Only in checksVarChar
Y) Yes
N) No
1
EnBnkStmntBank Statement ProcessingVarChar
Y) Yes
N) No
1
N
CalcVatGrpGroup Lines in VAT CalculationVarChar
Y) Yes
N) No
1
TaxSysTypeDefines Tax Calculation SystemVarChar
A) Preconfigured Formula with Jurisdiction Support
B) User-Defined Formula
C) Preconfigured Formula
M) Fixed implementation with jurisdiction support
S) Fixed implementation
1
ESEnabledIs Event Sender enabled?VarChar
Y) Yes
N) No
C) Customize
1
N
RateTotalUse rate for minor total calc.VarChar
N) No
Y) Yes
1
N
CompanyHisCreate/Upgrade HistoryText
16
EnblAssValEnable Assessable ValueVarChar
Y) Yes
N) No
1
N
CompanyStaCompany StatusVarChar
V) Valid
I) Invalid
U) Upgrading
A) Archived
S) Inventory Valuation Utility
P) Upgrade Simulation
1
U
eFRTActLvsNo. of Levels in Elect. FRTInt
11
TaxGrpTypeDefines Tax Grouping TypeVarChar
C) Code
J) Jurisdiction
1
C
InstallNoInstallation NumbernVarChar
30
IsOldPAIs Old for PAVarChar
N) No
Y) Yes
1
N
EnbNegDocEnable Negative Total in DocVarChar
1
AlgoEncryption AlgorithmInt
6
ArcCompArchived CompanyVarChar
Y) Yes
N) No
1
N
UpdatedTFIs Updated Tax FormulaVarChar
N) No
Y) Yes
1
N
DARDBGUIDReadonly DB GUID for ArchivingnVarChar
32
NegStoLvNegative Stock: Check LevelVarChar
C) Company
W) Warehouse
I) Item Setting
1
I
SPNEnabledEnable Transact. NotificationVarChar
Y) Yes
N) No
1
Y
PrsWkCntEbPersonal Work Center EnabledVarChar
N) No Cockpit
Y) Normal Style Cockpit
F) Fiori Style Cockpit
1
N
DashbdEbDashboard EnabledVarChar
Y) Yes
N) No
1
N
BoxEffDateBox Effective From DateDate
8
LogInstancLog InstanceInt
11
0
UpdateDateDate of UpdateDate
8
UserSign2Updating UserInt
6OUSR
Users
SnapShotIdSnapshot IDInt
11
0
CreatedByCreated ByVarChar
N)
P) Solution Packager
W) Express Configuration Wizard
1
N
B1SgtEbB1 Suggest: EnableVarChar
Y) Yes
N) No
1
Y
IsHConEnvIs in High Concurrency EnvVarChar
Y) Yes
N) No
1
N
B1BuzzEbEnable Streamwork WidgetVarChar
1
N
IMCEEnableIMCE EnableVarChar
Y) Yes
N) No
1
N
DKeyIdCurrent Dynamic Key IDnVarChar
127
ResetDDataReset Dyn. Key Data to DefaultVarChar
1
N
ConvDifActEnable Conversion Diff. AcctVarChar
Y) Yes
N) No
1
Y
BasEffDateBase Effective From DateDate
8
oldFxAssHas Used Old Fixed AssetsVarChar
Y) Yes
N) No
1
N
MaxRowsCFLMax. Rows for Choose from ListInt
0
5000) 5000
10000) 10000
50000) 50000
100000) 100000
11
0
ColSelColumn SelectionText
16
EnblSPEDUFEnable SPED Related UDFsVarChar
Y) Yes
N) No
1
N
DpmAffTotDown Payment Affects TotalVarChar
Y) Yes
N) No
1
Y
AliasUpdInstallation DatenVarChar
127
TrailDaysTrial DaysInt
6
TestCompTest Comp.VarChar
Y) Yes
N) No
1
N
DashConfEnable Side BarText
16
SideEnableEnable Side BarVarChar
Y) Yes
N) No
1
N
IsPALInitIs PAL Init. or NotVarChar
1
N
PANAVerPervasive VersionInt
11
0

Table relationship map

SELECT statement

SELECT CINF.Version AS 'Version', CINF.CompnyName AS 'Company Name', CINF.Flags AS 'Flags', CINF.InfoL1 AS 'InfoL1', CINF.InfoL2 AS 'InfoL2', CINF.InfoA1 AS 'InfoA1', CINF.InfoA2 AS 'InfoA2', CINF.ACTStamp AS 'ACT Stamp', CINF.ADMStamp AS 'ADM Stamp', CINF.RTTStamp AS 'RTT Stamp', CINF.CINFStamp AS 'CINF Stamp', CINF.LawsSet AS 'Laws Set', CINF.EnblVatGrp AS 'Tax System', CINF.EnblVTGPmn AS 'Use Tax Groups in Payments', CINF.VatOOS_O AS 'Tax Definition', CINF.VatOOS_I AS 'Tax Exempt Revenue Account', CINF.VatStnd_O AS 'Tax Standard O', CINF.VatStnd_I AS 'Tax Standard I', CINF.VatExmpt_O AS 'Tax Exempt O', CINF.VatExmpt_I AS 'Tax Exempt I', CINF.VatHalf_O AS 'Tax Definition', CINF.VatHalf_I AS 'Tax Definition', CINF.VatZrRt_O AS 'Tax Zero Rate O', CINF.VatZrRt_I AS 'Tax Zero Rate I', CINF.MaxActGrps AS 'Max. No. of Account Groups', CINF.EnblDctSrc AS 'Enable Deduction at Source', CINF.EnblRCN AS 'Enable Retail Chain Stores', CINF.EnblCorINV AS 'Enable Correction Invoice', CINF.EnblCshRep AS 'Enable Cash Report', CINF.EnblIRTRep AS 'Enable Interest Report', CINF.EnblTrnRep AS 'Enable Turnover Report', CINF.EnblVPMRep AS 'Enable Payments Report', CINF.EnblACTRep AS 'Enable Adv. Corp. Tax Report', CINF.EnblFTZ AS 'Enable Free Trade Zone', CINF.EnblSlfPCH AS 'Enable Self A/P Invoice', CINF.EnblPCHUpd AS 'Enable Purchase Trans. Update', CINF.EnblRsvINV AS 'Enable Reserve Invoice', CINF.EnblRTDnld AS 'Enable Rates Download', CINF.RTTDnldAdr AS 'Rates Download Web Address', CINF.ZPrcCode AS 'Zero Center Code', CINF.EnblExpns AS 'Enable Freight Management', CINF.EnblRtrRep AS 'Enable Returns Report', CINF.IsEC AS 'European Countries', CINF.EnblCshDsc AS 'Enable Cash Discount', CINF.EnblLostCD AS 'Enable Lost Cash Discount', CINF.NumActLvls AS 'No. of Account Group Levels', CINF.EnblRealRD AS 'Enable Realized Rate Diff.', CINF.EnblVTGNoD AS 'Enable Tax on Down Payment', CINF.EnblGLManP AS 'Enable Manual Postings in Control Accoun', CINF.EnblOptVIP AS 'Enable Optional Tax in Payments', CINF.EnblActCrC AS 'Enable Account Currency Change', CINF.EnblFrnAct AS 'Enable Foreign Item Account', CINF.EnblECAct AS 'Enable EU Item Account', CINF.EnblECRpt AS 'Enable 349 Report', CINF.EnblRound AS 'Enable Rounding', CINF.EnblPrVatS AS 'Enable Print Tax Amount', CINF.EnblYrTrns AS 'Enable Year Transfer', CINF.EnblActTtl AS 'Enable Account Title', CINF.EnblDocWrn AS 'Enable No Base Doc. Alert', CINF.ActSegNum AS 'No. of Segments', CINF.EnbSgmnAct AS 'Enable Account Segmentation', CINF.SizeOfSeg0 AS 'Size of Segment 0', CINF.SizeOfSeg1 AS 'Size of Segment 1', CINF.SizeOfSeg2 AS 'Size of Segment 2', CINF.SizeOfSeg3 AS 'Size of Segment 3', CINF.SizeOfSeg4 AS 'Size of Segment 4', CINF.SizeOfSeg5 AS 'Size of Segment 5', CINF.SizeOfSeg6 AS 'Size of Segment 6', CINF.SizeOfSeg7 AS 'Size of Segment 7', CINF.SizeOfSeg8 AS 'Size of Segment 8', CINF.SizeOfSeg9 AS 'Size of Segment 9', CINF.Rprt1099 AS '1099 Report', CINF.MultiAddss AS 'Multi Address', CINF.EnbDunning AS 'Enable Dunning', CINF.EnbQtyEDln AS 'Allow Qty in Delivery Note to Exceed Bas', CINF.Itw1Date AS 'Next Alert Date', CINF.Itw1Time AS 'Next Alert Time', CINF.Itw1Count AS 'ITW1 Counter', CINF.EnbPayRef AS 'Calculate Payment Ref. No.', CINF.EnblDfrTax AS 'Enable Deferred Tax', CINF.EnblClsPr AS 'Enable Period-End Closing', CINF.EnblTaxEL AS 'Enable Tax Exemption Letter', CINF.EnableBOE AS 'Enable Bill of Exchange', CINF.EnableWHT AS 'Enable WTax', CINF.EnblEquVat AS 'Enable Equalization Tax', CINF.EnblFAsset AS 'Enable Fixed Assets', CINF.EnblDoubt AS 'Enable Doubtful Debts', CINF.RateBase AS 'Base Date for Exchange Rate', CINF.BOEStatClo AS 'Allow Closed Status for Bill of Exchange', CINF.ARDocsInWT AS 'Enable WTax in A/R Docs', CINF.BISBnkCnt AS 'BISR Bank Country', CINF.BISRBnkCd AS 'BISR Bank No.', CINF.BISRBnkAc AS 'BISR Bank Account', CINF.BISRBranch AS 'BISR Branch', CINF.EnblBPConn AS 'Enable BP Cards Connection', CINF.EnblVATDat AS 'Enable VAT Date', CINF.EnblStAgRp AS 'Enable Stock Aging Report', CINF.EnblCARepo AS 'Enable Control Account Repost', CINF.EnblMatRev AS 'Enable Inventory Revaluation', CINF.EnblMBPRec AS 'Enable Multiple BPs Reconcil.', CINF.CshDscGros AS 'Cash Discount Flag For CN, HK', CINF.EnblTaxInv AS 'Enable Tax Invoices', CINF.EnblCorAct AS 'Enable Correspondence of Accts', CINF.EnblRuDIP AS 'Enable RU Delivery & Invoice', CINF.EnblCurDec AS 'Enable Decimal Places', CINF.EnblPayMtd AS 'Enable Payment Method on Inv.', CINF.EnblBaseUn AS 'Enable UoM on Invoice', CINF.EnblVATAna AS 'Enable VAT Analytics Report', CINF.EnblExREnh AS 'Enable Frgn. Curr. Valuation', CINF.VATGrpCal AS 'Enable VAT Calculation by Grp', CINF.MaxChoose AS 'No. of Choose from List Rows', CINF.EnblInfla AS 'Enable Inflation', CINF.EnblLAWHT AS 'Enable Latin America WHT', CINF.EnblRTWHT AS 'Enable Rounding Type WHT', CINF.ChkQunty AS 'Enable Check Quantity In RDR', CINF.SriMngSys AS 'SRI Management System', CINF.BtchMngSys AS 'Batch Management System', CINF.SriCreatIn AS 'Auto SRI creation on receipt', CINF.EnblFolio AS 'Enable Folio Numbers', CINF.EnblDocSbT AS 'Enable Document Sub-type', CINF.IepsPayer AS 'IEPS Payer', CINF.DaysOrdCnc AS 'Default Days for Ord. Canc.', CINF.EnblLATaxS AS 'Enable Latin America Tax Sys', CINF.PercOfAcq AS 'Percent of Total Acquisition', CINF.MinBaseDoc AS 'Minimum Base Amount per Doc', CINF.EnblDpmJdt AS 'Create JE rows in Down Pmnt', CINF.EnblDownP AS 'Down Payment', CINF.EnblNDdctC AS 'Enable Non Deduct VAT Per Card', CINF.DocNmMtd AS 'Enable Sharing Series', CINF.DoFilter AS 'Data Ownership Indication', CINF.EnblOnPDCh AS 'Enable Opened Postdated Checks', CINF.EnblOnWnCr AS 'Open Window for Credit Voucher', CINF.EnblDefInx AS 'Enable Define Indexes', CINF.EnblMxComm AS 'Enable Max Commitment', CINF.EnblIndxOp AS 'Enable Index Option', CINF.EnblSbtCVo AS 'Enable Submit Credit Voucher', CINF.MinAmntOAP AS 'Minimum Amount for Appndix O&P', CINF.CredSumm AS 'Credit Card Summary', CINF.PostdChk AS 'Postdated Check', CINF.PostdCred AS 'Postdated Credit Voucher', CINF.CredVend AS 'Credit Vendors', CINF.WkoStatus AS 'Old Work Order Status', CINF.DispTrByDf AS 'Display Transactions by Dflt', CINF.stampTax AS 'Default Stamp Tax', CINF.MinAmntAL AS 'Minimum Amount for Annual List', CINF.BlockZeroQ AS 'Block Stock Negative Quantity', CINF.AutoCrIns AS 'Auto Create Customer Eq Card', CINF.EnbRepomo AS 'Enable Inflation for Cash Act', CINF.RFCValidat AS 'Enable RFC Validations', CINF.MxDcsInPmt AS 'Max. Number of Documents in Payment', CINF.RelStkNoPr AS 'Enable Stock Release without Item Cost', CINF.CashDisc AS 'Cash Discount In Document', CINF.EnableSMS AS 'Enable SMS', CINF.EnblIndic AS 'Enable Indicator', CINF.EnbFedTax AS 'Enable Federal Tax ID', CINF.EnblCounty AS 'Enable County', CINF.Language AS 'Language on Create Company', CINF.ChkIntgUpd AS 'Check Data Integrity On Update', CINF.ChkIntgCre AS 'Check Data Integrity On Create', CINF.BisBnkAcKy AS 'BISR Bank Account Key', CINF.EnbZeroDec AS 'Enable Print Check Show Zero Decimal', CINF.EnbDecWord AS 'Show Check Decimal in Words', CINF.ChkWrdOnly AS 'Add the word Only in checks', CINF.EnBnkStmnt AS 'Bank Statement Processing', CINF.CalcVatGrp AS 'Group Lines in VAT Calculation', CINF.TaxSysType AS 'Defines Tax Calculation System', CINF.ESEnabled AS 'Is Event Sender enabled?', CINF.RateTotal AS 'Use rate for minor total calc.', CINF.CompanyHis AS 'Create/Upgrade History', CINF.EnblAssVal AS 'Enable Assessable Value', CINF.CompanySta AS 'Company Status', CINF.eFRTActLvs AS 'No. of Levels in Elect. FRT', CINF.TaxGrpType AS 'Defines Tax Grouping Type', CINF.InstallNo AS 'Installation Number', CINF.IsOldPA AS 'Is Old for PA', CINF.EnbNegDoc AS 'Enable Negative Total in Doc', CINF.Algo AS 'Encryption Algorithm', CINF.ArcComp AS 'Archived Company', CINF.UpdatedTF AS 'Is Updated Tax Formula', CINF.DARDBGUID AS 'Readonly DB GUID for Archiving', CINF.NegStoLv AS 'Negative Stock: Check Level', CINF.SPNEnabled AS 'Enable Transact. Notification', CINF.PrsWkCntEb AS 'Personal Work Center Enabled', CINF.DashbdEb AS 'Dashboard Enabled', CINF.BoxEffDate AS 'Box Effective From Date', CINF.LogInstanc AS 'Log Instance', CINF.UpdateDate AS 'Date of Update', CINF.UserSign2 AS 'Updating User', CINF.SnapShotId AS 'Snapshot ID', CINF.CreatedBy AS 'Created By', CINF.B1SgtEb AS 'B1 Suggest: Enable', CINF.IsHConEnv AS 'Is in High Concurrency Env', CINF.B1BuzzEb AS 'Enable Streamwork Widget', CINF.IMCEEnable AS 'IMCE Enable', CINF.DKeyId AS 'Current Dynamic Key ID', CINF.ResetDData AS 'Reset Dyn. Key Data to Default', CINF.ConvDifAct AS 'Enable Conversion Diff. Acct', CINF.BasEffDate AS 'Base Effective From Date', CINF.oldFxAss AS 'Has Used Old Fixed Assets', CINF.MaxRowsCFL AS 'Max. Rows for Choose from List', CINF.ColSel AS 'Column Selection', CINF.EnblSPEDUF AS 'Enable SPED Related UDFs', CINF.DpmAffTot AS 'Down Payment Affects Total', CINF.AliasUpd AS 'Installation Date', CINF.TrailDays AS 'Trial Days', CINF.TestComp AS 'Test Comp.', CINF.DashConf AS 'Enable Side Bar', CINF.SideEnable AS 'Enable Side Bar', CINF.IsPALInit AS 'Is PAL Init. or Not', CINF.PANAVer AS 'Pervasive Version' FROM CINF AS CINF

Related information


Company Info CompanyInfo Object· Table: CINF
The CompanyInfo is a data structure related to the CompanyService. It includes initial parameters related to the company. The default values of part of the properties vary according to the country localization. Source table: CINF.
   Parent: Company Service CompanyService Service
House Bank Accounts DSC1 SQL Table

Tax Definition OVTG SQL Table

Users OUSR SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates