Load file formats must be defined for these import/export jobs:
-
Format TF - used by P.80.01 Download Traffic
-
Format FT - used by P.90.01 Load Fab Tracking. To use load fab tracking, you must define a fabrication type.
-
Format PR - used by AS.10.03 Load Price
You can define load file formats using the A.10.37 Load File Formats screen.
To create a new load format, enter the format name in the Name field and select the appropriate type from the LOV on the Type field. For type FT, you must assign a fabrication type by selecting a predefined type from the LOV in the Fabrication Type field on the right. The fabrication types are defined on the P.10.91 Fabrications Types screen.
The details of the load format are defined in the second (Load Format Details) block of A.10.37. With the values in the From and To fields, you define the allocated position in the file for the assigned attribute.
For type FT (Fab Tracking, used on P.90.01), you can assign the following attributes:
CANCEL
HOLD_CODE
TAG (required)
All attributes of the fabrication type (optional)
For type PR (Prices, used on AS.10.03), the following attributes are available:
IDENT_CODE (required)
PRICE (required)
QUANTITY (required)
QUANTITY_UNIT (required)
ADDEND
FACTOR
COMMENTS
For type TF (Traffic, used on P.80.01 for downloading traffic data), the following attributes can be assigned:
For supplier data (all optional):
SUPPLIER
SUP_NAME
CONTACT
PHONE
ADDR1
ADDR2
CITY
STATE
ZIP
COUNTRY
For item shipments (all optional, exceptions given below):
PO_NUMBER (required)
PO_SUPP (required)
POLI_POS (required)
POLI_SUB_POS (required)
ITEM_SHIP_POS (required)
ITEM_SHIP_SUB_POS (required)
CLIENT_PO_NUMBER
PROJ_ID
IDENT_DESC
IDENT_CODE
COMMODITY_CODE
SIZE_1
SIZE_2
SIZE_3
SIZE_4
SIZE_5
TAG_NUMBER
ITEM_SHIP_QTY
QTY_UNIT
ITEM_SHIP_VOLUME
APPROVED_DATE
PROM_SHIP_DATE
REQ_SITE_DATE
UNIT_PRICE
CURRENCY
ROUTING_METHOD