Diagrams

Table

Item Cross Reference

DynamicsDocs.comItem Cross Reference«Table 5717»Item Cross ReferenceItem No. [PK]Variant Code [PK]Unit of Measure [PK]Cross-Reference Type; [,Customer,Vendo...Cross-Reference Type No. [PK]Cross-Reference No. [PK,NN]DescriptionDiscontinue Bar Code«Table 427»IC Outbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Shipment No.Shipment Line No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Delivery DatePromised Delivery DateReturn Receipt No.Return Receipt Line No.«Table 429»IC Outbox Purchase LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Receipt DatePromised Receipt Date«Table 431»Handled IC Outbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Shipment No.Shipment Line No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Delivery DatePromised Delivery DateReturn Receipt No.Return Receipt Line No.«Table 433»Handled IC Outbox Purch. LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Receipt DatePromised Receipt Date«Table 435»IC Inbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Item Ref.; [Local Item No.,Cross Refer...Unit of Measure CodeRequested Delivery DatePromised Delivery Date«Table 437»IC Inbox Purchase LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Receipt No.Receipt Line No.Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Item Ref.; [Local Item No.,Cross Refer...Unit of Measure CodeRequested Receipt DatePromised Receipt DateReturn Shipment No.Return Shipment Line No.«Table 439»Handled IC Inbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Item Ref.; [Local Item No.,Cross Refer...Unit of Measure CodeRequested Delivery DatePromised Delivery Date«Table 441»Handled IC Inbox Purch. LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Receipt No.Receipt Line No.Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Unit of Measure CodeRequested Receipt DatePromised Receipt DateReturn Shipment No.Return Shipment Line No.«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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...<Item No.><Variant Code><Unit of Measure><Cross-Reference Type No.><Cross-Reference Type No.><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><Vendor No.><Alternative Item No.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Bill-to Customer No.><Pay-to Vendor No.>

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

Fields

# Name Type
1 Item No. (Item No.) Code20
2 Variant Code (Variant Code) Code10
3 Unit of Measure (Unit of Measure) Code10
4 Cross-Reference Type (Cross-Reference Type) Option
5 Cross-Reference Type No. (Cross-Reference Type No.) Code30
6 Cross-Reference No. (Cross-Reference No.) Code20 NotBlank: Yes
7 Description (Description) Text50
8 Discontinue Bar Code (Discontinue Bar Code) Boolean

Keys

# Fields
0 Item No.,Variant Code,Unit of Measure,Cross-Reference Type,Cross-Reference Type No.,Cross-Reference No. (Item No.,Variant Code,Unit of Measure,Cross-Reference Type,Cross-Reference Type No.,Cross-Reference No.) Clustered: Yes
1 Cross-Reference No. (Cross-Reference No.)
2 Cross-Reference No.,Cross-Reference Type,Cross-Reference Type No.,Discontinue Bar Code (Cross-Reference No.,Cross-Reference Type,Cross-Reference Type No.,Discontinue Bar Code)
3 Cross-Reference Type,Cross-Reference No. (Cross-Reference Type,Cross-Reference No.)
4 Item No.,Variant Code,Unit of Measure,Cross-Reference Type,Cross-Reference No.,Discontinue Bar Code (Item No.,Variant Code,Unit of Measure,Cross-Reference Type,Cross-Reference No.,Discontinue Bar Code)
5 Cross-Reference Type,Cross-Reference Type No. (Cross-Reference Type,Cross-Reference Type No.)

Table Relations To Other Tables

Field Related Table Related Field
Cross-Reference Type No. (Cross-Reference Type No.) Customer No. (No.) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Unit of Measure (Unit of Measure) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Cross-Reference Type No. (Cross-Reference Type No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Handled IC Inbox Purch. Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Inbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Outbox Purch. Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Outbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
IC Inbox Purchase Line IC Partner Reference (IC Partner Reference) 1..n
IC Inbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
IC Outbox Purchase Line IC Partner Reference (IC Partner Reference) 1..n
IC Outbox Sales Line IC Partner Reference (IC Partner Reference) 1..n