Diagrams


Table

Service Ledger Entry

DynamicsDocs.comService Ledger Entry«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 5934»Service RegisterNo. [PK]From Entry No.To Entry No.From Warranty Entry No.To Warranty Entry No.Creation DateSource CodeUser ID«Table 5965»Service Contract HeaderContract No. [PK]Contract Type; [Quote,Contract] [PK]DescriptionDescription 2Status; [,Signed,Canceled]Change Status; [Open,Locked]Customer No. [NN]NameAddressAddress 2Post CodeCityContact NameYour ReferenceSalesperson CodeBill-to Customer No.Bill-to NameBill-to AddressBill-to Address 2Bill-to Post CodeBill-to CityShip-to CodeShip-to NameShip-to AddressShip-to Address 2Ship-to Post CodeShip-to CityServ. Contract Acc. Gr. CodeInvoice Period; [Month,Two Months,Quar...Last Invoice DateNext Invoice Date...«Table 5973»Service Contract Account GroupCode [PK]DescriptionNon-Prepaid Contract Acc.Prepaid Contract Acc.«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code«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 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«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 IDIdLast Modified Date Time«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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 5966»Contract GroupCode [PK,NN]DescriptionDisc. on Contr. Orders OnlyDate FilterContract Gain/Loss Amount«Table 7»Standard TextCode [PK,NN]Description«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 Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«Table 5917»Fault Reason CodeCode [PK,NN]DescriptionExclude Warranty DiscountExclude Contract Discount«Table 5903»Service Order TypeCode [PK,NN]Description«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Open,Completed...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 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId«Table 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated«Table 5714»Responsibility CenterCode [PK,NN]NameAddressAddress 2CityPost CodeCountry/Region CodePhone No.Fax No.Name 2ContactGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeCountyE-MailHome PageDate FilterContract Gain/Loss Amount«Table 6082»Service Price Adjustment GroupCode [PK,NN]Description«Table 6080»Service Price GroupCode [PK,NN]Description«Table 1001»Job TaskJob No. [PK,NN]Job Task No. [PK,NN]DescriptionJob Task Type; [Posting,Heading,Total,...WIP-Total; [,Total,Excluded]Job Posting GroupWIP MethodSchedule [Total Cost]Schedule [Total Price]Usage [Total Cost]Usage [Total Price]Contract [Total Cost]Contract [Total Price]Contract [Invoiced Price]Contract [Invoiced Cost]Posting Date FilterPlanning Date FilterTotalingNew PageNo. of Blank LinesIndentationRecognized Sales AmountRecognized Costs AmountRecognized Sales G/L AmountRecognized Costs G/L AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeOutstanding OrdersAmt. Rcd. Not InvoicedRemaining [Total Cost]Remaining [Total Price]...«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Service Contract No.><No.><Serv. Contract Acc. Gr. Code><Customer No.><Bill-to Customer No.><Ship-to Code><Item No. (Serviced)><No.><User ID><Global Dimension 1 Code><Global Dimension 2 Code><Service Item No. (Serviced)><Variant Code (Serviced)><Variant Code><Contract Group Code><No.><No.><No.><No.><Fault Reason Code><Service Order Type><Job No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Location Code><Unit of Measure Code><Work Type Code><Bin Code><Responsibility Center><Serv. Price Adjmt. Gr. Code><Service Price Group Code><Job Task No.><Dimension Set ID><From Entry No.><To Entry No.><User ID><Customer No.><Bill-to Customer No.><Ship-to Code><Serv. Contract Acc. Gr. Code><Contract Group Code><Service Order Type><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Price Inv. Increase Code><Responsibility Center><Item Filter><Dimension Set ID><Contract Filter><Non-Prepaid Contract Acc.><Prepaid Contract Acc.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Bill-to Customer No.><Location Code><Gen. Bus. Posting Group><Responsibility Center><Ship-to Filter><Customer No.><Bill-to Customer No.><Customer No.><Location Code><Ship-to Code><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Location Filter><Gen. Prod. Posting Group><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Unit of Measure Id><Item No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Value Code><Global Dimension 1 Code><Global Dimension 2 Code><Unit of Measure Code><Preferred Resource><Variant Code><Service Price Group Code><Base Unit of Measure><Unit of Measure Filter><Gen. Prod. Posting Group><Person Responsible><Resource Filter><Account No.><Unit of Measure Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Job No.><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Location Code><Location Code><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 Entry No. Integer
2 Service Contract No. Code20
3 Document Type Option
4 Document No. Code20
5 Serv. Contract Acc. Gr. Code Code10
6 Document Line No. Integer
8 Moved from Prepaid Acc. Boolean
9 Posting Date Date
11 Amount (LCY) Decimal
12 Customer No. Code20
13 Ship-to Code Code10
14 Item No. (Serviced) Code20
15 Serial No. (Serviced) Code20
16 User ID Code50
17 Contract Invoice Period Text30
18 Global Dimension 1 Code Code20
19 Global Dimension 2 Code Code20
20 Service Item No. (Serviced) Code20
21 Variant Code (Serviced) Code10
22 Contract Group Code Code10
23 Type Option
24 No. Code20
25 Cost Amount Decimal
26 Discount Amount Decimal
27 Unit Cost Decimal
28 Quantity Decimal (0:5)
29 Charged Qty. Decimal (0:5)
30 Unit Price Decimal
31 Discount % Decimal (0:5)
32 Contract Disc. Amount Decimal
33 Bill-to Customer No. Code20
34 Fault Reason Code Code10
35 Description Text50
37 Service Order Type Code10
39 Service Order No. Code20
40 Job No. Code20
41 Gen. Bus. Posting Group Code20
42 Gen. Prod. Posting Group Code20
43 Location Code Code10
44 Unit of Measure Code Code10
45 Work Type Code Code10
46 Bin Code Code20
47 Responsibility Center Code10
48 Variant Code Code10
50 Entry Type Option
51 Open Boolean
52 Serv. Price Adjmt. Gr. Code Code10
53 Service Price Group Code Code10
54 Prepaid Boolean
55 Apply Until Entry No. Integer
56 Applies-to Entry No. Integer
57 Amount Decimal
58 Job Task No. Code20
59 Job Line Type Option
60 Job Posted Boolean
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 Document No.,Posting Date
2 Entry Type,Document Type,Document No.,Document Line No.
3 Service Contract No.,Entry No.,Entry Type,Type,Moved from Prepaid Acc.,Posting Date,Open,Prepaid,Service Item No. (Serviced),Customer No.,Contract Group Code,Responsibility Center
4 Service Order No.,Service Item No. (Serviced),Entry Type,Moved from Prepaid Acc.,Posting Date,Open,Type,Service Contract No.
5 Type,No.,Entry Type,Moved from Prepaid Acc.,Posting Date,Open,Prepaid
6 Service Item No. (Serviced),Entry Type,Moved from Prepaid Acc.,Type,Posting Date,Open,Service Contract No.,Prepaid,Customer No.,Contract Group Code,Responsibility Center
7 Service Item No. (Serviced),Entry Type,Type,Service Contract No.,Posting Date,Service Order No.

Table Relations To Other Tables

Field Related Table Related Field
Bin Code Bin Code 1..n
Contract Group Code Contract Group Code 1..n
Bill-to Customer No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Fault Reason Code Fault Reason Code Code 1..n
No. G/L Account No. 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
No. Item No. 1..n
Variant Code Item Variant Code 1..n
Job No. Job No. 1..n
Job Task No. Job Task Job Task No. 1..n
Location Code Location Code 1..n
No. Resource No. 1..n
Responsibility Center Responsibility Center Code 1..n
Serv. Contract Acc. Gr. Code Service Contract Account Group Code 1..n
No. Service Contract Header Contract No. 1..n
No. Service Cost Code 1..n
Service Item No. (Serviced) Service Item No. 1..n
Service Order Type Service Order Type Code 1..n
Serv. Price Adjmt. Gr. Code Service Price Adjustment Group Code 1..n
Service Price Group Code Service Price Group Code 1..n
Ship-to Code Ship-to Address Code 1..n
No. Standard Text Code 1..n
Unit of Measure Code Unit of Measure Code 1..n
User ID User User Name 1..n
Work Type Code Work Type Code 1..n

Table Relations From Other Tables

From Table From Field
Service Register To Entry No. 1..n