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

Keys

# Fields
0 Entry No. Clustered: Yes
1 Item Ledger Entry No.,Entry Type
2 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
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.
5 Document No.
6 Item No.,Valuation Date,Location Code,Variant Code
7 Source Type,Source No.,Item No.,Posting Date,Entry Type,Adjustment,Item Ledger Entry Type
8 Item Charge No.,Inventory Posting Group,Item No.
9 Capacity Ledger Entry No.,Entry Type
10 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
12 Job No.,Job Task No.,Document No.
13 Item Ledger Entry Type,Posting Date,Item No.,Inventory Posting Group,Dimension Set ID
14 Item Ledger Entry No.,Valuation Date

Table Relations To Other Tables

Field Related Table Related Field
Capacity Ledger Entry No. Capacity Ledger Entry Entry No. 1..n
Source No. Customer No. 1..n
Source Posting Group Customer Posting Group Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Source Posting Group Inventory Posting Group Code 1..n
Source No. Item No. 1..n
Item Charge No. Item Charge No. 1..n
Item Ledger Entry No. Item Ledger Entry Entry No. 1..n
Variant Code Item Variant Code 1..n
Job No. Job No. 1..n
Job Ledger Entry No. Job Ledger Entry Entry No. 1..n
Job Task No. Job Task Job Task No. 1..n
Location Code Location Code 1..n
No. Machine Center No. 1..n
Reason Code Reason Code Code 1..n
No. Resource No. 1..n
Return Reason Code Return Reason Code 1..n
Salespers./Purch. Code Salesperson/Purchaser Code 1..n
Source Code Source Code Code 1..n
User ID User User Name 1..n
Source No. Vendor No. 1..n
Source Posting Group Vendor Posting Group Code 1..n
No. Work Center No. 1..n

Table Relations From Other Tables

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