Table ORGAFFIL
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| ORGAFFIL | ORA | Organization membership | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| ORA0 | LEV+POP+CPY+FCY+REFNUM+CTR+ORG | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CODOPT | Option | A | 30 | |||||
| CODPOP | Population | A | 30 | |||||
| CPY | Company | CPY | [CPY]CPY0=[ORA]CPY | Block | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[ORA]CREUSR | Other | ||||
| CTR | Contract | CTR | ||||||
| FCY | Site | FCY | [FCY]FCY0=[ORA]FCY | Delete | ||||
| LEV | Folder, Plant, Emp | M | 15 | 506 | ||||
| NUMAFF | Membership no. | A | 35 | |||||
| NUMCTR | Contract no. | A | 35 | |||||
| ORG | Organization | ORG | [ORG]ORG0=[ORA]ORG | Block | ||||
| ORGCRT | Site tax ID no. | CRT | ||||||
| POP | Population | POP | [POP]POP0=POP | Delete | ||||
| REFNUM | Employee ID | MAT | [ID]ID0=[ORA]REFNUM | Delete | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[ORA]UPDUSR | Other |