biuan SAP® BUSINESS ONE SDK
API AEDG
AEDG - Discount Groups Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEUnique EntryInt
11
PRIMARYYes
TypeTypeVarChar
A) All BPs
C) Customer Group
V) Vendor Group
S) Specific BP
1
ObjTypeObject TypenVarChar
-1)
10) Card Payment Groups
2) Cards
20
-1
ObjCodeObject CodenVarChar
15
DiscRelDisc. RelationsVarChar
L) Lowest Discount
H) Highest Discount
A) Average
S) Total
M) Discount Multiples
1
L
ValidForActiveVarChar
Y) Yes
N) No
1
Y
ValidFormActive FromDate
8
ValidToActive ToDate
8
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser FormInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
CreateDateCreation DateDate
8
UpdateDateUpdate DateDate
8

SELECT statement

SELECT AEDG.AbsEntry AS 'Unique Entry', AEDG.Type AS 'Type', AEDG.ObjType AS 'Object Type', AEDG.ObjCode AS 'Object Code', AEDG.DiscRel AS 'Disc. Relations', AEDG.ValidFor AS 'Active', AEDG.ValidForm AS 'Active From', AEDG.ValidTo AS 'Active To', AEDG.DataSource AS 'Data Source', AEDG.UserSign AS 'User Form', AEDG.LogInstanc AS 'Log Instance', AEDG.UserSign2 AS 'Updating User', AEDG.CreateDate AS 'Creation Date', AEDG.UpdateDate AS 'Update Date' FROM AEDG AS AEDG

Related information


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