Diagrams

Table

Inventory Profile

DynamicsDocs.comInventory Profile«Table 99000853»Inventory ProfileLine No. [PK]Attribute PriorityOrder PriorityItem No.Variant CodeLocation CodeBin CodeIsSupplyOrder Relation; [Normal,Safety Stock,R...Source TypeSource Order StatusSource IDSource Batch NameSource Ref. No.Source Prod. Order LinePrimary Order StatusPrimary Order No.Primary Order LinePrimary Order TypeOriginal QuantityRemaining Quantity [Base]Untracked QuantityOriginal Due DateDue DatePlanning Flexibility; [Unlimited,None,...Fixed DateAction Message; [,New,Change Qty.,Resc...Binding; [,Order-to-Order]Quantity [Base]Min. QuantityStarting Date...«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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated«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...<Item No.><Variant Code><Location Code><Bin Code><Sell-to Customer No.><Alternative Item No.><Location Filter><Bin Filter><Item Filter><Variant Filter><Item No.><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Location Code><Location Code><Bill-to Customer No.>

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

Fields

# Name Type
3 Line No. (Line No.) Integer
4 Attribute Priority (Attribute Priority) Integer
5 Order Priority (Order Priority) Integer
11 Item No. (Item No.) Code20
12 Variant Code (Variant Code) Code10
13 Location Code (Location Code) Code10
14 Bin Code (Bin Code) Code20
15 IsSupply (IsSupply) Boolean
16 Order Relation (Order Relation) Option
21 Source Type (Source Type) Integer
22 Source Order Status (Source Order Status) Integer
23 Source ID (Source ID) Code20
24 Source Batch Name (Source Batch Name) Code10
25 Source Ref. No. (Source Ref. No.) Integer
26 Source Prod. Order Line (Source Prod. Order Line) Integer
27 Primary Order Status (Primary Order Status) Integer
28 Primary Order No. (Primary Order No.) Code20
29 Primary Order Line (Primary Order Line) Integer
30 Primary Order Type (Primary Order Type) Integer
31 Original Quantity (Original Quantity) Decimal (0:5)
32 Remaining Quantity (Base) (Remaining Quantity (Base)) Decimal (0:5)
33 Untracked Quantity (Untracked Quantity) Decimal (0:5)
34 Original Due Date (Original Due Date) Date
35 Due Date (Due Date) Date
36 Planning Flexibility (Planning Flexibility) Option
37 Fixed Date (Fixed Date) Date
38 Action Message (Action Message) Option
39 Binding (Binding) Option Editable: No
40 Quantity (Base) (Quantity (Base)) Decimal (0:5)
41 Min. Quantity (Min. Quantity) Decimal (0:5)
42 Starting Date (Starting Date) Date
43 Planning Line No. (Planning Line No.) Integer
44 Unit of Measure Code (Unit of Measure Code) Code10
45 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5)
46 Quantity (Quantity) Decimal (0:5)
47 Remaining Quantity (Remaining Quantity) Decimal (0:5)
48 Finished Quantity (Finished Quantity) Decimal (0:5)
50 Planning Level Code (Planning Level Code) Integer Editable: No
51 Planning Line Phase (Planning Line Phase) Option
52 Due Time (Due Time) Time
53 Sell-to Customer No. (Sell-to Customer No.) Code20
54 Drop Shipment (Drop Shipment) Boolean
55 Special Order (Special Order) Boolean
56 Ref. Order No. (Ref. Order No.) Code20 Editable: No
57 Ref. Line No. (Ref. Line No.) Integer BlankZero: Yes
Editable: No
58 Derived from Blanket Order (Derived from Blanket Order) Boolean
59 Ref. Blanket Order No. (Ref. Blanket Order No.) Code20
60 Tracking Reference (Tracking Reference) Integer
61 Lot No. (Lot No.) Code20
62 Serial No. (Serial No.) Code20
63 Max. Quantity (Max. Quantity) Decimal (0:5)
64 Safety Stock Quantity (Safety Stock Quantity) Decimal (0:5)
65 Is Exception Order (Is Exception Order) Boolean
66 Transfer Location Not Planned (Transfer Location Not Planned) Boolean
67 Expiration Date (Expiration Date) Date Editable: No
68 Ref. Order Type (Ref. Order Type) Option Editable: No
69 Disallow Cancellation (Disallow Cancellation) Boolean
70 MPS Order (MPS Order) Boolean

Keys

# Fields
0 Line No. (Line No.) Clustered: Yes
1 Item No.,Variant Code,Location Code,Due Date,Attribute Priority,Order Priority (Item No.,Variant Code,Location Code,Due Date,Attribute Priority,Order Priority)
2 Item No.,Variant Code,Location Code,IsSupply,Primary Order Status,Primary Order No.,Due Date,Order Priority (Item No.,Variant Code,Location Code,IsSupply,Primary Order Status,Primary Order No.,Due Date,Order Priority)
3 Source Type,Source Order Status,Source ID,Source Batch Name,Source Ref. No.,Source Prod. Order Line,IsSupply,Due Date (Source Type,Source Order Status,Source ID,Source Batch Name,Source Ref. No.,Source Prod. Order Line,IsSupply,Due Date)

Table Relations To Other Tables

Field Related Table Related Field
Bin Code (Bin Code) Bin Code (Code) 1..n
Sell-to Customer No. (Sell-to Customer No.) Customer No. (No.) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Location Code (Location Code) Location Code (Code) 1..n

Table Relations From Other Tables

From Table From Field