Diagrams


Table

IC Inbox Purchase Header

DynamicsDocs.comIC Inbox Purchase Header«Table 436»IC Inbox Purchase 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 Option Editable: No
2 Buy-from Vendor No. Code20 Editable: No
3 No. Code20 Editable: No
4 Pay-to Vendor No. Code20 Editable: No
11 Your Reference Text35
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
21 Expected Receipt Date Date Editable: No
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
66 Vendor Order No. Code35
68 Vendor Invoice No. Code35 Editable: No
69 Vendor Cr. Memo No. Code35 Editable: No
72 Sell-to Customer No. Code20 Editable: No
91 Ship-to Post Code Code20 Editable: No
99 Document Date Date
125 IC Partner Code Code20 Editable: No
201 IC Transaction No. Integer Editable: No
202 Transaction Source Option Editable: No
5790 Requested Receipt Date Date Editable: No
5791 Promised Receipt 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
IC Partner Code IC Partner Code 1..n
Pay-to Vendor No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field