JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryItemLotslotStandardDFF

InventoryItemLotslotStandardDFF

Columns

Name Type Description
InventoryItemLotsInventoryItemId [KEY] Long InventoryItemLotsInventoryItemId of InventoryItemLotslotStandardDFF
InventoryItemLotsLotNumber [KEY] String InventoryItemLotsLotNumber of InventoryItemLotslotStandardDFF
InventoryItemLotsOrganizationId [KEY] Long InventoryItemLotsOrganizationId of InventoryItemLotslotStandardDFF
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 standards.
_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