# DW_NS_inventoryAssignment_F

This fact table contains the more specific details of the items that are involved in inventory impacting transactions such as the associated bin number, corresponding lot/serial number, item status and quantity involved per bin/serial/lot/status of the line item in a transaction.

## Details

Module:

## Key Columns

invassignment_id

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
invassignment_id | NUMBER | 38 | 0 | True | Identifier of the Inventory Assignment associated with the item in a transaction line. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Composite key that consists of all PK values of the transaction. This consists combination of columns that defines the granularity of the table and identifies a row uniquely. |  |
bin | NUMBER | 38 | 0 |  | Identifier of the bin associated with the item in a transaction. |  |
inventorynumber | NUMBER | 38 | 0 |  | The Serial/Lot number from which the picking will be performed. |  |
inventorystatus | NUMBER | 38 | 0 |  | Identifier of the inventory Status associated with the item in a transaction. |  |
packcarton | VARCHAR2 | 999 |  |  | Pack Carton associated with the item in a transaction. |  |
pickcarton | VARCHAR2 | 999 |  |  | Pick Carton associated with the item in a transaction. |  |
quantity | NUMBER |  |  |  | Number or unit count of items used in the transaction. |  |
quantitystaged | NUMBER |  |  |  | This indicates the quantity staged for order processing. |  |
transaction | NUMBER | 38 | 0 |  | The transaction identifier to which a transaction line belongs to. |  |
transactionline | NUMBER | 38 | 0 |  | The transaction line identifier associated to a transaction. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.