---
id: object/table/20560
type: object
title: Table 20560 "Subcontractor WIP Ledger Entry"
summary: Table 20560 "Subcontractor WIP Ledger Entry" in Subcontracting (Microsoft.Manufacturing.Subcontracting). 21 fields, 3 public procedures. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - table
  - subcontracting
versions:
  introduced: "29"
  last_changed: null
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 702767cd9aefed68233b119c7492d02f7d9ed717b96efdbe6f2f66dee7dc21bb
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Subcontracting/app/src/WIPItem/SubcontractorWIPLedgerEntry.Table.al
    title: src/Apps/W1/Subcontracting/app/src/WIPItem/SubcontractorWIPLedgerEntry.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/9892
object_type: table
object_id: 20560
name: Subcontractor WIP Ledger Entry
namespace: Microsoft.Manufacturing.Subcontracting
app: Subcontracting
extends: null
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 21
  procedures: 3
  events: 0
  subscribers: 0
relations:
  out: 12
  referenced_by: 2
  pages: 2
  extended_by: 0
  event_subscribers: 1
  calls: 0
  called_by: 0
  implements: 0
---

# Table 20560 "Subcontractor WIP Ledger Entry"

> Table 20560 "Subcontractor WIP Ledger Entry" in Subcontracting (Microsoft.Manufacturing.Subcontracting). 21 fields, 3 public procedures. Introduced in BC29, still in BC30.

Subcontracting · Microsoft.Manufacturing.Subcontracting · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Subcontracting/app/src/WIPItem/SubcontractorWIPLedgerEntry.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Subcontractor WIP Ledger Entry |
| DataClassification | CustomerContent |
| LookupPageId | Subc. WIP Ledger Entries |
| DrillDownPageId | Subc. WIP Ledger Entries |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Entry No. | Integer | Specifies the number of the Subcontractor WIP Ledger Entry. |  |
| 2 | Item No. | Code[20] | Specifies the item number. | TableRelation [Table 27 "Item"](../table/27.md) |
| 3 | Variant Code | Code[10] | Specifies the variant code. | TableRelation [Table 5401 "Item Variant"](../table/5401.md) ("Item Variant".Code where("Item No." = field("Item No."))) |
| 4 | Location Code | Code[10] | Specifies the location where the WIP quantity is tracked. | TableRelation [Table 14 "Location"](../table/14.md) |
| 5 | Posting Date | Date | Specifies the date when the WIP ledger entry was posted. |  |
| 6 | Entry Type | Enum "WIP Ledger Entry Type" | Specifies which type of transaction that the entry is created from. | enum [Enum 20508 "WIP Ledger Entry Type"](../enum/20508.md) |
| 7 | Quantity (Base) | Decimal | Specifies the WIP quantity in base unit of measure |  |
| 8 | Base Unit of Measure | Code[10] | Specifies the base unit of measure of the item. | TableRelation [Table 5404 "Item Unit of Measure"](../table/5404.md) ("Item Unit of Measure".Code where("Item No." = field("Item No."))) |
| 9 | Document Type | Enum "WIP Document Type" | Specifies the document type that created this entry. | enum [Enum 20509 "WIP Document Type"](../enum/20509.md) |
| 10 | Document No. | Code[20] | Specifies the document number. |  |
| 11 | Document Line No. | Integer | Specifies the document line number. |  |
| 12 | Prod. Order Status | Enum "Production Order Status" | Specifies the production order status. | enum [Enum 5405 "Production Order Status"](../enum/5405.md) |
| 13 | Prod. Order No. | Code[20] | Specifies the production order number. | TableRelation [Table 5405 "Production Order"](../table/5405.md) ("Production Order"."No." where(Status = field("Prod. Order Status"))) |
| 14 | Prod. Order Line No. | Integer | Specifies the production order line number. | TableRelation [Table 5406 "Prod. Order Line"](../table/5406.md) ("Prod. Order Line"."Line No." where(Status = field("Prod. Order Status"), "Prod. Order No." = field("Prod. Order No."))) |
| 15 | Routing No. | Code[20] | Specifies the routing number. | TableRelation [Table 99000763 "Routing Header"](../table/99000763.md) (Routing Header) |
| 16 | Routing Reference No. | Integer | Specifies the routing reference number. | TableRelation [Table 5409 "Prod. Order Routing Line"](../table/5409.md) ("Prod. Order Routing Line"."Routing Reference No." where(Status = field("Prod. Order Status"), "Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."))) |
| 17 | Operation No. | Code[10] | Specifies the operation number. | TableRelation [Table 5409 "Prod. Order Routing Line"](../table/5409.md) ("Prod. Order Routing Line"."Operation No." where(Status = field("Prod. Order Status"), "Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."))) |
| 18 | Work Center No. | Code[20] | Specifies the work center number. | TableRelation [Table 99000754 "Work Center"](../table/99000754.md) (Work Center) |
| 19 | Description | Text[100] | Specifies a description for the WIP ledger entry. |  |
| 20 | Description 2 | Text[50] | Specifies description 2 for the WIP ledger entry. |  |
| 21 | In Transit | Boolean | Specifies whether the WIP quantity is currently in transit. |  |

