Diagrams


Table

Service Header

DynamicsDocs.comService Header«Table 5900»Service HeaderDocument Type; [Quote,Order,Invoice,Cr...Customer No.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 DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«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 5906»Service Comment LineType; [General,Fault,Resolution,Access...No. [PK,NN]Table Line No. [PK]Line No. [PK]CommentDateTable Subtype; [0,1,2,3] [PK]Table Name; [Service Contract,Service...«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 5942»Service Item LogService Item No. [PK,NN]Entry No. [PK]Event No.Document No.AfterBeforeChange DateChange TimeUser IDDocument Type; [,Quote,Order,Contract]«Table 951»Time Sheet LineTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«Table 952»Time Sheet DetailTime Sheet No. [PK]Time Sheet Line No. [PK]Date [PK]Type; [,Resource,Job,Service,Absence,A...Resource No.Job No.Job Task No.Cause of Absence CodeService Order No.Service Order Line No.QuantityPosted QuantityAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Posted«Table 955»Time Sheet Line ArchiveTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«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 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. Memos«Table 10»Shipment MethodCode [PK,NN]Description«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 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line Account«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«Table 340»Customer Discount GroupCode [PK,NN]Description«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 Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc....«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«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 5992»Service Invoice 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 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 258»Transaction TypeCode [PK,NN]Description«Table 259»Transport MethodCode [PK,NN]Description«Table 282»Entry/Exit PointCode [PK,NN]Description«Table 285»Transaction SpecificationCode [PK,NN]Text«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. Type«Table 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 318»Tax AreaCode [PK,NN]Description«Table 323»VAT Business Posting GroupCode [PK,NN]Description«Table 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First Name...«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 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code«Table 5903»Service Order TypeCode [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 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 5957»Service ZoneCode [PK,NN]Description«Table 91»User SetupUser ID [PK,NN]Allow Posting FromAllow Posting ToRegister TimeSalespers./Purch. CodeApprover IDSales Amount Approval LimitPurchase Amount Approval LimitUnlimited Sales ApprovalUnlimited Purchase ApprovalSubstituteE-MailRequest Amount Approval LimitUnlimited Request ApprovalApproval AdministratorLicense Type; [Full User,Limited User,...Time Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter<Customer No.><Bill-to Customer No.><Customer Filter><Ship-to Code><Payment Terms Code><Shipment Method Code><Location Code><Location Filter><Customer Posting Group><Customer Price Group><Customer Disc. Group><Bal. Account No.><Bal. Account No.><Last Shipping No.><Last Posting No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><Shipping Agent Code><Tax Area Code><VAT Bus. Posting Group><Contact No.><Bill-to Contact No.><Responsibility Center><Shipping Agent Service Code><Service Order Type><Contract No.><Contract Filter><Resource Filter><Resource Group Filter><Service Zone Filter><Service Zone Code><Assigned User ID><Document No.><Service Order Filter><Document No.><No.><Service Order Filter><Document No.><Service Order No.><Service Order No.><Service Order No.><Service Item No.><Contract No.><Ship-to Code><Customer No.><Resource Filter><Responsibility Center><Resource Group Filter><Service Item Line No.><Customer No.><Bill-to Customer No.><No.><No.><Location Code><Customer Price Group><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><Tax Area Code><VAT Bus. Posting Group><Time Sheet Line No.><Time Sheet Date><Responsibility Center><Shipping Agent Code><Shipping Agent Service Code><Service Item No.><Replaced Item No.><Ship-to Code><Contract No.><Customer Disc. Group><No.><No.><Customer No.><Ship-to Code><Preferred Resource><Contract Filter><Service Item No.><Document No.><Approver ID><Approved By><Resource No.><Approver ID><Approved By><Customer Posting Group><Customer Price Group><Payment Terms Code><Cash Flow Payment Terms Code><Shipment Method Code><Shipping Agent Code><Customer Disc. Group><Bill-to Customer No.><Payment Method Code><Location Code><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><Primary Contact No.><Responsibility Center><Shipping Agent Service Code><Service Zone Code><Ship-to Filter><Customer No.><Customer No.><Bill-to Customer No.><Customer No.><Bill-to Customer No.><Customer Filter><Customer No.><Bill-to Customer No.><Customer Filter><Shipment Method Code><Shipping Agent Code><Location Code><Tax Area Code><Shipping Agent Service Code><Service Zone Code><Ship-to Code><Ship-to Code><Ship-to Code><Direct Debit Pmt. Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Location Code><Location Code><Location Code><Receivables Account><Service Charge Acc.><Payment Disc. Debit Acc.><Invoice Rounding Account><Additional Fee Account><Interest Account><Debit Curr. Appln. Rndg. Acc.><Credit Curr. Appln. Rndg. Acc.><Debit Rounding Account><Credit Rounding Account><Payment Disc. Credit Acc.><Payment Tolerance Debit Acc.><Payment Tolerance Credit Acc.><Add. Fee per Line Account><Customer Posting Group><Customer Posting Group><VAT Bus. Posting Gr. (Price)><Customer Price Group><Customer Price Group><Customer Disc. Group><Customer Disc. Group><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><Tax Area Code><VAT Bus. Posting Group><Contact No.><Bill-to Contact No.><Responsibility Center><Service Order Type><Contract No.><Contract Filter><Posted Service Order Filter><Resource Filter><Resource Group Filter><Service Zone Filter><Service Zone Code><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><Tax Area Code><VAT Bus. Posting Group><Contact No.><Bill-to Contact No.><Responsibility Center><Service Order Type><Contract No.><Contract Filter><Resource Filter><Resource Group Filter><Service Zone Filter><Service Zone Code><Cancel Reason Code><Reason Code Filter><Def. VAT Bus. Posting Group><Shipping Agent Code><Company No.><Lookup Contact No.><Contact No.><Bill-to Contact No.><Responsibility Center><Sales Resp. Ctr. Filter><Purchase Resp. Ctr. Filter><Service Resp. Ctr. Filter><Service Order Type><Service Zone Code><Resource Group No.><Time Sheet Owner User ID><Time Sheet Approver User ID><Service Zone Filter><Approver ID><Substitute>

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

Fields

# Name Type
1 Document Type (Document Type) Option
2 Customer No. (Customer No.) Code20
3 No. (No.) Code20
4 Bill-to Customer No. (Bill-to Customer No.) Code20 NotBlank: Yes
5 Bill-to Name (Bill-to Name) Text50
6 Bill-to Name 2 (Bill-to Name 2) Text50
7 Bill-to Address (Bill-to Address) Text50
8 Bill-to Address 2 (Bill-to Address 2) Text50
9 Bill-to City (Bill-to City) Text30
10 Bill-to Contact (Bill-to Contact) Text50
11 Your Reference (Your Reference) Text35
12 Ship-to Code (Ship-to Code) Code10
13 Ship-to Name (Ship-to Name) Text50
14 Ship-to Name 2 (Ship-to Name 2) Text50
15 Ship-to Address (Ship-to Address) Text50
16 Ship-to Address 2 (Ship-to Address 2) Text50
17 Ship-to City (Ship-to City) Text30
18 Ship-to Contact (Ship-to Contact) Text50
19 Order Date (Order Date) Date NotBlank: Yes
20 Posting Date (Posting Date) Date
22 Posting Description (Posting Description) Text50
23 Payment Terms Code (Payment Terms Code) Code10
24 Due Date (Due Date) Date
25 Payment Discount % (Payment Discount %) Decimal (0:5)
26 Pmt. Discount Date (Pmt. Discount Date) Date
27 Shipment Method Code (Shipment Method Code) Code10
28 Location Code (Location Code) Code10
29 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
30 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
31 Customer Posting Group (Customer Posting Group) Code10 Editable: No
32 Currency Code (Currency Code) Code10
33 Currency Factor (Currency Factor) Decimal (0:15) Editable: No
34 Customer Price Group (Customer Price Group) Code10
35 Prices Including VAT (Prices Including VAT) Boolean
37 Invoice Disc. Code (Invoice Disc. Code) Code20
40 Customer Disc. Group (Customer Disc. Group) Code20
41 Language Code (Language Code) Code10
43 Salesperson Code (Salesperson Code) Code10
46 Comment (Comment) Boolean Editable: No
FlowField
47 No. Printed (No. Printed) Integer Editable: No
52 Applies-to Doc. Type (Applies-to Doc. Type) Option
53 Applies-to Doc. No. (Applies-to Doc. No.) Code20
55 Bal. Account No. (Bal. Account No.) Code20
62 Shipping No. (Shipping No.) Code20
63 Posting No. (Posting No.) Code20
64 Last Shipping No. (Last Shipping No.) Code20 Editable: No
65 Last Posting No. (Last Posting No.) Code20 Editable: No
70 VAT Registration No. (VAT Registration No.) Text20
73 Reason Code (Reason Code) Code10
74 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
75 EU 3-Party Trade (EU 3-Party Trade) Boolean
76 Transaction Type (Transaction Type) Code10
77 Transport Method (Transport Method) Code10
78 VAT Country/Region Code (VAT Country/Region Code) Code10
79 Name (Name) Text50
80 Name 2 (Name 2) Text50
81 Address (Address) Text50
82 Address 2 (Address 2) Text50
83 City (City) Text30
84 Contact Name (Contact Name) Text50
85 Bill-to Post Code (Bill-to Post Code) Code20
86 Bill-to County (Bill-to County) Text30
87 Bill-to Country/Region Code (Bill-to Country/Region Code) Code10
88 Post Code (Post Code) Code20
89 County (County) Text30
90 Country/Region Code (Country/Region Code) Code10
91 Ship-to Post Code (Ship-to Post Code) Code20
92 Ship-to County (Ship-to County) Text30
93 Ship-to Country/Region Code (Ship-to Country/Region Code) Code10
94 Bal. Account Type (Bal. Account Type) Option
97 Exit Point (Exit Point) Code10
98 Correction (Correction) Boolean
99 Document Date (Document Date) Date
101 Area (Area) Code10
102 Transaction Specification (Transaction Specification) Code10
104 Payment Method Code (Payment Method Code) Code10
105 Shipping Agent Code (Shipping Agent Code) Code10
107 No. Series (No. Series) Code10 Editable: No
108 Posting No. Series (Posting No. Series) Code10
109 Shipping No. Series (Shipping No. Series) Code10
114 Tax Area Code (Tax Area Code) Code20
115 Tax Liable (Tax Liable) Boolean
116 VAT Bus. Posting Group (VAT Bus. Posting Group) Code10
117 Reserve (Reserve) Option
118 Applies-to ID (Applies-to ID) Code50
119 VAT Base Discount % (VAT Base Discount %) Decimal (0:5)
120 Status (Status) Option
121 Invoice Discount Calculation (Invoice Discount Calculation) Option Editable: No
122 Invoice Discount Value (Invoice Discount Value) Decimal Editable: No
130 Release Status (Release Status) Option Editable: No
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
5052 Contact No. (Contact No.) Code20
5053 Bill-to Contact No. (Bill-to Contact No.) Code20
5700 Responsibility Center (Responsibility Center) Code10
5750 Shipping Advice (Shipping Advice) Option
5752 Completely Shipped (Completely Shipped) Boolean Editable: No
FlowField
5754 Location Filter (Location Filter) Code10 FlowFilter
5792 Shipping Time (Shipping Time) DateFormula
5794 Shipping Agent Service Code (Shipping Agent Service Code) Code10
5796 Date Filter (Date Filter) Date FlowFilter
5902 Description (Description) Text50
5904 Service Order Type (Service Order Type) Code10
5905 Link Service to Service Item (Link Service to Service Item) Boolean
5907 Priority (Priority) Option Editable: No
5911 Allocated Hours (Allocated Hours) Decimal (0:5) Editable: No
FlowField
5915 Phone No. (Phone No.) Text30 [Phone No.]
5916 E-Mail (E-Mail) Text80 [E-Mail]
5917 Phone No. 2 (Phone No. 2) Text30 [Phone No.]
5918 Fax No. (Fax No.) Text30
5921 No. of Unallocated Items (No. of Unallocated Items) Integer Editable: No
FlowField
5923 Order Time (Order Time) Time NotBlank: Yes
5924 Default Response Time (Hours) (Default Response Time (Hours)) Decimal (0:5)
5925 Actual Response Time (Hours) (Actual Response Time (Hours)) Decimal (0:5) Editable: No
5926 Service Time (Hours) (Service Time (Hours)) Decimal (0:5) Editable: No
5927 Response Date (Response Date) Date Editable: No
5928 Response Time (Response Time) Time Editable: No
5929 Starting Date (Starting Date) Date
5930 Starting Time (Starting Time) Time
5931 Finishing Date (Finishing Date) Date
5932 Finishing Time (Finishing Time) Time
5933 Contract Serv. Hours Exist (Contract Serv. Hours Exist) Boolean Editable: No
FlowField
5934 Reallocation Needed (Reallocation Needed) Boolean Editable: No
FlowField
5936 Notify Customer (Notify Customer) Option
5937 Max. Labor Unit Price (Max. Labor Unit Price) Decimal BlankZero: Yes
5938 Warning Status (Warning Status) Option
5939 No. of Allocations (No. of Allocations) Integer Editable: No
FlowField
5940 Contract No. (Contract No.) Code20
5951 Type Filter (Type Filter) Option FlowFilter
5952 Customer Filter (Customer Filter) Code20 FlowFilter
5953 Resource Filter (Resource Filter) Code20 FlowFilter
5954 Contract Filter (Contract Filter) Code20 FlowFilter
5955 Ship-to Fax No. (Ship-to Fax No.) Text30
5956 Ship-to E-Mail (Ship-to E-Mail) Text80 [E-Mail]
5957 Resource Group Filter (Resource Group Filter) Code20 FlowFilter
5958 Ship-to Phone (Ship-to Phone) Text30 [Phone No.]
5959 Ship-to Phone 2 (Ship-to Phone 2) Text30 [Phone No.]
5966 Service Zone Filter (Service Zone Filter) Code10 FlowFilter
5968 Service Zone Code (Service Zone Code) Code10 Editable: No
5981 Expected Finishing Date (Expected Finishing Date) Date
7001 Allow Line Disc. (Allow Line Disc.) Boolean
9000 Assigned User ID (Assigned User ID) Code50
9001 Quote No. (Quote No.) Code20

Keys

# Fields
0 Document Type,No. (Document Type,No.) Clustered: Yes
1 No.,Document Type (No.,Document Type)
2 Customer No.,Order Date (Customer No.,Order Date)
3 Contract No.,Status,Posting Date (Contract No.,Status,Posting Date)
4 Status,Response Date,Response Time,Priority (Status,Response Date,Response Time,Priority)
5 Status,Priority,Response Date,Response Time (Status,Priority,Response Date,Response Time)
6 Document Type,Customer No.,Order Date (Document Type,Customer No.,Order Date) MaintainSQLIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Area (Area) Area Code (Code) 1..n
Bal. Account No. (Bal. Account No.) Bank Account No. (No.) 1..n
Bill-to Contact No. (Bill-to Contact No.) Contact No. (No.) 1..n
Ship-to Country/Region Code (Ship-to Country/Region Code) Country/Region Code (Code) 1..n
Currency Code (Currency Code) Currency Code (Code) 1..n
Customer Filter (Customer Filter) Customer No. (No.) 1..n
Customer Disc. Group (Customer Disc. Group) Customer Discount Group Code (Code) 1..n
Customer Posting Group (Customer Posting Group) Customer Posting Group Code (Code) 1..n
Customer Price Group (Customer Price Group) Customer Price Group Code (Code) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Dimension Value Code (Code) 1..n
Exit Point (Exit Point) Entry/Exit Point Code (Code) 1..n
Bal. Account No. (Bal. Account No.) G/L Account No. (No.) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Language Code (Language Code) Language Code (Code) 1..n
Location Filter (Location Filter) Location Code (Code) 1..n
Shipping No. Series (Shipping No. Series) No. Series Code (Code) 1..n
Payment Method Code (Payment Method Code) Payment Method Code (Code) 1..n
Payment Terms Code (Payment Terms Code) Payment Terms Code (Code) 1..n
Reason Code (Reason Code) Reason 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
Salesperson Code (Salesperson Code) Salesperson/Purchaser Code (Code) 1..n
Contract Filter (Contract Filter) Service Contract Header Contract No. (Contract No.) 1..n
Last Posting No. (Last Posting No.) Service Invoice Header No. (No.) 1..n
Service Order Type (Service Order Type) Service Order Type Code (Code) 1..n
Last Shipping No. (Last Shipping No.) Service Shipment Header No. (No.) 1..n
Service Zone Code (Service Zone Code) Service Zone Code (Code) 1..n
Ship-to Code (Ship-to Code) Ship-to Address Code (Code) 1..n
Shipment Method Code (Shipment Method Code) Shipment Method Code (Code) 1..n
Shipping Agent Code (Shipping Agent Code) Shipping Agent Code (Code) 1..n
Shipping Agent Service Code (Shipping Agent Service Code) Shipping Agent Services Code (Code) 1..n
Tax Area Code (Tax Area Code) Tax Area Code (Code) 1..n
Transaction Specification (Transaction Specification) Transaction Specification Code (Code) 1..n
Transaction Type (Transaction Type) Transaction Type Code (Code) 1..n
Transport Method (Transport Method) Transport Method Code (Code) 1..n
Assigned User ID (Assigned User ID) User Setup User ID (User ID) 1..n
VAT Bus. Posting Group (VAT Bus. Posting Group) VAT Business Posting Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Cash Flow Forecast Entry Source No. (Source No.) 1..n
Service Comment Line No. (No.) 1..n
Service Item Service Order Filter (Service Order Filter) 1..n
Service Item Line Service Order Filter (Service Order Filter) 1..n
Service Item Log Document No. (Document No.) 1..n
Service Line Document No. (Document No.) 1..n
Time Sheet Detail Service Order No. (Service Order No.) 1..n
Time Sheet Detail Archive Service Order No. (Service Order No.) 1..n
Time Sheet Line Service Order No. (Service Order No.) 1..n
Time Sheet Line Archive Service Order No. (Service Order No.) 1..n