| 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 | SCPOSID_INT | Internal ID of Benefits Catalog Item | nvarchar | 32 | 0 | CHAR | (N' ') | No | | ICL_SERVCAT_POSID_INT | Allow NULL? |
| 3 | ACTIVE | Status | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_ACTIVE2 | Allow NULL? |
| 4 | CHANGEDBY | Version Created By (= Object Changed By) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | ICL_CHANGEBY | Allow NULL? |
| 5 | CHANGETIME | Version Created: Date + Time | decimal | 15 | 0 | DEC | ((0)) | Yes | | ICL_CHANGEUTC | |
| 6 | INACTIVETIME | Version Deactivated: Date + Time | decimal | 15 | 0 | DEC | ((0)) | Yes | | ICL_INACTIUTC | |
| 7 | EFFFROMTIME | Version Valid From: Date + Time | decimal | 15 | 0 | DEC | ((0)) | Yes | | ICL_EFFROMUTC | |
| 8 | EFFTOTIME | Version Valid To: Date + Time | decimal | 15 | 0 | DEC | ((0)) | Yes | | ICL_EFFETOUTC | |
| 9 | TERMTIME | Valid-To Date Set: Date + Time | decimal | 15 | 0 | DEC | ((0)) | Yes | | ICL_TERMINUTC | |
| 10 | DELETED | Flag: Deletion Entry? | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_XDELETE | Allow NULL? |
| 11 | OSYSID | Original System of Version | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ICL_OSYSID | Allow NULL? |
| 12 | OMANDT | Client in Original System | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | ICL_OMANDT | Allow NULL? |
| 13 | SCPOSID_PREV | Internal ID of Benefits Catalog Item | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICL_SERVCAT_POSID_INT | Allow NULL? |
| 14 | SERVCATID | ID of a Benefits, Services and Fees Catalog | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TICL401 | ICL_SERVCATID | Allow NULL? |
| 15 | SC_VARIANT | Variant of a Benefits/Services/Fee Catalog | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TICL402 | ICL_SERVCAT_VARIANT | Allow NULL? |
| 16 | SCPOSID_EXT | ID of a Benefits Catalog Item | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ICL_SERVCAT_POSID | Allow NULL? |
| 17 | SCPOSID_AMNTFROM | Lower Interval Limit of a Benefits Catalog Item | decimal | 15 | 2 | CURR | ((0)) | Yes | | ICL_SERVCAT_POSID_AMOUNT_FROM | |
| 18 | SCPOSID_AMNTTO | Upper Interval Limit of a Benefits Catalog Item | decimal | 15 | 2 | CURR | ((0)) | Yes | | ICL_SERVCAT_POSID_AMOUNT_TO | |
| 19 | SCPOS_CURR | Currency of Benefits/Services/Fees Catalog | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | ICL_SERVCAT_POS_CURR | Allow NULL? |
| 20 | SCPOS_PARENT | Internal ID of Benefits Catalog Item | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICL_SERVCAT_POSID_INT | Allow NULL? |
| 21 | SCPOS_TYPE | Type of Benefits Catalog Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TICL404 | ICL_SERVCAT_POS_TYPE | Allow NULL? |
| 22 | SCPOS_XSEL | Entry Lock for Benefits Catalog Item | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_SERVCAT_POS_SELECTABLE | Allow NULL? |
| 23 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TICL055 | ICL_BENTYPE | Allow NULL? |
| 24 | BENTYPE_EXP | BRF: Expression | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BRF_EXPRESSION | Allow NULL? |
| 25 | SCPOS_QUANTITY | Evaluation Quantity of Benefits Catalog Item | decimal | 10 | 3 | QUAN | ((0)) | Yes | | ICL_SERVCAT_POS_QUANTITY | |
| 26 | SCPOS_QUANTITYTO | Evaluation Quantity of Catalog Item (Upper Limit) | decimal | 10 | 3 | QUAN | ((0)) | Yes | | ICL_SERVCAT_POS_QUANTITY_TO | |
| 27 | SCPOS_QUANUNIT | Unit of Benefits Catalog Item | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ICL_SERVCAT_POS_QUANUNIT | Allow NULL? |
| 28 | SCPOS_VALPERUNIT | Value per Unit of Benefits Catalog Item | decimal | 20 | 12 | DEC | ((0)) | Yes | | ICL_SERVCAT_POS_VALPERUNIT | |
| 29 | SCPOS_XREIMBURSE | Reimbursability of a Benefits Catalog Item | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_SERVCAT_POS_REIMBURSABLE | Allow NULL? |
| 30 | SCPOS_XAPPROVAL | Obsolete: Approval Requirement of a Benefits Catalog Item | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_SERVCAT_POS_APPROVAL | Allow NULL? |
| 31 | SCPOS_CALC_EXP | BRFplus Expression for Additional Calculations | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | ICL_SERVCAT_CALCULATION_EXP_D | Allow NULL? |
| 32 | SCPOS_TXT_EXP | BRFplus Expression for Determination of Text Module | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | ICL_SERVCAT_TEXT_SAMPLE_EXP_D | Allow NULL? |
| 33 | SCPOS_TAXCODEINV | Type of Sales Tax Calculation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ICL_TAXCODE_INV | Allow NULL? |
| 34 | RV | Relative Value | decimal | 10 | 0 | QUAN | ((0)) | Yes | | ICL_SERVCAT_RV_D_PE | |
| 35 | RVU | Unit of Measure of Relative Value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ICL_SERVCAT_RVU_D_PE | Allow NULL? |
| 36 | AVLENGTH | Average Length of Stay in Days | decimal | 5 | 2 | DEC | ((0)) | Yes | | ICL_SERVCAT_AVLENG_D_PE | |
| 37 | DEDUCTION | First Day of Markdown | decimal | 5 | 2 | DEC | ((0)) | Yes | | ICL_SERVCAT_DEDUCTION_D_PE | |
| 38 | SURCHARGE | First Day of Markup | decimal | 5 | 2 | DEC | ((0)) | Yes | | ICL_SERVCAT_SURCHARGE_D_PE | |
| 39 | LOCALIZATION | Indicator 'Localization Possible' | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_SERVCATAL_LOCAL_D_PE | Allow NULL? |
| 40 | CATAID | Catalog for Major Diagnostic Categories (MDC) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TICL350 | ICL_CATAID_MDC_D_PE | Allow NULL? |
| 41 | DIAGID | Code of an MDC Item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TICL351 | ICL_MDCPOSID_D_PE | Allow NULL? |
| 42 | ARCHIVE_STATUS | Archiving Status | char | 1 | 0 | CHAR | (N' ') | Yes | | TYP_ARCHIVE_STATUS | Allow NULL? |
| 43 | ARCHIVE_FLUD | Resubmission Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TYP_ARCHIVE_FLUD | Allow NULL? |
| 44 | REJECTION | Rejection Reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TYP_REJECTION | Allow NULL? |
