biuan SAP® BUSINESS ONE SDK
API OTPA
OTPA - Tax Parameter Attributes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
Code KEY UNIQUEAttribute CodenVarChar
8
CODEYes
DescrDescriptionnVarChar
30
DataTypeData TypeVarChar
S) Amounts
P) Prices
Q) Quantities
%) Percents
I) Integer
A) String
M) Measures
1
S
FieldIdField ID in CUFDInt
11CUFD
User Fields - Description
LockedLockedVarChar
Y) Yes
N) Changeable
1
N

Table relationship map

SELECT statement

SELECT OTPA.AbsId AS 'Internal Number', OTPA.Code AS 'Attribute Code', OTPA.Descr AS 'Description', OTPA.DataType AS 'Data Type', OTPA.FieldId AS 'Field ID in CUFD', OTPA.Locked AS 'Locked' FROM OTPA AS OTPA

Related information


OTPA SQL Table

User Fields - Description CUFD 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