Extracts Details

From CTMS
Revision as of 15:33, 16 April 2025 by Anw (talk | contribs) (Initial Creation)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

This is a full list of all extracts in the system.

AA Trip and Order Detail

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Activity M STRING Both
Group Name M
Start Schedule M
End Schedule M
Carrier O

ACC Missing Payments

No parameters


ACTIVITY_EXTRACT

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Schedule M
Owning Depot O
From Schedule M

Accruals

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Revenue After O
Revenue Before O
Customer Group O
Debit Account O
Credit Account O

Actual Load

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
Load Date To M
Load Date From M

Actual Unload

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Load Date To M
Load Date From M

Additional Reporting Requirements

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M
Customer Group O
Customer O
Cost Centre O

Amazon Resources

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Arrival Time To O
Arrival Time From O

Amazon Resources Update

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Update After (HHMI) O
Arrival Time To O
Arrival Time From O

Approved Price Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
To Date M TODAY
Cost Centre O
Customer Group O
Customer O

Asset History

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Date From M TODAY
Driver/User O STRING
Asset Id O STRING ALL Asset Asset ID Asset ID
Date To M TODAY
Customer O STRING ALL
Asset Id O STRING ALL Asset Asset ID Asset ID
Last Scan Location O STRING ALL Last Scan Location Location ID Name
Customer O STRING ALL

Asset Utilisation

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
Route O
From Date M TODAY
To Date M TODAY
Vehicle O
Current Location O Location Location Location Name
Location O Location Location Location Name

Assets On Time Delivery

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
Location O Location Location Location Name
Route O
To Date M TODAY
From Date M TODAY

Automotive Planning Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
Utilisation > O STRING 0
Utilisation < O STRING 999
End Schedule M
Depot M STRING ALL
Level M STRING SUMMARY

BGW Trip and Order Detail

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M
Carrier O
Loaded At O
Activity M STRING Both
Group Name M

BGW_DEBRIEF

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cost Centre O
From Date M TODAY
To Date M TODAY
Customer O

BMW Asset Dwell

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Asset Type O

Backing Sheet

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Sched To O
Customer O
Manifest O
Sched From O

Baxter CSR

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer M STRING ALL
From Date M TODAY
To Date M TODAY
Cost Centre O

Baxter Download Id Orders

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Download Id M STRING

CN Data Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot O Depot Location Id Name
From Date M TODAY
Customer O
Group Name O
To Date M TODAY

CN Planning Export

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Group Name O
Current Depot M Current Depot Location Id Name
To Date M TODAY
From Date M TODAY

CN Tokairo Export

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date M TODAY
From Date M TODAY

CN Trip and Order Detail

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule M
Start Schedule M
Loaded At O
Carrier O
Group Name M
Activity M STRING Both

CN Warehouse Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Location M From Location Location Id Name
From Date M TODAY
To Date M TODAY
Owning Depot M Depot Location Id Name
Group Name O
Trip ID (optional) O
Depot M Depot Location Id Name
Carrier O
Start Schedule M
End Schedule M
Customer O Customer CUSTOMER_ID CUSTOMER_NAME

CTM Carrier Responsiveness

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule O
Carrier O
End Schedule O
Start Schedule O
Carrier O
End Schedule O

Call Collection OTIF Day

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
Customer O
Customer Group O
Product Type O
End Schedule O
Start Schedule O
From Date M TODAY
To Date M TODAY

Call Collection OTIF Time Window

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
Customer O
Customer Group O
Product Type O
End Schedule O
Start Schedule O
To Date M TODAY
From Date M TODAY

Call Delivery OTIF Day

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
From Date M TODAY
To Date M TODAY
Start Schedule O
End Schedule O
Product Type O
Customer Group O
Customer O

Call Delivery OTIF Time Window

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule O
Product Type O
Customer Group O
Customer O
Carrier O
From Date M TODAY
To Date M TODAY
Start Schedule O

Carrier DUs Shipped

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O STRING ALL
To Date M TODAY
From Date M TODAY

Carrier Delivery Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Sched Name M
Carrier M
Depot M
Trip ID O STRING ALL