## Keys

- PK: Entry No. (clustered)
- Key2: Item No., Variant Code, Location Code
- Key3: Prod. Order No., Prod. Order Status, Prod. Order Line No., Routing Reference No., Routing No., Operation No., Location Code
- Key4: Prod. Order No., Prod. Order Status, Prod. Order Line No., Routing Reference No., Routing No., Operation No., Location Code, Item No., Variant Code
- Key5: Document No., Posting Date

## Trigger event subscribers

- OnAfterInsertEvent: [Codeunit 20567 "Subc. Pst. Prev. Event Handler"](../codeunit/20567.md) OnInsertWIPEntry

## Procedures

- `SetProductionOrderFilter(ProductionOrder: Record "Production Order"; SetKey: Boolean)`: Filters the record set to WIP entries for the given production order. When SetKey is true, the sort key is aligned to Key3 before applying the filters.
- `SetProductionOrderRoutingFilter(ProdOrderRoutingLine: Record "Prod. Order Routing Line"; SetKey: Boolean)`: Filters the record set to WIP entries for the given prod. order routing line. When SetKey is true, the sort key is aligned to Key3 before applying the filters.
- `GetNextEntryNo(): Integer`: Gets the next entry number for the Subcontractor WIP Ledger Entry table.

## Relations

- drill-down page [Page 20560 "Subc. WIP Ledger Entries"](../page/20560.md)
- lookup page [Page 20560 "Subc. WIP Ledger Entries"](../page/20560.md)
- Location Code: TableRelation [Table 14 "Location"](../table/14.md)
- Item No.: TableRelation [Table 27 "Item"](../table/27.md)
- Variant Code: TableRelation [Table 5401 "Item Variant"](../table/5401.md)
- Base Unit of Measure: TableRelation [Table 5404 "Item Unit of Measure"](../table/5404.md)
- Prod. Order No.: TableRelation [Table 5405 "Production Order"](../table/5405.md)
- Prod. Order Line No.: TableRelation [Table 5406 "Prod. Order Line"](../table/5406.md)
- Operation No.: TableRelation [Table 5409 "Prod. Order Routing Line"](../table/5409.md)
- Routing Reference No.: TableRelation [Table 5409 "Prod. Order Routing Line"](../table/5409.md)
- Work Center No.: TableRelation [Table 99000754 "Work Center"](../table/99000754.md)
- Routing No.: TableRelation [Table 99000763 "Routing Header"](../table/99000763.md)

## Referenced by

2 fields in 1 objects relate to this table (TableRelation or CalcFormula).

- [Table extension 20506 "Subc. ProdOrderRtngLine Ext."](../tableextension/20506.md): WIP Qty. (Base) at Subc., WIP Qty. (Base) in Transit

## Pages and codeunits on this table

- [Page 20560 "Subc. WIP Ledger Entries"](../page/20560.md) (source table)
- [Page 20561 "Subc. WIP Adjustment"](../page/20561.md) (source table)

## Recent changes

- 2026-08-18 [#9892 [main] Bug 644283: Renumber Subcontracting app object ids as it clashes with partner range](../../changes/bcapps/9892.md) (main, BC30, refactor)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: none

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Subcontractor WIP Ledger Entry")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.