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予定標準時間 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
● |
|