Diagrams

Table

Warranty Ledger Entry

DynamicsDocs.comWarranty Ledger Entry«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 5934»Service RegisterNo. [PK]From Entry No.To Entry No.From Warranty Entry No.To Warranty Entry No.Creation DateSource CodeUser ID«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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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 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 5904»Service Item GroupCode [PK,NN]DescriptionCreate Service ItemDefault Contract Discount %Default Serv. Price Group CodeDefault Response Time [Hours]«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 5917»Fault Reason CodeCode [PK,NN]DescriptionExclude Warranty DiscountExclude Contract Discount«Table 5915»Fault AreaCode [PK,NN]Description«Table 5918»Fault CodeFault Area Code [PK]Symptom Code [PK]Code [PK,NN]Description«Table 5916»Symptom CodeCode [PK,NN]Description«Table 5919»Resolution CodeCode [PK,NN]Description«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 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard 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 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 ID«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 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Customer No.><Bill-to Customer No.><Ship-to Code><Variant Code (Serviced)><Variant Code><Service Item No. (Serviced)><Item No. (Serviced)><No.><Service Item Group (Serviced)><Service Contract No.><Fault Reason Code><Fault Area Code><Fault Code><Symptom Code><Resolution Code><No.><No.><No.><Work Type Code><Unit of Measure Code><Unit of Measure Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Vendor No.><Dimension Set ID><From Warranty Entry No.><To Warranty Entry No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Bill-to Customer No.><Gen. Bus. Posting Group><Ship-to Filter><Customer No.><Customer No.><Customer No.><Bill-to Customer No.><Ship-to Code><Ship-to Code><Item No.><Variant Filter><Variant Code><Service Item Group Code><Item No.><Unit of Measure Code><Unit of Measure Code><Vendor No.><Preferred Resource><Contract Filter><Vendor No.><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Gen. Prod. Posting Group><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Service Item Group><Item Filter><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Price Inv. Increase Code><Dimension Set ID><Fault Area Code><Symptom Code><Global Dimension 1 Code><Global Dimension 2 Code><Base Unit of Measure><Unit of Measure Filter><Vendor No.><Gen. Prod. Posting Group><Unit of Measure Code><Unit of Measure Code><Code><Gen. Bus. Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Dimension Value Code><Pay-to Vendor No.>

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

Fields

# Name Type
1 Entry No. (Entry No.) Integer
3 Document No. (Document No.) Code20
4 Posting Date (Posting Date) Date
5 Customer No. (Customer No.) Code20
6 Ship-to Code (Ship-to Code) Code10
7 Bill-to Customer No. (Bill-to Customer No.) Code20
8 Variant Code (Serviced) (Variant Code (Serviced)) Code10
9 Service Item No. (Serviced) (Service Item No. (Serviced)) Code20
10 Item No. (Serviced) (Item No. (Serviced)) Code20
11 Serial No. (Serviced) (Serial No. (Serviced)) Code20
12 Service Item Group (Serviced) (Service Item Group (Serviced)) Code10
13 Service Order No. (Service Order No.) Code20
14 Service Contract No. (Service Contract No.) Code20
15 Fault Reason Code (Fault Reason Code) Code10
16 Fault Area Code (Fault Area Code) Code10
17 Fault Code (Fault Code) Code10
18 Symptom Code (Symptom Code) Code10
19 Resolution Code (Resolution Code) Code10
20 Type (Type) Option
21 No. (No.) Code20
22 Quantity (Quantity) Decimal (0:5)
24 Work Type Code (Work Type Code) Code10
25 Unit of Measure Code (Unit of Measure Code) Code10
26 Amount (Amount) Decimal
27 Description (Description) Text50
29 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
30 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
31 Global Dimension 1 Code (Global Dimension 1 Code) Code20
32 Global Dimension 2 Code (Global Dimension 2 Code) Code20
33 Open (Open) Boolean
35 Vendor No. (Vendor No.) Code20
36 Vendor Item No. (Vendor Item No.) Text20
38 Variant Code (Variant Code) Code10
39 Service Order Line No. (Service Order Line No.) Integer
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Service Item No. (Serviced),Posting Date,Document No. (Service Item No. (Serviced),Posting Date,Document No.)
2 Service Order No.,Posting Date,Document No. (Service Order No.,Posting Date,Document No.)
3 Service Contract No.,Posting Date,Document No. (Service Contract No.,Posting Date,Document No.)
4 Document No.,Posting Date (Document No.,Posting Date)

Table Relations To Other Tables

Field Related Table Related Field
Bill-to Customer No. (Bill-to Customer No.) Customer No. (No.) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
Fault Area Code (Fault Area Code) Fault Area Code (Code) 1..n
Fault Code (Fault Code) Fault Code Code (Code) 1..n
Fault Reason Code (Fault Reason Code) Fault Reason Code Code (Code) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
No. (No.) Item No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Resolution Code (Resolution Code) Resolution Code Code (Code) 1..n
No. (No.) Resource No. (No.) 1..n
Service Contract No. (Service Contract No.) Service Contract Header Contract No. (Contract No.) 1..n
No. (No.) Service Cost Code (Code) 1..n
Service Item No. (Serviced) (Service Item No. (Serviced)) Service Item No. (No.) 1..n
Service Item Group (Serviced) (Service Item Group (Serviced)) Service Item Group Code (Code) 1..n
Ship-to Code (Ship-to Code) Ship-to Address Code (Code) 1..n
No. (No.) Standard Text Code (Code) 1..n
Symptom Code (Symptom Code) Symptom Code Code (Code) 1..n
Unit of Measure Code (Unit of Measure Code) Unit of Measure Code (Code) 1..n
Vendor No. (Vendor No.) Vendor No. (No.) 1..n
Work Type Code (Work Type Code) Work Type Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Service Register To Warranty Entry No. (To Warranty Entry No.) 1..n