Database Table: INVADJUST

This table records adjustments made to inventory.

Column Name Column Type Column Description
ADJUSTMENTCOMMENT VARCHAR (254)
NULL
Comment.
ADJUSTMENTDATE TIMESTAMP
NULL
Timestamp of adjustment.
INVADJCODE_ID BIGINT
NOT NULL
Foreign key to INVADJCODE table to indicate the type of adjustment being done.
INVADJUSTNUM INTEGER
NOT NULL
A number that uniquely identifies this receipt adjustment along with its specified INVADJUST_ID.
INVADJUST_ID BIGINT
NOT NULL
System generated identifier which groups together the RECEIPT rows that were updated during an adjustment.
LASTUPDATE TIMESTAMP
NULL
Timestamp of last update.
QUANTITY INTEGER
NULL
Quantity adjusted for this receipt.
RECEIPT_ID BIGINT
NOT NULL
Indicates the receipt which was adjusted.
Indexes:
Index Name Indexed Column Names Index Type
I0000136 INVADJUST_ID, INVADJCODE_ID, ADJUSTMENTDATE Non-Unique Index
SQL030416034946880 INVADJUST_ID, INVADJUSTNUM Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_391 INVADJCODE_ID INVADJCODE INVADJCODE_ID Cascade
F_392 RECEIPT_ID RECEIPT RECEIPT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable