Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | No. (No.) | Code20 | NotBlank: Yes | |
2 | Name (Name) | Text50 | ||
3 | Search Name (Search Name) | Code50 | ||
4 | Account Type (Account Type) | Option | [Posting,Heading,Total,Begin-Total,End-Total] | |
6 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
7 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
8 | Account Category (Account Category) | Option | [ ,Assets,Liabilities,Equity,Income,Cost of Goods Sold,Expense] | BlankZero: Yes |
9 | Income/Balance (Income/Balance) | Option | [Income Statement,Balance Sheet] | |
10 | Debit/Credit (Debit/Credit) | Option | [Both,Debit,Credit] | |
11 | No. 2 (No. 2) | Code20 | ||
12 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
13 | Blocked (Blocked) | Boolean | ||
14 | Direct Posting (Direct Posting) | Boolean | InitValue: Yes | |
16 | Reconciliation Account (Reconciliation Account) | Boolean | AccessByPermission: TableData 270=R | |
17 | New Page (New Page) | Boolean | ||
18 | No. of Blank Lines (No. of Blank Lines) | Integer | ||
19 | Indentation (Indentation) | Integer | ||
25 | Last Modified Date Time (Last Modified Date Time) | DateTime | Editable: No | |
26 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
28 | Date Filter (Date Filter) | Date | FlowFilter | |
29 | Global Dimension 1 Filter (Global Dimension 1 Filter) | Code20 | CaptionClass: '1,3,1'
|
FlowFilter |
30 | Global Dimension 2 Filter (Global Dimension 2 Filter) | Code20 | CaptionClass: '1,3,2'
|
FlowFilter |
31 | Balance at Date (Balance at Date) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
32 | Net Change (Net Change) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
33 | Budgeted Amount (Budgeted Amount) | Decimal | AutoFormatType: 1
|
FlowField |
34 | Totaling (Totaling) | Text250 | ||
35 | Budget Filter (Budget Filter) | Code10 |
|
FlowFilter |
36 | Balance (Balance) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
37 | Budget at Date (Budget at Date) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
39 | Consol. Translation Method (Consol. Translation Method) | Option | [Average Rate (Manual),Closing Rate,Historical Rate,Composite Rate,Equity Rate] AccessByPermission: TableData 220=R |
|
40 | Consol. Debit Acc. (Consol. Debit Acc.) | Code20 | AccessByPermission: TableData 220=R | |
41 | Consol. Credit Acc. (Consol. Credit Acc.) | Code20 | AccessByPermission: TableData 220=R | |
42 | Business Unit Filter (Business Unit Filter) | Code20 |
|
FlowFilter |
43 | Gen. Posting Type (Gen. Posting Type) | Option | [ ,Purchase,Sale] | |
44 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code20 |
|
|
45 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code20 |
|
|
46 | Picture (Picture) | BLOB [Bitmap] | ||
47 | Debit Amount (Debit Amount) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
48 | Credit Amount (Credit Amount) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
49 | Automatic Ext. Texts (Automatic Ext. Texts) | Boolean | ||
52 | Budgeted Debit Amount (Budgeted Debit Amount) | Decimal | AutoFormatType: 1
|
BlankNumbers: BlankNegAndZero FlowField |
53 | Budgeted Credit Amount (Budgeted Credit Amount) | Decimal | AutoFormatType: 1
|
BlankNumbers: BlankNegAndZero FlowField |
54 | Tax Area Code (Tax Area Code) | Code20 |
|
|
55 | Tax Liable (Tax Liable) | Boolean | ||
56 | Tax Group Code (Tax Group Code) | Code20 |
|
|
57 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code20 |
|
|
58 | VAT Prod. Posting Group (VAT Prod. Posting Group) | Code20 |
|
|
60 | Additional-Currency Net Change (Additional-Currency Net Change) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode
|
Editable: No FlowField |
61 | Add.-Currency Balance at Date (Add.-Currency Balance at Date) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode
|
Editable: No FlowField |
62 | Additional-Currency Balance (Additional-Currency Balance) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode
|
Editable: No FlowField |
63 | Exchange Rate Adjustment (Exchange Rate Adjustment) | Option | [No Adjustment,Adjust Amount,Adjust Additional-Currency Amount] AccessByPermission: TableData 4=R |
|
64 | Add.-Currency Debit Amount (Add.-Currency Debit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode
|
Editable: No FlowField |
65 | Add.-Currency Credit Amount (Add.-Currency Credit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode
|
Editable: No FlowField |
66 | Default IC Partner G/L Acc. No (Default IC Partner G/L Acc. No) | Code20 |
|
|
70 | Omit Default Descr. in Jnl. (Omit Default Descr. in Jnl.) | Boolean | ||
80 | Account Subcategory Entry No. (Account Subcategory Entry No.) | Integer |
|
|
81 | Account Subcategory Descript. (Account Subcategory Descript.) | Text80 |
|
Editable: No FlowField |
400 | Dimension Set ID Filter (Dimension Set ID Filter) | Integer | FlowFilter | |
1100 | Cost Type No. (Cost Type No.) | Code20 |
|
Editable: No |
1700 | Default Deferral Template Code (Default Deferral Template Code) | Code10 |
|
|
8000 | Id (Id) | GUID |
Keys
# | Fields | ||
---|---|---|---|
0 | No. (No.) | Clustered: Yes | |
1 | Search Name (Search Name) | ||
2 | Reconciliation Account (Reconciliation Account) | ||
3 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | ||
4 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | ||
5 | Consol. Debit Acc.,Consol. Translation Method (Consol. Debit Acc.,Consol. Translation Method) | ||
6 | Consol. Credit Acc.,Consol. Translation Method (Consol. Credit Acc.,Consol. Translation Method) | ||
7 | Name (Name) | ||
8 | Account Type (Account Type) | ||
9 | Account Category (Account Category) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Business Unit Filter (Business Unit Filter) | Business Unit | Code (Code) |
|
1..n |
Default Deferral Template Code (Default Deferral Template Code) | Deferral Template | Deferral Code (Deferral Code) |
|
1..n |
Global Dimension 2 Filter (Global Dimension 2 Filter) | Dimension Value | Code (Code) |
|
1..n |
Account Subcategory Entry No. (Account Subcategory Entry No.) | G/L Account Category | Entry No. (Entry No.) |
|
1..n |
Budget Filter (Budget Filter) | G/L Budget Name | Name (Name) |
|
1..n |
Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Gen. Business Posting Group | Code (Code) |
|
1..n |
Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
Default IC Partner G/L Acc. No (Default IC Partner G/L Acc. No) | IC G/L Account | No. (No.) |
|
1..n |
Tax Area Code (Tax Area Code) | Tax Area | Code (Code) |
|
1..n |
Tax Group Code (Tax Group Code) | Tax Group | Code (Code) |
|
1..n |
VAT Bus. Posting Group (VAT Bus. Posting Group) | VAT Business Posting Group | Code (Code) |
|
1..n |
VAT Prod. Posting Group (VAT Prod. Posting Group) | VAT Product Posting Group | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Analysis View Budget Entry | G/L Account No. (G/L Account No.) |
|
1..n |
Analysis View Entry | Account No. (Account No.) |
|
1..n |
Applied Payment Entry | Account No. (Account No.) |
|
1..n |
Bank Acc. Reconciliation Line | Account No. (Account No.) |
|
1..n |
Bank Account Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Bank Account Posting Group | G/L Bank Account No. (G/L Bank Account No.) |
|
1..n |
Budget Buffer | G/L Account No. (G/L Account No.) |
|
1..n |
Business Unit | Minority Exch. Rate Losses Acc (Minority Exch. Rate Losses Acc) |
|
1..n |
Business Unit Information | Minority Exch. Rate Losses Acc (Minority Exch. Rate Losses Acc) |
|
1..n |
CV Ledger Entry Buffer | Bal. Account No. (Bal. Account No.) |
|
1..n |
Cash Flow Forecast Entry | Source No. (Source No.) |
|
1..n |
Cash Flow Setup | Tax Bal. Account No. (Tax Bal. Account No.) |
|
1..n |
Check Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Close Income Statement Buffer | G/L Account No. (G/L Account No.) |
|
1..n |
Comment Line | No. (No.) |
|
1..n |
Cost Entry | G/L Account (G/L Account) |
|
1..n |
Currency | Conv. LCY Rndg. Credit Acc. (Conv. LCY Rndg. Credit Acc.) |
|
1..n |
Cust. Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Customer Posting Group | Add. Fee per Line Account (Add. Fee per Line Account) |
|
1..n |
Default Dimension | No. (No.) |
|
1..n |
Deferral Post. Buffer | G/L Account (G/L Account) |
|
1..n |
Deferral Template | Deferral Account (Deferral Account) |
|
1..n |
Dimension Selection Buffer | New Dimension Value Code (New Dimension Value Code) |
|
1..n |
Employee Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Employee Posting Group | Payables Account (Payables Account) |
|
1..n |
Extended Text Header | No. (No.) |
|
1..n |
Extended Text Line | No. (No.) |
|
1..n |
FA Allocation | Account No. (Account No.) |
|
1..n |
FA G/L Posting Buffer | Account No. (Account No.) |
|
1..n |
FA Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
FA Posting Group | Book Val. Acc. on Disp. (Loss) (Book Val. Acc. on Disp. (Loss)) |
|
1..n |
Finance Charge Memo Line | No. (No.) |
|
1..n |
G/L Account (Analysis View) | No. (No.) |
|
1..n |
G/L Budget Entry | G/L Account No. (G/L Account No.) |
|
1..n |
G/L Entry | Account Id (Account Id) |
|
1..n |
Gen. Jnl. Allocation | Account No. (Account No.) |
|
1..n |
Gen. Journal Batch | Bal. Account No. (Bal. Account No.) |
|
1..n |
Gen. Journal Line | Account Id (Account Id) |
|
1..n |
Gen. Journal Template | Bal. Account No. (Bal. Account No.) |
|
1..n |
General Posting Setup | Purchase Variance Account (Purchase Variance Account) |
|
1..n |
IC G/L Account | Map-to G/L Acc. No. (Map-to G/L Acc. No.) |
|
1..n |
IC Partner | Payables Account (Payables Account) |
|
1..n |
Import G/L Transaction | G/L Account (G/L Account) |
|
1..n |
Inventory Posting Setup | Subcontracted Variance Account (Subcontracted Variance Account) |
|
1..n |
Invoice Post. Buffer | G/L Account (G/L Account) |
|
1..n |
Invt. Post to G/L Test Buffer | Account No. (Account No.) |
|
1..n |
Issued Fin. Charge Memo Line | No. (No.) |
|
1..n |
Issued Reminder Line | No. (No.) |
|
1..n |
Job G/L Account Price | G/L Account No. (G/L Account No.) |
|
1..n |
Job Journal Line | No. (No.) |
|
1..n |
Job Ledger Entry | No. (No.) |
|
1..n |
Job Planning Line | No. (No.) |
|
1..n |
Job Posting Group | G/L Costs Applied Account (G/L Costs Applied Account) |
|
1..n |
Job WIP Buffer | Bal. G/L Account No. (Bal. G/L Account No.) |
|
1..n |
Job WIP Entry | G/L Bal. Account No. (G/L Bal. Account No.) |
|
1..n |
Job WIP G/L Entry | G/L Bal. Account No. (G/L Bal. Account No.) |
|
1..n |
Maintenance Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
My Account | Account No. (Account No.) |
|
1..n |
Payment Application Proposal | Account No. (Account No.) |
|
1..n |
Payment Method | Bal. Account No. (Bal. Account No.) |
|
1..n |
Payment Registration Buffer | Bal. Account No. (Bal. Account No.) |
|
1..n |
Payment Registration Setup | Bal. Account No. (Bal. Account No.) |
|
1..n |
Posted Deferral Header | Deferral Account (Deferral Account) |
|
1..n |
Posted Deferral Line | Deferral Account (Deferral Account) |
|
1..n |
Posted Payment Recon. Line | Account No. (Account No.) |
|
1..n |
Prepayment Inv. Line Buffer | G/L Account No. (G/L Account No.) |
|
1..n |
Purch. Cr. Memo Hdr. | Bal. Account No. (Bal. Account No.) |
|
1..n |
Purch. Cr. Memo Line | No. (No.) |
|
1..n |
Purch. Inv. Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Purch. Inv. Line | No. (No.) |
|
1..n |
Purch. Rcpt. Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Purch. Rcpt. Line | No. (No.) |
|
1..n |
Purchase Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Purchase Header Archive | Bal. Account No. (Bal. Account No.) |
|
1..n |
Purchase Line Archive | No. (No.) |
|
1..n |
Purchases & Payables Setup | Credit Acc. for Non-Item Lines (Credit Acc. for Non-Item Lines) |
|
1..n |
Reconcile CV Acc Buffer | G/L Account No. (G/L Account No.) |
|
1..n |
Reminder Line | No. (No.) |
|
1..n |
Requisition Line | No. (No.) |
|
1..n |
Return Receipt Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Return Receipt Line | No. (No.) |
|
1..n |
Return Shipment Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Return Shipment Line | No. (No.) |
|
1..n |
Reversal Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales & Receivables Setup | Freight G/L Acc. No. (Freight G/L Acc. No.) |
|
1..n |
Sales Cr.Memo Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales Cr.Memo Line | No. (No.) |
|
1..n |
Sales Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales Header Archive | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales Invoice Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales Invoice Line | No. (No.) |
|
1..n |
Sales Line Archive | No. (No.) |
|
1..n |
Sales Shipment Buffer | No. (No.) |
|
1..n |
Sales Shipment Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales Shipment Line | No. (No.) |
|
1..n |
Serv. Price Adjustment Detail | No. (No.) |
|
1..n |
Service Contract Account Group | Prepaid Contract Acc. (Prepaid Contract Acc.) |
|
1..n |
Service Cost | Account No. (Account No.) |
|
1..n |
Service Cr.Memo Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Service Cr.Memo Line | No. (No.) |
|
1..n |
Service Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Service Invoice Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Service Invoice Line | No. (No.) |
|
1..n |
Service Ledger Entry | No. (No.) |
|
1..n |
Service Line | No. (No.) |
|
1..n |
Service Shipment Buffer | No. (No.) |
|
1..n |
Service Shipment Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Service Shipment Line | No. (No.) |
|
1..n |
Standard General Journal Line | Bal. Account No. (Bal. Account No.) |
|
1..n |
Standard Purchase Line | No. (No.) |
|
1..n |
Standard Sales Line | No. (No.) |
|
1..n |
Standard Service Line | No. (No.) |
|
1..n |
Tax Jurisdiction | Unreal. Rev. Charge (Purch.) (Unreal. Rev. Charge (Purch.)) |
|
1..n |
Tax Setup | Unreal. Rev. Charge (Purch.) (Unreal. Rev. Charge (Purch.)) |
|
1..n |
Text-to-Account Mapping | Bal. Source No. (Bal. Source No.) |
|
1..n |
Trial Balance Entity Buffer | Account Id (Account Id) |
|
1..n |
VAT Posting Setup | Reverse Chrg. VAT Unreal. Acc. (Reverse Chrg. VAT Unreal. Acc.) |
|
1..n |
VAT Setup Posting Groups | Reverse Chrg. VAT Acc. (Reverse Chrg. VAT Acc.) |
|
1..n |
Vendor Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Vendor Posting Group | Payment Tolerance Credit Acc. (Payment Tolerance Credit Acc.) |
|
1..n |