Carrier Invoice

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Invoice No M
Credit Acc M
Debit Acc M
Invoice No M
Credit Acc M
Debit Acc M

Carrier Self Billing

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule M
Carrier 0
Start Schedule M

Co-ordinate Non-Conformities

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
Discrepancy Dist 0 1
TomTom,Epod,Both M B
Driver O
Depot O
End Schedule M

Commercial

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M

Compliance Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Collection Date M

Concurrent Logon Export

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date O TODAY
To Date O TODAY

==Contracts== || || || || || || || || || No Parameters

Cross Dock

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Media Type O STRING
Route O STRING
Schedule From M
Dealer O STRING
Depot O STRING
Schedule To M
Customer O STRING

Customer Invoice

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Invoice No M
Credit Acc M
Debit Acc M
Invoice No M
Debit Acc M
Credit Acc M

Customer Invoice By Dates

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Payment Status O
Customer M
From Date M
To Date M

Customer Invoice Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Invoice No M
Credit Acc M
Debit Acc M

Cut Offs Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule M
Customer 0
Start Schedule M

DELIVERY_OVERVIEW

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Schedule M
To Schedule M
Owning Depot O
POD Confirmed O

DOOD Rpt

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule To M
Schedule From M
Customer O STRING OPENFIELD

DUs Despatched

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Consignment Num O STRING
Start Sched O
Manifest O STRING
PO Number O STRING
Supplier O
End Sched O

DUs Not Loaded

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Store O Store Location ID Name
Schedule M

==DUs Not Received |- |To Date ||M || || || || || || |- |From Date ||M || || || || || || |}

Daily Manifest E-OT-L

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M
To Date M
End Schedule M
Start Schedule M

Daily Transport Plan

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Order Status M STRING ALL
Supplier M STRING ALL
To Date M
From Date M

Daily Unscheduled Orders

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date M
From Date M

Debrief Performance

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier Code O
Carrier Group O
Customer O
Cust Group O
Cost Centre O
From Date M TODAY
From Date M TODAY

Del Scans

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule M
Start Schedule M

Delivery Conf

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Type M M
Owning Depot O
Cost Centre M
To Actual date M TODAY
From Actual date M TODAY

Delivery Schedule Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Show Dates Y

Depot Exits by Hour (Loads)

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot M Depot Location Id Name
From Date M TODAY
To Date M TODAY
From Date M TODAY
To Date M TODAY
Depot M Depot Location Id Name

Detailed Interface Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer Group O
To Date O TODAY
Customer O
From Date O TODAY
Status M STRING All

Dixons Catalyst Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule M
Carrier O
Depot O Depot Location Id Name
Start Schedule M

Dixons Order Export

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date O TODAY
Carrier O
To Date O TODAY

Dixons Trip Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
To Date O TODAY
From Date O TODAY

Driver Hours

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
Customer Group O
To Date M TODAY
Cost Centre O

Driver Scanning

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O STRING
Dealer O STRING
Depot O STRING
Route O STRING
Media Type O STRING
Schedule To M
Schedule From M
Activity O STRING

Dunelm Backing Sheet

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Manifest O
Customer M
Sched To M
Sched From M

Dunelm Inventory Transactions

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Delivery Trip O
Trunk Trip O
Collection Trip O
Store O
Customer O
Date Type M STRING C
To Date M TODAY TODAY:23:59
From Date M TODAY TODAY:00:00

Dunelm Item Movements 3

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Manifest Number O
Actual To Date M TODAY
Actual From Date M TODAY
DU Type O
Supplier O
P/O Number O
Store O

Dunelm Item Movements Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Manifest Number O STRING
P/O Number O
Store O
DU Type O
Supplier O
Actual To Date M TODAY
Actual From Date M TODAY

Dunelm Item Movements Extract New

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
P/O Number O
Manifest Number O STRING
Store O
DU Type O
Supplier O
Actual From Date M TODAY
Actual To Date M TODAY

Dunelm Left Offs

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Trip Id (Optional) O
Days Back M STRING 30
Store (Optional) O Store Location Id Name

