1. Background of Data Analysis
1-4. Information Required for Data Analysis
1) File Types and Items
A. Item Master File
Item Code (incl. branch No.) Item Name
Case Pack Qty (Piece Qty) Case Dimensions W L H Weight
Inner Box Pack Qty Target Stock Period Pallet Stacking Pattern Qty
Item Traits (Storage Temp Shape, Material, Handling Method, Value-added Services)
B. Destination Master File
Destination Code Destination Category (Delivery Route / Work Conditions)
Destination Name Label/Tagging Requirement Special Invoice Requirement
C. Inbound Data
Date (Time) Item Code (incl. branch No.) Supplier Code
Quantity (Standardize unit: Piece or Case)
Inbound Traits & Special Conditions
D. Outbound Shipping Data
Date (Time) Shipping Category Truck Route Code
Ordering Customer Code Destination Code
Item Code (incl. branch No.) Quantity (Piece/Case, Unit Info)
Outbound Traits & Special Conditions
F. Inventory Data
Item Code (incl. branch No.) Quantity (Piece/Case, Unit Info)
Latest Receiving Date (Time) Location Code (Shelf) Storage Conditions
G. Return Data
Date (Time) Item Code (incl. branch No.)
Returning Customer Code Quantity (Piece/Case, Unit Info)
Return Conditions
2) Media & Format Specifications
A. Media Format
Standard PC Media: MO / CD / DVD
IBM Format (used in N5200 / AS400, rare)
Please specify Kanji encoding standard.
B. File Format
Text (Delimiter-separated or Fixed length), CSV, SYLK
MS Excel, Database (MS Access or Oracle)
Note: Excel has row limit constraints
[Explanation] From General Data Requirements to Practical Processing in Tera Calculation
For successful logistics data analysis, master data (such as Item Master) and transaction logs shown above are essential.
To proceed further into EIQ analysis and simulation modeling with Tera Calculation, specific outbound shipping data fields and internal processing steps are required.
Outbound shipping data imported into Tera Calculation consists of 13 specific fields:
- Basic Info & Timestamp: Sequence No., Shipping Date (DateTime), Shipping Time (DateTime)
- Core EIQ Elements: Destination Code (String), Item Code (String), Piece Quantity (Numeric)
- Grouping & Classification: Item Category, Shipping Category, Shipping Route (String)
- Master Conversion Values: Case Pack Qty, Pallet Case Qty, Case Volume, Case Weight (Numeric)
*These fields form the baseline for subsequent conversions and simulations.
After importing raw shipping data, the system calculates conversion values and rankings internally, creating the dataset known as the "T200" table.
Enables separate aggregation for Case shipping vs. Piece shipping.
Pre-computes Case count, Pallet count, Volume, and Weight per record.
Assigns independent E-rank and I-rank for both Case and Piece shipping per record.
Tera Calculation executes core analytical processing based on this "T200" table layout.