biuan SAP® BUSINESS ONE SDK
API GTI1
GTI1 - GTS Invoice Details Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OGTI
GTS Invoice
PRIMARYYes
LineNumLine NumberInt
11
DisctLineDiscount FlagVarChar
0
1) Discount Line
1
0
ItemNameItem NamenVarChar
60
ItemSpecItem SpecificationnVarChar
30
UomUnit of MeasurementnVarChar
16
QuantityQuantityNum
20
NetAmountNet AmountNum
20
VatPercentVAT PercentNum
20
VatAmountVAT AmountNum
20
UnitPriceUnit PriceNum
20
UnitPricTpUnit Price TypeVarChar
0
1) Gross
1
0
ItemTaxCatItem Tax CategorynVarChar
4

SELECT statement

SELECT GTI1.AbsEntry AS 'Internal Number', GTI1.LineNum AS 'Line Number', GTI1.DisctLine AS 'Discount Flag', GTI1.ItemName AS 'Item Name', GTI1.ItemSpec AS 'Item Specification', GTI1.Uom AS 'Unit of Measurement', GTI1.Quantity AS 'Quantity', GTI1.NetAmount AS 'Net Amount', GTI1.VatPercent AS 'VAT Percent', GTI1.VatAmount AS 'VAT Amount', GTI1.UnitPrice AS 'Unit Price', GTI1.UnitPricTp AS 'Unit Price Type', GTI1.ItemTaxCat AS 'Item Tax Category' FROM GTI1 AS GTI1

Related information


GTS Invoice OGTI 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