📚 SAP Business One SDK Help

Table Name: OACT

Table Description: G/L Accounts

Field Description Type Size Related Default Value Constraints
AcctCode Account Code nVarChar 15 -      
AcctName Account Name nVarChar 200 -      
CurrTotal Current Balance Num 19.6 -      
EndTotal Opening Balance Num 19.6 -      
Finanse Cash Account VarChar 1 - N Y Yes
            N No
Groups Main Group nVarChar 8 -      
Budget Budget VarChar 1 - N Y Yes
            N No
Frozen Account on Hold [Y/N] VarChar 1 - N Y Yes
            N No
Free_2 Free 2 VarChar 1 -      
Postable Account [Active/Title] VarChar 1 - Y Y Active Account
            N Title Account
Fixed Main Account VarChar 1 -      
Levels Account Level Int 6 - 2    
ExportCode Data Export Code nVarChar 10 -      
GrpLine Serial No. in Group Int 11 -      
FatherNum Parent Account Key nVarChar 15 -      
AccntntCod External Code nVarChar 15 -      
CashBox Capital Account [Y/N] VarChar 1 - N Y Yes
            N No
GroupMask Group Mask Int 6 - 1    
RateTrans For Conversion Differences VarChar 1 - Y Y Yes
            N No
TaxIncome Tax Definition VarChar 1 - N Y Yes
            N No
ExmIncome Tax Definition VarChar 1 - N Y Yes
            N No
ExtrMatch External Reconciliation No. Int 11 -      
IntrMatch Internal Reconciliation No. Int 11 -      
ActType Account Type VarChar 1 - N I Sales
            E Expenditure
            N Other
Transfered Year Transfer [Y/N] VarChar 1 - N Y Yes
            N No
BlncTrnsfr Balances Transferred [Y/N] VarChar 1 - N Y Yes
            N No
OverType Loading Type VarChar 1 - N N None
            Y Yes
OverCode Loading Factor Code nVarChar 8 OOCR      
SysMatch System Reconciliation No. Int 11 - -1    
PrevYear There are accounts from the previous year VarChar 1 - N Y Yes
            N No
ActCurr Account Currency nVarChar 3 OCRN      
RateDifAct Rate Differences Account nVarChar 15 -      
SysTotal Balance in System Currency Num 19.6 -      
FcTotal Balance in Account Currency Num 19.6 -      
Protected Confidential Account VarChar 1 - N Y Yes
            N No
RealAcct Indexed Account VarChar 1 - N Y Yes
            N No
Advance Advance Payments VarChar 1 - Y Y Yes
            N No
CreateDate Creation Date Date 8 -      
UpdateDate Date of Update Date 8 -      
FrgnName Foreign Name nVarChar 200 -      
Details Details nVarChar 254 -      
ExtraSum Additional Amount Num 19.6 -      
Project Project Code nVarChar 20 OPRJ      
RevalMatch Revaluation Coordinated VarChar 1 - N Y Yes
            N No
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
LocMth LC Reconciliation VarChar 1 - Y Y Yes
            N No
MTHCounter MTH Counter Int 11 -      
BNKCounter BNK Counter Int 11 -      
UserSign User Signature Int 6 OUSR      
LocManTran Control Account VarChar 1 - N Y Yes
            N No
LogInstanc Log Instance Int 11 - 0    
ObjType Object Type nVarChar 20 ADP1 1    
ValidFor Active VarChar 1 - N Y Yes
            N No
ValidFrom Active From Date 8 -      
ValidTo Active To Date 8 -      
ValidComm Active Remarks nVarChar 30 -      
FrozenFor Inactive VarChar 1 - N Y Yes
            N No
FrozenFrom Inactive From Date 8 -      
FrozenTo Inactive To Date 8 -      
FrozenComm Inactive Remarks nVarChar 30 -      
Counter Counter Int 11 - 0    
Segment_0 Segment 0 nVarChar 20 -      
Segment_1 Segment 1 nVarChar 20 -      
Segment_2 Segment 2 nVarChar 20 -      
Segment_3 Segment 3 nVarChar 20 -      
Segment_4 Segment 4 nVarChar 20 -      
Segment_5 Segment 5 nVarChar 20 -      
Segment_6 Segment 6 nVarChar 20 -      
Segment_7 Segment 7 nVarChar 20 -      
Segment_8 Segment 8 nVarChar 20 -      
Segment_9 Segment 9 nVarChar 20 -      
FormatCode Format Code nVarChar 210 -      
CfwRlvnt Cash Flow Relevant [Y/N] VarChar 1 - N Y Yes
            N No
