BranchId | Branch | Calculated (calculated) | | The transfer's From Branch, copied from the header as text rather than as a branch reference. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
DamagedQuantity | Damaged Quantity | Number | | Goods that arrived damaged, entered with Edit before posting. Above zero, posting writes a Damaged entry at the destination bin. |
ExcessQuantity | Excess Quantity | Calculated (calculated) | | Received Quantity minus Quantity when Received Quantity is higher, otherwise 0. Above zero, posting writes an Excess entry at the destination bin. |
FieldSaleLineId | FieldSaleLine | Guid | | A link to a van-sales line. Van runs create two-step transfers, so no shipped process fills it in on single-step lines. |
FieldSalesLineId | Field Sales Line | Lookup → FieldSalesLine | | Not stored. Use FieldSaleLineId for the van-sales link. |
Id | Id | Guid | Yes | |
InventoryLedgerId | Inventory Ledger | Lookup → InventoryLedger | | The ledger entry the posting created. A line that has one is skipped by every later posting, and Post Inventory refuses with "Transfer lines are already posted." when every line has one. |
IsILPosted | IL Posted | Boolean | Yes | Not set by transfer posting. Use Inventory Ledger to tell whether a line has been posted. |
IsILPostingApproved | IL Posting Approved | Boolean | Yes | Ticked when Post Inventory or Selective Transfer sends the line for posting. A ticked line that has an Inventory Ledger entry is never posted again. |
ItemId | Item | Lookup → Item | | |
ItemLotId | Item Lot | Lookup → ItemLot | | The source lot, required for posting when the item tracks lots. The seeded Quick Add and Edit forms do not show it, though the record page does. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Calculated (calculated) | | The transfer's From Partner Account, copied from the header as text. |
PendingReceivedQuantity | Pending Received Quantity | Calculated (calculated) | | Quantity minus Received Quantity. Selective Transfer starts each line's Requested Quantity at this value, and refuses when no ticked line has anything pending. |
Quantity | Quantity | Number | | The quantity moved. Posting takes this full quantity out of the source and into the destination, whatever Received Quantity says. Defaults to 0, and a line with 0 posts nothing. When the SKU, or else the item, has Maximum Lot Quantity 1, saving a new line with a larger quantity splits it into lines of 1. |
ReceivedQuantity | Received Quantity | Decimal | | The quantity confirmed as arrived. Defaults to 0. Selective Transfer adds the requested quantity to it. Post Inventory does not change it, so a line posted with Post Inventory while this is 0 records its whole Quantity as a shortage. Typed values above Quantity become Excess Quantity. |
RecordTypeId | Record Type | Guid, hidden | | |
RelatedBranchId | Related Branch | Calculated (calculated) | | The transfer's To Branch, copied from the header as text. The destination entries post against this branch. |
RelatedItemLotId | Related Item Lot | Lookup → ItemLot | | The destination copy of the source lot, created when the line is posted with Post Inventory or Selective Transfer. It has the same batch, serial number, cost, MRP and dates, and belongs to the To Branch and the destination company. |
RelatedPartnerAccountId | Related Partner Account | Calculated (calculated) | | The transfer's To Partner Account, copied from the header as text. Empty when the move stays inside one company, in which case the destination entries use the source company. |
RelatedStorageLocationId | Destination Storgae Location | Lookup → StorageLocation | | The destination bin the goods go into. The Transfer Inward, Shortage, Damaged and Excess entries post here. The picker is not filtered by branch. |
RequestedQuantity | Requested Quantity | Decimal | | Not stored. The quantity entered for a line in the Selective Transfer dialog. It must be above zero and no more than Pending Received Quantity, and it is added to Received Quantity. |
ShortageQuantity | Shortage Quantity | Calculated (calculated) | | Quantity minus Received Quantity when Received Quantity is lower, otherwise 0. It equals the whole Quantity while Received Quantity is 0. Above zero, posting writes a Shortage entry at the destination bin. |
SKUId | Item SKU | Lookup → SKU | | |
StorageLocationId | Source Storgae Location | Lookup → StorageLocation | | The source bin the goods leave from. The picker is not filtered by branch. |
TransferId | Transfer | Lookup → Transfer | Yes | The parent document. |
TransferType | Transfer Type | PickList | | On Hand Transfer, the default, moves stock on hand from the source bin to the destination bin. Pending Deliveries Transfer instead moves the source's pending-deliveries quantity to the destination's pending-deliveries quantity. Values: On Hand Transfer, Pending Deliveries Transfer. |
Type | Type | Calculated (calculated) | | The parent transfer's Type, copied from the header. On these lines it is Single Step. |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | The cost per unit carried into the ledger entries. It is not on the seeded forms. Lines created by a partner takeover carry the outgoing partner's average cost. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
