Diagrams


Table

Extended Text Line

DynamicsDocs.comExtended Text Line«Table 280»Extended Text LineTable Name; [Standard Text,G/L Account...No. [PK]Language Code [PK]Text No. [PK]Line No. [PK]Text«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 Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit 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 (Table Name) Option
2 No. (No.) Code20
3 Language Code (Language Code) Code10
4 Text No. (Text No.) Integer
5 Line No. (Line No.) Integer
6 Text (Text) Text50

Keys

# Fields
0 Table Name,No.,Language Code,Text No.,Line No. (Table Name,No.,Language Code,Text No.,Line No.) Clustered: Yes

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