Diagrams

Table

Resource Unit of Measure

DynamicsDocs.comResource Unit of Measure«Table 205»Resource Unit of MeasureResource No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureRelated to Base Unit of Meas.«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 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 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 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 5870»BOM BufferEntry No. [PK]Type; [,Item,Machine Center,Work Cente...No.DescriptionUnit of Measure CodeVariant CodeLocation CodeReplenishment System; [Purchase,Prod....IndentationIs LeafBottleneckRouting No.Production BOM No.Lot SizeLow-Level CodeRounding PrecisionQty. per ParentQty. per Top ItemAble to Make Top ItemAble to Make ParentAvailable QuantityGross RequirementScheduled ReceiptsUnused QuantityLead Time CalculationLead-Time OffsetRolled-up Lead-Time OffsetNeeded by DateSafety Lead TimeUnit CostIndirect Cost %...«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 83»Item Journal LineJournal Template Name [PK]Line No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupQuantityInvoiced QuantityUnit AmountUnit CostAmountDiscount AmountSalespers./Purch. CodeSource CodeApplies-to EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Source Type; [,Customer,Vendor,Item]Journal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyDrop Shipment...«Table 901»Assembly LineDocument Type; [Quote,Order,,,Blanket...Document No. [PK]Line No. [PK]Type; [,Item,Resource]No.Variant CodeDescriptionDescription 2Lead-Time OffsetResource Usage Type; [,Direct,Fixed]Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodePositionPosition 2Position 3Appl.-to Item EntryAppl.-from Item EntryQuantityQuantity [Base]Remaining QuantityRemaining Quantity [Base]Consumed QuantityConsumed Quantity [Base]Quantity to ConsumeQuantity to Consume [Base]Reserved QuantityReserved Qty. [Base]Avail. WarningSubstitution Available...«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 911»Posted Assembly LineDocument No. [PK]Line No. [PK]Order No.Order Line No.Type; [,Item,Resource]No.Variant CodeDescriptionDescription 2Lead-Time OffsetResource Usage Type; [,Direct,Fixed]Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodePositionPosition 2Position 3Item Shpt. Entry No.QuantityQuantity [Base]Due DateQuantity perQty. per Unit of MeasureInventory Posting GroupGen. Prod. Posting GroupUnit CostCost AmountUnit of Measure CodeDimension Set ID«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 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code<Resource No.><Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><BOM Unit of Measure Code><Unit of Measure Code><Cap. Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><No.><Unit of Measure Code><Job Ledger Entry No.><No.><Resource No.><No.><Unit of Measure Code><Attached to Line No.><Blanket Order Line No.><Unit of Measure Code><No.><No.><Attached to Line No.><Unit of Measure Code><No.><No.><No.><No.><Base Unit of Measure><Unit of Measure Filter>

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

Fields

# Name Type
1 Resource No. (Resource No.) Code20 NotBlank: Yes
2 Code (Code) Code10 NotBlank: Yes
3 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5)
4 Related to Base Unit of Meas. (Related to Base Unit of Meas.) Boolean

Keys

# Fields
0 Resource No.,Code (Resource No.,Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Resource No. (Resource No.) Resource No. (No.) 1..n
Code (Code) Unit of Measure Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Assembly Line Unit of Measure Code (Unit of Measure Code) 1..n
BOM Buffer BOM Unit of Measure Code (BOM Unit of Measure Code) 1..n
BOM Component Unit of Measure Code (Unit of Measure Code) 1..n
Item Journal Line Cap. Unit of Measure Code (Cap. Unit of Measure Code) 1..n
Job Journal Line Unit of Measure Code (Unit of Measure Code) 1..n
Job Ledger Entry Unit of Measure Code (Unit of Measure Code) 1..n
Job Planning Line Unit of Measure Code (Unit of Measure Code) 1..n
Posted Assembly Line Unit of Measure Code (Unit of Measure Code) 1..n
Res. Journal Line Unit of Measure Code (Unit of Measure Code) 1..n
Sales Line Unit of Measure Code (Unit of Measure Code) 1..n
Service Line Unit of Measure Code (Unit of Measure Code) 1..n