Diagrams

Table

Registered Invt. Movement Hdr.

DynamicsDocs.comRegistered Invt. Movement Hdr.«Table 7344»Registered Invt. Movement Hdr.No. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt. Movement No.No. PrintedPosting DateSource 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.Shipment DateExternal Document No.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 7301»Warehouse EmployeeUser ID [PK]Location Code [PK]DefaultADCS User«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 120»Purch. Rcpt. HeaderBuy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency Code...«Table 110»Sales Shipment HeaderSell-to Customer No. [NN]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 GroupCurrency Code...«Table 6650»Return Shipment HeaderBuy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactPosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency CodeCurrency Factor...«Table 6660»Return Receipt HeaderSell-to Customer No. [NN]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 GroupCurrency Code...«Table 5744»Transfer Shipment HeaderNo. [PK]Transfer-from CodeTransfer-from NameTransfer-from Name 2Transfer-from AddressTransfer-from Address 2Transfer-from Post CodeTransfer-from CityTransfer-from CountyTrsf.-from Country/Region CodeTransfer-to CodeTransfer-to NameTransfer-to Name 2Transfer-to AddressTransfer-to Address 2Transfer-to Post CodeTransfer-to CityTransfer-to CountyTrsf.-to Country/Region CodeTransfer Order DatePosting DateCommentShortcut Dimension 1 CodeShortcut Dimension 2 CodeTransfer Order No.No. SeriesShipment DateReceipt DateIn-Transit CodeTransfer-from ContactTransfer-to Contact...«Table 5746»Transfer Receipt HeaderNo. [PK]Transfer-from CodeTransfer-from NameTransfer-from Name 2Transfer-from AddressTransfer-from Address 2Transfer-from Post CodeTransfer-from CityTransfer-from CountyTrsf.-from Country/Region CodeTransfer-to CodeTransfer-to NameTransfer-to Name 2Transfer-to AddressTransfer-to Address 2Transfer-to Post CodeTransfer-to CityTransfer-to CountyTrsf.-to Country/Region CodeTransfer Order DatePosting DateCommentShortcut Dimension 1 CodeShortcut Dimension 2 CodeTransfer Order No.No. SeriesShipment DateReceipt DateIn-Transit CodeTransfer-from ContactTransfer-to Contact...«Table 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«Table 900»Assembly HeaderDocument Type; [Quote,Order,,,Blanket...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedItem No.Variant CodeInventory Posting GroupGen. Prod. Posting GroupCommentLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodePosting DateDue DateStarting DateEnding DateBin CodeQuantityQuantity [Base]Remaining QuantityRemaining Quantity [Base]Assembled QuantityAssembled Quantity [Base]Quantity to AssembleQuantity to Assemble [Base]Reserved QuantityReserved Qty. [Base]Planning Flexibility; [Unlimited,None]...«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><Source No.><Source No.><Source No.><Source No.><Source No.><Source No.><Source No.><Source No.><Destination No.><Destination No.><Destination No.><Destination No.><Destination No.><Location Code><Location Code><Location Code><Location Code><Location Filter><Location Code><Location Filter><Location Code><Transfer-from Code><Transfer-to Code><In-Transit Code><Transfer-from Code><Transfer-to Code><In-Transit Code><Location Code><Location Code><Location Code><Location Code><No. Series><Order No. Series><No. Series><Order No. Series><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><No. Series><No. Series><No. Series><Return Order No. Series><No. Series><Return Order No. Series><No. Series><Posting No. Series><Buy-from Vendor No.><Pay-to Vendor No.><Sell-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Last Shipping No.><Buy-from Vendor No.><Pay-to Vendor No.><Sell-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Last Return Receipt No.><Source No.><Source No.><Source No.><Item No.><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
2 No. (No.) Code20
3 Location Code (Location Code) Code10 NotBlank: Yes
4 Assigned User ID (Assigned User ID) Code50
5 Assignment Date (Assignment Date) Date
6 Assignment Time (Assignment Time) Time
8 Registering Date (Registering Date) Date
9 No. Series (No. Series) Code10 Editable: No
10 Comment (Comment) Boolean Editable: No
FlowField
11 Invt. Movement No. (Invt. Movement No.) Code20
12 No. Printed (No. Printed) Integer Editable: No
20 Posting Date (Posting Date) Date
7306 Source No. (Source No.) Code20
7307 Source Document (Source Document) Option BlankZero: Yes
7308 Source Type (Source Type) Integer
7309 Source Subtype (Source Subtype) Option Editable: No
7310 Destination Type (Destination Type) Option
7311 Destination No. (Destination No.) Code20
7312 External Document No. (External Document No.) Code35
7314 Shipment Date (Shipment Date) Date
7315 External Document No.2 (External Document No.2) Code35

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Invt. Movement No. (Invt. Movement No.)
2 Location Code (Location Code)

Table Relations To Other Tables

Field Related Table Related Field
Source No. (Source No.) Assembly Header No. (No.) 1..n
Destination No. (Destination No.) Customer No. (No.) 1..n
Destination No. (Destination No.) Family No. (No.) 1..n
Destination No. (Destination No.) Item No. (No.) 1..n
Destination No. (Destination No.) Location Code (Code) 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Source No. (Source No.) Production Order No. (No.) 1..n
Source No. (Source No.) Purch. Rcpt. Header No. (No.) 1..n
Source No. (Source No.) Return Receipt Header No. (No.) 1..n
Source No. (Source No.) Return Shipment Header No. (No.) 1..n
Destination No. (Destination No.) Sales Header No. (No.) 1..n
Source No. (Source No.) Sales Shipment Header No. (No.) 1..n
Source No. (Source No.) Transfer Receipt Header No. (No.) 1..n
Source No. (Source No.) Transfer Shipment Header No. (No.) 1..n
Destination No. (Destination No.) Vendor No. (No.) 1..n
Assigned User ID (Assigned User ID) Warehouse Employee User ID (User ID) 1..n

Table Relations From Other Tables

From Table From Field