Item Ledger Entries – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages IItem Ledger Entries

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/page38

Page Name: Item Ledger Entries
Page Number: 38
Page Type: List

Source Table Name: Item Ledger Entry
Source Table Number: 32

Show/hide columns in the Item Ledger Entries page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	1865609574	Posting Date	3	Posting Date	true	True	true
1	1584970974	Entry Type	4	Entry Type	true	True	true
	Available options are: “Purchase” “Sale” “Positive Adjmt.” “Negative Adjmt.” “Transfer” “Consumption” “Output” ” “ “Assembly Consumption” “Assembly Output”
2	1366511753	Document Type	79	Document Type	true	True	true
	Available options are: ” “ “Sales Shipment” “Sales Invoice” “Sales Return Receipt” “Sales Credit Memo” “Purchase Receipt” “Purchase Invoice” “Purchase Return Shipment” “Purchase Credit Memo” “Transfer Shipment” “Transfer Receipt” “Service Shipment” “Service Invoice” “Service Credit Memo” “Posted Assembly” “Inventory Receipt” “Inventory Shipment” “Direct Transfer”
3	1756192230	Document No.	6	Document No.	true	True	true
4	507324832	Document Line No.	80	Document Line No.	true	True	false
5	285335908	Item No.	2	Item No.	true	True	true
6	686115772	Variant Code	5402	Variant Code	true	True	false
7	1159658584	Description	7	Description	true	True	true
8	1749565869	Return Reason Code	6602	Return Reason Code	true	True	false
9	1221243953	Global Dimension 1 Code	33	Global Dimension 1 Code	true	True	p38p38Dim1Visible
10	721432654	Global Dimension 2 Code	34	Global Dimension 2 Code	true	True	p38p38Dim2Visible
11	1429452143	Expiration Date	6503	Expiration Date	true	True	false
12	804533121	Serial No.	6500	Serial No.	true	True	false
13	2131683510	Lot No.	6501	Lot No.	true	True	false
14	1609633139	Package No.	6515	Package No.	true	True	p38p38PackageTrackingVisible
15	1606704610	Location Code	8	Location Code	true	True	true
16	1715193811	Quantity	12	Quantity	true	True	true
17	283243184	Invoiced Quantity	14	Invoiced Quantity	true	True	true
18	1415035551	Remaining Quantity	13	Remaining Quantity	true	True	true
19	584306887	Shipped Qty. Not Returned	5818	Shipped Qty. Not Returned	true	True	false
20	49291287	Reserved Quantity	70	Reserved Quantity	true	False	false
21	838293660	Qty. per Unit of Measure	5404	Qty. per Unit of Measure	true	True	false
22	1375267244	Unit of Measure Code	5407	Unit of Measure Code	true	True	false
23	1214799563	Sales Amount (Expected)	5815	Sales Amount (Expected)	true	False	false
24	333320643	Sales Amount (Actual)	5816	Sales Amount (Actual)	true	False	true
25	181399582	Cost Amount (Expected)	5803	Cost Amount (Expected)	true	False	false
26	857303590	Cost Amount (Actual)	5804	Cost Amount (Actual)	true	False	true
27	1346612903	Cost Amount (Non-Invtbl.)	5805	Cost Amount (Non-Invtbl.)	true	False	true
28	216821812	Cost Amount (Expected) (ACY)	5806	Cost Amount (Expected) (ACY)	true	False	false
29	1158397868	Cost Amount (Actual) (ACY)	5807	Cost Amount (Actual) (ACY)	true	False	false
30	450272149	Cost Amount (Non-Invtbl.)(ACY)	5808	Cost Amount (Non-Invtbl.)(ACY)	true	False	false
31	1142438841	Completely Invoiced	5800	Completely Invoiced	true	True	false
32	1401060486	Open	29	Open	true	True	true
33	972123385	Drop Shipment	47	Drop Shipment	true	True	false
34	1629535281	Assemble to Order	904	Assemble to Order	true	True	false
35	689749967	Applied Entry to Adjust	5802	Applied Entry to Adjust	true	True	false
36	258263488	Order Type	90	Order Type	true	False	true
	Available options are: ” “ “Production” “Transfer” “Service” “Assembly”
37	1206109543	Order No.	91	Order No.	true	False	false
38	730362153	Order Line No.	92	Order Line No.	true	False	false
39	549478297	Prod. Order Comp. Line No.	5833	Prod. Order Comp. Line No.	true	True	false
40	1233206187	Entry No.	1	Entry No.	true	True	true
41	1164798694	Job No.	1000	Job No.	true	True	false
42	754756109	Job Task No.	1001	Job Task No.	true	True	false
43	1830077831	Dimension Set ID	480	Dimension Set ID	true	False	false
44	1619612888	Shortcut Dimension 3 Code	481	Shortcut Dimension 3 Code	true	false	p38p38Dim3Visible
45	1294940465	Shortcut Dimension 4 Code	482	Shortcut Dimension 4 Code	true	false	p38p38Dim4Visible
46	258234478	Shortcut Dimension 5 Code	483	Shortcut Dimension 5 Code	true	false	p38p38Dim5Visible
47	832041421	Shortcut Dimension 6 Code	484	Shortcut Dimension 6 Code	true	false	p38p38Dim6Visible
48	1349184596	Shortcut Dimension 7 Code	485	Shortcut Dimension 7 Code	true	false	p38p38Dim7Visible
49	1351332893	Shortcut Dimension 8 Code	486	Shortcut Dimension 8 Code	true	false	p38p38Dim8Visible
50	1660970717	Source Type	41	Source Type	true	True	false
	Available options are: ” “ “Customer” “Vendor” “Item”
51	852458860	Source No.	5	Source No.	true	True	false

Dynamics 365 BC Table Reference Pages IItem Ledger Entries

Show/hide columns in the Item Ledger Entries page

Leave a Reply Cancel reply