Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentLineTransactionRequests

Supports management of shipment line transaction requests, including tracking and updating interface and base table data.

Columns

Name Type Description
TransactionId [KEY] Long The unique identifier for the shipment line transaction request. It is used to track and reference each specific transaction request within the system.
ActionCode String A code representing the action to be performed on the transaction request. Valid actions include CREATE, UPDATE, CANCEL, and other statuses such as StagingCreate, TPUpdate, and more.
TransactionStatusCode String A code that represents the status of the transaction request. It helps determine whether the request is in progress, completed, or encountered errors.
TransactionStatus String A human-readable description of the current status of the transaction request. This provides more detailed information about the status of the request.
DocumentNumber String The document number associated with the shipment line transaction request. It helps identify the related document for the transaction.
SourceSystemId Long The unique identifier for the source system that initiated the transaction request. It is used to track the origin of the request.
SourceSystem String The name of the source system that initiated the transaction request. This helps identify where the transaction request came from.
OrderTypeCode String An abbreviation that identifies the type of source document, such as SALES_ORDER. It is used to specify the type of order in the system.
Order String The number identifying the sales order in the order capture application. This links the transaction to a specific order in the system.
SourceOrder String The number identifying the source order header that this transaction request is related to. It helps track which order this transaction is based on.
LogisticsServiceProviderCustomerId Long The unique identifier for the logistics service provider customer who sent the order lines in this transaction request.
LogisticsServiceProviderCustomer String The name of the logistics service provider customer responsible for sending the order lines in the transaction request.
LogisticsServiceProviderCustomerNumber String The number identifying the logistics service provider customer who sent the order lines in the transaction request.
ShipToPartyId Long The unique identifier for the ship-to party across all shipment lines in the transaction request. It is used to track the recipient party for the shipment.
ShipToCustomer String The name of the party who will receive the sales order lines that are shipped. It helps identify the customer receiving the shipment.
ShipToCustomerNumber String The number that identifies the ship-to party for all shipment lines in the transaction request.
ShipToPartySiteId Long The unique identifier for the ship-to party site of all the shipment lines in this transaction request. It identifies the specific location of the recipient.
ShipToPartySiteNumber String The number that identifies the ship-to party site for all the shipment lines in the transaction request.
ShipToContactId Long The unique identifier for the contact person at the ship-to location for all shipment lines in this transaction request.
ShipToContact String The name of the person to contact at the ship-to customer site. This helps facilitate communication about the shipment.
ShipToContactNumber String The contact number for the person at the ship-to customer site for all shipment lines in this transaction request.
SoldToPartyId Long The unique identifier for the sold-to party of all the shipment lines in this transaction request. It helps identify the customer who purchased the items.
SoldToCustomer String The name of the party who purchased the sales order lines in this transaction request. It identifies the billing party for the transaction.
SoldToCustomerNumber String The number that identifies the sold-to party for all the shipment lines in this transaction request.
SoldToContactId Long The unique identifier for the sold-to contact for all the shipment lines in this transaction request.
SoldToContact String The name of the contact person at the sold-to customer site. This person is responsible for managing the transaction details.
SoldToContactNumber String The contact number for the person at the sold-to customer site for all shipment lines in this transaction request.
BillToPartyId Long The unique identifier for the bill-to party across all shipment lines in the transaction request. It helps identify the party to be billed.
BillToCustomer String The name of the party to bill for all the sales order lines in this transaction request.
BillToCustomerNumber String The number that identifies the billing party for all shipment lines in the transaction request.
BillToPartySiteId Long The unique identifier for the bill-to party site across all shipment lines in the transaction request.
BillToPartySiteNumber String The number that identifies the bill-to party site for all shipment lines in the transaction request.
BillToContactId Long The unique identifier for the bill-to contact for all the shipment lines in this transaction request.
BillToContact String The name of the contact person at the bill-to customer site.
BillToContactNumber String The contact number for the person at the bill-to customer site for all shipment lines in this transaction request.
OrganizationId Long The unique identifier for the inventory organization associated with the transaction request.
OrganizationCode String The abbreviation identifying the organization where the shipment is processed or originates.
OrganizationName String The name of the inventory organization associated with the shipment lines in this transaction request.
ShipFromLocationId Long The unique identifier for the ship-from location for all shipment lines in this transaction request.
CarrierId Long The unique identifier for the carrier responsible for transporting the shipment containing all the shipment lines.
Carrier String The name of the carrier responsible for transporting the shipment.
CarrierNumber String The number identifying the carrier used for transporting the shipment.
ModeOfTransportCode String The abbreviation identifying the mode of transport for the shipping method used for the shipment.
ServiceLevelCode String The abbreviation identifying the service level for the shipping method used in the shipment.
FOBCode String The code that identifies the terms of ownership for the items in transit, such as when the risk passes from seller to buyer.
FreightTermsCode String The abbreviation for the terms describing whether the buyer or seller pays for shipping and when payment is due.
Currency String The currency used for all the shipment lines in this transaction request.
ConversionTypeCode String The abbreviation identifying the type of currency conversion applied to the order if it differs from the shipping cost currency.
ConversionDate Datetime The date when the currency conversion for the shipment lines was applied.
ConversionRate Decimal The rate of currency conversion applied to the shipment lines during the transaction.
CreationDate Datetime The date when the shipment line transaction request was created in the system.
CreatedBy String The person or system responsible for creating the shipment line transaction request.
LastUpdateDate Datetime The date when the shipment line transaction request was last updated.
LastUpdatedBy String The person or system responsible for the most recent update to the shipment line transaction request.
BaseItem String The item number for the base item in the shipment request.
BaseItemId Long The unique identifier for the base item in the shipment request.
EndAssemblyItem String The item number for the end assembly item related to the shipment request.
Finder String A unique search identifier for the shipment line transaction request, used for locating the record in queries.
FromRequestedDate Datetime The starting requested date for the shipment lines in this transaction request.
FromScheduledShipDate Datetime The starting scheduled ship date for the shipment lines in this transaction request.
InitialDestinationId Long The identifier for the initial destination of the shipment lines in the transaction request.
Item String The item being shipped in this transaction request.
ItemId Long The unique identifier for the item being shipped in this transaction request.
ToRequestedDate Datetime The ending requested date for the shipment lines in this transaction request.
ToScheduledShipDate Datetime The ending scheduled ship date for the shipment lines in this transaction request.
TransportationShipment String The unique identifier for the transportation shipment associated with the transaction request.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175