INV_PHYSICAL_ADJUSTMENTS
INV_PHYSICAL_ADJUSTMENTS contains all the information about the adjustment transactions, including the size of the necessary adjustment, the accounts to which the adjustment transaction was posted, and the approval-status of each transaction. An adjustment of zero will still be stored in this table, although it will not cause an adjustment transaction to be posted. This table will always be correct and consistent with any tags that have been entered in INV_PHYSICAL_INVENTORY_TAGS.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_PHYSICAL_ADJS_PK |
ADJUSTMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ADJUSTMENT_ID | NUMBER | 18 | Yes | Physical inventory adjustment identifier | |
| OWNING_ENTITY_ID | NUMBER | 18 | This identifies the owning entity. | ||
| OWNING_TYPE | VARCHAR2 | 30 | The owning type identifies the type of the entity who owns this quantity, in the context of consignment; the lookup type INV_OWNING_TYPES has the valid values. The record is consigned only if OWNING_TYPE is populated. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | |
| PHYSICAL_INVENTORY_ID | NUMBER | 18 | Yes | Identifier of physical inventory owning the adjustment | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SUBINVENTORY_NAME | VARCHAR2 | 10 | Yes | This is name of the subinventory of adjustment. | |
| SYSTEM_QUANTITY | NUMBER | Yes | This is the frozen quantity of this SKU. | ||
| COUNT_QUANTITY | NUMBER | Quantity of this SKU counted during the physical inventory | |||
| ADJUSTMENT_QUANTITY | NUMBER | Yes | Quantity adjustment required to correct frozen quantity to counted quantity | ||
| ADJUSTMENT_UOM | VARCHAR2 | 3 | Adjustment UOM. Can be either Primary UOM or SPQ UOM | ||
| REVISION | VARCHAR2 | 18 | Revision of item being adjusted | ||
| LOCATOR_ID | NUMBER | 18 | Identifier of locator of this SKU | ||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number of the item being adjusted | ||
| LOT_EXPIRATION_DATE | DATE | Expiration date of the lot number of this adjustment | |||
| SERIAL_NUMBER | VARCHAR2 | 80 | Serial number of the item being adjusted | ||
| ACTUAL_COST | NUMBER | This is cost per unit of this item. | |||
| ADJUSTMENT_AMOUNT | NUMBER | Amount of the financial adjustment that is created due to the difference between the system quantity and the counted quantity. | |||
| APPROVAL_STATUS | VARCHAR2 | 30 | Whether this adjustment has been approved for transaction or not | ||
| APPROVED_BY_EMPLOYEE_ID | NUMBER | 18 | Identifier of employee who approved or rejected this adjustment | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| LOT_SERIAL_CONTROLS | VARCHAR2 | 1 | Dummy column required by AOL for protected decsriptive flexfield | ||
| TEMP_APPROVER | NUMBER | 1 | This dummy column is required for protected descriptive flexfield. | ||
| SECONDARY_SYSTEM_QTY | NUMBER | This is the secondary system quantity. | |||
| SECONDARY_COUNT_QTY | NUMBER | This is the secondary count quantity. | |||
| SECONDARY_ADJUSTMENT_QTY | NUMBER | This is the secondary adjustment quantity. | |||
| INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions | ||
| TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions | ||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions | ||
| INV_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||
| INV_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||
| INV_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||
| INV_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_PHYSICAL_ADJUSTMENTS | inv_physical_inventories | ORGANIZATION_ID, PHYSICAL_INVENTORY_ID |
| INV_PHYSICAL_ADJUSTMENTS | egp_item_org_associations | INVENTORY_ITEM_ID, ORGANIZATION_ID |
| INV_PHYSICAL_ADJUSTMENTS | inv_secondary_inventories | SUBINVENTORY_NAME, ORGANIZATION_ID |
| inv_physical_inventory_tags | inv_physical_adjustments | ADJUSTMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_PHYSICAL_ADJS_N1 | Non Unique | FUSION_TS_TX_IDX | PHYSICAL_INVENTORY_ID, APPROVAL_STATUS |
| INV_PHYSICAL_ADJS_N2 | Non Unique | FUSION_TS_TX_IDX | PHYSICAL_INVENTORY_ID, INVENTORY_ITEM_ID, SUBINVENTORY_NAME |
| INV_PHYSICAL_ADJS_N3 | Non Unique | FUSION_TS_TX_IDX | PHYSICAL_INVENTORY_ID, SUBINVENTORY_NAME, INVENTORY_ITEM_ID |
| INV_PHYSICAL_ADJS_U1 | Unique | FUSION_TS_TX_IDX | ADJUSTMENT_ID |
| INV_PHYSICAL_ADJS_U2 | Unique | FUSION_TS_TX_IDX | ORGANIZATION_ID, PHYSICAL_INVENTORY_ID, ADJUSTMENT_ID |