Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº °èÁ¤ÀÇ ±¸¸ÅÀÚ Á¶Á÷ÀÌ ÆÇ¸ÅÀÚ Á¶Á÷°úÀÇ °Å·¡¿¡ ´ëÇØ Á¤ÀÇÇÏ¿´°Å³ª »ç¿ëÇÑ ±¸¸Å ÁÖ¹® ¹øÈ£¸¦ ³ªÅ¸³À´Ï´Ù. ¹øÈ£´Â °èÁ¤ ³»¿¡¼ °íÀ¯ÇÕ´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
ACCOUNT_ID |
BIGINT
NULL |
±¸¸ÅÀÚ ±¸¸Å ÁÖ¹® ¹øÈ£°¡ ¼ÓÇÏ´Â ºñÁî´Ï½º °èÁ¤ÀÇ ID. ACCOUNT Å×À̺íÀÇ Foreign key. |
AMOUNT |
DECIMAL(20,5)
NULL |
Á¦ÇѵǴ ±¸¸Å ÁÖ¹® ¾ç. |
BUYERPO_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű. |
BUYERPOTYP_ID |
INTEGER
NOT NULL |
±¸¸ÅÀÚ ±¸¸Å ÁÖ¹® ¹øÈ£ÀÇ À¯Çü. BUYERPOTYP Å×ÀÌºí¿¡¼ À¯ÇüÀÌ Á¤Àǵ˴ϴÙ. |
PONUMBER |
VARCHAR (128)
NOT NULL |
±¸¸ÅÀÚ ±¸¸Å ÁÖ¹® ¹øÈ£. |
SETCCURR |
CHARACTER (3)
NULL |
±Ý¾× ÇʵåÀÇ ÅëÈ ISO 4217¿¡ µû¸¥ ¾ËÆÄºª ÅëÈ ÄÚµå. |
STATE |
INTEGER
NULL, DEFAULT 0 |
±¸¸Å ÁÖ¹® ¹øÈ£ÀÇ »óÅÂ: 0=Á¤ÀǵÇÁö ¾ÊÀ½, 1=Ȱ¼ºÈ, ÁÖ¹®¿¡ »ç¿ë °¡´É, 2=Á¾·á, ÁÖ¹®¿¡ »ç¿ëÇÒ ¼ö ¾øÀ½. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
SQL020206020551980 | BUYERPO_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_135 | BUYERPOTYP_ID | BUYERPOTYP | BUYERPOTYP_ID | °è´Ü½Ä |
F_136 | SETCCURR | SETCURR | SETCCURR | °è´Ü½Ä |
F_137 | ACCOUNT_ID | ACCOUNT | ACCOUNT_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_424 | BUYERPO_ID | LPOPURAMT | BUYERPO_ID | °è´Ü½Ä |
F_538 | BUYERPO_ID | ORDPAYMTHD | BUYERPO_ID | °è´Ü½Ä |
![]() |