USER_MATRIX_BUTTON_MASTER ¤Ë¤½¤Î¥Õ¥¡¥¤¥ë¤Ï¸«¤Ä¤«¤ê¤Þ¤»¤ó

PrimeKarte > USER_ORDER > USER_MATRIX_BUTTON_MASTER

³µÍ× †

• ¥Þ¥È¥ê¥¯¥¹¥Ü¥¿¥ó¾ðÊó¥Þ¥¹¥¿
• ¥Æ¡¼¥Ö¥ë¡§USER_ORDER
• MASTER_CODE_STR¡§00030308
• ¥Þ¥È¥ê¥¯¥¹¥Ü¥¿¥ó¡¦¥Þ¥¹¥¿¥á¥ó¥Æ¤Ç¥Ü¥¿¥ó¤Ë¥»¥Ã¥È¤¹¤ë¹àÌܤÎÁªÂò»è¤È¤Ê¤ë

¥Æ¡¼¥Ö¥ëÄêµÁ †

• ´ðËÜŪ¤Ë¤ÏUSER_BUTTON_INF¤ÈƱ¤¸
• ¤¿¤À¤·¡¢²¼µ­¤ÎÄêµÁ¤¬Äɲ䵤ì¤ë

  ¥«¥é¥à̾	ÆâÍÆ	ËÞÎã
  MASTER_CODE_STR	¥Þ¥¹¥¿¥³¡¼¥É	00030308
  CODE_15	¹àÌÜ¥³¡¼¥É¡ÊËÜ¥Þ¥¹¥¿Æâ¤Ç°ì°Õ¡Ë	1
  STR_15	¥Þ¥È¥ê¥¯¥¹²èÌ̤Ëɽ¼¨¤¹¤ë¥Ä¡¼¥ë¥Á¥Ã¥×	ºÆ¿ÇͽÌ󥪡¼¥À²èÌ̤ò³«¤­¤Þ¤¹¡£

½é´ü¥»¥Ã¥È¥¢¥Ã¥× †

• USER_BUTTON_INF¤ÈÁ´¤¯Æ±¤¸ÆâÍƤΥޥ¹¥¿¤òºîÀ®¤¹¤ë¤Ë¤Ï¡¢²¼µ­¤Î¥¹¥¯¥ê¥×¥È¤òή¤¹

  DELETE FROM USER_ORDER WHERE MASTER_CODE_STR = '00030308'
  /
  INSERT INTO USER_ORDER
  SELECT
  '00030308' --MASTER_CODE_STR
  , USER_ID
  , CONDITION_FLG
  , LAST_FLG
  , SYSTIMESTAMP
  , SYSTIMESTAMP
  , 'SBS'
  , LEVEL_CODE_STR
  , DISP_FLGTBL
  , FLGTBL
  , START_DATETIME
  , END_DATETIME
  , STAFF_KIND
  , NAME
  , SHORT_NAME
  , KANA_NAME
  , REAL_NAME
  , PRINT_NAME
  , ENGLISH_NAME
  , IJI_CODE
  , IJI_CODE_STR
  , IJI_INTERFACE_FLGTBL
  , BUMON_CODE
  , BUMON_CODE_STR
  , DISP_ORDER
  , CONTENTS
  , ORDER_KIND_CODE_STR
  , CONVERT_CODE_STR
  , FLGTBL_L_01
  , FLGTBL_L_02
  , FLGTBL_L_03
  , FLGTBL_L_04
  , CODE_01
  , CODE_DBL_01
  , DATE_01
  , FLG_01
  , STR_01
  , CODE_02
  , CODE_DBL_02
  , DATE_02
  , FLG_02
  , STR_02
  , CODE_03
  , CODE_DBL_03
  , DATE_03
  , FLG_03
  , STR_03
  , CODE_04
  , CODE_DBL_04
  , DATE_04
  , FLG_04
  , STR_04
  , CODE_05
  , CODE_DBL_05
  , DATE_05
  , FLG_05
  , STR_05
  , CODE_06
  , CODE_DBL_06
  , DATE_06
  , FLG_06
  , STR_06
  , CODE_07
  , CODE_DBL_07
  , DATE_07
  , FLG_07
  , STR_07
  , CODE_08
  , CODE_DBL_08
  , DATE_08
  , FLG_08
  , STR_08
  , CODE_09
  , CODE_DBL_09
  , DATE_09
  , FLG_09
  , STR_09
  , CODE_10
  , CODE_DBL_10
  , DATE_10
  , FLG_10
  , STR_10
  , CODE_11
  , CODE_DBL_11
  , DATE_11
  , FLG_11
  , STR_11
  , CODE_12
  , CODE_DBL_12
  , DATE_12
  , FLG_12
  , STR_12
  , CODE_13
  , CODE_DBL_13
  , DATE_13
  , FLG_13
  , STR_13
  , CODE_14
  , CODE_DBL_14
  , DATE_14
  , FLG_14
  , STR_14
  , ROWNUM --CODE_15:¹àÌÜ¥³¡¼¥É
  , CODE_DBL_15
  , DATE_15
  , FLG_15
  , '' --STR_15:¥Ä¡¼¥ë¥Á¥Ã¥×
  FROM
  (
  SELECT * FROM USER_ORDER
  WHERE MASTER_CODE_STR = '00030001'
  AND CONDITION_FLG = 0
  AND LAST_FLG = 1
  AND USER_ID = 'default'
  ORDER BY CODE_01, CODE_02
  )
  /

