Payables and payment postings — current work Pro
Period/organization to AP/PP transactions, voucher/vendor references, recorded amount/currency and current work dossiers.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For finance, purchasing and project teams: choose a transaction period and organization, search voucher/vendor references, inspect posted accounts-payable and payment-processing detail with its recorded amount/currency, native transaction type, account, purchase-order and work references. Open the exact current project, phase or task record on demand for team, dates, estimated progress and notes.
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; 34 transaction values and 20 current work values in grouped Details. Complete LedgerAP Period+PostSeq+PKey identity is hidden but retained. Voucher, vendor, entry reference and voucher line number are useful business references, NOT row identities. Repeated references stay separate. Each list is bounded to 1,000 rows and may be incomplete; no scheduled refresh. Native opening period (inclusive start/exclusive end), mandatory transaction organization and optional transaction type are applied before the row cap. Undated transactions are excluded by a chosen period. Row caps do not guarantee server performance; verify query timing and indexes. Local filters/search affect loaded rows only.
These are posted LedgerAP AP/PP details, NOT AP approval records, supplier invoice headers, a complete voucher statement, remaining debt, payables aging, bank reconciliation or proof of a bank transfer. TransactionType PP is payment processing, not a promise that money has arrived. Native subtype distinguishes regular payment, AP disbursement, discount, tax/VAT and void check where documented. Unknown/blank type/subtype remains unknown; no guessed normal or paid status. TransactionAmount uses its recorded TransactionCurrencyCode with original sign and no fallback, conversion or cross-row total. Unknown currency stays blank. Source/payment-currency amounts, PartialPayment and Discount are not exposed without a certified currency context; no invented balance formula. Historical/SkipGL rows are not silently removed.
Vendor and OriginatingVendor are distinct recorded numbers; originating vendor applies when different from the vendor being paid. No supplier-name/address join is guessed from a blank Clendor.Vendor definition, and no historical master snapshot is asserted. BankCode is a stored lookup code, not account details or transfer execution. PONumber is a reference, not a guaranteed purchase-header identity or delivered quantity. LedgerAP.Invoice has a contradictory cash-receipt definition and is deliberately excluded rather than presented as a supplier invoice number. BillStatus refers to expense billing processing, NOT supplier debt paid/unpaid. InvoiceStatus stays a native approval code without guessing its allowed values or joining an approval workflow. Final-billed invoice/WBS/period, credit memo and additional book remain distinct references.
Org is the recorded transaction organization, not an inferred owning company. Its current name uses Organization.Org. LinkCompany/LinkWBS are intercompany counterparts, never the owning company or selected work. The child rereads the complete ledger key and saved nullable WBS/organization/type/entry/vendor/voucher/purchase reference context plus the voucher line before an exact three-WBS PR lookup. Changed/deleted parent context or absent exact work record gives no child: refresh and verify access. NULL references are not coerced into blank root projects. Missing current names never remove a transaction. Current work/team/dates/estimated percentages/notes are not historical financial snapshots, payroll, actual cost or a project total. No current client, company-currency or invoice-family join is invented.
Physical identifiers/types/nullability/keys use the official Vantagepoint 2025.1 dictionary. Separate official 7.2 project meanings are supplementary, not a same-edition installation guarantee. Use an administrator-approved on-premises SQL Server database and a dedicated least-privilege SELECT account. Verify the database, default schema, projected columns, full identities, authorized company/project/confidential-data scope and source timing. Default-schema object-identity guards refuse mismatched resolution; empty results can mean missing metadata or a guard failure. Direct SQL does NOT inherit ERP roles, active-company or confidentiality controls. Opening filters and saved context are NOT ACLs. Complete the real Cifru compatibility/read test and inspect a real preview before use. No sa/sysadmin, writes, DDL or administrative operations; no direct Cloud SQL access promised.
Not tested on a real ERP, SQL Server or iOS. SQLite adapter tests/native fictional DEMO galleries do not certify installed keys, collation, trailing-space/Unicode behavior, decimals, performance, permissions or compatibility. Package includes 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
Current work context (7.2): https://help.deltek.com/Product/Vantagepoint/7.2/ut_tf_projects.html
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Payables and payments
- Details: Current work record
- Sub-button: Current work record
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 CONCAT(a.Period,N':',a.PostSeq,N':',DATALENGTH(a.PKey),N':',a.PKey) AS LedgerRowKey, a.Period AS LedgerPeriod, a.PostSeq AS LedgerPostSeq, a.PKey AS LedgerPKey, CONCAT(CASE WHEN a.WBS1 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS1),N':',a.WBS1,N';') END,CASE WHEN a.WBS2 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS2),N':',a.WBS2,N';') END,CASE WHEN a.WBS3 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS3),N':',a.WBS3,N';') END,CASE WHEN a.Org IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Org),N':',a.Org,N';') END,CASE WHEN a.TransType IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.TransType),N':',a.TransType,N';') END,CASE WHEN a.RefNo IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.RefNo),N':',a.RefNo,N';') END,CASE WHEN a.Vendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Vendor),N':',a.Vendor,N';') END,CASE WHEN a.OriginatingVendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.OriginatingVendor),N':',a.OriginatingVendor,N';') END,CASE WHEN a.Voucher IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Voucher),N':',a.Voucher,N';') END,CASE WHEN a.PONumber IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.PONumber),N':',a.PONumber,N';') END,N'I',a.Line,N';') AS ContextToken, a.Voucher AS Voucher, a.Line AS VoucherLine, a.Vendor AS Vendor, a.OriginatingVendor AS OriginatingVendor, a.RefNo AS EntryReference, CASE a.TransType WHEN N'AP' THEN N'Accounts payable posting' WHEN N'PP' THEN N'Payment processing posting' ELSE CASE WHEN a.TransType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(a.TransType)) END END AS TransactionType, CASE WHEN NULLIF(LTRIM(RTRIM(a.SubType)),N'') IS NULL THEN NULL WHEN a.TransType=N'AP' AND a.SubType=N'L' THEN N'Voucher line' WHEN a.TransType=N'AP' AND a.SubType=N'T' THEN N'Voucher tax / VAT line' WHEN a.TransType=N'PP' AND a.SubType=N'A' THEN N'Regular payment' WHEN a.TransType=N'PP' AND a.SubType=N'C' THEN N'AP disbursement payment' WHEN a.TransType=N'PP' AND a.SubType=N'D' THEN N'Discount line' WHEN a.TransType=N'PP' AND a.SubType=N'T' THEN N'Tax / VAT payment' WHEN a.TransType=N'PP' AND a.SubType=N'V' THEN N'Void check' ELSE CONCAT(N'Code ',a.SubType) END AS TransactionSubtype, a.TransDate AS TransDate, a.TransactionAmount AS TransactionAmount, a.TransactionCurrencyCode AS TransactionCurrencyCode, a.Desc1 AS Desc1, a.Desc2 AS Desc2, a.Account AS Account, a.Org AS Org, o.Name AS OrganizationName, a.BankCode AS BankCode, a.PONumber AS PONumber, a.WBS1 AS WBS1, a.WBS2 AS WBS2, a.WBS3 AS WBS3, CASE WHEN p.WBS1 IS NULL THEN N'No exact current work record' ELSE N'Current work record available' END AS WorkContext, CASE a.BillStatus WHEN N'B' THEN N'To be billed' WHEN N'W' THEN N'To be written off' WHEN N'H' THEN N'Held' WHEN N'F' THEN N'Final billed' WHEN N'X' THEN N'Written off' WHEN N'T' THEN N'Transferred' WHEN N'I' THEN N'Inserted' WHEN N'M' THEN N'Modified' WHEN N'D' THEN N'To be deleted' WHEN N'N' THEN N'Not billable' WHEN N'O' THEN N'Deleted' WHEN N'R' THEN N'Partial hold / released' ELSE CASE WHEN a.BillStatus IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(a.BillStatus)) END END AS BillStatus, a.InvoiceStatus AS InvoiceStatus, a.BilledInvoice AS BilledInvoice, a.BilledPeriod AS BilledPeriod, a.BilledWBS1 AS BilledWBS1, a.BilledWBS2 AS BilledWBS2, a.BilledWBS3 AS BilledWBS3, a.CreditMemoRefNo AS CreditMemoRefNo, a.BookCode AS BookCode, a.LinkCompany AS LinkCompany, a.LinkWBS1 AS LinkWBS1, a.LinkWBS2 AS LinkWBS2, a.LinkWBS3 AS LinkWBS3 FROM LedgerAP a LEFT JOIN PR p ON p.WBS1=a.WBS1 AND p.WBS2=a.WBS2 AND p.WBS3=a.WBS3 LEFT JOIN Organization o ON o.Org=a.Org WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'LedgerAP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LedgerAP',N'U') AND OBJECT_ID(N'Organization',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Organization',N'U') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(a.Period,N':',a.PostSeq,N':',DATALENGTH(a.PKey),N':',a.PKey) AS LedgerRowKey, a.Period AS LedgerPeriod, a.PostSeq AS LedgerPostSeq, a.PKey AS LedgerPKey, CONCAT(CASE WHEN a.WBS1 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS1),N':',a.WBS1,N';') END,CASE WHEN a.WBS2 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS2),N':',a.WBS2,N';') END,CASE WHEN a.WBS3 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS3),N':',a.WBS3,N';') END,CASE WHEN a.Org IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Org),N':',a.Org,N';') END,CASE WHEN a.TransType IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.TransType),N':',a.TransType,N';') END,CASE WHEN a.RefNo IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.RefNo),N':',a.RefNo,N';') END,CASE WHEN a.Vendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Vendor),N':',a.Vendor,N';') END,CASE WHEN a.OriginatingVendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.OriginatingVendor),N':',a.OriginatingVendor,N';') END,CASE WHEN a.Voucher IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Voucher),N':',a.Voucher,N';') END,CASE WHEN a.PONumber IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.PONumber),N':',a.PONumber,N';') END,N'I',a.Line,N';') AS ContextToken, p.Name AS Name, p.WBS1 AS WBS1, CASE p.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'D' THEN N'Dormant' ELSE CASE WHEN p.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Status)) END END AS Status, CASE p.ChargeType WHEN N'R' THEN N'Regular' WHEN N'H' THEN N'Overhead' WHEN N'P' THEN N'Promotional' ELSE CASE WHEN p.ChargeType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.ChargeType)) END END AS ChargeType, p.Org AS Org, NULLIF(LTRIM(RTRIM(CONCAT(pm.FirstName,N' ',pm.LastName))),N'') AS ProjMgrName, NULLIF(LTRIM(RTRIM(CONCAT(su.FirstName,N' ',su.LastName))),N'') AS SupervisorName, p.EstStartDate AS EstStartDate, p.EstCompletionDate AS EstCompletionDate, p.ActCompletionDate AS ActCompletionDate, p.PctComp AS PctComp, p.LabPctComp AS LabPctComp, p.ExpPctComp AS ExpPctComp, p.LongName AS LongName, p.Description AS Description, p.Memo AS Memo, p.WBS2 AS WBS2, p.WBS3 AS WBS3, NULLIF(LTRIM(RTRIM(CONCAT(pi.FirstName,N' ',pi.LastName))),N'') AS PrincipalName, p.ContractDate AS ContractDate FROM LedgerAP a INNER JOIN PR p ON p.WBS1=a.WBS1 AND p.WBS2=a.WBS2 AND p.WBS3=a.WBS3 LEFT JOIN EMMain pm ON pm.Employee=p.ProjMgr LEFT JOIN EMMain su ON su.Employee=p.Supervisor LEFT JOIN EMMain pi ON pi.Employee=p.Principal WHERE a.Period=:period AND a.PostSeq=:post_seq AND a.PKey=:row_id AND CONCAT(CASE WHEN a.WBS1 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS1),N':',a.WBS1,N';') END,CASE WHEN a.WBS2 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS2),N':',a.WBS2,N';') END,CASE WHEN a.WBS3 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS3),N':',a.WBS3,N';') END,CASE WHEN a.Org IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Org),N':',a.Org,N';') END,CASE WHEN a.TransType IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.TransType),N':',a.TransType,N';') END,CASE WHEN a.RefNo IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.RefNo),N':',a.RefNo,N';') END,CASE WHEN a.Vendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Vendor),N':',a.Vendor,N';') END,CASE WHEN a.OriginatingVendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.OriginatingVendor),N':',a.OriginatingVendor,N';') END,CASE WHEN a.Voucher IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Voucher),N':',a.Voucher,N';') END,CASE WHEN a.PONumber IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.PONumber),N':',a.PONumber,N';') END,N'I',a.Line,N';')=:context AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'LedgerAP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LedgerAP',N'U') AND OBJECT_ID(N'Organization',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Organization',N'U') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Vantagepoint — authorised SQL Server database",
"id": "FA1EE815-3BD0-5279-AD6A-2E5A4ACC829F",
"kind": "sqlServer",
"requiredObjects": [
"LedgerAP",
"Organization",
"PR",
"EMMain"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "3D7F678F-6D1F-5A76-A8DA-DB288A4F4BF9",
"key": "TransDate",
"type": "date"
},
{
"direction": "ascending",
"id": "CFAD91CA-31CC-5C47-8012-8BCC7367C815",
"key": "LedgerRowKey",
"type": "text"
}
],
"id": "1E17CD36-F393-5183-A29E-FEBEA597B459",
"mappings": [
{
"commonFieldKey": "",
"key": "ContextToken",
"label": "Internal ContextToken",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContextToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LedgerPKey",
"label": "Internal LedgerPKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LedgerPKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LedgerPeriod",
"label": "Internal LedgerPeriod",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LedgerPeriod",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LedgerPostSeq",
"label": "Internal LedgerPostSeq",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LedgerPostSeq",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LedgerRowKey",
"label": "Internal LedgerRowKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LedgerRowKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Voucher",
"label": "Voucher reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Voucher",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VoucherLine",
"label": "Voucher line number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VoucherLine",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Vendor",
"label": "Vendor number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Vendor",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OriginatingVendor",
"label": "Originating vendor — if different",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OriginatingVendor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryReference",
"label": "Entry reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EntryReference",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionType",
"label": "Transaction type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransactionType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TransactionSubtype",
"label": "Transaction subtype",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransactionSubtype",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TransDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TransactionAmount",
"label": "Recorded transaction amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TransactionCurrencyCode",
"label": "Transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransactionCurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Desc1",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Desc1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Desc2",
"label": "Additional description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Desc2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Account",
"label": "Account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Account",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Org",
"label": "Transaction organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Org",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrganizationName",
"label": "Current organization name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrganizationName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BankCode",
"label": "Recorded bank code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BankCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PONumber",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PONumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WBS1",
"label": "Transaction project",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WBS2",
"label": "Transaction phase",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WBS3",
"label": "Transaction task",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WorkContext",
"label": "Current work lookup",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WorkContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BillStatus",
"label": "Recorded billing status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceStatus",
"label": "Native invoice approval code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BilledInvoice",
"label": "Final-billed invoice reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BilledInvoice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BilledPeriod",
"label": "Final-billed fiscal period",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BilledPeriod",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BilledWBS1",
"label": "Final-billed project",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BilledWBS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BilledWBS2",
"label": "Final-billed phase",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BilledWBS2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BilledWBS3",
"label": "Final-billed task",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BilledWBS3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CreditMemoRefNo",
"label": "Credit memo reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreditMemoRefNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BookCode",
"label": "Additional book code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BookCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LinkCompany",
"label": "Intercompany counterpart code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LinkCompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LinkWBS1",
"label": "Intercompany counterpart project",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LinkWBS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LinkWBS2",
"label": "Intercompany counterpart phase",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LinkWBS2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LinkWBS3",
"label": "Intercompany counterpart task",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LinkWBS3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Payables and payments",
"primaryKey": "LedgerRowKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Voucher",
"VoucherLine",
"Vendor",
"OriginatingVendor",
"EntryReference",
"TransactionType",
"TransactionSubtype",
"TransDate",
"TransactionAmount",
"TransactionCurrencyCode",
"Desc1",
"Desc2",
"Account",
"Org",
"OrganizationName",
"BankCode",
"PONumber",
"WBS1",
"WBS2",
"WBS3",
"WorkContext",
"BillStatus",
"InvoiceStatus",
"BilledInvoice",
"BilledPeriod",
"BilledWBS1",
"BilledWBS2",
"BilledWBS3",
"CreditMemoRefNo",
"BookCode",
"LinkCompany",
"LinkWBS1",
"LinkWBS2",
"LinkWBS3"
],
"sourceID": "FA1EE815-3BD0-5279-AD6A-2E5A4ACC829F",
"sqlQuery": "SELECT CONCAT(a.Period,N':',a.PostSeq,N':',DATALENGTH(a.PKey),N':',a.PKey) AS LedgerRowKey, a.Period AS LedgerPeriod, a.PostSeq AS LedgerPostSeq, a.PKey AS LedgerPKey, CONCAT(CASE WHEN a.WBS1 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS1),N':',a.WBS1,N';') END,CASE WHEN a.WBS2 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS2),N':',a.WBS2,N';') END,CASE WHEN a.WBS3 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS3),N':',a.WBS3,N';') END,CASE WHEN a.Org IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Org),N':',a.Org,N';') END,CASE WHEN a.TransType IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.TransType),N':',a.TransType,N';') END,CASE WHEN a.RefNo IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.RefNo),N':',a.RefNo,N';') END,CASE WHEN a.Vendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Vendor),N':',a.Vendor,N';') END,CASE WHEN a.OriginatingVendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.OriginatingVendor),N':',a.OriginatingVendor,N';') END,CASE WHEN a.Voucher IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Voucher),N':',a.Voucher,N';') END,CASE WHEN a.PONumber IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.PONumber),N':',a.PONumber,N';') END,N'I',a.Line,N';') AS ContextToken, a.Voucher AS Voucher, a.Line AS VoucherLine, a.Vendor AS Vendor, a.OriginatingVendor AS OriginatingVendor, a.RefNo AS EntryReference, CASE a.TransType WHEN N'AP' THEN N'Accounts payable posting' WHEN N'PP' THEN N'Payment processing posting' ELSE CASE WHEN a.TransType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(a.TransType)) END END AS TransactionType, CASE WHEN NULLIF(LTRIM(RTRIM(a.SubType)),N'') IS NULL THEN NULL WHEN a.TransType=N'AP' AND a.SubType=N'L' THEN N'Voucher line' WHEN a.TransType=N'AP' AND a.SubType=N'T' THEN N'Voucher tax / VAT line' WHEN a.TransType=N'PP' AND a.SubType=N'A' THEN N'Regular payment' WHEN a.TransType=N'PP' AND a.SubType=N'C' THEN N'AP disbursement payment' WHEN a.TransType=N'PP' AND a.SubType=N'D' THEN N'Discount line' WHEN a.TransType=N'PP' AND a.SubType=N'T' THEN N'Tax / VAT payment' WHEN a.TransType=N'PP' AND a.SubType=N'V' THEN N'Void check' ELSE CONCAT(N'Code ',a.SubType) END AS TransactionSubtype, a.TransDate AS TransDate, a.TransactionAmount AS TransactionAmount, a.TransactionCurrencyCode AS TransactionCurrencyCode, a.Desc1 AS Desc1, a.Desc2 AS Desc2, a.Account AS Account, a.Org AS Org, o.Name AS OrganizationName, a.BankCode AS BankCode, a.PONumber AS PONumber, a.WBS1 AS WBS1, a.WBS2 AS WBS2, a.WBS3 AS WBS3, CASE WHEN p.WBS1 IS NULL THEN N'No exact current work record' ELSE N'Current work record available' END AS WorkContext, CASE a.BillStatus WHEN N'B' THEN N'To be billed' WHEN N'W' THEN N'To be written off' WHEN N'H' THEN N'Held' WHEN N'F' THEN N'Final billed' WHEN N'X' THEN N'Written off' WHEN N'T' THEN N'Transferred' WHEN N'I' THEN N'Inserted' WHEN N'M' THEN N'Modified' WHEN N'D' THEN N'To be deleted' WHEN N'N' THEN N'Not billable' WHEN N'O' THEN N'Deleted' WHEN N'R' THEN N'Partial hold / released' ELSE CASE WHEN a.BillStatus IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(a.BillStatus)) END END AS BillStatus, a.InvoiceStatus AS InvoiceStatus, a.BilledInvoice AS BilledInvoice, a.BilledPeriod AS BilledPeriod, a.BilledWBS1 AS BilledWBS1, a.BilledWBS2 AS BilledWBS2, a.BilledWBS3 AS BilledWBS3, a.CreditMemoRefNo AS CreditMemoRefNo, a.BookCode AS BookCode, a.LinkCompany AS LinkCompany, a.LinkWBS1 AS LinkWBS1, a.LinkWBS2 AS LinkWBS2, a.LinkWBS3 AS LinkWBS3 FROM LedgerAP a LEFT JOIN PR p ON p.WBS1=a.WBS1 AND p.WBS2=a.WBS2 AND p.WBS3=a.WBS3 LEFT JOIN Organization o ON o.Org=a.Org WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'LedgerAP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LedgerAP',N'U') AND OBJECT_ID(N'Organization',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Organization',N'U') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "CFAD91CA-31CC-5C47-8012-8BCC7367C815",
"key": "LedgerRowKey",
"type": "text"
}
],
"id": "1B73E383-39FC-5862-86D8-3412B5C9F201",
"mappings": [
{
"commonFieldKey": "",
"key": "ContextToken",
"label": "Internal ContextToken",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContextToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LedgerPKey",
"label": "Internal LedgerPKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LedgerPKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LedgerPeriod",
"label": "Internal LedgerPeriod",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LedgerPeriod",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LedgerPostSeq",
"label": "Internal LedgerPostSeq",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LedgerPostSeq",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LedgerRowKey",
"label": "Internal LedgerRowKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LedgerRowKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Name",
"label": "Name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WBS1",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ChargeType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Org",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjMgrName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SupervisorName",
"label": "Supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupervisorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EstStartDate",
"label": "Estimated start",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EstStartDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EstCompletionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ActCompletionDate",
"label": "Actual completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ActCompletionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LabPctComp",
"label": "Estimated labor complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LabPctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ExpPctComp",
"label": "Estimated expense complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ExpPctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LongName",
"label": "Long name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LongName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Memo",
"label": "Notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Memo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WBS2",
"label": "Phase number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS2",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WBS3",
"label": "Task number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS3",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PrincipalName",
"label": "Principal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PrincipalName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ContractDate",
"label": "Contract award date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ContractDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Current work record",
"primaryKey": "LedgerRowKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "LedgerPeriod",
"id": "18AA7AAD-2431-50C9-BA7C-B075A2615F42",
"name": "period",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "LedgerPostSeq",
"id": "2E10E776-6D26-59BA-BB7D-7AFD0F4737A2",
"name": "post_seq",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "LedgerPKey",
"id": "5E6221CB-5DE7-54F6-914C-4C7237733803",
"name": "row_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ContextToken",
"id": "534B37DB-CE88-58FE-8323-B9DEB60FFE53",
"name": "context",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Name",
"WBS1",
"Status",
"ChargeType",
"Org",
"ProjMgrName",
"SupervisorName",
"EstStartDate",
"EstCompletionDate",
"ActCompletionDate",
"PctComp",
"LabPctComp",
"ExpPctComp",
"LongName",
"Description",
"Memo",
"WBS2",
"WBS3",
"PrincipalName",
"ContractDate"
],
"sourceID": "FA1EE815-3BD0-5279-AD6A-2E5A4ACC829F",
"sqlQuery": "SELECT CONCAT(a.Period,N':',a.PostSeq,N':',DATALENGTH(a.PKey),N':',a.PKey) AS LedgerRowKey, a.Period AS LedgerPeriod, a.PostSeq AS LedgerPostSeq, a.PKey AS LedgerPKey, CONCAT(CASE WHEN a.WBS1 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS1),N':',a.WBS1,N';') END,CASE WHEN a.WBS2 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS2),N':',a.WBS2,N';') END,CASE WHEN a.WBS3 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS3),N':',a.WBS3,N';') END,CASE WHEN a.Org IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Org),N':',a.Org,N';') END,CASE WHEN a.TransType IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.TransType),N':',a.TransType,N';') END,CASE WHEN a.RefNo IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.RefNo),N':',a.RefNo,N';') END,CASE WHEN a.Vendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Vendor),N':',a.Vendor,N';') END,CASE WHEN a.OriginatingVendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.OriginatingVendor),N':',a.OriginatingVendor,N';') END,CASE WHEN a.Voucher IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Voucher),N':',a.Voucher,N';') END,CASE WHEN a.PONumber IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.PONumber),N':',a.PONumber,N';') END,N'I',a.Line,N';') AS ContextToken, p.Name AS Name, p.WBS1 AS WBS1, CASE p.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'D' THEN N'Dormant' ELSE CASE WHEN p.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Status)) END END AS Status, CASE p.ChargeType WHEN N'R' THEN N'Regular' WHEN N'H' THEN N'Overhead' WHEN N'P' THEN N'Promotional' ELSE CASE WHEN p.ChargeType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.ChargeType)) END END AS ChargeType, p.Org AS Org, NULLIF(LTRIM(RTRIM(CONCAT(pm.FirstName,N' ',pm.LastName))),N'') AS ProjMgrName, NULLIF(LTRIM(RTRIM(CONCAT(su.FirstName,N' ',su.LastName))),N'') AS SupervisorName, p.EstStartDate AS EstStartDate, p.EstCompletionDate AS EstCompletionDate, p.ActCompletionDate AS ActCompletionDate, p.PctComp AS PctComp, p.LabPctComp AS LabPctComp, p.ExpPctComp AS ExpPctComp, p.LongName AS LongName, p.Description AS Description, p.Memo AS Memo, p.WBS2 AS WBS2, p.WBS3 AS WBS3, NULLIF(LTRIM(RTRIM(CONCAT(pi.FirstName,N' ',pi.LastName))),N'') AS PrincipalName, p.ContractDate AS ContractDate FROM LedgerAP a INNER JOIN PR p ON p.WBS1=a.WBS1 AND p.WBS2=a.WBS2 AND p.WBS3=a.WBS3 LEFT JOIN EMMain pm ON pm.Employee=p.ProjMgr LEFT JOIN EMMain su ON su.Employee=p.Supervisor LEFT JOIN EMMain pi ON pi.Employee=p.Principal WHERE a.Period=:period AND a.PostSeq=:post_seq AND a.PKey=:row_id AND CONCAT(CASE WHEN a.WBS1 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS1),N':',a.WBS1,N';') END,CASE WHEN a.WBS2 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS2),N':',a.WBS2,N';') END,CASE WHEN a.WBS3 IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.WBS3),N':',a.WBS3,N';') END,CASE WHEN a.Org IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Org),N':',a.Org,N';') END,CASE WHEN a.TransType IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.TransType),N':',a.TransType,N';') END,CASE WHEN a.RefNo IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.RefNo),N':',a.RefNo,N';') END,CASE WHEN a.Vendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Vendor),N':',a.Vendor,N';') END,CASE WHEN a.OriginatingVendor IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.OriginatingVendor),N':',a.OriginatingVendor,N';') END,CASE WHEN a.Voucher IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.Voucher),N':',a.Voucher,N';') END,CASE WHEN a.PONumber IS NULL THEN N'N;' ELSE CONCAT(N'V',DATALENGTH(a.PONumber),N':',a.PONumber,N';') END,N'I',a.Line,N';')=:context AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'LedgerAP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LedgerAP',N'U') AND OBJECT_ID(N'Organization',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Organization',N'U') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "A5C5ECB8-F51F-5EE0-8755-31873ED23814",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "327A7511-564C-5E2C-BE5E-E0A733018BD7",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "1B73E383-39FC-5862-86D8-3412B5C9F201",
"title": "Current work record",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Vendor",
"label": "Vendor number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VoucherLine",
"label": "Voucher line number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransactionType",
"label": "Transaction type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransactionSubtype",
"label": "Transaction subtype",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransactionAmount",
"label": "Recorded transaction amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransactionCurrencyCode",
"label": "Transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Transaction organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WBS1",
"label": "Transaction project",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Account",
"label": "Account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PONumber",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "1E17CD36-F393-5183-A29E-FEBEA597B459",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "Voucher",
"label": "Voucher reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "VoucherLine",
"label": "Voucher line number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "Vendor",
"label": "Vendor number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "OriginatingVendor",
"label": "Originating vendor — if different",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "EntryReference",
"label": "Entry reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "TransactionType",
"label": "Transaction type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "TransactionSubtype",
"label": "Transaction subtype",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "TransDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "TransactionAmount",
"label": "Recorded transaction amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "TransactionCurrencyCode",
"label": "Transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "Desc1",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher and transaction",
"detailRole": "information",
"isVisible": true,
"key": "Desc2",
"label": "Additional description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Account, organization and references",
"detailRole": "information",
"isVisible": true,
"key": "Account",
"label": "Account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Account, organization and references",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Transaction organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Account, organization and references",
"detailRole": "information",
"isVisible": true,
"key": "OrganizationName",
"label": "Current organization name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Account, organization and references",
"detailRole": "information",
"isVisible": true,
"key": "BankCode",
"label": "Recorded bank code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Account, organization and references",
"detailRole": "information",
"isVisible": true,
"key": "PONumber",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded work references",
"detailRole": "information",
"isVisible": true,
"key": "WBS1",
"label": "Transaction project",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded work references",
"detailRole": "information",
"isVisible": true,
"key": "WBS2",
"label": "Transaction phase",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded work references",
"detailRole": "information",
"isVisible": true,
"key": "WBS3",
"label": "Transaction task",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded work references",
"detailRole": "information",
"isVisible": true,
"key": "WorkContext",
"label": "Current work lookup",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Billing processing — not supplier debt",
"detailRole": "information",
"isVisible": true,
"key": "BillStatus",
"label": "Recorded billing status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Billing processing — not supplier debt",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceStatus",
"label": "Native invoice approval code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Billing processing — not supplier debt",
"detailRole": "information",
"isVisible": true,
"key": "BilledInvoice",
"label": "Final-billed invoice reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Billing processing — not supplier debt",
"detailRole": "information",
"isVisible": true,
"key": "BilledPeriod",
"label": "Final-billed fiscal period",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Billing processing — not supplier debt",
"detailRole": "information",
"isVisible": true,
"key": "BilledWBS1",
"label": "Final-billed project",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Billing processing — not supplier debt",
"detailRole": "information",
"isVisible": true,
"key": "BilledWBS2",
"label": "Final-billed phase",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Billing processing — not supplier debt",
"detailRole": "information",
"isVisible": true,
"key": "BilledWBS3",
"label": "Final-billed task",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Billing processing — not supplier debt",
"detailRole": "information",
"isVisible": true,
"key": "CreditMemoRefNo",
"label": "Credit memo reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Billing processing — not supplier debt",
"detailRole": "information",
"isVisible": true,
"key": "BookCode",
"label": "Additional book code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Intercompany counterpart — not owning company",
"detailRole": "information",
"isVisible": true,
"key": "LinkCompany",
"label": "Intercompany counterpart code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Intercompany counterpart — not owning company",
"detailRole": "information",
"isVisible": true,
"key": "LinkWBS1",
"label": "Intercompany counterpart project",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Intercompany counterpart — not owning company",
"detailRole": "information",
"isVisible": true,
"key": "LinkWBS2",
"label": "Intercompany counterpart phase",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Intercompany counterpart — not owning company",
"detailRole": "information",
"isVisible": true,
"key": "LinkWBS3",
"label": "Intercompany counterpart task",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "83D3641F-C5EA-572C-9A8E-8540096BF57F",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "1F99DF2C-44B0-5464-8DFA-020F9240F717",
"includeAllOption": false,
"key": "TransDate",
"title": "Transaction period",
"type": "date"
},
{
"id": "7D39A33A-BC7F-5400-8EAA-E5DCAC239F0D",
"includeAllOption": false,
"key": "Org",
"title": "Transaction organization",
"type": "text"
},
{
"id": "997606B6-9BA6-5CA2-9BE0-05B269ED9AD2",
"includeAllOption": true,
"key": "TransactionType",
"title": "Transaction type",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "3D7F678F-6D1F-5A76-A8DA-DB288A4F4BF9",
"key": "TransDate",
"type": "date"
},
{
"direction": "ascending",
"id": "CFAD91CA-31CC-5C47-8012-8BCC7367C815",
"key": "LedgerRowKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Vendor",
"systemImage": "doc.text",
"title": "Payables and payments",
"titleKey": "Voucher"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WBS1",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WBS2",
"label": "Phase number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WBS3",
"label": "Task number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SupervisorName",
"label": "Supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "1B73E383-39FC-5862-86D8-3412B5C9F201",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current work and team",
"detailRole": "information",
"isVisible": true,
"key": "Name",
"label": "Name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current work and team",
"detailRole": "information",
"isVisible": true,
"key": "WBS1",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current work and team",
"detailRole": "information",
"isVisible": true,
"key": "WBS2",
"label": "Phase number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current work and team",
"detailRole": "information",
"isVisible": true,
"key": "WBS3",
"label": "Task number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current work and team",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current work and team",
"detailRole": "information",
"isVisible": true,
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current work and team",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current work and team",
"detailRole": "information",
"isVisible": true,
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current work and team",
"detailRole": "information",
"isVisible": true,
"key": "SupervisorName",
"label": "Supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current work and team",
"detailRole": "information",
"isVisible": true,
"key": "PrincipalName",
"label": "Principal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "EstStartDate",
"label": "Estimated start",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "ActCompletionDate",
"label": "Actual completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "ContractDate",
"label": "Contract award date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "LabPctComp",
"label": "Estimated labor complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "ExpPctComp",
"label": "Estimated expense complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current context",
"detailRole": "information",
"isVisible": true,
"key": "LongName",
"label": "Long name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current context",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current context",
"detailRole": "information",
"isVisible": true,
"key": "Memo",
"label": "Notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "178C8FD9-2763-54D2-9ADB-9C676C9502A3",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "CFAD91CA-31CC-5C47-8012-8BCC7367C815",
"key": "LedgerRowKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "WBS1",
"systemImage": "doc.text",
"title": "Current work record",
"titleKey": "Name"
}
],
"relations": [
{
"childDatasetID": "1B73E383-39FC-5862-86D8-3412B5C9F201",
"childKey": "LedgerRowKey",
"id": "327A7511-564C-5E2C-BE5E-E0A733018BD7",
"name": "Current work record",
"parentDatasetID": "1E17CD36-F393-5183-A29E-FEBEA597B459",
"parentKey": "LedgerRowKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Deltek Vantagepoint",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-10T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For finance, purchasing and project teams: choose a transaction period and organization, search voucher/vendor references, inspect posted accounts-payable and payment-processing detail with its recorded amount/currency, native transaction type, account, purchase-order and work references. Open the exact current project, phase or task record on demand for team, dates, estimated progress and notes. \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; 34 transaction values and 20 current work values in grouped Details. Complete LedgerAP Period+PostSeq+PKey identity is hidden but retained. Voucher, vendor, entry reference and voucher line number are useful business references, NOT row identities. Repeated references stay separate. Each list is bounded to 1,000 rows and may be incomplete; no scheduled refresh. Native opening period (inclusive start/exclusive end), mandatory transaction organization and optional transaction type are applied before the row cap. Undated transactions are excluded by a chosen period. Row caps do not guarantee server performance; verify query timing and indexes. Local filters/search affect loaded rows only.\n\nThese are posted LedgerAP AP/PP details, NOT AP approval records, supplier invoice headers, a complete voucher statement, remaining debt, payables aging, bank reconciliation or proof of a bank transfer. TransactionType PP is payment processing, not a promise that money has arrived. Native subtype distinguishes regular payment, AP disbursement, discount, tax/VAT and void check where documented. Unknown/blank type/subtype remains unknown; no guessed normal or paid status. TransactionAmount uses its recorded TransactionCurrencyCode with original sign and no fallback, conversion or cross-row total. Unknown currency stays blank. Source/payment-currency amounts, PartialPayment and Discount are not exposed without a certified currency context; no invented balance formula. Historical/SkipGL rows are not silently removed.\n\nVendor and OriginatingVendor are distinct recorded numbers; originating vendor applies when different from the vendor being paid. No supplier-name/address join is guessed from a blank Clendor.Vendor definition, and no historical master snapshot is asserted. BankCode is a stored lookup code, not account details or transfer execution. PONumber is a reference, not a guaranteed purchase-header identity or delivered quantity. LedgerAP.Invoice has a contradictory cash-receipt definition and is deliberately excluded rather than presented as a supplier invoice number. BillStatus refers to expense billing processing, NOT supplier debt paid/unpaid. InvoiceStatus stays a native approval code without guessing its allowed values or joining an approval workflow. Final-billed invoice/WBS/period, credit memo and additional book remain distinct references.\n\nOrg is the recorded transaction organization, not an inferred owning company. Its current name uses Organization.Org. LinkCompany/LinkWBS are intercompany counterparts, never the owning company or selected work. The child rereads the complete ledger key and saved nullable WBS/organization/type/entry/vendor/voucher/purchase reference context plus the voucher line before an exact three-WBS PR lookup. Changed/deleted parent context or absent exact work record gives no child: refresh and verify access. NULL references are not coerced into blank root projects. Missing current names never remove a transaction. Current work/team/dates/estimated percentages/notes are not historical financial snapshots, payroll, actual cost or a project total. No current client, company-currency or invoice-family join is invented.\n\nPhysical identifiers/types/nullability/keys use the official Vantagepoint 2025.1 dictionary. Separate official 7.2 project meanings are supplementary, not a same-edition installation guarantee. Use an administrator-approved on-premises SQL Server database and a dedicated least-privilege SELECT account. Verify the database, default schema, projected columns, full identities, authorized company/project/confidential-data scope and source timing. Default-schema object-identity guards refuse mismatched resolution; empty results can mean missing metadata or a guard failure. Direct SQL does NOT inherit ERP roles, active-company or confidentiality controls. Opening filters and saved context are NOT ACLs. Complete the real Cifru compatibility/read test and inspect a real preview before use. No sa/sysadmin, writes, DDL or administrative operations; no direct Cloud SQL access promised.\n\nNot tested on a real ERP, SQL Server or iOS. SQLite adapter tests/native fictional DEMO galleries do not certify installed keys, collation, trailing-space/Unicode behavior, decimals, performance, permissions or compatibility. Package includes 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\nCurrent work context (7.2): https://help.deltek.com/Product/Vantagepoint/7.2/ut_tf_projects.html",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "5B61E341-88CA-599A-8AAC-1567DF2AC524",
"rootButtonCount": 1,
"summary": "Period/organization to AP/PP transactions, voucher/vendor references, recorded amount/currency and current work dossiers.",
"tags": [
"Deltek Vantagepoint",
"SQL Server",
"Accounts payable",
"Payments",
"Vouchers",
"Finance",
"Projects",
"Pro"
],
"title": "Payables and payment postings — current work Pro"
}
}