| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | FCODE | Superannuation Fund Code NZ | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | FUTYP | KIwi Saver or Complying type of fund | char | 1 | 0 | | | | Allow NULL? |
| 7 | ABART | Employee subgroup grouping for personnel calculation rule | char | 1 | 0 | | | | Allow NULL? |
| 8 | LGART | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | APZNR | PC205 assignment | varbinary | 1 | 0 | | | | |
| 10 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | | | |
| 11 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | | | |
| 12 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | | | |
| 13 | ALZNR | Assignment for alternative payment | varbinary | 1 | 0 | | | | |
| 14 | C1ZNR | Pointer to cost accounting | varbinary | 2 | 0 | | | | |
| 15 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | | | |
| 16 | ABZNR | Absence assignment | varbinary | 1 | 0 | | | | |
| 17 | V0TYP | Variable assignment type | char | 1 | 0 | | | | Allow NULL? |
| 18 | V0ZNR | Variable assignment number | varbinary | 1 | 0 | | | | |
| 19 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | BETPE | Payroll: Amount per unit | decimal | 15 | 2 | | | | |
| 21 | SCRTE | | decimal | 15 | 0 | | | | |
| 22 | ANZHL | HR payroll: Number | decimal | 15 | 2 | | | | |
| 23 | BETRG | HR Payroll: Amount | decimal | 15 | 2 | | | | |
| 24 | SCAMT | | decimal | 15 | 0 | | | | |
| 25 | RTE_CURR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |