Supplier voucher history — lines and distributions Pro
Company/period to supplier invoices, distinct original and payment context, voucher lines and nested account/project distributions.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For accountants, project controllers and managers: choose company and invoice period, inspect supplier voucher history, invoice/due dates and original amounts, then open voucher lines and their project/account/organization distributions. Optional matching OPEN_AP data adds native payment status and distinctly labelled settlement/selection context.
Why Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.
Pro: one SQL Server source, three lists, two nested relations, 26 voucher values, 23 line values and 18 distribution values. Native mandatory invoice period (start/end-exclusive) and company apply before the bounded live root read; no unresolved opening SQL parameters or inner TOP. Selector discovery may be bounded and missing options do not prove absence of records. Each child binds numeric voucher key + company; distributions also bind the physical numeric line key, not the editable business line or invoice/voucher number. Joined canonical parent identities preserve exact native relations. Full technical keys, audit fields, bank/tax IDs, document locations and free-form notes are hidden/excluded. Business accounts, project codes and references remain useful. Up to 1,000 rows per list; no completeness, unlimited SQL work or performance guarantee. Child reads only when opened, no automatic refresh; loaded-row search is local.
Reads VCHR_HDR_HS/VCHR_LN_HS/VCHR_LN_ACCT_HS, not editable working vouchers removed after posting. History can also contain manually initialized, fully paid legacy records. It is NOT a working-voucher approval queue or a guarantee that every historical row came through normal posting. Supplier name is the stored historical VEND_NAME (or native supplier account fallback), not current master enrichment; VEND_NAME_EXT is not concatenated as a guessed long name. An invoice number may repeat across suppliers and voucher numbers across fiscal years; physical keys keep them separate. Invoice date selection can exclude undated historical records; choose an appropriate period and verify completeness.
All money is read from stored TRN fields with the history invoice TRN_CRNCY_CD, not functional/payment amounts or current vendor defaults. Original net due = invoice minus original discount in the functional help; it is NOT the remaining unpaid balance. No outstanding balance is calculated. OPEN_AP joins by physical voucher key AND invoice supplier account; its absence/mismatch leaves amounts NULL and context unknown, not Paid or zero. The native status description comes from S_AP_STATUS_CD; unknown status rows fall back to the actual code, never guessed translations. Recorded settlement may include discounts added during payment processing: it is NOT pure cash paid, cleared bank funds, or a complete disbursement history. Selected payment is an instruction for a future check/EFT, not an executed payment. Open-record discount reads OPEN_AP.TRN_DISC_TAKEN_AMT neutrally: the dictionary has no definition and the functional help does not explicitly bind this physical column to pending versus cumulative discounts. Neither is claimed; verify the installed meaning. Retained amount and anticipated payment date are editable ERP context, not evidence of a bank transaction. A stored pay supplier may differ legitimately from the invoice supplier (factoring). All four optional amounts are in invoice transaction currency. Validate actual installed payment behavior and sample vouchers before relying on these fields.
Lines preserve quantity/unit, stored unit/extended costs, charges, separate tax components, discount, recovery and net amount. A zero/amount-only quantity does not zero a stored amount; signs, credits and zero values are not converted to absolute/positive values. Taxability stays the native code. Distribution accounts are distinct from the root liability account. No quantity-times-price reconstruction, derived tax, currency/units mixing, allocation percentage scale guess, cross-company sums or totals across repeated voucher distributions. No joined current project/account names are invented.
Evidence: frozen official 8.1.0 transaction dictionary, separate 8.1 history/payment/currency/posting help and working import column bindings. Import bindings corroborate money names but are NOT history column definitions, proof of every deployed copy, or permission to import/write. Most dictionary definitions are blank; Oracle type spellings are NOT verified Microsoft SQL Server DDL. Preserve the distinction: Manage Vendor History Remaining Balance is an undistributed invoice amount, not the inquiry unpaid amount. This is not a 2026 schema or installed-compatibility certificate, not Deltek Vantagepoint/Planning/Time & Expense/GovWin.
Requires administrator-authorised on-premises transaction SQL Server and a dedicated least-privilege SELECT account. No dbo owner or direct Deltek Cloud SQL access is assumed. Confirm database/default schema, actual fields/types, complete keys, company scope, date/currency meanings and permitted records. Default-schema object checks refuse ambiguous resolution but do not certify the intended database, source or permissions. Direct SQL does NOT inherit Costpoint accounting/project/employee, ITAR/EAR, role, suppression or masking permissions; opening filters are NOT ACLs. No sa/sysadmin, writes, DDL or administration. Pass Cifru read/compatibility checks, inspect real invoice/payment previews and measure timings.
Not tested on a real ERP or Microsoft SQL Server. Documentary/synthetic SELECT and native DEMO checks do not prove actual installation compatibility, complete data, source ACLs or regulatory compliance. Captures are wholly fictional; no credentials, connection addresses, cached source rows or executable code are distributed. Unofficial, not affiliated with Deltek.
Physical dictionary: https://help.deltek.com/product/Costpoint/Documentation/81DataDictionary.html
Invoice history: https://help.deltek.com/Product/Costpoint/8.1/GA/APQVCHRH_Contents_of_the_View_Voucher_History_Inquiry_Screen.html
Payment semantics: https://help.deltek.com/Product/Costpoint/8.1/GA/APMOPEN_Contents_of_the_Edit_Voucher_Payment_Status_Screen.html
Posted/history context: https://help.deltek.com/Product/Costpoint/8.1/GA/APPPOSTV.html
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Supplier voucher history
- Details: Voucher lines
- Details: Account distributions
- Sub-button: Voucher lines
- Sub-button: Voucher distributions
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VCHR_KEY,N'#')),N':',m.VCHR_KEY,N':') AS VoucherKey, m.VCHR_KEY AS VCHR_KEY, COALESCE(NULLIF(LTRIM(RTRIM(m.VEND_NAME)),N''),m.VEND_ID) AS SupplierName, m.INVC_ID AS INVC_ID, m.VCHR_NO AS VCHR_NO, m.FY_CD AS FY_CD, m.COMPANY_ID AS COMPANY_ID, m.INVC_DT AS INVC_DT, m.DUE_DT AS DUE_DT, m.ANTIC_PAY_DT AS ANTIC_PAY_DT, m.VEND_ID AS VEND_ID, m.PAY_VEND_ID AS PAY_VEND_ID, m.PO_ID AS PO_ID, m.PO_RLSE_NO AS PO_RLSE_NO, m.AP_ACCT_ID AS AP_ACCT_ID, m.AP_ORG_ID AS AP_ORG_ID, 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_DUE_AMT AS TRN_DUE_AMT, m.TRN_SALES_TAX_AMT AS TRN_SALES_TAX_AMT, m.TRN_USE_TAX_AMT AS TRN_USE_TAX_AMT, CASE WHEN o.VCHR_KEY IS NULL THEN N'No matching record — unknown' ELSE N'Matching payment record' END AS OpenRecordContext, CASE WHEN o.VCHR_KEY IS NULL THEN N'Not available' ELSE COALESCE(NULLIF(LTRIM(RTRIM(s.S_STATUS_DESC)),N''),o.S_STATUS_CD) END AS PaymentStatus, o.TRN_PAID_AMT AS RecordedSettlement, o.TRN_PAY_AMT AS SelectedPayment, o.TRN_DISC_TAKEN_AMT AS OpenDiscountAmount, o.TRN_RTN_AMT AS RetainedAmount FROM VCHR_HDR_HS m LEFT JOIN OPEN_AP o ON o.VCHR_KEY=m.VCHR_KEY AND o.VCHR_VEND_ID=m.VEND_ID LEFT JOIN S_AP_STATUS_CD s ON s.S_STATUS_CD=o.S_STATUS_CD WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VCHR_HDR_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_HDR_HS',N'U') AND OBJECT_ID(N'VCHR_LN_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_HS',N'U') AND OBJECT_ID(N'VCHR_LN_ACCT_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_ACCT_HS',N'U') AND OBJECT_ID(N'OPEN_AP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.OPEN_AP',N'U') AND OBJECT_ID(N'S_AP_STATUS_CD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.S_AP_STATUS_CD',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VCHR_KEY,N'#')),N':',m.VCHR_KEY,N':'),CONCAT(LEN(CONCAT(l.VCHR_LN_KEY,N'#')),N':',l.VCHR_LN_KEY,N':')) AS LineKey, CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VCHR_KEY,N'#')),N':',m.VCHR_KEY,N':') AS ParentVoucherKey, m.VCHR_KEY AS VCHR_KEY, l.VCHR_LN_KEY AS VCHR_LN_KEY, l.VCHR_LN_DESC AS VCHR_LN_DESC, l.VCHR_LN_NO AS VCHR_LN_NO, m.INVC_ID AS INVC_ID, m.COMPANY_ID AS COMPANY_ID, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, l.QTY AS QTY, l.UM_CD AS UM_CD, l.TRN_UNIT_CST_AMT AS TRN_UNIT_CST_AMT, l.TRN_EXT_CST_AMT AS TRN_EXT_CST_AMT, l.TRN_LN_CHG_CST_AMT AS TRN_LN_CHG_CST_AMT, l.TRN_SALES_TAX_AMT AS TRN_SALES_TAX_AMT, l.TRN_USE_TAX_AMT AS TRN_USE_TAX_AMT, l.TRN_LN_CHG_TAX_AMT AS TRN_LN_CHG_TAX_AMT, l.TRN_LN_CHG_USE_AMT AS TRN_LN_CHG_USE_AMT, l.TRN_TOT_BEF_DC_AMT AS TRN_TOT_BEF_DC_AMT, l.TRN_DISC_AMT AS TRN_DISC_AMT, l.TRN_NET_AMT AS TRN_NET_AMT, l.TRN_RECOVERY_AMT AS TRN_RECOVERY_AMT, l.SALES_TAX_CD AS SALES_TAX_CD, l.S_TAXABLE_CD AS Taxability, l.PO_ID AS PO_ID, l.PO_RLSE_NO AS PO_RLSE_NO, l.PO_LN_NO AS PO_LN_NO FROM VCHR_LN_HS l INNER JOIN VCHR_HDR_HS m ON m.VCHR_KEY=l.VCHR_KEY WHERE m.VCHR_KEY=:voucher_key AND m.COMPANY_ID=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VCHR_HDR_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_HDR_HS',N'U') AND OBJECT_ID(N'VCHR_LN_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_HS',N'U') AND OBJECT_ID(N'VCHR_LN_ACCT_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_ACCT_HS',N'U') AND OBJECT_ID(N'OPEN_AP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.OPEN_AP',N'U') AND OBJECT_ID(N'S_AP_STATUS_CD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.S_AP_STATUS_CD',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VCHR_KEY,N'#')),N':',m.VCHR_KEY,N':'),CONCAT(LEN(CONCAT(l.VCHR_LN_KEY,N'#')),N':',l.VCHR_LN_KEY,N':'),CONCAT(LEN(CONCAT(a.VCHR_LN_ACCT_KEY,N'#')),N':',a.VCHR_LN_ACCT_KEY,N':')) AS DistributionKey, CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VCHR_KEY,N'#')),N':',m.VCHR_KEY,N':'),CONCAT(LEN(CONCAT(l.VCHR_LN_KEY,N'#')),N':',l.VCHR_LN_KEY,N':')) AS ParentLineKey, a.ACCT_ID AS ACCT_ID, a.PROJ_ID AS PROJ_ID, a.ORG_ID AS ORG_ID, m.INVC_ID AS INVC_ID, l.VCHR_LN_NO AS VCHR_LN_NO, m.COMPANY_ID AS COMPANY_ID, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, a.TRN_CST_AMT AS TRN_CST_AMT, a.TRN_LN_CHG_CST_AMT AS TRN_LN_CHG_CST_AMT, a.TRN_SALES_TAX_AMT AS TRN_SALES_TAX_AMT, a.TRN_USE_TAX_AMT AS TRN_USE_TAX_AMT, a.TRN_TOT_BEF_DC_AMT AS TRN_TOT_BEF_DC_AMT, a.TRN_DISC_AMT AS TRN_DISC_AMT, a.TRN_NET_AMT AS TRN_NET_AMT, a.TRN_RECOVERY_AMT AS TRN_RECOVERY_AMT, a.REF1_ID AS REF1_ID, a.REF2_ID AS REF2_ID, a.PROJ_ACCT_ABBRV_CD AS PROJ_ACCT_ABBRV_CD FROM VCHR_LN_HS l INNER JOIN VCHR_HDR_HS m ON m.VCHR_KEY=l.VCHR_KEY INNER JOIN VCHR_LN_ACCT_HS a ON a.VCHR_KEY=l.VCHR_KEY AND a.VCHR_LN_KEY=l.VCHR_LN_KEY WHERE m.VCHR_KEY=:voucher_key AND m.COMPANY_ID=:company AND l.VCHR_LN_KEY=:line_key AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VCHR_HDR_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_HDR_HS',N'U') AND OBJECT_ID(N'VCHR_LN_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_HS',N'U') AND OBJECT_ID(N'VCHR_LN_ACCT_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_ACCT_HS',N'U') AND OBJECT_ID(N'OPEN_AP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.OPEN_AP',N'U') AND OBJECT_ID(N'S_AP_STATUS_CD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.S_AP_STATUS_CD',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": "91171080-0FFA-52CB-AAC4-8D30230339D4",
"kind": "sqlServer",
"requiredObjects": [
"VCHR_HDR_HS",
"VCHR_LN_HS",
"VCHR_LN_ACCT_HS",
"OPEN_AP",
"S_AP_STATUS_CD"
],
"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": "81DD7B2A-E561-5E1A-8F1C-003846533FA5",
"key": "VoucherKey",
"type": "text"
}
],
"id": "63CD9B9C-6031-540C-BDC2-AFC5D473AA20",
"mappings": [
{
"commonFieldKey": "",
"key": "VoucherKey",
"label": "Internal VoucherKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VoucherKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VCHR_KEY",
"label": "Internal VCHR_KEY",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VCHR_KEY",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Stored supplier name / account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "INVC_ID",
"label": "Supplier invoice",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "INVC_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VCHR_NO",
"label": "Voucher number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VCHR_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FY_CD",
"label": "Fiscal year",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FY_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMPANY_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "INVC_DT",
"label": "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": "ANTIC_PAY_DT",
"label": "Anticipated payment date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ANTIC_PAY_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VEND_ID",
"label": "Invoice supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VEND_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PAY_VEND_ID",
"label": "Stored pay supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PAY_VEND_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_ID",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PO_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_RLSE_NO",
"label": "Purchase release reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PO_RLSE_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AP_ACCT_ID",
"label": "Payables liability account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AP_ACCT_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AP_ORG_ID",
"label": "Payables organization",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AP_ORG_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"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": "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_DUE_AMT",
"label": "Original net due (not remaining)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_DUE_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_SALES_TAX_AMT",
"label": "Sales tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_SALES_TAX_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_USE_TAX_AMT",
"label": "Use tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_USE_TAX_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OpenRecordContext",
"label": "Current payment record context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OpenRecordContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymentStatus",
"label": "Current native payment status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymentStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "RecordedSettlement",
"label": "Settlement recorded (incl. discounts)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RecordedSettlement",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SelectedPayment",
"label": "Selected payment (not paid)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SelectedPayment",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OpenDiscountAmount",
"label": "Open-record discount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OpenDiscountAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RetainedAmount",
"label": "Amount retained (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RetainedAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Supplier voucher history",
"primaryKey": "VoucherKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"SupplierName",
"INVC_ID",
"VCHR_NO",
"FY_CD",
"COMPANY_ID",
"INVC_DT",
"DUE_DT",
"ANTIC_PAY_DT",
"VEND_ID",
"PAY_VEND_ID",
"PO_ID",
"PO_RLSE_NO",
"AP_ACCT_ID",
"AP_ORG_ID",
"TRN_CRNCY_CD",
"TRN_INVC_AMT",
"TRN_DISC_AMT",
"TRN_DUE_AMT",
"TRN_SALES_TAX_AMT",
"TRN_USE_TAX_AMT",
"OpenRecordContext",
"PaymentStatus",
"RecordedSettlement",
"SelectedPayment",
"OpenDiscountAmount",
"RetainedAmount"
],
"sourceID": "91171080-0FFA-52CB-AAC4-8D30230339D4",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VCHR_KEY,N'#')),N':',m.VCHR_KEY,N':') AS VoucherKey, m.VCHR_KEY AS VCHR_KEY, COALESCE(NULLIF(LTRIM(RTRIM(m.VEND_NAME)),N''),m.VEND_ID) AS SupplierName, m.INVC_ID AS INVC_ID, m.VCHR_NO AS VCHR_NO, m.FY_CD AS FY_CD, m.COMPANY_ID AS COMPANY_ID, m.INVC_DT AS INVC_DT, m.DUE_DT AS DUE_DT, m.ANTIC_PAY_DT AS ANTIC_PAY_DT, m.VEND_ID AS VEND_ID, m.PAY_VEND_ID AS PAY_VEND_ID, m.PO_ID AS PO_ID, m.PO_RLSE_NO AS PO_RLSE_NO, m.AP_ACCT_ID AS AP_ACCT_ID, m.AP_ORG_ID AS AP_ORG_ID, 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_DUE_AMT AS TRN_DUE_AMT, m.TRN_SALES_TAX_AMT AS TRN_SALES_TAX_AMT, m.TRN_USE_TAX_AMT AS TRN_USE_TAX_AMT, CASE WHEN o.VCHR_KEY IS NULL THEN N'No matching record — unknown' ELSE N'Matching payment record' END AS OpenRecordContext, CASE WHEN o.VCHR_KEY IS NULL THEN N'Not available' ELSE COALESCE(NULLIF(LTRIM(RTRIM(s.S_STATUS_DESC)),N''),o.S_STATUS_CD) END AS PaymentStatus, o.TRN_PAID_AMT AS RecordedSettlement, o.TRN_PAY_AMT AS SelectedPayment, o.TRN_DISC_TAKEN_AMT AS OpenDiscountAmount, o.TRN_RTN_AMT AS RetainedAmount FROM VCHR_HDR_HS m LEFT JOIN OPEN_AP o ON o.VCHR_KEY=m.VCHR_KEY AND o.VCHR_VEND_ID=m.VEND_ID LEFT JOIN S_AP_STATUS_CD s ON s.S_STATUS_CD=o.S_STATUS_CD WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VCHR_HDR_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_HDR_HS',N'U') AND OBJECT_ID(N'VCHR_LN_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_HS',N'U') AND OBJECT_ID(N'VCHR_LN_ACCT_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_ACCT_HS',N'U') AND OBJECT_ID(N'OPEN_AP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.OPEN_AP',N'U') AND OBJECT_ID(N'S_AP_STATUS_CD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.S_AP_STATUS_CD',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "3C5A6603-A584-5D38-B38A-3DD9F1BF8B50",
"key": "VCHR_LN_NO",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "97D8D6E6-5AEA-5466-8B28-D672A74BC1CE",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Internal LineKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentVoucherKey",
"label": "Internal ParentVoucherKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentVoucherKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VCHR_KEY",
"label": "Internal VCHR_KEY",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VCHR_KEY",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VCHR_LN_KEY",
"label": "Internal VCHR_LN_KEY",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VCHR_LN_KEY",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VCHR_LN_DESC",
"label": "Stored voucher line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VCHR_LN_DESC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VCHR_LN_NO",
"label": "Business voucher line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VCHR_LN_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "INVC_ID",
"label": "Supplier invoice",
"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": "TRN_CRNCY_CD",
"label": "Invoice transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TRN_CRNCY_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QTY",
"label": "Invoice quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTY",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UM_CD",
"label": "Invoice unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UM_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_UNIT_CST_AMT",
"label": "Unit cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_UNIT_CST_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_EXT_CST_AMT",
"label": "Extended cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_EXT_CST_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_LN_CHG_CST_AMT",
"label": "Line charges (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_LN_CHG_CST_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_SALES_TAX_AMT",
"label": "Sales tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_SALES_TAX_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_USE_TAX_AMT",
"label": "Use tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_USE_TAX_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_LN_CHG_TAX_AMT",
"label": "Charge sales tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_LN_CHG_TAX_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_LN_CHG_USE_AMT",
"label": "Charge use tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_LN_CHG_USE_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_TOT_BEF_DC_AMT",
"label": "Before discount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_TOT_BEF_DC_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_DISC_AMT",
"label": "Line discount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_DISC_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_NET_AMT",
"label": "Line net amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_NET_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_RECOVERY_AMT",
"label": "Recovery amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_RECOVERY_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SALES_TAX_CD",
"label": "Sales tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SALES_TAX_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Taxability",
"label": "Native taxability code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Taxability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_ID",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PO_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PO_RLSE_NO",
"label": "Purchase release reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PO_RLSE_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_LN_NO",
"label": "Purchase business line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PO_LN_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Voucher lines",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VCHR_KEY",
"id": "2C8B6972-2189-5FF2-A994-D10D32F13C87",
"name": "voucher_key",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "COMPANY_ID",
"id": "7DAC8C06-C8D8-5FCB-A70A-1B2A94E99669",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VCHR_LN_DESC",
"VCHR_LN_NO",
"INVC_ID",
"COMPANY_ID",
"TRN_CRNCY_CD",
"QTY",
"UM_CD",
"TRN_UNIT_CST_AMT",
"TRN_EXT_CST_AMT",
"TRN_LN_CHG_CST_AMT",
"TRN_SALES_TAX_AMT",
"TRN_USE_TAX_AMT",
"TRN_LN_CHG_TAX_AMT",
"TRN_LN_CHG_USE_AMT",
"TRN_TOT_BEF_DC_AMT",
"TRN_DISC_AMT",
"TRN_NET_AMT",
"TRN_RECOVERY_AMT",
"SALES_TAX_CD",
"Taxability",
"PO_ID",
"PO_RLSE_NO",
"PO_LN_NO"
],
"sourceID": "91171080-0FFA-52CB-AAC4-8D30230339D4",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VCHR_KEY,N'#')),N':',m.VCHR_KEY,N':'),CONCAT(LEN(CONCAT(l.VCHR_LN_KEY,N'#')),N':',l.VCHR_LN_KEY,N':')) AS LineKey, CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VCHR_KEY,N'#')),N':',m.VCHR_KEY,N':') AS ParentVoucherKey, m.VCHR_KEY AS VCHR_KEY, l.VCHR_LN_KEY AS VCHR_LN_KEY, l.VCHR_LN_DESC AS VCHR_LN_DESC, l.VCHR_LN_NO AS VCHR_LN_NO, m.INVC_ID AS INVC_ID, m.COMPANY_ID AS COMPANY_ID, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, l.QTY AS QTY, l.UM_CD AS UM_CD, l.TRN_UNIT_CST_AMT AS TRN_UNIT_CST_AMT, l.TRN_EXT_CST_AMT AS TRN_EXT_CST_AMT, l.TRN_LN_CHG_CST_AMT AS TRN_LN_CHG_CST_AMT, l.TRN_SALES_TAX_AMT AS TRN_SALES_TAX_AMT, l.TRN_USE_TAX_AMT AS TRN_USE_TAX_AMT, l.TRN_LN_CHG_TAX_AMT AS TRN_LN_CHG_TAX_AMT, l.TRN_LN_CHG_USE_AMT AS TRN_LN_CHG_USE_AMT, l.TRN_TOT_BEF_DC_AMT AS TRN_TOT_BEF_DC_AMT, l.TRN_DISC_AMT AS TRN_DISC_AMT, l.TRN_NET_AMT AS TRN_NET_AMT, l.TRN_RECOVERY_AMT AS TRN_RECOVERY_AMT, l.SALES_TAX_CD AS SALES_TAX_CD, l.S_TAXABLE_CD AS Taxability, l.PO_ID AS PO_ID, l.PO_RLSE_NO AS PO_RLSE_NO, l.PO_LN_NO AS PO_LN_NO FROM VCHR_LN_HS l INNER JOIN VCHR_HDR_HS m ON m.VCHR_KEY=l.VCHR_KEY WHERE m.VCHR_KEY=:voucher_key AND m.COMPANY_ID=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VCHR_HDR_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_HDR_HS',N'U') AND OBJECT_ID(N'VCHR_LN_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_HS',N'U') AND OBJECT_ID(N'VCHR_LN_ACCT_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_ACCT_HS',N'U') AND OBJECT_ID(N'OPEN_AP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.OPEN_AP',N'U') AND OBJECT_ID(N'S_AP_STATUS_CD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.S_AP_STATUS_CD',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "9885EF93-EC93-5480-8F15-88C4E9C5FFBE",
"key": "ACCT_ID",
"type": "text"
},
{
"direction": "ascending",
"id": "BF20F508-E9F4-5948-9022-A3FAD48E3124",
"key": "PROJ_ID",
"type": "text"
},
{
"direction": "ascending",
"id": "4F458A2C-358B-5577-87CF-9C95B536418D",
"key": "DistributionKey",
"type": "text"
}
],
"id": "80B62439-8F55-587B-BC36-8B2DFEC69862",
"mappings": [
{
"commonFieldKey": "",
"key": "DistributionKey",
"label": "Internal DistributionKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DistributionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentLineKey",
"label": "Internal ParentLineKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentLineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACCT_ID",
"label": "Distribution account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ACCT_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROJ_ID",
"label": "Project code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROJ_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORG_ID",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ORG_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "INVC_ID",
"label": "Supplier invoice",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "INVC_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VCHR_LN_NO",
"label": "Business voucher line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VCHR_LN_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMPANY_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"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_CST_AMT",
"label": "Distributed cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_CST_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_LN_CHG_CST_AMT",
"label": "Distributed line charges",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_LN_CHG_CST_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_SALES_TAX_AMT",
"label": "Distributed sales tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_SALES_TAX_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_USE_TAX_AMT",
"label": "Distributed use tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_USE_TAX_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_TOT_BEF_DC_AMT",
"label": "Distributed before discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_TOT_BEF_DC_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_DISC_AMT",
"label": "Distributed discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_DISC_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_NET_AMT",
"label": "Distributed net amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_NET_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_RECOVERY_AMT",
"label": "Distributed recovery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_RECOVERY_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REF1_ID",
"label": "Reference 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "REF1_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REF2_ID",
"label": "Reference 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "REF2_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROJ_ACCT_ABBRV_CD",
"label": "Project account abbreviation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROJ_ACCT_ABBRV_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Voucher distributions",
"primaryKey": "DistributionKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VCHR_KEY",
"id": "2C8B6972-2189-5FF2-A994-D10D32F13C87",
"name": "voucher_key",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "COMPANY_ID",
"id": "7DAC8C06-C8D8-5FCB-A70A-1B2A94E99669",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VCHR_LN_KEY",
"id": "E1168EE5-705C-5BB1-AA62-67782197DC5D",
"name": "line_key",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ACCT_ID",
"PROJ_ID",
"ORG_ID",
"INVC_ID",
"VCHR_LN_NO",
"COMPANY_ID",
"TRN_CRNCY_CD",
"TRN_CST_AMT",
"TRN_LN_CHG_CST_AMT",
"TRN_SALES_TAX_AMT",
"TRN_USE_TAX_AMT",
"TRN_TOT_BEF_DC_AMT",
"TRN_DISC_AMT",
"TRN_NET_AMT",
"TRN_RECOVERY_AMT",
"REF1_ID",
"REF2_ID",
"PROJ_ACCT_ABBRV_CD"
],
"sourceID": "91171080-0FFA-52CB-AAC4-8D30230339D4",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VCHR_KEY,N'#')),N':',m.VCHR_KEY,N':'),CONCAT(LEN(CONCAT(l.VCHR_LN_KEY,N'#')),N':',l.VCHR_LN_KEY,N':'),CONCAT(LEN(CONCAT(a.VCHR_LN_ACCT_KEY,N'#')),N':',a.VCHR_LN_ACCT_KEY,N':')) AS DistributionKey, CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VCHR_KEY,N'#')),N':',m.VCHR_KEY,N':'),CONCAT(LEN(CONCAT(l.VCHR_LN_KEY,N'#')),N':',l.VCHR_LN_KEY,N':')) AS ParentLineKey, a.ACCT_ID AS ACCT_ID, a.PROJ_ID AS PROJ_ID, a.ORG_ID AS ORG_ID, m.INVC_ID AS INVC_ID, l.VCHR_LN_NO AS VCHR_LN_NO, m.COMPANY_ID AS COMPANY_ID, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, a.TRN_CST_AMT AS TRN_CST_AMT, a.TRN_LN_CHG_CST_AMT AS TRN_LN_CHG_CST_AMT, a.TRN_SALES_TAX_AMT AS TRN_SALES_TAX_AMT, a.TRN_USE_TAX_AMT AS TRN_USE_TAX_AMT, a.TRN_TOT_BEF_DC_AMT AS TRN_TOT_BEF_DC_AMT, a.TRN_DISC_AMT AS TRN_DISC_AMT, a.TRN_NET_AMT AS TRN_NET_AMT, a.TRN_RECOVERY_AMT AS TRN_RECOVERY_AMT, a.REF1_ID AS REF1_ID, a.REF2_ID AS REF2_ID, a.PROJ_ACCT_ABBRV_CD AS PROJ_ACCT_ABBRV_CD FROM VCHR_LN_HS l INNER JOIN VCHR_HDR_HS m ON m.VCHR_KEY=l.VCHR_KEY INNER JOIN VCHR_LN_ACCT_HS a ON a.VCHR_KEY=l.VCHR_KEY AND a.VCHR_LN_KEY=l.VCHR_LN_KEY WHERE m.VCHR_KEY=:voucher_key AND m.COMPANY_ID=:company AND l.VCHR_LN_KEY=:line_key AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VCHR_HDR_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_HDR_HS',N'U') AND OBJECT_ID(N'VCHR_LN_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_HS',N'U') AND OBJECT_ID(N'VCHR_LN_ACCT_HS',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VCHR_LN_ACCT_HS',N'U') AND OBJECT_ID(N'OPEN_AP',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.OPEN_AP',N'U') AND OBJECT_ID(N'S_AP_STATUS_CD',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.S_AP_STATUS_CD',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "0CD4B4A2-77F5-585F-A46C-FBFF394415C7",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "3C54FCAE-FA86-5B90-8B37-350FDF280AAA",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "97D8D6E6-5AEA-5466-8B28-D672A74BC1CE",
"title": "Voucher lines",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VCHR_NO",
"label": "Voucher number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FY_CD",
"label": "Fiscal year",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "INVC_DT",
"label": "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": "Invoice amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaymentStatus",
"label": "Current native payment status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "63CD9B9C-6031-540C-BDC2-AFC5D473AA20",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Invoice and native payment status",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Stored supplier name / account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and native payment status",
"detailRole": "information",
"isVisible": true,
"key": "INVC_ID",
"label": "Supplier invoice",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and native payment status",
"detailRole": "information",
"isVisible": true,
"key": "VCHR_NO",
"label": "Voucher number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Invoice and native payment status",
"detailRole": "information",
"isVisible": true,
"key": "FY_CD",
"label": "Fiscal year",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and native payment status",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and native payment status",
"detailRole": "information",
"isVisible": true,
"key": "INVC_DT",
"label": "Invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Invoice and native payment status",
"detailRole": "information",
"isVisible": true,
"key": "DUE_DT",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Invoice and native payment status",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Invoice transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Invoice and native payment status",
"detailRole": "information",
"isVisible": true,
"key": "TRN_INVC_AMT",
"label": "Invoice amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Invoice and native payment status",
"detailRole": "information",
"isVisible": true,
"key": "PaymentStatus",
"label": "Current native payment status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Original invoice amounts",
"detailRole": "information",
"isVisible": true,
"key": "TRN_DISC_AMT",
"label": "Original discount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Original invoice amounts",
"detailRole": "information",
"isVisible": true,
"key": "TRN_DUE_AMT",
"label": "Original net due (not remaining)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Original invoice amounts",
"detailRole": "information",
"isVisible": true,
"key": "TRN_SALES_TAX_AMT",
"label": "Sales tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Original invoice amounts",
"detailRole": "information",
"isVisible": true,
"key": "TRN_USE_TAX_AMT",
"label": "Use tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Payment context — not bank evidence",
"detailRole": "information",
"isVisible": true,
"key": "OpenRecordContext",
"label": "Current payment record context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment context — not bank evidence",
"detailRole": "information",
"isVisible": true,
"key": "RecordedSettlement",
"label": "Settlement recorded (incl. discounts)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Payment context — not bank evidence",
"detailRole": "information",
"isVisible": true,
"key": "SelectedPayment",
"label": "Selected payment (not paid)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Payment context — not bank evidence",
"detailRole": "information",
"isVisible": true,
"key": "OpenDiscountAmount",
"label": "Open-record discount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Payment context — not bank evidence",
"detailRole": "information",
"isVisible": true,
"key": "RetainedAmount",
"label": "Amount retained (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Payment context — not bank evidence",
"detailRole": "information",
"isVisible": true,
"key": "ANTIC_PAY_DT",
"label": "Anticipated payment date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Supplier and liability references",
"detailRole": "information",
"isVisible": true,
"key": "VEND_ID",
"label": "Invoice supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Supplier and liability references",
"detailRole": "information",
"isVisible": true,
"key": "PAY_VEND_ID",
"label": "Stored pay supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Supplier and liability references",
"detailRole": "information",
"isVisible": true,
"key": "PO_ID",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Supplier and liability references",
"detailRole": "information",
"isVisible": true,
"key": "PO_RLSE_NO",
"label": "Purchase release reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Supplier and liability references",
"detailRole": "information",
"isVisible": true,
"key": "AP_ACCT_ID",
"label": "Payables liability account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Supplier and liability references",
"detailRole": "information",
"isVisible": true,
"key": "AP_ORG_ID",
"label": "Payables organization",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "1CE970D6-4C04-5694-82C2-7212B17BB059",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "12EE6C8B-47CF-59B9-A5E5-00ACE1CF2539",
"includeAllOption": false,
"key": "INVC_DT",
"title": "Invoice 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": "81DD7B2A-E561-5E1A-8F1C-003846533FA5",
"key": "VoucherKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "INVC_ID",
"systemImage": "doc.text",
"title": "Supplier voucher history",
"titleKey": "SupplierName"
},
{
"actions": [
{
"id": "6A4B5152-1BD1-5974-B48E-202BC2614F00",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "6CB8B5C9-9676-5295-BA2A-C5F8E770A82C",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "80B62439-8F55-587B-BC36-8B2DFEC69862",
"title": "Account distributions",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VCHR_LN_NO",
"label": "Business voucher line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTY",
"label": "Invoice quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UM_CD",
"label": "Invoice unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Invoice transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_NET_AMT",
"label": "Line net amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PO_ID",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PO_LN_NO",
"label": "Purchase business line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "97D8D6E6-5AEA-5466-8B28-D672A74BC1CE",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Voucher line and quantity",
"detailRole": "information",
"isVisible": true,
"key": "VCHR_LN_DESC",
"label": "Stored voucher line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher line and quantity",
"detailRole": "information",
"isVisible": true,
"key": "INVC_ID",
"label": "Supplier invoice",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher line and quantity",
"detailRole": "information",
"isVisible": true,
"key": "VCHR_LN_NO",
"label": "Business voucher line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Voucher line and quantity",
"detailRole": "information",
"isVisible": true,
"key": "QTY",
"label": "Invoice quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Voucher line and quantity",
"detailRole": "information",
"isVisible": true,
"key": "UM_CD",
"label": "Invoice unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher line and quantity",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Invoice transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher line and quantity",
"detailRole": "information",
"isVisible": true,
"key": "TRN_NET_AMT",
"label": "Line net amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Voucher line and quantity",
"detailRole": "information",
"isVisible": true,
"key": "PO_ID",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Voucher line and quantity",
"detailRole": "information",
"isVisible": true,
"key": "PO_LN_NO",
"label": "Purchase business line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction cost and charges",
"detailRole": "information",
"isVisible": true,
"key": "TRN_UNIT_CST_AMT",
"label": "Unit cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction cost and charges",
"detailRole": "information",
"isVisible": true,
"key": "TRN_EXT_CST_AMT",
"label": "Extended cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction cost and charges",
"detailRole": "information",
"isVisible": true,
"key": "TRN_LN_CHG_CST_AMT",
"label": "Line charges (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction cost and charges",
"detailRole": "information",
"isVisible": true,
"key": "TRN_TOT_BEF_DC_AMT",
"label": "Before discount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction cost and charges",
"detailRole": "information",
"isVisible": true,
"key": "TRN_DISC_AMT",
"label": "Line discount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction cost and charges",
"detailRole": "information",
"isVisible": true,
"key": "TRN_RECOVERY_AMT",
"label": "Recovery amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored tax components",
"detailRole": "information",
"isVisible": true,
"key": "TRN_SALES_TAX_AMT",
"label": "Sales tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored tax components",
"detailRole": "information",
"isVisible": true,
"key": "TRN_USE_TAX_AMT",
"label": "Use tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored tax components",
"detailRole": "information",
"isVisible": true,
"key": "TRN_LN_CHG_TAX_AMT",
"label": "Charge sales tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored tax components",
"detailRole": "information",
"isVisible": true,
"key": "TRN_LN_CHG_USE_AMT",
"label": "Charge use tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored tax components",
"detailRole": "information",
"isVisible": true,
"key": "SALES_TAX_CD",
"label": "Sales tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored tax components",
"detailRole": "information",
"isVisible": true,
"key": "Taxability",
"label": "Native taxability code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent references",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent references",
"detailRole": "information",
"isVisible": true,
"key": "PO_RLSE_NO",
"label": "Purchase release reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "9917D177-F20D-5CC4-9D92-329695EFB214",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "3C5A6603-A584-5D38-B38A-3DD9F1BF8B50",
"key": "VCHR_LN_NO",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "INVC_ID",
"systemImage": "doc.text",
"title": "Voucher lines",
"titleKey": "VCHR_LN_DESC"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORG_ID",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VCHR_LN_NO",
"label": "Business voucher line",
"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_CST_AMT",
"label": "Distributed cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_NET_AMT",
"label": "Distributed net amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "80B62439-8F55-587B-BC36-8B2DFEC69862",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Project and account distribution",
"detailRole": "information",
"isVisible": true,
"key": "ACCT_ID",
"label": "Distribution account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and account distribution",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_ID",
"label": "Project code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and account distribution",
"detailRole": "information",
"isVisible": true,
"key": "ORG_ID",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and account distribution",
"detailRole": "information",
"isVisible": true,
"key": "VCHR_LN_NO",
"label": "Business voucher line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Project and account distribution",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Invoice transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project and account distribution",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CST_AMT",
"label": "Distributed cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Project and account distribution",
"detailRole": "information",
"isVisible": true,
"key": "TRN_NET_AMT",
"label": "Distributed net amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction components",
"detailRole": "information",
"isVisible": true,
"key": "TRN_LN_CHG_CST_AMT",
"label": "Distributed line charges",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction components",
"detailRole": "information",
"isVisible": true,
"key": "TRN_SALES_TAX_AMT",
"label": "Distributed sales tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction components",
"detailRole": "information",
"isVisible": true,
"key": "TRN_USE_TAX_AMT",
"label": "Distributed use tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction components",
"detailRole": "information",
"isVisible": true,
"key": "TRN_TOT_BEF_DC_AMT",
"label": "Distributed before discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction components",
"detailRole": "information",
"isVisible": true,
"key": "TRN_DISC_AMT",
"label": "Distributed discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction components",
"detailRole": "information",
"isVisible": true,
"key": "TRN_RECOVERY_AMT",
"label": "Distributed recovery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Parent and business references",
"detailRole": "information",
"isVisible": true,
"key": "INVC_ID",
"label": "Supplier invoice",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent and business references",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent and business references",
"detailRole": "information",
"isVisible": true,
"key": "REF1_ID",
"label": "Reference 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent and business references",
"detailRole": "information",
"isVisible": true,
"key": "REF2_ID",
"label": "Reference 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent and business references",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_ACCT_ABBRV_CD",
"label": "Project account abbreviation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "5749C731-6540-5050-A852-EDE1C71C2916",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "9885EF93-EC93-5480-8F15-88C4E9C5FFBE",
"key": "ACCT_ID",
"type": "text"
},
{
"direction": "ascending",
"id": "BF20F508-E9F4-5948-9022-A3FAD48E3124",
"key": "PROJ_ID",
"type": "text"
},
{
"direction": "ascending",
"id": "4F458A2C-358B-5577-87CF-9C95B536418D",
"key": "DistributionKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "PROJ_ID",
"systemImage": "doc.text",
"title": "Voucher distributions",
"titleKey": "ACCT_ID"
}
],
"relations": [
{
"childDatasetID": "97D8D6E6-5AEA-5466-8B28-D672A74BC1CE",
"childKey": "ParentVoucherKey",
"id": "3C54FCAE-FA86-5B90-8B37-350FDF280AAA",
"name": "Voucher lines",
"parentDatasetID": "63CD9B9C-6031-540C-BDC2-AFC5D473AA20",
"parentKey": "VoucherKey"
},
{
"childDatasetID": "80B62439-8F55-587B-BC36-8B2DFEC69862",
"childKey": "ParentLineKey",
"id": "6CB8B5C9-9676-5295-BA2A-C5F8E770A82C",
"name": "Account distributions",
"parentDatasetID": "97D8D6E6-5AEA-5466-8B28-D672A74BC1CE",
"parentKey": "LineKey"
}
],
"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, project controllers and managers: choose company and invoice period, inspect supplier voucher history, invoice/due dates and original amounts, then open voucher lines and their project/account/organization distributions. Optional matching OPEN_AP data adds native payment status and distinctly labelled settlement/selection context.\n\nWhy Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.\n\nPro: one SQL Server source, three lists, two nested relations, 26 voucher values, 23 line values and 18 distribution values. Native mandatory invoice period (start/end-exclusive) and company apply before the bounded live root read; no unresolved opening SQL parameters or inner TOP. Selector discovery may be bounded and missing options do not prove absence of records. Each child binds numeric voucher key + company; distributions also bind the physical numeric line key, not the editable business line or invoice/voucher number. Joined canonical parent identities preserve exact native relations. Full technical keys, audit fields, bank/tax IDs, document locations and free-form notes are hidden/excluded. Business accounts, project codes and references remain useful. Up to 1,000 rows per list; no completeness, unlimited SQL work or performance guarantee. Child reads only when opened, no automatic refresh; loaded-row search is local.\n\nReads VCHR_HDR_HS/VCHR_LN_HS/VCHR_LN_ACCT_HS, not editable working vouchers removed after posting. History can also contain manually initialized, fully paid legacy records. It is NOT a working-voucher approval queue or a guarantee that every historical row came through normal posting. Supplier name is the stored historical VEND_NAME (or native supplier account fallback), not current master enrichment; VEND_NAME_EXT is not concatenated as a guessed long name. An invoice number may repeat across suppliers and voucher numbers across fiscal years; physical keys keep them separate. Invoice date selection can exclude undated historical records; choose an appropriate period and verify completeness.\n\nAll money is read from stored TRN fields with the history invoice TRN_CRNCY_CD, not functional/payment amounts or current vendor defaults. Original net due = invoice minus original discount in the functional help; it is NOT the remaining unpaid balance. No outstanding balance is calculated. OPEN_AP joins by physical voucher key AND invoice supplier account; its absence/mismatch leaves amounts NULL and context unknown, not Paid or zero. The native status description comes from S_AP_STATUS_CD; unknown status rows fall back to the actual code, never guessed translations. Recorded settlement may include discounts added during payment processing: it is NOT pure cash paid, cleared bank funds, or a complete disbursement history. Selected payment is an instruction for a future check/EFT, not an executed payment. Open-record discount reads OPEN_AP.TRN_DISC_TAKEN_AMT neutrally: the dictionary has no definition and the functional help does not explicitly bind this physical column to pending versus cumulative discounts. Neither is claimed; verify the installed meaning. Retained amount and anticipated payment date are editable ERP context, not evidence of a bank transaction. A stored pay supplier may differ legitimately from the invoice supplier (factoring). All four optional amounts are in invoice transaction currency. Validate actual installed payment behavior and sample vouchers before relying on these fields.\n\nLines preserve quantity/unit, stored unit/extended costs, charges, separate tax components, discount, recovery and net amount. A zero/amount-only quantity does not zero a stored amount; signs, credits and zero values are not converted to absolute/positive values. Taxability stays the native code. Distribution accounts are distinct from the root liability account. No quantity-times-price reconstruction, derived tax, currency/units mixing, allocation percentage scale guess, cross-company sums or totals across repeated voucher distributions. No joined current project/account names are invented.\n\nEvidence: frozen official 8.1.0 transaction dictionary, separate 8.1 history/payment/currency/posting help and working import column bindings. Import bindings corroborate money names but are NOT history column definitions, proof of every deployed copy, or permission to import/write. Most dictionary definitions are blank; Oracle type spellings are NOT verified Microsoft SQL Server DDL. Preserve the distinction: Manage Vendor History Remaining Balance is an undistributed invoice amount, not the inquiry unpaid amount. This is not a 2026 schema or installed-compatibility certificate, not Deltek Vantagepoint/Planning/Time & Expense/GovWin.\n\nRequires administrator-authorised on-premises transaction SQL Server and a dedicated least-privilege SELECT account. No dbo owner or direct Deltek Cloud SQL access is assumed. Confirm database/default schema, actual fields/types, complete keys, company scope, date/currency meanings and permitted records. Default-schema object checks refuse ambiguous resolution but do not certify the intended database, source or permissions. Direct SQL does NOT inherit Costpoint accounting/project/employee, ITAR/EAR, role, suppression or masking permissions; opening filters are NOT ACLs. No sa/sysadmin, writes, DDL or administration. Pass Cifru read/compatibility checks, inspect real invoice/payment previews and measure timings.\n\nNot tested on a real ERP or Microsoft SQL Server. Documentary/synthetic SELECT and native DEMO checks do not prove actual installation compatibility, complete data, source ACLs or regulatory compliance. Captures are wholly fictional; no credentials, connection addresses, cached source rows or executable code are distributed. Unofficial, not affiliated with Deltek.\n\nPhysical dictionary: https://help.deltek.com/product/Costpoint/Documentation/81DataDictionary.html\nInvoice history: https://help.deltek.com/Product/Costpoint/8.1/GA/APQVCHRH_Contents_of_the_View_Voucher_History_Inquiry_Screen.html\nPayment semantics: https://help.deltek.com/Product/Costpoint/8.1/GA/APMOPEN_Contents_of_the_Edit_Voucher_Payment_Status_Screen.html\nPosted/history context: https://help.deltek.com/Product/Costpoint/8.1/GA/APPPOSTV.html",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "BF9164B5-7F8E-5754-BAA6-39A7BD7EBAD2",
"rootButtonCount": 1,
"summary": "Company/period to supplier invoices, distinct original and payment context, voucher lines and nested account/project distributions.",
"tags": [
"Deltek Costpoint",
"SQL Server",
"Supplier invoices",
"Accounting",
"Projects",
"Pro"
],
"title": "Supplier voucher history — lines and distributions Pro"
}
}