Diagrams

Table

Contract/Service Discount

DynamicsDocs.comContract/Service Discount«Table 5972»Contract/Service DiscountContract Type; [Quote,Contract,Templat...Contract No. [PK]Type; [Service Item Group,Resource Gro...No. [PK]Starting Date [PK]Discount %«Table 5968»Service Contract TemplateNo. [PK]DescriptionInvoice Period; [Month,Two Months,Quar...Max. Labor Unit PriceCombine InvoicesPrepaidService Zone CodeLanguage CodeDefault Response Time [Hours]Contract Lines on InvoiceDefault Service PeriodInvoice after ServiceAllow Unbalanced AmountsContract Group CodeService Order TypeAutomatic Credit MemosNo. SeriesPrice Update PeriodPrice Inv. Increase CodeServ. Contract Acc. Gr. Code«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 5904»Service Item GroupCode [PK,NN]DescriptionCreate Service ItemDefault Contract Discount %Default Serv. Price Group CodeDefault Response Time [Hours]«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 5905»Service CostCode [PK,NN]DescriptionAccount No.Default Unit PriceDefault QuantityUnit of Measure CodeCost Type; [Travel,Support,Other]Service Zone CodeDefault Unit Cost<Contract No.><Contract No.><No.><No.><No.>

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

Fields

# Name Type
1 Contract Type (Contract Type) Option
2 Contract No. (Contract No.) Code20
4 Type (Type) Option
5 No. (No.) Code20
6 Starting Date (Starting Date) Date
7 Discount % (Discount %) Decimal (0:5)

Keys

# Fields
0 Contract Type,Contract No.,Type,No.,Starting Date (Contract Type,Contract No.,Type,No.,Starting Date) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
No. (No.) Resource Group No. (No.) 1..n
Contract No. (Contract No.) Service Contract Header Contract No. (Contract No.) 1..n
Contract No. (Contract No.) Service Contract Template No. (No.) 1..n
No. (No.) Service Cost Code (Code) 1..n
No. (No.) Service Item Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field