Diagrams

Table

Sales Price Worksheet

DynamicsDocs.comSales Price Worksheet«Table 7023»Sales Price WorksheetItem No. [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Current Unit PriceNew Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price G...Minimum Quantity [PK]Ending Date [PK]Item DescriptionSales DescriptionUnit of Measure Code [PK]Variant Code [PK]Allow Line Disc.«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 5071»CampaignNo. [PK]DescriptionStarting DateEnding DateSalesperson CodeCommentLast Date ModifiedNo. SeriesGlobal Dimension 1 CodeGlobal Dimension 2 CodeStatus CodeTarget Contacts ContactedContacts RespondedDuration [Min.]Cost [LCY]No. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterContact FilterContact Company FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P...To-do Closed Filter...«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 323»VAT Business Posting GroupCode [PK,NN]Description«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<Item No.><Sales Code><Sales Code><Sales Code><Currency Code><VAT Bus. Posting Gr. (Price)><Unit of Measure Code><Variant Code><Alternative Item No.><VAT Bus. Posting Gr. (Price)><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><VAT Bus. Posting Gr. (Price)><Customer Price Group><Currency Code><Currency Filter><Customer Filter><Bill-to Customer No.><VAT Bus. Posting Group>

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

Fields

# Name Type
1 Item No. (Item No.) Code20 NotBlank: Yes
2 Sales Code (Sales Code) Code20
3 Currency Code (Currency Code) Code10
4 Starting Date (Starting Date) Date
5 Current Unit Price (Current Unit Price) Decimal Editable: No
6 New Unit Price (New Unit Price) Decimal
7 Price Includes VAT (Price Includes VAT) Boolean
10 Allow Invoice Disc. (Allow Invoice Disc.) Boolean
11 VAT Bus. Posting Gr. (Price) (VAT Bus. Posting Gr. (Price)) Code10
13 Sales Type (Sales Type) Option
14 Minimum Quantity (Minimum Quantity) Decimal
15 Ending Date (Ending Date) Date
20 Item Description (Item Description) Text50 FlowField
21 Sales Description (Sales Description) Text50
5400 Unit of Measure Code (Unit of Measure Code) Code10
5700 Variant Code (Variant Code) Code10
7001 Allow Line Disc. (Allow Line Disc.) Boolean

Keys

# Fields
0 Starting Date,Ending Date,Sales Type,Sales Code,Currency Code,Item No.,Variant Code,Unit of Measure Code,Minimum Quantity (Starting Date,Ending Date,Sales Type,Sales Code,Currency Code,Item No.,Variant Code,Unit of Measure Code,Minimum Quantity) Clustered: Yes
1 Item No.,Variant Code,Unit of Measure Code,Minimum Quantity,Starting Date,Ending Date,Sales Type,Sales Code,Currency Code (Item No.,Variant Code,Unit of Measure Code,Minimum Quantity,Starting Date,Ending Date,Sales Type,Sales Code,Currency Code)

Table Relations To Other Tables

Field Related Table Related Field
Sales Code (Sales Code) Campaign No. (No.) 1..n
Currency Code (Currency Code) Currency Code (Code) 1..n
Sales Code (Sales Code) Customer No. (No.) 1..n
Sales Code (Sales Code) Customer Price Group Code (Code) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
VAT Bus. Posting Gr. (Price) (VAT Bus. Posting Gr. (Price)) VAT Business Posting Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field