Understanding the File Structures

1
Understanding the File Structures

• 13th November 2008 Finning Group

2
Agenda
1000 MUA Update 1015 Introductions 1030 Nami
ng Conventions 1115 Coffee 1130 Vision
Solutions 1230 Lunch 1330 Archiving
Models 1430 Coffee 1445 General
Discussion 1530 Close
3
Mission Statement
The User Association is formed to look after the
interest of its members with regard to the
benefits provided by their association with MOVEX
and to encourage information exchange between its
members
4
Web Site
www.mua.org.uk

• Home, About Us, Calendar general view
• Other areas limited to members only
• Presentation minutes available for downloads.
• Members company details
• Committee meeting minutes
• If you wish a user-id password simply contact
  me.

5
Global Association of M3 User Groups
1. Support 2. Product Enhancements 3.
Training / Education 4. Partners /
Consultants
6
Product Enhancements

• 39 Of the enhancement ideas are already standard
  in M3 7.1
• 10 enhancement ideas partially answered in M3
  7.1
• 7 enhancement ideas given as input into user
  interface development group
• 5 enhancement ideas have triggered a research
  project into improved reporting in M3
• 17 enhancement ideas have been planned into the
  next release of M3
• 8 of the top 10 ideas - will influence the
  future of Lawson M3
• 79 out of 303 received positive feedback

7
Introductions
8
Movex Naming Conventions

• Designing an ERP system circa 1990
• Movex subsystem naming convention (original)
• Movex Data File Naming Convention
• Movex Data Logic
• Movex Field Naming Convention
• Linking Movex Files
• Logical Files
• Customer Order Files (explosion)
• Movex Processing
• Customer Order Status

9
ERP Master Files
10
ERP Master Files
11
ERP Master Files
Customers
12
ERP Master Files
Customers
13
ERP Master Files
Customers
Transactions
14
ERP Master Files
Customers
Transactions
15
ERP Master Files
Customers
Orders
Transactions
16
ERP Master Files
Customers
Orders
Transactions
17
ERP Master Files
Common Data
Customers
Orders
Transactions
18
ERP Master Files
Common Data
Customers
Orders
Transactions
19
ERP Master Files
Common Data
Customers
Calendar
Orders
Transactions
20
ERP Master Files
Common Data
Customers
Calendar
Orders
Transactions
21
ERP Master Files
Common Data
Customers
Calendar
Orders
Transactions
Items
22
ERP Master Files
Common Data
Customers
Calendar
Orders
Transactions
Items
23
ERP Master Files
Common Data
Customers
Calendar
Orders
Transactions
Material
Items
24
ERP Master Files
Common Data
Customers
Calendar
Orders
Transactions
Material
Items
25
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Transactions
Material
Items
26
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Transactions
Material
Items
27
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Material
Items
28
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Material
Items
29
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Material
Production
Items
30
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Material
Production
Items
31
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
32
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
33
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Employees
34
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Employees
35
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Labour
Employees
36
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Labour
Employees
37
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Labour
Accounts
Employees
38
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Labour
Accounts
Employees
39
ERP Master Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Labour
Finance
Accounts
Employees
40
Movex Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Labour
Finance
Accounts
Employees
41
Movex Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Labour
Finance
1999
Accounts
Employees
42
Movex Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Finance
Accounts
43
Movex Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Finance
Accounts
44
Movex Databases
45
Movex Databases
DTA
46
Movex Databases
DTA
47
Movex Databases
ENV
DTA
48
Movex Databases
Users Programs Security
ENV
DTA
49
Movex Files
Common Data
Customers
Suppliers
Calendar
Orders
Invoices
Transactions
Products
Material
Production
Items
Finance
Accounts
50
Movex Files
Common Data
Customers
Suppliers
Orders
Calendar
Invoices
Transactions
Products
Material
Production
Items
Finance
Accounts
51
Movex Files
Common Data
Calendar
Customers
Suppliers
Orders
Invoices
Transactions
Production
Products
Items
Material
Finance
Accounts
52
Movex Modules
Common Data
Calendar
Customers
Suppliers
Orders
Invoices
Transactions
Production
Products
Items
Material
Finance
Accounts
53
Movex Modules
Common Data
Calendar
Customers
Suppliers
Orders
Invoices
Production
Products
Items
Material
Finance
Accounts
54
Movex Modules
Common Data
Calendar
Customers
Suppliers
Orders
Invoices
Production
Products
Items
Material
Finance
Accounts
55
Movex Modules
Common Data
Calendar
Customers
Suppliers
Orders
Invoices
Production
Products
Items
Material
Finance
Accounts
56
Movex Modules
Common Data
Calendar
Customers
Suppliers
Orders
Invoices
Production
Products
Items
Material
Finance
Accounts
57
Movex Modules
Common Data
Calendar
Customers
Suppliers
O
Invoices
Production
Products
Items
Material
Finance
Accounts
58
Movex Modules
Common Data
C
Customers
Suppliers
O
I
Production
P
Items
M
F
Accounts
59
Movex File Naming Convention

