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

SQL Inventory and Production / Discount Groups Rows

DTW Inventory / Price Lists / Special Prices / Discount Groups

API EDG1

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Unique Entry	Int		11	OEDG Discount Groups		PRIMARY	Yes
ObjType	Object Type	nVarChar	52) Item Groups 8) Item Properties 43) Manufacturer 4) Items	20
ObjKey	Object Key	nVarChar		20
DiscType	Discount Type	VarChar	D) Discount P) Pay for/Get for Free	1		D
Discount	Discount	Num		20
PayFor	Paid Qty	Num		20
ForFree	Free Qty	Num		20
UpTo	Max. Free Qty	Num		20
LogInstanc	Log Instance	Int		11		0

SELECT statement

SELECT
   EDG1.AbsEntry AS 'Unique Entry', 
   EDG1.ObjType AS 'Object Type', 
   EDG1.ObjKey AS 'Object Key', 
   EDG1.DiscType AS 'Discount Type', 
   EDG1.Discount AS 'Discount', 
   EDG1.PayFor AS 'Paid Qty', 
   EDG1.ForFree AS 'Free Qty', 
   EDG1.UpTo AS 'Max. Free Qty', 
   EDG1.LogInstanc AS 'Log Instance'
FROM EDG1 AS EDG1

Related information

OEDG 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