| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TDNUM | Tax district number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | TDREF | Tax district indicator | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | FAPER | HR-GB: payroll period | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | NPYFP | No payment due as no employees or subcontractors paid | char | 1 | 0 | | | | Allow NULL? |
| 7 | ADRYR | Advance received from HMRC Year to date | decimal | 15 | 2 | | | | |
| 8 | SSPRY | Value of SSP recovered Year to date | decimal | 15 | 2 | | | | |
| 9 | SMPRY | Value of SMP recovered Year to date | decimal | 15 | 2 | | | | |
| 10 | OSPRY | Value of OSPP recovered Year to date | decimal | 15 | 2 | | | | |
| 11 | SAPRY | Value of SAP recovered Year to date | decimal | 15 | 2 | | | | |
| 12 | ASPRY | Value of ASPP recovered Year to date | decimal | 15 | 2 | | | | |
| 13 | NSMPY | Value of NIC compensation on SMP Year to date | decimal | 15 | 2 | | | | |
| 14 | NOSPY | Value of NIC compensation on OSPP Year to date | decimal | 15 | 2 | | | | |
| 15 | NSAPY | Value of NIC compensation on SAP Year to date | decimal | 15 | 2 | | | | |
| 16 | NASPY | Value of NIC compensation on ASPP Year to date | decimal | 15 | 2 | | | | |
| 17 | CISDY | Value of CIS deductions suffered Year to date | decimal | 15 | 2 | | | | |
| 18 | NICHY | Value of NICs Holiday Year to date | decimal | 15 | 2 | | | | |
| 19 | FINSC | Final submission because scheme ceased | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | FINAL | Final submission for year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | FTXPY | Free of tax payments to an employee | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | EVBFO | Benefits to employees while they were employed | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | EMOUK | Employed outside UK for 30 days or more in a row | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | PYTSO | Paid employee’s pay to someone other than the employee | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | P11FD | Completed forms P11D and P11D(b) are due | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | SRCOM | Service Company | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 28 | STATUS | RTI E filing Status | char | 1 | 0 | | | | Allow NULL? |
