H,A,111111,USER
L,Smith,demo,admin,1,[email protected],en_US
Leaf Stream Loader
LeafStreams.template file
The Leaf Stream loader (formerly Data Stream Loader) allows you to describe the format for the data stream file you intend to bulk load or extract. For example, not all companies use all the fields allowed or specify them in the same column position. The Integrator lets you specify which fields you are using and the column position of each field. Basically, you are describing how your ASCII-delimited data stream files are structured - the fields contained in your data streams and the columns in which the fields appear. The validation rules for this parser are described in “Integrator Data Loader and Data Extractor Field Definitions."
Once you devise an adequate format, you should not have to change or modify this file for subsequent data loads sent to you by the trading partner as long as subsequent data streams adhere to the agreed-upon format.
Any or all of the following fields are allowed described in Table 5, “Leaf Stream Loader Fields”.
When the Integrator has completed the loading process, it will move the last data file from the file group to the archive directory.
Telephone Number User telephone number Fax Number User FAX number
Note: If the same record exists in two different data files in the same load, it is treated as a duplicate record.
Note: The streams for which you wish to load data must be assigned to the company before you attempt the data load.
Note: If you are loading leaf stream data for balance streams on a daily database with consecutive periods and the “fill bucket” option turned on, it may result in multiple records for that stream type code.
If this occurs, the record will be rejected with a “duplicate rows” error.
Table A–5 (Cont.) Extract Format
Term Description
Leaf Stream Loader
Integrator Data Loader and Data Extractor Field Definitions A-9 After loading, file(s) will be created that contain a list of any missing products,
locations and periods for the Leaf Stream and Aggregate Stream Loaders. A sample list would resemble the following:
//Products not found
If you want to overwrite Comments (that have already been loaded) with spaces, comments value should be " ". i.e., Null during loading.
Note: When the creator company loads data, Xt will check for pre-existing collaborations. If collaborations exist, partner collaborations will not be created.
Table A–6 Leaf Stream Loader Fields
Column Description Value Optional
Creator Company ID
The Global Company ID of the company that created the data for the stream.
Up to 40 characters
Yes*
Creator Location ID
The location ID of the company. Up to 40 characters
Yes*
Partner Company ID
Your trading partner’s company ID. Up to 40 characters
Yes*
Partner Location ID
Your trading partner’s location ID. Up to 40 characters
The type code you configured for the data stream.
Type Code No
Period Begin The data stream’s beginning time period. YYYYMMDD No Period End The data stream’s ending time period. YYYYMMDD No Data Stream
Item Type Code
The item type code you configured for the data stream item.
Item Type Code No
Quantity The data amount. Numeric No
Creation date The creation date of the stream. You cannot load a stream into the current stream table that has a creation date less than or equal to the prev_creation_date. For example, if you loaded a stream with a creation date of 10/30/2001, and the previous date is 10/29/2001, you cannot load a new stream with a date equal to or prior to 10/29/2001.
Also note that the creation date is translated into GMT in the database according to the time zone selected.
Format:
YYYYMMdd or YYYYMMdd HHmmSS
or YYYYMMdd HHmmssSS
No Table A–6 (Cont.) Leaf Stream Loader Fields
Column Description Value Optional
Leaf Stream Loader
Integrator Data Loader and Data Extractor Field Definitions A-11 Reason Code The reason for the change to the data stream. The comment
reason codes are as follows:
0 = none specified 1 = New
7 = Miscellaneous event
8 = Production issue
9 = Distribution issue
14 = Forward buy 15 = Price change 16 = Revised plan (re-plan)
17 = Product changeover 18 = New product 19 = Discontinued product
20 = New location 21 = Store closure
Yes
Comment A comment that is associated with the product data stream.
Up to 1000 characters
Yes Table A–6 (Cont.) Leaf Stream Loader Fields
Column Description Value Optional
Unit of Measure Unit of measure used for products in the data stream. The default base units UOM is
“EA”, which is the default if left blank. UOM field could be blank or Base UOM if the quantity you are loading is in Base Units.
Use custom UOM if the quantity you are loading is in converted units.
If you are using a UOM other than the default, for example CASES, the UOM you are using must be available in the UOM table. It must match the UOM specified in the “Other UOM” field for this company and other Global Item Number.
Yes
User name The name of the user responsible for the data load.
The ID Type of the company that created
data for the stream. Numeric Yes
Creator Company Alternate ID
The Alternate ID of the Creator Company Up to 40 characters
The Alternate ID Type of the Creator
Company Numeric. Yes
Creator Location ID Type
The ID Type of the Creator Location Numeric. Yes
Creator Location Alternate ID
The Alternate ID of the Creator Location Up to 40 characters
The Alternate ID Type of the Creator
Location Numeric Yes
Partner Company ID Type
The ID Type of the Partner Company Numeric Yes
Partner Company Alternate ID
The Alternate ID of the Partner Company Up to 40 characters
The Alternate ID Type of the Partner
Company Numeric Yes
Partner Location ID Type
The ID Type of the Partner Location Numeric. Yes
Partner Location Alternate ID
The Alternate ID of the Partner Location Up to 40 characters
Yes*
Table A–6 (Cont.) Leaf Stream Loader Fields
Column Description Value Optional
Leaf Stream Loader
Integrator Data Loader and Data Extractor Field Definitions A-13 Conditionally Optional Fields
*Although marked “Yes” in the Optional column, these fields are conditionally optional, based on whether or not other information has been provided. The introduction of “Alternate” IDs in version 6.1 means that not only are the Alternate fields optional, but the Global fields become optional if a matching Alternate field is provided. VCC requires that some ID be given, whether it is global, alternate, or both for Location, Partner Location, Company, and Product.
For example, if you supply the “Creator Company Alternate ID”, you have the option of providing the global “Creator Company ID”, and vice versa. One or the other must be provided and you may supply both if desired.
Partner Location Alternate ID Type
The Alternate ID Type of the Partner Location.
Numeric Yes
Global Item Number Type
The product’s Type of Global Item Number. Numeric. Yes
Local Item Number
A proprietary unique identifier for this product.
The Type of Local Item Number Numeric. Yes
Revision Status Revision Status Codes:
“0” or nothing specified = none 1 = new
Table A–7 Type Constants for Product
Column Description
GTIN 1
UPC 2
SELLER_ASSIGNED 3
BUYER_ASSIGNED 4
Table A–8 Type Constants for Company and Location
Column Description
Table A–6 (Cont.) Leaf Stream Loader Fields
Column Description Value Optional
If the creator company is a buyer company, it cannot load the leaf stream and aggregate data for seller-only editable streams. If the creator company is a seller company, it cannot load the leaf stream and aggregate data for buyer-only editable streams.
Note that in the Creation Date field, if the hour, minute, or seconds is more than 24, 60 and 60 respectively, the date is moved forward. For example: 20020210340101
(YYYYMMddHHmmss - GMT) becomes 20020211100101.
Sample Leaf Stream Loader Datafile
The following sample files use the pipe (|) character as the file delimiter.
20011018203631 |Dave Wilson |10-124-1107 |10-124-1107-0001 |30-333-3333
|30-333-3333-0001 |0168846122 |20020107 |20020113 |21 |17 |1 |Comment |0
Revision Status Codes for Leaf Stream Loader Blank or “0” ---> None
1 ---> New
2 ---> Acknowledged 3 ---> Accepted 4 ---> Rejected 5 ---> Superseded
Creator Role Constants for Extractor Buyer --->2
Seller --->1