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

SQL Finance / GBI Row 15 - Enterprise's VAT Payable Detail Report

API GBI15

GBI15 - GBI Row 15 - Enterprise's VAT Payable Detail Report 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
ItemName	Item Name	nVarChar	100
LineNum	Line Number	nVarChar	6
CurMonAmnt	Current Month Amount	Num	20
CurYrAmnt	Current Year Amount	Num	20

SELECT statement

SELECT
   GBI15.HistoryId AS 'History Key', 
   GBI15.RowId AS 'Row Number', 
   GBI15.ItemName AS 'Item Name', 
   GBI15.LineNum AS 'Line Number', 
   GBI15.CurMonAmnt AS 'Current Month Amount', 
   GBI15.CurYrAmnt AS 'Current Year Amount'
FROM GBI15 AS GBI15

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