ShipmentLines
Handles details for shipment lines, including search and retrieval based on attributes like order type, status, and reservations.
Columns
Name | Type | Description |
ShipmentLine [KEY] | Long | The unique identifier for each shipment line within the shipment table. |
OrderTypeCode | String | The code representing the order type for this shipment line, used to categorize the order (for example, standard, expedited). |
OrderType | String | The specific type of order this shipment line belongs to, such as a regular or backorder. |
Order | String | The order number associated with the shipment line, typically referencing the customer’s purchase order. |
OrderLine | String | The line number within the order, used to track specific items or quantities in an order. |
OrderSchedule | String | The schedule or expected delivery date associated with the order line. |
InventoryItemId | Long | The unique identifier for the inventory item that is being shipped in this shipment line. |
Item | String | The item number assigned to the product being shipped, used for tracking and identification purposes. |
ItemDescription | String | A description of the item, providing additional details about the product being shipped. |
Revision | String | The revision number of the item, typically used to track different versions of the product. |
UnitPrice | Long | The price per unit of the item being shipped, typically in the base currency for the organization. |
SellingPrice | Long | The price at which the item is sold, which may include any additional costs such as handling or delivery fees. |
RequestedQuantity | Decimal | The quantity of the item requested to be shipped, as specified by the customer on their order. |
RequestedQuantityUOMCode | String | The unit of measure (UOM) code for the requested quantity (for example, each, kg, lb). |
RequestedQuantityUOM | String | The full UOM for the requested quantity (for example, each, kilograms, pounds). |
SecondaryRequestedQuantity | Decimal | The secondary quantity requested, usually used for items with dual UOM settings (for example, weight or volume). |
SecondaryRequestedQuantityUOMCode | String | The UOM code for the secondary requested quantity. |
SecondaryRequestedQuantityUOM | String | The full UOM for the secondary requested quantity. |
FOBCode | String | The code that specifies the terms of delivery (for example, Free On Board), which determines when the responsibility for the item transfers. |
FOB | String | The term of delivery indicating the point at which the item ownership is transferred, typically including shipping and handling terms. |
FreightTermsCode | String | The code used to specify the terms for freight or shipping, which can determine who pays for freight costs. |
FreightTerms | String | The description or name of the freight terms, which specify whether the buyer or seller pays for shipping costs. |
ShippingPriorityCode | String | A code used to categorize the urgency of the shipment, impacting delivery methods or timelines. |
ShippingPriority | String | The description of the shipping priority (for example, High, Medium, Low), determining how urgently the item should be shipped. |
PreferredGrade | String | The preferred grade of the item, which could refer to quality standards or customer preferences for the product. |
PreferredGradeName | String | The full name or description of the preferred grade of the item. |
CurrencyCode | String | The currency code used for pricing and charges related to this shipment line (for example, USD, EUR). |
CurrencyName | String | The full name of the currency used for pricing (for example, USD, EUR). |
ShipmentSet | String | A grouping identifier for shipment lines that are part of the same shipment batch or set. |
ArrivalSet | String | A grouping identifier for items within the shipment that should arrive together. |
CustomerPONumber | String | The customer's purchase order number associated with the shipment line. |
CustomerItemId | Long | The unique identifier of the item as assigned by the customer, for reference or tracking purposes. |
CustomerItem | String | The item number assigned by the customer, typically for inventory or order tracking. |
CustomerItemDescription | String | A description of the item as identified by the customer, providing context about the product. |
RequestedDate | Datetime | The date the customer requested the shipment or delivery to occur. |
ScheduledShipDate | Datetime | The date scheduled for the item to be shipped, often determined by the fulfillment process. |
RequestedDateTypeCode | String | The code specifying the type of requested date, such as delivery date or ship date. |
RequestedDateType | String | A description of the type of requested date, clarifying whether it's for shipping or delivery. |
ShipToPartyId | Long | The unique identifier for the party (customer or recipient) to whom the item is being shipped. |
ShipToCustomer | String | The name of the customer or recipient receiving the shipment. |
ShipToCustomerNumber | String | The unique identifier for the customer receiving the shipment, typically used in the system for tracking. |
ShipToPartySiteId | Long | The unique identifier for the site (address or location) where the item is to be shipped. |
ShipToPartySiteNumber | String | The site number used for identifying the specific location within the party's address. |
ShipToContactId | Long | The identifier for the contact person at the delivery location, used for communication or delivery coordination. |
ShipToContact | String | The full name of the contact person at the delivery site. |
ShipToContactFirstName | String | The first name of the contact person at the delivery site. |
ShipToContactLastName | String | The last name of the contact person at the delivery site. |
ShipToContactPhone | String | The phone number of the contact person at the delivery site, used for coordination or issues during delivery. |
ShipToURL | String | The URL or website associated with the contact or delivery site. |
ShipToFax | String | The fax number for the contact person at the shipping destination. |
ShipToEmail | String | The email address of the contact person at the shipping destination. |
ShipToLocationId | Long | The location ID used to uniquely identify the place where the shipment will be delivered. |
ShipToLocationType | String | The type of location for the delivery, such as a warehouse, retail store, or residential address. |
ShipToAddress1 | String | The first line of the shipping address for the destination, typically including street or building number. |
ShipToAddress2 | String | The second line of the shipping address, often used for apartment numbers or additional address details. |
ShipToAddress3 | String | The third line of the shipping address, used for extended address information if necessary. |
ShipToAddress4 | String | The fourth line of the shipping address, typically used for additional address details in specific cases. |
ShipToCity | String | The city of the shipping address where the item is to be delivered. |
ShipToCounty | String | The county of the shipping address where the item is to be delivered. |
ShipToPostalCode | String | The postal code (ZIP code) for the shipping address, used for mail sorting and delivery. |
ShipToRegion | String | The region or area within the country for the shipping address (for example, state or province). |
ShipToState | String | The state or province associated with the shipping address, providing a more specific geographic location. |
ShipToCountry | String | The country of the shipping address, used to identify international or domestic deliveries. |
SoldToPartyId | Long | The unique identifier for the party (typically the customer) who purchased the item being shipped. |
SoldToCustomer | String | The name of the customer who made the purchase and is associated with the sold-to party. |
SoldToCustomerNumber | String | The unique identifier for the customer who made the purchase, typically used for billing or order tracking. |
Supplier | String | The supplier or vendor providing the items for shipment, often used for tracking sourcing details. |
SupplierPartyNumber | String | The supplier's internal party number used for identification and reference in the system. |
SoldToContactId | Long | The identifier for the contact person at the sold-to party, used for communication regarding the shipment. |
SoldToContact | String | The name of the contact person at the sold-to party. |
SoldToContactFirstName | String | The first name of the contact person at the sold-to party. |
SoldToContactLastName | String | The last name of the contact person at the sold-to party. |
SoldToContactPhone | String | The phone number for the contact person at the sold-to party. |
SoldToURL | String | The URL associated with the sold-to party, potentially for online customer portals or communications. |
SoldToFax | String | The fax number for the contact person at the sold-to party. |
SoldToEmail | String | The email address for the contact person at the sold-to party. |
BillToPartyId | Long | The unique identifier for the party responsible for paying for the goods or services. |
BillToCustomer | String | The name of the customer associated with the billing party. |
BillToCustomerNumber | String | The unique customer number assigned to the billing party for invoicing and payment purposes. |
BillToPartySiteId | Long | The unique identifier for the site (location) where the billing information is processed or managed. |
BillToPartySiteNumber | String | The party site number used for identifying the specific location within the billing party's records. |
BillToContactId | Long | The identifier for the contact person responsible for handling billing-related communication. |
BillToContact | String | The name of the contact person for billing inquiries at the bill-to party. |
BillToContactFirstName | String | The first name of the contact person responsible for billing inquiries. |
BillToContactLastName | String | The last name of the contact person responsible for billing inquiries. |
BillToContactPhone | String | The phone number of the contact person for billing-related questions or issues. |
BillToURL | String | The URL associated with the billing party, possibly for online payments or billing-related communications. |
BillToFax | String | The fax number for sending billing-related documents to the bill-to contact. |
BillToEmail | String | The email address for the billing contact, used for invoices and communication. |
BillToLocationId | Long | The location ID used to uniquely identify where billing information is stored or processed. |
BillToAddress1 | String | The first line of the billing address, typically including street or building number. |
BillToAddress2 | String | The second line of the billing address, often used for apartment numbers or additional address details. |
BillToAddress3 | String | The third line of the billing address, used for extended address details if necessary. |
BillToAddress4 | String | The fourth line of the billing address, typically used for additional details in specific cases. |
BillToCity | String | The city of the billing address, where the customer is registered or where invoices are sent. |
BillToCounty | String | The county or region associated with the billing address. |
BillToPostalCode | String | The postal code (ZIP code) for the billing address. |
BillToRegion | String | The region or area within the country for the billing address (for example, state or province). |
BillToState | String | The state or province associated with the billing address. |
BillToCountry | String | The country for the billing address, used to determine the geographical location of the bill-to party. |
Subinventory | String | The subinventory within the warehouse where the inventory for this shipment line is stored. |
LocatorId | Long | The identifier for the specific location within the subinventory where the inventory item is found. |
Locator | String | The locator name or code used to pinpoint the exact physical location of the item in the warehouse or storage. |
ShippedQuantity | Decimal | The quantity of the item actually shipped as part of this shipment line. |
SecondaryShippedQuantity | Decimal | The secondary quantity of the item shipped, used when multiple units of measure are involved (for example, weight or volume). |
NetWeight | Long | The total weight of the shipped items in this line, excluding packaging, measured in the unit of weight (for example, kilograms or pounds). |
GrossWeight | Long | The total weight of the shipment including the items and the packaging material, measured in the unit of weight (for example, kilograms or pounds). |
TareWeight | Decimal | The weight of the packaging material for the shipment, without the items, measured in the unit of weight. |
WeightUOMCode | String | The code used to define the UOM for the weight (for example, KG for kilograms, LB for pounds). |
WeightUOM | String | The UOM for weight, providing context on whether the weight is in kilograms, pounds, or other weight units. |
Volume | Long | The total volume of the shipment line, typically representing the space the items occupy in the shipping container or pallet, measured in cubic units. |
VolumeUOMCode | String | The UOM code for the volume, indicating the system used (for example, CM for cubic meters, FT3 for cubic feet). |
VolumeUOM | String | The UOM for volume, such as cubic meters or cubic feet, used to describe the space occupied by the shipment. |
LoadingSequence | Long | The order in which the shipment lines are to be loaded into the transport vehicle, typically based on size, weight, or priority. |
LotNumber | String | The lot number assigned to a batch of items that were manufactured or processed together, used for inventory tracking and quality control. |
EndAssemblyItemNumber | String | The item number of the end assembly product, if this shipment line involves the delivery of a finished product from subassemblies. |
OrganizationId | Long | The unique identifier for the organization responsible for managing the shipment line within the company. |
OrganizationCode | String | The code used to identify the organization within the company’s system, helping to classify and track shipments. |
OrganizationName | String | The name of the organization that is responsible for managing this shipment line. |
ParentPackingUnitId | Long | The unique identifier for the parent packing unit under which this shipment line is grouped, often used for bulk or multi-item shipments. |
ParentPackingUnit | String | The identifier or description for the parent packing unit, indicating if this line is part of a larger unit (for example, carton, pallet). |
ShipmentId | Long | The unique identifier for the shipment, used to track the entire shipment process across various systems. |
Shipment | String | The shipment number or identifier assigned to the specific shipping event, used for tracking and reference purposes. |
ProjectSalesOrderFlag | Bool | A flag indicating whether the shipment line is related to a project sales order, distinguishing it from regular sales orders. |
RcvShipmentLineId | Long | The unique identifier for the shipment line within the receiving system, helping to track the goods once they arrive at the destination. |
LineStatusCode | String | The status code for the shipment line, indicating its current state in the shipping or delivery process (for example, shipped, pending, cancelled). |
LineStatus | String | The descriptive status of the shipment line, providing context to the current state such as 'shipped,' 'in transit,' or 'delivered.' |
TrackingNumber | String | The tracking number assigned by the carrier for the shipment, used to monitor the movement of goods from dispatch to delivery. |
SealNumber | String | The seal number assigned to the shipment container, ensuring the integrity of the shipment during transit and storage. |
PickWaveId | Long | The unique identifier for the pick wave, which groups together shipments or items for picking during the fulfillment process. |
PickWave | String | The code or name assigned to a pick wave, helping to track and manage the grouping of items for fulfillment. |
SourceOrderId | Long | The identifier for the original order from which this shipment line is derived, linking it back to the initial order request. |
SourceOrder | String | The order number or identifier from the originating sales or fulfillment order that this shipment line is part of. |
SourceOrderLineId | Long | The specific line item identifier from the source order that this shipment line corresponds to. |
SourceOrderLine | String | The line number or identifier from the source order, providing the specific product or item being shipped. |
SourceOrderFulfillmentLineId | Int | The unique identifier for the fulfillment line in the source order, helping to track specific fulfillments related to the shipment. |
SourceOrderFulfillmentLine | String | The description or identifier for the fulfillment line in the source order, showing which product is being shipped from the order. |
TaxationCountryCode | String | The country code used for tax purposes, indicating the country where the goods are being shipped or where the tax rules apply. |
TaxationCountry | String | The name of the country used for taxation, helping to apply correct tax rates based on the delivery or shipping location. |
FirstPartyTaxRegistrationId | Long | The unique identifier for the first party’s tax registration, often linked to the billing or selling party in the shipment. |
FirstPartyTaxRegistrationNumber | String | The tax registration number assigned to the first party for tax reporting and legal purposes. |
ThirdPartyTaxRegistrationId | Long | The unique identifier for the third party’s tax registration, typically relevant when third-party vendors or service providers are involved. |
ThirdPartyTaxRegistrationNumber | String | The tax registration number for the third party, needed for tax reporting purposes when a third-party is handling shipments or taxes. |
LocationOfFinalDischargeId | Long | The unique identifier for the final discharge location of the shipment, which specifies where the goods are delivered or unloaded. |
LocationOfFinalDischargeCode | String | The code used to represent the final discharge location, aiding in the classification and tracking of delivery destinations. |
LocationOfFinalDischarge | String | The full name or description of the final discharge location, providing details about where the shipment will be unloaded. |
DocumentFiscalClassificationCode | String | The code used for fiscal classification of the shipment document, helping to categorize goods for taxation and customs purposes. |
DocumentFiscalClassification | String | The fiscal classification associated with the shipment document, providing context for customs, duty, and tax calculations. |
TransactionBusinessCategoryCode | String | The code identifying the business category for the transaction, used for classifying the nature of the shipment (for example, sale, return, exchange). |
TransactionBusinessCategory | String | The descriptive category of the business transaction, helping categorize the shipment based on its commercial purpose (for example, sale, return, exchange). |
UserDefinedFiscalClassificationCode | String | A custom code used for fiscal classification that may be specific to a business's unique processes or tax requirements. |
UserDefinedFiscalClassification | String | A user-defined description for fiscal classification, providing flexibility to adapt to specific tax categories or business rules. |
TaxInvoiceNumber | String | The unique identifier for the tax invoice associated with the shipment, used for tax reporting and legal documentation purposes. |
TaxInvoiceDate | Date | The date the tax invoice was issued, which is essential for determining the timing of tax obligations and compliance reporting. |
ProductCategoryCode | String | The code used to categorize the type of product being shipped, helping streamline logistics and inventory management. |
ProductCategory | String | The category or classification of the product being shipped, providing context for managing products and understanding their commercial use. |
IntendedUseClassificationId | Decimal | The identifier for the intended use classification of the products in the shipment, ensuring proper categorization for compliance and reporting. |
IntendedUse | String | The intended use description for the product, helping determine how the item is used and ensuring it meets legal and compliance standards. |
ProductTypeCode | String | The code assigned to the product type, aiding in the classification of goods and aligning them with the appropriate shipping or tax classifications. |
ProductType | String | The product type description, which classifies goods based on their commercial or industrial type, influencing shipping and handling procedures. |
AssessableValue | Decimal | The value assigned to the goods for assessment purposes, typically for customs or taxation, representing the taxable value of the shipment. |
TaxClassificationCode | String | The code used to classify the shipment for tax purposes, helping apply the correct tax rates based on the product and shipping destination. |
TaxClassification | String | The descriptive classification of the shipment’s tax status, determining the tax rate and any applicable exemptions based on the product and location. |
TaxExemptionCertificateNumber | String | The number of the tax exemption certificate provided for the shipment, indicating that the goods are exempt from certain taxes. |
TaxExemptionReasonCode | String | The code identifying the reason for tax exemption, explaining why the shipment is exempt from taxes under specific legal conditions. |
TaxExemptionReason | String | The description of why the goods in the shipment are tax-exempt, used for documentation and compliance with tax regulations. |
ProductFiscalClassificationId | Long | The unique identifier for the product fiscal classification, which helps assign the correct tax treatment based on the fiscal classification of the goods. |
ProductFiscalClassification | String | The description of the fiscal classification for the product, used to determine the appropriate tax rates and legal treatment for the shipment. |
TransportationPlanningStatusCode | String | The code representing the current status of transportation planning for the shipment, indicating progress in shipment preparation. |
TransportationPlanningStatus | String | The descriptive status of transportation planning, showing whether the shipment is in the preparation, transit, or completed phase. |
TransportationPlanningDate | Datetime | The date when transportation planning was completed or scheduled for the shipment, helping track logistics timelines. |
TransportationShipment | String | The identifier or number assigned to the transportation shipment, used to track the progress and status of goods in transit. |
TransportationShipmentLine | String | The line identifier for the transportation shipment, representing a specific item or group of items within the broader shipment. |
InitialDestinationId | Long | The unique identifier for the initial destination of the shipment, specifying the first intended delivery location. |
InitialDestination | String | The description of the initial destination for the shipment, indicating the location where the goods are first intended to be delivered. |
TradeComplianceStatusCode | String | The code used to indicate the trade compliance status of the shipment, showing whether the shipment meets all legal and regulatory requirements. |
TradeComplianceStatus | String | The descriptive status of the trade compliance process, indicating whether the shipment has passed all necessary legal checks for export or import. |
TradeComplianceDate | Datetime | The date when trade compliance was verified or completed, ensuring that the shipment complies with all international trade laws. |
TradeComplianceReason | String | The reason for any non-compliance or delay in the trade compliance process, explaining issues that need resolution for shipment clearance. |
TradeComplianceScreeningMethodCode | String | The code indicating the method used for trade compliance screening, which determines how shipments are assessed for legal compliance. |
TradeComplianceScreeningMethod | String | The description of the screening method used for assessing the shipment’s compliance with trade laws and regulations. |
ShipFromLocationId | Long | The unique identifier for the location from which the shipment is dispatched, used for tracking and logistical purposes. |
ShipFromAddress1 | String | The first line of the shipping address from where the goods are being dispatched, providing location-specific details. |
ShipFromAddress2 | String | The second line of the shipping address from where the goods are being dispatched, used to complete the full address. |
ShipFromAddress3 | String | The third line of the shipping address from where the goods are being dispatched, providing further location detail if needed. |
ShipFromAddress4 | String | The fourth line of the shipping address from where the goods are being dispatched, used to provide additional address information. |
ShipFromCity | String | The city of the shipping origin, specifying the urban area where the shipment is being dispatched from. |
ShipFromCounty | String | The county of the shipping origin, detailing the broader administrative region from which the goods are being dispatched. |
ShipFromPostalCode | String | The postal code of the shipping origin, used to identify the area for shipping logistics and delivery purposes. |
ShipFromRegion | String | The region of the shipping origin, which may include broader geographic details such as state or province. |
ShipFromState | String | The state or province from where the shipment originates, used for location-specific regulations and delivery coordination. |
ShipFromCountry | String | The country from which the shipment is being dispatched, essential for international shipping and customs processes. |
MaximumOvershipmentPercentage | Long | The maximum allowed percentage by which a shipment can exceed the requested quantity without requiring special approval or adjustments. |
MaximumUndershipmentPercentage | Long | The maximum allowed percentage by which a shipment can fall short of the requested quantity without requiring special approval or adjustments. |
SourceRequestedQuantity | Decimal | The quantity of goods requested for shipment as indicated by the source document or order, used for inventory and shipment planning. |
SourceRequestedQuantityUOMCode | String | The UOM code for the requested quantity, specifying the measurement units used (for example, units, kilograms). |
SourceRequestedQuantityUOM | String | The UOM description for the requested quantity, ensuring clarity in the type of measurement (for example, kg, box, unit). |
SecondarySourceRequestedQuantity | Decimal | The secondary requested quantity for the shipment, typically used in cases where dual units of measure are involved (for example, kilograms and units). |
SecondarySourceRequestedQuantityUOMCode | String | The UOM code for the secondary requested quantity, used in dual-unit shipments to specify additional measurements. |
SecondarySourceRequestedQuantityUOM | String | The UOM description for the secondary requested quantity, further detailing the additional measurement type (for example, liters, meters). |
DeliveredQuantity | Decimal | The quantity of goods actually delivered in the shipment, used to track discrepancies between requested and delivered amounts. |
SecondaryDeliveredQuantity | Decimal | The secondary delivered quantity for the shipment, used when multiple units of measure are involved (for example, weight and volume). |
CancelledQuantity | Decimal | The quantity of goods in the shipment that have been cancelled, used for adjustments and inventory management. |
SecondaryCancelledQuantity | Decimal | The secondary cancelled quantity for the shipment, relevant when dual units of measure are used and some units are cancelled. |
BackorderedQuantity | Decimal | The quantity of goods that could not be fulfilled and are placed on backorder, awaiting future delivery. |
SecondaryBackorderedQuantity | Decimal | The secondary backordered quantity, relevant in cases where dual units of measure are used for backordered items. |
PickedQuantity | Decimal | The quantity of goods picked from inventory for the shipment, used in warehouse management and order fulfillment tracking. |
SecondaryPickedQuantity | Decimal | The secondary picked quantity, detailing the picked goods when multiple units of measure are used (for example, weight and number of units). |
ConvertedQuantity | Decimal | The quantity of goods converted for shipment, typically used when items are re-measured or packed in different units of measure. |
SecondaryConvertedQuantity | Decimal | The secondary converted quantity for goods being shipped, used in dual-UOM systems. |
StagedQuantity | Decimal | The quantity of goods staged for shipment, indicating the goods that have been prepped but not yet shipped. |
SecondaryStagedQuantity | Decimal | The secondary staged quantity, used when dual units of measure are involved for staging the shipment. |
PendingQuantity | Decimal | The quantity of goods that are pending shipment, typically representing items that are in the process of being fulfilled. |
PendingQuantityFlag | Bool | A flag indicating whether there is any pending quantity in the shipment that has not yet been fulfilled. |
CreationDate | Datetime | The date and time when the shipment line was created, providing a timestamp for shipment record keeping. |
CreatedBy | String | The user or system responsible for creating the shipment line, ensuring traceability and accountability in the system. |
LastUpdateDate | Datetime | The date and time when the shipment line was last updated, used for audit purposes and tracking any modifications. |
LastUpdatedBy | String | The user or system responsible for the most recent update to the shipment line, ensuring traceability for changes. |
SplitFromShipmentLine | Long | The identifier of the shipment line from which the current shipment line has been split, used for managing changes in shipment volumes. |
SourceSubinventory | String | The source subinventory from which the goods are being shipped, used in inventory management to specify which location the goods are picked from. |
CarrierId | Long | The identifier for the carrier responsible for the shipment, used for tracking and coordination with third-party shipping providers. |
Carrier | String | The name of the carrier responsible for transporting the shipment, providing clarity on the shipment’s logistics provider. |
CarrierNumber | String | The carrier’s reference number for the shipment, used for tracking purposes and to identify the shipment in the carrier’s system. |
ModeOfTransportCode | String | The code representing the mode of transport used for the shipment (for example, air, sea, land). |
ModeOfTransport | String | The descriptive name of the mode of transport used for the shipment (for example, Air Freight, Ocean Shipping, Ground Transport). |
ServiceLevelCode | String | The service level code representing the speed and type of delivery service selected for the shipment (for example, standard, expedited). |
ServiceLevel | String | The description of the service level selected for the shipment, providing more context about the expected delivery time and service type. |
ShippingMethodCode | String | The code identifying the shipping method used for the shipment, specifying how the goods are to be delivered. |
ShippingMethod | String | The descriptive name of the shipping method used for the shipment (for example, Express, Standard Shipping, Same-Day Delivery). |
SourceDocumentTypeId | Long | The identifier for the source document type that initiated the shipment, such as a sales order or purchase order. |
UnitWeight | Long | The weight of a single unit of the item being shipped, important for calculating shipping costs and managing logistics. |
UnitVolume | Long | The volume of a single unit of the item being shipped, which is critical for space optimization in shipping containers. |
LogisticsServiceProviderCustomerId | Long | The identifier for the customer of the logistics service provider, used for managing and tracking logistics service relationships. |
LogisticsServiceProviderCustomer | String | The name of the customer associated with the logistics service provider, allowing identification of customer accounts in logistics systems. |
LogisticsServiceProviderCustomerNumber | String | The customer number assigned by the logistics service provider, used for identifying and tracking specific customer shipments. |
SourceLineUpdateDate | Datetime | The date when the source line was last updated, helping track changes or modifications made to the originating order. |
SourceSystemId | Long | The identifier for the source system where the shipment information was originally created or managed. |
SourceSystem | String | The name or code for the source system, which might be an internal or external system managing shipment details. |
ShipmentAdviceStatusFlag | Bool | A flag indicating whether the shipment advice has been completed, used to track the advice status in the shipment process. |
DoNotShipBeforeDate | Datetime | The earliest date that the goods in the shipment can be shipped, typically used to handle specific timing or delay requirements. |
DoNotShipAfterDate | Datetime | The latest date the shipment can be processed or delivered, often used for time-sensitive shipments. |
IntegrationStatusCode | String | The code representing the integration status of the shipment, used for tracking whether the shipment has been successfully integrated with other systems. |
IntegrationStatus | String | The descriptive status of the shipment integration, providing information about the current state of integration (for example, pending, completed). |
QuickShipStatus | String | The status of the quick shipping process, indicating whether the shipment is being expedited or processed normally. |
BusinessUnitId | Long | The identifier for the business unit responsible for the shipment, used for internal tracking and reporting within the organization. |
BusinessUnit | String | The name of the business unit responsible for the shipment, used for organizational tracking and coordination. |
LegalEntityId | Long | The identifier for the legal entity that owns or is responsible for the shipment, often used for accounting and legal purposes. |
LegalEntity | String | The name of the legal entity responsible for the shipment, used for accounting, reporting, and legal identification. |
POHeaderId | Long | The identifier for the purchase order header associated with the shipment, providing a link between the shipment and the original purchase order. |
PONumber | String | The purchase order number associated with the shipment, used for order tracking and reporting. |
POBillToBusinessUnitId | Long | The identifier for the business unit to which the billing for the purchase order is attributed. |
POBillToBusinessUnit | String | The name of the business unit to which the billing for the purchase order is attributed, used for invoicing and financial purposes. |
POSoldToLegalEntityId | Long | The identifier for the legal entity to which the sale in the purchase order is attributed. |
POSoldToLegalEntity | String | The name of the legal entity to which the sale in the purchase order is attributed, often used for legal and accounting purposes. |
ConversionTypeCode | String | The code identifying the type of conversion applied to the shipment, such as currency conversion or unit conversion. |
ConversionDate | Date | The date on which the conversion (for example, currency or unit) was applied to the shipment, used for historical tracking. |
ConversionRate | Double | The conversion rate used for changing the quantity or currency in the shipment, used for calculations and adjustments. |
ParentItemId | Long | The identifier for the parent item in the shipment, indicating the parent-child relationship between items (for example, kits or sets). |
ParentItem | String | The name of the parent item in the shipment, used to track and manage product relationships. |
ParentItemDescription | String | The description of the parent item in the shipment, providing additional details about the item or product. |
ParentSourceOrderFulfillmentLineId | Long | The identifier for the parent source order fulfillment line, used to track the parent-child relationship in order fulfillment. |
BaseItemId | Long | The identifier for the base item associated with the shipment, often used for standardizing shipments or for tracking base model products. |
BaseItem | String | The name of the base item associated with the shipment, used to link shipments with specific product categories. |
BaseItemDescription | String | The description of the base item associated with the shipment, providing more context about the item or product being shipped. |
SrcAttributeCategory | String | The category of the source attributes associated with the shipment, used for organizing and filtering shipment-related data. |
SrcAttribute1 | String | A custom attribute for the shipment, allowing users to define additional characteristics or classifications for the shipment. |
SrcAttribute2 | String | A custom attribute for the shipment, similar to SrcAttribute1 but offering more flexible categorization of shipment data. |
SrcAttribute3 | String | A custom attribute for the shipment, designed for additional classifications or metadata that might be needed in the shipment process. |
SrcAttribute4 | String | A custom attribute for the shipment, allowing for further classification and organization of shipment data. |
SrcAttribute5 | String | A custom attribute for the shipment, allowing for additional flexibility in categorizing the shipment and its components. |
SrcAttribute6 | String | A custom attribute for the shipment, designed for users who need to track unique characteristics of the shipment. |
SrcAttribute7 | String | A custom attribute for the shipment, offering additional classification options for managing shipment data. |
SrcAttribute8 | String | A custom attribute for the shipment, providing more ways to classify or categorize shipments for organizational or analytical purposes. |
SrcAttribute9 | String | A custom attribute for the shipment, used for specific shipment details that are relevant to internal or external reporting. |
SrcAttribute10 | String | A custom attribute for the shipment, designed to track particular shipment-related features that are important to the organization. |
SrcAttribute11 | String | A custom attribute for the shipment, allowing for tracking additional shipment metadata as needed. |
SrcAttribute12 | String | A custom attribute for the shipment, used for specifying further characteristics or conditions of the shipment. |
SrcAttribute13 | String | A custom attribute for the shipment, used for organizing and categorizing additional shipment details. |
SrcAttribute14 | String | A custom attribute for the shipment, offering flexibility for users to categorize shipments with specific features. |
SrcAttribute15 | String | A custom attribute for the shipment, used for organizing data points that are not typically captured in standard fields. |
SrcAttribute16 | String | A custom attribute for the shipment, allowing further classification and tracking for shipment-related data. |
SrcAttribute17 | String | A custom attribute for the shipment, offering more ways to classify shipment data based on unique needs. |
SrcAttribute18 | String | A custom attribute for the shipment, designed to track specific shipment details as required. |
SrcAttribute19 | String | A custom attribute for the shipment, used for tracking special shipment features that might not be covered by default fields. |
SrcAttribute20 | String | A custom attribute for the shipment, providing another layer of classification or categorization for the shipment data. |
SrcAttributeDate1 | Date | A custom date attribute for the shipment, allowing users to capture and track date-based shipment information. |
SrcAttributeDate2 | Date | A custom date attribute for the shipment, providing more flexibility for tracking date-specific shipment details. |
SrcAttributeDate3 | Date | A custom date attribute for the shipment, used for specifying additional time-based data for the shipment. |
SrcAttributeDate4 | Date | A custom date attribute for the shipment, offering more options for recording specific dates related to shipments. |
SrcAttributeDate5 | Date | A custom date attribute for the shipment, used to track additional dates associated with shipment events. |
SrcAttributeNumber1 | Decimal | A custom numeric attribute for the shipment, allowing users to track numeric data related to the shipment. |
SrcAttributeNumber2 | Decimal | A custom numeric attribute for the shipment, providing another way to track numeric shipment details. |
SrcAttributeNumber3 | Decimal | A custom numeric attribute for the shipment, used for specifying shipment-related numerical data. |
SrcAttributeNumber4 | Decimal | A custom numeric attribute for the shipment, offering flexibility to track numeric data as needed. |
SrcAttributeNumber5 | Decimal | A custom numeric attribute for the shipment, used for recording additional numeric data related to the shipment. |
SrcAttributeNumber6 | Decimal | A custom numeric attribute for the shipment, allowing users to track numeric data points associated with the shipment. |
SrcAttributeNumber7 | Decimal | A custom numeric attribute for the shipment, offering further options to capture shipment-specific numeric data. |
SrcAttributeNumber8 | Decimal | A custom numeric attribute for the shipment, enabling the tracking of additional numerical details. |
SrcAttributeNumber9 | Decimal | A custom numeric attribute for the shipment, providing more flexibility for tracking numeric shipment information. |
SrcAttributeNumber10 | Decimal | A custom numeric attribute for the shipment, designed to track specific numeric data related to shipments. |
SrcAttributeTimestamp1 | Datetime | A custom timestamp attribute for the shipment, allowing users to track specific date and time-based shipment details. |
SrcAttributeTimestamp2 | Datetime | A custom timestamp attribute for the shipment, used to capture additional time-sensitive data. |
SrcAttributeTimestamp3 | Datetime | A custom timestamp attribute for the shipment, allowing the tracking of other timestamped events during the shipment lifecycle. |
SrcAttributeTimestamp4 | Datetime | A custom timestamp attribute for the shipment, used for tracking specific moments or events tied to a shipment. |
SrcAttributeTimestamp5 | Datetime | A custom timestamp attribute for the shipment, enabling the capture of specific time-based data as needed. |
TransportationShipmentFromEvent | String | The event that initiated the transportation shipment, used for tracking the source of the transportation process. |
TransportationShipmentLineFromEvent | String | The event that initiated the transportation shipment line, used to associate each line item of the shipment with an event. |
TransportationShipmentCompleteFromEvent | String | The event that marks the completion of the transportation shipment, used for tracking finalization events in the shipment process. |
TradeComplianceScreenedFromEvent | String | The event related to the screening of the shipment for trade compliance, often used to ensure that the shipment meets regulatory requirements. |
CurrentBackorderedQuantityFromEvent | Decimal | The current backordered quantity associated with the shipment, used for tracking the quantity of items that have not yet been fulfilled. |
OriginalShipmentLineFromEvent | Long | The original shipment line identifier from the event, used to link the shipment line to the event that triggered the creation of the shipment. |
ProjectCostingProjectId | Long | The project identifier associated with the shipment, used for cost tracking and project management purposes in shipment processing. |
ProjectCostingProjectNumber | String | The project number associated with the shipment, providing a unique reference for project-based cost accounting. |
ProjectCostingProjectName | String | The project name associated with the shipment, used to identify the specific project for which the shipment is being processed. |
ProjectCostingTaskId | Long | The task identifier for the project associated with the shipment, used for tracking specific tasks within a project. |
ProjectCostingTaskNumber | String | The task number for the project associated with the shipment, used to identify a particular task within a project. |
ProjectCostingTaskName | String | The task name associated with the shipment in the context of the project, used to provide more detail about the shipment's purpose. |
OverShipTolerancePercentage | Decimal | The percentage of overshipment tolerance allowed for the shipment, used to track how much more than the requested quantity can be shipped. |
UnderShipTolerancePercentage | Decimal | The percentage of undershipment tolerance allowed for the shipment, used to track how much less than the requested quantity can be shipped. |
ShippingToleranceBehavior | String | Defines the behavior for handling shipping tolerances, such as whether over or under shipments are accepted. |
ConvertedRequestedQuantity | Decimal | The quantity of items in the shipment that has been converted, such as from one UOM to another, or from one product type to another. |
LineNetWeight | Decimal | The net weight of the shipment line, excluding packaging, used for logistical purposes and transportation calculations. |
LineGrossWeight | Decimal | The gross weight of the shipment line, including packaging, used to determine shipping costs and compliance with weight limits. |
SupplierLotNumber | String | The lot number provided by the supplier for the shipment, used to track the specific batch or group of items in the shipment. |
MovementRequestLineId | Long | The identifier for the movement request line associated with the shipment, used to link shipment details to specific requests for item movement. |
AllowItemSubstitutionFlag | Bool | Indicates whether item substitution is allowed in the shipment, typically used in cases where the original item is unavailable. |
OriginalItemId | Long | The identifier for the original item in the shipment, used to track the original item before any substitutions or modifications. |
OriginalItemNumber | String | The original item number of the shipment, used to identify the product before any changes or substitutions are made. |
OriginalDeliveryDetailId | Long | The identifier for the original delivery detail associated with the shipment, linking it to the initial shipping details. |
OriginalItemConvertedQuantity | Decimal | The quantity of the original item that has been converted (for example, due to unit changes), used for tracking modifications to the shipment. |
DestinationOrganizationCode | String | The code of the organization where the shipment is ultimately going, used for organizational tracking and reporting purposes. |
LineUnitPrice | Decimal | The unit price of the line item in the shipment, used for pricing, invoicing, and financial reporting. |
LineUnitVolume | Decimal | The unit volume of the shipment line, used for logistical calculations and ensuring the shipment meets dimensional requirements. |
LineVolume | Decimal | The total volume of the shipment line, used for determining storage and shipping space requirements. |
LineUnitWeight | Decimal | The unit weight of the shipment line item, used for logistics, transportation, and weight-based cost calculations. |
LineSellingPrice | Decimal | The selling price of the line item in the shipment, used for financial purposes, invoicing, and revenue tracking. |
OriginalSourceOrderFulfillmentLineId | Long | The identifier for the source order fulfillment line from which the shipment line originated, used to track the relationship between source orders and shipments. |
OriginalSourceOrderFulfillmentLine | String | The identifier of the source order fulfillment line from which the shipment line was generated, linking the shipment to the original order. |
EnforceSingleShipment | String | A flag indicating whether the system should enforce that all items in the shipment are consolidated into a single shipment, typically used for order consolidation. |
CancelBackorders | String | A flag indicating whether backordered items related to the shipment should be canceled, often used in cases of shipment adjustments. |
Finder | String | The finder used to search and retrieve specific shipment lines based on criteria, used in queries and reports to filter shipment data. |