SMS Data Files (Advanced)
LOADOWN.DAT

This data file is "downloaded" from other existing automated sources and will eventually be used in an on-going production environment.  It is highly complex and requires specific data definition of all fields.  Additionally, files for DRP, MRP and Supersession functions are often used in tandem with this production extract file.  Contact Decision Associates, Inc. at (630) 369-1810 with specific questions.

Data Element

1.  Location

Highest level grouping which summarizes several product groups and can be used for distribution requirements planning and/or manufacturing plant locations or warehouse locations

2.  Level Three
Intermediate level grouping which summarizes several product lines and is typically used to consolidate various product lines from a vendor or manufacturing source  

3.  Level Two
 Sub-groups which contain the lowest level of summarization which is usually a line of products within a product group      

4.  Item Number

Item tag commonly known as stock-keeping-unit or part number

5.  Item Description
Description of individual item or part

6.  Service Level
Target availability when needed -- this will be higher for important or costly items and will directly affect safety stock levels

7.  Ordering/Set-up Cost
This is the typical cost of processing or handling each order and is roughly equivalent to spreading all processing costs (e.g., staff, computer charges, etc.) Across all orders

8.  Standard Price
Existing sales or marketing price for each item which is used for relative comparison of inventory investment and margins -- this should not be construed to be a precise accounting tool for tracking item sales over time at varying prices

9.  Standard Cost  
Existing purchase or replacement cost for the item which would also be used for relative comparison of inventory investment and margins - this is also used in the determination of EOQ - as with PRICE, this should not be construed to be a precise accounting toll for tracking item sales over time at varying costs.

10.  Lead Time    
Time needed to deliver stock - from point of order requisition through receipt of stock into inventory.

11.  On-Hand

Available inventory currently on the shelf

12.  Back Orders  

Total stock on order by customers but not yet available

13.  Minimum Order Qty
Minimum amount which may be procured due to production constraints or vendor restrictions

14.  Incremental Order Qty
Multiples of lot sizes - or orders - procured according to production constraints or vendor requirements

15.  -  38.  Demand (past 24 months)
Past 24 months (or as many as may exist up to 24 months) of actual demand requests although not all may have been filled -- shipment history can be used if actual demand is not available -- forecasting patterns are derived from these demand values

39.  -  78.  Replenishment Orders
Existing orders to replenish stock which have already been placed -- they may be regularly scheduled or expedite orders  -- these may be either requisitions to suppliers or manufacturing orders

79.  -  90.  Known Future Demand
Any scheduled usage or sales that have been identified during the next twelve month period (slotted by month)

91. - 110.  Purchase Order Numbers
These fields contain the corresponding purchase order number for each REPLENISHMENT ORDER captured in fields   39 - 58.

111.  Emerency Reserve
Absolute minimum safety stock needed for item availability - used in maintenance inventories

112.  In-Use Inventory
Number of this specific item installed - or in place - which may require routine or emergency maintenance, even if not replaced over the past 24 months - used in maintenance inventories

113.  Manufacturer's Failure Rate
Expected failure rate projected by the manufacturer based on all customer experience - used in maintenance inventories

114.  Planner   
Planner initials for data split to individual user copies

115.  Class          
Inventory class for data structuring (i.e. A-B-C class)

116. - 125.  Discount Levels & Values
These are the "cutoff" levels at which the corresponding discount values take effect - may impact EOQ values

126.  Replenishment Source
This field is used in DRP environments where one location may be replenished from another location -- or directly from a vendor -- and enables SMS to "roll-up" requirements for each location so as to include both direct requirements and requirements for other locations, known at "TREQ" (total requirement)

127.  Min
This field is the current MIN in existing stock status systems that triggers an order

128.  Max
This field is the user's EOQ plus MIN value

Field

Format

Type

Start

Stop

1. Location

20 Alpha Characters

(A20)

1

20

2. Level Three

20 Alpha Characters

(A20)

21

40

3. Level Two

20 Alpha Characters

(A20)

41

60

4. Item Number

