| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Mandant | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | EINRI | IS-H: Instelling | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | FALNR | IS-H: Nummer ziektegeval | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | FALNR | Allow NULL? |
| 4 | LFDNR | IS-H: Volgnummer van een beweging | nvarchar | 5 | 0 | NUMC | (N'00000') | No | * | LFDBEW | Allow NULL? |
| 5 | LEVNR | IS-H NL: LAZR-aanleveringsnummer LAZR-bestand | nvarchar | 7 | 0 | NUMC | (N'0000000') | No | | ISH_LEVNR | Allow NULL? |
| 6 | RECTP | IS-H NL: LAZR-record-type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_RECTP | Allow NULL? |
| 7 | INSNR | IS-H NL:LAZR-instellingsnummer | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | ISH_INSNR2 | Allow NULL? |
| 8 | LOCNR | IS-H NL: Polikliniek- of locatienummer | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_LOCNR | Allow NULL? |
| 9 | SIGNR_S | IS-H NL: LAZR-artsnummer SIG (specialist, (verwijzend)arts) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | ISH_SIGNR | Allow NULL? |
| 10 | CONTP | IS-H NL: LAZR code contacttype | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_CONTYP | Allow NULL? |
| 11 | BWIDT | IS-H: Datum van de beweging | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BWIDT | Allow NULL? |
| 12 | VLGNR | IS-H NL: LAZR-volgnummer contact in spreekuur | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_VLGNR | Allow NULL? |
| 13 | MEDBH | IS-H NL: LAZR-medische behandeling | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_MEDBH | Allow NULL? |
| 14 | AFSPR | IS-H NL: LAZR-afspraakcode | char | 1 | 0 | NUMC | (N'0') | Yes | | ISH_AFSPR | Allow NULL? |
| 15 | SIGNR_V | IS-H NL: LAZR-artsnummer SIG (specialist, (verwijzend)arts) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | ISH_SIGNR | Allow NULL? |
| 16 | PATNR | IS-H NL: LAZR-patiëntnummer | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ISH_PATNR | Allow NULL? |
| 17 | GBDAT | Geboortedatum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GBDAT | Allow NULL? |
| 18 | GSCHL | IS-H NL: LAZR-geslachtscode | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_GSCHL | Allow NULL? |
| 19 | PSTLZ_1 | IS-H NL: LAZR-cijfers in postcode | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_PSTLZ1 | Allow NULL? |
| 20 | PSTLZ_2 | IS-H NL: LAZR-letters in postcode | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_PSTLZ2 | Allow NULL? |
| 21 | LNDCD | IS-H NL: LMR-landcode | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_LMRLND | Allow NULL? |
| 22 | SIGNR_A | IS-H NL: LAZR-artsnummer SIG (specialist, (verwijzend)arts) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | ISH_SIGNR | Allow NULL? |
| 23 | VERWZ | IS-H NL: LMR-verzekeringswijze | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_VERWZ | Allow NULL? |
| 24 | RUBR1 | IS-H NL: LAZR-rubriceringsgroep | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_RUBGR | Allow NULL? |
| 25 | RUBR2 | IS-H NL: LAZR-rubriceringsgroep | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_RUBGR | Allow NULL? |
| 26 | PROCS | IS-H NL: LAZR-verwerkingswijze van record | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PROCS | Allow NULL? |
| 27 | PROCS_INT | IS-H NL: LAZR-verwerkingswijze van record | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PROCS | Allow NULL? |
