Customer invoices, recorded lines and current dossiers — Pro

Choose an invoice period; inspect recorded amounts, due dates, addresses and lines, then current item and customer details.

UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.

For sales, accounting, customer service and managers: choose the recorded invoice-date period, inspect recorded bill-to/ship-to details, due dates, source foreign amounts and balance, then open recorded invoice lines and an optional current inventory item. A separate action opens the current customer contact, address, classification and trading references.

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 SQL Server company source, four live lists, full same-row Details and three lazy actions: invoice to recorded lines, line to current inventory item, invoice to current customer. 79 invoice, 47 line, 20 item and 37 current-customer useful Detail positions; identity tokens hidden. Mandatory native invoice-date period before the final 2,000-root cap; child caps 500. Search/local filters affect loaded rows. No widgets, automatic refresh, computed financial totals or writes. Existing workspace resources count; caps are not performance guarantees.

SCOPE: current Arinvc/Aritrs only. No automatic history, recurring-invoice, payment/allocation, serial/lot or amortisation-transaction union. Invoice type and line/GL status are NATIVE CODES, not guessed invoice/credit/open/paid meanings. Voided, negative, zero, NULL and unknown values are retained; no implicit exclusion. The period uses recorded dinvoice, not due, payment or creation date; NULL invoice dates do not enter a chosen period.

IDENTITY: full company-scoped invoice cuid, NOT its displayed cinvno or customer-number pair. The manual documents special invoice numbers FCHG and 0. Aritrs has its own cuid and recorded invoice/customer references, NOT an owning-header UID column. Before line selection require ONE exact invoice/customer pair across ALL current headers, including outside the period. An ambiguous/blank pair leaves the header readable, clearly explains the blocked lines in Details and returns no arbitrary line match; current customer remains independently accessible. Blank/missing/ambiguous matching line cuid blocks the entire line/product branch. Revalidate all 11 invoice context tokens (UID, number, customer, currency, invoice/due dates, void/type/revision, stored foreign balance and paid amount), then nine recorded line tokens before item access. Every child projects bound parent context, including the nested child; no synthetic filter is allowed to silently skip a missing field. UTF16 encoded NULL-aware tokens preserve exact Unicode/whitespace/NULL versus blank through app trimming. No business-value SQL interpolation.

RECORDED VERSUS CURRENT: invoice contacts, addresses, prices, warehouse, SO/shipment/RMA references and lines remain document values. Nonstock/service/orphan lines stay visible. Current item/customer require optional unique exact code matches, not historical ownership or ERP ACL proof. Missing/ambiguous masters return no arbitrary match and do not erase the invoice or line. Current customer currency is separately shown from recorded invoice currency. Current inventory price/cost currency and unit basis are UNVERIFIED, not invoice unit price.

MONEY: foreign subtotal, invoice discount, freight, three taxes and three freight-tax fields, adjustment, finance charge, paid, total discounts/adjustments/write-off and balance are SEPARATE exact source values. No net/total/FX/ageing/overdue/payment-status/reconciliation computation or addition of potentially included taxes. Stored paid, balance, closed and last-paid fields are NOT a complete payment or allocation log. Line foreign values retain owning recorded invoice currency; no own line-currency column, ISO convention, base currency or FX direction is invented. Money, quantities, flags and terms stay text with textual local operations; only sequence sorts numerically. Ordered/shipped quantities and two unit factors stay separate: no remaining or stock formula, unit conversion or completion proof. Amortisation codes/dates/cycles are metadata, NOT a schedule or realised revenue report.

NOTES: AR12 explicitly links header-note UID to header UID and line-note UID to line UID. Use the own UID AND exact invoice reference, with optional unique matches; missing/ambiguous notes cannot drop/multiply rows. Previews contain only the first 4,000 characters, NOT guaranteed complete text. Private notes/contacts require authorised access. Bank/check/card/cardholder/expiry, password/tax identifiers and generic audit fields are excluded.

COMPATIBILITY: historical AccountMate 12 SQL/Express AR PDF created 20 April 2021 (printed February 2021), plus separate IC12 product and own AR12 customer proof. Not Enterprise or current SQL14 certification. SQL Server2012+ CONCAT is needed. Owner is UNKNOWN: administrator confirms one uniquely readable Arinvc/Aritrs/Arirmk/Aritrk/Icitem/Arcust resolved identically by Android/iOS login/default schema. Android metadata may prefer dbo while iOS uses default resolution; import is NOT claimed to reject duplicate owners automatically. Qualify confirmed objects in Studio and rerun bounded tests. Required/AMTBL is data-entry metadata, not installed DDL/NOT NULL. Check actual edition/types/keys/NULL/collation/indexes/SQL cost/date/decimal/currency/unit semantics. Documentary and adapted SQLite synthetic checks are NOT real ERP, native SQL Server, iOS, performance, security or entitlement certification.

SECURITY: authorised companyDB least-privilege SELECT. Direct SQL does not inherit ERP ACL; filters are not permissions. Package has no credentials, server addresses or business rows. Unofficial, not endorsed by AccountMate.

Documentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_ar_drg.pdf
https://www.accountmateportal.com/xasset/techdoc/amsql12_ic_drg.pdf

Gallery: Eight original native Cifru DEMO images show complete invoice, recorded-line, current-product and current-customer cards and representative Details for all four actual routes. The two root actions and nested item action were actually traversed; both root sub-buttons appear in the selected invoice Details. All business values are invented; no AccountMate installation was connected. The configuration retains 183 useful Detail positions (79 invoice, 47 line, 20 current item, 37 current customer), checked in full private overlapping native continuations. This is a representative gallery, not a claim that eight images show every configured field. Recorded bill-to/ship-to contacts and addresses, additional dates, taxes, amounts, codes, amortisation metadata and note continuations remain in the JSON and private captures; no field was removed and no screenshot retouched to fit eight. Source paid amount and balance are not a complete payment or allocation log; dates/flags do not create a guessed paid or credit status. Money, quantities, flags and terms stay exact source text, not net/FX/ageing/overdue/remaining/stock formulas. Current item price/cost has explicitly unverified currency and unit basis and is not the recorded invoice price. The current-customer currency/contact/address is not the invoice snapshot and never replaces it. Invoice and line notes use their own documented UID ownership and exact invoice reference with optional unique first-4,000-character previews; missing/ambiguous notes do not drop or multiply rows. Invoice identity uses full cuid, not the displayed number. An ambiguous exact invoice/customer pair across all current headers blocks arbitrary line access, not the readable invoice or independent current-customer action. Nonstock/service/orphan lines remain visible. Amortisation fields are metadata, not a schedule or realised-revenue report; archives/payments/serials are not automatically included. Private contacts/notes require authorised SQL access; direct SQL does not inherit ERP ACL. Original PNG/XML pairs, frozen invented input and silent RAW are retained for future videos. Whole RAW/Home, the native opening-summary internal last7Days label, synthetic null placeholders and redundant continuations remain private and are not video-approved. Pro requirements were checked; capture uses a Pro test entitlement, not a purchase test. This proves native synthetic Android UI/action traversal and constrained adapted reference query intent, not real ERP, native SQLServer/iOS/current edition/DDL/owner/collation, connector NULL conversion, ISO currency/FX/unit conventions, source ACL, reconciliation, archive completeness or performance.

Screenshots

What this package creates

1 Home3 Details4 lists1 sources to map

Home: Customer invoices
Details: Recorded invoice lines
Details: Current inventory item
Details: Current customer
Sub-button: Recorded invoice lines
Sub-button: Current inventory item
Sub-button: Current customer

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.sqlQuery

SELECT 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 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 InvoiceToken, CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AS InvoiceNumberToken, 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 AS CustomerToken, CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END AS InvoiceDateToken, CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END AS DueDateToken, CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END AS VoidedToken, CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END AS DocumentTypeToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END AS BalanceToken, CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END AS PaidToken, 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(onote.mremark AS nvarchar(max)), 4000) AS InvoiceRemark, CASE WHEN onote.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, inspect source for full text' END AS InvoiceNoteContext, CASE WHEN h.cinvno IS NOT NULL AND h.cinvno<>N'' AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arinvc hp WHERE hp.cinvno=h.cinvno AND CASE WHEN hp.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.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 CASE WHEN hp.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.ccustno AS nvarchar(max))), 2)) END=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) THEN N'Unique current invoice/customer pair; lines requested on demand' ELSE N'Ambiguous or blank invoice/customer pair: recorded lines are not displayed; administrator must verify ownership' END AS LineOwnershipContext FROM Arinvc h LEFT JOIN Arirmk onote ON onote.cuid=h.cuid AND CASE WHEN onote.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(onote.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 onote.cinvno=h.cinvno AND CASE WHEN onote.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(onote.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 nq WHERE nq.cuid=onote.cuid) WHERE 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

Statically verified read-only$.components.workspaceSelection.datasets.1.sqlQuery

