+------+----------------+---+---------+----------+-------------+-------------+-------------------+---------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+--------+ |STATUS|USERNAME |CSF|SEG_OWNER|TABLE_NAME|SCN |COMMIT_SCN |TIMESTAMP |OPERATION|ROLLBACK|SQL_REDO |XID |SESSION#| +------+----------------+---+---------+----------+-------------+-------------+-------------------+---------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+--------+ |0 |MQXABAT |0 |null |null |7590034236001|7590034236001|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001E006A54CE03|1083 | |0 |MQXABAT |0 |null |null |7590034236003|7590034236003|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001400FEE0CC03|1083 | |0 |MQXABAT |0 |null |null |7590034236005|7590034236005|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000C00CD4DCC03|1083 | |0 |MQXABAT |0 |null |null |7590034236007|7590034236007|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000500894CCE03|1083 | |0 |MQXABAT |0 |null |null |7590034236009|7590034236009|2023-10-05 20:26:32|COMMIT |0 |commit |0x180015000237CD03|1083 | |0 |MQXABAT |0 |null |null |7590034236010|7590034236010|2023-10-05 20:26:32|COMMIT |0 |commit |0x11000400A5EB3E04|990 | |0 |MQXABAT |0 |null |null |7590034236012|7590034236012|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001100295DCE03|1083 | |0 |UNKNOWN |1 |P1BOFF |BOFF_ORDER|7590034236013|null |2023-10-05 20:26:32|UPDATE |0 |update "P1BOFF"."BOFF_ORDER" set "NO" = NULL, "CUST_NO" = NULL, "ORCT_CODE" = NULL, "ZIPC_NO" = NULL, "STAT_CODE" = NULL, "STCO_STTY_CODE" = NULL, "STCO_CODE" = NULL, "ORME_NO" = NULL, "DELO_NO" = NULL, "MUCO_NO" = NULL, "DERU_NO" = NULL, "DERU_NO_ORIG" = NULL, "POSL_NO" = NULL, "DEDA_DATE" = NULL, "DESH_CODE" = NULL, "CUQC_CODE" = NULL, "EMPL_NO_ORDER_ENTRY" = NULL, "EMPL_NO_CHANGED" = NULL, "DELIVERY_ADDRESS" = NULL, "HOUSE_NO" = NULL, "STREET" = NULL, "CITY" = NULL, "ORDER_ENTRY_DATE" = NULL, "DATE_CHANGED" = NULL, "ZIPCODE_EXTRA" = NULL, "PROMO_SALES_LOSS" = NULL, "SERVICE_CHARGE" = NULL, "E_MAIL" = NULL, "SERVICE_SURCHARGE" = NULL, "ORDER_ENTRY_START_TIME" = NULL, "DELIVERY_EXTRA_SPECS" = NULL, "HOUSE_NO_EXTRA" = NULL, "DELIVERY_RUN_SEQ" = NULL, "CLASSIFICATION" = NULL, "ORDER_ENTRY_END_TIME" = NULL, "DEBIT_NO" = NULL, "DEBIT_ATTEMPT" = NULL, "TOTAL_PROFIT" = NULL, "LOW_VAT" = NULL, "TOTAL_DEPOSIT" = NULL, "TOTAL_COST_PRICE" = NULL, "TOTAL_DISCOUNT" = NULL, "TOTAL_MIXED_VAT" = NULL, "TOTAL_AMOUNT" = NULL, "TOTAL_VAT" = NULL, "TOTAL_PRICE" = NULL, "TOTAL_PKG" = NULL, "TOTAL_WEIGHT" = NULL, "TOTAL_SIZE" = NULL, "DELIVERY_RUN_SEQ_ORIG" = NULL, "TOTAL_CORRECTION_AMOUNT_MEMO" = NULL, "INTRO_PROMO_LOSS" = NULL, "POS_LOG_TRANSACTION_NO" = NULL, "BONUS_CARD_NO" = NULL, "BONUS_POINT_BALANCE" = NULL, "THOP_ORDERPICKING_SYSTEM_FLG" = NULL, "CARD_AUTHORIZATION_NO" = NULL, "EURO_TO_GUILDER_DIFFERENCE" = NULL, "GUILDER_TO_EURO_DIFFERENCE" = NULL, "TIMES_OPENED_FROM_SUBMITTED" = NULL, "DIFFERENCE_THOP_INVOICE_IN" = NULL, "DIFFERENCE_THOP_INVOICE_OUT" = NULL, "DIFFERENCE_THOP_ACCOUNTING" = NULL, "ACSA_BATCH_NO" = NULL, "AIRMILES_PROCESS_FLAG" = NULL, "PILO_NO" = NULL, "ACCOUNT_NO" = NULL, "TOTAL_INCENTIVE_DISCOUNT" = NULL, "RECALCULATE_FLG" = NULL, "SERVICE_CHARGE_DISCOUNT" = NULL, "TOTAL_VAT_ORDER_LINE" = NULL, "LOW_VAT_ORDER_LINE" = NULL, "TOTAL_VAT_SERVICE_MEMO" = NULL, "LOW_VAT_SERVICE_MEMO" = NULL, "TOTAL_VAT_SERVICE_CHARGE" = NULL, "LOW_VAT_SERVICE_CHARGE" = NULL, "TOTAL_VAT_INCENTIVE_DISCOUNT" = NULL, "LOW_VAT_INCENTIVE_DISCOUNT" = NULL, "DELIVERY_START_TIME" = NULL, "DELIVERY_END_TIME" = NULL, "ARRIVAL_TIME" = NULL, "DEPARTURE_TIME" = NULL, "KM_SINCE_PREVIOUS_ORDER" = NULL, "MINUTES_DROP" = NULL, "ZIPCODE_EXTRA_NO" = NULL, "DERU_NO_ROUTE_SCHEDULING" = NULL, "WEIGHT_ROUTE_SCHEDULING" = NULL, "PACKAGINGS_ROUTE_SCHEDULING" = NULL, "DRIVING_MINUTES_SINCE_PREV_ORD" = NULL, "WAIT_MINUTES_SINCE_PREV_ORD" = NULL, "REASON_CODE_NOT_PLANNED" = NULL, "DELIV_RUN_SEQ_ROUTE_SCHEDUL" = NULL, "DELIV_START_TIME_ROUTE_SCHEDUL" = NULL, "DELIV_END_TIME_ROUTE_SCHEDUL" = NULL, "BREAK_MINUTES_SINCE_PREV_ORD" = NULL, "INVOICE_VAT1_BASE" = NULL, "INVOICE_VAT1_RATE" = NULL, "INVOICE_VAT1" = NULL, "INVOICE_VAT2_BASE" = NULL, "INVOICE_VAT2_RATE" = NULL, "INVOICE_VAT2" = NULL, "INVOICE_VAT3_BASE" = NULL, "INVOICE_VAT3_RATE" = NULL, "INVOICE_VAT3" = NULL, "SHOC_NO" = NULL, "PRICE_DATE" = NULL, "ASSORTMENT_DATE" = NULL, "PAME_CODE" = NULL, "RECALC_AFTER_ORDERING_FLG" = NULL, "MULTIPLE_ITEMS_NUMBER" = NULL, "CANCELLED_AFTER_PAYMENT_FLG" = NULL, "TOTAL_AMOUNT_DELIVERED" = NULL, "AMOUNT_REFUND" = NULL, "DATE_REFUND_CALCULATED" = NULL, "PROCESS_STOCK_AVAIL_FLG" = NULL, "ORLI_CUST_SALES_PRICE_NON_INCE" = NULL, "ORLI_VAT_NON_INCENT" = NULL, "ORLI_COST_PRICE_NON_INCENT" = NULL, "ORLI_LOGISTIC_COSTS_NON_INCENT" = NULL, "PICKUP_TIME" = NULL, "TOTAL_VAT_PROMO_SALES_LOSS" = NULL, "TOTAL_VAT_SERVICE_SURCHARGE" = NULL, "TOTAL_VAT_DISCOUNT" = NULL, "TOTAL_VAT_PRICE" = NULL, "TOTAL_VAT_INTRO_PROMO_LOSS" = NULL, "TOTAL_VAT_SERVICE_CHARGE_DISC" = NULL, "CLEANUP_FLG" = NULL, "DATE_REVERSED_DIRECT_DEBIT" = NULL, "INVOICE_NUMBER" = NULL, "DATE_INVOICED" = NULL, "EXT_ORDERING_IDENTIFICATION" = NULL, "MISSING_OBD_FLG" = NULL, "ORDE_NO_MASTER" = NULL, "DATE_CANCELLED_AT_SETTLEMENT" = NULL, "EXT_ORDERING_AUTHORIZED_FLG" = NULL, "TRANSACTION_COMPLETE_FLG" = NULL, "EMPL_NO_CASHIER" = NULL, "IBAN_EXCASSO" = NULL, "PICKUP_HOME_DELIVERY_FLG" = NULL, "B2B_FLG" = NULL, "MESSAGE_RECIPIENT" = |0x2C0016002C70DD02|0 | |0 |UNKNOWN |1 |P1BOFF |BOFF_ORDER|7590034236013|null |2023-10-05 20:26:32|UPDATE |0 |NULL, "LONGITUDE" = NULL, "LATITUDE" = NULL, "OFFERS_FINAL_FLG" = NULL, "ORDER_NOT_COMPLETE_FLG" = NULL, "OE_ERROR_FLG" = NULL, "CONTROL_CLUSTER" = NULL, "OE_PURCHASE_STAMPS_FLG" = NULL, "OPRO_NO" = NULL, "PACKAGING_PLAN" = NULL, "METERS_SINCE_PREVIOUS_ORD" = NULL, "DRIVING_SECONDS_SINCE_PREV_ORD" = NULL, "TRIP_SEQ_NO" = NULL, "CHECKSUM_BOFF" = NULL, "CHECKSUM_CWMS" = NULL where "NO" = 65649259 and "CUST_NO" = 6778668 and "ORCT_CODE" = '0' and "ZIPC_NO" = 7227 and "STAT_CODE" = 'GD' and "STCO_STTY_CODE" = 'O' and "STCO_CODE" = '47' and "ORME_NO" = 28 and "DELO_NO" = 8953 and "MUCO_NO" IS NULL and "DERU_NO" = 15965069 and "DERU_NO_ORIG" = 15965069 and "POSL_NO" = 0 and "DEDA_DATE" = TIMESTAMP ' 2023-10-05 00:00:00' and "DESH_CODE" = '2K' and "CUQC_CODE" = '0' and "EMPL_NO_ORDER_ENTRY" = 19132 and "EMPL_NO_CHANGED" = 19132 and "DELIVERY_ADDRESS" = 'H' and "HOUSE_NO" = 14 and "STREET" = 'Beekstraat' and "CITY" = 'TOLDIJK' and "ORDER_ENTRY_DATE" = TIMESTAMP ' 2023-10-04 00:00:00' and "DATE_CHANGED" = TIMESTAMP ' 2023-10-04 14:29:36' and "ZIPCODE_EXTRA" = 'NC' and "PROMO_SALES_LOSS" = 0 and "SERVICE_CHARGE" = 0 and "E_MAIL" = 'marijepelsrijcken@gmail.com' and "SERVICE_SURCHARGE" IS NULL and "ORDER_ENTRY_START_TIME" = TIMESTAMP ' 2023-10-04 13:27:05' and "DELIVERY_EXTRA_SPECS" IS NULL and "HOUSE_NO_EXTRA" IS NULL and "DELIVERY_RUN_SEQ" = 24 and "CLASSIFICATION" IS NULL and "ORDER_ENTRY_END_TIME" = TIMESTAMP ' 2023-10-04 14:29:36' and "DEBIT_NO" IS NULL and "DEBIT_ATTEMPT" IS NULL and "TOTAL_PROFIT" = 0 and "LOW_VAT" IS NULL and "TOTAL_DEPOSIT" = .25 and "TOTAL_COST_PRICE" = 34.76 and "TOTAL_DISCOUNT" = 0 and "TOTAL_MIXED_VAT" IS NULL and "TOTAL_AMOUNT" = 56.84 and "TOTAL_VAT" IS NULL and "TOTAL_PRICE" = 51.59 and "TOTAL_PKG" = 5 and "TOTAL_WEIGHT" IS NULL and "TOTAL_SIZE" IS NULL and "DELIVERY_RUN_SEQ_ORIG" = 24 and "TOTAL_CORRECTION_AMOUNT_MEMO" = 0 and "INTRO_PROMO_LOSS" = 0 and "POS_LOG_TRANSACTION_NO" IS NULL and "BONUS_CARD_NO" = 2622243752959 and "BONUS_POINT_BALANCE" IS NULL and "THOP_ORDERPICKING_SYSTEM_FLG" IS NULL and "CARD_AUTHORIZATION_NO" IS NULL and "EURO_TO_GUILDER_DIFFERENCE" IS NULL and "GUILDER_TO_EURO_DIFFERENCE" IS NULL and "TIMES_OPENED_FROM_SUBMITTED" = 1 and "DIFFERENCE_THOP_INVOICE_IN" IS NULL and "DIFFERENCE_THOP_INVOICE_OUT" IS NULL and "DIFFERENCE_THOP_ACCOUNTING" IS NULL and "ACSA_BATCH_NO" IS NULL and "AIRMILES_PROCESS_FLAG" IS NULL and "PILO_NO" IS NULL and "ACCOUNT_NO" IS NULL and "TOTAL_INCENTIVE_DISCOUNT" = 0 and "RECALCULATE_FLG" IS NULL and "SERVICE_CHARGE_DISCOUNT" = 0 and "TOTAL_VAT_ORDER_LINE" IS NULL and "LOW_VAT_ORDER_LINE" IS NULL and "TOTAL_VAT_SERVICE_MEMO" IS NULL and "LOW_VAT_SERVICE_MEMO" IS NULL and "TOTAL_VAT_SERVICE_CHARGE" IS NULL and "LOW_VAT_SERVICE_CHARGE" IS NULL and "TOTAL_VAT_INCENTIVE_DISCOUNT" IS NULL and "LOW_VAT_INCENTIVE_DISCOUNT" IS NULL and "DELIVERY_START_TIME" = '1800' and "DELIVERY_END_TIME" = '2200' and "ARRIVAL_TIME" = '2113' and "DEPARTURE_TIME" = '2119' and "KM_SINCE_PREVIOUS_ORDER" = 5 and "MINUTES_DROP" = 5 and "ZIPCODE_EXTRA_NO" = 977843 and "DERU_NO_ROUTE_SCHEDULING" = 15965069 and "WEIGHT_ROUTE_SCHEDULING" = 8 and "PACKAGINGS_ROUTE_SCHEDULING" = 9 and "DRIVING_MINUTES_SINCE_PREV_ORD" = 8 and "WAIT_MINUTES_SINCE_PREV_ORD" = 0 and "REASON_CODE_NOT_PLANNED" IS NULL and "DELIV_RUN_SEQ_ROUTE_SCHEDUL" = 24 and "DELIV_START_TIME_ROUTE_SCHEDUL" = '1758' and "DELIV_END_TIME_ROUTE_SCHEDUL" = '2154' and "BREAK_MINUTES_SINCE_PREV_ORD" = 0 and "INVOICE_VAT1_BASE" IS NULL and "INVOICE_VAT1_RATE" IS NULL and "INVOICE_VAT1" IS NULL and "INVOICE_VAT2_BASE" IS NULL and "INVOICE_VAT2_RATE" IS NULL and "INVOICE_VAT2" IS NULL and "INVOICE_VAT3_BASE" IS NULL and "INVOICE_VAT3_RATE" IS NULL and "INVOICE_VAT3" IS NULL and "SHOC_NO" = 1 and "PRICE_DATE" = TIMESTAMP ' 2023-10-05 00:00:00' and "ASSORTMENT_DATE" = TIMESTAMP ' 2023-10-05 00:00:00' and "PAME_CODE" = 'DELIVERY' and "RECALC_AFTER_ORDERING_FLG" = 'Y' and "MULTIPLE_ITEMS_NUMBER" IS NULL and "CANCELLED_AFTER_PAYMENT_FLG" IS NU|0x2C0016002C70DD02|0 | |0 |UNKNOWN |0 |P1BOFF |BOFF_ORDER|7590034236013|null |2023-10-05 20:26:32|UPDATE |0 |LL and "TOTAL_AMOUNT_DELIVERED" IS NULL and "AMOUNT_REFUND" IS NULL and "DATE_REFUND_CALCULATED" IS NULL and "PROCESS_STOCK_AVAIL_FLG" IS NULL and "ORLI_CUST_SALES_PRICE_NON_INCE" = 51.59 and "ORLI_VAT_NON_INCENT" IS NULL and "ORLI_COST_PRICE_NON_INCENT" = 34.759 and "ORLI_LOGISTIC_COSTS_NON_INCENT" = 7.15 and "PICKUP_TIME" IS NULL and "TOTAL_VAT_PROMO_SALES_LOSS" IS NULL and "TOTAL_VAT_SERVICE_SURCHARGE" IS NULL and "TOTAL_VAT_DISCOUNT" IS NULL and "TOTAL_VAT_PRICE" IS NULL and "TOTAL_VAT_INTRO_PROMO_LOSS" IS NULL and "TOTAL_VAT_SERVICE_CHARGE_DISC" IS NULL and "CLEANUP_FLG" IS NULL and "DATE_REVERSED_DIRECT_DEBIT" IS NULL and "INVOICE_NUMBER" IS NULL and "DATE_INVOICED" IS NULL and "EXT_ORDERING_IDENTIFICATION" IS NULL and "MISSING_OBD_FLG" IS NULL and "ORDE_NO_MASTER" IS NULL and "DATE_CANCELLED_AT_SETTLEMENT" IS NULL and "EXT_ORDERING_AUTHORIZED_FLG" IS NULL and "TRANSACTION_COMPLETE_FLG" = 'Y' and "EMPL_NO_CASHIER" = 88349 and "IBAN_EXCASSO" IS NULL and "PICKUP_HOME_DELIVERY_FLG" IS NULL and "B2B_FLG" = 'N' and "MESSAGE_RECIPIENT" IS NULL and "LONGITUDE" = 6.23996 and "LATITUDE" = 52.03803 and "OFFERS_FINAL_FLG" = 'Y' and "ORDER_NOT_COMPLETE_FLG" IS NULL and "OE_ERROR_FLG" IS NULL and "CONTROL_CLUSTER" = '20231005-00' and "OE_PURCHASE_STAMPS_FLG" IS NULL and "OPRO_NO" = 2 and "PACKAGING_PLAN" = 'STANDARD' and "METERS_SINCE_PREVIOUS_ORD" = 4855 and "DRIVING_SECONDS_SINCE_PREV_ORD" = 487 and "TRIP_SEQ_NO" = 1 and "CHECKSUM_BOFF" = '{"checks":[{"orlo":8953, "checksum":89530550757878686270108}]}' and "CHECKSUM_CWMS" = '{"checks":[{"orlo":8953, "checksum":89530550757878686270108}]}' and "EXTERNAL_ORDER_ID" IS NULL and "PREPAID_FLG" IS NULL and "EXTERNAL_SHLO_NO" IS NULL and "EXTERNAL_DELIVERY_RUN_ID" IS NULL and "EXTERNAL_DELIVERY_RUN_SEQ" IS NULL and "FIRST_ORDER_FLG" IS NULL |0x2C0016002C70DD02|0 | |0 |MQXABAT |0 |null |null |7590034236014|7590034236014|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000B003D26CC03|1083 | |0 |MQXABAT |0 |null |null |7590034236016|7590034236016|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001600F86ACE03|1083 | |0 |SV_ORDER_INVOICE|0 |null |null |7590034236017|7590034236017|2023-10-05 20:26:32|COMMIT |0 |commit |0x2C0015000F8BDE02|1059 | |0 |MQXABAT |0 |null |null |7590034236019|7590034236019|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000E002764CE03|1083 | |0 |MQXABAT |0 |null |null |7590034236020|7590034236020|2023-10-05 20:26:32|COMMIT |0 |commit |0x05001000D9BE6103|990 | |0 |MQXABAT |0 |null |null |7590034236022|7590034236022|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001B00B2B4CE03|1083 | |0 |MQXABAT |0 |null |null |7590034236025|7590034236025|2023-10-05 20:26:32|COMMIT |0 |commit |0x180021003351CE03|1083 | |0 |MQXABAT |0 |null |null |7590034236027|7590034236027|2023-10-05 20:26:32|COMMIT |0 |commit |0x180010008F74CB03|1083 | |0 |MQXABAT |0 |null |null |7590034236029|7590034236029|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001200EB5BCD03|1083 | |0 |MQXABAT |0 |null |null |7590034236031|7590034236031|2023-10-05 20:26:32|COMMIT |0 |commit |0x29000D00C1C9C302|990 | |0 |MQXABAT |0 |null |null |7590034236033|7590034236033|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001A006B4BCD03|1083 | |0 |SV-ORDER-PAYMENT|1 |P1BOFF |BOFF_ORDER|7590034236033|null |2023-10-05 20:26:32|UPDATE |0 |update "P1BOFF"."BOFF_ORDER" set "ORCT_CODE" = '0', "STCO_CODE" = '47', "RECALCULATE_FLG" = NULL where "NO" = 94553394 and "CUST_NO" = 820989 and "ORCT_CODE" = '0' and "ZIPC_NO" = 6824 and "STAT_CODE" = 'GD' and "STCO_STTY_CODE" = 'O' and "STCO_CODE" = '45' and "ORME_NO" = 83 and "DELO_NO" = 8953 and "MUCO_NO" IS NULL and "DERU_NO" = 15964903 and "DERU_NO_ORIG" = 15964903 and "POSL_NO" = 0 and "DEDA_DATE" = TIMESTAMP ' 2023-10-05 00:00:00' and "DESH_CODE" = '2C' and "CUQC_CODE" = '0' and "EMPL_NO_ORDER_ENTRY" = 19132 and "EMPL_NO_CHANGED" = 19132 and "DELIVERY_ADDRESS" = 'H' and "HOUSE_NO" = 46 and "STREET" = 'Jac. van Looystraat' and "CITY" = 'ARNHEM' and "ORDER_ENTRY_DATE" = TIMESTAMP ' 2023-09-07 00:00:00' and "DATE_CHANGED" = TIMESTAMP ' 2023-10-03 20:03:48' and "ZIPCODE_EXTRA" = 'PT' and "PROMO_SALES_LOSS" = 0 and "SERVICE_CHARGE" = 0 and "E_MAIL" = 'ahodiamont@gmail.com' and "SERVICE_SURCHARGE" IS NULL and "ORDER_ENTRY_START_TIME" = TIMESTAMP ' 2023-09-07 01:58:55' and "DELIVERY_EXTRA_SPECS" IS NULL and "HOUSE_NO_EXTRA" IS NULL and "DELIVERY_RUN_SEQ" = 15 and "CLASSIFICATION" IS NULL and "ORDER_ENTRY_END_TIME" = TIMESTAMP ' 2023-10-03 20:03:48' and "DEBIT_NO" IS NULL and "DEBIT_ATTEMPT" IS NULL and "TOTAL_PROFIT" = 0 and "LOW_VAT" IS NULL and "TOTAL_DEPOSIT" = 1.25 and "TOTAL_COST_PRICE" = 73.14 and "TOTAL_DISCOUNT" = 20.83 and "TOTAL_MIXED_VAT" IS NULL and "TOTAL_AMOUNT" = 117.14 and "TOTAL_VAT" IS NULL and "TOTAL_PRICE" = 131.37 and "TOTAL_PKG" = 5.35 and "TOTAL_WEIGHT" IS NULL and "TOTAL_SIZE" IS NULL and "DELIVERY_RUN_SEQ_ORIG" = 15 and "TOTAL_CORRECTION_AMOUNT_MEMO" = 0 and "INTRO_PROMO_LOSS" = 0 and "POS_LOG_TRANSACTION_NO" IS NULL and "BONUS_CARD_NO" = 2622601561889 and "BONUS_POINT_BALANCE" IS NULL and "THOP_ORDERPICKING_SYSTEM_FLG" IS NULL and "CARD_AUTHORIZATION_NO" IS NULL and "EURO_TO_GUILDER_DIFFERENCE" IS NULL and "GUILDER_TO_EURO_DIFFERENCE" IS NULL and "TIMES_OPENED_FROM_SUBMITTED" = 3 and "DIFFERENCE_THOP_INVOICE_IN" IS NULL and "DIFFERENCE_THOP_INVOICE_OUT" IS NULL and "DIFFERENCE_THOP_ACCOUNTING" IS NULL and "ACSA_BATCH_NO" IS NULL and "AIRMILES_PROCESS_FLAG" IS NULL and "PILO_NO" IS NULL and "ACCOUNT_NO" IS NULL and "TOTAL_INCENTIVE_DISCOUNT" = 0 and "RECALCULATE_FLG" IS NULL and "SERVICE_CHARGE_DISCOUNT" = 0 and "TOTAL_VAT_ORDER_LINE" IS NULL and "LOW_VAT_ORDER_LINE" IS NULL and "TOTAL_VAT_SERVICE_MEMO" IS NULL and "LOW_VAT_SERVICE_MEMO" IS NULL and "TOTAL_VAT_SERVICE_CHARGE" IS NULL and "LOW_VAT_SERVICE_CHARGE" IS NULL and "TOTAL_VAT_INCENTIVE_DISCOUNT" IS NULL and "LOW_VAT_INCENTIVE_DISCOUNT" IS NULL and "DELIVERY_START_TIME" = '2000' and "DELIVERY_END_TIME" = '2200' and "ARRIVAL_TIME" = '2035' and "DEPARTURE_TIME" = '2042' and "KM_SINCE_PREVIOUS_ORDER" = 0 and "MINUTES_DROP" = 6 and "ZIPCODE_EXTRA_NO" = 446694 and "DERU_NO_ROUTE_SCHEDULING" = 15964903 and "WEIGHT_ROUTE_SCHEDULING" = 26 and "PACKAGINGS_ROUTE_SCHEDULING" = 19 and "DRIVING_MINUTES_SINCE_PREV_ORD" = 0 and "WAIT_MINUTES_SINCE_PREV_ORD" = 0 and "REASON_CODE_NOT_PLANNED" IS NULL and "DELIV_RUN_SEQ_ROUTE_SCHEDUL" = 15 and "DELIV_START_TIME_ROUTE_SCHEDUL" = '1958' and "DELIV_END_TIME_ROUTE_SCHEDUL" = '2154' and "BREAK_MINUTES_SINCE_PREV_ORD" = 0 and "INVOICE_VAT1_BASE" IS NULL and "INVOICE_VAT1_RATE" IS NULL and "INVOICE_VAT1" IS NULL and "INVOICE_VAT2_BASE" IS NULL and "INVOICE_VAT2_RATE" IS NULL and "INVOICE_VAT2" IS NULL and "INVOICE_VAT3_BASE" IS NULL and "INVOICE_VAT3_RATE" IS NULL and "INVOICE_VAT3" IS NULL and "SHOC_NO" = 1 and "PRICE_DATE" = TIMESTAMP ' 2023-10-05 00:00:00' and "ASSORTMENT_DATE" = TIMESTAMP ' 2023-10-05 00:00:00' and "PAME_CODE" = 'DELIVERY' and "RECALC_AFTER_ORDERING_FLG" = 'Y' and "MULTIPLE_ITEMS_NUMBER" IS NULL and "CANCELLED_AFTER_PAYMENT_FLG" IS NULL and "TOTAL_AMOUNT_DELIVERED" IS NULL and "AMOUNT_REFUND" IS NULL and "DATE_REFUND_CALCULATED" IS NULL and "PROCESS_STOCK_AVAIL_FLG" IS NULL and "ORLI_CUST_SALES_PRICE_NON_INCE" = 110.54 and "ORLI_VAT_NON_INCENT" IS NULL and "ORLI_COST_PRICE_NON_INCENT" = 73.136 an|0x33000200ED1FA602|1318 | |0 |SV-ORDER-PAYMENT|0 |P1BOFF |BOFF_ORDER|7590034236033|null |2023-10-05 20:26:32|UPDATE |0 |d "ORLI_LOGISTIC_COSTS_NON_INCENT" = 26.95 and "PICKUP_TIME" IS NULL and "TOTAL_VAT_PROMO_SALES_LOSS" IS NULL and "TOTAL_VAT_SERVICE_SURCHARGE" IS NULL and "TOTAL_VAT_DISCOUNT" IS NULL and "TOTAL_VAT_PRICE" IS NULL and "TOTAL_VAT_INTRO_PROMO_LOSS" IS NULL and "TOTAL_VAT_SERVICE_CHARGE_DISC" IS NULL and "CLEANUP_FLG" IS NULL and "DATE_REVERSED_DIRECT_DEBIT" IS NULL and "INVOICE_NUMBER" IS NULL and "DATE_INVOICED" IS NULL and "EXT_ORDERING_IDENTIFICATION" IS NULL and "MISSING_OBD_FLG" IS NULL and "ORDE_NO_MASTER" IS NULL and "DATE_CANCELLED_AT_SETTLEMENT" IS NULL and "EXT_ORDERING_AUTHORIZED_FLG" IS NULL and "TRANSACTION_COMPLETE_FLG" = 'Y' and "EMPL_NO_CASHIER" = 83659 and "IBAN_EXCASSO" IS NULL and "PICKUP_HOME_DELIVERY_FLG" IS NULL and "B2B_FLG" = 'N' and "MESSAGE_RECIPIENT" IS NULL and "LONGITUDE" = 5.94976 and "LATITUDE" = 51.9986 and "OFFERS_FINAL_FLG" = 'Y' and "ORDER_NOT_COMPLETE_FLG" IS NULL and "OE_ERROR_FLG" IS NULL and "CONTROL_CLUSTER" = '20231005-00' and "OE_PURCHASE_STAMPS_FLG" IS NULL and "OPRO_NO" = 2 and "PACKAGING_PLAN" = 'STANDARD' and "METERS_SINCE_PREVIOUS_ORD" = 58 and "DRIVING_SECONDS_SINCE_PREV_ORD" = 10 and "TRIP_SEQ_NO" = 1 and "CHECKSUM_BOFF" = '{"checks":[{"orlo":8953, "checksum":895305506734987491060009}]}' and "CHECKSUM_CWMS" = '{"checks":[{"orlo":8953, "checksum":895305506734987491060009}]}' and "EXTERNAL_ORDER_ID" IS NULL and "PREPAID_FLG" IS NULL and "EXTERNAL_SHLO_NO" IS NULL and "EXTERNAL_DELIVERY_RUN_ID" IS NULL and "EXTERNAL_DELIVERY_RUN_SEQ" IS NULL and "FIRST_ORDER_FLG" IS NULL |0x33000200ED1FA602|1318 | |0 |MQXABAT |0 |null |null |7590034236035|7590034236035|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000F0084BDCE03|1083 | |0 |SV_ORDER_INVOICE|0 |null |null |7590034236036|7590034236036|2023-10-05 20:26:32|COMMIT |0 |commit |0x2C001C00A995DB02|1059 | |0 |SV-ORDER-PAYMENT|0 |null |null |7590034236037|7590034236037|2023-10-05 20:26:32|COMMIT |0 |commit |0x33001900887EA302|1318 | |0 |MQXABAT |0 |null |null |7590034236039|7590034236039|2023-10-05 20:26:32|COMMIT |0 |commit |0x0F002000C25F1904|990 | |0 |MQXABAT |0 |null |null |7590034236041|7590034236041|2023-10-05 20:26:32|COMMIT |0 |commit |0x180001007800CF03|1083 | |0 |MQXABAT |0 |null |null |7590034236043|7590034236043|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001300784BCC03|1083 | |0 |SV_ORDER_INVOICE|0 |null |null |7590034236044|7590034236044|2023-10-05 20:26:32|COMMIT |0 |commit |0x2C0007004092DD02|1059 | |0 |MQXABAT |0 |null |null |7590034236046|7590034236046|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001800A6BDCE03|1083 | |0 |MQXABAT |0 |null |null |7590034236048|7590034236048|2023-10-05 20:26:32|COMMIT |0 |commit |0x180002008A3BCE03|1083 | |0 |MQXABAT |0 |null |null |7590034236049|7590034236049|2023-10-05 20:26:32|COMMIT |0 |commit |0x32002000ED35DF02|990 | |0 |UNKNOWN |0 |null |null |7590034236051|7590034236051|2023-10-05 20:26:32|COMMIT |0 |commit |0x2C0016002C70DD02|0 | |0 |MQXABAT |0 |null |null |7590034236053|7590034236053|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000300FB25CE03|1083 | |0 |MQXABAT |0 |null |null |7590034236055|7590034236055|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001C00F78ACD03|1083 | |0 |MQXABAT |0 |null |null |7590034236057|7590034236057|2023-10-05 20:26:32|COMMIT |0 |commit |0x180017001E92CE03|1083 | |0 |MQXABAT |0 |null |null |7590034236058|7590034236058|2023-10-05 20:26:32|COMMIT |0 |commit |0x32001D00FE44DC02|990 | |0 |MQXABAT |0 |null |null |7590034236060|7590034236060|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000A00B65DCE03|1083 | |0 |MQXABAT |0 |null |null |7590034236062|7590034236062|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000900CB3BCE03|1083 | |0 |MQXABAT |0 |null |null |7590034236064|7590034236064|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000400A265CE03|1083 | |0 |MQXABAT |0 |null |null |7590034236066|7590034236066|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000D00724FCE03|1083 | |0 |MQXABAT |0 |null |null |7590034236068|7590034236068|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000600AF6FCC03|1083 | |0 |MQXABAT |0 |null |null |7590034236070|7590034236070|2023-10-05 20:26:32|COMMIT |0 |commit |0x180019007C3FCC03|1083 | |0 |MQXABAT |0 |null |null |7590034236072|7590034236072|2023-10-05 20:26:32|COMMIT |0 |commit |0x18000700BA24CF03|1083 | |0 |MQXABAT |0 |null |null |7590034236074|7590034236074|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001F007581CD03|1083 | |0 |MQXABAT |0 |null |null |7590034236076|7590034236076|2023-10-05 20:26:32|COMMIT |0 |commit |0x180008008D45CC03|1083 | |0 |MQXABAT |0 |null |null |7590034236078|7590034236078|2023-10-05 20:26:32|COMMIT |0 |commit |0x180000001C58CA03|1083 | |0 |MQXABAT |0 |null |null |7590034236080|7590034236080|2023-10-05 20:26:32|COMMIT |0 |commit |0x18002000E796CE03|1083 | |0 |MQXABAT |0 |null |null |7590034236082|7590034236082|2023-10-05 20:26:32|COMMIT |0 |commit |0x18001E006B54CE03|1083 | +------+----------------+---+---------+----------+-------------+-------------+-------------------+---------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+--------+