biuan SAP® BUSINESS ONE SDK
DTW Inventory / Price Lists / Special Prices / Discount Groups
API EDG1
EDG1 - Discount Groups Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEUnique EntryInt
11OEDG
Discount Groups
PRIMARYYes
ObjTypeObject TypenVarChar
52) Item Groups
8) Item Properties
43) Manufacturer
4) Items
20
ObjKeyObject KeynVarChar
20
DiscTypeDiscount TypeVarChar
D) Discount
P) Pay for/Get for Free
1
D
DiscountDiscountNum
20
PayForPaid QtyNum
20
ForFreeFree QtyNum
20
UpToMax. Free QtyNum
20
LogInstancLog InstanceInt
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


Discount Groups OEDG 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