Diagrams

Table

Standard Service Line

DynamicsDocs.comStandard Service Line«Table 5997»Standard Service LineStandard Service Code [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.DescriptionQuantityAmount Excl. VATUnit of Measure CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVariant CodeDimension Set ID«Table 5996»Standard Service CodeCode [PK,NN]DescriptionCurrency Code«Table 7»Standard TextCode [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 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 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Standard Service Code><No.><No.><No.><No.><No.><Unit of Measure Code><Unit of Measure Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Variant Code><Dimension Set ID><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Global Dimension 1 Code><Global Dimension 2 Code><Base Unit of Measure><Unit of Measure Filter><Account No.><Unit of Measure Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Code><Dimension Value Code>

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

Fields

# Name Type
1 Standard Service Code (Standard Service Code) Code10 Editable: No
2 Line No. (Line No.) Integer Editable: No
3 Type (Type) Option
4 No. (No.) Code20
5 Description (Description) Text50
6 Quantity (Quantity) Decimal (0:5) BlankZero: Yes
7 Amount Excl. VAT (Amount Excl. VAT) Decimal BlankZero: Yes
8 Unit of Measure Code (Unit of Measure Code) Code10
9 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
10 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
11 Variant Code (Variant Code) Code10
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Standard Service Code,Line No. (Standard Service Code,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Dimension Value Code (Code) 1..n
No. (No.) G/L Account No. (No.) 1..n
No. (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
No. (No.) Resource No. (No.) 1..n
No. (No.) Service Cost Code (Code) 1..n
Standard Service Code (Standard Service Code) Standard Service Code Code (Code) 1..n
No. (No.) Standard Text Code (Code) 1..n
Unit of Measure Code (Unit of Measure Code) Unit of Measure Code (Code) 1..n

Table Relations From Other Tables

From Table From Field