CREATE VIEW `v_shiharai_list` AS select
`t_denpyou_boki`.`簿記伝票ID` AS `簿記伝票ID`
,`t_shiharai_info`.`相手方登録CD` AS `相手方登録CD`
,`t_shiharai_info`.`支払日` AS `支払日`
,`t_shiharai_info`.`支払方法CD` AS `支払方法CD`
,`t_denpyou_boki`.`所属CD` AS `所属CD`
,`t_denpyou_boki`.`摘要名称` AS `摘要名称`
,`t_denpyou_boki`.`借方CD` AS `借方CD`
,`t_denpyou_boki`.`借方金額` AS `借方金額`
,`t_denpyou_boki`.`貸方CD` AS `貸方CD`
,`t_denpyou_boki`.`貸方金額` AS `貸方金額`
,`t_denpyou_boki`.`発行日` AS `発行日`
 from `t_denpyou_boki` join `t_shiharai_info`
 on `t_denpyou_boki`.`簿記伝票ID` = `t_shiharai_info`.`ID`
