Diagrams


Table

IC Inbox Sales Header

DynamicsDocs.comIC Inbox Sales Header«Table 434»IC Inbox Sales HeaderDocument Type; [,Order,Invoice,Credit...Sell-to Customer No.No.Bill-to Customer No.Ship-to NameShip-to AddressShip-to Address 2Ship-to CityPosting DateDue DatePayment Discount %Pmt. Discount DateCurrency CodePrices Including VATShip-to Post CodeDocument DateExternal Document No.IC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Requested Delivery DatePromised Delivery Date«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 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 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,E-...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCY<Sell-to Customer No.><Bill-to Customer No.><Currency Code><IC Partner Code><Currency Code><Currency Filter><Customer Filter><Bill-to Customer No.><IC Partner Code><Customer No.><Currency Code>

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

Fields

# Name Type
1 Document Type Option Editable: No
2 Sell-to Customer No. Code20 Editable: No
3 No. Code20 Editable: No
4 Bill-to Customer No. Code20 Editable: No
13 Ship-to Name Text50 Editable: No
15 Ship-to Address Text50 Editable: No
16 Ship-to Address 2 Text50 Editable: No
17 Ship-to City Text30 Editable: No
20 Posting Date Date
24 Due Date Date
25 Payment Discount % Decimal Editable: No
26 Pmt. Discount Date Date Editable: No
32 Currency Code Code10 Editable: No
35 Prices Including VAT Boolean
91 Ship-to Post Code Code20 Editable: No
99 Document Date Date
100 External Document No. Code35
125 IC Partner Code Code20 Editable: No
201 IC Transaction No. Integer Editable: No
202 Transaction Source Option Editable: No
5790 Requested Delivery Date Date Editable: No
5791 Promised Delivery Date Date Editable: No

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Bill-to Customer No. Customer No. 1..n
IC Partner Code IC Partner Code 1..n

Table Relations From Other Tables

From Table From Field