if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC0アクセスログ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC0アクセスログ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC0ウェイトフラグ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC0ウェイトフラグ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC1システムM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC1システムM]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC2演習M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC2演習M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC3学生グループM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC3学生グループM]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC4演習許可学生M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC4演習許可学生M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC4演習許可学生グループM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC4演習許可学生グループM]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC5学生M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC5学生M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC6演習履歴M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC6演習履歴M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC9元号M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC9元号M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC9区分M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC9区分M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC9名刺デザインM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC9名刺デザインM]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC9文書種類M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TC9文書種類M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA会社M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA会社M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA勘定科目M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA勘定科目M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA勘定科目会社学生M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA勘定科目会社学生M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA商品M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA商品M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA報告書書式M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA報告書書式M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA市場M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA市場M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA材料M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA材料M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA株主資本等変動計算書書式M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA株主資本等変動計算書書式M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA消費税率M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA消費税率M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA為替レートM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA為替レートM]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA経費労務費M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA経費労務費M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA表記名称M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA表記名称M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA部品展開M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA部品展開M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGA入出庫TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGA入出庫TRN]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGA入出庫明細TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGA入出庫明細TRN]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGA契約書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGA契約書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGA手形F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGA手形F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGA手形明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGA手形明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGB銀行口座F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGB銀行口座F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGB銀行口座入出金TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGB銀行口座入出金TRN]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC保険契約F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGC保険契約F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC出庫F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGC出庫F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC寄託在庫F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGC寄託在庫F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC寄託在庫明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGC寄託在庫明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC寄託者TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGC寄託者TRN]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC寄託者台帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGC寄託者台帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC寄託者明細TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGC寄託者明細TRN]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC運送契約F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGC運送契約F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGD製造指図書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGD製造指図書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGK現金入出金TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGK現金入出金TRN]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGPポータル会社F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGPポータル会社F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGPポータル商品F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGPポータル商品F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGU保険請求領収書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGU保険請求領収書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGU倉庫料請求領収書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGU倉庫料請求領収書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGU運送費請求領収書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGU運送費請求領収書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TKH小売販売M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TKH小売販売M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TKH小売販売TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TKH小売販売TRN]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TKH小売販売TTL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TKH小売販売TTL]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSA仕入売上書類F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSA仕入売上書類F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSA仕入売上書類明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSA仕入売上書類明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSA領収書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSA領収書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSB銀行取引申込書類F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSB銀行取引申込書類F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSC運送書類F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSC運送書類F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSC運送書類明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSC運送書類明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSC運送費請求書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSC運送費請求書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSC運送費請求書手動F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSC運送費請求書手動F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSC運送費請求書手動明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSC運送費請求書手動明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK伝票F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK伝票F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK伝票仕入売上明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK伝票仕入売上明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK伝票明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK伝票明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_仕訳帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK帳簿_仕訳帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_仕訳日記帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK帳簿_仕訳日記帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_仕訳集計表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK帳簿_仕訳集計表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_八桁精算表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK帳簿_八桁精算表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_合計残高試算表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK帳簿_合計残高試算表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_損益計算書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK帳簿_損益計算書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_株主資本等変動計算書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK帳簿_株主資本等変動計算書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_株主資本等変動計算書FM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK帳簿_株主資本等変動計算書FM]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_総勘定元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK帳簿_総勘定元帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_貸借対照表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK帳簿_貸借対照表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_仕入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_仕入帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_原価計算表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_原価計算表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_受取手形記入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_受取手形記入帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_商品有高帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_商品有高帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_売上帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_売上帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_売掛金元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_売掛金元帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_小口現金出納帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_小口現金出納帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_当座預金出納帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_当座預金出納帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_支払手形記入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_支払手形記入帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_材料仕入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_材料仕入帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_材料元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_材料元帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_現金出納帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_現金出納帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_製造間接費配賦表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_製造間接費配賦表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_買掛金元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TSK補助簿_買掛金元帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTA損益計画F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTA損益計画F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTA社員台帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTA社員台帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTA社員台帳M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTA社員台帳M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTA給与明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTA給与明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTK摘要M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTK摘要M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTK記帳チェック2F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTK記帳チェック2F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTK記帳チェックF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTK記帳チェックF]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTL合併残高F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTL合併残高F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTM名刺データ2F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTM名刺データ2F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTM名刺データF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTM名刺データF]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTXFAXF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTXFAXF]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTXメールF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTXメールF]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTX文書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTX文書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TC4演習許可学生M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TC4演習許可学生M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TC4演習許可学生グループM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TC4演習許可学生グループM]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TC5学生M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TC5学生M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TDA報告書書式M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TDA報告書書式M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TDA株主資本等変動計算書書式M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TDA株主資本等変動計算書書式M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TDA経費労務費M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TDA経費労務費M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TDA部品展開M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TDA部品展開M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TGA入出庫明細TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TGA入出庫明細TRN]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TGB銀行口座入出金TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TGB銀行口座入出金TRN]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TGC寄託在庫明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TGC寄託在庫明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK伝票仕入売上明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK伝票仕入売上明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK伝票明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK伝票明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_仕訳帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK帳簿_仕訳帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_仕訳日記帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK帳簿_仕訳日記帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_仕訳集計表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK帳簿_仕訳集計表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_八桁精算表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK帳簿_八桁精算表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_合計残高試算表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK帳簿_合計残高試算表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_損益計算書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK帳簿_損益計算書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_株主資本等変動計算書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK帳簿_株主資本等変動計算書F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_総勘定元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK帳簿_総勘定元帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_貸借対照表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK帳簿_貸借対照表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_仕入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_仕入帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_原価計算表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_原価計算表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_受取手形記入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_受取手形記入帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_商品有高帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_商品有高帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_売上帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_売上帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_売掛金元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_売掛金元帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_小口現金出納帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_小口現金出納帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_当座預金出納帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_当座預金出納帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_支払手形記入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_支払手形記入帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_材料仕入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_材料仕入帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_材料元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_材料元帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_現金出納帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_現金出納帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_製造間接費配賦表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_製造間接費配賦表F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_買掛金元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TSK補助簿_買掛金元帳F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TTL合併残高F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[YTMP_TTL合併残高F]
GO

