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

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Item No. (Item No.)
2 Item No.,Posting Date (Item No.,Posting Date)
3 Item No.,Entry Type,Variant Code,Drop Shipment,Location Code,Posting Date (Item No.,Entry Type,Variant Code,Drop Shipment,Location Code,Posting Date)
4 Source Type,Source No.,Item No.,Variant Code,Posting Date (Source Type,Source No.,Item No.,Variant Code,Posting Date)
5 Item No.,Open,Variant Code,Positive,Location Code,Posting Date (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. (Item No.,Open,Variant Code,Positive,Location Code,Posting Date,Expiration Date,Lot No.,Serial No.)
7 Country/Region Code,Entry Type,Posting Date (Country/Region Code,Entry Type,Posting Date)
8 Document No.,Document Type,Document Line No. (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 (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 (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. (Order Type,Order No.,Order Line No.,Entry Type,Prod. Order Comp. Line No.) MaintainSIFTIndex: No
12 Item No.,Applied Entry to Adjust (Item No.,Applied Entry to Adjust)
13 Item No.,Positive,Location Code,Variant Code (Item No.,Positive,Location Code,Variant Code)
14 Entry Type,Nonstock,Item No.,Posting Date (Entry Type,Nonstock,Item No.,Posting Date)
15 Item No.,Location Code,Open,Variant Code,Unit of Measure Code,Lot No.,Serial No. (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. (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. (Item No.,Open,Variant Code,Location Code,Item Tracking,Lot No.,Serial No.) MaintainSQLIndex: No
MaintainSIFTIndex: No
18 Lot No. (Lot No.)
19 Serial No. (Serial No.)

Table Relations To Other Tables

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

Table Relations From Other Tables

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