The Fenwick Gold Finance semantic model is organized in a star schema data model.
The Fact tables contain information about individual transactions from sources such as G/L Entries and Vendor Ledger Entries. Dimension tables provide additional context and attributes to the transactional data such as G/L Account, G/L Account Categories and Vendor details.
Fact Tables
Fact tables store transactional data and support summarizations such as SUM, AVG, COUNT and more.
- G/L Entries
- G/L Budget Entries
- Vendor Ledger Entries
- Customer Ledger Entries
G/L Entries
| Field Name | Description |
|---|---|
| Closing Entry | Specifies if the G/L Entry is a closing income statement entry. |
| Description | Specifies a description of the entry. |
| Entry No. | Specifies the number of the entry. |
| Posting Date | Specifies the date the entry was posted. |
| Source Code | Specifies the source code that specifies where the entry was created. |
| Source No. | Specifies the number of the source that the entry originates from. |
| Source Type | Specifies the source type that applies to the source number that is shown in the Source No. field. |
G/L Budget Entries
| Field Name | Description |
|---|---|
| Budget Date | Specifies the date of the budget entry. |
| Budget Name | Specifies the budget name. |
| Entry No. | Specifies the number of the budget entry. |
Vendor Ledger Entries
The Vendor Ledger Entries table is a composite table made up of data from the Vendor Ledger, Detailed Vendor Ledger, and Purchase Invoice Header tables. Where applicable we’ve prepended the field names with table identifiers such as VLE, DVLE and PIH.
| Field Name | Description |
|---|---|
| Applied Vendor Ledger Entry No. | Specifies the entry no. of the Vendor Ledger Entry that the Detailed Vendor Ledger Entry was applied to. |
| DVLE Document Date | Specifies the Detailed Vendor Ledger Entry Document Date. |
| DVLE Entry No. | Specifies the Detailed Vendor Ledger Entry number. |
| DVLE Initial Entry Due Date | Specifies the date on which the initial entry is due for payment. |
| DVLE Posting Date | Specifies the posting date of the Detailed Vendor Ledger Entry. |
| Entry Type | Specifies the entry type of the Detailed Vendor Ledger Entry. |
| VLE Document Date | Specifies the Vendor Ledger Entry Document Date. |
| VLE Due Date | Specifies the due date on the entry. |
| VLE Entry No. | Specifies the Vendor Ledger Entry number. |
| VLE Open | Specifies whether the amount on the entry has been fully paid or there is still a remaining amount that must be applied to. |
| VLE Posting Date | Specifies the Vendor Ledger Entry posting date. |
| Document No. | Specifies the Vendor Ledger Entry document number. |
| Document Type | Specifies the document type that the Vendor Ledger Entry belongs to. |
| Payment Discount Date | Specifies the date on which the amount in the entry must be paid for a payment discount to be granted. |
| Payment Terms Code | Specifies the code to use to find the payment terms that apply to the purchase header. |
| PIH Document No. | Specifies the Posted Purchase Invoice number. |
Customer Ledger Entries
The Customer Ledger Entries table is a composite table made up of data from the Customer Ledger, Detailed Customer Ledger, and Sales Invoice Header tables. Where applicable we’ve prepended the field names with table identifiers such as CLE, DCLE and SIH.
| Field Name | Description |
|---|---|
| Applied Customer Ledger Entry No. | Specifies the entry no. of the Customer Ledger Entry that the Detailed Vendor Ledger Entry was applied to. |
| DCLE Document Date | Specifies the Detailed Customer Ledger Entry Document Date. |
| DCLE Entry No. | Specifies the Detailed Customer Ledger Entry number. |
| DCLE Initial Entry Due Date | Specifies the date on which the initial entry is due for payment. |
| DCLE Posting Date | Specifies the posting date of the Detailed Customer Ledger Entry. |
| Entry Type | Specifies the entry type of the Detailed Customer Ledger Entry. |
| CLE Document Date | Specifies the Customer Ledger Entry Document Date. |
| CLE Due Date | Specifies the due date on the entry. |
| CLE Entry No. | Specifies the Customer Ledger Entry number. |
| CLE Open | Specifies whether the amount on the entry has been fully paid or there is still a remaining amount that must be applied to. |
| CLE Posting Date | Specifies the posting date of the Customer Vendor Ledger Entry. |
| Document No. | Specifies the Customer Ledger Entry document number. |
| Document Type | Specifies the document type that the Customer Ledger Entry belongs to. |
| Payment Discount Date | Specifies the date on which the amount in the entry must be paid for a payment discount to be granted. |
| Payment Terms Code | Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount. |
| SIH Document No. | Specifies the Posted Sales Invoice number. |
Dimension Tables
- Customers
- Date
- Dimension Sets
- G/L Account
- G/L Account Categories
- Vendors
- Aging Bucket Period
- Aging Date Parameter
G/L Account
| Field Name | Description |
|---|---|
| Account Type | Specifies the purpose of the account. Types include Total, Begin-Total, End-Total, or Posting. |
| G/L Account Name | Specifies the name of the general ledger account. |
| G/L Account No. | Specifies the number of the general ledger account. |
| G/L Account No./Name | A concatenated name/number identifier of the general ledger account. |
| Income/Balance | Specifies whether a general ledger account is an income statement account or a balance sheet account. |
| Parent G/L Account No. | The parent account in the hierarchy of accounts in the chart of accounts. |
| G/L Account Hierarchy | A five level hierarchy of general ledger accounts. |
G/L Account Categories
| Field Name | Description |
|---|---|
| G/L Acc. Category Description | Specifies the description of the G/L account category. |
| G/L Account Category Hierarchy | A three level hierarchy of G/L account categories. |
Aging Bucket Period
| Field Name | Description |
|---|---|
| Aging Bucket Period | Expressed in number of days, specifies the period for which data is shown in the report. For example, 30 for thirty days. This field is used on the Aged Receivables (Back Dating) and Aged Payables (Back Dating) reports and has been recaptioned as Aging Bucket Length. |
Aging Date Parameter
| Field Name | Description |
|---|---|
| Aging Parameter | Specifies which date field to base the aging report on. This field is used on the Aged Receivables (Back Dating) and Aged Payables (Back Dating) reports and has been recaptioned as Use Aging Date. |