Project fiscal dossier — posted ledger and transactions Pro
Fiscal project cohorts with current dossier, posting counts and lazy ledger/transactions, with three separate currency contexts.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For project managers, controllers and accountants: choose the current project company and a fiscal subperiod-end cohort, inspect project responsibility, performance dates, charging setup and contract references, then open Posted ledger and the selected posting’s Transactions on demand. Keep functional, transaction and voucher currency contexts separate while investigating recorded project accounting.
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, three live lists, two lazy nested relations, 26 project/context values, 16 posting/context values and 23 transaction values. No automatic refresh. Mandatory native company and subperiod-end period selection, plus optional project, precede bounded root reads. Root is one project per fiscal year/period/subperiod with posted records, enriched by the CURRENT project master. The same project appears separately for multiple subperiods. Unposted projects and undated/missing-calendar cohorts are NOT listed; their absence is NOT proof of no activity. Date filtering uses the ACTUAL SUB_PD_END_DT with start inclusive and end exclusive, NOT project performance or posting dates. Root SQL has no opening parameters, permitting cold native distinct-option discovery. Children bind project/company AND the exact year/period/subperiod before the limit; Transactions additionally binds all four posting keys. The posting record count belongs only to this fiscal cohort, not all-time project activity or transaction-line count. Calendar end is NOT document, entry, transaction or posting day; fiscal periods need not be calendar months. No frozen/as-of snapshot or complete current master catalogue is promised.
Physical project identity is the full global PROJ_ID, not a fabricated project+company PK. Report row identity is derived project PLUS the complete fiscal triple, not the physical PROJ key. Company is separately required scope. Children bind the selected project AND company before the read limit. Current project company and optional organization text are NOT certified historical ownership after reassignment. Manager name is read directly: a non-employee manager does not remove the project. Raw Active, Allow Charging and Billable setup flags stay distinct native values. Active relates to charging purposes, not an authorization grant or complete work status. Billable setup is not proof of actual billability, invoices or revenue. Recorded performance dates are user-maintained, not legal contract validation. Customer/contract references and notes are not reconstructed document histories.
PROJ → GL_POST_SUM → GL_DETL uses all four physical posting keys and the detail’s four GLPSUM foreign-key columns. GL_DETL has no project column. Each detail retains its OWN four-key identity; repeated invoice, journal or posting sequence references are not identities. Posting and detail company must agree, as must current project scope. Orphans and mismatched scopes do not borrow another record. Current ORG/ACCT/GL_CONFIG masters are optional; missing names or currency stay unknown and do not remove an otherwise scoped transaction. SUB_PD uses the full year/period/subperiod triple and has no company column. Internal keys remain hidden and are not searchable.
GL_POST_SUM.AMT is the stored functional posting value. Detail AMT is functional, TRN_AMT uses its recorded TRN_CRNCY_CD, and VCHR_INVC_AMT uses its own voucher-invoice currency. Functional currency is CURRENT GL_CONFIG.FUNC_S_CRNCY_CD for that company; verify historical denomination and actual mappings before financial use. No guessed USD, monetary symbol, FX conversion, NULL-to-zero, ABS or sum of posting and detail values. Zero, negative and reversal rows remain. Do not add functional, transactional and voucher-invoice values: they are separate contexts, not extra charges. This is general posted GL activity, NOT exclusively expenses, complete project costs, burden/revenue totals, budget, profit, cash flow or a certified reconciliation.
No PROJ_SUM snapshot sums or PROJ/PROJ_MOD financial values are included: their selected 8.1 currency roles are not certified. PTD/YTD snapshots are not independent deltas. Ledger processing and summarization can affect available history; absent rows do not establish completeness. Newer 2026.2 columns are not backported into 8.1. Physical evidence is frozen official 8.1.0 Transaction Schema plus separate project, fiscal-calendar, posting and functional/transaction-currency help. AMT roles are corroborated by process and UI, not a deployed SQL mapping certificate. Oracle type spellings are NOT Microsoft SQL Server DDL or proof of current 2026 compatibility.
Explicit SELECT excludes employee IDs, generic person NAME/ID, authentication fields, audit users, timestamps and document paths. Project/transaction notes and business references can be confidential: use dedicated least-privilege SELECT access approved by the administrator for these exact rows and fields. Direct SQL does NOT inherit Costpoint project/org/company roles, masking or ITAR/EAR controls. Opening filters are NOT ACLs. No source credentials, cached business rows, real people or source host details are bundled. Public capture material must be wholly fictional DEMO. No dbo owner assumption, Deltek Cloud direct SQL access, sa/sysadmin, DDL, writes or financial updates. Default-schema object checks reject ambiguous lookup but do not prove the intended database. Pass compatibility/read tests, confirm actual schema, full keys, currency meanings, scope, privacy and timings. Up to 1,000 rows per list; option discovery and reads can be limited, loaded search is local. Root fiscal grouping may scan substantial GL history even for a short selected period; confirm real query plans and approved reporting indexes/views with the administrator. No completeness, real-time or performance guarantee. Not tested on a real ERP or SQL Server. Documentary/synthetic tests and native DEMO do not prove deployed compatibility. Unofficial, not affiliated with Deltek.
Physical dictionary: https://help.deltek.com/product/Costpoint/Documentation/81DataDictionary.html
Project setup: https://help.deltek.com/Product/Costpoint/8.1/GA/PJMBASIC_Basic_Info_Tab.html
GL currency process: https://help.deltek.com/Product/Costpoint/8.1/GA/PJPALCST.html
GL transactions: https://help.deltek.com/Product/Costpoint/8.1/GA/GLQINQ_Transactions_Subtask.html
Fiscal calendar: https://help.deltek.com/Product/Costpoint/8.1/GA/GLMSUBPD_Contents_of_the_Manage_Subperiods_Screen.html
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Project fiscal dossier
- Details: Posted ledger
- Details: Transactions
- Sub-button: Project posted ledger
- Sub-button: Posted transactions
Sources are mapped locally and verified before applying.
Custom queriesPRO3 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.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(p.PROJ_ID,N'#')),N':',p.PROJ_ID,N':'),CONCAT(LEN(CONCAT(z.FY_CD,N'#')),N':',z.FY_CD,N':',LEN(CONCAT(z.PD_NO,N'#')),N':',z.PD_NO,N':',LEN(CONCAT(z.SUB_PD_NO,N'#')),N':',z.SUB_PD_NO,N':')) AS ProjectPeriodKey, COALESCE(NULLIF(LTRIM(RTRIM(p.PROJ_NAME)),N''),p.PROJ_ID) AS ProjectName, p.PROJ_ID AS ProjectCode, p.COMPANY_ID AS COMPANY_ID, p.PROJ_LONG_NAME AS PROJ_LONG_NAME, p.PROJ_TYPE_DC AS PROJ_TYPE_DC, p.PROJ_MGR_NAME AS PROJ_MGR_NAME, p.CUST_ID AS CUST_ID, p.ORG_ID AS ORG_ID, o.ORG_NAME AS CurrentOrganizationName, p.ACCT_GRP_CD AS ACCT_GRP_CD, p.LVL_NO AS LVL_NO, p.PROJ_ABBRV_CD AS PROJ_ABBRV_CD, p.ACTIVE_FL AS ACTIVE_FL, p.ALLOW_CHARGES_FL AS ALLOW_CHARGES_FL, p.BILL_PROJ_FL AS BILL_PROJ_FL, p.PROJ_START_DT AS PROJ_START_DT, p.PROJ_END_DT AS PROJ_END_DT, p.PRIME_CONTR_ID AS PRIME_CONTR_ID, p.SUBCTR_ID AS SUBCTR_ID, p.CUST_PO_ID AS CUST_PO_ID, p.NOTES AS NOTES, z.FY_CD AS FiscalYear, z.PD_NO AS FiscalPeriod, z.SUB_PD_NO AS FiscalSubperiod, c.SUB_PD_END_DT AS FiscalSubperiodEnd, z.PostedRecordCount AS PostedRecordCount FROM PROJ p INNER JOIN (SELECT s.PROJ_ID,s.COMPANY_ID,s.FY_CD,s.PD_NO,s.SUB_PD_NO,COUNT_BIG(*) AS PostedRecordCount FROM GL_POST_SUM s GROUP BY s.PROJ_ID,s.COMPANY_ID,s.FY_CD,s.PD_NO,s.SUB_PD_NO) z ON z.PROJ_ID=p.PROJ_ID AND z.COMPANY_ID=p.COMPANY_ID INNER JOIN SUB_PD c ON c.FY_CD=z.FY_CD AND c.PD_NO=z.PD_NO AND c.SUB_PD_NO=z.SUB_PD_NO LEFT JOIN ORG o ON o.ORG_ID=p.ORG_ID AND o.COMPANY_ID=p.COMPANY_ID WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PROJ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PROJ',N'U') AND OBJECT_ID(N'GL_POST_SUM',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_POST_SUM',N'U') AND OBJECT_ID(N'GL_DETL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_DETL',N'U') AND OBJECT_ID(N'SUB_PD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SUB_PD',N'U') AND OBJECT_ID(N'ORG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORG',N'U') AND OBJECT_ID(N'ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ACCT',N'U') AND OBJECT_ID(N'GL_CONFIG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_CONFIG',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(LEN(CONCAT(s.SRCE_KEY,N'#')),N':',s.SRCE_KEY,N':',LEN(CONCAT(s.LVL1_KEY,N'#')),N':',s.LVL1_KEY,N':',LEN(CONCAT(s.LVL2_KEY,N'#')),N':',s.LVL2_KEY,N':',LEN(CONCAT(s.LVL3_KEY,N'#')),N':',s.LVL3_KEY,N':') AS PostingKey, CONCAT(CONCAT(LEN(CONCAT(p.PROJ_ID,N'#')),N':',p.PROJ_ID,N':'),CONCAT(LEN(CONCAT(s.FY_CD,N'#')),N':',s.FY_CD,N':',LEN(CONCAT(s.PD_NO,N'#')),N':',s.PD_NO,N':',LEN(CONCAT(s.SUB_PD_NO,N'#')),N':',s.SUB_PD_NO,N':')) AS ParentProjectPeriodKey, s.SRCE_KEY AS PostingSourceKey, s.LVL1_KEY AS PostingLevel1Key, s.LVL2_KEY AS PostingLevel2Key, s.LVL3_KEY AS PostingLevel3Key, CONCAT(COALESCE(NULLIF(LTRIM(RTRIM(a.ACCT_NAME)),N''),s.ACCT_ID),N' · ',s.FY_CD,N'/',s.PD_NO,N'/',s.SUB_PD_NO) AS PostingTitle, p.PROJ_NAME AS ProjectName, p.PROJ_ID AS ProjectCode, s.COMPANY_ID AS CompanyCode, s.FY_CD AS FiscalYear, s.PD_NO AS FiscalPeriod, s.SUB_PD_NO AS FiscalSubperiod, c.SUB_PD_END_DT AS FiscalSubperiodEnd, s.ACCT_ID AS AccountCode, a.ACCT_NAME AS CurrentAccountName, s.ORG_ID AS OrganizationCode, o.ORG_NAME AS CurrentOrganizationName, s.S_JNL_CD AS JournalCode, s.POST_SEQ_NO AS PostingSequence, s.AMT AS FunctionalAmount, g.FUNC_S_CRNCY_CD AS CurrentFunctionalCurrency FROM GL_POST_SUM s JOIN PROJ p ON p.PROJ_ID = s.PROJ_ID AND p.COMPANY_ID = s.COMPANY_ID LEFT JOIN SUB_PD c ON c.FY_CD = s.FY_CD AND c.PD_NO = s.PD_NO AND c.SUB_PD_NO = s.SUB_PD_NO LEFT JOIN ORG o ON o.ORG_ID = s.ORG_ID AND o.COMPANY_ID = s.COMPANY_ID LEFT JOIN ACCT a ON a.ACCT_ID = s.ACCT_ID LEFT JOIN GL_CONFIG g ON g.COMPANY_ID = s.COMPANY_ID WHERE p.PROJ_ID = :project AND p.COMPANY_ID = :company AND s.FY_CD=:year AND s.PD_NO=:period AND s.SUB_PD_NO=:subperiod AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PROJ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PROJ',N'U') AND OBJECT_ID(N'GL_POST_SUM',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_POST_SUM',N'U') AND OBJECT_ID(N'GL_DETL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_DETL',N'U') AND OBJECT_ID(N'SUB_PD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SUB_PD',N'U') AND OBJECT_ID(N'ORG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORG',N'U') AND OBJECT_ID(N'ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ACCT',N'U') AND OBJECT_ID(N'GL_CONFIG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_CONFIG',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(LEN(CONCAT(d.SRCE_KEY,N'#')),N':',d.SRCE_KEY,N':',LEN(CONCAT(d.LVL1_KEY,N'#')),N':',d.LVL1_KEY,N':',LEN(CONCAT(d.LVL2_KEY,N'#')),N':',d.LVL2_KEY,N':',LEN(CONCAT(d.LVL3_KEY,N'#')),N':',d.LVL3_KEY,N':') AS TransactionKey, CONCAT(LEN(CONCAT(s.SRCE_KEY,N'#')),N':',s.SRCE_KEY,N':',LEN(CONCAT(s.LVL1_KEY,N'#')),N':',s.LVL1_KEY,N':',LEN(CONCAT(s.LVL2_KEY,N'#')),N':',s.LVL2_KEY,N':',LEN(CONCAT(s.LVL3_KEY,N'#')),N':',s.LVL3_KEY,N':') AS ParentPostingKey, d.SRCE_KEY AS TransactionSourceKey, d.LVL1_KEY AS TransactionLevel1Key, d.LVL2_KEY AS TransactionLevel2Key, d.LVL3_KEY AS TransactionLevel3Key, s.SRCE_KEY AS PostingSourceKey, s.LVL1_KEY AS PostingLevel1Key, s.LVL2_KEY AS PostingLevel2Key, s.LVL3_KEY AS PostingLevel3Key, COALESCE(NULLIF(LTRIM(RTRIM(d.TRN_DESC)),N''),N'Posted transaction') AS TransactionDescription, p.PROJ_ID AS ProjectCode, s.COMPANY_ID AS CompanyCode, s.FY_CD AS FiscalYear, s.PD_NO AS FiscalPeriod, s.SUB_PD_NO AS FiscalSubperiod, c.SUB_PD_END_DT AS FiscalSubperiodEnd, s.ACCT_ID AS AccountCode, a.ACCT_NAME AS CurrentAccountName, s.ORG_ID AS OrganizationCode, o.ORG_NAME AS CurrentOrganizationName, s.S_JNL_CD AS JournalCode, s.POST_SEQ_NO AS PostingSequence, d.AMT AS FunctionalAmount, g.FUNC_S_CRNCY_CD AS CurrentFunctionalCurrency, d.TRN_AMT AS TransactionAmount, d.TRN_CRNCY_CD AS TransactionCurrency, d.VCHR_INVC_AMT AS VoucherInvoiceAmount, d.VCHR_INVC_CRNCY_CD AS VoucherInvoiceCurrency, d.INVC_ID AS InvoiceReference, d.VCHR_NO AS VoucherReference, d.PO_ID AS PurchaseOrderReference, d.JE_NO AS JournalEntryReference FROM GL_DETL d JOIN GL_POST_SUM s ON s.SRCE_KEY = d.GLPSUM_SRCE_KEY AND s.LVL1_KEY = d.GLPSUM_LVL1_KEY AND s.LVL2_KEY = d.GLPSUM_LVL2_KEY AND s.LVL3_KEY = d.GLPSUM_LVL3_KEY AND s.COMPANY_ID = d.COMPANY_ID JOIN PROJ p ON p.PROJ_ID = s.PROJ_ID AND p.COMPANY_ID = s.COMPANY_ID LEFT JOIN SUB_PD c ON c.FY_CD = s.FY_CD AND c.PD_NO = s.PD_NO AND c.SUB_PD_NO = s.SUB_PD_NO LEFT JOIN ORG o ON o.ORG_ID = s.ORG_ID AND o.COMPANY_ID = s.COMPANY_ID LEFT JOIN ACCT a ON a.ACCT_ID = s.ACCT_ID LEFT JOIN GL_CONFIG g ON g.COMPANY_ID = s.COMPANY_ID WHERE p.PROJ_ID = :project AND p.COMPANY_ID = :company AND s.SRCE_KEY = :source AND s.LVL1_KEY = :level1 AND s.LVL2_KEY = :level2 AND s.LVL3_KEY = :level3 AND s.FY_CD=:year AND s.PD_NO=:period AND s.SUB_PD_NO=:subperiod AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PROJ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PROJ',N'U') AND OBJECT_ID(N'GL_POST_SUM',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_POST_SUM',N'U') AND OBJECT_ID(N'GL_DETL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_DETL',N'U') AND OBJECT_ID(N'SUB_PD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SUB_PD',N'U') AND OBJECT_ID(N'ORG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORG',N'U') AND OBJECT_ID(N'ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ACCT',N'U') AND OBJECT_ID(N'GL_CONFIG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_CONFIG',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Costpoint 8.1 — authorised project / GL SQL Server database",
"id": "3DFD46F3-B6C0-5E6E-B539-EFD8E857E84A",
"kind": "sqlServer",
"requiredObjects": [
"PROJ",
"GL_POST_SUM",
"GL_DETL",
"SUB_PD",
"ORG",
"ACCT",
"GL_CONFIG"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "CAAED3AD-E1EA-51E2-87D5-487C026FFC97",
"key": "FiscalSubperiodEnd",
"type": "date"
},
{
"direction": "ascending",
"id": "E5677A13-2E89-5254-8E59-E6BF83E6CBDF",
"key": "ProjectName",
"type": "text"
},
{
"direction": "ascending",
"id": "8B794BBC-B6C8-5562-A475-98A0AF90EA33",
"key": "ProjectPeriodKey",
"type": "text"
}
],
"id": "6A62DF91-54C9-5058-B8D0-3E1C9847634C",
"mappings": [
{
"commonFieldKey": "",
"key": "ProjectPeriodKey",
"label": "Internal ProjectPeriodKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjectPeriodKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProjectName",
"label": "Project name (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjectName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProjectCode",
"label": "Project code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjectCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMPANY_ID",
"label": "Project company (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMPANY_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PROJ_LONG_NAME",
"label": "Extended name (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROJ_LONG_NAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROJ_TYPE_DC",
"label": "Project type (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROJ_TYPE_DC",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PROJ_MGR_NAME",
"label": "Manager name (recorded)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROJ_MGR_NAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CUST_ID",
"label": "Customer account (recorded)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CUST_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORG_ID",
"label": "Owning organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ORG_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrentOrganizationName",
"label": "Owning organization (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrentOrganizationName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACCT_GRP_CD",
"label": "Project account group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ACCT_GRP_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LVL_NO",
"label": "Project level (recorded)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LVL_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROJ_ABBRV_CD",
"label": "Project abbreviation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROJ_ABBRV_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACTIVE_FL",
"label": "Active flag (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ACTIVE_FL",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ALLOW_CHARGES_FL",
"label": "Allow charging (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ALLOW_CHARGES_FL",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BILL_PROJ_FL",
"label": "Billable setup (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BILL_PROJ_FL",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROJ_START_DT",
"label": "Performance start (recorded)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PROJ_START_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROJ_END_DT",
"label": "Performance end (recorded)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PROJ_END_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRIME_CONTR_ID",
"label": "Prime contract reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PRIME_CONTR_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SUBCTR_ID",
"label": "Subcontract reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SUBCTR_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CUST_PO_ID",
"label": "Customer PO reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CUST_PO_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NOTES",
"label": "Project notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NOTES",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalYear",
"label": "Fiscal year",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FiscalYear",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalPeriod",
"label": "Fiscal period",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FiscalPeriod",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalSubperiod",
"label": "Fiscal subperiod",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FiscalSubperiod",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalSubperiodEnd",
"label": "Subperiod end date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FiscalSubperiodEnd",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PostedRecordCount",
"label": "Posting records (subperiod)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PostedRecordCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Project fiscal dossier",
"primaryKey": "ProjectPeriodKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ProjectName",
"ProjectCode",
"COMPANY_ID",
"PROJ_LONG_NAME",
"PROJ_TYPE_DC",
"PROJ_MGR_NAME",
"CUST_ID",
"ORG_ID",
"CurrentOrganizationName",
"ACCT_GRP_CD",
"LVL_NO",
"PROJ_ABBRV_CD",
"ACTIVE_FL",
"ALLOW_CHARGES_FL",
"BILL_PROJ_FL",
"PROJ_START_DT",
"PROJ_END_DT",
"PRIME_CONTR_ID",
"SUBCTR_ID",
"CUST_PO_ID",
"NOTES",
"FiscalYear",
"FiscalPeriod",
"FiscalSubperiod",
"FiscalSubperiodEnd",
"PostedRecordCount"
],
"sourceID": "3DFD46F3-B6C0-5E6E-B539-EFD8E857E84A",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(p.PROJ_ID,N'#')),N':',p.PROJ_ID,N':'),CONCAT(LEN(CONCAT(z.FY_CD,N'#')),N':',z.FY_CD,N':',LEN(CONCAT(z.PD_NO,N'#')),N':',z.PD_NO,N':',LEN(CONCAT(z.SUB_PD_NO,N'#')),N':',z.SUB_PD_NO,N':')) AS ProjectPeriodKey, COALESCE(NULLIF(LTRIM(RTRIM(p.PROJ_NAME)),N''),p.PROJ_ID) AS ProjectName, p.PROJ_ID AS ProjectCode, p.COMPANY_ID AS COMPANY_ID, p.PROJ_LONG_NAME AS PROJ_LONG_NAME, p.PROJ_TYPE_DC AS PROJ_TYPE_DC, p.PROJ_MGR_NAME AS PROJ_MGR_NAME, p.CUST_ID AS CUST_ID, p.ORG_ID AS ORG_ID, o.ORG_NAME AS CurrentOrganizationName, p.ACCT_GRP_CD AS ACCT_GRP_CD, p.LVL_NO AS LVL_NO, p.PROJ_ABBRV_CD AS PROJ_ABBRV_CD, p.ACTIVE_FL AS ACTIVE_FL, p.ALLOW_CHARGES_FL AS ALLOW_CHARGES_FL, p.BILL_PROJ_FL AS BILL_PROJ_FL, p.PROJ_START_DT AS PROJ_START_DT, p.PROJ_END_DT AS PROJ_END_DT, p.PRIME_CONTR_ID AS PRIME_CONTR_ID, p.SUBCTR_ID AS SUBCTR_ID, p.CUST_PO_ID AS CUST_PO_ID, p.NOTES AS NOTES, z.FY_CD AS FiscalYear, z.PD_NO AS FiscalPeriod, z.SUB_PD_NO AS FiscalSubperiod, c.SUB_PD_END_DT AS FiscalSubperiodEnd, z.PostedRecordCount AS PostedRecordCount FROM PROJ p INNER JOIN (SELECT s.PROJ_ID,s.COMPANY_ID,s.FY_CD,s.PD_NO,s.SUB_PD_NO,COUNT_BIG(*) AS PostedRecordCount FROM GL_POST_SUM s GROUP BY s.PROJ_ID,s.COMPANY_ID,s.FY_CD,s.PD_NO,s.SUB_PD_NO) z ON z.PROJ_ID=p.PROJ_ID AND z.COMPANY_ID=p.COMPANY_ID INNER JOIN SUB_PD c ON c.FY_CD=z.FY_CD AND c.PD_NO=z.PD_NO AND c.SUB_PD_NO=z.SUB_PD_NO LEFT JOIN ORG o ON o.ORG_ID=p.ORG_ID AND o.COMPANY_ID=p.COMPANY_ID WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PROJ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PROJ',N'U') AND OBJECT_ID(N'GL_POST_SUM',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_POST_SUM',N'U') AND OBJECT_ID(N'GL_DETL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_DETL',N'U') AND OBJECT_ID(N'SUB_PD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SUB_PD',N'U') AND OBJECT_ID(N'ORG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORG',N'U') AND OBJECT_ID(N'ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ACCT',N'U') AND OBJECT_ID(N'GL_CONFIG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_CONFIG',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "CAAED3AD-E1EA-51E2-87D5-487C026FFC97",
"key": "FiscalSubperiodEnd",
"type": "date"
},
{
"direction": "ascending",
"id": "AF6211CE-AA81-5D06-A0D9-8FFEFABDD891",
"key": "PostingKey",
"type": "text"
}
],
"id": "26820ED7-1DC8-5AE4-A028-C06ED8685BF8",
"mappings": [
{
"commonFieldKey": "",
"key": "PostingKey",
"label": "Internal PostingKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentProjectPeriodKey",
"label": "Internal ParentProjectPeriodKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentProjectPeriodKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingSourceKey",
"label": "Internal PostingSourceKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingSourceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingLevel1Key",
"label": "Internal PostingLevel1Key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingLevel1Key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingLevel2Key",
"label": "Internal PostingLevel2Key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingLevel2Key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingLevel3Key",
"label": "Internal PostingLevel3Key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingLevel3Key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingTitle",
"label": "Account / fiscal context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingTitle",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProjectName",
"label": "Project name (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjectName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProjectCode",
"label": "Project code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjectCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyCode",
"label": "Posting company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalYear",
"label": "Fiscal year",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FiscalYear",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalPeriod",
"label": "Fiscal period",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FiscalPeriod",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalSubperiod",
"label": "Fiscal subperiod",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FiscalSubperiod",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalSubperiodEnd",
"label": "Subperiod end date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FiscalSubperiodEnd",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountCode",
"label": "Account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrentAccountName",
"label": "Current account name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrentAccountName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrganizationCode",
"label": "Posting organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrganizationCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrentOrganizationName",
"label": "Organization name (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrentOrganizationName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JournalCode",
"label": "Journal code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "JournalCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PostingSequence",
"label": "Posting sequence reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PostingSequence",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FunctionalAmount",
"label": "Posting amount (functional)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FunctionalAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrentFunctionalCurrency",
"label": "Functional currency (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrentFunctionalCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Project posted ledger",
"primaryKey": "PostingKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "FiscalYear",
"id": "7EA71E63-3A01-5FD8-95BB-80F3ED449D4C",
"name": "year",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "FiscalPeriod",
"id": "03735CA4-57B4-500E-8660-165813E22488",
"name": "period",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "FiscalSubperiod",
"id": "BFC10F4A-1133-524F-AB4A-BAE0A8E8EF44",
"name": "subperiod",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ProjectCode",
"id": "91491550-B347-59AD-AF12-AA3BC2DC5FB2",
"name": "project",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "COMPANY_ID",
"id": "AF79BF58-7DEC-59F5-B2F8-8818924BBF8D",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"PostingTitle",
"ProjectName",
"ProjectCode",
"CompanyCode",
"FiscalYear",
"FiscalPeriod",
"FiscalSubperiod",
"FiscalSubperiodEnd",
"AccountCode",
"CurrentAccountName",
"OrganizationCode",
"CurrentOrganizationName",
"JournalCode",
"PostingSequence",
"FunctionalAmount",
"CurrentFunctionalCurrency"
],
"sourceID": "3DFD46F3-B6C0-5E6E-B539-EFD8E857E84A",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(s.SRCE_KEY,N'#')),N':',s.SRCE_KEY,N':',LEN(CONCAT(s.LVL1_KEY,N'#')),N':',s.LVL1_KEY,N':',LEN(CONCAT(s.LVL2_KEY,N'#')),N':',s.LVL2_KEY,N':',LEN(CONCAT(s.LVL3_KEY,N'#')),N':',s.LVL3_KEY,N':') AS PostingKey, CONCAT(CONCAT(LEN(CONCAT(p.PROJ_ID,N'#')),N':',p.PROJ_ID,N':'),CONCAT(LEN(CONCAT(s.FY_CD,N'#')),N':',s.FY_CD,N':',LEN(CONCAT(s.PD_NO,N'#')),N':',s.PD_NO,N':',LEN(CONCAT(s.SUB_PD_NO,N'#')),N':',s.SUB_PD_NO,N':')) AS ParentProjectPeriodKey, s.SRCE_KEY AS PostingSourceKey, s.LVL1_KEY AS PostingLevel1Key, s.LVL2_KEY AS PostingLevel2Key, s.LVL3_KEY AS PostingLevel3Key, CONCAT(COALESCE(NULLIF(LTRIM(RTRIM(a.ACCT_NAME)),N''),s.ACCT_ID),N' · ',s.FY_CD,N'/',s.PD_NO,N'/',s.SUB_PD_NO) AS PostingTitle, p.PROJ_NAME AS ProjectName, p.PROJ_ID AS ProjectCode, s.COMPANY_ID AS CompanyCode, s.FY_CD AS FiscalYear, s.PD_NO AS FiscalPeriod, s.SUB_PD_NO AS FiscalSubperiod, c.SUB_PD_END_DT AS FiscalSubperiodEnd, s.ACCT_ID AS AccountCode, a.ACCT_NAME AS CurrentAccountName, s.ORG_ID AS OrganizationCode, o.ORG_NAME AS CurrentOrganizationName, s.S_JNL_CD AS JournalCode, s.POST_SEQ_NO AS PostingSequence, s.AMT AS FunctionalAmount, g.FUNC_S_CRNCY_CD AS CurrentFunctionalCurrency FROM GL_POST_SUM s\nJOIN PROJ p ON p.PROJ_ID = s.PROJ_ID AND p.COMPANY_ID = s.COMPANY_ID\nLEFT JOIN SUB_PD c ON c.FY_CD = s.FY_CD AND c.PD_NO = s.PD_NO AND c.SUB_PD_NO = s.SUB_PD_NO\nLEFT JOIN ORG o ON o.ORG_ID = s.ORG_ID AND o.COMPANY_ID = s.COMPANY_ID\nLEFT JOIN ACCT a ON a.ACCT_ID = s.ACCT_ID\nLEFT JOIN GL_CONFIG g ON g.COMPANY_ID = s.COMPANY_ID\nWHERE p.PROJ_ID = :project AND p.COMPANY_ID = :company\n AND s.FY_CD=:year AND s.PD_NO=:period AND s.SUB_PD_NO=:subperiod AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PROJ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PROJ',N'U') AND OBJECT_ID(N'GL_POST_SUM',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_POST_SUM',N'U') AND OBJECT_ID(N'GL_DETL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_DETL',N'U') AND OBJECT_ID(N'SUB_PD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SUB_PD',N'U') AND OBJECT_ID(N'ORG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORG',N'U') AND OBJECT_ID(N'ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ACCT',N'U') AND OBJECT_ID(N'GL_CONFIG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_CONFIG',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "CAAED3AD-E1EA-51E2-87D5-487C026FFC97",
"key": "FiscalSubperiodEnd",
"type": "date"
},
{
"direction": "ascending",
"id": "E090F16D-50C3-5228-91D7-2B1CBABB3A9D",
"key": "TransactionKey",
"type": "text"
}
],
"id": "3F0CC7D1-F811-54DE-8DBF-57EED620C86E",
"mappings": [
{
"commonFieldKey": "",
"key": "TransactionKey",
"label": "Internal TransactionKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransactionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentPostingKey",
"label": "Internal ParentPostingKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentPostingKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionSourceKey",
"label": "Internal TransactionSourceKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransactionSourceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionLevel1Key",
"label": "Internal TransactionLevel1Key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransactionLevel1Key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionLevel2Key",
"label": "Internal TransactionLevel2Key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransactionLevel2Key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionLevel3Key",
"label": "Internal TransactionLevel3Key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransactionLevel3Key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingSourceKey",
"label": "Internal PostingSourceKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingSourceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingLevel1Key",
"label": "Internal PostingLevel1Key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingLevel1Key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingLevel2Key",
"label": "Internal PostingLevel2Key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingLevel2Key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingLevel3Key",
"label": "Internal PostingLevel3Key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingLevel3Key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionDescription",
"label": "Transaction description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransactionDescription",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProjectCode",
"label": "Project code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjectCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyCode",
"label": "Posting / transaction company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalYear",
"label": "Fiscal year",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FiscalYear",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalPeriod",
"label": "Fiscal period",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FiscalPeriod",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalSubperiod",
"label": "Fiscal subperiod",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FiscalSubperiod",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalSubperiodEnd",
"label": "Subperiod end date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FiscalSubperiodEnd",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountCode",
"label": "Account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrentAccountName",
"label": "Current account name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrentAccountName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrganizationCode",
"label": "Posting organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrganizationCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrentOrganizationName",
"label": "Organization name (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrentOrganizationName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JournalCode",
"label": "Journal code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "JournalCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PostingSequence",
"label": "Posting sequence reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PostingSequence",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FunctionalAmount",
"label": "Transaction value (functional)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FunctionalAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrentFunctionalCurrency",
"label": "Functional currency (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrentFunctionalCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionAmount",
"label": "Amount (transaction currency)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TransactionCurrency",
"label": "Transaction currency (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransactionCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VoucherInvoiceAmount",
"label": "Amount (voucher-invoice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VoucherInvoiceAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VoucherInvoiceCurrency",
"label": "Voucher-invoice currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VoucherInvoiceCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceReference",
"label": "Invoice reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceReference",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VoucherReference",
"label": "Voucher reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VoucherReference",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchaseOrderReference",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchaseOrderReference",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JournalEntryReference",
"label": "Journal entry reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JournalEntryReference",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Posted transactions",
"primaryKey": "TransactionKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "FiscalYear",
"id": "24C8747B-B003-5D25-BE33-67EA8D90CA1E",
"name": "year",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "FiscalPeriod",
"id": "A34F62FB-88A9-5316-B523-AF35F9C19F92",
"name": "period",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "FiscalSubperiod",
"id": "47155134-55A3-5E17-A12C-30899D1B67DC",
"name": "subperiod",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ProjectCode",
"id": "091B9CF0-2BF6-5358-97BE-28B2E607E04C",
"name": "project",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyCode",
"id": "7960D9F0-7DF6-569C-A7FD-EACD714EC4C7",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PostingSourceKey",
"id": "7E352A7F-6508-5A7A-A46A-B464D9E34240",
"name": "source",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PostingLevel1Key",
"id": "A46F17ED-CC8D-5431-B82F-6CAB25885C56",
"name": "level1",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PostingLevel2Key",
"id": "DDF290B0-B41D-51A9-A6CB-CCB16B469D70",
"name": "level2",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PostingLevel3Key",
"id": "ED62F969-F934-59FE-BF19-D489073FE1E2",
"name": "level3",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"TransactionDescription",
"ProjectCode",
"CompanyCode",
"FiscalYear",
"FiscalPeriod",
"FiscalSubperiod",
"FiscalSubperiodEnd",
"AccountCode",
"CurrentAccountName",
"OrganizationCode",
"CurrentOrganizationName",
"JournalCode",
"PostingSequence",
"FunctionalAmount",
"CurrentFunctionalCurrency",
"TransactionAmount",
"TransactionCurrency",
"VoucherInvoiceAmount",
"VoucherInvoiceCurrency",
"InvoiceReference",
"VoucherReference",
"PurchaseOrderReference",
"JournalEntryReference"
],
"sourceID": "3DFD46F3-B6C0-5E6E-B539-EFD8E857E84A",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(d.SRCE_KEY,N'#')),N':',d.SRCE_KEY,N':',LEN(CONCAT(d.LVL1_KEY,N'#')),N':',d.LVL1_KEY,N':',LEN(CONCAT(d.LVL2_KEY,N'#')),N':',d.LVL2_KEY,N':',LEN(CONCAT(d.LVL3_KEY,N'#')),N':',d.LVL3_KEY,N':') AS TransactionKey, CONCAT(LEN(CONCAT(s.SRCE_KEY,N'#')),N':',s.SRCE_KEY,N':',LEN(CONCAT(s.LVL1_KEY,N'#')),N':',s.LVL1_KEY,N':',LEN(CONCAT(s.LVL2_KEY,N'#')),N':',s.LVL2_KEY,N':',LEN(CONCAT(s.LVL3_KEY,N'#')),N':',s.LVL3_KEY,N':') AS ParentPostingKey, d.SRCE_KEY AS TransactionSourceKey, d.LVL1_KEY AS TransactionLevel1Key, d.LVL2_KEY AS TransactionLevel2Key, d.LVL3_KEY AS TransactionLevel3Key, s.SRCE_KEY AS PostingSourceKey, s.LVL1_KEY AS PostingLevel1Key, s.LVL2_KEY AS PostingLevel2Key, s.LVL3_KEY AS PostingLevel3Key, COALESCE(NULLIF(LTRIM(RTRIM(d.TRN_DESC)),N''),N'Posted transaction') AS TransactionDescription, p.PROJ_ID AS ProjectCode, s.COMPANY_ID AS CompanyCode, s.FY_CD AS FiscalYear, s.PD_NO AS FiscalPeriod, s.SUB_PD_NO AS FiscalSubperiod, c.SUB_PD_END_DT AS FiscalSubperiodEnd, s.ACCT_ID AS AccountCode, a.ACCT_NAME AS CurrentAccountName, s.ORG_ID AS OrganizationCode, o.ORG_NAME AS CurrentOrganizationName, s.S_JNL_CD AS JournalCode, s.POST_SEQ_NO AS PostingSequence, d.AMT AS FunctionalAmount, g.FUNC_S_CRNCY_CD AS CurrentFunctionalCurrency, d.TRN_AMT AS TransactionAmount, d.TRN_CRNCY_CD AS TransactionCurrency, d.VCHR_INVC_AMT AS VoucherInvoiceAmount, d.VCHR_INVC_CRNCY_CD AS VoucherInvoiceCurrency, d.INVC_ID AS InvoiceReference, d.VCHR_NO AS VoucherReference, d.PO_ID AS PurchaseOrderReference, d.JE_NO AS JournalEntryReference FROM GL_DETL d\nJOIN GL_POST_SUM s ON s.SRCE_KEY = d.GLPSUM_SRCE_KEY\n AND s.LVL1_KEY = d.GLPSUM_LVL1_KEY AND s.LVL2_KEY = d.GLPSUM_LVL2_KEY\n AND s.LVL3_KEY = d.GLPSUM_LVL3_KEY AND s.COMPANY_ID = d.COMPANY_ID\nJOIN PROJ p ON p.PROJ_ID = s.PROJ_ID AND p.COMPANY_ID = s.COMPANY_ID\nLEFT JOIN SUB_PD c ON c.FY_CD = s.FY_CD AND c.PD_NO = s.PD_NO AND c.SUB_PD_NO = s.SUB_PD_NO\nLEFT JOIN ORG o ON o.ORG_ID = s.ORG_ID AND o.COMPANY_ID = s.COMPANY_ID\nLEFT JOIN ACCT a ON a.ACCT_ID = s.ACCT_ID\nLEFT JOIN GL_CONFIG g ON g.COMPANY_ID = s.COMPANY_ID\nWHERE p.PROJ_ID = :project AND p.COMPANY_ID = :company\n AND s.SRCE_KEY = :source AND s.LVL1_KEY = :level1\n AND s.LVL2_KEY = :level2 AND s.LVL3_KEY = :level3\n AND s.FY_CD=:year AND s.PD_NO=:period AND s.SUB_PD_NO=:subperiod AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PROJ',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PROJ',N'U') AND OBJECT_ID(N'GL_POST_SUM',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_POST_SUM',N'U') AND OBJECT_ID(N'GL_DETL',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_DETL',N'U') AND OBJECT_ID(N'SUB_PD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SUB_PD',N'U') AND OBJECT_ID(N'ORG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORG',N'U') AND OBJECT_ID(N'ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ACCT',N'U') AND OBJECT_ID(N'GL_CONFIG',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.GL_CONFIG',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "FF7473B9-FE55-5415-ADC6-2621CBFB95A5",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "711E731F-BDBA-5308-96A2-0A6CC108A0FB",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "26820ED7-1DC8-5AE4-A028-C06ED8685BF8",
"title": "Posted ledger",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Project company (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FiscalSubperiodEnd",
"label": "Subperiod end date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_TYPE_DC",
"label": "Project type (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_MGR_NAME",
"label": "Manager name (recorded)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PostedRecordCount",
"label": "Posting records (subperiod)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ACTIVE_FL",
"label": "Active flag (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "6A62DF91-54C9-5058-B8D0-3E1C9847634C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "ProjectName",
"label": "Project name (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "ProjectCode",
"label": "Project code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Project company (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_LONG_NAME",
"label": "Extended name (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_TYPE_DC",
"label": "Project type (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "LVL_NO",
"label": "Project level (recorded)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_ABBRV_CD",
"label": "Project abbreviation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_MGR_NAME",
"label": "Manager name (recorded)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "CUST_ID",
"label": "Customer account (recorded)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "ORG_ID",
"label": "Owning organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "CurrentOrganizationName",
"label": "Owning organization (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current project and responsibility",
"detailRole": "information",
"isVisible": true,
"key": "ACCT_GRP_CD",
"label": "Project account group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded performance and charging",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_START_DT",
"label": "Performance start (recorded)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded performance and charging",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_END_DT",
"label": "Performance end (recorded)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded performance and charging",
"detailRole": "information",
"isVisible": true,
"key": "ACTIVE_FL",
"label": "Active flag (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded performance and charging",
"detailRole": "information",
"isVisible": true,
"key": "ALLOW_CHARGES_FL",
"label": "Allow charging (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded performance and charging",
"detailRole": "information",
"isVisible": true,
"key": "BILL_PROJ_FL",
"label": "Billable setup (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contract references and fiscal cohort",
"detailRole": "information",
"isVisible": true,
"key": "PRIME_CONTR_ID",
"label": "Prime contract reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contract references and fiscal cohort",
"detailRole": "information",
"isVisible": true,
"key": "SUBCTR_ID",
"label": "Subcontract reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contract references and fiscal cohort",
"detailRole": "information",
"isVisible": true,
"key": "CUST_PO_ID",
"label": "Customer PO reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contract references and fiscal cohort",
"detailRole": "information",
"isVisible": true,
"key": "NOTES",
"label": "Project notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contract references and fiscal cohort",
"detailRole": "information",
"isVisible": true,
"key": "FiscalYear",
"label": "Fiscal year",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contract references and fiscal cohort",
"detailRole": "information",
"isVisible": true,
"key": "FiscalPeriod",
"label": "Fiscal period",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract references and fiscal cohort",
"detailRole": "information",
"isVisible": true,
"key": "FiscalSubperiod",
"label": "Fiscal subperiod",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract references and fiscal cohort",
"detailRole": "information",
"isVisible": true,
"key": "FiscalSubperiodEnd",
"label": "Subperiod end date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contract references and fiscal cohort",
"detailRole": "information",
"isVisible": true,
"key": "PostedRecordCount",
"label": "Posting records (subperiod)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "6F881BA8-05A0-5A33-A46E-2AFB6D65F20C",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "AAB4E46B-18C5-5813-BF4B-987AD7D46B4F",
"includeAllOption": false,
"key": "FiscalSubperiodEnd",
"title": "Fiscal subperiod-end cohort",
"type": "date"
},
{
"id": "E8167923-A01B-5BCF-819A-5425F54440D2",
"includeAllOption": false,
"key": "COMPANY_ID",
"title": "Current project company",
"type": "text"
},
{
"id": "8E872D80-DD7B-599B-A963-45380D38A60A",
"includeAllOption": true,
"key": "ProjectCode",
"title": "Project code",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "CAAED3AD-E1EA-51E2-87D5-487C026FFC97",
"key": "FiscalSubperiodEnd",
"type": "date"
},
{
"direction": "ascending",
"id": "E5677A13-2E89-5254-8E59-E6BF83E6CBDF",
"key": "ProjectName",
"type": "text"
},
{
"direction": "ascending",
"id": "8B794BBC-B6C8-5562-A475-98A0AF90EA33",
"key": "ProjectPeriodKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ProjectCode",
"systemImage": "folder",
"title": "Project fiscal dossier",
"titleKey": "ProjectName"
},
{
"actions": [
{
"id": "1BF5102B-E275-5181-957C-0FAED21BD079",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "E763EEB5-9B83-5F9B-ACA9-E34BA6D56445",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "3F0CC7D1-F811-54DE-8DBF-57EED620C86E",
"title": "Transactions",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FiscalSubperiodEnd",
"label": "Subperiod end date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountCode",
"label": "Account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrganizationCode",
"label": "Posting organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "JournalCode",
"label": "Journal code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FunctionalAmount",
"label": "Posting amount (functional)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrentFunctionalCurrency",
"label": "Functional currency (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "26820ED7-1DC8-5AE4-A028-C06ED8685BF8",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Posted record — not a project-cost total",
"detailRole": "information",
"isVisible": true,
"key": "PostingTitle",
"label": "Account / fiscal context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posted record — not a project-cost total",
"detailRole": "information",
"isVisible": true,
"key": "ProjectName",
"label": "Project name (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posted record — not a project-cost total",
"detailRole": "information",
"isVisible": true,
"key": "ProjectCode",
"label": "Project code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posted record — not a project-cost total",
"detailRole": "information",
"isVisible": true,
"key": "CompanyCode",
"label": "Posting company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posted record — not a project-cost total",
"detailRole": "information",
"isVisible": true,
"key": "JournalCode",
"label": "Journal code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posted record — not a project-cost total",
"detailRole": "information",
"isVisible": true,
"key": "PostingSequence",
"label": "Posting sequence reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fiscal subperiod cohort",
"detailRole": "information",
"isVisible": true,
"key": "FiscalYear",
"label": "Fiscal year",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Fiscal subperiod cohort",
"detailRole": "information",
"isVisible": true,
"key": "FiscalPeriod",
"label": "Fiscal period",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fiscal subperiod cohort",
"detailRole": "information",
"isVisible": true,
"key": "FiscalSubperiod",
"label": "Fiscal subperiod",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fiscal subperiod cohort",
"detailRole": "information",
"isVisible": true,
"key": "FiscalSubperiodEnd",
"label": "Subperiod end date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Account and organization",
"detailRole": "information",
"isVisible": true,
"key": "AccountCode",
"label": "Account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Account and organization",
"detailRole": "information",
"isVisible": true,
"key": "CurrentAccountName",
"label": "Current account name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Account and organization",
"detailRole": "information",
"isVisible": true,
"key": "OrganizationCode",
"label": "Posting organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Account and organization",
"detailRole": "information",
"isVisible": true,
"key": "CurrentOrganizationName",
"label": "Organization name (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored functional posting value",
"detailRole": "information",
"isVisible": true,
"key": "FunctionalAmount",
"label": "Posting amount (functional)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored functional posting value",
"detailRole": "information",
"isVisible": true,
"key": "CurrentFunctionalCurrency",
"label": "Functional currency (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "3DD92625-D145-5B7B-911D-513BC758E41F",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "CAAED3AD-E1EA-51E2-87D5-487C026FFC97",
"key": "FiscalSubperiodEnd",
"type": "date"
},
{
"direction": "ascending",
"id": "AF6211CE-AA81-5D06-A0D9-8FFEFABDD891",
"key": "PostingKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountCode",
"systemImage": "doc.text",
"title": "Project posted ledger",
"titleKey": "PostingTitle"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountCode",
"label": "Account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrganizationCode",
"label": "Posting organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "JournalCode",
"label": "Journal code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransactionAmount",
"label": "Amount (transaction currency)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransactionCurrency",
"label": "Transaction currency (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceReference",
"label": "Invoice reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "3F0CC7D1-F811-54DE-8DBF-57EED620C86E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded transaction and references",
"detailRole": "information",
"isVisible": true,
"key": "TransactionDescription",
"label": "Transaction description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded transaction and references",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceReference",
"label": "Invoice reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded transaction and references",
"detailRole": "information",
"isVisible": true,
"key": "VoucherReference",
"label": "Voucher reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded transaction and references",
"detailRole": "information",
"isVisible": true,
"key": "PurchaseOrderReference",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded transaction and references",
"detailRole": "information",
"isVisible": true,
"key": "JournalEntryReference",
"label": "Journal entry reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Functional context — do not add to transaction value",
"detailRole": "information",
"isVisible": true,
"key": "FunctionalAmount",
"label": "Transaction value (functional)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Functional context — do not add to transaction value",
"detailRole": "information",
"isVisible": true,
"key": "CurrentFunctionalCurrency",
"label": "Functional currency (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded transaction context",
"detailRole": "information",
"isVisible": true,
"key": "TransactionAmount",
"label": "Amount (transaction currency)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded transaction context",
"detailRole": "information",
"isVisible": true,
"key": "TransactionCurrency",
"label": "Transaction currency (stored)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded voucher-invoice context",
"detailRole": "information",
"isVisible": true,
"key": "VoucherInvoiceAmount",
"label": "Amount (voucher-invoice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded voucher-invoice context",
"detailRole": "information",
"isVisible": true,
"key": "VoucherInvoiceCurrency",
"label": "Voucher-invoice currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent posting account and organization",
"detailRole": "information",
"isVisible": true,
"key": "ProjectCode",
"label": "Project code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent posting account and organization",
"detailRole": "information",
"isVisible": true,
"key": "CompanyCode",
"label": "Posting / transaction company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent posting account and organization",
"detailRole": "information",
"isVisible": true,
"key": "AccountCode",
"label": "Account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent posting account and organization",
"detailRole": "information",
"isVisible": true,
"key": "CurrentAccountName",
"label": "Current account name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent posting account and organization",
"detailRole": "information",
"isVisible": true,
"key": "OrganizationCode",
"label": "Posting organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent posting account and organization",
"detailRole": "information",
"isVisible": true,
"key": "CurrentOrganizationName",
"label": "Organization name (current)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent fiscal subperiod — not transaction date",
"detailRole": "information",
"isVisible": true,
"key": "FiscalYear",
"label": "Fiscal year",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent fiscal subperiod — not transaction date",
"detailRole": "information",
"isVisible": true,
"key": "FiscalPeriod",
"label": "Fiscal period",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Parent fiscal subperiod — not transaction date",
"detailRole": "information",
"isVisible": true,
"key": "FiscalSubperiod",
"label": "Fiscal subperiod",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Parent fiscal subperiod — not transaction date",
"detailRole": "information",
"isVisible": true,
"key": "FiscalSubperiodEnd",
"label": "Subperiod end date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Parent fiscal subperiod — not transaction date",
"detailRole": "information",
"isVisible": true,
"key": "JournalCode",
"label": "Journal code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent fiscal subperiod — not transaction date",
"detailRole": "information",
"isVisible": true,
"key": "PostingSequence",
"label": "Posting sequence reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "C2C09EB0-8D78-58D2-BE62-5F48597308E1",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "CAAED3AD-E1EA-51E2-87D5-487C026FFC97",
"key": "FiscalSubperiodEnd",
"type": "date"
},
{
"direction": "ascending",
"id": "E090F16D-50C3-5228-91D7-2B1CBABB3A9D",
"key": "TransactionKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "InvoiceReference",
"systemImage": "doc.text",
"title": "Posted transactions",
"titleKey": "TransactionDescription"
}
],
"relations": [
{
"childDatasetID": "26820ED7-1DC8-5AE4-A028-C06ED8685BF8",
"childKey": "ParentProjectPeriodKey",
"id": "711E731F-BDBA-5308-96A2-0A6CC108A0FB",
"name": "Posted ledger",
"parentDatasetID": "6A62DF91-54C9-5058-B8D0-3E1C9847634C",
"parentKey": "ProjectPeriodKey"
},
{
"childDatasetID": "3F0CC7D1-F811-54DE-8DBF-57EED620C86E",
"childKey": "ParentPostingKey",
"id": "E763EEB5-9B83-5F9B-ACA9-E34BA6D56445",
"name": "Transactions",
"parentDatasetID": "26820ED7-1DC8-5AE4-A028-C06ED8685BF8",
"parentKey": "PostingKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Deltek Costpoint",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-08T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For project managers, controllers and accountants: choose the current project company and a fiscal subperiod-end cohort, inspect project responsibility, performance dates, charging setup and contract references, then open Posted ledger and the selected posting’s Transactions on demand. Keep functional, transaction and voucher currency contexts separate while investigating recorded project accounting.\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, three live lists, two lazy nested relations, 26 project/context values, 16 posting/context values and 23 transaction values. No automatic refresh. Mandatory native company and subperiod-end period selection, plus optional project, precede bounded root reads. Root is one project per fiscal year/period/subperiod with posted records, enriched by the CURRENT project master. The same project appears separately for multiple subperiods. Unposted projects and undated/missing-calendar cohorts are NOT listed; their absence is NOT proof of no activity. Date filtering uses the ACTUAL SUB_PD_END_DT with start inclusive and end exclusive, NOT project performance or posting dates. Root SQL has no opening parameters, permitting cold native distinct-option discovery. Children bind project/company AND the exact year/period/subperiod before the limit; Transactions additionally binds all four posting keys. The posting record count belongs only to this fiscal cohort, not all-time project activity or transaction-line count. Calendar end is NOT document, entry, transaction or posting day; fiscal periods need not be calendar months. No frozen/as-of snapshot or complete current master catalogue is promised.\n\nPhysical project identity is the full global PROJ_ID, not a fabricated project+company PK. Report row identity is derived project PLUS the complete fiscal triple, not the physical PROJ key. Company is separately required scope. Children bind the selected project AND company before the read limit. Current project company and optional organization text are NOT certified historical ownership after reassignment. Manager name is read directly: a non-employee manager does not remove the project. Raw Active, Allow Charging and Billable setup flags stay distinct native values. Active relates to charging purposes, not an authorization grant or complete work status. Billable setup is not proof of actual billability, invoices or revenue. Recorded performance dates are user-maintained, not legal contract validation. Customer/contract references and notes are not reconstructed document histories.\n\nPROJ → GL_POST_SUM → GL_DETL uses all four physical posting keys and the detail’s four GLPSUM foreign-key columns. GL_DETL has no project column. Each detail retains its OWN four-key identity; repeated invoice, journal or posting sequence references are not identities. Posting and detail company must agree, as must current project scope. Orphans and mismatched scopes do not borrow another record. Current ORG/ACCT/GL_CONFIG masters are optional; missing names or currency stay unknown and do not remove an otherwise scoped transaction. SUB_PD uses the full year/period/subperiod triple and has no company column. Internal keys remain hidden and are not searchable.\n\nGL_POST_SUM.AMT is the stored functional posting value. Detail AMT is functional, TRN_AMT uses its recorded TRN_CRNCY_CD, and VCHR_INVC_AMT uses its own voucher-invoice currency. Functional currency is CURRENT GL_CONFIG.FUNC_S_CRNCY_CD for that company; verify historical denomination and actual mappings before financial use. No guessed USD, monetary symbol, FX conversion, NULL-to-zero, ABS or sum of posting and detail values. Zero, negative and reversal rows remain. Do not add functional, transactional and voucher-invoice values: they are separate contexts, not extra charges. This is general posted GL activity, NOT exclusively expenses, complete project costs, burden/revenue totals, budget, profit, cash flow or a certified reconciliation.\n\nNo PROJ_SUM snapshot sums or PROJ/PROJ_MOD financial values are included: their selected 8.1 currency roles are not certified. PTD/YTD snapshots are not independent deltas. Ledger processing and summarization can affect available history; absent rows do not establish completeness. Newer 2026.2 columns are not backported into 8.1. Physical evidence is frozen official 8.1.0 Transaction Schema plus separate project, fiscal-calendar, posting and functional/transaction-currency help. AMT roles are corroborated by process and UI, not a deployed SQL mapping certificate. Oracle type spellings are NOT Microsoft SQL Server DDL or proof of current 2026 compatibility.\n\nExplicit SELECT excludes employee IDs, generic person NAME/ID, authentication fields, audit users, timestamps and document paths. Project/transaction notes and business references can be confidential: use dedicated least-privilege SELECT access approved by the administrator for these exact rows and fields. Direct SQL does NOT inherit Costpoint project/org/company roles, masking or ITAR/EAR controls. Opening filters are NOT ACLs. No source credentials, cached business rows, real people or source host details are bundled. Public capture material must be wholly fictional DEMO. No dbo owner assumption, Deltek Cloud direct SQL access, sa/sysadmin, DDL, writes or financial updates. Default-schema object checks reject ambiguous lookup but do not prove the intended database. Pass compatibility/read tests, confirm actual schema, full keys, currency meanings, scope, privacy and timings. Up to 1,000 rows per list; option discovery and reads can be limited, loaded search is local. Root fiscal grouping may scan substantial GL history even for a short selected period; confirm real query plans and approved reporting indexes/views with the administrator. No completeness, real-time or performance guarantee. Not tested on a real ERP or SQL Server. Documentary/synthetic tests and native DEMO do not prove deployed compatibility. Unofficial, not affiliated with Deltek.\n\nPhysical dictionary: https://help.deltek.com/product/Costpoint/Documentation/81DataDictionary.html\nProject setup: https://help.deltek.com/Product/Costpoint/8.1/GA/PJMBASIC_Basic_Info_Tab.html\nGL currency process: https://help.deltek.com/Product/Costpoint/8.1/GA/PJPALCST.html\nGL transactions: https://help.deltek.com/Product/Costpoint/8.1/GA/GLQINQ_Transactions_Subtask.html\nFiscal calendar: https://help.deltek.com/Product/Costpoint/8.1/GA/GLMSUBPD_Contents_of_the_Manage_Subperiods_Screen.html",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "1D3402A1-564C-57AD-9157-AE09F3017588",
"rootButtonCount": 1,
"summary": "Fiscal project cohorts with current dossier, posting counts and lazy ledger/transactions, with three separate currency contexts.",
"tags": [
"Deltek Costpoint",
"SQL Server",
"Projects",
"Accounting",
"General ledger",
"Pro"
],
"title": "Project fiscal dossier — posted ledger and transactions Pro"
}
}