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