Diagrams

Table

Serv. Price Adjustment Detail

DynamicsDocs.comServ. Price Adjustment Detail«Table 6083»Serv. Price Adjustment DetailServ. Price Adjmt. Gr. Code [PK,NN]Type; [Item,Resource,Resource Group,Se...No. [PK]Work Type [PK]Gen. Prod. Posting Group [PK]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 152»Resource GroupNo. [PK,NN]NameDate FilterCapacityQty. on Order [Job]Qty. Quoted [Job]Unit of Measure FilterUsage [Qty.]Usage [Cost]Usage [Price]Sales [Qty.]Sales [Cost]Sales [Price]Chargeable FilterGlobal Dimension 1 CodeGlobal Dimension 2 CodeNo. of Resources AssignedQty. on Service Order«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 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc....«Table 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default<Serv. Price Adjmt. Gr. Code><No.><No.><No.><No.><No.><Work Type><Gen. Prod. Posting Group><Alternative Item No.><Gen. Prod. Posting Group><Resource Group No.><Gen. Prod. Posting Group><Account No.><Gen. Prod. Posting Group>

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

Fields

# Name Type
1 Serv. Price Adjmt. Gr. Code (Serv. Price Adjmt. Gr. Code) Code10 NotBlank: Yes
2 Type (Type) Option
3 No. (No.) Code20
4 Work Type (Work Type) Code10
5 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
6 Description (Description) Text50

Keys

# Fields
0 Serv. Price Adjmt. Gr. Code,Type,No.,Work Type,Gen. Prod. Posting Group (Serv. Price Adjmt. Gr. Code,Type,No.,Work Type,Gen. Prod. Posting Group) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
No. (No.) G/L Account No. (No.) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
No. (No.) Item No. (No.) 1..n
No. (No.) Resource No. (No.) 1..n
No. (No.) Resource Group No. (No.) 1..n
No. (No.) Service Cost Code (Code) 1..n
Serv. Price Adjmt. Gr. Code (Serv. Price Adjmt. Gr. Code) Service Price Adjustment Group Code (Code) 1..n
Work Type (Work Type) Work Type Code (Code) 1..n

Table Relations From Other Tables

From Table From Field