| 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 | * | MANDT | Allow NULL? |
| 2 | PERNR | Personnel number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | * | PERSNO | Allow NULL? |
| 3 | STARTD | P60-GB: Start date of work | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | P08_STARTD | Allow NULL? |
| 4 | TYPE | HR GB: Starter or Pensioner Indicator | char | 1 | 0 | CHAR | (N' ') | No | | P08_STPE | Allow NULL? |
| 5 | PFIRE | HR GB: Previous Employment Leaving Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P08_PFIREDATE | Allow NULL? |
| 6 | TXCOD | HR GB: Previous Employment Tax Code | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | P08_PTXCODE | Allow NULL? |
| 7 | TDREF | HR GB: Previous Employment Tax District Indicator | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | P08_PTDRCE | Allow NULL? |
| 8 | TDNUM | HR GB: Previous Employment Tax district number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | P08_PTDNUM | Allow NULL? |
| 9 | CLASS | HR GB: Starter Declaration | char | 1 | 0 | NUMC | (N'0') | Yes | | P08_P46CLS | Allow NULL? |
| 10 | PENAMT | HR GB: Pension Amount Paid by employer Annually to Employee | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_PENAMT | |
| 11 | PENWIDI | HR GB: Retiring on Pension Recently Bereaved Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_PENWIDI | Allow NULL? |
| 12 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 13 | PISSUED | HR GB: Pension Notification Issued | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_PISSUED | Allow NULL? |
| 14 | SISSUED | HR GB: Starter Notice Issued | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_SISSUED | Allow NULL? |
