Customer orders, recorded lines and current inventory item — Pro
Choose an order-date period; inspect recorded shipping, source amounts and notes, then lines and optional current item details.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.
For sales, customer service, warehouse teams and managers: choose the recorded order-date period to inspect current customer documents, customer PO references, recorded bill-to and ship-to contacts/addresses, shipping, hold/cancellation codes, foreign source amounts and retained notes. Open the recorded lines on demand, then the current inventory-code match when available.
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, three bounded live lists, full same-row Details and two actual lazy actions (order to lines, line to current inventory item). 52 order, 38 line and 19 current-item useful Detail positions; identity/context tokens hidden. Native mandatory order-date period before the final 2,000 root cap; child caps 500. Search/local filters apply to loaded rows only. No widgets, computed totals, writes or periodic refresh. Existing workspace resources count. A cap is not a query-performance guarantee.
SCOPE: current Sosord/Sostrs documents only. Quotes, held/cancelled and unknown native values are not silently excluded or reclassified. The lquote name and its historical manual wording conflict: wording says marked for order, unmarked for quote. KEEP THE NATIVE FLAG; no guessed 0/1 order/quote label or filter. Verify installed behavior. Period is recorded dorder, not creation, quote, delivery or payment date; NULL order dates cannot enter a chosen date period. No automatic history, blanket/recurring order or shipment-table union; no promise of complete archive, invoice, delivery tracking or payment execution.
RECORDED CONTEXT: bill-to and ship-to data, salesperson, shipping/warehouse/payment codes, requested line dates, description, specifications, unit and prices are recorded document values, not replaced by current customer/product masters. Non-stock/service and orphan lines remain. Current inventory child is only an optional unique code match; verify the native line stock flag. It is NOT proof a non-stock line originally used that inventory master. Missing/ambiguous matches leave recorded lines intact and an empty child is not proof of no original product.
QUANTITIES: ordered, shipped, advanced-billing and built quantities are separate exact source values. Both base/transaction-unit factors are retained, not applied. No remaining, stock, availability, weight-unit, conversion or completion calculation. Sequence alone sorts numerically; money/quantities/flags stay source text with textual local filtering/sorting.
MONEY: foreign unit prices, subtotal, discount, freight, adjustments and three tax amounts are read separately, never recomputed, summed or added twice. Line foreign values display the owning recorded order currency context; no own line-currency column is invented. No ISO code, base currency or exchange-rate direction is assumed. Current item price/cost has UNVERIFIED currency and unit basis and is not the order price. Zero, negative, NULL and unknown source values remain distinct. Verify semantics before financial decisions.
NOTES: optional unique order/line-owned remarks; missing/ambiguous notes neither drop nor multiply a document/line. Notes are explicitly previews of the first 4,000 characters, NOT guaranteed complete original text. Free text may contain private information; grant access only when authorised. No bank, check, credit-card, cardholder/expiry or password fields selected.
IDENTITY: own csono order key within the authorised companyDB, full cuid line identity; clineitem is a hidden reference, not a global primary key. Root missing/blank/ambiguous order identities are excluded. Recorded customer NULL/blank is not a reason to invent a master or drop the root: line membership checks the exact NULL-aware customer token plus full order. Missing/blank/ambiguous matching line UID blocks the WHOLE line branch, not partial arbitrary selection. Revalidate full order/customer/currency/date/native flags before lines, and line/item/warehouse/unit/request-date/stock/specification tokens before inventory child. Encoded UTF16 context preserves whitespace/Unicode and NULL versus blank through app trimming.
COMPATIBILITY: historical AccountMate 12 SQL/Express SO and separate IC12 item proof, 15 February 2021. Not Enterprise/current SQL14 certification. Required/AMTBL widths are entry metadata, not installed DDL or NOT NULL. SQL Server 2012+ for CONCAT. Owner is UNKNOWN: administrator confirms exactly one readable Sosord/Sostrs/Sosork/Sotrmk/Icitem resolved identically by Android/iOS login/default schema. Android metadata may prefer dbo while iOS queries use default resolution; import is NOT claimed to automatically reject duplicate owners. Confirm/qualify objects in Studio and repeat bounded read tests. Check installed edition/fields/types/full keys/collation/indexes/SQL cost, date/decimal/NULL conversion and currency/unit semantics. Documentary and adapted SQLite synthetic checks are NOT real ERP, native SQL Server, iOS, performance, security or purchase-entitlement certification.
SECURITY: company-authorised least-privilege SELECT reporting connection. Direct SQL does not inherit ERP ACL; filters are not permissions. Package has no credentials, server address or business rows. Unofficial, not endorsed by AccountMate.
Documentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_so_drg.pdf
https://www.accountmateportal.com/xasset/techdoc/amsql12_ic_drg.pdf
Gallery: Eight original native Cifru DEMO images show complete recorded-order, recorded-line and current-inventory cards, both actually traversed nested actions and representative Details. All values are invented; no AccountMate installation was connected. The configuration retains 109 useful Detail positions (52 order, 38 line, 19 current item); their nonblank values are checked in full private overlapping native continuations. This is a representative gallery, not a claim that eight images show every configured field. Recorded bill/ship addresses, contacts, dates, codes, notes and further context remain in the JSON and private continuations; no field was removed or screenshot retouched to fit eight. The ambiguous historical order/quote flag is kept raw, never guessed into an enum or silently filtered. Source ordered, shipped, advanced-billing and built quantities and unit factors remain distinct, with no remaining/stock/availability calculation. Foreign monetary fields are separate source values in the owning recorded order currency; current inventory price/cost has unverified currency and unit basis and is not the historic order price. Notes are explicit first 4,000-character previews, not claimed complete text. Optional absent/ambiguous notes and item matches do not drop or multiply recorded rows. 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, redundant continuations and the incomplete R2 take are private and not video-approved. Pro requirements were checked; capture uses a Pro test entitlement, not a purchase test. This proves native synthetic UI/action traversal plus adapted reference query intent, not real ERP, SQLServer/iOS/current edition/DDL/owner/collation, connector conversion, ISO currency/FX/unit conventions, source ACL, financial reconciliation, archive completeness or performance.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Customer orders
- Details: Recorded order lines
- Details: Current inventory item
- Sub-button: Recorded order lines
- Sub-button: Current inventory item
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AS OrderKey, CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AS OrderToken, 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.dorder IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dorder, 126) AS nvarchar(max))), 2)) END AS OrderDateToken, CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END AS OrderQuoteToken, CASE WHEN h.lhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lhold AS nvarchar(max))), 2)) END AS HoldToken, CASE WHEN h.lcrhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lcrhold AS nvarchar(max))), 2)) END AS CreditHoldToken, 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 CancelledToken, CASE WHEN h.lnobo IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lnobo AS nvarchar(max))), 2)) END AS NoBackorderToken, CAST(h.csono AS nvarchar(max)) AS csono, CAST(h.ccustno AS nvarchar(max)) AS ccustno, CAST(h.corderby AS nvarchar(max)) AS corderby, CAST(h.cslpnno AS nvarchar(max)) AS cslpnno, 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.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.cfrgtcode AS nvarchar(max)) AS cfrgtcode, 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.cwarehouse AS nvarchar(max)) AS cwarehouse, CONVERT(varchar(10), h.dorder, 23) AS dorder, CONVERT(varchar(10), h.dquote, 23) AS dquote, CONVERT(varchar(10), h.dquoteaprv, 23) AS dquoteaprv, CAST(h.lquote AS nvarchar(max)) AS lquote, CAST(h.lhold AS nvarchar(max)) AS lhold, CAST(h.lcrhold AS nvarchar(max)) AS lcrhold, CAST(h.lvoid AS nvarchar(max)) AS lvoid, CAST(h.lnobo AS nvarchar(max)) AS lnobo, CAST(h.lprcinctax AS nvarchar(max)) AS lprcinctax, 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.nfadjamt AS nvarchar(max)) AS nfadjamt, CAST(h.nxchgrate AS nvarchar(max)) AS nxchgrate, COALESCE(NULLIF(h.cbcompany,N''),NULLIF(h.ccustno,N''),N'Unknown recorded customer') AS OrderPartyLabel, LEFT(CAST(onote.msoremark AS nvarchar(max)), 4000) AS OrderRemark, CASE WHEN onote.csono 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 OrderNoteContext FROM Sosord h LEFT JOIN Sosork onote ON onote.csono=h.csono AND CASE WHEN onote.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(onote.csono AS nvarchar(max))), 2)) END=CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Sosork nq WHERE nq.csono=onote.csono) WHERE h.csono IS NOT NULL AND h.csono<>N'' AND DATALENGTH(CAST(h.csono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Sosord hq WHERE hq.csono=h.csono)
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AS OrderToken, 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.dorder IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dorder, 126) AS nvarchar(max))), 2)) END AS OrderDateToken, CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END AS OrderQuoteToken, CASE WHEN h.lhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lhold AS nvarchar(max))), 2)) END AS HoldToken, CASE WHEN h.lcrhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lcrhold AS nvarchar(max))), 2)) END AS CreditHoldToken, 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 CancelledToken, CASE WHEN h.lnobo IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lnobo AS nvarchar(max))), 2)) END AS NoBackorderToken, 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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), l.drequest, 126) AS nvarchar(max))), 2)) END AS RequestDateToken, 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, CAST(l.csono AS nvarchar(max)) AS csono, CAST(l.ccustno AS nvarchar(max)) AS ccustno, 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.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(l.cmeasure AS nvarchar(max)) AS cmeasure, CAST(l.crevncode AS nvarchar(max)) AS crevncode, CAST(l.ctaxcode AS nvarchar(max)) AS ctaxcode, CONVERT(varchar(10), l.drequest, 23) AS drequest, 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.ltaxable1 AS nvarchar(max)) AS ltaxable1, CAST(l.ltaxable2 AS nvarchar(max)) AS ltaxable2, CAST(l.lautoacpt AS nvarchar(max)) AS lautoacpt, CAST(l.ldropship AS nvarchar(max)) AS ldropship, 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.nbuiltqty AS nvarchar(max)) AS nbuiltqty, CAST(l.nordqty AS nvarchar(max)) AS nordqty, CAST(l.nshipqty AS nvarchar(max)) AS nshipqty, CAST(l.nadvqty AS nvarchar(max)) AS nadvqty, CAST(l.nitmcnvqty AS nvarchar(max)) AS nitmcnvqty, CAST(l.ntrscnvqty AS nvarchar(max)) AS ntrscnvqty, CAST(l.nweight AS nvarchar(max)) AS nweight, 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(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 line stock flag, not order snapshot' END AS ProductContext FROM Sosord h INNER JOIN Sostrs l ON l.csono=h.csono 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=CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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 Sotrmk 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.csono=l.csono AND CASE WHEN lnote.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lnote.csono AS nvarchar(max))), 2)) END=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 AND 1=(SELECT COUNT(*) FROM Sotrmk 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.csono=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:order, 2, 2147483647), 2)) AND h.csono IS NOT NULL AND h.csono<>N'' AND DATALENGTH(CAST(h.csono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Sosord hq WHERE hq.csono=h.csono) AND CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END=:order 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.dorder IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dorder, 126) AS nvarchar(max))), 2)) END=:order_date AND CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END=:order_quote AND CASE WHEN h.lhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lhold AS nvarchar(max))), 2)) END=:hold AND CASE WHEN h.lcrhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lcrhold AS nvarchar(max))), 2)) END=:credit_hold 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=:cancelled AND CASE WHEN h.lnobo IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lnobo AS nvarchar(max))), 2)) END=:no_backorder AND NOT EXISTS (SELECT 1 FROM Sostrs lx WHERE lx.csono=h.csono AND CASE WHEN lx.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.csono AS nvarchar(max))), 2)) END=CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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 Sostrs lq WHERE lq.cuid=lx.cuid)))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AS OrderToken, 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.dorder IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dorder, 126) AS nvarchar(max))), 2)) END AS OrderDateToken, CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END AS OrderQuoteToken, CASE WHEN h.lhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lhold AS nvarchar(max))), 2)) END AS HoldToken, CASE WHEN h.lcrhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lcrhold AS nvarchar(max))), 2)) END AS CreditHoldToken, 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 CancelledToken, CASE WHEN h.lnobo IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lnobo AS nvarchar(max))), 2)) END AS NoBackorderToken, 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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), l.drequest, 126) AS nvarchar(max))), 2)) END AS RequestDateToken, 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, 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, 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 line stock flag, not order snapshot' END AS ProductContext FROM Sosord h INNER JOIN Sostrs l ON l.csono=h.csono 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=CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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.csono=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:order, 2, 2147483647), 2)) AND h.csono IS NOT NULL AND h.csono<>N'' AND DATALENGTH(CAST(h.csono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Sosord hq WHERE hq.csono=h.csono) AND CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END=:order 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.dorder IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dorder, 126) AS nvarchar(max))), 2)) END=:order_date AND CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END=:order_quote AND CASE WHEN h.lhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lhold AS nvarchar(max))), 2)) END=:hold AND CASE WHEN h.lcrhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lcrhold AS nvarchar(max))), 2)) END=:credit_hold 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=:cancelled AND CASE WHEN h.lnobo IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lnobo AS nvarchar(max))), 2)) END=:no_backorder AND NOT EXISTS (SELECT 1 FROM Sostrs lx WHERE lx.csono=h.csono AND CASE WHEN lx.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.csono AS nvarchar(max))), 2)) END=CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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 Sostrs 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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), l.drequest, 126) AS nvarchar(max))), 2)) END=:request_date 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 i.citemno IS NOT NULL
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "AccountMate SQL/Express — authorised company database",
"id": "B033385A-5CE7-5E86-856A-D95BDDA144C4",
"kind": "sqlServer",
"requiredObjects": [
"Sosord",
"Sostrs",
"Sosork",
"Sotrmk",
"Icitem"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "25D951C3-0B23-54A4-8E69-990D4EFECB65",
"key": "dorder",
"type": "date"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"id": "861EFA49-7FC5-5BA1-B1DA-128BF5E765C7",
"mappings": [
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Hidden full order identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderToken",
"label": "Hidden order context order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerToken",
"label": "Hidden order context customer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyToken",
"label": "Hidden order context currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderDateToken",
"label": "Hidden order context order_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderDateToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderQuoteToken",
"label": "Hidden order context order_quote",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderQuoteToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HoldToken",
"label": "Hidden order context hold",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "HoldToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CreditHoldToken",
"label": "Hidden order context credit_hold",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreditHoldToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CancelledToken",
"label": "Hidden order context cancelled",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CancelledToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NoBackorderToken",
"label": "Hidden order context no_backorder",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NoBackorderToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csono",
"label": "Sales order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csono",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccustno",
"label": "Customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccustno",
"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": "Salesperson code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cslpnno",
"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": "Bill-to address1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbaddr1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbaddr2",
"label": "Bill-to address2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbaddr2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbcity",
"label": "Bill-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbcity",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbstate",
"label": "Bill-to state/region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbstate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbzip",
"label": "Bill-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbzip",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbcountry",
"label": "Bill-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbcountry",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbphone",
"label": "Bill-to phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbphone",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbcontact",
"label": "Bill-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbcontact",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbemail",
"label": "Bill-to email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbemail",
"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": true
},
{
"commonFieldKey": "",
"key": "csaddr1",
"label": "Ship-to address1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csaddr1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csaddr2",
"label": "Ship-to address2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csaddr2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cscity",
"label": "Ship-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cscity",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csstate",
"label": "Ship-to state/region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csstate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cszip",
"label": "Ship-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cszip",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cscountry",
"label": "Ship-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cscountry",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csphone",
"label": "Ship-to phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csphone",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cscontact",
"label": "Ship-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cscontact",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csemail",
"label": "Ship-to email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csemail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cshipvia",
"label": "Shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cshipvia",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cfob",
"label": "F.O.B. code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfob",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpono",
"label": "Customer purchase-order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpono",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cfrgtcode",
"label": "Freight code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfrgtcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctaxcode",
"label": "Tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctaxcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpaycode",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpaycode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccurrcode",
"label": "Recorded order currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccurrcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cwarehouse",
"label": "Order warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cwarehouse",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "dorder",
"label": "Recorded order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dorder",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "dquote",
"label": "Recorded quote date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dquote",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dquoteaprv",
"label": "Recorded quote approval date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dquoteaprv",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lquote",
"label": "Order/quote source flag — verify semantics",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lquote",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lhold",
"label": "On-hold native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lhold",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "lcrhold",
"label": "Credit-hold native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lcrhold",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lvoid",
"label": "Cancelled native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lvoid",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lnobo",
"label": "No-backorder native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lnobo",
"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": "ndiscrate",
"label": "Recorded discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ndiscrate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfsalesamt",
"label": "Recorded foreign subtotal amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfsalesamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nfdiscamt",
"label": "Recorded foreign discount amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfdiscamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nffrtamt",
"label": "Recorded foreign freight amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nffrtamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt1",
"label": "Recorded foreign tax amount1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt2",
"label": "Recorded foreign tax amount2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt3",
"label": "Recorded foreign tax amount3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfadjamt",
"label": "Recorded foreign adjustment amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfadjamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nxchgrate",
"label": "Recorded exchange rate — direction unverified",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nxchgrate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderPartyLabel",
"label": "Card recorded bill-to party",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderPartyLabel",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderRemark",
"label": "Recorded order remark — preview",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderRemark",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderNoteContext",
"label": "Order remark availability and preview scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderNoteContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Customer orders",
"primaryKey": "OrderKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"csono",
"ccustno",
"corderby",
"cslpnno",
"cbcompany",
"cbaddr1",
"cbaddr2",
"cbcity",
"cbstate",
"cbzip",
"cbcountry",
"cbphone",
"cbcontact",
"cbemail",
"cscompany",
"csaddr1",
"csaddr2",
"cscity",
"csstate",
"cszip",
"cscountry",
"csphone",
"cscontact",
"csemail",
"cshipvia",
"cfob",
"cpono",
"cfrgtcode",
"ctaxcode",
"cpaycode",
"ccurrcode",
"cwarehouse",
"lquote",
"lhold",
"lcrhold",
"lvoid",
"lnobo",
"lprcinctax",
"ndiscrate",
"nfsalesamt",
"nfdiscamt",
"nffrtamt",
"nftaxamt1",
"nftaxamt2",
"nftaxamt3",
"nfadjamt",
"nxchgrate",
"OrderRemark",
"OrderNoteContext"
],
"sourceID": "B033385A-5CE7-5E86-856A-D95BDDA144C4",
"sqlQuery": "SELECT CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AS OrderKey, CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AS OrderToken, 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.dorder IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dorder, 126) AS nvarchar(max))), 2)) END AS OrderDateToken, CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END AS OrderQuoteToken, CASE WHEN h.lhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lhold AS nvarchar(max))), 2)) END AS HoldToken, CASE WHEN h.lcrhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lcrhold AS nvarchar(max))), 2)) END AS CreditHoldToken, 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 CancelledToken, CASE WHEN h.lnobo IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lnobo AS nvarchar(max))), 2)) END AS NoBackorderToken, CAST(h.csono AS nvarchar(max)) AS csono, CAST(h.ccustno AS nvarchar(max)) AS ccustno, CAST(h.corderby AS nvarchar(max)) AS corderby, CAST(h.cslpnno AS nvarchar(max)) AS cslpnno, 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.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.cfrgtcode AS nvarchar(max)) AS cfrgtcode, 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.cwarehouse AS nvarchar(max)) AS cwarehouse, CONVERT(varchar(10), h.dorder, 23) AS dorder, CONVERT(varchar(10), h.dquote, 23) AS dquote, CONVERT(varchar(10), h.dquoteaprv, 23) AS dquoteaprv, CAST(h.lquote AS nvarchar(max)) AS lquote, CAST(h.lhold AS nvarchar(max)) AS lhold, CAST(h.lcrhold AS nvarchar(max)) AS lcrhold, CAST(h.lvoid AS nvarchar(max)) AS lvoid, CAST(h.lnobo AS nvarchar(max)) AS lnobo, CAST(h.lprcinctax AS nvarchar(max)) AS lprcinctax, 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.nfadjamt AS nvarchar(max)) AS nfadjamt, CAST(h.nxchgrate AS nvarchar(max)) AS nxchgrate, COALESCE(NULLIF(h.cbcompany,N''),NULLIF(h.ccustno,N''),N'Unknown recorded customer') AS OrderPartyLabel, LEFT(CAST(onote.msoremark AS nvarchar(max)), 4000) AS OrderRemark, CASE WHEN onote.csono 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 OrderNoteContext FROM Sosord h LEFT JOIN Sosork onote ON onote.csono=h.csono AND CASE WHEN onote.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(onote.csono AS nvarchar(max))), 2)) END=CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Sosork nq WHERE nq.csono=onote.csono) WHERE h.csono IS NOT NULL AND h.csono<>N'' AND DATALENGTH(CAST(h.csono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Sosord hq WHERE hq.csono=h.csono)",
"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": "350B60F1-88F8-5186-938E-84D8A5F0DA1B",
"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": "OrderToken",
"label": "Hidden order context order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerToken",
"label": "Hidden order context customer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyToken",
"label": "Hidden order context currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderDateToken",
"label": "Hidden order context order_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderDateToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderQuoteToken",
"label": "Hidden order context order_quote",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderQuoteToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HoldToken",
"label": "Hidden order context hold",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "HoldToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CreditHoldToken",
"label": "Hidden order context credit_hold",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreditHoldToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CancelledToken",
"label": "Hidden order context cancelled",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CancelledToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NoBackorderToken",
"label": "Hidden order context no_backorder",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NoBackorderToken",
"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": "RequestDateToken",
"label": "Hidden line context request_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RequestDateToken",
"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": "csono",
"label": "Sales order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csono",
"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": "citemno",
"label": "Recorded item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "citemno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cspeccode1",
"label": "Specification code1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cspeccode1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cspeccode2",
"label": "Specification code2",
"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": "cwarehouse",
"label": "Recorded line warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cwarehouse",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cmeasure",
"label": "Recorded transaction unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cmeasure",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "crevncode",
"label": "Revenue code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "crevncode",
"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": "drequest",
"label": "Requested date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "drequest",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "lkititem",
"label": "Kit 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": "Customized-kit native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lmodikit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ltaxable1",
"label": "Taxable1 native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ltaxable1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ltaxable2",
"label": "Taxable2 native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ltaxable2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lautoacpt",
"label": "Auto-accept shipment native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lautoacpt",
"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": "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 tax1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt2",
"label": "Recorded foreign line tax2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt3",
"label": "Recorded foreign line tax3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nbuiltqty",
"label": "Recorded built quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nbuiltqty",
"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": "nadvqty",
"label": "Recorded advanced-billing quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nadvqty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"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": "nweight",
"label": "Recorded line weight — unit unverified",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nweight",
"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": "Line sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "number",
"sourceColumn": "nseq",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentCurrencyCode",
"label": "Recorded owning-order currency code",
"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 order snapshot",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProductContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Recorded order lines",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderToken",
"id": "402AD671-E6D5-573D-BBE7-22FAF6D3616D",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CustomerToken",
"id": "640A308B-B2A7-5F49-9290-E2ADCAC94ACF",
"name": "customer",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CurrencyToken",
"id": "1245F18B-0D19-599E-9F28-EA67913A7BA1",
"name": "currency",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderDateToken",
"id": "CFD262D5-678B-5756-845A-90438910D007",
"name": "order_date",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderQuoteToken",
"id": "443311F9-795B-53CA-A268-5FC683F58712",
"name": "order_quote",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "HoldToken",
"id": "E8F4EB59-7DAE-5D30-AB7C-D57AD6C8BBC9",
"name": "hold",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CreditHoldToken",
"id": "2FFFE545-93AC-53D1-9806-93F53717C94B",
"name": "credit_hold",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CancelledToken",
"id": "7AD01CF5-FF2A-5EBA-8E34-5B99B4964606",
"name": "cancelled",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "NoBackorderToken",
"id": "AE8E0BD9-82C4-5F02-8CCA-40B919F94E3E",
"name": "no_backorder",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"csono",
"ccustno",
"citemno",
"cspeccode1",
"cspeccode2",
"cdescript",
"cwarehouse",
"cmeasure",
"crevncode",
"ctaxcode",
"lkititem",
"lstock",
"lmodikit",
"ltaxable1",
"ltaxable2",
"lautoacpt",
"ldropship",
"ndiscrate",
"nfsalesamt",
"nfdiscamt",
"nftaxamt1",
"nftaxamt2",
"nftaxamt3",
"nbuiltqty",
"nordqty",
"nshipqty",
"nadvqty",
"nitmcnvqty",
"ntrscnvqty",
"nweight",
"nfprice",
"nfprcinctx",
"nseq",
"ParentCurrencyCode",
"LineRemark",
"LineNoteContext",
"ProductContext"
],
"sourceID": "B033385A-5CE7-5E86-856A-D95BDDA144C4",
"sqlQuery": "SELECT CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AS OrderToken, 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.dorder IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dorder, 126) AS nvarchar(max))), 2)) END AS OrderDateToken, CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END AS OrderQuoteToken, CASE WHEN h.lhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lhold AS nvarchar(max))), 2)) END AS HoldToken, CASE WHEN h.lcrhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lcrhold AS nvarchar(max))), 2)) END AS CreditHoldToken, 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 CancelledToken, CASE WHEN h.lnobo IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lnobo AS nvarchar(max))), 2)) END AS NoBackorderToken, 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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), l.drequest, 126) AS nvarchar(max))), 2)) END AS RequestDateToken, 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, CAST(l.csono AS nvarchar(max)) AS csono, CAST(l.ccustno AS nvarchar(max)) AS ccustno, 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.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(l.cmeasure AS nvarchar(max)) AS cmeasure, CAST(l.crevncode AS nvarchar(max)) AS crevncode, CAST(l.ctaxcode AS nvarchar(max)) AS ctaxcode, CONVERT(varchar(10), l.drequest, 23) AS drequest, 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.ltaxable1 AS nvarchar(max)) AS ltaxable1, CAST(l.ltaxable2 AS nvarchar(max)) AS ltaxable2, CAST(l.lautoacpt AS nvarchar(max)) AS lautoacpt, CAST(l.ldropship AS nvarchar(max)) AS ldropship, 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.nbuiltqty AS nvarchar(max)) AS nbuiltqty, CAST(l.nordqty AS nvarchar(max)) AS nordqty, CAST(l.nshipqty AS nvarchar(max)) AS nshipqty, CAST(l.nadvqty AS nvarchar(max)) AS nadvqty, CAST(l.nitmcnvqty AS nvarchar(max)) AS nitmcnvqty, CAST(l.ntrscnvqty AS nvarchar(max)) AS ntrscnvqty, CAST(l.nweight AS nvarchar(max)) AS nweight, 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(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 line stock flag, not order snapshot' END AS ProductContext FROM Sosord h INNER JOIN Sostrs l ON l.csono=h.csono 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=CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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 Sotrmk 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.csono=l.csono AND CASE WHEN lnote.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lnote.csono AS nvarchar(max))), 2)) END=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 AND 1=(SELECT COUNT(*) FROM Sotrmk 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.csono=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:order, 2, 2147483647), 2)) AND h.csono IS NOT NULL AND h.csono<>N'' AND DATALENGTH(CAST(h.csono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Sosord hq WHERE hq.csono=h.csono) AND CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END=:order 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.dorder IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dorder, 126) AS nvarchar(max))), 2)) END=:order_date AND CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END=:order_quote AND CASE WHEN h.lhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lhold AS nvarchar(max))), 2)) END=:hold AND CASE WHEN h.lcrhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lcrhold AS nvarchar(max))), 2)) END=:credit_hold 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=:cancelled AND CASE WHEN h.lnobo IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lnobo AS nvarchar(max))), 2)) END=:no_backorder AND NOT EXISTS (SELECT 1 FROM Sostrs lx WHERE lx.csono=h.csono AND CASE WHEN lx.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.csono AS nvarchar(max))), 2)) END=CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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 Sostrs 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": "6D0F7D7B-55E3-5D40-8EBC-3F145B9C299E",
"mappings": [
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Hidden parent-owned inventory 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": "OrderToken",
"label": "Hidden order context order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerToken",
"label": "Hidden order context customer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyToken",
"label": "Hidden order context currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderDateToken",
"label": "Hidden order context order_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderDateToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderQuoteToken",
"label": "Hidden order context order_quote",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderQuoteToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HoldToken",
"label": "Hidden order context hold",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "HoldToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CreditHoldToken",
"label": "Hidden order context credit_hold",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreditHoldToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CancelledToken",
"label": "Hidden order context cancelled",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CancelledToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NoBackorderToken",
"label": "Hidden order context no_backorder",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NoBackorderToken",
"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": "RequestDateToken",
"label": "Hidden line context request_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RequestDateToken",
"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": "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": "ProductContext",
"label": "Current inventory context — not order 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": "OrderToken",
"id": "402AD671-E6D5-573D-BBE7-22FAF6D3616D",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CustomerToken",
"id": "640A308B-B2A7-5F49-9290-E2ADCAC94ACF",
"name": "customer",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CurrencyToken",
"id": "1245F18B-0D19-599E-9F28-EA67913A7BA1",
"name": "currency",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderDateToken",
"id": "CFD262D5-678B-5756-845A-90438910D007",
"name": "order_date",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderQuoteToken",
"id": "443311F9-795B-53CA-A268-5FC683F58712",
"name": "order_quote",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "HoldToken",
"id": "E8F4EB59-7DAE-5D30-AB7C-D57AD6C8BBC9",
"name": "hold",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CreditHoldToken",
"id": "2FFFE545-93AC-53D1-9806-93F53717C94B",
"name": "credit_hold",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CancelledToken",
"id": "7AD01CF5-FF2A-5EBA-8E34-5B99B4964606",
"name": "cancelled",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "NoBackorderToken",
"id": "AE8E0BD9-82C4-5F02-8CCA-40B919F94E3E",
"name": "no_backorder",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "LineToken",
"id": "7BAC7AA0-86D6-5490-9B99-F4485420AEAD",
"name": "line_uid",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ItemToken",
"id": "0E35C51B-7333-5564-9854-D59FD1BE1CC9",
"name": "item",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "WarehouseToken",
"id": "7CD00365-AC2B-57F4-8935-44E0887EE102",
"name": "warehouse",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "UnitToken",
"id": "60CAC972-CCD7-5C22-8B85-9E3D2971B41F",
"name": "unit",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "RequestDateToken",
"id": "AA26C909-1F64-5183-87C1-B0033CF01E27",
"name": "request_date",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "StockToken",
"id": "2DB06B3F-BCB7-5100-BAA3-D04A2DE4391A",
"name": "stock",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "Spec1Token",
"id": "A41BA38B-6D44-5AAF-8E05-5C0E46BDD106",
"name": "spec1",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "Spec2Token",
"id": "400D5F5D-3BDF-5F67-AEF1-7B634DAF8AFD",
"name": "spec2",
"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",
"ProductContext"
],
"sourceID": "B033385A-5CE7-5E86-856A-D95BDDA144C4",
"sqlQuery": "SELECT CONCAT(CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END AS OrderToken, 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.dorder IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dorder, 126) AS nvarchar(max))), 2)) END AS OrderDateToken, CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END AS OrderQuoteToken, CASE WHEN h.lhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lhold AS nvarchar(max))), 2)) END AS HoldToken, CASE WHEN h.lcrhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lcrhold AS nvarchar(max))), 2)) END AS CreditHoldToken, 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 CancelledToken, CASE WHEN h.lnobo IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lnobo AS nvarchar(max))), 2)) END AS NoBackorderToken, 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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), l.drequest, 126) AS nvarchar(max))), 2)) END AS RequestDateToken, 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, 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, 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 line stock flag, not order snapshot' END AS ProductContext FROM Sosord h INNER JOIN Sostrs l ON l.csono=h.csono 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=CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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.csono=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:order, 2, 2147483647), 2)) AND h.csono IS NOT NULL AND h.csono<>N'' AND DATALENGTH(CAST(h.csono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Sosord hq WHERE hq.csono=h.csono) AND CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono AS nvarchar(max))), 2)) END=:order 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.dorder IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.dorder, 126) AS nvarchar(max))), 2)) END=:order_date AND CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END=:order_quote AND CASE WHEN h.lhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lhold AS nvarchar(max))), 2)) END=:hold AND CASE WHEN h.lcrhold IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lcrhold AS nvarchar(max))), 2)) END=:credit_hold 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=:cancelled AND CASE WHEN h.lnobo IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lnobo AS nvarchar(max))), 2)) END=:no_backorder AND NOT EXISTS (SELECT 1 FROM Sostrs lx WHERE lx.csono=h.csono AND CASE WHEN lx.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.csono AS nvarchar(max))), 2)) END=CASE WHEN h.csono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.csono 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 Sostrs 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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), l.drequest, 126) AS nvarchar(max))), 2)) END=:request_date 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 i.citemno IS NOT NULL",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "6BA07755-49D4-5E40-80E3-8206FF24E02E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "3E465EB4-2E32-5A9F-AB8B-3878423C9746",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "350B60F1-88F8-5186-938E-84D8A5F0DA1B",
"title": "Recorded order lines",
"urlKey": ""
}
],
"badgeKey": "ccurrcode",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cscompany",
"label": "Recorded ship-to company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cpono",
"label": "Customer purchase-order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cwarehouse",
"label": "Order warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dorder",
"label": "Recorded order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "lhold",
"label": "On-hold native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nfsalesamt",
"label": "Recorded foreign subtotal amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "861EFA49-7FC5-5BA1-B1DA-128BF5E765C7",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded document — native order/quote flag",
"detailRole": "information",
"isVisible": true,
"key": "csono",
"label": "Sales order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native order/quote flag",
"detailRole": "information",
"isVisible": true,
"key": "ccustno",
"label": "Customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native order/quote flag",
"detailRole": "information",
"isVisible": true,
"key": "cpono",
"label": "Customer purchase-order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native order/quote flag",
"detailRole": "information",
"isVisible": true,
"key": "corderby",
"label": "Ordered by",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native order/quote flag",
"detailRole": "information",
"isVisible": true,
"key": "cslpnno",
"label": "Salesperson code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded document — native order/quote flag",
"detailRole": "information",
"isVisible": true,
"key": "lquote",
"label": "Order/quote source flag — verify semantics",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded dates — not delivery or payment proof",
"detailRole": "information",
"isVisible": true,
"key": "dorder",
"label": "Recorded order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded dates — not delivery or payment proof",
"detailRole": "information",
"isVisible": true,
"key": "dquote",
"label": "Recorded quote date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded dates — not delivery or payment proof",
"detailRole": "information",
"isVisible": true,
"key": "dquoteaprv",
"label": "Recorded quote approval date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"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": "Bill-to address1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbaddr2",
"label": "Bill-to address2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbcity",
"label": "Bill-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbstate",
"label": "Bill-to state/region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbzip",
"label": "Bill-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbcountry",
"label": "Bill-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbphone",
"label": "Bill-to phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbcontact",
"label": "Bill-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bill-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cbemail",
"label": "Bill-to email",
"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": "Ship-to address1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "csaddr2",
"label": "Ship-to address2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cscity",
"label": "Ship-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "csstate",
"label": "Ship-to state/region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cszip",
"label": "Ship-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cscountry",
"label": "Ship-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "csphone",
"label": "Ship-to phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "cscontact",
"label": "Ship-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current customer master",
"detailRole": "information",
"isVisible": true,
"key": "csemail",
"label": "Ship-to email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cshipvia",
"label": "Shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cfob",
"label": "F.O.B. code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cfrgtcode",
"label": "Freight code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cwarehouse",
"label": "Order warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cpaycode",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "ctaxcode",
"label": "Tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native hold, cancellation and pricing flags",
"detailRole": "information",
"isVisible": true,
"key": "lhold",
"label": "On-hold native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native hold, cancellation and pricing flags",
"detailRole": "information",
"isVisible": true,
"key": "lcrhold",
"label": "Credit-hold native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native hold, cancellation and pricing flags",
"detailRole": "information",
"isVisible": true,
"key": "lvoid",
"label": "Cancelled native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native hold, cancellation and pricing flags",
"detailRole": "information",
"isVisible": true,
"key": "lnobo",
"label": "No-backorder native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native hold, cancellation and pricing flags",
"detailRole": "information",
"isVisible": true,
"key": "lprcinctax",
"label": "Price-includes-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native hold, cancellation and pricing flags",
"detailRole": "information",
"isVisible": true,
"key": "ndiscrate",
"label": "Recorded discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "ccurrcode",
"label": "Recorded order currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nfsalesamt",
"label": "Recorded foreign subtotal amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nfdiscamt",
"label": "Recorded foreign discount amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nffrtamt",
"label": "Recorded foreign freight amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt1",
"label": "Recorded foreign tax amount1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt2",
"label": "Recorded foreign tax amount2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt3",
"label": "Recorded foreign tax amount3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nfadjamt",
"label": "Recorded foreign adjustment amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded exchange rate — direction unverified",
"detailRole": "information",
"isVisible": true,
"key": "nxchgrate",
"label": "Recorded exchange rate — direction unverified",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded order note — first 4,000 characters only",
"detailRole": "information",
"isVisible": true,
"key": "OrderRemark",
"label": "Recorded order remark — preview",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded order note — first 4,000 characters only",
"detailRole": "information",
"isVisible": true,
"key": "OrderNoteContext",
"label": "Order remark availability and preview scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "0E15828F-8B47-5B67-9F14-7EF4E2316DAA",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "CD1B0B8C-8ACC-5203-854A-D6D3518A627D",
"includeAllOption": false,
"key": "dorder",
"title": "Choose recorded order-date period",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "25D951C3-0B23-54A4-8E69-990D4EFECB65",
"key": "dorder",
"type": "date"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "OrderPartyLabel",
"systemImage": "doc.text",
"title": "Customer orders",
"titleKey": "csono"
},
{
"actions": [
{
"id": "1D17A03B-A0AF-54A0-A84D-7CE5EC03AB1E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "FA2D439E-2159-5F2B-B974-BEA08C4CC53F",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "6D0F7D7B-55E3-5D40-8EBC-3F145B9C299E",
"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": "cmeasure",
"label": "Recorded transaction unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "drequest",
"label": "Requested date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"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": "350B60F1-88F8-5186-938E-84D8A5F0DA1B",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "csono",
"label": "Sales order 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": "Line sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "number"
},
{
"detailGroup": "Recorded line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cspeccode1",
"label": "Specification code1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cspeccode2",
"label": "Specification code2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"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": "drequest",
"label": "Requested date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"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": "nadvqty",
"label": "Recorded advanced-billing quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded quantities and unit factors — no remaining formula",
"detailRole": "information",
"isVisible": true,
"key": "nbuiltqty",
"label": "Recorded built 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": "nweight",
"label": "Recorded line weight — unit unverified",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign price and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "ParentCurrencyCode",
"label": "Recorded owning-order currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign price and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nfprice",
"label": "Recorded foreign unit price",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign price and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nfprcinctx",
"label": "Recorded foreign unit price plus tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign price and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nfsalesamt",
"label": "Recorded foreign line subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign price and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nfdiscamt",
"label": "Recorded foreign line discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign price and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt1",
"label": "Recorded foreign line tax1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign price and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt2",
"label": "Recorded foreign line tax2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign price and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt3",
"label": "Recorded foreign line tax3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign price and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "ndiscrate",
"label": "Recorded line discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native line, delivery and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "crevncode",
"label": "Revenue code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native line, delivery and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "ctaxcode",
"label": "Recorded line tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native line, delivery and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "lstock",
"label": "Stock-item native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native line, delivery and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "lkititem",
"label": "Kit native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native line, delivery and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "lmodikit",
"label": "Customized-kit native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native line, delivery and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "ldropship",
"label": "Drop-ship native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native line, delivery and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "lautoacpt",
"label": "Auto-accept shipment native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native line, delivery and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "ltaxable1",
"label": "Taxable1 native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native line, delivery and tax codes",
"detailRole": "information",
"isVisible": true,
"key": "ltaxable2",
"label": "Taxable2 native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded line note — first 4,000 characters only",
"detailRole": "information",
"isVisible": true,
"key": "LineRemark",
"label": "Recorded line remark — preview",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded line note — first 4,000 characters only",
"detailRole": "information",
"isVisible": true,
"key": "LineNoteContext",
"label": "Line remark availability and preview scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded line note — first 4,000 characters only",
"detailRole": "information",
"isVisible": true,
"key": "ProductContext",
"label": "Current inventory context — not order snapshot",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "FEE06935-BDEA-559F-9014-7389D00D4B0F",
"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 order 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": "6D0F7D7B-55E3-5D40-8EBC-3F145B9C299E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current catalogue match — verify line kind",
"detailRole": "information",
"isVisible": true,
"key": "citemno",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current catalogue match — verify line kind",
"detailRole": "information",
"isVisible": true,
"key": "cdescript",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current catalogue match — verify line kind",
"detailRole": "information",
"isVisible": true,
"key": "cfdescript",
"label": "Foreign description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current catalogue match — verify line kind",
"detailRole": "information",
"isVisible": true,
"key": "cbarcode1",
"label": "Barcode 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current catalogue match — verify line kind",
"detailRole": "information",
"isVisible": true,
"key": "cbarcode2",
"label": "Barcode 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current catalogue match — verify line kind",
"detailRole": "information",
"isVisible": true,
"key": "cclass",
"label": "Item class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current catalogue match — verify line kind",
"detailRole": "information",
"isVisible": true,
"key": "cprodline",
"label": "Product line code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current catalogue match — verify line kind",
"detailRole": "information",
"isVisible": true,
"key": "cstatus",
"label": "Status code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current catalogue match — verify line kind",
"detailRole": "information",
"isVisible": true,
"key": "ProductContext",
"label": "Current inventory context — not order snapshot",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current stock, sales and purchase units",
"detailRole": "information",
"isVisible": true,
"key": "cmeasure",
"label": "Stock unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current stock, sales and purchase units",
"detailRole": "information",
"isVisible": true,
"key": "csmeasure",
"label": "Sales unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current stock, sales and purchase units",
"detailRole": "information",
"isVisible": true,
"key": "cpmeasure",
"label": "Purchase unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current 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": "CA9ABD32-86CF-5CC6-9235-172D0D18AE95",
"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"
}
],
"relations": [
{
"childDatasetID": "350B60F1-88F8-5186-938E-84D8A5F0DA1B",
"childKey": "ParentKey",
"id": "3E465EB4-2E32-5A9F-AB8B-3878423C9746",
"name": "Recorded order lines",
"parentDatasetID": "861EFA49-7FC5-5BA1-B1DA-128BF5E765C7",
"parentKey": "OrderKey"
},
{
"childDatasetID": "6D0F7D7B-55E3-5D40-8EBC-3F145B9C299E",
"childKey": "ParentKey",
"id": "FA2D439E-2159-5F2B-B974-BEA08C4CC53F",
"name": "Current inventory item",
"parentDatasetID": "350B60F1-88F8-5186-938E-84D8A5F0DA1B",
"parentKey": "LineKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "AccountMate for SQL/Express",
"changelog": "Initial Pro current customer orders, recorded lines and optional current inventory item; mandatory order-date period, native fictional complete cards and representative Details. Not a real ERP connection test.",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-11T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.\n\nFor sales, customer service, warehouse teams and managers: choose the recorded order-date period to inspect current customer documents, customer PO references, recorded bill-to and ship-to contacts/addresses, shipping, hold/cancellation codes, foreign source amounts and retained notes. Open the recorded lines on demand, then the current inventory-code match when available.\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, three bounded live lists, full same-row Details and two actual lazy actions (order to lines, line to current inventory item). 52 order, 38 line and 19 current-item useful Detail positions; identity/context tokens hidden. Native mandatory order-date period before the final 2,000 root cap; child caps 500. Search/local filters apply to loaded rows only. No widgets, computed totals, writes or periodic refresh. Existing workspace resources count. A cap is not a query-performance guarantee.\n\nSCOPE: current Sosord/Sostrs documents only. Quotes, held/cancelled and unknown native values are not silently excluded or reclassified. The lquote name and its historical manual wording conflict: wording says marked for order, unmarked for quote. KEEP THE NATIVE FLAG; no guessed 0/1 order/quote label or filter. Verify installed behavior. Period is recorded dorder, not creation, quote, delivery or payment date; NULL order dates cannot enter a chosen date period. No automatic history, blanket/recurring order or shipment-table union; no promise of complete archive, invoice, delivery tracking or payment execution.\n\nRECORDED CONTEXT: bill-to and ship-to data, salesperson, shipping/warehouse/payment codes, requested line dates, description, specifications, unit and prices are recorded document values, not replaced by current customer/product masters. Non-stock/service and orphan lines remain. Current inventory child is only an optional unique code match; verify the native line stock flag. It is NOT proof a non-stock line originally used that inventory master. Missing/ambiguous matches leave recorded lines intact and an empty child is not proof of no original product.\n\nQUANTITIES: ordered, shipped, advanced-billing and built quantities are separate exact source values. Both base/transaction-unit factors are retained, not applied. No remaining, stock, availability, weight-unit, conversion or completion calculation. Sequence alone sorts numerically; money/quantities/flags stay source text with textual local filtering/sorting.\n\nMONEY: foreign unit prices, subtotal, discount, freight, adjustments and three tax amounts are read separately, never recomputed, summed or added twice. Line foreign values display the owning recorded order currency context; no own line-currency column is invented. No ISO code, base currency or exchange-rate direction is assumed. Current item price/cost has UNVERIFIED currency and unit basis and is not the order price. Zero, negative, NULL and unknown source values remain distinct. Verify semantics before financial decisions.\n\nNOTES: optional unique order/line-owned remarks; missing/ambiguous notes neither drop nor multiply a document/line. Notes are explicitly previews of the first 4,000 characters, NOT guaranteed complete original text. Free text may contain private information; grant access only when authorised. No bank, check, credit-card, cardholder/expiry or password fields selected.\n\nIDENTITY: own csono order key within the authorised companyDB, full cuid line identity; clineitem is a hidden reference, not a global primary key. Root missing/blank/ambiguous order identities are excluded. Recorded customer NULL/blank is not a reason to invent a master or drop the root: line membership checks the exact NULL-aware customer token plus full order. Missing/blank/ambiguous matching line UID blocks the WHOLE line branch, not partial arbitrary selection. Revalidate full order/customer/currency/date/native flags before lines, and line/item/warehouse/unit/request-date/stock/specification tokens before inventory child. Encoded UTF16 context preserves whitespace/Unicode and NULL versus blank through app trimming.\n\nCOMPATIBILITY: historical AccountMate 12 SQL/Express SO and separate IC12 item proof, 15 February 2021. Not Enterprise/current SQL14 certification. Required/AMTBL widths are entry metadata, not installed DDL or NOT NULL. SQL Server 2012+ for CONCAT. Owner is UNKNOWN: administrator confirms exactly one readable Sosord/Sostrs/Sosork/Sotrmk/Icitem resolved identically by Android/iOS login/default schema. Android metadata may prefer dbo while iOS queries use default resolution; import is NOT claimed to automatically reject duplicate owners. Confirm/qualify objects in Studio and repeat bounded read tests. Check installed edition/fields/types/full keys/collation/indexes/SQL cost, date/decimal/NULL conversion and currency/unit semantics. Documentary and adapted SQLite synthetic checks are NOT real ERP, native SQL Server, iOS, performance, security or purchase-entitlement certification.\n\nSECURITY: company-authorised least-privilege SELECT reporting connection. Direct SQL does not inherit ERP ACL; filters are not permissions. Package has no credentials, server address or business rows. Unofficial, not endorsed by AccountMate.\n\nDocumentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_so_drg.pdf\nhttps://www.accountmateportal.com/xasset/techdoc/amsql12_ic_drg.pdf\n\nGallery: Eight original native Cifru DEMO images show complete recorded-order, recorded-line and current-inventory cards, both actually traversed nested actions and representative Details. All values are invented; no AccountMate installation was connected. The configuration retains 109 useful Detail positions (52 order, 38 line, 19 current item); their nonblank values are checked in full private overlapping native continuations. This is a representative gallery, not a claim that eight images show every configured field. Recorded bill/ship addresses, contacts, dates, codes, notes and further context remain in the JSON and private continuations; no field was removed or screenshot retouched to fit eight. The ambiguous historical order/quote flag is kept raw, never guessed into an enum or silently filtered. Source ordered, shipped, advanced-billing and built quantities and unit factors remain distinct, with no remaining/stock/availability calculation. Foreign monetary fields are separate source values in the owning recorded order currency; current inventory price/cost has unverified currency and unit basis and is not the historic order price. Notes are explicit first 4,000-character previews, not claimed complete text. Optional absent/ambiguous notes and item matches do not drop or multiply recorded rows. 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, redundant continuations and the incomplete R2 take are private and not video-approved. Pro requirements were checked; capture uses a Pro test entitlement, not a purchase test. This proves native synthetic UI/action traversal plus adapted reference query intent, not real ERP, SQLServer/iOS/current edition/DDL/owner/collation, connector conversion, ISO currency/FX/unit conventions, source ACL, financial reconciliation, archive completeness or performance.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "6636CE14-5F33-5E7E-AA23-E8D7F17DC99B",
"rootButtonCount": 1,
"summary": "Choose an order-date period; inspect recorded shipping, source amounts and notes, then lines and optional current item details.",
"tags": [
"AccountMate",
"SQL Server",
"Sales",
"Customer orders",
"Order lines",
"Warehouse",
"Pro"
],
"title": "Customer orders, recorded lines and current inventory item — Pro"
}
}