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