SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OPCH386A/P Invoice

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Administration
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.3CINF2191Company InfoAdministration
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT Version, CompnyName, Flags, InfoL1, InfoL2, InfoA1, InfoA2, ACTStamp, ADMStamp, RTTStamp, CINFStamp, LawsSet, EnblVatGrp, EnblVTGPmn, VatOOS_O, VatOOS_I, VatStnd_O, VatStnd_I, VatExmpt_O, VatExmpt_I, VatHalf_O, VatHalf_I, VatZrRt_O, VatZrRt_I, MaxActGrps, EnblDctSrc, EnblRCN, EnblCorINV, EnblCshRep, EnblIRTRep, EnblTrnRep, EnblVPMRep, EnblACTRep, EnblFTZ, EnblSlfPCH, EnblPCHUpd, EnblRsvINV, EnblRTDnld, RTTDnldAdr, ZPrcCode, EnblExpns, EnblRtrRep, IsEC, EnblCshDsc, EnblLostCD, NumActLvls, EnblRealRD, EnblVTGNoD, EnblGLManP, EnblOptVIP, EnblActCrC, EnblFrnAct, EnblECAct, EnblECRpt, EnblRound, EnblPrVatS, EnblYrTrns, EnblActTtl, EnblDocWrn, ActSegNum, EnbSgmnAct, SizeOfSeg0, SizeOfSeg1, SizeOfSeg2, SizeOfSeg3, SizeOfSeg4, SizeOfSeg5, SizeOfSeg6, SizeOfSeg7, SizeOfSeg8, SizeOfSeg9, Rprt1099, MultiAddss, EnbDunning, EnbQtyEDln, Itw1Date, Itw1Time, Itw1Count, EnbPayRef, EnblDfrTax, EnblClsPr, EnblTaxEL, EnableBOE, EnableWHT, EnblEquVat, EnblFAsset, EnblDoubt, RateBase, BOEStatClo, ARDocsInWT, BISBnkCnt, BISRBnkCd, BISRBnkAc, BISRBranch, EnblBPConn, EnblVATDat, EnblStAgRp, EnblCARepo, EnblMatRev, EnblMBPRec, CshDscGros, EnblTaxInv, EnblCorAct, EnblRuDIP, EnblCurDec, EnblPayMtd, EnblBaseUn, EnblVATAna, EnblExREnh, VATGrpCal, MaxChoose, EnblInfla, EnblLAWHT, EnblRTWHT, ChkQunty, SriMngSys, BtchMngSys, SriCreatIn, EnblFolio, EnblDocSbT, IepsPayer, DaysOrdCnc, EnblLATaxS, PercOfAcq, MinBaseDoc, EnblDpmJdt, EnblDownP, EnblNDdctC, DocNmMtd, DoFilter, EnblOnPDCh, EnblOnWnCr, EnblDefInx, EnblMxComm, EnblIndxOp, EnblSbtCVo, MinAmntOAP, CredSumm, PostdChk, PostdCred, CredVend, WkoStatus, DispTrByDf, stampTax, MinAmntAL, BlockZeroQ, AutoCrIns, EnbRepomo, RFCValidat, MxDcsInPmt, RelStkNoPr, CashDisc, EnableSMS, EnblIndic, EnbFedTax, EnblCounty, Language, ChkIntgUpd, ChkIntgCre, BisBnkAcKy, EnbZeroDec, EnbDecWord, ChkWrdOnly, EnBnkStmnt, CalcVatGrp, TaxSysType, ESEnabled, RateTotal, CompanyHis, EnblAssVal, CompanySta, eFRTActLvs, TaxGrpType, InstallNo, IsOldPA, EnbNegDoc, Algo, ArcComp, UpdatedTF, DARDBGUID, NegStoLv, SPNEnabled, PrsWkCntEb, DashbdEb, BoxEffDate, LogInstanc, UpdateDate, UserSign2, SnapShotId, CreatedBy, B1SgtEb, IsHConEnv, B1BuzzEb, IMCEEnable, DKeyId, ResetDData, ConvDifAct, BasEffDate, oldFxAss, MaxRowsCFL, ColSel, EnblSPEDUF, DpmAffTot, AliasUpd, TrailDays, TestComp, DashConf, SideEnable, IsPALInit, PANAVer, ExpEnable, LastSsrDat, LastSsrHsh, B1iTimeOut, CpRfshEnbl, CpRfshIntv, EnbMBFilt, CompnyGUID, ShutTime FROM CINF

