| 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 | * | MANDT | Allow NULL? |
| 2 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PERNR_D | Allow NULL? |
| 3 | EDATE | Date of event to be reported to employees/employers register | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | P20_EDATE | Allow NULL? |
| 4 | MTYPE | Type of message to employees/employers register | nvarchar | 2 | 0 | CHAR | (N' ') | No | | P20_MTYPE | Allow NULL? |
| 5 | RDATE | Date message for the AA-register was created in the system | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | P20_RDATE | Allow NULL? |
| 6 | RTIME | Time message for the AA-register was created in the system | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | P20_RTIME | Allow NULL? |
| 7 | RSTAT | Status for reporting to AA-Register | char | 1 | 0 | CHAR | (N' ') | Yes | | P20_RSTAT | Allow NULL? |
| 8 | CDATE | Date the message to the AA-register was invalidated/correctd | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P20_CDATE | Allow NULL? |
| 9 | FDNUM | Norwegian personal id (foedselsnummer) | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | P20_FDNUM | Allow NULL? |
| 10 | WOSID | Identifier for planned working hour per week, 1, 2, 3 | char | 1 | 0 | CHAR | (N' ') | Yes | | P20_WOSID | Allow NULL? |
| 11 | ORGNR | Organization number | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | | P20_EMPID | Allow NULL? |
| 12 | NORGNR | Organization number | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | | P20_EMPID | Allow NULL? |
| 13 | TRYNR | NAV No. | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P20_TRYNR | Allow NULL? |
| 14 | ARBGID | Layout rule for address type | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | VARGA | Allow NULL? |
