| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | PERNR | Personnel number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | STRNR | Personal tax number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | ID | Commission contract internal ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | SORSZ | Sequence number of payment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | STAT | Comm - Processing status (Act, Rev, Old) | char | 1 | 0 | | | | Allow NULL? |
| 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | | | Allow NULL? |
| 9 | FUPER | For-period for payroll | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | KIF_DAT | Payment date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | TIMESTAMP | Program run ID (YYYYMMDDhhmmss###) | nvarchar | 17 | 0 | | | | Allow NULL? |
| 12 | KIF_0164 | Comm -0164 valid at payment(AGREN,EUHOZ,ANREN,ANKRA-B,EUPRZ) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | BRUTTO | Comm - Gross amounts in items | decimal | 25 | 8 | | | | |
| 14 | FPER | Comm - First processing period | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | BOOKING_PERNR | Comm - PERNR when posting | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | UDAT | Date of bank transfer | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | CLKEY | Comm - Commission key for relation P21_PS_HAVIBONT | nvarchar | 16 | 0 | | | | Allow NULL? |
| 18 | KISOSSZEGU_E | Small-amount payment | char | 1 | 0 | | | | Allow NULL? |
| 19 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | B_MV_EHO | Comm - HIP base % | decimal | 25 | 8 | | | | |
| 21 | B_MA_JAR | Comm - base for contribution paid by employers | decimal | 25 | 8 | | | | |
| 22 | B_MV_JAR | Comm - Base for contribution paid by employees | decimal | 25 | 8 | | | | |
| 23 | B_MV_NY | Comm - Pension fund contribution paid by employees | decimal | 25 | 8 | | | | |
| 24 | B_MV_EUP | Comm - Employee's health insurance contribution cash | decimal | 25 | 8 | | | | |
| 25 | B_MV_EUT | Comm - Employee's health insurance contribution in-kind | decimal | 25 | 8 | | | | |
| 26 | K_MV_EHO | Comm - % HIP base (corr.) | decimal | 25 | 8 | | | | |
| 27 | K_MA_JAR | Comm - Base for contribution paid by employers (correction) | decimal | 25 | 8 | | | | |
| 28 | K_MV_JAR | Comm - Base for contribution paid by employees (corr.) | decimal | 25 | 8 | | | | |
| 29 | K_MV_NY | Comm - Pension fund contribution paid by employees (corr.) | decimal | 25 | 8 | | | | |
| 30 | K_MV_EUP | Comm - Employee's health insurance contribution cash (corr.) | decimal | 25 | 8 | | | | |
| 31 | K_MV_EUT | Comm - Health fund contrib.paid by employees in-kind (corr.) | decimal | 25 | 8 | | | | |
| 32 | K_EHONAP | Comm. - number of itemized HIP days | smallint | 5 | 0 | | | | |
| 33 | K_EHOFT | Comm - Lump-sum HIP days total | decimal | 25 | 8 | | | | |
| 34 | K_JARMAX_NAP | Comm. - days for calculating contribution maximum | smallint | 5 | 0 | | | | |
| 35 | K_JARMAX_FELETT | Amount above contribution maximum | decimal | 25 | 8 | | | | |
| 36 | DAILY_AVG | | decimal | 25 | 0 | | | | |
