Extracts List

From CTMS

This page shows a list of all extracts, with links to the detail of each extract.

Report Name Filename Procedure for Scheduling
10.6 Customer By Product Export Cust_By_Product CSV.Cust_By_Product
10.6 Customer Location Export Customer_Location CSV.Customer_Location
10.6 Customer Product By Arrival Cust_Product_By_Arrive CSV.Cust_Product_By_Arrive
10.6 Data Extract Data_Extract CSV.Data_Extract
10.6 Load Status Export Load_Status_Export CSV.Load_Status_Export
10.6 Matthew Clark Data Extract Matt_Clark_Data_Extract CSV.Matt_Clark_Data_Extract
10.6 Planning Export Planning_Export CSV.Planning_Export
10.6 Tokairo Export Tokairo_Export CSV.Tokairo_Export
10.6 Warehouse Extract Warehouse_Extract CSV.Warehouse_Extract
1POD Delivery Extract POD_Delivery_Extract DP_CSV2.POD_DELIVERY_EXTRACT
AA Trip and Order Detail AA_Trip_Order_Detail_Extract CSV.AA_Trip_Order_Detail_Extract
ACC Missing Payments ACC_Missing_Payment DP_CSV_DUN.ACC_MISSING_PAYMENT
ACTIVITY_EXTRACT ACTIVITY_EXTRACT dp_csv3.activity_extract
Accruals ACCRUALS CSV.ACCRUALS
Actual Load ACTUAL_LOAD_EXTRACT DP_CSV_GEN.DAILY_EXT_LOAD
Actual Unload ACTUAL_UNLOAD_EXTRACT DP_CSV_GEN.DAILY_EXT_UNLOAD
Additional Reporting Requirements nr_additional_rep dp_csv_nr.nr_additional_report
Amazon Resources FMC_BULK_UPLOAD DP_CSV_CSS.AMAZON_RESOURCES
Amazon Resources Update FMC_UPDATE DP_CSV_CSS.AMAZON_RESOURCE_UPDATE
Approved Price Report approved_price_rep dp_csv_nr.approved_price_report
Asset History ASSET_HISTORY DP_CSV6.ASSET_HISTORY_EXTRACT
Asset Status ASSET_STATUS DP_CSV6.ASSET_STATUS
Asset Utilisation ASSET_UTILISATION dp_csv4.asset_utilisation
Assets On Time Delivery ASSET_ON_TIME_DELIV dp_csv4.asset_on_time_deliv
Automotive Planning Report Planning_Report DP_CSV2.PLANNING_REPORT
BGW Trip and Order Detail BGW_Trip_Order_Detail_Extract DP_CSV3.BGW_TRIP_ORDER_DETAIL_EXTRACT
BGW_DEBRIEF BGW_DEBRIEF dp_csv3.bgw_debrief
BMW Asset Dwell AUTO_ASSET_DWELL DP_CSV3.AUTO_AFTERMARKET_BMW
Backing Sheet BACKING_SHEET_EXTRACT DP_CSV_GEN.BACKING_SHEET
Baxter CSR Baxter_csr DP_CSV5.BAXTER_CSR
Baxter Download Id Orders Baxter Download DP_CSV5.BAXTER_DOWNLOAD_ID_ORDER
CARGOWISE Header CARGOWISE_HEADER OF_INT.WRITE_CARGOWISE_HEADER
CN Equipment Moves Equip_Move DP_CSV2.CN_EQUIP_MOVE
CN Trip and Order Detail CN_Trip_Order_Detail_Extract CSV.CN_Trip_Order_Detail_Extract
CN Warehouse Loading CN_Warehouse_Loading DP_CSV_DHL.p_warehouse_loading
CTM Carrier Responsiveness CTM_CARRIER_RESPONSIVENESS CSV.CTM_CARRIER_RESPONSIVENESS
CTM Trips Not Responded To CTM_TRIPS_NO_RESPONSE CSV.CTM_TRIPS_NO_RESPONSE
Call Collection OTIF Day coll_OTIF_date_window dp_csv_nr.coll_otif_date_window
Call Collection OTIF Time Window coll_OTIF_window dp_csv_nr.coll_otif_window
Call Delivery OTIF Day del_OTIF_date_window dp_csv_nr.del_otif_date_window
Call Delivery OTIF Time Window del_OTIF_window dp_csv_nr.del_otif_window
Campus KPI Extract Campus_KPI_Extract KPI.KPI_CAMPUS_EXTRACT
Carrier DUs Shipped CARRIER_DUS_SHIPPED DP_CSV5.CARRIER_DUS_SHIPPED
Carrier Delivery Report Carrier_Delivery_Report DP_CSV5.CARRIER_DELIVERY
Carrier Invoice Carrier_Invoice CSV.CARRIER_INVOICE
Carrier Self Billing Carrier_Self_billing DP_CSV_BNL.CARRIER_SELF_BILLING
Catalyst Extract CATALYST_EXTRACT CSV.CATALYST_EXTRACT
Co-ordinate Non-Conformities Co_Ord_Non_Conf DP_CSV6.CO_ORD_NON_CONFORM
Commercial COMMERCIAL CSV.Commercial_Orders
Compliance Report COMPLIANCE_REPORT DP_CSV_DUN.COMPLIANCE_REPORT
Concurrent Logon Export Concurrent_Logon_Export CSV.Concurrent_Logon
Contracts CONTRACTS CSV.CONTRACTS
Cross Dock CROSS_DOCK DP_CSV6.CROSS_DOCK
Customer Invoice Customer_Invoice CSV.Customer_Invoice
Customer Invoice By Dates Customer_Invoice_By_Dates CSV.Customer_Invoice_By_Dates
Customer Invoice Extract Customer_Invoice CSV.Customer_Invoice
Cut Offs Extract Cut_offs_extract DP_CSV6.CUT_OFF_EXTRACT
D365 Extract DP_FINANCE.D365_EXPORT D365_EXPORT_
DELIVERY_OVERVIEW DELIVERY_OVERVIEW dp_csv3.delivery_overview
DG Test Do Not Use DG_Test CSV.DO_NOT_USE
DOOD Rpt DOOD_RPT dp_csv_dood.dood_rpt
DUs Despatched DUS_DESPATCHED_EXTRACT DP_CSV_GEN.DUS_DESPATCHED_EXTRACT
DUs Not Loaded DUS_NOT_LOADED_EXTRACT DP_CSV_GEN.DUS_NOT_LOADED_EXTRACT
DUs Not Received DUS_NOT_RECEIVED_EXTRACT DP_CSV_GEN.DAILY_EXT_NOT_RECD
Daily Manifest E-OT-L DAILY_MANIFEST_E_OT_L_EXTRACT DP_CSV_GEN.DAILY_EXT_MANIFEST
Daily Receiving E-OT-L RECEIVING_E_OT_L_EXTRACT DP_CSV_GEN.DAILY_EXT_RECEIPTING
Daily Transport Plan DAILY_TRANSPORT_PLAN_EXTRACT DP_CSV_GEN.DAILY_TRANSPORT_PLAN
Daily Unscheduled Orders DAILY_UNSCHEDULED_ORDERS_EXTRACT DP_CSV_GEN.DAILY_UNSCHED_ORD
Debrief Performance debrief_performance dp_csv_nr.debrief_performance
Del Scans DEL_SCANS DP_CSV6.DEL_SCANS
Delivery Conf BGYP_DELCONF_ DP_CSV5.DELIVERY_CONF
Delivery Schedule Extract Delivery_Schedule DP_CSV_DHL.DELIVERY_SCHEDULE
Depot Exits by Hour (Loads) DEPOT_EXITS_LOADS CSV.DEPOT_EXITS_BY_HOUR_LOADS
Depot Exits by Hour (RPEs) DEPOT_EXITS_RPE CSV.DEPOT_EXITS_BY_HOUR_RPE
Detailed Interface Report Detailed_Interface_Report CSV.Detailed_Interface_Report
Dixons Catalyst Report fn CSV.Dixons_Catalyst_Report
Dixons Order Export Dixons_Order_Export CSV.Dixons_Order_Export
Dixons Trip Extract Dixons_Trip_Extract CSV.Dixons_Trip_Extract
Driver Hours driver_hours dp_csv_nr.driver_hours
Driver Scanning DRIVER_SCANNING DP_CSV6.DRIVER_SCANNING
Dunelm Actual Load DUNELM_ACTUAL_LOAD DP_CSV_DUN.daily_ext_load
Dunelm Actual Unload DUNELM_ACTUAL_UNLOAD DP_CSV_DUN.daily_ext_unload
Dunelm Backing Sheet BACKING_SHEET DP_CSV2.BACKING_SHEET
Dunelm DUs Despatched Extract DUNELM_DUS_DESPATCHED_EXTRACT DP_CSV_DUN.DUN_DU_DESPATCHED_EXTRACT
Dunelm DUs Not Loaded Extract DUNELM_DUS_NOT_LOADED_EXTRACT DP_CSV_DUN.DUN_DU_NOT_LOADED_EXTRACT
Dunelm DUs Not Received DUNELM_DUS_NOT_RECEIVED DP_CSV_DUN.daily_ext_not_recd
Dunelm Inventory Transactions DUN_INVENTORY_TRANS DP_CSV_DUN.DUN_INVENTORY_TRANSACTIONS
Dunelm Item Movements 3 DUN_ITEM_MOVEMENTS_EXTRACT DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_3
Dunelm Item Movements Extract DUN_ITEM_MOVEMENTS_EXTRACT DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT
Dunelm Item Movements Extract New DUN_ITEM_MOVEMENTS_EXTRACT DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_2
Dunelm Left Offs Left_Offs_Extract DP_CSV_DUN.left_offs_extract
Dunelm Loading Extract DUNELM_LOADING_EXTRACT DP_CSV2.DUN_LOADING
Dunelm Manifest E-OT-L Extract DUNELM_MANIFESTED_EOL DP_CSV_DUN.daily_ext_manifest
Dunelm Manual Loaded Items Extract MANL_SCAN_ORDER_DETAIL_EXTRACT DP_CSV2.MANL_SCAN_ORDER_DETAIL_EXTRACT
Dunelm Receiving Extract DUNELM_RECEIVING_EXTRACT DP_CSV2.DUN_RECEIVING
Dunelm Recieving E-OT-L Extract DUNELM_RECEIPTED_EOL DP_CSV_DUN.daily_ext_receipting
Dunelm Supplier DU Extract DUNELM_SUPPLIER_DU_EXTRACT DP_CSV2.DUN_SUPPLIER_DU_EXTRACT
Dunelm Supplier DU Extract by Store DUNELM_DU_STORE_EXTRACT DP_CSV2.DUN_DU_STORE_EXTRACT
Dunelm Supplier Revenue Extract DUNELM_SUPPLIER_REVENUE_EXTRACT DP_CSV2.DUN_SUPPLIER_REVENUE_EXTRACT
Dunelm Supplier Revenue Extract New DUNELM_SUPPLIER_REVENUE_NEW DP_CSV2.DUN_SUPPLIER_REVENUE_NEW
Dunelm Supplier Trends Extract DUN_SUPPLIER_TRENDS dp_csv_dun.dun_du_rpe_revenue_extract
Dunelm Transport Plan DUNELM_TRANSPORT_PLAN DP_CSV_DUN.daily_transport_plan
Dunelm Unsched Orders DUNELM_UNSCHED_ORD DP_CSV_DUN.daily_unsched_ord
Duplicate Postcodes DUPLICATE_POSTCODES dp_csv2.duplicate_postcodes_extract
EFX Inbound Errors EFX_Inbound_Errors DP_CSV2.EFX_In_Errs_Extract
ERC ERC DP_CSV_DHL.ERC
Equipment Moves Equip_Move DP_CSV2.EQUIP_MOVE
Extract Lane EXTRACT_LANE CSV.EXTRACT_BY_LANE
Failed Shipment FAILED_SHIPMENT dp_csv3.failed_shipment
Fixed Routes Extract Routes_Extract CSV.FIXED_ROUTES_EXPORT
GREENE KING Interface Results GREENE_KING_interface_results CSV.GREENE_KING_if_res
GYP EFX Export GYP_EFX_Export DP_CSV5.GYP_EFX_EXPORT
HC Booking In Form HC_BOOKING_IN_FORM DP_CSV5.P_HC_BOOKING_IN_FORM
HC Haulier Trip Sheet HAULIER_TRIP_SHEET DP_CSV2.HAULIER_TRIP_SHEET
HCR Customer Orders HCR_CUSTOMER_ORDERS DP_CSV_DHL.HCR_CUSTOMER_ORDERS
HCR Loading Sheet CSV HCR_LOADING_SHEET DP_CSV5.HCR_LOADING_SHEET
Haulier Invoice Haulier_Invoice DP_CSV5.HAULIER_INVOICE
Historical Lane Based Orders hist_lbo CSV.Historical_LBOrders
IND Trip and Order Detail IND_Trip_Order_Detail_Extract DP_CSV2.IND_TRIP_ORDER_DETAIL_EXTRACT
ISC Finance (2) Export FINANCE_2_EXPORT DP_CSV2.FINANCE_EXPORT_V2
ISC Finance (3) Export FINANCE_2_EXPORT CSV6.ISC_FINANCE_2_EXPORT
ISC Finance (4) Export FINANCE_2_EXPORT CSV7.FINANCE_EXPORT_V2
Interface Errors Failures Interface_Errors_Failures DP_CSV5.INTERFACE_ERRORS_FAILURES
Invalid Orders Invalid_Orders DP_CSV6.INVALID_ORDERS
Item Movements ITEM_MOVEMENTS_EXTRACT DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT
Item Movements 2 ITEM_MOVEMENTS_2_EXTRACT DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_2
Item Movements 3 ITEM_MOVEMENTS_3_EXTRACT DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_3
Items Not Scanned By Date Items_Not_Scanned DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_DATE
Items Not Scanned By Trip Items_Not_Scanned DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_TRIP
JEYES Interface Results JEYES_interface_results CSV.JEYES_if_res
Job Notes Job_Notes DP_CSV5.JOB_NOTES
KPI By Lane KPI_BY_LANE CSV.KPI_BY_LANE
KPI Extract CN_KPI_Extract KPI_EXTRACT.KPI_EXTRACT
Kraft KPI KRAFT_KPI CSV.Trips_with_Orders
LFS Packages LFS_Packages DP_CSV_LFS.LFS_PACKAGES
Lane Extract Lane_Extract CSV.LANE_EXPORT
Left Offs LEFT_OFFS_EXTRACT DP_CSV_GEN.LEFT_OFFS_EXTRACT
Loading Extract LOADING_EXTRACT DP_CSV_GEN.EXT_LOADING
Loading Schedule CSV Loading_Schedule CSV.LOADING_SCHEDULE
Location Export Location_Export DP_CSV2.LOCATION_EXPORT
Location Export GL Location_Export CSV.LOCATION_EXPORT_GL
Location Export GPR Location_Export CSV.LOCATION_EXPORT_GPR
Location Pre-Warning Loc_Del_Pre_Warn CSV.Loc_Del_Pre_Warning
MDD Code 03 Exceptions MDD Code 03 Exceptions CSV.MDD_Code_03_Exceptions
MTS Finance Export FINANCE_EXPORT CSV.finance_export_v2
MTS Finance Export V2 FINANCE_EXPORT_V2 CSV.finance_export_v2
Manual Loaded Items MANUAL_LOADED_ITEMS_EXTRACT DP_CSV_GEN.MANL_SCAN_ORDER_DETAIL_EXTRACT
Master and Child Locations Master_and_Child DP_CSV5.MASTER_AND_CHILD
Message Maintenance Message_Maintenance CSV.msg_maint
Missing Lat Long Report MISSING_LAT_LONGS dp_csv3.missing_lat_long_extract
Missing Steps Report Missing_Steps_Report DP_CSV5.Missing_Steps_Report
Month End Accruals month_end_accruals dp_csv_nr.month_end_accruals
NR Additional Report nr_additional_rep dp_csv_nr.nr_additional_report
NR Finance Extract NR_Finance_Extract DP_CSV_NR.NR_FINANCE_EXTRACT
NR Invoice NR_Invoice DP_CSV_NR.NR_INVOICE
OPS KPI Extract OPS_KPI_Extract KPI.KPI_OPS_EXTRACT
OPS KPI Extract2 OPS_KPI_Extract KPI.KPI_OPUS_EXTRACT
OTM Export OTM_Export DP_CSV_DHL.OTM_EXPORT
On Time Arrivals ON_TIME_ARRIVALS DP_CSV6.ON_TIME_ARRIVALS
On Time Drops ON_TIME_DROPS DP_CSV6.ON_TIME_DROPS
On Time Items ON_TIME_ITEMS DP_CSV6.ON_TIME_ITEMS
On Time Items (Assets) ON_TIME_ITEMS DP_CSV6.ON_TIME_ITEMS_ASSETS
On Time Returns ON_TIME_RETURNS DP_CSV6.ON_TIME_RETURNS
Operational Information Operational_Information DP_CSV2.OPERATIONAL_INFO
Order Charges Extract ORD_CHARGE DP_CSV5.ORD_CHARGE_REPORT
Order Extract ORDER_EXTRACT.csv DP_CSV2.HCR_ORDER_EXTRACT
Order Interface Results ORDER_INTERFACE_RESULTS CSV.ORDER_INTERFACE_RESULTS
Order Items POD Debriefed Order_Items_POD_Debriefed DP_CSV_GEN.ORDER_ITEMS_POD_DEBRIEFED
Order Savings ORDER_SAVINGS CSV.Order_savings
Order Tracking Order_Tracking DP_CSV5.ORDER_TRACKING
Orders for Relabelling ORDERS_FOR_RELABELLING DP_CSV_DHL.ORDERS_FOR_RELABELLING
Orders to LogiX LogiX_Orders DP_LOGIX.ORDER_EXPORT
Orders to Paragon Paragon_Orders CSV.Orders_to_Paragon
Outbound Shortage OUTBOUND_SHORTAGE DP_CSV6.OUTBOUND_SHORTAGE
PAYMENT_DTLS PAYMENT_DTLS OF_INT.WRITE_PAYMENT_DETAILS
POC to SAP Extract POC to SAP Extract CSV.POC_to_Sap_Extract
POC to SAP Extract(A) POC to SAP Extract(A) CSV.POC_to_Sap_Extract
POC-POD Reprocessing Team Export POC_POD_REPOROCESSING DP_CSV.POC_POD_REPROCESSING
POD Delivery Extract POD_Delivery_Extract DP_CSV2.POD_DELIVERY_EXTRACT
POD Generation Extract POD_GEN DP_CSV5.POD_REPORT
POD to SAP Extract POD to SAP Extract CSV.POD_to_Sap_Extract
POD to SAP Extract(A) POD to SAP Extract(A) CSV.POD_to_Sap_Extract
PORSCHE19 Invoice Extract Invoice_Extract DP_CSV2.Invoice_Extract
PROVIDER_REVENUE PROVIDER_REVENUE dp_csv3.provider_revenue
Parts and Empites Parts_and_Empties DP_CSV5.PARTS_AND_EMPTIES
PostCode Matrix POSTCODE_MATRIX dp_csv3.postcode_matrix
Pre Invoice Check Pre_Invoice_Check CSV.PRE_INVOICE_CHECK
Process Items Audit PROCESS_ITEMS_AUDIT DP_CSV6.PROCESS_ITEMS_AUDIT
Process Items Interface Audit PROCESS_ITEMS_INTERFACE_AUDIT DP_CSV6.PROCESS_ITEMS_INTERFACE_AUDIT
Provisional Booking Exceptions Provisional Booking Exceptions CSV.Provisional_Booking_Exceptions
Purchase Order Extract po_extract DP_CSV2.PURCHASE_ORDER_EXTRACT
Reason Listings REASON_LISTING_ dp_csv3.reasons_listing
Receipt Scanning RECEIPT_SCANNING DP_CSV6.RECEIPT_SCANNING
Receiving Extract RECEIVING_EXTRACT DP_CSV_GEN.EXT_RECEIVING
Revenue Check (Account) revenue_report dp_csv_nr.revenue_report
SMS Email Summary Report sms_email_summary DP_CSV5.SMS_EMAIL_SUMMARY
STL Trip and Order Extract STL_Trip_Order_Extract DP_CSV2.STL_TRIP_ORDER_EXTRACT
Sales Margin Extract sme CSV.order_costs
Savings Extract Savings CSV.SAVINGS_EXTRACT
Schedule Schedule CSV.SCHEDULE
Schedule Details schedule_details DP_CSV_GEN.SCHEDULE
Schedule Trips CS SCHED_TRIPS_CS CSV.SCHEDULE_TRIPS_CS
Scheduled and Cancelled Orders Schedule_Orders CSV.SCHEDULE_ORDERS_VS
Scheduled and Cancelled Orders v2 fn CSV.SCHEDULE_ORDERS_VS_V2
Short Rail Report short_rail_rep dp_csv_nr.short_rail_report
Slot Extract Slot_Extract DP_CSV3.Slot_Extract
Store PVA STORE_PVA DP_CSV_DUN.STORE_PVA
Store Pre Warning Store_Pre_Warning CSV.Store_Pre_Warning
Sub Contractor SUB_CONTRACTOR DP_CSV_GEN.SUB_CONTRACTOR
Supplier DUs SUPPLIER_DU_EXTRACT DP_CSV_GEN.SUPPLIER_DU_EXTRACT
Supplier DUs By Store SUPPLIER_DU_BY_STORE_EXTRACT DP_CSV_GEN.DU_STORE_EXTRACT
Supplier Invoice Supplier_Invoice DP_CSV5.SUPPLIER_INVOICE
Supplier Revenue SUPPLIER_REVENUE_EXTRACT DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT
Supplier Revenue 2 SUPPLIER_REVENUE_2_EXTRACT DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT_2
TYRE SUMMARY EXTRACT TYRE_SUMMARY_EXTRACT DP_CSV6.TYRE_SUMMARY_EXTRACT
Trip Actuals TRIP_ACTUALS CSV.TRIP_ACTUALS
Trip Assessment Extract chk_trips dp_csv_lfs.chk_trips
Trip Extract Trip_Extract CSV.Trip_Extract
Trip and Order Detail Extract Trip_Order_Detail_Extract CSV.Trip_Order_Detail_Extract
Trunking Report Trunking_Report CSV.Trunking_Report
UNISON Interface Results UNSION_interface_results CSV.UNISON_if_res
User Activity Extract User_Activity_Extract CSV.User_Activity_Extract
User Last Logon Extract USER_LAST_LOGON CSV.user_logon_export
Variance Analysis Store Detail VAR_ANLYS_STORE_DTL CSV.VARIANCE_ANALYSIS_STORE_DTL
Variance Analysis Summary VAR_ANLYSIS_SUM CSV.VARIANCE_ANALYSIS_SUMMARY
Variance Analysis Trip Detail VAR_ANLYS_TRIP_DTL CSV.VARIANCE_ANALYSIS_TRIP_DTL
Vehicle Utilisation vehicle_util dp_csv_nr.vehicle_utilisation
Vehicle Utilisation Heavy hvy_vehicle_util dp_csv_nr.heavy_vehicle_utilisation
Vehicle Utilisation Non-Heavy vehicle_util dp_csv_nr.vehicle_utilisation
Volume Deviation Extract VOLUME_DEVIATION_EXTRACT DP_CSV5.volume_deviation_report
Volume or Activity VOLUME_ACTIVITY DP_CSV6.VOLUME_ACTIVITY
WCS Location Snapshot WCS_LOC_SANPSHOT DP_CSV2.wcs_loc_snapshot
WCS Order Items Extract WCS_ORDER_ITEMS_EXTRACT DP_CSV2.WCS_ORDER_ITEMS_EXTRACT
Weekly Transport Report Weekly_Transport DP_CSV_BNL.Weekly_Transport
XML Order Interface Export XML_Order_Interface DP_CSV3.XML_ORDER_INTERFACE