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

SQL Finance / GBI Row 8 - Enterprise's Balance Sheet

API GBI8

GBI8 - GBI Row 8 - Enterprise's Balance Sheet Table

SBO SQL database table details

Field	Description	Type	Size	Related	Primary_Key	Unique
HistoryId ^KEY ^UNIQUE	History Key	Int	11	OGBI GB Interface: Common Info	PRIMARY	Yes
RowId	Row Number	Int	11
AcctName	Account Name	nVarChar	100
LineNum	Line Number	nVarChar	6
YearBAmt	Year Begin Amount	Num	20
PerEAmt	Period End Amount	Num	20
RepDate	Report Date	nVarChar	8

SELECT statement

SELECT
   GBI8.HistoryId AS 'History Key', 
   GBI8.RowId AS 'Row Number', 
   GBI8.AcctName AS 'Account Name', 
   GBI8.LineNum AS 'Line Number', 
   GBI8.YearBAmt AS 'Year Begin Amount', 
   GBI8.PerEAmt AS 'Period End Amount', 
   GBI8.RepDate AS 'Report Date'
FROM GBI8 AS GBI8

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