Diagrams


Table

Work Type

DynamicsDocs.comWork Type«Table 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code«Table 1003»Job Planning LineLine No. [PK]Job No. [PK,NN]Planning DateDocument No.Type; [Resource,Item,G/L Account,Text]No.DescriptionQuantityDirect Unit Cost [LCY]Unit Cost [LCY]Total Cost [LCY]Unit Price [LCY]Total Price [LCY]Resource Group No.Unit of Measure CodeLocation CodeLast Date ModifiedUser IDWork Type CodeCustomer Price GroupCountry/Region CodeGen. Bus. Posting GroupGen. Prod. Posting GroupDocument DateJob Task No. [PK,NN]Line Amount [LCY]Unit CostTotal CostUnit PriceTotal PriceLine Amount...«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 111»Sales Shipment LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No....«Table 113»Sales Invoice LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeShipment No....«Table 115»Sales Cr.Memo LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeBill-to Customer No....«Table 169»Job Ledger EntryEntry No. [PK]Job No.Posting DateDocument No.Type; [Resource,Item,G/L Account]No.DescriptionQuantityDirect Unit Cost [LCY]Unit Cost [LCY]Total Cost [LCY]Unit Price [LCY]Total Price [LCY]Resource Group No.Unit of Measure CodeLocation CodeJob Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeWork Type CodeCustomer Price GroupUser IDSource CodeAmt. to Post to G/LAmt. Posted to G/LEntry Type; [Usage,Sale]Journal Batch NameReason CodeTransaction TypeTransport MethodCountry/Region 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 203»Res. Ledger EntryEntry No. [PK]Entry Type; [Usage,Sale]Document No.Posting DateResource No.Resource Group No.DescriptionWork Type CodeJob No.Unit of Measure CodeQuantityDirect Unit CostUnit CostTotal CostUnit PriceTotal PriceGlobal Dimension 1 CodeGlobal Dimension 2 CodeUser IDSource CodeChargeableJournal Batch NameReason CodeGen. Bus. Posting GroupGen. Prod. Posting GroupDocument DateExternal Document No.No. SeriesSource Type; [,Customer]Source No.Qty. per Unit of Measure...«Table 207»Res. Journal LineJournal Template Name [PK]Line No. [PK]Entry Type; [Usage,Sale]Document No.Posting DateResource No.Resource Group No.DescriptionWork Type CodeJob No.Unit of Measure CodeQuantityDirect Unit CostUnit CostTotal CostUnit PriceTotal PriceShortcut Dimension 1 CodeShortcut Dimension 2 CodeSource CodeJournal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyGen. Bus. Posting GroupGen. Prod. Posting GroupDocument DateExternal Document No.Posting No. SeriesSource Type; [,Customer]...«Table 210»Job Journal LineJournal Template Name [PK]Line No. [PK]Job No.Posting DateDocument No.Type; [Resource,Item,G/L Account]No.DescriptionQuantityDirect Unit Cost [LCY]Unit Cost [LCY]Total Cost [LCY]Unit Price [LCY]Total Price [LCY]Resource Group No.Unit of Measure CodeLocation CodeChargeablePosting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeWork Type CodeCustomer Price GroupApplies-to EntryEntry Type; [Usage,Sale]Source CodeJournal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring Frequency...«Table 212»Job Posting BufferJob No. [PK]Entry Type; [Usage,Sale] [PK]Posting Group Type; [Resource,Item,G/L...No. [PK]Posting Group [PK]Global Dimension 1 CodeGlobal Dimension 2 CodeUnit of Measure Code [PK]Work Type Code [PK]AmountQuantityTotal CostTotal PriceApplies-to IDGen. Bus. Posting Group [PK]Gen. Prod. Posting Group [PK]Additional-Currency AmountDimension Entry No. [PK]Variant Code [PK]Dimension Set ID«Table 278»Job Journal QuantityIs Total [PK]Unit of Measure Code [PK]Line Type; [,Total] [PK]Work Type Code [PK]Quantity«Table 335»Resource Price ChangeType; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Currency Code [PK]Current Unit PriceNew Unit Price«Table 37»Sales LineDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 Code...«Table 5108»Sales Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupQuantity Disc. CodeShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«Table 5902»Service LineDocument Type; [Quote,Order,Invoice,Cr...Customer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price Group...«Table 5907»Service Ledger EntryEntry No. [PK]Service Contract No.Document Type; [,Payment,Invoice,Credi...Document No.Serv. Contract Acc. Gr. CodeDocument Line No.Moved from Prepaid Acc.Posting DateAmount [LCY]Customer No.Ship-to CodeItem No. [Serviced]Serial No. [Serviced]User IDContract Invoice PeriodGlobal Dimension 1 CodeGlobal Dimension 2 CodeService Item No. [Serviced]Variant Code [Serviced]Contract Group CodeType; [,Resource,Item,Service Cost,Ser...No.Cost AmountDiscount AmountUnit CostQuantityCharged Qty.Unit PriceDiscount %Contract Disc. AmountBill-to Customer No....«Table 5908»Warranty Ledger EntryEntry No. [PK]Document No.Posting DateCustomer No.Ship-to CodeBill-to Customer No.Variant Code [Serviced]Service Item No. [Serviced]Item No. [Serviced]Serial No. [Serviced]Service Item Group [Serviced]Service Order No.Service Contract No.Fault Reason CodeFault Area CodeFault CodeSymptom CodeResolution CodeType; [,Item,Resource,Service Cost]No.QuantityWork Type CodeUnit of Measure CodeAmountDescriptionGen. Bus. Posting GroupGen. Prod. Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeOpenVendor No....«Table 5933»Service Order Posting BufferService Order No. [PK]Entry Type; [Usage,Sale] [PK]Posting Group Type; [,Resource,Item,Se...No. [PK]Global Dimension 1 Code [PK]Global Dimension 2 Code [PK]Gen. Bus. Posting Group [PK]Gen. Prod. Posting Group [PK]Unit of Measure Code [PK]Work Type CodeQuantityTotal CostTotal PriceAppl.-to Service Entry [PK]Service Contract No.Service Item No. [PK]Qty. to InvoiceLocation Code [PK]Dimension Entry No.Line Discount %Dimension Set ID«Table 5991»Service Shipment LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No.Order Line No.Bill-to Customer No....«Table 5993»Service Invoice LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeShipment No.Shipment Line No.Bill-to Customer No....«Table 5995»Service Cr.Memo LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeShipment No.Bill-to Customer No.Inv. Discount AmountGen. Bus. Posting Group...«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 6661»Return Receipt LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQuantity InvoicedBill-to Customer No.Gen. Bus. Posting Group...«Table 951»Time Sheet LineTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«Table 955»Time Sheet Line ArchiveTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId<Unit of Measure Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type Code><Work Type><Work Type Code><Work Type Code><Work Type Code><Unit of Measure Code><Job Ledger Entry No.><Ledger Entry No.><Attached to Line No.><Blanket Order Line No.><Unit of Measure Code><Attached to Line No.><Blanket Order Line No.><Unit of Measure Code><Attached to Line No.><Blanket Order Line No.><Unit of Measure Code><Ledger Entry No.><Unit of Measure Code><Ledger Entry No.><Time Sheet Line No.><Unit of Measure Code><Time Sheet Line No.><Unit of Measure Code><Attached to Line No.><Blanket Order Line No.><Unit of Measure Code><Blanket Order Line No.><Blanket Order Line No.><Attached to Line No.><Unit of Measure Code><Attached to Line No.><Time Sheet Line No.><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Time Sheet Line No.><Unit of Measure Code><Attached to Line No.><Unit of Measure Code><Attached to Line No.><Unit of Measure Code><Attached to Line No.><Unit of Measure Code>

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

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Description Text50
3 Unit of Measure Code Code10

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Unit of Measure Code Unit of Measure Code 1..n

Table Relations From Other Tables

From Table From Field
Job Journal Line Work Type Code 1..n
Job Journal Quantity Work Type Code 1..n
Job Ledger Entry Work Type Code 1..n
Job Planning Line Work Type Code 1..n
Job Posting Buffer Work Type Code 1..n
Job Resource Price Work Type Code 1..n
Res. Journal Line Work Type Code 1..n
Res. Ledger Entry Work Type Code 1..n
Resource Cost Work Type Code 1..n
Resource Price Work Type Code 1..n
Resource Price Change Work Type Code 1..n
Return Receipt Line Work Type Code 1..n
Sales Cr.Memo Line Work Type Code 1..n
Sales Invoice Line Work Type Code 1..n
Sales Line Work Type Code 1..n
Sales Line Archive Work Type Code 1..n
Sales Shipment Line Work Type Code 1..n
Serv. Price Adjustment Detail Work Type 1..n
Service Cr.Memo Line Work Type Code 1..n
Service Invoice Line Work Type Code 1..n
Service Ledger Entry Work Type Code 1..n
Service Line Work Type Code 1..n
Service Order Posting Buffer Work Type Code 1..n
Service Shipment Line Work Type Code 1..n
Time Sheet Line Work Type Code 1..n
Time Sheet Line Archive Work Type Code 1..n
Warranty Ledger Entry Work Type Code 1..n