Diagrams

Table

Service Shipment Item Line

DynamicsDocs.comService Shipment Item Line«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 5990»Service Shipment HeaderCustomer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price Group...«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 5904»Service Item GroupCode [PK,NN]DescriptionCreate Service ItemDefault Contract Discount %Default Serv. Price Group CodeDefault Response Time [Hours]«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 5929»Service ShelfNo. [PK,NN]Description«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 5913»LoanerNo. [PK]DescriptionDescription 2Unit of Measure CodeItem No.Last Date ModifiedCommentBlockedNo. SeriesDocument No.LentSerial No.Document Type; [,Quote,Order]«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 5917»Fault Reason CodeCode [PK,NN]DescriptionExclude Warranty DiscountExclude Contract Discount«Table 6080»Service Price GroupCode [PK,NN]Description«Table 5915»Fault AreaCode [PK,NN]Description«Table 5916»Symptom CodeCode [PK,NN]Description«Table 5918»Fault CodeFault Area Code [PK]Symptom Code [PK]Code [PK,NN]Description«Table 5919»Resolution CodeCode [PK,NN]Description«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 6082»Service Price Adjustment GroupCode [PK,NN]Description«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 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 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 152»Resource GroupNo. [PK,NN]NameDate FilterCapacityQty. on Order [Job]Qty. Quoted [Job]Unit of Measure FilterUsage [Qty.]Usage [Cost]Usage [Price]Sales [Qty.]Sales [Cost]Sales [Price]Chargeable FilterGlobal Dimension 1 CodeGlobal Dimension 2 CodeNo. of Resources AssignedQty. on Service Order«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 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<No.><Service Item No.><Service Item Group Code><Item No.><Service Shelf No.><Contract No.><Loaner No.><Vendor No.><Fault Reason Code><Service Price Group Code><Fault Area Code><Symptom Code><Fault Code><Resolution Code><Variant Code><Service Price Adjmt. Gr. Code><Ship-to Code><Customer No.><Resource Filter><Resource Group Filter><Responsibility Center><Dimension Set ID><Customer No.><Bill-to Customer No.><Customer Filter><Ship-to Code><Dimension Set ID><Responsibility Center><Contract No.><Contract Filter><Posted Service Order Filter><Resource Filter><Resource Group Filter><Service Item Group Code><Customer No.><Ship-to Code><Item No.><Vendor No.><Preferred Resource><Variant Code><Service Price Group Code><Contract Filter><Default Serv. Price Group Code><Service Item Group><Vendor No.><Alternative Item No.><Variant Filter><Item No.><Item No.><Item Filter><Customer No.><Bill-to Customer No.><Ship-to Code><Responsibility Center><Dimension Set ID><Pay-to Vendor No.><Responsibility Center><Vendor No.><Fault Area Code><Symptom Code><Customer No.><Ship-to Filter><Bill-to Customer No.><Responsibility Center><Resource Group No.>

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

Fields

