Vocabularies — details

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 10 of 18)

CODE DESCRIPTION TRANSLATION STATUS DATE_ENTERED DATE_UPDATED
AGLM  AGRICULTURAL LIME/GROUND LIMESTONE  Agricultural Fertilisers  14-FEB-01  18-JUL-06 
BUST  BUILDING STONE  Building Stone  14-FEB-01  18-JUL-06 
CONB  PRODUCTS USED IN CONCRETE BLOCK PRODUCTION  Concrete Blocks  14-FEB-01  18-JUL-06 
DRYS  DRY STONE WALLING  Dry Stone Walling  14-FEB-01  18-JUL-06 
FLAG  FLAGSTONES  Flagstones  14-FEB-01  18-JUL-06 
IRSF  LIMESTONE AS FLUX IN IRON/STEEL MAKING  Flux in Steel Industry  14-FEB-01  18-JUL-06 
PPMA  LIMESTONE IN PAPER MAKING  Paper Making  14-FEB-01  18-JUL-06 
ROST  ROADSTONE  Roadstone  14-FEB-01  18-JUL-06 
SAGG  SANDSTONE AGGREGATES  Aggregates  14-FEB-01  18-JUL-06 
SBUI  SAND USED IN BUILDING TRADE  Sand (Building Trade)  14-FEB-01  18-JUL-06