TransferOrderstransferOrderLines
Manages details of lines within transfer orders, supporting effective order execution and tracking.
Columns
| Name | Type | Description |
| TransferOrdersHeaderId [KEY] | Long | Unique identifier for the transfer order header. |
| LineId [KEY] | Long | Unique identifier for the transfer order line. |
| LineNumber | Int | Line number within the transfer order. |
| HeaderId | Long | Reference to the transfer order header. |
| HeaderNumber | String | Transfer order header number. |
| InterfaceStatusLookup | String | Lookup code for interface processing status. |
| InterfaceStatus | String | Status of the transfer order line interface. |
| FulfillmentStatusLookup | String | Lookup code for fulfillment status. |
| FulfillStatusMeaning | String | Meaning of the fulfillment status. |
| SourceTypeLookup | String | Source type lookup for the transfer order. |
| SourceOfTransferOrder | String | Source application for the transfer order. |
| SourceOrganizationId | Long | ID of the source organization. |
| SourceOrganizationCode | String | Code of the source organization. |
| SourceOrganizationName | String | Name of the source organization. |
| SourceSubinventoryCode | String | Code of the source subinventory. |
| DestinationOrganizationId | Long | ID of the destination organization. |
| DestinationOrganizationCode | String | Code of the destination organization. |
| DestinationOrganizationName | String | Name of the destination organization. |
| DestinationSubinventoryCode | String | Code of the destination subinventory. |
| DestinationTypeLookup | String | Lookup code for destination type. |
| DestinationType | String | Type of destination (Inventory, Expense). |
| DestinationLocationId | Long | ID of the destination location. |
| DestinationLocationCode | String | Code of the destination location. |
| DestinationLocationName | String | Name of the destination location. |
| DestinationAddressFirstLine | String | First line of the destination address. |
| DestinationAddressSecondLine | String | Second line of the destination address. |
| DestinationAddressThirdLine | String | Third line of the destination address. |
| DestinationAddressFourthLine | String | Fourth line of the destination address. |
| DestinationCity | String | City of the destination. |
| DestinationState | String | State of the destination. |
| DestinationPostalCode | String | Postal code of the destination. |
| DestinationCountry | String | Country of the destination. |
| MaterialReturnRequired | String | Indicates if material return is required. |
| StatusLookup | String | Lookup code for line status. |
| TransferOrderLineStatus | String | Current status of the transfer order line. |
| InventoryItemId | Long | Unique identifier for the inventory item. |
| ItemNumber | String | Item number associated with the transfer order. |
| ItemRevision | String | Revision number of the item. |
| NeedByDate | Datetime | Date when the item is needed. |
| ScheduledShipDate | Datetime | Scheduled shipping date. |
| QuantityUOMCode | String | Unit of measure (UOM) code for requested quantity. |
| QuantityUOMName | String | UOM name for requested quantity. |
| RequestedQuantity | Decimal | Quantity requested for transfer. |
| ShippedQuantity | Decimal | Quantity shipped from the source. |
| ReceivedQuantity | Decimal | Quantity received at the destination. |
| DeliveredQuantity | Decimal | Quantity delivered to the recipient. |
| SecondaryQuantityUOMCode | String | Secondary UOM code. |
| SecondaryQuantityUOMName | String | Secondary UOM name. |
| SecondaryRequestedQuantity | Decimal | Quantity requested in secondary UOM. |
| SecondaryShippedQuantity | Decimal | Quantity shipped in secondary UOM. |
| SecondaryReceivedQuantity | Decimal | Quantity received in secondary UOM. |
| SecondaryDeliveredQuantity | Decimal | Quantity delivered in secondary UOM. |
| UnitPrice | Decimal | Unit price of the item in transfer. |
| FreightCarrierId | Long | Unique identifier for the freight carrier. |
| CarrierName | String | Name of the freight carrier. |
| ModeOfTransportLookup | String | Lookup code for mode of transport. |
| ModeOfTransport | String | Mode of transportation (Air, Rail). |
| ServiceLevelLookup | String | Lookup code for service level. |
| ServiceLevel | String | Service level of the shipment. |
| ShipMethodDescription | String | Description of the shipping method. |
| ShipmentPriorityLookup | String | Lookup code for shipment priority. |
| ShipmentPriority | String | Shipment priority level (High, Medium, Low). |
| OriginalHeaderId | Long | Original header ID for linked orders. |
| OriginalTransferOrder | String | Original transfer order number. |
| OriginalLineId | Long | Original line ID for linked orders. |
| OriginalTransferOrderLine | String | Original transfer order line number. |
| RequisitionId | Long | Unique identifier for the requisition. |
| RequisitionLineId | Long | Unique identifier for the requisition line. |
| RequisitionLineNumber | String | Requisition line number. |
| RequesterId | Long | ID of the requester of the transfer. |
| RequesterName | String | Name of the requester of the transfer. |
| InterfaceErrMsgCode | String | Error message code for interface processing. |
| InterfaceErrMsgText | String | Detailed error message for interface processing. |
| PlannerId | Long | ID of the supply chain planner. |
| PlannerName | String | Name of the supply chain planner. |
| ChangeStatusLookup | String | Lookup code for change status. |
| ChangeStatus | String | Current status of the requested change. |
| ChangeRequestedDate | Datetime | Date when the change was requested. |
| Comments | String | Additional comments on the transfer order line. |
| SourceHeaderId | Long | ID of the source transaction header. |
| SourceLineId | Long | ID of the source transaction line. |
| InclNonrecoverableTax | Decimal | Amount of non-recoverable tax included. |
| InclRecoverableTax | Decimal | Amount of recoverable tax included. |
| NoninclNonrecoverableTax | Decimal | Non-included non-recoverable tax. |
| NoninclRecoverableTax | Decimal | Non-included recoverable tax. |
| CurrencyCode | String | Currency code for financial transactions. |
| AgreementPtrId | Long | Reference ID for the agreement. |
| FirmPlanningScheduleLookup | String | Lookup code for firm planning schedule. |
| FirmPlanningSchedule | String | Firm planning schedule details. |
| InterfaceSourceCode | String | Source code for interface processing. |
| BackToBack | String | Indicates if the transfer is a back-to-back request. |
| OriginalRequestLineId | Long | ID of the original request line. |
| ActionSourceType | String | Type of action source. |
| NoteToReceiver | String | Notes for the receiving party. |
| NoteToSupplier | String | Notes for the supplier. |
| Reprice | String | Indicates if re-pricing is required. |
| ChangePartyId | Long | ID of the party initiating the change. |
| ChangeInitiatingPersonName | String | Name of the person initiating the change. |
| Region | String | Region associated with the transfer order. |
| Action | String | Action to be performed on the transfer order. |
| AllowItemSubstitution | String | Indicates if item substitution is allowed. |
| AllowItemSubstitutionMeaning | String | Description of the item substitution rule. |
| ItemSubstituted | String | Indicates if an item was substituted. |
| ItemSubstitutedMeaning | String | Description of the substituted item. |
| InitialRequestedQuantity | Decimal | Initial requested quantity before changes. |
| RequisitionNumber | String | Requisition number linked to the transfer. |
| Finder | String | Utility field for locating transfer order lines. |
| PBatch | String | Batch identifier for the transfer order. |
| PDestinationOrganization | String | Destination organization for the transfer order. |
| PItemNumber | String | Item number associated with the transfer order. |
| PLineNumber | String | Line number within the transfer order. |
| PLineStatus | String | Current status of the transfer order line. |
| PScheduledShipDate | Datetime | Scheduled ship date for the transfer order line. |
| PSourceOrganization | String | Source organization for the transfer order. |
| PTransactionOrigin | String | Transaction origin of the transfer order. |
| PTransferOrder | String | Reference number for the transfer order. |