Diagrams


Table

Service Contract Account Group

DynamicsDocs.comService Contract Account Group«Table 5973»Service Contract Account GroupCode [PK]DescriptionNon-Prepaid Contract Acc.Prepaid Contract Acc.«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 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...«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....<Non-Prepaid Contract Acc.><Prepaid Contract Acc.><Serv. Contract Acc. Gr. Code><Serv. Contract Acc. Gr. Code><Serv. Contract Acc. Gr. Code><Serv. Contract Acc. Gr. Code><Service Contract No.><No.><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
2 Description Text50
3 Non-Prepaid Contract Acc. Code20
4 Prepaid Contract Acc. Code20

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Prepaid Contract Acc. G/L Account No. 1..n

Table Relations From Other Tables

From Table From Field
Filed Service Contract Header Serv. Contract Acc. Gr. Code 1..n
Service Contract Header Serv. Contract Acc. Gr. Code 1..n
Service Contract Template Serv. Contract Acc. Gr. Code 1..n
Service Ledger Entry Serv. Contract Acc. Gr. Code 1..n