Supplier invoice approvals — project cost allocations Pro
Period/company to supplier invoice approvals, amount/currency, payment instructions and on-demand project cost allocations.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For finance, project managers and purchasing teams: select a supplier-invoice period and approval company, find an invoice, inspect its approval status and invoice amount/currency, payment instructions, submission and stored voucher references. Open its project cost allocations on demand with project/phase/task, expense and account codes, line net and total amounts.
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, two lists and one relation; 21 invoice/approval values and 18 allocation values in grouped Details. Technical MasterPKey and the complete MasterPKey+PKey allocation identity are hidden. Choose a native invoice period (start/end-exclusive) and mandatory approval company before the root read. Status is optional. Opening predicates are applied by the native SQL connector before the bounded read; the root projection has no TOP, LIMIT or unresolved parameters. An invoice with no InvoiceDate is excluded by a chosen date period. Allocation reads bind both the exact parent MasterPKey and recorded company, never invoice or vendor number alone. Each list has a 2,000-row maximum, no scheduled refresh and may be incomplete. Local search/filtering affects loaded rows only. A row limit is not a server performance guarantee; test query timings and source indexes.
These are AP Invoice Approval records and their project cost distribution, NOT a current payables aging report, complete supplier transaction history or proof of posted vouchers or executed payments. Cifru cannot submit, approve, reject, post or pay an invoice. Stored voucher number/date and diary references do not establish posting. Do not join approval records to LedgerAP via invoice number or voucher reference alone; the vendor UI link can fail after invoice number/date changes. PayTerms and the Date-only scheduled date are payment instructions, not a confirmed payment date. No current balance or calculated cross-invoice total is invented.
InvoiceAmount uses the recorded CurrencyCode. Blank/unknown currency remains unknown, without a company-currency fallback or exchange-rate conversion. Allocation Amount and NetAmount are the approval grid values; NetAmount excludes tax and Amount includes the configured tax context. Parent invoice currency is shown separately, not a historic ledger conversion certificate; confirm the installed tax/currency behavior in the real preview. Approval status description is looked up using the complete Code+en-US culture key. Missing/blank descriptions retain Code plus the original value; unknown payment/routing codes are not decoded as normal states. Only the documented EM routing option can display the current route-to employee name. The contradictory 2025.1 RouteToOrg definition is not used to invent an organization/employee join; this dossier does not expose a full workflow timeline or approver hierarchy.
Vendor name is current master enrichment only when exactly one Clendor row has the vendor number. Ambiguous or absent vendor mappings remain blank; invoices are not removed or multiplied. Current project and phase names use unambiguous blank-lower-level PR records, and task name uses the full WBS1+WBS2+WBS3 identity. Names may change after invoice entry, and missing names do not remove allocation lines. Liability, address, expense and diary values are stored business references, not guessed full account/address records. No bank-account, tax, authentication, home-address, medical or audit fields are projected.
Physical names/types/nullability/keys use the official Vantagepoint 2025.1 dictionary; AP approval UI meanings come separately from official 7.2 help. Cross-version context is not a certificate for the installed edition. Use only an administrator-authorized on-premises SQL Server database with a dedicated least-privilege SELECT account. Confirm database, default schema, object resolution, projected columns, keys, company/record permissions and timing. A default-schema object-identity guard refuses mismatched resolution; empty results can mean a guard failure, not absent invoices. Direct SQL does NOT inherit Vantagepoint roles, active-company or confidentiality restrictions. The mandatory opening company filter is NOT an SQL access-control boundary. Complete the real Cifru read/compatibility test and inspect a real preview before use. Do not use sa/sysadmin, and do not execute administrative examples in the manuals. No Deltek Cloud direct SQL access is promised.
Not tested on a real ERP or SQL Server. SQLite query-adapter tests and native fictional DEMO captures do not prove installed compatibility. Package contains no credentials, real server address, business rows, executable code or vendor documents. Unofficial and not affiliated with Deltek.
Physical dictionary: https://help.deltek.com/product/Vantagepoint/2025.1/DataDictionary/index.htm
AP approval context (7.2): https://help.deltek.com/Product/Vantagepoint/7.2/TransCenter_Contents_AP_Inv_Approvals_Form.html
Approval/voucher boundary (7.2): https://help.deltek.com/product/Vantagepoint/7.2/st_dashboards_ap_detail_dashpart_base_columns.html
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Supplier invoice approvals
- Details: Project cost allocations
- Sub-button: Project cost allocations
Sources are mapped locally and verified before applying.
Custom queriesPRO2 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 p.MasterPKey AS MasterPKey, p.ApprovalID AS ApprovalID, p.Invoice AS Invoice, p.InvoiceDate AS InvoiceDate, p.Vendor AS Vendor, v.VendorName AS VendorName, p.InvoiceAmount AS InvoiceAmount, p.CurrencyCode AS CurrencyCode, CASE WHEN NULLIF(LTRIM(RTRIM(st.Description)),N'') IS NOT NULL THEN st.Description ELSE CONCAT(N'Code ',p.Status) END AS Status, p.Company AS Company, co.FirmName AS CompanyName, CASE p.PayTerms WHEN N'Date' THEN N'Scheduled date' WHEN N'Hold' THEN N'On hold' WHEN N'PWP' THEN N'Pay when paid' WHEN N'Next' THEN N'Next payment run' ELSE CASE WHEN p.PayTerms IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.PayTerms)) END END AS PayTerms, CASE WHEN p.PayTerms=N'Date' THEN p.PayDate ELSE NULL END AS PayDate, p.LiabCode AS LiabCode, p.Address AS Address, CASE p.RouteType WHEN N'EM' THEN N'Employee' WHEN N'ORG' THEN N'Organization' ELSE CASE WHEN p.RouteType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.RouteType)) END END AS RouteType, CASE WHEN p.RouteType=N'EM' THEN NULLIF(LTRIM(RTRIM(CONCAT(rte.FirstName,N' ',rte.LastName))),N'') ELSE NULL END AS RouteEmployeeName, NULLIF(LTRIM(RTRIM(CONCAT(sub.FirstName,N' ',sub.LastName))),N'') AS SubmittedByName, p.SubmittedDate AS SubmittedDate, p.opNextVoucherNumber AS VoucherNumberReference, p.opVoucherDate AS VoucherDateReference, p.opDiary AS DiaryCode FROM APApprovalMaster p LEFT JOIN CFGAPApprovalStatusDescriptions st ON st.Code=p.Status AND st.UICultureName=N'en-US' LEFT JOIN EMMain rte ON rte.Employee=p.RouteToEmployee LEFT JOIN EMMain sub ON sub.Employee=p.SubmittedBy LEFT JOIN (SELECT Vendor,MAX(Name) AS VendorName FROM Clendor WHERE NULLIF(LTRIM(RTRIM(Vendor)),N'') IS NOT NULL GROUP BY Vendor HAVING COUNT(*)=1) v ON v.Vendor=p.Vendor LEFT JOIN CFGMainData co ON co.Company=p.Company WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'APApprovalMaster',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.APApprovalMaster',N'U') AND OBJECT_ID(N'APApprovalWBS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.APApprovalWBS',N'U') AND OBJECT_ID(N'CFGAPApprovalStatusDescriptions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGAPApprovalStatusDescriptions',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U') AND OBJECT_ID(N'Clendor',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Clendor',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT p.MasterPKey AS MasterPKey, CONCAT(DATALENGTH(d.MasterPKey),N':',d.MasterPKey,N':',DATALENGTH(d.PKey),N':',d.PKey) AS AllocationKey, d.Description AS Description, d.Seq AS Seq, d.WBS1 AS ProjectNumber, prj.ProjectName AS ProjectName, d.WBS2 AS PhaseNumber, pha.PhaseName AS PhaseName, d.WBS3 AS TaskNumber, tsk.Name AS TaskName, d.ExpenseCode AS ExpenseCode, d.Account AS Account, d.NetAmount AS NetAmount, d.Amount AS Amount, p.CurrencyCode AS CurrencyCode, p.ApprovalID AS ApprovalID, p.Invoice AS Invoice, p.Vendor AS Vendor, p.Company AS Company, co.FirmName AS CompanyName FROM APApprovalWBS d INNER JOIN APApprovalMaster p ON p.MasterPKey=d.MasterPKey LEFT JOIN (SELECT WBS1,MAX(Name) AS ProjectName FROM PR q WHERE NULLIF(LTRIM(RTRIM(q.WBS2)),N'') IS NULL AND NULLIF(LTRIM(RTRIM(q.WBS3)),N'') IS NULL GROUP BY WBS1 HAVING COUNT(*)=1) prj ON prj.WBS1=d.WBS1 LEFT JOIN (SELECT WBS1,WBS2,MAX(Name) AS PhaseName FROM PR q WHERE NOT (NULLIF(LTRIM(RTRIM(q.WBS2)),N'') IS NULL) AND NULLIF(LTRIM(RTRIM(q.WBS3)),N'') IS NULL GROUP BY WBS1,WBS2 HAVING COUNT(*)=1) pha ON pha.WBS1=d.WBS1 AND pha.WBS2=d.WBS2 LEFT JOIN PR tsk ON tsk.WBS1=d.WBS1 AND tsk.WBS2=d.WBS2 AND tsk.WBS3=d.WBS3 AND NOT (NULLIF(LTRIM(RTRIM(d.WBS3)),N'') IS NULL) LEFT JOIN CFGMainData co ON co.Company=p.Company WHERE p.MasterPKey=:approval_id AND p.Company=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'APApprovalMaster',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.APApprovalMaster',N'U') AND OBJECT_ID(N'APApprovalWBS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.APApprovalWBS',N'U') AND OBJECT_ID(N'CFGAPApprovalStatusDescriptions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGAPApprovalStatusDescriptions',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U') AND OBJECT_ID(N'Clendor',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Clendor',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Vantagepoint — authorised SQL Server database",
"id": "EDFEFB18-637B-5C62-953E-6A92CE9EA0B7",
"kind": "sqlServer",
"requiredObjects": [
"APApprovalMaster",
"APApprovalWBS",
"CFGAPApprovalStatusDescriptions",
"CFGMainData",
"Clendor",
"EMMain",
"PR"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "4F735011-E033-5589-BF51-40D6F11DA441",
"key": "InvoiceDate",
"type": "date"
},
{
"direction": "ascending",
"id": "CA071827-39BF-5681-8884-6E2FE9A3995A",
"key": "MasterPKey",
"type": "text"
}
],
"id": "691E1AF3-3A54-51FE-84AC-CFFB87771D27",
"mappings": [
{
"commonFieldKey": "",
"key": "MasterPKey",
"label": "Internal MasterPKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MasterPKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ApprovalID",
"label": "Approval reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ApprovalID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Invoice",
"label": "Supplier invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Invoice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceDate",
"label": "Supplier invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Vendor",
"label": "Vendor number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Vendor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorName",
"label": "Current vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceAmount",
"label": "Invoice amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Invoice currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Status",
"label": "Approval status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Company",
"label": "Approval company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Company",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyName",
"label": "Company name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PayTerms",
"label": "Payment instruction",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PayTerms",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PayDate",
"label": "Scheduled date — Date terms only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PayDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LiabCode",
"label": "Liability code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LiabCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Address",
"label": "Vendor address reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Address",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RouteType",
"label": "Routing lookup type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RouteType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RouteEmployeeName",
"label": "Route-to employee — EM only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RouteEmployeeName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SubmittedByName",
"label": "Submitted by",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SubmittedByName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SubmittedDate",
"label": "Submitted for approval",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SubmittedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VoucherNumberReference",
"label": "Stored voucher reference — not proof of posting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VoucherNumberReference",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VoucherDateReference",
"label": "Stored voucher date reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VoucherDateReference",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiaryCode",
"label": "Stored diary code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DiaryCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Supplier invoice approvals",
"primaryKey": "MasterPKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ApprovalID",
"Invoice",
"InvoiceDate",
"Vendor",
"VendorName",
"InvoiceAmount",
"CurrencyCode",
"Status",
"Company",
"CompanyName",
"PayTerms",
"PayDate",
"LiabCode",
"Address",
"RouteType",
"RouteEmployeeName",
"SubmittedByName",
"SubmittedDate",
"VoucherNumberReference",
"VoucherDateReference",
"DiaryCode"
],
"sourceID": "EDFEFB18-637B-5C62-953E-6A92CE9EA0B7",
"sqlQuery": "SELECT p.MasterPKey AS MasterPKey, p.ApprovalID AS ApprovalID, p.Invoice AS Invoice, p.InvoiceDate AS InvoiceDate, p.Vendor AS Vendor, v.VendorName AS VendorName, p.InvoiceAmount AS InvoiceAmount, p.CurrencyCode AS CurrencyCode, CASE WHEN NULLIF(LTRIM(RTRIM(st.Description)),N'') IS NOT NULL THEN st.Description ELSE CONCAT(N'Code ',p.Status) END AS Status, p.Company AS Company, co.FirmName AS CompanyName, CASE p.PayTerms WHEN N'Date' THEN N'Scheduled date' WHEN N'Hold' THEN N'On hold' WHEN N'PWP' THEN N'Pay when paid' WHEN N'Next' THEN N'Next payment run' ELSE CASE WHEN p.PayTerms IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.PayTerms)) END END AS PayTerms, CASE WHEN p.PayTerms=N'Date' THEN p.PayDate ELSE NULL END AS PayDate, p.LiabCode AS LiabCode, p.Address AS Address, CASE p.RouteType WHEN N'EM' THEN N'Employee' WHEN N'ORG' THEN N'Organization' ELSE CASE WHEN p.RouteType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.RouteType)) END END AS RouteType, CASE WHEN p.RouteType=N'EM' THEN NULLIF(LTRIM(RTRIM(CONCAT(rte.FirstName,N' ',rte.LastName))),N'') ELSE NULL END AS RouteEmployeeName, NULLIF(LTRIM(RTRIM(CONCAT(sub.FirstName,N' ',sub.LastName))),N'') AS SubmittedByName, p.SubmittedDate AS SubmittedDate, p.opNextVoucherNumber AS VoucherNumberReference, p.opVoucherDate AS VoucherDateReference, p.opDiary AS DiaryCode FROM APApprovalMaster p LEFT JOIN CFGAPApprovalStatusDescriptions st ON st.Code=p.Status AND st.UICultureName=N'en-US' LEFT JOIN EMMain rte ON rte.Employee=p.RouteToEmployee LEFT JOIN EMMain sub ON sub.Employee=p.SubmittedBy LEFT JOIN (SELECT Vendor,MAX(Name) AS VendorName FROM Clendor WHERE NULLIF(LTRIM(RTRIM(Vendor)),N'') IS NOT NULL GROUP BY Vendor HAVING COUNT(*)=1) v ON v.Vendor=p.Vendor LEFT JOIN CFGMainData co ON co.Company=p.Company WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'APApprovalMaster',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.APApprovalMaster',N'U') AND OBJECT_ID(N'APApprovalWBS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.APApprovalWBS',N'U') AND OBJECT_ID(N'CFGAPApprovalStatusDescriptions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGAPApprovalStatusDescriptions',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U') AND OBJECT_ID(N'Clendor',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Clendor',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "C41BC1DC-58C0-5484-9B4F-761508B65012",
"key": "Seq",
"type": "number"
},
{
"direction": "ascending",
"id": "05298CA0-52AE-5059-A69C-ACE2FC4F7EFD",
"key": "AllocationKey",
"type": "text"
}
],
"id": "7D4134D8-6E08-501D-B826-EAEE66E864D4",
"mappings": [
{
"commonFieldKey": "",
"key": "MasterPKey",
"label": "Internal MasterPKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MasterPKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocationKey",
"label": "Internal AllocationKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AllocationKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Allocation description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Seq",
"label": "Grid sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Seq",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProjectNumber",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjectNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProjectName",
"label": "Current project name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjectName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PhaseNumber",
"label": "Phase number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PhaseNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PhaseName",
"label": "Current phase name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PhaseName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TaskNumber",
"label": "Task number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TaskNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TaskName",
"label": "Current task name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TaskName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ExpenseCode",
"label": "Expense code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ExpenseCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Account",
"label": "Allocation account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Account",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "NetAmount",
"label": "Net — excludes tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NetAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Amount",
"label": "Total — includes tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Amount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Invoice currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ApprovalID",
"label": "Approval reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ApprovalID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Invoice",
"label": "Supplier invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Invoice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Vendor",
"label": "Vendor number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Vendor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Company",
"label": "Approval company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Company",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyName",
"label": "Company name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Project cost allocations",
"primaryKey": "AllocationKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "MasterPKey",
"id": "6047B207-9AF0-58FA-85C1-B8B5D37EEA50",
"name": "approval_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "Company",
"id": "E3F7E248-BA6A-5F5B-B82A-E2ED0615D59E",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Description",
"Seq",
"ProjectNumber",
"ProjectName",
"PhaseNumber",
"PhaseName",
"TaskNumber",
"TaskName",
"ExpenseCode",
"Account",
"NetAmount",
"Amount",
"CurrencyCode",
"ApprovalID",
"Invoice",
"Vendor",
"Company",
"CompanyName"
],
"sourceID": "EDFEFB18-637B-5C62-953E-6A92CE9EA0B7",
"sqlQuery": "SELECT p.MasterPKey AS MasterPKey, CONCAT(DATALENGTH(d.MasterPKey),N':',d.MasterPKey,N':',DATALENGTH(d.PKey),N':',d.PKey) AS AllocationKey, d.Description AS Description, d.Seq AS Seq, d.WBS1 AS ProjectNumber, prj.ProjectName AS ProjectName, d.WBS2 AS PhaseNumber, pha.PhaseName AS PhaseName, d.WBS3 AS TaskNumber, tsk.Name AS TaskName, d.ExpenseCode AS ExpenseCode, d.Account AS Account, d.NetAmount AS NetAmount, d.Amount AS Amount, p.CurrencyCode AS CurrencyCode, p.ApprovalID AS ApprovalID, p.Invoice AS Invoice, p.Vendor AS Vendor, p.Company AS Company, co.FirmName AS CompanyName FROM APApprovalWBS d INNER JOIN APApprovalMaster p ON p.MasterPKey=d.MasterPKey LEFT JOIN (SELECT WBS1,MAX(Name) AS ProjectName FROM PR q WHERE NULLIF(LTRIM(RTRIM(q.WBS2)),N'') IS NULL AND NULLIF(LTRIM(RTRIM(q.WBS3)),N'') IS NULL GROUP BY WBS1 HAVING COUNT(*)=1) prj ON prj.WBS1=d.WBS1 LEFT JOIN (SELECT WBS1,WBS2,MAX(Name) AS PhaseName FROM PR q WHERE NOT (NULLIF(LTRIM(RTRIM(q.WBS2)),N'') IS NULL) AND NULLIF(LTRIM(RTRIM(q.WBS3)),N'') IS NULL GROUP BY WBS1,WBS2 HAVING COUNT(*)=1) pha ON pha.WBS1=d.WBS1 AND pha.WBS2=d.WBS2 LEFT JOIN PR tsk ON tsk.WBS1=d.WBS1 AND tsk.WBS2=d.WBS2 AND tsk.WBS3=d.WBS3 AND NOT (NULLIF(LTRIM(RTRIM(d.WBS3)),N'') IS NULL) LEFT JOIN CFGMainData co ON co.Company=p.Company WHERE p.MasterPKey=:approval_id AND p.Company=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'APApprovalMaster',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.APApprovalMaster',N'U') AND OBJECT_ID(N'APApprovalWBS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.APApprovalWBS',N'U') AND OBJECT_ID(N'CFGAPApprovalStatusDescriptions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGAPApprovalStatusDescriptions',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U') AND OBJECT_ID(N'Clendor',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Clendor',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "F1C62159-CD32-5820-BB71-50D0DF2CECA4",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "BF001CC2-330B-5FD2-B860-840666E4A991",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "7D4134D8-6E08-501D-B826-EAEE66E864D4",
"title": "Project cost allocations",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Supplier invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAmount",
"label": "Invoice amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Invoice currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Approval status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CompanyName",
"label": "Company name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ApprovalID",
"label": "Approval reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PayTerms",
"label": "Payment instruction",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SubmittedDate",
"label": "Submitted for approval",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "691E1AF3-3A54-51FE-84AC-CFFB87771D27",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Invoice and approval",
"detailRole": "information",
"isVisible": true,
"key": "Invoice",
"label": "Supplier invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and approval",
"detailRole": "information",
"isVisible": true,
"key": "VendorName",
"label": "Current vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and approval",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Supplier invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Invoice and approval",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAmount",
"label": "Invoice amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Invoice and approval",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Invoice currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and approval",
"detailRole": "information",
"isVisible": true,
"key": "ApprovalID",
"label": "Approval reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and approval",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Approval status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and approval",
"detailRole": "information",
"isVisible": true,
"key": "CompanyName",
"label": "Company name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and approval",
"detailRole": "information",
"isVisible": true,
"key": "Company",
"label": "Approval company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and approval",
"detailRole": "information",
"isVisible": true,
"key": "Vendor",
"label": "Vendor number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment instructions — not execution",
"detailRole": "information",
"isVisible": true,
"key": "PayTerms",
"label": "Payment instruction",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment instructions — not execution",
"detailRole": "information",
"isVisible": true,
"key": "PayDate",
"label": "Scheduled date — Date terms only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Payment instructions — not execution",
"detailRole": "information",
"isVisible": true,
"key": "LiabCode",
"label": "Liability code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment instructions — not execution",
"detailRole": "information",
"isVisible": true,
"key": "Address",
"label": "Vendor address reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Routing and submission",
"detailRole": "information",
"isVisible": true,
"key": "RouteType",
"label": "Routing lookup type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Routing and submission",
"detailRole": "information",
"isVisible": true,
"key": "RouteEmployeeName",
"label": "Route-to employee — EM only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Routing and submission",
"detailRole": "information",
"isVisible": true,
"key": "SubmittedByName",
"label": "Submitted by",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Routing and submission",
"detailRole": "information",
"isVisible": true,
"key": "SubmittedDate",
"label": "Submitted for approval",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored voucher references — not proof of posting",
"detailRole": "information",
"isVisible": true,
"key": "VoucherNumberReference",
"label": "Stored voucher reference — not proof of posting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored voucher references — not proof of posting",
"detailRole": "information",
"isVisible": true,
"key": "VoucherDateReference",
"label": "Stored voucher date reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored voucher references — not proof of posting",
"detailRole": "information",
"isVisible": true,
"key": "DiaryCode",
"label": "Stored diary code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "6FAF2737-A976-5F4C-ADB6-D6E1530CFD0D",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "179D90B5-EFEF-5224-83F9-5FF4D3E68FEA",
"includeAllOption": false,
"key": "InvoiceDate",
"title": "Supplier invoice period",
"type": "date"
},
{
"id": "A7F52E16-7054-5B07-BCF2-DA18335D792D",
"includeAllOption": false,
"key": "Company",
"title": "Approval company",
"type": "text"
},
{
"id": "E0A70BD0-5122-5141-B015-F9B52CA555A7",
"includeAllOption": true,
"key": "Status",
"title": "Approval status",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "4F735011-E033-5589-BF51-40D6F11DA441",
"key": "InvoiceDate",
"type": "date"
},
{
"direction": "ascending",
"id": "CA071827-39BF-5681-8884-6E2FE9A3995A",
"key": "MasterPKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "VendorName",
"systemImage": "doc.text",
"title": "Supplier invoice approvals",
"titleKey": "Invoice"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProjectNumber",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProjectName",
"label": "Current project name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PhaseNumber",
"label": "Phase number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TaskNumber",
"label": "Task number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Account",
"label": "Allocation account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NetAmount",
"label": "Net — excludes tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Amount",
"label": "Total — includes tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Invoice currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "7D4134D8-6E08-501D-B826-EAEE66E864D4",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Cost distribution",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Allocation description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Cost distribution",
"detailRole": "information",
"isVisible": true,
"key": "Seq",
"label": "Grid sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cost distribution",
"detailRole": "information",
"isVisible": true,
"key": "NetAmount",
"label": "Net — excludes tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cost distribution",
"detailRole": "information",
"isVisible": true,
"key": "Amount",
"label": "Total — includes tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cost distribution",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Invoice currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Cost distribution",
"detailRole": "information",
"isVisible": true,
"key": "Account",
"label": "Allocation account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Cost distribution",
"detailRole": "information",
"isVisible": true,
"key": "ExpenseCode",
"label": "Expense code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project hierarchy — current names",
"detailRole": "information",
"isVisible": true,
"key": "ProjectNumber",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project hierarchy — current names",
"detailRole": "information",
"isVisible": true,
"key": "ProjectName",
"label": "Current project name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project hierarchy — current names",
"detailRole": "information",
"isVisible": true,
"key": "PhaseNumber",
"label": "Phase number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project hierarchy — current names",
"detailRole": "information",
"isVisible": true,
"key": "PhaseName",
"label": "Current phase name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project hierarchy — current names",
"detailRole": "information",
"isVisible": true,
"key": "TaskNumber",
"label": "Task number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project hierarchy — current names",
"detailRole": "information",
"isVisible": true,
"key": "TaskName",
"label": "Current task name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent invoice and company",
"detailRole": "information",
"isVisible": true,
"key": "Invoice",
"label": "Supplier invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent invoice and company",
"detailRole": "information",
"isVisible": true,
"key": "ApprovalID",
"label": "Approval reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent invoice and company",
"detailRole": "information",
"isVisible": true,
"key": "Vendor",
"label": "Vendor number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent invoice and company",
"detailRole": "information",
"isVisible": true,
"key": "CompanyName",
"label": "Company name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent invoice and company",
"detailRole": "information",
"isVisible": true,
"key": "Company",
"label": "Approval company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "E10DE01E-3266-5EF7-9702-A6E2E9CA6711",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "C41BC1DC-58C0-5484-9B4F-761508B65012",
"key": "Seq",
"type": "number"
},
{
"direction": "ascending",
"id": "05298CA0-52AE-5059-A69C-ACE2FC4F7EFD",
"key": "AllocationKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Account",
"systemImage": "doc.text",
"title": "Project cost allocations",
"titleKey": "Description"
}
],
"relations": [
{
"childDatasetID": "7D4134D8-6E08-501D-B826-EAEE66E864D4",
"childKey": "MasterPKey",
"id": "BF001CC2-330B-5FD2-B860-840666E4A991",
"name": "Project cost allocations",
"parentDatasetID": "691E1AF3-3A54-51FE-84AC-CFFB87771D27",
"parentKey": "MasterPKey"
}
],
"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 finance, project managers and purchasing teams: select a supplier-invoice period and approval company, find an invoice, inspect its approval status and invoice amount/currency, payment instructions, submission and stored voucher references. Open its project cost allocations on demand with project/phase/task, expense and account codes, line net and total amounts. \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, two lists and one relation; 21 invoice/approval values and 18 allocation values in grouped Details. Technical MasterPKey and the complete MasterPKey+PKey allocation identity are hidden. Choose a native invoice period (start/end-exclusive) and mandatory approval company before the root read. Status is optional. Opening predicates are applied by the native SQL connector before the bounded read; the root projection has no TOP, LIMIT or unresolved parameters. An invoice with no InvoiceDate is excluded by a chosen date period. Allocation reads bind both the exact parent MasterPKey and recorded company, never invoice or vendor number alone. Each list has a 2,000-row maximum, no scheduled refresh and may be incomplete. Local search/filtering affects loaded rows only. A row limit is not a server performance guarantee; test query timings and source indexes.\n\nThese are AP Invoice Approval records and their project cost distribution, NOT a current payables aging report, complete supplier transaction history or proof of posted vouchers or executed payments. Cifru cannot submit, approve, reject, post or pay an invoice. Stored voucher number/date and diary references do not establish posting. Do not join approval records to LedgerAP via invoice number or voucher reference alone; the vendor UI link can fail after invoice number/date changes. PayTerms and the Date-only scheduled date are payment instructions, not a confirmed payment date. No current balance or calculated cross-invoice total is invented.\n\nInvoiceAmount uses the recorded CurrencyCode. Blank/unknown currency remains unknown, without a company-currency fallback or exchange-rate conversion. Allocation Amount and NetAmount are the approval grid values; NetAmount excludes tax and Amount includes the configured tax context. Parent invoice currency is shown separately, not a historic ledger conversion certificate; confirm the installed tax/currency behavior in the real preview. Approval status description is looked up using the complete Code+en-US culture key. Missing/blank descriptions retain Code plus the original value; unknown payment/routing codes are not decoded as normal states. Only the documented EM routing option can display the current route-to employee name. The contradictory 2025.1 RouteToOrg definition is not used to invent an organization/employee join; this dossier does not expose a full workflow timeline or approver hierarchy.\n\nVendor name is current master enrichment only when exactly one Clendor row has the vendor number. Ambiguous or absent vendor mappings remain blank; invoices are not removed or multiplied. Current project and phase names use unambiguous blank-lower-level PR records, and task name uses the full WBS1+WBS2+WBS3 identity. Names may change after invoice entry, and missing names do not remove allocation lines. Liability, address, expense and diary values are stored business references, not guessed full account/address records. No bank-account, tax, authentication, home-address, medical or audit fields are projected.\n\nPhysical names/types/nullability/keys use the official Vantagepoint 2025.1 dictionary; AP approval UI meanings come separately from official 7.2 help. Cross-version context is not a certificate for the installed edition. Use only an administrator-authorized on-premises SQL Server database with a dedicated least-privilege SELECT account. Confirm database, default schema, object resolution, projected columns, keys, company/record permissions and timing. A default-schema object-identity guard refuses mismatched resolution; empty results can mean a guard failure, not absent invoices. Direct SQL does NOT inherit Vantagepoint roles, active-company or confidentiality restrictions. The mandatory opening company filter is NOT an SQL access-control boundary. Complete the real Cifru read/compatibility test and inspect a real preview before use. Do not use sa/sysadmin, and do not execute administrative examples in the manuals. No Deltek Cloud direct SQL access is promised.\n\nNot tested on a real ERP or SQL Server. SQLite query-adapter tests and native fictional DEMO captures do not prove installed compatibility. Package contains no credentials, real server address, business rows, executable code or vendor documents. Unofficial and not affiliated with Deltek.\n\nPhysical dictionary: https://help.deltek.com/product/Vantagepoint/2025.1/DataDictionary/index.htm\nAP approval context (7.2): https://help.deltek.com/Product/Vantagepoint/7.2/TransCenter_Contents_AP_Inv_Approvals_Form.html\nApproval/voucher boundary (7.2): https://help.deltek.com/product/Vantagepoint/7.2/st_dashboards_ap_detail_dashpart_base_columns.html",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "4EFD842D-5B40-5272-BC4F-E49DA03F80DA",
"rootButtonCount": 1,
"summary": "Period/company to supplier invoice approvals, amount/currency, payment instructions and on-demand project cost allocations.",
"tags": [
"Deltek Vantagepoint",
"SQL Server",
"Supplier invoices",
"Approval workflow",
"Project costs",
"Finance",
"Pro"
],
"title": "Supplier invoice approvals — project cost allocations Pro"
}
}