Phys. Inventory Ledger Entry #281

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

43
Fields
0
Records
1
Primary key
6
FlowFields
18
Relations
Open in Data Explorer →

Primary key

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

All fields (43)

Phys. Inventory Ledger Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Item No. Code Normal → Item #27
3 Posting Date Date Normal
4 Entry Type Option Normal
6 Document No. Code Normal
7 Description Text Normal
8 Location Code Code Normal → Location #14
9 Inventory Posting Group Code Normal → Inventory Posting Group #94
12 Quantity Decimal Normal
15 Unit Amount Decimal Normal
16 Unit Cost Decimal Normal
17 Amount Decimal Normal
20 Item Register No. Integer Normal → Item Register #46
21 SIFT Bucket No. Integer Normal
22 Salespers./Purch. Code Code Normal → Salesperson/Purchaser #13
24 User ID Code Normal
25 Source Code Code Normal → Source Code #230
33 Global Dimension 1 Code Code Normal → Dimension Value #349
34 Global Dimension 2 Code Code Normal → Dimension Value #349
45 Journal Batch Name Code Normal
46 Reason Code Code Normal → Reason Code #231
54 Qty. (Calculated) Decimal Normal
55 Qty. (Phys. Inventory) Decimal Normal
56 Last Item Ledger Entry No. Integer Normal → Item Ledger Entry #32
60 Document Date Date Normal
61 External Document No. Code Normal
64 No. Series Code Normal → No. Series #308
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
5402 Variant Code Code Normal → Item Variant #5401
5407 Unit of Measure Code Code Normal → Item Unit of Measure #5404
7380 Phys Invt Counting Period Code Code Normal → Phys. Invt. Counting Period #7381
7381 Phys Invt Counting Period Type Option 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 (15)

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

Item
#27 · Inventory · via Item No.
Location
#14 · General Ledger · via Location Code
Inventory Posting Group
#94 · Other · via Inventory Posting Group
Item Register
#46 · Sales Documents · via Item Register No.
Salesperson/Purchaser
#13 · General Ledger · via Salespers./Purch. Code
Source Code
#230 · Other · via Source Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Reason Code
#231 · Other · via Reason Code
Item Ledger Entry
#32 · Inventory · via Last Item Ledger Entry No.
No. Series
#308 · Other · via No. Series
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Item Variant
#5401 · Other · via Variant Code
Item Unit of Measure
#5404 · Other · via Unit of Measure Code
Phys. Invt. Counting Period
#7381 · Warehouse · via Phys Invt Counting Period Code