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

Keys

# Fields
0 Source Template Name,Source Name/No.,Source Line No.,Line No. (Source Template Name,Source Name/No.,Source Line No.,Line No.) Clustered: Yes
MaintainSIFTIndex: No
1 Item No.,Location Code (Item No.,Location Code)
2 From Source Type,From Source Subtype,From Source No.,From Source Line No.,From Source Subline No. (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. (To Source Type,To Source Subtype,To Source No.,To Source Line No.,To Source Subline No.) MaintainSIFTIndex: No
4 Due Date (Due Date)

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (No.) 1..n
To-Src. Unit of Measure Code (To-Src. Unit of Measure Code) Item Unit of Measure Code (Code) 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