CREATE TABLE adempiere.JP_InvValAdjust
(
  JP_InvValAdjust_ID numeric(10,0) NOT NULL,
  JP_InvValAdjust_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(),
  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,

  TotalLines numeric NOT NULL DEFAULT 0,
  Description character varying(255),
  JP_InvValCal_ID numeric(10,0),
  GL_Journal_ID numeric(10,0),
  DateAcct timestamp without time zone NOT NULL,
  DifferenceQty numeric NOT NULL DEFAULT 0,
  DifferenceAmt numeric NOT NULL DEFAULT 0,
   
  CONSTRAINT JP_InvValAdjust_pkey PRIMARY KEY (JP_InvValAdjust_ID)
)