Capacity Ledger Entry #5832

Other table in Microsoft Dynamics 365 Business Central. 67 fields, 0 records in Cronus demo.

67
Fields
0
Records
1
Primary key
10
FlowFields
21
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (67)

Capacity Ledger Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 No. Code Normal
3 Posting Date Date Normal
4 Type Option Normal
6 Document No. Code Normal
7 Description Text Normal
8 Operation No. Code Normal
9 Work Center No. Code Normal → Work Center #99000754
10 Quantity Decimal Normal
11 Setup Time Decimal Normal
12 Run Time Decimal Normal
13 Stop Time Decimal Normal
15 Invoiced Quantity Decimal Normal
16 Output Quantity Decimal Normal
17 Scrap Quantity Decimal Normal
19 Concurrent Capacity Decimal Normal
20 Item Register No. Integer Normal → Item Register #46
21 SIFT Bucket No. Integer Normal
28 Cap. Unit of Measure Code Code Normal → Capacity Unit of Measure #99000780
29 Qty. per Cap. Unit of Measure Decimal Normal
33 Global Dimension 1 Code Code Normal → Dimension Value #349
34 Global Dimension 2 Code Code Normal → Dimension Value #349
39 Last Output Line Boolean Normal
42 Completely Invoiced Boolean Normal
43 Starting Time Time Normal
44 Ending Time Time Normal
52 Routing No. Code Normal → Routing Header #99000763
53 Routing Reference No. Integer Normal
56 Item No. Code Normal → Item #27
57 Variant Code Code Normal → Item Variant #5401
58 Unit of Measure Code Code Normal → Item Unit of Measure #5404
59 Qty. per Unit of Measure Decimal Normal
60 Document Date Date Normal
61 External Document No. Code Normal
65 Stop Code Code Normal → Stop #99000761
66 Scrap Code Code Normal → Scrap #99000762
68 Work Center Group Code Code Normal → Work Center Group #99000756
69 Work Shift Code Code Normal → Work Shift #99000750
71 Direct Cost ⚡ FLOW Decimal FlowField
72 Overhead Cost ⚡ FLOW Decimal FlowField
76 Direct Cost (ACY) ⚡ FLOW Decimal FlowField
77 Overhead Cost (ACY) ⚡ FLOW Decimal FlowField
78 Subcontracting Boolean Normal
87 Reversed Boolean Normal
88 Reversed by Entry No. Integer Normal → Capacity Ledger Entry #5832
89 Reversed Entry No. Integer Normal → Capacity Ledger Entry #5832
90 Order Type Option Normal
91 Order No. Code Normal
92 Order Line No. Integer Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
481 Shortcut Dimension 3 Code ⚡ FLOW Code FlowField
482 Shortcut Dimension 4 Code ⚡ FLOW Code FlowField
483 Shortcut Dimension 5 Code ⚡ FLOW Code FlowField
484 Shortcut Dimension 6 Code ⚡ FLOW Code FlowField
485 Shortcut Dimension 7 Code ⚡ FLOW Code FlowField
486 Shortcut Dimension 8 Code ⚡ FLOW Code FlowField
6210 Sustainability Account No. Code Normal → Sustainability Account #6210
6211 Sustainability Account Name Text Normal
6212 Sustainability Account Category Code Normal → Sustain. Account Category #6211
6213 Sustainability Account Subcategory Code Normal → Sustain. Account Subcategory #6212
6214 CO2e per Unit Decimal Normal
6215 Total CO2e Decimal Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (18)

Tables referenced by fields on the Capacity Ledger Entry table through TableRelation properties.

Work Center
#99000754 · Manufacturing · via Work Center No.
Item Register
#46 · Sales Documents · via Item Register No.
Capacity Unit of Measure
#99000780 · Manufacturing · via Cap. Unit of Measure Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Routing Header
#99000763 · Manufacturing · via Routing No.
Item
#27 · Inventory · via Item No.
Item Variant
#5401 · Other · via Variant Code
Item Unit of Measure
#5404 · Other · via Unit of Measure Code
Stop
#99000761 · Manufacturing · via Stop Code
Scrap
#99000762 · Manufacturing · via Scrap Code
Work Center Group
#99000756 · Manufacturing · via Work Center Group Code
Work Shift
#99000750 · Manufacturing · via Work Shift Code
Capacity Ledger Entry
#5832 · Other · via Reversed by Entry No., Reversed Entry No.
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Sustainability Account
#6210 · Other · via Sustainability Account No.
Sustain. Account Category
#6211 · Other · via Sustainability Account Category
Sustain. Account Subcategory
#6212 · Other · via Sustainability Account Subcategory