Diagrams


Table

Item Application Entry

Fields

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

Keys

# Fields
0 Entry No. Clustered: Yes
1 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.
3 Transferred-from Entry No.,Cost Application
4 Inbound Item Entry No.,Outbound Item Entry No.,Cost Application
5 Item Ledger Entry No.,Output Completely Invd. Date

Table Relations To Other Tables

Field Related Table Related Field
Transferred-from Entry No. Item Ledger Entry Entry No. 1..n
Last Modified By User User User Name 1..n

Table Relations From Other Tables

From Table From Field