µ¥ÀÌÅͺ£À̽º Å×À̺í: RECEIPT

°¢ Çà¿¡´Â ¼­ºñ½º ¼¾ÅÍ¿¡¼­ÀÇ °¢ Ç׸ñ ¼ö·É¿¡ ´ëÇÑ Á¤º¸°¡ ÀÖ½À´Ï´Ù.

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
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 °è´Ü½Ä