Embedded Files
This document describes the process to run the the WSX PSLog docket export.
For dockets to be written to the PSLog export file the following criteria must first be met,
Delivery date within the selected range (date range selected when export is run)
Docket LogOrg in the selected list (Log Orgs selected when export is run)
Docket Not Yet Sent
Net weight > 0
If 'Include Export Customers?' is checked then JAS and Pieces must be present for Export Customers
Must have M-Check or E-Check depending on rules set in the database (check with TFL Support on rules for your DB)
Cannot have E-Error or M-Error
Running an Export
Running an Export
To run the docket export, access the function from the menu: Dockets > PS Log > Export to PS Log. From the Docket Export screen that presents, make the following selections,
Start Date - Select the first date from which you want to include dockets
End Date - Select the final date up to which you want to include dockets
Send Un-Validated? - If selected this will export all dockets that are not set as ‘Error’. CAUTION: ticking this option will include non-validated docket data in the export.
Include Export Customers? - Includes dockets for customers marked as ‘Export Customer’ in the database.
Log Org - Select the Log Org(s) for which you want to export docket data
Data Exported to CSV
Data Exported to CSV
The table below describes the data output in the docket export file. This data is exported in a CSV format to the location specified in the DB Setting HFFExportPath_LogOrg, with a file naming convention of ‘Export_LogOrg(s)_AllSuppliers_YY_MM_DD_HoursMinutesSeconds.CSV’
Key to the Table Columns,
Field = Describes data in field
Origin = WSX or External Data Record
Data Source Field = Describes the source of data from within WSX
Translation = Translation available with associated Translation Entity Type
Required for Export? = Data must be present in these fields for docket to be written to FLITS export file. Note those marked as 'System' will always be present.
Field Origin Data Source Field Translation Required for Export?
Docket WSX Docket Number --- Yes
Delivery WSX Delivery Date --- System
Cartage WSX Trucking Contractor Code TRUCKCON System
Crew WSX Gang Number CREW System
Forest WSX Forest Short Code FOREST System
Compartment Code WSX Compartment Code --- System
Setting Code WSX Setting Code --- System
Sold As WSX Sold As WoodGroup MajorGrade if present, if not MAJORGRADE or System
WoodType code is used WOODTYPE
Load Length WSX Sold As WoodGroup Cut Length --- System
Customer WSX Customer Code CUSTOMER System
Destination WSX Customer Code* DESTINATION System
Net Weight WSX Net Weight --- Yes
Pieces WSX Pieces --- Export Customers Only
Volume WSX JAS (Volume) --- Export Customers Only
TripType WSX Trip Type (Primary, On-Truck, Re-Haul) --- System
Tare WSX Tare Weight --- No
Gross WSX Gross Weight --- No
Journey WSX Journey No. --- System
PurchaseDocket WSX Purchase Docket (PDkt) --- No
Truck WSX Truck Code TRUCK Yes (if Truck or Full Load)
Trailer WSX Trailer Code TRAILER Yes (if Trailer or Full Load)
LoadType WSX Truck, Trailer or Truck + Trailer --- System
Permits WSX Permits --- Optional
Species WSX Species (from Sold As WoodGroup) --- System
Cut_As WSX WoodType Code (Uplift) WOODTYPE System
Major_Grade WSX MajorGrade (from Sold As WoodGroup) MAJORGRADE System
Master_Grade WSX MasterGrade (from Sold As WoodGroup) --- System
Backload WSX Backload Type --- System
*Note: The DB Setting HFFPSLog_SourceForCust_LogOrg also allows for the Destination to be replaced by the 'Source' against the uplift where applicable.
Page updated
Report abuse