Deltek Vantagepoint

Chart of accounts — complete settings Pro

Account types, status, ERP company availability, posting currency, cash-basis and revaluation mappings.

UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For accountants, finance staff and managers: choose account type and status, search by number or name, and inspect the complete account dossier. See classification, ERP company availability, posting currency, custom-field currency, cash-basis mapping, revaluation mappings and stored report/legacy settings.

Why Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.

Pro: one SQL Server source, one list and 13 useful configured values in grouped same-row Details. The 2025.1 physical primary key is Account + Type. Both original components are preserved in a hidden length-prefixed row key, so equal account numbers with different types cannot overwrite one another. TypeCode is hidden only as a numeric sorting aid; the visible type contains its documented number and name. This custom read-only SQL requires Pro even without child lists. It is NOT labelled Free. Existing workspace resources still count towards your plan limits.

Type 1 Asset; 2 Liability; 3 Net Worth; 4 Revenue; 5 Reimbursable; 6 Reimbursable Consultant; 7 Direct; 8 Direct Consultant; 9 Indirect; 10 Other Charges. Other Charges includes below-the-line miscellaneous revenue AND expense; it is not an expense-only classification. A/I/D statuses are Active/Inactive/Dormant. GlobalAccount Y/N indicates ERP availability to all companies or only designated companies; it does NOT identify the current company, list its authorised mappings, grant database access or enforce ERP security. Unknown codes remain Code plus their value; NULL stays blank.

Account posting currency restricts posting when populated; it is not company functional currency, a default source currency or an account balance. Custom-field currency is the currency context of custom Chart of Accounts fields. A blank optional currency is not replaced with USD. Cash-basis account, unrealized gain/loss accounts and legacy fixed-assets reference remain stored business codes, not inferred account names or monetary values. GL report detail has documented Show Detail, No Detail and Summarized options, but their numeric encoding is NOT proven here: the native smallint code is displayed without guessing. Cash-basis revaluation is also a native stored flag, not an invented Yes/No decoding. Confirm these settings against your installed ERP. No company/group mapping, revaluation calculation, account balance, trial balance, ledger transactions or financial statement is included.

Physical names/types/nullability and complete key use the frozen official 2025.1 dictionary. Supplementary 7.2 Accounts form/import meanings are disclosed separately. The 7.2 import page calls Account the primary key and uses varchar lengths; it does NOT override the 2025.1 Account+Type PK or physical nvarchar types. This is not same-edition or current-installation certification.

Live reads without scheduled refresh, bounded to 2,000 rows. Opening type/status, search and local filters act on loaded rows and are NOT SQL access control; a reached row limit may leave the chart incomplete and is not a query-cost guarantee. Use only an administrator-approved on-premises SQL Server database/default schema and a dedicated least-privilege SELECT account with authorised company/account scope at the source. Direct SQL does not inherit Vantagepoint Company Mapping or application roles. No dbo owner is assumed; mismatched default-schema object resolution refuses results, not certifies that the source is correct. Complete the Cifru read/compatibility test and inspect a real preview, full keys, edition, codes and timings at import. No direct Deltek Cloud/ODBC access promised; do not use sa/sysadmin, writes, DDL or administrative/migration examples.

No credentials, connection address, cached business row, bank/tax identifiers, QuickBooks internal IDs, audit users/dates or Rowversion in the package. Native screenshots use wholly fictional DEMO rows, not real ERP/SQL Server results. Synthetic adapter tests do not prove installed compatibility. Unofficial and not affiliated with Deltek.

Physical dictionary: https://help.deltek.com/product/Vantagepoint/2025.1/DataDictionary/Content/Tbl_4ccdf7fcb1574207b43e4da6a6b33b37.htm
Supplementary meanings: https://help.deltek.com/product/Vantagepoint/7.2/Settings_GL_Contents_of_Accounts_Form.html
Import format: https://help.deltek.com/product/Vantagepoint/7.2/ut_tf_accounts.html

