Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Code (Code) | Code20 | NotBlank: Yes | |
2 | Name (Name) | Text50 | ||
3 | Currency Code (Currency Code) | Code10 |
|
|
4 | Inbox Type (Inbox Type) | Option | [File Location,Database,Email,No IC Transfer] | |
5 | Inbox Details (Inbox Details) | Text250 |
|
|
6 | Receivables Account (Receivables Account) | Code20 |
|
|
7 | Payables Account (Payables Account) | Code20 |
|
|
10 | Blocked (Blocked) | Boolean | ||
11 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
12 | Customer No. (Customer No.) | Code20 |
|
|
13 | Vendor No. (Vendor No.) | Code20 |
|
|
14 | Outbound Sales Item No. Type (Outbound Sales Item No. Type) | Option | [Internal No.,Common Item No.,Cross Reference] | |
15 | Outbound Purch. Item No. Type (Outbound Purch. Item No. Type) | Option | [Internal No.,Common Item No.,Cross Reference,Vendor Item No.] | |
16 | Cost Distribution in LCY (Cost Distribution in LCY) | Boolean |
Keys
# | Fields | ||
---|---|---|---|
0 | Code (Code) | Clustered: Yes |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Inbox Details (Inbox Details) | Company | Name (Name) |
|
1..n |
Currency Code (Currency Code) | Currency | Code (Code) |
|
1..n |
Customer No. (Customer No.) | Customer | No. (No.) |
|
1..n |
Payables Account (Payables Account) | G/L Account | No. (No.) |
|
1..n |
Vendor No. (Vendor No.) | Vendor | No. (No.) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Applied Payment Entry | Account No. (Account No.) |
|
1..n |
Bank Acc. Reconciliation Line | Account No. (Account No.) |
|
1..n |
Comment Line | No. (No.) |
|
1..n |
Cust. Ledger Entry | IC Partner Code (IC Partner Code) |
|
1..n |
Customer | IC Partner Code (IC Partner Code) |
|
1..n |
Default Dimension | No. (No.) |
|
1..n |
G/L Entry | IC Partner Code (IC Partner Code) |
|
1..n |
Gen. Journal Line | IC Partner Code (IC Partner Code) |
|
1..n |
Handled IC Inbox Jnl. Line | Account No. (Account No.) |
|
1..n |
Handled IC Inbox Purch. Header | IC Partner Code (IC Partner Code) |
|
1..n |
Handled IC Inbox Purch. Line | IC Partner Code (IC Partner Code) |
|
1..n |
Handled IC Inbox Sales Header | IC Partner Code (IC Partner Code) |
|
1..n |
Handled IC Inbox Sales Line | IC Partner Code (IC Partner Code) |
|
1..n |
Handled IC Inbox Trans. | IC Partner Code (IC Partner Code) |
|
1..n |
Handled IC Outbox Jnl. Line | Account No. (Account No.) |
|
1..n |
Handled IC Outbox Purch. Hdr | IC Partner Code (IC Partner Code) |
|
1..n |
Handled IC Outbox Purch. Line | IC Partner Code (IC Partner Code) |
|
1..n |
Handled IC Outbox Sales Header | IC Partner Code (IC Partner Code) |
|
1..n |
Handled IC Outbox Sales Line | IC Partner Code (IC Partner Code) |
|
1..n |
Handled IC Outbox Trans. | IC Partner Code (IC Partner Code) |
|
1..n |
IC Comment Line | IC Partner Code (IC Partner Code) |
|
1..n |
IC Document Dimension | IC Partner Code (IC Partner Code) |
|
1..n |
IC Inbox Jnl. Line | Account No. (Account No.) |
|
1..n |
IC Inbox Purchase Header | IC Partner Code (IC Partner Code) |
|
1..n |
IC Inbox Purchase Line | IC Partner Code (IC Partner Code) |
|
1..n |
IC Inbox Sales Header | IC Partner Code (IC Partner Code) |
|
1..n |
IC Inbox Sales Line | IC Partner Code (IC Partner Code) |
|
1..n |
IC Inbox Transaction | IC Partner Code (IC Partner Code) |
|
1..n |
IC Inbox/Outbox Jnl. Line Dim. | IC Partner Code (IC Partner Code) |
|
1..n |
IC Outbox Jnl. Line | Account No. (Account No.) |
|
1..n |
IC Outbox Purchase Header | IC Partner Code (IC Partner Code) |
|
1..n |
IC Outbox Purchase Line | IC Partner Code (IC Partner Code) |
|
1..n |
IC Outbox Sales Header | IC Partner Code (IC Partner Code) |
|
1..n |
IC Outbox Sales Line | IC Partner Code (IC Partner Code) |
|
1..n |
IC Outbox Transaction | IC Partner Code (IC Partner Code) |
|
1..n |
Payment Application Proposal | Account No. (Account No.) |
|
1..n |
Posted Payment Recon. Line | Account No. (Account No.) |
|
1..n |
Purch. Cr. Memo Line | IC Partner Code (IC Partner Code) |
|
1..n |
Purch. Inv. Line | IC Partner Code (IC Partner Code) |
|
1..n |
Purchase Header | Pay-to IC Partner Code (Pay-to IC Partner Code) |
|
1..n |
Purchase Header Archive | Pay-to IC Partner Code (Pay-to IC Partner Code) |
|
1..n |
Purchase Line | IC Partner Code (IC Partner Code) |
|
1..n |
Purchase Line Archive | IC Partner Code (IC Partner Code) |
|
1..n |
Sales Cr.Memo Line | IC Partner Code (IC Partner Code) |
|
1..n |
Sales Header | Bill-to IC Partner Code (Bill-to IC Partner Code) |
|
1..n |
Sales Header Archive | Bill-to IC Partner Code (Bill-to IC Partner Code) |
|
1..n |
Sales Invoice Line | IC Partner Code (IC Partner Code) |
|
1..n |
Sales Line | IC Partner Code (IC Partner Code) |
|
1..n |
Sales Line Archive | IC Partner Code (IC Partner Code) |
|
1..n |
Standard General Journal Line | IC Partner Code (IC Partner Code) |
|
1..n |
Vendor | IC Partner Code (IC Partner Code) |
|
1..n |
Vendor Ledger Entry | IC Partner Code (IC Partner Code) |
|
1..n |