OGBI - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Finance / GB Interface: Common Info

API OGBI

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Numerator	Int		11		PRIMARY	Yes
RepNo	Report Number	nVarChar		20
RepCompany	Report Company Name	nVarChar		60
RepPeriod	Report Period	nVarChar		8
Currency	Currency Unit	nVarChar		10
UserSign	User Signature	Int		6
CreateDate	Report Creation Date	nVarChar		8
RepType	Report Type	Int	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
RepEntity	Report Entity	nVarChar		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

biuan SAP® BUSINESS ONE

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