Table 5832 "Capacity Ledger Entry"
Base Application · Microsoft.Manufacturing.Capacity
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC2617 fields removed, 3 fields changed
- BC273 fields added, 2 fields changed
- BC2831 fields changed
- BC29-30unchanged
Neighbourhood 24 connected objects and pages
Base Application · Microsoft.Manufacturing.Capacity · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 5832 “Capacity Ledger Entries” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Capacity Ledger Entry |
| DataClassification | CustomerContent |
| Permissions | TableData “Capacity Ledger Entry” = ri |
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. Δ BC28 | Integer | Specifies the number of the entry, as assigned from the specified number series when the entry was created. | |
| 2 | No. Δ BC26 Δ BC28 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | TableRelation Table 156 “Resource” (if (Type = const(Resource)) Resource) |
| 3 | Posting Date Δ BC28 | Date | Specifies the posting date of the entry. | |
| 4 | Type Δ BC28 | Enum “Capacity Type Journal” | Specifies the type of capacity entry. | enum Enum 5873 “Capacity Type Journal” |
| 6 | Document No. Δ BC28 | Code[20] | Specifies the document number of the entry. | |
| 7 | Description Δ BC28 | Text[100] | Specifies a description of the entry. | |
| 10 | Quantity Δ BC28 | Decimal | Specifies the quantity of this entry, in base units of measure. | |
| 15 | Invoiced Quantity Δ BC28 | Decimal | — | |
| 20 | Item Register No. + BC26 | Integer | — | TableRelation Table 46 “Item Register” (Item Register); not editable |
| 21 | SIFT Bucket No. + BC26 | Integer | Specifies an automatically generated number that is used by the system to enable better concurrency. | not editable |
| 28 | Cap. Unit of Measure Code Δ BC28 | Code[10] | Specifies the unit of measure code for the capacity usage. | TableRelation Table 99000780 “Capacity Unit of Measure” (Capacity Unit of Measure) |
| 29 | Qty. per Cap. Unit of Measure Δ BC28 | Decimal | — | |
| 33 | Global Dimension 1 Code Δ BC28 | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 34 | Global Dimension 2 Code Δ BC28 | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 42 | Completely Invoiced Δ BC28 | Boolean | Specifies if the entry has been fully invoiced or if more posted invoices are expected. | |
| 56 | Item No. Δ BC28 | Code[20] | Specifies the item number. | TableRelation Table 27 “Item” |
| 57 | Variant Code Δ BC28 | Code[10] | Specifies the variant of the item on the line. | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”))) |
| 58 | Unit of Measure Code | Code[10] | — | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))) |
| 59 | Qty. per Unit of Measure Δ BC28 | Decimal | — | |
| 60 | Document Date | Date | — | |
| 61 | External Document No. | Code[35] | — | |
| 71 | Direct Cost Δ BC28 | Decimal | Specifies the direct cost in LCY of the quantity posting. | FlowField: sum(“Value Entry”.“Cost Amount (Actual)” where(“Capacity Ledger Entry No.” = field(“Entry No.”), “Entry Type” = const(“Direct Cost”))); not editable |
| 72 | Overhead Cost Δ BC28 | Decimal | Specifies the overhead cost in LCY of the quantity posting. | FlowField: sum(“Value Entry”.“Cost Amount (Actual)” where(“Capacity Ledger Entry No.” = field(“Entry No.”), “Entry Type” = const(“Indirect Cost”))); not editable |
| 76 | Direct Cost (ACY) Δ BC27 | Decimal | Specifies the direct cost in the additional reporting currency. via Page 5832 “Capacity Ledger Entries” | FlowField: sum(“Value Entry”.“Cost Amount (Actual) (ACY)” where(“Capacity Ledger Entry No.” = field(“Entry No.”), “Entry Type” = const(“Direct Cost”))); not editable |
| 77 | Overhead Cost (ACY) Δ BC27 | Decimal | Specifies the overhead cost in the additional reporting currency. via Page 5832 “Capacity Ledger Entries” | FlowField: sum(“Value Entry”.“Cost Amount (Actual) (ACY)” where(“Capacity Ledger Entry No.” = field(“Entry No.”), “Entry Type” = const(“Indirect Cost”))); not editable |
| 78 | Subcontracting | Boolean | — | |
| 87 | Reversed + BC27 Δ BC28 | Boolean | Specifies if the entry has been part of a reverse transaction. | |
| 88 | Reversed by Entry No. + BC27 Δ BC28 | Integer | Specifies the number of the correcting entry that replaced the original entry in the reverse transaction. | TableRelation Table 5832 “Capacity Ledger Entry” (Capacity Ledger Entry) |
| 89 | Reversed Entry No. + BC27 Δ BC28 | Integer | Specifies the number of the original entry that was undone by the reverse transaction. | TableRelation Table 5832 “Capacity Ledger Entry” (Capacity Ledger Entry) |
| 90 | Order Type Δ BC28 | Enum “Inventory Order Type” | Specifies which type of order the entry was created in. | enum Enum 90 “Inventory Order Type”; not editable |
| 91 | Order No. Δ BC26 Δ BC28 | Code[20] | Specifies the number of the order that created the entry. | not editable |
| 92 | Order Line No. Δ BC26 Δ BC28 | Integer | Specifies the line number of the order that created the entry. | not editable |
| 480 | Dimension Set ID Δ BC28 | Integer | Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 481 | Shortcut Dimension 3 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(3))); not editable |
| 482 | Shortcut Dimension 4 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(4))); not editable |
| 483 | Shortcut Dimension 5 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(5))); not editable |
| 484 | Shortcut Dimension 6 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(6))); not editable |
| 485 | Shortcut Dimension 7 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(7))); not editable |
| 486 | Shortcut Dimension 8 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(8))); not editable |
Keys
- Key1: Entry No. (clustered)
- Key2: Document No., Posting Date
- Key3: Order Type, Order No., Order Line No.
- Key5: Type, No., Item No., Posting Date
Trigger event subscribers
- OnAfterInsertEvent: Codeunit 99000799 “Mfg. Posting Preview Handler” OnInsertCapacityLedgerEntry
Procedures
GetNextEntryNo(): Integer+ BC26GetLastEntryNo(): IntegerΔ BC26ShowDimensions()
Plus 1 local procedures.
Triggers
OnInsert
Relations
- drill-down page Page 5832 “Capacity Ledger Entries”
- lookup page Page 5832 “Capacity Ledger Entries”
- No.: TableRelation Table 156 “Resource”
- Item No.: TableRelation Table 27 “Item”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Item Register No.: TableRelation Table 46 “Item Register”
- Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
- Direct Cost: CalcFormula Table 5802 “Value Entry”
- Direct Cost (ACY): CalcFormula Table 5802 “Value Entry”
- Overhead Cost: CalcFormula Table 5802 “Value Entry”
- Overhead Cost (ACY): CalcFormula Table 5802 “Value Entry”
- Reversed by Entry No.: TableRelation Table 5832 “Capacity Ledger Entry”
- Reversed Entry No.: TableRelation Table 5832 “Capacity Ledger Entry”
- Cap. Unit of Measure Code: TableRelation Table 99000780 “Capacity Unit of Measure”
Referenced by
12 fields in 7 objects relate to this table (TableRelation or CalcFormula).
- Table 5409 “Prod. Order Routing Line”: Posted Output Quantity, Posted Run Time, Posted Scrap Quantity, Posted Setup Time
- Table 46 “Item Register”: From Capacity Entry No., To Capacity Entry No.
- Table 5832 “Capacity Ledger Entry”: Reversed by Entry No., Reversed Entry No.
- Table 5405 “Production Order”: Actual Time Used
- Table 5802 “Value Entry”: Capacity Ledger Entry No.
- Table 6227 “Sustainability Value Entry”: Capacity Ledger Entry No.
- Table extension 99000758 “Mfg. Item Journal Line”: Rev. Capacity Ledger Entry No.
Pages and codeunits on this table
- Page 5832 “Capacity Ledger Entries” (source table)
Extended by
- Table extension 20504 “Subc. Cap Ledger Entry Ext.”
- Table extension 6259 “Sust. Capacity Ledger Entry”
- Table extension 99000801 “Mfg. Capacity Ledger Entry”
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 703 “Find Record Management” (1 call:
GetLastEntryNo → GetLastEntryIntFieldValue) - Codeunit 9500 “Sequence No. Mgt.” (1 call:
GetNextEntryNo → GetNextSeqNo)
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "Capacity Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.