| 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 | T000 | MANDT | Allow NULL? |
| 2 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T500L | MOLGA | Allow NULL? |
| 3 | SUPER | Superannuation Modifier | nvarchar | 2 | 0 | CHAR | (N' ') | No | T5QSZ | P13Q_SUPER | Allow NULL? |
| 4 | FCODE | Superannuation Fund Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T591A | P13Q_FCODE | Allow NULL? |
| 5 | RNUMB | Superannuation Restriction Rule Number | nvarchar | 2 | 0 | NUMC | (N'00') | No | | P13Q_RNUMB | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 8 | MINAG | Superannuation Minimum Age | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P13Q_MINAG | Allow NULL? |
| 9 | MAXAG | Superannuation Maximum Age | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P13Q_MAXAG | Allow NULL? |
| 10 | MINHR | Superannuation Minimum Hours | decimal | 5 | 2 | DEC | ((0)) | Yes | | P13Q_MINHR | |
| 11 | MINEA | Superannuation Minimum Earnings | decimal | 8 | 2 | DEC | ((0)) | Yes | | P13Q_MINEA | |
| 12 | MAXEA | Superannuation Maximum Earnings | decimal | 8 | 2 | DEC | ((0)) | Yes | | P13Q_MAXEA | |
| 13 | DPCON | Superannuation Default Contribution Percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | P13Q_DPCON | |
| 14 | MAXCN | Superannuation Maximum Company Contribution | decimal | 8 | 2 | DEC | ((0)) | No | | P13Q_MAXCN | |
| 15 | MINCN | Superannuation Minimum Company Contribution | decimal | 8 | 2 | DEC | ((0)) | No | | P13Q_MINCN | |
| 16 | PRIND | Maximum Contribution Processing Indicator | char | 1 | 0 | CHAR | (N' ') | No | | P13Q_PRIND | Allow NULL? |
| 17 | FACTR | Superannuation Australia Factoring Method | char | 1 | 0 | CHAR | (N' ') | Yes | | P13Q_FACTR | Allow NULL? |