| 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 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | CHAR | (N' ') | No | TNC301G0 | N_EDIPROC | Allow NULL? |
| 4 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | NFAL | FALNR | Allow NULL? |
| 5 | LFDVV | IS-H: Sequence Number of Insurance Relationship | nvarchar | 3 | 0 | NUMC | (N'000') | No | | LFDVV | Allow NULL? |
| 6 | LFDNM | IS-H: Sequence Number of Guarantor | nvarchar | 3 | 0 | NUMC | (N'000') | No | | ISH_LFDNM | Allow NULL? |
| 7 | LF301 | IS-H: Message Number | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | * | ISH_LF301 | Allow NULL? |
| 8 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNC301SA | ISH_APSTATE | Allow NULL? |
| 9 | AMOUNT1 | IS-H: Amount Paid | decimal | 15 | 2 | CURR | ((0)) | Yes | | N_PAYAMNT | |
| 10 | AMOUNT2 | IS-H: Amount Paid | decimal | 15 | 2 | CURR | ((0)) | Yes | | N_PAYAMNT | |
| 11 | AMOUNT3 | IS-H: Amount Paid | decimal | 15 | 2 | CURR | ((0)) | Yes | | N_PAYAMNT | |
| 12 | AMOUNT4 | IS-H: Amount Paid | decimal | 15 | 2 | CURR | ((0)) | Yes | | N_PAYAMNT | |
| 13 | AMOUNT5 | IS-H: Amount Paid | decimal | 15 | 2 | CURR | ((0)) | Yes | | N_PAYAMNT | |
| 14 | WAERS | IS-H: Currency for EDI Data Transfer Amounts | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | ISH_EDICURR | Allow NULL? |
| 15 | APDATE | IS-H: Date of Approval/Rejection | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_APDATE | Allow NULL? |
| 16 | EXCODE | Additional/External Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_EXCODE | Allow NULL? |
| 17 | ECODE1 | IS-H: Error Code of EDI Messages (External) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N_301ECODE | Allow NULL? |
| 18 | ECODE2 | IS-H: Error Code of EDI Messages (External) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N_301ECODE | Allow NULL? |
| 19 | ECODE3 | IS-H: Error Code of EDI Messages (External) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N_301ECODE | Allow NULL? |
| 20 | ECODE4 | IS-H: Error Code of EDI Messages (External) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N_301ECODE | Allow NULL? |
| 21 | ECODE5 | IS-H: Error Code of EDI Messages (External) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N_301ECODE | Allow NULL? |
| 22 | ECONT | IS-H: Indicator that More Information Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_MOREKZ | 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 when Data Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_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 Data Record was Last Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_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 | DEDUCDT | IS-H: Transfer date, deduction date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N_DEDUCDT | Allow NULL? |
| 30 | PSTAT | IS-H: Processing status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | N_PSTATUS | Allow NULL? |
| 31 | AINFO | IS-H: Additional Information | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | N_ADDINFO | Allow NULL? |
