Diagrams


Table

Contract Group

DynamicsDocs.comContract Group«Table 5966»Contract GroupCode [PK,NN]DescriptionDisc. on Contr. Orders OnlyDate FilterContract Gain/Loss Amount«Table 5907»Service Ledger EntryEntry No. [PK]Service Contract No.Document Type; [,Payment,Invoice,Credi...Document No.Serv. Contract Acc. Gr. CodeDocument Line No.Moved from Prepaid Acc.Posting DateAmount [LCY]Customer No.Ship-to CodeItem No. [Serviced]Serial No. [Serviced]User IDContract Invoice PeriodGlobal Dimension 1 CodeGlobal Dimension 2 CodeService Item No. [Serviced]Variant Code [Serviced]Contract Group CodeType; [,Resource,Item,Service Cost,Ser...No.Cost AmountDiscount AmountUnit CostQuantityCharged Qty.Unit PriceDiscount %Contract Disc. AmountBill-to Customer No....«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 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 5969»Contract Gain/Loss EntryEntry No. [PK]Contract No.Contract Group CodeChange DateReason CodeType of Change; [Line Added,Line Delet...Responsibility CenterCustomer No.Ship-to CodeUser IDAmount«Table 5970»Filed Service Contract HeaderContract No.Contract Type; [Quote,Contract]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...<Contract Group Code><Contract Group Code><Contract Group Code><Contract Group Code><Contract Group Code><Service Contract No.><No.><Contract No.><Contract No. Relation>

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

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Description Text50
3 Disc. on Contr. Orders Only Boolean
4 Date Filter Date FlowFilter
5 Contract Gain/Loss Amount Decimal Editable: No
FlowField

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Contract Gain/Loss Entry Contract Group Code 1..n
Filed Service Contract Header Contract Group Code 1..n
Service Contract Header Contract Group Code 1..n
Service Contract Template Contract Group Code 1..n
Service Ledger Entry Contract Group Code 1..n