Dunelm Manual Loaded Items Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date O
To Date O

Dunelm Supplier Trends Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Year M
Week M

Duplicate Postcodes

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Ignore Inactive? O
Location From O Location From Location Id Location Name
Location To O Location To Location Id Location Name

ERC

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Sched End M
Sched Start M
Carrier O
DHL Carriers M
Detail Level M

Equipment Moves

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Owning Depot O
Customer O
To Date M TODAY
From Date M TODAY
Carrier O

Extract Lane

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cost Centre O Cost Centre Location Id Name
Customer O

Failed Shipment

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule To M
Schedule From M
Customer O STRING OPENFIELD

Fixed Routes Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Show Active / Inactive M STRING B
Carrier O
Depot O Depot Location Id Name

GREENE KING Interface Results

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
Depot O
To Date O TODAY
From Date O TODAY

GYP EFX Export

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Trip Status O
To Schedule M
From Schedule M
Cost Centre O
Customer Group O

HC Booking In Form

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M
Group Name O
Delivery Location O
Customer O
Group Name O
Schedule M
Delivery Location O
Customer O

HC Haulier Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Trip ID (optional) O
Owning Depot O Depot Location Id Name
Schedule M
Carrier O
Group Name O
Load Location O Loading Location Location Id Name
Owning Depot O Depot Location Id Name
Trip ID (optional) O
Schedule M
Carrier O
Group Name O
Load Location O Loading Location Location Id Name

HCR Customer Orders

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
Schedule M
Cost Centre O
Depot O

HCR Loading Sheet CSV

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Trip ID (optional) O
Load Location O Loading Location Loading Location Name
Owning Depot O Depot Loading Location Name
Schedule From M
Schedule To M
Carrier O
Customer O
Group Name O

Haulier Invoice

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Date O
Start Date O
Invoice ID O STRING
End Date O
Start Date O
Invoice ID O STRING

Heavy Vehicle Utilisation

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M
Customer Group O

Historical Lane Based Orders

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date O TODAY
From Date M TODAY

IND Trip and Order Detail

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Activity M STRING Both
End Schedule M
Carrier O
Loaded At O
Start Schedule M
Group Name M

ISC Finance (2) Export

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer M STRING ALL
End Schedule M
Start Schedule M

Interface Errors Failures

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
External Ref O STRING
Customer O Customer
Source System O
End Date M TODAY
Start Date M TODAY

Invalid Orders

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M
Customer 0

Item Movements

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Actual To Date M TODAY
Actual From Date M TODAY
Supplier O
DU Type O
Store O
Manifest Number O
P/O Number O

Item Movements 2

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
DU Type O
Supplier O
Actual From Date M TODAY
Actual To Date M TODAY
P/O Number O
Store O
Manifest Number O

Item Movements 3

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
P/O Number O
Store O
Manifest Number O
DU Type O
Supplier O
Actual To Date M TODAY
Actual From Date M TODAY

Items Not Scanned By Date

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule To M
Schedule From M
Depot M

Items Not Scanned By Trip

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Trip M
Schedule M

JEYES Interface Results

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date O TODAY
Customer O
Depot O
From Date O TODAY

KPI By Lane

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer Group O
End Date M
Show Detail M STRING Y
Grouping M STRING CUST_GROUP
End Date M TODAY
Start Date M TODAY
Start Date M
Tolerance(days) O
Separate Pages M STRING N
Customer Group O
Grouping M STRING CUST_GROUP

Kraft KPI

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
To Date M TODAY
Cost Centre O

LFS Packages

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M
Order Status O
Customer O
External Ref O

Lane Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
Cost Centre O
To Loc O To Loc Location Id Name
From Loc O From Loc Location Id Name

Left Offs

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Store (optional) O Store Location ID Name
Days Back M STRING 30
Trip ID (optional) O

Loading Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M

Loading Schedule CSV

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot M Depot Location Id Name
To Date M TODAY
From Date M TODAY

Location Export

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Country O

