| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Administration | ||||||||||
| 1 | ODCR | Checking Rule | 10 | validFor | Active | VarChar | 1 | 0 | N | |
| Business Partners | ||||||||||
| 2 | ACRD | Business Partners - History | 151 | validFor | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 3 | OCRD | Business Partner | 151 | validFor | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 4 | TGG1 | Target Group Details | 6 | validFor | Active | VarChar | 1 | 0 | A=Active, I=Inactive | |
| Finance | ||||||||||
| 5 | AACT | G/L Account - History | 53 | ValidFor | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 6 | OACT | G/L Accounts | 53 | ValidFor | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |
| General | ||||||||||
| 7 | ARSC | Resource Master Data - Log | 27 | validFor | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 8 | ORSC | Resources | 27 | validFor | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |
| Inventory and Production | ||||||||||
| 9 | AEDG | Discount Groups | 6 | ValidFor | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 10 | AITM | Items - History | 189 | validFor | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 11 | APLN | Price Lists | 14 | ValidFor | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 12 | OEDG | Discount Groups | 6 | ValidFor | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 13 | OITM | Items | 189 | validFor | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 14 | OPLN | Price Lists | 14 | ValidFor | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 15 | SITM | Items | 189 | validFor | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 16 | UITM | Items | 189 | validFor | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |