| |
|
Definitions and formats for adding data to the Forecast Exchange
|
| |
SUPP
|
Defines Supplier
|
| |
DCWH
|
Defines retailer distribution centers and warehouses
|
| |
UPC
|
Defines UPCs
|
| |
PGP#
|
Defines product groups
|
| |
LINK
|
Places products in the product groups and places product groups within broader product groups
|
|
|
Definitions and formats to load forecast/demand/promotional data to the Forecast Exchange
|
| |
FCST
|
Forecast data (EDI830 is supported)
|
| |
DMND
|
Order data
|
| |
PROM
|
Promotional data
|
|
|
Supplier - SUPP Format
|
|
Field
|
Max
Length
|
Type
|
Required
|
Description
|
|
Format Type
|
4
|
NUM
|
Y
|
The format type identifies the record type. In this case, it should be SUPP
|
|
Supplier Number
|
25
|
NUM
|
Y
|
Supplier ID number referenced by EDI transactions
|
|
Supplier Name
|
25
|
CHAR
|
Y
|
Supplier Name
|
|
Supplier Description
|
50
|
CHAR
|
Y
|
If not provided, default to Supplier Name
|
|
Example:
SUPP,56743,Coventry Consumer Labs,Coventry Consumer Pharmaceuticals Labs
|
| |
|
DC/Warehouse - DCWH Format
|
|
Field
|
Max
Length
|
Type
|
Required
|
Description
|
|
Dataload Format
|
4
|
NUM
|
Y
|
The format type identifies the record type. In this case, it should be DCWH
|
|
Warehouse Number
|
25
|
CHAR
|
Y
|
This is either GLN, Ucc/EAN, or DUNS+4
|
|
Warehouse Name
|
25
|
CHAR
|
Y
|
Warehouse Name
|
|
Warehouse Description
|
50
|
CHAR
|
Y
|
If not provided, default to Warehouse Name
|
|
Example:
DCWH,888347190234,North Philadelphia PA,North Philadelphia PA Warehouse
|
| |
|
UPC - UPC Format
|
|
Field
|
Max
Length
|
Type
|
Required
|
Description
|
|
Dataload Format
|
4
|
NUM
|
Y
|
The format type identifies the record type. In this case, it should be UPC
|
|
UPC
|
25
|
NUM
|
Y
|
UPC
|
|
SKU Codes
|
25
|
CHAR
|
Y
|
Supplier and Retailer SKU numbers
|
|
UPC Description
|
50
|
CHAR
|
Y
|
If not provided, default to UPC Name
|
|
Example:
UPC,01133334455,SU123123 RE 888732,16 oz Seasonal Amber Ale Limited Edition
|
| |
|
Product Groups - PGP# format
|
|
First Grouping Level
|
|
Field
|
Max
Length
|
Type
|
Required
|
Description
|
|
Dataload Format
|
4
|
CHAR
|
Y
|
The format type identifies the record type. In this case, it should be PGP3
|
|
Product Group 3
|
25
|
CHAR
|
Y
|
Product Group 3
|
|
Product Group 3 Name
|
25
|
CHAR
|
Y
|
Product Group 3 Name
|
|
Product Group 3 Description
|
50
|
CHAR
|
Y
|
Product Group 3 Description
|
Example:
PGP3,Baby Products,Baby Products,Baby Products
|
|
Second Grouping Level
|
|
Field
|
Max
Length
|
Type
|
Required
|
Description
|
|
Dataload Format
|
4
|
CHAR
|
Y
|
The format type identifies the record type. In this case, it should be PGP2
|
|
Product Group 2
|
25
|
CHAR
|
Y
|
Product Group 2
|
|
Product Group 2 Name
|
25
|
CHAR
|
Y
|
Product Group 2 Name
|
|
Product Group 2 Description
|
50
|
CHAR
|
Y
|
Product Group 2 Description
|
Example:
PGP2,Childcare,Childcare,Childcare
|
|
Third Grouping Level
|
|
Field
|
Max
Length
|
Type
|
Required
|
Description
|
|
Dataload Format
|
4
|
CHAR
|
Y
|
The format type identifies the record type. In this case, it should be PGP1
|
|
Product Group 1
|
25
|
CHAR
|
Y
|
Product Group 1
|
|
Product Group 1 Name
|
25
|
CHAR
|
Y
|
Product Group 1 Name
|
|
Product Group 1 Description
|
50
|
CHAR
|
Y
|
Product Group 1 Description
|
Example:
PGP1,Consumer Goods,Consumer Goods,Consumer Goods
|
|
|
| |
|
Linking - LINK Format
|
|
Field
|
Max
Length
|
Type
|
Required
|
Description
|
|
Dataload Format
|
4
|
CHAR
|
Y
|
The format type identifies the record type. In this case, it should be LINK
|
|
Child Type
|
4
|
CHAR
|
Y
|
Child's Data Type (UPC, PGP2, or PGP3)
|
|
Child Value
|
25
|
CHAR
|
Y
|
UPC or Product Group value
|
|
Parent Type
|
4
|
CHAR
|
Y
|
Parent's Data Type (PGP1, PGP2 or PGP3)
|
|
Parent Value
|
25
|
CHAR
|
Y
|
Product Group 1,2 or 3
|
|
Examples:
LINK,UPC,1232133232221,PGP3,Baby Products
LINK,PGP3,Baby Products,PGP2,Childcare
LINK,PGP2,Childcare,PGP1,Consumer Goods
|
| |
|
Forecast - FCST Format
|
|
Field
|
Max
Length
|
Type
|
Required
|
Description
|
|
Dataload Format
|
4
|
CHAR
|
Y
|
The format type identifies the record type. In this case, it should be FCST
|
|
Forecast Source
|
2
|
CHAR
|
Y
|
Who is supplying forecast - "FC" if retailer/"BD" if supplier
|
|
Vendor Code
|
25
|
NUM
|
Y
|
Vendor ID referenced by EDI transactions
|
|
Forecast Year
|
4
|
NUM
|
Y
|
Year that period being forecast falls in (YYYY format)
|
|
DC/Warehouse
|
25
|
CHAR
|
Y
|
This is either GLN,UCC/EAN, or DUNS+4
|
|
UPC
|
25
|
NUM
|
Y
|
UPC
|
|
Quantity
|
|
NUM
|
Y
|
Forecast quantity
|
|
Calendar Period
|
10
|
NUM
|
Y
|
Period number
|
|
Examples:
FCST,BD,33356,2004,00088,01133334455,5500,22
|
| |
|
Demand - DMND Format
|
|
Field
|
Max
Length
|
Type
|
Required
|
Description
|
|
Dataload Format
|
4
|
CHAR
|
Y
|
The format type identifies the record type. In this case, it should be DMND
|
|
Sales Data Type
|
3
|
CHAR
|
Y
|
Always "S01"
|
|
Vendor Code
|
25
|
NUM
|
Y
|
Vendor ID referenced by EDI transactions
|
|
Sales Year
|
4
|
NUM
|
Y
|
Year that period being forecast falls in (YYYY format)
|
|
DC/Warehouse
|
25
|
CHAR
|
Y
|
This is either GLN,UCC/EAN, or DUNS+4
|
|
UPC
|
25
|
NUM
|
Y
|
UPC
|
|
Quantity
|
|
NUM
|
Y
|
Demand quantity or shipment quantity
|
|
Calendar Period
|
10
|
NUM
|
Y
|
Period number
|
|
Examples:
DMND,S01,33546,2004,00088,01133334455,3343,22
|
| |
|
Promotions - PROM Format
|
|
Field
|
Max
Length
|
Type
|
Required
|
Description
|
|
Dataload Format
|
4
|
CHAR
|
Y
|
The format type identifies the record type. In this case, it should be PROM
|
|
Promotion Source
|
2
|
CHAR
|
Y
|
Who is supplying promotional data - "FC" if retailer / "BD" if supplier
|
|
Vendor Code
|
25
|
NUM
|
Y
|
Vendor ID referenced by EDI transactions
|
|
Promotion Year
|
4
|
NUM
|
Y
|
Year that promotion falls in (YYYY format)
|
|
DC/Warehouse
|
25
|
CHAR
|
Y
|
This is either GLN,UCC/EAN, or DUNS+4
|
|
UPC
|
25
|
NUM
|
Y
|
UPC
|
|
Quantity
|
|
NUM
|
Y
|
Demand quantity or shipment quantity
|
|
Calendar Period
|
10
|
NUM
|
Y
|
Period number
|
|
Examples:
PROM,FC,33356,2004,00088,01133334455,5000,22
|
| |
|
|
|
