| 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 | DBCNR | Volgnummer DBC-code | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | ISH_NL_DBCNR | Allow NULL? |
| 4 | DATUM | ISH_NL: Datum | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ISH_NL_DAT | Allow NULL? |
| 5 | TIJD | Systeemtijd | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | SYUZEIT | Allow NULL? |
| 6 | ZORGT | IS-H NL: Zorgtype | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_ZORGT | Allow NULL? |
| 7 | ZORGVR | ISH_NL: Zorgvraag | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_ZORGVR | Allow NULL? |
| 8 | DIAGN | Diagnose | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_DIAGN | Allow NULL? |
| 9 | DIAGN2 | Diagnose | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_DIAGN | Allow NULL? |
| 10 | THERAP | ISH_NL: Behandeling | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_THERAP | Allow NULL? |
| 11 | BEGDT | ISH_NL: Datum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_NL_DAT | Allow NULL? |
| 12 | ENDDT | ISH_NL: Datum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_NL_DAT | Allow NULL? |
| 13 | AFCODE | ISH_NL: Afsluitcode | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_NL_AFCODE | Allow NULL? |
| 14 | UPUSR | IS-H: Naam van laatste bewerker | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 15 | CHRON | ISH_NL: Chronisch | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_CHRON | Allow NULL? |
| 16 | STORN | IS-H: Stornoteken | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 17 | TRJNR | ISH_NL: Zorgtrajectnummer | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ISH_NL_TRJNR | Allow NULL? |
| 18 | DZGV | IS-H: Nummer ziektegeval | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FALNR | Allow NULL? |
| 19 | BARNR | IS-H NL: Personeelsnummer van arts verantwoordelijk voor DBC | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_DBC_ARZT | Allow NULL? |
| 20 | STATUS | IS-H NL: DBC interne status | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_STATUS | Allow NULL? |
| 21 | DDBCNR | Volgnummer DBC-code | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ISH_NL_DBCNR | Allow NULL? |
| 22 | DDBC | ISH_NL: DBC | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_NL_DBC | Allow NULL? |
| 23 | ESTATUS | ISH_NL: Externe DBC-status | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_ESTATUS | Allow NULL? |
| 24 | DISPERIODE | IS-H NL: Periode DIS-aanlevering | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | ISH_NL_DIS_PERIODE | Allow NULL? |
| 25 | DISSTATUS | IS-H NL: Status DIS-aanlevering | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_DIS_STATUS | Allow NULL? |
| 26 | DISPERIODE_ALT | IS-H NL: Periode DIS-aanlevering | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | ISH_NL_DIS_PERIODE | Allow NULL? |
| 27 | DISSTATUS_ALT | IS-H NL: Status DIS-aanlevering | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_DIS_STATUS | Allow NULL? |
| 28 | DISLOCNR | IS-H NL: Locatiecode voor DIS-aanlevering | char | 1 | 0 | NUMC | (N'0') | Yes | | ISH_NL_DIS_LOCNR | Allow NULL? |
| 29 | THERAP_EXT_ALT | ISH_NL: Alternatieve behandelas | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_THERAP_ALT | Allow NULL? |
| 30 | EVENT | IS-H NL: Gebeurtenis waardoor DBC's zijn gegenereerd | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_NL_DBC_EVENT | Allow NULL? |
| 31 | DECL_CODE_ALT | Declaratiecode | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_DECLCODE | Allow NULL? |
| 32 | OBJCT | IS-H NL: Object waardoor DBC's zijn gegenereerd | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_NL_DBC_OBJECT | Allow NULL? |
| 33 | EVTUP | IS-H NL: Gebeurtenis waardoor DBC's zijn gewijzigd | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_NL_DBC_EVT_UP | Allow NULL? |
| 34 | OBJUP | IS-H NL: Object waardoor DBC's zijn gewijzigd | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_NL_DBC_OBJ_UP | Allow NULL? |
| 35 | TCODE | Transactiecode | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | TCODE | Allow NULL? |
| 36 | ABADBC | Afr.soort DBC | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_ABADBC | Allow NULL? |
| 37 | EXP_CPCOD | Zorgproductcode | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_CP_COD | Allow NULL? |
| 38 | EXP_CPCAT | Categorie zorgproduct | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_NL_CP_CAT | Allow NULL? |
| 39 | CLAIM | Aanspraak ZVW indicatie | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_CLAIM_IND | Allow NULL? |
| 40 | BILLING_BLOCK | DBC - facturatieblokkering | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_DBC_BILLING_BLOCK | Allow NULL? |
