Handled IC Outbox Sales Header

DynamicsDocs.comHandled IC Outbox Sales Header«Table 430»Handled IC Outbox 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 VATOrder No.Ship-to Post CodeDocument DateExternal Document No.IC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...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,Em...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


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


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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field