| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | LFDNR | Sequence Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | EINRI | Institution | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | CC_STATUS | IS-H FR: Insurance Verification Request Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | CLAIM | IS-H FR: Control Settings for Insurance Verification Request | char | 1 | 0 | | | | Allow NULL? |
| 8 | POSTDATE | IS-H FR: Date of Request (Postmark) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | LTEXT | Object Long Text Available | char | 1 | 0 | | | | Allow NULL? |
| 10 | PRINTDATE | IS-H FR: Print Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | ERNAM | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | UPNAM | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | | | | Allow NULL? |
| 16 | STDAT | Date of Cancellation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | STNAM | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | CC_AUTO | IS-H FR: Automatic Confirmation of Coverage | char | 1 | 0 | | | | Allow NULL? |