This table records adjustments made to inventory.
Column Descriptions
| 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.
|