biuan SAP® BUSINESS ONE SDK
DTW Inventory / Price Lists / Price Lists
API OLTB
OLTB - Location-based Tax Bal Table Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUENumeratorInt
11
PRIMARYYes
LocCode KEYLocation CodeInt
11OLCT
Location
indexNo
STATypeTax TypeInt
11OSTT
Sales Tax Authorities Type
STACodeSTA CodenVarChar
8OSTA
Sales Tax Authorities
BalaTypeBalance TypeVarChar
P)
R)
C)
F)
1
BalanceBalanceNum
20

Table relationship map

SELECT statement

SELECT OLTB.AbsId AS 'Numerator', OLTB.LocCode AS 'Location Code', OLTB.STAType AS 'Tax Type', OLTB.STACode AS 'STA Code', OLTB.BalaType AS 'Balance Type', OLTB.Balance AS 'Balance' FROM OLTB AS OLTB

Related information


Location OLCT SQL Table

Sales Tax Authorities OSTA SQL Table

Sales Tax Authorities Type OSTT 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