What this package creates

1 Home0 Details1 lists1 sources to map
  • Home: Chart of accounts

Sources are mapped locally and verified before applying.

Custom queriesPRO1 SQL

Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.

Statically verified read-only$.components.workspaceSelection.datasets.0.sqlQuery
SELECT CONCAT(DATALENGTH(a.Account),N':',a.Account,N':',a.Type) AS RecordKey, a.Type AS TypeCode, a.Name AS Name, a.Account AS Account, CASE a.Type WHEN 1 THEN N'1 - Asset' WHEN 2 THEN N'2 - Liability' WHEN 3 THEN N'3 - Net Worth' WHEN 4 THEN N'4 - Revenue' WHEN 5 THEN N'5 - Reimbursable' WHEN 6 THEN N'6 - Reimbursable Consultant' WHEN 7 THEN N'7 - Direct' WHEN 8 THEN N'8 - Direct Consultant' WHEN 9 THEN N'9 - Indirect' WHEN 10 THEN N'10 - Other Charges' ELSE CONCAT(N'Code ',a.Type) END AS TypeLabel, CASE a.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'D' THEN N'Dormant' ELSE CASE WHEN a.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(a.Status)) END END AS Status, CASE a.GlobalAccount WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN a.GlobalAccount IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(a.GlobalAccount)) END END AS GlobalAccount, a.AccountCurrencyCode AS AccountCurrencyCode, a.CustomCurrencyCode AS CustomCurrencyCode, a.CashBasisAccount AS CashBasisAccount, a.Detail AS Detail, a.UnrealizedGainAccount AS UnrealizedGainAccount, a.UnrealizedLossAccount AS UnrealizedLossAccount, a.CashBasisRevaluation AS CashBasisRevaluation, a.FASAccount AS FASAccount FROM CA a WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'CA',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CA',N'U')

static read-only checks passed

View the JSON being importedcollapsed by default

The exact portable content of this version.

