°¢ Çà¿¡´Â ¼ºñ½º ¼¾ÅÍ¿¡¼ÀÇ °¢ Ç׸ñ ¼ö·É¿¡ ´ëÇÑ Á¤º¸°¡ ÀÖ½À´Ï´Ù.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
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. |
RECEIPTDATE | TIMESTAMP NOT NULL |
Àç°í°¡ ¼ö·ÉµÈ ³¯Â¥. |
RECEIPTTYPE | CHARACTER (4) NOT NULL, DEFAULT 'ADHC' |
ÀÌ ¼ö·ÉÀÇ ÀÛ¼º ¹æ½ÄÀ» ³ªÅ¸³À´Ï´Ù. ADHC = Àӽà ¼ö·É, EIR = ¿¹»ó Àç°í ¼ö·É ¶Ç´Â RTN = ¹Ýǰ ¼ö·É. |
RECEIPT_ID | BIGINT NOT NULL |
°íÀ¯ ½Äº°ÀÚ. |
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 | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL030416035048830 | RECEIPT_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
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 | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
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 | °è´Ü½Ä |