biuan SAP® BUSINESS ONE SDK
DTW Financials / Chart of Accounts
API OACT / / Chart Of Accounts
OACT - G/L Accounts Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AcctCode KEY UNIQUEAccount CodenVarChar
15
PRIMARYYes
AcctNameAccount NamenVarChar
100
CurrTotalCurrent BalanceNum
20
EndTotalOpening BalanceNum
20
FinanseCash Account [Y/N]VarChar
Y) Yes
N) No
1
N
GroupsMain GroupnVarChar
8
BudgetBudgetVarChar
Y) Yes
N) No
1
N
FrozenAccount on Hold [Y/N]VarChar
Y) Yes
N) No
1
N
Free_2Free 2VarChar
1
PostableAccount [Active/Title]VarChar
Y) Active Account
N) Title Account
1
Y
FixedMain AccountVarChar
1
LevelsAccount LevelInt
6
2
ExportCodeData Export CodenVarChar
10
GrpLineSerial No. in GroupInt
11
FatherNum KEYParent Account KeynVarChar
15
INTER_KEYNo
AccntntCodExternal CodenVarChar
15
CashBoxCapital Account [Y/N]VarChar
Y) Yes
N) No
1
N
GroupMaskGroup MaskInt
6
1
RateTransFor Conversion DifferencesVarChar
Y) Yes
N) No
1
Y
TaxIncomeTax DefinitionVarChar
Y) Yes
N) No
1
N
ExmIncomeTax DefinitionVarChar
Y) Yes
N) No
1
N
ExtrMatchExternal Reconciliation No.Int
11
IntrMatchInternal Reconciliation No.Int
11
ActTypeAccount CategoryVarChar
I) Sales
E) Expenditure
N) Other
1
N
TransferedYear Transfer [Y/N]VarChar
Y) Yes
N) No
1
N
BlncTrnsfrBalances Transferred [Y/N]VarChar
Y) Yes
N) No
1
N
OverTypeLoading TypeVarChar
N) None
Y) Yes
1
N
OverCodeLoading Factor CodenVarChar
8OOCR
Distribution Rule
SysMatchSystem Reconciliation No.Int
11
-1
PrevYearThere are accounts from the previous yeaVarChar
Y) Yes
N) No
1
N
ActCurr KEYAccount CurrencynVarChar
3OCRN
Currency Codes
CURRENCYNo
RateDifActRate Differences AccountnVarChar
15
SysTotalBalance in System CurrencyNum
20
FcTotalBalance in Account CurrencyNum
20
ProtectedProtected Account [Y/N]VarChar
Y) Yes
N) No
1
N
RealAcctReconciled Account [Y/N]VarChar
Y) Yes
N) No
1
N
AdvanceLiable for AdvancesVarChar
Y) Yes
N) No
1
Y
CreateDateCreation DateDate
8
UpdateDateDate of UpdateDate
8
FrgnNameForeign NamenVarChar
100
DetailsDetailsnVarChar
127
ExtraSumAdditional AmountNum
20
ProjectProject CodenVarChar
20OPRJ
Project Codes
RevalMatchRevaluation Coordinated [Yes/No]VarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
LocMthLC ReconciliationVarChar
Y) Yes
N) No
1
Y
MTHCounterMTH CounterInt
11
BNKCounterBNK CounterInt
11
UserSignUser SignatureInt
6OUSR
Users
LocManTranLock Manual TransactionVarChar
Y) Yes
N) No
1
N
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
1
ValidForActiveVarChar
Y) Yes
N) No
1
N
ValidFromActive FromDate
8
ValidToActive ToDate
8
ValidCommActive RemarksnVarChar
30
FrozenForInactiveVarChar
Y) Yes
N) No
1
N
FrozenFromInactive FromDate
8
FrozenToInactive ToDate
8
FrozenCommInactive RemarksnVarChar
30
Counter KEYCounterInt
11
0COUNTERNo
Segment_0Segment 0nVarChar
20
Segment_1Segment 1nVarChar
20
Segment_2Segment 2nVarChar
20
Segment_3Segment 3nVarChar
20
Segment_4Segment 4nVarChar
20
Segment_5Segment 5nVarChar
20
Segment_6Segment 6nVarChar
20
Segment_7Segment 7nVarChar
20
Segment_8Segment 8nVarChar
20
Segment_9Segment 9nVarChar
20
FormatCode KEYFormat CodenVarChar
127
FORMATNo
CfwRlvntCash Flow Relevant [Y/N]VarChar
Y) Yes
N) No
1
N
ExchRateExchange Rate DifferencesVarChar
Y) Yes
N) No
1
Y
RevalAcctRevaluation AccountnVarChar
15
LastRevBalLast Revaluation BalanceNum
20
LastRevDatLast Revaluation DateDate
8
DfltVatDefault VAT GroupnVarChar
8OVTG
Tax Definition
VatChangeAllow Change VAT GroupVarChar
Y) Yes
N) No
1
Y
CategoryCategoryInt
11OACG
Account Category
TransCodeTransaction CodenVarChar
4OTRC
Journal Entry Codes
OverCode5Loading Factor Code 5nVarChar
8OOCR
Distribution Rule
OverCode2Loading Factor Code 2nVarChar
8OOCR
Distribution Rule
OverCode3Loading Factor Code 3nVarChar
8OOCR
Distribution Rule
OverCode4Loading Factor Code 4nVarChar
8OOCR
Distribution Rule
DfltTaxDefault Tax CodenVarChar
8OSTC
Sales Tax Codes
TaxPostAccDefault Tax Posting AccountVarChar
N)
R) Sales Tax Account
P) Purchasing Tax Account
1
N
AcctStrLeAccount Structure LevelnVarChar
2
MeaUnitMeasurement UnitnVarChar
10
BalDirectDirection of BalancenVarChar
0
1) Credit
2) Debit
4
0
UserSign2Updating UserInt
6OUSR
Users
PlngLevelB1i Info for IntegrationnVarChar
2
MultiLinkAllow Multiple LinkingVarChar
N) No
Y) Yes
1
N
PrjRelvntProject RelevantVarChar
Y) Yes
N) No
1
N
Dim1RelvntDimension 1 RelevantVarChar
Y) Yes
N) No
1
N
Dim2RelvntDimension 2 RelevantVarChar
Y) Yes
N) No
1
N
Dim3RelvntDimension 3 RelevantVarChar
Y) Yes
N) No
1
N
Dim4RelvntDimension 4 RelevantVarChar
Y) Yes
N) No
1
N
Dim5RelvntDimension 5 RelevantVarChar
Y) Yes
N) No
1
N
AccrualTypAccrual TypeVarChar
N) None
P) Posting Account
C) Calculation Account
I) Calculation Interim Account
1
N
DatevAcctDATEV AccountInt
11
DatevAutoADATEV Automatic AccountVarChar
Y) Yes
N) No
1
N
DatevFirstFirst Data EntryVarChar
Y) Yes
N) No
1
Y
SnapShotIdSnapshot IDInt
11
0
PCN874RptPCN 874 Report RelevantVarChar
Y) Yes
N) No
1
N
SCAdjustSC AdjustmentVarChar
Y) Yes
N) No
1
N
BPLIdAssigned BranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
SubLedgerNSubledger No.nVarChar
60
VATRegNumVAT Reg. NumbernVarChar
32
ActId KEY UNIQUEAccount IdentifiernVarChar
127
IDENTIFIERYes
ClosingAccG/L Account ClosingnVarChar
15
PurpCodeAccount Purpose CodenVarChar
01) Contas de ativo
02) Contas de Passivo
03) Patrimônio Líquido
04) Contas de Resultado
05) Contas de Compensação
09) Outras
2
RefCodeReferential Account CodenVarChar
30