ExchRate Exchange Rate Differences VarChar 1 - Y Y Yes
            N No
RevalAcct Revaluation Account nVarChar 15 -      
LastRevBal Last Revaluation Balance Num 19.6 -      
LastRevDat Last Revaluation Date Date 8 -      
DfltVat Default VAT Group nVarChar 8 OVTG      
VatChange Allow Change VAT Group VarChar 1 - Y Y Yes
            N No
Category Category Int 11 OACG      
TransCode Transaction Code nVarChar 4 OTRC      
OverCode5 Loading Factor Code 5 nVarChar 8 OOCR      
OverCode2 Loading Factor Code 2 nVarChar 8 OOCR      
OverCode3 Loading Factor Code 3 nVarChar 8 OOCR      
OverCode4 Loading Factor Code 4 nVarChar 8 OOCR      
DfltTax Default Tax Code nVarChar 8 OSTC      
TaxPostAcc Default Tax Posting Account VarChar 1 - N N  
            R Sales Tax Account
            P Purchasing Tax Account
AcctStrLe Account Structure Level nVarChar 2 -      
MeaUnit Measurement Unit nVarChar 10 -      
BalDirect Direction of Balance nVarChar 4 - 0 0  
            1 Credit
            2 Debit
UserSign2 Updating User Int 6 OUSR      
PlngLevel B1i Info for Integration nVarChar 2 -      
MultiLink Allow Multiple Linking VarChar 1 - N N No
            Y Yes
PrjRelvnt Project Relevant VarChar 1 - N Y Yes
            N No
Dim1Relvnt Dimension 1 Relevant VarChar 1 - N Y Yes
            N No
Dim2Relvnt Dimension 2 Relevant VarChar 1 - N Y Yes
            N No
Dim3Relvnt Dimension 3 Relevant VarChar 1 - N Y Yes
            N No
Dim4Relvnt Dimension 4 Relevant VarChar 1 - N Y Yes
            N No
Dim5Relvnt Dimension 5 Relevant VarChar 1 - N Y Yes
            N No
AccrualTyp Accrual Type VarChar 1 - N N None
            P Posting Account
            C Calculation Account
            I Calculation Interim Account
DatevAcct DATEV Account nVarChar 8 -      
DatevAutoA DATEV Automatic Account VarChar 1 - N Y Yes
            N No
DatevFirst First Data Entry VarChar 1 - Y Y Yes
            N No
SnapShotId Snapshot ID Int 11 - 0    
PCN874Rpt PCN 874 Report Relevant VarChar 1 - N Y Yes
            N No
SCAdjust SC Adjustment VarChar 1 - N Y Yes
            N No
BPLId Assigned Branch Int 11 OBPL      
BPLName Branch Name nVarChar 200 -      
SubLedgerN Subledger No. nVarChar 60 -      
VATRegNum VAT Reg. Number nVarChar 32 -      
ActId Account Identifier nVarChar 210 -      
ClosingAcc G/L Account Closing nVarChar 15 -      
PurpCode Account Purpose Code nVarChar 2 -   01 Contas de ativo
            02 Contas de Passivo
            03 Patrim�nio L�quido
            04 Contas de Resultado
            05 Contas de Compensa��o
            09 Outras
RefCode Referential Account Code nVarChar 30 -      
BlocManPos Block Manual Posting VarChar 1 - N Y Yes
            N No
PriAccCode Primary Closing Account nVarChar 15 OACT      
CstAccOnly Cost Account Only VarChar 1 - N Y YES
            N NO
AlloweFrom Account Balance Allowed From Num 19.6 -      
AllowedTo Account Balance Allowed To Num 19.6 -      
BalanceA Account Balance Allowed VarChar 1 - N N NO
            Y YES
RmrkTmpt Remark Text Template Int 11 OTTR      
CemRelvnt Cost Element Relevant VarChar 1 - N Y Yes
            N No
CemCode Cost Element Code nVarChar 20 OCEM      
StdActCode Standard Account Code nVarChar 35 -      
TaxonCode Taxonomy Code nVarChar 15 -      
InClassTyp Income Class. Type Int 11 OICP      
InClassCat Income Class. Category Int 11 OICC      
ExClassTyp Expense Class. Type Int 11 OECP      
ExClassCat Expense Class. Category Int 11 OECC      
OffcCode Official Account Code nVarChar 15 -      
EUBPRelvnt euBP-Relevant VarChar 1 - N Y Yes
            N No
Key Unique Field
PRIMARY Yes AcctCode
INTER_KEY No FatherNum
CURRENCY No ActCurr
FORMAT No FormatCode
COUNTER No Counter
IDENTIFIER Yes ActId