ShipmentTransactionRequests
ShipmentTransactionRequests
Columns
| Name | Type | Description |
| TransactionId [KEY] | Long | TransactionId of ShipmentTransactionRequests |
| ActionCode | String | Value that uniquely identifies the action to be run for this transaction request. Valid values are CreateAndConfirmShipment, ShipmentCreate, and ShipmentUpdate. |
| TransactionStatusCode | String | TransactionStatusCode of ShipmentTransactionRequests |
| TransactionStatus | String | TransactionStatus of ShipmentTransactionRequests |
| CreatedBy | String | CreatedBy of ShipmentTransactionRequests |
| CreationDate | Datetime | CreationDate of ShipmentTransactionRequests |
| LastUpdatedBy | String | LastUpdatedBy of ShipmentTransactionRequests |
| LastUpdateDate | Datetime | LastUpdateDate of ShipmentTransactionRequests |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Carrier | String | Carrier |
| ExternalSystemTransactionReference | String | ExternalSystemTransactionReference |
| FromActualShipDate | Datetime | FromActualShipDate |
| FromInitialShipDate | Datetime | FromInitialShipDate |
| Item | String | Item |
| ModeOfTransportCode | String | ModeOfTransportCode |
| Order | String | Order |
| PackingUnit | String | PackingUnit |
| ServiceLevelCode | String | ServiceLevelCode |
| ShipFromOrganizationCode | String | ShipFromOrganizationCode |
| Shipment | String | Shipment |
| ShipmentLine | Long | ShipmentLine |
| SoldToCustomer | String | SoldToCustomer |
| ToActualShipDate | Datetime | ToActualShipDate |
| ToInitialShipDate | Datetime | ToInitialShipDate |
| Finder | String | finder |