biuan SAP® BUSINESS ONE SDK
API OFML
OFML - Tax Formula Master Table Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
CodeCodenVarChar
20
DescrDescriptionnVarChar
100
SttIdTax Type IDInt
11OSTT
Sales Tax Authorities Type
FmlLangFormula Language Free TextText
16
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
FmlType KEY UNIQUEFormula TypeVarChar
T) Tax
W) WTax
1
TCODEYes
IsOrigFmlOriginal/Edited FormulaVarChar
Y) Yes
N) No
1
Y

Table relationship map

SELECT statement

SELECT OFML.AbsId AS 'Internal Number', OFML.Code AS 'Code', OFML.Descr AS 'Description', OFML.SttId AS 'Tax Type ID', OFML.FmlLang AS 'Formula Language Free Text', OFML.LogInstanc AS 'Log Instance', OFML.UserSign2 AS 'Updating User', OFML.UpdateDate AS 'Update Date', OFML.FmlType AS 'Formula Type', OFML.IsOrigFml AS 'Original/Edited Formula' FROM OFML AS OFML

Related information


OFML SQL Table

Sales Tax Authorities Type OSTT SQL Table

Users OUSR 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