Power BI Connector for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryItemSerialNumbers

InventoryItemSerialNumbers

Columns

Name Type Description
OrganizationId [KEY] Long Value that uniquely identifies the organization.
OrganizationCode String Abbreviation that identifies the organization.
OrganizationName String Name of the organization.
InventoryItemId [KEY] Long Value that uniquely identifies the inventory item.
ItemNumber String Name of the inventory item.
ItemDescription String ItemDescription of InventoryItemSerialNumbers
SerialNumber [KEY] String Serial number that identifies the inventory item.
SubinventoryCode String SubinventoryCode of InventoryItemSerialNumbers
LocatorId Long LocatorId of InventoryItemSerialNumbers
Locator String Locator of InventoryItemSerialNumbers
LotNumber String LotNumber of InventoryItemSerialNumbers
Revision String Revision of InventoryItemSerialNumbers
StatusId Long Value that uniquely identifies the material status.
StatusCode String Abbreviation that identifies the status of the item.
UsageCode String UsageCode of InventoryItemSerialNumbers
Usage String Usage of InventoryItemSerialNumbers
ShippedDate Datetime ShippedDate of InventoryItemSerialNumbers
ReceiptDate Datetime ReceiptDate of InventoryItemSerialNumbers
Allocated String Allocated of InventoryItemSerialNumbers
Reserved String Reserved of InventoryItemSerialNumbers
Supplier String Name of the supplier.
SupplierLot String Number that identifies the supplier lot.
SupplierSerialNumber String Serial number assigned to the item by its supplier.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
BindInventoryItemId Long bindInventoryItemId
BindItemNumber String bindItemNumber
BindLotNumber String bindLotNumber
BindOrganizationCode String bindOrganizationCode
BindSerialNumber String bindSerialNumber
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839