{
    "components": {
        "sourceSlots": [
            {
                "displayName": "Vantagepoint — authorised SQL Server database",
                "id": "08E6CA1B-BEDA-5C9C-86A7-9EFDCE7117AF",
                "kind": "sqlServer",
                "requiredObjects": [
                    "CA"
                ],
                "requiresCustomSQL": true
            }
        ],
        "workspaceSelection": {
            "commonFields": [],
            "datasets": [
                {
                    "cacheMode": "live",
                    "calculatedFields": [],
                    "customQueryIntegrationName": "",
                    "endpointPath": "",
                    "fetchSortRules": [
                        {
                            "direction": "ascending",
                            "id": "2306DCE1-D2DE-5A4E-AF51-708153ECB7E4",
                            "key": "Account",
                            "type": "text"
                        },
                        {
                            "direction": "ascending",
                            "id": "8D526DC3-2197-56A2-83FA-CC34C545354E",
                            "key": "TypeCode",
                            "type": "number"
                        },
                        {
                            "direction": "ascending",
                            "id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
                            "key": "RecordKey",
                            "type": "text"
                        }
                    ],
                    "id": "E0E91E7A-B15F-5728-853B-E7AAB70A7607",
                    "mappings": [
                        {
                            "commonFieldKey": "",
                            "key": "RecordKey",
                            "label": "Internal full account key",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "RecordKey",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "TypeCode",
                            "label": "Native account type sort code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "TypeCode",
                            "type": "number",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "Name",
                            "label": "Account name",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "Name",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "Account",
                            "label": "Account number",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "Account",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "TypeLabel",
                            "label": "Account type",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "TypeLabel",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "Status",
                            "label": "Status",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "Status",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "GlobalAccount",
                            "label": "Available to all ERP companies",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "GlobalAccount",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "AccountCurrencyCode",
                            "label": "Account posting currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "AccountCurrencyCode",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CustomCurrencyCode",
                            "label": "Custom-field currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CustomCurrencyCode",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CashBasisAccount",
                            "label": "Cash-basis account number",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CashBasisAccount",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "Detail",
                            "label": "GL report detail code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "Detail",
                            "type": "number",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "UnrealizedGainAccount",
                            "label": "Revaluation gain account",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "UnrealizedGainAccount",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "UnrealizedLossAccount",
                            "label": "Revaluation loss account",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "UnrealizedLossAccount",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CashBasisRevaluation",
                            "label": "Cash-basis revaluation flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CashBasisRevaluation",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "FASAccount",
                            "label": "Legacy fixed-assets account reference",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "FASAccount",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        }
                    ],
                    "maxRows": 2000,
                    "name": "Chart of accounts",
                    "primaryKey": "RecordKey",
                    "queryParameters": [],
                    "refreshPolicy": {
                        "enabled": false,
                        "intervalMinutes": 60
                    },
                    "rootArrayPath": "",
                    "rowLimitEnabled": true,
                    "searchKeys": [
                        "Name",
                        "Account",
                        "TypeLabel",
                        "Status",
                        "GlobalAccount",
                        "AccountCurrencyCode",
                        "CustomCurrencyCode",
                        "CashBasisAccount",
                        "Detail",
                        "UnrealizedGainAccount",
                        "UnrealizedLossAccount",
                        "CashBasisRevaluation",
                        "FASAccount"
                    ],
                    "sourceID": "08E6CA1B-BEDA-5C9C-86A7-9EFDCE7117AF",
                    "sqlQuery": "SELECT CONCAT(DATALENGTH(a.Account),N':',a.Account,N':',a.Type) AS RecordKey, a.Type AS TypeCode, a.Name AS Name, a.Account AS Account, CASE a.Type WHEN 1 THEN N'1 - Asset' WHEN 2 THEN N'2 - Liability' WHEN 3 THEN N'3 - Net Worth' WHEN 4 THEN N'4 - Revenue' WHEN 5 THEN N'5 - Reimbursable' WHEN 6 THEN N'6 - Reimbursable Consultant' WHEN 7 THEN N'7 - Direct' WHEN 8 THEN N'8 - Direct Consultant' WHEN 9 THEN N'9 - Indirect' WHEN 10 THEN N'10 - Other Charges' ELSE CONCAT(N'Code ',a.Type) END AS TypeLabel, CASE a.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'D' THEN N'Dormant' ELSE CASE WHEN a.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(a.Status)) END END AS Status, CASE a.GlobalAccount WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN a.GlobalAccount IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(a.GlobalAccount)) END END AS GlobalAccount, a.AccountCurrencyCode AS AccountCurrencyCode, a.CustomCurrencyCode AS CustomCurrencyCode, a.CashBasisAccount AS CashBasisAccount, a.Detail AS Detail, a.UnrealizedGainAccount AS UnrealizedGainAccount, a.UnrealizedLossAccount AS UnrealizedLossAccount, a.CashBasisRevaluation AS CashBasisRevaluation, a.FASAccount AS FASAccount FROM CA a WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'CA',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CA',N'U')",
                    "tableName": ""
                }
            ],
            "pages": [
                {
                    "actions": [],
                    "badgeKey": "",
                    "cardEnrichments": [],
                    "cardFieldLayout": [
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "TypeLabel",
                            "label": "Account type",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "Status",
                            "label": "Status",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "GlobalAccount",
                            "label": "Available to all ERP companies",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "AccountCurrencyCode",
                            "label": "Account posting currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "CashBasisAccount",
                            "label": "Cash-basis account number",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "Detail",
                            "label": "GL report detail code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        }
                    ],
                    "datasetID": "E0E91E7A-B15F-5728-853B-E7AAB70A7607",
                    "dateFilterKey": "",
                    "dateFilterLastDays": 7,
                    "dateFilterPreset": "none",
                    "detailFieldLayout": [
                        {
                            "detailGroup": "Account identity",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "Account",
                            "label": "Account number",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Account identity",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "Name",
                            "label": "Account name",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Account identity",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "TypeLabel",
                            "label": "Account type",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Account identity",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "Status",
                            "label": "Status",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Company and currency settings",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "GlobalAccount",
                            "label": "Available to all ERP companies",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Company and currency settings",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "AccountCurrencyCode",
                            "label": "Account posting currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Company and currency settings",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "CustomCurrencyCode",
                            "label": "Custom-field currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Cash basis and ledger report",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "CashBasisAccount",
                            "label": "Cash-basis account number",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Cash basis and ledger report",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "CashBasisRevaluation",
                            "label": "Cash-basis revaluation flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Cash basis and ledger report",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "Detail",
                            "label": "GL report detail code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "Revaluation and legacy mapping",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "UnrealizedGainAccount",
                            "label": "Revaluation gain account",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Revaluation and legacy mapping",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "UnrealizedLossAccount",
                            "label": "Revaluation loss account",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Revaluation and legacy mapping",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "FASAccount",
                            "label": "Legacy fixed-assets account reference",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        }
                    ],
                    "detailLiveRefreshSeconds": 0,
                    "fixedFilters": [],
                    "id": "DF3CFF1D-98DF-539D-A8BD-6DE785D2A1AD",
                    "openFilters": [
                        {
                            "id": "DD7ECD38-F5C4-52C0-A28E-DC6DF839625D",
                            "includeAllOption": true,
                            "key": "TypeLabel",
                            "title": "Account type",
                            "type": "text"
                        },
                        {
                            "id": "0AADE6C2-49E2-5709-8D13-6A3F21A5B185",
                            "includeAllOption": true,
                            "key": "Status",
                            "title": "Account status",
                            "type": "text"
                        }
                    ],
                    "pageSize": 100,
                    "requiresOpeningFilterSelection": true,
                    "showOnHome": true,
                    "sortRules": [
                        {
                            "direction": "ascending",
                            "id": "2306DCE1-D2DE-5A4E-AF51-708153ECB7E4",
                            "key": "Account",
                            "type": "text"
                        },
                        {
                            "direction": "ascending",
                            "id": "8D526DC3-2197-56A2-83FA-CC34C545354E",
                            "key": "TypeCode",
                            "type": "number"
                        },
                        {
                            "direction": "ascending",
                            "id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
                            "key": "RecordKey",
                            "type": "text"
                        }
                    ],
                    "subtitle": "",
                    "subtitleKey": "Account",
                    "systemImage": "list.bullet.rectangle",
                    "title": "Chart of accounts",
                    "titleKey": "Name"
                }
            ],
            "relations": [],
            "widgets": []
        }
    },
    "format": "cifru-configuration-package",
    "formatVersion": 1,
    "manifest": {
        "applicationName": "Deltek Vantagepoint",
        "configurationLanguages": [
            "en"
        ],
        "countries": [
            "US"
        ],
        "createdAt": "2026-10-08T00:00:00Z",
        "description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For accountants, finance staff and managers: choose account type and status, search by number or name, and inspect the complete account dossier. See classification, ERP company availability, posting currency, custom-field currency, cash-basis mapping, revaluation mappings and stored report/legacy settings.\n\nWhy Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.\n\nPro: one SQL Server source, one list and 13 useful configured values in grouped same-row Details. The 2025.1 physical primary key is Account + Type. Both original components are preserved in a hidden length-prefixed row key, so equal account numbers with different types cannot overwrite one another. TypeCode is hidden only as a numeric sorting aid; the visible type contains its documented number and name. This custom read-only SQL requires Pro even without child lists. It is NOT labelled Free. Existing workspace resources still count towards your plan limits.\n\nType 1 Asset; 2 Liability; 3 Net Worth; 4 Revenue; 5 Reimbursable; 6 Reimbursable Consultant; 7 Direct; 8 Direct Consultant; 9 Indirect; 10 Other Charges. Other Charges includes below-the-line miscellaneous revenue AND expense; it is not an expense-only classification. A/I/D statuses are Active/Inactive/Dormant. GlobalAccount Y/N indicates ERP availability to all companies or only designated companies; it does NOT identify the current company, list its authorised mappings, grant database access or enforce ERP security. Unknown codes remain Code plus their value; NULL stays blank.\n\nAccount posting currency restricts posting when populated; it is not company functional currency, a default source currency or an account balance. Custom-field currency is the currency context of custom Chart of Accounts fields. A blank optional currency is not replaced with USD. Cash-basis account, unrealized gain/loss accounts and legacy fixed-assets reference remain stored business codes, not inferred account names or monetary values. GL report detail has documented Show Detail, No Detail and Summarized options, but their numeric encoding is NOT proven here: the native smallint code is displayed without guessing. Cash-basis revaluation is also a native stored flag, not an invented Yes/No decoding. Confirm these settings against your installed ERP. No company/group mapping, revaluation calculation, account balance, trial balance, ledger transactions or financial statement is included.\n\nPhysical names/types/nullability and complete key use the frozen official 2025.1 dictionary. Supplementary 7.2 Accounts form/import meanings are disclosed separately. The 7.2 import page calls Account the primary key and uses varchar lengths; it does NOT override the 2025.1 Account+Type PK or physical nvarchar types. This is not same-edition or current-installation certification.\n\nLive reads without scheduled refresh, bounded to 2,000 rows. Opening type/status, search and local filters act on loaded rows and are NOT SQL access control; a reached row limit may leave the chart incomplete and is not a query-cost guarantee. Use only an administrator-approved on-premises SQL Server database/default schema and a dedicated least-privilege SELECT account with authorised company/account scope at the source. Direct SQL does not inherit Vantagepoint Company Mapping or application roles. No dbo owner is assumed; mismatched default-schema object resolution refuses results, not certifies that the source is correct. Complete the Cifru read/compatibility test and inspect a real preview, full keys, edition, codes and timings at import. No direct Deltek Cloud/ODBC access promised; do not use sa/sysadmin, writes, DDL or administrative/migration examples.\n\nNo credentials, connection address, cached business row, bank/tax identifiers, QuickBooks internal IDs, audit users/dates or Rowversion in the package. Native screenshots use wholly fictional DEMO rows, not real ERP/SQL Server results. Synthetic adapter tests do not prove installed compatibility. Unofficial and not affiliated with Deltek.\n\nPhysical dictionary: https://help.deltek.com/product/Vantagepoint/2025.1/DataDictionary/Content/Tbl_4ccdf7fcb1574207b43e4da6a6b33b37.htm\nSupplementary meanings: https://help.deltek.com/product/Vantagepoint/7.2/Settings_GL_Contents_of_Accounts_Form.html\nImport format: https://help.deltek.com/product/Vantagepoint/7.2/ut_tf_accounts.html",
        "licenseCode": "Cifru-Community-1.0",
        "minimumCifruVersion": "1.1.0",
        "minimumPlan": "pro",
        "packageID": "1B85FA46-5E24-55D5-950E-EE98B5A6BC06",
        "rootButtonCount": 1,
        "summary": "Account types, status, ERP company availability, posting currency, cash-basis and revaluation mappings.",
        "tags": [
            "Deltek Vantagepoint",
            "SQL Server",
            "Accounting",
            "Chart of accounts",
            "Pro"
        ],
        "title": "Chart of accounts — complete settings Pro"
    }
}

Tags

Reviews

There are no approved reviews for this version yet.

Write a review

Sign in to review

Similar templates

From the same application, then shared tags, in the same language and country.