Å×ÀÌºí ¼³¸í:
°¢ Çà¿¡´Â ¼ºñ½º ¼¾ÅÍ¿¡¼ÀÇ °¢ Ç׸ñ ¼ö·É¿¡ ´ëÇÑ Á¤º¸°¡ ÀÖ½À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
COMMENT1 |
VARCHAR (254)
NULL |
¼³¸í |
COMMENT2 |
VARCHAR (254)
NULL |
¼³¸í |
COST |
DECIMAL(20,5)
NULL |
ºñ¿ë ´ÜÀ§ |
CREATETIME |
TIMESTAMP
NOT NULL |
ÇàÀÌ ÀÛ¼ºµÈ ³¯Â¥ ¹× ½Ã°£. |
FFMCENTER_ID |
INTEGER
NOT NULL |
Àç°í°¡ ¼ö·ÉµÈ ¼ºñ½º ¼¾ÅÍ |
LASTUPDATE |
TIMESTAMP
NULL |
¸¶Áö¸·À¸·Î °»½ÅµÈ ½Ã°£¼ÒÀÎ |
QTYINKITS |
INTEGER
NOT NULL, DEFAULT 0 |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
QTYINPROCESS |
INTEGER
NOT NULL, DEFAULT 0 |
°í°´ ÁÖ¹®¿¡ ÇÒ´çµÇ¾úÁö¸¸ ¼ºñ½º ¼¾ÅÍ·Î ¾ÆÁ÷ Ãâ°íµÇÁö ¾ÊÀº ¼ö·® |
QTYONHAND |
INTEGER
NOT NULL, DEFAULT 0 |
ÇöÀç Àç°í ¼ö·® |
QTYRECEIVED |
INTEGER
NOT NULL, DEFAULT 0 |
¼ö·ÉµÈ ¼ö·® |
RADETAIL_ID |
BIGINT
NULL |
¿¹»ó Àç°í·ÎºÎÅÍ ¼ö·ÉÀÌ ÀÛ¼ºµÈ °æ¿ì RADETAIL Å×ÀÌºí¿¡ ´ëÇÑ foreign key |
RECEIPT_ID |
BIGINT
NOT NULL |
°íÀ¯ ½Äº°ÀÚ |
RECEIPTDATE |
TIMESTAMP
NOT NULL |
Àç°í°¡ ¼ö·ÉµÈ ³¯Â¥ |
RECEIPTTYPE |
CHARACTER (4)
NOT NULL, DEFAULT 'ADHC' |
ÀÌ ¼ö·ÉÀÇ ÀÛ¼º ¹æ½ÄÀ» ³ªÅ¸³À´Ï´Ù. ADHC = Àӽà ¼ö·É, EIR = ¿¹»ó Àç°í ¼ö·É ¶Ç´Â RTN = ¹Ýǰ ¼ö·É. |
RTNRCPTDSP_ID |
BIGINT
NULL |
¹Ýǰ Ç׸ñÀ¸·ÎºÎÅÍ ¼ö·ÉÀÌ ÀÛ¼ºµÈ °æ¿ì RTNRCTPDSP Å×ÀÌºí¿¡ ´ëÇÑ foreign key |
SETCCURR |
CHARACTER (3)
NULL |
COST ÇʵåÀÇ ÅëÈ ISO 4217 Ç¥ÁØ¿¡ ¸Â´Â ÅëÈ ÄÚµå. |
STORE_ID |
INTEGER
NOT NULL |
Àç°í¸¦ °¡Áö°í ÀÖ´Â »óÁ¡ |
VENDOR_ID |
BIGINT
NULL |
Àç°í¸¦ °ø±ÞÇÑ °ø±Þ¾÷ü |
VERSIONSPC_ID |
BIGINT
NOT NULL |
½Äº°ÀÚ Ç׸ñ |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000204 | VERSIONSPC_ID, FFMCENTER_ID, STORE_ID, CREATETIME | °íÀ¯ »öÀÎ |
I0000205 | RECEIPT_ID, RADETAIL_ID, RECEIPTDATE | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020206020733660 | RECEIPT_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_660 | RADETAIL_ID | RADETAIL | RADETAIL_ID | °è´Ü½Ä |
F_661 | STORE_ID | STORE | STORE_ID | °è´Ü½Ä |
F_662 | SETCCURR | SETCURR | SETCCURR | °è´Ü½Ä |
F_663 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | °è´Ü½Ä |
F_664 | VENDOR_ID | VENDOR | VENDOR_ID | °è´Ü½Ä |
F_665 | VERSIONSPC_ID | VERSIONSPC | VERSIONSPC_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_392 | RECEIPT_ID | INVADJUST | RECEIPT_ID | °è´Ü½Ä |
F_544 | RECEIPT_ID | ORDPICKHST | RECEIPT_ID | °è´Ü½Ä |
F_550 | RECEIPT_ID | ORDSHIPHST | RECEIPT_ID | °è´Ü½Ä |
F_659 | RECEIPT_ID | RCPTAVAIL | RECEIPT_ID | °è´Ü½Ä |
![]() |