CREATE TABLE

--CREATE TABLE GENSHINHIKAKU_TEST."TMP_GEN_NEW_COMP＿CARD_KMTN_SEISAN_KAKUTEI_ATLAS_RENKEI_DATA" (

"recordSikibetuSign" VARCHAR(1) NOT NULL,

"memNo" VARCHAR(12) NOT NULL,

"uriNo" CHAR(12) NOT NULL,

"hansokuhiSeq" CHAR(1) NOT NULL,

"shrShubetuCd" CHAR(2) NOT NULL,

"processDay" CHAR(8) NOT NULL,

"processTime" CHAR(8) NOT NULL,

"moveShubetuCd" CHAR(2) NOT NULL,

"recordKbn" VARCHAR(1) NOT NULL,

"sTatekaekinShrsakiKmtnNo" CHAR(8) NOT NULL,

"sTatekaekinShrsakiSeq" CHAR(2) NOT NULL,

"sShrsakiAddressCd" CHAR(7) NOT NULL,

"sShrsakiBankCd" CHAR(4) NOT NULL,

"sShrsakiBankHonsitenNo" CHAR(3) NOT NULL,

"sSiryoCreateDay" CHAR(8) NOT NULL,

"sShrDay" CHAR(8) NOT NULL,

"sTegataShrDay" CHAR(8) NOT NULL,

"shrSign" CHAR(2) NOT NULL,

"shrGakuSumKbn" CHAR(2) NOT NULL,

"simekiriDate" CHAR(8) NOT NULL,

"shrSumStartDate" CHAR(8) NOT NULL,

"shrSumEndDate" CHAR(8) NOT NULL,

"dealKind" CHAR(1) NOT NULL,

"dealKindSubCd" CHAR(1) NOT NULL,

"inputReason" CHAR(2) NOT NULL,

"shrDaySiteiInputSign" CHAR(1) NOT NULL,

"ryorituSettingUpperGaku" DECIMAL(13) NOT NULL,

"shrTatekaeBaraiGaku" DECIMAL(11) NOT NULL,

"shrDaikoTesuryo" DECIMAL(11) NOT NULL,

"shrShunyuInsi" DECIMAL(1) NOT NULL,

"shrKoseiShoshoDai" DECIMAL(1) NOT NULL,

"shrJimuTesuryo" DECIMAL(1) NOT NULL,

"shrOtherHiyo" DECIMAL(9) NOT NULL,

"shrAzukariHoshokin" DECIMAL(11) NOT NULL,

"shrHansokuhi" DECIMAL(11) NOT NULL,

"hansokuhiRituGakuCd" CHAR(1) NOT NULL,

"hansokuhiApplyRyoritu" DECIMAL(9) NOT NULL,

"hansokuhiApplyGaku" DECIMAL(9) NOT NULL,

"shrOrderHensaiGaku" DECIMAL(1) NOT NULL,

"seisanKindCd" CHAR(2) NOT NULL,

"hansokuhiSeisanSign" CHAR(1) NOT NULL,

"shrSeisanGaku" DECIMAL(11) NOT NULL,

"shrCancelTesuryo" DECIMAL(9) NOT NULL,

"shrCardIntroduceRyo" DECIMAL(11) NOT NULL,

"shrTaxOther" DECIMAL(11) NOT NULL,

"shrGaku" DECIMAL(13) NOT NULL,

"shrGakuNaiGenkin" DECIMAL(11) NOT NULL,

"shrGakuNaiFurikomiTesuryo" DECIMAL(1) NOT NULL,

"shrGakuNaiTegata" DECIMAL(11) NOT NULL,

"kykMosikomiUketukeDate" CHAR(1) NOT NULL,

"kykRingiAuthNo" CHAR(6) NOT NULL,

"kykUkeireDate" CHAR(8) NOT NULL,

"kykSaikenKizokuButenCd" CHAR(3) NOT NULL,

"kykSaikenKizokuButenCompanyCd" CHAR(2) NOT NULL,

"kykSaikenKizokuButenNm" VARCHAR(90) NOT NULL,

"kykSaikenKizokuButenKanaNm" VARCHAR(30) NOT NULL,

"kykSaikenKizokuButenDaihyoTel" VARCHAR(12) NOT NULL,

"cstSinseiHensaiMethodCd" CHAR(1) NOT NULL,

"kmtnTkskHoyuInfoNy" VARCHAR(20) NOT NULL,

"kmtnKykNo" CHAR(12) NOT NULL,

"sofusakiSiteiUmuSign" CHAR(1) NOT NULL,

"dealFormCd" CHAR(1) NOT NULL,

"sinyoHoshoFormCd" CHAR(1) NOT NULL,

"uriIncludeSikibetuCd" CHAR(1) NOT NULL,

"risokuCalcFormCd" CHAR(1) NOT NULL,

"kykGaku" DECIMAL(1) NOT NULL,

"tatekaeDivideTimes" SMALLINT NOT NULL,

"tatekaeBaraiGaku" DECIMAL(11) NOT NULL,

"tatekaeKoseiShoshoDai" DECIMAL(1) NOT NULL,

"tatekaeUriShunyuInsiDai" DECIMAL(1) NOT NULL,

"tatekaeUriJimuTesuryo" DECIMAL(1) NOT NULL,

"tatekaeUriOtherHiyo" DECIMAL(9) NOT NULL,

"tatekaeUserTesuryo" DECIMAL(11) NOT NULL,

"tatekaeDaikoTesuryo" DECIMAL(11) NOT NULL,

"tatekaeCancelTesuryo" DECIMAL(9) NOT NULL,

"tatekaeUriHansokuhi" DECIMAL(11) NOT NULL,

"ryorituKbn" CHAR(2) NOT NULL,

"kmtnTkskNo" CHAR(8) NOT NULL,

"tatekaeKonyuShohinKanaNm" CHAR(1) NOT NULL,

"consumptionTaxKeikaSochiCd" CHAR(1) NOT NULL,

"furikomiTesuryoChoshuSign" CHAR(1) NOT NULL,

"tatekaeUriShrDate" CHAR(8) NOT NULL,

"tatekaeShrSimekiriDate" CHAR(8) NOT NULL,

"shrSiryoCreateDate" CHAR(8) NOT NULL,

"shrMethodCd" CHAR(1) NOT NULL,

"shrKisanCd" CHAR(1) NOT NULL,

"shrKijituSiteiCd" CHAR(1) NOT NULL,

"shrKijitu" CHAR(4) NOT NULL,

"daikinKaishuDate" CHAR(8) NOT NULL,

"daikinKaishuCd" CHAR(1) NOT NULL,

"daikinKaishukinGaku" DECIMAL(11) NOT NULL,

"henkoCancelShrDate" CHAR(8) NOT NULL,

"henkoCancelShrSimekiriDate" CHAR(8) NOT NULL,

"henkoCancelShrSiryoCreateDate" CHAR(8) NOT NULL,

"tatekaeSpecialUkeireSign" CHAR(1) NOT NULL,

"tatekaeSosaiTaishoUriNo" CHAR(1) NOT NULL,

"tatekaeSosaiTaishoGaku" DECIMAL(1) NOT NULL,

"tatekaeUriCstYakujoDate" CHAR(1) NOT NULL,

"tatekaeMonthlySkyGankin1" DECIMAL(1) NOT NULL,

"tatekaeMonthlySkyGankin2" DECIMAL(1) NOT NULL,

"tatekaeMonthlySkyGankin3" DECIMAL(1) NOT NULL,

"tatekaeMonthlyFractionSkyGankin" DECIMAL(1) NOT NULL,

"tatekaeMonthlyFirstSkyRisoku" DECIMAL(1) NOT NULL,

"tatekaeMonthlyFirstSkyHoshoryo" DECIMAL(1) NOT NULL,

"tatekaeFirstSkyDate" CHAR(8) NOT NULL,

"finalSkyDate" CHAR(1) NOT NULL,

"tatekaeZogakuAddGaku1" DECIMAL(1) NOT NULL,

"tatekaeZogakuAddGaku2" DECIMAL(1) NOT NULL,

"tatekaeZogakuAddGaku3" DECIMAL(1) NOT NULL,

"tatekaeZogakuSkyCalcHosikiCd" CHAR(1) NOT NULL,

"tatekaeZogakuSkyMonth1" CHAR(1) NOT NULL,

"tatekaeZogakuSkyMonth2" CHAR(1) NOT NULL,

"tatekaeZogakuSkyMonth3" CHAR(1) NOT NULL,

"tatekaeZogakuSkyMonth4" CHAR(1) NOT NULL,

"tatekaeZogakuSkyGankin1" DECIMAL(1) NOT NULL,

"tatekaeZogakuSkyGankin2" DECIMAL(1) NOT NULL,

"tatekaeZogakuSkyGankin3" DECIMAL(1) NOT NULL,

"tatekaeZogakuFirstSkyRisoku" DECIMAL(1) NOT NULL,

"tatekaeZogakuFirstSkyHoshoryo" DECIMAL(1) NOT NULL,

"tatekaeZogakuFirstSkyDate" CHAR(8) NOT NULL,

"tatekaeZogakuSkyTimes" DECIMAL(1) NOT NULL,

"tatekaeMonthlySoGankin" DECIMAL(1) NOT NULL,

"tatekaeMonthlySoGankinTotalGaku" DECIMAL(1) NOT NULL,

"tatekaeZogakuSoGankin" DECIMAL(1) NOT NULL,

"tatekaeZogakuSoGankinTotalGaku" DECIMAL(1) NOT NULL,

"tatekaeSoSkyTimes" DECIMAL(1) NOT NULL,

"tatekaeSoSkyTimesTotal" DECIMAL(1) NOT NULL,

"tatekaeSueokiZogakuKeikaRisokuToriatukaiCd" CHAR(1) NOT NULL,

"tatekaeHensaiKindCd" CHAR(4) NOT NULL,

"tatekaeBubaraikinFractionProcessMethodCd" CHAR(1) NOT NULL,

"tatekaeBubaraikinCalcMethodCd" CHAR(1) NOT NULL,

"tatekaeGankinRisokuHensaiMethodCd1" CHAR(1) NOT NULL,

"tatekaeGankinRisokuHensaiMethodCd2" CHAR(1) NOT NULL,

"tatekaeGankinRisokuHensaiMethodCd3" CHAR(1) NOT NULL,

"tatekaeStageSikibetuSign" CHAR(1) NOT NULL,

"tatekaeToriatukaiKoteiHendoCd" CHAR(1) NOT NULL,

"tatekaePeriodStepAddTimes" DECIMAL(1) NOT NULL,

"tatekaeHoshoryoCalcHosikiCd" CHAR(1) NOT NULL,

"tatekaeHoshoryoFractionProcessMethodCd" CHAR(1) NOT NULL,

"tatekaeFirstRisokuCalcMethodCd" CHAR(1) NOT NULL,

"tatekaeHiwariCalcKatahashiRyohashiCd" CHAR(1) NOT NULL,

"tatekaeHiwariKijunDayCd" CHAR(1) NOT NULL,

"tatekaeFinalZogakuHensaiCd" CHAR(1) NOT NULL,

"tatekaeKoseiShoshoDaiChoshusakiCd" CHAR(1) NOT NULL,

"tatekaeUriShunyuInsiDaiChoshusakiCd" CHAR(1) NOT NULL,

"tatekaeUriJimuTesuryoChoshusakiCd" CHAR(1) NOT NULL,

"tatekaeUriOtherHiyoChoshusakiCd" CHAR(1) NOT NULL,

"tatekaeKoseiShoshoDaiChoshuMethodCd" CHAR(1) NOT NULL,

"tatekaeUriInsiDaiChoshuMethodCd" CHAR(1) NOT NULL,

"tatekaeUriJimuTesuryoChoshuMethodCd" CHAR(1) NOT NULL,

"tatekaeUriTaHiyoChoshuMethodCd" CHAR(1) NOT NULL,

"kykShohinNo" CHAR(1) NOT NULL,

"uriSikibetuCd" CHAR(1) NOT NULL,

"creditCardNo" CHAR(19) NOT NULL,

"tatekaeUriKonyuDate" CHAR(8) NOT NULL,

"taxOther" DECIMAL(11) NOT NULL,

"tatekaekinShrsakiSikibetuCd" CHAR(1) NOT NULL,

"cstNo" CHAR(12) NOT NULL,

"tatekaeRivoMinShrGaku" DECIMAL(7) NOT NULL,

"tatekaeRivoSpToriatukaiCourse" CHAR(1) NOT NULL,

"cardNoFamilySaihakkoGenerator" DECIMAL(1) NOT NULL,

"kuriageHensaiKakuteiDate" CHAR(1) NOT NULL,

"hansokuhiKuriageKaishuPeriodCd" CHAR(1) NOT NULL,

"shrsakiKjnHjnCd" CHAR(1) NOT NULL,

"shrsakiDealStopReasonCd" CHAR(3) NOT NULL,

"shrsakiDealStopDate" CHAR(8) NOT NULL,

"shrsakiKankatuButenCd" CHAR(3) NOT NULL,

"shrsakiKankatuButenCompanyCd" CHAR(2) NOT NULL,

"shrsakiKankatuButenNm" VARCHAR(90) NOT NULL,

"shrsakiNm" VARCHAR(90) NOT NULL,

"shrsakiKanaNm" VARCHAR(30) NOT NULL,

"shrsakiPostno" CHAR(8) NOT NULL,

"shrsakiAddressCd" CHAR(7) NOT NULL,

"shrsakiAddress1" VARCHAR(45) NOT NULL,

"shrsakiAddress2" VARCHAR(84) NOT NULL,

"shrsakiHosokuAddress" VARCHAR(84) NOT NULL,

"shrsakiKanaAddress1" VARCHAR(14) NOT NULL,

"shrsakiKanaAddress2" VARCHAR(28) NOT NULL,

"shrsakiKanaHosokuAddress" VARCHAR(28) NOT NULL,

"shrsakiTel" CHAR(12) NOT NULL,

"shrsakiBankCd" CHAR(4) NOT NULL,

"shrsakiBankNm" VARCHAR(90) NOT NULL,

"shrsakiBankKanaNm" VARCHAR(30) NOT NULL,

"shrsakiBankHonsitenNo" CHAR(3) NOT NULL,

"shrsakiBankHonsitenNm" VARCHAR(90) NOT NULL,

"shrsakiBankHonsitenKanaNm" VARCHAR(30) NOT NULL,

"shrsakiKzNo" CHAR(7) NOT NULL,

"shrsakiYokinShubetuCd" CHAR(1) NOT NULL,

"shrsakiKzNm" VARCHAR(90) NOT NULL,

"shrsakiKzNmKanaNm" VARCHAR(30) NOT NULL,

"kmtnTkskKjnHjnCd" CHAR(1) NOT NULL,

"kmtnTkskNm" VARCHAR(90) NOT NULL,

"kmtnTkskKanaNm" VARCHAR(30) NOT NULL,

"kmtnTkskHjnKakuCd" CHAR(1) NOT NULL,

"kmtnTkskHjnKakuZengoCd" CHAR(1) NOT NULL,

"kmtnTkskPostno" CHAR(8) NOT NULL,

"kmtnTkskAddressCd" CHAR(7) NOT NULL,

"kmtnTkskAddress1" VARCHAR(45) NOT NULL,

"kmtnTkskAddress2" VARCHAR(84) NOT NULL,

"kmtnTkskHosokuAddress" VARCHAR(84) NOT NULL,

"kmtnTkskKanaAddress1" VARCHAR(14) NOT NULL,

"kmtnTkskKanaAddress2" VARCHAR(28) NOT NULL,

"kmtnKanaHosokuAddress" VARCHAR(28) NOT NULL,

"kmtnTkskKankatuButenCd" CHAR(3) NOT NULL,

"kmtnKankatuButenCompanyCd" CHAR(2) NOT NULL,

"kmtnTkskKankatuButenNm" VARCHAR(90) NOT NULL,

"kmtnTkskUseTenno" VARCHAR(14) NOT NULL,

"companyKmtnTkskNo" CHAR(8) NOT NULL,

"kjnCstNm" VARCHAR(60) NOT NULL,

"kjnCstKanaNm" VARCHAR(20) NOT NULL,

"kjnCstGenderCd" CHAR(1) NOT NULL,

"kjnCstBirthDate" CHAR(8) NOT NULL,

"kjnCstHomePostno" CHAR(8) NOT NULL,

"kjnCstHomeAddressCd" CHAR(7) NOT NULL,

"kjnCstHomeAddress1" VARCHAR(45) NOT NULL,

"kjnCstHomeAddress2" VARCHAR(84) NOT NULL,

"kjnCstHomeHosokuAddress" VARCHAR(84) NOT NULL,

"kjnCstHomeKanaAddress1" VARCHAR(14) NOT NULL,

"kjnCstHomeKanaAddress2" VARCHAR(28) NOT NULL,

"kjnCstHomeKanaHosokuAddress" VARCHAR(28) NOT NULL,

"kjnCstHomeTel" VARCHAR(12) NOT NULL,

"kjnCstHomeTelYobidasiSign" CHAR(1) NOT NULL,

"kjnCstKinmusakiKanaNm" VARCHAR(45) NOT NULL,

"kjnCstKinmusakiTel" VARCHAR(12) NOT NULL,

"hjnCstNm" VARCHAR(90) NOT NULL,

"hjnCstKanaNm" VARCHAR(30) NOT NULL,

"hjnCstHjnKakuCd" CHAR(1) NOT NULL,

"hjnCstHjnKakuZengoCd" CHAR(1) NOT NULL,

"hjnCstShozaichiPostno" CHAR(8) NOT NULL,

"hjnCstShozaichiAddressCd" CHAR(7) NOT NULL,

"hjnCstShozaichiAddress1" VARCHAR(45) NOT NULL,

"hjnCstShozaichiAddress2" VARCHAR(84) NOT NULL,

"hjnCstShozaichiHosokuAddress" VARCHAR(84) NOT NULL,

"hjnCstShozaichiKanaAddress1" VARCHAR(14) NOT NULL,

"hjnCstShozaichiKanaAddress2" VARCHAR(28) NOT NULL,

"hjnCstShozaichiKanaHosokuAddress" VARCHAR(28) NOT NULL,

"hjnCstDaihyoTel" CHAR(12) NOT NULL,

"sofusakiNm" CHAR(1) NOT NULL,

"sofusakiKanaNm" CHAR(1) NOT NULL,

"sofusakiPostno" CHAR(1) NOT NULL,

"sofusakiAddressCd" CHAR(1) NOT NULL,

"sofusakiAddress1" CHAR(1) NOT NULL,

"sofusakiAddress2" CHAR(1) NOT NULL,

"sofusakiHosokuAddress" CHAR(1) NOT NULL,

"sofusakiKanaAddress1" CHAR(1) NOT NULL,

"sofusakiKanaAddress2" CHAR(1) NOT NULL,

"sofusakiKanaHosokuAddress" CHAR(1) NOT NULL,

"kmtnKykShohinNo" CHAR(4) NOT NULL,

"kmtnKykShohinNyNo" CHAR(5) NOT NULL,

"kmtnKykKindCd" CHAR(4) NOT NULL,

"kmtnKykApplyStartDate" CHAR(8) NOT NULL,

"kmtnKykKanriButenCd" CHAR(3) NOT NULL,

"kmtnKykKanriButenCompanyCd" CHAR(2) NOT NULL,

"kmtnKykKanriButenNm" VARCHAR(90) NOT NULL,

"kmtnKykKanriButenTel" VARCHAR(12) NOT NULL,

"kmtnKykHoyuInfoPatternKbn" CHAR(1) NOT NULL,

"kmtnTkskUseNm" VARCHAR(75) NOT NULL,

"azukariHoshokinChoshuUmuSign" CHAR(1) NOT NULL,

"azukariHoshokinRituGakuCd" CHAR(1) NOT NULL,

"azukariHoshokinRitu" DECIMAL(9) NOT NULL,

"azukariHoshokinGaku" DECIMAL(13) NOT NULL,

"zogakuIkkatuHensaiShrKijituSiteiCd" CHAR(1) NOT NULL,

"zogakuHensaiToriatukaiStartDate" CHAR(8) NOT NULL,

"zogakuHensaiToriatukaiEndDate" CHAR(8) NOT NULL,

"shrDetailCreateCd" CHAR(3) NOT NULL,

"shrDetailSiryoCreateCopies" DECIMAL(2) NOT NULL,

"kmtnTkskShrKijituSiteiCd" CHAR(2) NOT NULL,

"kmtnTkskShrSimekiriDate1" CHAR(2) NOT NULL,

"kmtnTkskShrSimekiriDate2" CHAR(2) NOT NULL,

"kmtnTkskShrSimekiriDate3" CHAR(2) NOT NULL,

"kmtnTkskShrSimekiriDate4" CHAR(2) NOT NULL,

"kmtnTkskShrSimekiriDate5" CHAR(2) NOT NULL,

"kmtnTkskShrSimekiriDate6" CHAR(2) NOT NULL,

"kmtnTkskShrSumStartMd1" CHAR(4) NOT NULL,

"kmtnTkskShrSumStartMd2" CHAR(4) NOT NULL,

"kmtnTkskShrSumStartMd3" CHAR(4) NOT NULL,

"kmtnTkskShrSumStartMd4" CHAR(4) NOT NULL,

"kmtnTkskShrSumStartMd5" CHAR(4) NOT NULL,

"kmtnTkskShrSumStartMd6" CHAR(4) NOT NULL,

"kmtnTkskShrSumStartMd7" CHAR(4) NOT NULL,

"kmtnTkskShrSumStartMd8" CHAR(4) NOT NULL,

"kmtnTkskShrSumStartMd9" CHAR(4) NOT NULL,

"kmtnTkskShrSumStartMd10" CHAR(4) NOT NULL,

"kmtnTkskShrSumStartMd11" CHAR(4) NOT NULL,

"kmtnTkskShrSumStartMd12" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd1" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd2" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd3" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd4" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd5" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd6" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd7" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd8" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd9" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd10" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd11" CHAR(4) NOT NULL,

"kmtnTkskShrSumEndMd12" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu1" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu2" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu3" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu4" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu5" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu6" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu7" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu8" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu9" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu10" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu11" CHAR(4) NOT NULL,

"tatekaekinShrSiryoCreateKijitu12" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu1" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu2" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu3" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu4" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu5" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu6" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu7" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu8" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu9" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu10" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu11" CHAR(4) NOT NULL,

"tatekaekinShrSiteiKijitu12" CHAR(4) NOT NULL,

"tatekaekinDivideShrCd" CHAR(1) NOT NULL,

"hansokuhiSumUnitCd" CHAR(1) NOT NULL,

"tatekaeCancelDaiteHenreiUmuSign" CHAR(1) NOT NULL,

"tatekaekinSofuriKahiSign" CHAR(1) NOT NULL,

"tatekaekinFurikomiTesuryoChoshuMethodCd" CHAR(1) NOT NULL,

"shrDetailCreateGroup" CHAR(8) NOT NULL,

"tatekaekinShrsakiKmtnNo" CHAR(8) NOT NULL,

"tatekaekinShrsakiSeq" CHAR(2) NOT NULL,

"tatekaekinShrMethodCd" CHAR(1) NOT NULL,

"sogoFurikomiToriatukaiUmuSign" CHAR(1) NOT NULL,

"sogoFurikomiDataExchangeMediaCd" CHAR(1) NOT NULL,

"sogoFurikomiDensoMethodCd" CHAR(1) NOT NULL,

"sogoFurikomiDensoKanoStartTimeHm" CHAR(4) NOT NULL,

"sogoFurikomiDensoKanoEndTimeHm" CHAR(4) NOT NULL,

"sogoFurikomiContactTel" VARCHAR(12) NOT NULL,

"sogoFurikomiIraiCd" CHAR(10) NOT NULL,

"sogoFurikomisakiBankCd" CHAR(4) NOT NULL,

"sogoFurikomisakiBankHonsitenNo" CHAR(3) NOT NULL,

"sogoFurikomisakiYokinShubetuCd" CHAR(1) NOT NULL,

"sogoFurikomisakiKzNo" CHAR(7) NOT NULL,

"specialFurikomiToriatukaiKahiSign" CHAR(1) NOT NULL,

"specialFurikomiDensosakiBankCd" CHAR(4) NOT NULL,

"specialFurikomiDensosakiHonsitenNo" CHAR(3) NOT NULL,

"INSERT_USER_ID" VARCHAR(10) NOT NULL,

"INSERT_DATE_TIME" TIMESTAMP(0) NOT NULL,

"UPDATE_USER_ID" VARCHAR(10) NOT NULL,

"UPDATE_DATE_TIME" TIMESTAMP(0) NOT NULL,

PRIMARY KEY (

"memNo",

"uriNo",

"processDay",

"processTime",

"sTatekaekinShrsakiKmtnNo",

"sTatekaekinShrsakiSeq",

"sSiryoCreateDay",

"sShrDay",

"sTegataShrDay",

"shrSign",

"shrGakuSumKbn",

"shrKijituSiteiCd",

"shrKijitu"

) );

COMMENT ON TABLE "GENSHINHIKAKU_TEST"."TMP_GEN_NEW_COMP＿CARD_KMTN_SEISAN_KAKUTEI_ATLAS_RENKEI_DATA" IS '現新比較テストにおいて

ATLASでカード、非カードを含めた加盟店精算を行うため、ATREEよりカードの売上、契約、清算に関わる支払明細を連携するデータをテーブル化したもの';