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 EmailExchange IdentifierApplication ID<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


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


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

Table Relations To Other Tables

Field Related Table Related Field
Contract Group Code (Contract Group Code) Contract Group Code (Code) 1..n
Customer No. (Customer No.) Customer No. (No.) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 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
Ship-to Code (Ship-to Code) Ship-to Address Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field