积分查询或是礼品测试造积分数据sql

INSERT INTO "IBASETL"."T_ZHJF_HX_PER_CISIA"("JFCUNO", "SICUNM", "SIDFNM", "SINTNL", "SISEXX", "SIBRTH", "SIPRFS", "SIAPBG", "SIADDR", "SIZPCD", "SITELP", "SIIDTP", "SIIDNO", "SIISAU", "SICOCD", "SISTC1", "SISTC2", "SISTCD", "ODS_SRC_DT", "SJCPNM", "SJOFAD", "SJOFZP", "SJPSAD", "SJPSZP", "SJHMAD", "SJHMZP", "SJMOBL", "SJADCD", "SJADNM", "SJMDDT", "SJCRDT", "BANK_AGE", "BANK_AGE_UPDATE", "JFBRNO")
VALUES('90001001', 'zxize', NULL, 'CN', '1', '1964-07-08', NULL, NULL, NULL, '954407', NULL, '03', '护照1294293A', NULL, NULL, NULL, NULL, 'A', '2009-12-05', 'a', '', '', '苏州', '215000', '苏州', '215000', '13912609296', '3050', '江苏省苏州市', '2009-06-30', '2007-09-01', 0, NULL, '0110')
GO

INSERT INTO "IBASETL"."T_ZHJF_HX_SCSAA"("SASCNO", "CARDBIN", "SABRNO", "SASBNO", "JFBRNO", "SAACNO", "SACDKD", "SACDID", "JFCUNO", "SACUNO", "SACPNM", "SAICDT", "SAENDT", "SALDDT", "SACSAM", "SANCFG", "SATRDT", "SATRNO", "SAMCFG", "SARCTL", "SAFSFG", "SAMSFG", "SASTCD", "ODS_ORG_ID", "ODS_SRC_DT")
VALUES('9688071500772505', '100000', '00002', '1', '0110', '6288714382911239369', '38', '2', '90001001', '90001001', 'zhao', '2007-09-01', 20970505, 20090111, 5858882308616, '0', '2009-09-30', '67940781174104', '1', NULL, 'A', 'A', 'D', NULL, '2007-09-21')
GO

INSERT INTO "IBASDB"."JG_MEMBER"("M_ID", "DOMAIN_ID", "KIND_ID", "M_CODE", "M_NAME", "M_CODE2", "M_GROUP", "CREATE_TIME", "LAST_UPDATE", "STATUS")
VALUES(91657102, NULL, 19002, '90001001', '未初始化', NULL, NULL, '2009-10-19 10:57:13.0', '2009-10-19 10:57:13.0', '1')
GO

 

INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731577, 91657102, 90, '90001001.90', 0, 3332, 0, 0, 0, 0, 3332, '1', '2009-10-19 11:22:15.0', '2009-10-19 11:22:19.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731543, 91657102, 88, '90001001.88', 0, 3332, 0, 0, 0, 0, 3332, '1', '2009-10-19 11:20:10.0', '2009-10-19 11:20:10.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731502, 91657102, 111, '90001001.85', 0, 1320000, 0, 0, 0, 0, 1320000, '1', '2009-10-19 11:17:20.0', '2009-10-19 11:17:20.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731136, 91657102, 41, '90001001.41', 0, 10, 0, 0, 0, 0, 10, '1', '2009-10-19 11:02:29.0', '2009-10-19 11:02:30.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731063, 91657102, 56, '90001001.56', 0, 10, 0, 0, 0, 0, 10, '1', '2009-10-19 10:57:28.0', '2009-10-19 10:57:29.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731109, 91657102, 43, '90001001.43', 0, 10, 0, 0, 0, 0, 10, '1', '2009-10-19 10:58:38.0', '2009-10-19 10:58:38.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731083, 91657102, 72, '90001001.72', 0, 10, 0, 0, 0, 0, 10, '1', '2009-10-19 10:57:30.0', '2009-10-19 10:57:30.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731042, 91657102, 71, '90001001.71', 0, 30, 0, 0, 0, 0, 30, '1', '2009-10-19 10:57:18.0', '2009-10-19 10:57:18.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731022, 91657102, 54, '90001001.54', 0, 600, 0, 0, 0, 0, 600, '1', '2009-10-19 10:57:15.0', '2009-10-19 10:57:15.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731002, 91657102, 55, '90001001.55', 0, 10, 0, 0, 0, 0, 10, '1', '2009-10-19 10:57:13.0', '2009-10-19 10:57:14.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734093, 91657102, 111, '90001001.111', 0, 10, 0, 0, 0, 0, 10, '1', '2009-11-12 10:58:21.0', '2009-11-12 10:58:21.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734089, 91657102, 118, '90001001.118', 0, 10, 0, 0, 0, 0, 10, '1', '2009-11-12 10:56:03.0', '2009-11-12 10:56:03.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734077, 91657102, 113, '90001001.113', 0, 10, 0, 0, 0, 0, 10, '1', '2009-11-12 10:55:41.0', '2009-11-12 10:55:41.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734043, 91657102, 117, '90001001.117', 0, 600, 0, 0, 0, 0, 600, '1', '2009-11-12 10:55:23.0', '2009-11-12 10:55:23.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734023, 91657102, 116, '90001001.116', 0, 10, 0, 0, 0, 0, 10, '1', '2009-11-12 10:55:22.0', '2009-11-12 10:55:22.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734002, 91657102, 115, '90001001.115', 0, 30, 0, 0, 0, 0, 30, '1', '2009-11-12 10:54:50.0', '2009-11-12 10:54:50.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93733505, 91657102, 86, '90001001.86', 0, 3332, 0, 0, 0, 0, 3332, '1', '2009-10-19 13:09:24.0', '2009-10-19 13:09:26.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93732300, 91657102, 101, '90001001.101', 0, 60000, 0, 0, 0, 0, 60000, '1', '2009-10-19 11:23:44.0', '2009-10-19 11:23:45.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93732503, 91657102, 84, '90001001.84', 0, 33320, 0, 0, 0, 0, 33320, '1', '2009-10-19 13:08:57.0', '2009-10-19 13:09:00.0', 2)
GO

insert into IBASETL.T_ACCT_DEPOIST(JFBRNO,ODS_ACCT_NO,JFCUNO,ODS_SRC_DT,MSOPDT) VALUES ('0110','6288714382911239369','90001001',null,'2010-07-16')