| 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 | LNCRD | Sequence Number of Health Insurance Card | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | ISH_LNCARD | Allow NULL? |
| 3 | LNCRD_PAT | Sequence Number of Details for Health Insurance Card | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | ISH_LNCARD_DET | Allow NULL? |
| 4 | NAME_LAST | Last name of business partner (person) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BU_NAMEP_L | Allow NULL? |
| 5 | NAME_FIRST | First name of business partner (person) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BU_NAMEP_F | Allow NULL? |
| 6 | BIRTHDT | Date of Birth of Business Partner | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BU_BIRTHDT | Allow NULL? |
| 7 | GENDER | IS-H: Sex Indicator - Internal | char | 1 | 0 | CHAR | (N' ') | Yes | | GSCHL | Allow NULL? |
| 8 | EXPDT | IS-H: EHIC - Validity End | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_EHIC_EXPDT | Allow NULL? |
| 9 | INSID | | nvarchar | 10 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 10 | AD_PREFIX_TXT | Name prefix | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_PREFIXT | Allow NULL? |
| 11 | AD_TITLES_TXT | Name supplement, e.g. noble title (written form) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_TITLEST | Allow NULL? |
| 12 | AD_TITLE1_TXT | Academic Title: Written Form | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_TITLE1T | Allow NULL? |
| 13 | POST_CODE2 | PO Box Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD2 | Allow NULL? |
| 14 | PO_BOX_LOC | PO Box city | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_POBXLOC | Allow NULL? |
| 15 | PO_BOX | PO Box | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_POBX | Allow NULL? |
| 16 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | AD_POBXCTY | Allow NULL? |
| 17 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD1 | Allow NULL? |
| 18 | CITY | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY1 | Allow NULL? |
| 19 | COUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |
| 20 | STREET | Street | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | AD_STREET | Allow NULL? |
| 21 | HOUSE_NUM | House Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM1 | Allow NULL? |
| 22 | STREET_SUPPL | Street 2 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_STRSPP1 | Allow NULL? |
| 23 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 24 | ERTIM | IS-H: Time Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_ERTIM | Allow NULL? |
| 25 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 26 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 27 | UPTIM | IS-H: Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_UPTIM | Allow NULL? |
| 28 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 29 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 30 | EGK_CDM_PVSD | | nvarchar | 20 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 31 | EGK_NAMEF | | nvarchar | 45 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 32 | EGK_NAMEL | | nvarchar | 45 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 33 | EGK_GSCHL | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 34 | UNKNOWN_GBDAT | Birthdate Is Unknown | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_UNKNOWN_GBDAT | Allow NULL? |
| 35 | GBNAM | IS-H: Birthname | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | GBNAM | Allow NULL? |
| 36 | BIRTHRK | IS-H: Birth Rank | char | 1 | 0 | NUMC | (N'0') | Yes | | ISH_BIRTH_RANK | Allow NULL? |
| 37 | RVNUM | IS-H: Social Insurance Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_RVNUM | Allow NULL? |
| 38 | RVNUM_MIP | IS-H: Social Insurance Number of Main Person Insured | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_RVNUM_MAIN | Allow NULL? |
| 39 | BSNNR | | nvarchar | 10 | 0 | | (N'0000000000') | Yes | | | Allow NULL? |
| 40 | BSN_STAT | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 41 | SOURCE | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 42 | CRDNR | | nvarchar | 10 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 43 | ID_STAT | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 44 | ID_TYPE | | nvarchar | 2 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 45 | LAST_UPD | | nvarchar | 8 | 0 | | (N'00000000') | Yes | | | Allow NULL? |
| 46 | PERSON | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 47 | PO_BOX_TEXT | PO Box Text | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ISH_EHC_PO_BOX_TEXT | Allow NULL? |
| 48 | LOCATION | Location | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_EHC_LOCATION | Allow NULL? |
| 49 | POST_CODE3 | Foreign Postal Code | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ISH_EHC_POST_CODE3 | Allow NULL? |
| 50 | VERSID | | nvarchar | 20 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 51 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | EXT_PATNR | Allow NULL? |
| 52 | PASSNR | IS-H: Identification Document Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ISH_PASSNR | Allow NULL? |
| 53 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | REGIO | Allow NULL? |
| 54 | CITY2 | District | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY2 | Allow NULL? |
| 55 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AD_TLNMBR | Allow NULL? |
