| 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 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | | | |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | OBRAS | Welfare Fund | nvarchar | 6 | 0 | | | | Allow NULL? |
| 9 | OSNOA | Welfare Fund affiliation number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 10 | OBRAO | Original Welfare Fund of the employee | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | SYJUB | Indicator: Employee belongs to the distribution scheme | char | 1 | 0 | | | | Allow NULL? |
| 12 | CAFJP | Administradoras de Fondos de Jubilaciones y Pensiones | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | TYACT | Employee activity code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | ARTID | Type of absence due to accident or occupational illness | char | 1 | 0 | | | | Allow NULL? |
| 15 | TCSES | Type of work contract in Argentina | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | GESES | Grouping of employee subgroups for Social Insurance | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | PLANS | Welfare Fund plan | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | CSERV | Service character | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | TPUOS | Calculation of deductions and contributions to Welfare Fund | char | 1 | 0 | | | | Allow NULL? |
| 20 | ASPCE | Employee grouping for Social Insurance contributions | nvarchar | 4 | 0 | | | | Allow NULL? |