µ¥ÀÌÅͺ£À̽º Å×À̺í: 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
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 °è´Ü½Ä
IBM copyright