20 Alpha Characters

(A20)

61

80

5. Item Description

30 Alpha Characters

(A30)

81

110

6. Service Level

XX (85%- 99%)

(I2)

111

112

7. Order/Setup Cost

XXXX.XX

(F7.2)

113

119

8. Standard Price

XXXXXXXX.XX

(F10.2)

120

129

9. Standard Cost

XXXXXXXX.XX

(F10.2)

130

139

10. Lead Time (Weeks)

XX (01 - 99 Weeks)

I2

140

141

11. On-Hand (Units)

XXXXXXXX (Units)

I8

142

149

12. Back Orders (Units)

XXXXXXXX (Units)

I8

150

157

13. Minimum Order Qty.

XXXXXXXX (Units)

I8

158

165

14. Incremental Order Qty.

XXXXXXXX (Units)

I8

166

173

 
-------------------- Demand History --------------------

15. Demand (-24 Month)

XXXXXXXX (Units)

(I8)

174

181

16. Demand (-23 Month)

XXXXXXXX (Units)

(I8)

182

189

17. Demand (-22 Month)

XXXXXXXX (Units)

(I8)

190

197

18. Demand (-21 Month)

XXXXXXXX (Units)

(I8)

198

205

19. Demand (-20 Month)

XXXXXXXX (Units)

(I8)

206

213

20. Demand (-19 Month)

XXXXXXXX (Units)

(I8)

214

221

21. Demand (-18 Month)

XXXXXXXX (Units)

(I8)

222

229

22. Demand (-17 Month)

XXXXXXXX (Units)

(I8)

230

237

23. Demand (-16 Month)

XXXXXXXX (Units)

(I8)

238

245

24. Demand (-15 Month)

XXXXXXXX (Units)

(I8)

246

253

25. Demand (-14 Month)

XXXXXXXX (Units)

(I8)

254

261

26. Demand (-13 Month)

XXXXXXXX (Units)

(I8)

262

269

27. Demand (-12 Month)

XXXXXXXX (Units)

(I8)

270

277

28. Demand (-11 Month)

XXXXXXXX (Units)

(I8)

278

285

29. Demand (-10 Month)

XXXXXXXX (Units)

(I8)

286

293

30. Demand (-09 Month)

XXXXXXXX (Units)

(I8)

294

301

31. Demand (-08 Month)

XXXXXXXX (Units)

(I8)

302

309

32. Demand (-07 Month)

XXXXXXXX (Units)

(I8)

310

317

33. Demand (-06 Month)

XXXXXXXX (Units)

(I8)

318

325

34. Demand (-05 Month)

XXXXXXXX (Units)

(I8)

326

333

35. Demand (-04 Month)

XXXXXXXX (Units)

(I8)

334

341

36. Demand (-03 Month)

XXXXXXXX (Units)

(I8)

342

349

37. Demand (-02 Month)

XXXXXXXX (Units)

(I8)

350

357

38. Demand (-01 Month)

XXXXXXXX (Units)

(I8)

358

365

 
------------------- Replenishment Orders procured into Inventory --------------------

Field

Format

Type

Start

Stop

39. Replenish Order #01

XXXXXXXX (Units)

(I8)

366

373

40. Replenish Order #02

XXXXXXXX (Units)

(I8)

374

381

41. Replenish Order #03

XXXXXXXX (Units)

(I8)

382

389

42. Replenish Order #04

XXXXXXXX (Units)

(I8)

390

397

43. Replenish Order #05

XXXXXXXX (Units)

(I8)

398

405

44. Replenish Order #06

XXXXXXXX (Units)

(I8)

406

413

45. Replenish Order #07

XXXXXXXX (Units)

(I8)

414

421

46. Replenish Order #08

XXXXXXXX (Units)

(I8)

422

429

47. Replenish Order #09

XXXXXXXX (Units)

(I8)

430

437

48. Replenish Order #10

XXXXXXXX (Units)

(I8)

438

445

49. Replenish Order #11

XXXXXXXX (Units)

