> >Structure for table: C:\PHARMACY\TABLES\DRUG.DBF >Number of data records: 191274 >Date of last update: 11/28/06 >Memo file block size: 64 > Code Page: 1252 > Field Field Name Type Width Dec Index Collate Nulls Next Step > 1 DRUG_ID Integer 4 Asc Machine No > 2 NDC Character 11 No > 3 ACTIVE Logical 1 No > 4 NAME Character 25 No > 5 FORM Character 3 No > 6 STRENGTH Character 8 No > 7 SIZE Numeric 8 3 No > 8 DEA_CLASS Character 1 No > 9 THIRD_PARTY_.. Character 1 No > 10 MANUFACTURER Character 30 No > 11 SHORT_NAME Character 23 No > 12 SHORTCUT Character 8 No > 13 DRUG_TYPE Numeric 1 No > 14 TOT_PKG_QTY Numeric 6 3 No > 15 PKG_UNIT_MEA.. Character 2 No > 16 PKG_QTY Integer 4 No > 17 DRUG_NAME_CO.. Character 6 No > 18 THERAPEUTIC_.. Character 10 No >>