SELECT 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 ParentKey, CONCAT(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,N':',CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END) AS LineKey, 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 InvoiceToken, CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AS InvoiceNumberToken, 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 AS CustomerToken, CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END AS InvoiceDateToken, CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END AS DueDateToken, CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END AS VoidedToken, CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END AS DocumentTypeToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END AS BalanceToken, CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END AS PaidToken, CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END AS LineToken, CASE WHEN l.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.citemno AS nvarchar(max))), 2)) END AS ItemToken, CASE WHEN l.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN l.cmeasure IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cmeasure AS nvarchar(max))), 2)) END AS UnitToken, CASE WHEN l.lstock IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.lstock AS nvarchar(max))), 2)) END AS StockToken, CASE WHEN l.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode1 AS nvarchar(max))), 2)) END AS Spec1Token, CASE WHEN l.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode2 AS nvarchar(max))), 2)) END AS Spec2Token, CASE WHEN l.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.csono AS nvarchar(max))), 2)) END AS SalesOrderToken, CASE WHEN l.cshipno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cshipno AS nvarchar(max))), 2)) END AS ShipmentToken, CAST(l.cinvno AS nvarchar(max)) AS cinvno, CAST(l.ccustno AS nvarchar(max)) AS ccustno, CAST(l.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(l.csono AS nvarchar(max)) AS csono, CAST(l.cshipno AS nvarchar(max)) AS cshipno, CAST(l.crmano AS nvarchar(max)) AS crmano, CAST(l.crtncode AS nvarchar(max)) AS crtncode, CAST(l.citemno AS nvarchar(max)) AS citemno, CAST(l.cspeccode1 AS nvarchar(max)) AS cspeccode1, CAST(l.cspeccode2 AS nvarchar(max)) AS cspeccode2, CAST(l.cdescript AS nvarchar(max)) AS cdescript, CAST(l.cmeasure AS nvarchar(max)) AS cmeasure, CAST(l.cstatus AS nvarchar(max)) AS cstatus, CAST(l.crevncode AS nvarchar(max)) AS crevncode, CAST(l.cbin AS nvarchar(max)) AS cbin, CAST(l.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(l.camrtmethd AS nvarchar(max)) AS camrtmethd, CAST(l.camrtrecur AS nvarchar(max)) AS camrtrecur, CONVERT(varchar(10), l.damrtstart, 23) AS damrtstart, CONVERT(varchar(10), l.damrtend, 23) AS damrtend, CAST(l.lkititem AS nvarchar(max)) AS lkititem, CAST(l.lstock AS nvarchar(max)) AS lstock, CAST(l.lmodikit AS nvarchar(max)) AS lmodikit, CAST(l.lmultibin AS nvarchar(max)) AS lmultibin, CAST(l.ltaxable1 AS nvarchar(max)) AS ltaxable1, CAST(l.ltaxable2 AS nvarchar(max)) AS ltaxable2, CAST(l.lamortize AS nvarchar(max)) AS lamortize, CAST(l.ldropship AS nvarchar(max)) AS ldropship, CAST(l.nqtydec AS nvarchar(max)) AS nqtydec, CAST(l.ndiscrate AS nvarchar(max)) AS ndiscrate, CAST(l.nfsalesamt AS nvarchar(max)) AS nfsalesamt, CAST(l.nfdiscamt AS nvarchar(max)) AS nfdiscamt, CAST(l.nftaxamt1 AS nvarchar(max)) AS nftaxamt1, CAST(l.nftaxamt2 AS nvarchar(max)) AS nftaxamt2, CAST(l.nftaxamt3 AS nvarchar(max)) AS nftaxamt3, CAST(l.nordqty AS nvarchar(max)) AS nordqty, CAST(l.nshipqty AS nvarchar(max)) AS nshipqty, CAST(l.nitmcnvqty AS nvarchar(max)) AS nitmcnvqty, CAST(l.ntrscnvqty AS nvarchar(max)) AS ntrscnvqty, CAST(l.nfprice AS nvarchar(max)) AS nfprice, CAST(l.nfprcinctx AS nvarchar(max)) AS nfprcinctx, CAST(l.nseq AS nvarchar(max)) AS nseq, CAST(l.namrtcycle AS nvarchar(max)) AS namrtcycle, CAST(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode, LEFT(CAST(lnote.mremark AS nvarchar(max)), 4000) AS LineRemark, CASE WHEN lnote.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, inspect source for full text' END AS LineNoteContext, CASE WHEN i.citemno IS NULL THEN N'Missing or ambiguous current inventory item; recorded line retained' ELSE N'Unique current inventory code match; verify native stock flag, not invoice snapshot; current-price currency/unit basis UNVERIFIED' END AS ProductContext FROM Arinvc h INNER JOIN Aritrs l ON l.cinvno=h.cinvno AND CASE WHEN l.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.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 CASE WHEN l.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.ccustno AS nvarchar(max))), 2)) END=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 LEFT JOIN Aritrk lnote ON lnote.cuid=l.cuid AND CASE WHEN lnote.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lnote.cuid AS nvarchar(max))), 2)) END=CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END AND lnote.cinvno=l.cinvno AND CASE WHEN lnote.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lnote.cinvno AS nvarchar(max))), 2)) END=CASE WHEN l.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cinvno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Aritrk nq WHERE nq.cuid=lnote.cuid) LEFT JOIN Icitem i ON i.citemno=l.citemno AND CASE WHEN i.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(i.citemno AS nvarchar(max))), 2)) END=CASE WHEN l.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.citemno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Icitem iq WHERE iq.citemno=i.citemno) WHERE h.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:invoice_uid, 2, 2147483647), 2)) 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) AND 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=:invoice_uid AND CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END=:invoice_number 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=:customer AND CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END=:invoice_date AND CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END=:due_date AND CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END=:voided AND CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END=:document_type AND CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END=:revision AND CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END=:foreign_balance AND CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END=:foreign_paid AND h.cinvno IS NOT NULL AND h.cinvno<>N'' AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arinvc hp WHERE hp.cinvno=h.cinvno AND CASE WHEN hp.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.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 CASE WHEN hp.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.ccustno AS nvarchar(max))), 2)) END=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) AND NOT EXISTS (SELECT 1 FROM Aritrs lx WHERE lx.cinvno=h.cinvno AND CASE WHEN lx.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.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 CASE WHEN lx.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.ccustno AS nvarchar(max))), 2)) END=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 AND (lx.cuid IS NULL OR lx.cuid=N'' OR DATALENGTH(CAST(lx.cuid AS nvarchar(max)))=0 OR 1<>(SELECT COUNT(*) FROM Aritrs lq WHERE lq.cuid=lx.cuid)))

static read-only checks passed

Statically verified read-only$.components.workspaceSelection.datasets.2.sqlQuery

SELECT CONCAT(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,N':',CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END) AS ParentKey, CONCAT(CONCAT(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,N':',CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END),N':',CASE WHEN i.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(i.citemno AS nvarchar(max))), 2)) END) AS ProductKey, 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 InvoiceToken, CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AS InvoiceNumberToken, 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 AS CustomerToken, CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END AS InvoiceDateToken, CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END AS DueDateToken, CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END AS VoidedToken, CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END AS DocumentTypeToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END AS BalanceToken, CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END AS PaidToken, CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END AS LineToken, CASE WHEN l.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.citemno AS nvarchar(max))), 2)) END AS ItemToken, CASE WHEN l.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN l.cmeasure IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cmeasure AS nvarchar(max))), 2)) END AS UnitToken, CASE WHEN l.lstock IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.lstock AS nvarchar(max))), 2)) END AS StockToken, CASE WHEN l.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode1 AS nvarchar(max))), 2)) END AS Spec1Token, CASE WHEN l.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode2 AS nvarchar(max))), 2)) END AS Spec2Token, CASE WHEN l.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.csono AS nvarchar(max))), 2)) END AS SalesOrderToken, CASE WHEN l.cshipno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cshipno AS nvarchar(max))), 2)) END AS ShipmentToken, CAST(i.citemno AS nvarchar(max)) AS citemno, CAST(i.cdescript AS nvarchar(max)) AS cdescript, CAST(i.cfdescript AS nvarchar(max)) AS cfdescript, CAST(i.cbarcode1 AS nvarchar(max)) AS cbarcode1, CAST(i.cbarcode2 AS nvarchar(max)) AS cbarcode2, CAST(i.cclass AS nvarchar(max)) AS cclass, CAST(i.cprodline AS nvarchar(max)) AS cprodline, CAST(i.cstatus AS nvarchar(max)) AS cstatus, CAST(i.cmeasure AS nvarchar(max)) AS cmeasure, CAST(i.csmeasure AS nvarchar(max)) AS csmeasure, CAST(i.cpmeasure AS nvarchar(max)) AS cpmeasure, CAST(i.nqtydec AS nvarchar(max)) AS nqtydec, CAST(i.cvendno AS nvarchar(max)) AS cvendno, CAST(i.cbuyer AS nvarchar(max)) AS cbuyer, CAST(i.lkititem AS nvarchar(max)) AS lkititem, CAST(i.llot AS nvarchar(max)) AS llot, CAST(i.nprice AS nvarchar(max)) AS nprice, CAST(i.nstdcost AS nvarchar(max)) AS nstdcost, CAST(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode, CASE WHEN i.citemno IS NULL THEN N'Missing or ambiguous current inventory item; recorded line retained' ELSE N'Unique current inventory code match; verify native stock flag, not invoice snapshot; current-price currency/unit basis UNVERIFIED' END AS ProductContext FROM Arinvc h INNER JOIN Aritrs l ON l.cinvno=h.cinvno AND CASE WHEN l.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.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 CASE WHEN l.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.ccustno AS nvarchar(max))), 2)) END=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 LEFT JOIN Icitem i ON i.citemno=l.citemno AND CASE WHEN i.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(i.citemno AS nvarchar(max))), 2)) END=CASE WHEN l.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.citemno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Icitem iq WHERE iq.citemno=i.citemno) WHERE h.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:invoice_uid, 2, 2147483647), 2)) 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) AND 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=:invoice_uid AND CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END=:invoice_number 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=:customer AND CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END=:invoice_date AND CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END=:due_date AND CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END=:voided AND CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END=:document_type AND CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END=:revision AND CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END=:foreign_balance AND CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END=:foreign_paid AND h.cinvno IS NOT NULL AND h.cinvno<>N'' AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arinvc hp WHERE hp.cinvno=h.cinvno AND CASE WHEN hp.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.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 CASE WHEN hp.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.ccustno AS nvarchar(max))), 2)) END=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) AND NOT EXISTS (SELECT 1 FROM Aritrs lx WHERE lx.cinvno=h.cinvno AND CASE WHEN lx.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.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 CASE WHEN lx.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.ccustno AS nvarchar(max))), 2)) END=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 AND (lx.cuid IS NULL OR lx.cuid=N'' OR DATALENGTH(CAST(lx.cuid AS nvarchar(max)))=0 OR 1<>(SELECT COUNT(*) FROM Aritrs lq WHERE lq.cuid=lx.cuid))) AND l.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:line_uid, 2, 2147483647), 2)) AND CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END=:line_uid AND CASE WHEN l.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.citemno AS nvarchar(max))), 2)) END=:item AND CASE WHEN l.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cwarehouse AS nvarchar(max))), 2)) END=:warehouse AND CASE WHEN l.cmeasure IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cmeasure AS nvarchar(max))), 2)) END=:unit AND CASE WHEN l.lstock IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.lstock AS nvarchar(max))), 2)) END=:stock AND CASE WHEN l.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode1 AS nvarchar(max))), 2)) END=:spec1 AND CASE WHEN l.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode2 AS nvarchar(max))), 2)) END=:spec2 AND CASE WHEN l.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.csono AS nvarchar(max))), 2)) END=:sales_order AND CASE WHEN l.cshipno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cshipno AS nvarchar(max))), 2)) END=:shipment AND i.citemno IS NOT NULL

static read-only checks passed

Statically verified read-only$.components.workspaceSelection.datasets.3.sqlQuery

