Diagrams

Table

Item Application Entry History

DynamicsDocs.comItem Application Entry History«Table 343»Item Application Entry HistoryEntry No.Item Ledger Entry No.Inbound Item Entry No.Outbound Item Entry No.Primary Entry No. [PK]QuantityPosting DateTransferred-from Entry No.Creation DateCreated By UserLast Modified DateLast Modified By UserDeleted DateDeleted By UserCost ApplicationOutput Completely Invd. Date«Table 32»Item Ledger EntryEntry No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeQuantityRemaining QuantityInvoiced QuantityApplies-to EntryOpenGlobal Dimension 1 CodeGlobal Dimension 2 CodePositiveSource Type; [,Customer,Vendor,Item]Drop ShipmentTransaction TypeTransport MethodCountry/Region CodeEntry/Exit PointDocument DateExternal Document No.AreaTransaction SpecificationNo. SeriesReserved QuantityDocument Type; [,Sales Shipment,Sales...Document Line No.Order Type; [,Production,Transfer,Serv......«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID<Item Ledger Entry No.><Inbound Item Entry No.><Outbound Item Entry No.><Transferred-from Entry No.><Created By User><Last Modified By User><Deleted By User>

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

Fields

# Name Type
1 Entry No. (Entry No.) Integer
2 Item Ledger Entry No. (Item Ledger Entry No.) Integer
3 Inbound Item Entry No. (Inbound Item Entry No.) Integer
4 Outbound Item Entry No. (Outbound Item Entry No.) Integer
9 Primary Entry No. (Primary Entry No.) Integer
11 Quantity (Quantity) Decimal (0:5)
21 Posting Date (Posting Date) Date
23 Transferred-from Entry No. (Transferred-from Entry No.) Integer
25 Creation Date (Creation Date) DateTime
26 Created By User (Created By User) Code50
27 Last Modified Date (Last Modified Date) DateTime
28 Last Modified By User (Last Modified By User) Code50
29 Deleted Date (Deleted Date) DateTime
30 Deleted By User (Deleted By User) Code50
5800 Cost Application (Cost Application) Boolean
5804 Output Completely Invd. Date (Output Completely Invd. Date) Date

Keys

# Fields
0 Primary Entry No. (Primary Entry No.) Clustered: Yes
1 Entry No. (Entry No.)

Table Relations To Other Tables

Field Related Table Related Field
Transferred-from Entry No. (Transferred-from Entry No.) Item Ledger Entry Entry No. (Entry No.) 1..n
Deleted By User (Deleted By User) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field