Diagrams

Table

Resource Skill

DynamicsDocs.comResource Skill«Table 5956»Resource SkillType; [Resource,Service Item Group,Ite...No. [PK,NN]Skill Code [PK,NN]Assigned From; [,Service Item Group,It...Source Type; [,Service Item Group,Item...Source Code«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 5904»Service Item GroupCode [PK,NN]DescriptionCreate Service ItemDefault Contract Discount %Default Serv. Price Group CodeDefault Response Time [Hours]«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 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 5955»Skill CodeCode [PK,NN]Description<No.><No.><No.><No.><Skill Code><Preferred Resource><Service Item Group><Service Item Group Code><Alternative Item No.><Item No.>

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

Fields

# Name Type
1 Type (Type) Option
2 No. (No.) Code20 NotBlank: Yes
3 Skill Code (Skill Code) Code10 NotBlank: Yes
4 Assigned From (Assigned From) Option
5 Source Type (Source Type) Option
6 Source Code (Source Code) Code20

Keys

# Fields
0 Type,No.,Skill Code (Type,No.,Skill Code) Clustered: Yes
1 Skill Code,Type,No. (Skill Code,Type,No.)
2 Assigned From (Assigned From)
3 Source Type,Source Code (Source Type,Source Code)
4 Assigned From,Source Type,Source Code (Assigned From,Source Type,Source Code)

Table Relations To Other Tables

Field Related Table Related Field
No. (No.) Item No. (No.) 1..n
No. (No.) Resource No. (No.) 1..n
No. (No.) Service Item No. (No.) 1..n
No. (No.) Service Item Group Code (Code) 1..n
Skill Code (Skill Code) Skill Code Code (Code) 1..n

Table Relations From Other Tables

From Table From Field