CREATE TABLE adempiere.JP_ContractLine
(
   jp_contractline_id numeric(10,0) NOT NULL,
    jp_contractline_uu character varying(36) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    ad_client_id numeric(10,0) NOT NULL,
    ad_org_id numeric(10,0) NOT NULL,
    isactive character(1) COLLATE pg_catalog."default" 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_contractcontent_id numeric(10,0) NOT NULL,
    c_bpartner_id numeric(10,0),
    c_bpartner_location_id numeric(10,0),
    line numeric(10,0) NOT NULL,
    jp_contractlinet_id numeric(10,0),
    m_product_id numeric(10,0),
    m_attributesetinstance_id numeric(10,0),
    s_resourceassignment_id numeric(10,0),
    jp_locator_id numeric(10,0),
    deliverytime_promised numeric(10,0) DEFAULT 0,
    description character varying(255) COLLATE pg_catalog."default",
    iscreatedoclinejp character(1) COLLATE pg_catalog."default" NOT NULL DEFAULT 'Y'::bpchar,
    qtyentered numeric NOT NULL,
    c_uom_id numeric(10,0) NOT NULL,
    qtyordered numeric NOT NULL DEFAULT 0,
    jp_derivativedocpolicy_inout character(2) COLLATE pg_catalog."default",
    jp_contractcalender_inout_id numeric(10,0),
    jp_contractprocess_inout_id numeric(10,0),
    movementqty numeric NOT NULL DEFAULT 0,
    jp_derivativedocpolicy_inv character(2) COLLATE pg_catalog."default",
    jp_contractcalender_inv_id numeric(10,0),
    jp_contractprocess_inv_id numeric(10,0),
    qtyinvoiced numeric NOT NULL DEFAULT 0,
    priceentered numeric NOT NULL,
    priceactual numeric NOT NULL DEFAULT 0,
    pricelist numeric NOT NULL DEFAULT 0,
    pricelimit numeric NOT NULL DEFAULT 0,
    discount numeric,
    c_tax_id numeric(10,0) NOT NULL,
    jp_locatorfrom_id numeric(10,0),
    jp_locatorto_id numeric(10,0),
    jp_asi_from_id numeric(10,0),
    jp_asi_to_id numeric(10,0),
    linenetamt numeric NOT NULL DEFAULT 0,
    c_charge_id numeric(10,0),
    isdescription character(1) COLLATE pg_catalog."default" NOT NULL DEFAULT 'N'::bpchar,
    c_project_id numeric(10,0),
    c_projectphase_id numeric(10,0),
    c_projecttask_id numeric(10,0),
    c_campaign_id numeric(10,0),
    c_activity_id numeric(10,0),
    user1_id numeric(10,0),
    user2_id numeric(10,0),
    ad_orgtrx_id numeric(10,0),
    datepromised timestamp without time zone,
    dateordered timestamp without time zone,
    processed character(1) COLLATE pg_catalog."default" NOT NULL DEFAULT 'N'::bpchar,
    jp_processing1 character(1) COLLATE pg_catalog."default" DEFAULT NULL::bpchar,
    jp_processing2 character(1) COLLATE pg_catalog."default" DEFAULT NULL::bpchar,
    jp_procperiod_lump_inout_id numeric(10,0) DEFAULT NULL::numeric,
    jp_procperiod_lump_inv_id numeric(10,0) DEFAULT NULL::numeric,
    jp_procperiod_start_inout_id numeric(10,0) DEFAULT NULL::numeric,
    jp_procperiod_end_inout_id numeric(10,0) DEFAULT NULL::numeric,
    jp_procperiod_start_inv_id numeric(10,0) DEFAULT NULL::numeric,
    jp_procperiod_end_inv_id numeric(10,0) DEFAULT NULL::numeric,
    jp_basedoclinepolicy character varying(2) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    jp_procperiod_lump_id numeric(10,0) DEFAULT NULL::numeric,
    jp_procperiod_start_id numeric(10,0) DEFAULT NULL::numeric,
    jp_procperiod_end_id numeric(10,0) DEFAULT NULL::numeric,

  CONSTRAINT JP_ContractLine_pkey PRIMARY KEY (JP_ContractLine_ID)
)