Table relationship map

SELECT statement

SELECT OACT.AcctCode AS 'Account Code', OACT.AcctName AS 'Account Name', OACT.CurrTotal AS 'Current Balance', OACT.EndTotal AS 'Opening Balance', OACT.Finanse AS 'Cash Account [Y/N]', OACT.Groups AS 'Main Group', OACT.Budget AS 'Budget', OACT.Frozen AS 'Account on Hold [Y/N]', OACT.Free_2 AS 'Free 2', OACT.Postable AS 'Account [Active/Title]', OACT.Fixed AS 'Main Account', OACT.Levels AS 'Account Level', OACT.ExportCode AS 'Data Export Code', OACT.GrpLine AS 'Serial No. in Group', OACT.FatherNum AS 'Parent Account Key', OACT.AccntntCod AS 'External Code', OACT.CashBox AS 'Capital Account [Y/N]', OACT.GroupMask AS 'Group Mask', OACT.RateTrans AS 'For Conversion Differences', OACT.TaxIncome AS 'Tax Definition', OACT.ExmIncome AS 'Tax Definition', OACT.ExtrMatch AS 'External Reconciliation No.', OACT.IntrMatch AS 'Internal Reconciliation No.', OACT.ActType AS 'Account Category', OACT.Transfered AS 'Year Transfer [Y/N]', OACT.BlncTrnsfr AS 'Balances Transferred [Y/N]', OACT.OverType AS 'Loading Type', OACT.OverCode AS 'Loading Factor Code', OACT.SysMatch AS 'System Reconciliation No.', OACT.PrevYear AS 'There are accounts from the previous yea', OACT.ActCurr AS 'Account Currency', OACT.RateDifAct AS 'Rate Differences Account', OACT.SysTotal AS 'Balance in System Currency', OACT.FcTotal AS 'Balance in Account Currency', OACT.Protected AS 'Protected Account [Y/N]', OACT.RealAcct AS 'Reconciled Account [Y/N]', OACT.Advance AS 'Liable for Advances', OACT.CreateDate AS 'Creation Date', OACT.UpdateDate AS 'Date of Update', OACT.FrgnName AS 'Foreign Name', OACT.Details AS 'Details', OACT.ExtraSum AS 'Additional Amount', OACT.Project AS 'Project Code', OACT.RevalMatch AS 'Revaluation Coordinated [Yes/No]', OACT.DataSource AS 'Data Source', OACT.LocMth AS 'LC Reconciliation', OACT.MTHCounter AS 'MTH Counter', OACT.BNKCounter AS 'BNK Counter', OACT.UserSign AS 'User Signature', OACT.LocManTran AS 'Lock Manual Transaction', OACT.LogInstanc AS 'Log Instance', OACT.ObjType AS 'Object Type', OACT.ValidFor AS 'Active', OACT.ValidFrom AS 'Active From', OACT.ValidTo AS 'Active To', OACT.ValidComm AS 'Active Remarks', OACT.FrozenFor AS 'Inactive', OACT.FrozenFrom AS 'Inactive From', OACT.FrozenTo AS 'Inactive To', OACT.FrozenComm AS 'Inactive Remarks', OACT.Counter AS 'Counter', OACT.Segment_0 AS 'Segment 0', OACT.Segment_1 AS 'Segment 1', OACT.Segment_2 AS 'Segment 2', OACT.Segment_3 AS 'Segment 3', OACT.Segment_4 AS 'Segment 4', OACT.Segment_5 AS 'Segment 5', OACT.Segment_6 AS 'Segment 6', OACT.Segment_7 AS 'Segment 7', OACT.Segment_8 AS 'Segment 8', OACT.Segment_9 AS 'Segment 9', OACT.FormatCode AS 'Format Code', OACT.CfwRlvnt AS 'Cash Flow Relevant [Y/N]', OACT.ExchRate AS 'Exchange Rate Differences', OACT.RevalAcct AS 'Revaluation Account', OACT.LastRevBal AS 'Last Revaluation Balance', OACT.LastRevDat AS 'Last Revaluation Date', OACT.DfltVat AS 'Default VAT Group', OACT.VatChange AS 'Allow Change VAT Group', OACT.Category AS 'Category', OACT.TransCode AS 'Transaction Code', OACT.OverCode5 AS 'Loading Factor Code 5', OACT.OverCode2 AS 'Loading Factor Code 2', OACT.OverCode3 AS 'Loading Factor Code 3', OACT.OverCode4 AS 'Loading Factor Code 4', OACT.DfltTax AS 'Default Tax Code', OACT.TaxPostAcc AS 'Default Tax Posting Account', OACT.AcctStrLe AS 'Account Structure Level', OACT.MeaUnit AS 'Measurement Unit', OACT.BalDirect AS 'Direction of Balance', OACT.UserSign2 AS 'Updating User', OACT.PlngLevel AS 'B1i Info for Integration', OACT.MultiLink AS 'Allow Multiple Linking', OACT.PrjRelvnt AS 'Project Relevant', OACT.Dim1Relvnt AS 'Dimension 1 Relevant', OACT.Dim2Relvnt AS 'Dimension 2 Relevant', OACT.Dim3Relvnt AS 'Dimension 3 Relevant', OACT.Dim4Relvnt AS 'Dimension 4 Relevant', OACT.Dim5Relvnt AS 'Dimension 5 Relevant', OACT.AccrualTyp AS 'Accrual Type', OACT.DatevAcct AS 'DATEV Account', OACT.DatevAutoA AS 'DATEV Automatic Account', OACT.DatevFirst AS 'First Data Entry', OACT.SnapShotId AS 'Snapshot ID', OACT.PCN874Rpt AS 'PCN 874 Report Relevant', OACT.SCAdjust AS 'SC Adjustment', OACT.BPLId AS 'Assigned Branch', OACT.BPLName AS 'Branch Name', OACT.SubLedgerN AS 'Subledger No.', OACT.VATRegNum AS 'VAT Reg. Number', OACT.ActId AS 'Account Identifier', OACT.ClosingAcc AS 'G/L Account Closing', OACT.PurpCode AS 'Account Purpose Code', OACT.RefCode AS 'Referential Account Code' FROM OACT AS OACT

Related information


Chart Of Accounts ChartOfAccounts Object· Table: OACT
ChartOfAccounts is a business object that represents the General Ledger (G/L) accounts in the Finance module. This object enables you to: Add a G/L account. Retrieve a G/L account by its key. Update a G/L account. Remove a G/L account....

OACT SQL Table

Currency Codes OCRN SQL Table

Account Category OACG SQL Table

Sales Tax Codes OSTC SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Journal Entry Codes OTRC 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