| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Administration | ||||||||||
| 1 | AUSR | Users - History | 12 | DISCOUNT | Max. Discount | Num | 19 | 6 | ||
| 2 | OUSR | Users | 12 | DISCOUNT | Max. Discount | Num | 19 | 6 | ||
| Business Partners | ||||||||||
| 3 | ACRD | Business Partners - History | 22 | Discount | Discount % | Num | 19 | 6 | ||
| 4 | AOA1 | Blanket Agreement - Rows | 21 | Discount | Line Discount | Num | 19 | 6 | ||
| 5 | OAT1 | Blanket Agreement - Rows | 21 | Discount | Line Discount | Num | 19 | 6 | ||
| 6 | OCRD | Business Partner | 22 | Discount | Discount % | Num | 19 | 6 | ||
| Finance | ||||||||||
| 7 | CDC1 | Cash Discount - Rows | 4 | Discount | Discount % | Num | 19 | 6 | ||
| Inventory and Production | ||||||||||
| 8 | ADG1 | Discount Groups Rows | 5 | Discount | Discount | Num | 19 | 6 | ||
| 9 | ASP1 | Special Prices - Data Areas | 6 | Discount | Discount % | Num | 19 | 6 | ||
| 10 | ASP2 | Special Prices - Quantity Areas | 8 | Discount | Discount in % | Num | 19 | 6 | ||
| 11 | ASPP | Special Prices | 5 | Discount | Discount in % | Num | 19 | 6 | ||
| 12 | EDG1 | Discount Groups Rows | 5 | Discount | Discount | Num | 19 | 6 | ||
| 13 | OSPG | Special Prices for Groups | 4 | Discount | Discount | Num | 19 | 6 | ||
| 14 | OSPP | Special Prices | 5 | Discount | Discount in % | Num | 19 | 6 | ||
| 15 | SPP1 | Special Prices - Data Areas | 6 | Discount | Discount % | Num | 19 | 6 | ||
| 16 | SPP2 | Special Prices - Quantity Areas | 8 | Discount | Discount in % | Num | 19 | 6 | ||