Diagrams


Table

Item Application Entry

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
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
5800 Cost Application (Cost Application) Boolean
5804 Output Completely Invd. Date (Output Completely Invd. Date) Date
5805 Outbound Entry is Updated (Outbound Entry is Updated) Boolean

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Inbound Item Entry No.,Item Ledger Entry No.,Outbound Item Entry No.,Cost Application (Inbound Item Entry No.,Item Ledger Entry No.,Outbound Item Entry No.,Cost Application)
2 Outbound Item Entry No.,Item Ledger Entry No.,Cost Application,Transferred-from Entry No. (Outbound Item Entry No.,Item Ledger Entry No.,Cost Application,Transferred-from Entry No.)
3 Transferred-from Entry No.,Cost Application (Transferred-from Entry No.,Cost Application)
4 Inbound Item Entry No.,Outbound Item Entry No.,Cost Application (Inbound Item Entry No.,Outbound Item Entry No.,Cost Application)
5 Item Ledger Entry No.,Output Completely Invd. Date (Item Ledger Entry No.,Output Completely Invd. Date)

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
Last Modified By User (Last Modified By User) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field