| 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 | FORM_NAME | IS-H: Form Name for Service Entry | nvarchar | 15 | 0 | CHAR | (N' ') | No | | ISH_FORM_NAME | Allow NULL? |
| 3 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TN01 | EINRI | Allow NULL? |
| 4 | FORM_TYPE | IS-H: Form Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_FORMTYPE | Allow NULL? |
| 5 | ENVIRONMENT | IS-H: Application Area for Service Form | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_ENVIRONMENT | Allow NULL? |
| 6 | FORM_TEXT | Text Describing Form | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_TEXT | Allow NULL? |
| 7 | HTML_FORM1 | IS-H: HTML File for Form | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML | Allow NULL? |
| 8 | HTML_PIC1 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 9 | HTML_PIC2 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 10 | HTML_PIC3 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 11 | HTML_PIC4 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 12 | HTML_PIC5 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 13 | HTML_PIC6 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 14 | HTML_PIC7 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 15 | HTML_PIC8 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 16 | HTML_PIC9 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 17 | HTML_PIC10 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 18 | HTML_PIC11 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 19 | HTML_PIC12 | IS-H: Picture for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_PICTURE | Allow NULL? |
| 20 | HTML_SOUND | IS-H: Sound File for HTML File (Form) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_SOUND | Allow NULL? |
| 21 | FORM_BEW | IS-H: Form Is Movement-Related | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_FORM_HTML_BEWEGUNGSBEZ | Allow NULL? |