Each row contains information about each receipt of
an item at a FulfillmentCenter.
Column Descriptions:
Name | 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.The value must be a
positive integer, a zero or negative value is invalid |
QTYINPROCESS | INTEGER NOT NULL DEFAULT 0 | The quantity allocated to customer orders but not
yet released to fulfillment. The value must be a positive integer
or zero. Negative values are invalid |
QTYONHAND | INTEGER NOT NULL DEFAULT 0 | The current quantity in inventory. The value must
be a positive integer or zero. Negative values are invalid |
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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | RECEIPT_ID | Primary Key |
I0000204 |
VERSIONSPC_ID+FFMCENTER_ID+STORE_ID+CREATETIME | Unique Index |
I0000205 | RECEIPT_ID+RADETAIL_ID+RECEIPTDATE | Non-Unique Index |
I0000715 | RADETAIL_ID | Non-Unique Index |
I0000716 | FFMCENTER_ID | Non-Unique Index |
I0000717 | STORE_ID | Non-Unique Index |
I0001276 | VENDOR_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | 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 Child Tables:
Constraint | Columns | Child Table | Child Columns | 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 |