biuan SAP® BUSINESS ONE SDK
SQL Finance / G/L Accounts / Account Category
DTW Financials / Chart of Accounts / Account Category
API Chart Of Accounts / Category
OACG - Account Category Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
NameNamenVarChar
40
Source KEY UNIQUESourceVarChar
B) Balance Sheet
P) Profit and Loss
O) Other
1
BSECONDYes
LockedLockedVarChar
Y) Yes
N) No
1
N
DateSourceDate SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Document Date
P) Partner Implementation
T) Year Transfer
1
UserSignUser SignaturenVarChar
6OUSR
Users

Table relationship map

SELECT statement

SELECT OACG.AbsId AS 'Internal Number', OACG.Name AS 'Name', OACG.Source AS 'Source', OACG.Locked AS 'Locked', OACG.DateSource AS 'Date Source', OACG.UserSign AS 'User Signature' FROM OACG AS OACG

Related information


Category Category Property· Table: OACG
Sets or returns this chart of account category.Field name: category.This is a foreign key to the OACG object.
· Table: OACT    Parent: Chart Of Accounts ChartOfAccounts Object· Table: OACT
OACG 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