Diagrams


Table

Inventory Adjustment Buffer

DynamicsDocs.comInventory Adjustment Buffer«Table 5895»Inventory Adjustment BufferEntry No. [PK]Item No.Posting DateDocument No.Location CodeItem Ledger Entry No.Item Ledger Entry QuantityCost Amount [Actual]Cost Amount [Actual] [ACY]Expected CostValued By Average CostValuation DateEntry Type; [Direct Cost,Revaluation,R...Variance Type; [,Purchase,Material,Cap...Cost Amount [Expected]Cost Amount [Expected] [ACY]Variant Code«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 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 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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Item No.><Location Code><Item Ledger Entry No.><Variant Code><Alternative Item No.><Location Filter><Variant Filter><Item No.><Item No.><Source No.><Originally Ordered No.><Location Code><Variant Code><Originally Ordered Var. Code>

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
6 Document No. Code20
8 Location Code Code10
11 Item Ledger Entry No. Integer
13 Item Ledger Entry Quantity Decimal (0:5)
43 Cost Amount (Actual) Decimal
68 Cost Amount (Actual) (ACY) Decimal
98 Expected Cost Boolean
100 Valued By Average Cost Boolean
104 Valuation Date Date
105 Entry Type Option
106 Variance Type Option
151 Cost Amount (Expected) Decimal
156 Cost Amount (Expected) (ACY) Decimal
5402 Variant Code Code10

Keys

# Fields
0 Entry No. Clustered: Yes
1 Item Ledger Entry No.
2 Item No.,Valuation Date,Location Code,Variant Code

Table Relations To Other Tables

Field Related Table Related Field
Item No. Item No. 1..n
Item Ledger Entry No. Item Ledger Entry Entry No. 1..n
Variant Code Item Variant Code 1..n
Location Code Location Code 1..n

Table Relations From Other Tables

From Table From Field