{ "source" : { "server" : "dbzdfcsrvr" }, "position" : { "snapshot_pending_tx" : "79010300a1040000:30002764957", "snapshot_scn" : "30002776930", "snapshot" : true, "scn" : "30002776930", "snapshot_completed" : false }, "databaseName" : "WAMAPRF", "schemaName" : "WAMAS_PROD", "ddl" : "\n CREATE TABLE \"WAMAS_PROD\".\"STOCKOBJECTBUNDLE_TMP\" \n (\t\"LUID\" VARCHAR2(20 CHAR), \n\t\"LUORIGIN\" NVARCHAR2(20), \n\t\"OFFSET_X0_NORMVALUE\" BINARY_DOUBLE DEFAULT 0.0, \n\t\"OFFSET_X0_VALUE\" NUMBER(12,3) DEFAULT 0, \n\t\"OFFSET_X0_UNIT_ID\" NVARCHAR2(7), \n\t\"OFFSET_Y0_NORMVALUE\" BINARY_DOUBLE DEFAULT 0.0, \n\t\"OFFSET_Y0_VALUE\" NUMBER(12,3) DEFAULT 0, \n\t\"OFFSET_Y0_UNIT_ID\" NVARCHAR2(7), \n\t\"OFFSET_Z0_NORMVALUE\" BINARY_DOUBLE DEFAULT 0.0, \n\t\"OFFSET_Z0_VALUE\" NUMBER(12,3) DEFAULT 0, \n\t\"OFFSET_Z0_UNIT_ID\" NVARCHAR2(7), \n\t\"KEYDATA_DANGOODSPOINTS\" NUMBER(18,0) DEFAULT 0, \n\t\"KEYDATA_GOODSVOLUME_NORMVALUE\" BINARY_DOUBLE DEFAULT 0.0, \n\t\"KEYDATA_GOODSVOLUME_VALUE\" NUMBER(12,3) DEFAULT 0, \n\t\"KEYDATA_GOODSVOLUME_UNIT_ID\" NVARCHAR2(7), \n\t\"KEYDATA_GROSSWEIGHT_NORMVALUE\" BINARY_DOUBLE DEFAULT 0.0, \n\t\"KEYDATA_GROSSWEIGHT_VALUE\" NUMBER(12,3) DEFAULT 0, \n\t\"KEYDATA_GROSSWEIGHT_UNIT_ID\" NVARCHAR2(7), \n\t\"KEYDATA_NUMPRIMARYSOS\" NUMBER(18,0) DEFAULT 0, \n\t\"KEYDATA_WEIGHTKIND\" VARCHAR2(10 CHAR) DEFAULT 'CALCULATED', \n\t\"VERSIONCOUNTING_COUNTER\" NUMBER(18,0) DEFAULT 0, \n\t\"VERSIONCOUNTING_EMITTER\" NUMBER(18,0) DEFAULT 0, \n\t\"HISTORY_CREATEDAT\" TIMESTAMP (0), \n\t\"HISTORY_CREATEDBY\" NVARCHAR2(35), \n\t\"HISTORY_MODIFIEDAT\" TIMESTAMP (0), \n\t\"HISTORY_MODIFIEDBY\" NVARCHAR2(35), \n\t\"LASTMOVEMENT_KIND\" VARCHAR2(9 CHAR) DEFAULT 'NONE', \n\t\"LASTMOVEMENT_TIME\" TIMESTAMP (0), \n\t\"STOLOC_STOLOCID\" NVARCHAR2(20), \n\t\"STOLOC_WHLOCID\" NVARCHAR2(20), \n\t\"LUIDKIND\" VARCHAR2(4 CHAR), \n\t\"LUKIND\" VARCHAR2(11 CHAR), \n\t\"SYSTEMLU\" NUMBER(1,0), \n\t\"WHOLELU\" NUMBER(1,0), \n\t\"EXTLUID\" VARCHAR2(20 CHAR), \n\t\"TAREWEIGHTMEASURED_NORMVALUE\" BINARY_DOUBLE, \n\t\"TAREWEIGHTMEASURED_VALUE\" NUMBER(12,3), \n\t\"TAREWEIGHTMEASURED_UNIT_ID\" NVARCHAR2(7), \n\t\"ORIGDATA_CUBATURE_CUBATUREID\" NVARCHAR2(10), \n\t\"INVFIELDS_INVBLOCK\" NUMBER(1,0), \n\t\"INVFIELDS_LASTINVTIME\" TIMESTAMP (0), \n\t\"TRANSBLOCK\" NUMBER(1,0), \n\t\"LOCPOSTINGINFO_SEQINITTIME\" TIMESTAMP (0), \n\t\"LOCPOSTINGINFO_SEQNAME\" NVARCHAR2(30), \n\t\"LOCPOSTINGINFO_SEQUENCE\" NUMBER(18,0), \n\t\"PARKED\" NUMBER(1,0), \n\t\"CUSTOMGROUP\" NVARCHAR2(20), \n\t\"SEQUENCEWITHINSTOCOMP\" NUMBER(18,0), \n\t\"ORIENTATION\" VARCHAR2(4 CHAR), \n\t\"WAATTRS_CAGE\" NUMBER(1,0), \n\t\"WAATTRS_EMPTY\" NUMBER(1,0), \n\t\"WAATTRS_EMPTYSTACK\" NUMBER(1,0), \n\t\"WAATTRS_MFSBOOKINGCOUNT\" NUMBER(18,0), \n\t\"WAATTRS_MOVCNTGRP\" NVARCHAR2(80), \n\t\"WAATTRS_MOVCNTLASTINCTIME\" TIMESTAMP (0), \n\t\"WAATTRS_MOVCTNVALUE\" NUMBER(18,0), \n\t\"MASTERLUKIND\" VARCHAR2(7 CHAR), \n\t\"ITEMBARCODE\" NVARCHAR2(40), \n\t\"PRJGAYLORDISFULL\" NUMBER(1,0), \n\t\"PRJIDENTIFYBYSHIPPINGLABEL\" NUMBER(1,0), \n\t\"PRJLUISMIXEDPALLETFORITEMSETUP\" NUMBER(1,0), \n\t\"PRJPICKINGPOLYBAGISFULL\" NUMBER(1,0), \n\t\"PRJRECSORTLUID\" VARCHAR2(40 CHAR), \n\t\"LOADAIDID\" NVARCHAR2(10), \n\t\"CUBATUREID\" NVARCHAR2(10), \n\t\"LUCOMPDIVID\" NVARCHAR2(20), \n\t\"FOGGRAPH_FOGGRAPHID\" NVARCHAR2(10), \n\t\"FOGGRAPH_WHLOCID\" NVARCHAR2(20), \n\t\"MASTER_LUID\" VARCHAR2(20 CHAR), \n\t\"MASTER_LUORIGIN\" NVARCHAR2(20), \n\t\"ROOTMASTER_LUID\" VARCHAR2(20 CHAR), \n\t\"ROOTMASTER_LUORIGIN\" NVARCHAR2(20), \n\t\"TEMPORARYSTOCK\" NUMBER(1,0), \n\t\"DISCRIMINATOR\" VARCHAR2(255 CHAR), \n\t\"PRJSHIPPINGLABEL\" NVARCHAR2(40), \n\t\"PRJSDCSHIPPINGLABELFILENAME\" NVARCHAR2(100), \n\t\"PRJSDCSHPLABELSEQNR\" NVARCHAR2(100), \n\t\"INVFIELDS_LASTINVUSER\" NVARCHAR2(35), \n\t\"PRJOBDGROUPING\" NVARCHAR2(40), \n\t\"CUSTOMER_NAME\" VARCHAR2(45 CHAR), \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_LUID\" CHECK (trim(luId) is not null and trim(luId) <> '' and trim(luId) = luId) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_VE_1Q5EVMS\" CHECK (versionCounting_counter is not null and abs(versionCounting_counter) <=\n999999999999999999 and versionCounting_counter >= 0) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_ST_1IZ22W1\" CHECK (stoLoc_whLocId is not null) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_OR_19I298S\" CHECK (orientation is null or (orientation in ('O0','O90','O180','O270'))) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_KE_1DHFKRC\" CHECK (keyData_grossWeight_normValue is not null) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_KEY_EWQSJW\" CHECK (keyData_goodsVolume_normValue is not null) ENABLE, \n\t CONSTRAINT \"SUBFKC_LOADUNIT_LOADAID_TMP\" CHECK (DISCRIMINATOR <> 'LoadUnit' or ( loadAidId is not null)) ENABLE, \n\t CONSTRAINT \"FKC_STOCKOBJECTBUNDLE_TMP_MASTER\" CHECK ((master_luId is null and master_luOrigin is null) or (master_luId is not null and\nmaster_luOrigin is not null)) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_LUIDKIND\" CHECK (luIdKind is null or (luIdKind in ('NO','SSCC'))) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_OFF_EEQ55C\" CHECK (offset_z0_value is not null) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_OFF_RSL902\" CHECK (offset_x0_value is not null) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_LUORIGIN\" CHECK (trim(luOrigin) is not null and trim(luOrigin) <> '' and trim(luOrigin) = luOrigin) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_LAS_76MIEI\" CHECK (lastMovement_kind is not null and lastMovement_kind in ('NONE','PICKING','TRANSPORT')) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_DI_1XRTKAG\" CHECK (DISCRIMINATOR is not null) ENABLE, \n\t CONSTRAINT \"FKC_STOCKOBJECTBUNDLE_TMP_FOGGRAPH\" CHECK ((fogGraph_fogGraphId is null and fogGraph_whLocId is null) or (fogGraph_fogGraphId is not\nnull and fogGraph_whLocId is not null)) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_KEY_9UZPMU\" CHECK (keyData_weightKind is not null and keyData_weightKind in ('CALCULATED','MEASURED')) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_OFF_AGYUBA\" CHECK (offset_x0_normValue is not null) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_KEY_C0ZTF8\" CHECK (keyData_grossWeight_value is not null) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_STO_5ASS7Q\" CHECK (stoLoc_stoLocId is not null) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_WAA_DKKCXX\" CHECK (waAttrs_mfsBookingCount is null or (abs(waAttrs_mfsBookingCount) <= 999999999999999999)) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_VER_JCIG46\" CHECK (versionCounting_emitter is not null and abs(versionCounting_emitter) <=\n999999999999999999 and versionCounting_emitter >= 0) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_KE_1117AHT\" CHECK (keyData_numPrimarySOs is not null and abs(keyData_numPrimarySOs) <= 99999) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_LUKIND\" CHECK (luKind is null or (luKind in ('NORMAL','UNQUALIFIED','TEMPORARY','TRANSIENT'))) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_SE_1NBOBZH\" CHECK (sequenceWithinStoComp is null or (abs(sequenceWithinStoComp) <= 9999999 and\nsequenceWithinStoComp >= 0)) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_OFF_CLTJ6D\" CHECK (offset_y0_normValue is not null) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_KE_1XH48H4\" CHECK (keyData_goodsVolume_value is not null) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_LO_1OK76JW\" CHECK (locPostingInfo_sequence is null or (abs(locPostingInfo_sequence) <= 999999999999999999)) ENABLE, \n\t CONSTRAINT \"FKC_STOCKOBJECTBUNDLE_TMP_11P20OD\" CHECK ((rootMaster_luId is null and rootMaster_luOrigin is null) or (rootMaster_luId is not null\nand rootMaster_luOrigin is not null)) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_OFF_EQO81G\" CHECK (offset_z0_normValue is not null) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_OF_1KM7Q29\" CHECK (offset_y0_value is not null) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_WAA_KBVVWD\" CHECK (waAttrs_movCtnValue is null or (abs(waAttrs_movCtnValue) <= 9999)) ENABLE, \n\t CONSTRAINT \"SUBFKC_LOADUNIT_LOADUN_1XJ1WOZ_TMP\" CHECK (DISCRIMINATOR <> 'LoadUnit' or ( cubatureId is not null)) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_MA_1UG4R0J\" CHECK (masterLuKind is null or (masterLuKind in ('NONE','DEFAULT'))) ENABLE, \n\t CONSTRAINT \"C_STOCKOBJECTBUNDLE_TMP_KE_1VNLOMA\" CHECK (keyData_danGoodsPoints is not null and abs(keyData_danGoodsPoints) <= 999999999999999 and\nkeyData_danGoodsPoints >= 0) ENABLE, \n\t CONSTRAINT \"PK_STOCKOBJECTBUNDLE_TMP\" PRIMARY KEY (\"LUID\", \"LUORIGIN\")\n USING INDEX ENABLE, \n\t CONSTRAINT \"UX_LOADUNITLUIDWHLOCID_TMP\" UNIQUE (\"LUID\", \"STOLOC_WHLOCID\")\n USING INDEX ENABLE, \n\t SUPPLEMENTAL LOG DATA (ALL) COLUMNS, \n\t SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS, \n\t SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS\n ) ;", "tableChanges" : [ { "type" : "CREATE", "id" : "\"WAMAPRF\".\"WAMAS_PROD\".\"STOCKOBJECTBUNDLE_TMP\"", "table" : { "defaultCharsetName" : null, "primaryKeyColumnNames" : [ "LUID", "LUORIGIN" ], "columns" : [ { "name" : "LUID", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 20, "position" : 1, "optional" : false, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : false, "enumValues" : [ ] }, { "name" : "LUORIGIN", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 20, "position" : 2, "optional" : false, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : false, "enumValues" : [ ] }, { "name" : "OFFSET_X0_NORMVALUE", "jdbcType" : 101, "typeName" : "BINARY_DOUBLE", "typeExpression" : "BINARY_DOUBLE", "charsetName" : null, "length" : 8, "position" : 3, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0.0", "enumValues" : [ ] }, { "name" : "OFFSET_X0_VALUE", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 12, "scale" : 3, "position" : 4, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0", "enumValues" : [ ] }, { "name" : "OFFSET_X0_UNIT_ID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 7, "position" : 5, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "OFFSET_Y0_NORMVALUE", "jdbcType" : 101, "typeName" : "BINARY_DOUBLE", "typeExpression" : "BINARY_DOUBLE", "charsetName" : null, "length" : 8, "position" : 6, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0.0", "enumValues" : [ ] }, { "name" : "OFFSET_Y0_VALUE", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 12, "scale" : 3, "position" : 7, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0", "enumValues" : [ ] }, { "name" : "OFFSET_Y0_UNIT_ID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 7, "position" : 8, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "OFFSET_Z0_NORMVALUE", "jdbcType" : 101, "typeName" : "BINARY_DOUBLE", "typeExpression" : "BINARY_DOUBLE", "charsetName" : null, "length" : 8, "position" : 9, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0.0", "enumValues" : [ ] }, { "name" : "OFFSET_Z0_VALUE", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 12, "scale" : 3, "position" : 10, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0", "enumValues" : [ ] }, { "name" : "OFFSET_Z0_UNIT_ID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 7, "position" : 11, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "KEYDATA_DANGOODSPOINTS", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 18, "scale" : 0, "position" : 12, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0", "enumValues" : [ ] }, { "name" : "KEYDATA_GOODSVOLUME_NORMVALUE", "jdbcType" : 101, "typeName" : "BINARY_DOUBLE", "typeExpression" : "BINARY_DOUBLE", "charsetName" : null, "length" : 8, "position" : 13, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0.0", "enumValues" : [ ] }, { "name" : "KEYDATA_GOODSVOLUME_VALUE", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 12, "scale" : 3, "position" : 14, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0", "enumValues" : [ ] }, { "name" : "KEYDATA_GOODSVOLUME_UNIT_ID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 7, "position" : 15, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "KEYDATA_GROSSWEIGHT_NORMVALUE", "jdbcType" : 101, "typeName" : "BINARY_DOUBLE", "typeExpression" : "BINARY_DOUBLE", "charsetName" : null, "length" : 8, "position" : 16, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0.0", "enumValues" : [ ] }, { "name" : "KEYDATA_GROSSWEIGHT_VALUE", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 12, "scale" : 3, "position" : 17, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0", "enumValues" : [ ] }, { "name" : "KEYDATA_GROSSWEIGHT_UNIT_ID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 7, "position" : 18, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "KEYDATA_NUMPRIMARYSOS", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 18, "scale" : 0, "position" : 19, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0", "enumValues" : [ ] }, { "name" : "KEYDATA_WEIGHTKIND", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 10, "position" : 20, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "'CALCULATED'", "enumValues" : [ ] }, { "name" : "VERSIONCOUNTING_COUNTER", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 18, "scale" : 0, "position" : 21, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0", "enumValues" : [ ] }, { "name" : "VERSIONCOUNTING_EMITTER", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 18, "scale" : 0, "position" : 22, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "0", "enumValues" : [ ] }, { "name" : "HISTORY_CREATEDAT", "jdbcType" : 93, "typeName" : "TIMESTAMP(0)", "typeExpression" : "TIMESTAMP(0)", "charsetName" : null, "length" : 0, "position" : 23, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "HISTORY_CREATEDBY", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 35, "position" : 24, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "HISTORY_MODIFIEDAT", "jdbcType" : 93, "typeName" : "TIMESTAMP(0)", "typeExpression" : "TIMESTAMP(0)", "charsetName" : null, "length" : 0, "position" : 25, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "HISTORY_MODIFIEDBY", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 35, "position" : 26, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "LASTMOVEMENT_KIND", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 9, "position" : 27, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "defaultValueExpression" : "'NONE'", "enumValues" : [ ] }, { "name" : "LASTMOVEMENT_TIME", "jdbcType" : 93, "typeName" : "TIMESTAMP(0)", "typeExpression" : "TIMESTAMP(0)", "charsetName" : null, "length" : 0, "position" : 28, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "STOLOC_STOLOCID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 20, "position" : 29, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "STOLOC_WHLOCID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 20, "position" : 30, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "LUIDKIND", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 4, "position" : 31, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "LUKIND", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 11, "position" : 32, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "SYSTEMLU", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 33, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "WHOLELU", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 34, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "EXTLUID", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 20, "position" : 35, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "TAREWEIGHTMEASURED_NORMVALUE", "jdbcType" : 101, "typeName" : "BINARY_DOUBLE", "typeExpression" : "BINARY_DOUBLE", "charsetName" : null, "length" : 8, "position" : 36, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "TAREWEIGHTMEASURED_VALUE", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 12, "scale" : 3, "position" : 37, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "TAREWEIGHTMEASURED_UNIT_ID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 7, "position" : 38, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "ORIGDATA_CUBATURE_CUBATUREID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 10, "position" : 39, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "INVFIELDS_INVBLOCK", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 40, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "INVFIELDS_LASTINVTIME", "jdbcType" : 93, "typeName" : "TIMESTAMP(0)", "typeExpression" : "TIMESTAMP(0)", "charsetName" : null, "length" : 0, "position" : 41, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "TRANSBLOCK", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 42, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "LOCPOSTINGINFO_SEQINITTIME", "jdbcType" : 93, "typeName" : "TIMESTAMP(0)", "typeExpression" : "TIMESTAMP(0)", "charsetName" : null, "length" : 0, "position" : 43, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "LOCPOSTINGINFO_SEQNAME", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 30, "position" : 44, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "LOCPOSTINGINFO_SEQUENCE", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 18, "scale" : 0, "position" : 45, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "PARKED", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 46, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "CUSTOMGROUP", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 20, "position" : 47, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "SEQUENCEWITHINSTOCOMP", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 18, "scale" : 0, "position" : 48, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "ORIENTATION", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 4, "position" : 49, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "WAATTRS_CAGE", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 50, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "WAATTRS_EMPTY", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 51, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "WAATTRS_EMPTYSTACK", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 52, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "WAATTRS_MFSBOOKINGCOUNT", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 18, "scale" : 0, "position" : 53, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "WAATTRS_MOVCNTGRP", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 80, "position" : 54, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "WAATTRS_MOVCNTLASTINCTIME", "jdbcType" : 93, "typeName" : "TIMESTAMP(0)", "typeExpression" : "TIMESTAMP(0)", "charsetName" : null, "length" : 0, "position" : 55, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "WAATTRS_MOVCTNVALUE", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 18, "scale" : 0, "position" : 56, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "MASTERLUKIND", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 7, "position" : 57, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "ITEMBARCODE", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 40, "position" : 58, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "PRJGAYLORDISFULL", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 59, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "PRJIDENTIFYBYSHIPPINGLABEL", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 60, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "PRJLUISMIXEDPALLETFORITEMSETUP", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 61, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "PRJPICKINGPOLYBAGISFULL", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 62, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "PRJRECSORTLUID", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 40, "position" : 63, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "LOADAIDID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 10, "position" : 64, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "CUBATUREID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 10, "position" : 65, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "LUCOMPDIVID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 20, "position" : 66, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "FOGGRAPH_FOGGRAPHID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 10, "position" : 67, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "FOGGRAPH_WHLOCID", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 20, "position" : 68, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "MASTER_LUID", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 20, "position" : 69, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "MASTER_LUORIGIN", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 20, "position" : 70, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "ROOTMASTER_LUID", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 20, "position" : 71, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "ROOTMASTER_LUORIGIN", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 20, "position" : 72, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "TEMPORARYSTOCK", "jdbcType" : 2, "typeName" : "NUMBER", "typeExpression" : "NUMBER", "charsetName" : null, "length" : 1, "scale" : 0, "position" : 73, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "DISCRIMINATOR", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 255, "position" : 74, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "PRJSHIPPINGLABEL", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 40, "position" : 75, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "PRJSDCSHIPPINGLABELFILENAME", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 100, "position" : 76, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "PRJSDCSHPLABELSEQNR", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 100, "position" : 77, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "INVFIELDS_LASTINVUSER", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 35, "position" : 78, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "PRJOBDGROUPING", "jdbcType" : -9, "typeName" : "NVARCHAR2", "typeExpression" : "NVARCHAR2", "charsetName" : null, "length" : 40, "position" : 79, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "CUSTOMER_NAME", "jdbcType" : 12, "typeName" : "VARCHAR2", "typeExpression" : "VARCHAR2", "charsetName" : null, "length" : 45, "position" : 80, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] } ] }, "comment" : null } ] }