CREATE TABLE "WAMAS_PROD"."OUTBOUNDORDER_TMP1"
   (	"OBONO" VARCHAR2(20 CHAR),
	"CLIENTID" NVARCHAR2(10),
	"SYSPARTNER_ID" NVARCHAR2(10),
	"ORDERTIME" TIMESTAMP (0),
	"PRIORITY" NUMBER(18,0),
	"STARTTIME" TIMESTAMP (0),
	"FINISHTIME" TIMESTAMP (0),
	"RELEASETIME" TIMESTAMP (0),
	"KEYD_DEL_NUMWHQTYUNITS" NUMBER(18,0),
	"KEYD_DEL_TOTDANGOODSPOINTS" NUMBER(18,0),
	"KEYD_DEL_TOTGRWT_NORMVALUE" BINARY_DOUBLE,
	"KEYD_DEL_TOTGRWT_VALUE" NUMBER(12,3),
	"KEYD_DEL_TOTGRWT_UNIT_ID" NVARCHAR2(7),
	"KEYD_DEL_TOTVOL_NORMVALUE" BINARY_DOUBLE,
	"KEYD_DEL_TOTVOL_VALUE" NUMBER(12,3),
	"KEYD_DEL_TOTVOL_UNIT_ID" NVARCHAR2(7),
	"KEYD_NUMLINES" NUMBER(18,0),
	"KEYD_NUMOBD" NUMBER(18,0),
	"KEYD_NUMPRIMARYLINES" NUMBER(18,0),
	"KEYD_REL_NUMWHQTYUNITS" NUMBER(18,0),
	"KEYD_REL_TOTDANGOODSPOINTS" NUMBER(18,0),
	"KEYD_REL_TOTGRWT_NORMVALUE" BINARY_DOUBLE,
	"KEYD_REL_TOTGRWT_VALUE" NUMBER(12,3),
	"KEYD_REL_TOTGRWT_UNIT_ID" NVARCHAR2(7),
	"KEYD_REL_TOTVOL_NORMVALUE" BINARY_DOUBLE,
	"KEYD_REL_TOTVOL_VALUE" NUMBER(12,3),
	"KEYD_REL_TOTVOL_UNIT_ID" NVARCHAR2(7),
	"STATE_CANCELED" NUMBER(1,0),
	"STATE_DRAFT" NUMBER(1,0),
	"STATE_ERROR" NUMBER(1,0),
	"STATE_MAINSTATE" VARCHAR2(8 CHAR),
	"STATE_ORDERTOLERANCEEXCEEDED" NUMBER(1,0),
	"STATE_PROGRESS" NUMBER(4,0),
	"STATE_RELEASESTATE" VARCHAR2(20 CHAR),
	"STATE_STATEREF" VARCHAR2(10 CHAR),
	"OBDRESTR_REDUCTIONALLOWED" VARCHAR2(9 CHAR),
	"OBDRESTR_SPLITALLOWED" VARCHAR2(9 CHAR),
	"DATASTATE" VARCHAR2(8 CHAR),
	"HISTORY_CREATEDAT" TIMESTAMP (0),
	"HISTORY_CREATEDBY" NVARCHAR2(35),
	"HISTORY_MODIFIEDAT" TIMESTAMP (0),
	"HISTORY_MODIFIEDBY" NVARCHAR2(35),
	"VERSIONCOUNTING_COUNTER" NUMBER(18,0),
	"VERSIONCOUNTING_EMITTER" NUMBER(18,0),
	"ROUNDINGBYRULES" VARCHAR2(9 CHAR),
	"PRJBUYBACKBEGINDATE" TIMESTAMP (0),
	"PRJBUYBACKENDDATE" TIMESTAMP (0),
	"PRJBUYBACKSCAC" NVARCHAR2(4),
	"PRJDEMANDTYPE" NVARCHAR2(5),
	"PRJDESTINATION" NVARCHAR2(20),
	"PRJEXPECTEDDELIVERYDATE" TIMESTAMP (0),
	"PRJEXPECTEDSHIPPINGDATE" TIMESTAMP (0),
	"PRJORDERONHOLD" VARCHAR2(1 CHAR),
	"PRJRTMREASONCODE" NVARCHAR2(40),
	"PRJRESERVESTOCK" VARCHAR2(1 CHAR),
	"PRJSEQUENCE" NUMBER(18,0),
	"PRJSHOPKEY" NVARCHAR2(40),
	"PRJTRANSFERSTORE" NVARCHAR2(15),
	"ID" NUMBER(18,0),
	"SERVICELEVELID" NVARCHAR2(20),
	"EXTREFGROUP_ID" NUMBER(18,0),
	"RECIPIENT_ROLEKIND" VARCHAR2(17 CHAR),
	"RECIPIENT_OBONO" VARCHAR2(20 CHAR),
	"RECIPIENT_CLIENTID" NVARCHAR2(10),
	"RECIPIENT_SYSPARTNER_ID" NVARCHAR2(10),
	"REQSHIPPINGCATEGORY_CATEGORYID" NVARCHAR2(10),
	"REQSHIPPINGMETHOD_METHODID" NVARCHAR2(10),
	"TEXTLINEGROUP_ID" NUMBER(18,0),
	"TYPE_OBOTYPEID" NVARCHAR2(20),
	"TYPE_CLIENTID" NVARCHAR2(10),
	"WHLOC_WHLOCID" NVARCHAR2(20),
	"CONSOLIDATIONID" NVARCHAR2(255),
	 CONSTRAINT "OUTBOUNDORDER_TMP1_PK" PRIMARY KEY ("OBONO", "CLIENTID", "SYSPARTN
ER_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "WAMASDATA"  ENABLE,
	 SUPPLEMENTAL LOG DATA (ALL) COLUMNS
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "WAMASDATA"