| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Business Partners | ||||||||||
| 1 | ACRD | Business Partners - History | 152 | validFrom | Active From | Date | 8 | 0 | ||
| 2 | OCRD | Business Partner | 152 | validFrom | Active From | Date | 8 | 0 | ||
| Finance | ||||||||||
| 3 | AACT | G/L Account - History | 54 | ValidFrom | Active From | Date | 8 | 0 | ||
| 4 | AJD1 | Journal Entry - History - Rows | 77 | ValidFrom | Valid from | Date | 8 | 0 | 19000101 | |
| 5 | AMDR1 | Manual Distribution Rule - Rows | 7 | ValidFrom | Effective from | Date | 8 | 0 | 19000101 | |
| 6 | BTF1 | Journal Voucher | 77 | ValidFrom | Valid from | Date | 8 | 0 | 19000101 | |
| 7 | JDT1 | Journal Entry - Rows | 77 | ValidFrom | Valid from | Date | 8 | 0 | 19000101 | |
| 8 | MDR1 | Manual Distribution Rule - Rows | 7 | ValidFrom | Effective From | Date | 8 | 0 | 19000101 | |
| 9 | OACT | G/L Accounts | 54 | ValidFrom | Active From | Date | 8 | 0 | ||
| 10 | OPRJ | Project Codes | 6 | ValidFrom | Valid from | Date | 8 | 0 | ||
| Inventory and Production | ||||||||||
| 11 | AITM | Items - History | 190 | validFrom | Active From | Date | 8 | 0 | ||
| 12 | OITM | Items | 190 | validFrom | Active From | Date | 8 | 0 | ||
| 13 | SITM | Items | 190 | validFrom | Active From | Date | 8 | 0 | ||
| 14 | UITM | Items | 190 | validFrom | Active From | Date | 8 | 0 | ||
| Sales Opportunities | ||||||||||
| 15 | AOC1 | Distribution Rule - Rows | 7 | ValidFrom | Effective from | Date | 8 | 0 | ||
| 16 | OCR1 | Distribution Rule - Rows | 7 | ValidFrom | Effective From | Date | 8 | 0 | 19000101 | |
| 17 | OPRC | Cost Center | 10 | ValidFrom | Valid from | Date | 8 | 0 | ||