RECEIPT

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

Column Descriptions:

NameTypeDescription
RECEIPT_IDBIGINT NOT NULLUnique identifier.
VERSIONSPC_IDBIGINT NOT NULLItem identifier.
RADETAIL_IDBIGINTIt is a foreign key to RADETAIL table if the receipt was created from expected inventory.
STORE_IDINTEGER NOT NULLThe Store that owns the inventory.
SETCCURRCHAR (3)Currency of the COST field. This is a currency code as per ISO 4217 standards.
FFMCENTER_IDINTEGER NOT NULLFulfillmentCenter where the inventory was received.
VENDOR_IDBIGINTThe vendor that supplied the inventory.
RECEIPTDATETIMESTAMP NOT NULLDate the inventory was received.
QTYRECEIVEDINTEGER NOT NULL DEFAULT 0The quantity received.The value must be a positive integer, a zero or negative value is invalid
QTYINPROCESSINTEGER NOT NULL DEFAULT 0The quantity allocated to customer orders but not yet released to fulfillment. The value must be a positive integer or zero. Negative values are invalid
QTYONHANDINTEGER NOT NULL DEFAULT 0The current quantity in inventory. The value must be a positive integer or zero. Negative values are invalid
QTYINKITSINTEGER NOT NULL DEFAULT 0Reserved for IBM internal use.
COSTDECIMAL (20,5)Unit cost.
COMMENT1VARCHAR (254)Comment.
COMMENT2VARCHAR (254)Comment.
LASTUPDATETIMESTAMPTimestamp of last update.
CREATETIMETIMESTAMP NOT NULLThe date and time the row was created.
RECEIPTTYPECHAR (4) NOT NULL DEFAULT 'ADHC'Indicates how this receipt was created: ADHC = AdHoc receipt, EIR = Expected Inventory Receipt, or RTN = returned receipt.
RTNRCPTDSP_IDBIGINTIt is a foreign key to RTNRCTPDSP table if the receipt was created from a returned item.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RECEIPT_IDPrimary Key
I0000204 VERSIONSPC_ID+FFMCENTER_ID+STORE_ID+CREATETIMEUnique Index
I0000205RECEIPT_ID+RADETAIL_ID+RECEIPTDATENon-Unique Index
I0000715RADETAIL_IDNon-Unique Index
I0000716FFMCENTER_IDNon-Unique Index
I0000717STORE_IDNon-Unique Index
I0001276VENDOR_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_660RADETAIL_IDRADETAILRADETAIL_IDCascade
F_661STORE_IDSTORESTORE_IDCascade
F_662SETCCURRSETCURRSETCCURRCascade
F_663FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_664VENDOR_IDVENDORVENDOR_IDCascade
F_665VERSIONSPC_IDVERSIONSPCVERSIONSPC_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_392RECEIPT_IDINVADJUSTRECEIPT_IDCascade
F_544RECEIPT_IDORDPICKHSTRECEIPT_IDCascade
F_550RECEIPT_IDORDSHIPHSTRECEIPT_IDCascade
F_659RECEIPT_IDRCPTAVAILRECEIPT_IDCascade