TOPB1 9.3  | CINF COLUMNS

ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1VersionVersionint110 Allow NULL? 
2CompnyNameCompany Namenvarchar1000 Allow NULL? 
3FlagsFlagsnvarchar500NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN Allow NULL? 
4InfoL1InfoL1int110 Allow NULL? 
5InfoL2InfoL2int110 Allow NULL? 
6InfoA1InfoA1nvarchar1280 Allow NULL? 
7InfoA2InfoA2nvarchar500 Allow NULL? 
8ACTStampACT Stampint1100 Allow NULL? 
9ADMStampADM Stampint1100 Allow NULL? 
10RTTStampRTT Stampint1100 Allow NULL? 
11CINFStampCINF Stampint1100 Allow NULL? 
12LawsSetLaws Setnvarchar30 Allow NULL? 
13EnblVatGrpTax Systemchar10C=Tax per BP, L=Tax per Row, O=One Tax Allow NULL? 
14EnblVTGPmnUse Tax Groups in Paymentschar10N=No, Y=Yes Allow NULL? 
15VatOOS_OTax Definitionnvarchar80 Allow NULL? 
16VatOOS_ITax Exempt Revenue Accountnvarchar80 Allow NULL? 
17VatStnd_OTax Standard Onvarchar80 Allow NULL? 
18VatStnd_ITax Standard Invarchar80 Allow NULL? 
19VatExmpt_OTax Exempt Onvarchar80 Allow NULL? 
20VatExmpt_ITax Exempt Invarchar80 Allow NULL? 
21VatHalf_OTax Definitionnvarchar80 Allow NULL? 
22VatHalf_ITax Definitionnvarchar80 Allow NULL? 
23VatZrRt_OTax Zero Rate Onvarchar80 Allow NULL? 
24VatZrRt_ITax Zero Rate Invarchar80 Allow NULL? 
25MaxActGrpsMax. No. of Account Groupsint110 Allow NULL? 
26EnblDctSrcEnable Deduction at Sourcechar10N=No, Y=Yes Allow NULL? 
27EnblRCNEnable Retail Chain Storeschar10N=No, Y=Yes Allow NULL? 
28EnblCorINVEnable Correction Invoicechar10N=No, Y=Yes Allow NULL? 
29EnblCshRepEnable Cash Reportchar10N=No, Y=Yes Allow NULL? 
30EnblIRTRepEnable Interest Reportchar10N=No, Y=Yes Allow NULL? 
31EnblTrnRepEnable Turnover Reportchar10N=No, Y=Yes Allow NULL? 
32EnblVPMRepEnable Payments Reportchar10N=No, Y=Yes Allow NULL? 
33EnblACTRepEnable Adv. Corp. Tax Reportchar10N=No, Y=Yes Allow NULL? 
34EnblFTZEnable Free Trade Zonechar10N=No, Y=Yes Allow NULL? 
35EnblSlfPCHEnable Self A/P Invoicechar10N=No, Y=Yes Allow NULL? 
36EnblPCHUpdEnable Purchase Trans. Updatechar10N=No, Y=Yes Allow NULL? 
37EnblRsvINVEnable Reserve Invoicechar10N=No, Y=Yes Allow NULL? 
38EnblRTDnldEnable Rates Downloadchar10N=No, Y=Yes Allow NULL? 
39RTTDnldAdrRates Download Web Addressnvarchar2540 Allow NULL? 
40ZPrcCodeZero Center Codenvarchar80 Allow NULL? 
41EnblExpnsEnable Freight Managementchar10N=No, Y=Yes Allow NULL? 
42EnblRtrRepEnable Returns Reportchar10N=No, Y=Yes Allow NULL? 
43IsECEuropean Countrieschar10N=No, Y=Yes Allow NULL? 
44EnblCshDscEnable Cash Discountchar10N=No, V=No Tax Adjustment, Y=Yes Allow NULL? 
45EnblLostCDEnable Lost Cash Discountchar10N=No, Y=Yes Allow NULL? 
46NumActLvlsNo. of Account Group Levelsint110 Allow NULL? 
47EnblRealRDEnable Realized Rate Diff.char10N=No, Y=Yes Allow NULL? 
48EnblVTGNoDEnable Tax on Down Paymentchar10YN=No, Y=Yes Allow NULL? 
49EnblGLManPEnable Manual Postings in Control Accountchar10N=No, Y=Yes Allow NULL? 
50EnblOptVIPEnable Optional Tax in Paymentschar10N=No, Y=Yes Allow NULL? 
51EnblActCrCEnable Account Currency Changechar10N=No, Y=Yes Allow NULL? 
52EnblFrnActEnable Foreign Item Accountchar10N=No, Y=Yes Allow NULL? 
53EnblECActEnable EU Item Accountchar10N=No, Y=Yes Allow NULL? 
54EnblECRptEnable 349 Reportchar10N=No, Y=Yes Allow NULL? 
55EnblRoundEnable Roundingchar10N=No, Y=Yes Allow NULL? 
56EnblPrVatSEnable Print Tax Amountchar10N=No, Y=Yes Allow NULL? 
57EnblYrTrnsEnable Year Transferchar10A=Data Archive, N=No, Y=Year Transfer Allow NULL? 
58EnblActTtlEnable Account Titlechar10N=No, Y=Yes Allow NULL? 
59EnblDocWrnEnable No Base Doc. Alertchar10N=No, Y=Yes Allow NULL? 
60ActSegNumNo. of Segmentsint600 Allow NULL? 
61EnbSgmnActEnable Account Segmentationchar10N=No, Y=Yes Allow NULL? 
62SizeOfSeg0Size of Segment 0int600 Allow NULL? 
63SizeOfSeg1Size of Segment 1int600 Allow NULL? 
64SizeOfSeg2Size of Segment 2int600 Allow NULL? 
65SizeOfSeg3Size of Segment 3int600 Allow NULL? 
66SizeOfSeg4Size of Segment 4int600 Allow NULL? 
67SizeOfSeg5Size of Segment 5int600 Allow NULL? 
68SizeOfSeg6Size of Segment 6int600 Allow NULL? 
69SizeOfSeg7Size of Segment 7int600 Allow NULL? 
70SizeOfSeg8Size of Segment 8int600 Allow NULL? 
71SizeOfSeg9Size of Segment 9int600 Allow NULL? 
72Rprt10991099 Reportchar10N=No, Y=Yes Allow NULL? 
73MultiAddssMulti Addresschar10N=No, Y=Yes Allow NULL? 
74EnbDunningEnable Dunningchar10YN=No, Y=Yes Allow NULL? 
75EnbQtyEDlnAllow Qty in Delivery Note to Exceed Base Doc. Qtychar10N=No, Y=Yes Allow NULL? 
76Itw1DateNext Alert Datedate80
77Itw1TimeNext Alert Timeint110 Allow NULL? 
78Itw1CountITW1 Counterint110 Allow NULL? 
79EnbPayRefCalculate Payment Ref. No.char10I=ISR Reference, N=No, Y=Payment Reference No. Allow NULL? 
80EnblDfrTaxEnable Deferred Taxchar10N=No, Y=Yes Allow NULL? 
81EnblClsPrEnable Period-End Closingchar10N=No, Y=Yes Allow NULL? 
82EnblTaxELEnable Tax Exemption Letterchar10N=No, Y=Yes Allow NULL? 
83EnableBOEEnable Bill of Exchangechar10NN=No, Y=Yes Allow NULL? 
84EnableWHTEnable WTaxchar10NN=No, Y=Yes Allow NULL? 
85EnblEquVatEnable Equalization Taxchar10N=No, Y=Yes Allow NULL? 
86EnblFAssetEnable Fixed Assetschar10N=No, Y=Yes Allow NULL? 
87EnblDoubtEnable Doubtful Debtschar10N=No, Y=Yes Allow NULL? 
88RateBaseBase Date for Exchange Ratechar10PP=Posting Date, T=Document Date Allow NULL? 
89BOEStatCloAllow Closed Status for Bill of Exchangechar10N=No, Y=Yes Allow NULL? 
90ARDocsInWTEnable WTax in A/R Docschar10N=No, Y=Yes Allow NULL? 
91BISBnkCntBISR Bank Countrynvarchar30 Allow NULL? 
92BISRBnkCdBISR Bank No.nvarchar300 Allow NULL? 
93BISRBnkAcBISR Bank Accountnvarchar500 Allow NULL? 
94BISRBranchBISR Branchnvarchar500 Allow NULL? 
95EnblBPConnEnable BP Cards Connectionchar10N=No, Y=Yes Allow NULL? 
96EnblVATDatEnable VAT Datechar10N=No, Y=Yes Allow NULL? 
97EnblStAgRpEnable Stock Aging Reportchar10N=No, Y=Yes Allow NULL? 
98EnblCARepoEnable Control Account Repostchar10N=No, Y=Yes Allow NULL? 
99EnblMatRevEnable Inventory Revaluationchar10N=No, Y=Yes Allow NULL? 
100EnblMBPRecEnable Multiple BPs Reconcil.char10N=No, Y=Yes Allow NULL? 
101CshDscGrosCash Discount Flag For CN, HKchar10N Allow NULL? 
102EnblTaxInvEnable Tax Invoiceschar10N=No, Y=Yes Allow NULL? 
103EnblCorActEnable Correspondence of Acctschar10N=No, Y=Yes Allow NULL? 
104EnblRuDIPEnable RU Delivery & Invoicechar10YN=No, Y=Yes Allow NULL? 
105EnblCurDecEnable Decimal Placeschar10N=No, Y=Yes Allow NULL? 
106EnblPayMtdEnable Payment Method on Inv.char10N=No, Y=Yes Allow NULL? 
107EnblBaseUnEnable UoM on Invoicechar10N=No, Y=Yes Allow NULL? 
108EnblVATAnaEnable VAT Analytics Reportchar10N=No, Y=Yes Allow NULL? 
109EnblExREnhEnable Frgn. Curr. Valuationchar10N=No, Y=Yes Allow NULL? 
110VATGrpCalEnable VAT Calculation by Grpchar10N=No, Y=Yes Allow NULL? 
111MaxChooseNo. of Choose from List Rowsint1100 Allow NULL? 
112EnblInflaEnable Inflationchar10N=No, Y=Yes Allow NULL? 
113EnblLAWHTEnable Latin America WHTchar10N=No, Y=Yes Allow NULL? 
114EnblRTWHTEnable Rounding Type WHTchar10N=No, Y=Yes Allow NULL? 
115ChkQuntyEnable Check Quantity In RDRchar10NN=No, Y=Yes Allow NULL? 
116SriMngSysSRI Management Systemchar10RA=On Every Transaction, R=On Release Only Allow NULL? 
117BtchMngSysBatch Management Systemchar10RA=On Every Transaction, R=On Release Only Allow NULL? 
118SriCreatInAuto SRI creation on receiptchar10NN=No, Y=Yes Allow NULL? 
119EnblFolioEnable Folio Numbersnvarchar20CL=Chile, MX=Mexico, N=No Allow NULL? 
120EnblDocSbTEnable Document Sub-typenvarchar20CL=Chile, IN=India, MX=Mexico, N=No Allow NULL? 
121IepsPayerIEPS Payerchar10NN=No, Y=Yes Allow NULL? 
122DaysOrdCncDefault Days for Ord. Canc.int11030 Allow NULL? 
123EnblLATaxSEnable Latin America Tax Syschar10N=No, Y=Yes Allow NULL? 
124PercOfAcqPercent of Total Acquisitionnum196 Allow NULL? 
125MinBaseDocMinimum Base Amount per Docnum196 Allow NULL? 
126EnblDpmJdtCreate JE rows in Down Pmntchar10N=No, Y=Yes Allow NULL? 
127EnblDownPDown Paymentchar10N=No, Y=Yes Allow NULL? 
128EnblNDdctCEnable Non Deduct VAT Per Cardchar10N=No, Y=Yes Allow NULL? 
129DocNmMtdEnable Sharing Serieschar10N=No., Y=YES Allow NULL? 
130DoFilterData Ownership Indicationchar10NN=No, Y=YES Allow NULL? 
131EnblOnPDChEnable Opened Postdated Checkschar10N=No, Y=Yes Allow NULL? 
132EnblOnWnCrOpen Window for Credit Voucherchar10N=No, Y=Yes Allow NULL? 
133EnblDefInxEnable Define Indexeschar10N=No, Y=Yes Allow NULL? 
134EnblMxCommEnable Max Commitmentchar10N=No, Y=Yes Allow NULL? 
135EnblIndxOpEnable Index Optionchar10N=No, Y=Yes Allow NULL? 
136EnblSbtCVoEnable Submit Credit Voucherchar10N=No, Y=Yes Allow NULL? 
137MinAmntOAPMinimum Amount for Appndix O&Pnum196 Allow NULL? 
138CredSummCredit Card Summarychar10N=No, Y=Yes Allow NULL? 
139PostdChkPostdated Checkchar10N=No, Y=Yes Allow NULL? 
140PostdCredPostdated Credit Voucherchar10N=No, Y=Yes Allow NULL? 
141CredVendCredit Vendorschar10N=No, Y=Yes Allow NULL? 
142WkoStatusOld Work Order Statuschar10N=No, Y=Yes Allow NULL? 
143DispTrByDfDisplay Transactions by Dfltchar10YN=No, Y=Yes Allow NULL? 
144stampTaxDefault Stamp Taxnvarchar80OVTG Allow NULL? 
145MinAmntALMinimum Amount for Annual Listnum196 Allow NULL? 
146BlockZeroQBlock Stock Negative Quantitychar10YN=No, Y=Yes Allow NULL? 
147AutoCrInsAuto Create Customer Eq Cardchar10NN=No, Y=Yes Allow NULL? 
148EnbRepomoEnable Inflation for Cash Actchar10N=No, Y=Yes Allow NULL? 
149RFCValidatEnable RFC Validationschar10N=No, Y=Yes Allow NULL? 
150MxDcsInPmtMax. Number of Documents in Paymentint1100 Allow NULL? 
151RelStkNoPrEnable Stock Release without Item Costchar10NN=No, Y=Yes Allow NULL? 
152CashDiscCash Discount In Documentchar10N=No, Y=Yes Allow NULL? 
153EnableSMSEnable SMSchar10N=No, Y=Yes Allow NULL? 
154EnblIndicEnable Indicatorchar10N=No, Y=Yes Allow NULL? 
155EnbFedTaxEnable Federal Tax IDchar10N=No, Y=Yes Allow NULL? 
156EnblCountyEnable Countychar10N=No, Y=Yes Allow NULL? 
157LanguageLanguage on Create Companyint110 Allow NULL? 
158ChkIntgUpdCheck Data Integrity On Updatechar10YN=No, Y=Yes Allow NULL? 
159ChkIntgCreCheck Data Integrity On Createchar10YN=No, Y=Yes Allow NULL? 
160BisBnkAcKyBISR Bank Account Keyint110DSC1 Allow NULL? 
161EnbZeroDecEnable Print Check Show Zero Decimalchar10NN=No, Y=Yes Allow NULL? 
162EnbDecWordShow Check Decimal in Wordschar10YN=No, Y=Yes Allow NULL? 
163ChkWrdOnlyAdd the word Only in checkschar10N=No, Y=Yes Allow NULL? 
164EnBnkStmntBank Statement Processingchar10NN=No, Y=Yes Allow NULL? 
165CalcVatGrpGroup Lines in VAT Calculationchar10N=No, Y=Yes Allow NULL? 
166TaxSysTypeDefines Tax Calculation Systemchar10A=Preconfigured Formula with Jurisdiction Support, B=User-Defined Formula, C=Preconfigured Formula, M=Fixed implementation with jurisdiction support, S=Fixed implementation Allow NULL? 
167ESEnabledIs Event Sender enabled?char10NC=Customize, N=No, Y=Yes Allow NULL? 
168RateTotalUse rate for minor total calc.char10NN=No, Y=Yes Allow NULL? 
169CompanyHisCreate/Upgrade Historytext160
170EnblAssValEnable Assessable Valuechar10NN=No, Y=Yes Allow NULL? 
171CompanyStaCompany Statuschar10UA=Archived, I=Invalid, P=Upgrade Simulation, S=Inventory Valuation Utility, U=Upgrading, V=Valid Allow NULL? 
172eFRTActLvsNo. of Levels in Elect. FRTint110 Allow NULL? 
173TaxGrpTypeDefines Tax Grouping Typechar10CC=Code, J=Jurisdiction Allow NULL? 
174InstallNoInstallation Numbernvarchar300 Allow NULL? 
175IsOldPAIs Old for PAchar10NN=No, Y=Yes Allow NULL? 
176EnbNegDocEnable Negative Total in Docchar10 Allow NULL? 
177AlgoEncryption Algorithmint60 Allow NULL? 
178ArcCompArchived Companychar10NN=No, Y=Yes Allow NULL? 
179UpdatedTFIs Updated Tax Formulachar10NN=No, Y=Yes Allow NULL? 
180DARDBGUIDReadonly DB GUID for Archivingnvarchar320 Allow NULL? 
181NegStoLvNegative Stock: Check Levelchar10IC=Company, I=Item Setting, W=Warehouse Allow NULL? 
182SPNEnabledEnable Transact. Notificationchar10YN=No, Y=Yes Allow NULL? 
183PrsWkCntEbPersonal Work Center Enabledchar10NF=Fiori Style Cockpit, N=No Cockpit, Y=Normal Style Cockpit Allow NULL? 
184DashbdEbDashboard Enabledchar10NN=No, Y=Yes Allow NULL? 
185BoxEffDateBox Effective From Datedate80
186LogInstancLog Instanceint1100 Allow NULL? 
187UpdateDateDate of Updatedate80
188UserSign2Updating Userint60OUSR Allow NULL? 
189SnapShotIdSnapshot IDint1100 Allow NULL? 
190CreatedByCreated Bychar10NN, P=Solution Packager, W=Express Configuration Wizard Allow NULL? 
191B1SgtEbB1 Suggest: Enablechar10YN=No, Y=Yes Allow NULL? 
192IsHConEnvIs in High Concurrency Envchar10NN=No, Y=Yes Allow NULL? 
193B1BuzzEbEnable Streamwork Widgetchar10N Allow NULL? 
194IMCEEnableIMCE Enablechar10NN=No, Y=Yes Allow NULL? 
195DKeyIdCurrent Dynamic Key IDnvarchar1280 Allow NULL? 
196ResetDDataReset Dyn. Key Data to Defaultchar10N Allow NULL? 
197ConvDifActEnable Conversion Diff. Acctchar10YN=No, Y=Yes Allow NULL? 
198BasEffDateBase Effective From Datedate80
199oldFxAssHas Used Old Fixed Assetschar10NN=No, Y=Yes Allow NULL? 
200MaxRowsCFLMax. Rows for Choose from Listint11000=Unlimited, 100000=100000, 10000=10000, 50000=50000, 5000=5000 Allow NULL? 
201ColSelColumn Selectiontext160
202EnblSPEDUFEnable SPED Related UDFschar10NN=No, Y=Yes Allow NULL? 
203DpmAffTotDown Payment Affects Totalchar10YN=No, Y=Yes Allow NULL? 
204AliasUpdInstallation Datenvarchar2540 Allow NULL? 
205TrailDaysTrial Daysint60 Allow NULL? 
206TestCompTest Comp.char10NN=No, Y=Yes Allow NULL? 
207DashConfEnable Side Bartext160
208SideEnableEnable Side Barchar10NN=No, Y=Yes Allow NULL? 
209IsPALInitIs PAL Init. or Notchar10N Allow NULL? 
210PANAVerPervasive Versionint1100 Allow NULL? 
211ExpEnableEnable Expense Claimchar10YN=No, Y=Yes Allow NULL? 
212LastSsrDatLast SSR upload datedate80
213LastSsrHshLast SSR upload date hashnvarchar330 Allow NULL? 
214B1iTimeOutB1i Request Timeoutint11030 Allow NULL? 
215CpRfshEnblEnable Cockpit Auto Refreshchar10N Allow NULL? 
216CpRfshIntvCockpit Refresh Intervalint110300 Allow NULL? 
217EnbMBFiltEnable Filtering Mechanism by Branchchar10NN=No, Y=Yes Allow NULL? 
218CompnyGUIDCompany GUIDnvarchar400 Allow NULL? 
219ShutTimeSAP Business One Shutdown Timeint110 Allow NULL? 

TOPB1 9.3  | CINF INDEXES

NamePrimaryUniqueTypeColumns
PRIMARYNoYesVersion