Diagrams


Table

Item Ledger Entry

DynamicsDocs.comItem Ledger Entry«Table 32»Item Ledger EntryEntry No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeQuantityRemaining QuantityInvoiced QuantityApplies-to EntryOpenGlobal Dimension 1 CodeGlobal Dimension 2 CodePositiveSource Type; [,Customer,Vendor,Item]Drop ShipmentTransaction TypeTransport MethodCountry/Region CodeEntry/Exit PointDocument DateExternal Document No.AreaTransaction SpecificationNo. SeriesReserved QuantityDocument Type; [,Sales Shipment,Sales...Document Line No.Order Type; [,Production,Transfer,Serv......«Table 336»Tracking SpecificationEntry No. [PK]Item No.Location CodeQuantity [Base]DescriptionCreation DateSource TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source IDSource Batch NameSource Prod. Order LineSource Ref. No.Item Ledger Entry No.Transfer Item Entry No.Serial No.PositiveQty. per Unit of MeasureAppl.-to Item EntryWarranty DateExpiration DateQty. to Handle [Base]Qty. to Invoice [Base]Quantity Handled [Base]Quantity Invoiced [Base]Qty. to HandleQty. to InvoiceBuffer Status; [,MODIFY,INSERT]Buffer Status2; [,ExpDate blocked]Buffer Value1Buffer Value2Buffer Value3...«Table 5830»Availability Calc. OverviewEntry No. [PK]Type; [Item,As of Date,Inventory,Suppl...DateItem No.Location CodeVariant CodeUnit of Measure CodeAttached to Entry No.LevelSource TypeSource Order StatusSource IDSource Batch NameSource Ref. No.Source Prod. Order LineDescriptionQuantityReserved QuantityInventory Running TotalSupply Running TotalDemand Running TotalRunning TotalMatches Criteria«Table 5847»Average Cost Calc. OverviewEntry No. [PK]Type; [Closing Entry,Increase,Applied...Valuation DateItem No.Location CodeVariant CodeCost is AdjustedAttached to Entry No.Attached to Valuation DateLevelItem Ledger Entry No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Document Type; [,Sales Shipment,Sales...Document No.Document Line No.DescriptionQuantityApplied QuantityCost Amount [Expected]Cost Amount [Actual]«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 258»Transaction TypeCode [PK,NN]Description«Table 259»Transport MethodCode [PK,NN]Description«Table 282»Entry/Exit PointCode [PK,NN]Description«Table 285»Transaction SpecificationCode [PK,NN]Text«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Open,Completed...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 1001»Job TaskJob No. [PK,NN]Job Task No. [PK,NN]DescriptionJob Task Type; [Posting,Heading,Total,...WIP-Total; [,Total,Excluded]Job Posting GroupWIP MethodSchedule [Total Cost]Schedule [Total Price]Usage [Total Cost]Usage [Total Price]Contract [Total Cost]Contract [Total Price]Contract [Invoiced Price]Contract [Invoiced Cost]Posting Date FilterPlanning Date FilterTotalingNew PageNo. of Blank LinesIndentationRecognized Sales AmountRecognized Costs AmountRecognized Sales G/L AmountRecognized Costs G/L AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeOutstanding OrdersAmt. Rcd. Not InvoicedRemaining [Total Cost]Remaining [Total Price]...«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 5722»Item CategoryCode [PK,NN]Parent CategoryDescriptionIndentationPresentation OrderHas ChildrenLast Modified Date TimeId«Table 5721»PurchasingCode [PK,NN]DescriptionDrop ShipmentSpecial Order«Table 6635»Return ReasonCode [PK,NN]DescriptionDefault Location CodeInventory Value Zero<Item No.><Source No.><Originally Ordered No.><Source No.><Source No.><Location Code><Transaction Type><Transport Method><Entry/Exit Point><Transaction Specification><Job No.><Job Task No.><Variant Code><Originally Ordered Var. Code><Unit of Measure Code><Item Category Code><Purchasing Code><Return Reason Code><Item Ledger Entry No.><Transfer Item Entry No.><Attached to Entry No.><Attached to Entry No.><Item Ledger Entry No.><Item No.><Location Code><Variant Code><Item No.><Location Code><Variant Code><Item No.><Location Code><Variant Code><Vendor No.><Alternative Item No.><Location Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Item Category Code><Bill-to Customer No.><Location Code><Bill-to Customer No.><Pay-to Vendor No.><Location Code><Default Location Code><Job No.><Parent Category>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Entry No. Integer
2 Item No. Code20
3 Posting Date Date
4 Entry Type Option
5 Source No. Code20
6 Document No. Code20
7 Description Text50
8 Location Code Code10
12 Quantity Decimal (0:5)
13 Remaining Quantity Decimal (0:5)
14 Invoiced Quantity Decimal (0:5)
28 Applies-to Entry Integer
29 Open Boolean
33 Global Dimension 1 Code Code20
34 Global Dimension 2 Code Code20
36 Positive Boolean
41 Source Type Option
47 Drop Shipment Boolean
50 Transaction Type Code10
51 Transport Method Code10
52 Country/Region Code Code10
59 Entry/Exit Point Code10
60 Document Date Date
61 External Document No. Code35
62 Area Code10
63 Transaction Specification Code10
64 No. Series Code20
70 Reserved Quantity Decimal (0:5) Editable: No
FlowField
79 Document Type Option
80 Document Line No. Integer
90 Order Type Option Editable: No
91 Order No. Code20 Editable: No
92 Order Line No. Integer Editable: No
480 Dimension Set ID Integer Editable: No
904 Assemble to Order Boolean
1000 Job No. Code20
1001 Job Task No. Code20
1002 Job Purchase Boolean
5402 Variant Code Code10
5404 Qty. per Unit of Measure Decimal (0:5)
5407 Unit of Measure Code Code10
5408 Derived from Blanket Order Boolean
5700 Cross-Reference No. Code20
5701 Originally Ordered No. Code20
5702 Originally Ordered Var. Code Code10
5703 Out-of-Stock Substitution Boolean
5704 Item Category Code Code20
5705 Nonstock Boolean
5706 Purchasing Code Code10
5707 Product Group Code Code10
5800 Completely Invoiced Boolean
5801 Last Invoice Date Date
5802 Applied Entry to Adjust Boolean
5803 Cost Amount (Expected) Decimal Editable: No
FlowField
5804 Cost Amount (Actual) Decimal Editable: No
FlowField
5805 Cost Amount (Non-Invtbl.) Decimal Editable: No
FlowField
5806 Cost Amount (Expected) (ACY) Decimal Editable: No
FlowField
5807 Cost Amount (Actual) (ACY) Decimal Editable: No
FlowField
5808 Cost Amount (Non-Invtbl.)(ACY) Decimal Editable: No
FlowField
5813 Purchase Amount (Expected) Decimal Editable: No
FlowField
5814 Purchase Amount (Actual) Decimal Editable: No
FlowField
5815 Sales Amount (Expected) Decimal Editable: No
FlowField
5816 Sales Amount (Actual) Decimal Editable: No
FlowField
5817 Correction Boolean
5818 Shipped Qty. Not Returned Decimal (0:5)
5833 Prod. Order Comp. Line No. Integer
6500 Serial No. Code20
6501 Lot No. Code20
6502 Warranty Date Date
6503 Expiration Date Date
6510 Item Tracking Option Editable: No
6602 Return Reason Code Code10

Keys

# Fields
0 Entry No. Clustered: Yes
1 Item No.
2 Item No.,Posting Date
3 Item No.,Entry Type,Variant Code,Drop Shipment,Location Code,Posting Date
4 Source Type,Source No.,Item No.,Variant Code,Posting Date
5 Item No.,Open,Variant Code,Positive,Location Code,Posting Date
6 Item No.,Open,Variant Code,Positive,Location Code,Posting Date,Expiration Date,Lot No.,Serial No.
7 Country/Region Code,Entry Type,Posting Date
8 Document No.,Document Type,Document Line No.
9 Item No.,Entry Type,Variant Code,Drop Shipment,Global Dimension 1 Code,Global Dimension 2 Code,Location Code,Posting Date
10 Source Type,Source No.,Global Dimension 1 Code,Global Dimension 2 Code,Item No.,Variant Code,Posting Date
11 Order Type,Order No.,Order Line No.,Entry Type,Prod. Order Comp. Line No. MaintainSIFTIndex: No
12 Item No.,Applied Entry to Adjust
13 Item No.,Positive,Location Code,Variant Code
14 Entry Type,Nonstock,Item No.,Posting Date
15 Item No.,Location Code,Open,Variant Code,Unit of Measure Code,Lot No.,Serial No.
16 Item No.,Open,Variant Code,Positive,Lot No.,Serial No. MaintainSQLIndex: No
MaintainSIFTIndex: No
17 Item No.,Open,Variant Code,Location Code,Item Tracking,Lot No.,Serial No. MaintainSQLIndex: No
MaintainSIFTIndex: No
18 Lot No.
19 Serial No.

Table Relations To Other Tables

Field Related Table Related Field
Area Area Code 1..n
Country/Region Code Country/Region Code 1..n
Source No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Entry/Exit Point Entry/Exit Point Code 1..n
Originally Ordered No. Item No. 1..n
Item Category Code Item Category Code 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Originally Ordered Var. Code Item Variant Code 1..n
Job No. Job No. 1..n
Job Task No. Job Task Job Task No. 1..n
Location Code Location Code 1..n
No. Series No. Series Code 1..n
Purchasing Code Purchasing Code 1..n
Return Reason Code Return Reason Code 1..n
Transaction Specification Transaction Specification Code 1..n
Transaction Type Transaction Type Code 1..n
Transport Method Transport Method Code 1..n
Source No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Availability Calc. Overview Attached to Entry No. 1..n
Average Cost Calc. Overview Item Ledger Entry No. 1..n
Intrastat Jnl. Line Source Entry No. 1..n
Inventory Adjustment Buffer Item Ledger Entry No. 1..n
Item Application Entry Transferred-from Entry No. 1..n
Item Application Entry History Transferred-from Entry No. 1..n
Item Entry Relation Item Entry No. 1..1
Item Journal Line Last Item Ledger Entry No. 1..n
Item Register To Entry No. 1..n
Item Tracing Buffer Item Ledger Entry No. 1..n
Job Journal Line Ledger Entry No. 1..n
Job Ledger Entry Ledger Entry No. 1..n
Job Planning Line Ledger Entry No. 1..n
Phys. Inventory Ledger Entry Last Item Ledger Entry No. 1..n
Reservation Entry Item Ledger Entry No. 1..n
Tracking Specification Transfer Item Entry No. 1..n
Value Entry Item Ledger Entry No. 1..n
Whse. Item Entry Relation Item Entry No. 1..1