• ¥»¥ë¥¹¥¿¥¤¥ë¤Î¥Ç¥Õ¥©¥ë¥ÈÃͤ¬¤Ê¤¤¤È¥¨¥é¡¼¤È¤Ê¤ë

  -- Äɲå쥳¡¼¥É¿ô¡§4
  DELETE FROM CELL_STYLE WHERE ORDER_KIND_CODE_STR = '0003' AND CODE IN (0, 1, 2, 39)
  /
  INSERT INTO CELL_STYLE VALUES('00201106', 0, TO_DATE('2007/07/03 16:03:00', 'YYYY/MM/DD HH24:MI:SS'), TO_DATE('2011/12/06 20:36:50', 'YYYY/MM/DD HH24:MI:SS'), '', 1, 'test', '¥Ç¥Õ¥©¥ë¥È¤ÎÇطʡʸÇÄê¡Ë', '0003', 12, 0, 0, '£Í£Ó £Ð¥´¥·¥Ã¥¯', 0, 0, 0, 255, 255, 255, 1)
  /
  INSERT INTO CELL_STYLE VALUES('00201106', 1, TO_DATE('2007/07/03 16:03:00', 'YYYY/MM/DD HH24:MI:SS'), TO_DATE('2012/01/17 22:07:23', 'YYYY/MM/DD HH24:MI:SS'), '', 1, 'test', '¥Ç¥Õ¥©¥ë¥È¤ÎÁªÂò»þÇطʡʸÇÄê¡Ë', '0003', 12, 1, 0, '£Í£Ó £Ð¥´¥·¥Ã¥¯', 0, 0, 0, 0, 255, 255, 1)
  /
  INSERT INTO CELL_STYLE VALUES('00201106', 2, TO_DATE('2007/07/03 16:03:00', 'YYYY/MM/DD HH24:MI:SS'), TO_DATE('2011/12/20 10:32:32', 'YYYY/MM/DD HH24:MI:SS'), '', 1, 'test', '¾®Ê¬Îà­¡', '0003', 12, 0, 0, '£Í£Ó £Ð¥´¥·¥Ã¥¯', 0, 0, 0, 192, 224, 255, 4)
  /
  INSERT INTO CELL_STYLE VALUES('00020106', 39, TO_DATE('2020/05/07 15:56:19', 'YYYY/MM/DD HH24:MI:SS'), TO_DATE('2020/05/07 15:56:19', 'YYYY/MM/DD HH24:MI:SS'), '', 1, 'test', '¥³¥á¥ó¥È', '0003', 9, 0, 0, '£Í£Ó £Ð¥´¥·¥Ã¥¯', 0, 0, 0, 255, 255, 255, 9)
  /