SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: OEDG
Table Description: Discount Groups
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| AbsEntry |
Unique Entry |
Int |
11 |
- |
|
|
|
| Type |
Type |
VarChar |
1 |
- |
|
A |
All BPs |
| |
|
|
|
|
|
C |
Customer Group |
| |
|
|
|
|
|
V |
Vendor Group |
| |
|
|
|
|
|
S |
Specific BP |
| ObjType |
Object Type |
nVarChar |
20 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
10 |
Card Payment Groups |
| |
|
|
|
|
|
2 |
Cards |
| ObjCode |
Object Code |
nVarChar |
15 |
- |
|
|
|
| DiscRel |
Disc. Relations |
VarChar |
1 |
- |
L |
L |
Lowest Discount |
| |
|
|
|
|
|
H |
Highest Discount |
| |
|
|
|
|
|
A |
Average |
| |
|
|
|
|
|
S |
Total |
| |
|
|
|
|
|
M |
Discount Multiples |
| ValidFor |
Active |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ValidForm |
Active From |
Date |
8 |
- |
|
|
|
| ValidTo |
Active To |
Date |
8 |
- |
|
|
|
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| UserSign |
User Form |
Int |
6 |
OUSR |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| UpdateDate |
Update Date |
Date |
8 |
- |
|
|
|
| Key |
Unique |
Field |
| PRIMARY |
Yes |
AbsEntry |
| CODE_TYPE |
Yes |
ObjCode |
| |
|
Type |