Tables and Data Flow of the Accpac Inventory Control Module – Part 2
The main types of database tables in I/C can be categorized as:
- Master Data
- Data Entry
- Data Processing
- Periodic Processing
We covered Setup and Master Data last week. This week we will cover Data Entry, Data Processing and Periodic Processing.
Data Entry consists of: Receipts, Shipments, Adjustments, Transfers, Assemblies/Disassembles and Internal Usage.
These functions are only used by the I/C forms for entering data into I/C. Although applications can enter documents into these functions and post them, this isn’t the normal way of interacting with I/C. When applications feed data into G/L, A/R, A/P, O/E or P/O they create and post documents just like a user would. So in G/L Journal Entry you can see all the G/L batches created by entry operators plus a large number of batches entered into G/L by other accounting applications. This is a very uniform manner of entry that keeps everything together. However this wouldn’t be practical for I/C, since then there would be huge numbers of I/C Receipts and Shipments for everything that affects inventory and costing levels. Hence applications have protocols to interact with the inventory items directly without creating documents to do it during posting. This whole process is then orchestrated by Day End Processing to keep a unified audit trail so you can accurately track everything that happens.
ICREEH (IC0590): Receipt Headers.
ICREED (IC0580): Receipt Details
ICREEDO (IC0585): Receipt Details Optional Fields.
ICREEDS (IC0587): Receipt Detail Serial Numbers.
ICREEDL (IC0582): Receipt Detail Lot Numbers.
ICREEHO (IC0595): Receipt Headers Optional Fields.
ICPSTRE (IC0520): Post Receipts. Superview to post receipts.
ICRCPH (IC0560): Receipt Not Costed Headers. Receipt After Post – uncosted.
ICRCPD (IC0550): Receipt Not Costed Details.
ICRCPDP (IC0555): Receipt Not Costed Detail Optional Fields.
ICRCPDS (IC0558): Receipt Not Costed Detail Serial Numbers.
ICRCPDL (IC0553): Receipt Not Costed Detail Lot Numbers.
ICRCPHP (IC0565): Receipt Not Costed Header Optional Fields.
ICSHEH (IC0640): Shipment Header.
ICSHED (IC0630): Shipment Detail.
ICSHEDO (IC0635): Shipment Detail Optional Fields.
ICSHEDL (IC0632): Shipment Detail Lot Numbers.
ICSHEDS (IC0636): Shipment Detail Serial Numbers.
ICSHEHO (IC0645): Shipment Header Optional Fields.
ICPSTSH (IC0530): Post Shipments. Superview to post shipments.
ICADEH (IC0120): Adjustment Headers.
ICADED (IC0110): Adjustment Details.
ICADEDO (IC0115): Adjustment Detail Optional Fields.
ICADEDS (IC0117): Adjustment Detail Serial Numbers.
ICADEDL (IC0113): Adjustment Detail Lot Numbers.
ICADEHO (IC0125): Adjustment Header Optional Fields.
ICPSTAD (IC0500): Post Adjustments. Superview to post adjustments.
ICTREH (IC0740): Transfer Header.
ICTRED (IC0730): Transfer Detail.
ICTREDO (IC0735): Transfer Detail Optional Fields.
ICTREDS (IC0738): Transfer Detail Serial Numbers.
ICTREDL (IC0733): Transfer Detail Lot Numbers.
ICTREHO (IC0741): Transfer Header Optional Fields.
ICPSTTR (IC0540): Post Transfers. Superview to post transfer documents.
ICASEN (IC0160): Assemblies.
ICASENO (IC0165): Assembly Optional Fields.
ICASENL (IC0162): Assembly Lot Details.
ICASENS (IC0167): Assembly Serial Details.
ICPSTBM (IC0510): Post Bill of Materials. Superview to post bills of materials.
ICICEH (IC0288): Internal Usage Headers.
ICICEHO (IC0289): Internal Usage Header Optional Fields.
ICICED (IC0286): Internal Usage Details.
ICICEDO (IC0287): Internal Usage Detail Optional Fields.
ICICEDS (IC0284): Internal Usage Serial Numbers.
ICICEDA (IC0283): Internal Usage FAS Details.
Day End Processing
For more details on the Day End Processing Process, have a look at this blog post.
How and when Day End Processing is run is heavily controlled by the various options records in the system. For instance whether costing is performed during day end or posting is controlled by I/C options. These settings are there so you can optimize I/C for your business needs and environment.
ICDEND (IC0275): Master Day End Processing.
ICDEP (IC0276): IC Day End Processing
Calls the following superviews and updates the following tables:
ICCSTP (IC0270): Post Item Costs.
ICPOSTR (IC0420): Receipt Posting.
ICITRP (IC0350): Item Receipts Posting.
ICRECPH (IC0570): Receipt Audit List Headers.
ICRECHP (IC0568): Receipt Audit Header Optional Fields.
ICRECPD (IC0575): Receipt Audit List Details.
ICRECDP (IC0567): Receipt Audit Details Optional Fields.
ICPOSTS (IC0430): Shipment Posting.
ICSHIPH (IC0652): Shipment Audit List Headers.
ICSHPHP (IC0657): Shipment Audit Header Optional Fields.
ICSHIPD (IC0650): Shipment Audit List Details.
ICSHPDP (IC0655): Shipment Audit Detail Optional Fields.
ICPOSTA (IC0400): Adjustment Posting .
ICADJP (IC0140): Post Adjustment Details.
ICADJH (IC0132): Adjustment Audit List Headers.
ICADJHP (IC0135): Adjustment Audit List Header Optional Fields.
ICADJD (IC0130): Adjustment Audit List Details.
ICADJDP (IC0131): Adjustment Audit List Detail Optional Fields.
ICPOSTT (IC0440): Transfer Posting.
ICTRANH (IC0716): Transfer Audit List Headers.
ICTRNHP (IC0720): Transfer Audit List Header Optional Fields.
ICTRAND (IC0714): Transfer Audit List Details.
ICTRNDP (IC0718): Transfer Audit List Detail Optional Fields.
ICPOSTB (IC0410): Assembly Posting
ICASSMH (IC0182): Assembly Audit List Headers.
ICASMHP (IC0172): Assembly Audit List Header Optional Fields.
ICASSMD (IC0180): Assembly Audit List Details.
ICASMDP (IC0170): Assembly Audit List Detail Optional Fields.
ICHIST (IC0280): Transaction History.
ICHISTS (IC0285): Transaction History Inquiry summary.
ICSTAT (IC0700): Transaction Statistics.
ICSTATI (IC0710): Sales Statistics.
ICXLHIS (IC0815): Lot Number History.
ICXSHIS (IC0835): Serial Number History.
I/C has many processing functions that are run on demand (often infrequently). This section gives a sampling of the main I/C Periodic Processing functions:
ICCLRHI (IC0230): Clear History.
ICCLRIN (IC0240): Delete Inactive Records.
ICPRCC (IC0460): Copy Item Pricing.
ICPRCU (IC0470): Update Item Pricing.
ICWKGEN (IC0760): Generate Inventory Worksheet.
ICWKL (IC0770): Inventory Worksheets.
ICWKLO (IC0775): Worksheet Optional Fields.
ICWKUH (IC0790): Inventory Worksheet Headers.
ICWKUD (IC0780): Inventory Worksheet Details.
ICWKUHO (IC0795): Worksheet Detail Optional Fields.
ICWKUHL (IC0793): Inventory Worksheet Lot Numbers.
ICWKUHS (IC0797): Inventory Worksheet Serial Numbers.
ICPOSTW (IC0450): Inventory Reconciliation Posting.
ICGLTR (IC0278): Generate G/L Batches.
ICINTCK (IC0300): Integrity Checker.
ICUPGD (IC0752): Activation.
ICCTOE (IC0271): Transaction Inquiry for OE.
ICPRJNL (IC0483): Reset Printed Posting Journals.
ICLBLH(IC0365): Label Headers.
ICDLDN (IC0277): IC Drill Down.
ICADGEN (IC0128): Process Adjustments.
Hopefully this gives a bit of help in understanding the I/C module for when you are producing custom forms, reports or writing VBA macros.