JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryItemSerialNumbersserialAttributeDFF

InventoryItemSerialNumbersserialAttributeDFF

Columns

Name Type Description
InventoryItemSerialNumbersInventoryItemId [KEY] Long InventoryItemSerialNumbersInventoryItemId of InventoryItemSerialNumbersserialAttributeDFF
InventoryItemSerialNumbersOrganizationId [KEY] Long InventoryItemSerialNumbersOrganizationId of InventoryItemSerialNumbersserialAttributeDFF
InventoryItemSerialNumbersSerialNumber [KEY] String InventoryItemSerialNumbersSerialNumber of InventoryItemSerialNumbersserialAttributeDFF
InventoryItemId [KEY] Long Value that uniquely identifies the item.
SerialNumber [KEY] String Serial number that identifies the inventory item.
CurrentOrganizationId [KEY] Long Value that uniquely identifies the organization.
_FLEX_Context String Descriptive flexfield context name for serial number attributes.
_FLEX_Context_DisplayValue String Context Value

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
OrganizationId Long OrganizationId
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