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. |
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 |
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 |
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 |