• Home
• org.kuali.ole
• ole-master-sql
• 1.5.8
• source code
• FS_ORIGIN_CODE_T.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.mysql.FS_ORIGIN_CODE_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE FS_ORIGIN_CODE_T
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NEXT_CG_AGENCY_NBR,NEXT_CG_SUBCNR_NBR,NXT_DV_PAYEEID_NBR,NXT_FDOC_ATT_ID,AR_NEXT_CUST_NBR,FDOC_NEXT_ITEM_ID,ROW_ACTV_IND)
  VALUES ('01','054EDFB3B241C8D2E043814FD881C8D2',17.0,'KULDBA','KFS','KFS',385596.0,153.0,'54984','850',178064.0,593252.0,18763.0,348.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,ROW_ACTV_IND)
  VALUES ('02','3978FAAFD5002076E043814FD8812076',1.0,'KFSYearEnd','KFSYearEnd','Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NEXT_CG_AGENCY_NBR,NEXT_CG_SUBCNR_NBR,NXT_DV_PAYEEID_NBR,NXT_FDOC_ATT_ID,AR_NEXT_CUST_NBR,FDOC_NEXT_ITEM_ID,ROW_ACTV_IND)
  VALUES ('99','BDCF7192-D2DA-5E18-ABDA-CB10CE64540C',1.0,'iuis','gle','gle',1.0,1.0,'1','1',1.0,1.0,1.0,1.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NEXT_CG_AGENCY_NBR,NEXT_CG_SUBCNR_NBR,NXT_DV_PAYEEID_NBR,NXT_FDOC_ATT_ID,ROW_ACTV_IND)
  VALUES ('CS','054EDFB3B242C8D2E043814FD881C8D2',1.0,'IUIS','GLE','GLE',0.0,0.0,' ',' ',0.0,0.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NXT_FDOC_ATT_ID,ROW_ACTV_IND)
  VALUES ('CV','054EDFB3B243C8D2E043814FD881C8D2',1.0,'IUIS','GLE','GLE',0.0,0.0,1.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,ROW_ACTV_IND)
  VALUES ('EM','915B897D3763C017E0404F8189D86D9B',1.0,'KULDBA','KFS','KFS','Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NEXT_CG_AGENCY_NBR,NEXT_CG_SUBCNR_NBR,NXT_DV_PAYEEID_NBR,NXT_FDOC_ATT_ID,AR_NEXT_CUST_NBR,FDOC_NEXT_ITEM_ID,ROW_ACTV_IND)
  VALUES ('EP','31B4CCF8C7506150E043814FD8816150',1.0,'GEN1PRD','PUR','PUR',0.0,0.0,'0','0',0.0,0.0,0.0,0.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NXT_FDOC_ATT_ID,ROW_ACTV_IND)
  VALUES ('EU','054EDFB3B244C8D2E043814FD881C8D2',1.0,'IUIS','GLE','GLE',0.0,0.0,1.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NEXT_CG_AGENCY_NBR,NEXT_CG_SUBCNR_NBR,NXT_DV_PAYEEID_NBR,NXT_FDOC_ATT_ID,AR_NEXT_CUST_NBR,FDOC_NEXT_ITEM_ID,ROW_ACTV_IND)
  VALUES ('IN','054EDFB3B24DC8D2E043814FD881C8D2',1.0,'IUIS','GLE','GLE',0.0,0.0,'0','0',0.0,0.0,0.0,0.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NXT_FDOC_ATT_ID,ROW_ACTV_IND)
  VALUES ('LD','054EDFB3B245C8D2E043814FD881C8D2',1.0,'IUIS','GLE','GLE',1.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NXT_FDOC_ATT_ID,ROW_ACTV_IND)
  VALUES ('LG','054EDFB3B246C8D2E043814FD881C8D2',1.0,'IUIS','GLE','GLE',0.0,0.0,1.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NXT_FDOC_ATT_ID,ROW_ACTV_IND)
  VALUES ('MF','054EDFB3B247C8D2E043814FD881C8D2',1.0,'IUIS','GLE','GLE',0.0,0.0,1.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NXT_FDOC_ATT_ID,ROW_ACTV_IND)
  VALUES ('NB','054EDFB3B248C8D2E043814FD881C8D2',1.0,'IUIS','GLE','GLE',1.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NEXT_CG_AGENCY_NBR,NEXT_CG_SUBCNR_NBR,NXT_DV_PAYEEID_NBR,NXT_FDOC_ATT_ID,AR_NEXT_CUST_NBR,FDOC_NEXT_ITEM_ID,ROW_ACTV_IND)
  VALUES ('NT','054EDFB3B24BC8D2E043814FD881C8D2',1.0,'IUIS','GLE','GLE',0.0,0.0,'0','0',0.0,0.0,0.0,0.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NEXT_CG_AGENCY_NBR,NEXT_CG_SUBCNR_NBR,NXT_DV_PAYEEID_NBR,NXT_FDOC_ATT_ID,AR_NEXT_CUST_NBR,FDOC_NEXT_ITEM_ID,ROW_ACTV_IND)
  VALUES ('PD','054EDFB3B24FC8D2E043814FD881C8D2',1.0,'GEN1PRD','PDP','PDP',0.0,0.0,'0','0',0.0,0.0,0.0,0.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NEXT_CG_AGENCY_NBR,NEXT_CG_SUBCNR_NBR,NXT_DV_PAYEEID_NBR,NXT_FDOC_ATT_ID,AR_NEXT_CUST_NBR,FDOC_NEXT_ITEM_ID,ROW_ACTV_IND)
  VALUES ('PL','054EDFB3B24CC8D2E043814FD881C8D2',1.0,'PS1PRD','HRMS','HRMS',0.0,0.0,'0','0',0.0,0.0,0.0,0.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NXT_FDOC_ATT_ID,ROW_ACTV_IND)
  VALUES ('PR','30C0299B574621B2E043814FD88121B2',1.0,'IUIS','GLE','GLE',1.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NXT_FDOC_ATT_ID,ROW_ACTV_IND)
  VALUES ('RV','054EDFB3B249C8D2E043814FD881C8D2',1.0,'IUIS','GLE','GLE',0.0,0.0,1.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NEXT_CG_AGENCY_NBR,NEXT_CG_SUBCNR_NBR,NXT_DV_PAYEEID_NBR,NXT_FDOC_ATT_ID,AR_NEXT_CUST_NBR,FDOC_NEXT_ITEM_ID,ROW_ACTV_IND)
  VALUES ('SF','054EDFB3B24EC8D2E043814FD881C8D2',1.0,'PS1PRD','SIS','SIS',0.0,0.0,'0','0',0.0,0.0,0.0,0.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NEXT_CPTLAST_NBR,NEXT_NONCA_NBR,NEXT_CG_AGENCY_NBR,NEXT_CG_SUBCNR_NBR,NXT_DV_PAYEEID_NBR,NXT_FDOC_ATT_ID,AR_NEXT_CUST_NBR,FDOC_NEXT_ITEM_ID,ROW_ACTV_IND)
  VALUES ('TR','31B4CCF8C7516150E043814FD8816150',1.0,'GEN1PRD','TVL','TVL',0.0,0.0,'0','0',0.0,0.0,0.0,0.0,'Y')
/
INSERT INTO FS_ORIGIN_CODE_T (FS_ORIGIN_CD,OBJ_ID,VER_NBR,FS_SERVER_NM,FS_DATABASE_NM,FS_DATABASE_DESC,NXT_FDOC_ATT_ID,ROW_ACTV_IND)
  VALUES ('UB','054EDFB3B24AC8D2E043814FD881C8D2',1.0,'IUIS','GLE','GLE',1.0,'Y')
/