Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Code (Code) | Code10 | NotBlank: Yes | |
2 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
3 | Last Date Adjusted (Last Date Adjusted) | Date | Editable: No | |
6 | Unrealized Gains Acc. (Unrealized Gains Acc.) | Code20 |
|
|
7 | Realized Gains Acc. (Realized Gains Acc.) | Code20 |
|
|
8 | Unrealized Losses Acc. (Unrealized Losses Acc.) | Code20 |
|
|
9 | Realized Losses Acc. (Realized Losses Acc.) | Code20 |
|
|
10 | Invoice Rounding Precision (Invoice Rounding Precision) | Decimal | InitValue: 0.01 AutoFormatType: 1 AutoFormatExpr: Code |
|
12 | Invoice Rounding Type (Invoice Rounding Type) | Option | [Nearest,Up,Down] | |
13 | Amount Rounding Precision (Amount Rounding Precision) | Decimal (2:5) | InitValue: 0.01 | |
14 | Unit-Amount Rounding Precision (Unit-Amount Rounding Precision) | Decimal (0:9) | InitValue: 1.0E-5 | |
15 | Description (Description) | Text30 | ||
17 | Amount Decimal Places (Amount Decimal Places) | Text5 | InitValue: 2:2 | NotBlank: Yes |
18 | Unit-Amount Decimal Places (Unit-Amount Decimal Places) | Text5 | InitValue: 2:5 | NotBlank: Yes |
19 | Customer Filter (Customer Filter) | Code20 |
|
FlowFilter |
20 | Vendor Filter (Vendor Filter) | Code20 |
|
FlowFilter |
21 | Global Dimension 1 Filter (Global Dimension 1 Filter) | Code20 | CaptionClass: '1,3,1'
|
FlowFilter |
22 | Global Dimension 2 Filter (Global Dimension 2 Filter) | Code20 | CaptionClass: '1,3,2'
|
FlowFilter |
23 | Date Filter (Date Filter) | Date | FlowFilter | |
24 | Cust. Ledg. Entries in Filter (Cust. Ledg. Entries in Filter) | Boolean |
|
Editable: No FlowField |
25 | Customer Balance (Customer Balance) | Decimal | AutoFormatType: 1 AutoFormatExpr: Code
|
Editable: No FlowField |
26 | Customer Outstanding Orders (Customer Outstanding Orders) | Decimal | AutoFormatType: 1 AutoFormatExpr: Code AccessByPermission: TableData 110=R
|
Editable: No FlowField |
27 | Customer Shipped Not Invoiced (Customer Shipped Not Invoiced) | Decimal | AutoFormatType: 1 AutoFormatExpr: Code AccessByPermission: TableData 110=R
|
Editable: No FlowField |
28 | Customer Balance Due (Customer Balance Due) | Decimal | AutoFormatType: 1 AutoFormatExpr: Code
|
Editable: No FlowField |
29 | Vendor Ledg. Entries in Filter (Vendor Ledg. Entries in Filter) | Boolean |
|
Editable: No FlowField |
30 | Vendor Balance (Vendor Balance) | Decimal | AutoFormatType: 1 AutoFormatExpr: Code
|
Editable: No FlowField |
31 | Vendor Outstanding Orders (Vendor Outstanding Orders) | Decimal | AutoFormatType: 1 AutoFormatExpr: Code AccessByPermission: TableData 120=R
|
Editable: No FlowField |
32 | Vendor Amt. Rcd. Not Invoiced (Vendor Amt. Rcd. Not Invoiced) | Decimal | AutoFormatType: 1 AutoFormatExpr: Code AccessByPermission: TableData 120=R
|
Editable: No FlowField |
33 | Vendor Balance Due (Vendor Balance Due) | Decimal | AutoFormatType: 1 AutoFormatExpr: Code
|
Editable: No FlowField |
34 | Customer Balance (LCY) (Customer Balance (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
35 | Vendor Balance (LCY) (Vendor Balance (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
40 | Realized G/L Gains Account (Realized G/L Gains Account) | Code20 |
|
|
41 | Realized G/L Losses Account (Realized G/L Losses Account) | Code20 |
|
|
44 | Appln. Rounding Precision (Appln. Rounding Precision) | Decimal | AutoFormatType: 1 AutoFormatExpr: Code |
|
45 | EMU Currency (EMU Currency) | Boolean | ||
46 | Currency Factor (Currency Factor) | Decimal (0:5) | Editable: No | |
47 | Residual Gains Account (Residual Gains Account) | Code20 |
|
|
48 | Residual Losses Account (Residual Losses Account) | Code20 |
|
|
50 | Conv. LCY Rndg. Debit Acc. (Conv. LCY Rndg. Debit Acc.) | Code20 |
|
|
51 | Conv. LCY Rndg. Credit Acc. (Conv. LCY Rndg. Credit Acc.) | Code20 |
|
|
52 | Max. VAT Difference Allowed (Max. VAT Difference Allowed) | Decimal | AutoFormatType: 1 AutoFormatExpr: Code |
|
53 | VAT Rounding Type (VAT Rounding Type) | Option | [Nearest,Up,Down] | |
54 | Payment Tolerance % (Payment Tolerance %) | Decimal (0:5) | MaxValue: 100 | Editable: No |
55 | Max. Payment Tolerance Amount (Max. Payment Tolerance Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: Code |
Editable: No |
56 | Symbol (Symbol) | Text10 |
Keys
# | Fields | ||
---|---|---|---|
0 | Code (Code) | Clustered: Yes |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Customer Filter (Customer Filter) | Customer | No. (No.) |
|
1..n |
Global Dimension 2 Filter (Global Dimension 2 Filter) | Dimension Value | Code (Code) |
|
1..n |
Conv. LCY Rndg. Credit Acc. (Conv. LCY Rndg. Credit Acc.) | G/L Account | No. (No.) |
|
1..n |
Vendor Filter (Vendor Filter) | Vendor | No. (No.) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Additional Fee Setup | Currency Code (Currency Code) |
|
1..n |
Adjust Exchange Rate Buffer | Currency Code (Currency Code) |
|
1..n |
Applied Payment Entry | Currency Code (Currency Code) |
|
1..n |
Approval Entry | Currency Code (Currency Code) |
|
1..n |
Bank Account | Currency Code (Currency Code) |
|
1..n |
Bank Account Ledger Entry | Currency Code (Currency Code) |
|
1..n |
Business Unit | Currency Code (Currency Code) |
|
1..n |
CV Ledger Entry Buffer | Closed by Currency Code (Closed by Currency Code) |
|
1..n |
Contact | Currency Code (Currency Code) |
|
1..n |
Credit Transfer Entry | Currency Code (Currency Code) |
|
1..n |
Currency Amount | Currency Code (Currency Code) |
|
1..n |
Currency Exchange Rate | Relational Currency Code (Relational Currency Code) |
|
1..n |
Currency Total Buffer | Currency Code (Currency Code) |
|
1..1 |
Currency for Fin. Charge Terms | Currency Code (Currency Code) |
|
1..n |
Currency for Reminder Level | Currency Code (Currency Code) |
|
1..n |
Cust. Invoice Disc. | Currency Code (Currency Code) |
|
1..n |
Cust. Ledger Entry | Closed by Currency Code (Closed by Currency Code) |
|
1..n |
Customer | Currency Filter (Currency Filter) |
|
1..n |
Customer Bank Account | Currency Code (Currency Code) |
|
1..n |
Customer Template | Currency Code (Currency Code) |
|
1..n |
Deferral Header | Currency Code (Currency Code) |
|
1..n |
Deferral Header Archive | Currency Code (Currency Code) |
|
1..n |
Detailed CV Ledg. Entry Buffer | Currency Code (Currency Code) |
|
1..n |
Detailed Cust. Ledg. Entry | Currency Code (Currency Code) |
|
1..n |
Detailed Vendor Ledg. Entry | Currency Code (Currency Code) |
|
1..n |
Direct Debit Collection Entry | Applies-to Entry Currency Code (Applies-to Entry Currency Code) |
|
1..n |
Exch. Rate Adjmt. Reg. | Currency Code (Currency Code) |
|
1..n |
Filed Service Contract Header | Currency Code (Currency Code) |
|
1..n |
Finance Charge Memo Header | Currency Code (Currency Code) |
|
1..n |
Gen. Journal Line | Source Currency Code (Source Currency Code) |
|
1..n |
General Ledger Setup | Additional Reporting Currency (Additional Reporting Currency) |
|
1..n |
Handled IC Inbox Purch. Header | Currency Code (Currency Code) |
|
1..n |
Handled IC Inbox Purch. Line | Currency Code (Currency Code) |
|
1..n |
Handled IC Inbox Sales Header | Currency Code (Currency Code) |
|
1..n |
Handled IC Inbox Sales Line | Currency Code (Currency Code) |
|
1..n |
Handled IC Outbox Purch. Hdr | Currency Code (Currency Code) |
|
1..n |
Handled IC Outbox Purch. Line | Currency Code (Currency Code) |
|
1..n |
Handled IC Outbox Sales Header | Currency Code (Currency Code) |
|
1..n |
Handled IC Outbox Sales Line | Currency Code (Currency Code) |
|
1..n |
IC Inbox Purchase Header | Currency Code (Currency Code) |
|
1..n |
IC Inbox Purchase Line | Currency Code (Currency Code) |
|
1..n |
IC Inbox Sales Header | Currency Code (Currency Code) |
|
1..n |
IC Inbox Sales Line | Currency Code (Currency Code) |
|
1..n |
IC Outbox Purchase Header | Currency Code (Currency Code) |
|
1..n |
IC Outbox Purchase Line | Currency Code (Currency Code) |
|
1..n |
IC Outbox Sales Header | Currency Code (Currency Code) |
|
1..n |
IC Outbox Sales Line | Currency Code (Currency Code) |
|
1..n |
IC Partner | Currency Code (Currency Code) |
|
1..n |
Invt. Post to G/L Test Buffer | Source Currency Code (Source Currency Code) |
|
1..n |
Issued Fin. Charge Memo Header | Currency Code (Currency Code) |
|
1..n |
Issued Reminder Header | Currency Code (Currency Code) |
|
1..n |
Item Journal Line | Source Currency Code (Source Currency Code) |
|
1..n |
Job | Invoice Currency Code (Invoice Currency Code) |
|
1..n |
Job G/L Account Price | Currency Code (Currency Code) |
|
1..n |
Job Item Price | Currency Code (Currency Code) |
|
1..n |
Job Journal Line | Currency Code (Currency Code) |
|
1..n |
Job Ledger Entry | Currency Code (Currency Code) |
|
1..n |
Job Planning Line | Currency Code (Currency Code) |
|
1..n |
Job Resource Price | Currency Code (Currency Code) |
|
1..n |
Mini Customer Template | Currency Code (Currency Code) |
|
1..n |
Mini Vendor Template | Currency Code (Currency Code) |
|
1..n |
O365 Sales Document | Currency Code (Currency Code) |
|
1..n |
Payable Vendor Ledger Entry | Currency Code (Currency Code) |
|
1..n |
Payment Application Proposal | Currency Code (Currency Code) |
|
1..n |
Payment Buffer | Currency Code (Currency Code) |
|
1..n |
Payment Export Data | Currency Code (Currency Code) |
|
1..n |
Positive Pay Entry Detail | Currency Code (Currency Code) |
|
1..n |
Posted Approval Entry | Currency Code (Currency Code) |
|
1..n |
Posted Deferral Header | Currency Code (Currency Code) |
|
1..n |
Purch. Cr. Memo Hdr. | Currency Code (Currency Code) |
|
1..n |
Purch. Inv. Header | Currency Code (Currency Code) |
|
1..n |
Purch. Rcpt. Header | Currency Code (Currency Code) |
|
1..n |
Purchase Header | Currency Code (Currency Code) |
|
1..n |
Purchase Header Archive | Currency Code (Currency Code) |
|
1..n |
Purchase Line | Currency Code (Currency Code) |
|
1..n |
Purchase Line Archive | Currency Code (Currency Code) |
|
1..n |
Purchase Line Discount | Currency Code (Currency Code) |
|
1..n |
Purchase Price | Currency Code (Currency Code) |
|
1..n |
Reconcile CV Acc Buffer | Currency code (Currency code) |
|
1..n |
Reminder Header | Currency Code (Currency Code) |
|
1..n |
Requisition Line | Currency Code (Currency Code) |
|
1..n |
Resource Price | Currency Code (Currency Code) |
|
1..n |
Resource Price Change | Currency Code (Currency Code) |
|
1..n |
Return Receipt Header | Currency Code (Currency Code) |
|
1..n |
Return Shipment Header | Currency Code (Currency Code) |
|
1..n |
Reversal Entry | Currency Code (Currency Code) |
|
1..n |
Sales Cr.Memo Header | Currency Code (Currency Code) |
|
1..n |
Sales Header | Currency Code (Currency Code) |
|
1..n |
Sales Header Archive | Currency Code (Currency Code) |
|
1..n |
Sales Invoice Header | Currency Code (Currency Code) |
|
1..n |
Sales Line | Currency Code (Currency Code) |
|
1..n |
Sales Line Archive | Currency Code (Currency Code) |
|
1..n |
Sales Line Discount | Currency Code (Currency Code) |
|
1..n |
Sales Price | Currency Code (Currency Code) |
|
1..n |
Sales Price Worksheet | Currency Code (Currency Code) |
|
1..n |
Sales Price and Line Disc Buff | Currency Code (Currency Code) |
|
1..n |
Sales Shipment Header | Currency Code (Currency Code) |
|
1..n |
Serv. Price Group Setup | Currency Code (Currency Code) |
|
1..n |
Service Contract Header | Currency Code (Currency Code) |
|
1..n |
Service Cr.Memo Header | Currency Code (Currency Code) |
|
1..n |
Service Header | Currency Code (Currency Code) |
|
1..n |
Service Invoice Header | Currency Code (Currency Code) |
|
1..n |
Service Line | Currency Code (Currency Code) |
|
1..n |
Service Shipment Header | Currency Code (Currency Code) |
|
1..n |
Service Shipment Line | Currency Code (Currency Code) |
|
1..n |
Standard General Journal Line | Currency Code (Currency Code) |
|
1..n |
Standard Purchase Code | Currency Code (Currency Code) |
|
1..n |
Standard Sales Code | Currency Code (Currency Code) |
|
1..n |
Standard Service Code | Currency Code (Currency Code) |
|
1..n |
Vendor | Currency Filter (Currency Filter) |
|
1..n |
Vendor Bank Account | Currency Code (Currency Code) |
|
1..n |
Vendor Invoice Disc. | Currency Code (Currency Code) |
|
1..n |
Vendor Ledger Entry | Closed by Currency Code (Closed by Currency Code) |
|
1..n |