# Name Type
1 No. (No.) Code20 Editable: No
2 Line No. (Line No.) Integer
3 Service Item No. (Service Item No.) Code20
4 Service Item Group Code (Service Item Group Code) Code10
5 Item No. (Item No.) Code20
6 Serial No. (Serial No.) Code20
7 Description (Description) Text50
8 Description 2 (Description 2) Text50
10 Priority (Priority) Option
11 Response Time (Hours) (Response Time (Hours)) Decimal (0:5)
12 Response Date (Response Date) Date
13 Response Time (Response Time) Time
14 Starting Date (Starting Date) Date Editable: No
15 Starting Time (Starting Time) Time Editable: No
16 Finishing Date (Finishing Date) Date Editable: No
17 Finishing Time (Finishing Time) Time Editable: No
18 Service Shelf No. (Service Shelf No.) Code10
19 Warranty Starting Date (Parts) (Warranty Starting Date (Parts)) Date
20 Warranty Ending Date (Parts) (Warranty Ending Date (Parts)) Date
21 Warranty (Warranty) Boolean
22 Warranty % (Parts) (Warranty % (Parts)) Decimal (0:5)
23 Warranty % (Labor) (Warranty % (Labor)) Decimal (0:5)
24 Warranty Starting Date (Labor) (Warranty Starting Date (Labor)) Date
25 Warranty Ending Date (Labor) (Warranty Ending Date (Labor)) Date
26 Contract No. (Contract No.) Code20 Editable: No
27 Location of Service Item (Location of Service Item) Text30 Editable: No
FlowField
28 Loaner No. (Loaner No.) Code20
29 Vendor No. (Vendor No.) Code20
30 Vendor Item No. (Vendor Item No.) Text20
31 Fault Reason Code (Fault Reason Code) Code10
32 Service Price Group Code (Service Price Group Code) Code10
33 Fault Area Code (Fault Area Code) Code10
34 Symptom Code (Symptom Code) Code10
35 Fault Code (Fault Code) Code10
36 Resolution Code (Resolution Code) Code10
37 Fault Comment (Fault Comment) Boolean Editable: No
FlowField
38 Resolution Comment (Resolution Comment) Boolean Editable: No
FlowField
39 Accessory Comment (Accessory Comment) Boolean Editable: No
FlowField
40 Variant Code (Variant Code) Code10
42 Actual Response Time (Hours) (Actual Response Time (Hours)) Decimal (0:5)
44 Service Price Adjmt. Gr. Code (Service Price Adjmt. Gr. Code) Code10 Editable: No
45 Adjustment Type (Adjustment Type) Option Editable: No
46 Base Amount to Adjust (Base Amount to Adjust) Decimal Editable: No
60 No. of Active/Finished Allocs (No. of Active/Finished Allocs) Integer Editable: No
FlowField
64 Ship-to Code (Ship-to Code) Code10 Editable: No
65 Customer No. (Customer No.) Code20 Editable: No
91 Date Filter (Date Filter) Date FlowFilter
92 Resource Filter (Resource Filter) Code20 FlowFilter
93 Allocation Date Filter (Allocation Date Filter) Date FlowFilter
95 Resource Group Filter (Resource Group Filter) Code20 FlowFilter
97 Responsibility Center (Responsibility Center) Code10 Editable: No
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 No.,Line No. (No.,Line No.) Clustered: Yes
1 Service Item No. (Service Item No.)
2 Item No.,Serial No.,Loaner No. (Item No.,Serial No.,Loaner No.)
3 Service Price Group Code,Adjustment Type,Base Amount to Adjust,Customer No. (Service Price Group Code,Adjustment Type,Base Amount to Adjust,Customer No.)

Table Relations To Other Tables

Field Related Table Related Field
Customer No. (Customer No.) Customer No. (No.) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 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
Item No. (Item No.) Item No. (No.) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Loaner No. (Loaner No.) Loaner No. (No.) 1..n
Resolution Code (Resolution Code) Resolution Code Code (Code) 1..n
Resource Filter (Resource Filter) Resource No. (No.) 1..n
Resource Group Filter (Resource Group Filter) Resource Group No. (No.) 1..n
Responsibility Center (Responsibility Center) Responsibility Center Code (Code) 1..n
Contract No. (Contract No.) Service Contract Header Contract No. (Contract No.) 1..n
Service Item No. (Service Item No.) Service Item No. (No.) 1..n
Service Item Group Code (Service Item Group Code) Service Item Group Code (Code) 1..n
Service Price Adjmt. Gr. Code (Service Price Adjmt. Gr. Code) Service Price Adjustment Group Code (Code) 1..n
Service Price Group Code (Service Price Group Code) Service Price Group Code (Code) 1..n
Service Shelf No. (Service Shelf No.) Service Shelf No. (No.) 1..n
No. (No.) Service Shipment Header No. (No.) 1..n
Ship-to Code (Ship-to Code) Ship-to Address Code (Code) 1..n
Symptom Code (Symptom Code) Symptom Code Code (Code) 1..n
Vendor No. (Vendor No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field