Exporting CSV File Structure

This process is a one-way data export from Plant Focus to an external accounting system.

The current CSV file structure is as follows.

Pasted contents example from text file.

4600033           ,500RM01,4600033           ,101,7401.75976563,23.379999,09052013,000001,09052013,232247,0.00000000000,,52000052  ,

4600033           ,500RM01,4600041           ,261,0.00000000000,0.0000000,09052013,000001,09052013,235959,3728.79003906,,52000052  ,

4600033           ,500RM01,4600040           ,261,0.00000000000,0.0000000,09052013,000001,09052013,235959,217.660003662,,52000052  ,

4600033           ,500RM01,4600029           ,261,0.00000000000,0.0000000,09052013,000001,09052013,235959,679.760009766,,52000052  ,

4600033           ,500RM01,4600038           ,261,0.00000000000,0.0000000,09052013,000001,09052013,235959,5.98999977112,,52000052  ,

4600033           ,500RM01,4600039           ,261,0.00000000000,0.0000000,09052013,000001,09052013,235959,90.1900024414,,52000052  ,

• Material To Produce

  • This is the product being made. In this case 4600033 = RAW MIX

• Resource

  • This is the equipment making the product, in this case the equipment 500RM1 = Raw Mill 1.  The prefix 500 is a unique plant code

• Material

  • This is the material we are sending a number for
    • 4600033 = RAW MIX
    • 4600041 = PRE BLEND
    • 4600040 = FLY ASH
    • 4600029 = LIMESTONE FINES
    • 4600038 = SAND
    • 4600039 = IRON

• Type of Movement

  • This indicates a production or consumption value
    • 101 = PRODUCTION
    • 102 = NEGATIVE PRODUCTION
    • 261 = CONSUMPTION
    • 262 = NEGATIVE CONSUMPTION
    • 531 = BYPRODUCT MOVEMENT
    • 532 = NEGATIVE BYPRODUCT MOVEMENT

• Produced Value

  • If this is a production (type of movement = 101 or 102) then this will have a value
  • If not production, this will be 0

• Machine Time

  • Number of hours the machine operated for the day

• Date This Started

  • Start DATE for the day = MMDDYYYY

• Time Started

  • Start TIME for the day = HHmmSS

• Date Ended

  • End DATE for the day = MMDDYYYY

• Time Ended

  • End TIME for the day = HHmmSS

• Consumed Value

  • If this is a consumption (type of movement = 261,262,531,532) then this will have a value
  • If not a consumption, this will be 0

• Batch

  • If this is a byproduct or non-finished-good, the PLANT CODE where it came from
  • If site A makes clinker, ships it to site B, site B consumes it, then the BATCH would be the plant code for SITE A

• Production Order Number

  • The unique production order number generated by the accounting system
  • This is imported at the beginning of the month
  • This generally has a TARGET or BUDGET associated with it.