JiniSoft Corporation JiniSoft at Home Page JiniSoft Product JiniSoft Service Forum, Question & answer Partner & Distributor Developer, Programmer History Purpose Thai Chinese English




Facebook : roongroj @ jinisoft.com

JiniSoft Product
Home
JiniSoft Billing
ERP / E-Resource
Enterprise Resource Planning
- Financial
- Front Office
- Manufacturing
  Manufacturing Detail
- Human Resource
- Accounting Format
- Relation Diagram
- Transaction Diagram
- Customer Relation Management
EBP / E-Business
Enterprise Business Planning
ECP / E-Commerce
Enterprise Commerce Planning
EIP / E-Intellignece
Enterprise Intelligence Planning
High-Speed Cluster OODB


Production System / Quanlity Control System / Preventive & Maintenance System

 

Standard Cost

StandardCost.jpg (26131 bytes)

StandardCostHdr
Original
Product
EffectiveDate
Cost
StandardCostDtl
Original
Product
Library
Department
Quantity
Price
Amount
  • 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

Production.jpg (31684 bytes)

ProductionTransHdr
Original
DocumentNo
Product
Equation
ProductionTransDtl
Original
DocumentNo
Product
Department
ReferDocumentNo
Process
AccountCode
Component
Quantity
UsageTime
Price
Unit
Amount
Result
  • 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

Production.jpg (31684 bytes)

ProductionTransHdr
Original
DocumentNo
Product
Equation
ProductionTransDtl
Original
DocumentNo
Product
Department
ReferDocumentNo
Process
AccountCode
Component
Quantity
UsageTime
Price
Unit
Amount
Result
  • 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

Production.jpg (31684 bytes)

ProductionTransHdr
Original
DocumentNo
Product
Equation
ProductionTransDtl
Original
DocumentNo
Product
Department
ReferDocumentNo
Process
AccountCode
Component
Quantity
UsageTime
Price
Unit
Amount
Result
  • 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

Maintenance.jpg (41860 bytes)

MaintenanceHdr
Original
MaintenanceNo
DepartmentOriginal
People
RequestDate
Corporation
Department
Product
RequestDate
ExpectedDate
PreventiveDate
ExpectedTask
Task
ReferDocumentNo
Duration
MaintenanceDtl
Original
MaintenanceNo
Product
Library
ExpectedTask
Task
Duration
Library
Quantity
Unit
Price
Amount
  • 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

DocumentControl.jpg (28043 bytes)

DocumentControl
Original
Department
DocumentType
DocumentNo
Revision
CreateByTool
GenerateDate
EffectiveDate
CancelDate
Note
ResponsePerson
Place
  • 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

DocumentList.jpg (24758 bytes)

DocumentList
Original
Department
DocumentType
DocumentNo
Revision
Date
UserDepartment
Recipient
  • 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 )