{ "source": { "server": "PRD.BOFF" }, "position": { "snapshot_scn": "7590034236000", "snapshot": true, "scn": "7590034236000", "snapshot_completed": false }, "ts_ms": 1696950311713, "databaseName": "PECBOFF3", "schemaName": "P1BOFF", "ddl": "\n CREATE TABLE \"P1BOFF\".\"BOFF_ORDER\" \n (\t\"NO\" NUMBER(10,0) CONSTRAINT \"SYS_C007483\" NOT NULL ENABLE, \n\t\"CUST_NO\" NUMBER(7,0) CONSTRAINT \"SYS_C0011454\" NOT NULL ENABLE, \n\t\"ORCT_CODE\" VARCHAR2(2 CHAR) CONSTRAINT \"SYS_C0011455\" NOT NULL ENABLE, \n\t\"ZIPC_NO\" NUMBER(5,0) CONSTRAINT \"SYS_C0011456\" NOT NULL ENABLE, \n\t\"STAT_CODE\" VARCHAR2(2 CHAR) CONSTRAINT \"SYS_C0011457\" NOT NULL ENABLE, \n\t\"STCO_STTY_CODE\" VARCHAR2(1 CHAR) CONSTRAINT \"SYS_C0011458\" NOT NULL ENABLE, \n\t\"STCO_CODE\" VARCHAR2(3 CHAR) CONSTRAINT \"SYS_C0011459\" NOT NULL ENABLE, \n\t\"ORME_NO\" NUMBER(2,0) CONSTRAINT \"SYS_C0011453\" NOT NULL ENABLE, \n\t\"DELO_NO\" NUMBER(4,0) CONSTRAINT \"SYS_C0011466\" NOT NULL ENABLE, \n\t\"MUCO_NO\" NUMBER(4,0), \n\t\"DERU_NO\" NUMBER(10,0), \n\t\"DERU_NO_ORIG\" NUMBER(10,0), \n\t\"POSL_NO\" NUMBER(5,0) DEFAULT 0, \n\t\"DEDA_DATE\" DATE, \n\t\"DESH_CODE\" VARCHAR2(2 CHAR), \n\t\"CUQC_CODE\" VARCHAR2(3 CHAR), \n\t\"EMPL_NO_ORDER_ENTRY\" NUMBER(9,0), \n\t\"EMPL_NO_CHANGED\" NUMBER(9,0), \n\t\"DELIVERY_ADDRESS\" VARCHAR2(1 CHAR) CONSTRAINT \"SYS_C0011460\" NOT NULL ENABLE, \n\t\"HOUSE_NO\" NUMBER(5,0) CONSTRAINT \"SYS_C0011461\" NOT NULL ENABLE, \n\t\"STREET\" VARCHAR2(80 CHAR) CONSTRAINT \"SYS_C0011462\" NOT NULL ENABLE, \n\t\"CITY\" VARCHAR2(80 CHAR) CONSTRAINT \"SYS_C0011463\" NOT NULL ENABLE, \n\t\"ORDER_ENTRY_DATE\" DATE CONSTRAINT \"SYS_C0011464\" NOT NULL ENABLE, \n\t\"DATE_CHANGED\" DATE, \n\t\"ZIPCODE_EXTRA\" VARCHAR2(4 CHAR), \n\t\"PROMO_SALES_LOSS\" NUMBER(7,2), \n\t\"SERVICE_CHARGE\" NUMBER(5,2), \n\t\"E_MAIL\" VARCHAR2(50 CHAR), \n\t\"SERVICE_SURCHARGE\" NUMBER(5,2), \n\t\"ORDER_ENTRY_START_TIME\" DATE, \n\t\"DELIVERY_EXTRA_SPECS\" VARCHAR2(256 CHAR), \n\t\"HOUSE_NO_EXTRA\" VARCHAR2(10 CHAR), \n\t\"DELIVERY_RUN_SEQ\" NUMBER(2,0), \n\t\"CLASSIFICATION\" VARCHAR2(1 CHAR), \n\t\"ORDER_ENTRY_END_TIME\" DATE, \n\t\"DEBIT_NO\" NUMBER(5,0), \n\t\"DEBIT_ATTEMPT\" NUMBER(2,0), \n\t\"TOTAL_PROFIT\" NUMBER(7,2), \n\t\"LOW_VAT\" NUMBER(7,2), \n\t\"TOTAL_DEPOSIT\" NUMBER(7,2), \n\t\"TOTAL_COST_PRICE\" NUMBER(7,2), \n\t\"TOTAL_DISCOUNT\" NUMBER(7,2), \n\t\"TOTAL_MIXED_VAT\" NUMBER(7,2), \n\t\"TOTAL_AMOUNT\" NUMBER(7,2), \n\t\"TOTAL_VAT\" NUMBER(7,2), \n\t\"TOTAL_PRICE\" NUMBER(7,2), \n\t\"TOTAL_PKG\" NUMBER(7,2), \n\t\"TOTAL_WEIGHT\" NUMBER(7,0), \n\t\"TOTAL_SIZE\" NUMBER(7,0), \n\t\"DELIVERY_RUN_SEQ_ORIG\" NUMBER(2,0), \n\t\"TOTAL_CORRECTION_AMOUNT_MEMO\" NUMBER(7,2), \n\t\"INTRO_PROMO_LOSS\" NUMBER(7,2), \n\t\"POS_LOG_TRANSACTION_NO\" NUMBER(7,0), \n\t\"BONUS_CARD_NO\" NUMBER(13,0), \n\t\"BONUS_POINT_BALANCE\" VARCHAR2(5 CHAR), \n\t\"THOP_ORDERPICKING_SYSTEM_FLG\" VARCHAR2(1 CHAR), \n\t\"CARD_AUTHORIZATION_NO\" VARCHAR2(6 CHAR), \n\t\"EURO_TO_GUILDER_DIFFERENCE\" NUMBER(10,5), \n\t\"GUILDER_TO_EURO_DIFFERENCE\" NUMBER(10,5), \n\t\"TIMES_OPENED_FROM_SUBMITTED\" NUMBER(5,0), \n\t\"DIFFERENCE_THOP_INVOICE_IN\" NUMBER(10,5), \n\t\"DIFFERENCE_THOP_INVOICE_OUT\" NUMBER(10,5), \n\t\"DIFFERENCE_THOP_ACCOUNTING\" NUMBER(10,5), \n\t\"ACSA_BATCH_NO\" NUMBER(6,0), \n\t\"AIRMILES_PROCESS_FLAG\" VARCHAR2(1 CHAR), \n\t\"PILO_NO\" NUMBER(6,0), \n\t\"ACCOUNT_NO\" VARCHAR2(16 CHAR), \n\t\"TOTAL_INCENTIVE_DISCOUNT\" NUMBER(7,2), \n\t\"RECALCULATE_FLG\" VARCHAR2(1 CHAR), \n\t\"SERVICE_CHARGE_DISCOUNT\" NUMBER(5,2), \n\t\"TOTAL_VAT_ORDER_LINE\" NUMBER(9,4), \n\t\"LOW_VAT_ORDER_LINE\" NUMBER(9,4), \n\t\"TOTAL_VAT_SERVICE_MEMO\" NUMBER(9,4), \n\t\"LOW_VAT_SERVICE_MEMO\" NUMBER(9,4), \n\t\"TOTAL_VAT_SERVICE_CHARGE\" NUMBER(9,4), \n\t\"LOW_VAT_SERVICE_CHARGE\" NUMBER(9,4), \n\t\"TOTAL_VAT_INCENTIVE_DISCOUNT\" NUMBER(9,4), \n\t\"LOW_VAT_INCENTIVE_DISCOUNT\" NUMBER(9,4), \n\t\"DELIVERY_START_TIME\" VARCHAR2(4 CHAR), \n\t\"DELIVERY_END_TIME\" VARCHAR2(4 CHAR), \n\t\"ARRIVAL_TIME\" VARCHAR2(4 CHAR), \n\t\"DEPARTURE_TIME\" VARCHAR2(4 CHAR), \n\t\"KM_SINCE_PREVIOUS_ORDER\" NUMBER(4,0), \n\t\"MINUTES_DROP\" NUMBER(4,0), \n\t\"ZIPCODE_EXTRA_NO\" NUMBER(8,0), \n\t\"DERU_NO_ROUTE_SCHEDULING\" NUMBER(10,0), \n\t\"WEIGHT_ROUTE_SCHEDULING\" NUMBER(6,0), \n\t\"PACKAGINGS_ROUTE_SCHEDULING\" NUMBER(6,0), \n\t\"DRIVING_MINUTES_SINCE_PREV_ORD\" NUMBER(4,0), \n\t\"WAIT_MINUTES_SINCE_PREV_ORD\" NUMBER(4,0), \n\t\"REASON_CODE_NOT_PLANNED\" NUMBER(2,0), \n\t\"DELIV_RUN_SEQ_ROUTE_SCHEDUL\" NUMBER(2,0), \n\t\"DELIV_START_TIME_ROUTE_SCHEDUL\" VARCHAR2(4 CHAR), \n\t\"DELIV_END_TIME_ROUTE_SCHEDUL\" VARCHAR2(4 CHAR), \n\t\"BREAK_MINUTES_SINCE_PREV_ORD\" NUMBER(4,0), \n\t\"INVOICE_VAT1_BASE\" NUMBER(7,2), \n\t\"INVOICE_VAT1_RATE\" NUMBER(5,2), \n\t\"INVOICE_VAT1\" NUMBER(7,2), \n\t\"INVOICE_VAT2_BASE\" NUMBER(7,2), \n\t\"INVOICE_VAT2_RATE\" NUMBER(5,2), \n\t\"INVOICE_VAT2\" NUMBER(7,2), \n\t\"INVOICE_VAT3_BASE\" NUMBER(7,2), \n\t\"INVOICE_VAT3_RATE\" NUMBER(5,2), \n\t\"INVOICE_VAT3\" NUMBER(7,2), \n\t\"SHOC_NO\" NUMBER(5,0) CONSTRAINT \"SYS_C0013346\" NOT NULL ENABLE, \n\t\"PRICE_DATE\" DATE, \n\t\"ASSORTMENT_DATE\" DATE, \n\t\"PAME_CODE\" VARCHAR2(10 CHAR), \n\t\"RECALC_AFTER_ORDERING_FLG\" VARCHAR2(1 CHAR), \n\t\"MULTIPLE_ITEMS_NUMBER\" NUMBER(5,0), \n\t\"CANCELLED_AFTER_PAYMENT_FLG\" VARCHAR2(1 CHAR), \n\t\"TOTAL_AMOUNT_DELIVERED\" NUMBER(7,2), \n\t\"AMOUNT_REFUND\" NUMBER(7,2), \n\t\"DATE_REFUND_CALCULATED\" DATE, \n\t\"PROCESS_STOCK_AVAIL_FLG\" VARCHAR2(1 CHAR), \n\t\"ORLI_CUST_SALES_PRICE_NON_INCE\" NUMBER(8,2), \n\t\"ORLI_VAT_NON_INCENT\" NUMBER(7,2), \n\t\"ORLI_COST_PRICE_NON_INCENT\" NUMBER(10,3), \n\t\"ORLI_LOGISTIC_COSTS_NON_INCENT\" NUMBER(10,5), \n\t\"PICKUP_TIME\" VARCHAR2(4 CHAR), \n\t\"TOTAL_VAT_PROMO_SALES_LOSS\" NUMBER(9,4), \n\t\"TOTAL_VAT_SERVICE_SURCHARGE\" NUMBER(9,4), \n\t\"TOTAL_VAT_DISCOUNT\" NUMBER(9,4), \n\t\"TOTAL_VAT_PRICE\" NUMBER(9,4), \n\t\"TOTAL_VAT_INTRO_PROMO_LOSS\" NUMBER(9,4), \n\t\"TOTAL_VAT_SERVICE_CHARGE_DISC\" NUMBER(9,4), \n\t\"CLEANUP_FLG\" VARCHAR2(1 CHAR), \n\t\"DATE_REVERSED_DIRECT_DEBIT\" DATE, \n\t\"INVOICE_NUMBER\" VARCHAR2(16 CHAR), \n\t\"DATE_INVOICED\" DATE, \n\t\"EXT_ORDERING_IDENTIFICATION\" VARCHAR2(30 CHAR), \n\t\"MISSING_OBD_FLG\" VARCHAR2(1 CHAR), \n\t\"ORDE_NO_MASTER\" NUMBER(10,0), \n\t\"DATE_CANCELLED_AT_SETTLEMENT\" DATE, \n\t\"EXT_ORDERING_AUTHORIZED_FLG\" VARCHAR2(1 CHAR), \n\t\"TRANSACTION_COMPLETE_FLG\" VARCHAR2(1 CHAR), \n\t\"EMPL_NO_CASHIER\" NUMBER(9,0), \n\t\"IBAN_EXCASSO\" VARCHAR2(34 CHAR), \n\t\"PICKUP_HOME_DELIVERY_FLG\" VARCHAR2(1 CHAR), \n\t\"B2B_FLG\" VARCHAR2(1 CHAR), \n\t\"MESSAGE_RECIPIENT\" VARCHAR2(4000 CHAR), \n\t\"LONGITUDE\" NUMBER(10,7), \n\t\"LATITUDE\" NUMBER(10,7), \n\t\"OFFERS_FINAL_FLG\" VARCHAR2(1 CHAR), \n\t\"ORDER_NOT_COMPLETE_FLG\" VARCHAR2(1 CHAR), \n\t\"OE_ERROR_FLG\" VARCHAR2(1 CHAR), \n\t\"CONTROL_CLUSTER\" VARCHAR2(30 CHAR), \n\t\"OE_PURCHASE_STAMPS_FLG\" VARCHAR2(1 CHAR), \n\t\"OPRO_NO\" NUMBER(10,0), \n\t\"PACKAGING_PLAN\" VARCHAR2(80 CHAR), \n\t\"METERS_SINCE_PREVIOUS_ORD\" NUMBER(10,2), \n\t\"DRIVING_SECONDS_SINCE_PREV_ORD\" NUMBER(6,0), \n\t\"TRIP_SEQ_NO\" NUMBER(2,0), \n\t\"CHECKSUM_BOFF\" VARCHAR2(400 CHAR), \n\t\"CHECKSUM_CWMS\" VARCHAR2(400 CHAR), \n\t\"EXTERNAL_ORDER_ID\" VARCHAR2(64 CHAR), \n\t\"PREPAID_FLG\" VARCHAR2(1 CHAR), \n\t\"EXTERNAL_SHLO_NO\" NUMBER(6,0), \n\t\"EXTERNAL_DELIVERY_RUN_ID\" NUMBER(10,0), \n\t\"EXTERNAL_DELIVERY_RUN_SEQ\" NUMBER(2,0), \n\t\"FIRST_ORDER_FLG\" VARCHAR2(1 CHAR), \n\t CONSTRAINT \"BOFF_ORDE_CK35\" CHECK (\n /* QMS */\n MISSING_OBD_FLG in ('Y'\n )\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK1\" CHECK ( /* QMS */ ORCT_CODE = UPPER(ORCT_CODE) ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK11\" CHECK ( DELIVERY_RUN_SEQ > 0 ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK12\" CHECK ( DELIVERY_RUN_SEQ_ORIG > 0 ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK13\" CHECK ( /* QMS */ AIRMILES_PROCESS_FLAG in ('Y' ) ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK15\" CHECK (\n /* QMS */\n RECALCULATE_FLG = UPPER(RECALCULATE_FLG)\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK16\" CHECK (\n KM_SINCE_PREVIOUS_ORDER >=0\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK17\" CHECK (\n MINUTES_DROP >= 0\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK18\" CHECK (\n house_no >= 0\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK19\" CHECK (\n PACKAGINGS_ROUTE_SCHEDULING >= 0\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK20\" CHECK (\n DRIVING_MINUTES_SINCE_PREV_ORD >= 0\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK21\" CHECK (\n WAIT_MINUTES_SINCE_PREV_ORD >= 0\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK22\" CHECK (\n BREAK_MINUTES_SINCE_PREV_ORD >= 0\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK23\" CHECK (\n /* QMS */\n RECALC_AFTER_ORDERING_FLG in ('Y'\n , 'N'\n )\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK24\" CHECK (\n /* QMS */\n PAME_CODE = UPPER(PAME_CODE)\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK25\" CHECK (\n /* QMS */\n RECALC_AFTER_ORDERING_FLG = UPPER(RECALC_AFTER_ORDERING_FLG)\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK3\" CHECK ( /* QMS */ STCO_STTY_CODE = UPPER(STCO_STTY_CODE) ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK31\" CHECK (\n /* QMS */\n CANCELLED_AFTER_PAYMENT_FLG in ('Y'\n )\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK32\" CHECK (\n /* QMS */\n CANCELLED_AFTER_PAYMENT_FLG = UPPER(CANCELLED_AFTER_PAYMENT_FLG)\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK33\" CHECK (\n /* QMS */\n CLEANUP_FLG in ('Y'\n )\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK34\" CHECK (\n /* QMS */\n CLEANUP_FLG = UPPER(CLEANUP_FLG)\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK4\" CHECK ( /* QMS */ STAT_CODE = UPPER(STAT_CODE) ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK6\" CHECK ( /* QMS */ DELIVERY_ADDRESS = UPPER(DELIVERY_ADDRESS) ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK7\" CHECK ( /* QMS */ DELIVERY_ADDRESS in ('H' , 'P' , 'O' , 'L' ) ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK8\" CHECK ( /* QMS */ STCO_CODE = UPPER(STCO_CODE) ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK9\" CHECK ( /* QMS */ CUQC_CODE = UPPER(CUQC_CODE) ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK10\" CHECK ( /* QMS */ DESH_CODE = UPPER(DESH_CODE) ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK36\" CHECK (\n /* QMS$ENFORCE_UPPER_CASE_EXT_ORDERING_AUTHORIZED_FLG */\n EXT_ORDERING_AUTHORIZED_FLG = UPPER(EXT_ORDERING_AUTHORIZED_FLG)\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK37\" CHECK ( -- QMS$ENFORCE_HARD_DOMAIN_TRANSACTION_COMPLETE_FLG\n transaction_complete_flg in ('Y','N')\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK38\" CHECK (\n -- QMS$ENFORCE_UPPER_CASE_IBAN_EXCASSO\n IBAN_EXCASSO = UPPER(IBAN_EXCASSO)\n ) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK39\" CHECK (pickup_home_delivery_flg in ('Y')) ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CK40\" CHECK ( oe_error_flg in ( 'Y' ) ) ENABLE NOVALIDATE, \n\t CONSTRAINT \"BOFF_ORDE_CK41\" CHECK ( oe_purchase_stamps_flg in ( 'Y','N') ) ENABLE NOVALIDATE, \n\t CONSTRAINT \"BOFF_ORDE_CK2\" CHECK (\n -- QMS$ENFORCE_UPPER_CASE_ZIPCODE_EXTRA\n ZIPCODE_EXTRA = UPPER(ZIPCODE_EXTRA)\n or\n zipcode_extra is null\n ) ENABLE, \n\t CONSTRAINT \"ENSURE_JSON_B\" CHECK (CHECKSUM_BOFF is JSON) ENABLE, \n\t CONSTRAINT \"ENSURE_JSON_C\" CHECK (CHECKSUM_CWMS is JSON) ENABLE, \n\t SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS, \n\t SUPPLEMENTAL LOG DATA (ALL) COLUMNS, \n\t CONSTRAINT \"BOFF_ORDE_ZIPC_FK1\" FOREIGN KEY (\"ZIPC_NO\")\n\t REFERENCES \"P1BOFF\".\"BOFF_ZIPCODE\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CUQC_FK1\" FOREIGN KEY (\"CUQC_CODE\")\n\t REFERENCES \"P1BOFF\".\"BOFF_CUSTOMER_QUALITY_CTRL\" (\"CODE\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_STAT_FK1\" FOREIGN KEY (\"STAT_CODE\")\n\t REFERENCES \"P1BOFF\".\"BOFF_STATE\" (\"CODE\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_SHOC_FK1\" FOREIGN KEY (\"SHOC_NO\")\n\t REFERENCES \"P1BOFF\".\"BOFF_SHOPPING_CART\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_POSL_FK1\" FOREIGN KEY (\"POSL_NO\")\n\t REFERENCES \"P1BOFF\".\"BOFF_POSLOG\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_PILO_FK1\" FOREIGN KEY (\"PILO_NO\")\n\t REFERENCES \"P1BOFF\".\"BOFF_LOCATION_PICKUP\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_ORCT_FK1\" FOREIGN KEY (\"ORCT_CODE\")\n\t REFERENCES \"P1BOFF\".\"BOFF_ORDER_CHARGE_TYPE\" (\"CODE\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_MUCO_FK1\" FOREIGN KEY (\"MUCO_NO\")\n\t REFERENCES \"P1BOFF\".\"BOFF_MODIFICATION_CODE\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_EMPL_FK2\" FOREIGN KEY (\"EMPL_NO_ORDER_ENTRY\")\n\t REFERENCES \"P1BOFF\".\"BOFF_EMPLOYEE\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_EMPL_FK1\" FOREIGN KEY (\"EMPL_NO_CHANGED\")\n\t REFERENCES \"P1BOFF\".\"BOFF_EMPLOYEE\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_DERU_FK2\" FOREIGN KEY (\"DERU_NO\")\n\t REFERENCES \"P1BOFF\".\"BOFF_DELIVERY_RUN\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_DERU_FK1\" FOREIGN KEY (\"DERU_NO_ORIG\")\n\t REFERENCES \"P1BOFF\".\"BOFF_DELIVERY_RUN\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_DELO_FK1\" FOREIGN KEY (\"DELO_NO\")\n\t REFERENCES \"P1BOFF\".\"BOFF_LOCATION_DELIVERY\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_DEDA_FK1\" FOREIGN KEY (\"DEDA_DATE\", \"DESH_CODE\", \"DELO_NO\", \"PILO_NO\")\n\t REFERENCES \"P1BOFF\".\"BOFF_DELIVERY_DATE\" (\"DATE_DELIVERY\", \"DESH_CODE\", \"DELO_NO\", \"PILO_NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_CUST_FK1\" FOREIGN KEY (\"CUST_NO\")\n\t REFERENCES \"P1BOFF\".\"BOFF_CUSTOMER\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_STCO_FK1\" FOREIGN KEY (\"STCO_CODE\", \"STCO_STTY_CODE\")\n\t REFERENCES \"P1BOFF\".\"BOFF_STATUS_CODE\" (\"CODE\", \"STTY_CODE\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_ORDE_FK1\" FOREIGN KEY (\"ORDE_NO_MASTER\")\n\t REFERENCES \"P1BOFF\".\"BOFF_ORDER\" (\"NO\") ENABLE, \n\t CONSTRAINT \"BOFF_ORDE_EMPL_FK4\" FOREIGN KEY (\"EMPL_NO_CASHIER\")\n\t REFERENCES \"P1BOFF\".\"BOFF_EMPLOYEE\" (\"NO\") ENABLE\n ) ;\n CREATE UNIQUE INDEX \"P1BOFF\".\"BOFF_ORDE_PK\" ON \"P1BOFF\".\"BOFF_ORDER\" (\"NO\") \n ;\nALTER TABLE \"P1BOFF\".\"BOFF_ORDER\" ADD CONSTRAINT \"BOFF_ORDE_PK\" PRIMARY KEY (\"NO\")\n USING INDEX \"P1BOFF\".\"BOFF_ORDE_PK\" ENABLE;", "tableChanges": [ { "type": "CREATE", "id": "\"PECBOFF3\".\"P1BOFF\".\"BOFF_ORDER\"", "table": { "defaultCharsetName": null, "primaryKeyColumnNames": [ "NO" ], "columns": [ { "name": "NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 0, "position": 1, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "CUST_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 0, "position": 2, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "ORCT_CODE", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 2, "position": 3, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "ZIPC_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 0, "position": 4, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "STAT_CODE", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 2, "position": 5, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "STCO_STTY_CODE", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 6, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "STCO_CODE", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 3, "position": 7, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "ORME_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 2, "scale": 0, "position": 8, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "DELO_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 4, "scale": 0, "position": 9, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "MUCO_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 4, "scale": 0, "position": 10, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DERU_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 0, "position": 11, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DERU_NO_ORIG", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 0, "position": 12, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "POSL_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 0, "position": 13, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "defaultValueExpression": "0", "enumValues": [] }, { "name": "DEDA_DATE", "jdbcType": 93, "typeName": "DATE", "typeExpression": "DATE", "charsetName": null, "position": 14, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DESH_CODE", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 2, "position": 15, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "CUQC_CODE", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 3, "position": 16, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "EMPL_NO_ORDER_ENTRY", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 0, "position": 17, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "EMPL_NO_CHANGED", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 0, "position": 18, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DELIVERY_ADDRESS", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 19, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "HOUSE_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 0, "position": 20, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "STREET", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 80, "position": 21, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "CITY", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 80, "position": 22, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "ORDER_ENTRY_DATE", "jdbcType": 93, "typeName": "DATE", "typeExpression": "DATE", "charsetName": null, "position": 23, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "DATE_CHANGED", "jdbcType": 93, "typeName": "DATE", "typeExpression": "DATE", "charsetName": null, "position": 24, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ZIPCODE_EXTRA", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 4, "position": 25, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "PROMO_SALES_LOSS", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 26, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "SERVICE_CHARGE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 2, "position": 27, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "E_MAIL", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 50, "position": 28, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "SERVICE_SURCHARGE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 2, "position": 29, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ORDER_ENTRY_START_TIME", "jdbcType": 93, "typeName": "DATE", "typeExpression": "DATE", "charsetName": null, "position": 30, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DELIVERY_EXTRA_SPECS", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 256, "position": 31, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "HOUSE_NO_EXTRA", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 10, "position": 32, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DELIVERY_RUN_SEQ", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 2, "scale": 0, "position": 33, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "CLASSIFICATION", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 34, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ORDER_ENTRY_END_TIME", "jdbcType": 93, "typeName": "DATE", "typeExpression": "DATE", "charsetName": null, "position": 35, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DEBIT_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 0, "position": 36, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DEBIT_ATTEMPT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 2, "scale": 0, "position": 37, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_PROFIT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 38, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "LOW_VAT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 39, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_DEPOSIT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 40, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_COST_PRICE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 41, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_DISCOUNT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 42, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_MIXED_VAT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 43, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_AMOUNT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 44, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_VAT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 45, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_PRICE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 46, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_PKG", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 47, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_WEIGHT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 0, "position": 48, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_SIZE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 0, "position": 49, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DELIVERY_RUN_SEQ_ORIG", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 2, "scale": 0, "position": 50, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_CORRECTION_AMOUNT_MEMO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 51, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "INTRO_PROMO_LOSS", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 52, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "POS_LOG_TRANSACTION_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 0, "position": 53, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "BONUS_CARD_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 13, "scale": 0, "position": 54, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "BONUS_POINT_BALANCE", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 5, "position": 55, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "THOP_ORDERPICKING_SYSTEM_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 56, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "CARD_AUTHORIZATION_NO", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 6, "position": 57, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "EURO_TO_GUILDER_DIFFERENCE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 5, "position": 58, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "GUILDER_TO_EURO_DIFFERENCE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 5, "position": 59, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TIMES_OPENED_FROM_SUBMITTED", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 0, "position": 60, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DIFFERENCE_THOP_INVOICE_IN", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 5, "position": 61, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DIFFERENCE_THOP_INVOICE_OUT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 5, "position": 62, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DIFFERENCE_THOP_ACCOUNTING", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 5, "position": 63, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ACSA_BATCH_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 6, "scale": 0, "position": 64, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "AIRMILES_PROCESS_FLAG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 65, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "PILO_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 6, "scale": 0, "position": 66, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ACCOUNT_NO", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 16, "position": 67, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_INCENTIVE_DISCOUNT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 68, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "RECALCULATE_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 69, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "SERVICE_CHARGE_DISCOUNT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 2, "position": 70, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_VAT_ORDER_LINE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 71, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "LOW_VAT_ORDER_LINE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 72, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_VAT_SERVICE_MEMO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 73, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "LOW_VAT_SERVICE_MEMO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 74, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_VAT_SERVICE_CHARGE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 75, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "LOW_VAT_SERVICE_CHARGE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 76, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_VAT_INCENTIVE_DISCOUNT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 77, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "LOW_VAT_INCENTIVE_DISCOUNT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 78, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DELIVERY_START_TIME", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 4, "position": 79, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DELIVERY_END_TIME", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 4, "position": 80, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ARRIVAL_TIME", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 4, "position": 81, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DEPARTURE_TIME", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 4, "position": 82, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "KM_SINCE_PREVIOUS_ORDER", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 4, "scale": 0, "position": 83, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "MINUTES_DROP", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 4, "scale": 0, "position": 84, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ZIPCODE_EXTRA_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 8, "scale": 0, "position": 85, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DERU_NO_ROUTE_SCHEDULING", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 0, "position": 86, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "WEIGHT_ROUTE_SCHEDULING", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 6, "scale": 0, "position": 87, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "PACKAGINGS_ROUTE_SCHEDULING", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 6, "scale": 0, "position": 88, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DRIVING_MINUTES_SINCE_PREV_ORD", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 4, "scale": 0, "position": 89, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "WAIT_MINUTES_SINCE_PREV_ORD", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 4, "scale": 0, "position": 90, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "REASON_CODE_NOT_PLANNED", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 2, "scale": 0, "position": 91, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DELIV_RUN_SEQ_ROUTE_SCHEDUL", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 2, "scale": 0, "position": 92, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DELIV_START_TIME_ROUTE_SCHEDUL", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 4, "position": 93, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DELIV_END_TIME_ROUTE_SCHEDUL", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 4, "position": 94, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "BREAK_MINUTES_SINCE_PREV_ORD", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 4, "scale": 0, "position": 95, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "INVOICE_VAT1_BASE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 96, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "INVOICE_VAT1_RATE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 2, "position": 97, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "INVOICE_VAT1", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 98, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "INVOICE_VAT2_BASE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 99, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "INVOICE_VAT2_RATE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 2, "position": 100, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "INVOICE_VAT2", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 101, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "INVOICE_VAT3_BASE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 102, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "INVOICE_VAT3_RATE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 2, "position": 103, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "INVOICE_VAT3", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 104, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "SHOC_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 0, "position": 105, "optional": false, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": false, "enumValues": [] }, { "name": "PRICE_DATE", "jdbcType": 93, "typeName": "DATE", "typeExpression": "DATE", "charsetName": null, "position": 106, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ASSORTMENT_DATE", "jdbcType": 93, "typeName": "DATE", "typeExpression": "DATE", "charsetName": null, "position": 107, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "PAME_CODE", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 10, "position": 108, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "RECALC_AFTER_ORDERING_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 109, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "MULTIPLE_ITEMS_NUMBER", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 5, "scale": 0, "position": 110, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "CANCELLED_AFTER_PAYMENT_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 111, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_AMOUNT_DELIVERED", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 112, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "AMOUNT_REFUND", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 113, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DATE_REFUND_CALCULATED", "jdbcType": 93, "typeName": "DATE", "typeExpression": "DATE", "charsetName": null, "position": 114, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "PROCESS_STOCK_AVAIL_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 115, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ORLI_CUST_SALES_PRICE_NON_INCE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 8, "scale": 2, "position": 116, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ORLI_VAT_NON_INCENT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 7, "scale": 2, "position": 117, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ORLI_COST_PRICE_NON_INCENT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 3, "position": 118, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ORLI_LOGISTIC_COSTS_NON_INCENT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 5, "position": 119, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "PICKUP_TIME", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 4, "position": 120, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_VAT_PROMO_SALES_LOSS", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 121, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_VAT_SERVICE_SURCHARGE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 122, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_VAT_DISCOUNT", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 123, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_VAT_PRICE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 124, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_VAT_INTRO_PROMO_LOSS", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 125, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TOTAL_VAT_SERVICE_CHARGE_DISC", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 4, "position": 126, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "CLEANUP_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 127, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DATE_REVERSED_DIRECT_DEBIT", "jdbcType": 93, "typeName": "DATE", "typeExpression": "DATE", "charsetName": null, "position": 128, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "INVOICE_NUMBER", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 16, "position": 129, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DATE_INVOICED", "jdbcType": 93, "typeName": "DATE", "typeExpression": "DATE", "charsetName": null, "position": 130, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "EXT_ORDERING_IDENTIFICATION", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 30, "position": 131, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "MISSING_OBD_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 132, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ORDE_NO_MASTER", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 0, "position": 133, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DATE_CANCELLED_AT_SETTLEMENT", "jdbcType": 93, "typeName": "DATE", "typeExpression": "DATE", "charsetName": null, "position": 134, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "EXT_ORDERING_AUTHORIZED_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 135, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TRANSACTION_COMPLETE_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 136, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "EMPL_NO_CASHIER", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 9, "scale": 0, "position": 137, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "IBAN_EXCASSO", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 34, "position": 138, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "PICKUP_HOME_DELIVERY_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 139, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "B2B_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 140, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "MESSAGE_RECIPIENT", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 4000, "position": 141, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "LONGITUDE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 7, "position": 142, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "LATITUDE", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 7, "position": 143, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "OFFERS_FINAL_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 144, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "ORDER_NOT_COMPLETE_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 145, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "OE_ERROR_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 146, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "CONTROL_CLUSTER", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 30, "position": 147, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "OE_PURCHASE_STAMPS_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 148, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "OPRO_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 0, "position": 149, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "PACKAGING_PLAN", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 80, "position": 150, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "METERS_SINCE_PREVIOUS_ORD", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 2, "position": 151, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "DRIVING_SECONDS_SINCE_PREV_ORD", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 6, "scale": 0, "position": 152, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "TRIP_SEQ_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 2, "scale": 0, "position": 153, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "CHECKSUM_BOFF", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 400, "position": 154, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "CHECKSUM_CWMS", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 400, "position": 155, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "EXTERNAL_ORDER_ID", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 64, "position": 156, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "PREPAID_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 157, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "EXTERNAL_SHLO_NO", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 6, "scale": 0, "position": 158, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "EXTERNAL_DELIVERY_RUN_ID", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 10, "scale": 0, "position": 159, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "EXTERNAL_DELIVERY_RUN_SEQ", "jdbcType": 2, "typeName": "NUMBER", "typeExpression": "NUMBER", "charsetName": null, "length": 2, "scale": 0, "position": 160, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] }, { "name": "FIRST_ORDER_FLG", "jdbcType": 12, "typeName": "VARCHAR2", "typeExpression": "VARCHAR2", "charsetName": null, "length": 1, "position": 161, "optional": true, "autoIncremented": false, "generated": false, "comment": null, "hasDefaultValue": true, "enumValues": [] } ], "attributes": [] }, "comment": null } ] }