Diagrams

Table

Fault Code

DynamicsDocs.comFault Code«Table 5918»Fault CodeFault Area Code [PK]Symptom Code [PK]Code [PK,NN]Description«Table 5901»Service Item LineDocument No. [PK]Line No. [PK]Service Item No.Service Item Group CodeItem No.Serial No.DescriptionDescription 2Repair Status CodePriority; [Low,Medium,High]Response Time [Hours]Response DateResponse TimeStarting DateStarting TimeFinishing DateFinishing TimeService Shelf No.Warranty Starting Date [Parts]Warranty Ending Date [Parts]WarrantyWarranty % [Parts]Warranty % [Labor]Warranty Starting Date [Labor]Warranty Ending Date [Labor]Contract No.Location of Service ItemLoaner No.Vendor No.Vendor Item No.Fault Reason Code...«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 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 5920»Fault/Resol. Cod. RelationshipFault Code [PK]Symptom Code [PK]Fault Area Code [PK]Resolution Code [PK]OccurrencesDescriptionService Item Group Code [PK]Created Manually«Table 5989»Service Shipment Item LineNo. [PK]Line No. [PK]Service Item No.Service Item Group CodeItem No.Serial No.DescriptionDescription 2Priority; [Low,Medium,High]Response Time [Hours]Response DateResponse TimeStarting DateStarting TimeFinishing DateFinishing TimeService Shelf No.Warranty Starting Date [Parts]Warranty Ending Date [Parts]WarrantyWarranty % [Parts]Warranty % [Labor]Warranty Starting Date [Labor]Warranty Ending Date [Labor]Contract No.Location of Service ItemLoaner No.Vendor No.Vendor Item No.Fault Reason CodeService Price Group Code...«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 5915»Fault AreaCode [PK,NN]Description«Table 5916»Symptom CodeCode [PK,NN]Description<Fault Area Code><Symptom Code><Fault Code><Fault Code><Fault Code><Fault Code><Fault Code><Fault Code><Fault Code><Fault Code><Fault Area Code><Symptom Code><Service Item Line No.><Attached to Line No.><Fault Area Code><Symptom Code><Fault Area Code><Symptom Code><Symptom Code><Fault Area Code><Fault Area Code><Symptom Code><Fault Area Code><Symptom Code><Attached to Line No.><Fault Area Code><Symptom Code><Attached to Line No.><Fault Area Code><Symptom Code>

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

Fields

# Name Type
1 Fault Area Code (Fault Area Code) Code10
2 Symptom Code (Symptom Code) Code10
3 Code (Code) Code10 NotBlank: Yes
4 Description (Description) Text80

Keys

# Fields
0 Fault Area Code,Symptom Code,Code (Fault Area Code,Symptom Code,Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Fault Area Code (Fault Area Code) Fault Area Code (Code) 1..n
Symptom Code (Symptom Code) Symptom Code Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Fault/Resol. Cod. Relationship Fault Code (Fault Code) 1..n
Service Cr.Memo Line Fault Code (Fault Code) 1..n
Service Invoice Line Fault Code (Fault Code) 1..n
Service Item Line Fault Code (Fault Code) 1..n
Service Line Fault Code (Fault Code) 1..n
Service Shipment Item Line Fault Code (Fault Code) 1..n
Service Shipment Line Fault Code (Fault Code) 1..n
Warranty Ledger Entry Fault Code (Fault Code) 1..n