Oracle Fusion · Data dictionary
INV_CYCLE_COUNT_ENTRIES
InventoryUsed in 1 subject areas25 reporting columns
Inventory (INV).
Primary key: not yet catalogued for INV_CYCLE_COUNT_ENTRIES, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADJUSTMENT_AMOUNT | ● | Adjustment amount. | |
| ADJUSTMENT_DATE | ● | Adjustment date. | |
| ADJUSTMENT_QUANTITY | ● | Adjustment quantity. | |
| APPROVAL_TYPE | ● | Type of approval. | |
| COUNT_DUE_DATE | ● | Count due date. | |
| COUNT_LIST_SEQUENCE | ● | Count list sequence. | |
| COUNT_QUANTITY | ● | Count quantity. | |
| COUNT_SECONDARY_UOM | ● | Count secondary unit of measure. | |
| COUNT_TYPE_CODE | ● | Code identifying the count type. | |
| COUNT_UOM | ● | Count unit of measure. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CYCLE_COUNT_ENTRY_ID | ● | Identifier for the cycle count entry. | |
| ENTRY_STATUS_CODE | ● | Code identifying the entry status. | |
| EXPORT_FLAG | ● | Indicator (Y/N) for the export. | |
| ITEM_UNIT_COST | ● | Item unit cost. | |
| LOT_NUMBER | ● | Lot number. | |
| NUMBER_OF_COUNTS | ● | Number of counts. | |
| OWNING_TYPE | ● | Type of owning. | |
| PRIMARY_UOM_QUANTITY | ● | Primary unit of measure quantity. | |
| REVISION | ● | Revision. | |
| SECONDARY_ADJUSTMENT_QUANTITY | ● | Secondary adjustment quantity. | |
| SECONDARY_SYSTEM_QTY | ● | Secondary system quantity. | |
| SECONDARY_UOM_QUANTITY | ● | Secondary unit of measure quantity. | |
| SERIAL_NUMBER | ● | Serial number. | |
| SYSTEM_QUANTITY | ● | System quantity. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
Need the extract + dbt staging for INV_CYCLE_COUNT_ENTRIES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table