--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 '現(xiàn)新比較テストにおいて
ATLASでカード、非カードを含めた加盟店精算を行うため赶促、ATREEよりカードの売上贰谣、契約衰粹、清算に関わる支払明細を連攜するデータをテーブル化したもの';