• All data file names 6 alpha characters
• 1st character denotes main module.
• - O - Customers Sales Orders
• - I - Suppliers Purchase Orders
• - M - Items Materials Management
• - P - Products Production Management
• - F - Finance Ledgers
• - C - Common data Calendars, System Values

60
Movex File Naming Convention

• All data file names 6 alpha characters
• 1st character denotes main module.
• - O - Customers Sales Orders
• - I - Suppliers Purchase Orders
• - M - Items Materials Management
• - P - Products Production Management
• - F - Finance Ledgers
• - C - Common data Calendars, System Values
• - Z - Modified Custom Built

61
Movex File Naming Convention

• All data file names 6 alpha characters
• 1st character denotes main module.
• - O - Customers Sales Orders
• - C - Suppliers Purchase Orders
• - M - Items Materials Management
• - P - Products Production Management
• - F - Finance Ledgers
• - C - Common data Calendars, System Values
• - Z - Modified Custom Built

62
Movex File Naming Convention

• All data file names 6 alpha characters
• remaining characters give reasonable description.
• OCUSMA - Customer Master
• CIDMAS - Supplier Master
• MITMAS - Item Master
• CSYTAB - System Reference Table

63
Movex File Naming Convention

• All data file names 6 alpha characters
• Lets look at Customer Orders more closely.
• OOHEAD - Customer Order Header
• OOLINE - Customer Order Lines
• ODHEAD - Customer Delivery Header
• ODLINE - Customer Delivery Lines

64
Movex File Naming Convention

• All data file names 6 alpha characters
• Lets look at Customer Orders more closely.
• OOHEAD - Customer Order Header
• OOLINE - Customer Order Lines
• ODHEAD - Customer Delivery Header
• ODLINE - Customer Delivery Lines

65
Movex File Naming Convention

• All data file names 6 alpha characters
• Lets look at Customer Orders more closely.
• OOHEAD - Customer Order Header
• OOLINE - Customer Order Lines
• ODHEAD - Customer Delivery Header
• ODLINE - Customer Delivery Lines
• OSASTD - Order Statistics (Detail)
• OSBSTD - Invoice Statistics (Detail)

66
Movex File Naming Convention

• All data file names 6 alpha characters
• Lets look at Customer Orders more closely.
• OOHEAD - Customer Order Header
• OOLINE - Customer Order Lines
• ODHEAD - Customer Delivery Header
• ODLINE - Customer Delivery Lines
• OSASTD - Order Statistics (Detail)
• OSBSTD - Invoice Statistics (Detail)

67
Movex File Naming Convention

• All data file names 6 alpha characters
• Watch out for files ending in-
• H - Header
• D - Detail
• L - Line
• S - Summary
• Not always consistent throughout the system.

