Diagrams


Table

Value Entry

DynamicsDocs.comValue Entry«Table 5802»Value EntryEntry No. [PK]Item No.Posting DateItem Ledger Entry Type; [Purchase,Sale...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupItem Ledger Entry No.Valued QuantityItem Ledger Entry QuantityInvoiced QuantityCost per UnitSales Amount [Actual]Salespers./Purch. CodeDiscount AmountUser IDSource CodeApplies-to EntryGlobal Dimension 1 CodeGlobal Dimension 2 CodeSource Type; [,Customer,Vendor,Item]Cost Amount [Actual]Cost Posted to G/LReason CodeDrop ShipmentJournal Batch NameGen. Bus. Posting GroupGen. Prod. Posting Group...«Table 5823»G/L - Item Ledger RelationG/L Entry No. [PK,NN]Value Entry No. [PK,NN]G/L Register No.«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 94»Inventory Posting GroupCode [PK,NN]Description«Table 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line Account«Table 93»Vendor Posting GroupCode [PK,NN]Payables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 5800»Item ChargeNo. [PK,NN]DescriptionGen. Prod. Posting GroupTax Group CodeVAT Prod. Posting GroupSearch DescriptionGlobal Dimension 1 CodeGlobal Dimension 2 Code«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 99000758»Machine CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeWork Center No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyBlockedDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Need AmountProd. Order Status Filter; [Simulated,...Setup TimeWait TimeMove Time...«Table 99000754»Work CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeAlternate Work CenterWork Center Group CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeSubcontractor No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentUnit of Measure CodeCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyCalendar Rounding Precision [NN]Simulation Type; [Moves,Moves When Nec...Shop Calendar CodeBlockedDate FilterWork Shift Filter...«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 6635»Return ReasonCode [PK,NN]DescriptionDefault Location CodeInventory Value Zero<Item No.><Source No.><Source No.><Source No.><Location Code><Inventory Posting Group><Source Posting Group><Source Posting Group><Source Posting Group><User ID><Reason Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Item Charge No.><Job No.><Job Task No.><Variant Code><No.><No.><No.><Return Reason Code><Value Entry No.><Inventory Posting Group><Vendor No.><Alternative Item No.><Location Filter><Gen. Prod. Posting Group><Variant Filter><Item No.><Item Filter><Customer Posting Group><Bill-to Customer No.><Location Code><Gen. Bus. Posting Group><Bill-to Customer No.><Vendor Posting Group><Pay-to Vendor No.><Gen. Bus. Posting Group><Location Code><Vendor No.><Subcontractor No.><Default Location Code><Location Code><Location Code><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Person Responsible><Resource Filter><Job No.><Work Center No.><Alternate Work Center>

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 Item Ledger Entry Type (Item Ledger 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
9 Inventory Posting Group (Inventory Posting Group) Code10
10 Source Posting Group (Source Posting Group) Code10
11 Item Ledger Entry No. (Item Ledger Entry No.) Integer
12 Valued Quantity (Valued Quantity) Decimal (0:5)
13 Item Ledger Entry Quantity (Item Ledger Entry Quantity) Decimal (0:5)
14 Invoiced Quantity (Invoiced Quantity) Decimal (0:5)
15 Cost per Unit (Cost per Unit) Decimal
17 Sales Amount (Actual) (Sales Amount (Actual)) Decimal
22 Salespers./Purch. Code (Salespers./Purch. Code) Code10
23 Discount Amount (Discount Amount) Decimal
24 User ID (User ID) Code50
25 Source Code (Source Code) Code10
28 Applies-to Entry (Applies-to Entry) Integer
33 Global Dimension 1 Code (Global Dimension 1 Code) Code20
34 Global Dimension 2 Code (Global Dimension 2 Code) Code20
41 Source Type (Source Type) Option
43 Cost Amount (Actual) (Cost Amount (Actual)) Decimal
45 Cost Posted to G/L (Cost Posted to G/L) Decimal
46 Reason Code (Reason Code) Code10
47 Drop Shipment (Drop Shipment) Boolean
48 Journal Batch Name (Journal Batch Name) Code10
57 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
58 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
60 Document Date (Document Date) Date
61 External Document No. (External Document No.) Code35
68 Cost Amount (Actual) (ACY) (Cost Amount (Actual) (ACY)) Decimal
70 Cost Posted to G/L (ACY) (Cost Posted to G/L (ACY)) Decimal
72 Cost per Unit (ACY) (Cost per Unit (ACY)) Decimal
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
98 Expected Cost (Expected Cost) Boolean
99 Item Charge No. (Item Charge No.) Code20
100 Valued By Average Cost (Valued By Average Cost) Boolean
102 Partial Revaluation (Partial Revaluation) Boolean
103 Inventoriable (Inventoriable) Boolean
104 Valuation Date (Valuation Date) Date
105 Entry Type (Entry Type) Option Editable: No
106 Variance Type (Variance Type) Option Editable: No
148 Purchase Amount (Actual) (Purchase Amount (Actual)) Decimal
149 Purchase Amount (Expected) (Purchase Amount (Expected)) Decimal
150 Sales Amount (Expected) (Sales Amount (Expected)) Decimal
151 Cost Amount (Expected) (Cost Amount (Expected)) Decimal
152 Cost Amount (Non-Invtbl.) (Cost Amount (Non-Invtbl.)) Decimal
156 Cost Amount (Expected) (ACY) (Cost Amount (Expected) (ACY)) Decimal
157 Cost Amount (Non-Invtbl.)(ACY) (Cost Amount (Non-Invtbl.)(ACY)) Decimal
158 Expected Cost Posted to G/L (Expected Cost Posted to G/L) Decimal
159 Exp. Cost Posted to G/L (ACY) (Exp. Cost Posted to G/L (ACY)) Decimal
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
1000 Job No. (Job No.) Code20
1001 Job Task No. (Job Task No.) Code20
1002 Job Ledger Entry No. (Job Ledger Entry No.) Integer BlankZero: Yes
5402 Variant Code (Variant Code) Code10
5818 Adjustment (Adjustment) Boolean Editable: No
5819 Average Cost Exception (Average Cost Exception) Boolean
5831 Capacity Ledger Entry No. (Capacity Ledger Entry No.) Integer
5832 Type (Type) Option
5834 No. (No.) Code20
6602 Return Reason Code (Return Reason Code) Code10

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Item Ledger Entry No.,Entry Type (Item Ledger Entry No.,Entry Type) MaintainSIFTIndex: No
2 Item Ledger Entry No.,Document No.,Document Line No. (Item Ledger Entry No.,Document No.,Document Line No.) MaintainSQLIndex: No
3 Item No.,Posting Date,Item Ledger Entry Type,Entry Type,Variance Type,Item Charge No.,Location Code,Variant Code (Item No.,Posting Date,Item Ledger Entry Type,Entry Type,Variance Type,Item Charge No.,Location Code,Variant Code)
4 Item No.,Posting Date,Item Ledger Entry Type,Entry Type,Variance Type,Item Charge No.,Location Code,Variant Code,Global Dimension 1 Code,Global Dimension 2 Code,Source Type,Source No. (Item No.,Posting Date,Item Ledger Entry Type,Entry Type,Variance Type,Item Charge No.,Location Code,Variant Code,Global Dimension 1 Code,Global Dimension 2 Code,Source Type,Source No.)
5 Document No. (Document No.)
6 Item No.,Valuation Date,Location Code,Variant Code (Item No.,Valuation Date,Location Code,Variant Code)
7 Source Type,Source No.,Item No.,Posting Date,Entry Type,Adjustment,Item Ledger Entry Type (Source Type,Source No.,Item No.,Posting Date,Entry Type,Adjustment,Item Ledger Entry Type)
8 Item Charge No.,Inventory Posting Group,Item No. (Item Charge No.,Inventory Posting Group,Item No.)
9 Capacity Ledger Entry No.,Entry Type (Capacity Ledger Entry No.,Entry Type)
10 Order Type,Order No.,Order Line No. (Order Type,Order No.,Order Line No.)
11 Source Type,Source No.,Global Dimension 1 Code,Global Dimension 2 Code,Item No.,Posting Date,Entry Type,Adjustment (Source Type,Source No.,Global Dimension 1 Code,Global Dimension 2 Code,Item No.,Posting Date,Entry Type,Adjustment)
12 Job No.,Job Task No.,Document No. (Job No.,Job Task No.,Document No.)
13 Item Ledger Entry Type,Posting Date,Item No.,Inventory Posting Group,Dimension Set ID (Item Ledger Entry Type,Posting Date,Item No.,Inventory Posting Group,Dimension Set ID)
14 Item Ledger Entry No.,Valuation Date (Item Ledger Entry No.,Valuation Date)

Table Relations To Other Tables

Field Related Table Related Field
Capacity Ledger Entry No. (Capacity Ledger Entry No.) Capacity Ledger Entry Entry No. (Entry No.) 1..n
Source No. (Source No.) Customer No. (No.) 1..n
Source Posting Group (Source Posting Group) Customer Posting Group Code (Code) 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
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
Source Posting Group (Source Posting Group) Inventory Posting Group Code (Code) 1..n
Source No. (Source No.) Item No. (No.) 1..n
Item Charge No. (Item Charge No.) Item Charge No. (No.) 1..n
Item Ledger Entry No. (Item Ledger Entry No.) Item Ledger Entry Entry No. (Entry No.) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Job No. (Job No.) Job No. (No.) 1..n
Job Ledger Entry No. (Job Ledger Entry No.) Job Ledger Entry Entry No. (Entry 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. (No.) Machine Center No. (No.) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
No. (No.) Resource No. (No.) 1..n
Return Reason Code (Return Reason Code) Return Reason Code (Code) 1..n
Salespers./Purch. Code (Salespers./Purch. Code) Salesperson/Purchaser Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n
Source No. (Source No.) Vendor No. (No.) 1..n
Source Posting Group (Source Posting Group) Vendor Posting Group Code (Code) 1..n
No. (No.) Work Center No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
G/L - Item Ledger Relation Value Entry No. (Value Entry No.) 1..n
Invt. Post to G/L Test Buffer Value Entry No. (Value Entry No.) 1..n
Item Register To Value Entry No. (To Value Entry No.) 1..n
Post Value Entry to G/L Value Entry No. (Value Entry No.) 1..1
Value Entry Relation Value Entry No. (Value Entry No.) 1..1