T'sFactoryシリーズのすべてのアプリケーション(Ver.5)は、同じ1つのデータ・データベースファイル(”TFctData.accdb”など)を共有しています。ここではその共有関係を表にあらわしました。
下表の●印は、そのテーブルがどのアプリケーションで使われているかを示しています。複数のアプリケーションに印が付いているテーブルは、それらのアプリケーション間でデータを相互利用したり、再利用したりすることができます。複数アプリケーションの併用によるデータ活用のヒントとして参考にしてください。
| テーブル名 |
日程管理 |
所要量計算 |
部品表管理 |
部品在庫管理 |
部品在庫管理Tablet+ |
部品ピッキング管理 |
備品貸出管理 |
設備保守管理 |
工程進捗管理 |
工程進捗管理POP+ |
受注出荷管理 |
進捗モニター |
出来高管理 |
仕掛品管理 |
タイムレコーダ |
生産予実管理 |
| ctbl消費税マスタ |
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
|
|
| mtblAssyマスタ |
|
● |
● |
|
|
|
|
|
|
|
|
|
|
|
|
|
| mtblアクセス権限 |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
| mtblカレンダマスタ |
● |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| mtblモニター端末マスタ |
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
|
| mtblモニター端末稼働マスタ |
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
|
| mtblログインユーザー |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
| mtbl加工設備マスタ |
|
|
|
|
|
|
|
|
● |
● |
|
|
|
|
|
|
| mtbl加工設備状況マスタ |
|
|
|
|
|
|
|
|
|
● |
|
|
|
|
|
|
| mtbl客先マスタ |
|
|
|
|
|
|
|
|
|
|
● |
|
|
● |
|
|
| mtbl勤怠区分マスタ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
|
| mtbl計画時点マスタ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| mtbl故障要因マスタ |
|
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
| mtbl工程マスタ |
|
|
|
|
|
|
|
|
● |
● |
|
|
|
● |
|
|
| mtbl購入先マスタ |
|
● |
● |
● |
● |
|
|
|
|
|
● |
|
|
|
|
|
| mtbl作業者マスタ |
|
|
|
|
|
|
|
|
● |
● |
|
|
|
|
|
|
| mtbl自社情報マスタ |
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
● |
|
| mtbl社員マスタ |
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
● |
|
| mtbl就業カレンダマスタ |
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
|
|
| mtbl就業時間マスタ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
|
| mtbl生産場所マスタ |
● |
|
|
|
|
● |
|
|
|
|
|
|
● |
● |
|
● |
| mtbl製品マスタ |
● |
● |
● |
|
|
● |
|
|
|
|
● |
|
● |
● |
|
● |
| mtbl素材マスタ |
|
● |
● |
|
|
|
|
|
|
|
|
|
|
|
|
|
| mtbl備品区分マスタ |
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
|
| mtbl部品マスタ |
|
● |
● |
● |
● |
● |
|
|
|
|
● |
|
|
|
|
|
| mtbl部門マスタ |
|
|
|
|
|
|
● |
● |
|
|
|
|
|
|
● |
|
| mtbl保管場所マスタ |
|
|
|
● |
● |
● |
|
|
|
|
|
|
|
|
|
|
| mtbl保守作業者マスタ |
|
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
| stblAuthCntrl |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
| stblSystemInfo |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
● |
| tblモニター進捗状況 |
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
|
| tblモニター進捗推移 |
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
|
| tbl月別生産計画 |
● |
● |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| tbl工程グループ |
|
|
|
|
|
|
|
|
● |
● |
|
|
|
|
|
|
| tbl工程グループ明細 |
|
|
|
|
|
|
|
|
● |
● |
|
|
|
|
|
|
| tbl作業オーダー |
|
|
|
|
|
|
|
|
● |
● |
|
|
|
|
|
|
| tbl作業オーダー工程明細 |
|
|
|
|
|
|
|
|
● |
● |
|
|
|
|
|
|
| tbl仕掛パターン |
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
| tbl仕掛パターン明細 |
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
| tbl仕掛品ロット |
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
| tbl仕掛品ロット明細 |
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
| tbl仕掛品在庫 |
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
| tbl実績生産計画 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| tbl実績生産場所レート |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| tbl実績製造原価 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| tbl実績能力計画 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| tbl実績能力計画明細 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| tbl実績標準時間 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| tbl受注 |
|
|
|
|
|
|
|
|
|
|
● |
|
|
● |
|
|
| tbl受注明細 |
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
|
|
| tbl出来高 |
|
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
| tbl出来高投入時間 |
|
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
| tbl出来高日報コメント |
|
|
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
| tbl生産指示 |
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
|
|
| tbl定期保守計画 |
|
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
| tbl定期保守項目 |
|
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
| tbl投入計画 |
● |
|
|
|
|
● |
|
|
|
|
|
|
● |
|
|
|
| tbl日別生産計画 |
● |
● |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| tbl入退場履歴 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
|
| tbl発注 |
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
|
|
| tbl発注明細 |
|
|
|
|
|
|
|
|
|
|
● |
|
|
|
|
|
| tbl備品 |
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
|
| tbl備品貸出予約 |
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
|
| tbl備品貸出履歴 |
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
|
| tbl部品設計変更履歴 |
|
● |
● |
|
|
|
|
|
|
|
|
|
|
|
|
|
| tbl部品棚卸 |
|
|
|
● |
● |
● |
|
|
|
|
|
|
|
|
|
|
| tbl部品入出庫 |
|
|
|
● |
● |
● |
|
|
|
|
|
|
|
|
|
|
| tbl部品入出庫過去履歴 |
|
|
|
● |
● |
|
|
|
|
|
|
|
|
|
|
|
| tbl部品表 |
|
● |
● |
|
|
|
|
|
|
|
|
|
|
|
|
|
| tbl部品表サマリ |
|
● |
● |
|
|
● |
|
|
|
|
● |
|
|
|
|
|
| tbl保守作業実績 |
|
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
| tbl保守設備 |
|
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
| tbl保守設備メンテ関連情報 |
|
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
| tbl保守設備履歴 |
|
|
|
|
|
|
|
● |
|
|
|
|
|
|
|
|
| tbl予定生産計画 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| tbl予定生産場所レート |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| tbl予定製造原価 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| tbl予定能力計画 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| tbl予定能力計画明細 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
| tbl予定標準時間 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
|