CREATE TABLE adempiere.JP_InvValCal
(
  JP_InvValCal_ID numeric(10,0) NOT NULL,
  JP_InvValCal_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,

  DocumentNo character varying(30) NOT NULL,
  DocStatus character(2) NOT NULL,
  DocAction character(2) NOT NULL,
  Processing character(1),
  Processed character(1) NOT NULL DEFAULT 'N'::bpchar,
  Posted character(1) NOT NULL DEFAULT 'N'::bpchar,
  IsApproved character(1) NOT NULL DEFAULT 'Y'::bpchar,
  ProcessedOn numeric,

  C_DocType_ID numeric(10,0) NOT NULL,
  DateValue timestamp without time zone NOT NULL DEFAULT now(),
  JP_LastDateValue timestamp without time zone DEFAULT now(),
  SalesRep_ID numeric(10,0),
  JP_InvValProfile_ID numeric(10,0) NOT NULL,

  C_Currency_ID numeric(10,0) NOT NULL,
  JP_Processing1 character(1),
  JP_ProcessedTime1 timestamp without time zone,
  JP_Processing2 character(1),
  JP_ProcessedTime2 timestamp without time zone,
  JP_Processing3 character(1),
  JP_ProcessedTime3 timestamp without time zone,
  JP_Processing4 character(1),

  TotalLines numeric NOT NULL DEFAULT 0,
  Description character varying(255),
  DateAcct timestamp without time zone NOT NULL,

  CONSTRAINT JP_InvValCal_pkey PRIMARY KEY (JP_InvValCal_ID)
)