68
Movex Data Logic
69
Movex Data Logic
Company
70
Movex Data Logic
Company
Division
71
Movex Data Logic
Company
Division
Facility
72
Movex Data Logic
Company
Division
Facility
Warehouse
73
Movex Data Logic
Company
Division
Facility
Warehouse
Location
74
Movex Data Logic
Group
Company
Division
Facility
Warehouse
Location
75
Movex Data Logic
Group
Company
Country
Division
Facility
Warehouse
Location
76
Movex Data Logic
Group
Company
Country
Division
Company
Facility
Warehouse
Location
77
Movex Data Logic
Group
Company
Country
Division
Company
Facility
Site
Warehouse
Location
78
Movex Data Logic
Group
Company
Country
Division
Company
Facility
Site
Warehouse
Bin
Location
79
Movex Data Logic
Group
CONO
Company
Country
DIVI
Division
Company
FACI
Facility
Site
WHLO
Warehouse
Bin
LOCN
Location
80
Movex Data Logic
Group
CONO
Company
Country
DIVI
Division
Company
FACI
Facility
Site
WHLO
Warehouse
Bin
LOCN
Location
81
Movex Data Logic
These fields are on every record CONO - Company
Number RGDT     - Entry Date RGTM    - Changed
Time LMDT     - Changed Date CHNO    - Change
Number CHID      - Changed By
82
Movex Data Logic
These fields are on every record CONO - Company
Number this is a key RGDT     - Entry
Date RGTM    - Changed Time LMDT     - Changed
Date CHNO    - Change Number CHID     
- Changed By
83
Movex File Naming Convention

• All data files 6 alpha characters
• Lets look at Customer Orders more closely.
• OOHEAD - Customer Order Header
• OOLINE - Customer Order Lines
• ODHEAD - Customer Delivery Header
• ODLINE - Customer Delivery Lines
• OSASTD - Order Statistics (Detail)
• OSBSTD - Invoice Statistics (Detail)

84
Movex Field Naming Convention

• All data files 6 alpha characters
• Lets look at Customer Order Header more closely.
• (OOHEAD - Customer Order Header)

85
Movex Field Naming Convention

• All data field names 6 alpha characters
• Lets look at Customer Order Header more closely.
• (OOHEAD - Customer Order Header)
• OACONO - Company Number this is a key
• OARGDT     - Entry Date
• OARGTM    - Changed Time
• OALMDT     - Changed Date
• OACHNO    - Change Number
• OACHID      - Changed By

86
Movex Field Naming Convention

• All data field names 6 alpha characters
• Lets look at Customer Order Header more closely.
• (OOHEAD - Customer Order Header)
• OACONO - Company Number this is a key
• OARGDT     - Entry Date
• OARGTM    - Changed Time
• OALMDT     - Changed Date
• OACHNO    - Change Number
• OACHID      - Changed By

87
Movex Field Naming Convention

• All data field names 6 alpha characters
• Lets look at Customer Order Header more closely.
• (OOHEAD - Customer Order Header)
• OACONO - Company Number this is a key
• OARGDT     - Entry Date
• OARGTM    - Changed Time
• OALMDT     - Changed Date
• OACHNO    - Change Number
• OACHID      - Changed By

88
Movex Field Naming Convention

• All data field names 6 alpha characters
• Lets look at Customer Order Header more closely.
• (OOHEAD - Customer Order Header)
• OACONO - Company Number this is a key
• OARGDT     - Entry Date
• OARGTM    - Changed Time
• OALMDT     - Changed Date
• OACHNO    - Change Number
• OACHID      - Changed By

89
Movex Field Naming Convention

• All data field names 6 alpha characters
• Lets look at Customer Order Header more closely.
• (OOHEAD - Customer Order Header)
• OACONO - Company Number
• OAORNO     - Order No
• OACUNO    - Customer Number
• All the above are keyed fields

