| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TRNUM | ITA88 Transaction Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | ISDAT | ITA88 Issue Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | STDAT | Recovery Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | SEQNO | Sequence Number | tinyint | 3 | 0 | | | | |
| 6 | RUNID | Run Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | TONAM | Trading or Other Name | nvarchar | 90 | 0 | | | | Allow NULL? |
| 8 | PAYEREF | PAYE Reference Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | PSOFT | Payroll Software | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | EENAM | Employee Surname or Trading Name | nvarchar | 120 | 0 | | | | Allow NULL? |
| 11 | FTNAM | First two Names | nvarchar | 90 | 0 | | | | Allow NULL? |
| 12 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 13 | ICNUM | Identity Number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 14 | REFNO | Tax Reference Number ZA | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | PERNR | Personnel number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | ACDAT | ITA88 Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | ENDAT | ITA88 End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | MODED | ITA88 Monthly Deduction | decimal | 15 | 2 | | | | |
| 19 | ERAMT | Employer Amount Due | decimal | 15 | 2 | | | | |
| 20 | PREFN | Payment Reference Number | nvarchar | 19 | 0 | | | | Allow NULL? |
| 21 | CADAT | ITA88 Cancellation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | CAVAL | ITA88 Cancel Value | decimal | 15 | 2 | | | | |
| 23 | CAREA | ITA88 Cancellation Reason | nvarchar | 90 | 0 | | | | Allow NULL? |
| 24 | DFAMT | ITA88 Default Amount (3345) | decimal | 15 | 2 | | | | |
| 25 | OTCDE | ITA88 Outcome Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | PAAMT | Employer ITA88 Paid Amount | decimal | 15 | 2 | | | | |
| 27 | ITEND | Last Infotype 11 Update Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | ITED1 | Last Infotype 11 Update Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | ITAM1 | ITA88 Monthly Deduction | decimal | 15 | 2 | | | | |
| 30 | ITAD1 | ITA88 Monthly Deduction | decimal | 15 | 2 | | | | |
| 31 | ITED2 | Last Infotype 11 Update Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | ITAM2 | ITA88 Monthly Deduction | decimal | 15 | 2 | | | | |
| 33 | ITAD2 | ITA88 Monthly Deduction | decimal | 15 | 2 | | | | |
| 34 | ITED3 | Last Infotype 11 Update Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | ITAM3 | ITA88 Monthly Deduction | decimal | 15 | 2 | | | | |
| 36 | ITAD3 | ITA88 Monthly Deduction | decimal | 15 | 2 | | | | |
| 37 | ITED4 | Last Infotype 11 Update Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 38 | ITAM4 | ITA88 Monthly Deduction | decimal | 15 | 2 | | | | |
| 39 | ITAD4 | ITA88 Monthly Deduction | decimal | 15 | 2 | | | | |
| 40 | ITED5 | Last Infotype 11 Update Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | ITAM5 | ITA88 Monthly Deduction | decimal | 15 | 2 | | | | |
| 42 | ITAD5 | ITA88 Monthly Deduction | decimal | 15 | 2 | | | | |
