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

SQL

Others /

Legal Data - Rows

API LGL1

LGL1 - Legal Data - Rows Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal ID	Int		11	OLGL Legal Data		PRIMARY	Yes
LineSeq	Line Sequence	Int		11
LineType	Line Type	VarChar	T) Document Total R) Tax Per Line V) Total Tax	1		R
TaxCode	Tax Code	nVarChar		8
TaxRate	Tax Rate	Num		20
Amount	Amount	Num		20

SELECT statement

SELECT
   LGL1.AbsEntry AS 'Internal ID', 
   LGL1.LineSeq AS 'Line Sequence', 
   LGL1.LineType AS 'Line Type', 
   LGL1.TaxCode AS 'Tax Code', 
   LGL1.TaxRate AS 'Tax Rate', 
   LGL1.Amount AS 'Amount'
FROM LGL1 AS LGL1

Related information

OLGL 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates