DIC_QUARRY_PRODUCT
Dictionary table containing a listing of quarry products. (e.g Agricultural Fertilisers, building stone, concrete blocks, dry stone walling etc.)
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(6) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(250) |
|
| 3 |
TRANSLATION |
Varchar(50) |
|
| 4 |
STATUS |
Varchar(1) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 18 of 18)
| CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| AGLM |
AGRICULTURAL LIME/GROUND LIMESTONE |
Agricultural Fertilisers |
C |
14-FEB-01 |
18-JUL-06 |
| BUST |
BUILDING STONE |
Building Stone |
C |
14-FEB-01 |
18-JUL-06 |
| CONB |
PRODUCTS USED IN CONCRETE BLOCK PRODUCTION |
Concrete Blocks |
C |
14-FEB-01 |
18-JUL-06 |
| DRYS |
DRY STONE WALLING |
Dry Stone Walling |
C |
14-FEB-01 |
18-JUL-06 |
| FLAG |
FLAGSTONES |
Flagstones |
C |
14-FEB-01 |
18-JUL-06 |
| IRSF |
LIMESTONE AS FLUX IN IRON/STEEL MAKING |
Flux in Steel Industry |
C |
14-FEB-01 |
18-JUL-06 |
| PPMA |
LIMESTONE IN PAPER MAKING |
Paper Making |
C |
14-FEB-01 |
18-JUL-06 |
| ROST |
ROADSTONE |
Roadstone |
C |
14-FEB-01 |
18-JUL-06 |
| SAGG |
SANDSTONE AGGREGATES |
Aggregates |
C |
14-FEB-01 |
18-JUL-06 |
| SBUI |
SAND USED IN BUILDING TRADE |
Sand (Building Trade) |
C |
14-FEB-01 |
18-JUL-06 |
| SDBU |
SANDSTONE FOR BULK FILL |
Bulk Fill |
C |
14-FEB-01 |
18-JUL-06 |
| SDCM |
LIMESTONE DUSTING (COAL MINING) |
Dusting (Coal Mining) |
C |
14-FEB-01 |
18-JUL-06 |
| SMIL |
SANDSTONE USED AS MILLSTONES |
Millstones(Sandstone) |
C |
14-FEB-01 |
19-JUL-06 |
| SSFY |
SILICA SAND USED IN FOUNDRY WORK |
Silica Sand (Foundry Work) |
C |
14-FEB-01 |
18-JUL-06 |
| WHET |
WHETSTONE /ABRASIVE |
Whetstones/Abrasives |
C |
14-FEB-01 |
18-JUL-06 |
| SIGL |
SILICA SAND IN GLASS INDUSTRY |
Silica Sand (Glass Industry) |
C |
14-FEB-01 |
18-JUL-06 |
| WMIL |
WHINSTONE USED AS MILLSTONES |
Millstones(Whin) |
C |
14-FEB-01 |
19-JUL-06 |
| OSBV |
OSMOND STONE USED IN CONSTRUCTION OF BAKERS OVENS |
Osmond Stone |
C |
14-FEB-01 |
18-JUL-06 |