Each row contains information about each receipt of an item at a FulfillmentCenter.
Column Descriptions
| Column Name
| Column Type
| Description
|
| RECEIPT_ID
| BIGINT NOT NULL
| Unique identifier.
|
| VERSIONSPC_ID
| BIGINT NOT NULL
| Item identifier.
|
| RADETAIL_ID
| BIGINT
| It is a foreign key to RADETAIL table if the receipt was created from expected inventory.
|
| STORE_ID
| INTEGER NOT NULL
| The Store that owns the inventory.
|
| SETCCURR
| CHAR(3)
| Currency of the COST field. This is a currency code as per ISO 4217 standards.
|
| FFMCENTER_ID
| INTEGER NOT NULL
| FulfillmentCenter where the inventory was received.
|
| VENDOR_ID
| BIGINT
| The vendor that supplied the inventory.
|
| RECEIPTDATE
| TIMESTAMP NOT NULL
| Date the inventory was received.
|
| QTYRECEIVED
| INTEGER NOT NULL DEFAULT 0
| The quantity received.
|
| 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.
|
| QTYINKITS
| INTEGER NOT NULL DEFAULT 0
| Reserved for IBM internal use.
|
| COST
| DECIMAL (20,5)
| Unit cost.
|
| COMMENT1
| VARCHAR(254)
| Comment.
|
| COMMENT2
| VARCHAR(254)
| Comment.
|
| LASTUPDATE
| TIMESTAMP
| Timestamp of last update.
|
| CREATETIME
| TIMESTAMP NOT NULL
| The date and time the row was created.
|
| RECEIPTTYPE
| CHAR(4) NOT NULL DEFAULT 'ADHC'
| Indicates how this receipt was created:
ADHC = AdHoc receipt, EIR = Expected Inventory Receipt, or RTN = returned receipt.
|
| RTNRCPTDSP_ID
| BIGINT
| It is a foreign key to RTNRCTPDSP table if the receipt was created from a returned item.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|