Microsoft SQL Server 2000 Small Business ERP Software Design (Part 1, Part 2)

Author: Jinhui ERP Promotion Center
Publisher:
Publish Date: 2004-04-01
Features: This book is a detailed design document designed using the MSSQL language. It provides complete content such as data tables, field descriptions, relationship diagrams, stored procedures, triggers, and E-R diagrams. Designed in accordance with foreign ERP standards while incorporating China's tax system, such as the handling of value-added tax (VAT) and consumption tax. It offers both the moving weighted average method and the actual cost method for cost calculation. The cost categories include five: direct materials, direct labor, variable manufacturing overhead, fixed manufacturing overhead, and subcontracted processing costs, facilitating cost and price comparison analysis. It provides functions for matching invoices with purchase (incoming goods receipts) and invoices with payment receipts. It also provides functions for matching invoices with sales (outgoing goods receipts) and invoices with collection receipts. It offers a cost simulation function for easy product cost modeling. This book also comes with a CD-ROM.