| 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 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | NFAL | FALNR | Allow NULL? |
| 3 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 4 | LFDNR | IS-H: Sequence Number of Insurance Relationship | nvarchar | 3 | 0 | NUMC | (N'000') | No | | LFDVV | Allow NULL? |
| 5 | LFDNM | IS-H: Sequence Number of Guarantor | nvarchar | 3 | 0 | NUMC | (N'000') | No | | ISH_LFDNM | Allow NULL? |
| 6 | NOMID | IS-H: Identification of a guarantor | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ISH_NOMID | Allow NULL? |
| 7 | IDTYP | Type of Identification Document | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN17D | ISH_IDTYP | Allow NULL? |
| 8 | RANKN | IS-H: Rank of Guarantor | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_RANKN | Allow NULL? |
| 9 | RELSH | IS-H: Relationship to patient | char | 1 | 0 | CHAR | (N' ') | Yes | TN17B | ISH_RELSH | Allow NULL? |
| 10 | NNAME | Last Name of Guarantor | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | ISH_LNAME | Allow NULL? |
| 11 | VNAME | First Name of Guarantor | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | ISH_PNAME | Allow NULL? |
| 12 | TITEL | IS-H: Title | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | T535N | RI_TITEL | Allow NULL? |
| 13 | GBDAT | IS-H: Birthdate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_GBDAT | Allow NULL? |
| 14 | ADRNR | IS-H: Address Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NADR | ISH_ADRNR | Allow NULL? |
| 15 | ADROB | IS-H: Address Object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_ADROBJ | Allow NULL? |
| 16 | ACCNO | IS-H: Account Number | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | ISH_ACCNO | Allow NULL? |
| 17 | BALDT | IS-H: Data of the last balance inquiry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_BALDT | Allow NULL? |
| 18 | BALAN | IS-H: Guarantor's Account Balance | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_BALAN | |
| 19 | MAXCP | IS-H: Maximum Percentage Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | ISH_MAXCP | |
| 20 | MAXCA | IS-H: Maximum payment amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_MAXCA | |
| 21 | APPAM | IS-H: Approved amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_APPAM | |
| 22 | DEACT | IS-H SG: Indicator that Guarantor is Deactivated | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_DEACT | Allow NULL? |
| 23 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNC301SA | ISH_APSTATE | Allow NULL? |
