Table CNGCPY
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| CNGCPY | CNG | Annual leave periods | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CNG0 | CPY+YEA+TIM | No | |
| CNG1 | TIM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CPY | Company | CPY | [CPY]CPY0=[CNG]CPY | Delete | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[CNG]CREUSR | Other | ||||
| CUM | Accumulated total | CUM | [CUM]CUM0=[CNG]CUM | Block | PAY | |||
| CUMACQ | Accumulated | 2 | CUM | [CUM]CUM0=[CNG]CUMACQ | Block | PAY | ||
| CUMPRI | Taken | 2 | CUM | [CUM]CUM0=[CNG]CUMPRI | Block | PAY | ||
| DEBDAT | Accepted start | D | ||||||
| ENDDAT | End date | D | ||||||
| ENDPER | End date | D | ||||||
| FINDAT | Accepted end | D | ||||||
| LVEFOR | Formula | AFR | 30 | KSA | ||||
| LVESEL | Leave cycle | M | 22 | 11667 | KSA | |||
| LVETRM | Term | C | 2 | KSA | ||||
| STRDAT | Start date | D | ||||||
| STRPER | Start date | D | ||||||
| TIM | Nature of events | TPS | [TIM]TIM0=[CNG]TIM | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[CNG]UPDUSR | Other | ||||
| YEA | Year | C | 4 |