JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryOrganizations

InventoryOrganizations

Columns

Name Type Description
OrganizationId [KEY] Long OrganizationId of InventoryOrganizations
OrganizationCode String OrganizationCode of InventoryOrganizations
OrganizationName String OrganizationName of InventoryOrganizations
ManagementBusinessUnitId Long ManagementBusinessUnitId of InventoryOrganizations
ManagementBusinessUnitName String ManagementBusinessUnitName of InventoryOrganizations
LegalEntityId Long LegalEntityId of InventoryOrganizations
LegalEntityName String LegalEntityName of InventoryOrganizations
ProfitCenterBusinessUnitId Long ProfitCenterBusinessUnitId of InventoryOrganizations
ProfitCenterBusinessUnitName String ProfitCenterBusinessUnitName of InventoryOrganizations
Status String Status of InventoryOrganizations
LocationId Long LocationId of InventoryOrganizations
LocationCode String LocationCode of InventoryOrganizations
InventoryFlag Bool InventoryFlag of InventoryOrganizations
ManufacturingPlantFlag Bool ManufacturingPlantFlag of InventoryOrganizations
ContractManufacturingFlag Bool ContractManufacturingFlag of InventoryOrganizations
MaintenanceEnabledFlag Bool MaintenanceEnabledFlag of InventoryOrganizations
MasterOrganizationId Long MasterOrganizationId of InventoryOrganizations
MasterOrganizationCode String MasterOrganizationCode of InventoryOrganizations
MasterOrganizationName String MasterOrganizationName of InventoryOrganizations
IntegratedSystemType String IntegratedSystemType of InventoryOrganizations
ItemGroupingCode String ItemGroupingCode of InventoryOrganizations
ItemDefinitionOrganizationId Long ItemDefinitionOrganizationId of InventoryOrganizations
ItemDefinitionOrganizationCode String ItemDefinitionOrganizationCode of InventoryOrganizations
ItemDefinitionOrganizationName String ItemDefinitionOrganizationName of InventoryOrganizations
ManufacturingParametersExistFlag Bool ManufacturingParametersExistFlag of InventoryOrganizations
CreatedBy String CreatedBy of InventoryOrganizations
CreationDate Datetime CreationDate of InventoryOrganizations
LastUpdatedBy String LastUpdatedBy of InventoryOrganizations
LastUpdateDate Datetime LastUpdateDate of InventoryOrganizations
FixedAssetCorporateBookTypeCode String FixedAssetCorporateBookTypeCode of InventoryOrganizations

Pseudo-Columns

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

Name Type Description
Finder String finder

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