JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ActiveLocators

ActiveLocators

Columns

Name Type Description
InventoryLocationId [KEY] Long InventoryLocationId of ActiveLocators
Locator String Locator of ActiveLocators
OrganizationId Long OrganizationId of ActiveLocators
OrganizationName String OrganizationName of ActiveLocators
OrganizationCode String OrganizationCode of ActiveLocators
SubinventoryId Long SubinventoryId of ActiveLocators
SubinventoryCode String SubinventoryCode of ActiveLocators
Description String Description of ActiveLocators
DisableDate Date DisableDate of ActiveLocators
InventoryLocationType String InventoryLocationType of ActiveLocators
LocatorType String LocatorType of ActiveLocators
PickingOrder Double PickingOrder of ActiveLocators
StatusId Long StatusId of ActiveLocators
StatusCode String StatusCode of ActiveLocators

Pseudo-Columns

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

Name Type Description
BindItemId Long bindItemId
BindTransactionTypeId Long bindTransactionTypeId
Finder String finder

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