| 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 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | CHAR | (N' ') | No | | N1ME_DRUGID | Allow NULL? |
| 3 | BEGDT | IS-H: Valid-From Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_BEGDT | Allow NULL? |
| 4 | ENDDT | IS-H: Valid-To Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ENDDT | Allow NULL? |
| 5 | CATID | Medication: Internal Key of Drug Catalog | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | N1DC | N1ME_CATID | Allow NULL? |
| 6 | RCDEACT | Medication: Reason Code - OBSOLETE | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TN1RCODE | N1ME_RCODEID_O | Allow NULL? |
| 7 | DEACT_RC | Medication: Deactivation Reason Code | nvarchar | 5 | 0 | CHAR | (N' ') | No | TN1RCIND | N1ME_RCDEACTV | Allow NULL? |
| 8 | MANUAL | Medication: Manually Added Data Record Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MANUAL | Allow NULL? |
| 9 | NOTE1 | Medication: Indicator Note for Pharmacist Exists - OBSOLETE | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_NOTE1_O | Allow NULL? |
| 10 | NOTE2 | Medication: Indicator Note for Nurse Exists - OBSOLETE | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_NOTE2_O | Allow NULL? |
| 11 | NOTE3 | Medication: Indicator Note for Physician Exists - OBSOLETE | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_NOTE3_O | Allow NULL? |
| 12 | PREP | Medication:Manufacture Directions Exist Indicator - OBSOLETE | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_PREP_O | Allow NULL? |
| 13 | AUTIDEM | Drug Substitution Allowed Indicator - OBSOLETE | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_AUTIDEM | Allow NULL? |
| 14 | BDCUPD | Medication: Indicator for Synchronize with External Catalog | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_BDCUPD | Allow NULL? |
| 15 | CATIDBDC | Medication: ID of External Drug Catalog - OBSOLETE | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | N1DC | N1ME_CATIDBDC_O | Allow NULL? |
| 16 | DRUGIDBDC | Medication: Mnemonic in Basic Catalog - OBSOLETE | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | N1BDCC | N1ME_DRUGIDBDC_O | Allow NULL? |
| 17 | TRMDAYS | Medication: Preset Treatment Period (Days) - OBSOLETE | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | N1ME_TRMDAYS | |
| 18 | TRMSTOP | Medication: Indicator Stop After Treatment Period - OBSOLETE | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_TRMSTOP | Allow NULL? |
| 19 | PREVENT | Medication: Predefined Events in Days | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | N1ME_PREVENT | |
| 20 | MEDCLID | Medication: Drug Category ID - OBSOLETE | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | N1ME_MEDCLID | Allow NULL? |
| 21 | MEDGRPID | Medication: Drug Category Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TN1MEDGROUP | N1ME_MEDGRPID | Allow NULL? |
| 22 | ADRTIMU | Medication: Unit of Administration Duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | N1ME_ADRTIMU | Allow NULL? |
| 23 | ADITIM | Medication: Administration Duration | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_ADITIM | |
| 24 | RECQUAN | Medication: Recipe Quantity - OBSOLETE | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_RECQUAN_O | |
| 25 | RECQUANU | Medication: Recipe Quantity Unit - OBSOLETE | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | N1ME_RECQUANU_O | Allow NULL? |
| 26 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 27 | MMRESERV | Medication: Create MM Reservation for Drug | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MMRESERV | Allow NULL? |
| 28 | INDISDOS | Medication: Indiscrete Dose Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_DISCDOS | Allow NULL? |
| 29 | DISPPKG | Medication: Deliver in Package Size Indicator (Pharmacy) | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_DISPPKG | Allow NULL? |
| 30 | ADMPKG | Medicat.: Post Package Unit at Administration Ind.(Patient) | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_ADMPKG | Allow NULL? |
| 31 | VERSDATE | Medication: Date and Time of Version | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | N1ME_VERSDATE | Allow NULL? |
| 32 | EXTDCODECAT | Medication: ID of Identification System - OBSOLETE | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | N1ME_EXTDCODECAT | Allow NULL? |
| 33 | EXTDCODEID | Medication: External Drug ID | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | N1ME_EXTDCODEID | Allow NULL? |
| 34 | BRANDNAME | Medication: Brand Name | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | N1ME_BRANDNAME | Allow NULL? |
| 35 | GENNAME | Medication: Generic Name | nvarchar | 200 | 0 | CHAR | (N' ') | Yes | | N1ME_GENNAME | Allow NULL? |
| 36 | NARCOTIC | Medication: Narcotic Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_NARCOTIC | Allow NULL? |
| 37 | PSYCHO | Medication: Psychotropic Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_PSYCHO | Allow NULL? |
| 38 | CONTR | Medication: Controlled Drug Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_CONTR | Allow NULL? |
| 39 | ADMIND | Medication: Administrable Independently | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_ADMIND | Allow NULL? |
| 40 | MONO | Medication: Single Agent Drug Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MONO | Allow NULL? |
| 41 | MANUF | Medication: Manufacturer | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | N1ME_MANUF | Allow NULL? |
| 42 | APDEVID | Medication: Administration Device ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TN1DEVICE | N1ME_APDEVID | Allow NULL? |
| 43 | APROUTEID | Medication: ID Administration Route | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TN1ROUTE | N1ME_ROUTEID | Allow NULL? |
| 44 | PHFORMID | Medication: ID Dosage Form | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TN1PHFORM | N1ME_PHFORMID | Allow NULL? |
| 45 | UNIT | Medication: Drug - Base Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | N1ME_UNIT | Allow NULL? |
| 46 | QUAN | Medication: Drug - Base Quantity | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_QUAN | |
| 47 | STRGTHU | Medication: Strength Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | N1ME_STRGTHU | Allow NULL? |
| 48 | STRGTH | Medciation: Drug Strength | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_STRGTH | |
| 49 | STRGTHPU | Medication: Reference Dose Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | N1ME_STRGTHPU | Allow NULL? |
| 50 | STRGTHP | Medication: Reference Dose | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_STRGTHP | |
| 51 | PSTRGTH | Medication: Percentage Strength Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_PSTRGTHP | Allow NULL? |
| 52 | PKGUNIT | Medication: Package Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | N1ME_PKGUNIT | Allow NULL? |
| 53 | PKGSIZE | Medication: Package Size | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_PKGSIZE | |
| 54 | DEFDOSM | Medication: Standard Individual Dose | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_DEFDOSM | |
| 55 | DEFEXP | Medication: Shelf Life | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_DEFEXP | |
| 56 | DEFEXPTU | Medication: Default Expiry Period Time Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | N1ME_DEFEXPTU | Allow NULL? |
| 57 | MAXDOSM | Medication: Maximum Individual Dose | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_MAXDOSM | |
| 58 | MAXDOSD | Medication: Maximum Daily Dose | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_MAXDOSD | |
| 59 | MAXDOSL | Medication: Maximum Lifetime Dose | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_MAXDOSL | |
| 60 | CUMDOS | Medication: Cumulative Dose Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_CUMDOS | Allow NULL? |
| 61 | FREEZE | Medication: Freezing Required Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_FREEZE | Allow NULL? |
| 62 | REFRIGERATE | Medication: Refrigeration Necessary Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_REFRIGERATE | Allow NULL? |
| 63 | MAXTEMP | Medication: Maximum Storage Temperature | decimal | 3 | 0 | QUAN | ((0)) | Yes | | N1ME_MAXTEMP | |
| 64 | MAXTEMP_VAL0 | Medication:Indicator Value 0 (SPACE = No Value/ X = Value 0) | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_VALUE_0 | Allow NULL? |
| 65 | MINTEMP | Medication: Minimum Storage Temperature | decimal | 3 | 0 | QUAN | ((0)) | Yes | | N1ME_MINTEMP | |
| 66 | MINTEMP_VAL0 | Medication:Indicator Value 0 (SPACE = No Value/ X = Value 0) | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_VALUE_0 | Allow NULL? |
| 67 | TEMPU | Medication: Temperature Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | N1ME_TEMPU | Allow NULL? |
| 68 | MAXDEN | Medciation: Maximum Denominator for Tablets | char | 1 | 0 | NUMC | (N'0') | Yes | | N1ME_MAXDEN | Allow NULL? |
| 69 | TIMSEN | Medication: Time-Sensitive Drug | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_TIMSEN | Allow NULL? |
| 70 | ADOUTPAT | Medication: Administration in IP/OC - OBSOLETE | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_ADOUTPAT | Allow NULL? |
| 71 | SECWITNESS | Medication: Witness Required | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_SECWITNESS | Allow NULL? |
| 72 | VFCOIND | Medication: Check Condition to Be Checked | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_CHKCO | Allow NULL? |
| 73 | OUPREP | Medication: Preparation Fill Source Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_OUPREP | Allow NULL? |
| 74 | NOCRUSH | Medication: Drug Uncrushable Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_NOCRUSH | Allow NULL? |
| 75 | OWNMED | Medication: Indicator for Patient's Own Medicine | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_OWNMED | Allow NULL? |
| 76 | INPATIENT | Medication: Indicator, Administration - OBSOLETE | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_IP_USE | Allow NULL? |
| 77 | OUTPATIENT | Medication: Indicator, Dispensing/Prescription - OBSOLETE | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_OP_USE | Allow NULL? |
| 78 | PRICE | Medication: Price of the Medication - OBSOLETE | decimal | 11 | 2 | CURR | ((0)) | Yes | | N2ME_DRUGPRICE_OBS | |
| 79 | PRICEU | Medication: Price Unit | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | | N2ME_DRUGPRICEU | Allow NULL? |
| 80 | FORMLVL | Medication: Internal Key of Drug Level | char | 1 | 0 | NUMC | (N'0') | Yes | TN1FORMLEVEL | N1ME_MD_FORMLVL | Allow NULL? |
| 81 | IVTYPE | Medication: Order - Infusion Type | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_IVTYPE | Allow NULL? |
| 82 | CHIVTYPE | Medication: Changeable Infusion Type | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_CHIVTYPE | Allow NULL? |
| 83 | STRGTHDOS | Medication: Order - Dosage Type | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_STRGTHDOS | Allow NULL? |
| 84 | ALTQUAN | Medication: Alternative Reference Dose | decimal | 12 | 3 | QUAN | ((0)) | Yes | | N1ME_MD_ALTQUAN | |
| 85 | ALTQUANU | Medication: Alternative Reference Dose Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | | N1ME_MD_ALTQUANU | Allow NULL? |
| 86 | EXTBEGDT | Medication: Start of Valid. Period in Ext. Catlog | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N1ME_MD_EXTBEGDT | Allow NULL? |
| 87 | EXTENDDT | Medication: End of Validity Period in Ext. Catalog | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N1ME_MD_EXTENDDT | Allow NULL? |
| 88 | PKGMULT | Medication: Number of Individual Packages | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | N1ME_MD_PKGMULT | Allow NULL? |
| 89 | INTERPOL | Medication: Manual Check Necessary | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_INTERPOL | Allow NULL? |
| 90 | UNDIVUNITIND | Medication: Indicator for Undivisible Dose Supply | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_UNDIVUNITIND | Allow NULL? |
| 91 | EMAR | Medication: "Administration" Purpose | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_EMAR | Allow NULL? |
| 92 | DISP | Medication: "Dispensing" Purpose | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_DISP | Allow NULL? |
| 93 | PPRINT | Medication: "Print Prescription" Purpose | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_PPRINT | Allow NULL? |
| 94 | DEFEMAR | Medication: Default for Administration | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_DEFEMAR | Allow NULL? |
| 95 | DEFDISP | Medication: Default Dispensing | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_DEFDISP | Allow NULL? |
| 96 | DEFPPRINT | Medication: Default Purpose Prescription Printout | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_DEFPPRINT | Allow NULL? |
| 97 | IMPORTER | Medication: Importer | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_IMPORTER | Allow NULL? |
| 98 | LEVEL1 | Medication: Mnemonic | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | N1ME_DRUGID | Allow NULL? |
| 99 | LEVEL2 | Medication: Mnemonic | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | N1ME_DRUGID | Allow NULL? |
| 100 | ASSIGNIND | Medication: Indicator "Assigned" | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_ASSIGNIND | Allow NULL? |
| 101 | EXTKEY | Medication: Key in External Catalog | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_EXTKEY | Allow NULL? |
| 102 | EXTCATID | Medication: ID of External Drug Catalog | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | N1DC | N1ME_CATIDBDC | Allow NULL? |
| 103 | COUNTDAY | Medication, "Display Treatment Days" Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_COUNTDAY | Allow NULL? |
| 104 | COUNTMAX | Medication: Number of Days for Treatment Day Display | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | N1ME_MD_COUNTMAX | Allow NULL? |
| 105 | MARKET | Medication: Marketability | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_MARKET | Allow NULL? |
| 106 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 107 | ERTIM | IS-H: Time Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_ERTIM | Allow NULL? |
| 108 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 109 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 110 | UPTIM | IS-H: Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_UPTIM | Allow NULL? |
| 111 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 112 | TIME_BEFORE | Medication: Time Difference Before | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | N1ME_TIME_BEFORE | Allow NULL? |
| 113 | TIME_AFTER | Medication: Time Difference After | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | N1ME_TIME_AFTER | Allow NULL? |
