Diagrams


Table

Contract Gain/Loss Entry

DynamicsDocs.comContract Gain/Loss Entry«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 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 5966»Contract GroupCode [PK,NN]DescriptionDisc. on Contr. Orders OnlyDate FilterContract Gain/Loss Amount«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«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 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 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email<Contract No.><Contract Group Code><Reason Code><Responsibility Center><Customer No.><Ship-to Code><User ID><Customer No.><Bill-to Customer No.><Ship-to Code><Cancel Reason Code><Reason Code Filter><Contract Group Code><Responsibility Center><Responsibility Center><Bill-to Customer No.><Ship-to Filter><Customer No.>

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

Fields

# Name Type
1 Entry No. Integer
2 Contract No. Code20
3 Contract Group Code Code10
4 Change Date Date
5 Reason Code Code10
6 Type of Change Option
8 Responsibility Center Code10
9 Customer No. Code20
10 Ship-to Code Code10
11 User ID Code50
12 Amount Decimal

Keys

# Fields
0 Entry No. Clustered: Yes
1 Contract No.,Change Date,Reason Code
2 Contract Group Code,Change Date
3 Customer No.,Ship-to Code,Change Date
4 Reason Code,Change Date
5 Responsibility Center,Change Date
6 Responsibility Center,Type of Change,Reason Code

Table Relations To Other Tables

Field Related Table Related Field
Contract Group Code Contract Group Code 1..n
Customer No. Customer No. 1..n
Reason Code Reason Code Code 1..n
Responsibility Center Responsibility Center Code 1..n
Contract No. Service Contract Header Contract No. 1..n
Ship-to Code Ship-to Address Code 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field