| 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 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | P_PERNR | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | HRPY_RGDIR | CDSEQ | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | HRDCT_ROWID | Allow NULL? |
| 5 | NUMCI | CI number (key for CI cluster table) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P12_CI_NUMCI | Allow NULL? |
| 6 | APZNR | PC205 assignment | varbinary | 1 | 0 | RAW | | Yes | | APZNR | |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 8 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 9 | SUBTY | Subtype | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SUBTY | Allow NULL? |
| 10 | CIPID | Indemnity ID | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P12_CI_CIPID | Allow NULL? |
| 11 | ALSGR | Allowance subgroup | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P12_CI_ALLW_SUBGROUP | Allow NULL? |
| 12 | ALLGA | Wage Type for the Social Welfare Benefit Theoretical Amount | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P12_CI_ALLW_LGART | Allow NULL? |
| 13 | ALBET | Social Welfare Benefit Theoretical Amount (00956) | decimal | 13 | 2 | CURR | ((0)) | Yes | | P12_CI_ALLW_BETRG | |
| 14 | DBNOT | Debtor (00949) | char | 1 | 0 | CHAR | (N' ') | Yes | * | P12_CI_DBNOT | Allow NULL? |
| 15 | FPDAT | First Complementary Indemnity Date (00823) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P12_CI_FPDAT | Allow NULL? |
| 16 | FPAGE | Age at First Complementary Indemnity Date | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | P12_CI_FP_AGE | Allow NULL? |
| 17 | NUMMO | Number of Months | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | P12_CI_NUM_MONTHS | Allow NULL? |
| 18 | BEGPC | Joint Commission (00046) | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | * | P12_CI_BEGPC | Allow NULL? |
| 19 | NACEC | NACE Code (00228) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | P12_CI_NACEC | Allow NULL? |
| 20 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | RSZCA | Allow NULL? |
| 21 | RSZKN | Worker Code (SI Employee Category) (00037) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | RSZKN | Allow NULL? |
| 22 | BEGGH | Dependent Family Members | char | 1 | 0 | CHAR | (N' ') | Yes | | P12_CI_BEGGH | Allow NULL? |
| 23 | ERNID | Employer ID | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | P12_CI_ERID | Allow NULL? |
| 24 | HTIND | Half-Time (00825) | char | 1 | 0 | CHAR | (N' ') | Yes | | P12_CI_HTIND | Allow NULL? |
| 25 | RPLEE | Substitute Employee (00749) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | P12_CI_RPLEE | Allow NULL? |
| 26 | SEREX | Work Exemption (00826) | char | 1 | 0 | CHAR | (N' ') | Yes | | P12_CI_SEREX | Allow NULL? |
| 27 | AGTYP | Agreement Type (00824) | char | 1 | 0 | NUMC | (N'0') | Yes | * | P12_CI_AGTYP | Allow NULL? |
| 28 | RECON | Resumption of Work Measure (00853) | char | 1 | 0 | CHAR | (N' ') | Yes | | P12_CI_RECON | Allow NULL? |
| 29 | NOTDT | Notice Date (00951) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P12_CI_NOTDT | Allow NULL? |
| 30 | AILRE | Recognition of Difficulty or Reorganization (00952) | char | 1 | 0 | CHAR | (N' ') | Yes | | BDHST | Allow NULL? |
| 31 | AKBEG | Acknowledgement Start Date (00953) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P12_CI_AKBEG | Allow NULL? |
| 32 | AKEND | Acknowledgement End Date (00954) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P12_CI_AKEND | Allow NULL? |
| 33 | PYTYP | Capitalization Payment Type (00892) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | P12_CI_PAYMENT_TYPE | Allow NULL? |
| 34 | REWOR | Resumption of Work Type | char | 1 | 0 | CHAR | (N' ') | Yes | | P12_CI_REWOR | Allow NULL? |
| 35 | MLERD | Multiple Employers as Debtor | char | 1 | 0 | CHAR | (N' ') | Yes | | P12_CI_MLERD | Allow NULL? |
| 36 | ETQSP | Employment % | decimal | 5 | 2 | DEC | ((0)) | Yes | | P12_CI_ET_QS_PERCENT | |
| 37 | ADNOT | Complementary Indemnity Amount Adjustment (00829) | char | 1 | 0 | CHAR | (N' ') | Yes | * | P12_CI_ADNOT | Allow NULL? |
| 38 | INJUS | Incomplete Month (00959) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | P12_CI_INJUS | Allow NULL? |
| 39 | PYLGA | Wage Type of the Complementary Indemnity Amount | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P12_CI_LGART | Allow NULL? |
| 40 | PYBET | Amount of the complementary indemnity | decimal | 13 | 2 | CURR | ((0)) | Yes | | P12_CI_BETRG | |
| 41 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 42 | AGRDT | Agreement Date | char | 1 | 0 | CHAR | (N' ') | Yes | | P12_CI_AGRDT | Allow NULL? |
| 43 | PRCLV | Specification for CI Processing Class | char | 1 | 0 | CHAR | (N' ') | Yes | * | P12_CI_AUSPV | Allow NULL? |
| 44 | PLPAP | Number of Planned Payments | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | P12_CI_PLPAP | Allow NULL? |
| 45 | REINP | Reference Capitalization Period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | P12_CI_REINP | Allow NULL? |
| 46 | CINOM | Reference indemnity payment period | decimal | 8 | 5 | DEC | ((0)) | Yes | | P12_CI_CINOM | |
| 47 | PAYAM | Capitalization Payment Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P12_CI_PAYAM | |
| 48 | PAYLG | Indemnity Payment Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P12_CI_PAYLG | Allow NULL? |
| 49 | C1ZNR | Pointer to cost accounting | varbinary | 2 | 0 | RAW | | Yes | | C1ZNO | |
