biuan SAP® BUSINESS ONE SDK
API OGBI
OGBI - GB Interface: Common Info Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUENumeratorInt
11
PRIMARYYes
RepNoReport NumbernVarChar
20
RepCompanyReport Company NamenVarChar
60
RepPeriodReport PeriodnVarChar
8
CurrencyCurrency UnitnVarChar
10
UserSignUser SignatureInt
6
CreateDateReport Creation DatenVarChar
8
RepTypeReport TypeInt
0
1) Electronic Account Book
2) G/L Account Master Records
3) Departments
16) Employees
4) Business Partners
5) Projects
6) G/L Account Balance
7) Accounting Vouchers
8) Enterprise's Balance Sheet
9) Enterprise's Profit and Loss Statement
10) Enterprise's Cash Flow Statement
11) Devalue Provision of Enterprise Assets
12) Shareholder's Rights and Interests Changing Report
13) Enterprise's Profit Distribution Report
14) Small Enterprise's Cash Flow Statement
15) Enterprise's VAT Payable Detail Report
11
0
RepEntityReport EntitynVarChar
60

SELECT statement

SELECT OGBI.AbsEntry AS 'Numerator', OGBI.RepNo AS 'Report Number', OGBI.RepCompany AS 'Report Company Name', OGBI.RepPeriod AS 'Report Period', OGBI.Currency AS 'Currency Unit', OGBI.UserSign AS 'User Signature', OGBI.CreateDate AS 'Report Creation Date', OGBI.RepType AS 'Report Type', OGBI.RepEntity AS 'Report Entity' FROM OGBI AS OGBI

Related information


OGBI 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