CREATE TABLE adempiere.JP_InvValCalLine
(
  JP_InvValCalLine_ID numeric(10,0) NOT NULL,
  JP_InvValCalLine_uu character varying(36) DEFAULT NULL::character varying,
  AD_Client_ID numeric(10,0) NOT NULL,
  AD_Org_ID numeric(10,0) NOT NULL,
  IsActive character(1) NOT NULL DEFAULT 'Y'::bpchar,
  Created timestamp without time zone NOT NULL DEFAULT now(),
  CreatedBy numeric(10,0) NOT NULL,
  Updated timestamp without time zone NOT NULL DEFAULT now(),
  UpdatedBy numeric(10,0) NOT NULL,

  JP_InvValCal_ID numeric(10,0) NOT NULL,
  Line numeric(10,0) NOT NULL,
  M_Product_ID numeric(10,0) NOT NULL,
  M_AttributeSetInstance_ID numeric(10,0),
  QtyBook numeric NOT NULL DEFAULT 0,
  C_AcctSchema_ID numeric(10,0) ,
  CostingMethod character(1) NOT NULL,
  CostingLevel character(1) NOT NULL,
  JP_InvValTotalAmt numeric NOT NULL DEFAULT 0,
  JP_InvValAmt numeric NOT NULL DEFAULT 0,
  Description character varying(255),
  CurrentCostPrice numeric NOT NULL DEFAULT 0,
  FutureCostPrice numeric NOT NULL DEFAULT 0,

  CONSTRAINT JP_InvValCalLine_pkey PRIMARY KEY (JP_InvValCalLine_ID)
)