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 |