AFM1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Administration / Tax Formula Parameter Declaration

API AFM1

AFM1 - Tax Formula Parameter Declaration Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
FmlId ^KEY ^UNIQUE	Formula ID	Int		11	OFML Tax Formula Master Table		PRIMARY	Yes
DispOrder	Display Order	Int		11
VarName	Variable Name	nVarChar		64
Category	Category	VarChar	1) Input 2) Output 3) In Out	1		1
Parameter	Parameter	Text		16
DataType	Data Type	VarChar	T) Tax Amounts S) Amounts P) Prices Q) Quantities %) Percents I) Integer A) String B) Boolean M) Measures	1		S
LogInstanc	Log Instance	Int		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

OFML SQL Table

biuan SAP® BUSINESS ONE

SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates