CREATE TABLE adempiere.JP_ContractLogDetail
(
  JP_ContractLog_ID numeric(10,0) NOT NULL,
  JP_ContractLogDetail_ID numeric(10,0) NOT NULL,
  JP_ContractLogDetail_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,

  Description character varying(255),

    jp_contract_id numeric(10,0) DEFAULT NULL::numeric,
    jp_contractcontent_id numeric(10,0) DEFAULT NULL::numeric,
    jp_contractprocperiod_id numeric(10,0) DEFAULT NULL::numeric,
    jp_contractprocess_id numeric(10,0) DEFAULT NULL::numeric,
    jp_contractprocesstracelevel character varying(3) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    c_order_id numeric(10,0) DEFAULT NULL::numeric,
    c_orderline_id numeric(10,0) DEFAULT NULL::numeric,
    m_inout_id numeric(10,0) DEFAULT NULL::numeric,
    m_inoutline_id numeric(10,0) DEFAULT NULL::numeric,
    c_invoice_id numeric(10,0) DEFAULT NULL::numeric,
    c_invoiceline_id numeric(10,0) DEFAULT NULL::numeric,
    jp_contractline_id numeric(10,0) DEFAULT NULL::numeric,
    jp_contractlogmsg character varying(2) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    ad_table_id numeric(10,0) DEFAULT NULL::numeric,
    record_id numeric(10,0) DEFAULT NULL::numeric,
    jp_contractstatus_from character varying(2) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    jp_contractstatus_to character varying(2) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    jp_contractprocstatus_from character varying(2) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    jp_contractprocstatus_to character varying(2) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    processed character(1) COLLATE pg_catalog."default" NOT NULL DEFAULT 'N'::bpchar,
    processing character(1) COLLATE pg_catalog."default" NOT NULL DEFAULT 'N'::bpchar,
    jp_processing1 character(1) COLLATE pg_catalog."default" NOT NULL DEFAULT 'N'::bpchar,
    jp_processing2 character(1) COLLATE pg_catalog."default" NOT NULL DEFAULT 'N'::bpchar,
    help character varying(2000) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    jp_confirmedby character varying(10) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    jp_confirmed timestamp without time zone,
    jp_recognition_id numeric(10,0) DEFAULT NULL::numeric,
    jp_recognitionline_id numeric(10,0) DEFAULT NULL::numeric,
    jp_contractprocschedule_id numeric(10,0) DEFAULT NULL::numeric,
    jp_contractpsline_id numeric(10,0) DEFAULT NULL::numeric,
    jp_contractpsinoutline_id numeric(10,0) DEFAULT NULL::numeric,
    jp_contractpsinvoiceline_id numeric(10,0) DEFAULT NULL::numeric,

  CONSTRAINT JP_ContractLogDetail_pkey PRIMARY KEY (JP_ContractLogDetail_ID)
)