CREATE TABLE adempiere.JP_Contract_Acct
(
  JP_Contract_Acct_ID numeric(10,0) NOT NULL,
  JP_Contract_Acct_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,

  Value character varying(40) NOT NULL,
  Name character varying(120) NOT NULL,
  Description character varying(255),
  Processing character(1),

  DocBaseType character varying(3) COLLATE NOT NULL DEFAULT 'SOO'::character varying,
  ispostingcontractacctjp character(1) COLLATE pg_catalog."default" NOT NULL DEFAULT 'N'::bpchar,
  ispostingrecognitiondocjp character(1) COLLATE pg_catalog."default" NOT NULL DEFAULT 'N'::bpchar,
  issotrx character(1) COLLATE pg_catalog."default" NOT NULL DEFAULT 'Y'::bpchar,
  docaction character varying(2)  DEFAULT NULL::character varying,
  issplitwhendifferencejp character(1) COLLATE pg_catalog."default" DEFAULT 'N'::bpchar,
  jp_recogtoinvoicepolicy character varying(2) COLLATE pg_catalog."default" DEFAULT 'NO'::character varying,

  CONSTRAINT JP_Contract_Acct_pkey PRIMARY KEY (JP_Contract_Acct_ID)
)