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
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
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OPCH268A/P Invoice
4OSRN20Serial Numbers Master Data
5OIVL77Whse Journal
6OBOT10Bill Of Exchang Transaction
7ORCT154Incoming Payment
8OVPM154Outgoing Payments
9OOCR9Loading Factors
10JDT1110Journal Entry - Rows - 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]char10NY=Yes, N=No Allow NULL? 
6GroupsMain Groupnvarchar80 Allow NULL? 
7BudgetBudgetchar10NY=Yes, N=No Allow NULL? 
8FrozenAccount on Hold [Y/N]char10NY=Yes, N=No Allow NULL? 
9Free_2Free 2char10 Allow NULL? 
10PostableAccount [Active/Title]char10YY=Active Account, N=Title 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]char10NY=Yes, N=No Allow NULL? 
18GroupMaskGroup Maskint601 Allow NULL? 
19RateTransFor Conversion Differenceschar10YY=Yes, N=No Allow NULL? 
20TaxIncomeTax Definitionchar10NY=Yes, N=No Allow NULL? 
21ExmIncomeTax Definitionchar10NY=Yes, N=No Allow NULL? 
22ExtrMatchExternal Reconciliation No.int110 Allow NULL? 
23IntrMatchInternal Reconciliation No.int110 Allow NULL? 
24ActTypeAccount Categorychar10NI=Sales, E=Expenditure, N=Other Allow NULL? 
25TransferedYear Transfer [Y/N]char10NY=Yes, N=No Allow NULL? 
26BlncTrnsfrBalances Transferred [Y/N]char10NY=Yes, N=No 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 yearchar10NY=Yes, N=No 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]char10NY=Yes, N=No Allow NULL? 
36RealAcctReconciled Account [Y/N]char10NY=Yes, N=No Allow NULL? 
37AdvanceLiable for Advanceschar10YY=Yes, N=No 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]char10NY=Yes, N=No Allow NULL? 
45DataSourceData Sourcechar10NN=Unknown, I=Interface, U=Update, M=Import, O=DI API, A=Doc. Generation Wizard, D=Restore Wizard, P=Partner Implementation, T=Year Transfer Allow NULL? 
46LocMthLC Reconciliationchar10YY=Yes, N=No Allow NULL? 
47MTHCounterMTH Counterint110 Allow NULL? 
48BNKCounterBNK Counterint110 Allow NULL? 
49UserSignUser Signatureint60 Allow NULL? 
50LocManTranLock Manual Transactionchar10NY=Yes, N=No Allow NULL? 
51LogInstancLog Instanceint1100 Allow NULL? 
52ObjTypeObject Typenvarchar2001 Allow NULL? 
53ValidForActivechar10NY=Yes, N=No Allow NULL? 
54ValidFromActive Fromdate80
55ValidToActive Todate80
56ValidCommActive Remarksnvarchar300 Allow NULL? 
57FrozenForInactivechar10NY=Yes, N=No 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]char10NY=Yes, N=No Allow NULL? 
74ExchRateExchange Rate Differenceschar10YY=Yes, N=No Allow NULL? 
75RevalAcctRevaluation Accountnvarchar150 Allow NULL? 
76LastRevBalLast Revaluation Balancenum196 Allow NULL? 
77LastRevDatLast Revaluation Datedate80
78DfltVatDefault VAT Groupnvarchar80 Allow NULL? 
79VatChangeAllow Change VAT Groupchar10YY=Yes, N=No 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, R=Sales Tax Account, P=Purchasing 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 Relevantchar10NY=Yes, N=No Allow NULL? 
95Dim1RelvntDimension 1 Relevantchar10NY=Yes, N=No Allow NULL? 
96Dim2RelvntDimension 2 Relevantchar10NY=Yes, N=No Allow NULL? 
97Dim3RelvntDimension 3 Relevantchar10NY=Yes, N=No Allow NULL? 
98Dim4RelvntDimension 4 Relevantchar10NY=Yes, N=No Allow NULL? 
99Dim5RelvntDimension 5 Relevantchar10NY=Yes, N=No Allow NULL? 
100AccrualTypAccrual Typechar10NN=None, P=Posting Account, C=Calculation Account, I=Calculation Interim Account Allow NULL? 
101DatevAcctDATEV Accountint110 Allow NULL? 
102DatevAutoADATEV Automatic Accountchar10NY=Yes, N=No Allow NULL? 
103DatevFirstFirst Data Entrychar10YY=Yes, N=No Allow NULL? 
104SnapShotIdSnapshot IDint1100 Allow NULL? 
105PCN874RptPCN 874 Report Relevantchar10NY=Yes, N=No Allow NULL? 
106SCAdjustSC Adjustmentchar10NY=Yes, N=No 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?