ROSS: Month End: Shipping Ownership correction

Created by Kathy Kale, Modified on Tue, 4 Feb at 9:42 AM by Kathy Kale

SELECT OWNERSHIP_TRANSFER_DATE, GEM_DBKEY, COMPANY_CODE, DIVISION, DESPATCH_NUMBER, DESPATCH_NOTE, DATE_CREATED, CUSTOMER_NUMBER, DELIVERY_ADDRESS_CODE, SYS_LANGUAGE_CODE, SYS_LANGUAGE_CODE_2, SYS_LANGUAGE_CODE_3, STATUS_FLAG, TM_ORDER_NUMBER, SOP_SHIPPING_RUN_NUMBER, SOP_DESTINATION_WAREHOUSE, PRINT_FLAG, AP_DIVISION, SYS_VERSION_NUMBER, MP_INVOICE_CUSTOMER, MP_SHIPPING_CUSTOMER, AMEND_ACTIVE_FLAG, SCC_DIST_INVOICE_NUMBER, IS_EDI_SCAC_CODE, IS_OSN_EQUIPMENT_ID, IS_PRO_NUMBER, IS_SEAL_NUMBER, IS_EDI_SCAC_CODE_DESCRIPTION, GEM_ARCHIVE_FLAG, WMS_SHIP_NOTE_FLAG, SHIPMENT_NUMBER, SYS_CONTAINER_NUMBER, SYS_CONTAINER_TYPE, SYS_CONTAINER_SIZE, SHIPPING_DESCRIPTION, SYS_EXPORT_GROSS_WEIGHT, WEIGHT_UOM, SYS_SIGNATORY_NAME, SYS_SIGNATORY_TITLE, ESTIMATED_FREIGHT_COST, CARRIER_ID, TRACKING_NUMBER

FROM DESPATCH_HEADERS

where OWNERSHIP_TRANSFER_DATE > '31-Dec-2024'

Once you know the last one add this

and DESPATCH_NOTE <= 869626

order by OWNERSHIP_TRANSFER_DATE desc

drop into excel

correct by 1 of these:

1. Either:

update DESPATCH_HEADERS set OWNERSHIP_TRANSFER_DATE = '31-Jan-2025' where OWNERSHIP_TRANSFER_DATE > '31-Jan-2025' and DESPATCH_NOTE <= 869626

2. OR:

add this to each line from Kim's spreadsheet.

Add this to each line excel line and copy to SQL to run:

update DESPATCH_HEADERS set OWNERSHIP_TRANSFER_DATE = '31-Dec-2024' where DESPATCH_NOTE = 866675