|
|
SQL Finance / G/L Accounts
DTW Financials / Chart of Accounts
API OACT / Chart Of Accounts
OACT - G/L Accounts Table
Chart Of Accounts ChartOfAccounts Object· Table: OACT
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AcctCode KEY UNIQUE | Account Code | nVarChar | 15 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| AcctName | Account Name | nVarChar | 100 | |||||
| CurrTotal | Current Balance | Num | 20 | |||||
| EndTotal | Opening Balance | Num | 20 | |||||
| Finanse | Cash Account [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| Groups | Main Group | nVarChar | 8 | |||||
| Budget | Budget | VarChar | Y) Yes N) No | 1 | N | |||
| Frozen | Account on Hold [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| Free_2 | Free 2 | VarChar | 1 | |||||
| Postable | Account [Active/Title] | VarChar | Y) Active Account N) Title Account | 1 | Y | |||
| 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 KEY | Parent Account Key | nVarChar | 15 | INTER_KEY | No | |||
| AccntntCod | External Code | nVarChar | 15 | |||||
| CashBox | Capital Account [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| GroupMask | Group Mask | Int | 6 | 1 | ||||
| RateTrans | For Conversion Differences | VarChar | Y) Yes N) No | 1 | Y | |||
| TaxIncome | Tax Definition | VarChar | Y) Yes N) No | 1 | N | |||
| ExmIncome | Tax Definition | VarChar | Y) Yes N) No | 1 | N | |||
| ExtrMatch | External Reconciliation No. | Int | 11 | |||||
| IntrMatch | Internal Reconciliation No. | Int | 11 | |||||
| ActType | Account Category | VarChar | I) Sales E) Expenditure N) Other | 1 | N | |||
| Transfered | Year Transfer [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| BlncTrnsfr | Balances Transferred [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| OverType | Loading Type | VarChar | N) None Y) Yes | 1 | N | |||
| OverCode | Loading Factor Code | nVarChar | 8 | OOCR Distribution Rule | ||||
| SysMatch | System Reconciliation No. | Int | 11 | -1 | ||||
| PrevYear | There are accounts from the previous yea | VarChar | Y) Yes N) No | 1 | N | |||
| ActCurr KEY | Account Currency | nVarChar | 3 | OCRN Currency Codes | CURRENCY | No | ||
| RateDifAct | Rate Differences Account | nVarChar | 15 | |||||
| SysTotal | Balance in System Currency | Num | 20 | |||||
| FcTotal | Balance in Account Currency | Num | 20 | |||||
| Protected | Protected Account [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| RealAcct | Reconciled Account [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| Advance | Liable for Advances | VarChar | Y) Yes N) No | 1 | Y | |||
| CreateDate | Creation Date | Date | 8 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| FrgnName | Foreign Name | nVarChar | 100 | |||||
| Details | Details | nVarChar | 127 | |||||
| ExtraSum | Additional Amount | Num | 20 | |||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| RevalMatch | Revaluation Coordinated [Yes/No] | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | 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 | |||
| LocMth | LC Reconciliation | VarChar | Y) Yes N) No | 1 | Y | |||
| MTHCounter | MTH Counter | Int | 11 | |||||
| BNKCounter | BNK Counter | Int | 11 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LocManTran | Lock Manual Transaction | VarChar | Y) Yes N) No | 1 | N | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 1 | |||
| ValidFor | Active | VarChar | Y) Yes N) No | 1 | N | |||
| ValidFrom | Active From | Date | 8 | |||||
| ValidTo | Active To | Date | 8 | |||||
| ValidComm | Active Remarks | nVarChar | 30 | |||||
| FrozenFor | Inactive | VarChar | Y) Yes N) No | 1 | N | |||
| FrozenFrom | Inactive From | Date | 8 | |||||
| FrozenTo | Inactive To | Date | 8 | |||||
| FrozenComm | Inactive Remarks | nVarChar | 30 | |||||
| Counter KEY | Counter | Int | 11 | 0 | COUNTER | No | ||
| 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 KEY | Format Code | nVarChar | 127 | FORMAT | No | |||
| CfwRlvnt | Cash Flow Relevant [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| ExchRate | Exchange Rate Differences | VarChar | Y) Yes N) No | 1 | Y | |||
| RevalAcct | Revaluation Account | nVarChar | 15 | |||||
| LastRevBal | Last Revaluation Balance | Num | 20 | |||||
| LastRevDat | Last Revaluation Date | Date | 8 | |||||
| DfltVat | Default VAT Group | nVarChar | 8 | OVTG Tax Definition | ||||
| VatChange | Allow Change VAT Group | VarChar | Y) Yes N) No | 1 | Y | |||
| Category | Category | Int | 11 | OACG Account Category | ||||
| TransCode | Transaction Code | nVarChar | 4 | OTRC Journal Entry Codes | ||||
| OverCode5 | Loading Factor Code 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OverCode2 | Loading Factor Code 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OverCode3 | Loading Factor Code 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OverCode4 | Loading Factor Code 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| DfltTax | Default Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| TaxPostAcc | Default Tax Posting Account | VarChar | N) R) Sales Tax Account P) Purchasing Tax Account | 1 | N | |||
| AcctStrLe | Account Structure Level | nVarChar | 2 | |||||
| MeaUnit | Measurement Unit | nVarChar | 10 | |||||
| BalDirect | Direction of Balance | nVarChar | 0 1) Credit 2) Debit | 4 | 0 | |||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| PlngLevel | B1i Info for Integration | nVarChar | 2 | |||||
| MultiLink | Allow Multiple Linking | VarChar | N) No Y) Yes | 1 | N | |||
| PrjRelvnt | Project Relevant | VarChar | Y) Yes N) No | 1 | N | |||
| Dim1Relvnt | Dimension 1 Relevant | VarChar | Y) Yes N) No | 1 | N | |||
| Dim2Relvnt | Dimension 2 Relevant | VarChar | Y) Yes N) No | 1 | N | |||
| Dim3Relvnt | Dimension 3 Relevant | VarChar | Y) Yes N) No | 1 | N | |||
| Dim4Relvnt | Dimension 4 Relevant | VarChar | Y) Yes N) No | 1 | N | |||
| Dim5Relvnt | Dimension 5 Relevant | VarChar | Y) Yes N) No | 1 | N | |||
| AccrualTyp | Accrual Type | VarChar | N) None P) Posting Account C) Calculation Account I) Calculation Interim Account | 1 | N | |||
| DatevAcct | DATEV Account | Int | 11 | |||||
| DatevAutoA | DATEV Automatic Account | VarChar | Y) Yes N) No | 1 | N | |||
| DatevFirst | First Data Entry | VarChar | Y) Yes N) No | 1 | Y | |||
| SnapShotId | Snapshot ID | Int | 11 | 0 | ||||
| PCN874Rpt | PCN 874 Report Relevant | VarChar | Y) Yes N) No | 1 | N | |||
| SCAdjust | SC Adjustment | VarChar | Y) Yes N) No | 1 | N | |||
| BPLId | Assigned Branch | Int | 11 | OBPL Business Place | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| SubLedgerN | Subledger No. | nVarChar | 60 | |||||
| VATRegNum | VAT Reg. Number | nVarChar | 32 | |||||
| ActId KEY UNIQUE | Account Identifier | nVarChar | 127 | IDENTIFIER | Yes | |||
| ClosingAcc | G/L Account Closing | nVarChar | 15 | |||||
| PurpCode | Account Purpose Code | nVarChar | 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 | ||||
| RefCode | Referential Account Code | nVarChar | 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
ChartOfAccounts
Enumeration
Method
Property
AccountLevel
DB
AccountType
DTW DB
AcctCurrency
DTW DB
ActiveAccount
DTW DB
AllowChangeVatGroup
DTW DB
Balance
DB
BudgetAccount
DTW DB
CashAccount
DTW DB
Category
DTW DB
Code
DTW DB
DataExportCode
DTW DB
DefaultVatGroup
DTW DB
Details
DTW DB
ExternalCode
DTW DB
FatherAccountKey
DTW DB
ForeignName
DTW DB
FormatCode
DTW DB
LiableForAdvances
DTW DB
LoadingFactorCode
DTW DB
LoadingFactorCode2
DTW DB
LoadingFactorCode3
DTW DB
LoadingFactorCode4
DTW DB
LoadingFactorCode5
DTW DB
LoadingType
DTW DB
LockManualTransaction
DTW DB
Name
DTW DB
PlanningLevel
DTW DB
ProjectCode
DTW DB
Protected
DTW DB
RateConversion
DTW DB
ReconciledAccount
DTW DB
RevaluationCoordinated
DTW DB
TaxExemptAccount
DTW DB
TaxLiableAccount
DTW DB
TransactionCode
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
