Diagrams

Table

Handled IC Inbox Sales Line

DynamicsDocs.comHandled IC Inbox Sales Line«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 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«Table 7»Standard TextCode [PK,NN]Description«Table 410»IC G/L AccountNo. [PK,NN]NameAccount Type; [Posting,Heading,Total,B...Income/Balance; [Income Statement,Bala...BlockedMap-to G/L Acc. No.Indentation«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 5800»Item ChargeNo. [PK,NN]DescriptionGen. Prod. Posting GroupTax Group CodeVAT Prod. Posting GroupSearch DescriptionGlobal Dimension 1 CodeGlobal Dimension 2 Code«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 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,Em...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCY<Currency Code><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Code><Currency Code><Alternative Item No.><Item No.>

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

Fields

# Name Type
1 Document Type (Document Type) Option Editable: No
3 Document No. (Document No.) Code20 Editable: No
4 Line No. (Line No.) Integer Editable: No
11 Description (Description) Text50 Editable: No
15 Quantity (Quantity) Decimal (0:5) Editable: No
22 Unit Price (Unit Price) Decimal Editable: No
27 Line Discount % (Line Discount %) Decimal (0:5)
28 Line Discount Amount (Line Discount Amount) Decimal Editable: No
30 Amount Including VAT (Amount Including VAT) Decimal Editable: No
45 Job No. (Job No.) Code20 Editable: No
73 Drop Shipment (Drop Shipment) Boolean Editable: No
91 Currency Code (Currency Code) Code10 Editable: No
99 VAT Base Amount (VAT Base Amount) Decimal Editable: No
103 Line Amount (Line Amount) Decimal Editable: No
107 IC Partner Ref. Type (IC Partner Ref. Type) Option Editable: No
108 IC Partner Reference (IC Partner Reference) Code20 Editable: No
125 IC Partner Code (IC Partner Code) Code20 Editable: No
126 IC Transaction No. (IC Transaction No.) Integer Editable: No
127 Transaction Source (Transaction Source) Option Editable: No
128 Item Ref. (Item Ref.) Option Editable: No
5407 Unit of Measure Code (Unit of Measure Code) Code10 Editable: No
5790 Requested Delivery Date (Requested Delivery Date) Date Editable: No
5791 Promised Delivery Date (Promised Delivery Date) Date Editable: No

Keys

# Fields
0 IC Transaction No.,IC Partner Code,Transaction Source,Line No. (IC Transaction No.,IC Partner Code,Transaction Source,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Currency Code (Currency Code) Currency Code (Code) 1..n
IC Partner Reference (IC Partner Reference) IC G/L Account No. (No.) 1..n
IC Partner Code (IC Partner Code) IC Partner Code (Code) 1..n
IC Partner Reference (IC Partner Reference) Item No. (No.) 1..n
IC Partner Reference (IC Partner Reference) Item Charge No. (No.) 1..n
IC Partner Reference (IC Partner Reference) Item Cross Reference Item No. (Item No.) 1..n
IC Partner Reference (IC Partner Reference) Standard Text Code (Code) 1..n

Table Relations From Other Tables

From Table From Field