biuan SAP® BUSINESS ONE SDK
API AACT
AACT - G/L Account - History 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 Type [Active/Title]VarChar
Y) Active Account
N) Title Account
1
Y
FixedPrimary AccountVarChar
1
LevelsAccount LevelInt
6
2
ExportCodeData Export CodenVarChar
10
GrpLineAccount Location in GroupInt
11
FatherNumParent Account KeynVarChar
15
AccntntCodExternal CodenVarChar
15
CashBoxPrimary Account [Y/N]VarChar
Y) Yes
N) No
1
N
GroupMaskGroup MaskInt
6
1
RateTransConversion 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 Transferred [Y/N]VarChar
Y) Yes
N) No
1
N
BlncTrnsfrBalances Transferred [Y/N]VarChar
Y) Yes
N) No
1
N
OverTypeDistribution RuleVarChar
N) None
Y) Yes
1
N
OverCodeDistribution Rule CodenVarChar
8OOCR
Distribution Rule
SysMatchSystem Reconciliation No.Int
11
-1
PrevYearTransferred from Prev. YearVarChar
Y) Yes
N) No
1
N
ActCurrAccount CurrencynVarChar
3OCRN
Currency Codes
RateDifActRate Differences AcctnVarChar
15
SysTotalBalance (SC)Num
20
FcTotalBalance (Account Currency)Num
20
ProtectedProtected Account [Y/N]VarChar
Y) Yes
N) No
1
N
RealAcctIndexed 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
DetailsDetails - HistorynVarChar
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
LocMthReconciliation in LCVarChar
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
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
CounterBP Bank AccountInt
11
0
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
FormatCodeFormat CodenVarChar
127
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
ActIdAccount IdentifiernVarChar
127
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 AACT.AcctCode AS 'Account Code', AACT.AcctName AS 'Account Name', AACT.CurrTotal AS 'Current Balance', AACT.EndTotal AS 'Opening Balance', AACT.Finanse AS 'Cash Account [Y/N]', AACT.Groups AS 'Main Group', AACT.Budget AS 'Budget', AACT.Frozen AS 'Account on Hold [Y/N]', AACT.Free_2 AS 'Free 2', AACT.Postable AS 'Account Type [Active/Title]', AACT.Fixed AS 'Primary Account', AACT.Levels AS 'Account Level', AACT.ExportCode AS 'Data Export Code', AACT.GrpLine AS 'Account Location in Group', AACT.FatherNum AS 'Parent Account Key', AACT.AccntntCod AS 'External Code', AACT.CashBox AS 'Primary Account [Y/N]', AACT.GroupMask AS 'Group Mask', AACT.RateTrans AS 'Conversion Differences', AACT.TaxIncome AS 'Tax Definition', AACT.ExmIncome AS 'Tax Definition', AACT.ExtrMatch AS 'External Reconciliation No.', AACT.IntrMatch AS 'Internal Reconciliation No.', AACT.ActType AS 'Account Category', AACT.Transfered AS 'Year Transferred [Y/N]', AACT.BlncTrnsfr AS 'Balances Transferred [Y/N]', AACT.OverType AS 'Distribution Rule', AACT.OverCode AS 'Distribution Rule Code', AACT.SysMatch AS 'System Reconciliation No.', AACT.PrevYear AS 'Transferred from Prev. Year', AACT.ActCurr AS 'Account Currency', AACT.RateDifAct AS 'Rate Differences Acct', AACT.SysTotal AS 'Balance (SC)', AACT.FcTotal AS 'Balance (Account Currency)', AACT.Protected AS 'Protected Account [Y/N]', AACT.RealAcct AS 'Indexed Account [Y/N]', AACT.Advance AS 'Liable for Advances', AACT.CreateDate AS 'Creation Date', AACT.UpdateDate AS 'Date of Update', AACT.FrgnName AS 'Foreign Name', AACT.Details AS 'Details - History', AACT.ExtraSum AS 'Additional Amount', AACT.Project AS 'Project Code', AACT.RevalMatch AS 'Revaluation Coordinated [Yes/No]', AACT.DataSource AS 'Data Source', AACT.LocMth AS 'Reconciliation in LC', AACT.MTHCounter AS 'MTH Counter', AACT.BNKCounter AS 'BNK Counter', AACT.UserSign AS 'User Signature', AACT.LocManTran AS 'Lock Manual Transaction', AACT.LogInstanc AS 'Log Instance', AACT.ObjType AS 'Object Type', AACT.ValidFor AS 'Active', AACT.ValidFrom AS 'Active From', AACT.ValidTo AS 'Active To', AACT.ValidComm AS 'Active Remarks', AACT.FrozenFor AS 'Inactive', AACT.FrozenFrom AS 'Inactive From', AACT.FrozenTo AS 'Inactive To', AACT.FrozenComm AS 'Inactive Remarks', AACT.Counter AS 'BP Bank Account', AACT.Segment_0 AS 'Segment 0', AACT.Segment_1 AS 'Segment 1', AACT.Segment_2 AS 'Segment 2', AACT.Segment_3 AS 'Segment 3', AACT.Segment_4 AS 'Segment 4', AACT.Segment_5 AS 'Segment 5', AACT.Segment_6 AS 'Segment 6', AACT.Segment_7 AS 'Segment 7', AACT.Segment_8 AS 'Segment 8', AACT.Segment_9 AS 'Segment 9', AACT.FormatCode AS 'Format Code', AACT.CfwRlvnt AS 'Cash Flow Relevant [Y/N]', AACT.ExchRate AS 'Exchange Rate Differences', AACT.RevalAcct AS 'Revaluation Account', AACT.LastRevBal AS 'Last Revaluation Balance', AACT.LastRevDat AS 'Last Revaluation Date', AACT.DfltVat AS 'Default VAT Group', AACT.VatChange AS 'Allow Change VAT Group', AACT.Category AS 'Category', AACT.TransCode AS 'Transaction Code', AACT.OverCode5 AS 'Loading Factor Code 5', AACT.OverCode2 AS 'Loading Factor Code 2', AACT.OverCode3 AS 'Loading Factor Code 3', AACT.OverCode4 AS 'Loading Factor Code 4', AACT.DfltTax AS 'Default Tax Code', AACT.TaxPostAcc AS 'Default Tax Posting Account', AACT.AcctStrLe AS 'Account Structure Level', AACT.MeaUnit AS 'Measurement Unit', AACT.BalDirect AS 'Direction of Balance', AACT.UserSign2 AS 'Updating User', AACT.PlngLevel AS 'B1i Info for Integration', AACT.MultiLink AS 'Allow Multiple Linking', AACT.PrjRelvnt AS 'Project Relevant', AACT.Dim1Relvnt AS 'Dimension 1 Relevant', AACT.Dim2Relvnt AS 'Dimension 2 Relevant', AACT.Dim3Relvnt AS 'Dimension 3 Relevant', AACT.Dim4Relvnt AS 'Dimension 4 Relevant', AACT.Dim5Relvnt AS 'Dimension 5 Relevant', AACT.AccrualTyp AS 'Accrual Type', AACT.DatevAcct AS 'DATEV Account', AACT.DatevAutoA AS 'DATEV Automatic Account', AACT.DatevFirst AS 'First Data Entry', AACT.SnapShotId AS 'Snapshot ID', AACT.PCN874Rpt AS 'PCN 874 Report Relevant', AACT.SCAdjust AS 'SC Adjustment', AACT.BPLId AS 'Assigned Branch', AACT.BPLName AS 'Branch Name', AACT.SubLedgerN AS 'Subledger No.', AACT.VATRegNum AS 'VAT Reg. Number', AACT.ActId AS 'Account Identifier', AACT.ClosingAcc AS 'G/L Account Closing', AACT.PurpCode AS 'Account Purpose Code', AACT.RefCode AS 'Referential Account Code' FROM AACT AS AACT

Related information


Currency Codes OCRN SQL Table

Business Place OBPL SQL Table

Account Category OACG SQL Table

Sales Tax Codes OSTC SQL Table

Tax Definition OVTG 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates