SupplyRequestssupplyRequestLinestransferCostRequestDetails
SupplyRequestssupplyRequestLinestransferCostRequestDetails
Columns
| Name | Type | Description |
| SupplyRequestsSupplyOrderReferenceNumber [KEY] | String | SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyRequestLinestransferCostRequestDetails |
| InterfaceBatchNumber | String | Number that identifies the batch of supply requests that are sent to Oracle Supply Chain Orchestration Cloud to create supplies. The batch consists of one or more supply requests. |
| TransferCostAmount | Double | Amount for the transfer cost on a transfer order line. |
| TransferCostCurrencyCode | String | Code that identifies the currency for the transfer cost amount. |
| TransferCostTypeName [KEY] | String | Name of the shipping cost type. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Cost Types task. |
| TransferCostOperation | String | Indicates whether the transfer cost line is to be created, updated, or canceled. Values include CREATE, UPDATE, and CANCEL. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SupplyOrderReferenceNumber | String | SupplyOrderReferenceNumber |
| BindDestOrganizationCode | String | bindDestOrganizationCode |
| BindDocumentNumber | String | bindDocumentNumber |
| BindItemNumber | String | bindItemNumber |
| BindNeedByDate | Datetime | bindNeedByDate |
| BindSupplyOrderNumber | String | bindSupplyOrderNumber |
| BindSupplyOrderReferenceNumber | String | bindSupplyOrderReferenceNumber |
| BindSupplyOrderSource | String | bindSupplyOrderSource |
| BindSupplyRequestDate | Datetime | bindSupplyRequestDate |
| BindSupplyStatus | String | bindSupplyStatus |
| BindSupplyType | String | bindSupplyType |
| Finder | String | finder |