Database Table: RECEIPT

Each row contains information about each receipt of an item at a FulfillmentCenter.

Column Name Column Type Column Description
COMMENT1 VARCHAR (254)
NULL
Comment.
COMMENT2 VARCHAR (254)
NULL
Comment.
COST DECIMAL (20,5)
NULL
Unit cost.
CREATETIME TIMESTAMP
NOT NULL
The date and time the row was created.
FFMCENTER_ID INTEGER
NOT NULL
FulfillmentCenter where the inventory was received.
LASTUPDATE TIMESTAMP
NULL
Timestamp of last update.
QTYINKITS INTEGER
NOT NULL, DEFAULT 0
Reserved for IBM internal use.
QTYINPROCESS INTEGER
NOT NULL, DEFAULT 0
The quantity allocated to customer orders but not yet released to fulfillment.
QTYONHAND INTEGER
NOT NULL, DEFAULT 0
The current quantity in inventory.
QTYRECEIVED INTEGER
NOT NULL, DEFAULT 0
The quantity received.
RADETAIL_ID BIGINT
NULL
Foreign key to RADETAIL table if the receipt was created from expected inventory.
RECEIPTDATE TIMESTAMP
NOT NULL
Date the inventory was received.
RECEIPTTYPE CHARACTER (4)
NOT NULL, DEFAULT 'ADHC'
Indicates how this receipt was created:
ADHC = AdHoc receipt, EIR = Expected Inventory Receipt, or RTN = returned receipt.
RECEIPT_ID BIGINT
NOT NULL
Unique identifier.
RTNRCPTDSP_ID BIGINT
NULL
Foreign key to RTNRCTPDSP table if the receipt was created from a returned item.
SETCCURR CHARACTER (3)
NULL
Currency of the COST field. This is a currency code as per ISO 4217 standards.
STORE_ID INTEGER
NOT NULL
The Store that owns the inventory.
VENDOR_ID BIGINT
NULL
The vendor that supplied the inventory.
VERSIONSPC_ID BIGINT
NOT NULL
Item identifier.
Indexes:
Index Name Indexed Column Names Index Type
I0000204 VERSIONSPC_ID, FFMCENTER_ID, STORE_ID, CREATETIME Unique Index
I0000205 RECEIPT_ID, RADETAIL_ID, RECEIPTDATE Non-Unique Index
SQL030416035048830 RECEIPT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_660 RADETAIL_ID RADETAIL RADETAIL_ID Cascade
F_661 STORE_ID STORE STORE_ID Cascade
F_662 SETCCURR SETCURR SETCCURR Cascade
F_663 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_664 VENDOR_ID VENDOR VENDOR_ID Cascade
F_665 VERSIONSPC_ID VERSIONSPC VERSIONSPC_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_392 RECEIPT_ID INVADJUST RECEIPT_ID Cascade
F_544 RECEIPT_ID ORDPICKHST RECEIPT_ID Cascade
F_550 RECEIPT_ID ORDSHIPHST RECEIPT_ID Cascade
F_659 RECEIPT_ID RCPTAVAIL RECEIPT_ID Cascade