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


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


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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field