JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryItemLotslotAttributeDFF

InventoryItemLotslotAttributeDFF

Columns

Name Type Description
InventoryItemLotsInventoryItemId [KEY] Long InventoryItemLotsInventoryItemId of InventoryItemLotslotAttributeDFF
InventoryItemLotsLotNumber [KEY] String InventoryItemLotsLotNumber of InventoryItemLotslotAttributeDFF
InventoryItemLotsOrganizationId [KEY] Long InventoryItemLotsOrganizationId of InventoryItemLotslotAttributeDFF
InventoryItemId [KEY] Long Value that uniquely identifies the inventory item.
OrganizationId [KEY] Long Value that uniquely identifies the organization.
LotNumber [KEY] String Number that identifies the lot.
_FLEX_Context String Descriptive flexfield context name for lot attributes.
_FLEX_Context_DisplayValue String Context Value

Pseudo-Columns

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

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

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