Location Pre-Warning

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Load Type M STRING ALL
Trip Status M STRING ALL
To Date M TODAY
To Date M TODAY
From Date M TODAY
Depot M Depot Location Id Name
Depot M Depot Location Id Name
From Date M TODAY
Load Type M STRING ALL
Trip Status M STRING ALL

MDD Code 03 Exceptions

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
To Date M TODAY

Manual Loaded Items

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date O
To Date O

Master and Child Locations

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Show UnMapped O Show UnMapped
Show Mapped O Show Mapped

==Message Maintenance== || || || || || || || || || |}

Missing Lat Long Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cost Centre M ALL

Missing Steps Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date M TODAY
Missing Step O STRING ALL
From Date M TODAY

Month End Accruals

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
From Date M TODAY
Cost Centre O
Customer O
Cust Group O

NR Finance Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
Debriefed M
Carrier O
To Region M STRING ALL
To Date M TODAY
Carrier Group O
Strategy O
Cost Centre O
Customer O
From Region M STRING ALL

NR Invoice

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date M TODAY
From Date M TODAY
Debriefed M
Carrier O
To Region M STRING ALL
From Region M STRING ALL
Carrier Group O
Strategy O
Customer O
Cost Centre O

OTM Export

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Date To M TODAY
Date From M TODAY
Carrier O

On Time Arrivals

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Outbase O
Media Type O
Route Code O
Dealer O
Customer O
Schedule To M
Schedule From M

On Time Drops

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Outbase O
Route Code O
Media Type O
Schedule To M
Customer O
Schedule From M
Dealer O

On Time Items

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Dealer O
Outbase O
Route Code O
Schedule To M
Schedule From M
Media Type O
Customer O

On Time Items (Assets)

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule From M
Customer O
Dealer O
Outbase O
Route Code O
Media Type O
Schedule To M

On Time Returns

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Media Type O
Route Code O
Outbase O
Dealer O
Customer O
Schedule From M
Schedule To M

Order Charges Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Date M TODAY

Order Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Sched M
Start Sched M

Order Interface Results

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
To Date O TODAY
From Date O TODAY
Depot O
Message Type O

Order Items POD Debriefed

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
End Schedule O
Start Schedule M

Order Savings

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule O
Show Neg Savings M

Order Tracking

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O STRING OPENFIELD
Month M
Week Offset O
Year M
Cost Centre O STRING OPENFIELDCC

Orders for Relabelling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M

==Orders to LogiX== || || || || || || || || || |}

Orders to Paragon

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3

Outbound Shortage

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule To M
Schedule From M
Dealer O STRING
Media Type O STRING
Route O STRING
Depot O STRING
Customer O STRING

PAYMENT_DTLS

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Date M TODAY
From Date M TODAY
Customer M

POC to SAP Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3

POC to SAP Extract(A)

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Resend All? M STRING No

POD Delivery Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Schedule M
To Schedule M
Del Msg Sent O STRING ALL
POD Status O STRING ALL
Carrier O STRING ALL
> Days Outstanding O STRING 0
Group O STRING ALL
Customer O STRING ALL
Scanning Depot O STRING ALL Depot Location Id Name

POD Generation Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
POD Flow M
Date To M TODAY
Date From M TODAY
Schedule O

POD to SAP Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3

POD to SAP Extract(A)

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Resend All? M STRING No

PORSCHE19 Invoice Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer M STRING PORSCHE19
Sub Debit Account O STRING ALL
Trip ID O STRING ALL
Sub Credit Account O STRING ALL
Invoice ID O STRING 0
Export ID O STRING 0

==PROVIDER_REVENUE== || ||Owning Depot ||O || || || || || || |- |To Schedule ||M || || || || || || |- |From Schedule ||M || || || || || || |}

Parts and Empites

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Export Type M
Schedule From M
Schedule To M
Location From O
Customer M

PostCode Matrix

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3

Pre Invoice Check

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cut-off Date M TODAY

Process Items Interface Audit

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Incl. Reprocessed M STRING N
Start Date M TODAY
End Date M TODAY
Record Status M STRING ALL

Provisional Booking Exceptions

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date M TODAY
From Date M TODAY

Purchase Order Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Status O STRING All
To Date O TODAY TODAY
From Date O TODAY TODAY