CREATE TABLE [dbo].[TC0アクセスログ] (
	[システムCD] [varchar] (12) NOT NULL ,
	[ログイン試行日時] [datetime] NULL ,
	[ログインID] [varchar] (12) NULL ,
	[ログインパスワード] [varchar] (12) NULL ,
	[リモートアドレス] [varchar] (30) NULL ,
	[接続成否] [varchar] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC0ウェイトフラグ] (
	[システムCD] [varchar] (12) NOT NULL ,
	[ウェイトフラグ] [varchar] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC1システムM] (
	[システムCD] [varchar] (12) NOT NULL ,
	[ユーザー名] [varchar] (50) NULL ,
	[デフォルトフラグ] [varchar] (2) NULL ,
	[システム名称] [varchar] (50) NULL ,
	[バージョン] [varchar] (20) NULL ,
	[ユーザー区分] [smallint] NULL ,
	[管理者コード] [varchar] (12) NULL ,
	[パスワード] [varchar] (8) NULL ,
	[共通データパス] [varchar] (250) NULL ,
	[IPアドレス] [varchar] (200) NULL ,
	[学校CD] [varchar] (200) NULL ,
	[方式] [int] NULL ,
	[APP種類] [int] NULL ,
	[FAX利用] [varchar] (2) NULL ,
	[FAX利用可能拡張子] [varchar] (8000) NULL ,
	[名刺印刷余白上] [real] NULL ,
	[名刺印刷余白左] [real] NULL ,
	[会社設立時手数料メッセージ] [varchar] (2) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC2演習M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[マスター演習] [varchar] (2) NULL ,
	[演習名称] [varchar] (40) NULL ,
	[演習区分] [varchar] (1) NULL ,
	[パッケージ区分] [varchar] (2) NULL ,
	[会計開始日] [datetime] NULL ,
	[会計終了日] [datetime] NULL ,
	[実践日] [datetime] NULL ,
	[消費税] [real] NULL ,
	[演習管理者ID] [varchar] (200) NULL ,
	[演習管理者パスワード] [varchar] (12) NULL ,
	[利用伝票数区分] [varchar] (1) NULL ,
	[銀行自動処理] [varchar] (1) NULL ,
	[銀行口座番号手動] [varchar] (2) NULL ,
	[銀行手形取立割引手動] [varchar] (2) NULL ,
	[銀行市場間利用] [varchar] (2) NULL ,
	[銀行窓口依頼保存] [varchar] (2) NULL ,
	[手動補助簿表示] [varchar] (2) NULL ,
	[手動仕訳帳表示] [varchar] (2) NULL ,
	[手動仕訳集計表表示] [varchar] (2) NULL ,
	[手動合計残高試算表表示] [varchar] (2) NULL ,
	[手動総勘定元帳表示] [varchar] (2) NULL ,
	[手動貸借対照表表示] [varchar] (2) NULL ,
	[手動損益計算書表示] [varchar] (2) NULL ,
	[手動8桁精算表表示] [varchar] (2) NULL ,
	[手動株主資本等変動計算書表示] [varchar] (2) NULL ,
	[自動転記仕訳帳表示] [varchar] (2) NULL ,
	[自動転記仕訳集計表表示] [varchar] (2) NULL ,
	[自動転記合計残高試算表表示] [varchar] (2) NULL ,
	[自動転記総勘定元帳表示] [varchar] (2) NULL ,
	[自動転記貸借対照表表示] [varchar] (2) NULL ,
	[自動転記損益計算書表示] [varchar] (2) NULL ,
	[自動転記8桁精算表表示] [varchar] (2) NULL ,
	[自動転記株主資本等変動計算書表示] [varchar] (2) NULL ,
	[現金出納帳表示] [varchar] (2) NULL ,
	[小口現金出納帳表示] [varchar] (2) NULL ,
	[当座預金出納帳表示] [varchar] (2) NULL ,
	[売上帳表示] [varchar] (2) NULL ,
	[仕入帳表示] [varchar] (2) NULL ,
	[売掛金元帳表示] [varchar] (2) NULL ,
	[買掛金元帳表示] [varchar] (2) NULL ,
	[商品有高帳表示] [varchar] (2) NULL ,
	[受取手形記入帳表示] [varchar] (2) NULL ,
	[支払手形記入帳表示] [varchar] (2) NULL ,
	[自動転記現金出納帳表示] [varchar] (2) NULL ,
	[自動転記当座預金出納帳表示] [varchar] (2) NULL ,
	[自動転記売上帳表示] [varchar] (2) NULL ,
	[自動転記仕入帳表示] [varchar] (2) NULL ,
	[自動転記売掛金元帳表示] [varchar] (2) NULL ,
	[自動転記買掛金元帳表示] [varchar] (2) NULL ,
	[自動転記商品有高帳表示] [varchar] (2) NULL ,
	[自動転記受取手形記入帳表示] [varchar] (2) NULL ,
	[自動転記支払手形記入帳表示] [varchar] (2) NULL ,
	[帳簿手入力自動トグル] [varchar] (2) NULL ,
	[財務諸表貸借対照表表示] [varchar] (2) NULL ,
	[財務諸表損益計算書表示] [varchar] (2) NULL ,
	[財務諸表キャッシュフロー計算書表示] [varchar] (2) NULL ,
	[財務諸表株主資本等変動計算書表示] [varchar] (2) NULL ,
	[財務分析損益実績表示] [varchar] (2) NULL ,
	[財務分析収益性表示] [varchar] (2) NULL ,
	[財務分析安全性表示] [varchar] (2) NULL ,
	[財務分析損益分岐点表示] [varchar] (2) NULL ,
	[履歴表示] [varchar] (200) NULL ,
	[銀行窓口表示] [varchar] (2) NULL ,
	[金庫表示] [varchar] (2) NULL ,
	[小切手表示] [varchar] (2) NULL ,
	[約束手形表示] [varchar] (2) NULL ,
	[為替手形表示] [varchar] (2) NULL ,
	[領収書表示] [varchar] (2) NULL ,
	[給与台帳表示] [varchar] (2) NULL ,
	[利用銀行口座種類] [varchar] (200) NULL ,
	[振込手数料低金額自行間] [money] NULL ,
	[振込手数料高金額自行間] [money] NULL ,
	[振込手数料低金額他行間] [money] NULL ,
	[振込手数料高金額他行間] [money] NULL ,
	[振込手数料高低区切金額] [money] NULL ,
	[手形割引率] [real] NULL ,
	[振込手数料当座振込元負担] [varchar] (2) NULL ,
	[振込手数料非当座振込元負担] [varchar] (2) NULL ,
	[残高証明書手数料] [money] NULL ,
	[自動番号伝票] [varchar] (2) NULL ,
	[自動番号仕入売上書類] [varchar] (2) NULL ,
	[自動番号手形] [varchar] (2) NULL ,
	[自動番号領収書] [varchar] (2) NULL ,
	[自動番号銀行書類] [varchar] (2) NULL ,
	[残高自動計算] [varchar] (2) NULL ,
	[日付仕訳日指定] [varchar] (2) NULL ,
	[仕入売上伝票消費税手動仕訳] [varchar] (2) NULL ,
	[振替伝票表示行数] [int] NULL ,
	[入庫時相手出庫必要] [varchar] (2) NULL ,
	[出庫時在庫必要] [varchar] (2) NULL ,
	[仕入売上書類受発信利用] [varchar] (2) NULL ,
	[仕入売上書類検認利用] [varchar] (50) NULL ,
	[注文請書確認利用] [varchar] (2) NULL ,
	[仕入売上書類先方書類必要] [varchar] (2) NULL ,
	[管理部買入売渡運賃諸掛] [varchar] (2) NULL ,
	[出庫時注文請書必要] [varchar] (2) NULL ,
	[出庫時払出単価入力] [varchar] (2) NULL ,
	[仕入他市場管理部利用] [varchar] (2) NULL ,
	[整理記入精算表利用] [varchar] (2) NULL ,
	[整理記入当期損益挿入先] [varchar] (4) NULL ,
	[総勘定元帳標準式利用] [varchar] (2) NULL ,
	[総勘定元帳月計累計利用] [varchar] (2) NULL ,
	[手形修正] [varchar] (2) NULL ,
	[小切手返却利用] [varchar] (2) NULL ,
	[通帳手動修正] [varchar] (2) NULL ,
	[商品入出庫整合性利用] [varchar] (2) NULL ,
	[当座引出振込小切手必要] [varchar] (2) NULL ,
	[記帳チェック表示] [varchar] (2) NULL ,
	[現物チェック表示] [varchar] (2) NULL ,
	[商品チェック表示] [varchar] (2) NULL ,
	[チェック画面リンク利用] [varchar] (2) NULL ,
	[商品開発課利用] [varchar] (2) NULL ,
	[メール利用] [varchar] (2) NULL ,
	[印刷ヘッダー表示] [varchar] (2) NULL ,
	[捺印利用] [varchar] (2) NULL ,
	[実印利用] [varchar] (2) NULL ,
	[仕入売上書類控え印刷] [varchar] (2) NULL ,
	[仕入売上書類社名優先] [varchar] (2) NULL ,
	[標準販売単価表示] [varchar] (2) NULL ,
	[送付済み手形表示様式] [varchar] (2) NULL ,
	[送付済み小切手表示様式] [varchar] (2) NULL ,
	[送付済み領収書表示様式] [varchar] (2) NULL ,
	[自動転記総勘定元帳仕丁表示] [varchar] (2) NULL ,
	[期首設定経理部利用] [varchar] (2) NULL ,
	[為替レート利用] [varchar] (2) NULL ,
	[小売販売有無] [varchar] (2) NULL ,
	[倉庫部利用] [varchar] (2) NULL ,
	[寄託倉庫利用] [varchar] (2) NULL ,
	[原価会計利用] [varchar] (2) NULL ,
	[WebCollabo利用] [varchar] (2) NULL ,
	[名刺作成旧バージョン利用] [varchar] (2) NULL ,
	[運送費請求書旧バージョン利用] [varchar] (2) NULL ,
	[手入力仕訳帳旧バージョン利用] [varchar] (2) NULL ,
	[期末繰越先演習CD] [varchar] (12) NULL ,
	[コピー元演習名称] [varchar] (40) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC3学生グループM] (
	[システムCD] [varchar] (12) NOT NULL ,
	[学生グループCD] [varchar] (12) NOT NULL ,
	[グループ名称] [varchar] (40) NULL ,
	[グループキー] [varchar] (12) NULL ,
	[作成者ID] [varchar] (200) NULL ,
	[非表示フラグ] [varchar] (2) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC4演習許可学生M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[学生番号] [varchar] (12) NOT NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC4演習許可学生グループM] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[学生グループCD] [varchar] (12) NOT NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC5学生M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[学生番号] [varchar] (12) NOT NULL ,
	[氏名] [varchar] (30) NULL ,
	[氏名略名称] [varchar] (8) NULL ,
	[パスワード] [varchar] (12) NULL ,
	[演習CD] [varchar] (12) NULL ,
	[学生グループCD] [varchar] (12) NULL ,
	[最新ログイン日] [datetime] NULL ,
	[更新時の戻り先] [varchar] (1000) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC6演習履歴M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[学生番号] [varchar] (12) NOT NULL ,
	[選択会社CD] [varchar] (20) NOT NULL ,
	[最終参加日時] [datetime] NULL ,
	[メール送信拒否] [varchar] (2) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC9元号M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[元号CD] [int] NOT NULL ,
	[元号] [varchar] (255) NULL ,
	[開始日] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC9区分M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[データ識別] [varchar] (20) NOT NULL ,
	[区分CD] [varchar] (2) NOT NULL ,
	[区分名称] [varchar] (20) NULL ,
	[順序] [int] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC9名刺デザインM] (
	[システムCD] [varchar] (12) NOT NULL ,
	[名刺デザインCD] [varchar] (12) NOT NULL ,
	[縦横区分] [varchar] (2) NULL ,
	[デザイン] [varchar] (7200) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TC9文書種類M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[自動フラグ] [varchar] (2) NOT NULL ,
	[文書名称] [varchar] (40) NULL ,
	[アドレス] [varchar] (120) NULL ,
	[順序] [int] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA会社M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[市場CD] [varchar] (6) NULL ,
	[学生番号] [varchar] (12) NULL ,
	[会社名称] [varchar] (80) NULL ,
	[会社略名称] [varchar] (10) NULL ,
	[会社カナ名称] [varchar] (40) NULL ,
	[郵便番号] [varchar] (8) NULL ,
	[住所1] [varchar] (50) NULL ,
	[住所2] [varchar] (50) NULL ,
	[TEL] [varchar] (14) NULL ,
	[FAX] [varchar] (14) NULL ,
	[業種CD] [varchar] (1) NULL ,
	[自社フラグ] [smallint] NULL ,
	[代表取締役] [varchar] (200) NULL ,
	[取締役1] [varchar] (200) NULL ,
	[取締役2] [varchar] (200) NULL ,
	[発起人4] [varchar] (200) NULL ,
	[発起人5] [varchar] (200) NULL ,
	[代表取締役住所] [varchar] (200) NULL ,
	[取締役1住所] [varchar] (200) NULL ,
	[取締役2住所] [varchar] (200) NULL ,
	[発起人4住所] [varchar] (200) NULL ,
	[発起人5住所] [varchar] (200) NULL ,
	[発起人1株式数] [money] NULL ,
	[発起人2株式数] [money] NULL ,
	[発起人3株式数] [money] NULL ,
	[発起人4株式数] [money] NULL ,
	[発起人5株式数] [money] NULL ,
	[株式の額面] [money] NULL ,
	[事業目的] [varchar] (200) NULL ,
	[資本金] [money] NULL ,
	[寄託会社CD] [varchar] (40) NULL ,
	[前演習繰越フラグ] [varchar] (2) NULL ,
	[次演習繰越フラグ] [varchar] (2) NULL ,
	[トップ画像] [varchar] (255) NULL ,
	[トップ画像マスタ] [varchar] (255) NULL ,
	[同時同業生徒自社] [varchar] (2) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA勘定科目M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[勘定CD] [varchar] (25) NOT NULL ,
	[業種CD] [varchar] (1) NULL ,
	[勘定名称] [varchar] (40) NULL ,
	[勘定略名称] [varchar] (20) NULL ,
	[勘定区分] [varchar] (2) NULL ,
	[勘定細目] [varchar] (2) NULL ,
	[所有会社CD] [varchar] (20) NULL ,
	[貸借区分] [varchar] (2) NULL ,
	[データ区分] [varchar] (2) NULL ,
	[費用区分] [varchar] (2) NULL ,
	[分析用区分] [varchar] (2) NULL ,
	[チェック区分] [varchar] (2) NULL ,
	[特別勘定区分] [varchar] (2) NULL ,
	[集計先勘定] [varchar] (4) NULL ,
	[集計区分] [varchar] (1) NULL ,
	[諸表集計CD] [varchar] (4) NULL ,
	[キャッシュフロー計算書集計CD] [varchar] (4) NULL ,
	[株主資本等変動計算書集計CD] [varchar] (4) NULL ,
	[製造原価報告書集計CD] [varchar] (4) NULL ,
	[作成区分] [smallint] NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA勘定科目会社学生M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[勘定CD] [varchar] (25) NOT NULL ,
	[業種CD] [varchar] (1) NULL ,
	[勘定名称] [varchar] (40) NULL ,
	[勘定略名称] [varchar] (20) NULL ,
	[勘定区分] [varchar] (2) NULL ,
	[勘定細目] [varchar] (2) NULL ,
	[所有会社CD] [varchar] (20) NOT NULL ,
	[貸借区分] [varchar] (2) NULL ,
	[データ区分] [varchar] (2) NULL ,
	[費用区分] [varchar] (2) NULL ,
	[分析用区分] [varchar] (2) NULL ,
	[チェック区分] [varchar] (2) NULL ,
	[特別勘定区分] [varchar] (2) NULL ,
	[集計先勘定] [varchar] (4) NULL ,
	[集計区分] [varchar] (1) NULL ,
	[諸表集計CD] [varchar] (4) NULL ,
	[キャッシュフロー計算書集計CD] [varchar] (4) NULL ,
	[株主資本等変動計算書集計CD] [varchar] (4) NULL ,
	[製造原価報告書集計CD] [varchar] (4) NULL ,
	[作成区分] [smallint] NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA商品M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[商品CD] [varchar] (20) NOT NULL ,
	[市場CD] [varchar] (6) NULL ,
	[学生番号] [varchar] (12) NULL ,
	[所有会社CD] [varchar] (20) NULL ,
	[仕入先CD] [varchar] (20) NULL ,
	[商品名称] [varchar] (80) NULL ,
	[商品略名称] [varchar] (20) NULL ,
	[商品区分CD] [varchar] (2) NULL ,
	[標準販売単価] [money] NULL ,
	[標準消費税率] [real] NULL ,
	[標準仕入単価] [money] NULL ,
	[運送料単価] [money] NULL ,
	[倉庫料単価] [money] NULL ,
	[商品重量] [real] NULL ,
	[商品容積] [real] NULL ,
	[備考] [varchar] (40) NULL ,
	[作成区分] [smallint] NULL ,
	[画像ファイル] [varchar] (200) NULL ,
	[単位] [varchar] (200) NULL ,
	[ロット] [money] NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA報告書書式M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[帳票区分] [varchar] (1) NOT NULL ,
	[集計CD] [varchar] (4) NOT NULL ,
	[集計名称] [varchar] (40) NULL ,
	[貸借] [varchar] (2) NULL ,
	[集計先] [varchar] (4) NULL ,
	[加減区分] [varchar] (1) NULL ,
	[ラインコントロール] [varchar] (1) NULL ,
	[アンダーライン] [varchar] (1) NULL ,
	[右方表示] [varchar] (1) NULL ,
	[構成表示] [varchar] (1) NULL ,
	[作成区分] [smallint] NULL ,
	[更新プログラムID] [varchar] (30) NULL ,
	[更新日時] [datetime] NULL ,
	[表示順] [int] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA市場M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[市場CD] [varchar] (6) NOT NULL ,
	[市場名称] [varchar] (50) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA材料M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[材料CD] [varchar] (20) NOT NULL ,
	[市場CD] [varchar] (6) NULL ,
	[学生番号] [varchar] (12) NULL ,
	[所有会社CD] [varchar] (20) NULL ,
	[仕入先CD] [varchar] (20) NULL ,
	[材料名称] [varchar] (80) NULL ,
	[材料略名称] [varchar] (20) NULL ,
	[材料区分CD] [varchar] (2) NULL ,
	[標準販売単価] [money] NULL ,
	[標準消費税率] [real] NULL ,
	[標準仕入単価] [money] NULL ,
	[運送料単価] [money] NULL ,
	[倉庫料単価] [money] NULL ,
	[材料重量] [real] NULL ,
	[材料容積] [real] NULL ,
	[備考] [varchar] (40) NULL ,
	[作成区分] [smallint] NULL ,
	[画像ファイル] [varchar] (200) NULL ,
	[単位] [varchar] (200) NULL ,
	[ロット] [money] NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA株主資本等変動計算書書式M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[集計CD] [varchar] (4) NOT NULL ,
	[集計分類1] [varchar] (40) NULL ,
	[集計分類2] [varchar] (40) NULL ,
	[集計分類3] [varchar] (40) NULL ,
	[集計区分] [varchar] (40) NULL ,
	[変動額細目] [varchar] (40) NULL ,
	[集計先] [varchar] (4) NULL ,
	[加減区分] [varchar] (1) NULL ,
	[ラインコントロール] [varchar] (1) NULL ,
	[アンダーライン] [varchar] (1) NULL ,
	[表示順] [int] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA消費税率M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[消費税率] [real] NOT NULL ,
	[標準] [varchar] (2) NULL ,
	[運送費標準] [varchar] (2) NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA為替レートM] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[通貨CD] [int] NOT NULL ,
	[名称] [varchar] (255) NULL ,
	[単位] [varchar] (255) NULL ,
	[金額] [money] NULL ,
	[摘要] [varchar] (255) NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA経費労務費M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[製造区分] [varchar] (2) NOT NULL ,
	[製品CD] [varchar] (20) NOT NULL ,
	[経費労務費区分] [varchar] (2) NOT NULL ,
	[経費労務費CD] [int] NOT NULL ,
	[摘要] [varchar] (255) NULL ,
	[金額] [money] NOT NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA表記名称M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[表記CD] [varchar] (12) NOT NULL ,
	[基準名称] [varchar] (255) NULL ,
	[表記名称] [varchar] (255) NULL ,
	[制限バイト数] [int] NULL ,
	[表示順] [int] NULL ,
	[備考] [varchar] (255) NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TDA部品展開M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[製造区分] [varchar] (2) NOT NULL ,
	[製品CD] [varchar] (20) NOT NULL ,
	[部品展開Seq] [int] NOT NULL ,
	[材料区分] [varchar] (2) NOT NULL ,
	[材料CD] [varchar] (20) NOT NULL ,
	[材料数量] [money] NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGA入出庫TRN] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[処理時期区分] [smallint] NULL ,
	[処理日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[先方文書種類CD] [varchar] (2) NULL ,
	[先方文書内容CD] [varchar] (20) NULL ,
	[先方処理日] [datetime] NULL ,
	[運賃諸掛区分] [varchar] (1) NULL ,
	[運送費] [money] NULL ,
	[発行フラグ] [smallint] NULL ,
	[返信フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[有効フラグ] [smallint] NULL ,
	[学生番号] [varchar] (20) NULL ,
	[寄託会社CD] [varchar] (200) NULL ,
	[運送会社CD] [varchar] (200) NULL ,
	[先方寄託会社CD] [varchar] (200) NULL ,
	[先方仕入売上種類CD] [varchar] (2) NULL ,
	[先方仕入売上内容CD] [varchar] (20) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGA入出庫明細TRN] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[入出庫SEQ] [smallint] NOT NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[単価] [money] NULL ,
	[元単価] [money] NULL ,
	[運送単価] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGA契約書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[送受信区分] [varchar] (2) NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[甲担当者CD] [int] NULL ,
	[乙担当者CD] [int] NULL ,
	[管轄裁判所] [varchar] (20) NULL ,
	[発行フラグ] [smallint] NULL ,
	[返信フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[処理日] [datetime] NULL ,
	[開始日] [datetime] NULL ,
	[終了日] [datetime] NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGA手形F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[手形番号] [varchar] (20) NULL ,
	[送受信区分] [varchar] (2) NULL ,
	[取引日] [datetime] NULL ,
	[振出人CD] [varchar] (20) NULL ,
	[受取人CD] [varchar] (20) NULL ,
	[引受人CD] [varchar] (20) NULL ,
	[裏書人CD] [varchar] (20) NULL ,
	[被裏書人CD] [varchar] (20) NULL ,
	[支払期日] [datetime] NULL ,
	[金額] [money] NULL ,
	[支払場所CD] [varchar] (20) NULL ,
	[摘要] [varchar] (40) NULL ,
	[顛末区分] [varchar] (2) NULL ,
	[顛末日] [datetime] NULL ,
	[顛末摘要] [varchar] (20) NULL ,
	[利息金額] [money] NULL ,
	[発行フラグ] [smallint] NULL ,
	[開封フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGA手形明細F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[文書内容SEQ] [smallint] NOT NULL ,
	[取引日] [datetime] NULL ,
	[裏書人CD] [varchar] (20) NULL ,
	[被裏書人CD] [varchar] (20) NULL ,
	[顛末区分] [varchar] (2) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGB銀行口座F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[銀行CD] [varchar] (20) NOT NULL ,
	[口座区分] [varchar] (1) NOT NULL ,
	[口座番号] [varchar] (20) NOT NULL ,
	[会社CD] [varchar] (20) NULL ,
	[処理日] [datetime] NULL ,
	[暗証番号] [varchar] (20) NULL ,
	[摘要] [varchar] (40) NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGB銀行口座入出金TRN] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[銀行CD] [varchar] (20) NOT NULL ,
	[口座区分] [varchar] (1) NOT NULL ,
	[口座番号] [varchar] (20) NOT NULL ,
	[入出金CD] [varchar] (12) NOT NULL ,
	[処理時期区分] [smallint] NULL ,
	[処理日] [datetime] NULL ,
	[金額] [money] NULL ,
	[銀行取引区分] [varchar] (2) NULL ,
	[摘要] [varchar] (40) NULL ,
	[学生番号] [varchar] (12) NULL ,
	[結果通知銀行CD] [varchar] (20) NULL ,
	[結果通知種類CD] [varchar] (2) NULL ,
	[結果通知内容CD] [varchar] (20) NULL ,
	[既読フラグ] [varchar] (2) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGC保険契約F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[申込番号] [smallint] NOT NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[保険種別] [varchar] (10) NULL ,
	[保険区分] [varchar] (2) NULL ,
	[申込年月日] [datetime] NULL ,
	[保険開始年月日] [datetime] NULL ,
	[保険終了年月日] [datetime] NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[単価] [money] NULL ,
	[保険対象金額] [money] NULL ,
	[料率] [real] NULL ,
	[請求金額] [money] NULL ,
	[備考] [varchar] (40) NULL ,
	[請求書発行フラグ] [smallint] NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGC出庫F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[出庫番号] [smallint] NOT NULL ,
	[寄託受付番号] [smallint] NULL ,
	[商品CD] [varchar] (20) NULL ,
	[寄託者CD] [varchar] (20) NULL ,
	[出庫年月日] [datetime] NULL ,
	[期数] [smallint] NULL ,
	[出庫数量] [int] NULL ,
	[請求書発行フラグ] [smallint] NULL ,
	[請求書発行日] [datetime] NULL ,
	[請求倉庫料金] [money] NULL ,
	[保管料金] [money] NULL ,
	[荷役料金] [money] NULL ,
	[摘要] [varchar] (40) NULL ,
	[学生番号] [varchar] (20) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGC寄託在庫F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[寄託依頼会社CD] [varchar] (20) NOT NULL ,
	[寄託受付番号] [smallint] NOT NULL ,
	[寄託開始年月日] [datetime] NULL ,
	[寄託保管期日] [datetime] NULL ,
	[入庫年月日] [datetime] NULL ,
	[倉庫場所] [varchar] (30) NULL ,
	[倉庫種別] [varchar] (10) NULL ,
	[処理日] [datetime] NULL ,
	[削除フラグ] [smallint] NULL ,
	[有効フラグ] [smallint] NULL ,
	[学生番号] [varchar] (20) NULL ,
	[先方文書種類CD] [varchar] (2) NULL ,
	[先方文書内容CD] [varchar] (20) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGC寄託在庫明細F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[寄託依頼会社CD] [varchar] (20) NOT NULL ,
	[寄託受付番号] [smallint] NOT NULL ,
	[寄託受付番号SEQ] [smallint] NOT NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[仕入単価] [money] NULL ,
	[運送単価] [money] NULL ,
	[総出庫数] [int] NULL ,
	[摘要] [varchar] (40) NULL ,
	[火災保険料金] [money] NULL ,
	[火災保険料率] [real] NULL ,
	[荷役料金] [money] NULL ,
	[荷役料率] [real] NULL ,
	[従量率] [real] NULL ,
	[従価率] [real] NULL ,
	[保管料金] [money] NULL ,
	[倉荷証券番号] [varchar] (20) NULL ,
	[倉荷証券発行手数料] [money] NULL ,
	[倉荷証券発行フラグ] [smallint] NULL ,
	[倉荷証券請求フラグ] [smallint] NULL ,
	[倉荷証券回収フラグ] [smallint] NULL ,
	[倉荷証券回収日] [datetime] NULL ,
	[学生番号] [varchar] (20) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGC寄託者TRN] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[処理時期区分] [smallint] NULL ,
	[処理日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[先方文書種類CD] [varchar] (2) NULL ,
	[先方文書内容CD] [varchar] (20) NULL ,
	[先方処理日] [datetime] NULL ,
	[運賃諸掛区分] [varchar] (1) NULL ,
	[運送費] [money] NULL ,
	[発行フラグ] [smallint] NULL ,
	[返信フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[有効フラグ] [smallint] NULL ,
	[学生番号] [varchar] (20) NULL ,
	[寄託会社CD] [varchar] (200) NULL ,
	[運送会社CD] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGC寄託者台帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[寄託受付番号] [smallint] NOT NULL ,
	[寄託者CD] [varchar] (20) NULL ,
	[寄託者名称] [varchar] (40) NULL ,
	[商品CD] [varchar] (20) NULL ,
	[寄託開始年月日] [datetime] NULL ,
	[寄託保管期日] [datetime] NULL ,
	[寄託数量] [int] NULL ,
	[倉庫場所] [varchar] (30) NULL ,
	[倉庫種別] [varchar] (10) NULL ,
	[入庫年月日] [datetime] NULL ,
	[入庫数量] [real] NULL ,
	[単価] [money] NULL ,
	[単量] [real] NULL ,
	[荷姿] [varchar] (30) NULL ,
	[才数] [real] NULL ,
	[摘要] [varchar] (40) NULL ,
	[総出庫数] [int] NULL ,
	[残高] [money] NULL ,
	[火災保険料金] [money] NULL ,
	[火災保険料率] [real] NULL ,
	[保管料金] [money] NULL ,
	[荷役料金] [money] NULL ,
	[従量率] [real] NULL ,
	[従価率] [real] NULL ,
	[荷役料率] [real] NULL ,
	[倉荷証券請求フラグ] [smallint] NULL ,
	[倉荷証券発行フラグ] [smallint] NULL ,
	[倉荷証券回収フラグ] [smallint] NULL ,
	[倉荷証券番号] [varchar] (20) NULL ,
	[倉荷証券回収日] [datetime] NULL ,
	[倉荷証券発行手数料] [money] NULL ,
	[学生番号] [varchar] (20) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGC寄託者明細TRN] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[入出庫SEQ] [smallint] NOT NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[単価] [money] NULL ,
	[元単価] [money] NULL ,
	[運送単価] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGC運送契約F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[申込番号] [smallint] NOT NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[申込年月日] [datetime] NULL ,
	[荷受取引先CD] [varchar] (20) NULL ,
	[荷送取引先CD] [varchar] (20) NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[単価] [money] NULL ,
	[運賃] [money] NULL ,
	[地区割増料] [money] NULL ,
	[荷造料金] [money] NULL ,
	[保険料金] [money] NULL ,
	[料率] [real] NULL ,
	[請求金額] [money] NULL ,
	[備考] [varchar] (40) NULL ,
	[請求書発行フラグ] [smallint] NULL ,
	[計算用1] [varchar] (20) NULL ,
	[計算用2] [varchar] (20) NULL ,
	[計算用3] [varchar] (20) NULL ,
	[計算用4] [varchar] (20) NULL ,
	[計算用5] [varchar] (20) NULL ,
	[計算用6] [varchar] (20) NULL ,
	[計算用7] [varchar] (20) NULL ,
	[計算用8] [varchar] (20) NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGD製造指図書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[製造状況区分] [varchar] (2) NOT NULL ,
	[商品入庫CD] [varchar] (20) NOT NULL ,
	[材料出庫CD] [varchar] (20) NOT NULL ,
	[処理日] [datetime] NULL ,
	[完了日] [datetime] NULL ,
	[経費] [money] NULL ,
	[労務費] [money] NULL ,
	[削除フラグ] [smallint] NULL ,
	[学生番号] [varchar] (20) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGK現金入出金TRN] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[現金入出金CD] [int] NOT NULL ,
	[処理時期区分] [smallint] NULL ,
	[処理日] [datetime] NULL ,
	[金額] [money] NULL ,
	[現金取引区分] [varchar] (2) NULL ,
	[摘要] [varchar] (40) NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGPポータル会社F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[見出し文] [varchar] (255) NULL ,
	[バナー] [varchar] (255) NULL ,
	[紹介文] [varchar] (240) NULL ,
	[商品棚表示] [varchar] (1) NULL ,
	[商品棚在庫無し表示] [varchar] (1) NULL ,
	[コンテンツ表示] [varchar] (1) NULL ,
	[コンテンツタイトル] [varchar] (60) NULL ,
	[コンテンツ] [varchar] (255) NULL ,
	[リンク表示] [varchar] (1) NULL ,
	[リンクタイトル] [varchar] (60) NULL ,
	[リンク] [varchar] (240) NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGPポータル商品F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[商品棚CD] [int] NOT NULL ,
	[表示順] [int] NULL ,
	[商品CD] [varchar] (20) NULL ,
	[商品広告画像] [varchar] (255) NULL ,
	[商品画像区分] [varchar] (1) NULL ,
	[商品見出し文] [varchar] (100) NULL ,
	[商品広告文] [varchar] (1000) NULL ,
	[希望卸価格] [money] NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGU保険請求領収書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[保険種別] [varchar] (10) NOT NULL ,
	[文書内容CD] [int] NOT NULL ,
	[番号] [varchar] (20) NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[処理日] [datetime] NULL ,
	[保険対象金額] [money] NULL ,
	[保険料金] [money] NULL ,
	[期間始] [datetime] NULL ,
	[期間終] [datetime] NULL ,
	[備考] [varchar] (255) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGU倉庫料請求領収書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[文書内容CD] [int] NOT NULL ,
	[番号] [varchar] (20) NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[処理日] [datetime] NULL ,
	[貯蔵倉庫場所] [varchar] (40) NULL ,
	[入庫日] [datetime] NULL ,
	[出庫日] [datetime] NULL ,
	[期間始] [datetime] NULL ,
	[期間終] [datetime] NULL ,
	[保管料] [money] NULL ,
	[入庫料] [money] NULL ,
	[出庫料] [money] NULL ,
	[消費税] [money] NULL ,
	[消費税率] [int] NULL ,
	[備考] [varchar] (255) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TGU運送費請求領収書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[文書内容CD] [int] NOT NULL ,
	[番号] [varchar] (20) NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[処理日] [datetime] NULL ,
	[運送日] [datetime] NULL ,
	[金額] [money] NULL ,
	[消費税] [money] NULL ,
	[消費税率] [int] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TKH小売販売M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[販売種類制限] [int] NULL ,
	[販売数量制限] [float] NULL ,
	[販売単価算出基準] [smallint] NULL ,
	[生徒数1] [int] NULL ,
	[掛け率上限1] [int] NULL ,
	[掛け率下限1] [int] NULL ,
	[生徒数2] [int] NULL ,
	[掛け率上限2] [int] NULL ,
	[掛け率下限2] [int] NULL ,
	[生徒数3] [int] NULL ,
	[掛け率上限3] [int] NULL ,
	[掛け率下限3] [int] NULL ,
	[生徒数4] [int] NULL ,
	[掛け率上限4] [int] NULL ,
	[掛け率下限4] [int] NULL ,
	[生徒数5] [int] NULL ,
	[掛け率上限5] [int] NULL ,
	[掛け率下限5] [int] NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [smallint] NULL ,
	[予備4] [int] NULL ,
	[予備5] [int] NULL ,
	[予備6] [smallint] NULL ,
	[更新日時] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TKH小売販売TRN] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[小売販売SEQ] [varchar] (2) NOT NULL ,
	[商品CD] [varchar] (20) NULL ,
	[商品名] [varchar] (80) NULL ,
	[商品略称] [varchar] (20) NULL ,
	[標準売価] [money] NULL ,
	[実販売単価] [money] NULL ,
	[仕入単価] [money] NULL ,
	[数量] [int] NULL ,
	[返品数量] [int] NULL ,
	[金額] [money] NULL ,
	[消費税率] [real] NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL ,
	[更新日時] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TKH小売販売TTL] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[客氏名] [varchar] (80) NULL ,
	[買上日] [datetime] NULL ,
	[摘要] [varchar] (100) NULL ,
	[学生番号] [varchar] (20) NULL ,
	[学生氏名] [varchar] (20) NULL ,
	[買上点数] [int] NULL ,
	[買上金額] [money] NULL ,
	[送料] [money] NULL ,
	[消費税] [money] NULL ,
	[合計金額] [money] NULL ,
	[買上票印刷フラグ] [smallint] NULL ,
	[領収書印刷フラグ] [smallint] NULL ,
	[出荷フラグ] [smallint] NULL ,
	[入出庫更新フラグ] [varchar] (10) NULL ,
	[削除フラグ] [smallint] NULL ,
	[寄託倉庫利用] [varchar] (2) NULL ,
	[返品文書内容CD] [varchar] (20) NULL ,
	[入出庫文書内容CD] [varchar] (20) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL ,
	[更新日時] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSA仕入売上書類F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[送受信区分] [varchar] (2) NULL ,
	[処理日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[先方文書種類CD] [varchar] (2) NULL ,
	[先方文書内容CD] [varchar] (20) NULL ,
	[先方処理日] [datetime] NULL ,
	[納入期日] [datetime] NULL ,
	[納入場所区分] [varchar] (1) NULL ,
	[運賃諸掛区分] [varchar] (1) NULL ,
	[運送会社CD] [varchar] (20) NULL ,
	[運送費] [money] NULL ,
	[運送費請求フラグ] [smallint] NULL ,
	[摘要] [varchar] (40) NULL ,
	[摘要2] [varchar] (40) NULL ,
	[支払方法] [varchar] (40) NULL ,
	[発行フラグ] [smallint] NULL ,
	[返信フラグ] [smallint] NULL ,
	[検認フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[学生番号] [varchar] (20) NULL ,
	[寄託会社CD] [varchar] (200) NULL ,
	[先方寄託会社CD] [varchar] (200) NULL ,
	[送信日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSA仕入売上書類明細F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[文書内容SEQ] [smallint] NOT NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[単価] [money] NULL ,
	[消費税率] [real] NULL ,
	[運送単価] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSA領収書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[送受信区分] [varchar] (2) NOT NULL ,
	[取引日] [datetime] NULL ,
	[発行人CD] [varchar] (20) NULL ,
	[受取人CD] [varchar] (20) NULL ,
	[金額] [money] NULL ,
	[摘要] [varchar] (80) NULL ,
	[発行フラグ] [smallint] NULL ,
	[開封フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSB銀行取引申込書類F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[送受信区分] [varchar] (2) NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[口座区分] [varchar] (1) NULL ,
	[口座番号] [varchar] (12) NULL ,
	[暗証番号] [varchar] (20) NULL ,
	[金額] [money] NULL ,
	[処理日] [datetime] NULL ,
	[受付区分] [varchar] (2) NULL ,
	[摘要] [varchar] (40) NULL ,
	[振込先銀行CD] [varchar] (20) NULL ,
	[振込先口座区分] [varchar] (12) NULL ,
	[振込先口座番号] [varchar] (12) NOT NULL ,
	[振込先会社CD] [varchar] (20) NULL ,
	[振込入金金額] [money] NULL ,
	[振込手数料] [money] NULL ,
	[振込元銀行CD] [varchar] (20) NULL ,
	[振込元口座区分] [varchar] (12) NULL ,
	[振込元口座番号] [varchar] (12) NULL ,
	[手形小切手出金銀行CD] [varchar] (20) NULL ,
	[手形小切手出金口座区分] [varchar] (12) NULL ,
	[手形小切手出金口座番号] [varchar] (12) NULL ,
	[手形小切手出金金額] [varchar] (20) NULL ,
	[手形作成会社CD] [varchar] (20) NULL ,
	[手形文書種類CD] [varchar] (2) NULL ,
	[手形文書内容CD] [varchar] (20) NULL ,
	[手形支払期日] [datetime] NULL ,
	[手形金額] [money] NULL ,
	[割引利率] [real] NULL ,
	[割引利率適用日数] [int] NULL ,
	[割引利息金額] [money] NULL ,
	[先方処理日] [datetime] NULL ,
	[先方文書種類CD] [varchar] (2) NULL ,
	[先方文書内容CD] [varchar] (20) NULL ,
	[先方摘要] [varchar] (40) NULL ,
	[発行フラグ] [smallint] NULL ,
	[返信フラグ] [smallint] NULL ,
	[入出金フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSC運送書類F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[送受信区分] [varchar] (2) NULL ,
	[処理日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[運送先CD] [varchar] (20) NULL ,
	[先方文書種類CD] [varchar] (2) NULL ,
	[先方文書内容CD] [varchar] (20) NULL ,
	[先方処理日] [datetime] NULL ,
	[納入期日] [datetime] NULL ,
	[納入場所区分] [varchar] (1) NULL ,
	[運賃諸掛区分] [varchar] (1) NULL ,
	[運送会社CD] [varchar] (20) NULL ,
	[運送費] [money] NULL ,
	[運送費請求フラグ] [smallint] NULL ,
	[摘要] [varchar] (40) NULL ,
	[支払方法] [varchar] (40) NULL ,
	[発行フラグ] [smallint] NULL ,
	[返信フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSC運送書類明細F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[文書内容SEQ] [smallint] NOT NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[単価] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSC運送費請求書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (12) NOT NULL ,
	[送受信区分] [varchar] (2) NULL ,
	[処理日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[納品請求書番号群] [varchar] (8000) NULL ,
	[支払方法] [varchar] (40) NULL ,
	[摘要] [varchar] (40) NULL ,
	[発行フラグ] [smallint] NULL ,
	[返信フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSC運送費請求書手動F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[送受信区分] [varchar] (2) NULL ,
	[処理日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[摘要] [varchar] (40) NULL ,
	[支払方法] [varchar] (40) NULL ,
	[発行フラグ] [smallint] NULL ,
	[返信フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSC運送費請求書手動明細F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[文書内容SEQ] [smallint] NOT NULL ,
	[運送日] [datetime] NULL ,
	[運送先CD] [varchar] (20) NULL ,
	[運送費] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK伝票F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[伝票区分] [varchar] (2) NOT NULL ,
	[伝票番号] [varchar] (16) NOT NULL ,
	[取引日] [datetime] NULL ,
	[伝票処理区分] [smallint] NULL ,
	[伝票摘要] [varchar] (40) NULL ,
	[作成日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[通常返品区分] [varchar] (1) NULL ,
	[学生番号] [varchar] (12) NULL ,
	[削除フラグ] [smallint] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK伝票仕入売上明細F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[伝票区分] [varchar] (2) NOT NULL ,
	[伝票番号] [varchar] (16) NOT NULL ,
	[仕入売上明細SEQ] [smallint] NOT NULL ,
	[商品CD] [varchar] (20) NULL ,
	[受注数量] [int] NULL ,
	[受注単価] [money] NULL ,
	[消費税率] [real] NULL ,
	[取引日] [datetime] NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK伝票明細F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[伝票区分] [varchar] (2) NOT NULL ,
	[伝票番号] [varchar] (16) NOT NULL ,
	[伝票SEQ] [smallint] NOT NULL ,
	[貸借区分] [varchar] (1) NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[相手勘定CD] [varchar] (25) NULL ,
	[摘要CD] [varchar] (20) NULL ,
	[摘要] [varchar] (100) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK帳簿_仕訳帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[伝票番号] [varchar] (12) NOT NULL ,
	[仕訳帳CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[摘要] [varchar] (50) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK帳簿_仕訳日記帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[仕訳日記帳CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[伝票] [varchar] (50) NULL ,
	[摘要] [varchar] (50) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK帳簿_仕訳集計表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[取引日] [datetime] NOT NULL ,
	[仕訳集計表CD] [int] NOT NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[元丁] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[摘要] [varchar] (100) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK帳簿_八桁精算表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[八桁精算表CD] [int] NOT NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[試算表借方金額] [money] NULL ,
	[試算表貸方金額] [money] NULL ,
	[整理記入借方金額] [money] NULL ,
	[整理記入貸方金額] [money] NULL ,
	[損益計算書借方金額] [money] NULL ,
	[損益計算書貸方金額] [money] NULL ,
	[貸借対照表借方金額] [money] NULL ,
	[貸借対照表貸方金額] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK帳簿_合計残高試算表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[合計残高試算表CD] [int] NOT NULL ,
	[取引日] [datetime] NOT NULL ,
	[借方残高] [money] NULL ,
	[借方金額] [money] NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[貸方金額] [money] NULL ,
	[貸方残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK帳簿_損益計算書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[損益計算書CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[借方勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方勘定CD] [varchar] (25) NULL ,
	[貸方金額] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK帳簿_株主資本等変動計算書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[株主資本等変動計算書CD] [int] NOT NULL ,
	[集計分類1] [varchar] (40) NULL ,
	[集計分類2] [varchar] (40) NULL ,
	[集計分類3] [varchar] (40) NULL ,
	[集計区分] [varchar] (1) NULL ,
	[変動額細目] [varchar] (40) NULL ,
	[加減区分] [varchar] (1) NULL ,
	[金額] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK帳簿_株主資本等変動計算書FM] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[株主資本等変動計算書CD] [int] NOT NULL ,
	[集計分類1] [varchar] (40) NULL ,
	[集計分類2] [varchar] (40) NULL ,
	[集計分類3] [varchar] (40) NULL ,
	[集計区分] [varchar] (1) NULL ,
	[変動額細目] [varchar] (40) NULL ,
	[加減区分] [varchar] (1) NULL ,
	[金額] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK帳簿_総勘定元帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[勘定CD] [varchar] (25) NOT NULL ,
	[総勘定元帳CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[仕丁] [varchar] (4) NULL ,
	[摘要CD] [varchar] (20) NULL ,
	[摘要] [varchar] (100) NULL ,
	[相手勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[貸借区分] [varchar] (2) NULL ,
	[残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK帳簿_貸借対照表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[貸借対照表CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[借方勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方勘定CD] [varchar] (25) NULL ,
	[貸方金額] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_仕入帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[仕入帳CD] [int] NOT NULL ,
	[摘要] [varchar] (40) NULL ,
	[取引日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[単価] [money] NULL ,
	[内訳金額] [money] NULL ,
	[金額] [money] NULL ,
	[返品区分] [varchar] (2) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_原価計算表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[製造指図書CD] [varchar] (20) NOT NULL ,
	[原価計算表CD] [int] NOT NULL ,
	[直接材料費日付] [datetime] NULL ,
	[直接材料費摘要] [varchar] (50) NULL ,
	[直接材料費] [money] NULL ,
	[直接労務費日付] [datetime] NULL ,
	[直接労務費摘要] [varchar] (50) NULL ,
	[直接労務費] [money] NULL ,
	[直接経費日付] [datetime] NULL ,
	[直接経費摘要] [varchar] (50) NULL ,
	[直接経費] [money] NULL ,
	[製造間接費日付] [datetime] NULL ,
	[製造間接費摘要] [varchar] (50) NULL ,
	[製造間接費] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_受取手形記入帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[受取手形記入帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[金額] [money] NULL ,
	[手形種類区分] [varchar] (2) NULL ,
	[手形番号] [varchar] (10) NULL ,
	[支払人] [varchar] (20) NULL ,
	[振出人または裏書人] [varchar] (20) NULL ,
	[振出日] [datetime] NULL ,
	[満期日] [datetime] NULL ,
	[支払場所] [varchar] (50) NULL ,
	[顛末日付] [datetime] NULL ,
	[顛末摘要] [varchar] (100) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_商品有高帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[商品CD] [varchar] (20) NOT NULL ,
	[商品有高帳CD] [int] NOT NULL ,
	[商品有高帳計算区分] [varchar] (2) NULL ,
	[取引日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[受払区分] [varchar] (2) NULL ,
	[受入数量] [int] NULL ,
	[受入単価] [money] NULL ,
	[受入金額] [money] NULL ,
	[払出数量] [int] NULL ,
	[払出単価] [money] NULL ,
	[払出金額] [money] NULL ,
	[残高数量] [int] NULL ,
	[残高単価] [money] NULL ,
	[残高金額] [money] NULL ,
	[単位] [varchar] (200) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_売上帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[売上帳CD] [int] NOT NULL ,
	[摘要] [varchar] (40) NULL ,
	[取引日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[単価] [money] NULL ,
	[内訳金額] [money] NULL ,
	[金額] [money] NULL ,
	[返品区分] [varchar] (2) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_売掛金元帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[取引先CD] [varchar] (20) NOT NULL ,
	[売掛金元帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[貸借区分] [varchar] (2) NULL ,
	[残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_小口現金出納帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[小口現金出納帳CD] [int] NOT NULL ,
	[受入] [money] NULL ,
	[取引日] [datetime] NULL ,
	[摘要] [varchar] (100) NULL ,
	[支払] [money] NULL ,
	[通信費] [money] NULL ,
	[交通費] [money] NULL ,
	[消耗品費] [money] NULL ,
	[水道光熱費] [money] NULL ,
	[その他] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_当座預金出納帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[銀行CD] [varchar] (20) NOT NULL ,
	[当座預金出納帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[小切手NO] [varchar] (10) NULL ,
	[預入金額] [money] NULL ,
	[払出金額] [money] NULL ,
	[貸借区分] [varchar] (2) NULL ,
	[残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_支払手形記入帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[支払手形記入帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[金額] [money] NULL ,
	[手形種類区分] [varchar] (2) NULL ,
	[手形番号] [varchar] (10) NULL ,
	[受取人] [varchar] (20) NULL ,
	[振出人] [varchar] (20) NULL ,
	[振出日] [datetime] NULL ,
	[満期日] [datetime] NULL ,
	[支払場所] [varchar] (50) NULL ,
	[顛末日付] [datetime] NULL ,
	[顛末摘要] [varchar] (100) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_材料仕入帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[材料仕入帳CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[摘要] [varchar] (40) NULL ,
	[素材] [money] NULL ,
	[買入部品] [money] NULL ,
	[工場消耗品] [money] NULL ,
	[元丁] [varchar] (4) NULL ,
	[買掛金] [money] NULL ,
	[諸口] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_材料元帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[材料CD] [varchar] (20) NOT NULL ,
	[材料元帳CD] [int] NOT NULL ,
	[材料元帳計算区分] [varchar] (2) NULL ,
	[取引日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[受払区分] [varchar] (2) NULL ,
	[受入数量] [int] NULL ,
	[受入単価] [money] NULL ,
	[受入金額] [money] NULL ,
	[払出数量] [int] NULL ,
	[払出単価] [money] NULL ,
	[払出金額] [money] NULL ,
	[残高数量] [int] NULL ,
	[残高単価] [money] NULL ,
	[残高金額] [money] NULL ,
	[単位] [varchar] (200) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_現金出納帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[現金出納帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[収入金額] [money] NULL ,
	[支出金額] [money] NULL ,
	[残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_製造間接費配賦表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[製造間接費配賦表CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[製造指図書] [varchar] (20) NULL ,
	[配賦率] [money] NULL ,
	[配賦基準] [money] NULL ,
	[配賦額] [money] NULL ,
	[摘要] [varchar] (40) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TSK補助簿_買掛金元帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[取引先CD] [varchar] (20) NOT NULL ,
	[買掛金元帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[貸借区分] [varchar] (2) NULL ,
	[残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTA損益計画F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[資本金] [money] NULL ,
	[資本金純利益率] [real] NULL ,
	[課税率] [real] NULL ,
	[固定費] [money] NULL ,
	[売上高総利益率] [money] NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTA社員台帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[社員番号] [int] NOT NULL ,
	[支給年月] [varchar] (20) NOT NULL ,
	[氏名] [varchar] (20) NULL ,
	[生年月日] [datetime] NULL ,
	[扶養家族人数] [smallint] NULL ,
	[役職] [varchar] (20) NULL ,
	[基本給] [money] NULL ,
	[時間外手当] [money] NULL ,
	[職務手当] [money] NULL ,
	[住宅手当] [money] NULL ,
	[精勤手当] [money] NULL ,
	[皆勤手当] [money] NULL ,
	[その他手当] [money] NULL ,
	[通勤手当] [money] NULL ,
	[健康保険] [money] NULL ,
	[厚生年金] [money] NULL ,
	[年金基金] [money] NULL ,
	[雇用保険] [money] NULL ,
	[所得税] [money] NULL ,
	[住民税] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTA社員台帳M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[社員番号] [int] NOT NULL ,
	[社員番号ラベル] [varchar] (50) NULL ,
	[氏名] [varchar] (20) NULL ,
	[郵便番号] [varchar] (8) NULL ,
	[住所] [varchar] (50) NULL ,
	[電話番号] [varchar] (15) NULL ,
	[ケータイ] [varchar] (15) NULL ,
	[生年月日] [datetime] NULL ,
	[扶養家族人数] [smallint] NULL ,
	[入社年月日] [datetime] NULL ,
	[離職年月日] [datetime] NULL ,
	[役職] [varchar] (20) NULL ,
	[基本給] [money] NULL ,
	[職務手当] [money] NULL ,
	[家族手当] [money] NULL ,
	[住宅手当] [money] NULL ,
	[精勤手当] [money] NULL ,
	[皆勤手当] [money] NULL ,
	[通勤手当] [money] NULL ,
	[健康保険] [money] NULL ,
	[厚生年金] [money] NULL ,
	[年金基金] [money] NULL ,
	[雇用保険] [money] NULL ,
	[介護保険] [money] NULL ,
	[代表取締役フラグ] [varchar] (2) NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTA給与明細F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[社員番号] [int] NOT NULL ,
	[給与明細CD] [int] NOT NULL ,
	[支給区分] [varchar] (2) NULL ,
	[支給年月日] [datetime] NULL ,
	[基本給] [money] NULL ,
	[時間外時間] [money] NULL ,
	[時間外手当] [money] NULL ,
	[職務手当] [money] NULL ,
	[家族手当] [money] NULL ,
	[住宅手当] [money] NULL ,
	[精勤手当] [money] NULL ,
	[皆勤手当] [money] NULL ,
	[その他手当] [money] NULL ,
	[通勤手当] [money] NULL ,
	[保険対象額] [money] NULL ,
	[健康保険] [money] NULL ,
	[厚生年金] [money] NULL ,
	[年金基金] [money] NULL ,
	[雇用保険] [money] NULL ,
	[介護保険] [money] NULL ,
	[所得控除額] [money] NULL ,
	[課税対象額] [money] NULL ,
	[所得税] [money] NULL ,
	[住民税] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTK摘要M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[摘要CD] [varchar] (12) NOT NULL ,
	[摘要] [varchar] (40) NULL ,
	[関連会社CD] [varchar] (20) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTK記帳チェック2F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[チェック区分] [varchar] (4) NOT NULL ,
	[チェック種類] [varchar] (4) NOT NULL ,
	[伝票借方] [money] NULL ,
	[伝票貸方] [money] NULL ,
	[伝票残高] [money] NULL ,
	[元帳借方] [money] NULL ,
	[元帳貸方] [money] NULL ,
	[元帳残高] [money] NULL ,
	[補助簿借方] [money] NULL ,
	[補助簿貸方] [money] NULL ,
	[補助簿残高] [money] NULL ,
	[現物借方] [money] NULL ,
	[現物貸方] [money] NULL ,
	[現物残高] [money] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTK記帳チェックF] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[チェック区分] [varchar] (4) NOT NULL ,
	[チェック種類] [varchar] (4) NOT NULL ,
	[伝票借方] [money] NULL ,
	[伝票貸方] [money] NULL ,
	[伝票残高] [money] NULL ,
	[元帳借方] [money] NULL ,
	[元帳貸方] [money] NULL ,
	[元帳残高] [money] NULL ,
	[補助簿借方] [money] NULL ,
	[補助簿貸方] [money] NULL ,
	[補助簿残高] [money] NULL ,
	[現物借方] [money] NULL ,
	[現物貸方] [money] NULL ,
	[現物残高] [money] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTL合併残高F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[学生番号] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[会社区分] [smallint] NOT NULL ,
	[勘定CD] [varchar] (25) NOT NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[WEB演習CD] [varchar] (12) NULL ,
	[WEB会社CD] [varchar] (20) NULL ,
	[WEB学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTM名刺データ2F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[学生番号] [varchar] (12) NOT NULL ,
	[名刺データ] [varchar] (7000) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTM名刺データF] (
	[システムCD] [varchar] (12) NULL ,
	[演習CD] [varchar] (12) NULL ,
	[会社CD] [varchar] (20) NULL ,
	[学生番号] [varchar] (50) NULL ,
	[名刺デザインCD] [varchar] (12) NULL ,
	[会社名称] [varchar] (50) NULL ,
	[肩書] [varchar] (50) NULL ,
	[氏名] [varchar] (50) NULL ,
	[郵便番号] [varchar] (50) NULL ,
	[住所1] [varchar] (50) NULL ,
	[住所2] [varchar] (50) NULL ,
	[電話番号] [varchar] (50) NULL ,
	[メールアドレス] [varchar] (50) NULL ,
	[画像ファイル] [varchar] (250) NULL ,
	[役職] [varchar] (200) NULL ,
	[FAX] [varchar] (200) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTXFAXF] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[FAXCD] [int] NOT NULL ,
	[送受信区分] [varchar] (2) NULL ,
	[宛先CD] [varchar] (2000) NULL ,
	[作成日] [datetime] NULL ,
	[件名] [varchar] (50) NULL ,
	[送付状] [varchar] (1000) NULL ,
	[拡張子] [varchar] (12) NULL ,
	[開封フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[学生番号] [varchar] (20) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTXメールF] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[メールCD] [int] NOT NULL ,
	[送受信区分] [varchar] (2) NULL ,
	[作成日] [datetime] NULL ,
	[作成会社CD] [varchar] (20) NULL ,
	[送信元メールCD] [int] NULL ,
	[表示用宛先CD] [varchar] (2000) NULL ,
	[件名] [varchar] (50) NULL ,
	[内容] [varchar] (1000) NULL ,
	[添付ファイル] [varchar] (255) NULL ,
	[送信フラグ] [smallint] NULL ,
	[開封フラグ] [smallint] NULL ,
	[学生番号] [varchar] (20) NULL ,
	[削除フラグ] [smallint] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTX文書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[送受信区分] [varchar] (2) NOT NULL ,
	[文書CD] [int] NOT NULL ,
	[処理日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[作成会社CD] [varchar] (20) NULL ,
	[文書種類CD] [varchar] (2) NULL ,
	[文書内容CD] [varchar] (20) NULL ,
	[開封フラグ] [smallint] NULL ,
	[削除フラグ] [smallint] NULL ,
	[学生番号] [varchar] (20) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TC4演習許可学生M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[学生番号] [varchar] (12) NOT NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TC4演習許可学生グループM] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[学生グループCD] [varchar] (12) NOT NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TC5学生M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[学生番号] [varchar] (12) NOT NULL ,
	[氏名] [varchar] (30) NULL ,
	[氏名略名称] [varchar] (8) NULL ,
	[パスワード] [varchar] (12) NULL ,
	[演習CD] [varchar] (12) NULL ,
	[学生グループCD] [varchar] (12) NULL ,
	[最新ログイン日] [datetime] NULL ,
	[更新時の戻り先] [varchar] (1000) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TDA報告書書式M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[帳票区分] [varchar] (1) NOT NULL ,
	[集計CD] [varchar] (4) NOT NULL ,
	[集計名称] [varchar] (40) NULL ,
	[貸借] [varchar] (2) NULL ,
	[集計先] [varchar] (4) NULL ,
	[加減区分] [varchar] (1) NULL ,
	[ラインコントロール] [varchar] (1) NULL ,
	[アンダーライン] [varchar] (1) NULL ,
	[右方表示] [varchar] (1) NULL ,
	[構成表示] [varchar] (1) NULL ,
	[作成区分] [smallint] NULL ,
	[更新プログラムID] [varchar] (30) NULL ,
	[更新日時] [datetime] NULL ,
	[表示順] [int] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TDA株主資本等変動計算書書式M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[集計CD] [varchar] (4) NOT NULL ,
	[集計分類1] [varchar] (40) NULL ,
	[集計分類2] [varchar] (40) NULL ,
	[集計分類3] [varchar] (40) NULL ,
	[集計区分] [varchar] (40) NULL ,
	[変動額細目] [varchar] (40) NULL ,
	[集計先] [varchar] (4) NULL ,
	[加減区分] [varchar] (1) NULL ,
	[ラインコントロール] [varchar] (1) NULL ,
	[アンダーライン] [varchar] (1) NULL ,
	[表示順] [int] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TDA経費労務費M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[製造区分] [varchar] (2) NOT NULL ,
	[製品CD] [varchar] (20) NOT NULL ,
	[経費労務費区分] [varchar] (2) NOT NULL ,
	[経費労務費CD] [int] NOT NULL ,
	[摘要] [varchar] (255) NULL ,
	[金額] [money] NOT NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TDA部品展開M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[製造区分] [varchar] (2) NOT NULL ,
	[製品CD] [varchar] (20) NOT NULL ,
	[部品展開Seq] [int] NOT NULL ,
	[材料区分] [varchar] (2) NOT NULL ,
	[材料CD] [varchar] (20) NOT NULL ,
	[材料数量] [money] NULL ,
	[更新日時] [datetime] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TGA入出庫明細TRN] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[文書種類CD] [varchar] (2) NOT NULL ,
	[文書内容CD] [varchar] (20) NOT NULL ,
	[入出庫SEQ] [smallint] NOT NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[単価] [money] NULL ,
	[元単価] [money] NULL ,
	[運送単価] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TGB銀行口座入出金TRN] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[銀行CD] [varchar] (20) NOT NULL ,
	[口座区分] [varchar] (1) NOT NULL ,
	[口座番号] [varchar] (20) NOT NULL ,
	[入出金CD] [varchar] (12) NOT NULL ,
	[処理時期区分] [smallint] NULL ,
	[処理日] [datetime] NULL ,
	[金額] [money] NULL ,
	[銀行取引区分] [varchar] (2) NULL ,
	[摘要] [varchar] (40) NULL ,
	[学生番号] [varchar] (12) NULL ,
	[結果通知銀行CD] [varchar] (20) NULL ,
	[結果通知種類CD] [varchar] (2) NULL ,
	[結果通知内容CD] [varchar] (20) NULL ,
	[既読フラグ] [varchar] (2) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TGC寄託在庫明細F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[作成会社CD] [varchar] (20) NOT NULL ,
	[寄託依頼会社CD] [varchar] (20) NOT NULL ,
	[寄託受付番号] [smallint] NOT NULL ,
	[寄託受付番号SEQ] [smallint] NOT NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[仕入単価] [money] NULL ,
	[運送単価] [money] NULL ,
	[総出庫数] [int] NULL ,
	[摘要] [varchar] (40) NULL ,
	[火災保険料金] [money] NULL ,
	[火災保険料率] [real] NULL ,
	[荷役料金] [money] NULL ,
	[荷役料率] [real] NULL ,
	[従量率] [real] NULL ,
	[従価率] [real] NULL ,
	[保管料金] [money] NULL ,
	[倉荷証券番号] [varchar] (20) NULL ,
	[倉荷証券発行手数料] [money] NULL ,
	[倉荷証券発行フラグ] [smallint] NULL ,
	[倉荷証券請求フラグ] [smallint] NULL ,
	[倉荷証券回収フラグ] [smallint] NULL ,
	[倉荷証券回収日] [datetime] NULL ,
	[学生番号] [varchar] (20) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK伝票仕入売上明細F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[伝票区分] [varchar] (2) NOT NULL ,
	[伝票番号] [varchar] (12) NOT NULL ,
	[仕入売上明細SEQ] [smallint] NOT NULL ,
	[商品CD] [varchar] (20) NULL ,
	[受注数量] [int] NULL ,
	[受注単価] [money] NULL ,
	[消費税率] [real] NULL ,
	[取引日] [datetime] NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK伝票明細F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[伝票区分] [varchar] (2) NOT NULL ,
	[伝票番号] [varchar] (12) NOT NULL ,
	[伝票SEQ] [smallint] NOT NULL ,
	[貸借区分] [varchar] (1) NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[相手勘定CD] [varchar] (25) NULL ,
	[摘要CD] [varchar] (20) NULL ,
	[摘要] [varchar] (40) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK帳簿_仕訳帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[伝票番号] [varchar] (12) NOT NULL ,
	[仕訳帳CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[摘要] [varchar] (50) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK帳簿_仕訳日記帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[仕訳日記帳CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[伝票] [varchar] (50) NULL ,
	[摘要] [varchar] (50) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK帳簿_仕訳集計表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[取引日] [datetime] NOT NULL ,
	[仕訳集計表CD] [int] NOT NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[元丁] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[摘要] [varchar] (100) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK帳簿_八桁精算表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[八桁精算表CD] [int] NOT NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[試算表借方金額] [money] NULL ,
	[試算表貸方金額] [money] NULL ,
	[整理記入借方金額] [money] NULL ,
	[整理記入貸方金額] [money] NULL ,
	[損益計算書借方金額] [money] NULL ,
	[損益計算書貸方金額] [money] NULL ,
	[貸借対照表借方金額] [money] NULL ,
	[貸借対照表貸方金額] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK帳簿_合計残高試算表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[合計残高試算表CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[借方残高] [money] NULL ,
	[借方金額] [money] NULL ,
	[勘定CD] [varchar] (25) NULL ,
	[貸方金額] [money] NULL ,
	[貸方残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK帳簿_損益計算書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[損益計算書CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[借方勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方勘定CD] [varchar] (25) NULL ,
	[貸方金額] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK帳簿_株主資本等変動計算書F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[株主資本等変動計算書CD] [int] NOT NULL ,
	[集計分類1] [varchar] (40) NULL ,
	[集計分類2] [varchar] (40) NULL ,
	[集計分類3] [varchar] (40) NULL ,
	[集計区分] [varchar] (1) NULL ,
	[変動額細目] [varchar] (40) NULL ,
	[加減区分] [varchar] (1) NULL ,
	[金額] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK帳簿_総勘定元帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[勘定CD] [varchar] (25) NOT NULL ,
	[総勘定元帳CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[仕丁] [varchar] (4) NULL ,
	[摘要CD] [varchar] (20) NULL ,
	[摘要] [varchar] (100) NULL ,
	[相手勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[貸借区分] [varchar] (2) NULL ,
	[残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK帳簿_貸借対照表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[貸借対照表CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[借方勘定CD] [varchar] (25) NULL ,
	[借方金額] [money] NULL ,
	[貸方勘定CD] [varchar] (25) NULL ,
	[貸方金額] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_仕入帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[仕入帳CD] [int] NOT NULL ,
	[摘要] [varchar] (40) NULL ,
	[取引日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[単価] [money] NULL ,
	[内訳金額] [money] NULL ,
	[金額] [money] NULL ,
	[返品区分] [varchar] (2) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_原価計算表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[製造指図書CD] [varchar] (20) NOT NULL ,
	[原価計算表CD] [int] NOT NULL ,
	[直接材料費日付] [datetime] NULL ,
	[直接材料費摘要] [varchar] (50) NULL ,
	[直接材料費] [money] NULL ,
	[直接労務費日付] [datetime] NULL ,
	[直接労務費摘要] [varchar] (50) NULL ,
	[直接労務費] [money] NULL ,
	[直接経費日付] [datetime] NULL ,
	[直接経費摘要] [varchar] (50) NULL ,
	[直接経費] [money] NULL ,
	[製造間接費日付] [datetime] NULL ,
	[製造間接費摘要] [varchar] (50) NULL ,
	[製造間接費] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_受取手形記入帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[受取手形記入帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[金額] [money] NULL ,
	[手形種類区分] [varchar] (2) NULL ,
	[手形番号] [varchar] (10) NULL ,
	[支払人] [varchar] (20) NULL ,
	[振出人または裏書人] [varchar] (20) NULL ,
	[振出日] [datetime] NULL ,
	[満期日] [datetime] NULL ,
	[支払場所] [varchar] (50) NULL ,
	[顛末日付] [datetime] NULL ,
	[顛末摘要] [varchar] (100) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_商品有高帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[商品CD] [varchar] (20) NOT NULL ,
	[商品有高帳CD] [int] NOT NULL ,
	[商品有高帳計算区分] [varchar] (2) NULL ,
	[取引日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[受払区分] [varchar] (2) NULL ,
	[受入数量] [int] NULL ,
	[受入単価] [money] NULL ,
	[受入金額] [money] NULL ,
	[払出数量] [int] NULL ,
	[払出単価] [money] NULL ,
	[払出金額] [money] NULL ,
	[残高数量] [int] NULL ,
	[残高単価] [money] NULL ,
	[残高金額] [money] NULL ,
	[単位] [varchar] (200) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_売上帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[売上帳CD] [int] NOT NULL ,
	[摘要] [varchar] (40) NULL ,
	[取引日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[商品CD] [varchar] (20) NULL ,
	[数量] [int] NULL ,
	[単価] [money] NULL ,
	[内訳金額] [money] NULL ,
	[金額] [money] NULL ,
	[返品区分] [varchar] (2) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_売掛金元帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[取引先CD] [varchar] (20) NOT NULL ,
	[売掛金元帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[貸借区分] [varchar] (2) NULL ,
	[残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_小口現金出納帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[小口現金出納帳CD] [int] NOT NULL ,
	[受入] [money] NULL ,
	[取引日] [datetime] NULL ,
	[摘要] [varchar] (100) NULL ,
	[支払] [money] NULL ,
	[通信費] [money] NULL ,
	[交通費] [money] NULL ,
	[消耗品費] [money] NULL ,
	[水道光熱費] [money] NULL ,
	[その他] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_当座預金出納帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[銀行CD] [varchar] (20) NOT NULL ,
	[当座預金出納帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[小切手NO] [varchar] (10) NULL ,
	[預入金額] [money] NULL ,
	[払出金額] [money] NULL ,
	[貸借区分] [varchar] (2) NULL ,
	[残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_支払手形記入帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[支払手形記入帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[金額] [money] NULL ,
	[手形種類区分] [varchar] (2) NULL ,
	[手形番号] [varchar] (10) NULL ,
	[受取人] [varchar] (20) NULL ,
	[振出人] [varchar] (20) NULL ,
	[振出日] [datetime] NULL ,
	[満期日] [datetime] NULL ,
	[支払場所] [varchar] (50) NULL ,
	[顛末日付] [datetime] NULL ,
	[顛末摘要] [varchar] (100) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_材料仕入帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[材料仕入帳CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[摘要] [varchar] (40) NULL ,
	[素材] [money] NULL ,
	[買入部品] [money] NULL ,
	[工場消耗品] [money] NULL ,
	[元丁] [varchar] (4) NULL ,
	[買掛金] [money] NULL ,
	[諸口] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_材料元帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[材料CD] [varchar] (20) NOT NULL ,
	[材料元帳CD] [int] NOT NULL ,
	[材料元帳計算区分] [varchar] (2) NULL ,
	[取引日] [datetime] NULL ,
	[取引先CD] [varchar] (20) NULL ,
	[受払区分] [varchar] (2) NULL ,
	[受入数量] [int] NULL ,
	[受入単価] [money] NULL ,
	[受入金額] [money] NULL ,
	[払出数量] [int] NULL ,
	[払出単価] [money] NULL ,
	[払出金額] [money] NULL ,
	[残高数量] [int] NULL ,
	[残高単価] [money] NULL ,
	[残高金額] [money] NULL ,
	[単位] [varchar] (200) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_現金出納帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[現金出納帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[収入金額] [money] NULL ,
	[支出金額] [money] NULL ,
	[残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_製造間接費配賦表F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[製造間接費配賦表CD] [int] NOT NULL ,
	[取引日] [datetime] NULL ,
	[製造指図書] [varchar] (20) NULL ,
	[配賦率] [money] NULL ,
	[配賦基準] [money] NULL ,
	[配賦額] [money] NULL ,
	[摘要] [varchar] (40) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TSK補助簿_買掛金元帳F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[取引先CD] [varchar] (20) NOT NULL ,
	[買掛金元帳CD] [int] NOT NULL ,
	[摘要] [varchar] (100) NULL ,
	[取引日] [datetime] NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[貸借区分] [varchar] (2) NULL ,
	[残高] [money] NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[YTMP_TTL合併残高F] (
	[システムCD] [varchar] (12) NOT NULL ,
	[学生番号] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[会社区分] [smallint] NOT NULL ,
	[勘定CD] [varchar] (25) NOT NULL ,
	[借方金額] [money] NULL ,
	[貸方金額] [money] NULL ,
	[WEB演習CD] [varchar] (12) NULL ,
	[WEB会社CD] [varchar] (20) NULL ,
	[WEB学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TC0ウェイトフラグ] ADD 
	CONSTRAINT [PK_TTK記帳チェックFLUG] PRIMARY KEY  CLUSTERED 
	(
		[システムCD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TC1システムM] ADD 
	CONSTRAINT [PK_TC1システムM] PRIMARY KEY  CLUSTERED 
	(
		[システムCD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TC2演習M] ADD 
	CONSTRAINT [PK_TC2演習M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TC3学生グループM] ADD 
	CONSTRAINT [PK_TC3学生グループM] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[学生グループCD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TC4演習許可学生M] ADD 
	CONSTRAINT [PK_TC4演習許可学生M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[学生番号]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TC4演習許可学生グループM] ADD 
	CONSTRAINT [PK_TC4演習許可学生グループM] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[学生グループCD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TC5学生M] ADD 
	CONSTRAINT [PK_TC5学生M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[学生番号]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TC6演習履歴M] ADD 
	CONSTRAINT [PK_TC6演習履歴M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[学生番号],
		[選択会社CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TC9元号M] ADD 
	CONSTRAINT [PK_TC9元号M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[元号CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TC9区分M] ADD 
	CONSTRAINT [PK_TC9区分M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[データ識別],
		[区分CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TC9名刺デザインM] ADD 
	CONSTRAINT [PK_TC9名刺デザインM] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[名刺デザインCD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TC9文書種類M] ADD 
	CONSTRAINT [PK_TC9文書種類M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[文書種類CD],
		[自動フラグ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA会社M] ADD 
	CONSTRAINT [PK_TDA会社M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA勘定科目M] ADD 
	CONSTRAINT [PK_TDA勘定科目M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[勘定CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA勘定科目会社学生M] ADD 
	CONSTRAINT [PK_TDA勘定科目学生M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[所有会社CD],
		[勘定CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA商品M] ADD 
	CONSTRAINT [PK_TDA商品M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[商品CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA報告書書式M] ADD 
	CONSTRAINT [PK_TDA報告書書式M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[帳票区分],
		[集計CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA市場M] ADD 
	CONSTRAINT [PK_TDA市場M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[市場CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA材料M] ADD 
	CONSTRAINT [PK_TDA材料M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[材料CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA株主資本等変動計算書書式M] ADD 
	CONSTRAINT [PK_TDA株主資本等変動計算書書式M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[集計CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA消費税率M] ADD 
	CONSTRAINT [PK_TDA消費税率M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[消費税率]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA為替レートM] ADD 
	CONSTRAINT [PK_TDA為替レートM] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[通貨CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA経費労務費M] ADD 
	CONSTRAINT [PK_TDA経費労務費M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[製造区分],
		[製品CD],
		[経費労務費区分],
		[経費労務費CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA表記名称M] ADD 
	CONSTRAINT [PK_TDA名称表記M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[表記CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TDA部品展開M] ADD 
	CONSTRAINT [PK_TDA部品展開M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[製造区分],
		[製品CD],
		[部品展開Seq],
		[材料区分],
		[材料CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGA入出庫TRN] ADD 
	CONSTRAINT [PK_TGA入出庫TRN] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGA入出庫明細TRN] ADD 
	CONSTRAINT [PK_TGA入出庫明細TRN] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD],
		[入出庫SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGA契約書F] ADD 
	CONSTRAINT [PK_TGA契約書F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[文書種類CD],
		[文書内容CD],
		[作成会社CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGA手形F] ADD 
	CONSTRAINT [PK_TGA手形F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGA手形明細F] ADD 
	CONSTRAINT [PK_TGA手形明細F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD],
		[文書内容SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGB銀行口座F] ADD 
	CONSTRAINT [PK_TGB銀行口座F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[銀行CD],
		[口座区分],
		[口座番号]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGB銀行口座入出金TRN] ADD 
	CONSTRAINT [PK_TGB銀行口座入出金TRN] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[銀行CD],
		[口座区分],
		[口座番号],
		[入出金CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGC保険契約F] ADD 
	CONSTRAINT [PK_TGC保険契約F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[申込番号]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGC出庫F] ADD 
	CONSTRAINT [PK_TGC出庫F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[出庫番号]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGC寄託在庫F] ADD 
	CONSTRAINT [PK_TGC寄託在庫F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[寄託依頼会社CD],
		[寄託受付番号]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGC寄託在庫明細F] ADD 
	CONSTRAINT [PK_TGC寄託在庫明細F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[寄託依頼会社CD],
		[寄託受付番号],
		[寄託受付番号SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGC寄託者TRN] ADD 
	CONSTRAINT [PK_TGC寄託者TRN] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGC寄託者台帳F] ADD 
	CONSTRAINT [PK_TGC寄託者台帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[寄託受付番号]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGC寄託者明細TRN] ADD 
	CONSTRAINT [PK_TGC寄託者明細TRN] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD],
		[入出庫SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGC運送契約F] ADD 
	CONSTRAINT [PK_TGC運送契約F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[申込番号]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGD製造指図書F] ADD 
	CONSTRAINT [PK_TGD製造指図書F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[文書内容CD],
		[製造状況区分]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGK現金入出金TRN] ADD 
	CONSTRAINT [PK_TGK現金入出金TRN] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[現金入出金CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGPポータル会社F] ADD 
	CONSTRAINT [PK_TGPポータル会社F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGPポータル商品F] ADD 
	CONSTRAINT [PK_TGPポータル商品F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[商品棚CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGU保険請求領収書F] ADD 
	CONSTRAINT [PK_TGU保険請求領収書F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[保険種別],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGU倉庫料請求領収書F] ADD 
	CONSTRAINT [PK_TGU倉庫料請求領収書F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TGU運送費請求領収書F] ADD 
	CONSTRAINT [PK_TGU運送費請求領収書F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TKH小売販売M] ADD 
	CONSTRAINT [PK_TKH小売販売M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TKH小売販売TRN] ADD 
	CONSTRAINT [PK_TKH小売販売TRN] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD],
		[小売販売SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TKH小売販売TTL] ADD 
	CONSTRAINT [PK_TKH小売販売TTL] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSA仕入売上書類F] ADD 
	CONSTRAINT [PK_TSA仕入売上書類F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSA仕入売上書類明細F] ADD 
	CONSTRAINT [PK_TSA仕入売上書類明細F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD],
		[文書内容SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSA領収書F] ADD 
	CONSTRAINT [PK_TSA領収書F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD],
		[送受信区分]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSB銀行取引申込書類F] ADD 
	CONSTRAINT [PK_TSB銀行取引申込書類F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSC運送書類F] ADD 
	CONSTRAINT [PK_TSC運送書類F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSC運送書類明細F] ADD 
	CONSTRAINT [PK_TSC運送書類明細F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD],
		[文書内容SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSC運送費請求書F] ADD 
	CONSTRAINT [PK_TSC運送費請求書F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSC運送費請求書手動F] ADD 
	CONSTRAINT [PK_TSC運送費請求書手動F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSC運送費請求書手動明細F] ADD 
	CONSTRAINT [PK_TSC運送費請求書手動明細F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[作成会社CD],
		[文書種類CD],
		[文書内容CD],
		[文書内容SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK伝票F] ADD 
	CONSTRAINT [PK_TSK伝票F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[伝票区分],
		[伝票番号]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK伝票仕入売上明細F] ADD 
	CONSTRAINT [PK_TSK伝票仕入売上明細F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[伝票区分],
		[伝票番号],
		[仕入売上明細SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK伝票明細F] ADD 
	CONSTRAINT [PK_TSK伝票明細F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[伝票区分],
		[伝票番号],
		[伝票SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK帳簿_仕訳帳F] ADD 
	CONSTRAINT [PK_TSK帳簿_仕訳帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[伝票番号],
		[仕訳帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK帳簿_仕訳日記帳F] ADD 
	CONSTRAINT [PK_TSK帳簿_仕訳日記帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[仕訳日記帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK帳簿_仕訳集計表F] ADD 
	CONSTRAINT [PK_TSK帳簿_仕訳集計表F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[取引日],
		[仕訳集計表CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK帳簿_八桁精算表F] ADD 
	CONSTRAINT [PK_TSK帳簿_八桁精算表F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[八桁精算表CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK帳簿_合計残高試算表F] ADD 
	CONSTRAINT [PK_TSK帳簿_合計残高試算表F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[合計残高試算表CD],
		[取引日]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK帳簿_損益計算書F] ADD 
	CONSTRAINT [PK_TSK帳簿_損益計算書F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[損益計算書CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK帳簿_株主資本等変動計算書F] ADD 
	CONSTRAINT [PK_TSK帳簿_株主資本等変動計算書F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[株主資本等変動計算書CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK帳簿_株主資本等変動計算書FM] ADD 
	CONSTRAINT [PK_TSK帳簿_株主資本等変動計算書FM] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[株主資本等変動計算書CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK帳簿_総勘定元帳F] ADD 
	CONSTRAINT [PK_TSK帳簿_総勘定元帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[勘定CD],
		[総勘定元帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK帳簿_貸借対照表F] ADD 
	CONSTRAINT [PK_TSK帳簿_貸借対照表F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[貸借対照表CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_仕入帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_仕入帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[仕入帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_原価計算表F] ADD 
	CONSTRAINT [PK_TSK補助簿_原価計算表F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[製造指図書CD],
		[原価計算表CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_受取手形記入帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_受取手形記入帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[受取手形記入帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_商品有高帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_商品有高帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[商品CD],
		[商品有高帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_売上帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_売上帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[売上帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_売掛金元帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_売掛金元帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[取引先CD],
		[売掛金元帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_小口現金出納帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_小口現金出納帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[小口現金出納帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_当座預金出納帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_当座預金出納帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[銀行CD],
		[当座預金出納帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_支払手形記入帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_支払手形記入帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[支払手形記入帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_材料仕入帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_材料仕入帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[材料仕入帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_材料元帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_材料元帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[材料CD],
		[材料元帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_現金出納帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_現金出納帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[現金出納帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_製造間接費配賦表F] ADD 
	CONSTRAINT [PK_TSK補助簿_製造間接費配賦表F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[製造間接費配賦表CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TSK補助簿_買掛金元帳F] ADD 
	CONSTRAINT [PK_TSK補助簿_買掛金元帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[取引先CD],
		[買掛金元帳CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTA損益計画F] ADD 
	CONSTRAINT [PK_TTA損益計画F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTA社員台帳F] ADD 
	CONSTRAINT [PK_TTA社員台帳F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[社員番号],
		[支給年月]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTA社員台帳M] ADD 
	CONSTRAINT [PK_TTA社員台帳M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[社員番号]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTA給与明細F] ADD 
	CONSTRAINT [PK_TTA給与明細F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[社員番号],
		[給与明細CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTK摘要M] ADD 
	CONSTRAINT [PK_TTK摘要M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[摘要CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTK記帳チェック2F] ADD 
	CONSTRAINT [PK_TTK記帳チェック2F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[チェック種類],
		[チェック区分]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTK記帳チェックF] ADD 
	CONSTRAINT [PK_TTK記帳チェックF] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[チェック種類],
		[チェック区分]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTL合併残高F] ADD 
	CONSTRAINT [PK_TTL合併残高F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[学生番号],
		[演習CD],
		[会社CD],
		[会社区分],
		[勘定CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTM名刺データ2F] ADD 
	CONSTRAINT [PK_TTM名刺データ2F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[学生番号]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTXFAXF] ADD 
	CONSTRAINT [PK_TTXFAXF] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[FAXCD],
		[作成会社CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTXメールF] ADD 
	CONSTRAINT [PK_TTXメールF] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[メールCD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTX文書F] ADD 
	CONSTRAINT [PK_TTX文書F] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[送受信区分],
		[文書CD]
	)  ON [PRIMARY] 
GO