| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | WERKS | Personnel Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | BTRTL | Personnel Subarea | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | ENTID | Enterprise unified ID | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | TAXGP | Tax grouping for company | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | PSIAU | Social insurance authority institution code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | ENTPI | Enterprise pension insurance ID | nvarchar | 20 | 0 | | | | Allow NULL? |
| 8 | MSIAU | Social insurance authority institution code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | ENTMI | Enterprise medical care insurance ID | nvarchar | 20 | 0 | | | | Allow NULL? |
| 10 | USIAU | Social insurance authority institution code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | ENTUI | Enterprise unemployment insurance ID | nvarchar | 20 | 0 | | | | Allow NULL? |
| 12 | ISIAU | Social insurance authority institution code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | ENTII | Enterprise on-job injure insurance ID | nvarchar | 20 | 0 | | | | Allow NULL? |
| 14 | BSIAU | Social insurance authority institution code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | ENTBI | Enterprise maternity insurance ID | nvarchar | 20 | 0 | | | | Allow NULL? |
| 16 | PHFAC | Public Housing Fund authority institution code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | ENTHI | Enterprise public housing fund ID | nvarchar | 20 | 0 | | | | Allow NULL? |
| 18 | PLCOD | Personal file holding location code | nvarchar | 8 | 0 | | | | Allow NULL? |