Diagrams


Table

Purch. Price Line Disc. Buff.

Fields

# Name Type
3 Currency Code Code10
4 Starting Date Date
5 Line Discount % Decimal
6 Direct Unit Cost Decimal
14 Minimum Quantity Decimal
15 Ending Date Date
1300 Line Type Option
1301 Item No. Code20 Editable: No
1303 Vendor No. Code20 Editable: No
5400 Unit of Measure Code Code20
5700 Variant Code Code20

Keys

# Fields
0 Line Type,Starting Date,Currency Code,Variant Code,Unit of Measure Code,Minimum Quantity,Item No.,Vendor No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Unit of Measure Code Item Unit of Measure Item No. 1..n
Variant Code Item Variant Item No. 1..n

Table Relations From Other Tables

From Table From Field