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 |