| 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 | FCODE | Superannuation Fund Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T591A | P13Q_FCODE | Allow NULL? |
| 4 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 6 | SGLFU | Superannuation Guarantee Fund Flag Australia | char | 1 | 0 | CHAR | (N' ') | Yes | | P13Q_SGLFU | Allow NULL? |
| 7 | EMPLR | Superannuation Fund Generated Employer Identifier | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P13Q_EMPLR | Allow NULL? |
| 8 | DPCON | Superannuation Default Contribution Percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | P13Q_DPCON | |
| 9 | OTEWT | Superannuation Ordinary Time Earnings Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5QSW | P13Q_OTEWT | Allow NULL? |
| 10 | EACCU | Superannuation W&S Earnings Cumulation Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5QSW | P13Q_EACCU | Allow NULL? |
| 11 | DEDEO | Superannuation Deduction Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5QSW | P13Q_DEDEO | Allow NULL? |
| 12 | CONCO | Superannuation Contribution Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5QSW | P13Q_CONCO | Allow NULL? |
| 13 | RETAF | Superannuation Retirement Age for Females | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P13Q_RETAF | Allow NULL? |
| 14 | RETAM | Superannuation Retirement Age for Males | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P13Q_RETAM | Allow NULL? |
| 15 | EDCON | Employee Default Contribution Percentage | decimal | 5 | 2 | DEC | ((0)) | No | | P13Q_EDCON | |
| 16 | MAXCN | Superannuation Maximum Company Contribution | decimal | 8 | 2 | DEC | ((0)) | Yes | | P13Q_MAXCN | |
| 17 | MINCN | Superannuation Minimum Company Contribution | decimal | 8 | 2 | DEC | ((0)) | Yes | | P13Q_MINCN | |
| 18 | FACTR | Superannuation Australia Factoring Method | char | 1 | 0 | CHAR | (N' ') | Yes | | P13Q_FACTR | Allow NULL? |
| 19 | DAGWT | Superannuation Deduction WT for aged employee | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P13Q_DAGWT | Allow NULL? |
| 20 | AGDPC | Superannuation Default Contribution Percentage for aged emp. | decimal | 5 | 2 | DEC | ((0)) | Yes | | P13Q_AGDPC | |
| 21 | IFLOW | Superannuation Inflow Wageytpe | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5QSW | P13Q_IFLOW | Allow NULL? |
| 22 | OFLOW | Superannuation Outflow Wageytpe | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5QSW | P13Q_OFLOW | Allow NULL? |
| 23 | ABNUM | Australian Business Number | nvarchar | 11 | 0 | NUMC | (N'00000000000') | Yes | | P13_ABNUM | Allow NULL? |
| 24 | USINO | Unique Superannuation Identification Number | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | P13_USINO | Allow NULL? |
| 25 | ENDURL | End Point URL | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | P13_EPURL | Allow NULL? |
| 26 | ORGNAME | Sender Organization Name | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | P13_ORGNM | Allow NULL? |
| 27 | BRANCHNUMBER | Bank State Branch Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | P13_SBRNO | Allow NULL? |
| 28 | ACCOUNTNUMBER | Financial Institution Account Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P13_FACNO | Allow NULL? |
| 29 | ACCOUNTNAME | Financial Institution Account Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_FACNM | Allow NULL? |
| 30 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P13_VENDOR | Allow NULL? |
| 31 | CUSTOMERREFNO | Customer Reference Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P13_CSRFN | Allow NULL? |
| 32 | BPAYBILLERCODE | BPay Biller Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P13_BPBCD | Allow NULL? |
| 33 | BRANCHNAME | Financial Institution Branch Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_BRNCH | Allow NULL? |
| 34 | BANKNAME | Financial Institution Bank Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_BANKNM | Allow NULL? |
| 35 | FSTRTNO | Fund Street and House Number | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | P13_FSTRTNO | Allow NULL? |
| 36 | FSTRTNAME | 2nd Address Line | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13Q_FSTRTNAME | Allow NULL? |
| 37 | FLOCALITY | City of the Fund | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13Q_FLOCALITY | Allow NULL? |
| 38 | FPOSTCODE | Postal Code of the Fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P13Q_FPOSTCODE | Allow NULL? |
| 39 | FSTATE | Region (State, Province, County) of the Fund | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | P13Q_REGIO | Allow NULL? |
| 40 | FCOUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 41 | FTELNUM | Telephone Contact Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P13_TELNO | Allow NULL? |
