ShipmentLineTransactionRequests
ShipmentLineTransactionRequests
Columns
| Name | Type | Description |
| TransactionId [KEY] | Long | TransactionId of ShipmentLineTransactionRequests |
| ActionCode | String | Value that uniquely identifies the action to be run for this transaction request. Valid values are CREATE, UPDATE, CANCEL, StagingCreate, StagingUpdate, StagingCancel, TPUpdate, TPDelete, Lock, ValidateAndLock, and ReleaseLock. |
| TransactionStatusCode | String | TransactionStatusCode of ShipmentLineTransactionRequests |
| TransactionStatus | String | TransactionStatus of ShipmentLineTransactionRequests |
| DocumentNumber | String | Number that identifies the document for the shipment line transaction request. |
| SourceSystemId | Long | Value that uniquely identifies the source application. |
| SourceSystem | String | Name of the source application. |
| OrderTypeCode | String | Abbreviation the identifies the type of source document. The default value is SALES_ORDER. A list of accepted values is defined in the lookup ORA_WSH_ORDER_LINE_TYPE. |
| Order | String | Number that identifies the sales order in the order capture application. |
| SourceOrder | String | Number that identifies the source order header. |
| LogisticsServiceProviderCustomerId | Long | Value that uniquely identifies the logistics service provider customer. |
| LogisticsServiceProviderCustomer | String | Name of the logistics service provider customer who sent the order lines in this transaction request.. |
| LogisticsServiceProviderCustomerNumber | String | Number that identifies the logistics service provider customer who sent the order lines in this transaction request. |
| ShipToPartyId | Long | Value that uniquely identifies the ship-to party of all the shipment lines in this transaction request. |
| ShipToCustomer | String | Name of the party who will receive the sales order line that ships. |
| ShipToCustomerNumber | String | Number that identifies the ship-to party of all the shipment lines in this transaction request. |
| ShipToPartySiteId | Long | Value that uniquely identifies the ship-to party site of all the shipment lines in this transaction request. |
| ShipToPartySiteNumber | String | Number that identifies the ship-to party site of all the shipment lines in this transaction request. |
| ShipToContactId | Long | Value that uniquely identifies the contact at the ship-to location. |
| ShipToContact | String | Person to contact at the ship-to customer site. |
| ShipToContactNumber | String | Number that identifies the person to contact at the ship-to customer for all the shipment lines in this transaction request. |
| SoldToPartyId | Long | Value that uniquely identifies the sold-to party of all the shipment lines in this transaction request. |
| SoldToCustomer | String | Name of the party who purchased the sales order lines in this transaction request. |
| SoldToCustomerNumber | String | Number that identifies the sold-to party. |
| SoldToContactId | Long | Value that uniquely identifies the sold-to contact for all the shipment line in this transaction request. |
| SoldToContact | String | Person to contact at the sold-to customer site. |
| SoldToContactNumber | String | Number that identifies the person to contact at the sold-to customer for all the shipment lines in this transaction request. |
| BillToPartyId | Long | Value that uniquely identifies the bill-to party of all the shipment lines in this transaction request. |
| BillToCustomer | String | Name of the party to bill for all the sales order lines in this transaction request. |
| BillToCustomerNumber | String | Number that identifies the person to be contacted for the billing details. |
| BillToPartySiteId | Long | Value that uniquely identifies the bill-to party site of all the shipment lines in this transaction request. |
| BillToPartySiteNumber | String | Number that identifies the bill-to party site. |
| BillToContactId | Long | Value that uniquely identifies the bill-to contact of all the shipment lines in this transaction request. |
| BillToContact | String | Person to contact at the bill-to customer site. |
| BillToContactNumber | String | Number that identifies the person to contact at the bill-to customer for all the shipment lines in this transaction request. |
| OrganizationId | Long | Value that uniquely identifies the inventory organization. |
| OrganizationCode | String | Abbreviation that identifies the ship-from organization. |
| OrganizationName | String | Name of the inventory organization. |
| ShipFromLocationId | Long | Value that uniquely identifies the ship-from location for all the shipment lines in this transaction request. |
| CarrierId | Long | Value that uniquely identifies the carrier for all the shipment lines in this transaction request. |
| Carrier | String | Name of the carrier that transports the shipment containing all the shipment lines in this transaction request. |
| CarrierNumber | String | Number that identifies the carrier. |
| ModeOfTransportCode | String | Abbreviation that identifies the mode of transport for the shipping method. A list of accepted values is defined in the lookup WSH_MODE_OF_TRANSPORT. |
| ServiceLevelCode | String | Abbreviation that identifies the service level for the shipping method. A list of accepted values is defined in the lookup WSH_SERVICE_LEVELS. |
| FOBCode | String | Abbreviation that identifies ownership of the items that are in transit. A list of acceptable values is defined in the lookup FOB. |
| FreightTermsCode | String | Abbreviation that identifies the agreement that describes whether the buyer or seller pays the shipping cost of the sales order and when is the payment due. A list of acceptable values is defined in the lookup WSH_FREIGHT_CHARGE_TERMS. |
| Currency | String | Abbreviation that identifies the currency of all the shipment lines in this transaction request. |
| ConversionTypeCode | String | Abbreviation that identifies the type of currency conversion to be used if order is in a different currency than the currency of shipping costs. |
| ConversionDate | Datetime | Date when the currency conversion occurred. |
| ConversionRate | Double | Rate of the currency conversion. |
| CreationDate | Datetime | CreationDate of ShipmentLineTransactionRequests |
| CreatedBy | String | CreatedBy of ShipmentLineTransactionRequests |
| LastUpdateDate | Datetime | LastUpdateDate of ShipmentLineTransactionRequests |
| LastUpdatedBy | String | LastUpdatedBy of ShipmentLineTransactionRequests |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BaseItem | String | BaseItem |
| BaseItemId | Long | BaseItemId |
| EndAssemblyItem | String | EndAssemblyItem |
| FromRequestedDate | Datetime | FromRequestedDate |
| FromScheduledShipDate | Datetime | FromScheduledShipDate |
| InitialDestinationId | Long | InitialDestinationId |
| Item | String | Item |
| ItemId | Long | ItemId |
| ToRequestedDate | Datetime | ToRequestedDate |
| ToScheduledShipDate | Datetime | ToScheduledShipDate |
| TransportationShipment | String | TransportationShipment |
| Finder | String | finder |