Diagrams


Table

Whse. Cross-Dock Opportunity

DynamicsDocs.comWhse. Cross-Dock Opportunity«Table 5768»Whse. Cross-Dock OpportunitySource Template Name [PK]Source Name/No. [PK]Source Line No. [PK]Line No. [PK]From Source TypeFrom Source Subtype; [0,1,2,3,4,5,6,7,...From Source No.From Source Line No.From Source Subline No.From Source Document; [,Sales Order,Sa...To Source TypeTo Source Subtype; [0,1,2,3,4,5,6,7,8,...To Source No.To Source Line No.To Source Subline No.To Source Document; [,Sales Order,,,,,...Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureLocation CodeQty. NeededQty. Needed [Base]Qty. to Cross-DockQty. to Cross-Dock [Base]Qty. Cross-Docked [Base]Total Qty. Needed [Base]Reserved QuantityReserved Qty. [Base]To-Src. Unit of Measure CodeTo-Src. Qty. per Unit of Meas....«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 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«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...<Item No.><Variant Code><Unit of Measure Code><To-Src. Unit of Measure Code><Location Code><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.>

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

Fields

# Name Type
1 Source Template Name Code10 Editable: No
2 Source Name/No. Code20 Editable: No
3 Source Line No. Integer Editable: No
4 Line No. Integer Editable: No
5 From Source Type Integer Editable: No
6 From Source Subtype Option Editable: No
7 From Source No. Code20 Editable: No
8 From Source Line No. Integer Editable: No
9 From Source Subline No. Integer Editable: No
10 From Source Document Option Editable: No
11 To Source Type Integer Editable: No
12 To Source Subtype Option Editable: No
13 To Source No. Code20 Editable: No
14 To Source Line No. Integer Editable: No
15 To Source Subline No. Integer Editable: No
16 To Source Document Option BlankZero: Yes
17 Item No. Code20 Editable: No
18 Variant Code Code10 Editable: No
19 Unit of Measure Code Code10 Editable: No
20 Qty. per Unit of Measure Decimal (0:5) Editable: No
21 Location Code Code10 Editable: No
24 Qty. Needed Decimal (0:5) Editable: No
25 Qty. Needed (Base) Decimal (0:5) Editable: No
26 Qty. to Cross-Dock Decimal (0:5)
27 Qty. to Cross-Dock (Base) Decimal (0:5)
28 Qty. Cross-Docked (Base) Decimal (0:5) Editable: No
FlowField
29 Total Qty. Needed (Base) Decimal FlowField
36 Reserved Quantity Decimal (0:5) Editable: No
FlowField
37 Reserved Qty. (Base) Decimal (0:5) Editable: No
FlowField
39 To-Src. Unit of Measure Code Code10 Editable: No
40 To-Src. Qty. per Unit of Meas. Decimal (0:5) Editable: No
41 Due Date Date Editable: No
42 Pick Qty. Decimal (0:5) Editable: No
Normal
43 Pick Qty. (Base) Decimal (0:5) Editable: No
Normal
44 Picked Qty. Decimal (0:5) Editable: No
45 Picked Qty. (Base) Decimal (0:5) Editable: No

Keys

# Fields
0 Source Template Name,Source Name/No.,Source Line No.,Line No. Clustered: Yes
MaintainSIFTIndex: No
1 Item No.,Location Code
2 From Source Type,From Source Subtype,From Source No.,From Source Line No.,From Source Subline No. MaintainSIFTIndex: No
3 To Source Type,To Source Subtype,To Source No.,To Source Line No.,To Source Subline No. MaintainSIFTIndex: No
4 Due Date

Table Relations To Other Tables

Field Related Table Related Field
Item No. Item No. 1..n
To-Src. Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
Location Code Location Code 1..n

Table Relations From Other Tables

From Table From Field