»õ °í°´ ¸Þ½ÃÁö¿¡´Â CUSTOMER_NEW_HDR010_DATA ¼¼±×¸ÕÆ®°¡ Æ÷ÇԵ˴ϴÙ. ÀÌ µ¥ÀÌÅÍ ¼¼±×¸ÕÆ®´Â »õ °í°´ ¸Þ½ÃÁö¿¡ ´ëÇØ »õ ±¸¸ÅÀÚÀÇ ±¸¸ÅÀÚ Á¤º¸·Î ±¸¼ºµË´Ï´Ù.
CUSTOMER_NEW_HDR010_DATA¿¡ ´ëÇÑ ÇÊµå ¼Ò½º ¹× Æ÷¸ËÀº ´ÙÀ½ Å×ÀÌºí¿¡ ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù. ÇÊµå ±æÀÌ´Â ´ÙÀ½ Å×ÀÌºí¿¡ ³ª¿Í ÀÖ½À´Ï´Ù. µ¥ÀÌÅͺ£À̽º ¿¿¡ ´ëÇÑ ¼³¸íÀº ¿¬°üµÈ Å×ÀÌºí¿¡ ´ëÇÑ ¸µÅ©¸¦ µû¸£½Ê½Ã¿À.
Çʵå À̸§ | Çʵå À¯Çü | Å×À̺í À̸§ | ¿ À̸§ | ÁÖ |
---|---|---|---|---|
NC_HDR010 Version Number |
CHAR (2) | ¾øÀ½ | ¾øÀ½ | 01 °íÁ¤°ª. |
NC_LoginID | CHAR (31) | USERREG | LOGONID | µî·ÏµÈ ±¸¸ÅÀÚÀÇ °íÀ¯ ·Î±×¿Â ID. |
NC_Password | CHAR (12) | USERREG | LOGONPASSWORD | µî·ÏµÈ ±¸¸ÅÀÚÀÇ ¾ÏÈ£ÈµÈ ·Î±×¿Â ¾ÏÈ£ |
NC_Verify Password |
CHAR (12) | ¾øÀ½ | ¾øÀ½ | µî·ÏµÈ ±¸¸ÅÀÚÀÇ ¾ÏÈ£ÈµÈ ·Î±×¿Â ¾ÏÈ£ °ËÁõ. ¸Þ½ÃÁö¸¦ ó¸®ÇÏ·Á¸é ÀÌ ÇʵåÀÇ °ªÀº NC_PasswordÀÇ µ¥ÀÌÅÍ¿Í °°¾Æ¾ß ÇÕ´Ï´Ù. |
NC_Merchant RefNumber |
CHAR (10) | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ |
NC_Method Comm |
CHAR (2) | USERPROF | PREFERREDCOMM | ±¸¸ÅÀÚ°¡ ¼±È£ÇÏ´Â ¿¬¶ô ¹æ¹ý: E1 - ÀüÀÚ ¿ìÆí ¶Ç´Â URL ÁÖ¼Ò 1 E2 - ÀüÀÚ ¿ìÆí ¶Ç´Â URL ÁÖ¼Ò 2 P1 - ÀüȹøÈ£ 1 P2 - ÀüȹøÈ£ 2 |
NC_Challenge Ques |
CHAR (250) | USERREG | CHALLENGEQUESTION | ±¸¸ÅÀÚ ½Å¿øÀ» È®ÀÎÇϱâ À§ÇÑ Áú¹® |
NC_Challenge Ans |
CHAR (250) | USERREG | CHALLENGEANSWER | È®ÀÎ Áú¹®¿¡ ´ëÇÑ ÀÀ´ä |
NC_Shopper Field1 |
CHAR (254) | USERS | FIELD1 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
NC_Shopper Field2 |
CHAR (254) | USERS | FIELD2 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
NC_Title | CHAR (5) | ADDRESS | PERSONTITLE | ±¸¸ÅÀÚÀÇ Á÷À§: Dr Mr Mrs Ms N - Á¦°øµÇÁö ¾ÊÀ½(±âº»°ª) |
NC_Last Name |
CHAR (30) | ADDRESS | LASTNAME | ±¸¸ÅÀÚÀÇ ¼º |
NC_First Name |
CHAR (30) | ADDRESS | FIRSTNAME | ±¸¸ÅÀÚÀÇ À̸§ |
NC_Middle Name |
CHAR (30) | ADDRESS | MIDDLENAME | ±¸¸ÅÀÚÀÇ Áß°£ À̸§ |
NC_Rep Company |
CHAR (80) | ADDRESS | ORGNAME | ±¸¸ÅÀÚ°¡ ¼ÓÇÑ È¸»ç |
NC_Phone1 | CHAR (30) | ADDRESS | PHONE1 | ±¸¸ÅÀÚÀÇ ÀüȹøÈ£ 1 |
NC_Phone2 | CHAR (30) | ADDRESS | PHONE2 | ±¸¸ÅÀÚÀÇ ÀüȹøÈ£ 2 |
NC_Fax | CHAR (30) | ADDRESS | FAX1 | ±¸¸ÅÀÚÀÇ ÆÑ½º ¹øÈ£ |
NC_Addr1 | CHAR (50) | ADDRESS | ADDRESS1 | ±¸¸ÅÀÚÀÇ ÁÖ¼Ò Çà 1 |
NC_Addr2 | CHAR (50) | ADDRESS | ADDRESS2 | ±¸¸ÅÀÚÀÇ ÁÖ¼Ò Çà 2 |
NC_Addr3 | CHAR (50) | ADDRESS | ADDRESS3 | ±¸¸ÅÀÚÀÇ ÁÖ¼Ò Çà 3 |
NC_City | CHAR (30) | ADDRESS | CITY | ±¸¸ÅÀÚÀÇ ±¸/±º/½Ã À̸§ |
NC_State | CHAR (20) | ADDRESS | STATE | ±¸¸ÅÀÚ°¡ °ÅÁÖÇÏ´Â ½Ã/µµ ¶Ç´Â ÀÌ¿¡ »óÀÀÇÏ´Â ¾àÀÚ |
NC_Country | CHAR (30) | ADDRESS | COUNTRY | ±¸¸ÅÀÚÀÇ ±¹°¡/Áö¿ª À̸§ |
NC_ZipCode | CHAR (20) | ADDRESS | ZIPCODE | ±¸¸ÅÀÚÀÇ ¿ìÆí¹øÈ£ ¶Ç´Â ÀÌ¿¡ »óÀÀÇÏ´Â °Í |
NC_Email1 | CHAR (254) | ADDRESS | EMAIL1 | ±¸¸ÅÀÚÀÇ 1Â÷ ÀüÀÚ ¿ìÆí ¶Ç´Â URL ÁÖ¼Ò |
NC_Email2 | CHAR (254) | ADDRESS | EMAIL2 | ±¸¸ÅÀÚÀÇ 2Â÷ ÀüÀÚ ¿ìÆí ¶Ç´Â URL ÁÖ¼Ò |
NC_Day PhoneType |
CHAR(3) | ADDRESS | PHONE1TYPE | û°¢Àå¾ÖÀÚ¸¦ À§ÇÑ ÅÚ·¹Å¸ÀÌÇÁ¶óÀÌÅÍÀÇ °æ¿ì¿¡´Â ÀüÀÚ½Ä, ÀÏ¹Ý ÀüÈÀÇ °æ¿ì¿¡´Â PHN°ú °°Àº ³·½Ã°£ÀÇ ÀüÈ À¯Çü |
NC_Day PhoneList |
CHAR(1) | ADDRESS | PUBLISHPHONE1 | 1 - ÁÖ°£ ÀüȹøÈ£°¡ ³ª¿µË´Ï´Ù. 0 - ÁÖ°£ ÀüȹøÈ£°¡ ³ª¿µÇÁö ¾Ê½À´Ï´Ù. |
NC_Evening PhoneType |
CHAR(3) | ADDRESS | PHONE2TYPE | û°¢Àå¾ÖÀÚ¸¦ À§ÇÑ ÅÚ·¹Å¸ÀÌÇÁ¶óÀÌÅÍÀÇ °æ¿ì¿¡´Â ÀüÀÚ½Ä, ÀÏ¹Ý ÀüÈÀÇ °æ¿ì¿¡´Â PHN°ú °°Àº ¹ã½Ã°£ÀÇ ÀüÈ À¯Çü |
NC_Evening PhoneList |
CHAR(1) | ADDRESS | PUBLISHPHONE2 | 1 - ¾ß°£ ÀüȹøÈ£°¡ ³ª¿µË´Ï´Ù. 0 - ¾ß°£ ÀüȹøÈ£°¡ ³ª¿µÇÁö ¾Ê½À´Ï´Ù. |
NC_BestTime ToCall |
CHAR(1) | ADDRESS | BESTCALLINGTIME | ¼±È£ ¿¬¶ô ½Ã°£ Áö½ÃÀÚ: D - ÁÖ°£ E - ¾ß°£ |
NC_Package Insert |
CHAR(1) | ADDRESS | PACKAGESUPPRESSION | ±¤°í¹° »ðÀÔ ¾ïÁ¦ Ç÷¡±×, ¿î¼ÛµÇ´Â
ÁÖ¹®¿¡ ±¤°í¹°À» Æ÷ÇÔ½ÃŰ´Â °Í¿¡ ´ëÇÑ ±¸¸ÅÀÚÀÇ ¼±È£µµ¸¦
³ªÅ¸³À´Ï´Ù. 1 - Æ÷ÇÔ 0 - Æ÷ÇÔ ¾ÈÇÔ |
NC_Address OptField1 |
CHAR(3) | ADDRESS | FIELD1 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
NC_Address OptField2 |
CHAR(1) | ADDRESS | FIELD2 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
NC_Shopper Gender |
CHAR(1) | USERDEMO | GENDER | ±¸¸ÅÀÚÀÇ ¼º: F - ¿©¼º M - ³²¼º N - Á¦°øµÇÁö ¾ÊÀ½(±âº»°ª) |
NC_Shopper Age |
CHAR (10) | USERDEMO | AGE | ±¸¸ÅÀÚÀÇ ¿¬·É: 0 - Á¦°øµÇÁö ¾ÊÀ½(±âº»°ª) 1 - 0-9¼¼ 2 - 10-19¼¼ 3 - 20-29¼¼ 4 - 30-39¼¼ 5 - 40-49¼¼ 6 - 50-59¼¼ 7 - 60¼¼ ÀÌ»ó |
NC_Shopper Income |
CHAR (10) | USERDEMO | INCOME | ±¸¸ÅÀÚÀÇ °¡Á· ¿¬°£ ¼öÀÔ: 0 - Á¦°øµÇÁö ¾ÊÀ½(±âº»°ª) 1 - 0 - 1,999¸¸¿ø 2 - 2,000 - 3,999¸¸¿ø 3 - 4,000 - 5,999¸¸¿ø 4 - 6,000¸¸¿ø ÀÌ»ó |
NC_Marital Status |
CHAR(1) | USERDEMO | MARITALSTATUS | ±¸¸ÅÀÚÀÇ ¹è¿ìÀÚ À¯¹«: S - ¹ÌÈ¥ M - ±âÈ¥ C - »ç½ÇÈ¥ P - º°°Å D - ÀÌÈ¥ W - »çº° 0 - ±âŸ N - Á¦°øµÇÁö ¾ÊÀ½ |
NC_Number OfChildren |
CHAR (10) | USERDEMO | CHILDREN | ÀÚ³à ¼ö. ±âº»°ªÀº 0ÀÔ´Ï´Ù. |
NC_Number InHouse |
CHAR (10) | USERDEMO | HOUSEHOLD | ±¸¸ÅÀÚÀÇ °¡Á· ¼ö. ±âº»°ªÀº 1ÀÔ´Ï´Ù. |
NC_Shopper Company |
CHAR (30) | USERDEMO | COMPANYNAME | ±¸¸ÅÀÚ°¡ ±Ù¹«Çϴ ȸ»ç. |
NC_Shopper Interest |
CHAR (254) | USERDEMO | HOBBIES | ±¸¸ÅÀÚÀÇ ÁÖ¿ä °ü½É»ç ¹× Ãë¹Ì. |
NC_Previous OrderFlag |
CHAR(1) | USERDEMO | ORDERBEFORE | ±¸¸ÅÀÚ°¡ ÀÌÀü¿¡ ÁÖ¹®À» Á¦ÃâÇÑ ÀûÀÌ ÀÖ´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³»´Â Áö½ÃÀÚ. |
NC_Demog Field1 |
CHAR(1) | USERDEMO | FIELD1 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
NC_Demog Field2 |
CHAR(1) | USERDEMO | FIELD2 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
NC_Demog Field3 |
CHAR(1) | USERDEMO | FIELD3 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
NC_Demog Field4 |
CHAR(1) | USERDEMO | FIELD4 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
NC_Demog Field5 |
CHAR (254) | USERDEMO | FIELD5 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
NC_Demog Field6 |
CHAR (10) | USERDEMO | FIELD6 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
![]() |