Customer dossier, contacts, address book and invoices — Pro
Choose a customer class; open full current dossiers, contacts, addresses and recent retained invoices on demand.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.
For sales, customer service, dispatch, accounting and managers: choose a customer class and open a useful customer dossier. See primary contact, current address, trading and shipping defaults, accounting references and retained customer note. Three buttons open all retained current contacts, the current address book with bill-to/ship-to reference matches, or the customer’s recent retained invoices, loaded only when opened.
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 SQL Server source, four live lists and three on-demand sub-buttons. All 63 customer, 10 contact, 21 address and 79 invoice useful Detail positions are kept; technical tokens are hidden. Choose class before the 2,000-customer cap. Contact/address/invoice lists have 500-row caps. The invoice sub-button reads this exact customer and sorts by recorded invoice date; it does not prompt for a separate period. Search/local filters affect loaded rows. No widgets, scheduled refresh, writes, automatic totals or invoice-line route. Existing workspace resources count; limits do not guarantee cheap SQL reads. Narrow the class and verify customer/invoice indexes and read time.
Current customer, contacts and address book are not historical invoice snapshots. Bill-to and ship-to are exact current references within this customer, not exclusive address types; the same address can match both. Missing defaults do not invent an address fallback. Status, statement, tax-exemption and all flags stay native codes, including unknown/NULL values. Codes/phones/ZIPs remain text. Stored average-pay days and discount are source values, not recomputed or vendor-procedure execution.
Invoice addresses, contacts, dates, currency, subtotal/discount/freight/taxes/adjustments/paid/write-off/balance are recorded invoice values and stay separate from current defaults. No currency conversion, net/ageing/overdue/paid-status calculation or complete payment/allocation history is implied. Voided, negative, zero and unknown type/status remain visible. Only current Arinvc, not archived documents. NULL invoice dates are retained as unknown. The invoice sub-button is a bounded recent-document view, not full history; use the separate invoice report to choose a period at opening. This dossier does not include invoice lines; use the separate recorded invoice-lines configuration for that workflow.
Keys: full company-scoped customer ccustno; contact cuid; address ccustno+caddrno; invoice cuid, never the displayed invoice number. Exact NULL-aware UTF16 encoded customer context (code/name/class/status/currency/bill-to/ship-to) is bound and projected by every child, revalidated at each request; no business-value SQL interpolation. Missing/duplicate customer identity returns no arbitrary dossier. Missing/ambiguous child identity blocks its branch, not unrelated routes. Contacts and addresses require exact owning customer. Repeated invoice numbers including FCHG/0 remain independent full-UID records.
Customer/contact/invoice notes use independently documented owning keys, unique optional matching and first-4,000-character previews; missing/ambiguous notes do not drop or multiply their records. Private notes/contacts require authorised access. Customer-master monetary balances/credit limits are excluded because their currency basis is unverified. No bank/routing, payment-card/password/tax-identifier or generic audit columns are selected.
Compatibility: historical AccountMate 12 SQL/Express AR database reference (created 20 April 2021), not Enterprise or current edition certification. SQL Server 2012+ CONCAT required. No owner is asserted. Administrator must verify uniquely readable objects resolved consistently by Android/iOS login/default schema; Android metadata may prefer dbo while iOS uses defaults, so import is not claimed to reject ambiguous owners automatically. Qualify confirmed objects in Studio and rerun bounded tests. Required/AMTBL describes data-entry metadata, not installed DDL/NOT NULL. Check actual edition/types/full keys/collation, currency/date/decimal semantics, read costs and SELECT permissions. Documentary/SQLite synthetic checks and fictional Android captures are not real ERP/native SQL Server/iOS, performance/security/entitlement certification.
Use a least-privilege SELECT-only authorised company database, not systemDB or another company. Direct SQL is not ERP ACL; filters are not access permissions. No credentials, server addresses or production rows in the package. Unofficial, not endorsed by AccountMate.
Documentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_ar_drg.pdf
Gallery: Eight original native Cifru DEMO images show the class opening filter, complete customer/contact/address/invoice card values, all three actual actions and representative Details from every branch. All values are invented; no AccountMate installation was connected. The configuration retains 173 useful Detail positions: 63 current customer, 10 current contact, 21 current address and 79 recorded invoice. Their nonblank values are checked in all private overlapping native continuations. Eight images are representative, not all 173 fields; no configured field was removed and no screenshot was retouched to fit the gallery. Native cards can shorten long labels; the full labels and caveats remain in Details and the configuration. All three action names are fully visible in the customer Details continuation. Current customer currency/defaults/addresses/contacts are not historic invoice values: the invented current customer uses GBP and its recorded invoice USD. Address reference matches use the exact owning customer and code, can both match, and do not imply exclusive address roles or fallback. Notes are private authorised first 4,000-character previews, not complete text. Invoice source amounts and balance remain separate, with no calculated net, FX, financial reconciliation, complete payment log or invoice-line report. Related invoices are a recent list capped at 500, not the entire history or a child opening-period prompt; the separate invoice dossier supplies a Home period and lines. Original PNG/XML, exact invented input and silent RAW are retained for future videos. Whole RAW/Home, the extra customer with instrumentation null placeholders and redundant continuations are private and not video-approved; NULL conversion is not certified. Pro requirements were checked; capture uses a Pro test entitlement, not a purchase test. This proves native synthetic Android GUI/action traversal and adapted SELECT intent, not real ERP/native SQL Server/iOS/current edition/DDL/owner/collation/source ACL or performance. Historical AccountMate 12 documentation is not certification of an installed or current schema.
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Customer dossiers
- Details: Current customer contacts
- Details: Current address book
- Details: Customer recorded invoices
- Sub-button: Current customer contacts
- Sub-button: Current address book
- Sub-button: Customer recorded invoices
Sources are mapped locally and verified before applying.
Custom queriesPRO4 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 CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS CustomerKey, CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS CustomerToken, CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END AS CompanyToken, CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END AS ClassToken, CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END AS StatusToken, CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END AS BillToToken, CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END AS ShipToToken, CAST(u.ccustno AS nvarchar(max)) AS ccustno, CAST(u.ccompany AS nvarchar(max)) AS ccompany, CAST(u.ccompany2 AS nvarchar(max)) AS ccompany2, CAST(u.caddr1 AS nvarchar(max)) AS caddr1, CAST(u.caddr2 AS nvarchar(max)) AS caddr2, CAST(u.ccity AS nvarchar(max)) AS ccity, CAST(u.cstate AS nvarchar(max)) AS cstate, CAST(u.czip AS nvarchar(max)) AS czip, CAST(u.ccountry AS nvarchar(max)) AS ccountry, CAST(u.cphone1 AS nvarchar(max)) AS cphone1, CAST(u.cphone2 AS nvarchar(max)) AS cphone2, CAST(u.cemail AS nvarchar(max)) AS cemail, CAST(u.cwebsite AS nvarchar(max)) AS cwebsite, CAST(u.cfname AS nvarchar(max)) AS cfname, CAST(u.clname AS nvarchar(max)) AS clname, CAST(u.ctitle AS nvarchar(max)) AS ctitle, CAST(u.cslpnno AS nvarchar(max)) AS cslpnno, CAST(u.cstatus AS nvarchar(max)) AS cstatus, CAST(u.cclass AS nvarchar(max)) AS cclass, CAST(u.cindustry AS nvarchar(max)) AS cindustry, CAST(u.cterr AS nvarchar(max)) AS cterr, CAST(u.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(u.cpaycode AS nvarchar(max)) AS cpaycode, CAST(u.cbilltono AS nvarchar(max)) AS cbilltono, CAST(u.cshiptono AS nvarchar(max)) AS cshiptono, CAST(u.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(u.cpricecd AS nvarchar(max)) AS cpricecd, CAST(u.cpcustno AS nvarchar(max)) AS cpcustno, CAST(u.clanguage AS nvarchar(max)) AS clanguage, CAST(u.clinvno AS nvarchar(max)) AS clinvno, CAST(u.clinvcurr AS nvarchar(max)) AS clinvcurr, CAST(u.clrcptno AS nvarchar(max)) AS clrcptno, CAST(u.clrcptcurr AS nvarchar(max)) AS clrcptcurr, CONVERT(varchar(10), u.dlsales, 23) AS dlsales, CONVERT(varchar(10), u.dlrcpt, 23) AS dlrcpt, CAST(u.cfax AS nvarchar(max)) AS cfax, CAST(u.corderby AS nvarchar(max)) AS corderby, CAST(u.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(u.crevncode AS nvarchar(max)) AS crevncode, CAST(u.cprtstmt AS nvarchar(max)) AS cprtstmt, CAST(u.caracc AS nvarchar(max)) AS caracc, CAST(u.cshipvia AS nvarchar(max)) AS cshipvia, CAST(u.cfob AS nvarchar(max)) AS cfob, CAST(u.ctxexptype AS nvarchar(max)) AS ctxexptype, CONVERT(varchar(10), u.dcertexp, 23) AS dcertexp, CAST(u.lprtstmt AS nvarchar(max)) AS lprtstmt, CAST(u.lconstmt AS nvarchar(max)) AS lconstmt, CAST(u.lfinchg AS nvarchar(max)) AS lfinchg, CAST(u.lusecusitm AS nvarchar(max)) AS lusecusitm, CAST(u.luseitemno AS nvarchar(max)) AS luseitemno, CAST(u.lusecusprc AS nvarchar(max)) AS lusecusprc, CAST(u.lgeninvc AS nvarchar(max)) AS lgeninvc, CAST(u.luselprice AS nvarchar(max)) AS luselprice, CAST(u.lapplytax AS nvarchar(max)) AS lapplytax, CAST(u.lprcinctax AS nvarchar(max)) AS lprcinctax, CAST(u.lreqcustpo AS nvarchar(max)) AS lreqcustpo, CAST(u.lchkdupcpo AS nvarchar(max)) AS lchkdupcpo, CAST(u.nexpdays AS nvarchar(max)) AS nexpdays, CAST(u.navgdays AS nvarchar(max)) AS navgdays, CAST(u.ndiscrate AS nvarchar(max)) AS ndiscrate, LEFT(CAST(custnote.mnotepad AS nvarchar(max)),4000) AS CustomerNote, CASE WHEN custnote.ccustno IS NULL THEN N'No unique retained note; absence is not proof of no original note' ELSE N'Unique retained note; preview first 4,000 characters only; private authorised context' END AS CustomerNoteContext, N'Current customer defaults and references, not historical invoice data, account balance or complete CRM history; related lists load on demand' AS CustomerContext FROM Arcust u LEFT JOIN Arcnot custnote ON custnote.ccustno=u.ccustno AND CASE WHEN custnote.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(custnote.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Arcnot custnoteq WHERE custnoteq.ccustno=custnote.ccustno) WHERE u.ccustno IS NOT NULL AND u.ccustno<>N'' AND DATALENGTH(CAST(u.ccustno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arcust uq WHERE uq.ccustno=u.ccustno)
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END,N':',CASE WHEN t.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(t.cuid AS nvarchar(max))), 2)) END) AS ContactKey, CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS CustomerToken, CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END AS CompanyToken, CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END AS ClassToken, CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END AS StatusToken, CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END AS BillToToken, CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END AS ShipToToken, CAST(t.ccustno AS nvarchar(max)) AS ccustno, CAST(t.cfname AS nvarchar(max)) AS cfname, CAST(t.clname AS nvarchar(max)) AS clname, CAST(t.ctitle AS nvarchar(max)) AS ctitle, CAST(t.cphone AS nvarchar(max)) AS cphone, CAST(t.cfax AS nvarchar(max)) AS cfax, CAST(t.cemail AS nvarchar(max)) AS cemail, CONCAT(t.cfname,N' ',t.clname) AS ContactName, CAST(u.ccompany AS nvarchar(max)) AS OwningCustomerName, LEFT(CAST(contactnote.mnotepad AS nvarchar(max)),4000) AS ContactNote, CASE WHEN contactnote.cuid IS NULL THEN N'No unique retained note; absence is not proof of no original note' ELSE N'Unique retained note; preview first 4,000 characters only; private authorised context' END AS ContactNoteContext FROM Arcust u INNER JOIN Arcont t ON t.ccustno=u.ccustno AND CASE WHEN t.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(t.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END LEFT JOIN Arccnt contactnote ON contactnote.cuid=t.cuid AND CASE WHEN contactnote.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(contactnote.cuid AS nvarchar(max))), 2)) END=CASE WHEN t.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(t.cuid AS nvarchar(max))), 2)) END AND contactnote.ccustno=u.ccustno AND CASE WHEN contactnote.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(contactnote.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Arccnt contactnoteq WHERE contactnoteq.cuid=contactnote.cuid) WHERE u.ccustno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:customer, 2, 2147483647), 2)) AND u.ccustno IS NOT NULL AND u.ccustno<>N'' AND DATALENGTH(CAST(u.ccustno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arcust uq WHERE uq.ccustno=u.ccustno) AND CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END=:customer AND CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END=:company AND CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END=:classification AND CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END=:status AND CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END=:billto AND CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END=:shipto AND NOT EXISTS (SELECT 1 FROM Arcont tx WHERE tx.ccustno=u.ccustno AND CASE WHEN tx.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(tx.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AND (NOT (tx.cuid IS NOT NULL AND tx.cuid<>N'' AND DATALENGTH(CAST(tx.cuid AS nvarchar(max)))>0) OR 1<>(SELECT COUNT(*) FROM Arcont tq WHERE tq.cuid=tx.cuid)))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END,N':',CASE WHEN a.caddrno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(a.caddrno AS nvarchar(max))), 2)) END) AS AddressKey, CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS CustomerToken, CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END AS CompanyToken, CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END AS ClassToken, CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END AS StatusToken, CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END AS BillToToken, CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END AS ShipToToken, CAST(a.ccustno AS nvarchar(max)) AS ccustno, CAST(a.caddrno AS nvarchar(max)) AS caddrno, CAST(a.ccompany AS nvarchar(max)) AS ccompany, CAST(a.caddr1 AS nvarchar(max)) AS caddr1, CAST(a.caddr2 AS nvarchar(max)) AS caddr2, CAST(a.ccity AS nvarchar(max)) AS ccity, CAST(a.cstate AS nvarchar(max)) AS cstate, CAST(a.czip AS nvarchar(max)) AS czip, CAST(a.ccountry AS nvarchar(max)) AS ccountry, CAST(a.cphone AS nvarchar(max)) AS cphone, CAST(a.ccontact AS nvarchar(max)) AS ccontact, CAST(a.cemail AS nvarchar(max)) AS cemail, CAST(a.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(a.cshipvia AS nvarchar(max)) AS cshipvia, CAST(a.cfob AS nvarchar(max)) AS cfob, CAST(a.ctxexptype AS nvarchar(max)) AS ctxexptype, CONVERT(varchar(10), a.dcertexp, 23) AS dcertexp, CAST(u.ccompany AS nvarchar(max)) AS OwningCustomerName, CASE WHEN NOT (u.cbilltono IS NOT NULL AND u.cbilltono<>N'' AND DATALENGTH(CAST(u.cbilltono AS nvarchar(max)))>0) THEN N'No usable current bill-to reference' WHEN CASE WHEN a.caddrno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(a.caddrno AS nvarchar(max))), 2)) END=CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END THEN N'Exact current bill-to reference' ELSE N'Not the current bill-to reference' END AS BillToReference, CASE WHEN NOT (u.cshiptono IS NOT NULL AND u.cshiptono<>N'' AND DATALENGTH(CAST(u.cshiptono AS nvarchar(max)))>0) THEN N'No usable current ship-to reference' WHEN CASE WHEN a.caddrno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(a.caddrno AS nvarchar(max))), 2)) END=CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END THEN N'Exact current ship-to reference' ELSE N'Not the current ship-to reference' END AS ShipToReference, N'Current address book; exact owning-customer default references, not exclusive address types, invoice snapshots or assumed fallback' AS AddressContext FROM Arcust u INNER JOIN Arcadr a ON a.ccustno=u.ccustno AND CASE WHEN a.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(a.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END WHERE u.ccustno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:customer, 2, 2147483647), 2)) AND u.ccustno IS NOT NULL AND u.ccustno<>N'' AND DATALENGTH(CAST(u.ccustno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arcust uq WHERE uq.ccustno=u.ccustno) AND CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END=:customer AND CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END=:company AND CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END=:classification AND CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END=:status AND CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END=:billto AND CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END=:shipto AND NOT EXISTS (SELECT 1 FROM Arcadr ax WHERE ax.ccustno=u.ccustno AND CASE WHEN ax.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(ax.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AND (NOT (ax.caddrno IS NOT NULL AND ax.caddrno<>N'' AND DATALENGTH(CAST(ax.caddrno AS nvarchar(max)))>0) OR 1<>(SELECT COUNT(*) FROM Arcadr aq WHERE aq.ccustno=ax.ccustno AND aq.caddrno=ax.caddrno)))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cuid AS nvarchar(max))), 2)) END) AS InvoiceKey, CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS CustomerToken, CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END AS CompanyToken, CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END AS ClassToken, CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END AS StatusToken, CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END AS BillToToken, CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END AS ShipToToken, CAST(h.cinvno AS nvarchar(max)) AS cinvno, CAST(h.crevision AS nvarchar(max)) AS crevision, CAST(h.ctype AS nvarchar(max)) AS ctype, CAST(h.ccustno AS nvarchar(max)) AS ccustno, CAST(h.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(h.coriginvno AS nvarchar(max)) AS coriginvno, CAST(h.corderby AS nvarchar(max)) AS corderby, CAST(h.cslpnno AS nvarchar(max)) AS cslpnno, CAST(h.cbaddrno AS nvarchar(max)) AS cbaddrno, CAST(h.cbcompany AS nvarchar(max)) AS cbcompany, CAST(h.cbaddr1 AS nvarchar(max)) AS cbaddr1, CAST(h.cbaddr2 AS nvarchar(max)) AS cbaddr2, CAST(h.cbcity AS nvarchar(max)) AS cbcity, CAST(h.cbstate AS nvarchar(max)) AS cbstate, CAST(h.cbzip AS nvarchar(max)) AS cbzip, CAST(h.cbcountry AS nvarchar(max)) AS cbcountry, CAST(h.cbphone AS nvarchar(max)) AS cbphone, CAST(h.cbcontact AS nvarchar(max)) AS cbcontact, CAST(h.cbemail AS nvarchar(max)) AS cbemail, CAST(h.csaddrno AS nvarchar(max)) AS csaddrno, CAST(h.cscompany AS nvarchar(max)) AS cscompany, CAST(h.csaddr1 AS nvarchar(max)) AS csaddr1, CAST(h.csaddr2 AS nvarchar(max)) AS csaddr2, CAST(h.cscity AS nvarchar(max)) AS cscity, CAST(h.csstate AS nvarchar(max)) AS csstate, CAST(h.cszip AS nvarchar(max)) AS cszip, CAST(h.cscountry AS nvarchar(max)) AS cscountry, CAST(h.csphone AS nvarchar(max)) AS csphone, CAST(h.cscontact AS nvarchar(max)) AS cscontact, CAST(h.csemail AS nvarchar(max)) AS csemail, CAST(h.cshipvia AS nvarchar(max)) AS cshipvia, CAST(h.cfob AS nvarchar(max)) AS cfob, CAST(h.cpono AS nvarchar(max)) AS cpono, CAST(h.crmano AS nvarchar(max)) AS crmano, CAST(h.cfrgtcode AS nvarchar(max)) AS cfrgtcode, CAST(h.cfrtaxcode AS nvarchar(max)) AS cfrtaxcode, CAST(h.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(h.cpaycode AS nvarchar(max)) AS cpaycode, CAST(h.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(h.caracc AS nvarchar(max)) AS caracc, CAST(h.ctogl AS nvarchar(max)) AS ctogl, CAST(h.cadvsono AS nvarchar(max)) AS cadvsono, CONVERT(varchar(10), h.dorder, 23) AS dorder, CONVERT(varchar(10), h.dinvoice, 23) AS dinvoice, CONVERT(varchar(10), h.ddiscount, 23) AS ddiscount, CONVERT(varchar(10), h.ddue, 23) AS ddue, CONVERT(varchar(10), h.dlastpaid, 23) AS dlastpaid, CONVERT(varchar(10), h.dclosed, 23) AS dclosed, CONVERT(varchar(10), h.dbill, 23) AS dbill, CAST(h.lvoid AS nvarchar(max)) AS lvoid, CAST(h.lfinchg AS nvarchar(max)) AS lfinchg, CAST(h.lapplytax AS nvarchar(max)) AS lapplytax, CAST(h.lprcinctax AS nvarchar(max)) AS lprcinctax, CAST(h.lprtinvc AS nvarchar(max)) AS lprtinvc, CAST(h.lmultiso AS nvarchar(max)) AS lmultiso, CAST(h.ndiscday AS nvarchar(max)) AS ndiscday, CAST(h.ndueday AS nvarchar(max)) AS ndueday, CAST(h.ntermdisc AS nvarchar(max)) AS ntermdisc, CAST(h.ndiscrate AS nvarchar(max)) AS ndiscrate, CAST(h.nfsalesamt AS nvarchar(max)) AS nfsalesamt, CAST(h.nfdiscamt AS nvarchar(max)) AS nfdiscamt, CAST(h.nffrtamt AS nvarchar(max)) AS nffrtamt, CAST(h.nftaxamt1 AS nvarchar(max)) AS nftaxamt1, CAST(h.nftaxamt2 AS nvarchar(max)) AS nftaxamt2, CAST(h.nftaxamt3 AS nvarchar(max)) AS nftaxamt3, CAST(h.nffrttax1 AS nvarchar(max)) AS nffrttax1, CAST(h.nffrttax2 AS nvarchar(max)) AS nffrttax2, CAST(h.nffrttax3 AS nvarchar(max)) AS nffrttax3, CAST(h.nfadjamt AS nvarchar(max)) AS nfadjamt, CAST(h.nffinamt AS nvarchar(max)) AS nffinamt, CAST(h.nftotpaid AS nvarchar(max)) AS nftotpaid, CAST(h.nftotdisc AS nvarchar(max)) AS nftotdisc, CAST(h.nftotadj AS nvarchar(max)) AS nftotadj, CAST(h.nftotdebt AS nvarchar(max)) AS nftotdebt, CAST(h.nfbalance AS nvarchar(max)) AS nfbalance, CAST(h.nxchgrate AS nvarchar(max)) AS nxchgrate, COALESCE(NULLIF(h.cbcompany,N''),NULLIF(h.ccustno,N''),N'Unknown recorded customer') AS InvoicePartyLabel, LEFT(CAST(invoicenote.mremark AS nvarchar(max)),4000) AS InvoiceRemark, CASE WHEN invoicenote.cuid IS NULL THEN N'No unique retained note; absence is not proof of no original note' ELSE N'Unique retained note; preview first 4,000 characters only; private authorised context' END AS InvoiceNoteContext, N'Recorded invoice addresses/currency/source amounts, not current customer defaults; no complete payment or invoice-line report' AS InvoiceContext FROM Arcust u INNER JOIN Arinvc h ON h.ccustno=u.ccustno AND CASE WHEN h.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END LEFT JOIN Arirmk invoicenote ON invoicenote.cuid=h.cuid AND CASE WHEN invoicenote.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(invoicenote.cuid AS nvarchar(max))), 2)) END=CASE WHEN h.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cuid AS nvarchar(max))), 2)) END AND invoicenote.cinvno=h.cinvno AND CASE WHEN invoicenote.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(invoicenote.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 1=(SELECT COUNT(*) FROM Arirmk invoicenoteq WHERE invoicenoteq.cuid=invoicenote.cuid) WHERE u.ccustno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:customer, 2, 2147483647), 2)) AND u.ccustno IS NOT NULL AND u.ccustno<>N'' AND DATALENGTH(CAST(u.ccustno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arcust uq WHERE uq.ccustno=u.ccustno) AND CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END=:customer AND CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END=:company AND CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END=:classification AND CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END=:status AND CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END=:billto AND CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END=:shipto AND h.cuid IS NOT NULL AND h.cuid<>N'' AND DATALENGTH(CAST(h.cuid AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arinvc hq WHERE hq.cuid=h.cuid)
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "AccountMate SQL/Express — authorised company database",
"id": "6B295A0A-C97F-5DAE-97D8-4FA3E10FAA8B",
"kind": "sqlServer",
"requiredObjects": [
"Arcust",
"Arcont",
"Arcadr",
"Arcnot",
"Arccnt",
"Arinvc",
"Arirmk"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "A6D42344-8C77-5253-8134-D1D2A94ED2A7",
"key": "ccompany",
"type": "text"
},
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"id": "6576C82D-8396-52B5-ABFF-C1B062388C9E",
"mappings": [
{
"commonFieldKey": "",
"key": "CustomerKey",
"label": "Hidden full company-scoped customer identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerToken",
"label": "Hidden current customer context customer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyToken",
"label": "Hidden current customer context company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ClassToken",
"label": "Hidden current customer context classification",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ClassToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StatusToken",
"label": "Hidden current customer context status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StatusToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyToken",
"label": "Hidden current customer context currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BillToToken",
"label": "Hidden current customer context billto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillToToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShipToToken",
"label": "Hidden current customer context shipto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShipToToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccustno",
"label": "Customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccustno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccompany",
"label": "Customer name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccompany2",
"label": "Customer alias",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccompany2",
"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": true
},
{
"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": "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": "text",
"sourceColumn": "cwebsite",
"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": "ctitle",
"label": "Contact title (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctitle",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cslpnno",
"label": "Salesperson code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cslpnno",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cstatus",
"label": "Status code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cstatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cclass",
"label": "Customer class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cclass",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cindustry",
"label": "Industry code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cindustry",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cterr",
"label": "Territory code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cterr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cwarehouse",
"label": "Default warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cwarehouse",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpaycode",
"label": "Payment code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpaycode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbilltono",
"label": "Bill-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbilltono",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cshiptono",
"label": "Ship-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cshiptono",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccurrcode",
"label": "Customer currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccurrcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpricecd",
"label": "Price code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpricecd",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpcustno",
"label": "Parent customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpcustno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "clanguage",
"label": "Customer language code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "clanguage",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "clinvno",
"label": "Last invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "clinvno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "clinvcurr",
"label": "Last invoice currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "clinvcurr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "clrcptno",
"label": "Last receipt number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "clrcptno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "clrcptcurr",
"label": "Last receipt currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "clrcptcurr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dlsales",
"label": "Last sales date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dlsales",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dlrcpt",
"label": "Last receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dlrcpt",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cfax",
"label": "Current customer fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfax",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "corderby",
"label": "Current ordered-by reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "corderby",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctaxcode",
"label": "Current sales-tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctaxcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "crevncode",
"label": "Current revenue code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "crevncode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cprtstmt",
"label": "Statement option code — native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cprtstmt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "caracc",
"label": "Current receivables GL account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "caracc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cshipvia",
"label": "Current shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cshipvia",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cfob",
"label": "Current FOB code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfob",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctxexptype",
"label": "Current tax-exemption type — native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctxexptype",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dcertexp",
"label": "Current tax-certificate expiry date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dcertexp",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lprtstmt",
"label": "Print-statement native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lprtstmt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lconstmt",
"label": "Consolidate-statement native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lconstmt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lfinchg",
"label": "Apply-finance-charge native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lfinchg",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lusecusitm",
"label": "Use-customer-item-code native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lusecusitm",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "luseitemno",
"label": "Use-inventory-item-code native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "luseitemno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lusecusprc",
"label": "Use-customer-price native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lusecusprc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lgeninvc",
"label": "Generate-invoice-on-shipment native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lgeninvc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "luselprice",
"label": "Use-last-customer-price native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "luselprice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lapplytax",
"label": "Apply-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lapplytax",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lprcinctax",
"label": "Price-includes-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lprcinctax",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lreqcustpo",
"label": "Require-customer-PO native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lreqcustpo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lchkdupcpo",
"label": "Check-duplicate-customer-PO native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lchkdupcpo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nexpdays",
"label": "Recorded multiple-pricing expiry days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nexpdays",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "navgdays",
"label": "Recorded average-pay days — not recalculated",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "navgdays",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ndiscrate",
"label": "Recorded customer discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ndiscrate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerNote",
"label": "Current customer notepad — preview",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerNote",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerNoteContext",
"label": "Customer notepad preview scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerNoteContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerContext",
"label": "Current dossier scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Customer dossiers",
"primaryKey": "CustomerKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ccustno",
"ccompany",
"ccompany2",
"caddr1",
"caddr2",
"ccity",
"cstate",
"czip",
"ccountry",
"cphone1",
"cphone2",
"cemail",
"cwebsite",
"cfname",
"clname",
"ctitle",
"cslpnno",
"cstatus",
"cclass",
"cindustry",
"cterr",
"cwarehouse",
"cpaycode",
"cbilltono",
"cshiptono",
"ccurrcode",
"cpricecd",
"cpcustno",
"clanguage",
"clinvno",
"clinvcurr",
"clrcptno",
"clrcptcurr",
"cfax",
"corderby",
"ctaxcode",
"crevncode",
"cprtstmt",
"caracc",
"cshipvia",
"cfob",
"ctxexptype",
"lprtstmt",
"lconstmt",
"lfinchg",
"lusecusitm",
"luseitemno",
"lusecusprc",
"lgeninvc",
"luselprice",
"lapplytax",
"lprcinctax",
"lreqcustpo",
"lchkdupcpo",
"nexpdays",
"navgdays",
"ndiscrate",
"CustomerNote",
"CustomerNoteContext",
"CustomerContext"
],
"sourceID": "6B295A0A-C97F-5DAE-97D8-4FA3E10FAA8B",
"sqlQuery": "SELECT CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS CustomerKey, CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS CustomerToken, CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END AS CompanyToken, CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END AS ClassToken, CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END AS StatusToken, CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END AS BillToToken, CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END AS ShipToToken, CAST(u.ccustno AS nvarchar(max)) AS ccustno, CAST(u.ccompany AS nvarchar(max)) AS ccompany, CAST(u.ccompany2 AS nvarchar(max)) AS ccompany2, CAST(u.caddr1 AS nvarchar(max)) AS caddr1, CAST(u.caddr2 AS nvarchar(max)) AS caddr2, CAST(u.ccity AS nvarchar(max)) AS ccity, CAST(u.cstate AS nvarchar(max)) AS cstate, CAST(u.czip AS nvarchar(max)) AS czip, CAST(u.ccountry AS nvarchar(max)) AS ccountry, CAST(u.cphone1 AS nvarchar(max)) AS cphone1, CAST(u.cphone2 AS nvarchar(max)) AS cphone2, CAST(u.cemail AS nvarchar(max)) AS cemail, CAST(u.cwebsite AS nvarchar(max)) AS cwebsite, CAST(u.cfname AS nvarchar(max)) AS cfname, CAST(u.clname AS nvarchar(max)) AS clname, CAST(u.ctitle AS nvarchar(max)) AS ctitle, CAST(u.cslpnno AS nvarchar(max)) AS cslpnno, CAST(u.cstatus AS nvarchar(max)) AS cstatus, CAST(u.cclass AS nvarchar(max)) AS cclass, CAST(u.cindustry AS nvarchar(max)) AS cindustry, CAST(u.cterr AS nvarchar(max)) AS cterr, CAST(u.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(u.cpaycode AS nvarchar(max)) AS cpaycode, CAST(u.cbilltono AS nvarchar(max)) AS cbilltono, CAST(u.cshiptono AS nvarchar(max)) AS cshiptono, CAST(u.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(u.cpricecd AS nvarchar(max)) AS cpricecd, CAST(u.cpcustno AS nvarchar(max)) AS cpcustno, CAST(u.clanguage AS nvarchar(max)) AS clanguage, CAST(u.clinvno AS nvarchar(max)) AS clinvno, CAST(u.clinvcurr AS nvarchar(max)) AS clinvcurr, CAST(u.clrcptno AS nvarchar(max)) AS clrcptno, CAST(u.clrcptcurr AS nvarchar(max)) AS clrcptcurr, CONVERT(varchar(10), u.dlsales, 23) AS dlsales, CONVERT(varchar(10), u.dlrcpt, 23) AS dlrcpt, CAST(u.cfax AS nvarchar(max)) AS cfax, CAST(u.corderby AS nvarchar(max)) AS corderby, CAST(u.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(u.crevncode AS nvarchar(max)) AS crevncode, CAST(u.cprtstmt AS nvarchar(max)) AS cprtstmt, CAST(u.caracc AS nvarchar(max)) AS caracc, CAST(u.cshipvia AS nvarchar(max)) AS cshipvia, CAST(u.cfob AS nvarchar(max)) AS cfob, CAST(u.ctxexptype AS nvarchar(max)) AS ctxexptype, CONVERT(varchar(10), u.dcertexp, 23) AS dcertexp, CAST(u.lprtstmt AS nvarchar(max)) AS lprtstmt, CAST(u.lconstmt AS nvarchar(max)) AS lconstmt, CAST(u.lfinchg AS nvarchar(max)) AS lfinchg, CAST(u.lusecusitm AS nvarchar(max)) AS lusecusitm, CAST(u.luseitemno AS nvarchar(max)) AS luseitemno, CAST(u.lusecusprc AS nvarchar(max)) AS lusecusprc, CAST(u.lgeninvc AS nvarchar(max)) AS lgeninvc, CAST(u.luselprice AS nvarchar(max)) AS luselprice, CAST(u.lapplytax AS nvarchar(max)) AS lapplytax, CAST(u.lprcinctax AS nvarchar(max)) AS lprcinctax, CAST(u.lreqcustpo AS nvarchar(max)) AS lreqcustpo, CAST(u.lchkdupcpo AS nvarchar(max)) AS lchkdupcpo, CAST(u.nexpdays AS nvarchar(max)) AS nexpdays, CAST(u.navgdays AS nvarchar(max)) AS navgdays, CAST(u.ndiscrate AS nvarchar(max)) AS ndiscrate, LEFT(CAST(custnote.mnotepad AS nvarchar(max)),4000) AS CustomerNote, CASE WHEN custnote.ccustno IS NULL THEN N'No unique retained note; absence is not proof of no original note' ELSE N'Unique retained note; preview first 4,000 characters only; private authorised context' END AS CustomerNoteContext, N'Current customer defaults and references, not historical invoice data, account balance or complete CRM history; related lists load on demand' AS CustomerContext FROM Arcust u LEFT JOIN Arcnot custnote ON custnote.ccustno=u.ccustno AND CASE WHEN custnote.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(custnote.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Arcnot custnoteq WHERE custnoteq.ccustno=custnote.ccustno) WHERE u.ccustno IS NOT NULL AND u.ccustno<>N'' AND DATALENGTH(CAST(u.ccustno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arcust uq WHERE uq.ccustno=u.ccustno)",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "8D9226E4-EF23-58A9-95F4-64D4C0737C81",
"key": "clname",
"type": "text"
},
{
"direction": "ascending",
"id": "992EF8B7-F10C-54B1-A8C7-5989E8B1BD96",
"key": "ContactKey",
"type": "text"
}
],
"id": "EC60C884-22E9-5F75-A75D-03F5F6A05CEE",
"mappings": [
{
"commonFieldKey": "",
"key": "ContactKey",
"label": "Hidden full contact identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentKey",
"label": "Hidden full owning customer identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerToken",
"label": "Hidden current customer context customer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyToken",
"label": "Hidden current customer context company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ClassToken",
"label": "Hidden current customer context classification",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ClassToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StatusToken",
"label": "Hidden current customer context status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StatusToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyToken",
"label": "Hidden current customer context currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BillToToken",
"label": "Hidden current customer context billto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillToToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShipToToken",
"label": "Hidden current customer context shipto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShipToToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccustno",
"label": "Owning current customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccustno",
"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": "ctitle",
"label": "Contact title — native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctitle",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cphone",
"label": "Contact phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cphone",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cfax",
"label": "Contact fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfax",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cemail",
"label": "Contact email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cemail",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ContactName",
"label": "Card contact name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactName",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OwningCustomerName",
"label": "Owning current customer name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OwningCustomerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ContactNote",
"label": "Current contact notepad — preview",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactNote",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ContactNoteContext",
"label": "Contact notepad preview scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactNoteContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Current customer contacts",
"primaryKey": "ContactKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CustomerToken",
"id": "E1490669-9D9D-56B7-AF44-E365C5A01C5C",
"name": "customer",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyToken",
"id": "E800DAAA-B2CD-54F4-9936-FCE27869D75A",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ClassToken",
"id": "08AD3913-F52D-5D9E-97E6-8DC508769F79",
"name": "classification",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "StatusToken",
"id": "08E07EFF-77B2-5ED5-BC95-A686FE54A815",
"name": "status",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CurrencyToken",
"id": "D307A053-F2C9-5558-8F8B-2A90D520D046",
"name": "currency",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "BillToToken",
"id": "0B55B1DB-0687-5ED3-9B01-461ABCBEFC9C",
"name": "billto",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ShipToToken",
"id": "B319203F-679C-5EFB-8FC6-3636E6449691",
"name": "shipto",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ccustno",
"cfname",
"clname",
"ctitle",
"cphone",
"cfax",
"cemail",
"OwningCustomerName",
"ContactNote",
"ContactNoteContext"
],
"sourceID": "6B295A0A-C97F-5DAE-97D8-4FA3E10FAA8B",
"sqlQuery": "SELECT CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END,N':',CASE WHEN t.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(t.cuid AS nvarchar(max))), 2)) END) AS ContactKey, CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS CustomerToken, CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END AS CompanyToken, CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END AS ClassToken, CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END AS StatusToken, CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END AS BillToToken, CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END AS ShipToToken, CAST(t.ccustno AS nvarchar(max)) AS ccustno, CAST(t.cfname AS nvarchar(max)) AS cfname, CAST(t.clname AS nvarchar(max)) AS clname, CAST(t.ctitle AS nvarchar(max)) AS ctitle, CAST(t.cphone AS nvarchar(max)) AS cphone, CAST(t.cfax AS nvarchar(max)) AS cfax, CAST(t.cemail AS nvarchar(max)) AS cemail, CONCAT(t.cfname,N' ',t.clname) AS ContactName, CAST(u.ccompany AS nvarchar(max)) AS OwningCustomerName, LEFT(CAST(contactnote.mnotepad AS nvarchar(max)),4000) AS ContactNote, CASE WHEN contactnote.cuid IS NULL THEN N'No unique retained note; absence is not proof of no original note' ELSE N'Unique retained note; preview first 4,000 characters only; private authorised context' END AS ContactNoteContext FROM Arcust u INNER JOIN Arcont t ON t.ccustno=u.ccustno AND CASE WHEN t.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(t.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END LEFT JOIN Arccnt contactnote ON contactnote.cuid=t.cuid AND CASE WHEN contactnote.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(contactnote.cuid AS nvarchar(max))), 2)) END=CASE WHEN t.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(t.cuid AS nvarchar(max))), 2)) END AND contactnote.ccustno=u.ccustno AND CASE WHEN contactnote.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(contactnote.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Arccnt contactnoteq WHERE contactnoteq.cuid=contactnote.cuid) WHERE u.ccustno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:customer, 2, 2147483647), 2)) AND u.ccustno IS NOT NULL AND u.ccustno<>N'' AND DATALENGTH(CAST(u.ccustno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arcust uq WHERE uq.ccustno=u.ccustno) AND CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END=:customer AND CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END=:company AND CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END=:classification AND CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END=:status AND CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END=:billto AND CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END=:shipto AND NOT EXISTS (SELECT 1 FROM Arcont tx WHERE tx.ccustno=u.ccustno AND CASE WHEN tx.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(tx.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AND (NOT (tx.cuid IS NOT NULL AND tx.cuid<>N'' AND DATALENGTH(CAST(tx.cuid AS nvarchar(max)))>0) OR 1<>(SELECT COUNT(*) FROM Arcont tq WHERE tq.cuid=tx.cuid)))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "18C8D752-7C83-5206-9591-17E7355E9413",
"key": "caddrno",
"type": "text"
},
{
"direction": "ascending",
"id": "4FFDE6B4-2149-5A3F-9385-91284A8741BF",
"key": "AddressKey",
"type": "text"
}
],
"id": "8F10DC5C-DB6A-5203-B3D7-FA9E6EE96EDA",
"mappings": [
{
"commonFieldKey": "",
"key": "AddressKey",
"label": "Hidden composite address identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AddressKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentKey",
"label": "Hidden full owning customer identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerToken",
"label": "Hidden current customer context customer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyToken",
"label": "Hidden current customer context company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ClassToken",
"label": "Hidden current customer context classification",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ClassToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StatusToken",
"label": "Hidden current customer context status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StatusToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyToken",
"label": "Hidden current customer context currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BillToToken",
"label": "Hidden current customer context billto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillToToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShipToToken",
"label": "Hidden current customer context shipto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShipToToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccustno",
"label": "Owning current customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccustno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "caddrno",
"label": "Current address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "caddrno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccompany",
"label": "Current address company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "caddr1",
"label": "Current address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "caddr1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "caddr2",
"label": "Current address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "caddr2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccity",
"label": "Current address city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccity",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cstate",
"label": "Current address state or region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cstate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "czip",
"label": "Current address postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "czip",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ccountry",
"label": "Current address country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccountry",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cphone",
"label": "Current address phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cphone",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ccontact",
"label": "Current address contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccontact",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cemail",
"label": "Current address email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cemail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctaxcode",
"label": "Current address sales-tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctaxcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cshipvia",
"label": "Current address shipping-method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cshipvia",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cfob",
"label": "Current address FOB code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfob",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctxexptype",
"label": "Current address tax-exemption type — native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctxexptype",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dcertexp",
"label": "Current address tax-certificate expiry date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dcertexp",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OwningCustomerName",
"label": "Owning current customer name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OwningCustomerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BillToReference",
"label": "Current bill-to reference match",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillToReference",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ShipToReference",
"label": "Current ship-to reference match",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShipToReference",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AddressContext",
"label": "Current address-book scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AddressContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Current address book",
"primaryKey": "AddressKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CustomerToken",
"id": "E1490669-9D9D-56B7-AF44-E365C5A01C5C",
"name": "customer",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyToken",
"id": "E800DAAA-B2CD-54F4-9936-FCE27869D75A",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ClassToken",
"id": "08AD3913-F52D-5D9E-97E6-8DC508769F79",
"name": "classification",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "StatusToken",
"id": "08E07EFF-77B2-5ED5-BC95-A686FE54A815",
"name": "status",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CurrencyToken",
"id": "D307A053-F2C9-5558-8F8B-2A90D520D046",
"name": "currency",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "BillToToken",
"id": "0B55B1DB-0687-5ED3-9B01-461ABCBEFC9C",
"name": "billto",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ShipToToken",
"id": "B319203F-679C-5EFB-8FC6-3636E6449691",
"name": "shipto",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ccustno",
"caddrno",
"ccompany",
"caddr1",
"caddr2",
"ccity",
"cstate",
"czip",
"ccountry",
"cphone",
"ccontact",
"cemail",
"ctaxcode",
"cshipvia",
"cfob",
"ctxexptype",
"OwningCustomerName",
"BillToReference",
"ShipToReference",
"AddressContext"
],
"sourceID": "6B295A0A-C97F-5DAE-97D8-4FA3E10FAA8B",
"sqlQuery": "SELECT CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END,N':',CASE WHEN a.caddrno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(a.caddrno AS nvarchar(max))), 2)) END) AS AddressKey, CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS CustomerToken, CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END AS CompanyToken, CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END AS ClassToken, CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END AS StatusToken, CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END AS BillToToken, CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END AS ShipToToken, CAST(a.ccustno AS nvarchar(max)) AS ccustno, CAST(a.caddrno AS nvarchar(max)) AS caddrno, CAST(a.ccompany AS nvarchar(max)) AS ccompany, CAST(a.caddr1 AS nvarchar(max)) AS caddr1, CAST(a.caddr2 AS nvarchar(max)) AS caddr2, CAST(a.ccity AS nvarchar(max)) AS ccity, CAST(a.cstate AS nvarchar(max)) AS cstate, CAST(a.czip AS nvarchar(max)) AS czip, CAST(a.ccountry AS nvarchar(max)) AS ccountry, CAST(a.cphone AS nvarchar(max)) AS cphone, CAST(a.ccontact AS nvarchar(max)) AS ccontact, CAST(a.cemail AS nvarchar(max)) AS cemail, CAST(a.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(a.cshipvia AS nvarchar(max)) AS cshipvia, CAST(a.cfob AS nvarchar(max)) AS cfob, CAST(a.ctxexptype AS nvarchar(max)) AS ctxexptype, CONVERT(varchar(10), a.dcertexp, 23) AS dcertexp, CAST(u.ccompany AS nvarchar(max)) AS OwningCustomerName, CASE WHEN NOT (u.cbilltono IS NOT NULL AND u.cbilltono<>N'' AND DATALENGTH(CAST(u.cbilltono AS nvarchar(max)))>0) THEN N'No usable current bill-to reference' WHEN CASE WHEN a.caddrno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(a.caddrno AS nvarchar(max))), 2)) END=CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END THEN N'Exact current bill-to reference' ELSE N'Not the current bill-to reference' END AS BillToReference, CASE WHEN NOT (u.cshiptono IS NOT NULL AND u.cshiptono<>N'' AND DATALENGTH(CAST(u.cshiptono AS nvarchar(max)))>0) THEN N'No usable current ship-to reference' WHEN CASE WHEN a.caddrno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(a.caddrno AS nvarchar(max))), 2)) END=CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END THEN N'Exact current ship-to reference' ELSE N'Not the current ship-to reference' END AS ShipToReference, N'Current address book; exact owning-customer default references, not exclusive address types, invoice snapshots or assumed fallback' AS AddressContext FROM Arcust u INNER JOIN Arcadr a ON a.ccustno=u.ccustno AND CASE WHEN a.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(a.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END WHERE u.ccustno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:customer, 2, 2147483647), 2)) AND u.ccustno IS NOT NULL AND u.ccustno<>N'' AND DATALENGTH(CAST(u.ccustno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arcust uq WHERE uq.ccustno=u.ccustno) AND CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END=:customer AND CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END=:company AND CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END=:classification AND CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END=:status AND CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END=:billto AND CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END=:shipto AND NOT EXISTS (SELECT 1 FROM Arcadr ax WHERE ax.ccustno=u.ccustno AND CASE WHEN ax.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(ax.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AND (NOT (ax.caddrno IS NOT NULL AND ax.caddrno<>N'' AND DATALENGTH(CAST(ax.caddrno AS nvarchar(max)))>0) OR 1<>(SELECT COUNT(*) FROM Arcadr aq WHERE aq.ccustno=ax.ccustno AND aq.caddrno=ax.caddrno)))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "0B569F81-C8C2-5168-AFDA-8A44F97F8A0A",
"key": "dinvoice",
"type": "date"
},
{
"direction": "ascending",
"id": "1FBAFB24-87C8-5993-9B00-F74D2B1076CD",
"key": "InvoiceKey",
"type": "text"
}
],
"id": "EC21363B-0EEA-5CFA-BA93-89C0982B18C4",
"mappings": [
{
"commonFieldKey": "",
"key": "InvoiceKey",
"label": "Hidden full customer-owned invoice identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentKey",
"label": "Hidden full owning customer identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerToken",
"label": "Hidden current customer context customer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyToken",
"label": "Hidden current customer context company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ClassToken",
"label": "Hidden current customer context classification",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ClassToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StatusToken",
"label": "Hidden current customer context status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StatusToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyToken",
"label": "Hidden current customer context currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BillToToken",
"label": "Hidden current customer context billto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillToToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShipToToken",
"label": "Hidden current customer context shipto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShipToToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cinvno",
"label": "Recorded invoice number — not a unique key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cinvno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "crevision",
"label": "Recorded revision code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "crevision",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctype",
"label": "Recorded document type code — native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctype",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccustno",
"label": "Recorded customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccustno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cwarehouse",
"label": "Recorded warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cwarehouse",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "coriginvno",
"label": "Recorded original invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "coriginvno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "corderby",
"label": "Ordered by",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "corderby",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cslpnno",
"label": "Recorded salesperson code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cslpnno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbaddrno",
"label": "Recorded bill-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbaddrno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbcompany",
"label": "Recorded bill-to company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbcompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbaddr1",
"label": "Recorded bill-to address 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbaddr1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbaddr2",
"label": "Recorded bill-to address 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbaddr2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbcity",
"label": "Recorded bill-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbcity",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbstate",
"label": "Recorded bill-to state",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbstate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbzip",
"label": "Recorded bill-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbzip",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbcountry",
"label": "Recorded bill-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbcountry",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbphone",
"label": "Recorded bill-to phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbphone",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbcontact",
"label": "Recorded bill-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbcontact",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbemail",
"label": "Recorded bill-to email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbemail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csaddrno",
"label": "Recorded ship-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csaddrno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cscompany",
"label": "Recorded ship-to company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cscompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csaddr1",
"label": "Recorded ship-to address 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csaddr1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csaddr2",
"label": "Recorded ship-to address 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csaddr2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cscity",
"label": "Recorded ship-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cscity",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csstate",
"label": "Recorded ship-to state",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csstate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cszip",
"label": "Recorded ship-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cszip",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cscountry",
"label": "Recorded ship-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cscountry",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csphone",
"label": "Recorded ship-to phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csphone",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cscontact",
"label": "Recorded ship-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cscontact",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csemail",
"label": "Recorded ship-to email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csemail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cshipvia",
"label": "Recorded shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cshipvia",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cfob",
"label": "Recorded FOB code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfob",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpono",
"label": "Recorded customer PO reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpono",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "crmano",
"label": "Recorded RMA reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "crmano",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cfrgtcode",
"label": "Recorded freight code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfrgtcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cfrtaxcode",
"label": "Recorded freight tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfrtaxcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctaxcode",
"label": "Recorded tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctaxcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpaycode",
"label": "Recorded payment code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpaycode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccurrcode",
"label": "Recorded invoice currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccurrcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "caracc",
"label": "Recorded receivables GL account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "caracc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctogl",
"label": "Posted-to-GL native code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctogl",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cadvsono",
"label": "Recorded advance-billing SO reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cadvsono",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dorder",
"label": "Recorded order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dorder",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dinvoice",
"label": "Recorded invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dinvoice",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ddiscount",
"label": "Recorded terms-discount date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ddiscount",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ddue",
"label": "Recorded due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ddue",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "dlastpaid",
"label": "Recorded last-paid date — not a payment log",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dlastpaid",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dclosed",
"label": "Recorded closed date — not a derived status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dclosed",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dbill",
"label": "Recorded bill date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dbill",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lvoid",
"label": "Voided native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lvoid",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lfinchg",
"label": "Apply-finance-charge native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lfinchg",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lapplytax",
"label": "Apply-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lapplytax",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lprcinctax",
"label": "Price-includes-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lprcinctax",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lprtinvc",
"label": "Invoice-printed native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lprtinvc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lmultiso",
"label": "Grouped-multiple-shipments native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lmultiso",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ndiscday",
"label": "Terms discount days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ndiscday",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ndueday",
"label": "Terms net days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ndueday",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ntermdisc",
"label": "Terms discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ntermdisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ndiscrate",
"label": "Recorded invoice discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ndiscrate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfsalesamt",
"label": "Recorded foreign subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfsalesamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nfdiscamt",
"label": "Recorded foreign invoice discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfdiscamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nffrtamt",
"label": "Recorded foreign freight",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nffrtamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt1",
"label": "Recorded foreign tax amount 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt2",
"label": "Recorded foreign tax amount 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt3",
"label": "Recorded foreign tax amount 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nffrttax1",
"label": "Recorded foreign freight tax 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nffrttax1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nffrttax2",
"label": "Recorded foreign freight tax 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nffrttax2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nffrttax3",
"label": "Recorded foreign freight tax 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nffrttax3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfadjamt",
"label": "Recorded foreign invoice adjustment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfadjamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nffinamt",
"label": "Recorded foreign finance charge",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nffinamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftotpaid",
"label": "Recorded foreign paid amount — not a payment log",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftotpaid",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nftotdisc",
"label": "Recorded foreign total discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftotdisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftotadj",
"label": "Recorded foreign total adjustment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftotadj",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftotdebt",
"label": "Recorded foreign write-off",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftotdebt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfbalance",
"label": "Recorded foreign balance — no recalculation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfbalance",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nxchgrate",
"label": "Recorded exchange rate — direction unverified",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nxchgrate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoicePartyLabel",
"label": "Card recorded bill-to name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoicePartyLabel",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceRemark",
"label": "Recorded invoice remark — preview",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceRemark",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceNoteContext",
"label": "Recorded invoice remark preview scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceNoteContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceContext",
"label": "Invoice versus current customer scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Customer recorded invoices",
"primaryKey": "InvoiceKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CustomerToken",
"id": "E1490669-9D9D-56B7-AF44-E365C5A01C5C",
"name": "customer",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyToken",
"id": "E800DAAA-B2CD-54F4-9936-FCE27869D75A",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ClassToken",
"id": "08AD3913-F52D-5D9E-97E6-8DC508769F79",
"name": "classification",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "StatusToken",
"id": "08E07EFF-77B2-5ED5-BC95-A686FE54A815",
"name": "status",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CurrencyToken",
"id": "D307A053-F2C9-5558-8F8B-2A90D520D046",
"name": "currency",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "BillToToken",
"id": "0B55B1DB-0687-5ED3-9B01-461ABCBEFC9C",
"name": "billto",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ShipToToken",
"id": "B319203F-679C-5EFB-8FC6-3636E6449691",
"name": "shipto",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cinvno",
"crevision",
"ctype",
"ccustno",
"cwarehouse",
"coriginvno",
"corderby",
"cslpnno",
"cbaddrno",
"cbcompany",
"cbaddr1",
"cbaddr2",
"cbcity",
"cbstate",
"cbzip",
"cbcountry",
"cbphone",
"cbcontact",
"cbemail",
"csaddrno",
"cscompany",
"csaddr1",
"csaddr2",
"cscity",
"csstate",
"cszip",
"cscountry",
"csphone",
"cscontact",
"csemail",
"cshipvia",
"cfob",
"cpono",
"crmano",
"cfrgtcode",
"cfrtaxcode",
"ctaxcode",
"cpaycode",
"ccurrcode",
"caracc",
"ctogl",
"cadvsono",
"lvoid",
"lfinchg",
"lapplytax",
"lprcinctax",
"lprtinvc",
"lmultiso",
"ndiscday",
"ndueday",
"ntermdisc",
"ndiscrate",
"nfsalesamt",
"nfdiscamt",
"nffrtamt",
"nftaxamt1",
"nftaxamt2",
"nftaxamt3",
"nffrttax1",
"nffrttax2",
"nffrttax3",
"nfadjamt",
"nffinamt",
"nftotpaid",
"nftotdisc",
"nftotadj",
"nftotdebt",
"nfbalance",
"nxchgrate",
"InvoiceRemark",
"InvoiceNoteContext",
"InvoiceContext"
],
"sourceID": "6B295A0A-C97F-5DAE-97D8-4FA3E10FAA8B",
"sqlQuery": "SELECT CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END,N':',CASE WHEN h.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cuid AS nvarchar(max))), 2)) END) AS InvoiceKey, CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END AS CustomerToken, CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END AS CompanyToken, CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END AS ClassToken, CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END AS StatusToken, CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END AS BillToToken, CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END AS ShipToToken, CAST(h.cinvno AS nvarchar(max)) AS cinvno, CAST(h.crevision AS nvarchar(max)) AS crevision, CAST(h.ctype AS nvarchar(max)) AS ctype, CAST(h.ccustno AS nvarchar(max)) AS ccustno, CAST(h.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(h.coriginvno AS nvarchar(max)) AS coriginvno, CAST(h.corderby AS nvarchar(max)) AS corderby, CAST(h.cslpnno AS nvarchar(max)) AS cslpnno, CAST(h.cbaddrno AS nvarchar(max)) AS cbaddrno, CAST(h.cbcompany AS nvarchar(max)) AS cbcompany, CAST(h.cbaddr1 AS nvarchar(max)) AS cbaddr1, CAST(h.cbaddr2 AS nvarchar(max)) AS cbaddr2, CAST(h.cbcity AS nvarchar(max)) AS cbcity, CAST(h.cbstate AS nvarchar(max)) AS cbstate, CAST(h.cbzip AS nvarchar(max)) AS cbzip, CAST(h.cbcountry AS nvarchar(max)) AS cbcountry, CAST(h.cbphone AS nvarchar(max)) AS cbphone, CAST(h.cbcontact AS nvarchar(max)) AS cbcontact, CAST(h.cbemail AS nvarchar(max)) AS cbemail, CAST(h.csaddrno AS nvarchar(max)) AS csaddrno, CAST(h.cscompany AS nvarchar(max)) AS cscompany, CAST(h.csaddr1 AS nvarchar(max)) AS csaddr1, CAST(h.csaddr2 AS nvarchar(max)) AS csaddr2, CAST(h.cscity AS nvarchar(max)) AS cscity, CAST(h.csstate AS nvarchar(max)) AS csstate, CAST(h.cszip AS nvarchar(max)) AS cszip, CAST(h.cscountry AS nvarchar(max)) AS cscountry, CAST(h.csphone AS nvarchar(max)) AS csphone, CAST(h.cscontact AS nvarchar(max)) AS cscontact, CAST(h.csemail AS nvarchar(max)) AS csemail, CAST(h.cshipvia AS nvarchar(max)) AS cshipvia, CAST(h.cfob AS nvarchar(max)) AS cfob, CAST(h.cpono AS nvarchar(max)) AS cpono, CAST(h.crmano AS nvarchar(max)) AS crmano, CAST(h.cfrgtcode AS nvarchar(max)) AS cfrgtcode, CAST(h.cfrtaxcode AS nvarchar(max)) AS cfrtaxcode, CAST(h.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(h.cpaycode AS nvarchar(max)) AS cpaycode, CAST(h.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(h.caracc AS nvarchar(max)) AS caracc, CAST(h.ctogl AS nvarchar(max)) AS ctogl, CAST(h.cadvsono AS nvarchar(max)) AS cadvsono, CONVERT(varchar(10), h.dorder, 23) AS dorder, CONVERT(varchar(10), h.dinvoice, 23) AS dinvoice, CONVERT(varchar(10), h.ddiscount, 23) AS ddiscount, CONVERT(varchar(10), h.ddue, 23) AS ddue, CONVERT(varchar(10), h.dlastpaid, 23) AS dlastpaid, CONVERT(varchar(10), h.dclosed, 23) AS dclosed, CONVERT(varchar(10), h.dbill, 23) AS dbill, CAST(h.lvoid AS nvarchar(max)) AS lvoid, CAST(h.lfinchg AS nvarchar(max)) AS lfinchg, CAST(h.lapplytax AS nvarchar(max)) AS lapplytax, CAST(h.lprcinctax AS nvarchar(max)) AS lprcinctax, CAST(h.lprtinvc AS nvarchar(max)) AS lprtinvc, CAST(h.lmultiso AS nvarchar(max)) AS lmultiso, CAST(h.ndiscday AS nvarchar(max)) AS ndiscday, CAST(h.ndueday AS nvarchar(max)) AS ndueday, CAST(h.ntermdisc AS nvarchar(max)) AS ntermdisc, CAST(h.ndiscrate AS nvarchar(max)) AS ndiscrate, CAST(h.nfsalesamt AS nvarchar(max)) AS nfsalesamt, CAST(h.nfdiscamt AS nvarchar(max)) AS nfdiscamt, CAST(h.nffrtamt AS nvarchar(max)) AS nffrtamt, CAST(h.nftaxamt1 AS nvarchar(max)) AS nftaxamt1, CAST(h.nftaxamt2 AS nvarchar(max)) AS nftaxamt2, CAST(h.nftaxamt3 AS nvarchar(max)) AS nftaxamt3, CAST(h.nffrttax1 AS nvarchar(max)) AS nffrttax1, CAST(h.nffrttax2 AS nvarchar(max)) AS nffrttax2, CAST(h.nffrttax3 AS nvarchar(max)) AS nffrttax3, CAST(h.nfadjamt AS nvarchar(max)) AS nfadjamt, CAST(h.nffinamt AS nvarchar(max)) AS nffinamt, CAST(h.nftotpaid AS nvarchar(max)) AS nftotpaid, CAST(h.nftotdisc AS nvarchar(max)) AS nftotdisc, CAST(h.nftotadj AS nvarchar(max)) AS nftotadj, CAST(h.nftotdebt AS nvarchar(max)) AS nftotdebt, CAST(h.nfbalance AS nvarchar(max)) AS nfbalance, CAST(h.nxchgrate AS nvarchar(max)) AS nxchgrate, COALESCE(NULLIF(h.cbcompany,N''),NULLIF(h.ccustno,N''),N'Unknown recorded customer') AS InvoicePartyLabel, LEFT(CAST(invoicenote.mremark AS nvarchar(max)),4000) AS InvoiceRemark, CASE WHEN invoicenote.cuid IS NULL THEN N'No unique retained note; absence is not proof of no original note' ELSE N'Unique retained note; preview first 4,000 characters only; private authorised context' END AS InvoiceNoteContext, N'Recorded invoice addresses/currency/source amounts, not current customer defaults; no complete payment or invoice-line report' AS InvoiceContext FROM Arcust u INNER JOIN Arinvc h ON h.ccustno=u.ccustno AND CASE WHEN h.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccustno AS nvarchar(max))), 2)) END=CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END LEFT JOIN Arirmk invoicenote ON invoicenote.cuid=h.cuid AND CASE WHEN invoicenote.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(invoicenote.cuid AS nvarchar(max))), 2)) END=CASE WHEN h.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cuid AS nvarchar(max))), 2)) END AND invoicenote.cinvno=h.cinvno AND CASE WHEN invoicenote.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(invoicenote.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 1=(SELECT COUNT(*) FROM Arirmk invoicenoteq WHERE invoicenoteq.cuid=invoicenote.cuid) WHERE u.ccustno=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:customer, 2, 2147483647), 2)) AND u.ccustno IS NOT NULL AND u.ccustno<>N'' AND DATALENGTH(CAST(u.ccustno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arcust uq WHERE uq.ccustno=u.ccustno) AND CASE WHEN u.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccustno AS nvarchar(max))), 2)) END=:customer AND CASE WHEN u.ccompany IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccompany AS nvarchar(max))), 2)) END=:company AND CASE WHEN u.cclass IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cclass AS nvarchar(max))), 2)) END=:classification AND CASE WHEN u.cstatus IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cstatus AS nvarchar(max))), 2)) END=:status AND CASE WHEN u.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN u.cbilltono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cbilltono AS nvarchar(max))), 2)) END=:billto AND CASE WHEN u.cshiptono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(u.cshiptono AS nvarchar(max))), 2)) END=:shipto AND h.cuid IS NOT NULL AND h.cuid<>N'' AND DATALENGTH(CAST(h.cuid AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arinvc hq WHERE hq.cuid=h.cuid)",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "0E03AE8D-5DBD-5BBD-A671-91AF22588026",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "993CEF88-27B8-5B74-B9F0-9E4E6A586A35",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "EC60C884-22E9-5F75-A75D-03F5F6A05CEE",
"title": "Current customer contacts",
"urlKey": ""
},
{
"id": "A80AF9BE-B1DD-5DB2-868F-C8D0BB8AC37E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "67A5B20A-E293-57F7-85A0-4726E7BC2A3D",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8F10DC5C-DB6A-5203-B3D7-FA9E6EE96EDA",
"title": "Current address book",
"urlKey": ""
},
{
"id": "AD26F948-D582-5334-9706-E88AB0973A36",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "3F5192B8-7BF5-547E-B6B2-A6CD4C8A10A5",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "EC21363B-0EEA-5CFA-BA93-89C0982B18C4",
"title": "Customer recorded invoices",
"urlKey": ""
}
],
"badgeKey": "ccurrcode",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ccity",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"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": "cslpnno",
"label": "Salesperson code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cclass",
"label": "Customer class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "6576C82D-8396-52B5-ABFF-C1B062388C9E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Customer identity",
"detailRole": "information",
"isVisible": true,
"key": "ccompany",
"label": "Customer name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Customer identity",
"detailRole": "information",
"isVisible": true,
"key": "ccustno",
"label": "Customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Customer identity",
"detailRole": "information",
"isVisible": true,
"key": "ccompany2",
"label": "Customer alias",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Customer identity",
"detailRole": "information",
"isVisible": true,
"key": "cpcustno",
"label": "Parent customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current primary contact",
"detailRole": "information",
"isVisible": true,
"key": "cfname",
"label": "Contact first name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current primary contact",
"detailRole": "information",
"isVisible": true,
"key": "clname",
"label": "Contact last name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current primary contact",
"detailRole": "information",
"isVisible": true,
"key": "ctitle",
"label": "Contact title (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current primary contact",
"detailRole": "information",
"isVisible": true,
"key": "cphone1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current primary contact",
"detailRole": "information",
"isVisible": true,
"key": "cphone2",
"label": "Phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current primary contact",
"detailRole": "information",
"isVisible": true,
"key": "cemail",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current primary contact",
"detailRole": "information",
"isVisible": true,
"key": "cwebsite",
"label": "Website",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current primary contact",
"detailRole": "information",
"isVisible": true,
"key": "cfax",
"label": "Current customer fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current primary contact",
"detailRole": "information",
"isVisible": true,
"key": "corderby",
"label": "Current ordered-by reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current customer address",
"detailRole": "information",
"isVisible": true,
"key": "caddr1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current customer address",
"detailRole": "information",
"isVisible": true,
"key": "caddr2",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current customer address",
"detailRole": "information",
"isVisible": true,
"key": "ccity",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current customer address",
"detailRole": "information",
"isVisible": true,
"key": "cstate",
"label": "State or region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current customer address",
"detailRole": "information",
"isVisible": true,
"key": "czip",
"label": "ZIP or postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current customer address",
"detailRole": "information",
"isVisible": true,
"key": "ccountry",
"label": "Country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native classification codes",
"detailRole": "information",
"isVisible": true,
"key": "cstatus",
"label": "Status code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native classification codes",
"detailRole": "information",
"isVisible": true,
"key": "cclass",
"label": "Customer class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native classification codes",
"detailRole": "information",
"isVisible": true,
"key": "cindustry",
"label": "Industry code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native classification codes",
"detailRole": "information",
"isVisible": true,
"key": "cterr",
"label": "Territory code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native classification codes",
"detailRole": "information",
"isVisible": true,
"key": "cslpnno",
"label": "Salesperson code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native classification codes",
"detailRole": "information",
"isVisible": true,
"key": "clanguage",
"label": "Customer language code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current trading defaults",
"detailRole": "information",
"isVisible": true,
"key": "cwarehouse",
"label": "Default warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current trading defaults",
"detailRole": "information",
"isVisible": true,
"key": "cpaycode",
"label": "Payment code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current trading defaults",
"detailRole": "information",
"isVisible": true,
"key": "cpricecd",
"label": "Price code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current trading defaults",
"detailRole": "information",
"isVisible": true,
"key": "ccurrcode",
"label": "Customer currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current trading defaults",
"detailRole": "information",
"isVisible": true,
"key": "cbilltono",
"label": "Bill-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current trading defaults",
"detailRole": "information",
"isVisible": true,
"key": "cshiptono",
"label": "Ship-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current trading defaults",
"detailRole": "information",
"isVisible": true,
"key": "cshipvia",
"label": "Current shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current trading defaults",
"detailRole": "information",
"isVisible": true,
"key": "cfob",
"label": "Current FOB code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Last sales and receipt references",
"detailRole": "information",
"isVisible": true,
"key": "clinvno",
"label": "Last invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Last sales and receipt references",
"detailRole": "information",
"isVisible": true,
"key": "clinvcurr",
"label": "Last invoice currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Last sales and receipt references",
"detailRole": "information",
"isVisible": true,
"key": "dlsales",
"label": "Last sales date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Last sales and receipt references",
"detailRole": "information",
"isVisible": true,
"key": "clrcptno",
"label": "Last receipt number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Last sales and receipt references",
"detailRole": "information",
"isVisible": true,
"key": "clrcptcurr",
"label": "Last receipt currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Last sales and receipt references",
"detailRole": "information",
"isVisible": true,
"key": "dlrcpt",
"label": "Last receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current accounting references and terms",
"detailRole": "information",
"isVisible": true,
"key": "ctaxcode",
"label": "Current sales-tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current accounting references and terms",
"detailRole": "information",
"isVisible": true,
"key": "crevncode",
"label": "Current revenue code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current accounting references and terms",
"detailRole": "information",
"isVisible": true,
"key": "caracc",
"label": "Current receivables GL account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current accounting references and terms",
"detailRole": "information",
"isVisible": true,
"key": "ctxexptype",
"label": "Current tax-exemption type — native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current accounting references and terms",
"detailRole": "information",
"isVisible": true,
"key": "dcertexp",
"label": "Current tax-certificate expiry date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current accounting references and terms",
"detailRole": "information",
"isVisible": true,
"key": "ndiscrate",
"label": "Recorded customer discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current accounting references and terms",
"detailRole": "information",
"isVisible": true,
"key": "nexpdays",
"label": "Recorded multiple-pricing expiry days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current accounting references and terms",
"detailRole": "information",
"isVisible": true,
"key": "navgdays",
"label": "Recorded average-pay days — not recalculated",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native statement settings",
"detailRole": "information",
"isVisible": true,
"key": "cprtstmt",
"label": "Statement option code — native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native statement settings",
"detailRole": "information",
"isVisible": true,
"key": "lprtstmt",
"label": "Print-statement native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native statement settings",
"detailRole": "information",
"isVisible": true,
"key": "lconstmt",
"label": "Consolidate-statement native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native statement settings",
"detailRole": "information",
"isVisible": true,
"key": "lfinchg",
"label": "Apply-finance-charge native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native item, pricing and invoice settings",
"detailRole": "information",
"isVisible": true,
"key": "lusecusitm",
"label": "Use-customer-item-code native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native item, pricing and invoice settings",
"detailRole": "information",
"isVisible": true,
"key": "luseitemno",
"label": "Use-inventory-item-code native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native item, pricing and invoice settings",
"detailRole": "information",
"isVisible": true,
"key": "lusecusprc",
"label": "Use-customer-price native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native item, pricing and invoice settings",
"detailRole": "information",
"isVisible": true,
"key": "lgeninvc",
"label": "Generate-invoice-on-shipment native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native item, pricing and invoice settings",
"detailRole": "information",
"isVisible": true,
"key": "luselprice",
"label": "Use-last-customer-price native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native item, pricing and invoice settings",
"detailRole": "information",
"isVisible": true,
"key": "lapplytax",
"label": "Apply-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native item, pricing and invoice settings",
"detailRole": "information",
"isVisible": true,
"key": "lprcinctax",
"label": "Price-includes-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native item, pricing and invoice settings",
"detailRole": "information",
"isVisible": true,
"key": "lreqcustpo",
"label": "Require-customer-PO native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current native item, pricing and invoice settings",
"detailRole": "information",
"isVisible": true,
"key": "lchkdupcpo",
"label": "Check-duplicate-customer-PO native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current notepad and scope",
"detailRole": "information",
"isVisible": true,
"key": "CustomerNote",
"label": "Current customer notepad — preview",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current notepad and scope",
"detailRole": "information",
"isVisible": true,
"key": "CustomerNoteContext",
"label": "Customer notepad preview scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current notepad and scope",
"detailRole": "information",
"isVisible": true,
"key": "CustomerContext",
"label": "Current dossier scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "0BFB115D-9D18-5AAD-80DB-62BA43BA7AB9",
"openFilters": [
{
"id": "C841E8CF-2BD8-53B8-B1D1-BB9654FBAD04",
"includeAllOption": false,
"key": "cclass",
"title": "Choose customer class code",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "A6D42344-8C77-5253-8134-D1D2A94ED2A7",
"key": "ccompany",
"type": "text"
},
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ccustno",
"systemImage": "doc.text",
"title": "Customer dossiers",
"titleKey": "ccompany"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cphone",
"label": "Contact phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cfax",
"label": "Contact fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cemail",
"label": "Contact email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "EC60C884-22E9-5F75-A75D-03F5F6A05CEE",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current contact and owning customer",
"detailRole": "information",
"isVisible": true,
"key": "cfname",
"label": "Contact first name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact and owning customer",
"detailRole": "information",
"isVisible": true,
"key": "clname",
"label": "Contact last name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact and owning customer",
"detailRole": "information",
"isVisible": true,
"key": "ctitle",
"label": "Contact title — native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact and owning customer",
"detailRole": "information",
"isVisible": true,
"key": "ccustno",
"label": "Owning current customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact and owning customer",
"detailRole": "information",
"isVisible": true,
"key": "OwningCustomerName",
"label": "Owning current customer name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact channels",
"detailRole": "information",
"isVisible": true,
"key": "cphone",
"label": "Contact phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact channels",
"detailRole": "information",
"isVisible": true,
"key": "cfax",
"label": "Contact fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact channels",
"detailRole": "information",
"isVisible": true,
"key": "cemail",
"label": "Contact email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Private retained contact note",
"detailRole": "information",
"isVisible": true,
"key": "ContactNote",
"label": "Current contact notepad — preview",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Private retained contact note",
"detailRole": "information",
"isVisible": true,
"key": "ContactNoteContext",
"label": "Contact notepad preview scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "13682E52-C0C3-5564-AC35-D46618F5A82E",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "8D9226E4-EF23-58A9-95F4-64D4C0737C81",
"key": "clname",
"type": "text"
},
{
"direction": "ascending",
"id": "992EF8B7-F10C-54B1-A8C7-5989E8B1BD96",
"key": "ContactKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ctitle",
"systemImage": "doc.text",
"title": "Current customer contacts",
"titleKey": "ContactName"
},
{
"actions": [],
"badgeKey": "ccountry",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ccity",
"label": "Current address city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "czip",
"label": "Current address postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cphone",
"label": "Current address phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ccontact",
"label": "Current address contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BillToReference",
"label": "Current bill-to reference match",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ShipToReference",
"label": "Current ship-to reference match",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "8F10DC5C-DB6A-5203-B3D7-FA9E6EE96EDA",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current address identity and references",
"detailRole": "information",
"isVisible": true,
"key": "caddrno",
"label": "Current address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address identity and references",
"detailRole": "information",
"isVisible": true,
"key": "ccompany",
"label": "Current address company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address identity and references",
"detailRole": "information",
"isVisible": true,
"key": "ccustno",
"label": "Owning current customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address identity and references",
"detailRole": "information",
"isVisible": true,
"key": "OwningCustomerName",
"label": "Owning current customer name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address identity and references",
"detailRole": "information",
"isVisible": true,
"key": "BillToReference",
"label": "Current bill-to reference match",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address identity and references",
"detailRole": "information",
"isVisible": true,
"key": "ShipToReference",
"label": "Current ship-to reference match",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address identity and references",
"detailRole": "information",
"isVisible": true,
"key": "AddressContext",
"label": "Current address-book scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address and contact",
"detailRole": "information",
"isVisible": true,
"key": "caddr1",
"label": "Current address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address and contact",
"detailRole": "information",
"isVisible": true,
"key": "caddr2",
"label": "Current address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address and contact",
"detailRole": "information",
"isVisible": true,
"key": "ccity",
"label": "Current address city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address and contact",
"detailRole": "information",
"isVisible": true,
"key": "cstate",
"label": "Current address state or region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address and contact",
"detailRole": "information",
"isVisible": true,
"key": "czip",
"label": "Current address postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address and contact",
"detailRole": "information",
"isVisible": true,
"key": "ccountry",
"label": "Current address country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address and contact",
"detailRole": "information",
"isVisible": true,
"key": "cphone",
"label": "Current address phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address and contact",
"detailRole": "information",
"isVisible": true,
"key": "ccontact",
"label": "Current address contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address and contact",
"detailRole": "information",
"isVisible": true,
"key": "cemail",
"label": "Current address email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address shipping and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "cshipvia",
"label": "Current address shipping-method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address shipping and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "cfob",
"label": "Current address FOB code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address shipping and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "ctaxcode",
"label": "Current address sales-tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address shipping and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "ctxexptype",
"label": "Current address tax-exemption type — native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current address shipping and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "dcertexp",
"label": "Current address tax-certificate expiry date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "562CEA76-D3B0-5461-A40C-43878EF4214F",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "18C8D752-7C83-5206-9591-17E7355E9413",
"key": "caddrno",
"type": "text"
},
{
"direction": "ascending",
"id": "4FFDE6B4-2149-5A3F-9385-91284A8741BF",
"key": "AddressKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "caddrno",
"systemImage": "doc.text",
"title": "Current address book",
"titleKey": "ccompany"
},
{
"actions": [],
"badgeKey": "ccurrcode",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cpono",
"label": "Recorded customer PO reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dinvoice",
"label": "Recorded invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ddue",
"label": "Recorded due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nfsalesamt",
"label": "Recorded foreign subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nftotpaid",
"label": "Recorded foreign paid amount — not a payment log",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nfbalance",
"label": "Recorded foreign balance — no recalculation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "EC21363B-0EEA-5CFA-BA93-89C0982B18C4",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded document — native type, not a guessed credit status",
"detailRole": "information",
"isVisible": true,
"key": "cinvno",
"label": "Recorded invoice number — not a unique key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native type, not a guessed credit status",
"detailRole": "information",
"isVisible": true,
"key": "ctype",
"label": "Recorded document type code — native",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native type, not a guessed credit status",
"detailRole": "information",
"isVisible": true,
"key": "crevision",
"label": "Recorded revision code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native type, not a guessed credit status",
"detailRole": "information",
"isVisible": true,
"key": "ccustno",
"label": "Recorded customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native type, not a guessed credit status",
"detailRole": "information",
"isVisible": true,
"key": "cpono",
"label": "Recorded customer PO reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native type, not a guessed credit status",
"detailRole": "information",
"isVisible": true,
"key": "coriginvno",
"label": "Recorded original invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native type, not a guessed credit status",
"detailRole": "information",
"isVisible": true,
"key": "crmano",
"label": "Recorded RMA reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native type, not a guessed credit status",
"detailRole": "information",
"isVisible": true,
"key": "cadvsono",
"label": "Recorded advance-billing SO reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native type, not a guessed credit status",
"detailRole": "information",
"isVisible": true,
"key": "corderby",
"label": "Ordered by",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native type, not a guessed credit status",
"detailRole": "information",
"isVisible": true,
"key": "cslpnno",
"label": "Recorded salesperson code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded dates — not a complete payment log",
"detailRole": "information",
"isVisible": true,
"key": "dinvoice",
"label": "Recorded invoice date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded dates — not a complete payment log",
"detailRole": "information",
"isVisible": true,
"key": "ddue",
"label": "Recorded due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded dates — not a complete payment log",
"detailRole": "information",
"isVisible": true,
"key": "ddiscount",
"label": "Recorded terms-discount date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded dates — not a complete payment log",
"detailRole": "information",
"isVisible": true,
"key": "dorder",
"label": "Recorded order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded dates — not a complete payment log",
"detailRole": "information",
"isVisible": true,
"key": "dlastpaid",
"label": "Recorded last-paid date — not a payment log",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded dates — not a complete payment log",
"detailRole": "information",
"isVisible": true,
"key": "dclosed",
"label": "Recorded closed date — not a derived status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded dates — not a complete payment log",
"detailRole": "information",
"isVisible": true,
"key": "dbill",
"label": "Recorded bill date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbaddrno",
"label": "Recorded bill-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbcompany",
"label": "Recorded bill-to company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbaddr1",
"label": "Recorded bill-to address 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbaddr2",
"label": "Recorded bill-to address 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbcity",
"label": "Recorded bill-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbstate",
"label": "Recorded bill-to state",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbzip",
"label": "Recorded bill-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbcountry",
"label": "Recorded bill-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbphone",
"label": "Recorded bill-to phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbcontact",
"label": "Recorded bill-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbemail",
"label": "Recorded bill-to email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "csaddrno",
"label": "Recorded ship-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cscompany",
"label": "Recorded ship-to company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "csaddr1",
"label": "Recorded ship-to address 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "csaddr2",
"label": "Recorded ship-to address 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cscity",
"label": "Recorded ship-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "csstate",
"label": "Recorded ship-to state",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cszip",
"label": "Recorded ship-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cscountry",
"label": "Recorded ship-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "csphone",
"label": "Recorded ship-to phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cscontact",
"label": "Recorded ship-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "csemail",
"label": "Recorded ship-to email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and accounting codes",
"detailRole": "information",
"isVisible": true,
"key": "cwarehouse",
"label": "Recorded warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and accounting codes",
"detailRole": "information",
"isVisible": true,
"key": "cshipvia",
"label": "Recorded shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and accounting codes",
"detailRole": "information",
"isVisible": true,
"key": "cfob",
"label": "Recorded FOB code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and accounting codes",
"detailRole": "information",
"isVisible": true,
"key": "cfrgtcode",
"label": "Recorded freight code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and accounting codes",
"detailRole": "information",
"isVisible": true,
"key": "cfrtaxcode",
"label": "Recorded freight tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and accounting codes",
"detailRole": "information",
"isVisible": true,
"key": "ctaxcode",
"label": "Recorded tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and accounting codes",
"detailRole": "information",
"isVisible": true,
"key": "caracc",
"label": "Recorded receivables GL account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and accounting codes",
"detailRole": "information",
"isVisible": true,
"key": "ctogl",
"label": "Posted-to-GL native code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and accounting codes",
"detailRole": "information",
"isVisible": true,
"key": "cpaycode",
"label": "Recorded payment code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded pricing and native flags",
"detailRole": "information",
"isVisible": true,
"key": "lvoid",
"label": "Voided native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded pricing and native flags",
"detailRole": "information",
"isVisible": true,
"key": "lfinchg",
"label": "Apply-finance-charge native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded pricing and native flags",
"detailRole": "information",
"isVisible": true,
"key": "lapplytax",
"label": "Apply-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded pricing and native flags",
"detailRole": "information",
"isVisible": true,
"key": "lprcinctax",
"label": "Price-includes-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded pricing and native flags",
"detailRole": "information",
"isVisible": true,
"key": "lprtinvc",
"label": "Invoice-printed native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded pricing and native flags",
"detailRole": "information",
"isVisible": true,
"key": "lmultiso",
"label": "Grouped-multiple-shipments native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded pricing and native flags",
"detailRole": "information",
"isVisible": true,
"key": "ndiscday",
"label": "Terms discount days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded pricing and native flags",
"detailRole": "information",
"isVisible": true,
"key": "ndueday",
"label": "Terms net days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded pricing and native flags",
"detailRole": "information",
"isVisible": true,
"key": "ntermdisc",
"label": "Terms discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded pricing and native flags",
"detailRole": "information",
"isVisible": true,
"key": "ndiscrate",
"label": "Recorded invoice discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "ccurrcode",
"label": "Recorded invoice currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nfsalesamt",
"label": "Recorded foreign subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nfdiscamt",
"label": "Recorded foreign invoice discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nffrtamt",
"label": "Recorded foreign freight",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt1",
"label": "Recorded foreign tax amount 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt2",
"label": "Recorded foreign tax amount 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt3",
"label": "Recorded foreign tax amount 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nffrttax1",
"label": "Recorded foreign freight tax 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nffrttax2",
"label": "Recorded foreign freight tax 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nffrttax3",
"label": "Recorded foreign freight tax 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nfadjamt",
"label": "Recorded foreign invoice adjustment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign invoice amounts — no net or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nffinamt",
"label": "Recorded foreign finance charge",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign ledger values — not complete allocations",
"detailRole": "information",
"isVisible": true,
"key": "nftotpaid",
"label": "Recorded foreign paid amount — not a payment log",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign ledger values — not complete allocations",
"detailRole": "information",
"isVisible": true,
"key": "nftotdisc",
"label": "Recorded foreign total discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign ledger values — not complete allocations",
"detailRole": "information",
"isVisible": true,
"key": "nftotadj",
"label": "Recorded foreign total adjustment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign ledger values — not complete allocations",
"detailRole": "information",
"isVisible": true,
"key": "nftotdebt",
"label": "Recorded foreign write-off",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign ledger values — not complete allocations",
"detailRole": "information",
"isVisible": true,
"key": "nfbalance",
"label": "Recorded foreign balance — no recalculation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign ledger values — not complete allocations",
"detailRole": "information",
"isVisible": true,
"key": "nxchgrate",
"label": "Recorded exchange rate — direction unverified",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded note and owning current customer",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceRemark",
"label": "Recorded invoice remark — preview",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded note and owning current customer",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceNoteContext",
"label": "Recorded invoice remark preview scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded note and owning current customer",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceContext",
"label": "Invoice versus current customer scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "3CEE074A-215C-55CE-9CB1-C21036CF2618",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "0B569F81-C8C2-5168-AFDA-8A44F97F8A0A",
"key": "dinvoice",
"type": "date"
},
{
"direction": "ascending",
"id": "1FBAFB24-87C8-5993-9B00-F74D2B1076CD",
"key": "InvoiceKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "InvoicePartyLabel",
"systemImage": "doc.text",
"title": "Customer recorded invoices",
"titleKey": "cinvno"
}
],
"relations": [
{
"childDatasetID": "EC60C884-22E9-5F75-A75D-03F5F6A05CEE",
"childKey": "ParentKey",
"id": "993CEF88-27B8-5B74-B9F0-9E4E6A586A35",
"name": "Current customer contacts",
"parentDatasetID": "6576C82D-8396-52B5-ABFF-C1B062388C9E",
"parentKey": "CustomerKey"
},
{
"childDatasetID": "8F10DC5C-DB6A-5203-B3D7-FA9E6EE96EDA",
"childKey": "ParentKey",
"id": "67A5B20A-E293-57F7-85A0-4726E7BC2A3D",
"name": "Current address book",
"parentDatasetID": "6576C82D-8396-52B5-ABFF-C1B062388C9E",
"parentKey": "CustomerKey"
},
{
"childDatasetID": "EC21363B-0EEA-5CFA-BA93-89C0982B18C4",
"childKey": "ParentKey",
"id": "3F5192B8-7BF5-547E-B6B2-A6CD4C8A10A5",
"name": "Customer recorded invoices",
"parentDatasetID": "6576C82D-8396-52B5-ABFF-C1B062388C9E",
"parentKey": "CustomerKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "AccountMate for SQL/Express",
"changelog": "Initial Pro customer dossiers with class opening filter, current contacts and address book, guarded private note previews and recent recorded invoices on demand. Eight original fictional native images. Not tested on a real ERP.",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-11T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.\n\nFor sales, customer service, dispatch, accounting and managers: choose a customer class and open a useful customer dossier. See primary contact, current address, trading and shipping defaults, accounting references and retained customer note. Three buttons open all retained current contacts, the current address book with bill-to/ship-to reference matches, or the customer’s recent retained invoices, loaded only when opened.\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 SQL Server source, four live lists and three on-demand sub-buttons. All 63 customer, 10 contact, 21 address and 79 invoice useful Detail positions are kept; technical tokens are hidden. Choose class before the 2,000-customer cap. Contact/address/invoice lists have 500-row caps. The invoice sub-button reads this exact customer and sorts by recorded invoice date; it does not prompt for a separate period. Search/local filters affect loaded rows. No widgets, scheduled refresh, writes, automatic totals or invoice-line route. Existing workspace resources count; limits do not guarantee cheap SQL reads. Narrow the class and verify customer/invoice indexes and read time.\n\nCurrent customer, contacts and address book are not historical invoice snapshots. Bill-to and ship-to are exact current references within this customer, not exclusive address types; the same address can match both. Missing defaults do not invent an address fallback. Status, statement, tax-exemption and all flags stay native codes, including unknown/NULL values. Codes/phones/ZIPs remain text. Stored average-pay days and discount are source values, not recomputed or vendor-procedure execution.\n\nInvoice addresses, contacts, dates, currency, subtotal/discount/freight/taxes/adjustments/paid/write-off/balance are recorded invoice values and stay separate from current defaults. No currency conversion, net/ageing/overdue/paid-status calculation or complete payment/allocation history is implied. Voided, negative, zero and unknown type/status remain visible. Only current Arinvc, not archived documents. NULL invoice dates are retained as unknown. The invoice sub-button is a bounded recent-document view, not full history; use the separate invoice report to choose a period at opening. This dossier does not include invoice lines; use the separate recorded invoice-lines configuration for that workflow.\n\nKeys: full company-scoped customer ccustno; contact cuid; address ccustno+caddrno; invoice cuid, never the displayed invoice number. Exact NULL-aware UTF16 encoded customer context (code/name/class/status/currency/bill-to/ship-to) is bound and projected by every child, revalidated at each request; no business-value SQL interpolation. Missing/duplicate customer identity returns no arbitrary dossier. Missing/ambiguous child identity blocks its branch, not unrelated routes. Contacts and addresses require exact owning customer. Repeated invoice numbers including FCHG/0 remain independent full-UID records.\n\nCustomer/contact/invoice notes use independently documented owning keys, unique optional matching and first-4,000-character previews; missing/ambiguous notes do not drop or multiply their records. Private notes/contacts require authorised access. Customer-master monetary balances/credit limits are excluded because their currency basis is unverified. No bank/routing, payment-card/password/tax-identifier or generic audit columns are selected.\n\nCompatibility: historical AccountMate 12 SQL/Express AR database reference (created 20 April 2021), not Enterprise or current edition certification. SQL Server 2012+ CONCAT required. No owner is asserted. Administrator must verify uniquely readable objects resolved consistently by Android/iOS login/default schema; Android metadata may prefer dbo while iOS uses defaults, so import is not claimed to reject ambiguous owners automatically. Qualify confirmed objects in Studio and rerun bounded tests. Required/AMTBL describes data-entry metadata, not installed DDL/NOT NULL. Check actual edition/types/full keys/collation, currency/date/decimal semantics, read costs and SELECT permissions. Documentary/SQLite synthetic checks and fictional Android captures are not real ERP/native SQL Server/iOS, performance/security/entitlement certification.\n\nUse a least-privilege SELECT-only authorised company database, not systemDB or another company. Direct SQL is not ERP ACL; filters are not access permissions. No credentials, server addresses or production rows in the package. Unofficial, not endorsed by AccountMate.\n\nDocumentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_ar_drg.pdf\n\nGallery: Eight original native Cifru DEMO images show the class opening filter, complete customer/contact/address/invoice card values, all three actual actions and representative Details from every branch. All values are invented; no AccountMate installation was connected. The configuration retains 173 useful Detail positions: 63 current customer, 10 current contact, 21 current address and 79 recorded invoice. Their nonblank values are checked in all private overlapping native continuations. Eight images are representative, not all 173 fields; no configured field was removed and no screenshot was retouched to fit the gallery. Native cards can shorten long labels; the full labels and caveats remain in Details and the configuration. All three action names are fully visible in the customer Details continuation. Current customer currency/defaults/addresses/contacts are not historic invoice values: the invented current customer uses GBP and its recorded invoice USD. Address reference matches use the exact owning customer and code, can both match, and do not imply exclusive address roles or fallback. Notes are private authorised first 4,000-character previews, not complete text. Invoice source amounts and balance remain separate, with no calculated net, FX, financial reconciliation, complete payment log or invoice-line report. Related invoices are a recent list capped at 500, not the entire history or a child opening-period prompt; the separate invoice dossier supplies a Home period and lines. Original PNG/XML, exact invented input and silent RAW are retained for future videos. Whole RAW/Home, the extra customer with instrumentation null placeholders and redundant continuations are private and not video-approved; NULL conversion is not certified. Pro requirements were checked; capture uses a Pro test entitlement, not a purchase test. This proves native synthetic Android GUI/action traversal and adapted SELECT intent, not real ERP/native SQL Server/iOS/current edition/DDL/owner/collation/source ACL or performance. Historical AccountMate 12 documentation is not certification of an installed or current schema.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "A616D024-D5F6-58D6-A306-7E8BE3195428",
"rootButtonCount": 1,
"summary": "Choose a customer class; open full current dossiers, contacts, addresses and recent retained invoices on demand.",
"tags": [
"AccountMate",
"SQL Server",
"Customers",
"Contacts",
"Address book",
"Accounting",
"Invoices",
"Pro"
],
"title": "Customer dossier, contacts, address book and invoices — Pro"
}
}