biuan SAP® BUSINESS ONE SDK
API GTM1
GTM1 - GTS Mapping Object Details Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OGTM
GTS Mapping Object
PRIMARYYes
LineNumLine NumberInt
11
ItemCodeItem CodenVarChar
20OITM
Items
ItemNameItem NamenVarChar
100
ItemUoMItem UoMnVarChar
100
ItemSpecItem Spec.nVarChar
30
ItemTaxCatItem Tax CategorynVarChar
4
QuantityQuantityNum
20
AmountAmountNum
20
VatPercentVAT PercentNum
20
DiscRateDiscount RateNum
20
DiscAmountDiscount AmountNum
20
VatAmountVAT AmountNum
20
DiscVatAmtDiscount VAT AmountNum
20
UnitPriceUnit PriceNum
20
UPirceTypeUnit Price TypeVarChar
0
1) Gross
1
0

Table relationship map

SELECT statement

SELECT GTM1.AbsEntry AS 'Internal Number', GTM1.LineNum AS 'Line Number', GTM1.ItemCode AS 'Item Code', GTM1.ItemName AS 'Item Name', GTM1.ItemUoM AS 'Item UoM', GTM1.ItemSpec AS 'Item Spec.', GTM1.ItemTaxCat AS 'Item Tax Category', GTM1.Quantity AS 'Quantity', GTM1.Amount AS 'Amount', GTM1.VatPercent AS 'VAT Percent', GTM1.DiscRate AS 'Discount Rate', GTM1.DiscAmount AS 'Discount Amount', GTM1.VatAmount AS 'VAT Amount', GTM1.DiscVatAmt AS 'Discount VAT Amount', GTM1.UnitPrice AS 'Unit Price', GTM1.UPirceType AS 'Unit Price Type' FROM GTM1 AS GTM1

Related information


GTS Mapping Object OGTM SQL Table

Items OITM 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