Production System / Quanlity Control System / Preventive & Maintenance System

Standard Cost

• Default Transaction Date by System Date
• VIEW & GET: Standard Cost Formula from TB CostAllocateBase

  SELECT Original, Product, EffectiveDate, Department, AllocationCondition FROM CostAllocateBase

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, StandardCostHdr.Original, StandardCostHdr.Product, StandardCostHdr.EffectiveDate, StandardCostHdr.Cost, StandardCostDtl.Code, StandardCostDtl.Department, StandardCostDtl.Quantity, StandardCostDtl.Price, StandardCostDtl.Amount FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, StandardCostHdr, StandardCostDtl

Production

• Run Auto TransactionNo จาก RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: Default Currency by Original.License -> Populate

  SELECT LibrarySpec.Amount FROM LibrarySpec Where Date = get last date and Code = Populate.People.Address

• VIEW & GET: Order No from OrderHdr -> OrderDtl

  SELECT OrderHdr.Populate, Populate.Prefix + Populate.FirstName + Populate.MiddleName + Populate.LastName, Corporation.Address, OrderHdr.Saleman, OrderHdr.ShipDate, OrderDtl.Library -> Library, Library.Name, OrderDtl.Quantity, OrderDtl.Unit FROM OrderHdr, Populate, Corporation, Library

• VIEW & GET: Costing Formula from TB CostAllocateBase

  SELECT Original, Product, EffectiveDate, Department, AllocateCondition FROM CostAllocateBase

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, ProductionTransHdr.Equation, ProductionTransDtl.Process, ProductionTransDtl.Component, ProductionTransDtl.Quantity, ProductionTransDtl.UsageTime FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, ProductionTransHdr, ProductionTransDtl

Costing

• Run Auto TransactionNo จาก RunningNumber
• Default Transaction by System Date
• VIEW & GET: Default Currency from Original.License -> Populate

  SELECT LibrarySpec.Amount FROM LibrarySpec Where Date = get last date and Code = Populate.People.Address

• VIEW & GET: Order No from OrderHdr -> OrderDtl

  SELECT OrderHdr.Populate, Populate.Prefix + Populate.FirstName + Populate.MiddleName + Populate.LastName, Corporation.Address, OrderHdr.Saleman, OrderHdr.ShipDate, OrderDtl.Library -> Library, Library.Name, OrderDtl.Quantity, OrderDtl.Unit FROM OrderHdr, Populate, Corporation, Library

• VIEW & GET: Costing Formula from TB CostAllocateBase

  SELECT Original, Product, EffectiveDate, Department, AllocateCondition FROM CostAllocateBase

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, ProductionTransHdr.Equation, ProductionTransDtl.Process, ProductionTransDtl.Component, ProductionTransDtl.Quantity, ProductionTransDtl.UsageTime FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, ProductionTransHdr, ProductionTransDtl

Quanlity Control

• Run Auto TransactionNo จาก RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: Order No from OrderHdr -> OrderDtl

  SELECT OrderHdr.Populate, Populate.Prefix + Populate.FirstName + Populate.MiddleName + Populate.LastName, Corporation.Address, OrderHdr.Saleman, OrderHdr.ShipDate, OrderDtl.Library -> Library, Library.Name, OrderDtl.Quantity, OrderDtl.Unit FROM OrderHdr, Populate, Corporation, Library

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, ProductionTransDtl.Process, ProductionTransDtl.Component, ProductionTransDtl.Quantity, ProductionTransDtl.UsageTime, Production.Result FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, ProductionTransHdr, ProductionTransDtl

Preventive & Maintenance & Calibrate

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: Machine

  SELECT Original, Product, Library, Inventory, Quantity, Unit, Rate, Range, UnitPrice, LastUpdateDate, LastUpdate, ChangeRangeDate, ChangeRange FROM Component

• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, MaintenanceHdr.Corportion, MaintenanceHdr.Department, MaintenanceHdr.Product, MaintenanceHdr.RequestDate, MaintenanceHdr.ExpectedDate, MaintenanceHdr.PreventiveDate, MaintenanceHdr.ExpectedTask, MaintenanceHdr.Task, MaintenanceHdr.ReferDocumentNo, MaintenanceHdr.Duration, MaintenanceDtl.Library, MaintenanceDtl.Inventory, MaintenanceDtl.Quantity, MaintenanceDtl.Price, MaintenanceDtl.Unit, MaintenanceDtl.Amount FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, MaintenanceHdr, MaintenanceDtl

Document Control

Document Control

• Run Auto TransactionNo from RunningNumber
• Default Transaction By System Date
• VIEW & GET: Document Type, Tool for create document such as Word, Excel TB Library
• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, DocumentControl.DocumentType, DocumentControl.DocumentNo, DocumentControl.Revision, DocumentControl.CreateByTool, DocumentControl.GenerateDate, DocumentControl.EffectiveDate, DocumentControl.CancelDate, DocumentControl.Note FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, DocumentControl

Document List

• Run Auto TransactionNo from RunningNumber
• Default Transaction Date by System Date
• VIEW & GET: Document Type, Tool for create document such as Word, Excel TB Library
• QUERY: SELECT TransactionHdr.Original, TransactionHdr.TransactionType, TransactionHdr.TransactionNo, TransactionHdr.TransactionDate, TransactionHdr.Department, TransactionHdr.Project, TransactionHdr.Populate, TransactionHdr.DataRemark, BusinessLibraryTransactionDtl.Library, BusinessLibraryTransactionDtl.Quantity, BusinessLibraryTransactionDtl.RemainQuantity, BusinessLibraryTransactionDtl.Amount, BusinessLibraryTransactionDtl.RemainAmount, BusinessInventoryTransactionDtl.Inventory, BusinessInventoryTransactionDtl.Amount, BusinessInventoryTransactionDtl.RemainAmount, DocumentList.DocumentType, DocumentList.DocumentNo, DocumentList.Revision, DocumentList.Date, DocumentList.UserDepartment, DocumentList.Recipient FROM TransactionHdr, BusinessLibraryTransactionDtl, BusinessInventoryTransactionDtl, DocumentList

Last update : Monday, 7 January 2002 07:00 ( Thailand )

Apple, Mac, iMac, iPhone and iPod are trademarks of Apple, Inc.

Jini, Java and all Java-based are trademarks of Oracle Corporation.

JiniSoft Corporation

Copyright @ 1990 - 2012   Mr. Roongroj Rojanapo ( )

89/1 Khao Lam Road, Saen Suk, Chon buri District, Chon buri 20130, Thailand

E-mail

:

roongroj @ jinisoft.com ( JiniSoft @ Facebook & Line )