90
Linking Files
OOHEAD
Order Header
91
Linking Files
OOHEAD
Order Header
OA
92
Linking Files
OOHEAD
Order Header
Customers
OA
93
Linking Files
OCUSMA
OOHEAD
Order Header
Customers
OK
OA
94
Linking Files
OCUSMA
OOHEAD
Order Header
Customers
OK
OA
OKCUNO EQ OACUNO
95
Linking Files
OCUSMA
OOHEAD
Order Header
Customers
OK
OA
OKCONO EQ OACONO OKCUNO EQ OACUNO
96
Linking Files
OCUSMA
OOHEAD
Order Header
Customers
Order Lines
OK
OA
OKCONO EQ OACONO OKCUNO EQ OACUNO
97
Linking Files
OCUSMA
OOHEAD
OOLINE
Order Header
Customers
Order Lines
OK
OB
OA
OKCONO EQ OACONO OKCUNO EQ OACUNO
98
Linking Files
OCUSMA
OOHEAD
OOLINE
Order Header
Customers
Order Lines
OK
OB
OA
OKCONO EQ OACONO OKCUNO EQ OACUNO
OAORNO EQ OBORNO
99
Linking Files
OCUSMA
OOHEAD
OOLINE
Order Header
Customers
Order Lines
OK
OB
OA
OKCONO EQ OACONO OKCUNO EQ OACUNO
OACONO EQ OBCONO OAORNO EQ OBORNO
100
Linking Files
OCUSMA
OOHEAD
OOLINE
Order Header
Customers
Order Lines
OK
OB
OA
OKCONO EQ OACONO OKCUNO EQ OACUNO
OACONO EQ OBCONO OAORNO EQ OBORNO
101
Linking Files
OCUSMA
OOHEAD
OOLINE
Order Header
Customers
Order Lines
OK
OB
OA
OKCONO EQ OACONO OKCUNO EQ OACUNO
OACONO EQ OBCONO OAORNO EQ OBORNO
102
Linking Files
OCUSMA
OOHEAD
OOLINE
Order Header
Customers
Order Lines
OK
OB
OA
OKCONO EQ OACONO OKCUNO EQ OACUNO
OACONO EQ OBCONO OAORNO EQ OBORNO
103
Movex Logical Files

• All logical file names 8 alpha numeric characters
• First 6 from data file 2 numeric
• OOHEAD00 - Customer Order Header - main
• OACONO - Company Number
• OAORNO     - Order No

104
Movex Logical Files

• All logical file names 8 alpha numeric characters
• First 6 from data file 2 numeric
• Added by Movex Developers
• Vastly improve performance of data access
• - Movex, Reports, etc
• Many logical files to every data file
• Logical files are much smaller than data files
• Many not used by your company
• Those not used waste disk space processor power
• Remove / archive where not used

