Diagrams


Table

Service Line Price Adjmt.

DynamicsDocs.comService Line Price Adjmt.«Table 6084»Service Line Price Adjmt.Document Type; [Quote,Order] [PK]Document No. [PK]Service Line No. [PK]Service Item Line No. [PK]Service Item No.Serv. Price Adjmt. Gr. CodeType; [,Item,Resource,Cost,G/L Account...No.DescriptionQuantityAmountNew AmountUnit PriceNew Unit PriceUnit CostDiscount %Discount AmountAmount incl. VATNew Amount incl. VATWeightAdjustment Type; [Fixed,Maximum,Minimu...Service Price Group CodeManually AdjustedVat %New Amount Excl. VAT«Table 5940»Service ItemNo. [PK]Serial No.Service Item Group CodeDescriptionDescription 2Status; [,Own Service Item,Installed,T...Priority; [Low,Medium,High]Customer No.Ship-to CodeItem No.Unit of Measure CodeLocation of Service ItemSales Unit PriceSales Unit CostWarranty Starting Date [Labor]Warranty Ending Date [Labor]Warranty Starting Date [Parts]Warranty Ending Date [Parts]Warranty % [Parts]Warranty % [Labor]Response Time [Hours]Installation DateSales DateLast Service DateDefault Contract ValueDefault Contract Discount %No. of Active ContractsVendor No.Vendor Item No.No. SeriesItem Description...«Table 6082»Service Price Adjustment GroupCode [PK,NN]Description«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 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 5905»Service CostCode [PK,NN]DescriptionAccount No.Default Unit PriceDefault QuantityUnit of Measure CodeCost Type; [Travel,Support,Other]Service Zone CodeDefault Unit Cost«Table 6080»Service Price GroupCode [PK,NN]Description<Service Item No.><Serv. Price Adjmt. Gr. Code><No.><No.><No.><Service Price Group Code><Item No.><Preferred Resource><Service Price Group Code><Alternative Item No.>

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

Fields

# Name Type
1 Document Type Option
2 Document No. Code20
3 Service Line No. Integer
4 Service Item Line No. Integer
5 Service Item No. Code20
6 Serv. Price Adjmt. Gr. Code Code10
7 Type Option Editable: No
8 No. Code20 Editable: No
9 Description Text50 Editable: No
10 Quantity Decimal Editable: No
14 Amount Decimal Editable: No
15 New Amount Decimal
16 Unit Price Decimal Editable: No
17 New Unit Price Decimal
18 Unit Cost Decimal Editable: No
19 Discount % Decimal Editable: No
20 Discount Amount Decimal Editable: No
21 Amount incl. VAT Decimal Editable: No
22 New Amount incl. VAT Decimal
24 Weight Decimal Editable: No
25 Adjustment Type Option Editable: No
26 Service Price Group Code Code10 Editable: No
27 Manually Adjusted Boolean Editable: No
28 Vat % Decimal Editable: No
29 New Amount Excl. VAT Decimal Editable: No

Keys

# Fields
0 Document Type,Document No.,Service Item Line No.,Service Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
No. Item No. 1..n
No. Resource No. 1..n
No. Service Cost Code 1..n
Service Item No. Service Item No. 1..n
Serv. Price Adjmt. Gr. Code Service Price Adjustment Group Code 1..n
Service Price Group Code Service Price Group Code 1..n

Table Relations From Other Tables

From Table From Field