BPCS Files

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