| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | FCODE | Superannuation Fund Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | | | |
| 10 | DPERC | Superannuation Employee Default Percentage | decimal | 5 | 2 | | | | |
| 11 | CONAM | Superannuation Contribution Amount | decimal | 9 | 2 | | | | |
| 12 | EXCLF | Superannuation Fund Exclusion Flag Australia | char | 1 | 0 | | | | Allow NULL? |
| 13 | SUPSC | Superannuation Salary Usage | char | 1 | 0 | | | | Allow NULL? |
| 14 | SUPES | Superannuation Period Salary | decimal | 15 | 2 | | | | |
| 15 | EMPCN | Superannuation Employee Contribution Percentage | decimal | 5 | 2 | | | | |
| 16 | EMPAM | Superannuation Employee Contribution Amount | decimal | 9 | 2 | | | | |
| 17 | MEMNO | Superannuation Fund Membership Number Australia | nvarchar | 20 | 0 | | | | Allow NULL? |
| 18 | MESSG | Superannuation Fund Message Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | SUPFR | Superannuation Australia Factoring Method | char | 1 | 0 | | | | Allow NULL? |
| 20 | COMFR | Superannuation Australia Factoring Method | char | 1 | 0 | | | | Allow NULL? |
| 21 | EMPFR | Superannuation Australia Factoring Method | char | 1 | 0 | | | | Allow NULL? |
| 22 | CONTR | Contributor status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | EFFDT | APS Superannuation date of effect | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | BENHR | APS Superannuation benefit hours | decimal | 5 | 2 | | | | |
| 25 | PIPEN | APS Superannuation PIP | char | 1 | 0 | | | | Allow NULL? |
| 26 | NOTSL | APS Superannuation Notional Salary | decimal | 15 | 2 | | | | |
| 27 | PIPHR | APS Superannuation PIP hours | decimal | 5 | 2 | | | | |
| 28 | TAXFN | Use of TFN for Superannuation indicator | char | 1 | 0 | | | | Allow NULL? |
| 29 | PYCTR | APS Pay Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | CS551 | Partial contributor | char | 1 | 0 | | | | Allow NULL? |
| 31 | CS542 | Employee going for part-time for more than 12 months | char | 1 | 0 | | | | Allow NULL? |
| 32 | ADSAL | APS Adjust Salary | decimal | 15 | 2 | | | | |
| 33 | ADALL | APS Adjust Allowance | decimal | 15 | 2 | | | | |
| 34 | ADHDA | APS Adjust Higher duty allowance | decimal | 15 | 2 | | | | |
| 35 | ADPLT | APS Adjust Penalties | decimal | 15 | 2 | | | | |
| 36 | INSAL | APS initial salary | decimal | 15 | 2 | | | | |
| 37 | INALL | APS initial allowance | decimal | 15 | 2 | | | | |
| 38 | INHDA | APS initial HDA | decimal | 15 | 2 | | | | |
| 39 | INPLT | APS initial penalties | decimal | 15 | 2 | | | | |
| 40 | CONLO | Contribute lower superable salary | char | 1 | 0 | | | | Allow NULL? |
| 41 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 42 | EXCHO | Choice for Superannuation Fund Exclusion | char | 1 | 0 | | | | Allow NULL? |
| 43 | PSSAM | Contribution mode, Superable salary / OTE | char | 1 | 0 | | | | Allow NULL? |
