To download traffic data to an ASCII file, you can use the P.80.01 Download Traffic screen. Such files can be sent to the freight forwarder.
For downloading traffic data, approved agreements of type PO (purchase order) and NOC (notice of commitment) are available. Approved change orders of purchase orders or notices of commitment are taken into account when downloading data.
Select the name (number) of the order from the LOV in the Order Number field. The Suppl field displays the supplement number of the selected order. If the project default ZP_COSUPPL is set to N (default value), the supplement number of the order itself is displayed, even if COs have been created for the order and approved already. If ZP_COSUPPL is set to Y, the supplement number of the highest approved change order is shown. In any case, only the data of the latest change order is available.
The type of the selected order is displayed in the Order Type field.
The name of the origin of the selected order is displayed in the Origin field.
Select the load file format for the download of the supplier data from the LOV in the Format for Supplier Data field.
Select the load file format for the download of the item shipments from the LOV in the Format for Item Shipments field.
Load file formats can be defined on the A.10.37 Load File Formats screen. Only formats of the type 'TF' (Traffic) are available for selection in both fields.
The following attributes are available for the supplier data load file format (all of them are optional):
Supplier data:
-
supplier's name (SUPPLIER)
-
supplier's company (SUP_NAME)
-
last name of the contact person at the supplier (CONTACT)
-
telephone number of this contact person (PHONE)
-
supplier's address (address of the address type marked as agreement default on A.10.25 Address Types is selected) (ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY)
The following attributes are available for the item shipment data load file format (mandatory attributes are marked as required; the others are optional):
Item shipments data:
-
order number (PO_NUMBER) (required)
-
order supplement (PO_SUPP) (required)
-
client order number (CLIENT_PO_NUMBER)
-
project number (PROJ_ID)
-
line item pos (POLI_POS) (required)
-
line item sub pos (POLI_SUB_POS) (required)
-
item shipment pos (ITEM_SHIP_POS) (required)
-
item shipment sub pos (ITEM_SHIP_SUB_POS) (required)
-
ident short description (IDENT_DESC)
-
ident code (IDENT CODE)
-
commodity code (COMMODITY_CODE)
-
sizes 1 - 5 (SIZE_1 to _5)
-
tag number (TAG_NUMBER)
-
item shipment quantity (ITEM_SHIP_QTY)
-
unit of item shipment quantity (QTY_UNIT)
-
item shipment volume (ITEM_SHIP_VOLUME)
-
date of order approval (APPROVED_DATE)
-
promised ship date (PROM_SHIP_DATE)
-
required on site date (REQ_SITE_DATE)
-
unit price (UNIT_PRICE)
-
currency (CURRENCY)
-
routing method (ROUTING_METHOD)
The Export Path field displays the file system path where the export file is to be stored. This path is relative to the database server. Click the Default Dir button to populate the Export Path field with the default directory defined by the TRAFFIC_EXPORT_PATH DBA setting on the A.60.04 DBA Settings screen.
Enter the name of the file to be created by this download with its extension in the Export File field.
Click the Start Download button to start the download of traffic data.