操作
タスク #6224
完了VKSHUTA[集配票マスター（集配手当用）]複数件取得するER図の実装見直し
開始日:
期日:
進捗率:
100%
予定工数:
実開始日:
ＤＤ名:
INCLUDE:
DSN:
バグ区分:
QA分析:
方針（第一貨物）:
実終了日:
ツールのバージョン:
AsIsSource行:
進捗計画:
設計・開発者:
画面ID:
機能区分:
機能ID:
レビュー指摘区分:
検査完了日:
検査依頼日:
説明
VKSHUTA[集配票マスター（集配手当用）] のユニーク条件は、
「TMJSSKNO[集配票ＮＯ]」「TMJSKYTN[稼働店所コード]」「TMJSSYHI[集荷、配達区分]」
の組であり、ER図1
1.集配票マスター取得
SELECT
*
FROM
VKSHUTA
WHERE
TMJSSKNO = :条件①
と、複数件取得できるSQLとなっている。
対して実装は、複数件取得できた場合にエラーが発生する。
修正対象ER図 → 1, 4, 5, 7, 10
メモ¶
VKSHUTA[集配票マスター（集配手当用）] 機能別 呼び出しER図一覧
| 機能ID | ER図(1) | ER図(2) | ER図(3) |
|---|---|---|---|
| BH10010 | vkshutaService.get1Data | ||
| BN10020 | vkshutaService.get1Data | ||
| BN10030 | vkshutaService.get1Data | ||
| BP30011 | vkshutaService.get3Data | ||
| BR10040 | vkshutaService.get1Data | ||
| BR10060 | vkshutaService.get1Data | ||
| BR10070 | vkshutaService.get1Data | ||
| BS0530 | vkshutaService.get1Data | vkshutaService.get3Data | |
| BS10010 | vkshutaService.get1Data | vkshutaService.get9Data | |
| BS10030 | vkshutaService.get1Data | ||
| BS10060 | vkshutaService.get1Data | ||
| BS10070 | vkshutaService.get1Data | ||
| BS10090 | vkshutaService.get1Data | ||
| BS10100 | vkshutaService.get1Data | ||
| BS10110 | vkshutaService.get1Data | ||
| BS10120 | vkshutaService.get1Data | ||
| BS10130 | vkshutaService.get1Data | ||
| BS10150 | vkshutaService.get1Data | ||
| BS10160 | vkshutaService.get1Data | ||
| BS10170 | vkshutaService.get8Data | ||
| BS10180 | vkshutaService.get8Data | ||
| BS10190 | vkshutaService.get1Data | ||
| BS10200 | vkshutaService.get1Data | ||
| BS10250 | vkshutaService.get1Data | ||
| BS10250 | vkshutaService.get1Data | ||
| BS10260 | vkshutaService.get9Data | ||
| BS10270 | vkshutaService.get3Data | vkshutaService.get9Data | |
| BS10300 | vkshutaService.get1Data | ||
| BS10310 | vkshutaService.get1Data | ||
| BS30010 | vkshutaService.get3Data | ||
| BS30070 | vkshutaService.get3Data | ||
| BS30150 | vkshutaService.get3Data | ||
| BS30170 | vkshutaService.get3Data | ||
| BS31060 | vkshutaService.get2Data | ||
| FA10020 | vkshutaService.get1Data | ||
| GJ10010 | vkshutaService.get6Data | ||
| KT30020 | vkshutaService.get1Data | ||
| LSS1000 | vkshutaService.get1Data | ||
| LSS1010 | vkshutaService.get1Data | vkshutaService.get4Data | |
| LSS1030 | vkshutaService.get3Data | ||
| TM10020 | vkshutaService.get1Data | vkshutaService.get3Data | vkshutaService.get10Data |
| TX30310 | vkshutaService.get3Data |
ファイル
操作