Diagrams

Table

Assembly Setup

DynamicsDocs.comAssembly Setup«Table 905»Assembly SetupPrimary Key [PK]Stockout WarningAssembly Order Nos.Assembly Quote Nos.Blanket Assembly Order Nos.Posted Assembly Order Nos.Copy Component Dimensions from; [Item/...Default Location for OrdersCopy Comments when PostingCreate Movements Automatically«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«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...<Assembly Order Nos.><Assembly Quote Nos.><Blanket Assembly Order Nos.><Posted Assembly Order Nos.><Default Location for Orders>

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

Fields

# Name Type
1 Primary Key (Primary Key) Code10
5 Stockout Warning (Stockout Warning) Boolean
10 Assembly Order Nos. (Assembly Order Nos.) Code10
20 Assembly Quote Nos. (Assembly Quote Nos.) Code10
30 Blanket Assembly Order Nos. (Blanket Assembly Order Nos.) Code10
50 Posted Assembly Order Nos. (Posted Assembly Order Nos.) Code10
100 Copy Component Dimensions from (Copy Component Dimensions from) Option
110 Default Location for Orders (Default Location for Orders) Code10
120 Copy Comments when Posting (Copy Comments when Posting) Boolean
130 Create Movements Automatically (Create Movements Automatically) Boolean

Keys

# Fields
0 Primary Key (Primary Key) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Default Location for Orders (Default Location for Orders) Location Code (Code) 1..n
Posted Assembly Order Nos. (Posted Assembly Order Nos.) No. Series Code (Code) 1..n

Table Relations From Other Tables

From Table From Field