CREATE TABLE adempiere.JP_ContractExtendPeriod
(
  JP_ContractExtendPeriod_ID numeric(10,0) NOT NULL,
  JP_ContractExtendPeriod_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),
  IsDueFixed character(1) NOT NULL DEFAULT 'N'::bpchar,
  JP_Year numeric NOT NULL DEFAULT 0,
  JP_Month numeric NOT NULL DEFAULT 0,
  JP_Day numeric NOT NULL DEFAULT 0,

  CONSTRAINT JP_ContractExtendPeriod_pkey PRIMARY KEY (JP_ContractExtendPeriod_ID)
)