Diagrams


Table

Resource

DynamicsDocs.comResource«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 1012»Job Resource PriceJob No. [PK,NN]Job Task No. [PK]Type; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Unit PriceCurrency Code [PK]Unit Cost FactorLine Discount %DescriptionApply Job PriceApply Job Discount«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Order,Complete...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 201»Resource PriceType; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Unit PriceCurrency Code [PK]«Table 202»Resource CostType; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Cost Type; [Fixed,% Extra,LCY Extra]Direct Unit CostUnit Cost«Table 205»Resource Unit of MeasureResource No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureRelated to Base Unit of Meas.«Table 335»Resource Price ChangeType; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Currency Code [PK]Current Unit PriceNew Unit Price«Table 5200»EmployeeNo. [PK]First NameMiddle NameLast NameInitialsJob TitleSearch NameAddressAddress 2CityPost CodeCountyPhone No.Mobile Phone No.E-MailAlt. Address CodeAlt. Address Start DateAlt. Address End DatePictureBirth DateSocial Security No.Union CodeUnion Membership No.Gender; [,Female,Male]Country/Region CodeManager No.Emplymt. Contract CodeStatistics Group CodeEmployment DateStatus; [Active,Inactive,Terminated]Inactive Date...«Table 5841»Standard Cost WorksheetStandard Cost Worksheet Name [PK]Type; [Item,Work Center,Machine Center...No. [PK,NN]DescriptionImplementedReplenishment System; [Purchase,Prod....Standard CostNew Standard CostIndirect Cost %New Indirect Cost %Overhead RateNew Overhead RateSingle-Lvl Material CostNew Single-Lvl Material CostSingle-Lvl Cap. CostNew Single-Lvl Cap. CostSingle-Lvl Subcontrd CostNew Single-Lvl Subcontrd CostSingle-Lvl Cap. Ovhd CostNew Single-Lvl Cap. Ovhd CostSingle-Lvl Mfg. Ovhd CostNew Single-Lvl Mfg. Ovhd CostRolled-up Material CostNew Rolled-up Material CostRolled-up Cap. CostNew Rolled-up Cap. CostRolled-up Subcontrd CostNew Rolled-up Subcontrd CostRolled-up Cap. Ovhd CostNew Rolled-up Cap. Ovhd CostRolled-up Mfg. Ovhd Cost...«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 5950»Service Order AllocationEntry No. [PK]Status; [Nonactive,Active,Finished,Can...Document No.Allocation DateResource No.Resource Group No.Service Item Line No.Allocated HoursStarting TimeFinishing TimeDescriptionReason CodeService Item No.PostedService Item DescriptionService Item Serial No.Repair StatusService StartedDocument Type; [Quote,Order]«Table 5952»Resource LocationLocation Code [PK]Location NameResource No. [PK]Resource NameStarting Date [PK]«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 5958»Resource Service ZoneResource No. [PK,NN]Service Zone Code [PK,NN]Starting Date [PK]Description«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 90»BOM ComponentParent Item No. [PK,NN]Line No. [PK]Type; [,Item,Resource]No.Assembly BOMDescriptionUnit of Measure CodeQuantity perPositionPosition 2Position 3Machine No.Lead-Time OffsetBOM DescriptionResource Usage Type; [Direct,Fixed]Variant CodeInstalled in Line No.Installed in Item No.«Table 952»Time Sheet DetailTime Sheet No. [PK]Time Sheet Line No. [PK]Date [PK]Type; [,Resource,Job,Service,Absence,A...Resource No.Job No.Job Task No.Cause of Absence CodeService Order No.Service Order Line No.QuantityPosted QuantityAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Posted«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 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 321»Tax GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description«Table 410»IC G/L AccountNo. [PK,NN]NameAccount Type; [Posting,Heading,Total,B...Income/Balance; [Income Statement,Bala...BlockedMap-to G/L Acc. No.Indentation«Table 91»User SetupUser ID [PK,NN]Allow Posting FromAllow Posting ToRegister TimeSalespers./Purch. CodeApprover IDSales Amount Approval LimitPurchase Amount Approval LimitUnlimited Sales ApprovalUnlimited Purchase ApprovalSubstituteE-MailRequest Amount Approval LimitUnlimited Request ApprovalApproval AdministratorTime Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter«Table 1700»Deferral TemplateDeferral Code [PK,NN]DescriptionDeferral Account [NN]Deferral %Calc. Method; [Straight-Line,Equal per...Start Date; [Posting Date,Beginning of...No. of PeriodsPeriod Description«Table 5957»Service ZoneCode [PK,NN]Description<Resource Group No.><Base Unit of Measure><Unit of Measure Filter><Vendor No.><Gen. Prod. Posting Group><Tax Group Code><VAT Prod. Posting Group><IC Partner Purch. G/L Acc. No.><Time Sheet Owner User ID><Time Sheet Approver User ID><Default Deferral Template Code><Service Zone Filter><Code><Person Responsible><Resource Filter><Code><Code><Resource No.><Code><Resource No.><No.><Preferred Resource><Resource No.><Resource No.><No.><Resource No.><No.><No.><Resource No.><Job No.><Code><Resource Gr. Filter><Job No.><Code><Code><Code><Unit of Measure Code><Code><Manager No.><Employee No. Filter><Unit of Measure Code><Vendor No.><Service Item No.><No.><Resource Group No.><Service Zone Code><No.><Gen. Prod. Posting Group><Unit of Measure Filter><Pay-to Vendor No.><Def. VAT Prod. Posting Group><Approver ID><Substitute>

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

Fields

# Name Type
1 No. Code20
2 Type Option
3 Name Text50
4 Search Name Code50
5 Name 2 Text50
6 Address Text50
7 Address 2 Text50
8 City Text30
9 Social Security No. Text30
10 Job Title Text30
11 Education Text30
12 Contract Class Text30
13 Employment Date Date
14 Resource Group No. Code20
16 Global Dimension 1 Code Code20
17 Global Dimension 2 Code Code20
18 Base Unit of Measure Code10
19 Direct Unit Cost Decimal
20 Indirect Cost % Decimal (2:2)
21 Unit Cost Decimal
22 Profit % Decimal (0:5)
23 Price/Profit Calculation Option
24 Unit Price Decimal
25 Vendor No. Code20
26 Last Date Modified Date Editable: No
27 Comment Boolean Editable: No
FlowField
38 Blocked Boolean
39 Date Filter Date FlowFilter
40 Unit of Measure Filter Code10 FlowFilter
41 Capacity Decimal (0:5) FlowField
42 Qty. on Order (Job) Decimal (0:5) Editable: No
FlowField
43 Qty. Quoted (Job) Decimal (0:5) Editable: No
FlowField
44 Usage (Qty.) Decimal (0:5) Editable: No
FlowField
45 Usage (Cost) Decimal Editable: No
FlowField
46 Usage (Price) Decimal Editable: No
FlowField
47 Sales (Qty.) Decimal (0:5) Editable: No
FlowField
48 Sales (Cost) Decimal Editable: No
FlowField
49 Sales (Price) Decimal Editable: No
FlowField
50 Chargeable Filter Boolean FlowFilter
51 Gen. Prod. Posting Group Code10
52 Picture BLOB [Bitmap]
53 Post Code Code20
54 County Text30
55 Automatic Ext. Texts Boolean
56 No. Series Code10 Editable: No
57 Tax Group Code Code10
58 VAT Prod. Posting Group Code10
59 Country/Region Code Code10
60 IC Partner Purch. G/L Acc. No. Code20
900 Qty. on Assembly Order Decimal (0:5) Editable: No
FlowField
950 Use Time Sheet Boolean
951 Time Sheet Owner User ID Code50
952 Time Sheet Approver User ID Code50
1700 Default Deferral Template Code Code10
5900 Qty. on Service Order Decimal (0:5) Editable: No
FlowField
5901 Service Zone Filter Code10
5902 In Customer Zone Boolean Editable: No
FlowField

Keys

# Fields
0 No. Clustered: Yes
1 Search Name
2 Gen. Prod. Posting Group
3 Name
4 Type
5 Base Unit of Measure

Table Relations To Other Tables

Field Related Table Related Field
Country/Region Code Country/Region Code 1..n
Default Deferral Template Code Deferral Template Deferral Code 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
IC Partner Purch. G/L Acc. No. IC G/L Account No. 1..n
No. Series No. Series Code 1..n
Resource Group No. Resource Group No. 1..n
Service Zone Filter Service Zone Code 1..n
Tax Group Code Tax Group Code 1..n
Unit of Measure Filter Unit of Measure Code 1..n
Time Sheet Approver User ID User Setup User ID 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n
Vendor No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Assembly Line No. 1..n
BOM Buffer No. 1..n
BOM Component No. 1..n
Capacity Ledger Entry No. 1..n
Comment Line No. 1..n
Default Dimension No. 1..n
Employee Resource No. 1..n
Extended Text Header No. 1..n
Extended Text Line No. 1..n
Item Journal Line No. 1..n
Job Resource Filter 1..n
Job Journal Line No. 1..n
Job Ledger Entry No. 1..n
Job Planning Line No. 1..n
Job Resource Price Code 1..n
Posted Assembly Line No. 1..n
Purchase Line Archive No. 1..n
Res. Capacity Entry Resource No. 1..n
Res. Journal Line Resource No. 1..n
Res. Ledger Entry Resource No. 1..n
Resource Cost Code 1..n
Resource Location Resource No. 1..n
Resource Price Code 1..n
Resource Price Change Code 1..n
Resource Service Zone Resource No. 1..n
Resource Skill No. 1..n
Resource Unit of Measure Resource No. 1..n
Return Receipt Line No. 1..n
Sales Cr.Memo Line No. 1..n
Sales Invoice Line No. 1..n
Sales Line No. 1..n
Sales Line Archive No. 1..n
Sales Shipment Buffer No. 1..n
Sales Shipment Line No. 1..n
Serv. Price Adjustment Detail No. 1..n
Service Cr.Memo Header Resource Filter 1..n
Service Cr.Memo Line No. 1..n
Service Header Resource Filter 1..n
Service Invoice Header Resource Filter 1..n
Service Invoice Line No. 1..n
Service Item Preferred Resource 1..n
Service Item Line Resource Filter 1..n
Service Ledger Entry No. 1..n
Service Line No. 1..n
Service Line Price Adjmt. No. 1..n
Service Order Allocation Resource No. 1..n
Service Shipment Buffer No. 1..n
Service Shipment Header Resource Filter 1..n
Service Shipment Item Line Resource Filter 1..n
Service Shipment Line No. 1..n
Standard Cost Worksheet No. 1..n
Standard Purchase Line No. 1..n
Standard Sales Line No. 1..n
Standard Service Line No. 1..n
Time Sheet Detail Resource No. 1..n
Time Sheet Detail Archive Resource No. 1..n
Time Sheet Header Resource No. 1..n
Time Sheet Header Archive Resource No. 1..n
Value Entry No. 1..n
Warranty Ledger Entry No. 1..n