This table records adjustments made to inventory.
Column Description(s):
Column Name | Column Type | Description |
INVADJUST_ID |
BIGINT NOT NULL |
System generated identifier which groups together the RECEIPT rows that were updated during an adjustment. |
INVADJUSTNUM |
INTEGER NOT NULL |
A number that uniquely identifies this receipt adjustment along with its specified INVADJUST_ID. |
INVADJCODE_ID |
BIGINT NOT NULL |
Foreign key to INVADJCODE table to indicate the type of adjustment being done. |
RECEIPT_ID |
BIGINT NOT NULL |
Indicates the receipt which was adjusted. |
ADJUSTMENTDATE |
TIMESTAMP |
Timestamp of adjustment. |
QUANTITY |
INTEGER |
Quantity adjusted for this receipt. |
ADJUSTMENTCOMMENT |
VARCHAR(254) |
Comment. |
LASTUPDATE |
TIMESTAMP |
Timestamp of last update. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031233880 |
INVADJUST_ID+INVADJUSTNUM |
Primary Key |
I0000136 |
INVADJUST_ID+INVADJCODE_ID+ADJUSTMENTDATE |
Non-Unique Index |
I0000592 |
RECEIPT_ID |
Non-Unique Index |
I0000593 |
INVADJCODE_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_391 |
INVADJCODE_ID |
INVADJCODE |
INVADJCODE_ID |
Cascade |
F_392 |
RECEIPT_ID |
RECEIPT |
RECEIPT_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.