工事管理システム製品化対応

-- 入金確認承認データ

drop table if exists depositapprovalinfo cascade;

create table depositapprovalinfo (

  ORDERERSDIVISION decimal(5,0) not null comment '発注者区分'

  , ORDERERSCODE decimal(5,0) not null comment '発注者コード'

  , UPDATEDATE datetime comment '更新日付'

  , constraint depositapprovalinfo_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)

) comment '入金確認承認データ' ;

-- 入金データ

drop table if exists depositdata cascade;

  , ORDERERSCODE decimal(5,0) not null comment '発注者コード'

  , TARGETDATE decimal(6,0) not null comment '対象年月'

  , SEQNO decimal(3,0) not null comment '連番'

  , DEPOSITDATE date comment '入金日'

  , DEPOSITAMOUNTCASH decimal(10,0) comment '入金金額（現金）'

  , DEPOSITAMOUNTBILL decimal(10,0) comment '入金金額（手形）'

  , ENTRYDATE datetime comment '登録日付'

  , UPDATEDATE datetime comment '更新日付'

  , constraint depositdata_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO)

  , DISCOUNTAMOUNT decimal(10,0) comment '値引き金額'

  , CNSTRPRICE decimal(10,0) comment '協力金'

  , FEES decimal(10,0) comment '手数料'

  , ENTRYDATE datetime comment '登録日付'

  , UPDATEDATE datetime comment '更新日付'

  , constraint depositdatadetail_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO,LINECOUNT)