Diagrams


Table

Handled IC Inbox Purch. Header

DynamicsDocs.comHandled IC Inbox Purch. Header«Table 440»Handled IC Inbox Purch. HeaderDocument Type; [,Order,Invoice,Credit...Buy-from Vendor No.No.Pay-to Vendor No.Your ReferenceShip-to NameShip-to AddressShip-to Address 2Ship-to CityPosting DateExpected Receipt DateDue DatePayment Discount %Pmt. Discount DateCurrency CodePrices Including VATVendor Order No.Vendor Invoice No.Vendor Cr. Memo No.Sell-to Customer No.Ship-to Post CodeDocument DateIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Requested Receipt DatePromised Receipt Date«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...«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<Buy-from Vendor No.><Pay-to Vendor No.><Currency Code><IC Partner Code><Currency Code><Currency Filter><Vendor Filter><Pay-to Vendor No.><IC Partner Code><Vendor 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 (Document Type) Option Editable: No
2 Buy-from Vendor No. (Buy-from Vendor No.) Code20 Editable: No
3 No. (No.) Code20 Editable: No
4 Pay-to Vendor No. (Pay-to Vendor No.) Code20 Editable: No
11 Your Reference (Your Reference) Text35
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
21 Expected Receipt Date (Expected Receipt 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
66 Vendor Order No. (Vendor Order No.) Code35
68 Vendor Invoice No. (Vendor Invoice No.) Code35 Editable: No
69 Vendor Cr. Memo No. (Vendor Cr. Memo No.) Code35 Editable: No
72 Sell-to Customer No. (Sell-to Customer No.) Code20 Editable: No
91 Ship-to Post Code (Ship-to Post Code) Code20 Editable: No
99 Document Date (Document Date) Date Editable: No
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 Receipt Date (Requested Receipt Date) Date Editable: No
5791 Promised Receipt Date (Promised Receipt Date) Date Editable: No

Keys

# 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
IC Partner Code (IC Partner Code) IC Partner Code (Code) 1..n
Pay-to Vendor No. (Pay-to Vendor No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field