| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | ALLERGY_SEQNO | Entry Sequence of an Allergy | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | REACT_SEQNO | Entry Sequence of an Allergic Reaction | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | REA | Allergic Reaction | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | BCHID_REA | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | | | Allow NULL? |
| 7 | BCPID_REA | Basic Cat.: Item Key | nvarchar | 33 | 0 | | | | Allow NULL? |
| 8 | SOA | Allergic Reaction Severity | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | BCHID_SOA | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | | | Allow NULL? |
| 10 | BCPID_SOA | Basic Cat.: Item Key | nvarchar | 33 | 0 | | | | Allow NULL? |
| 11 | EREASON | Change Reason, Code | char | 1 | 0 | | | | Allow NULL? |
| 12 | CREATE_DATE | IS-H: Date when Record Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | CREATE_TIME | IS-H: Time when Data Record Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | CREATE_USER | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | UPDATE_DATE | IS-H: Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | UPDATE_TIME | IS-H: Time Data Record was Last Changed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | UPDATE_USER | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | CANCEL_DATE | IS-H: Cancellation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | CANCEL_TIME | IS-H: Time Data Record Canceled | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | CANCEL_USER | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | CANCEL_REASON | Cancellation Reason | char | 1 | 0 | | | | Allow NULL? |
| 22 | CANCEL_FLAG | IS-H: Cancellation Indicator | char | 1 | 0 | | | | Allow NULL? |
| 23 | TIMESTAMP | Timestamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |