DROP TABLE IF EXISTS PurchaseOrderDate;
-- 注文書日付データ
CREATE TABLE PurchaseOrderDate
(
	ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード',
	SeqNo decimal(3) unsigned NOT NULL COMMENT '注文書枝番',
	CompanyCode decimal(8,0) NOT NULL COMMENT '協力会社コード',
	SendDate date NOT NULL COMMENT '注文書郵送日',
	ReturnDate date NOT NULL COMMENT '注文書返送日',
	ReturnCheckDate date NOT NULL COMMENT '注文書返送確認日',
	EntryDate datetime NOT NULL COMMENT '登録日付',
	UpdateDate datetime NOT NULL COMMENT '更新日付',
	PRIMARY KEY (ConstructionCode, SeqNo)
) COMMENT = '注文書日付データ';


DROP TABLE IF EXISTS RequestOrderDate;
-- 請求書日付データ
CREATE TABLE RequestOrderDate
(
	ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '工事コード',
	RequestNo decimal(9,0) NOT NULL COMMENT '請求No',
	SendDate date NOT NULL COMMENT '請求書発給郵送日',
	PaymentDate date NOT NULL COMMENT '入金日',
	EntryDate datetime NOT NULL COMMENT '登録日付',
	UpdateDate datetime NOT NULL COMMENT '更新日付'
) COMMENT = '請求書日付データ';