FLITS Export Data

The table below describes the data contained within the FLITS export file and how it is sourced from WSX

Note there are two export formats for the FLITS file, AFL and HFM. The differences between these are noted in the table below.

For dockets to be written to the FLITS export file the following criteria must first be met,

• • 1. Docket LogOrg in FlitsLogOrgs setting (check with TFL Support if unsure)

    2. Delivery date within the selected range (date range selected when export is run)

    3. Docket Not Yet Sent

    4. Docket LogOrg in the selected list (Log Orgs selected when export is run)

    5. Net weight > 0

    6. If 'Include Export' is checked then JAS and Pieces must be present for Export Customers

    7. Must have M-Check (E-Check not required) (unless DB exception exists- check with TFL Support if unsure)

    8. Cannot have E-Error or M-Error

Data Exported to CSV

The table below describes the data output in the docket export file. This data is exported in a CSV format with a file naming convention of ‘FLITSExport_LogOrg(s)_AllSupplier(s)_DateTime(when run).CSV’ 

Key to the Table Columns

• Col = Column in CSV

• 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.

Col Field Origin Data Source Field Translation Required for Export

A Blank --- --- --- ---

B Blank --- --- --- ---

C Docket No. WSX Docket --- Yes

D At Customer Date & Time WSX AFL = Uplift Date & Time --- Yes

HFM = Delivery Date & Time

E Truck WSX Truck Code TRUCK Yes

F Trailer WSX Trailer Code TRAILER Yes

G Crew WSX Gang Number (not Code) CREW Yes

H Blank --- --- --- ---

I Compartment WSX Compartment --- Yes

J Species* WSX AFL = First character Sold As WoodType Code SPECIES Yes

HFM = First character Sold As WoodType Full Name

K Log Grade (Sold As) WSX AFL = Sold As WoodType Code --- Yes

HFM = Sold As WoodType Full Name

L Pieces WSX Pieces --- Export Customers Only

M Length (Sold As) WSX Length of Sold As WoodType LOADLENGTH Yes

N Gross Weight WSX Gross Weight --- No

O Tare Weight WSX Tare Weight --- No

P Net Weight WSX Net Weight --- Yes

Q Loader No. WSX Loader Number (not code) --- Yes

R Blank --- --- --- ---

S At Customer Date & Time WSX At Customer Date & Time --- Yes

T Loaded Date & Time WSX Loaded Date & Time --- Yes

U Blank --- --- --- ---

V Blank --- --- --- ---

W Blank --- --- --- ---

X Blank --- --- --- ---

Y JAS WSX JAS (volume) --- Export Customers Only

Z Blank --- --- --- ---

AA Log Grade (Cut As) WSX AFL = Cut As WoodType Code --- Yes

HFM = Cut As WoodType Full Name

AB Blank --- --- --- ---

AC Entry Source WSX Hardcoded to E (=Electronic) --- Yes

AD Customer WSX Customer Code CUSTOMER Yes

AE Destination WSX Destination Code DESTINATION Yes

AF Blank --- --- --- ---

AG Weighbridge WSX Weighbridge from Journey --- Yes

Note: If no weighbridge = *W

AH Supplier WSX Supplier Code --- Yes

AI Blank --- --- --- ---

AJ Backload WSX Backload on Journey (Y or N) --- Yes

AK Compartment WSX Compartment Code --- Yes

Note: If NZFM Log Org = Gang Locn Op Code

AL Trucking Contractor WSX Trucking Contractor Code TRUCKCON Yes

AM Forest WSX Forest Short Code (excl Supplier) --- Yes

Note: If gang is a Log yard = Gang Number

AN Setting WSX Setting --- Yes

AO Compartment WSX Compartment Code --- Yes

AP Log Org WSX Log Org Code --- Yes

AQ Journey No. WSX Journey Number --- Yes

Note: Excluded from AFL version

AR Off Highway WSX Off Highway on Journey (Y or N) --- Yes

Note: Excluded from AFL version

AS CTI WSX CTI on Truck (0 or 1) --- Yes

AT Purchase Docket WSX Purchase Docket (PDkt) on Uplift --- No

AU Permits WSX Permits on Journey (Y or N) --- Yes