ÀÌ Å×À̺íÀÇ °¢ ÇàÀº StoreEntity¸¦ Ç¥½ÃÇÕ´Ï´Ù. StoreEntity´Â »óÁ¡ ¶Ç´Â »óÁ¡ ±×·ì¿¡ ÀÖÀ» ¼ö ÀÖ´Â Ãß»ó ¼öÆÛ Ŭ·¡½ºÀÔ´Ï´Ù. ÀÌ´Â Å×ÀÌºí¿¡ ÀÖ´Â ÇϳªÀÇ ÇàÀ¸·Î µ¥ÀÌÅͺ£À̽º¿¡ Ç¥½ÃµË´Ï´Ù.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
IDENTIFIER | VARCHAR (254) NOT NULL |
¼ÒÀ¯ÀÚ¿Í ÇÔ²² °íÀ¯ÇÏ°Ô StoreEntity¸¦ ½Äº°ÇÏ´Â ¹®ÀÚ¿. |
MARKFORDELETE | INTEGER NOT NULL, DEFAULT 0 |
StoreEntity°¡ »èÁ¦µÉ °ÍÀ¸·Î Ç¥½ÃµÇ¾ú´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. 0 = ¾Æ´Ï¿À 1 = ¿¹ |
MEMBER_ID | BIGINT NOT NULL |
StoreEntityÀÇ ¼ÒÀ¯ÀÚ. |
SETCCURR | CHARACTER (3) NULL |
¼±È£ÇÏ´Â Åëȸ¦ ÁöÁ¤ÇÏÁö ¾ÊÀº °í°´ÀÌ »ç¿ëÇÒ »óÁ¡ ¿£Æ¼Æ¼¿¡ ´ëÇÑ ±âº» ÅëÈ. ÀÌ´Â ISO 4217 Ç¥ÁØ¿¡ µû¸¥ ÅëÈ ÄÚµåÀÔ´Ï´Ù. »óÁ¡¿¡ ´ëÇÑ ÅëÈ Äڵ尡 ³Î(Null)°ªÀ̸é, ±âº» ÅëÈ´Â »óÁ¡ ±×·ìÀ» ÅëÇØ ÃëµæµË´Ï´Ù. STORELANG Å×ÀÌºíµµ ÂüÁ¶ÇϽʽÿÀ. |
STOREENT_ID | INTEGER NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű. |
TYPE | CHARACTER (1) NOT NULL |
ÀÌ ÇàÀÌ ³ªÅ¸³»´Â StoreEntityÀÇ À¯ÇüÀ» ³ªÅ¸³À´Ï´Ù. G = StoreGroup. S = Store. |
»öÀÎ À̸§ | »öÀÎÈµÈ ¿ À̸§ | »öÀÎ À¯Çü |
---|---|---|
I0000240 | IDENTIFIER, MEMBER_ID | °íÀ¯ »öÀÎ |
SQL030416035114220 | STOREENT_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_789 | SETCCURR | SETCURR | SETCCURR | °è´Ü½Ä |
F_790 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_1015 | STOREENT_ID | MSGARCHIVE | STOREENT_ID | °è´Ü½Ä |
F_1025 | STOREENT_ID | MSGSTORE | STOREENT_ID | °è´Ü½Ä |
F_128 | STOREENT_ID | BROADCAST | STOREENT_ID | °è´Ü½Ä |
F_15 | STOREENT_ID | ACCLOGMAIN | STOREENT_ID | °è´Ü½Ä |
F_152 | STOREENT_ID | CALCODE | STOREENT_ID | °è´Ü½Ä |
F_164 | STOREENT_ID | CALMETHOD | STOREENT_ID | °è´Ü½Ä |
F_177 | STOREENT_ID | CALSCALE | STOREENT_ID | °è´Ü½Ä |
F_182 | STOREENT_ID | CAMPAIGN | STOREENT_ID | °è´Ü½Ä |
F_233 | STOREENT_ID | CHARGETYPE | STOREENT_ID | °è´Ü½Ä |
F_236 | STOREENT_ID | CHKCMD | STOREENT_ID | °è´Ü½Ä |
F_243 | STOREENT_ID | CMDREG | STOREENT_ID | °è´Ü½Ä |
F_249 | STOREENT_ID | COLLATERAL | STOREENT_ID | °è´Ü½Ä |
F_265 | STOREENT_ID | CPPMN | STOREENT_ID | °è´Ü½Ä |
F_286 | STOREENT_ID | CURCONVERT | STOREENT_ID | °è´Ü½Ä |
F_289 | STOREENT_ID | CURCVLIST | STOREENT_ID | °è´Ü½Ä |
F_293 | STOREENT_ID | CURFORMAT | STOREENT_ID | °è´Ü½Ä |
F_296 | STOREENT_ID | CURLIST | STOREENT_ID | °è´Ü½Ä |
F_299 | STOREENT_ID | DISPCGPREL | STOREENT_ID | °è´Ü½Ä |
F_304 | STOREENT_ID | DISPENTREL | STOREENT_ID | °è´Ü½Ä |
F_313 | STOREENT_ID | EMSPOT | STOREENT_ID | °è´Ü½Ä |
F_325 | STOREENT_ID | FLOWADMIN | STOREENT_ID | °è´Ü½Ä |
F_381 | STOREENT_ID | IITEM | STOREENT_ID | °è´Ü½Ä |
F_385 | STOREENT_ID | INITIATIVE | STOREENT_ID | °è´Ü½Ä |
F_388 | STOREENT_ID | INVADJCODE | STOREENT_ID | °è´Ü½Ä |
F_409 | STOREENT_ID | JURST | STOREENT_ID | °è´Ü½Ä |
F_412 | STOREENT_ID | JURSTGROUP | STOREENT_ID | °è´Ü½Ä |
F_415 | STOREENT_ID | LANGPAIR | STOREENT_ID | °è´Ü½Ä |
F_420 | STOREENT_ID | LMEVENTMAP | STOREENT_ID | °è´Ü½Ä |
F_421 | STOREENT_ID | LMSERVER | STOREENT_ID | °è´Ü½Ä |
F_439 | STOREENT_ID | MBRATTRVAL | STOREENT_ID | °è´Ü½Ä |
F_478 | STOREENT_ID | ONLOG | STOREENT_ID | °è´Ü½Ä |
F_480 | STOREENT_ID | ONQUEUE | STOREENT_ID | °è´Ü½Ä |
F_507 | STOREENT_ID | ORDERITEMS | STOREENT_ID | °è´Ü½Ä |
F_517 | STOREENT_ID | ORDERS | STOREENT_ID | °è´Ü½Ä |
F_577 | STOREENT_ID | PAYMTHDSUP | STOREENT_ID | °è´Ü½Ä |
F_581 | STOREENT_ID | PAYSUMMARY | STOREENT_ID | °è´Ü½Ä |
F_608 | STOREENT_ID | POLICY | STOREENT_ID | °è´Ü½Ä |
F_636 | STOREENT_ID | PVCMDLSPEC | STOREENT_ID | °è´Ü½Ä |
F_645 | STOREENT_ID | QTYFORMAT | STOREENT_ID | °è´Ü½Ä |
F_721 | STOREENT_ID | RTNDNYRSN | STOREENT_ID | °è´Ü½Ä |
F_722 | STOREENT_ID | RTNDSPCODE | STOREENT_ID | °è´Ü½Ä |
F_728 | STOREENT_ID | RTNREASON | STOREENT_ID | °è´Ü½Ä |
F_736 | STOREENT_ID | SCHCMD | STOREENT_ID | °è´Ü½Ä |
F_737 | STOREENT_ID | SCHCONFIG | STOREENT_ID | °è´Ü½Ä |
F_745 | STOREENT_ID | SHIPMODE | STOREENT_ID | °è´Ü½Ä |
F_765 | STOREENT_ID | STENCALUSG | STOREENT_ID | °è´Ü½Ä |
F_775 | STOREENT_ID | STORE | STORE_ID | °è´Ü½Ä |
F_779 | STOREENT_ID | STORECAT | STOREENT_ID | °è´Ü½Ä |
F_780 | STOREENT_ID | STORECENT | STOREENT_ID | °è´Ü½Ä |
F_782 | STOREENT_ID | STORECGRP | STOREENT_ID | °è´Ü½Ä |
F_794 | STOREENT_ID | STOREENTDS | STOREENT_ID | °è´Ü½Ä |
F_795 | STOREENT_ID | STOREGRP | STOREGRP_ID | °è´Ü½Ä |
F_796 | STOREENT_ID | STOREITEM | STOREENT_ID | °è´Ü½Ä |
F_799 | STOREENT_ID | STORELANG | STOREENT_ID | °è´Ü½Ä |
F_805 | STOREENT_ID | STORITMFFC | STOREENT_ID | °è´Ü½Ä |
F_816 | STOREENT_ID | TAXCGRY | STOREENT_ID | °è´Ü½Ä |
F_885 | STOREENT_ID | TXCDCLASS | STOREENT_ID | °è´Ü½Ä |
F_887 | STOREENT_ID | URLREG | STOREENT_ID | °è´Ü½Ä |
F_901 | STOREENT_ID | VENDOR | STOREENT_ID | °è´Ü½Ä |
F_907 | STOREENT_ID | VIEWREG | STOREENT_ID | °è´Ü½Ä |
F_926 | STOREENT_ID | REPDLVRY | STOREENT_ID | °è´Ü½Ä |
F_956 | STOREENT_ID | INTVSCHED | STOREENT_ID | °è´Ü½Ä |
F_958 | STOREENT_ID | EMLPROMO | STOREENT_ID | °è´Ü½Ä |
F_965 | STOREENT_ID | EMLCFG | STOREENT_ID | °è´Ü½Ä |
F_967 | STOREENT_ID | EMLUSRRECV | STOREENT_ID | °è´Ü½Ä |
F_973 | STOREENT_ID | EMLMSG | STOREENT_ID | °è´Ü½Ä |