Customer AR history — accounting activity Pro
Company and invoice cohort to current stored balances, due dates, project references and lazy posted accounting activity.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For accountants, collections teams, project controllers and managers: choose company and original invoice period, inspect customer AR history, due dates and current stored transaction amounts, then open recorded invoice and receipt accounting activity on demand. Useful project, customer purchase order, sales order and receivable account references stay visible without technical keys.
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, one lazy relation, 27 AR record fields and 25 activity fields. Native mandatory company and invoice-date cohort period apply before the bounded root read. These are current stored balances for that invoice cohort, NOT an as-of-period aging report or all outstanding invoices. Old/undated unpaid records may be outside the selected cohort. Zero balances, credits, initialized rows and unallocated UNK receipts are retained when in scope: not every AR record is an ordinary invoice. The manual mentions INT records but says that function is unavailable; no finance-charge classification is inferred. Child accounting activity binds the full invoice + company key and is NOT cut to the invoice period: later receipts remain relevant. Up to 1,000 rows per list; option discovery and reads may be limited. No completeness or SQL performance guarantee; loaded search is local and no automatic refresh is enabled.
AR_HDR_HS/AR_DETL_HS are invoice/receipt history updated by posting, also used for initialization and correction. They exclude unposted billing and receipts. Changes made inside ERP history do not automatically synchronize GL/project ledgers, so this is not a certified reconciliation. Invoice Detail means accounting activity, NOT commercial product positions. Full company + invoice + physical activity key are hidden; business invoice and cash receipt references remain visible. A repeated invoice in another company is a different record. Current customer name is optional CUST enrichment by customer + company, NOT the historical invoiced name. Missing master data retains the historical customer account or invoice reference. No current project/account name is invented.
Money uses explicitly selected native TRN fields. Header amounts use its stored invoice transaction currency; activity amounts use the activity row currency, shown separately from parent invoice currency. Functional and PAY amounts are not substituted. Stored balance due is read, not recomputed: do not subtract Adjustment again, infer Paid from zero, turn NULL into zero, or apply ABS to credits/reversals. The functional help describes Balance Due as invoice minus receipts minus discount taken, but Net Amount Due also includes finance charges outside this selected schema. This report does NOT display net due including those charges, sum currencies, calculate FX, DSO, finance charges, due-date buckets or a complete bank-cleared cash history. The native bill categories S/P/D are documented; other/blank/null codes remain explicitly native/unknown, not Standard.
Accounting activity retains journal code, fiscal year/period/subperiod, separate invoice and receipt dates, recorded invoice/receipt/discount/adjustment amounts, receipt/check references and the authorised recorded description. Fiscal periods are not calendar months. Invoice and receipt amounts are initialized on separate rows; no fake single combined payment row or sum of unrelated balances. Receipt date can legitimately be missing from a billing row. Later activity has its own dates, currency and signs. PAY/functional amounts, sales-tax currency and liquidation fields are excluded without verified currency/binding. No automatic join to cash header history by receipt number alone, bank/account numbers, source credentials, tax IDs, audit usernames, modification timestamps or document locations. Free-text activity may contain sensitive business information: restrict SQL access to authorised users and inspect real previews before sharing.
Evidence: immutable official 8.1.0 transaction dictionary and separate official 8.1 history, collections, posting, currency and cash-working input documentation. Most physical definitions are blank: GUI meanings and import corroboration are NOT a guarantee of every physical-to-UI binding or deployed calculation. Oracle type spellings are NOT verified Microsoft SQL Server DDL or a 2026 schema. Confirm the actual column/currency meanings, stored balance behavior, initialization corrections, complete keys and ledger reconciliation on your installation.
Requires administrator-authorised on-premises transaction SQL Server and a dedicated least-privilege SELECT account. No dbo owner, Deltek Cloud SQL access, sa/sysadmin, DDL/writes or administration. Verify database and default schema; object identity checks refuse ambiguous resolution but cannot certify the intended source. Direct SQL does NOT inherit Costpoint company/organization/project/accounting, ITAR/EAR, role or masking permissions; opening filters are NOT ACLs. Pass Cifru compatibility/read checks, inspect real document/activity previews and measure timings. Not tested on a real ERP or SQL Server. Documentary/synthetic tests and native DEMO captures do not prove deployed compatibility, performance, complete data, source ACLs or regulatory compliance. Captures are wholly fictional. Unofficial, not affiliated with Deltek.
Physical dictionary: https://help.deltek.com/product/Costpoint/Documentation/81DataDictionary.html
AR history: https://help.deltek.com/Product/Costpoint/8.1/GA/ARMHIST_Contents_of_the_Manage_Accounts_Receivable_History_Screen.html
Accounting activity: https://help.deltek.com/Product/Costpoint/8.1/GA/ARMOREC_Invoice_Detail_Subtask.html
Posting: https://help.deltek.com/Product/Costpoint/8.1/GA/blx_Update_Accounts_Receivable_Tables.html
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Customer AR history
- Details: Accounting activity
- Sub-button: AR accounting activity
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(LEN(CONCAT(m.INVC_ID,N'#')),N':',m.INVC_ID,N':',LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':') AS ARKey, COALESCE(NULLIF(LTRIM(RTRIM(c.CUST_LONG_NAME)),N''),NULLIF(LTRIM(RTRIM(c.CUST_NAME)),N''),m.CUST_ID,m.INVC_ID) AS CurrentCustomerName, m.INVC_ID AS INVC_ID, m.COMPANY_ID AS COMPANY_ID, m.CUST_ID AS CUST_ID, m.INVC_DT AS INVC_DT, m.DUE_DT AS DUE_DT, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, m.TRN_INVC_AMT AS TRN_INVC_AMT, m.TRN_DISC_AMT AS TRN_DISC_AMT, m.TRN_RECPT_AMT AS TRN_RECPT_AMT, m.TRN_DISC_TAKEN_AMT AS TRN_DISC_TAKEN_AMT, m.TRN_RCV_ADJ_AMT AS TRN_RCV_ADJ_AMT, m.TRN_BAL_DUE_AMT AS TRN_BAL_DUE_AMT, m.LAST_CASH_RECPT_NO AS LAST_CASH_RECPT_NO, m.LAST_RECPT_DT AS LAST_RECPT_DT, CASE m.S_BILL_TYPE WHEN N'S' THEN N'Standard bill' WHEN N'P' THEN N'Progress payment' WHEN N'D' THEN N'Delivery bill' ELSE CASE WHEN m.S_BILL_TYPE IS NULL OR m.S_BILL_TYPE=N'' THEN N'Not recorded' ELSE CONCAT(N'Native code ',m.S_BILL_TYPE) END END AS BillType, m.SO_ID AS SO_ID, m.BILL_NO_ID AS BILL_NO_ID, m.CUST_PO_ID AS CUST_PO_ID, m.PROJ_ID AS PROJ_ID, m.RCV_ACCT_ID AS RCV_ACCT_ID, m.RCV_ORG_ID AS RCV_ORG_ID, m.RCV_REF1_ID AS RCV_REF1_ID, m.RCV_REF2_ID AS RCV_REF2_ID, m.ADDR_DC AS ADDR_DC, m.RATE_GRP_ID AS RATE_GRP_ID, m.TRN_CRNCY_DT AS TRN_CRNCY_DT FROM AR_HDR_HS m LEFT JOIN CUST c ON c.CUST_ID=m.CUST_ID AND c.COMPANY_ID=m.COMPANY_ID WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'AR_HDR_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.AR_HDR_HS',N'U') AND OBJECT_ID(N'AR_DETL_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.AR_DETL_HS',N'U') AND OBJECT_ID(N'CUST',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CUST',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(m.INVC_ID,N'#')),N':',m.INVC_ID,N':',LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':'),CONCAT(LEN(CONCAT(d.AR_DETL_KEY,N'#')),N':',d.AR_DETL_KEY,N':')) AS ActivityKey, CONCAT(LEN(CONCAT(m.INVC_ID,N'#')),N':',m.INVC_ID,N':',LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':') AS ParentARKey, COALESCE(NULLIF(LTRIM(RTRIM(d.TRN_DESC)),N''),m.INVC_ID) AS ActivityDescription, m.INVC_ID AS INVC_ID, m.COMPANY_ID AS COMPANY_ID, m.CUST_ID AS CUST_ID, d.TRN_DT AS TRN_DT, d.TRN_CRNCY_CD AS TRN_CRNCY_CD, m.TRN_CRNCY_CD AS InvoiceCurrency, d.FY_CD AS FY_CD, d.PD_NO AS PD_NO, d.SUB_PD_NO AS SUB_PD_NO, d.S_JNL_CD AS S_JNL_CD, d.INVC_DT AS INVC_DT, d.DUE_DT AS DUE_DT, d.RECPT_DT AS RECPT_DT, d.CASH_RECPT_NO AS CASH_RECPT_NO, d.CHK_NO AS CHK_NO, d.TRN_INVC_AMT AS TRN_INVC_AMT, d.TRN_DISC_AMT AS TRN_DISC_AMT, d.TRN_RECPT_AMT AS TRN_RECPT_AMT, d.TRN_DISC_TAKEN_AMT AS TRN_DISC_TAKEN_AMT, d.TRN_RCV_ADJ_AMT AS TRN_RCV_ADJ_AMT, d.RATE_GRP_ID AS RATE_GRP_ID, m.PROJ_ID AS PROJ_ID, m.RCV_ACCT_ID AS RCV_ACCT_ID, m.RCV_ORG_ID AS RCV_ORG_ID FROM AR_DETL_HS d INNER JOIN AR_HDR_HS m ON m.INVC_ID=d.INVC_ID AND m.COMPANY_ID=d.COMPANY_ID WHERE m.INVC_ID=:invoice AND m.COMPANY_ID=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'AR_HDR_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.AR_HDR_HS',N'U') AND OBJECT_ID(N'AR_DETL_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.AR_DETL_HS',N'U') AND OBJECT_ID(N'CUST',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CUST',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Costpoint 8.1 — authorised transaction SQL Server database",
"id": "390E412E-990E-5B6B-8B32-284D90E84E24",
"kind": "sqlServer",
"requiredObjects": [
"AR_HDR_HS",
"AR_DETL_HS",
"CUST"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "3905D655-5DB4-5B37-BC5E-5D91A8D24E2F",
"key": "INVC_DT",
"type": "date"
},
{
"direction": "ascending",
"id": "9A5F6058-9CB6-5CEC-9751-313222D9FBAD",
"key": "ARKey",
"type": "text"
}
],
"id": "E08E71F1-3F06-5AE6-8A27-51BDD196E649",
"mappings": [
{
"commonFieldKey": "",
"key": "ARKey",
"label": "Internal ARKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ARKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrentCustomerName",
"label": "Current customer name / account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrentCustomerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "INVC_ID",
"label": "Invoice / AR record",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "INVC_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMPANY_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CUST_ID",
"label": "Recorded customer account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CUST_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "INVC_DT",
"label": "Original invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "INVC_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DUE_DT",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DUE_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_CRNCY_CD",
"label": "Invoice transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TRN_CRNCY_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_INVC_AMT",
"label": "Recorded invoice amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_INVC_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_DISC_AMT",
"label": "Original discount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_DISC_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_RECPT_AMT",
"label": "Recorded receipts (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_RECPT_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_DISC_TAKEN_AMT",
"label": "Discount taken (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_DISC_TAKEN_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_RCV_ADJ_AMT",
"label": "Recorded adjustment (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_RCV_ADJ_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_BAL_DUE_AMT",
"label": "Stored balance due (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_BAL_DUE_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LAST_CASH_RECPT_NO",
"label": "Last cash receipt reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LAST_CASH_RECPT_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LAST_RECPT_DT",
"label": "Last recorded receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LAST_RECPT_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BillType",
"label": "Native bill category",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SO_ID",
"label": "Sales order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SO_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BILL_NO_ID",
"label": "Project bill reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BILL_NO_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CUST_PO_ID",
"label": "Customer purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CUST_PO_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROJ_ID",
"label": "Recorded project",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROJ_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RCV_ACCT_ID",
"label": "Receivable account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RCV_ACCT_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RCV_ORG_ID",
"label": "Receivable organization",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RCV_ORG_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RCV_REF1_ID",
"label": "Reference 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RCV_REF1_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RCV_REF2_ID",
"label": "Reference 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RCV_REF2_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDR_DC",
"label": "Recorded billing address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDR_DC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RATE_GRP_ID",
"label": "Recorded rate group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RATE_GRP_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_CRNCY_DT",
"label": "Invoice rate date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_CRNCY_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Customer AR history",
"primaryKey": "ARKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"CurrentCustomerName",
"INVC_ID",
"COMPANY_ID",
"CUST_ID",
"INVC_DT",
"DUE_DT",
"TRN_CRNCY_CD",
"TRN_INVC_AMT",
"TRN_DISC_AMT",
"TRN_RECPT_AMT",
"TRN_DISC_TAKEN_AMT",
"TRN_RCV_ADJ_AMT",
"TRN_BAL_DUE_AMT",
"LAST_CASH_RECPT_NO",
"LAST_RECPT_DT",
"BillType",
"SO_ID",
"BILL_NO_ID",
"CUST_PO_ID",
"PROJ_ID",
"RCV_ACCT_ID",
"RCV_ORG_ID",
"RCV_REF1_ID",
"RCV_REF2_ID",
"ADDR_DC",
"RATE_GRP_ID",
"TRN_CRNCY_DT"
],
"sourceID": "390E412E-990E-5B6B-8B32-284D90E84E24",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(m.INVC_ID,N'#')),N':',m.INVC_ID,N':',LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':') AS ARKey, COALESCE(NULLIF(LTRIM(RTRIM(c.CUST_LONG_NAME)),N''),NULLIF(LTRIM(RTRIM(c.CUST_NAME)),N''),m.CUST_ID,m.INVC_ID) AS CurrentCustomerName, m.INVC_ID AS INVC_ID, m.COMPANY_ID AS COMPANY_ID, m.CUST_ID AS CUST_ID, m.INVC_DT AS INVC_DT, m.DUE_DT AS DUE_DT, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, m.TRN_INVC_AMT AS TRN_INVC_AMT, m.TRN_DISC_AMT AS TRN_DISC_AMT, m.TRN_RECPT_AMT AS TRN_RECPT_AMT, m.TRN_DISC_TAKEN_AMT AS TRN_DISC_TAKEN_AMT, m.TRN_RCV_ADJ_AMT AS TRN_RCV_ADJ_AMT, m.TRN_BAL_DUE_AMT AS TRN_BAL_DUE_AMT, m.LAST_CASH_RECPT_NO AS LAST_CASH_RECPT_NO, m.LAST_RECPT_DT AS LAST_RECPT_DT, CASE m.S_BILL_TYPE WHEN N'S' THEN N'Standard bill' WHEN N'P' THEN N'Progress payment' WHEN N'D' THEN N'Delivery bill' ELSE CASE WHEN m.S_BILL_TYPE IS NULL OR m.S_BILL_TYPE=N'' THEN N'Not recorded' ELSE CONCAT(N'Native code ',m.S_BILL_TYPE) END END AS BillType, m.SO_ID AS SO_ID, m.BILL_NO_ID AS BILL_NO_ID, m.CUST_PO_ID AS CUST_PO_ID, m.PROJ_ID AS PROJ_ID, m.RCV_ACCT_ID AS RCV_ACCT_ID, m.RCV_ORG_ID AS RCV_ORG_ID, m.RCV_REF1_ID AS RCV_REF1_ID, m.RCV_REF2_ID AS RCV_REF2_ID, m.ADDR_DC AS ADDR_DC, m.RATE_GRP_ID AS RATE_GRP_ID, m.TRN_CRNCY_DT AS TRN_CRNCY_DT FROM AR_HDR_HS m LEFT JOIN CUST c ON c.CUST_ID=m.CUST_ID AND c.COMPANY_ID=m.COMPANY_ID WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'AR_HDR_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.AR_HDR_HS',N'U') AND OBJECT_ID(N'AR_DETL_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.AR_DETL_HS',N'U') AND OBJECT_ID(N'CUST',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CUST',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "9AF7862C-B316-581D-8203-7536A9412434",
"key": "TRN_DT",
"type": "date"
},
{
"direction": "ascending",
"id": "C39816EF-D6BF-5C30-B0C6-ABB917886102",
"key": "ActivityKey",
"type": "text"
}
],
"id": "43A7189C-B891-52B0-B12F-4E02CC6CD8F2",
"mappings": [
{
"commonFieldKey": "",
"key": "ActivityKey",
"label": "Internal ActivityKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ActivityKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentARKey",
"label": "Internal ParentARKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentARKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ActivityDescription",
"label": "Recorded activity description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ActivityDescription",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "INVC_ID",
"label": "Invoice / AR record",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "INVC_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMPANY_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CUST_ID",
"label": "Recorded customer account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CUST_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_DT",
"label": "Ledger transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_CRNCY_CD",
"label": "Activity transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TRN_CRNCY_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceCurrency",
"label": "Parent invoice currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FY_CD",
"label": "Fiscal year",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FY_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PD_NO",
"label": "Fiscal period",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PD_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SUB_PD_NO",
"label": "Fiscal subperiod",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SUB_PD_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "S_JNL_CD",
"label": "Native journal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "S_JNL_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "INVC_DT",
"label": "Activity invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "INVC_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DUE_DT",
"label": "Activity due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DUE_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RECPT_DT",
"label": "Receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RECPT_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CASH_RECPT_NO",
"label": "Cash receipt reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CASH_RECPT_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CHK_NO",
"label": "Check reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CHK_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_INVC_AMT",
"label": "Invoice activity (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_INVC_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_DISC_AMT",
"label": "Original discount activity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_DISC_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_RECPT_AMT",
"label": "Receipt activity (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_RECPT_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_DISC_TAKEN_AMT",
"label": "Discount taken activity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_DISC_TAKEN_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_RCV_ADJ_AMT",
"label": "Adjustment activity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_RCV_ADJ_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RATE_GRP_ID",
"label": "Activity rate group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RATE_GRP_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROJ_ID",
"label": "Recorded invoice project",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROJ_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RCV_ACCT_ID",
"label": "Parent receivable account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RCV_ACCT_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RCV_ORG_ID",
"label": "Parent receivable organization",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RCV_ORG_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "AR accounting activity",
"primaryKey": "ActivityKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "INVC_ID",
"id": "E9DF664F-B5B0-57D3-B745-5D8AD25550EA",
"name": "invoice",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "COMPANY_ID",
"id": "EDDC1724-4DB2-56FA-9A6F-C62EDA87B00D",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ActivityDescription",
"INVC_ID",
"COMPANY_ID",
"CUST_ID",
"TRN_DT",
"TRN_CRNCY_CD",
"InvoiceCurrency",
"FY_CD",
"PD_NO",
"SUB_PD_NO",
"S_JNL_CD",
"INVC_DT",
"DUE_DT",
"RECPT_DT",
"CASH_RECPT_NO",
"CHK_NO",
"TRN_INVC_AMT",
"TRN_DISC_AMT",
"TRN_RECPT_AMT",
"TRN_DISC_TAKEN_AMT",
"TRN_RCV_ADJ_AMT",
"RATE_GRP_ID",
"PROJ_ID",
"RCV_ACCT_ID",
"RCV_ORG_ID"
],
"sourceID": "390E412E-990E-5B6B-8B32-284D90E84E24",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(m.INVC_ID,N'#')),N':',m.INVC_ID,N':',LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':'),CONCAT(LEN(CONCAT(d.AR_DETL_KEY,N'#')),N':',d.AR_DETL_KEY,N':')) AS ActivityKey, CONCAT(LEN(CONCAT(m.INVC_ID,N'#')),N':',m.INVC_ID,N':',LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':') AS ParentARKey, COALESCE(NULLIF(LTRIM(RTRIM(d.TRN_DESC)),N''),m.INVC_ID) AS ActivityDescription, m.INVC_ID AS INVC_ID, m.COMPANY_ID AS COMPANY_ID, m.CUST_ID AS CUST_ID, d.TRN_DT AS TRN_DT, d.TRN_CRNCY_CD AS TRN_CRNCY_CD, m.TRN_CRNCY_CD AS InvoiceCurrency, d.FY_CD AS FY_CD, d.PD_NO AS PD_NO, d.SUB_PD_NO AS SUB_PD_NO, d.S_JNL_CD AS S_JNL_CD, d.INVC_DT AS INVC_DT, d.DUE_DT AS DUE_DT, d.RECPT_DT AS RECPT_DT, d.CASH_RECPT_NO AS CASH_RECPT_NO, d.CHK_NO AS CHK_NO, d.TRN_INVC_AMT AS TRN_INVC_AMT, d.TRN_DISC_AMT AS TRN_DISC_AMT, d.TRN_RECPT_AMT AS TRN_RECPT_AMT, d.TRN_DISC_TAKEN_AMT AS TRN_DISC_TAKEN_AMT, d.TRN_RCV_ADJ_AMT AS TRN_RCV_ADJ_AMT, d.RATE_GRP_ID AS RATE_GRP_ID, m.PROJ_ID AS PROJ_ID, m.RCV_ACCT_ID AS RCV_ACCT_ID, m.RCV_ORG_ID AS RCV_ORG_ID FROM AR_DETL_HS d INNER JOIN AR_HDR_HS m ON m.INVC_ID=d.INVC_ID AND m.COMPANY_ID=d.COMPANY_ID WHERE m.INVC_ID=:invoice AND m.COMPANY_ID=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'AR_HDR_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.AR_HDR_HS',N'U') AND OBJECT_ID(N'AR_DETL_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.AR_DETL_HS',N'U') AND OBJECT_ID(N'CUST',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CUST',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "4B17A698-F5A0-5C28-B7DA-D4DCBEE3882A",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "3DAB8C7F-7901-56A7-9A18-767051E54D07",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "43A7189C-B891-52B0-B12F-4E02CC6CD8F2",
"title": "Accounting activity",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "INVC_DT",
"label": "Original invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DUE_DT",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Invoice transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_INVC_AMT",
"label": "Recorded invoice amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_BAL_DUE_AMT",
"label": "Stored balance due (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BillType",
"label": "Native bill category",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "E08E71F1-3F06-5AE6-8A27-51BDD196E649",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "AR record and invoice context",
"detailRole": "information",
"isVisible": true,
"key": "CurrentCustomerName",
"label": "Current customer name / account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "AR record and invoice context",
"detailRole": "information",
"isVisible": true,
"key": "INVC_ID",
"label": "Invoice / AR record",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "AR record and invoice context",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "AR record and invoice context",
"detailRole": "information",
"isVisible": true,
"key": "INVC_DT",
"label": "Original invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "AR record and invoice context",
"detailRole": "information",
"isVisible": true,
"key": "DUE_DT",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "AR record and invoice context",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Invoice transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "AR record and invoice context",
"detailRole": "information",
"isVisible": true,
"key": "TRN_INVC_AMT",
"label": "Recorded invoice amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "AR record and invoice context",
"detailRole": "information",
"isVisible": true,
"key": "TRN_BAL_DUE_AMT",
"label": "Stored balance due (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "AR record and invoice context",
"detailRole": "information",
"isVisible": true,
"key": "BillType",
"label": "Native bill category",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current stored transaction amounts",
"detailRole": "information",
"isVisible": true,
"key": "TRN_DISC_AMT",
"label": "Original discount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current stored transaction amounts",
"detailRole": "information",
"isVisible": true,
"key": "TRN_RECPT_AMT",
"label": "Recorded receipts (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current stored transaction amounts",
"detailRole": "information",
"isVisible": true,
"key": "TRN_DISC_TAKEN_AMT",
"label": "Discount taken (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current stored transaction amounts",
"detailRole": "information",
"isVisible": true,
"key": "TRN_RCV_ADJ_AMT",
"label": "Recorded adjustment (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded receipts and customer",
"detailRole": "information",
"isVisible": true,
"key": "LAST_CASH_RECPT_NO",
"label": "Last cash receipt reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded receipts and customer",
"detailRole": "information",
"isVisible": true,
"key": "LAST_RECPT_DT",
"label": "Last recorded receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded receipts and customer",
"detailRole": "information",
"isVisible": true,
"key": "CUST_ID",
"label": "Recorded customer account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded receipts and customer",
"detailRole": "information",
"isVisible": true,
"key": "ADDR_DC",
"label": "Recorded billing address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and accounting references",
"detailRole": "information",
"isVisible": true,
"key": "SO_ID",
"label": "Sales order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and accounting references",
"detailRole": "information",
"isVisible": true,
"key": "BILL_NO_ID",
"label": "Project bill reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and accounting references",
"detailRole": "information",
"isVisible": true,
"key": "CUST_PO_ID",
"label": "Customer purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and accounting references",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_ID",
"label": "Recorded project",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and accounting references",
"detailRole": "information",
"isVisible": true,
"key": "RCV_ACCT_ID",
"label": "Receivable account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and accounting references",
"detailRole": "information",
"isVisible": true,
"key": "RCV_ORG_ID",
"label": "Receivable organization",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and accounting references",
"detailRole": "information",
"isVisible": true,
"key": "RCV_REF1_ID",
"label": "Reference 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and accounting references",
"detailRole": "information",
"isVisible": true,
"key": "RCV_REF2_ID",
"label": "Reference 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and accounting references",
"detailRole": "information",
"isVisible": true,
"key": "RATE_GRP_ID",
"label": "Recorded rate group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and accounting references",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_DT",
"label": "Invoice rate date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "A9A5C270-E272-5F79-930D-B06ED1AB63F4",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "A20630ED-3F6A-561A-8A7A-3EB9536F82B6",
"includeAllOption": false,
"key": "INVC_DT",
"title": "Invoice cohort period",
"type": "date"
},
{
"id": "B353CB46-69CC-523B-B29F-BA85B3D7F702",
"includeAllOption": false,
"key": "COMPANY_ID",
"title": "Company",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "3905D655-5DB4-5B37-BC5E-5D91A8D24E2F",
"key": "INVC_DT",
"type": "date"
},
{
"direction": "ascending",
"id": "9A5F6058-9CB6-5CEC-9751-313222D9FBAD",
"key": "ARKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "INVC_ID",
"systemImage": "doc.text",
"title": "Customer AR history",
"titleKey": "CurrentCustomerName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_DT",
"label": "Ledger transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "S_JNL_CD",
"label": "Native journal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Activity transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_INVC_AMT",
"label": "Invoice activity (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_RECPT_AMT",
"label": "Receipt activity (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "RECPT_DT",
"label": "Receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CASH_RECPT_NO",
"label": "Cash receipt reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "43A7189C-B891-52B0-B12F-4E02CC6CD8F2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Posted activity — not product positions",
"detailRole": "information",
"isVisible": true,
"key": "ActivityDescription",
"label": "Recorded activity description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posted activity — not product positions",
"detailRole": "information",
"isVisible": true,
"key": "INVC_ID",
"label": "Invoice / AR record",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posted activity — not product positions",
"detailRole": "information",
"isVisible": true,
"key": "TRN_DT",
"label": "Ledger transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Posted activity — not product positions",
"detailRole": "information",
"isVisible": true,
"key": "S_JNL_CD",
"label": "Native journal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posted activity — not product positions",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Activity transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posted activity — not product positions",
"detailRole": "information",
"isVisible": true,
"key": "TRN_INVC_AMT",
"label": "Invoice activity (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Posted activity — not product positions",
"detailRole": "information",
"isVisible": true,
"key": "TRN_RECPT_AMT",
"label": "Receipt activity (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Posted activity — not product positions",
"detailRole": "information",
"isVisible": true,
"key": "RECPT_DT",
"label": "Receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Posted activity — not product positions",
"detailRole": "information",
"isVisible": true,
"key": "CASH_RECPT_NO",
"label": "Cash receipt reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native period and invoice dates",
"detailRole": "information",
"isVisible": true,
"key": "FY_CD",
"label": "Fiscal year",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native period and invoice dates",
"detailRole": "information",
"isVisible": true,
"key": "PD_NO",
"label": "Fiscal period",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native period and invoice dates",
"detailRole": "information",
"isVisible": true,
"key": "SUB_PD_NO",
"label": "Fiscal subperiod",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native period and invoice dates",
"detailRole": "information",
"isVisible": true,
"key": "INVC_DT",
"label": "Activity invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native period and invoice dates",
"detailRole": "information",
"isVisible": true,
"key": "DUE_DT",
"label": "Activity due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native period and invoice dates",
"detailRole": "information",
"isVisible": true,
"key": "CHK_NO",
"label": "Check reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Other stored transaction amounts",
"detailRole": "information",
"isVisible": true,
"key": "TRN_DISC_AMT",
"label": "Original discount activity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Other stored transaction amounts",
"detailRole": "information",
"isVisible": true,
"key": "TRN_DISC_TAKEN_AMT",
"label": "Discount taken activity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Other stored transaction amounts",
"detailRole": "information",
"isVisible": true,
"key": "TRN_RCV_ADJ_AMT",
"label": "Adjustment activity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Other stored transaction amounts",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceCurrency",
"label": "Parent invoice currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Other stored transaction amounts",
"detailRole": "information",
"isVisible": true,
"key": "RATE_GRP_ID",
"label": "Activity rate group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent accounting context",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent accounting context",
"detailRole": "information",
"isVisible": true,
"key": "CUST_ID",
"label": "Recorded customer account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent accounting context",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_ID",
"label": "Recorded invoice project",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent accounting context",
"detailRole": "information",
"isVisible": true,
"key": "RCV_ACCT_ID",
"label": "Parent receivable account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent accounting context",
"detailRole": "information",
"isVisible": true,
"key": "RCV_ORG_ID",
"label": "Parent receivable organization",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "8AA5D679-ECB9-5C35-8D64-FD98F5FBA6D7",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "9AF7862C-B316-581D-8203-7536A9412434",
"key": "TRN_DT",
"type": "date"
},
{
"direction": "ascending",
"id": "C39816EF-D6BF-5C30-B0C6-ABB917886102",
"key": "ActivityKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "INVC_ID",
"systemImage": "doc.text",
"title": "AR accounting activity",
"titleKey": "ActivityDescription"
}
],
"relations": [
{
"childDatasetID": "43A7189C-B891-52B0-B12F-4E02CC6CD8F2",
"childKey": "ParentARKey",
"id": "3DAB8C7F-7901-56A7-9A18-767051E54D07",
"name": "Accounting activity",
"parentDatasetID": "E08E71F1-3F06-5AE6-8A27-51BDD196E649",
"parentKey": "ARKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Deltek Costpoint",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-08T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For accountants, collections teams, project controllers and managers: choose company and original invoice period, inspect customer AR history, due dates and current stored transaction amounts, then open recorded invoice and receipt accounting activity on demand. Useful project, customer purchase order, sales order and receivable account references stay visible without technical keys.\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, one lazy relation, 27 AR record fields and 25 activity fields. Native mandatory company and invoice-date cohort period apply before the bounded root read. These are current stored balances for that invoice cohort, NOT an as-of-period aging report or all outstanding invoices. Old/undated unpaid records may be outside the selected cohort. Zero balances, credits, initialized rows and unallocated UNK receipts are retained when in scope: not every AR record is an ordinary invoice. The manual mentions INT records but says that function is unavailable; no finance-charge classification is inferred. Child accounting activity binds the full invoice + company key and is NOT cut to the invoice period: later receipts remain relevant. Up to 1,000 rows per list; option discovery and reads may be limited. No completeness or SQL performance guarantee; loaded search is local and no automatic refresh is enabled.\n\nAR_HDR_HS/AR_DETL_HS are invoice/receipt history updated by posting, also used for initialization and correction. They exclude unposted billing and receipts. Changes made inside ERP history do not automatically synchronize GL/project ledgers, so this is not a certified reconciliation. Invoice Detail means accounting activity, NOT commercial product positions. Full company + invoice + physical activity key are hidden; business invoice and cash receipt references remain visible. A repeated invoice in another company is a different record. Current customer name is optional CUST enrichment by customer + company, NOT the historical invoiced name. Missing master data retains the historical customer account or invoice reference. No current project/account name is invented.\n\nMoney uses explicitly selected native TRN fields. Header amounts use its stored invoice transaction currency; activity amounts use the activity row currency, shown separately from parent invoice currency. Functional and PAY amounts are not substituted. Stored balance due is read, not recomputed: do not subtract Adjustment again, infer Paid from zero, turn NULL into zero, or apply ABS to credits/reversals. The functional help describes Balance Due as invoice minus receipts minus discount taken, but Net Amount Due also includes finance charges outside this selected schema. This report does NOT display net due including those charges, sum currencies, calculate FX, DSO, finance charges, due-date buckets or a complete bank-cleared cash history. The native bill categories S/P/D are documented; other/blank/null codes remain explicitly native/unknown, not Standard.\n\nAccounting activity retains journal code, fiscal year/period/subperiod, separate invoice and receipt dates, recorded invoice/receipt/discount/adjustment amounts, receipt/check references and the authorised recorded description. Fiscal periods are not calendar months. Invoice and receipt amounts are initialized on separate rows; no fake single combined payment row or sum of unrelated balances. Receipt date can legitimately be missing from a billing row. Later activity has its own dates, currency and signs. PAY/functional amounts, sales-tax currency and liquidation fields are excluded without verified currency/binding. No automatic join to cash header history by receipt number alone, bank/account numbers, source credentials, tax IDs, audit usernames, modification timestamps or document locations. Free-text activity may contain sensitive business information: restrict SQL access to authorised users and inspect real previews before sharing.\n\nEvidence: immutable official 8.1.0 transaction dictionary and separate official 8.1 history, collections, posting, currency and cash-working input documentation. Most physical definitions are blank: GUI meanings and import corroboration are NOT a guarantee of every physical-to-UI binding or deployed calculation. Oracle type spellings are NOT verified Microsoft SQL Server DDL or a 2026 schema. Confirm the actual column/currency meanings, stored balance behavior, initialization corrections, complete keys and ledger reconciliation on your installation.\n\nRequires administrator-authorised on-premises transaction SQL Server and a dedicated least-privilege SELECT account. No dbo owner, Deltek Cloud SQL access, sa/sysadmin, DDL/writes or administration. Verify database and default schema; object identity checks refuse ambiguous resolution but cannot certify the intended source. Direct SQL does NOT inherit Costpoint company/organization/project/accounting, ITAR/EAR, role or masking permissions; opening filters are NOT ACLs. Pass Cifru compatibility/read checks, inspect real document/activity previews and measure timings. Not tested on a real ERP or SQL Server. Documentary/synthetic tests and native DEMO captures do not prove deployed compatibility, performance, complete data, source ACLs or regulatory compliance. Captures are wholly fictional. Unofficial, not affiliated with Deltek.\n\nPhysical dictionary: https://help.deltek.com/product/Costpoint/Documentation/81DataDictionary.html\nAR history: https://help.deltek.com/Product/Costpoint/8.1/GA/ARMHIST_Contents_of_the_Manage_Accounts_Receivable_History_Screen.html\nAccounting activity: https://help.deltek.com/Product/Costpoint/8.1/GA/ARMOREC_Invoice_Detail_Subtask.html\nPosting: https://help.deltek.com/Product/Costpoint/8.1/GA/blx_Update_Accounts_Receivable_Tables.html",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "30B3DE9B-300C-5848-A5D0-F5681740B06B",
"rootButtonCount": 1,
"summary": "Company and invoice cohort to current stored balances, due dates, project references and lazy posted accounting activity.",
"tags": [
"Deltek Costpoint",
"SQL Server",
"Customer invoices",
"Receivables",
"Accounting",
"Pro"
],
"title": "Customer AR history — accounting activity Pro"
}
}