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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000136 | INVADJUST_ID, INVADJCODE_ID, ADJUSTMENTDATE | Non-Unique Index |
SQL030416034946880 | INVADJUST_ID, INVADJUSTNUM | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|