| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | STAND | IS-HCM: Communications Standard | nvarchar | 8 | 0 | CHAR | (N' ') | No | TNCST | CMSTD | Allow NULL? |
| 2 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | CHAR | (N' ') | No | TNCST | STDVER | Allow NULL? |
| 3 | FDNAM | IS-HCM: Segment Field Name | nvarchar | 10 | 0 | CHAR | (N' ') | No | | SFDNAM | Allow NULL? |
| 4 | FILLERKZ | IS-HCM: Filler Indicator (Field w/o Corresponding DB Struc.) | char | 1 | 0 | CHAR | (N' ') | Yes | | FILLERKZ | Allow NULL? |
| 5 | FDLEN | IS-H: Field Length of Original Field | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | FDLEN | Allow NULL? |
| 6 | FDDBT | IS-HCM: Name of Related DB Table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | FDDBT | Allow NULL? |
| 7 | FDDBF | IS-HCM: Name of Related Database Table Field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FDDBF | Allow NULL? |
| 8 | FDBF1 | IS-HCM: Name of Condition Field 1 | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | BEDFELD1 | Allow NULL? |
| 9 | FDBO1 | Relational Operator for Condition Field 1 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BEDOPER1 | Allow NULL? |
| 10 | FDBW1 | IS-HCM: Value to Be Checked for Condition Field 1 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BEDWERT1 | Allow NULL? |
| 11 | FDVKN | IS-HCM: Condition Link for 2 Conditions (AND/OR) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | BEDVERKN | Allow NULL? |
| 12 | FDBF2 | IS-HCM: Name of Condition Field 2 | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | BEDFELD2 | Allow NULL? |
| 13 | FDBO2 | Relational Operator for Condition Field 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BEDOPER2 | Allow NULL? |
| 14 | FDBW2 | IS-HCM: Value to Be Checked for Condition Field 2 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BEDWERT2 | Allow NULL? |
| 15 | HL7ITEMNO | IS-HCM: HL7 Indentification Number of Data Field | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | HL7ITEMNO | Allow NULL? |
| 16 | HL7REPSIGN | IS-HCM: Field May Repeat | char | 1 | 0 | CHAR | (N' ') | Yes | | HL7REPSIGN | Allow NULL? |
| 17 | SAPSERVICE | IS-HCM: Indicator that Field Is Not Supported by SAP System | char | 1 | 0 | CHAR | (N' ') | Yes | | NSAPSERVIC | Allow NULL? |
| 18 | CONTENTS | IS-HCM: Specification on Content of Message Field | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | NREFERENCE | Allow NULL? |
| 19 | HL7TABLE | IS-HCM: HL7 Identification Number of Value Table | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | HL7TABLE | Allow NULL? |
