Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Dimension Set ID | Integer | ||
| 2 | Dimension Code | Code20 |
|
NotBlank: Yes |
| 3 | Dimension Value Code | Code20 |
|
NotBlank: Yes |
| 4 | Dimension Value ID | Integer | ||
| 5 | Dimension Name | Text30 |
|
Editable: No FlowField |
| 6 | Dimension Value Name | Text50 |
|
Editable: No FlowField |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Dimension Set ID,Dimension Code | Clustered: Yes | |
| 1 | Dimension Value ID |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Dimension Code | Dimension | Code |
|
1..n |
| Dimension Value Code | Dimension Value | Code |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Assembly Header | Dimension Set ID |
|
1..n |
| Assembly Line | Dimension Set ID |
|
1..n |
| Bank Acc. Reconciliation | Dimension Set ID |
|
1..n |
| Bank Acc. Reconciliation Line | Dimension Set ID |
|
1..n |
| Bank Account Ledger Entry | Dimension Set ID |
|
1..n |
| CV Ledger Entry Buffer | Dimension Set ID |
|
1..n |
| Capacity Ledger Entry | Dimension Set ID |
|
1..n |
| Cash Flow Forecast Entry | Dimension Set ID |
|
1..n |
| Cash Flow Worksheet Line | Dimension Set ID |
|
1..n |
| Cust. Ledger Entry | Dimension Set ID |
|
1..n |
| Deferral Post. Buffer | Dimension Set ID |
|
1..n |
| FA Allocation | Dimension Set ID |
|
1..n |
| FA G/L Posting Buffer | Dimension Set ID |
|
1..n |
| FA Journal Line | Dimension Set ID |
|
1..n |
| FA Ledger Entry | Dimension Set ID |
|
1..n |
| Filed Service Contract Header | Dimension Set ID |
|
1..n |
| Finance Charge Memo Header | Dimension Set ID |
|
1..n |
| G/L Budget Entry | Dimension Set ID |
|
1..n |
| G/L Entry | Dimension Set ID |
|
1..n |
| Gen. Jnl. Allocation | Dimension Set ID |
|
1..n |
| Gen. Journal Line | Dimension Set ID |
|
1..n |
| Ins. Coverage Ledger Entry | Dimension Set ID |
|
1..n |
| Insurance Journal Line | Dimension Set ID |
|
1..n |
| Invoice Post. Buffer | Dimension Set ID |
|
1..n |
| Invt. Post to G/L Test Buffer | Dimension Set ID |
|
1..n |
| Invt. Posting Buffer | Dimension Set ID |
|
1..n |
| Issued Fin. Charge Memo Header | Dimension Set ID |
|
1..n |
| Issued Reminder Header | Dimension Set ID |
|
1..n |
| Item Budget Buffer | Dimension Set ID |
|
1..n |
| Item Budget Entry | Dimension Set ID |
|
1..n |
| Item Journal Line | New Dimension Set ID |
|
1..n |
| Item Ledger Entry | Dimension Set ID |
|
1..n |
| Job Journal Line | Dimension Set ID |
|
1..n |
| Job Ledger Entry | Dimension Set ID |
|
1..n |
| Job Posting Buffer | Dimension Set ID |
|
1..n |
| Job WIP Entry | Dimension Set ID |
|
1..n |
| Job WIP G/L Entry | Dimension Set ID |
|
1..n |
| Maintenance Ledger Entry | Dimension Set ID |
|
1..n |
| Payment Buffer | Dimension Set ID |
|
1..n |
| Phys. Inventory Ledger Entry | Dimension Set ID |
|
1..n |
| Planning Component | Dimension Set ID |
|
1..n |
| Posted Assembly Header | Dimension Set ID |
|
1..n |
| Posted Assembly Line | Dimension Set ID |
|
1..n |
| Prepayment Inv. Line Buffer | Dimension Set ID |
|
1..n |
| Prod. Order Component | Dimension Set ID |
|
1..n |
| Prod. Order Line | Dimension Set ID |
|
1..n |
| Production Order | Dimension Set ID |
|
1..n |
| Purch. Cr. Memo Hdr. | Dimension Set ID |
|
1..n |
| Purch. Cr. Memo Line | Dimension Set ID |
|
1..n |
| Purch. Inv. Header | Dimension Set ID |
|
1..n |
| Purch. Inv. Line | Dimension Set ID |
|
1..n |
| Purch. Rcpt. Header | Dimension Set ID |
|
1..n |
| Purch. Rcpt. Line | Dimension Set ID |
|
1..n |
| Purchase Header | Dimension Set ID |
|
1..n |
| Purchase Header Archive | Dimension Set ID |
|
1..n |
| Purchase Line | Dimension Set ID |
|
1..n |
| Purchase Line Archive | Dimension Set ID |
|
1..n |
| Reminder Header | Dimension Set ID |
|
1..n |
| Requisition Line | Dimension Set ID |
|
1..n |
| Res. Journal Line | Dimension Set ID |
|
1..n |
| Res. Ledger Entry | Dimension Set ID |
|
1..n |
| Return Receipt Header | Dimension Set ID |
|
1..n |
| Return Receipt Line | Dimension Set ID |
|
1..n |
| Return Shipment Header | Dimension Set ID |
|
1..n |
| Return Shipment Line | Dimension Set ID |
|
1..n |
| Sales Cr.Memo Header | Dimension Set ID |
|
1..n |
| Sales Cr.Memo Line | Dimension Set ID |
|
1..n |
| Sales Header | Dimension Set ID |
|
1..n |
| Sales Header Archive | Dimension Set ID |
|
1..n |
| Sales Invoice Header | Dimension Set ID |
|
1..n |
| Sales Invoice Line | Dimension Set ID |
|
1..n |
| Sales Line | Dimension Set ID |
|
1..n |
| Sales Line Archive | Dimension Set ID |
|
1..n |
| Sales Shipment Header | Dimension Set ID |
|
1..n |
| Sales Shipment Line | Dimension Set ID |
|
1..n |
| Service Contract Header | Dimension Set ID |
|
1..n |
| Service Cr.Memo Header | Dimension Set ID |
|
1..n |
| Service Cr.Memo Line | Dimension Set ID |
|
1..n |
| Service Header | Dimension Set ID |
|
1..n |
| Service Invoice Header | Dimension Set ID |
|
1..n |
| Service Invoice Line | Dimension Set ID |
|
1..n |
| Service Item Line | Dimension Set ID |
|
1..n |
| Service Ledger Entry | Dimension Set ID |
|
1..n |
| Service Line | Dimension Set ID |
|
1..n |
| Service Order Posting Buffer | Dimension Set ID |
|
1..n |
| Service Shipment Header | Dimension Set ID |
|
1..n |
| Service Shipment Item Line | Dimension Set ID |
|
1..n |
| Service Shipment Line | Dimension Set ID |
|
1..n |
| Standard General Journal Line | Dimension Set ID |
|
1..n |
| Standard Item Journal Line | Dimension Set ID |
|
1..n |
| Standard Purchase Line | Dimension Set ID |
|
1..n |
| Standard Sales Line | Dimension Set ID |
|
1..n |
| Standard Service Line | Dimension Set ID |
|
1..n |
| Transfer Header | Dimension Set ID |
|
1..n |
| Transfer Line | Dimension Set ID |
|
1..n |
| Transfer Receipt Header | Dimension Set ID |
|
1..n |
| Transfer Receipt Line | Dimension Set ID |
|
1..n |
| Transfer Shipment Header | Dimension Set ID |
|
1..n |
| Transfer Shipment Line | Dimension Set ID |
|
1..n |
| Value Entry | Dimension Set ID |
|
1..n |
| Vendor Ledger Entry | Dimension Set ID |
|
1..n |
| Warranty Ledger Entry | Dimension Set ID |
|
1..n |