Diagrams

Table

Purch. Price Line Disc. Buff.

DynamicsDocs.comPurch. Price Line Disc. Buff.«Table 1315»Purch. Price Line Disc. Buff.Currency Code [PK]Starting Date [PK]Line Discount %Direct Unit CostMinimum Quantity [PK]Ending DateLine Type; [,Purchase Line Discount,Pu...Item No. [PK]Vendor No. [PK]Unit of Measure Code [PK]Variant Code [PK]«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Currency Code><Unit of Measure Code><Variant Code>

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

Fields

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

Keys

# Fields
0 Line Type,Starting Date,Currency Code,Variant Code,Unit of Measure Code,Minimum Quantity,Item No.,Vendor No. (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) Currency Code (Code) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Item No. (Item No.) 1..n
Variant Code (Variant Code) Item Variant Item No. (Item No.) 1..n

Table Relations From Other Tables

From Table From Field