| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | NISSE | Company CA code | nvarchar | 11 | 0 | NUMC | (N'00000000000') | No | T5E08 | NISS1 | Allow NULL? |
| 3 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 4 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 5 | NISSC | Center identifier | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NISSC | Allow NULL? |
| 6 | GROUP_ID | Company group/grouping indentifier | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5E11 | PES_GRPID | Allow NULL? |
| 7 | REGIMEN | RED system: Social Insurance category | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PES_REG | Allow NULL? |
| 8 | SECTOR | RED system: Social Insurance sector | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PES_SEC | Allow NULL? |
| 9 | CALIFIC | RED system: Company code classifier | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PES_CALIF | Allow NULL? |
| 10 | TIPO_IDEN | RED system: Identification type | char | 1 | 0 | CHAR | (N' ') | Yes | | PES_IDEN | Allow NULL? |
| 11 | TIPO_EMPRE | Alphabetical type for employer | char | 1 | 0 | CHAR | (N' ') | Yes | | PES_TIPEMP | Allow NULL? |
| 12 | RAZON_SOC | Registered company name | nvarchar | 55 | 0 | CHAR | (N' ') | Yes | | PES_RZS | Allow NULL? |
| 13 | CONTACTO | RED system: Contact employee | nvarchar | 34 | 0 | CHAR | (N' ') | Yes | | PES_CONTAC | Allow NULL? |
| 14 | TELEFONO | RED system: Telephone number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PES_TEL | Allow NULL? |
| 15 | FAX | RED system: Fax number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PES_FAX | Allow NULL? |
| 16 | DOMICIL | Address | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | PES_DOMIC | Allow NULL? |
| 17 | CODPOS | Postal code | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | PES_CDPOS | Allow NULL? |
| 18 | LOCALIDAD | Town | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | PES_LOCAL | Allow NULL? |
| 19 | DENO_EXPLO | Name of activity | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PES_EXPLO | Allow NULL? |
| 20 | COD_LOC | Town code according to INEM | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | T5E35 | PES_CODLOC | Allow NULL? |
| 21 | AEPTX | Description of the company's main economic activity | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | PES_AEPTX | Allow NULL? |
| 22 | COMPANY_EE_IND | Number of company employees indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PES_COMPANY_EE_INDICATOR | Allow NULL? |
