Diagrams


Table

Warehouse Activity Header

DynamicsDocs.comWarehouse Activity Header«Table 5766»Warehouse Activity HeaderType; [,Put-away,Pick,Movement,Invt. P...No. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Document,Shelf...No. SeriesCommentNo. PrintedNo. of LinesSource Type FilterSource Subtype Filter; [0,1,2,3,4,5,6,...Source No. FilterLocation FilterPosting DateRegistering No.Last Registering No.Registering No. SeriesDate of Last PrintingTime of Last PrintingBreakbulk FilterSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment Date...«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 7301»Warehouse EmployeeUser ID [PK]Location Code [PK]DefaultADCS User«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 5772»Registered Whse. Activity Hdr.Type; [,Put-away,Pick,Movement] [PK]No. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Document,Shelf...Registering DateNo. SeriesCommentWhse. Activity No.No. Printed«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«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...«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 99000773»FamilyNo. [PK,NN]DescriptionDescription 2Search NameBlockedLast Date ModifiedRouting No.«Table 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...<Location Code><Destination No.><Assigned User ID><No. Series><Registering No. Series><Last Registering No.><Destination No.><Destination No.><Destination No.><Destination No.><Destination No.><Location Code><Location Code><Location Filter><Location Code><Location Filter><Location Code><Location Code><Assigned User ID><No. Series><No. Series><No. Series><Serial Nos.><Lot Nos.><No. Series><Posting No. Series><Shipping No. Series><Prepayment No. Series><Prepmt. Cr. Memo No. Series><Return Receipt No. Series><No. Series><Pay-to Vendor No.><Vendor No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Alternative Item No.>

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

Fields

# Name Type
1 Type Option
2 No. Code20
3 Location Code Code10
4 Assigned User ID Code50
5 Assignment Date Date Editable: No
6 Assignment Time Time Editable: No
7 Sorting Method Option
9 No. Series Code20
10 Comment Boolean Editable: No
FlowField
12 No. Printed Integer Editable: No
13 No. of Lines Integer Editable: No
FlowField
14 Source Type Filter Integer FlowFilter
15 Source Subtype Filter Option FlowFilter
16 Source No. Filter Code250 FlowFilter
17 Location Filter Code250 FlowFilter
20 Posting Date Date
61 Registering No. Code20
62 Last Registering No. Code20 Editable: No
63 Registering No. Series Code20
7303 Date of Last Printing Date Editable: No
7304 Time of Last Printing Time Editable: No
7305 Breakbulk Filter Boolean
7306 Source No. Code20
7307 Source Document Option BlankZero: Yes
7308 Source Type Integer
7309 Source Subtype Option Editable: No
7310 Destination Type Option
7311 Destination No. Code20
7312 External Document No. Code35
7313 Expected Receipt Date Date
7314 Shipment Date Date
7315 External Document No.2 Code35

Keys

# Fields
0 Type,No. Clustered: Yes
1 Location Code
2 Source Document,Source No.,Location Code

Table Relations To Other Tables

Field Related Table Related Field
Destination No. Customer No. 1..n
Destination No. Family No. 1..n
Destination No. Item No. 1..n
Destination No. Location Code 1..n
Registering No. Series No. Series Code 1..n
Last Registering No. Registered Whse. Activity Hdr. No. 1..n
Destination No. Sales Header No. 1..n
Destination No. Vendor No. 1..n
Assigned User ID Warehouse Employee User ID 1..n

Table Relations From Other Tables

From Table From Field