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. |