Table PERIOD
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| PERIOD | PEO | Extraction periods | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PEO1 | YEA+FCY+LIG | No | |
| PEO0 | FCY+PYRDAT | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| EXPNUM | Export number | L | 8 | |||||
| FCY | Site | FCY | [FCY]FCY0=[PEO]FCY | Block | ||||
| LIG | Line | C | 4 | |||||
| NUMWEK | Week | 6 | C | 2 | ||||
| PEREND | End | 5 | D | |||||
| PERSTR | Start | 5 | D | |||||
| PYRDAT | Pay date | D | ||||||
| STA | Input | M | 4 | 1 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 | |||||
| YEA | Year | C | 4 | |||||
| YEAWEK | Year | 6 | C | 4 |