| 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 | REVTY | Revision Type | char | 1 | 0 | CHAR | (N' ') | No | | P03_REVTY | Allow NULL? |
| 4 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEGDA | Allow NULL? |
| 5 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 6 | SEQNR | Sequence Document Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | P03_SEQNR | Allow NULL? |
| 7 | SETYP | Record Type for Electronic Notification | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_SETYP | Allow NULL? |
| 8 | READY | Release Status for Electronic Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_READY | Allow NULL? |
| 9 | SRTZA | Process Status for Consolidation and Notification Creation | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | P03_SRTZA | Allow NULL? |
| 10 | EMETH | Electronic Notification Procedure | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_EMETH | Allow NULL? |
| 11 | LZTYP | Payslip Data Category | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_LZTYP | Allow NULL? |
| 12 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | P03_MUNAM | Allow NULL? |
| 13 | DATUM | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P03_MDATU | Allow NULL? |
| 14 | UZEIT | Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | P03_MTIME | Allow NULL? |
| 15 | PGMID | ABAP Program Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P03_MPROG | Allow NULL? |
| 16 | EPRO2 | ELDA Project | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_EPRO2 | Allow NULL? |
| 17 | ESVGR | SI Group Transferring Data | char | 1 | 0 | CHAR | (N' ') | Yes | * | P03_ESVGR | Allow NULL? |
| 18 | EUSVA | ELDA: Insurance Agency as Data Recipient | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PC03_UVST0 | Allow NULL? |
| 19 | WOBD0 | Additional Classification Key for Employer | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PB03_WOBD0 | Allow NULL? |
| 20 | ZOBD0 | Additional Classification Key for Employer | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | PB03_ZOBD0 | Allow NULL? |
| 21 | EDTNR | ELDA: Data Medium Number | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | PC03_DTRNR | Allow NULL? |
| 22 | ESANR | ELDA: Sequence Record Number for Each Data Medium | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | PC03_LFDNR | Allow NULL? |
| 23 | ESANI | ELDA: Number of the Corresponding Information Record | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | P03_ESANI | Allow NULL? |
| 24 | LFVER | Payslip Tax: Structure Version | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P03_LFVER | Allow NULL? |
| 25 | TFDAT | Date of Transfer | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P03_TFDAT | Allow NULL? |
| 26 | TFTIM | Time of Transfer | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | P03C_P_TIM | Allow NULL? |
| 27 | FEHL1 | Error ID for Electronic Notification Record | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P03_LZEID | Allow NULL? |
| 28 | FEHL2 | Error ID for Electronic Notification Record | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P03_LZEID | Allow NULL? |
| 29 | FEHL3 | Error ID for Electronic Notification Record | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P03_LZEID | Allow NULL? |
| 30 | FEHL4 | Error ID for Electronic Notification Record | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P03_LZEID | Allow NULL? |
| 31 | FEHL5 | Error ID for Electronic Notification Record | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P03_LZEID | Allow NULL? |
| 32 | ESTAT | External Process Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_EPSTA | Allow NULL? |
| 33 | ANZA0 | Payslip Tax: Number of Notifications (Current) | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | P03_ANZA0 | Allow NULL? |
| 34 | TTE18 | Total Number of Annual E18 Payslips for DME | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | P03_ANZE18 | Allow NULL? |
| 35 | REFNR | Reference Number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P03_REFNR | Allow NULL? |
| 36 | AUSVL | 1st Part of SI Number (Sequential Number) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | AUSVL | Allow NULL? |
| 37 | AUSVG | 2nd Part of SI Number (Birth Date) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | AUSVG | Allow NULL? |
| 38 | ANNNA | Last Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PAD_NACHN | Allow NULL? |
| 39 | ANVNA | First Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PAD_VORNA | Allow NULL? |
| 40 | ANTIT | Title | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TITEL | Allow NULL? |
| 41 | GESCH | Gender Key | char | 1 | 0 | CHAR | (N' ') | Yes | | GESCH | Allow NULL? |
| 42 | ANADR | Employee's Residential Address | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | P03_ANLST | Allow NULL? |
| 43 | ANLKZ | Vehicle Country Key for Home Address | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P03_ANLKZ | Allow NULL? |
| 44 | ANPLZ | Postal Code of Residential Address | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P03_ANPLZ | Allow NULL? |
| 45 | ANORT | Type of Residence | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P03_ORT01 | Allow NULL? |
| 46 | ANNUM | Tax Number - Employee | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | P03_ANSTE | Allow NULL? |
| 47 | ANFZA | Tax Office Number of Employee (4-Digit) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | P03_ANFA0 | Allow NULL? |
| 48 | LOHNB | Employer Assignment Unit | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P03_LOHNB | Allow NULL? |
| 49 | AGNUM | Employer Tax Number | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P03_AGNUM | Allow NULL? |
| 50 | AGFZA | Tax office number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | FZAMA | Allow NULL? |
| 51 | AGDVR | Employer's Data Processing Number | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P03_DVRNR | Allow NULL? |
| 52 | AGNAM | Name of Employer | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | P03_NAMAG | Allow NULL? |
| 53 | AGTIT | Title of Employer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P03_TITAG | Allow NULL? |
| 54 | AGADR | Address of Employer/Contracting Party/Benefits Provider | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | P03_ADRAG | Allow NULL? |
| 55 | AGLKZ | Vehicle Country Key for Company Address of Empl./Contr.Party | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P03_AGLKZ | Allow NULL? |
| 56 | AGZIP | Postal Code in Company Address of Employer, Contractng Party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P03_AGPLZ | Allow NULL? |
| 57 | AGORT | City in Company Address of Employer | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P03_ORTAG | Allow NULL? |
| 58 | LBTEL | Addresses: telephone no. | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | TLFNR | Allow NULL? |
| 59 | LBFAX | Fax number | nvarchar | 31 | 0 | CHAR | (N' ') | Yes | | TELFX_BAS | Allow NULL? |
| 60 | LVNUM | Tax Number of Payroll Service Provider | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P03_TRSTN | Allow NULL? |
| 61 | LVFZA | Tax Office Number of Payroll Service Provider | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | P03_TRFAN | Allow NULL? |
| 62 | LVDVR | Data Processing Number of Payroll Service Provider | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P03_TRDVR | Allow NULL? |
| 63 | ARTE0 | Type of Payslip E18 (Service Provided) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P03_ARTE0 | Allow NULL? |
| 64 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 65 | KZ341 | Remuneration (Without Sales Tax, Incl. Cost Reimb., P/K) | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ341 | |
| 66 | KZ344 | Invoiced Sales Tax (KZ344) | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ344 | |
| 67 | KZ270 | Employee's Contribution to Social Insurance | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ270 | |
| 68 | KZ271 | Paid Contribution to Company Pension Fund (BV) | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ271 | |
| 69 | INPER | Last In-Period of Payroll in the Record | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P03_IPERI | Allow NULL? |
| 70 | REFN0 | Reference Number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P03_REFNR | Allow NULL? |