(I8)

446

453

50. Replenish Order #12

XXXXXXXX (Units)

(I8)

454

461

51. Replenish Order #13

XXXXXXXX (Units)

(I8)

462

469

52. Replenish Order #14

XXXXXXXX (Units)

(I8)

470

477

53. Replenish Order #15

XXXXXXXX (Units)

(I8)

478

485

54. Replenish Order #16

XXXXXXXX (Units)

(I8)

486

493

55. Replenish Order #17

XXXXXXXX (Units)

(I8)

494

501

56. Replenish Order #18

XXXXXXXX (Units)

(I8)

502

509

57. Replenish Order #19

XXXXXXXX (Units)

(I8)

510

517

58. Replenish Order #20

XXXXXXXX (Units)

(I8)

518

525

 
-------------------- Replenishment Dates for Above Orders --------------------

59. Replenish Date #01

XX/XX/XX (MM/DD/YY)

(A8)

526

533

60. Replenish Date #02

XX/XX/XX (MM/DD/YY)

(A8)

534

541

61. Replenish Date #03

XX/XX/XX (MM/DD/YY)

(A8)

542

549

62. Replenish Date #04

XX/XX/XX (MM/DD/YY)

(A8)

550

557

63. Replenish Date #05

XX/XX/XX (MM/DD/YY)

(A8)

558

565

64. Replenish Date #06

XX/XX/XX (MM/DD/YY)

(A8)

566

573

65. Replenish Date #07

XX/XX/XX (MM/DD/YY)

(A8)

574

581

66. Replenish Date #08

XX/XX/XX (MM/DD/YY)

(A8)

582

589

67. Replenish Date #09

XX/XX/XX (MM/DD/YY)

(A8)

590

597

68. Replenish Date #10

XX/XX/XX (MM/DD/YY)

(A8)

598

605

69. Replenish Date #11

XX/XX/XX (MM/DD/YY)

(A8)

606

613

70. Replenish Date #12

XX/XX/XX (MM/DD/YY)

(A8)

614

621

71. Replenish Date #13

XX/XX/XX (MM/DD/YY)

(A8)

622

629

72. Replenish Date #14

XX/XX/XX (MM/DD/YY)

(A8)

630

637

73. Replenish Date #15

XX/XX/XX (MM/DD/YY)

(A8)

638

645

74. Replenish Date #16

XX/XX/XX (MM/DD/YY)

(A8)

646

653

75. Replenish Date #17

XX/XX/XX (MM/DD/YY)

(A8)

654

661

76. Replenish Date #18

XX/XX/XX (MM/DD/YY)

(A8)

662

669

77. Replenish Date #19

XX/XX/XX (MM/DD/YY)

(A8)

670

677

78. Replenish Date #20

XX/XX/XX (MM/DD/YY)

(A8)

678

685

 

The following fields are optional - improved visibility of future requirements will result if the known future fields are available and can be passed to the system.  Additionally, purchase order numbers will assist in cross-referencing orders.

 
------------------- Known Future Demand Forecast --------------------

Field

Format

Type

Start

Stop

79. FUTURE (Next Month)

XXXXXXXX (Units)

(I8)

686

693

80. FUTURE (Month 2)

XXXXXXXX (Units)

(I8)

694

701

81. FUTURE (Month 3)

XXXXXXXX (Units)

(I8)

702

709

82. FUTURE (Month 4)

XXXXXXXX (Units)

(I8)

710

717

83. FUTURE (Month 5)

XXXXXXXX (Units)

(I8)

718

725

84. FUTURE (Month 6)

XXXXXXXX (Units)

(I8)

726

733

85. FUTURE (Month 7)

XXXXXXXX (Units)

(I8)

734

741

86. FUTURE (Month 8)

XXXXXXXX (Units)

(I8)

742

749

87. FUTURE (Month 9)

XXXXXXXX (Units)

(I8)

750

757

88. FUTURE (Month 10)

XXXXXXXX (Units)

(I8)

758

765

89. FUTURE (Month 11)