SELECT 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 ParentKey, CONCAT(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,N':',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 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 InvoiceToken, CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AS InvoiceNumberToken, 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 AS CustomerToken, CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END AS InvoiceDateToken, CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END AS DueDateToken, CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END AS VoidedToken, CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END AS DocumentTypeToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END AS BalanceToken, CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END AS PaidToken, 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(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode, N'Unique current customer; contact/address/trading defaults may differ from recorded invoice; no current balance or payment history implied' AS CustomerContext FROM Arinvc h INNER JOIN Arcust u ON u.ccustno=h.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=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 AND 1=(SELECT COUNT(*) FROM Arcust uq WHERE uq.ccustno=u.ccustno) WHERE h.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:invoice_uid, 2, 2147483647), 2)) 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) AND 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=:invoice_uid AND CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END=:invoice_number 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=:customer AND CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END=:invoice_date AND CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END=:due_date AND CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END=:voided AND CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END=:document_type AND CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END=:revision AND CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END=:foreign_balance AND CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END=:foreign_paid

static read-only checks passed

View the JSON being importedcollapsed by default

{
    "components": {
        "sourceSlots": [
            {
                "displayName": "AccountMate SQL/Express — authorised company database",
                "id": "6EFD56A7-6C09-5F13-8A9C-C4622C6909ED",
                "kind": "sqlServer",
                "requiredObjects": [
                    "Arinvc",
                    "Aritrs",
                    "Arirmk",
                    "Aritrk",
                    "Icitem",
                    "Arcust"
                ],
                "requiresCustomSQL": true
            }
        ],
        "workspaceSelection": {
            "commonFields": [],
            "datasets": [
                {
                    "cacheMode": "live",
                    "calculatedFields": [],
                    "customQueryIntegrationName": "AccountMate SQL/Express",
                    "endpointPath": "",
                    "fetchSortRules": [
                        {
                            "direction": "descending",
                            "id": "0B569F81-C8C2-5168-AFDA-8A44F97F8A0A",
                            "key": "dinvoice",
                            "type": "date"
                        },
                        {
                            "direction": "ascending",
                            "id": "1FBAFB24-87C8-5993-9B00-F74D2B1076CD",
                            "key": "InvoiceKey",
                            "type": "text"
                        }
                    ],
                    "id": "4CD53B74-195B-5063-B9EF-38B4F56B17C3",
                    "mappings": [
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceKey",
                            "label": "Hidden full invoice identity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceKey",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceToken",
                            "label": "Hidden invoice context invoice_uid",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceNumberToken",
                            "label": "Hidden invoice context invoice_number",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceNumberToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CustomerToken",
                            "label": "Hidden invoice context customer",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CustomerToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CurrencyToken",
                            "label": "Hidden invoice context currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CurrencyToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceDateToken",
                            "label": "Hidden invoice context invoice_date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceDateToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "DueDateToken",
                            "label": "Hidden invoice context due_date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "DueDateToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "VoidedToken",
                            "label": "Hidden invoice context voided",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "VoidedToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "DocumentTypeToken",
                            "label": "Hidden invoice context document_type",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "DocumentTypeToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "RevisionToken",
                            "label": "Hidden invoice context revision",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "RevisionToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "BalanceToken",
                            "label": "Hidden invoice context foreign_balance",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "BalanceToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "PaidToken",
                            "label": "Hidden invoice context foreign_paid",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "PaidToken",
                            "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 party",
                            "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": "Invoice remark availability and preview scope",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceNoteContext",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "LineOwnershipContext",
                            "label": "Recorded line ownership — ambiguity check",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "LineOwnershipContext",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        }
                    ],
                    "maxRows": 2000,
                    "name": "Customer invoices",
                    "primaryKey": "InvoiceKey",
                    "queryParameters": [],
                    "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",
                        "LineOwnershipContext"
                    ],
                    "sourceID": "6EFD56A7-6C09-5F13-8A9C-C4622C6909ED",
                    "sqlQuery": "SELECT 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 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 InvoiceToken, CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AS InvoiceNumberToken, 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 AS CustomerToken, CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END AS InvoiceDateToken, CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END AS DueDateToken, CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END AS VoidedToken, CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END AS DocumentTypeToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END AS BalanceToken, CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END AS PaidToken, 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(onote.mremark AS nvarchar(max)), 4000) AS InvoiceRemark, CASE WHEN onote.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, inspect source for full text' END AS InvoiceNoteContext, CASE WHEN h.cinvno IS NOT NULL AND h.cinvno<>N'' AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arinvc hp WHERE hp.cinvno=h.cinvno AND CASE WHEN hp.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.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 CASE WHEN hp.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.ccustno AS nvarchar(max))), 2)) END=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) THEN N'Unique current invoice/customer pair; lines requested on demand' ELSE N'Ambiguous or blank invoice/customer pair: recorded lines are not displayed; administrator must verify ownership' END AS LineOwnershipContext FROM Arinvc h LEFT JOIN Arirmk onote ON onote.cuid=h.cuid AND CASE WHEN onote.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(onote.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 onote.cinvno=h.cinvno AND CASE WHEN onote.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(onote.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 nq WHERE nq.cuid=onote.cuid) WHERE 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": ""
                },
                {
                    "cacheMode": "live",
                    "calculatedFields": [],
                    "customQueryIntegrationName": "AccountMate SQL/Express",
                    "endpointPath": "",
                    "fetchSortRules": [
                        {
                            "direction": "ascending",
                            "id": "C12EB95E-12A2-5632-9D0A-DCDDB28B446A",
                            "key": "nseq",
                            "type": "number"
                        },
                        {
                            "direction": "ascending",
                            "id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
                            "key": "LineKey",
                            "type": "text"
                        }
                    ],
                    "id": "230F3864-9334-5170-8320-DCE220CCB9D0",
                    "mappings": [
                        {
                            "commonFieldKey": "",
                            "key": "LineKey",
                            "label": "Hidden parent-owned line identity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "LineKey",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ParentKey",
                            "label": "Hidden full parent identity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ParentKey",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceToken",
                            "label": "Hidden invoice context invoice_uid",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceNumberToken",
                            "label": "Hidden invoice context invoice_number",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceNumberToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CustomerToken",
                            "label": "Hidden invoice context customer",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CustomerToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CurrencyToken",
                            "label": "Hidden invoice context currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CurrencyToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceDateToken",
                            "label": "Hidden invoice context invoice_date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceDateToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "DueDateToken",
                            "label": "Hidden invoice context due_date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "DueDateToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "VoidedToken",
                            "label": "Hidden invoice context voided",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "VoidedToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "DocumentTypeToken",
                            "label": "Hidden invoice context document_type",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "DocumentTypeToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "RevisionToken",
                            "label": "Hidden invoice context revision",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "RevisionToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "BalanceToken",
                            "label": "Hidden invoice context foreign_balance",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "BalanceToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "PaidToken",
                            "label": "Hidden invoice context foreign_paid",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "PaidToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "LineToken",
                            "label": "Hidden line context line_uid",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "LineToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ItemToken",
                            "label": "Hidden line context item",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ItemToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "WarehouseToken",
                            "label": "Hidden line context warehouse",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "WarehouseToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "UnitToken",
                            "label": "Hidden line context unit",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "UnitToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "StockToken",
                            "label": "Hidden line context stock",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "StockToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "Spec1Token",
                            "label": "Hidden line context spec1",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "Spec1Token",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "Spec2Token",
                            "label": "Hidden line context spec2",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "Spec2Token",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "SalesOrderToken",
                            "label": "Hidden line context sales_order",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "SalesOrderToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ShipmentToken",
                            "label": "Hidden line context shipment",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ShipmentToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cinvno",
                            "label": "Recorded owning invoice number",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cinvno",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ccustno",
                            "label": "Recorded line customer code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ccustno",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cwarehouse",
                            "label": "Recorded line warehouse",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cwarehouse",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "csono",
                            "label": "Recorded SO reference",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "csono",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cshipno",
                            "label": "Recorded shipment reference",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cshipno",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "crmano",
                            "label": "Recorded line RMA reference",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "crmano",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "crtncode",
                            "label": "Recorded return code — native",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "crtncode",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "citemno",
                            "label": "Recorded item code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "citemno",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cspeccode1",
                            "label": "Recorded specification code 1",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cspeccode1",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cspeccode2",
                            "label": "Recorded specification code 2",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cspeccode2",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cdescript",
                            "label": "Recorded line description",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cdescript",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cmeasure",
                            "label": "Recorded transaction unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cmeasure",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cstatus",
                            "label": "Recorded line status code — native",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cstatus",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "crevncode",
                            "label": "Recorded revenue code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "crevncode",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cbin",
                            "label": "Recorded bin",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cbin",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ctaxcode",
                            "label": "Recorded line tax code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ctaxcode",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "camrtmethd",
                            "label": "Recorded amortisation method code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "camrtmethd",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "camrtrecur",
                            "label": "Recorded amortisation recurring-cycle code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "camrtrecur",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "damrtstart",
                            "label": "Recorded amortisation start date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "damrtstart",
                            "type": "date",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "damrtend",
                            "label": "Recorded amortisation end date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic",
                            "sourceColumn": "damrtend",
                            "type": "date",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "lkititem",
                            "label": "Kit-item native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "lkititem",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "lstock",
                            "label": "Stock-item native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "lstock",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "lmodikit",
                            "label": "Customised-kit native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "lmodikit",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "lmultibin",
                            "label": "Multiple-bin native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "lmultibin",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ltaxable1",
                            "label": "Taxable-1 native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ltaxable1",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ltaxable2",
                            "label": "Taxable-2 native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ltaxable2",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "lamortize",
                            "label": "Amortise native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "lamortize",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ldropship",
                            "label": "Drop-ship native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ldropship",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nqtydec",
                            "label": "Recorded quantity decimal places",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nqtydec",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ndiscrate",
                            "label": "Recorded line discount percent",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ndiscrate",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nfsalesamt",
                            "label": "Recorded foreign line subtotal",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nfsalesamt",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nfdiscamt",
                            "label": "Recorded foreign line discount",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nfdiscamt",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nftaxamt1",
                            "label": "Recorded foreign line tax 1",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nftaxamt1",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nftaxamt2",
                            "label": "Recorded foreign line tax 2",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nftaxamt2",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nftaxamt3",
                            "label": "Recorded foreign line tax 3",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nftaxamt3",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nordqty",
                            "label": "Recorded ordered quantity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nordqty",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nshipqty",
                            "label": "Recorded shipped quantity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nshipqty",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nitmcnvqty",
                            "label": "Recorded base-unit factor",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nitmcnvqty",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ntrscnvqty",
                            "label": "Recorded transaction-unit factor",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ntrscnvqty",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nfprice",
                            "label": "Recorded foreign unit price",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nfprice",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nfprcinctx",
                            "label": "Recorded foreign unit price plus tax",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nfprcinctx",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nseq",
                            "label": "Recorded line sequence",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "number",
                            "sourceColumn": "nseq",
                            "type": "number",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "namrtcycle",
                            "label": "Recorded amortisation cycles",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "namrtcycle",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ParentCurrencyCode",
                            "label": "Owning recorded invoice currency — not current-master price currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ParentCurrencyCode",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "LineRemark",
                            "label": "Recorded line remark — preview",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "LineRemark",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "LineNoteContext",
                            "label": "Line remark availability and preview scope",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "LineNoteContext",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ProductContext",
                            "label": "Current inventory context — not invoice snapshot",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ProductContext",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        }
                    ],
                    "maxRows": 500,
                    "name": "Recorded invoice lines",
                    "primaryKey": "LineKey",
                    "queryParameters": [
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "InvoiceToken",
                            "id": "FEAF9BA8-BDBC-559A-BEA4-C8F82C9B91EE",
                            "name": "invoice_uid",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "InvoiceNumberToken",
                            "id": "DF2F2716-A523-5ACB-8890-2A54CA98CC7A",
                            "name": "invoice_number",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "CustomerToken",
                            "id": "C320EF7E-19EF-51DC-8DB7-12E90C8277E1",
                            "name": "customer",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "CurrencyToken",
                            "id": "9BFB7ADC-4F16-5A05-B26C-3C4C05F77037",
                            "name": "currency",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "InvoiceDateToken",
                            "id": "96E6418F-2489-5228-A2FC-AEE59E61D781",
                            "name": "invoice_date",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "DueDateToken",
                            "id": "8DB40039-002F-59C3-8064-8A7C798D1005",
                            "name": "due_date",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "VoidedToken",
                            "id": "E2C2D686-E227-594D-9331-4D0839A50032",
                            "name": "voided",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "DocumentTypeToken",
                            "id": "3641DC69-CBEE-5563-8CBE-F5EB590508BA",
                            "name": "document_type",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "RevisionToken",
                            "id": "47E9EE54-C24D-5936-9C11-5DF7FA705A50",
                            "name": "revision",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "BalanceToken",
                            "id": "A5BEA5F0-D416-5DF8-B3ED-A2405F7B282B",
                            "name": "foreign_balance",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "PaidToken",
                            "id": "6B07998F-8EB6-5D98-8E52-43C77C9A0181",
                            "name": "foreign_paid",
                            "source": "parentField",
                            "type": "text"
                        }
                    ],
                    "refreshPolicy": {
                        "enabled": false,
                        "intervalMinutes": 60
                    },
                    "rootArrayPath": "",
                    "rowLimitEnabled": true,
                    "searchKeys": [
                        "cinvno",
                        "ccustno",
                        "cwarehouse",
                        "csono",
                        "cshipno",
                        "crmano",
                        "crtncode",
                        "citemno",
                        "cspeccode1",
                        "cspeccode2",
                        "cdescript",
                        "cmeasure",
                        "cstatus",
                        "crevncode",
                        "cbin",
                        "ctaxcode",
                        "camrtmethd",
                        "camrtrecur",
                        "lkititem",
                        "lstock",
                        "lmodikit",
                        "lmultibin",
                        "ltaxable1",
                        "ltaxable2",
                        "lamortize",
                        "ldropship",
                        "nqtydec",
                        "ndiscrate",
                        "nfsalesamt",
                        "nfdiscamt",
                        "nftaxamt1",
                        "nftaxamt2",
                        "nftaxamt3",
                        "nordqty",
                        "nshipqty",
                        "nitmcnvqty",
                        "ntrscnvqty",
                        "nfprice",
                        "nfprcinctx",
                        "nseq",
                        "namrtcycle",
                        "ParentCurrencyCode",
                        "LineRemark",
                        "LineNoteContext",
                        "ProductContext"
                    ],
                    "sourceID": "6EFD56A7-6C09-5F13-8A9C-C4622C6909ED",
                    "sqlQuery": "SELECT 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 ParentKey, CONCAT(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,N':',CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END) AS LineKey, 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 InvoiceToken, CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AS InvoiceNumberToken, 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 AS CustomerToken, CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END AS InvoiceDateToken, CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END AS DueDateToken, CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END AS VoidedToken, CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END AS DocumentTypeToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END AS BalanceToken, CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END AS PaidToken, CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END AS LineToken, CASE WHEN l.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.citemno AS nvarchar(max))), 2)) END AS ItemToken, CASE WHEN l.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN l.cmeasure IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cmeasure AS nvarchar(max))), 2)) END AS UnitToken, CASE WHEN l.lstock IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.lstock AS nvarchar(max))), 2)) END AS StockToken, CASE WHEN l.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode1 AS nvarchar(max))), 2)) END AS Spec1Token, CASE WHEN l.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode2 AS nvarchar(max))), 2)) END AS Spec2Token, CASE WHEN l.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.csono AS nvarchar(max))), 2)) END AS SalesOrderToken, CASE WHEN l.cshipno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cshipno AS nvarchar(max))), 2)) END AS ShipmentToken, CAST(l.cinvno AS nvarchar(max)) AS cinvno, CAST(l.ccustno AS nvarchar(max)) AS ccustno, CAST(l.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(l.csono AS nvarchar(max)) AS csono, CAST(l.cshipno AS nvarchar(max)) AS cshipno, CAST(l.crmano AS nvarchar(max)) AS crmano, CAST(l.crtncode AS nvarchar(max)) AS crtncode, CAST(l.citemno AS nvarchar(max)) AS citemno, CAST(l.cspeccode1 AS nvarchar(max)) AS cspeccode1, CAST(l.cspeccode2 AS nvarchar(max)) AS cspeccode2, CAST(l.cdescript AS nvarchar(max)) AS cdescript, CAST(l.cmeasure AS nvarchar(max)) AS cmeasure, CAST(l.cstatus AS nvarchar(max)) AS cstatus, CAST(l.crevncode AS nvarchar(max)) AS crevncode, CAST(l.cbin AS nvarchar(max)) AS cbin, CAST(l.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(l.camrtmethd AS nvarchar(max)) AS camrtmethd, CAST(l.camrtrecur AS nvarchar(max)) AS camrtrecur, CONVERT(varchar(10), l.damrtstart, 23) AS damrtstart, CONVERT(varchar(10), l.damrtend, 23) AS damrtend, CAST(l.lkititem AS nvarchar(max)) AS lkititem, CAST(l.lstock AS nvarchar(max)) AS lstock, CAST(l.lmodikit AS nvarchar(max)) AS lmodikit, CAST(l.lmultibin AS nvarchar(max)) AS lmultibin, CAST(l.ltaxable1 AS nvarchar(max)) AS ltaxable1, CAST(l.ltaxable2 AS nvarchar(max)) AS ltaxable2, CAST(l.lamortize AS nvarchar(max)) AS lamortize, CAST(l.ldropship AS nvarchar(max)) AS ldropship, CAST(l.nqtydec AS nvarchar(max)) AS nqtydec, CAST(l.ndiscrate AS nvarchar(max)) AS ndiscrate, CAST(l.nfsalesamt AS nvarchar(max)) AS nfsalesamt, CAST(l.nfdiscamt AS nvarchar(max)) AS nfdiscamt, CAST(l.nftaxamt1 AS nvarchar(max)) AS nftaxamt1, CAST(l.nftaxamt2 AS nvarchar(max)) AS nftaxamt2, CAST(l.nftaxamt3 AS nvarchar(max)) AS nftaxamt3, CAST(l.nordqty AS nvarchar(max)) AS nordqty, CAST(l.nshipqty AS nvarchar(max)) AS nshipqty, CAST(l.nitmcnvqty AS nvarchar(max)) AS nitmcnvqty, CAST(l.ntrscnvqty AS nvarchar(max)) AS ntrscnvqty, CAST(l.nfprice AS nvarchar(max)) AS nfprice, CAST(l.nfprcinctx AS nvarchar(max)) AS nfprcinctx, CAST(l.nseq AS nvarchar(max)) AS nseq, CAST(l.namrtcycle AS nvarchar(max)) AS namrtcycle, CAST(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode, LEFT(CAST(lnote.mremark AS nvarchar(max)), 4000) AS LineRemark, CASE WHEN lnote.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, inspect source for full text' END AS LineNoteContext, CASE WHEN i.citemno IS NULL THEN N'Missing or ambiguous current inventory item; recorded line retained' ELSE N'Unique current inventory code match; verify native stock flag, not invoice snapshot; current-price currency/unit basis UNVERIFIED' END AS ProductContext FROM Arinvc h INNER JOIN Aritrs l ON l.cinvno=h.cinvno AND CASE WHEN l.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.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 CASE WHEN l.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.ccustno AS nvarchar(max))), 2)) END=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 LEFT JOIN Aritrk lnote ON lnote.cuid=l.cuid AND CASE WHEN lnote.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lnote.cuid AS nvarchar(max))), 2)) END=CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END AND lnote.cinvno=l.cinvno AND CASE WHEN lnote.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lnote.cinvno AS nvarchar(max))), 2)) END=CASE WHEN l.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cinvno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Aritrk nq WHERE nq.cuid=lnote.cuid) LEFT JOIN Icitem i ON i.citemno=l.citemno AND CASE WHEN i.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(i.citemno AS nvarchar(max))), 2)) END=CASE WHEN l.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.citemno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Icitem iq WHERE iq.citemno=i.citemno) WHERE h.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:invoice_uid, 2, 2147483647), 2)) 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) AND 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=:invoice_uid AND CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END=:invoice_number 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=:customer AND CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END=:invoice_date AND CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END=:due_date AND CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END=:voided AND CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END=:document_type AND CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END=:revision AND CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END=:foreign_balance AND CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END=:foreign_paid AND h.cinvno IS NOT NULL AND h.cinvno<>N'' AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arinvc hp WHERE hp.cinvno=h.cinvno AND CASE WHEN hp.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.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 CASE WHEN hp.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.ccustno AS nvarchar(max))), 2)) END=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) AND NOT EXISTS (SELECT 1 FROM Aritrs lx WHERE lx.cinvno=h.cinvno AND CASE WHEN lx.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.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 CASE WHEN lx.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.ccustno AS nvarchar(max))), 2)) END=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 AND (lx.cuid IS NULL OR lx.cuid=N'' OR DATALENGTH(CAST(lx.cuid AS nvarchar(max)))=0 OR 1<>(SELECT COUNT(*) FROM Aritrs lq WHERE lq.cuid=lx.cuid)))",
                    "tableName": ""
                },
                {
                    "cacheMode": "live",
                    "calculatedFields": [],
                    "customQueryIntegrationName": "AccountMate SQL/Express",
                    "endpointPath": "",
                    "fetchSortRules": [
                        {
                            "direction": "ascending",
                            "id": "6EF0F799-5EE8-5364-A17C-15145F64AD8C",
                            "key": "cdescript",
                            "type": "text"
                        },
                        {
                            "direction": "ascending",
                            "id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
                            "key": "ProductKey",
                            "type": "text"
                        }
                    ],
                    "id": "969D4012-9925-5246-A395-C05E2B751735",
                    "mappings": [
                        {
                            "commonFieldKey": "",
                            "key": "ProductKey",
                            "label": "Hidden parent-owned item identity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ProductKey",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ParentKey",
                            "label": "Hidden full parent identity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ParentKey",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceToken",
                            "label": "Hidden invoice context invoice_uid",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceNumberToken",
                            "label": "Hidden invoice context invoice_number",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceNumberToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CustomerToken",
                            "label": "Hidden invoice context customer",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CustomerToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CurrencyToken",
                            "label": "Hidden invoice context currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CurrencyToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceDateToken",
                            "label": "Hidden invoice context invoice_date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceDateToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "DueDateToken",
                            "label": "Hidden invoice context due_date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "DueDateToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "VoidedToken",
                            "label": "Hidden invoice context voided",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "VoidedToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "DocumentTypeToken",
                            "label": "Hidden invoice context document_type",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "DocumentTypeToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "RevisionToken",
                            "label": "Hidden invoice context revision",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "RevisionToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "BalanceToken",
                            "label": "Hidden invoice context foreign_balance",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "BalanceToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "PaidToken",
                            "label": "Hidden invoice context foreign_paid",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "PaidToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "LineToken",
                            "label": "Hidden line context line_uid",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "LineToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ItemToken",
                            "label": "Hidden line context item",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ItemToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "WarehouseToken",
                            "label": "Hidden line context warehouse",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "WarehouseToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "UnitToken",
                            "label": "Hidden line context unit",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "UnitToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "StockToken",
                            "label": "Hidden line context stock",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "StockToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "Spec1Token",
                            "label": "Hidden line context spec1",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "Spec1Token",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "Spec2Token",
                            "label": "Hidden line context spec2",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "Spec2Token",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "SalesOrderToken",
                            "label": "Hidden line context sales_order",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "SalesOrderToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ShipmentToken",
                            "label": "Hidden line context shipment",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ShipmentToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "citemno",
                            "label": "Item code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "citemno",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cdescript",
                            "label": "Description",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cdescript",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cfdescript",
                            "label": "Foreign description",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cfdescript",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cbarcode1",
                            "label": "Barcode 1",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cbarcode1",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cbarcode2",
                            "label": "Barcode 2",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cbarcode2",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cclass",
                            "label": "Item class code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cclass",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cprodline",
                            "label": "Product line code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cprodline",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cstatus",
                            "label": "Status code (native)",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cstatus",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cmeasure",
                            "label": "Stock unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cmeasure",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "csmeasure",
                            "label": "Sales unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "csmeasure",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cpmeasure",
                            "label": "Purchase unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cpmeasure",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": true
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nqtydec",
                            "label": "Quantity decimal places",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nqtydec",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cvendno",
                            "label": "Inventory vendor code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cvendno",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "cbuyer",
                            "label": "Buyer code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "cbuyer",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "lkititem",
                            "label": "Kit item (native flag)",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "lkititem",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "llot",
                            "label": "Lot controlled (native flag)",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "llot",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nprice",
                            "label": "Unit price (source value)",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nprice",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "nstdcost",
                            "label": "Standard cost (source value)",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "nstdcost",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ParentCurrencyCode",
                            "label": "Owning recorded invoice currency — not current-master price currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ParentCurrencyCode",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ProductContext",
                            "label": "Current inventory context — not invoice snapshot",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ProductContext",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        }
                    ],
                    "maxRows": 500,
                    "name": "Current inventory item",
                    "primaryKey": "ProductKey",
                    "queryParameters": [
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "InvoiceToken",
                            "id": "FEAF9BA8-BDBC-559A-BEA4-C8F82C9B91EE",
                            "name": "invoice_uid",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "InvoiceNumberToken",
                            "id": "DF2F2716-A523-5ACB-8890-2A54CA98CC7A",
                            "name": "invoice_number",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "CustomerToken",
                            "id": "C320EF7E-19EF-51DC-8DB7-12E90C8277E1",
                            "name": "customer",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "CurrencyToken",
                            "id": "9BFB7ADC-4F16-5A05-B26C-3C4C05F77037",
                            "name": "currency",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "InvoiceDateToken",
                            "id": "96E6418F-2489-5228-A2FC-AEE59E61D781",
                            "name": "invoice_date",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "DueDateToken",
                            "id": "8DB40039-002F-59C3-8064-8A7C798D1005",
                            "name": "due_date",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "VoidedToken",
                            "id": "E2C2D686-E227-594D-9331-4D0839A50032",
                            "name": "voided",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "DocumentTypeToken",
                            "id": "3641DC69-CBEE-5563-8CBE-F5EB590508BA",
                            "name": "document_type",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "RevisionToken",
                            "id": "47E9EE54-C24D-5936-9C11-5DF7FA705A50",
                            "name": "revision",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "BalanceToken",
                            "id": "A5BEA5F0-D416-5DF8-B3ED-A2405F7B282B",
                            "name": "foreign_balance",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "PaidToken",
                            "id": "6B07998F-8EB6-5D98-8E52-43C77C9A0181",
                            "name": "foreign_paid",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "LineToken",
                            "id": "D9F94C85-5934-5C69-BBB8-E76EDADE706E",
                            "name": "line_uid",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "ItemToken",
                            "id": "EB8A7D88-9448-53D1-8DCF-4FFDA414059F",
                            "name": "item",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "WarehouseToken",
                            "id": "FB69C8AD-CE53-593D-8615-DE10F771E5D4",
                            "name": "warehouse",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "UnitToken",
                            "id": "795FCD4B-5754-574C-A908-4E3C3437DEAF",
                            "name": "unit",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "StockToken",
                            "id": "3EBFB042-96C1-596C-93B6-F28A4BCA543B",
                            "name": "stock",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "Spec1Token",
                            "id": "80B9E411-1FD9-55C9-8816-FD9E45D16F64",
                            "name": "spec1",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "Spec2Token",
                            "id": "BE2DDFD9-B257-54E8-A011-A8134B8D30B2",
                            "name": "spec2",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "SalesOrderToken",
                            "id": "4EFEA18A-F0B7-5A7C-81F2-F9D29816C5B4",
                            "name": "sales_order",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "ShipmentToken",
                            "id": "E82E5A40-1029-5D95-B111-42B629042B76",
                            "name": "shipment",
                            "source": "parentField",
                            "type": "text"
                        }
                    ],
                    "refreshPolicy": {
                        "enabled": false,
                        "intervalMinutes": 60
                    },
                    "rootArrayPath": "",
                    "rowLimitEnabled": true,
                    "searchKeys": [
                        "citemno",
                        "cdescript",
                        "cfdescript",
                        "cbarcode1",
                        "cbarcode2",
                        "cclass",
                        "cprodline",
                        "cstatus",
                        "cmeasure",
                        "csmeasure",
                        "cpmeasure",
                        "nqtydec",
                        "cvendno",
                        "cbuyer",
                        "lkititem",
                        "llot",
                        "nprice",
                        "nstdcost",
                        "ParentCurrencyCode",
                        "ProductContext"
                    ],
                    "sourceID": "6EFD56A7-6C09-5F13-8A9C-C4622C6909ED",
                    "sqlQuery": "SELECT CONCAT(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,N':',CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END) AS ParentKey, CONCAT(CONCAT(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,N':',CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END),N':',CASE WHEN i.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(i.citemno AS nvarchar(max))), 2)) END) AS ProductKey, 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 InvoiceToken, CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AS InvoiceNumberToken, 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 AS CustomerToken, CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END AS InvoiceDateToken, CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END AS DueDateToken, CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END AS VoidedToken, CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END AS DocumentTypeToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END AS BalanceToken, CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END AS PaidToken, CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END AS LineToken, CASE WHEN l.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.citemno AS nvarchar(max))), 2)) END AS ItemToken, CASE WHEN l.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN l.cmeasure IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cmeasure AS nvarchar(max))), 2)) END AS UnitToken, CASE WHEN l.lstock IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.lstock AS nvarchar(max))), 2)) END AS StockToken, CASE WHEN l.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode1 AS nvarchar(max))), 2)) END AS Spec1Token, CASE WHEN l.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode2 AS nvarchar(max))), 2)) END AS Spec2Token, CASE WHEN l.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.csono AS nvarchar(max))), 2)) END AS SalesOrderToken, CASE WHEN l.cshipno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cshipno AS nvarchar(max))), 2)) END AS ShipmentToken, CAST(i.citemno AS nvarchar(max)) AS citemno, CAST(i.cdescript AS nvarchar(max)) AS cdescript, CAST(i.cfdescript AS nvarchar(max)) AS cfdescript, CAST(i.cbarcode1 AS nvarchar(max)) AS cbarcode1, CAST(i.cbarcode2 AS nvarchar(max)) AS cbarcode2, CAST(i.cclass AS nvarchar(max)) AS cclass, CAST(i.cprodline AS nvarchar(max)) AS cprodline, CAST(i.cstatus AS nvarchar(max)) AS cstatus, CAST(i.cmeasure AS nvarchar(max)) AS cmeasure, CAST(i.csmeasure AS nvarchar(max)) AS csmeasure, CAST(i.cpmeasure AS nvarchar(max)) AS cpmeasure, CAST(i.nqtydec AS nvarchar(max)) AS nqtydec, CAST(i.cvendno AS nvarchar(max)) AS cvendno, CAST(i.cbuyer AS nvarchar(max)) AS cbuyer, CAST(i.lkititem AS nvarchar(max)) AS lkititem, CAST(i.llot AS nvarchar(max)) AS llot, CAST(i.nprice AS nvarchar(max)) AS nprice, CAST(i.nstdcost AS nvarchar(max)) AS nstdcost, CAST(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode, CASE WHEN i.citemno IS NULL THEN N'Missing or ambiguous current inventory item; recorded line retained' ELSE N'Unique current inventory code match; verify native stock flag, not invoice snapshot; current-price currency/unit basis UNVERIFIED' END AS ProductContext FROM Arinvc h INNER JOIN Aritrs l ON l.cinvno=h.cinvno AND CASE WHEN l.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.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 CASE WHEN l.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.ccustno AS nvarchar(max))), 2)) END=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 LEFT JOIN Icitem i ON i.citemno=l.citemno AND CASE WHEN i.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(i.citemno AS nvarchar(max))), 2)) END=CASE WHEN l.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.citemno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Icitem iq WHERE iq.citemno=i.citemno) WHERE h.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:invoice_uid, 2, 2147483647), 2)) 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) AND 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=:invoice_uid AND CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END=:invoice_number 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=:customer AND CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END=:invoice_date AND CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END=:due_date AND CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END=:voided AND CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END=:document_type AND CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END=:revision AND CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END=:foreign_balance AND CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END=:foreign_paid AND h.cinvno IS NOT NULL AND h.cinvno<>N'' AND DATALENGTH(CAST(h.cinvno AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Arinvc hp WHERE hp.cinvno=h.cinvno AND CASE WHEN hp.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.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 CASE WHEN hp.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(hp.ccustno AS nvarchar(max))), 2)) END=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) AND NOT EXISTS (SELECT 1 FROM Aritrs lx WHERE lx.cinvno=h.cinvno AND CASE WHEN lx.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.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 CASE WHEN lx.ccustno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.ccustno AS nvarchar(max))), 2)) END=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 AND (lx.cuid IS NULL OR lx.cuid=N'' OR DATALENGTH(CAST(lx.cuid AS nvarchar(max)))=0 OR 1<>(SELECT COUNT(*) FROM Aritrs lq WHERE lq.cuid=lx.cuid))) AND l.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:line_uid, 2, 2147483647), 2)) AND CASE WHEN l.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cuid AS nvarchar(max))), 2)) END=:line_uid AND CASE WHEN l.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.citemno AS nvarchar(max))), 2)) END=:item AND CASE WHEN l.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cwarehouse AS nvarchar(max))), 2)) END=:warehouse AND CASE WHEN l.cmeasure IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cmeasure AS nvarchar(max))), 2)) END=:unit AND CASE WHEN l.lstock IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.lstock AS nvarchar(max))), 2)) END=:stock AND CASE WHEN l.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode1 AS nvarchar(max))), 2)) END=:spec1 AND CASE WHEN l.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cspeccode2 AS nvarchar(max))), 2)) END=:spec2 AND CASE WHEN l.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.csono AS nvarchar(max))), 2)) END=:sales_order AND CASE WHEN l.cshipno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cshipno AS nvarchar(max))), 2)) END=:shipment AND i.citemno IS NOT NULL",
                    "tableName": ""
                },
                {
                    "cacheMode": "live",
                    "calculatedFields": [],
                    "customQueryIntegrationName": "AccountMate SQL/Express",
                    "endpointPath": "",
                    "fetchSortRules": [
                        {
                            "direction": "ascending",
                            "id": "A6D42344-8C77-5253-8134-D1D2A94ED2A7",
                            "key": "ccompany",
                            "type": "text"
                        },
                        {
                            "direction": "ascending",
                            "id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
                            "key": "CustomerKey",
                            "type": "text"
                        }
                    ],
                    "id": "1BFD1F5D-70CF-5BA4-B430-8839B9F11002",
                    "mappings": [
                        {
                            "commonFieldKey": "",
                            "key": "CustomerKey",
                            "label": "Hidden invoice-owned current customer identity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CustomerKey",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "ParentKey",
                            "label": "Hidden full parent identity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ParentKey",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceToken",
                            "label": "Hidden invoice context invoice_uid",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceNumberToken",
                            "label": "Hidden invoice context invoice_number",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceNumberToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CustomerToken",
                            "label": "Hidden invoice context customer",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CustomerToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CurrencyToken",
                            "label": "Hidden invoice context currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CurrencyToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "InvoiceDateToken",
                            "label": "Hidden invoice context invoice_date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "InvoiceDateToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "DueDateToken",
                            "label": "Hidden invoice context due_date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "DueDateToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "VoidedToken",
                            "label": "Hidden invoice context voided",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "VoidedToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "DocumentTypeToken",
                            "label": "Hidden invoice context document_type",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "DocumentTypeToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "RevisionToken",
                            "label": "Hidden invoice context revision",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "RevisionToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "BalanceToken",
                            "label": "Hidden invoice context foreign_balance",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "BalanceToken",
                            "type": "text",
                            "visibleInDetail": false,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "PaidToken",
                            "label": "Hidden invoice context foreign_paid",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "PaidToken",
                            "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": "ParentCurrencyCode",
                            "label": "Owning recorded invoice currency — not current-master price currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "ParentCurrencyCode",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        },
                        {
                            "commonFieldKey": "",
                            "key": "CustomerContext",
                            "label": "Current customer context — not invoice snapshot",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text",
                            "sourceColumn": "CustomerContext",
                            "type": "text",
                            "visibleInDetail": true,
                            "visibleInList": false
                        }
                    ],
                    "maxRows": 500,
                    "name": "Current customer",
                    "primaryKey": "CustomerKey",
                    "queryParameters": [
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "InvoiceToken",
                            "id": "FEAF9BA8-BDBC-559A-BEA4-C8F82C9B91EE",
                            "name": "invoice_uid",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "InvoiceNumberToken",
                            "id": "DF2F2716-A523-5ACB-8890-2A54CA98CC7A",
                            "name": "invoice_number",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "CustomerToken",
                            "id": "C320EF7E-19EF-51DC-8DB7-12E90C8277E1",
                            "name": "customer",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "CurrencyToken",
                            "id": "9BFB7ADC-4F16-5A05-B26C-3C4C05F77037",
                            "name": "currency",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "InvoiceDateToken",
                            "id": "96E6418F-2489-5228-A2FC-AEE59E61D781",
                            "name": "invoice_date",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "DueDateToken",
                            "id": "8DB40039-002F-59C3-8064-8A7C798D1005",
                            "name": "due_date",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "VoidedToken",
                            "id": "E2C2D686-E227-594D-9331-4D0839A50032",
                            "name": "voided",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "DocumentTypeToken",
                            "id": "3641DC69-CBEE-5563-8CBE-F5EB590508BA",
                            "name": "document_type",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "RevisionToken",
                            "id": "47E9EE54-C24D-5936-9C11-5DF7FA705A50",
                            "name": "revision",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "BalanceToken",
                            "id": "A5BEA5F0-D416-5DF8-B3ED-A2405F7B282B",
                            "name": "foreign_balance",
                            "source": "parentField",
                            "type": "text"
                        },
                        {
                            "constantValue": "",
                            "dayOffset": 0,
                            "fieldKey": "PaidToken",
                            "id": "6B07998F-8EB6-5D98-8E52-43C77C9A0181",
                            "name": "foreign_paid",
                            "source": "parentField",
                            "type": "text"
                        }
                    ],
                    "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",
                        "ParentCurrencyCode",
                        "CustomerContext"
                    ],
                    "sourceID": "6EFD56A7-6C09-5F13-8A9C-C4622C6909ED",
                    "sqlQuery": "SELECT 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 ParentKey, CONCAT(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,N':',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 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 InvoiceToken, CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END AS InvoiceNumberToken, 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 AS CustomerToken, CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END AS CurrencyToken, CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END AS InvoiceDateToken, CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END AS DueDateToken, CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END AS VoidedToken, CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END AS DocumentTypeToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END AS BalanceToken, CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END AS PaidToken, 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(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode, N'Unique current customer; contact/address/trading defaults may differ from recorded invoice; no current balance or payment history implied' AS CustomerContext FROM Arinvc h INNER JOIN Arcust u ON u.ccustno=h.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=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 AND 1=(SELECT COUNT(*) FROM Arcust uq WHERE uq.ccustno=u.ccustno) WHERE h.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:invoice_uid, 2, 2147483647), 2)) 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) AND 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=:invoice_uid AND CASE WHEN h.cinvno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cinvno AS nvarchar(max))), 2)) END=:invoice_number 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=:customer AND CASE WHEN h.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ccurrcode AS nvarchar(max))), 2)) END=:currency AND CASE WHEN h.dinvoice IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dinvoice, 126) AS nvarchar(max))), 2)) END=:invoice_date AND CASE WHEN h.ddue IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.ddue, 126) AS nvarchar(max))), 2)) END=:due_date AND CASE WHEN h.lvoid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lvoid AS nvarchar(max))), 2)) END=:voided AND CASE WHEN h.ctype IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ctype AS nvarchar(max))), 2)) END=:document_type AND CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END=:revision AND CASE WHEN h.nfbalance IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nfbalance AS nvarchar(max))), 2)) END=:foreign_balance AND CASE WHEN h.nftotpaid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.nftotpaid AS nvarchar(max))), 2)) END=:foreign_paid",
                    "tableName": ""
                }
            ],
            "pages": [
                {
                    "actions": [
                        {
                            "id": "8C11AC3D-BD8C-53C6-B5AB-B2C0F094619A",
                            "kind": "showRelated",
                            "relatedInitiallyExpanded": false,
                            "relatedPresentation": "separate",
                            "relatedPreviewLimit": 12,
                            "relatedRowStyle": "cards",
                            "relatedShowsCount": true,
                            "relationID": "146D4997-44B8-5CF7-A988-B0456D709C53",
                            "systemImage": "list.bullet.rectangle",
                            "targetDatasetID": "230F3864-9334-5170-8320-DCE220CCB9D0",
                            "title": "Recorded invoice lines",
                            "urlKey": ""
                        },
                        {
                            "id": "683819DB-486A-5E2F-8A58-00DDA196408F",
                            "kind": "showRelated",
                            "relatedInitiallyExpanded": false,
                            "relatedPresentation": "separate",
                            "relatedPreviewLimit": 12,
                            "relatedRowStyle": "cards",
                            "relatedShowsCount": true,
                            "relationID": "9A8E2401-68A3-589D-B546-DAEB297C2F47",
                            "systemImage": "list.bullet.rectangle",
                            "targetDatasetID": "1BFD1F5D-70CF-5BA4-B430-8839B9F11002",
                            "title": "Current customer",
                            "urlKey": ""
                        }
                    ],
                    "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": "4CD53B74-195B-5063-B9EF-38B4F56B17C3",
                    "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 line ownership",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "InvoiceRemark",
                            "label": "Recorded invoice remark — preview",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded note and line ownership",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "InvoiceNoteContext",
                            "label": "Invoice remark availability and preview scope",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded note and line ownership",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "LineOwnershipContext",
                            "label": "Recorded line ownership — ambiguity check",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        }
                    ],
                    "detailLiveRefreshSeconds": 0,
                    "fixedFilters": [],
                    "id": "C45A5EE9-5DEF-50F7-A28D-F80D24705EA7",
                    "openFilters": [
                        {
                            "datePeriodOptions": [
                                "today",
                                "currentMonth",
                                "last7Days",
                                "last30Days",
                                "last90Days"
                            ],
                            "id": "3CBB1844-D87B-5C17-B903-7B5775873F11",
                            "includeAllOption": false,
                            "key": "dinvoice",
                            "title": "Choose recorded invoice-date period",
                            "type": "date"
                        }
                    ],
                    "pageSize": 100,
                    "requiresOpeningFilterSelection": true,
                    "showOnHome": true,
                    "sortRules": [
                        {
                            "direction": "descending",
                            "id": "0B569F81-C8C2-5168-AFDA-8A44F97F8A0A",
                            "key": "dinvoice",
                            "type": "date"
                        },
                        {
                            "direction": "ascending",
                            "id": "1FBAFB24-87C8-5993-9B00-F74D2B1076CD",
                            "key": "InvoiceKey",
                            "type": "text"
                        }
                    ],
                    "subtitle": "",
                    "subtitleKey": "InvoicePartyLabel",
                    "systemImage": "doc.text",
                    "title": "Customer invoices",
                    "titleKey": "cinvno"
                },
                {
                    "actions": [
                        {
                            "id": "9745B9F0-55D4-5A7E-8C0E-37D0F3235C76",
                            "kind": "showRelated",
                            "relatedInitiallyExpanded": false,
                            "relatedPresentation": "separate",
                            "relatedPreviewLimit": 12,
                            "relatedRowStyle": "cards",
                            "relatedShowsCount": true,
                            "relationID": "7D4E790C-5F47-5FE4-8DF8-9A98D66E517E",
                            "systemImage": "list.bullet.rectangle",
                            "targetDatasetID": "969D4012-9925-5246-A395-C05E2B751735",
                            "title": "Current inventory item",
                            "urlKey": ""
                        }
                    ],
                    "badgeKey": "ParentCurrencyCode",
                    "cardEnrichments": [],
                    "cardFieldLayout": [
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cwarehouse",
                            "label": "Recorded line warehouse",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "csono",
                            "label": "Recorded SO reference",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cmeasure",
                            "label": "Recorded transaction unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nordqty",
                            "label": "Recorded ordered quantity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nshipqty",
                            "label": "Recorded shipped quantity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nfprice",
                            "label": "Recorded foreign unit price",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        }
                    ],
                    "datasetID": "230F3864-9334-5170-8320-DCE220CCB9D0",
                    "dateFilterKey": "",
                    "dateFilterLastDays": 7,
                    "dateFilterPreset": "none",
                    "detailFieldLayout": [
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cinvno",
                            "label": "Recorded owning invoice number",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ccustno",
                            "label": "Recorded line customer code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "citemno",
                            "label": "Recorded item code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cdescript",
                            "label": "Recorded line description",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nseq",
                            "label": "Recorded line sequence",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "number"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cwarehouse",
                            "label": "Recorded line warehouse",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cbin",
                            "label": "Recorded bin",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cspeccode1",
                            "label": "Recorded specification code 1",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cspeccode2",
                            "label": "Recorded specification code 2",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "csono",
                            "label": "Recorded SO reference",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cshipno",
                            "label": "Recorded shipment reference",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "crmano",
                            "label": "Recorded line RMA reference",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "crtncode",
                            "label": "Recorded return code — native",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line — not current product snapshot",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cstatus",
                            "label": "Recorded line status code — native",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded quantities and unit factors — no remaining formula",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cmeasure",
                            "label": "Recorded transaction unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded quantities and unit factors — no remaining formula",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nordqty",
                            "label": "Recorded ordered quantity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded quantities and unit factors — no remaining formula",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nshipqty",
                            "label": "Recorded shipped quantity",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded quantities and unit factors — no remaining formula",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nitmcnvqty",
                            "label": "Recorded base-unit factor",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded quantities and unit factors — no remaining formula",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ntrscnvqty",
                            "label": "Recorded transaction-unit factor",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded quantities and unit factors — no remaining formula",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nqtydec",
                            "label": "Recorded quantity decimal places",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded foreign line prices and amounts",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ParentCurrencyCode",
                            "label": "Owning recorded invoice currency — not current-master price currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded foreign line prices and amounts",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nfprice",
                            "label": "Recorded foreign unit price",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded foreign line prices and amounts",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nfprcinctx",
                            "label": "Recorded foreign unit price plus tax",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded foreign line prices and amounts",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nfsalesamt",
                            "label": "Recorded foreign line subtotal",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded foreign line prices and amounts",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nfdiscamt",
                            "label": "Recorded foreign line discount",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded foreign line prices and amounts",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nftaxamt1",
                            "label": "Recorded foreign line tax 1",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded foreign line prices and amounts",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nftaxamt2",
                            "label": "Recorded foreign line tax 2",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded foreign line prices and amounts",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nftaxamt3",
                            "label": "Recorded foreign line tax 3",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded foreign line prices and amounts",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ndiscrate",
                            "label": "Recorded line discount percent",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded revenue, tax and item codes",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "crevncode",
                            "label": "Recorded revenue code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded revenue, tax and item codes",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ctaxcode",
                            "label": "Recorded line tax code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded revenue, tax and item codes",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "lstock",
                            "label": "Stock-item native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded revenue, tax and item codes",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "lkititem",
                            "label": "Kit-item native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded revenue, tax and item codes",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "lmodikit",
                            "label": "Customised-kit native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded revenue, tax and item codes",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "lmultibin",
                            "label": "Multiple-bin native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded revenue, tax and item codes",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ltaxable1",
                            "label": "Taxable-1 native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded revenue, tax and item codes",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ltaxable2",
                            "label": "Taxable-2 native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded revenue, tax and item codes",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ldropship",
                            "label": "Drop-ship native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded amortisation metadata — not a schedule",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "lamortize",
                            "label": "Amortise native flag",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded amortisation metadata — not a schedule",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "camrtmethd",
                            "label": "Recorded amortisation method code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded amortisation metadata — not a schedule",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "camrtrecur",
                            "label": "Recorded amortisation recurring-cycle code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded amortisation metadata — not a schedule",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "damrtstart",
                            "label": "Recorded amortisation start date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "Recorded amortisation metadata — not a schedule",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "damrtend",
                            "label": "Recorded amortisation end date",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "automatic"
                        },
                        {
                            "detailGroup": "Recorded amortisation metadata — not a schedule",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "namrtcycle",
                            "label": "Recorded amortisation cycles",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line note and current item availability",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "LineRemark",
                            "label": "Recorded line remark — preview",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line note and current item availability",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "LineNoteContext",
                            "label": "Line remark availability and preview scope",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Recorded line note and current item availability",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ProductContext",
                            "label": "Current inventory context — not invoice snapshot",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        }
                    ],
                    "detailLiveRefreshSeconds": 0,
                    "fixedFilters": [],
                    "id": "B9CCAC31-C2FD-5B07-809A-1EA0E7C79287",
                    "openFilters": [],
                    "pageSize": 100,
                    "requiresOpeningFilterSelection": false,
                    "showOnHome": false,
                    "sortRules": [
                        {
                            "direction": "ascending",
                            "id": "C12EB95E-12A2-5632-9D0A-DCDDB28B446A",
                            "key": "nseq",
                            "type": "number"
                        },
                        {
                            "direction": "ascending",
                            "id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
                            "key": "LineKey",
                            "type": "text"
                        }
                    ],
                    "subtitle": "",
                    "subtitleKey": "citemno",
                    "systemImage": "doc.text",
                    "title": "Recorded invoice lines",
                    "titleKey": "cdescript"
                },
                {
                    "actions": [],
                    "badgeKey": "cstatus",
                    "cardEnrichments": [],
                    "cardFieldLayout": [
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cbarcode1",
                            "label": "Barcode 1",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cbarcode2",
                            "label": "Barcode 2",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cclass",
                            "label": "Item class code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cmeasure",
                            "label": "Stock unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "csmeasure",
                            "label": "Sales unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cpmeasure",
                            "label": "Purchase unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        }
                    ],
                    "datasetID": "969D4012-9925-5246-A395-C05E2B751735",
                    "dateFilterKey": "",
                    "dateFilterLastDays": 7,
                    "dateFilterPreset": "none",
                    "detailFieldLayout": [
                        {
                            "detailGroup": "Current catalogue — not historical invoice values",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "citemno",
                            "label": "Item code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current catalogue — not historical invoice values",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cdescript",
                            "label": "Description",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current catalogue — not historical invoice values",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cfdescript",
                            "label": "Foreign description",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current catalogue — not historical invoice values",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cbarcode1",
                            "label": "Barcode 1",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current catalogue — not historical invoice values",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cbarcode2",
                            "label": "Barcode 2",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current catalogue — not historical invoice values",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cclass",
                            "label": "Item class code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current catalogue — not historical invoice values",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cprodline",
                            "label": "Product line code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current catalogue — not historical invoice values",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cstatus",
                            "label": "Status code (native)",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current catalogue — not historical invoice values",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ProductContext",
                            "label": "Current inventory context — not invoice snapshot",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current catalogue — not historical invoice values",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ParentCurrencyCode",
                            "label": "Owning recorded invoice currency — not current-master price currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current distinct stock, sales and purchase units",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cmeasure",
                            "label": "Stock unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current distinct stock, sales and purchase units",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "csmeasure",
                            "label": "Sales unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current distinct stock, sales and purchase units",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cpmeasure",
                            "label": "Purchase unit code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current distinct stock, sales and purchase units",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nqtydec",
                            "label": "Quantity decimal places",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current purchasing and item flags",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cvendno",
                            "label": "Inventory vendor code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current purchasing and item flags",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "cbuyer",
                            "label": "Buyer code",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current purchasing and item flags",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "lkititem",
                            "label": "Kit item (native flag)",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current purchasing and item flags",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "llot",
                            "label": "Lot controlled (native flag)",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current prices — currency and unit basis UNVERIFIED",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nprice",
                            "label": "Unit price (source value)",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Current prices — currency and unit basis UNVERIFIED",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "nstdcost",
                            "label": "Standard cost (source value)",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        }
                    ],
                    "detailLiveRefreshSeconds": 0,
                    "fixedFilters": [],
                    "id": "159C0864-5693-57DC-8B4E-3C6809C06B5C",
                    "openFilters": [],
                    "pageSize": 100,
                    "requiresOpeningFilterSelection": false,
                    "showOnHome": false,
                    "sortRules": [
                        {
                            "direction": "ascending",
                            "id": "6EF0F799-5EE8-5364-A17C-15145F64AD8C",
                            "key": "cdescript",
                            "type": "text"
                        },
                        {
                            "direction": "ascending",
                            "id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
                            "key": "ProductKey",
                            "type": "text"
                        }
                    ],
                    "subtitle": "",
                    "subtitleKey": "citemno",
                    "systemImage": "doc.text",
                    "title": "Current inventory item",
                    "titleKey": "cdescript"
                },
                {
                    "actions": [],
                    "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": "1BFD1F5D-70CF-5BA4-B430-8839B9F11002",
                    "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 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": "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": "Invoice versus current customer context",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "ParentCurrencyCode",
                            "label": "Owning recorded invoice currency — not current-master price currency",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        },
                        {
                            "detailGroup": "Invoice versus current customer context",
                            "detailRole": "information",
                            "isVisible": true,
                            "key": "CustomerContext",
                            "label": "Current customer context — not invoice snapshot",
                            "locationLabelKey": "",
                            "locationLongitudeKey": "",
                            "presentation": "text"
                        }
                    ],
                    "detailLiveRefreshSeconds": 0,
                    "fixedFilters": [],
                    "id": "F6B8C005-188C-506A-8198-846514C30ADA",
                    "openFilters": [],
                    "pageSize": 100,
                    "requiresOpeningFilterSelection": false,
                    "showOnHome": false,
                    "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": "Current customer",
                    "titleKey": "ccompany"
                }
            ],
            "relations": [
                {
                    "childDatasetID": "230F3864-9334-5170-8320-DCE220CCB9D0",
                    "childKey": "ParentKey",
                    "id": "146D4997-44B8-5CF7-A988-B0456D709C53",
                    "name": "Recorded invoice lines",
                    "parentDatasetID": "4CD53B74-195B-5063-B9EF-38B4F56B17C3",
                    "parentKey": "InvoiceKey"
                },
                {
                    "childDatasetID": "969D4012-9925-5246-A395-C05E2B751735",
                    "childKey": "ParentKey",
                    "id": "7D4E790C-5F47-5FE4-8DF8-9A98D66E517E",
                    "name": "Current inventory item",
                    "parentDatasetID": "230F3864-9334-5170-8320-DCE220CCB9D0",
                    "parentKey": "LineKey"
                },
                {
                    "childDatasetID": "1BFD1F5D-70CF-5BA4-B430-8839B9F11002",
                    "childKey": "ParentKey",
                    "id": "9A8E2401-68A3-589D-B546-DAEB297C2F47",
                    "name": "Current customer",
                    "parentDatasetID": "4CD53B74-195B-5063-B9EF-38B4F56B17C3",
                    "parentKey": "InvoiceKey"
                }
            ],
            "widgets": []
        }
    },
    "format": "cifru-configuration-package",
    "formatVersion": 1,
    "manifest": {
        "applicationName": "AccountMate for SQL/Express",
        "changelog": "Initial Pro customer invoices with recorded bill-to/ship-to details, due dates, separate source amounts and balance, guarded recorded lines, optional current item and current customer. Required invoice-date period; 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, accounting, customer service and managers: choose the recorded invoice-date period, inspect recorded bill-to/ship-to details, due dates, source foreign amounts and balance, then open recorded invoice lines and an optional current inventory item. A separate action opens the current customer contact, address, classification and trading references.\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 SQL Server company source, four live lists, full same-row Details and three lazy actions: invoice to recorded lines, line to current inventory item, invoice to current customer. 79 invoice, 47 line, 20 item and 37 current-customer useful Detail positions; identity tokens hidden. Mandatory native invoice-date period before the final 2,000-root cap; child caps 500. Search/local filters affect loaded rows. No widgets, automatic refresh, computed financial totals or writes. Existing workspace resources count; caps are not performance guarantees.\n\nSCOPE: current Arinvc/Aritrs only. No automatic history, recurring-invoice, payment/allocation, serial/lot or amortisation-transaction union. Invoice type and line/GL status are NATIVE CODES, not guessed invoice/credit/open/paid meanings. Voided, negative, zero, NULL and unknown values are retained; no implicit exclusion. The period uses recorded dinvoice, not due, payment or creation date; NULL invoice dates do not enter a chosen period.\n\nIDENTITY: full company-scoped invoice cuid, NOT its displayed cinvno or customer-number pair. The manual documents special invoice numbers FCHG and 0. Aritrs has its own cuid and recorded invoice/customer references, NOT an owning-header UID column. Before line selection require ONE exact invoice/customer pair across ALL current headers, including outside the period. An ambiguous/blank pair leaves the header readable, clearly explains the blocked lines in Details and returns no arbitrary line match; current customer remains independently accessible. Blank/missing/ambiguous matching line cuid blocks the entire line/product branch. Revalidate all 11 invoice context tokens (UID, number, customer, currency, invoice/due dates, void/type/revision, stored foreign balance and paid amount), then nine recorded line tokens before item access. Every child projects bound parent context, including the nested child; no synthetic filter is allowed to silently skip a missing field. UTF16 encoded NULL-aware tokens preserve exact Unicode/whitespace/NULL versus blank through app trimming. No business-value SQL interpolation.\n\nRECORDED VERSUS CURRENT: invoice contacts, addresses, prices, warehouse, SO/shipment/RMA references and lines remain document values. Nonstock/service/orphan lines stay visible. Current item/customer require optional unique exact code matches, not historical ownership or ERP ACL proof. Missing/ambiguous masters return no arbitrary match and do not erase the invoice or line. Current customer currency is separately shown from recorded invoice currency. Current inventory price/cost currency and unit basis are UNVERIFIED, not invoice unit price.\n\nMONEY: foreign subtotal, invoice discount, freight, three taxes and three freight-tax fields, adjustment, finance charge, paid, total discounts/adjustments/write-off and balance are SEPARATE exact source values. No net/total/FX/ageing/overdue/payment-status/reconciliation computation or addition of potentially included taxes. Stored paid, balance, closed and last-paid fields are NOT a complete payment or allocation log. Line foreign values retain owning recorded invoice currency; no own line-currency column, ISO convention, base currency or FX direction is invented. Money, quantities, flags and terms stay text with textual local operations; only sequence sorts numerically. Ordered/shipped quantities and two unit factors stay separate: no remaining or stock formula, unit conversion or completion proof. Amortisation codes/dates/cycles are metadata, NOT a schedule or realised revenue report.\n\nNOTES: AR12 explicitly links header-note UID to header UID and line-note UID to line UID. Use the own UID AND exact invoice reference, with optional unique matches; missing/ambiguous notes cannot drop/multiply rows. Previews contain only the first 4,000 characters, NOT guaranteed complete text. Private notes/contacts require authorised access. Bank/check/card/cardholder/expiry, password/tax identifiers and generic audit fields are excluded.\n\nCOMPATIBILITY: historical AccountMate 12 SQL/Express AR PDF created 20 April 2021 (printed February 2021), plus separate IC12 product and own AR12 customer proof. Not Enterprise or current SQL14 certification. SQL Server2012+ CONCAT is needed. Owner is UNKNOWN: administrator confirms one uniquely readable Arinvc/Aritrs/Arirmk/Aritrk/Icitem/Arcust resolved identically by Android/iOS login/default schema. Android metadata may prefer dbo while iOS uses default resolution; import is NOT claimed to reject duplicate owners automatically. Qualify confirmed objects in Studio and rerun bounded tests. Required/AMTBL is data-entry metadata, not installed DDL/NOT NULL. Check actual edition/types/keys/NULL/collation/indexes/SQL cost/date/decimal/currency/unit semantics. Documentary and adapted SQLite synthetic checks are NOT real ERP, native SQL Server, iOS, performance, security or entitlement certification.\n\nSECURITY: authorised companyDB least-privilege SELECT. Direct SQL does not inherit ERP ACL; filters are not permissions. Package has no credentials, server addresses or business rows. Unofficial, not endorsed by AccountMate.\n\nDocumentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_ar_drg.pdf\nhttps://www.accountmateportal.com/xasset/techdoc/amsql12_ic_drg.pdf\n\nGallery: Eight original native Cifru DEMO images show complete invoice, recorded-line, current-product and current-customer cards and representative Details for all four actual routes. The two root actions and nested item action were actually traversed; both root sub-buttons appear in the selected invoice Details. All business values are invented; no AccountMate installation was connected. The configuration retains 183 useful Detail positions (79 invoice, 47 line, 20 current item, 37 current customer), checked in full private overlapping native continuations. This is a representative gallery, not a claim that eight images show every configured field. Recorded bill-to/ship-to contacts and addresses, additional dates, taxes, amounts, codes, amortisation metadata and note continuations remain in the JSON and private captures; no field was removed and no screenshot retouched to fit eight. Source paid amount and balance are not a complete payment or allocation log; dates/flags do not create a guessed paid or credit status. Money, quantities, flags and terms stay exact source text, not net/FX/ageing/overdue/remaining/stock formulas. Current item price/cost has explicitly unverified currency and unit basis and is not the recorded invoice price. The current-customer currency/contact/address is not the invoice snapshot and never replaces it. Invoice and line notes use their own documented UID ownership and exact invoice reference with optional unique first-4,000-character previews; missing/ambiguous notes do not drop or multiply rows. Invoice identity uses full cuid, not the displayed number. An ambiguous exact invoice/customer pair across all current headers blocks arbitrary line access, not the readable invoice or independent current-customer action. Nonstock/service/orphan lines remain visible. Amortisation fields are metadata, not a schedule or realised-revenue report; archives/payments/serials are not automatically included. Private contacts/notes require authorised SQL access; direct SQL does not inherit ERP ACL. Original PNG/XML pairs, frozen invented input and silent RAW are retained for future videos. Whole RAW/Home, the native opening-summary internal last7Days label, synthetic null placeholders and redundant continuations remain private and are not video-approved. Pro requirements were checked; capture uses a Pro test entitlement, not a purchase test. This proves native synthetic Android UI/action traversal and constrained adapted reference query intent, not real ERP, native SQLServer/iOS/current edition/DDL/owner/collation, connector NULL conversion, ISO currency/FX/unit conventions, source ACL, reconciliation, archive completeness or performance.",
        "licenseCode": "Cifru-Community-1.0",
        "minimumCifruVersion": "1.1.0",
        "minimumPlan": "pro",
        "packageID": "E78B1DDA-ADA6-5C72-B37D-A779541C7340",
        "rootButtonCount": 1,
        "summary": "Choose an invoice period; inspect recorded amounts, due dates, addresses and lines, then current item and customer details.",
        "tags": [
            "AccountMate",
            "SQL Server",
            "Accounting",
            "Customer invoices",
            "Invoice lines",
            "Receivables",
            "Pro"
        ],
        "title": "Customer invoices, recorded lines and current dossiers — Pro"
    }
}

Customer invoices, recorded lines and current dossiers — Pro

Screenshots

What this package creates

Tags

Reviews

Write a review

Similar templates

Supplier invoices, accounting distributions and supplier — Pro

Customer dossier, contacts, address book and invoices — Pro

Purchase orders, recorded lines and supplier — Pro

Warehouse stock, current product and SKU-wide bins — Pro

Customer orders, recorded lines and current inventory item — Pro

Customer contacts, address and trading references — Free