|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Discount Groups
Table Name: AEDG
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 |
| Â | Â | LogInstanc |