biuan SAP® BUSINESS ONE SDK
API AFM1
AFM1 - Tax Formula Parameter Declaration Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
FmlId KEY UNIQUEFormula IDInt
11OFML
Tax Formula Master Table
PRIMARYYes
DispOrderDisplay OrderInt
11
VarNameVariable NamenVarChar
64
CategoryCategoryVarChar
1) Input
2) Output
3) In Out
1
1
ParameterParameterText
16
DataTypeData TypeVarChar
T) Tax Amounts
S) Amounts
P) Prices
Q) Quantities
%) Percents
I) Integer
A) String
B) Boolean
M) Measures
1
S
LogInstancLog InstanceInt
11
0

SELECT statement

SELECT AFM1.FmlId AS 'Formula ID', AFM1.DispOrder AS 'Display Order', AFM1.VarName AS 'Variable Name', AFM1.Category AS 'Category', AFM1.Parameter AS 'Parameter', AFM1.DataType AS 'Data Type', AFM1.LogInstanc AS 'Log Instance' FROM AFM1 AS AFM1

Related information


Tax Formula Master Table OFML 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