Difference between revisions of "BPCS Files"

From MidrangeWiki
Jump to: navigation, search
(405 CD Files)
m (cat alpha sort on Category:BPCS)
 
(13 intermediate revisions by 5 users not shown)
Line 1: Line 1:
This directory is not intended to be complete, since different people need access to different files for different purposes and as you can see by the main article on [[BPCS]] and others linked there, BPCS has many versions.
+
This directory is not intended to be complete, since different people need access to different files for different purposes and as you can see by the main article on [[BPCS]] and others linked there, BPCS has many versions.  Note that many [[SSA]] customers may [[add BPCS files]] to the collection, that did not come native with BPCS.
  
 
== 405 CD Files ==
 
== 405 CD Files ==
Line 6: Line 6:
  
 
=== Accounting Files ===
 
=== Accounting Files ===
 +
 +
* SIH Invoice History Header
 +
** one record per invoice
 +
* SIL Invoice History Lines
 +
** one record per item per customer per order shipment
  
 
=== Customer ORD ===
 
=== Customer ORD ===
Line 17: Line 22:
 
* EST Customer Ship-to
 
* EST Customer Ship-to
 
* RCM Customer Master
 
* RCM Customer Master
 +
* SIH Invoice History Header
 +
** one record per invoice
 +
* SIL Invoice History Lines
 +
** one record per item per customer per order shipment
 +
* SSD Sales History Detail
 +
* SSH Sales History
  
 
=== Engineering Files ===
 
=== Engineering Files ===
Line 24: Line 35:
 
* IIM Item Master
 
* IIM Item Master
 
* MBM Bill of Materials
 
* MBM Bill of Materials
 +
* LWK Work Center Master
  
=== Inventory Files
+
=== Inventory Files ===
  
 
* IIM Item Master
 
* IIM Item Master
Line 35: Line 47:
 
* ITH Inventory History
 
* ITH Inventory History
  
 +
=== Planning Files ===
 +
 +
* KFP = MRP Planned and Firm Planned Orders
 +
* KMR = MRP Material Requirements
 +
* KRO = MRP Releaseable Orders
 +
* LCR = CAP Detail
 +
 +
Also see MRP rescheduled date within various kinds of orders such as Production and Purchase
 +
 +
Date of all nines means this order should be cancelled
 +
 +
Sate of all zeros means this date cannot be improved upon
  
 
=== Production SFC Shop Floor & JIT Just in Time ===
 
=== Production SFC Shop Floor & JIT Just in Time ===
Line 45: Line 69:
 
* FOD Shop Order Operations
 
* FOD Shop Order Operations
 
* FSO Shop Order Summary
 
* FSO Shop Order Summary
 +
* JPH Just in Time Production history summary
 +
* LWK Work Center Master
  
=== Purchasing and Vendor Files
+
=== Purchasing and Vendor Files ===
  
 
* AVM Vendor Master
 
* AVM Vendor Master
Line 53: Line 79:
 
* HVH Vendor Item History
 
* HVH Vendor Item History
 
* ITH Inventory History
 
* ITH Inventory History
 +
 +
[[Category:BPCS|Files]]

Latest revision as of 20:00, 21 August 2006

This directory is not intended to be complete, since different people need access to different files for different purposes and as you can see by the main article on BPCS and others linked there, BPCS has many versions. Note that many SSA customers may add BPCS files to the collection, that did not come native with BPCS.

405 CD Files

BPCS files of general interest to creators of Query BPCS and other reports inquiry etc.

Accounting Files

  • SIH Invoice History Header
    • one record per invoice
  • SIL Invoice History Lines
    • one record per item per customer per order shipment

Customer ORD

  • ECH Customer Order Header
  • ECL Customer Order Regular Lines
  • ECS Customer Order Special Lines
  • ESH Shipping Header
  • ESL Shipping Detail
  • ESN Customer Notes
  • EST Customer Ship-to
  • RCM Customer Master
  • SIH Invoice History Header
    • one record per invoice
  • SIL Invoice History Lines
    • one record per item per customer per order shipment
  • SSD Sales History Detail
  • SSH Sales History

Engineering Files

  • FRT Routings
  • IIC Item Class
  • IIM Item Master
  • MBM Bill of Materials
  • LWK Work Center Master

Inventory Files

  • IIM Item Master
  • ILI Item Warehouse Location Lot combination inventory
  • ILM Item Warehouse Location Lot combination master
  • IWI Item Warehouse combination inventory
  • IWM Item Warehouse combination master
  • ITE Inventory Transaction Effects master
  • ITH Inventory History

Planning Files

  • KFP = MRP Planned and Firm Planned Orders
  • KMR = MRP Material Requirements
  • KRO = MRP Releaseable Orders
  • LCR = CAP Detail

Also see MRP rescheduled date within various kinds of orders such as Production and Purchase

Date of all nines means this order should be cancelled

Sate of all zeros means this date cannot be improved upon

Production SFC Shop Floor & JIT Just in Time

  • CDP Factory Departments
  • CEM Employee Clock Master
  • CIC Item Cost Planning by Facility
  • FLT Labor Ticket Gistory
  • FMA Shop Order Materials
  • FOD Shop Order Operations
  • FSO Shop Order Summary
  • JPH Just in Time Production history summary
  • LWK Work Center Master

Purchasing and Vendor Files

  • AVM Vendor Master
  • HPH Purchase Order Header
  • HPO Purchase Order Lines
  • HVH Vendor Item History
  • ITH Inventory History