105
Customer Order Files
OCUSMA
OOHEAD
Order Header
Customers
106
Customer Order Files
OODOCU
OOADRE
OOCHRG
Delivery Addresses
Documents
Charges
OCUSMA
OOHEAD
Order Header
Customers
107
Customer Order Files
OODOCU
OOADRE
OOCHRG
Delivery Addresses
Documents
Charges
OCUSMA
OOHEAD
Order Header
Customers
OSYTXH
Text Header
OSYTXL
Text Line
108
Customer Order Files
OODOCU
OOADRE
OOCHRG
Delivery Addresses
Documents
Charges
OCUSMA
OOHEAD
Order Header
Customers
OOLINE
OSYTXH
Order Lines
Text Header
OSYTXL
Text Line
109
Customer Order Files
OODOCU
OOADRE
OOCHRG
Delivery Addresses
Documents
Charges
OCUSMA
OOHEAD
Order Header
Customers
OOLINE
OSYTXH
Order Lines
Text Header
OSYTXL
OSASTD
Order Statistics
Text Line
110
Customer Order Files
OODOCU
OOADRE
OOCHRG
Delivery Addresses
Documents
Charges
OCUSMA
OOHEAD
Order Header
Customers
OOLINE
OSYTXH
Order Lines
Text Header
OSYTXL
OSASTD
Order Statistics
Text Line
111
Customer Order Files
OODOCU
OOADRE
OOCHRG
Delivery Addresses
Documents
Charges
OCUSMA
OOHEAD
OPRICH
Order Header
Price List Header
Customers
OOLINE
OSYTXH
OPRICL
Order Lines
Text Header
Price List
OSYTXL
OSASTD
Order Statistics
Text Line
112
Customer Order Files
OODOCU
OOADRE
OOCHRG
Delivery Addresses
Documents
Charges
OCUSMA
OOHEAD
OPRICH
Order Header
Price List Header
Customers
OOLINE
OSYTXH
OPRICL
Order Lines
Text Header
Price List
OSYTXL
OSASTD
OKITDI
OORESP
Order Statistics
Kit Details
Text Line
Responsibty
113
Customer Order Files
OODOCU
OOADRE
OOCHRG
Delivery Addresses
Documents
Charges
ODHEAD
OCUSMA
OOHEAD
OPRICH
Delivery Header
Order Header
Price List Header
Customers
OOLINE
OSYTXH
OPRICL
Order Lines
Text Header
Price List
OSYTXL
OSASTD
OKITDI
OORESP
Order Statistics
Kit Details
Text Line
Responsibty
114
Customer Order Files
OODOCU
OOADRE
OOCHRG
Delivery Addresses
Documents
Charges
ODHEAD
OCUSMA
OOHEAD
OPRICH
Delivery Header
Order Header
Price List Header
Customers
OOLINE
ODLINE
OSYTXH
OPRICL
Order Lines
Delivery Lines
Text Header
Price List
OSYTXL
OSASTD
OKITDI
OORESP
Order Statistics
Kit Details
Text Line
Responsibty
115
Customer Order Files
OODOCU
ODDOCU
OOADRE
OOCHRG
Delivery Documents
Delivery Addresses
Documents
Charges
ODHEAD
OCUSMA
OOHEAD
OPRICH
Delivery Header
Order Header
Price List Header
Customers
OOLINE
ODLINE
OSYTXH
OPRICL
Order Lines
Delivery Lines
Text Header
Price List
OSYTXL
OSASTD
OKITDI
OORESP
Order Statistics
Kit Details
Text Line
Responsibty
116
Customer Order Files
OODOCU
ODDOCU
OOADRE
OOCHRG
Delivery Documents
Delivery Addresses
Documents
Charges
ODHEAD
OCUSMA
OOHEAD
OPRICH
Delivery Header
Order Header
Price List Header
Customers
OOLINE
ODLINE
OSYTXH
OPRICL
Order Lines
Delivery Lines
Text Header
Price List
OSYTXL
OSASTD
OKITDI
OORESP
OSBSTD
Order Statistics
Kit Details
Sales Statistics
Text Line
Responsibty
117
Customer Order Files
OODOCU
ODDOCU
OOADRE
OOCHRG
Delivery Documents
Delivery Addresses
Documents
Charges
ODHEAD
OINVOH
OCUSMA
OOHEAD
OPRICH
Delivery Header
Invoice Header
Order Header
Price List Header
Customers
OOLINE
ODLINE
OINVOL
OSYTXH
OPRICL
Order Lines
Delivery Lines
Invoice Lines
Text Header
Price List
OSYTXL
OSASTD
OKITDI
OORESP
OSBSTD
OINACC
Order Statistics
Kit Details
Sales Statistics
Invoice Account
Text Line
Responsibty
118
Movex Processing
Real Time o
r Online
119
Movex Processing
Real Time
o Transactions updated as you hit enter. Data
is always up to date Massive resource
implications
r Online
120
Movex Processing
Real Time
o Transactions updated as you hit enter. Data
is always up to date Massive resource
implications
r Online Some transactions updated
as you hit enter, others updated by background
jobs. Data not always up to date Less resource
implications
121
Movex Processing

• Movex is an Online system
• There are a number of background jobs
• Depending upon your AS/400 these can be quicken
  or slowed down, but great care should be taken
• There are also a number of Night Jobs

122
Customer Order Status

• Movex uses status throughout the whole system
• They are always 2 numeric characters
• On customer order headers there are two status
• - High status of the highest item (line)
• - Low status of the lowest item (line)

123
Customer Order Status
Status Description 0 No lines
1 Preliminary order 2 Unallocated
3 Allocated 4 Packed 5 Picked
6 Delivered 7 Invoiced
9 Cancelled / Deleted
124
Coffee Break
Re-start at 1130 am
125
Lunch
Re-start at 1400 pm
126
Close
Close at 1600 pm