Table TMPDUCS
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| TMPDUCS | TDU | DUCS | Payroll |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TDU0 | USR+FCY+CAI+CODDCS+RAT+RATWAC+ORGCOD+PERDEB+LIBREF1 | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AMT1 | Base 1 | DCB | 9.2 | |||||
| AMT2 | Base 2 | DCB | 9.2 | |||||
| AMT3 | Contributions | DCB | 9.2 | |||||
| AUUID | Single identifier | AUUID | ||||||
| CAI | Type | M | 15 | 386 | ||||
| CAICOD | Fund | M | 15 | 329 | ||||
| CODDCS | DUCS code | ADI | [ADI]CODE=377;CODDCS | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[TDU]CREUSR | Other | ||||
| FCY | Site | FCY | [FCY]FCY0=[TDU]FCY | Block | ||||
| LIBREF1 | Reference | ADI | [ADI]CODE=389;LIBREF1 | Block | ||||
| LIBREF2 | Reference | ADI | [ADI]CODE=388;LIBREF2 | Block | ||||
| NBREMP1 | Workforce | C | 4 | |||||
| NBREMP2 | Number of annualized contracts | C | 4 | |||||
| ORGCOD | Organization | ORG | [ORG]ORG0=[TDU]ORGCOD | Block | ||||
| PERDEB | Period from the | D | ||||||
| QTY2 | Second quantity | DCB | 9.2 | |||||
| RAT | Rate | DCB | 3.2 | |||||
| RATWAC | WA rate | DCB | 3.2 | |||||
| TYPDCS | Contribution type | C | 1 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[TDU]UPDUSR | Other | ||||
| USR | User code | AUS | [AUS]CODUSR=[TDU]USR | Delete |