Supplier invoices, accounting distributions and supplier — Pro
Choose an invoice period; inspect source amounts and due dates, then accounting allocations and the current supplier on demand.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.
For accounting, purchasing and managers: select an invoice period and inspect current regular supplier invoices, recorded due dates, hold flag, foreign invoice/current-balance amounts and purchase/voucher references. Open rich Details, then load accounting distributions or the current supplier dossier only when needed.
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 authorised company source, three bounded live lists with same-row Details and two lazy sub-buttons. 28 invoice,24 distribution and25 current-supplier useful positions; opaque identity/context keys are hidden. No widgets, computed totals, write operations or periodic refresh. Mandatory native invoice-period selection before the final2,000 invoice cap;500-row child caps. Search and local filters cover loaded rows only. Existing workspace resources count; a cap is not a query-performance guarantee. Amounts/flags are exact source text with textual local sorting/filtering, not formatted currency or calculated balances.
SCOPE: current Apinvc regular invoices only (documented blank ctype). Open-balance, debit, credit-card and deferred-expense headers are excluded, not renamed ordinary invoices. No Apinvch/Apdisth history, deleted/void-history union, payment execution or as-of aging claim. Selecting an invoice-date period does NOT calculate the balance at the end of that period: displayed balances/applied amounts remain CURRENT source values. Recorded last-paid/closed dates are source context, not independently verified payment status. Hold and posting codes stay native; no nonzero-to-true assumption. Source dates can be unknown.
DISTRIBUTIONS: accounting allocation rows, NOT product/quantity invoice lines. Keep AP, nonpayment, prepayment, finance-charge, expense, accrual, receipt/charge, refund, tax-reversal and amendment/void-related native types; unknown types remain unchanged. No filtering to expense-only rows, debit/credit totals, account labels, tax recalculation or amortisation schedule is inferred. A GL code is not a proved account description. Native method/cycle and start/end dates are configuration, not proof of executed amortisation.
MONEY: selected nf* values are recorded FOREIGN amounts. Header currency, distribution currency and CURRENT supplier currency are separate recorded codes; no ISO code, base currency or exchange-rate direction assumed. Different/unknown distribution-vs-header currency receives an explicit context warning; NEVER add or convert such values. Paid, applied, discount, adjustment, prepayment and balance values are read independently, not recomputed or promised to reconcile. Zero, negative, NULL and unknown remain distinct. Verify source currency/type/rate conventions before financial decisions.
IDENTITY: full supplier+invoice key within the authorised companyDB, never invoice number alone or across companies. Parent identity and unchanged invoice type/currency/date are revalidated before each child; UTF16 encoded tokens preserve Unicode, spaces, blank versus NULL through app parent-value trimming. Incomplete/duplicate header identity is excluded, not arbitrarily selected. Full cuid identifies each distribution, hidden from business UI. Missing/empty/ambiguous matching distribution UID blocks the entire distribution branch; an empty branch is not proof of no accounting activity.
CURRENT SUPPLIER: optional unique Apvend enrichment preserves invoices with missing or duplicate supplier masters and an explicit warning; no fanout/arbitrary name. Supplier child requires a unique master and uses a parent-owned key. Contacts, postal address, classification, payment/purchasing codes and currency are CURRENT master values, not invoice snapshots. No bank account or tax/personal identity identifier is selected.
COMPATIBILITY: complete historical AccountMate12 SQL/Express AP reference, original 20April2021 (printedFebruary2021), own49 invoice/distribution field positions and full keys; supplier uses its separately verified AP12 contract. Not AccountMate Enterprise or current SQL14 certification. AMTBL widths/Required are data-entry metadata, not installed DDL/nullability. SQLServer2012+ required for CONCAT. Owner is UNKNOWN: administrator must confirm exactly one readable Apinvc,Apdist,Apvend resolved identically by Android and iOS login/default schema. Android metadata may prefer dbo; iOS queries use default resolution. Ambiguous owners must be replaced with confirmed qualified objects in Studio and bounded read tests repeated. Import is NOT claimed to automatically reject duplicate owners. Verify installed edition/fields/types/full keys, collation, currency semantics, date/decimal/NULL conversion, indexes/plan and response time.
SECURITY: company-authorised least-privilege SELECT-only reporting connection. Direct SQL does not inherit ERP ACL; period/filter selection is not access control. No credentials, server address or business rows in the package. Documentary and adapted synthetic checks do not certify real ERP, native SQLServer, iOS, permissions, performance or subscription purchase. Unofficial, not endorsed by AccountMate.
Documentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_ap_drg.pdf
Gallery: Eight original native Cifru DEMO images show complete invoice, accounting-distribution and current-supplier cards, both actually opened sub-buttons and representative Details. All values are invented; no AccountMate installation was connected. The configuration retains77 useful Detail positions (28invoice,24distribution,25supplier); their nonblank values were checked in full private overlapping native continuations. Native Details suppress the blank regular-invoice type; its configured mapping and hidden type context remain verified. This is a representative gallery, not a claim that eight images show every invoice field. Additional invoice identity/current-context/reference/date/amount Details remain in the JSON and private continuations. No field was removed or screenshot retouched to fit eight. Source amount/type/currency limits and exchange-direction/current-master/allocation caveats remain explicit. A representative subset of four invented invoices was selected from the constrained reference SELECT for filming; negative, NULL, duplicate and stale-parent cases remain in separate tests and unapproved R3/R4 material. Original PNG/XML pairs, frozen invented input and silent RAW are retained for future videos; whole RAW/Home, the native opening-summary internal last7Days label and redundant continuations are private and not video-approved. Pro requirements were checked; capture uses a Pro test entitlement, not a purchase test. This proves native synthetic UI/action traversal, not ERP/SQLServer/iOS/DDL/owner/collation, source conversion, ISO currency, FX direction, ACL, financial reconciliation, completeness or performance.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Supplier invoices
- Details: Accounting distributions
- Details: Current supplier
- Sub-button: Accounting distributions
- Sub-button: Current supplier
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(CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END) AS DocumentKey, CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AS VendorToken, CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AS InvoiceToken, CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END AS TypeToken, CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END AS InvoiceDateToken, CAST(h.cvendno AS nvarchar(max)) AS cvendno, CAST(h.cinvno AS nvarchar(max)) AS cinvno, CAST(h.cpono AS nvarchar(max)) AS cpono, CAST(h.cref AS nvarchar(max)) AS cref, CAST(h.cdescript AS nvarchar(max)) AS cdescript, CAST(h.ctype AS nvarchar(max)) AS ctype, CAST(h.cvoucherno AS nvarchar(max)) AS cvoucherno, CAST(h.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(h.ctaxcode AS nvarchar(max)) AS ctaxcode, CONVERT(varchar(10), h.dinvoice, 23) AS dinvoice, CONVERT(varchar(10), h.ddue, 23) AS ddue, CONVERT(varchar(10), h.ddisc, 23) AS ddisc, CONVERT(varchar(10), h.dlastpaid, 23) AS dlastpaid, CONVERT(varchar(10), h.dclosed, 23) AS dclosed, CAST(h.lhold AS nvarchar(max)) AS lhold, CAST(h.nfdiscamt AS nvarchar(max)) AS nfdiscamt, CAST(h.nfinvamt AS nvarchar(max)) AS nfinvamt, CAST(h.nfappamt AS nvarchar(max)) AS nfappamt, CAST(h.nfappdisc AS nvarchar(max)) AS nfappdisc, CAST(h.nfappadj AS nvarchar(max)) AS nfappadj, CAST(h.nfdappamt AS nvarchar(max)) AS nfdappamt, CAST(h.nfnonpamt AS nvarchar(max)) AS nfnonpamt, CAST(h.nfchrgamt AS nvarchar(max)) AS nfchrgamt, CAST(h.nfpaid AS nvarchar(max)) AS nfpaid, CAST(h.nfbalance AS nvarchar(max)) AS nfbalance, CAST(h.nxchgrate AS nvarchar(max)) AS nxchgrate, COALESCE(NULLIF(v.ccompany,N''),h.cvendno) AS SupplierLabel, CAST(v.ccompany AS nvarchar(max)) AS CurrentSupplierName, CASE WHEN v.cvendno IS NULL THEN N'Missing or ambiguous current supplier — verify source' ELSE N'Unique current supplier; not invoice snapshot' END AS VendorContext FROM Apinvc h LEFT JOIN Apvend v ON v.cvendno=h.cvendno AND 1=(SELECT COUNT(*) FROM Apvend vq WHERE vq.cvendno=v.cvendno) WHERE h.ctype=N'' AND h.cvendno<>N'' AND h.cinvno<>N'' AND h.cvendno IS NOT NULL AND DATALENGTH(CAST(h.cvendno AS nvarchar(max)))>0 AND h.cinvno IS NOT NULL AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Apinvc hq WHERE hq.cvendno=h.cvendno AND hq.cinvno=h.cinvno)
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END) AS ParentKey, CONCAT(CONCAT(CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END),N':',CASE WHEN d.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(d.cuid AS nvarchar(max))), 2)) END) AS DistributionKey, CAST(d.cvendno AS nvarchar(max)) AS cvendno, CAST(d.cinvno AS nvarchar(max)) AS cinvno, CAST(d.cglacc AS nvarchar(max)) AS cglacc, CAST(d.camrtexacc AS nvarchar(max)) AS camrtexacc, CAST(d.camrtmethd AS nvarchar(max)) AS camrtmethd, CAST(d.camrtrecur AS nvarchar(max)) AS camrtrecur, CAST(d.ctype AS nvarchar(max)) AS ctype, CAST(d.coldtype AS nvarchar(max)) AS coldtype, CAST(d.cdescript AS nvarchar(max)) AS cdescript, CAST(d.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(d.ctogl AS nvarchar(max)) AS ctogl, CAST(d.crcptno AS nvarchar(max)) AS crcptno, CAST(d.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(d.clinedesc AS nvarchar(max)) AS clinedesc, CONVERT(varchar(10), d.dtrs, 23) AS dtrs, CONVERT(varchar(10), d.damrtstart, 23) AS damrtstart, CONVERT(varchar(10), d.damrtend, 23) AS damrtend, CAST(d.lamortize AS nvarchar(max)) AS lamortize, CAST(d.nfamount AS nvarchar(max)) AS nfamount, CAST(d.nftaxamt1 AS nvarchar(max)) AS nftaxamt1, CAST(d.nftaxamt2 AS nvarchar(max)) AS nftaxamt2, CAST(d.nftaxamt3 AS nvarchar(max)) AS nftaxamt3, COALESCE(NULLIF(d.clinedesc,N''),NULLIF(d.cdescript,N''),d.cglacc) AS DistributionTitle, CAST(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode, CASE WHEN d.ccurrcode IS NULL OR h.ccurrcode IS NULL OR d.ccurrcode=N'' OR h.ccurrcode=N'' THEN N'Unknown currency context — verify source' WHEN d.ccurrcode=h.ccurrcode THEN N'Same recorded currency code; no conversion' ELSE N'Different recorded currency codes — do not combine' END AS CurrencyContext FROM Apinvc h INNER JOIN Apdist d ON d.cvendno=h.cvendno AND d.cinvno=h.cinvno AND CASE WHEN d.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(d.cvendno AS nvarchar(max))), 2)) END=CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AND CASE WHEN d.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(d.cinvno AS nvarchar(max))), 2)) END=CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END WHERE h.cvendno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:vendor, 2, 2147483647), 2)) AND h.cinvno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:invoice, 2, 2147483647), 2)) AND h.ctype=N'' AND h.cvendno<>N'' AND h.cinvno<>N'' AND h.cvendno IS NOT NULL AND DATALENGTH(CAST(h.cvendno AS nvarchar(max)))>0 AND h.cinvno IS NOT NULL AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Apinvc hq WHERE hq.cvendno=h.cvendno AND hq.cinvno=h.cinvno) AND CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END=:vendor AND CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END=:invoice AND CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END=:type AND CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END=:invoice_date AND NOT EXISTS (SELECT 1 FROM Apdist dx WHERE dx.cvendno=h.cvendno AND dx.cinvno=h.cinvno AND CASE WHEN dx.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(dx.cvendno AS nvarchar(max))), 2)) END=CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AND CASE WHEN dx.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(dx.cinvno AS nvarchar(max))), 2)) END=CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AND (dx.cuid IS NULL OR dx.cuid=N'' OR DATALENGTH(CAST(dx.cuid AS nvarchar(max)))=0 OR 1<>(SELECT COUNT(*) FROM Apdist dq WHERE dq.cuid=dx.cuid)))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END) AS ParentKey, CONCAT(CONCAT(CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END),N':',CASE WHEN v.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(v.cvendno AS nvarchar(max))), 2)) END) AS SupplierKey, CAST(v.cvendno AS nvarchar(max)) AS cvendno, CAST(v.ccompany AS nvarchar(max)) AS ccompany, CAST(v.ccompany2 AS nvarchar(max)) AS ccompany2, CAST(v.cvcustno AS nvarchar(max)) AS cvcustno, CAST(v.cref AS nvarchar(max)) AS cref, CAST(v.cfname AS nvarchar(max)) AS cfname, CAST(v.clname AS nvarchar(max)) AS clname, CAST(v.cphone1 AS nvarchar(max)) AS cphone1, CAST(v.cphone2 AS nvarchar(max)) AS cphone2, CAST(v.cemail AS nvarchar(max)) AS cemail, CAST(v.cwebsite AS nvarchar(max)) AS cwebsite, CAST(v.caddr1 AS nvarchar(max)) AS caddr1, CAST(v.caddr2 AS nvarchar(max)) AS caddr2, CAST(v.ccity AS nvarchar(max)) AS ccity, CAST(v.cstate AS nvarchar(max)) AS cstate, CAST(v.czip AS nvarchar(max)) AS czip, CAST(v.ccountry AS nvarchar(max)) AS ccountry, CAST(v.cstatus AS nvarchar(max)) AS cstatus, CAST(v.cclass AS nvarchar(max)) AS cclass, CAST(v.cbuyer AS nvarchar(max)) AS cbuyer, CAST(v.cpaycode AS nvarchar(max)) AS cpaycode, CAST(v.cpayurgenc AS nvarchar(max)) AS cpayurgenc, CAST(v.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(v.cpaytono AS nvarchar(max)) AS cpaytono, CAST(v.cordfrno AS nvarchar(max)) AS cordfrno FROM Apinvc h INNER JOIN Apvend v ON v.cvendno=h.cvendno AND 1=(SELECT COUNT(*) FROM Apvend vq WHERE vq.cvendno=v.cvendno) WHERE h.cvendno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:vendor, 2, 2147483647), 2)) AND h.cinvno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:invoice, 2, 2147483647), 2)) AND h.ctype=N'' AND h.cvendno<>N'' AND h.cinvno<>N'' AND h.cvendno IS NOT NULL AND DATALENGTH(CAST(h.cvendno AS nvarchar(max)))>0 AND h.cinvno IS NOT NULL AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Apinvc hq WHERE hq.cvendno=h.cvendno AND hq.cinvno=h.cinvno) AND CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END=:vendor AND CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END=:invoice AND CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END=:type AND CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END=:invoice_date
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "AccountMate SQL/Express — authorised company database",
"id": "687E886E-E489-5162-A339-354AB1D0287C",
"kind": "sqlServer",
"requiredObjects": [
"Apinvc",
"Apdist",
"Apvend"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "0B569F81-C8C2-5168-AFDA-8A44F97F8A0A",
"key": "dinvoice",
"type": "date"
},
{
"direction": "ascending",
"id": "6C99D094-05D0-5681-9500-0CA5504BECC9",
"key": "DocumentKey",
"type": "text"
}
],
"id": "ED034A50-2E7B-5E32-AD02-DC323C1DEACD",
"mappings": [
{
"commonFieldKey": "",
"key": "DocumentKey",
"label": "Hidden full invoice identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DocumentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorToken",
"label": "Hidden supplier context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceToken",
"label": "Hidden invoice context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TypeToken",
"label": "Hidden invoice type context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TypeToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyToken",
"label": "Hidden recorded currency context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceDateToken",
"label": "Hidden invoice date context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceDateToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cvendno",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cvendno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cinvno",
"label": "Invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cinvno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpono",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpono",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cref",
"label": "Invoice reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cref",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cdescript",
"label": "Invoice description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cdescript",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ctype",
"label": "Invoice type (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctype",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cvoucherno",
"label": "Voucher reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cvoucherno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccurrcode",
"label": "Invoice currency code (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccurrcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctaxcode",
"label": "Tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctaxcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dinvoice",
"label": "Invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dinvoice",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ddue",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ddue",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ddisc",
"label": "Discount date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ddisc",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dlastpaid",
"label": "Recorded last paid date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dlastpaid",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dclosed",
"label": "Recorded closed date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dclosed",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lhold",
"label": "Hold (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lhold",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nfdiscamt",
"label": "Foreign discount amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfdiscamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfinvamt",
"label": "Foreign invoice amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfinvamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nfappamt",
"label": "Foreign applied amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfappamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfappdisc",
"label": "Foreign applied discount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfappdisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfappadj",
"label": "Foreign applied adjustment (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfappadj",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfdappamt",
"label": "Foreign applied prepayment (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfdappamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfnonpamt",
"label": "Foreign non-payment amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfnonpamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfchrgamt",
"label": "Foreign finance charge (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfchrgamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfpaid",
"label": "Foreign paid amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfpaid",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfbalance",
"label": "Foreign current balance (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfbalance",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nxchgrate",
"label": "Recorded exchange rate — verify direction",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nxchgrate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierLabel",
"label": "Card supplier title",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupplierLabel",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrentSupplierName",
"label": "Current supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrentSupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorContext",
"label": "Current supplier context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Supplier invoices",
"primaryKey": "DocumentKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cvendno",
"cinvno",
"cpono",
"cref",
"cdescript",
"ctype",
"cvoucherno",
"ccurrcode",
"ctaxcode",
"lhold",
"nfdiscamt",
"nfinvamt",
"nfappamt",
"nfappdisc",
"nfappadj",
"nfdappamt",
"nfnonpamt",
"nfchrgamt",
"nfpaid",
"nfbalance",
"nxchgrate",
"CurrentSupplierName",
"VendorContext"
],
"sourceID": "687E886E-E489-5162-A339-354AB1D0287C",
"sqlQuery": "SELECT CONCAT(CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END) AS DocumentKey, CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AS VendorToken, CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AS InvoiceToken, CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END AS TypeToken, CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END AS InvoiceDateToken, CAST(h.cvendno AS nvarchar(max)) AS cvendno, CAST(h.cinvno AS nvarchar(max)) AS cinvno, CAST(h.cpono AS nvarchar(max)) AS cpono, CAST(h.cref AS nvarchar(max)) AS cref, CAST(h.cdescript AS nvarchar(max)) AS cdescript, CAST(h.ctype AS nvarchar(max)) AS ctype, CAST(h.cvoucherno AS nvarchar(max)) AS cvoucherno, CAST(h.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(h.ctaxcode AS nvarchar(max)) AS ctaxcode, CONVERT(varchar(10), h.dinvoice, 23) AS dinvoice, CONVERT(varchar(10), h.ddue, 23) AS ddue, CONVERT(varchar(10), h.ddisc, 23) AS ddisc, CONVERT(varchar(10), h.dlastpaid, 23) AS dlastpaid, CONVERT(varchar(10), h.dclosed, 23) AS dclosed, CAST(h.lhold AS nvarchar(max)) AS lhold, CAST(h.nfdiscamt AS nvarchar(max)) AS nfdiscamt, CAST(h.nfinvamt AS nvarchar(max)) AS nfinvamt, CAST(h.nfappamt AS nvarchar(max)) AS nfappamt, CAST(h.nfappdisc AS nvarchar(max)) AS nfappdisc, CAST(h.nfappadj AS nvarchar(max)) AS nfappadj, CAST(h.nfdappamt AS nvarchar(max)) AS nfdappamt, CAST(h.nfnonpamt AS nvarchar(max)) AS nfnonpamt, CAST(h.nfchrgamt AS nvarchar(max)) AS nfchrgamt, CAST(h.nfpaid AS nvarchar(max)) AS nfpaid, CAST(h.nfbalance AS nvarchar(max)) AS nfbalance, CAST(h.nxchgrate AS nvarchar(max)) AS nxchgrate, COALESCE(NULLIF(v.ccompany,N''),h.cvendno) AS SupplierLabel, CAST(v.ccompany AS nvarchar(max)) AS CurrentSupplierName, CASE WHEN v.cvendno IS NULL THEN N'Missing or ambiguous current supplier — verify source' ELSE N'Unique current supplier; not invoice snapshot' END AS VendorContext FROM Apinvc h LEFT JOIN Apvend v ON v.cvendno=h.cvendno AND 1=(SELECT COUNT(*) FROM Apvend vq WHERE vq.cvendno=v.cvendno) WHERE h.ctype=N'' AND h.cvendno<>N'' AND h.cinvno<>N'' AND h.cvendno IS NOT NULL AND DATALENGTH(CAST(h.cvendno AS nvarchar(max)))>0 AND h.cinvno IS NOT NULL AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Apinvc hq WHERE hq.cvendno=h.cvendno AND hq.cinvno=h.cinvno)",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "493EDE30-AE8D-5D50-AA0D-703ABA5E724A",
"key": "dtrs",
"type": "date"
},
{
"direction": "ascending",
"id": "4F458A2C-358B-5577-87CF-9C95B536418D",
"key": "DistributionKey",
"type": "text"
}
],
"id": "5182EB3B-0E09-5E62-A4EA-5D752A88C590",
"mappings": [
{
"commonFieldKey": "",
"key": "DistributionKey",
"label": "Hidden parent-owned distribution identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DistributionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentKey",
"label": "Hidden full parent identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cvendno",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cvendno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cinvno",
"label": "Invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cinvno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cglacc",
"label": "GL distribution account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cglacc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "camrtexacc",
"label": "Amortized expense account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "camrtexacc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "camrtmethd",
"label": "Amortization method (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "camrtmethd",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "camrtrecur",
"label": "Amortization cycle (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "camrtrecur",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctype",
"label": "Distribution type (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctype",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "coldtype",
"label": "Previous distribution type (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "coldtype",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cdescript",
"label": "Distribution description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cdescript",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccurrcode",
"label": "Distribution currency code (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccurrcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctogl",
"label": "Posting-to-GL code (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctogl",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "crcptno",
"label": "Receipt reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "crcptno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctaxcode",
"label": "Tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctaxcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "clinedesc",
"label": "Line reference description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "clinedesc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dtrs",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dtrs",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "damrtstart",
"label": "Amortization start date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "damrtstart",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "damrtend",
"label": "Amortization end date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "damrtend",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lamortize",
"label": "Amortize (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lamortize",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nfamount",
"label": "Foreign distribution amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfamount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nftaxamt1",
"label": "Foreign tax amount1 (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt2",
"label": "Foreign tax amount2 (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt3",
"label": "Foreign tax amount3 (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DistributionTitle",
"label": "Card distribution title",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DistributionTitle",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentCurrencyCode",
"label": "Parent invoice currency code (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentCurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyContext",
"label": "Currency context — no conversion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Accounting distributions",
"primaryKey": "DistributionKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VendorToken",
"id": "E4D29886-7067-56A7-BC4B-6C48E004DAFF",
"name": "vendor",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "InvoiceToken",
"id": "97A09499-94E8-57F8-87F4-74E13390F93B",
"name": "invoice",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TypeToken",
"id": "0FEC0E35-BB56-50D3-8DEA-30A367BA374E",
"name": "type",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CurrencyToken",
"id": "0E5E2E48-D8B2-566F-BEBF-BE9E83459EEA",
"name": "currency",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "InvoiceDateToken",
"id": "A9FB0C78-5519-5F3C-A1B0-2702B0511BC8",
"name": "invoice_date",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cvendno",
"cinvno",
"cglacc",
"camrtexacc",
"camrtmethd",
"camrtrecur",
"ctype",
"coldtype",
"cdescript",
"ccurrcode",
"ctogl",
"crcptno",
"ctaxcode",
"clinedesc",
"lamortize",
"nfamount",
"nftaxamt1",
"nftaxamt2",
"nftaxamt3",
"ParentCurrencyCode",
"CurrencyContext"
],
"sourceID": "687E886E-E489-5162-A339-354AB1D0287C",
"sqlQuery": "SELECT CONCAT(CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END) AS ParentKey, CONCAT(CONCAT(CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END),N':',CASE WHEN d.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(d.cuid AS nvarchar(max))), 2)) END) AS DistributionKey, CAST(d.cvendno AS nvarchar(max)) AS cvendno, CAST(d.cinvno AS nvarchar(max)) AS cinvno, CAST(d.cglacc AS nvarchar(max)) AS cglacc, CAST(d.camrtexacc AS nvarchar(max)) AS camrtexacc, CAST(d.camrtmethd AS nvarchar(max)) AS camrtmethd, CAST(d.camrtrecur AS nvarchar(max)) AS camrtrecur, CAST(d.ctype AS nvarchar(max)) AS ctype, CAST(d.coldtype AS nvarchar(max)) AS coldtype, CAST(d.cdescript AS nvarchar(max)) AS cdescript, CAST(d.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(d.ctogl AS nvarchar(max)) AS ctogl, CAST(d.crcptno AS nvarchar(max)) AS crcptno, CAST(d.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(d.clinedesc AS nvarchar(max)) AS clinedesc, CONVERT(varchar(10), d.dtrs, 23) AS dtrs, CONVERT(varchar(10), d.damrtstart, 23) AS damrtstart, CONVERT(varchar(10), d.damrtend, 23) AS damrtend, CAST(d.lamortize AS nvarchar(max)) AS lamortize, CAST(d.nfamount AS nvarchar(max)) AS nfamount, CAST(d.nftaxamt1 AS nvarchar(max)) AS nftaxamt1, CAST(d.nftaxamt2 AS nvarchar(max)) AS nftaxamt2, CAST(d.nftaxamt3 AS nvarchar(max)) AS nftaxamt3, COALESCE(NULLIF(d.clinedesc,N''),NULLIF(d.cdescript,N''),d.cglacc) AS DistributionTitle, CAST(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode, CASE WHEN d.ccurrcode IS NULL OR h.ccurrcode IS NULL OR d.ccurrcode=N'' OR h.ccurrcode=N'' THEN N'Unknown currency context — verify source' WHEN d.ccurrcode=h.ccurrcode THEN N'Same recorded currency code; no conversion' ELSE N'Different recorded currency codes — do not combine' END AS CurrencyContext FROM Apinvc h INNER JOIN Apdist d ON d.cvendno=h.cvendno AND d.cinvno=h.cinvno AND CASE WHEN d.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(d.cvendno AS nvarchar(max))), 2)) END=CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AND CASE WHEN d.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(d.cinvno AS nvarchar(max))), 2)) END=CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END WHERE h.cvendno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:vendor, 2, 2147483647), 2)) AND h.cinvno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:invoice, 2, 2147483647), 2)) AND h.ctype=N'' AND h.cvendno<>N'' AND h.cinvno<>N'' AND h.cvendno IS NOT NULL AND DATALENGTH(CAST(h.cvendno AS nvarchar(max)))>0 AND h.cinvno IS NOT NULL AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Apinvc hq WHERE hq.cvendno=h.cvendno AND hq.cinvno=h.cinvno) AND CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END=:vendor AND CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END=:invoice AND CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END=:type AND CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END=:invoice_date AND NOT EXISTS (SELECT 1 FROM Apdist dx WHERE dx.cvendno=h.cvendno AND dx.cinvno=h.cinvno AND CASE WHEN dx.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(dx.cvendno AS nvarchar(max))), 2)) END=CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AND CASE WHEN dx.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(dx.cinvno AS nvarchar(max))), 2)) END=CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AND (dx.cuid IS NULL OR dx.cuid=N'' OR DATALENGTH(CAST(dx.cuid AS nvarchar(max)))=0 OR 1<>(SELECT COUNT(*) FROM Apdist dq WHERE dq.cuid=dx.cuid)))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "A6D42344-8C77-5253-8134-D1D2A94ED2A7",
"key": "ccompany",
"type": "text"
},
{
"direction": "ascending",
"id": "ED8350F2-8ACE-5D71-BFE9-E224C8EE103B",
"key": "SupplierKey",
"type": "text"
}
],
"id": "CA323D9F-F525-5EEA-896D-97C2B46628FD",
"mappings": [
{
"commonFieldKey": "",
"key": "SupplierKey",
"label": "Hidden parent-owned supplier identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupplierKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentKey",
"label": "Hidden full parent identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cvendno",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cvendno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccompany",
"label": "Supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccompany2",
"label": "Supplier alias",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccompany2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cvcustno",
"label": "Our account code at supplier",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cvcustno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cref",
"label": "Supplier reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cref",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cfname",
"label": "Contact first name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfname",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "clname",
"label": "Contact last name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "clname",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cphone1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cphone1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cphone2",
"label": "Phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cphone2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cemail",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cemail",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cwebsite",
"label": "Website",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cwebsite",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "caddr1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "caddr1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "caddr2",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "caddr2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccity",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccity",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cstate",
"label": "State or region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cstate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "czip",
"label": "ZIP or postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "czip",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccountry",
"label": "Country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccountry",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cstatus",
"label": "Status code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cstatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cclass",
"label": "Supplier class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cclass",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cbuyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbuyer",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpaycode",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpaycode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cpayurgenc",
"label": "Payment urgency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpayurgenc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccurrcode",
"label": "Supplier currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccurrcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cpaytono",
"label": "Pay-to supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpaytono",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cordfrno",
"label": "Order-from address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cordfrno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Current supplier",
"primaryKey": "SupplierKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VendorToken",
"id": "E4D29886-7067-56A7-BC4B-6C48E004DAFF",
"name": "vendor",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "InvoiceToken",
"id": "97A09499-94E8-57F8-87F4-74E13390F93B",
"name": "invoice",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TypeToken",
"id": "0FEC0E35-BB56-50D3-8DEA-30A367BA374E",
"name": "type",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CurrencyToken",
"id": "0E5E2E48-D8B2-566F-BEBF-BE9E83459EEA",
"name": "currency",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "InvoiceDateToken",
"id": "A9FB0C78-5519-5F3C-A1B0-2702B0511BC8",
"name": "invoice_date",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cvendno",
"ccompany",
"ccompany2",
"cvcustno",
"cref",
"cfname",
"clname",
"cphone1",
"cphone2",
"cemail",
"cwebsite",
"caddr1",
"caddr2",
"ccity",
"cstate",
"czip",
"ccountry",
"cstatus",
"cclass",
"cbuyer",
"cpaycode",
"cpayurgenc",
"ccurrcode",
"cpaytono",
"cordfrno"
],
"sourceID": "687E886E-E489-5162-A339-354AB1D0287C",
"sqlQuery": "SELECT CONCAT(CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END) AS ParentKey, CONCAT(CONCAT(CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END),N':',CASE WHEN v.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(v.cvendno AS nvarchar(max))), 2)) END) AS SupplierKey, CAST(v.cvendno AS nvarchar(max)) AS cvendno, CAST(v.ccompany AS nvarchar(max)) AS ccompany, CAST(v.ccompany2 AS nvarchar(max)) AS ccompany2, CAST(v.cvcustno AS nvarchar(max)) AS cvcustno, CAST(v.cref AS nvarchar(max)) AS cref, CAST(v.cfname AS nvarchar(max)) AS cfname, CAST(v.clname AS nvarchar(max)) AS clname, CAST(v.cphone1 AS nvarchar(max)) AS cphone1, CAST(v.cphone2 AS nvarchar(max)) AS cphone2, CAST(v.cemail AS nvarchar(max)) AS cemail, CAST(v.cwebsite AS nvarchar(max)) AS cwebsite, CAST(v.caddr1 AS nvarchar(max)) AS caddr1, CAST(v.caddr2 AS nvarchar(max)) AS caddr2, CAST(v.ccity AS nvarchar(max)) AS ccity, CAST(v.cstate AS nvarchar(max)) AS cstate, CAST(v.czip AS nvarchar(max)) AS czip, CAST(v.ccountry AS nvarchar(max)) AS ccountry, CAST(v.cstatus AS nvarchar(max)) AS cstatus, CAST(v.cclass AS nvarchar(max)) AS cclass, CAST(v.cbuyer AS nvarchar(max)) AS cbuyer, CAST(v.cpaycode AS nvarchar(max)) AS cpaycode, CAST(v.cpayurgenc AS nvarchar(max)) AS cpayurgenc, CAST(v.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(v.cpaytono AS nvarchar(max)) AS cpaytono, CAST(v.cordfrno AS nvarchar(max)) AS cordfrno FROM Apinvc h INNER JOIN Apvend v ON v.cvendno=h.cvendno AND 1=(SELECT COUNT(*) FROM Apvend vq WHERE vq.cvendno=v.cvendno) WHERE h.cvendno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:vendor, 2, 2147483647), 2)) AND h.cinvno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:invoice, 2, 2147483647), 2)) AND h.ctype=N'' AND h.cvendno<>N'' AND h.cinvno<>N'' AND h.cvendno IS NOT NULL AND DATALENGTH(CAST(h.cvendno AS nvarchar(max)))>0 AND h.cinvno IS NOT NULL AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Apinvc hq WHERE hq.cvendno=h.cvendno AND hq.cinvno=h.cinvno) AND CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END=:vendor AND CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END=:invoice AND CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END=:type AND CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END=:invoice_date",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "D0DD8955-1EC8-5540-B736-6292ACEE449C",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "7266E785-8922-5549-8429-59964D2A41DE",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "5182EB3B-0E09-5E62-A4EA-5D752A88C590",
"title": "Accounting distributions",
"urlKey": ""
},
{
"id": "BD4DE54A-A52B-564E-9337-11CE98F58552",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "8C49D6A9-274A-545F-83B3-8576C212FC38",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "CA323D9F-F525-5EEA-896D-97C2B46628FD",
"title": "Current supplier",
"urlKey": ""
}
],
"badgeKey": "ccurrcode",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cdescript",
"label": "Invoice description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dinvoice",
"label": "Invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ddue",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "lhold",
"label": "Hold (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nfinvamt",
"label": "Foreign invoice amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nfbalance",
"label": "Foreign current balance (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "ED034A50-2E7B-5E32-AD02-DC323C1DEACD",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current regular invoice — not all AP documents",
"detailRole": "information",
"isVisible": true,
"key": "cinvno",
"label": "Invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current regular invoice — not all AP documents",
"detailRole": "information",
"isVisible": true,
"key": "cvendno",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current regular invoice — not all AP documents",
"detailRole": "information",
"isVisible": true,
"key": "CurrentSupplierName",
"label": "Current supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current regular invoice — not all AP documents",
"detailRole": "information",
"isVisible": true,
"key": "VendorContext",
"label": "Current supplier context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current regular invoice — not all AP documents",
"detailRole": "information",
"isVisible": true,
"key": "ctype",
"label": "Invoice type (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchase, voucher and invoice references",
"detailRole": "information",
"isVisible": true,
"key": "cpono",
"label": "Purchase order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchase, voucher and invoice references",
"detailRole": "information",
"isVisible": true,
"key": "cvoucherno",
"label": "Voucher reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchase, voucher and invoice references",
"detailRole": "information",
"isVisible": true,
"key": "cref",
"label": "Invoice reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchase, voucher and invoice references",
"detailRole": "information",
"isVisible": true,
"key": "cdescript",
"label": "Invoice description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchase, voucher and invoice references",
"detailRole": "information",
"isVisible": true,
"key": "ctaxcode",
"label": "Tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded invoice and due dates",
"detailRole": "information",
"isVisible": true,
"key": "dinvoice",
"label": "Invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded invoice and due dates",
"detailRole": "information",
"isVisible": true,
"key": "ddue",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded invoice and due dates",
"detailRole": "information",
"isVisible": true,
"key": "ddisc",
"label": "Discount date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current source amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "ccurrcode",
"label": "Invoice currency code (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current source amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "nfinvamt",
"label": "Foreign invoice amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current source amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "nfbalance",
"label": "Foreign current balance (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current source amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "nfpaid",
"label": "Foreign paid amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current source amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "nfdiscamt",
"label": "Foreign discount amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded applied amounts — no recalculation",
"detailRole": "information",
"isVisible": true,
"key": "nfappamt",
"label": "Foreign applied amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded applied amounts — no recalculation",
"detailRole": "information",
"isVisible": true,
"key": "nfappdisc",
"label": "Foreign applied discount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded applied amounts — no recalculation",
"detailRole": "information",
"isVisible": true,
"key": "nfappadj",
"label": "Foreign applied adjustment (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded applied amounts — no recalculation",
"detailRole": "information",
"isVisible": true,
"key": "nfdappamt",
"label": "Foreign applied prepayment (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded applied amounts — no recalculation",
"detailRole": "information",
"isVisible": true,
"key": "nfnonpamt",
"label": "Foreign non-payment amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded applied amounts — no recalculation",
"detailRole": "information",
"isVisible": true,
"key": "nfchrgamt",
"label": "Foreign finance charge (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Hold and recorded dates — not payment proof",
"detailRole": "information",
"isVisible": true,
"key": "lhold",
"label": "Hold (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Hold and recorded dates — not payment proof",
"detailRole": "information",
"isVisible": true,
"key": "dlastpaid",
"label": "Recorded last paid date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Hold and recorded dates — not payment proof",
"detailRole": "information",
"isVisible": true,
"key": "dclosed",
"label": "Recorded closed date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded exchange rate — direction unverified",
"detailRole": "information",
"isVisible": true,
"key": "nxchgrate",
"label": "Recorded exchange rate — verify direction",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "ECFF91DB-4256-504D-AB8A-4DFDAB8C2CB0",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "295DCD0B-7179-534B-9C0A-6EDB94C2B719",
"includeAllOption": false,
"key": "dinvoice",
"title": "Choose invoice period",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "0B569F81-C8C2-5168-AFDA-8A44F97F8A0A",
"key": "dinvoice",
"type": "date"
},
{
"direction": "ascending",
"id": "6C99D094-05D0-5681-9500-0CA5504BECC9",
"key": "DocumentKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "SupplierLabel",
"systemImage": "doc.text",
"title": "Supplier invoices",
"titleKey": "cinvno"
},
{
"actions": [],
"badgeKey": "ccurrcode",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ctype",
"label": "Distribution type (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dtrs",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "lamortize",
"label": "Amortize (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nfamount",
"label": "Foreign distribution amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "5182EB3B-0E09-5E62-A4EA-5D752A88C590",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Accounting allocation — NOT a product line",
"detailRole": "information",
"isVisible": true,
"key": "cinvno",
"label": "Invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Accounting allocation — NOT a product line",
"detailRole": "information",
"isVisible": true,
"key": "cvendno",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Accounting allocation — NOT a product line",
"detailRole": "information",
"isVisible": true,
"key": "clinedesc",
"label": "Line reference description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Accounting allocation — NOT a product line",
"detailRole": "information",
"isVisible": true,
"key": "cdescript",
"label": "Distribution description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Accounting allocation — NOT a product line",
"detailRole": "information",
"isVisible": true,
"key": "ctype",
"label": "Distribution type (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Accounting allocation — NOT a product line",
"detailRole": "information",
"isVisible": true,
"key": "coldtype",
"label": "Previous distribution type (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "GL and source posting codes",
"detailRole": "information",
"isVisible": true,
"key": "cglacc",
"label": "GL distribution account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "GL and source posting codes",
"detailRole": "information",
"isVisible": true,
"key": "ctogl",
"label": "Posting-to-GL code (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "GL and source posting codes",
"detailRole": "information",
"isVisible": true,
"key": "crcptno",
"label": "Receipt reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "GL and source posting codes",
"detailRole": "information",
"isVisible": true,
"key": "ctaxcode",
"label": "Tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "GL and source posting codes",
"detailRole": "information",
"isVisible": true,
"key": "dtrs",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded foreign amounts — no sums or FX",
"detailRole": "information",
"isVisible": true,
"key": "ccurrcode",
"label": "Distribution currency code (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no sums or FX",
"detailRole": "information",
"isVisible": true,
"key": "ParentCurrencyCode",
"label": "Parent invoice currency code (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no sums or FX",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyContext",
"label": "Currency context — no conversion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no sums or FX",
"detailRole": "information",
"isVisible": true,
"key": "nfamount",
"label": "Foreign distribution amount (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no sums or FX",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt1",
"label": "Foreign tax amount1 (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no sums or FX",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt2",
"label": "Foreign tax amount2 (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no sums or FX",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt3",
"label": "Foreign tax amount3 (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Amortisation setup — not an executed schedule",
"detailRole": "information",
"isVisible": true,
"key": "lamortize",
"label": "Amortize (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Amortisation setup — not an executed schedule",
"detailRole": "information",
"isVisible": true,
"key": "camrtexacc",
"label": "Amortized expense account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Amortisation setup — not an executed schedule",
"detailRole": "information",
"isVisible": true,
"key": "camrtmethd",
"label": "Amortization method (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Amortisation setup — not an executed schedule",
"detailRole": "information",
"isVisible": true,
"key": "camrtrecur",
"label": "Amortization cycle (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Amortisation setup — not an executed schedule",
"detailRole": "information",
"isVisible": true,
"key": "damrtstart",
"label": "Amortization start date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amortisation setup — not an executed schedule",
"detailRole": "information",
"isVisible": true,
"key": "damrtend",
"label": "Amortization end date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "80671F74-7311-53FE-B155-DCF1B899E7A5",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "493EDE30-AE8D-5D50-AA0D-703ABA5E724A",
"key": "dtrs",
"type": "date"
},
{
"direction": "ascending",
"id": "4F458A2C-358B-5577-87CF-9C95B536418D",
"key": "DistributionKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "cglacc",
"systemImage": "doc.text",
"title": "Accounting distributions",
"titleKey": "DistributionTitle"
},
{
"actions": [],
"badgeKey": "cstatus",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cphone1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cemail",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cclass",
"label": "Supplier class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cpaycode",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ccurrcode",
"label": "Supplier currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "CA323D9F-F525-5EEA-896D-97C2B46628FD",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current supplier master — not invoice snapshot",
"detailRole": "information",
"isVisible": true,
"key": "ccompany",
"label": "Supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not invoice snapshot",
"detailRole": "information",
"isVisible": true,
"key": "ccompany2",
"label": "Supplier alias",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not invoice snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cvendno",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not invoice snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cvcustno",
"label": "Our account code at supplier",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not invoice snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cref",
"label": "Supplier reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not invoice snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cstatus",
"label": "Status code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not invoice snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cclass",
"label": "Supplier class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "cfname",
"label": "Contact first name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "clname",
"label": "Contact last name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "cphone1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "cphone2",
"label": "Phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "cemail",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "cwebsite",
"label": "Website",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "caddr1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "caddr2",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "ccity",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "cstate",
"label": "State or region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "czip",
"label": "ZIP or postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "ccountry",
"label": "Country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cbuyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cpaycode",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cpayurgenc",
"label": "Payment urgency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "ccurrcode",
"label": "Supplier currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cpaytono",
"label": "Pay-to supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cordfrno",
"label": "Order-from address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "A4E073E0-693B-51BD-A720-74DB831CC168",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "A6D42344-8C77-5253-8134-D1D2A94ED2A7",
"key": "ccompany",
"type": "text"
},
{
"direction": "ascending",
"id": "ED8350F2-8ACE-5D71-BFE9-E224C8EE103B",
"key": "SupplierKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "cvendno",
"systemImage": "doc.text",
"title": "Current supplier",
"titleKey": "ccompany"
}
],
"relations": [
{
"childDatasetID": "5182EB3B-0E09-5E62-A4EA-5D752A88C590",
"childKey": "ParentKey",
"id": "7266E785-8922-5549-8429-59964D2A41DE",
"name": "Accounting distributions",
"parentDatasetID": "ED034A50-2E7B-5E32-AD02-DC323C1DEACD",
"parentKey": "DocumentKey"
},
{
"childDatasetID": "CA323D9F-F525-5EEA-896D-97C2B46628FD",
"childKey": "ParentKey",
"id": "8C49D6A9-274A-545F-83B3-8576C212FC38",
"name": "Current supplier",
"parentDatasetID": "ED034A50-2E7B-5E32-AD02-DC323C1DEACD",
"parentKey": "DocumentKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "AccountMate for SQL/Express",
"changelog": "Initial Pro current regular supplier invoices, accounting distributions and current supplier; native fictional complete cards and representative Details. Not a real ERP connection test.",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-11T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.\n\nFor accounting, purchasing and managers: select an invoice period and inspect current regular supplier invoices, recorded due dates, hold flag, foreign invoice/current-balance amounts and purchase/voucher references. Open rich Details, then load accounting distributions or the current supplier dossier only when needed.\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 authorised company source, three bounded live lists with same-row Details and two lazy sub-buttons. 28 invoice,24 distribution and25 current-supplier useful positions; opaque identity/context keys are hidden. No widgets, computed totals, write operations or periodic refresh. Mandatory native invoice-period selection before the final2,000 invoice cap;500-row child caps. Search and local filters cover loaded rows only. Existing workspace resources count; a cap is not a query-performance guarantee. Amounts/flags are exact source text with textual local sorting/filtering, not formatted currency or calculated balances.\n\nSCOPE: current Apinvc regular invoices only (documented blank ctype). Open-balance, debit, credit-card and deferred-expense headers are excluded, not renamed ordinary invoices. No Apinvch/Apdisth history, deleted/void-history union, payment execution or as-of aging claim. Selecting an invoice-date period does NOT calculate the balance at the end of that period: displayed balances/applied amounts remain CURRENT source values. Recorded last-paid/closed dates are source context, not independently verified payment status. Hold and posting codes stay native; no nonzero-to-true assumption. Source dates can be unknown.\n\nDISTRIBUTIONS: accounting allocation rows, NOT product/quantity invoice lines. Keep AP, nonpayment, prepayment, finance-charge, expense, accrual, receipt/charge, refund, tax-reversal and amendment/void-related native types; unknown types remain unchanged. No filtering to expense-only rows, debit/credit totals, account labels, tax recalculation or amortisation schedule is inferred. A GL code is not a proved account description. Native method/cycle and start/end dates are configuration, not proof of executed amortisation.\n\nMONEY: selected nf* values are recorded FOREIGN amounts. Header currency, distribution currency and CURRENT supplier currency are separate recorded codes; no ISO code, base currency or exchange-rate direction assumed. Different/unknown distribution-vs-header currency receives an explicit context warning; NEVER add or convert such values. Paid, applied, discount, adjustment, prepayment and balance values are read independently, not recomputed or promised to reconcile. Zero, negative, NULL and unknown remain distinct. Verify source currency/type/rate conventions before financial decisions.\n\nIDENTITY: full supplier+invoice key within the authorised companyDB, never invoice number alone or across companies. Parent identity and unchanged invoice type/currency/date are revalidated before each child; UTF16 encoded tokens preserve Unicode, spaces, blank versus NULL through app parent-value trimming. Incomplete/duplicate header identity is excluded, not arbitrarily selected. Full cuid identifies each distribution, hidden from business UI. Missing/empty/ambiguous matching distribution UID blocks the entire distribution branch; an empty branch is not proof of no accounting activity.\n\nCURRENT SUPPLIER: optional unique Apvend enrichment preserves invoices with missing or duplicate supplier masters and an explicit warning; no fanout/arbitrary name. Supplier child requires a unique master and uses a parent-owned key. Contacts, postal address, classification, payment/purchasing codes and currency are CURRENT master values, not invoice snapshots. No bank account or tax/personal identity identifier is selected.\n\nCOMPATIBILITY: complete historical AccountMate12 SQL/Express AP reference, original 20April2021 (printedFebruary2021), own49 invoice/distribution field positions and full keys; supplier uses its separately verified AP12 contract. Not AccountMate Enterprise or current SQL14 certification. AMTBL widths/Required are data-entry metadata, not installed DDL/nullability. SQLServer2012+ required for CONCAT. Owner is UNKNOWN: administrator must confirm exactly one readable Apinvc,Apdist,Apvend resolved identically by Android and iOS login/default schema. Android metadata may prefer dbo; iOS queries use default resolution. Ambiguous owners must be replaced with confirmed qualified objects in Studio and bounded read tests repeated. Import is NOT claimed to automatically reject duplicate owners. Verify installed edition/fields/types/full keys, collation, currency semantics, date/decimal/NULL conversion, indexes/plan and response time.\n\nSECURITY: company-authorised least-privilege SELECT-only reporting connection. Direct SQL does not inherit ERP ACL; period/filter selection is not access control. No credentials, server address or business rows in the package. Documentary and adapted synthetic checks do not certify real ERP, native SQLServer, iOS, permissions, performance or subscription purchase. Unofficial, not endorsed by AccountMate.\n\nDocumentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_ap_drg.pdf\n\nGallery: Eight original native Cifru DEMO images show complete invoice, accounting-distribution and current-supplier cards, both actually opened sub-buttons and representative Details. All values are invented; no AccountMate installation was connected. The configuration retains77 useful Detail positions (28invoice,24distribution,25supplier); their nonblank values were checked in full private overlapping native continuations. Native Details suppress the blank regular-invoice type; its configured mapping and hidden type context remain verified. This is a representative gallery, not a claim that eight images show every invoice field. Additional invoice identity/current-context/reference/date/amount Details remain in the JSON and private continuations. No field was removed or screenshot retouched to fit eight. Source amount/type/currency limits and exchange-direction/current-master/allocation caveats remain explicit. A representative subset of four invented invoices was selected from the constrained reference SELECT for filming; negative, NULL, duplicate and stale-parent cases remain in separate tests and unapproved R3/R4 material. Original PNG/XML pairs, frozen invented input and silent RAW are retained for future videos; whole RAW/Home, the native opening-summary internal last7Days label and redundant continuations are private and not video-approved. Pro requirements were checked; capture uses a Pro test entitlement, not a purchase test. This proves native synthetic UI/action traversal, not ERP/SQLServer/iOS/DDL/owner/collation, source conversion, ISO currency, FX direction, ACL, financial reconciliation, completeness or performance.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "BBB4933B-A1BC-5562-816A-02BC77463149",
"rootButtonCount": 1,
"summary": "Choose an invoice period; inspect source amounts and due dates, then accounting allocations and the current supplier on demand.",
"tags": [
"AccountMate",
"SQL Server",
"Accounting",
"Supplier invoices",
"Accounts payable",
"Purchasing",
"Pro"
],
"title": "Supplier invoices, accounting distributions and supplier — Pro"
}
}