biuan SAP® BUSINESS ONE SDK
API LGL1
LGL1 - Legal Data - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal IDInt
11OLGL
Legal Data
PRIMARYYes
LineSeqLine SequenceInt
11
LineTypeLine TypeVarChar
T) Document Total
R) Tax Per Line
V) Total Tax
1
R
TaxCodeTax CodenVarChar
8
TaxRateTax RateNum
20
AmountAmountNum
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


Legal Data OLGL 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