| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2CN_SUI | Payroll result: Supplementary Insurance (CN) | 5 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 2 | P2IN_IOS | Income from other sources | 22 | INTYP | Income Type From Other Sources | nvarchar | 4 | 0 | | |
| 3 | T7CN27 | Social average salary switch period | 3 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 4 | T7QA26 | Occupational Hazard(Serious Incident) | 3 | INTYP | Serious Incident Type | nvarchar | 3 | 0 | | |
| TOPChina |
| 5 | PA0532 | HR Master Record: Infotype 0532 (Insurance) | 24 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 6 | T7CN13 | Salary information (CN) | 3 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 7 | T7CN14 | Contribution change reason | 3 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 8 | T7CN15 | Social insurance authority institution information | 3 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 9 | T7CN15T | Social insurance authority institution name | 4 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 10 | T7CN1A | Contribution change reason text | 4 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 11 | T7CN20 | Contribution base | 3 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 12 | T7CN22 | Pass Rule ER-to-EE | 3 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 13 | T7CN24 | Contribution Type | 3 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 14 | T7CN25 | Contribution Area | 3 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 15 | T7CN26 | Contribution switch period | 3 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 16 | T7CN29 | Social insurance | 4 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 17 | T7CN2A | Contribution Area Text | 4 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 18 | T7CN2Y | Contribution Type Text | 4 | INTYP | Insurance type | nvarchar | 4 | 0 | | |
| 19 | T7CN3F | Reported Tax Data | 4 | INTYP | Tax Income Type | nvarchar | 1 | 0 | | |
| 20 | T7CNC9 | Assign External Institution to Pension Plan | 3 | INTYP | External Institution Type | nvarchar | 2 | 0 | | |
| TOPCollectionsDisbursements |
| 21 | TKKVINVER | Dunning Information Procedure | 3 | INTYP | Information Category | nvarchar | 3 | 0 | | |
| TOPIndia |
| 22 | PA0584 | Income from other sources | 41 | INTYP | Income Type From Other Sources | nvarchar | 4 | 0 | | |
| TOPMaintenance Orders |
| 23 | /MRSS/D_WORKTIME | Pers. Resource: HCM - Base Normal and Planning Working Time | 4 | INTYP | Daily Work Schedule: Interval Type for an Employee | nvarchar | 2 | 0 | | |
| TOPPayroll |
| 24 | T7PL11 | Configuration of data sources for ZUS reporting | 3 | INTYP | Infotype | nvarchar | 4 | 0 | | |
| TOPPersonnel Administration |
| 25 | PA0604 | Invalidism SI | 42 | INTYP | Invalidity group | nvarchar | 2 | 0 | | |
| 26 | PB0604 | Invalidism SI | 42 | INTYP | Invalidity group | nvarchar | 2 | 0 | | |
| TOPPersonnel Time Management |
| 27 | PTEX2003SPEC | Interface Table for IT 2003: Interval Information | 8 | INTYP | Daily Work Schedule: Interval Type for an Employee | nvarchar | 2 | 0 | | |
| TOPPublic Sector |
| 28 | T5RPBS10G | Interdict/Stop pay type | 3 | INTYP | Interdict/Stop pay type | nvarchar | 3 | 0 | | |
| 29 | T5RPBS10GT | Text Table for Interdiction Type | 4 | INTYP | Interdict/Stop pay type | nvarchar | 3 | 0 | | |
| TOPReuse Services for Country Development |
| 30 | T5F99F0 | Forms | 13 | INTYP | Inheritance type | nvarchar | 1 | 0 | | |
| 31 | T5F99FS | Forms: Sections | 20 | INTYP | Inheritance type | nvarchar | 1 | 0 | | |
| TOPTaiwan |
| 32 | T7TW1A | Insurance Type | 2 | INTYP | Insurance type | nvarchar | 1 | 0 | | |
| 33 | T7TW1B | Insurance Amount Category | 2 | INTYP | Insurance type | nvarchar | 1 | 0 | | |
| 34 | T7TW1C | Insurance Subsidy Percentage | 2 | INTYP | Insurance type | nvarchar | 1 | 0 | | |
| 35 | T7TW1G | Insurer Name and Address | 2 | INTYP | Insurance type | nvarchar | 1 | 0 | | |
| 36 | T7TW1GT | Insurer Name and Address | 3 | INTYP | Insurance type | nvarchar | 1 | 0 | | |
| 37 | T7TW1L | Last rported data of LI/NHI reports | 6 | INTYP | Insurance type | nvarchar | 1 | 0 | | |
| 38 | T7TW1Q | Reason for Insurance Status Change | 2 | INTYP | Insurance type | nvarchar | 1 | 0 | | |
| 39 | T7TW1R | Reason for Insurance Status Change (Text) | 3 | INTYP | Insurance type | nvarchar | 1 | 0 | | |
| 40 | T7TW1Z | Insurance Type Text | 3 | INTYP | Insurance type | nvarchar | 1 | 0 | | |
| TOPUSA |
| 41 | T5UF0 | HR-US: ADP Interface | 3 | INTYP | HR-US: ADP Interface, Interface Type | nvarchar | 1 | 0 | | |
| 42 | T5UF1 | HR-US: ADP Interface, ADP Fields | 1 | INTYP | HR-US: ADP Interface, Interface Type | nvarchar | 1 | 0 | | |
| 43 | T5UF2 | HR-US: ADP Interface, used fields per Interface | 3 | INTYP | HR-US: ADP Interface, Interface Type | nvarchar | 1 | 0 | | |
| 44 | T5UF3 | HR-US: ADP Interface, field sort | 3 | INTYP | HR-US: ADP Interface, Interface Type | nvarchar | 1 | 0 | | |
| 45 | T5UF4 | HR-US: ADP Interface, Record type | 3 | INTYP | HR-US: ADP Interface, Interface Type | nvarchar | 1 | 0 | | |
| 46 | T5UF5 | HR-US: ADP Interface, fields per record type | 3 | INTYP | HR-US: ADP Interface, Interface Type | nvarchar | 1 | 0 | | |
| 47 | T5UF6 | HR-US: ADP Interface, Mapping Information | 3 | INTYP | HR-US: ADP Interface, Interface Type | nvarchar | 1 | 0 | | |
