JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

TransferOrders

TransferOrders

Columns

Name Type Description
HeaderId [KEY] Long HeaderId of TransferOrders
HeaderNumber String HeaderNumber of TransferOrders
Description String Description of TransferOrders
RequisitionBUId Long RequisitionBUId of TransferOrders
BusinessUnitName String BusinessUnitName of TransferOrders
SourceTypeLookup String SourceTypeLookup of TransferOrders
SourceOfTransferOrder String SourceOfTransferOrder of TransferOrders
OrderedDate Datetime OrderedDate of TransferOrders
FulfillOrchestrationRequired String FulfillOrchestrationRequired of TransferOrders
BudgetControlEnabled String BudgetControlEnabled of TransferOrders
InterfaceStatus String InterfaceStatus of TransferOrders
MessageText String MessageText of TransferOrders

Pseudo-Columns

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

Name Type Description
Finder String finder
PBatch String pBatch
PDestinationOrganization String pDestinationOrganization
PItemNumber String pItemNumber
PLineNumber String pLineNumber
PLineStatus String pLineStatus
PScheduledShipDate Datetime pScheduledShipDate
PSourceOrganization String pSourceOrganization
PTransactionOrigin String pTransactionOrigin
PTransferOrder String pTransferOrder

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