| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | APRFNR | Application reference number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | ENTGELTART | Remuneration Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | ENTGELTE | Remunerations in Entitlement Period | decimal | 15 | 2 | | | | |
| 9 | ENTGELTE_WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | WOKNZ | West/East Indicator | char | 1 | 0 | | | | Allow NULL? |
| 11 | NUMER | Imputation factor: Numerator | decimal | 7 | 3 | | | | |
| 12 | DENOM | Imputation factor: Denominator | decimal | 7 | 3 | | | | |
| 13 | AUSBILDUNG | Indicator for Training Period | char | 1 | 0 | | | | Allow NULL? |
| 14 | RVPNB | Indicator: Second Job Liable to PI Contributions | char | 1 | 0 | | | | Allow NULL? |
| 15 | INFOF | Indicator: Do Not Evaluate | char | 1 | 0 | | | | Allow NULL? |
| 16 | AEDTM | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | FIKT_GW | Indicator for Notional Active Military Service | char | 1 | 0 | | | | Allow NULL? |
| 19 | UNTERBRECH_ART | Suspension Type Entitlement Period Retro. Pension Insurance | nvarchar | 2 | 0 | | | | Allow NULL? |