ÀÌ Å×À̺íÀÇ °¢ ÇàÀº »óÁ¡À» ³ªÅ¸³À´Ï´Ù. »óÁ¡Àº StoreEntityÀÔ´Ï´Ù.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
ALLOCATIONGOODFOR | INTEGER NOT NULL, DEFAULT 43200 |
Ãâ°í ¸¸±â ÇÒ´ç ½ºÄÉÁÙ·¯ ÀÛ¾÷ÀÇ »ç¿ë¹ýÀ» ÁöÁ¤ÇÕ´Ï´Ù. ÀÛ¾÷Àº ÇÒ´ç ÀÌÈÄ¿¡ °æ°úÇÑ ½Ã°£(ÃÊ ¼ö)À» ÁöÁ¤ÇÒ ¶§ ATP(Available To Promise) Àç°í ÇÒ´çÀ» µÇµ¹¸± ¼ö ÀÖ½À´Ï´Ù. ÁöÁ¤µÈ ÃÊ ¼ö°¡ 0À̸é, ATP Àç°í ÇÒ´çÀÌ ÀÌ »óÁ¡¿¡¼ »ç¿ëµÇÁö ¾Ê½À´Ï´Ù. ´ë½Å INVENTORY Å×À̺íÀÌ »ç¿ëµË´Ï´Ù. |
AVSACCEPTCODES | VARCHAR (64) NULL |
»óÁ¡ÀÌ ½ÂÀÎ °¡´ÉÇÑ °ÍÀ¸·Î °£ÁÖÇÏ´Â WebSphere Commerce Payments AVS
°á°ú ÄÚµå´Â ´ÙÀ½°ú °°½À´Ï´Ù. 0 = ÁÖ¼Ò ¹× ¿ìÆí¹øÈ£ µÑ ´Ù ÀÏÄ¡ÇÕ´Ï´Ù. 1 = ÁÖ¼Ò´Â ÀÏÄ¡ÇÏÁö¸¸ ¿ìÆí¹øÈ£´Â ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù. 2 = ¿ìÆí¹øÈ£´Â ÀÏÄ¡ÇÏÁö¸¸ ÁÖ¼Ò´Â ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù. 3 = ÁÖ¼Òµµ ¿ìÆí¹øÈ£µµ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù. 4 = AVS °á°ú¸¦ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. 0Àº ÀÌ ¹®ÀÚ¿¿¡ Ç¥½ÃµÇ´Â Áö¿¡ °ü°è¾øÀÌ Ç×»ó ½ÂÀÎ °¡´ÉÇÕ´Ï´Ù. ÀÌ ¿¿¡ ´ëÇÑ Àû¿ë °¡´ÉÇÑ ¸ðµç º¯¼ö´Â VARCHAR Çü½ÄÀ̸ç, ´Ü¼öÀÏ ÇÊ¿ä´Â ¾ø½À´Ï´Ù. ¿¹¸¦ µé¾î, º¯¼ö "14"¿¡¼ 0Àº Àû¿ë °¡´É(0Àº Ç×»ó Àû¿ë °¡´É), 1Àº Àû¿ë °¡´É ±×¸®°í 4´Â Àû¿ë °¡´ÉÀ» ÀǹÌÇÕ´Ï´Ù. WebSphere Commerce Payments AVS Äڵ忡 ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº WebSphere Commerce Payments ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. |
BOPMPADFACTOR | INTEGER NULL, DEFAULT 0 |
»óÁ¡ÀÌ ´Ù¸¥ ¼ºñ½º ¼¾ÅͿʹ ´Ù¸£°Ô ÁÖ¹® ±Ý¾×(¼¼±Ý ¶Ç´Â ¿î¼Û ºñ¿ë°ú °°Àº)À» °è»êÇÒ °æ¿ì, ÀÌÀü¿¡ Á¦ÃâµÈ ÁÖ¹®¿¡ ´ëÇÑ ÁÖ¹® ±Ý¾×Àº ¼ºñ½º ¼¾ÅͰ¡ ÀÌ¿ù ÁÖ¹®µÈ ÁÖ¹® Ç׸ñÀ» À§ÇØ ÇÒ´çµÉ ¶§ º¯°æÇÒ ¼ö ÀÖ½À´Ï´Ù. ä¿ì±â ¿ä¼Ò °ªÀº WebSphere Commerce Payments¿¡ Á¦½ÃµÇ´Â ÁÖ¹® ±Ý¾×À» Áõ°¡½Ãų ¼ö ÀÖ´Â(ÇÊ¿äÇÑ °æ¿ì) ¹éºÐÀ²ÀÔ´Ï´Ù. ¿¹¸¦ µé¾î, 5ÆÛ¼¾Æ®¾¿ Áõ°¡ÇÏ·Á¸é 5¸¦ ÁöÁ¤ÇϽʽÿÀ. |
CRTDBYCNTR_ID | BIGINT NULL |
»óÁ¡À» ÀÛ¼ºÇÏ´Â µ¥ »ç¿ëµÇ´Â Àå±â ±¸¸Å °è¾à. |
DEFAULTBOOFFSET | INTEGER NOT NULL, DEFAULT 7776000 |
ÀÌ¿ù ÁÖ¹®µÈ ÁÖ¹® Ç׸ñ¿¡ ´ëÇØ ¿¹»ó À¯È¿ ½Ã°£À» ÆÇº°ÇÒ ¼ö ¾øÀ» °æ¿ì, ±âº»ÀûÀ¸·Î ÇâÈÄ¿¡ ÀÌ ÃÊ °ªÀ¸·Î ¼³Á¤µË´Ï´Ù. |
DIRECTORY | VARCHAR (254) NULL |
»óÁ¡ °íÀ¯ÀÇ À¥ ÀÚ¿ø(¿¹: JSP ÆÄÀÏ ¹× Ư¼º)ÀÌ ÀÕ´Â µð·ºÅ丮. ÆÄÀÏ ½Ã½ºÅÛ¿¡¼ ÀÌ·¯ÇÑ À¥ ÀÚ¿øµéÀÇ ½ÇÁ¦ À§Ä¡´Â ÀÌ ¿ÀÇ °ª°ú,
WebSphere Commerce ±¸¼º ÆÄÀÏ¿¡¼ÀÇ ÀϺΠ±¸¼º ¸Å°³º¯¼ö(StoresDocRoot, StoresWebPath,
StoresPropertiesPath)¸¦ ±âÃÊ·Î °áÁ¤µË´Ï´Ù. ¿¹¸¦ µé¸é, StoresDocRoot°¡ D:\WebSphere\CommerceServer\storesÀ̰í, StoresWebPath°¡ webÀ̸ç, StorePropertiesPath°¡ propertiesÀ̰í, ÀÌ ¿ÀÇ °ªÀÌ mystoreÀ̸é, JSP ÆÄÀÏÀÌ µð·ºÅ丮¿¡ À§Ä¡ÇÕ´Ï´Ù. D:\WebSphere\CommerceServer\stores\web\mystore ¹× Ư¼º ÆÄÀϵéÀº D:\WebSphere\CommerceServer\stores\properties\mystore¿¡ ÀÖ°Ô µË´Ï´Ù. |
FFMCENTER_ID | INTEGER NULL |
»óÁ¡¿¡ ´ëÇÑ ±âº» ¼ºñ½º ¼¾ÅÍ. |
FFMCSELECTIONFLAGS | INTEGER NOT NULL, DEFAULT 0 |
»óŰ¡ "B"ÀÎ OrderItem¿¡ ´ëÇÑ FulfillmentCenter ¼±Åÿ¡
°ü·ÃµÇ´Â GetEligibleFulfillmentCenterÀÇ ±âº» ±¸Çö¿¡¼ »ç¿ëµÇ´Â Á¤Ã¥À» ÁöÁ¤ÇÏ´Â
ºñÆ® Ç÷¡±×°¡ µé¾î ÀÖ½À´Ï´Ù. 1 = preferCurrent - ÇöÀç ÁöÁ¤µÈ FulfillmentCenter(ÀÖ´Â °æ¿ì)¿¡ ȯ°æ¼³Á¤À» ºÎ¿©ÇÕ´Ï´Ù. 2 = noChange - ÇöÀç ÁöÁ¤µÈ FulfillmentCenter(ÀÖ´Â °æ¿ì)¸¦ º¯°æÇÏÁö ¾Ê½À´Ï´Ù. |
FIELD1 | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
FIELD2 | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
LANGUAGE_ID | INTEGER NULL |
»óÁ¡¿¡¼ °í°´ ¼îÇο¡ ´ëÇØ Ç¥½ÃµÈ Á¤º¸¿¡ ´ëÇÑ ±âº» ¾ð¾î. ¾ð¾î ±¸¼º¿ä¼Ò´Â LANGUAGE Å×À̺íÀ» ÂüÁ¶ÇϽʽÿÀ. |
LASTUPDATESTATUS | TIMESTAMP NULL |
»óÁ¡ÀÇ »óŰ¡ ¸¶Áö¸·À¸·Î °»½ÅµÈ ½Ã°£À» ³ªÅ¸³À´Ï´Ù. |
MAXBOOFFSET | INTEGER NOT NULL, DEFAULT 7776000 |
ÀÌ¿ù ÁÖ¹®µÈ ÁÖ¹® Ç׸ñÀÇ ¿¹»ó »ç¿ë °¡´ÉÇÑ ½Ã°£ÀÌ ÇöÀç °ªÀÌ ¼³Á¤µÈ ÀÌÈÄ¿¡ ÀÌ °ªÀ» ÃʰúÇÒ °æ¿ì, ¿¹»ó »ç¿ë °¡´ÉÇÑ ½Ã°£Àº ¾ÕÀ¸·Î ÃʰúµÇ°Ô µÇ´Â ½Ã°£(ÃÊ)À¸·Î ÀÚµ¿À¸·Î ¼³Á¤µË´Ï´Ù. °á°úÀûÀ¸·Î, ¿©±â¿¡¼ ÁöÁ¤ÇÑ ½Ã°£º¸´Ù ´õ ±æ°Ô Ç׸ñÀ» ÀÌ¿ù ÁÖ¹®ÇÒ ¼ö ¾ø½À´Ï´Ù. |
OID | CHARACTER (32) NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à.. |
PRICEREFFLAGS | INTEGER NOT NULL, DEFAULT 0 |
GetContractunitPrices ŽºÅ© ¸í·ÉÀÇ ±âº» ±¸Çö¿¡ ÀÇÇØ °¡°ÝÀ» »õ·Î °íÄ¥ ¶§
°Ë»öÇÏ´Â TradingAgreement ¹× Offer¸¦ Á¦¾îÇÏ´Â ºñÆ® Ç÷¡±×°¡ µé¾î
ÀÖ½À´Ï´Ù. 1 = usePreviousOnly - OrderItem¿¡¼ ÂüÁ¶ÇÏ´Â °ÍÀ» »ç¿ëÇÕ´Ï´Ù. ´õÀÌ»ó »ç¿ëÇÒ ¼ö ¾øÀ» °æ¿ì ½ÇäÇÕ´Ï´Ù. 2 = usePreviousOrSearchAgain - usePreviousOnly¿Í °°Áö¸¸, ´õÀÌ»ó »ç¿ëÇÒ ¼ö ¾øÀ» ¶§ ½ÇÆÐÇÏ´Â ´ë½Å ORDIOFFER ¹× ORDITRD Å×ÀÌºí¿¡ ÀúÀåÇÑ °ÍÀ» °Ë»öÇÕ´Ï´Ù. 4 = alwaysSearchAgain - Ç×»ó ORDIOFFER ¹× ORDITRD Å×ÀÌºí¿¡ ÀúÀåµÈ °ÍÀ» °Ë»öÇÕ´Ï´Ù. |
QUOTEGOODFOR | INTEGER NULL, DEFAULT 43200 |
ÁÖ¹®ÀÌ ÁغñµÈ ÈÄ ÀÌ Ãʰ¡ °æ°úÇϸé, °í°´ÀÌ ¾ÆÁ÷ ÁöºÒ È®¾àÇÏÁö ¾ÊÀº ÁÖ¹®¿¡ ´ëÇØ OrderProcess°¡ ½ÇÇàµÉ ¶§ ÁÖ¹® °¡°Ý ¹× ±âŸ ±Ý¾×ÀÌ º¯°æµÉ ¼ö ÀÖ½À´Ï´Ù. |
REJECTEDORDEXPIRY | INTEGER NULL, DEFAULT 259200 |
ÀÌ ÃÊ ¼öº¸´Ù ±ä ¼èÅð »óÅ¿¡ ÀÖ´Â ÁöºÒÀ» °¡Áö°í ÀÖ´Â ÁÖ¹®ÀÌ Ãë¼Ò Èĺ¸ÀÔ´Ï´Ù. |
RMAGOODFOR | INTEGER NULL, DEFAULT 86400 |
¹Ýǰ »óǰ ±ÇÇÑ(RMA) °è»êÀÌ À¯ÀÍÇÑ ÃÊ ´ÜÀ§ÀÇ ±â°£. MA°¡ ¿Ï·áµÇ±â Àü¿¡ ÀÌ ±â°£ÀÌ °æ°úÇÏ¸é ºñ¿ë ¶Ç´Â ´ëº¯ ¹× ½ÂÀÎÀÌ ´Ù½Ã °è»êµË´Ï´Ù. |
RTNFFMCTR_ID | INTEGER NULL |
»óÁ¡¿¡ »óǰÀ» ¹ÝǰÇϱâ À§ÇÑ ±âº» ¼ºñ½º ¼¾ÅÍ |
STATUS | INTEGER NOT NULL, DEFAULT 1 |
»óÁ¡ÀÇ »óŸ¦ ³ªÅ¸³À´Ï´Ù. 1 = ¿¸² 0 = ´ÝÈû -1 = ÀϽÃÁß´Ü |
STORECGRY_ID | INTEGER NULL |
ÀÌ »óÁ¡¿¡ ´ëÇÑ StoreCategory(ÀÖÀ» °æ¿ì). |
STOREGRP_ID | INTEGER NOT NULL |
ÀÌ »óÁ¡¿¡ ´ëÇÑ StoreGroup. |
STORELEVEL | CHARACTER (10) NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à.. |
STORETYPE | CHARACTER (3) NULL |
StoreType¿¡ µû¶ó ÀûÀýÇÑ ±â´ÉÀ» Á¦°øÇÏ´Â ´ÙÀ½°ú °°Àº »ç¿ëÀÚ ÀÎÅÍÆäÀ̽º¿ë
StoreType Áß Çϳª¸¦ ³ªÅ¸³À´Ï´Ù. B2B = Business to Business. B2C = Business to Consumer. CHS = Reseller Hub. CPS = Master Catalog Profile Store. RHS = Reseller Hosted Store. RPS = Reseller Profile Store. DPS = Distributor Profile Store. DPX = Distributor Proxy Store. HCP = Commerce Hosting Hub. PBS = Store Directory. MPS = Merchant Profile Store. MHS = Merchant Hosted Store. SCP = Supplier Hub. SPS = Supplier Profile Store. SHS = Supplier Hosted Store. |
STORE_ID | INTEGER NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű. |
»öÀÎ À̸§ | »öÀÎÈµÈ ¿ À̸§ | »öÀÎ À¯Çü |
---|---|---|
SQL030416035111720 | STORE_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_772 | RTNFFMCTR_ID | FFMCENTER | FFMCENTER_ID | °è´Ü½Ä |
F_773 | STORECGRY_ID | STORECGRY | STORECGRY_ID | °è´Ü½Ä |
F_774 | STOREGRP_ID | STOREGRP | STOREGRP_ID | °è´Ü½Ä |
F_775 | STORE_ID | STOREENT | STOREENT_ID | °è´Ü½Ä |
F_776 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | °è´Ü½Ä |
F_777 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | °è´Ü½Ä |
F_925 | CRTDBYCNTR_ID | CONTRACT | CONTRACT_ID | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_1020 | STORE_ID | RFQTARGET | STORE_ID | °è´Ü½Ä |
F_103 | STORE_ID | AUTOBIDLOG | STORE_ID | °è´Ü½Ä |
F_113 | STORE_ID | BID | STORE_ID | °è´Ü½Ä |
F_119 | STORE_ID | BIDLOG | STORE_ID | °è´Ü½Ä |
F_191 | STORE_ID | CATENCALCD | STORE_ID | °è´Ü½Ä |
F_211 | STORE_ID | CATGPCALCD | STORE_ID | °è´Ü½Ä |
F_23 | STORE_ID | ACCOUNT | STORE_ID | °è´Ü½Ä |
F_258 | STORE_ID | CPENDORDER | STOREENT_ID | °è´Ü½Ä |
F_308 | STORE_ID | DISTARRANG | WHOLESALESTORE_ID | °è´Ü½Ä |
F_309 | STORE_ID | DISTARRANG | MERCHANTSTORE_ID | °è´Ü½Ä |
F_311 | STORE_ID | ECEOUT | STORE_ID | °è´Ü½Ä |
F_393 | STORE_ID | INVENTORY | STORE_ID | °è´Ü½Ä |
F_403 | STORE_ID | ITEMFFMCTR | STORE_ID | °è´Ü½Ä |
F_462 | STORE_ID | MOPICONFIG | STORE_ID | °è´Ü½Ä |
F_578 | STORE_ID | PAYSTATUS | STORE_ID | °è´Ü½Ä |
F_623 | STORE_ID | PROFILE | STORE_ID | °è´Ü½Ä |
F_650 | STORE_ID | RA | STORE_ID | °è´Ü½Ä |
F_661 | STORE_ID | RECEIPT | STORE_ID | °è´Ü½Ä |
F_677 | STORE_ID | RFQ | STORE_ID | °è´Ü½Ä |
F_697 | STORE_ID | RMA | STORE_ID | °è´Ü½Ä |
F_748 | STORE_ID | SHPARRANGE | STORE_ID | °è´Ü½Ä |
F_784 | STORE_ID | STORECNTR | STORE_ID | °è´Ü½Ä |
F_786 | STORE_ID | STOREDEF | STORE_ID | °è´Ü½Ä |
F_802 | STORE_ID | STOREMBRGP | STORE_ID | °è´Ü½Ä |
F_803 | STORE_ID | STORETRANS | STORE_ID | °è´Ü½Ä |
F_859 | STORE_ID | TFTRADENG | STORE_ID | °è´Ü½Ä |
F_911 | STORE_ID | WTAXINFO | STORE_ID | °è´Ü½Ä |
F_916 | STORE_ID | STOREREL | STORE_ID | °è´Ü½Ä |
F_917 | STORE_ID | STOREREL | RELATEDSTORE_ID | °è´Ü½Ä |
F_93 | STORE_ID | AUCTSTRREL | STORE_ID | °è´Ü½Ä |
F_930 | STORE_ID | SHPMODCLCD | STORE_ID | °è´Ü½Ä |
F_934 | STORE_ID | ORDQUOTREL | CHILDSTORE_ID | °è´Ü½Ä |
F_936 | STORE_ID | USRTRAFFIC | STORE_ID | °è´Ü½Ä |
F_943 | STORE_ID | MASSOCCECE | STORE_ID | °è´Ü½Ä |
F_944 | STORE_ID | MASSOCGPGP | STORE_ID | °è´Ü½Ä |
F_945 | STORE_ID | CATGRPTPC | STORE_ID | °è´Ü½Ä |
F_946 | STORE_ID | ICMETAFEAT | STOREID | °è´Ü½Ä |
F_947 | STORE_ID | ICMETAPHOR | STOREID | °è´Ü½Ä |
F_951 | STORE_ID | QUEUE | STORE_ID | °è´Ü½Ä |
F_970 | STORE_ID | ICMERTREE | STOREID | °è´Ü½Ä |
F_971 | STORE_ID | ICKNOWLEDG | STOREID | °è´Ü½Ä |
F_986 | STORE_ID | FILEUPLOAD | STORE_ID | °è´Ü½Ä |
F_99 | STORE_ID | AUTOBID | STORE_ID | °è´Ü½Ä |