Difference between revisions of "Import Data"

From Skynet Software Wiki
Jump to navigation Jump to search
Line 3: Line 3:
  
 
= Customers =
 
= Customers =
−
Column Format:
+
;Column Format:
 
#Customer
 
#Customer
 
#Telephone Number
 
#Telephone Number
Line 23: Line 23:
  
 
= Machines =
 
= Machines =
−
Column Format:
+
;Column Format:
 
#Machine ID Number
 
#Machine ID Number
 
#Machine Specification
 
#Machine Specification
Line 31: Line 31:
  
 
= Tools =
 
= Tools =
−
Column Format:
+
;Column Format:
 
#Tool Number
 
#Tool Number
 
#Rack Location
 
#Rack Location
Line 40: Line 40:
 
#Code ID
 
#Code ID
 
#Description
 
#Description
 +
 +
= Supplier Data =
 +
;Column Format:
 +
#Supplier Name
 +
#Our SKU
 +
#Supplier Description
 +
#Supplier Reference / SKU
 +
#Minimum Order Quantity
 +
#Lead Time (Days)
 +
#Price Per KG
 +
#Price Per Thousand
 +
#Price Each
  
 
= Finished Goods =
 
= Finished Goods =
−
Column Format:
+
;Column Format:
 
#Customer
 
#Customer
 
#Own SKU
 
#Own SKU
Line 50: Line 62:
 
#Commodity Code
 
#Commodity Code
 
#Box Quantity
 
#Box Quantity
 +
 +
= Bill of Material Products =
 +
;Column Format:
 +
#Customer
 +
#Wheatley Plastics Part Number
 +
#Customer Part Number
 +
#Part Description
 +
#Commodity Code
 +
#Finished Component Colour
 +
#Part Weight
 +
#Material Stock Code
 +
#Material Description
 +
#Material Supplier Reference
 +
#Material %
 +
#Masterbatch Stock Code
 +
#Masterbatch Description
 +
#Masterbatch Supplier Reference
 +
#Masterbatch %
 +
#BOP Stock Code
 +
#BOP Description
 +
#BOP Supplier Reference
 +
#BOP UOM
 +
#BOP Stock Code
 +
#BOP Description
 +
#BOP Supplier Reference
 +
#BOP UOM
 +
#Bag Stock code
 +
#Bag Description
 +
#Bag Supplier Reference
 +
#Bag UOM
 +
#Bag Quantity
 +
#Box Stock Code
 +
#Box Description
 +
#Box Supplier Reference
 +
#Box UOM
 +
#Box Quantity
 +
#Preferred Machine 1
 +
#Preferred Machine 2
 +
#Preferred Machine 3
 +
#Cavities
 +
#Tool Number
 +
#Labour Content
 +
#Standard Cycle Time
 +
#Set Up Time (hours)
 +
#Scrap %
 +
#Selling Price each
 +
#Secondary Op Needed
 +
#Comments
  
 
= Suppliers =
 
= Suppliers =
−
Column Format:
+
;Column Format:
 
#Supplier Name
 
#Supplier Name
 
#Telephone Number
 
#Telephone Number
Line 70: Line 130:
 
#Delivery line 5 (Not Used)
 
#Delivery line 5 (Not Used)
 
#VAT Number
 
#VAT Number
−
 
−
= Supplier Data =
 
−
Column Format:
 
−
#Supplier Name
 
−
#Our SKU
 
−
#Supplier Description
 
−
#Supplier Reference / SKU
 
−
#Minimum Order Quantity
 
−
#Lead Time (Days)
 
−
#Price Per KG
 
−
#Price Per Thousand
 
−
#Price Each
 

Revision as of 15:20, 14 February 2021

Overview

This import uses an XLS Spreadsheet to import all of the necessary data. It is recommended to import in the order displayed in this Wiki.

Customers

Column Format
  1. Customer
  2. Telephone Number
  3. Accounts Contact
  4. Customer Service Contact
  5. Accounts Email Address
  6. Customer Service Email Address
  7. Invoice Line 1
  8. Invoice Line 2
  9. Invoice Line 3
  10. Invoice Line 4
  11. Invoice Line 5
  12. Delivery Line 1
  13. Delivery Line 2
  14. Delivery Line 3
  15. Delivery Line 4
  16. Delivery Line 5
  17. VAT Number

Machines

Column Format
  1. Machine ID Number
  2. Machine Specification
  3. Serial Number
  4. Year of Manufacture
  5. Machine Rate Per Hour

Tools

Column Format
  1. Tool Number
  2. Rack Location
  3. Available Status

Stock Category Codes

Column Format:

  1. Code ID
  2. Description

Supplier Data

Column Format
  1. Supplier Name
  2. Our SKU
  3. Supplier Description
  4. Supplier Reference / SKU
  5. Minimum Order Quantity
  6. Lead Time (Days)
  7. Price Per KG
  8. Price Per Thousand
  9. Price Each

Finished Goods

Column Format
  1. Customer
  2. Own SKU
  3. Customer SKU
  4. Part Description
  5. Colour
  6. Commodity Code
  7. Box Quantity

Bill of Material Products

Column Format
  1. Customer
  2. Wheatley Plastics Part Number
  3. Customer Part Number
  4. Part Description
  5. Commodity Code
  6. Finished Component Colour
  7. Part Weight
  8. Material Stock Code
  9. Material Description
  10. Material Supplier Reference
  11. Material %
  12. Masterbatch Stock Code
  13. Masterbatch Description
  14. Masterbatch Supplier Reference
  15. Masterbatch %
  16. BOP Stock Code
  17. BOP Description
  18. BOP Supplier Reference
  19. BOP UOM
  20. BOP Stock Code
  21. BOP Description
  22. BOP Supplier Reference
  23. BOP UOM
  24. Bag Stock code
  25. Bag Description
  26. Bag Supplier Reference
  27. Bag UOM
  28. Bag Quantity
  29. Box Stock Code
  30. Box Description
  31. Box Supplier Reference
  32. Box UOM
  33. Box Quantity
  34. Preferred Machine 1
  35. Preferred Machine 2
  36. Preferred Machine 3
  37. Cavities
  38. Tool Number
  39. Labour Content
  40. Standard Cycle Time
  41. Set Up Time (hours)
  42. Scrap %
  43. Selling Price each
  44. Secondary Op Needed
  45. Comments

Suppliers

Column Format
  1. Supplier Name
  2. Telephone Number
  3. Accounts Contact
  4. Customer Service Contact
  5. Accounts Email Address
  6. Customer Service Email Address
  7. Invoice Line 1
  8. Invoice Line 2
  9. Invoice Line 3
  10. Invoice Line 4
  11. Invoice Line 5
  12. Delivery Line 1 (Not Used)
  13. Delivery Line 2 (Not Used)
  14. Delivery Line 3 (Not Used)
  15. Delivery Line 4 (Not Used)
  16. Delivery line 5 (Not Used)
  17. VAT Number
Retrieved from ‘https://wiki.genisys-systems.co.uk/index.php?title=Import_Data&oldid=440’