Table 20560 "Subcontractor WIP Ledger Entry"

Subcontracting · Microsoft.Manufacturing.Subcontracting · BC29-30 · source at ea08af5e · 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”
3	Variant Code	Code[10]	Specifies the variant code.	TableRelation Table 5401 “Item Variant” (“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”
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”
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” (“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”
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”
13	Prod. Order No.	Code[20]	Specifies the production order number.	TableRelation Table 5405 “Production Order” (“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” (“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” (Routing Header)
16	Routing Reference No.	Integer	Specifies the routing reference number.	TableRelation Table 5409 “Prod. Order Routing Line” (“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” (“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” (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” 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”
lookup page Page 20560 “Subc. WIP Ledger Entries”
Location Code: TableRelation Table 14 “Location”
Item No.: TableRelation Table 27 “Item”
Variant Code: TableRelation Table 5401 “Item Variant”
Base Unit of Measure: TableRelation Table 5404 “Item Unit of Measure”
Prod. Order No.: TableRelation Table 5405 “Production Order”
Prod. Order Line No.: TableRelation Table 5406 “Prod. Order Line”
Operation No.: TableRelation Table 5409 “Prod. Order Routing Line”
Routing Reference No.: TableRelation Table 5409 “Prod. Order Routing Line”
Work Center No.: TableRelation Table 99000754 “Work Center”
Routing No.: TableRelation Table 99000763 “Routing Header”

Referenced by

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

Table extension 20506 “Subc. ProdOrderRtngLine Ext.”: WIP Qty. (Base) at Subc., WIP Qty. (Base) in Transit

Pages and codeunits on this table

Page 20560 “Subc. WIP Ledger Entries” (source table)
Page 20561 “Subc. WIP Adjustment” (source table)

Recent changes

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

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.