Using OLE DB · ADO Generic Table Display | 9/28/2003 - 11:21 |
Connection: | Provider=Unisys.DMSII; data source=waspdb |
Table: | waspdb.waspdb.skus |
Fields:
Field | Type | Row 1 | Row 2 | Row 3 | Row 4 | Row 5 | Row 6 | Row 7 | Row 8 |
---|---|---|---|---|---|---|---|---|---|
sku | Numeric(19:5) | 391 | 1135 | 1138 | 1145 | 1534 | 1535 | 3105 | 3107 |
itemnum | Numeric(19:5) | 391 | 1035 | 1038 | 1045 | 1034 | 1035 | 3105 | 3107 |
skugroup | Numeric(19:2) | 40 | 40 | 40 | 40 | 40 | 34 | 40 | 40 |
prodcode | Numeric(19:2) | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
container | VarChar(30) | LUBEIT HOUSEHOLD 30Z/144CANS | LUBEIT E/F MULTIPURP 30Z/24 CN | LUBEIT E/F MULTIPURP 80Z/12 CN | LUBEIT MOTOR OIL 3OZ/24 CANS | LUBEIT E/F MULTIPURP 40Z/12 CN | LUBEIT M-PURP 3OZ E/F STRIP DP | LUBEIT HOUSEHOLD OIL 30ML | LUBEIT HOUSEHOLD OIL 90ML |
skueach | Numeric(19:4) | 1 | 24 | 12 | 24 | 12 | 24 | 1 | 1 |
Indexes:
Index Name | Type | Primary | Unique | Fields |
---|---|---|---|---|
skussku | B+tree | True | True | 1: sku |