CUSTOMER_UPDATE_HDR010_DATA

°í°´ °»½Å ¸Þ½ÃÁö¿¡´Â CUSTOMER_UPDATE_HDR010_DATA ¼¼±×¸ÕÆ®°¡ Æ÷ÇԵ˴ϴÙ. ÀÌ µ¥ÀÌÅÍ ¼¼±×¸ÕÆ®´Â °í°´ °»½Å ¸Þ½ÃÁö¿¡ ´ëÇØ µî·ÏµÈ ±¸¸ÅÀÚÀÇ Á¤º¸·Î ±¸¼ºµË´Ï´Ù.

CUSTOMER_UPDATE_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 ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à

°ü·Ã °³³ä

°ü·ÃµÈ ÂüÁ¶

IBM copyright