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 '現(xiàn)新比較テストにおいて

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

?著作權歸作者所有,轉載或內容合作請聯(lián)系作者
  • 序言:七十年代末,一起剝皮案震驚了整個濱河市颠黎,隨后出現(xiàn)的幾起案子,更是在濱河造成了極大的恐慌,老刑警劉巖蒋情,帶你破解...
    沈念sama閱讀 222,729評論 6 517
  • 序言:濱河連續(xù)發(fā)生了三起死亡事件,死亡現(xiàn)場離奇詭異耸携,居然都是意外死亡棵癣,警方通過查閱死者的電腦和手機,發(fā)現(xiàn)死者居然都...
    沈念sama閱讀 95,226評論 3 399
  • 文/潘曉璐 我一進店門夺衍,熙熙樓的掌柜王于貴愁眉苦臉地迎上來狈谊,“玉大人,你說我怎么就攤上這事沟沙『尤埃” “怎么了?”我有些...
    開封第一講書人閱讀 169,461評論 0 362
  • 文/不壞的土叔 我叫張陵矛紫,是天一觀的道長赎瞎。 經常有香客問我,道長颊咬,這世上最難降的妖魔是什么煎娇? 我笑而不...
    開封第一講書人閱讀 60,135評論 1 300
  • 正文 為了忘掉前任二庵,我火速辦了婚禮,結果婚禮上缓呛,老公的妹妹穿的比我還像新娘催享。我一直安慰自己,他們只是感情好哟绊,可當我...
    茶點故事閱讀 69,130評論 6 398
  • 文/花漫 我一把揭開白布因妙。 她就那樣靜靜地躺著,像睡著了一般票髓。 火紅的嫁衣襯著肌膚如雪攀涵。 梳的紋絲不亂的頭發(fā)上,一...
    開封第一講書人閱讀 52,736評論 1 312
  • 那天洽沟,我揣著相機與錄音以故,去河邊找鬼。 笑死裆操,一個胖子當著我的面吹牛怒详,可吹牛的內容都是我干的。 我是一名探鬼主播踪区,決...
    沈念sama閱讀 41,179評論 3 422
  • 文/蒼蘭香墨 我猛地睜開眼昆烁,長吁一口氣:“原來是場噩夢啊……” “哼!你這毒婦竟也來了缎岗?” 一聲冷哼從身側響起静尼,我...
    開封第一講書人閱讀 40,124評論 0 277
  • 序言:老撾萬榮一對情侶失蹤,失蹤者是張志新(化名)和其女友劉穎传泊,沒想到半個月后鼠渺,有當?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體,經...
    沈念sama閱讀 46,657評論 1 320
  • 正文 獨居荒郊野嶺守林人離奇死亡眷细,尸身上長有42處帶血的膿包…… 初始之章·張勛 以下內容為張勛視角 年9月15日...
    茶點故事閱讀 38,723評論 3 342
  • 正文 我和宋清朗相戀三年系冗,在試婚紗的時候發(fā)現(xiàn)自己被綠了。 大學時的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片薪鹦。...
    茶點故事閱讀 40,872評論 1 353
  • 序言:一個原本活蹦亂跳的男人離奇死亡掌敬,死狀恐怖,靈堂內的尸體忽然破棺而出池磁,到底是詐尸還是另有隱情奔害,我是刑警寧澤,帶...
    沈念sama閱讀 36,533評論 5 351
  • 正文 年R本政府宣布地熄,位于F島的核電站华临,受9級特大地震影響,放射性物質發(fā)生泄漏端考。R本人自食惡果不足惜雅潭,卻給世界環(huán)境...
    茶點故事閱讀 42,213評論 3 336
  • 文/蒙蒙 一揭厚、第九天 我趴在偏房一處隱蔽的房頂上張望。 院中可真熱鬧扶供,春花似錦筛圆、人聲如沸。這莊子的主人今日做“春日...
    開封第一講書人閱讀 32,700評論 0 25
  • 文/蒼蘭香墨 我抬頭看了看天上的太陽。三九已至扳碍,卻和暖如春提岔,著一層夾襖步出監(jiān)牢的瞬間,已是汗流浹背笋敞。 一陣腳步聲響...
    開封第一講書人閱讀 33,819評論 1 274
  • 我被黑心中介騙來泰國打工碱蒙, 沒想到剛下飛機就差點兒被人妖公主榨干…… 1. 我叫王不留,地道東北人夯巷。 一個月前我還...
    沈念sama閱讀 49,304評論 3 379
  • 正文 我出身青樓赛惩,卻偏偏與公主長得像,于是被迫代替她去往敵國和親鞭莽。 傳聞我的和親對象是個殘疾皇子坊秸,可洞房花燭夜當晚...
    茶點故事閱讀 45,876評論 2 361

推薦閱讀更多精彩內容