Reason Listings

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Date From M DATETIME TODAY:00:01
Depot M
Date To M DATETIME TODAY:23:59

Receipt Scanning

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Dealer O STRING
Route O STRING
Media Type O STRING
Customer O STRING
Date To M TODAY
Date From M TODAY
Depot O STRING

Receiving Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M

Revenue Check (Account)

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
From Date M TODAY
Cost Centre O
Cust Group O
Customer O

SMS Email Summary Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
Cost Centre M STRING ALL

STL Trip and Order Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Trip Schedule M
End Trip Schedule M
Order Status O
Carrier O
Location Type O

Sales Margin Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier Group O
Schedule M
Customer Group O
Last Schedule O
Customer O

Savings Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date O TODAY
Credit Acc O
Customer Group O
To Cty Code O
From Cty Code O
Lane Id O
From Date O TODAY
Debit Acc O
Saving (> or <) O STRING

Schedule

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
To Date M TODAY

Schedule Details

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M

Schedule Trips CS

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O

Schedule Trips CS

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M

Scheduled and Cancelled Orders

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M
Last Schedule O
Customer Group O
Customer O
Carrier Group O

==Scheduled and Cancelled Orders v2 |- |Schedule ||M || || || || || || |- |Customer ||O || || || || || || |- |Last Schedule ||O || || || || || || |- |Customer Group ||O || || || || || || |- |Carrier Group ||O || || || || || || |}

Short Rail Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cost Centre O
Product Type O
Start Schedule M
End Schedule M

Slot Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Day O String ALL
Slot Type O String ALL
Location Type O String ALL

==Store PVA || ||Del |- |ivery Date ||M || || || || || || |}

Store Pre Warning

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Show empty Slots O STRING N
Depot O Depot Location Id Name
Store O Store Location Id Name
Sched Name M

Sub Contractor

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Sched M
Cost Centre M
From Sched M

Supplier DUs

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To M TODAY
From M TODAY

Supplier DUs By Store

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Store O Store Location ID Name
Order Status O
End Schedule M
Start Schedule M

Supplier Invoice

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Date O
End Date O
Invoice ID O STRING
End Date O
Invoice ID O STRING
Start Date O
Start Schedule M
End Schedule M

Supplier Revenue 2

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Revenue Start M TODAY
Revenue End M TODAY

TYRE SUMMARY EXTRACT

Note Note: Can be run from Trip Waterfall screen.

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M

Trip Actuals

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M

Trip Assessment Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M

Trip Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
To Date O TODAY
From Date O TODAY

Trip and Order Detail Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
End Schedule M
Location Type M ALL
Start Schedule M

Trunking Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot M Depot Location Id Name
End Schedule M
Start Schedule M
Report Type M STRING Revenue

UNISON Interface Results

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot O Depot Location Id Name
Customer O
To Date O TODAY
From Date O TODAY

User Activity Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date M TODAY
From Date M TODAY

User Last Logon Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Days since logon M STRING 90

Variance Analysis Store Detail

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M

Variance Analysis Summary

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date M TODAY
From Date M TODAY

Variance Analysis Trip Detail

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M

Vehicle Utilisation

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M

Vehicle Utilisation Heavy

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier Code O
Carrier Group O
Cost Centre O
Customer Group O
End Schedule M
Start Schedule M

Vehicle Utilisation Non-Heavy

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier Group O
Customer Group O
Cost Centre O
End Schedule M
Start Schedule M
Carrier Code O

Volume Deviation Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O ALL
To Date M TODAY
From Date M TODAY
Schedule O
Cost Centre O ALL
Trip Leg O STRING ALL
Include Unpacked O STRING Y
Deviation O STRING ALL

Volume or Activity

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule From M
Schedule To M
Route Code O
Customer O
Dealer O
Depot O
Media Type O

WCS Order Items Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
To Date M TODAY
Order O STRING
Trip O STRING

Weekly Transport Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Sched M
To Sched M
Carrier ALL

XML Order Interface Export

No Parameters

Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/MTS/index.php?title=Extracts_Details&oldid=7775’