biuan SAP® BUSINESS ONE SDK
API OTPR
OTPR - Tax Return Values Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
Code KEY UNIQUEReturn Value CodenVarChar
7
CODEYes
DescrDescriptionnVarChar
30
DisplayDisplayVarChar
Y) Yes
N) No
1
Y
FieldIDField ID in CUFDInt
11CUFD
User Fields - Description
LockedLockedVarChar
Y) Yes
N) Changeable
1
N
DataTypeData TypeVarChar
T) Tax Amounts
S) Amounts
P) Prices
Q) Quantities
%) Percents
I) Integer
A) String
M) Measures
1
S

Table relationship map

SELECT statement

SELECT OTPR.AbsId AS 'Internal Number', OTPR.Code AS 'Return Value Code', OTPR.Descr AS 'Description', OTPR.Display AS 'Display', OTPR.FieldID AS 'Field ID in CUFD', OTPR.Locked AS 'Locked', OTPR.DataType AS 'Data Type' FROM OTPR AS OTPR

Related information


OTPR 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