Diagrams

Table

Standard Purchase Line

DynamicsDocs.comStandard Purchase Line«Table 174»Standard Purchase LineStandard Purchase Code [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.DescriptionQuantityAmount Excl. VATUnit of Measure CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVariant CodeDimension Set ID«Table 173»Standard Purchase CodeCode [PK,NN]DescriptionCurrency Code«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 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«Table 5800»Item ChargeNo. [PK,NN]DescriptionGen. Prod. Posting GroupTax Group CodeVAT Prod. Posting GroupSearch DescriptionGlobal Dimension 1 CodeGlobal Dimension 2 Code«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Standard Purchase Code><No.><No.><No.><No.><No.><No.><Unit of Measure Code><Unit of Measure Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Variant Code><Dimension Set ID><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Global Dimension 1 Code><Global Dimension 2 Code><Base Unit of Measure><Unit of Measure Filter><Global Dimension 1 Code><Global Dimension 2 Code><Component of Main Asset><Global Dimension 1 Code><Global Dimension 2 Code><Code><Dimension Value Code>

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

Fields

# Name Type
1 Standard Purchase Code (Standard Purchase Code) Code10 Editable: No
2 Line No. (Line No.) Integer Editable: No
3 Type (Type) Option
4 No. (No.) Code20
5 Description (Description) Text50
6 Quantity (Quantity) Decimal (0:5) BlankZero: Yes
7 Amount Excl. VAT (Amount Excl. VAT) Decimal BlankZero: Yes
8 Unit of Measure Code (Unit of Measure Code) Code10
9 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
10 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
11 Variant Code (Variant Code) Code10
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Standard Purchase Code,Line No. (Standard Purchase Code,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Dimension Value Code (Code) 1..n
No. (No.) Fixed Asset No. (No.) 1..n
No. (No.) G/L Account No. (No.) 1..n
No. (No.) Item No. (No.) 1..n
No. (No.) Item Charge No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
No. (No.) Resource No. (No.) 1..n
Standard Purchase Code (Standard Purchase Code) Standard Purchase Code Code (Code) 1..n
No. (No.) Standard Text Code (Code) 1..n
Unit of Measure Code (Unit of Measure Code) Unit of Measure Code (Code) 1..n

Table Relations From Other Tables

From Table From Field