@EndUserText.label : 'Drilling job'
@AbapCatalog.enhancement.category : #NOT_EXTENSIBLE
@AbapCatalog.tableCategory : #TRANSPARENT
@AbapCatalog.deliveryClass : #A
@AbapCatalog.dataMaintenance : #RESTRICTED
define table {{p}}well {
  key client    : abap.clnt not null;
  key job_id    : abap.char(10) not null;
  site_name     : abap.char(40);
  drilled_on    : abap.tims;
  @Semantics.quantity.unitOfMeasure : '{{p}}well.depth_unit'
  depth_m       : abap.dec(7,2);
  depth_unit    : abap.unit(3);
  @Semantics.amount.currencyCode : '{{p}}well.currency_code'
  price         : abap.dec(15,2);
  currency_code : abap.cuky;
  permit_no     : abap.numc(8);
  crew_size     : abap.int4;
}