Diagrams

Table

IC Partner

DynamicsDocs.comIC Partner«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«Table 1293»Payment Application ProposalBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountAppliedApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...Pmt. Disc. Due DateRemaining Pmt. Disc. PossiblePmt. Disc. Tolerance DateApplied Amt. Incl. DiscountRemaining AmountRemaining Amt. Incl. DiscountType; [Bank Account Ledger Entry,Check...Sorting OrderStmt To Rem. Amount Difference«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 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 414»IC Outbox TransactionTransaction No. [PK]IC Partner Code [PK]Source Type; [Journal Line,Sales Docum...Document Type; [,Payment,Invoice,Credi...Document No.Posting DateTransaction Source; [Rejected by Curre...Document DateLine Action; [No Action,Send to IC Par...IC Partner G/L Acc. No.Source Line No.«Table 416»Handled IC Outbox Trans.Transaction No. [PK]IC Partner Code [PK]Source Type; [Journal,Sales Document,P...Document Type; [,Payment,Invoice,Credi...Document No.Posting DateTransaction Source; [Rejected by Curre...Document DateStatus; [Sent to IC Partner,Rejection...IC Partner G/L Acc. No.Source Line No.«Table 418»IC Inbox TransactionTransaction No. [PK]IC Partner Code [PK]Source Type; [Journal,Sales Document,P...Document Type; [,Payment,Invoice,Credi...Document No.Posting DateTransaction Source; [Returned by Partn...Document DateLine Action; [No Action,Accept,Return...Original Document No.IC Partner G/L Acc. No.Source Line No.«Table 420»Handled IC Inbox Trans.Transaction No. [PK]IC Partner Code [PK]Source Type; [Journal,Sales Document,P...Document Type; [,Payment,Invoice,Credi...Document No.Posting DateTransaction Source; [Returned by Partn...Document DateStatus; [Accepted,Posted,,Returned to...IC Partner G/L Acc. No.Source Line No.«Table 442»IC Document DimensionTable ID [PK,NN]Transaction No. [PK]IC Partner Code [PK]Transaction Source; [Rejected by Curre...Line No. [PK]Dimension Code [PK,NN]Dimension Value Code [NN]«Table 2000000006»CompanyName [PK]Evaluation Company«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc....<Inbox Details><Receivables Account><Payables Account><Customer No.><IC Partner Code><Vendor No.><IC Partner Code><Account No.><IC Partner Code><IC Partner Code><IC Partner Code><IC Partner Code><IC Partner Code><Account No.><Account No.><Account No.><Bill-to Customer No.><Pay-to Vendor No.>

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

Fields

# Name Type
1 Code Code20 NotBlank: Yes
2 Name Text50
3 Currency Code Code10
4 Inbox Type Option
5 Inbox Details Text250
6 Receivables Account Code20
7 Payables Account Code20
10 Blocked Boolean
11 Comment Boolean Editable: No
FlowField
12 Customer No. Code20
13 Vendor No. Code20
14 Outbound Sales Item No. Type Option
15 Outbound Purch. Item No. Type Option
16 Cost Distribution in LCY Boolean

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Inbox Details Company Name 1..n
Currency Code Currency Code 1..n
Customer No. Customer No. 1..n
Payables Account G/L Account No. 1..n
Vendor No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Applied Payment Entry Account No. 1..n
Bank Acc. Reconciliation Line Account No. 1..n
Comment Line No. 1..n
Cust. Ledger Entry IC Partner Code 1..n
Customer IC Partner Code 1..n
Default Dimension No. 1..n
G/L Entry IC Partner Code 1..n
Gen. Journal Line IC Partner Code 1..n
Handled IC Inbox Jnl. Line Account No. 1..n
Handled IC Inbox Purch. Header IC Partner Code 1..n
Handled IC Inbox Purch. Line IC Partner Code 1..n
Handled IC Inbox Sales Header IC Partner Code 1..n
Handled IC Inbox Sales Line IC Partner Code 1..n
Handled IC Inbox Trans. IC Partner Code 1..n
Handled IC Outbox Jnl. Line Account No. 1..n
Handled IC Outbox Purch. Hdr IC Partner Code 1..n
Handled IC Outbox Purch. Line IC Partner Code 1..n
Handled IC Outbox Sales Header IC Partner Code 1..n
Handled IC Outbox Sales Line IC Partner Code 1..n
Handled IC Outbox Trans. IC Partner Code 1..n
IC Comment Line IC Partner Code 1..n
IC Document Dimension IC Partner Code 1..n
IC Inbox Jnl. Line Account No. 1..n
IC Inbox Purchase Header IC Partner Code 1..n
IC Inbox Purchase Line IC Partner Code 1..n
IC Inbox Sales Header IC Partner Code 1..n
IC Inbox Sales Line IC Partner Code 1..n
IC Inbox Transaction IC Partner Code 1..n
IC Inbox/Outbox Jnl. Line Dim. IC Partner Code 1..n
IC Outbox Jnl. Line Account No. 1..n
IC Outbox Purchase Header IC Partner Code 1..n
IC Outbox Purchase Line IC Partner Code 1..n
IC Outbox Sales Header IC Partner Code 1..n
IC Outbox Sales Line IC Partner Code 1..n
IC Outbox Transaction IC Partner Code 1..n
Payment Application Proposal Account No. 1..n
Posted Payment Recon. Line Account No. 1..n
Purch. Cr. Memo Line IC Partner Code 1..n
Purch. Inv. Line IC Partner Code 1..n
Purchase Header Pay-to IC Partner Code 1..n
Purchase Header Archive Pay-to IC Partner Code 1..n
Purchase Line IC Partner Code 1..n
Purchase Line Archive IC Partner Code 1..n
Sales Cr.Memo Line IC Partner Code 1..n
Sales Header Bill-to IC Partner Code 1..n
Sales Header Archive Bill-to IC Partner Code 1..n
Sales Invoice Line IC Partner Code 1..n
Sales Line IC Partner Code 1..n
Sales Line Archive IC Partner Code 1..n
Standard General Journal Line IC Partner Code 1..n
Vendor IC Partner Code 1..n
Vendor Ledger Entry IC Partner Code 1..n