Diagrams


Table

Inventory Adjmt. Entry (Order)

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

Fields

# Name Type
1 Order Type Option
2 Order No. Code20
3 Order Line No. Integer
4 Item No. Code20
7 Routing No. Code20
8 Routing Reference No. Integer
21 Indirect Cost % Decimal (0:5)
22 Overhead Rate Decimal
29 Cost is Adjusted Boolean
30 Allow Online Adjustment Boolean
41 Unit Cost Decimal
42 Direct Cost Decimal
43 Indirect Cost Decimal
44 Single-Level Material Cost Decimal
45 Single-Level Capacity Cost Decimal
46 Single-Level Subcontrd. Cost Decimal
47 Single-Level Cap. Ovhd Cost Decimal
48 Single-Level Mfg. Ovhd Cost Decimal
52 Direct Cost (ACY) Decimal
53 Indirect Cost (ACY) Decimal
54 Single-Lvl Material Cost (ACY) Decimal
55 Single-Lvl Capacity Cost (ACY) Decimal
56 Single-Lvl Subcontrd Cost(ACY) Decimal
57 Single-Lvl Cap. Ovhd Cost(ACY) Decimal
58 Single-Lvl Mfg. Ovhd Cost(ACY) Decimal
61 Completely Invoiced Boolean
62 Is Finished Boolean

Keys

# Fields
0 Order Type,Order No.,Order Line No. Clustered: Yes
1 Cost is Adjusted,Allow Online Adjustment

Table Relations To Other Tables

Field Related Table Related Field
Item No. Item No. 1..n
Routing No. Routing Header No. 1..n

Table Relations From Other Tables

From Table From Field