JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHublinespriceValidations

SalesOrdersForOrderHublinespriceValidations

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinespriceValidations
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublinespriceValidations
ChargeDefinitionCode String ChargeDefinitionCode of SalesOrdersForOrderHublinespriceValidations
ChargeDefinition String ChargeDefinition of SalesOrdersForOrderHublinespriceValidations
ChargeId Long ChargeId of SalesOrdersForOrderHublinespriceValidations
ConstrainingValue Double ConstrainingValue of SalesOrdersForOrderHublinespriceValidations
ConstrainingValueTypeCode String ConstrainingValueTypeCode of SalesOrdersForOrderHublinespriceValidations
ConstrainingValueTypeName String ConstrainingValueTypeName of SalesOrdersForOrderHublinespriceValidations
Explanation String Explanation of SalesOrdersForOrderHublinespriceValidations
ExplanationMessageName String ExplanationMessageName of SalesOrdersForOrderHublinespriceValidations
HeaderCurrencyConstrainingAmount Double HeaderCurrencyConstrainingAmount of SalesOrdersForOrderHublinespriceValidations
HeaderCurrencyCode String HeaderCurrencyCode of SalesOrdersForOrderHublinespriceValidations
HeaderCurrencyName String HeaderCurrencyName of SalesOrdersForOrderHublinespriceValidations
ManualPriceAdjustmentId Long ManualPriceAdjustmentId of SalesOrdersForOrderHublinespriceValidations
PricePeriodicityCode String PricePeriodicityCode of SalesOrdersForOrderHublinespriceValidations
PricePeriodicity String PricePeriodicity of SalesOrdersForOrderHublinespriceValidations
PriceValidationId [KEY] Long PriceValidationId of SalesOrdersForOrderHublinespriceValidations
RollupFlag Bool RollupFlag of SalesOrdersForOrderHublinespriceValidations
ValidationComponentEntityType String ValidationComponentEntityType of SalesOrdersForOrderHublinespriceValidations
ValidationComponentCode String ValidationComponentCode of SalesOrdersForOrderHublinespriceValidations
ValidationComponent String ValidationComponent of SalesOrdersForOrderHublinespriceValidations
ValidationComponentEntityId Long ValidationComponentEntityId of SalesOrdersForOrderHublinespriceValidations
ValidationSourceRuleId Long ValidationSourceRuleId of SalesOrdersForOrderHublinespriceValidations
ValidationSourceTypeCode String ValidationSourceTypeCode of SalesOrdersForOrderHublinespriceValidations
ValidationSourceType String ValidationSourceType of SalesOrdersForOrderHublinespriceValidations
ValidationStatus String ValidationStatus of SalesOrdersForOrderHublinespriceValidations
ViolationTypeCode String ViolationTypeCode of SalesOrdersForOrderHublinespriceValidations
ViolationTypeName String ViolationTypeName of SalesOrdersForOrderHublinespriceValidations

Pseudo-Columns

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

Name Type Description
FromDate Date FromDate
HeaderId String HeaderId
OrderKey String OrderKey
OrderNumber String OrderNumber
SourceTransactionNumber String SourceTransactionNumber
SourceTransactionSystem String SourceTransactionSystem
ToDate Date ToDate
Finder String finder

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