| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | GUID | Identification of Question List Header | varbinary | 16 | 0 | RAW | | No | | PLMT_QUEST_H_GUID | |
| 3 | ORIGINAL_LANGU | Creation Language of Question List | char | 1 | 0 | LANG | (N' ') | Yes | * | PLMT_ORIGINAL_LANGU_QUEST | Allow NULL? |
| 4 | VALIDFROM | Valid From | decimal | 15 | 0 | DEC | ((0)) | Yes | | PLMT_VALIDFROM | |
| 5 | VALIDTO | Valid To | decimal | 15 | 0 | DEC | ((0)) | Yes | | PLMT_VALIDTO | |
| 6 | RELEASED_ON | Release Time | decimal | 15 | 0 | DEC | ((0)) | Yes | | PLMT_RELEASED_ON | |
| 7 | RELEASED_BY | Name of Person, Who Has Released Component | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PLMT_RELEASED_BY | Allow NULL? |
| 8 | PROC_STATUS | Processing Status of the Audit Component | char | 1 | 0 | CHAR | (N' ') | Yes | | PLMT_PROC_STATUS | Allow NULL? |
| 9 | LISTITYP | List Item Type | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | PLMT_TV_LISTITYP | Allow NULL? |
| 10 | AUTH_GROUP | Authorization Group | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | PLMT_AUTH_GROUP | Allow NULL? |
| 11 | HIERARCHY_PROFIL | Description of Hierarchy Profile | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | PLMT_HIERARCHY_PROFIL | Allow NULL? |
| 12 | QUEST_CHANGEABLE | Changeability of Question List in Investigation (Audit,...) | char | 1 | 0 | CHAR | (N' ') | Yes | | PLMT_QUEST_CHANGEABLE | Allow NULL? |
| 13 | LISTTYP | Type of List in Investigations (Audit, FMEA,...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | PLMT_TV_LISTTYP | Allow NULL? |
| 14 | GROUPING | Grouping | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PLMT_GROUPING | Allow NULL? |
| 15 | SEARCH_FIELD | Search Field | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PLMT_SEARCH_FIELD | Allow NULL? |
| 16 | EXT_POSITION | External Item Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | PLMT_EXT_POSITION | Allow NULL? |
| 17 | ASSESSM_PROFIL | Valuation Profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PLMT_ASSESSMENT_PROFIL | Allow NULL? |
| 18 | ASSESSMENT_SUG | Valuation Proposal | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PLMT_ASSESSMENT_SUGGESTION | Allow NULL? |
| 19 | SUGGESTION_SCORE | Valuation Proposal | decimal | 5 | 1 | DEC | ((0)) | Yes | | PLMT_SUGGESTION_SCORE | |
| 20 | AUDIT_CALCULATE | Calculation of the Result and Degree of Fulfillment | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PLMT_AUDIT_CALCULATE_BADI | Allow NULL? |
| 21 | MIN_RESULT | Minimum Result That Must Be Reached | decimal | 10 | 1 | DEC | ((0)) | Yes | | PLMT_MIN_RESULT | |
| 22 | WEIGHTING | Weighting | smallint | 5 | 0 | INT2 | ((0)) | Yes | | PLMT_WEIGHTING | |
| 23 | PRIORITY | Priority | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PLMT_PRIORITY | Allow NULL? |
| 24 | QUEST_REF_GUID | Link to Question List/Element of Question List | varbinary | 16 | 0 | RAW | | Yes | | PLMT_QUEST_REF_GUID | |
| 25 | APPLICATION | Application in Project Planning | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | CGPL_APPLICATION_TYPE | Allow NULL? |
