Diagrams


Table

Extended Text Header

DynamicsDocs.comExtended Text Header«Table 279»Extended Text HeaderTable Name; [Standard Text,G/L Account...No. [PK]Language Code [PK]Text No. [PK]Starting DateEnding DateAll Language CodesDescriptionSales QuoteSales InvoiceSales OrderSales Credit MemoPurchase QuotePurchase InvoicePurchase OrderPurchase Credit MemoReminderFinance Charge MemoSales Blanket OrderPurchase Blanket OrderPrepmt. Sales InvoicePrepmt. Sales Credit MemoPrepmt. Purchase InvoicePrepmt. Purchase Credit MemoService OrderService QuoteService InvoiceService Credit MemoSales Return OrderPurchase Return Order«Table 7»Standard TextCode [PK,NN]Description«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....«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 8»LanguageCode [PK,NN]NameWindows Language IDWindows Language Name<No.><No.><No.><No.><Language Code><Alternative Item No.>

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

Fields

# Name Type
1 Table Name Option
2 No. Code20
3 Language Code Code10
4 Text No. Integer Editable: No
5 Starting Date Date
6 Ending Date Date
7 All Language Codes Boolean
8 Description Text30
11 Sales Quote Boolean
12 Sales Invoice Boolean
13 Sales Order Boolean
14 Sales Credit Memo Boolean
15 Purchase Quote Boolean
16 Purchase Invoice Boolean
17 Purchase Order Boolean
18 Purchase Credit Memo Boolean
19 Reminder Boolean
20 Finance Charge Memo Boolean
21 Sales Blanket Order Boolean
22 Purchase Blanket Order Boolean
23 Prepmt. Sales Invoice Boolean
24 Prepmt. Sales Credit Memo Boolean
25 Prepmt. Purchase Invoice Boolean
26 Prepmt. Purchase Credit Memo Boolean
5900 Service Order Boolean
5901 Service Quote Boolean
5902 Service Invoice Boolean
5903 Service Credit Memo Boolean
6600 Sales Return Order Boolean
6605 Purchase Return Order Boolean

Keys

# Fields
0 Table Name,No.,Language Code,Text No. Clustered: Yes
1 Table Name,No.,Language Code,All Language Codes,Starting Date,Ending Date

Table Relations To Other Tables

Field Related Table Related Field
No. G/L Account No. 1..n
No. Item No. 1..n
Language Code Language Code 1..n
No. Resource No. 1..n
No. Standard Text Code 1..n

Table Relations From Other Tables

From Table From Field