XXXXXXXX (Units)

(I8)

766

773

90. FUTURE (Month 12)

XXXXXXXX (Units)

(I8)

774

781

 
-------------------- Purchase Order Numbers --------------------

91. Purchase Order #01

10 Alpha Characters

(A10)

782

791

92. Purchase Order #02

10 Alpha Characters

(A10)

792

801

93. Purchase Order #03

10 Alpha Characters

(A10)

802

811

94. Purchase Order #04

10 Alpha Characters

(A10)

812

821

95. Purchase Order #05

10 Alpha Characters

(A10)

822

831

96. Purchase Order #06

10 Alpha Characters

(A10)

832

841

97. Purchase Order #07

10 Alpha Characters

(A10)

842

851

98. Purchase Order #08

10 Alpha Characters

(A10)

852

861

99. Purchase Order #09

10 Alpha Characters

(A10)

862

871

100. Purchase Order #10

10 Alpha Characters

(A10)

872

881

101. Purchase Order #11

10 Alpha Characters

(A10)

882

891

102. Purchase Order #12

10 Alpha Characters

(A10)

892

901

103. Purchase Order #13

10 Alpha Characters

(A10)

902

911

104. Purchase Order #14

10 Alpha Characters

(A10)

912

921

105. Purchase Order #15

10 Alpha Characters

(A10)

922

931

106. Purchase Order #16

10 Alpha Characters

(A10)

932

941

107. Purchase Order #17

10 Alpha Characters

(A10)

942

951

108. Purchase Order #18

10 Alpha Characters

(A10)

952

961

109. Purchase Order #19

10 Alpha Characters

(A10)

962

971

110. Purchase Order #20

10 Alpha Characters

(A10)

972

981

 
 The following fields are also optional and less commonly available, but may be useful for more precise control over various inventory situations.  For example, "slow moving" items - perhaps critical, yet almost never used - would utilize these fields.

 
--------------------- Slow - Moving Item Control Fields ------------------

Field

Format

Type

Start

Stop

111.  Emergency Reserve

XXXXXXXX (Units)

(I8)

982

989

112.  In-Use Inventory

XXXXXXXX (Units)

(I8)

990

997

113.  MFG. Failure Rate

X.XX (Units)

(F4.2)

998

1001

 Planner codes and inventory class fields can be used for splitting data or setting ranges.
 
--------------------- Planner & Class Codes ------------------

114.  Planner Code

XX Characters

(A2)

1002

1003

115.  Class Code

XX Characters

(A2)

1004

1005

 
Pricing discounts from vendors can help determine EOQ levels.  Replenishment source tags would be useful to "roll-up" requirements for multiple locations in a "DRP" environment.

 
--------------------- Purchasing Related Control Fields ------------------

116.  Discount Point #1

XXXXXXXX (Units)

(I8)

1006

1013

117.  Discount Point #2

XXXXXXXX (Units)

(I8)

1014

1021

118.  Discount Point #3

XXXXXXXX (Units)

(I8)

1022

1029

119.  Discount Point #4

XXXXXXXX (Units)

(I8)

1030

1037

120.  Discount Point #5

XXXXXXXX (Units)

(I8)

1038

1045

121.  Discount Value #1

XXXXXXX.XX (Units)

(F10.2)

1046

1055

122.  Discount Value #2

XXXXXXX.XX (Units)

(F10.2)

1056

1065

123.  Discount Value #3

XXXXXXX.XX (Units)

(F10.2)

1066

1075

124.  Discount Value #4

XXXXXXX.XX (Units)

(F10.2)

1076

1085

125.  Discount Value #5

XXXXXXX.XX (Units)

(F10.2)

1086

1095

 
---------------------Distribution Related Control Fields ------------------

126. Replenishment Source

20 Alpha Characters

(A20)

1096

1115

 
--------------------- Maintenance Related Control Fields ------------------

127. MIN

XXXXXXXX

(I8)

1116

1123

128. MAX

XXXXXXXX

(I8)

1124

1131