SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

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

SELECT AcctCode, AcctName, CurrTotal, EndTotal, Finanse, Groups, Budget, Frozen, Free_2, Postable, Fixed, Levels, ExportCode, GrpLine, FatherNum, AccntntCod, CashBox, GroupMask, RateTrans, TaxIncome, ExmIncome, ExtrMatch, IntrMatch, ActType, Transfered, BlncTrnsfr, OverType, OverCode, SysMatch, PrevYear, ActCurr, RateDifAct, SysTotal, FcTotal, Protected, RealAcct, Advance, CreateDate, UpdateDate, FrgnName, Details, ExtraSum, Project, RevalMatch, DataSource, LocMth, MTHCounter, BNKCounter, UserSign, LocManTran, LogInstanc, ObjType, ValidFor, ValidFrom, ValidTo, ValidComm, FrozenFor, FrozenFrom, FrozenTo, FrozenComm, Counter, Segment_0, Segment_1, Segment_2, Segment_3, Segment_4, Segment_5, Segment_6, Segment_7, Segment_8, Segment_9, FormatCode, CfwRlvnt, ExchRate, RevalAcct, LastRevBal, LastRevDat, DfltVat, VatChange, Category, TransCode, OverCode5, OverCode2, OverCode3, OverCode4, DfltTax, TaxPostAcc, AcctStrLe, MeaUnit, BalDirect, UserSign2, PlngLevel, MultiLink, PrjRelvnt, Dim1Relvnt, Dim2Relvnt, Dim3Relvnt, Dim4Relvnt, Dim5Relvnt, AccrualTyp, DatevAcct, DatevAutoA, DatevFirst, SnapShotId, PCN874Rpt, SCAdjust, BPLId, BPLName, SubLedgerN, VATRegNum, ActId, ClosingAcc, PurpCode, RefCode FROM OACT


ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1AcctCodeAccount Codenvarchar150 Allow NULL? 
2AcctNameAccount Namenvarchar1000 Allow NULL? 
3CurrTotalCurrent Balancenum196 Allow NULL? 
4EndTotalOpening Balancenum196 Allow NULL? 
5FinanseCash Account [Y/N]char10NN=No, Y=Yes Allow NULL? 
6GroupsMain Groupnvarchar80 Allow NULL? 
7BudgetBudgetchar10NN=No, Y=Yes Allow NULL? 
8FrozenAccount on Hold [Y/N]char10NN=No, Y=Yes Allow NULL? 
9Free_2Free 2char10 Allow NULL? 
10PostableAccount [Active/Title]char10YN=Title Account, Y=Active Account Allow NULL? 
11FixedMain Accountchar10 Allow NULL? 
12LevelsAccount Levelint602 Allow NULL? 
13ExportCodeData Export Codenvarchar100 Allow NULL? 
14GrpLineSerial No. in Groupint110 Allow NULL? 
15FatherNumParent Account Keynvarchar150 Allow NULL? 
16AccntntCodExternal Codenvarchar150 Allow NULL? 
17CashBoxCapital Account [Y/N]char10NN=No, Y=Yes Allow NULL? 
18GroupMaskGroup Maskint601 Allow NULL? 
19RateTransFor Conversion Differenceschar10YN=No, Y=Yes Allow NULL? 
20TaxIncomeTax Definitionchar10NN=No, Y=Yes Allow NULL? 
21ExmIncomeTax Definitionchar10NN=No, Y=Yes Allow NULL? 
22ExtrMatchExternal Reconciliation No.int110 Allow NULL? 
23IntrMatchInternal Reconciliation No.int110 Allow NULL? 
24ActTypeAccount Categorychar10NE=Expenditure, I=Sales, N=Other Allow NULL? 
25TransferedYear Transfer [Y/N]char10NN=No, Y=Yes Allow NULL? 
26BlncTrnsfrBalances Transferred [Y/N]char10NN=No, Y=Yes Allow NULL? 
27OverTypeLoading Typechar10NN=None, Y=Yes Allow NULL? 
28OverCodeLoading Factor Codenvarchar80 Allow NULL? 
29SysMatchSystem Reconciliation No.int110-1 Allow NULL? 
30PrevYearThere are accounts from the previous yearchar10NN=No, Y=Yes Allow NULL? 
31ActCurrAccount Currencynvarchar30 Allow NULL? 
32RateDifActRate Differences Accountnvarchar150 Allow NULL? 
33SysTotalBalance in System Currencynum196 Allow NULL? 
34FcTotalBalance in Account Currencynum196 Allow NULL? 
35ProtectedProtected Account [Y/N]char10NN=No, Y=Yes Allow NULL? 
36RealAcctReconciled Account [Y/N]char10NN=No, Y=Yes Allow NULL? 
37AdvanceLiable for Advanceschar10YN=No, Y=Yes Allow NULL? 
38CreateDateCreation Datedate80
39UpdateDateDate of Updatedate80
40FrgnNameForeign Namenvarchar1000 Allow NULL? 
41DetailsDetailsnvarchar2540 Allow NULL? 
42ExtraSumAdditional Amountnum196 Allow NULL? 
43ProjectProject Codenvarchar200 Allow NULL? 
44RevalMatchRevaluation Coordinated [Yes/No]char10NN=No, Y=Yes Allow NULL? 
45DataSourceData Sourcechar10NA=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update Allow NULL? 
46LocMthLC Reconciliationchar10YN=No, Y=Yes Allow NULL? 
47MTHCounterMTH Counterint110 Allow NULL? 
48BNKCounterBNK Counterint110 Allow NULL? 
49UserSignUser Signatureint60 Allow NULL? 
50LocManTranLock Manual Transactionchar10NN=No, Y=Yes Allow NULL? 
51LogInstancLog Instanceint1100 Allow NULL? 
52ObjTypeObject Typenvarchar2001 Allow NULL? 
53ValidForActivechar10NN=No, Y=Yes Allow NULL? 
54ValidFromActive Fromdate80
55ValidToActive Todate80
56ValidCommActive Remarksnvarchar300 Allow NULL? 
57FrozenForInactivechar10NN=No, Y=Yes Allow NULL? 
58FrozenFromInactive Fromdate80
59FrozenToInactive Todate80
60FrozenCommInactive Remarksnvarchar300 Allow NULL? 
61CounterCounterint1100 Allow NULL? 
62Segment_0Segment 0nvarchar200 Allow NULL? 
63Segment_1Segment 1nvarchar200 Allow NULL? 
64Segment_2Segment 2nvarchar200 Allow NULL? 
65Segment_3Segment 3nvarchar200 Allow NULL? 
66Segment_4Segment 4nvarchar200 Allow NULL? 
67Segment_5Segment 5nvarchar200 Allow NULL? 
68Segment_6Segment 6nvarchar200 Allow NULL? 
69Segment_7Segment 7nvarchar200 Allow NULL? 
70Segment_8Segment 8nvarchar200 Allow NULL? 
71Segment_9Segment 9nvarchar200 Allow NULL? 
72FormatCodeFormat Codenvarchar2100 Allow NULL? 
73CfwRlvntCash Flow Relevant [Y/N]char10NN=No, Y=Yes Allow NULL? 
74ExchRateExchange Rate Differenceschar10YN=No, Y=Yes Allow NULL? 
75RevalAcctRevaluation Accountnvarchar150 Allow NULL? 
76LastRevBalLast Revaluation Balancenum196 Allow NULL? 
77LastRevDatLast Revaluation Datedate80
78DfltVatDefault VAT Groupnvarchar80 Allow NULL? 
79VatChangeAllow Change VAT Groupchar10YN=No, Y=Yes Allow NULL? 
80CategoryCategoryint110 Allow NULL? 
81TransCodeTransaction Codenvarchar40 Allow NULL? 
82OverCode5Loading Factor Code 5nvarchar80 Allow NULL? 
83OverCode2Loading Factor Code 2nvarchar80 Allow NULL? 
84OverCode3Loading Factor Code 3nvarchar80 Allow NULL? 
85OverCode4Loading Factor Code 4nvarchar80 Allow NULL? 
86DfltTaxDefault Tax Codenvarchar80 Allow NULL? 
87TaxPostAccDefault Tax Posting Accountchar10NN, P=Purchasing Tax Account, R=Sales Tax Account Allow NULL? 
88AcctStrLeAccount Structure Levelnvarchar20 Allow NULL? 
89MeaUnitMeasurement Unitnvarchar100 Allow NULL? 
90BalDirectDirection of Balancenvarchar4000, 1=Credit, 2=Debit Allow NULL? 
91UserSign2Updating Userint60 Allow NULL? 
92PlngLevelB1i Info for Integrationnvarchar20 Allow NULL? 
93MultiLinkAllow Multiple Linkingchar10NN=No, Y=Yes Allow NULL? 
94PrjRelvntProject Relevantchar10NN=No, Y=Yes Allow NULL? 
95Dim1RelvntDimension 1 Relevantchar10NN=No, Y=Yes Allow NULL? 
96Dim2RelvntDimension 2 Relevantchar10NN=No, Y=Yes Allow NULL? 
97Dim3RelvntDimension 3 Relevantchar10NN=No, Y=Yes Allow NULL? 
98Dim4RelvntDimension 4 Relevantchar10NN=No, Y=Yes Allow NULL? 
99Dim5RelvntDimension 5 Relevantchar10NN=No, Y=Yes Allow NULL? 
100AccrualTypAccrual Typechar10NC=Calculation Account, I=Calculation Interim Account, N=None, P=Posting Account Allow NULL? 
101DatevAcctDATEV Accountint110 Allow NULL? 
102DatevAutoADATEV Automatic Accountchar10NN=No, Y=Yes Allow NULL? 
103DatevFirstFirst Data Entrychar10YN=No, Y=Yes Allow NULL? 
104SnapShotIdSnapshot IDint1100 Allow NULL? 
105PCN874RptPCN 874 Report Relevantchar10NN=No, Y=Yes Allow NULL? 
106SCAdjustSC Adjustmentchar10NN=No, Y=Yes Allow NULL? 
107BPLIdAssigned Branchint110 Allow NULL? 
108BPLNameBranch Namenvarchar1000 Allow NULL? 
109SubLedgerNSubledger No.nvarchar600 Allow NULL? 
110VATRegNumVAT Reg. Numbernvarchar320 Allow NULL? 
111ActIdAccount Identifiernvarchar2100 Allow NULL? 
112ClosingAccG/L Account Closingnvarchar150 Allow NULL? 
113PurpCodeAccount Purpose Codenvarchar2001=Contas de ativo, 02=Contas de Passivo, 03=Patrimônio Líquido, 04=Contas de Resultado, 05=Contas de Compensação, 09=Outras Allow NULL? 
114RefCodeReferential Account Codenvarchar300 Allow NULL?