Purchase orders, recorded lines and supplier — Pro
Choose an order-date period; inspect delivery details, source costs and quantities, then recorded lines and the current supplier.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.
For purchasing, warehouse teams and managers: choose the order-date period, inspect recorded supplier and delivery details, source costs, quantities, payment terms and notes. Open the recorded purchase lines or the current supplier dossier only when you need them.
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, grouped Details and two lazy sub-buttons. 66 order, 31 line and 27 current-supplier useful Detail positions; technical identity/context tokens hidden. Mandatory native order-date period before the 2,000 root cap; children capped at 500. Local search/filters cover loaded rows. No widgets, computed totals, writes or periodic refresh. Existing workspace resources count. A cap is not a query-performance guarantee.
RECORDED ORDER: current Popord/Poptrs documents, including native quote/cancelled/unknown values without silent exclusion. Keep the native Order or Quote flag: PO documentation does not give a complete 0/1 legend; do not copy SO wording. Period means recorded dorder, not creation, requested, receipt, quote or payment date. NULL dates cannot enter a date period. No automatic history, blanket-order, receipt/cancellation or accrual/matching union. No promise of complete archive, receipts, invoices, payments or order completion.
USEFUL CONTEXT: recorded revision, buyer, entered/confirmed-by, order-from/ship-to contacts and addresses, shipping/warehouse/payment/tax codes, requested dates, vendor parts, specifications, unit and costs remain document values, not current master snapshots. Non-stock/service and orphan lines remain without requiring a current inventory item.
QUANTITIES AND MONEY: ordered and received quantities, both unit factors, foreign costs, subtotal/discount/freight and ordinary/freight tax amounts are separate source values, never summed or recomputed. No remaining, stock, availability, conversion, tax total, FX or financial reconciliation. Received quantity and invoiced/freight-charged amounts are not complete receipt, invoice or payment logs. Line foreign values use owning recorded order currency; no own line-currency column is invented. No ISO code, base currency or exchange-rate direction assumed. Current supplier currency never replaces recorded order currency. Source values/flags stay exact text, with textual local sorting/filtering; sequence alone is numeric. Zero, negative, NULL and unknown remain distinct. Verify semantics before financial decisions.
NOTES: optional unique Popork order note, explicitly a preview of the first 4,000 characters, NOT guaranteed complete text. Missing/ambiguous notes do not drop or multiply orders. Potrmk line-note join is NOT included: its own cuid/order fields do not prove equality with Poptrs.cuid. No guessed UID join or all-order notes repeated per line. Free text and contacts may be confidential; grant access only when authorised.
CURRENT SUPPLIER: optional child requires one unique current Apvend match, not an order snapshot. Missing/ambiguous suppliers leave orders and lines intact; an empty child is not proof of no original supplier. Contacts, address, class, purchasing/payment codes and currency are current master values. An explicit context distinguishes current supplier versus order currency, without conversion. No bank, check, credit-card, password or tax identifier selected.
IDENTITY AND ACCESS: company-owned cpono order key, full cuid line identity; line/SO references and sequence are not primary keys. Eleven encoded order/vendor/currency/full-date/revision/native-flag/warehouse context values are revalidated before both children. NULL-aware vendor membership retains rows without inventing a master. Missing/blank/ambiguous matching line UID blocks the WHOLE line branch, not partial arbitrary selection. Encoded UTF16 context preserves NULL/blank, spaces and Unicode through app trimming. Reference account is ERP permission-gated in the manual: direct SQL does not inherit ERP ACL. Only explicitly authorised least-privilege SELECT reporting access; filters are not permissions.
COMPATIBILITY: historical AccountMate 12 SQL/Express PO, 15 February 2021, plus the separately verified AP12 supplier contract. Not Enterprise/current SQL14 certification. Required/AMTBL widths are entry metadata, not installed DDL/NOT NULL. SQL Server 2012+ for CONCAT. Owner is UNKNOWN: administrator confirms exactly one readable Popord/Poptrs/Popork/Apvend 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 reads. Check installed edition, keys/types/collation/indexes/SQL cost, date/decimal/NULL conversions and currency/unit conventions. Documentary and adapted synthetic checks are NOT real ERP, native SQL Server, iOS, security, performance or purchase-entitlement certification. No credentials, server address or business rows in the package. Unofficial, not endorsed by AccountMate.
Documentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_po_drg.pdf
https://www.accountmateportal.com/xasset/techdoc/amsql12_ap_drg.pdf
Gallery: Eight original native Cifru DEMO images show complete purchase-order, recorded-line and current-supplier cards, both actually traversed root sub-buttons and representative Details. All values are invented; no AccountMate installation was connected. The configuration retains 124 useful Detail positions (66 order, 31 recorded line, 27 current supplier), checked in full private overlapping native continuations. This is a representative gallery, not a claim that eight images show every configured field. Recorded supplier/delivery contacts and addresses, dates, codes, native flags and additional source amounts remain in the JSON and private continuations; no field was removed or screenshot retouched to fit eight. Quote/cancellation values remain native without guessed enums or silent exclusion. Ordered/received quantities and both unit factors remain distinct; no remaining, stock, availability or unit-conversion formula. Foreign costs, subtotals, discounts, freight and taxes are separate source values in the recorded owning-order currency, not a computed total. Current supplier data and currency are not a historical order snapshot and never replace order values. Received quantity and invoiced amount are not complete receipt, invoice or payment logs. Order notes are explicit first 4,000-character previews, not complete-text claims. The unproved Potrmk line-note UID join is excluded; missing/ambiguous optional notes or suppliers do not drop or multiply documents. Reference-account access requires explicitly authorised reporting: direct SQL does not inherit ERP permissions. Original PNG/XML pairs, frozen invented input and silent RAW are retained for future videos; whole RAW/Home, the native opening summary internal last7Days label and redundant continuations are private and not video-approved. Pro requirements were checked; capture uses a Pro test entitlement, not a purchase test. This proves native synthetic UI/action traversal and constrained adapted query intent, not real ERP, SQLServer/iOS/current edition/DDL/owner/collation, connector conversion, ISO currency/FX/unit conventions, ACL, reconciliation, archive completeness or performance.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Purchase orders
- Details: Recorded purchase lines
- Details: Current supplier
- Sub-button: Recorded purchase lines
- Sub-button: Current supplier
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS OrderKey, CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS OrderToken, CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AS VendorToken, CASE WHEN h.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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.drequest, 126) AS nvarchar(max))), 2)) END AS RequestDateToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.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 QuoteToken, 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.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN h.lmatch IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lmatch AS nvarchar(max))), 2)) END AS MatchingToken, CASE WHEN h.ldropship IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ldropship AS nvarchar(max))), 2)) END AS DropShipToken, CAST(h.cpono AS nvarchar(max)) AS cpono, CAST(h.crevision AS nvarchar(max)) AS crevision, CAST(h.cvendno AS nvarchar(max)) AS cvendno, CAST(h.cbuyer AS nvarchar(max)) AS cbuyer, CAST(h.centerby AS nvarchar(max)) AS centerby, CAST(h.cconfirmto AS nvarchar(max)) AS cconfirmto, CAST(h.cshortrmk AS nvarchar(max)) AS cshortrmk, CAST(h.cocompany AS nvarchar(max)) AS cocompany, CAST(h.coaddr1 AS nvarchar(max)) AS coaddr1, CAST(h.coaddr2 AS nvarchar(max)) AS coaddr2, CAST(h.cocity AS nvarchar(max)) AS cocity, CAST(h.costate AS nvarchar(max)) AS costate, CAST(h.cozip AS nvarchar(max)) AS cozip, CAST(h.cocountry AS nvarchar(max)) AS cocountry, CAST(h.cophone AS nvarchar(max)) AS cophone, CAST(h.cocontact AS nvarchar(max)) AS cocontact, CAST(h.coemail AS nvarchar(max)) AS coemail, 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.cshipvia AS nvarchar(max)) AS cshipvia, CAST(h.cfob AS nvarchar(max)) AS cfob, CAST(h.csono AS nvarchar(max)) AS csono, CAST(h.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(h.cfrgtcode AS nvarchar(max)) AS cfrgtcode, CAST(h.cfrtaxcode AS nvarchar(max)) AS cfrtaxcode, CAST(h.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(h.cpaycode AS nvarchar(max)) AS cpaycode, CAST(h.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(h.cbpono AS nvarchar(max)) AS cbpono, CONVERT(varchar(10), h.dorder, 23) AS dorder, CONVERT(varchar(10), h.drequest, 23) AS drequest, CONVERT(varchar(10), h.dquoteaprv, 23) AS dquoteaprv, CAST(h.laccrue AS nvarchar(max)) AS laccrue, CAST(h.lquote AS nvarchar(max)) AS lquote, CAST(h.lvoid AS nvarchar(max)) AS lvoid, CAST(h.lnobo AS nvarchar(max)) AS lnobo, CAST(h.lapplytax AS nvarchar(max)) AS lapplytax, CAST(h.lcstinctax AS nvarchar(max)) AS lcstinctax, CAST(h.lusepartno AS nvarchar(max)) AS lusepartno, CAST(h.lmatch AS nvarchar(max)) AS lmatch, CAST(h.ldropship AS nvarchar(max)) AS ldropship, CAST(h.ndiscday AS nvarchar(max)) AS ndiscday, CAST(h.ndueday AS nvarchar(max)) AS ndueday, CAST(h.ntermdisc AS nvarchar(max)) AS ntermdisc, CAST(h.ndiscrate AS nvarchar(max)) AS ndiscrate, CAST(h.nforderamt AS nvarchar(max)) AS nforderamt, CAST(h.nfdiscamt AS nvarchar(max)) AS nfdiscamt, CAST(h.nffrtamt AS nvarchar(max)) AS nffrtamt, CAST(h.nftaxamt1 AS nvarchar(max)) AS nftaxamt1, CAST(h.nftaxamt2 AS nvarchar(max)) AS nftaxamt2, CAST(h.nftaxamt3 AS nvarchar(max)) AS nftaxamt3, CAST(h.nffrttax1 AS nvarchar(max)) AS nffrttax1, CAST(h.nffrttax2 AS nvarchar(max)) AS nffrttax2, CAST(h.nffrttax3 AS nvarchar(max)) AS nffrttax3, CAST(h.nffrtamtch AS nvarchar(max)) AS nffrtamtch, CAST(h.nfpoinvamt AS nvarchar(max)) AS nfpoinvamt, CAST(h.nxchgrate AS nvarchar(max)) AS nxchgrate, COALESCE(NULLIF(h.cocompany,N''),NULLIF(h.cvendno,N''),N'Unknown recorded supplier') AS OrderPartyLabel, LEFT(CAST(onote.mremark AS nvarchar(max)), 4000) AS OrderRemark, CASE WHEN onote.cpono IS NULL THEN N'No unique retained order note; absence is not proof of no original note' ELSE N'Unique retained order note; preview first 4,000 characters only, inspect source for full text' END AS OrderNoteContext FROM Popord h LEFT JOIN Popork onote ON onote.cpono=h.cpono AND CASE WHEN onote.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(onote.cpono AS nvarchar(max))), 2)) END=CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Popork nq WHERE nq.cpono=onote.cpono) WHERE h.cpono IS NOT NULL AND h.cpono<>N'' AND DATALENGTH(CAST(h.cpono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Popord hq WHERE hq.cpono=h.cpono)
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS OrderToken, CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AS VendorToken, CASE WHEN h.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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.drequest, 126) AS nvarchar(max))), 2)) END AS RequestDateToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.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 QuoteToken, 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.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN h.lmatch IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lmatch AS nvarchar(max))), 2)) END AS MatchingToken, CASE WHEN h.ldropship IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ldropship AS nvarchar(max))), 2)) END AS DropShipToken, CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono 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, CAST(l.cpono AS nvarchar(max)) AS cpono, CAST(l.cvendno AS nvarchar(max)) AS cvendno, CAST(l.cwarehouse AS nvarchar(max)) AS cwarehouse, 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.cpartno AS nvarchar(max)) AS cpartno, CAST(l.cmeasure AS nvarchar(max)) AS cmeasure, CAST(l.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(l.crefacct AS nvarchar(max)) AS crefacct, CONVERT(varchar(10), l.drequest, 23) AS drequest, CAST(l.lstock AS nvarchar(max)) AS lstock, CAST(l.lpartno AS nvarchar(max)) AS lpartno, CAST(l.ltaxable1 AS nvarchar(max)) AS ltaxable1, CAST(l.ltaxable2 AS nvarchar(max)) AS ltaxable2, CAST(l.nqtydec AS nvarchar(max)) AS nqtydec, CAST(l.ndiscrate AS nvarchar(max)) AS ndiscrate, CAST(l.nforderamt AS nvarchar(max)) AS nforderamt, CAST(l.nfdiscamt AS nvarchar(max)) AS nfdiscamt, CAST(l.nftaxamt1 AS nvarchar(max)) AS nftaxamt1, CAST(l.nftaxamt2 AS nvarchar(max)) AS nftaxamt2, CAST(l.nftaxamt3 AS nvarchar(max)) AS nftaxamt3, CAST(l.nordqty AS nvarchar(max)) AS nordqty, CAST(l.nrecqty AS nvarchar(max)) AS nrecqty, CAST(l.nitmcnvqty AS nvarchar(max)) AS nitmcnvqty, CAST(l.ntrscnvqty AS nvarchar(max)) AS ntrscnvqty, CAST(l.nfcost AS nvarchar(max)) AS nfcost, CAST(l.nfcstinctx AS nvarchar(max)) AS nfcstinctx, CAST(l.nseq AS nvarchar(max)) AS nseq, CAST(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode FROM Popord h INNER JOIN Poptrs l ON l.cpono=h.cpono AND CASE WHEN l.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cpono AS nvarchar(max))), 2)) END=CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AND CASE WHEN l.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cvendno AS nvarchar(max))), 2)) END=CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END WHERE h.cpono=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:order, 2, 2147483647), 2)) AND h.cpono IS NOT NULL AND h.cpono<>N'' AND DATALENGTH(CAST(h.cpono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Popord hq WHERE hq.cpono=h.cpono) AND CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END=:order AND CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END=:vendor AND CASE WHEN h.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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.drequest, 126) AS nvarchar(max))), 2)) END=:request_date AND CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END=:revision AND CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END=:quote 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.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cwarehouse AS nvarchar(max))), 2)) END=:warehouse AND CASE WHEN h.lmatch IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lmatch AS nvarchar(max))), 2)) END=:matching AND CASE WHEN h.ldropship IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ldropship AS nvarchar(max))), 2)) END=:drop_ship AND NOT EXISTS (SELECT 1 FROM Poptrs lx WHERE lx.cpono=h.cpono AND CASE WHEN lx.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.cpono AS nvarchar(max))), 2)) END=CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AND CASE WHEN lx.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.cvendno AS nvarchar(max))), 2)) END=CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AND (lx.cuid IS NULL OR lx.cuid=N'' OR DATALENGTH(CAST(lx.cuid AS nvarchar(max)))=0 OR 1<>(SELECT COUNT(*) FROM Poptrs lq WHERE lq.cuid=lx.cuid)))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS OrderToken, CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AS VendorToken, CASE WHEN h.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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.drequest, 126) AS nvarchar(max))), 2)) END AS RequestDateToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.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 QuoteToken, 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.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN h.lmatch IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lmatch AS nvarchar(max))), 2)) END AS MatchingToken, CASE WHEN h.ldropship IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ldropship AS nvarchar(max))), 2)) END AS DropShipToken, CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END,N':',CASE WHEN v.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(v.cvendno AS nvarchar(max))), 2)) END) AS SupplierKey, CAST(v.cvendno AS nvarchar(max)) AS cvendno, CAST(v.ccompany AS nvarchar(max)) AS ccompany, CAST(v.ccompany2 AS nvarchar(max)) AS ccompany2, CAST(v.cvcustno AS nvarchar(max)) AS cvcustno, CAST(v.cref AS nvarchar(max)) AS cref, CAST(v.cfname AS nvarchar(max)) AS cfname, CAST(v.clname AS nvarchar(max)) AS clname, CAST(v.cphone1 AS nvarchar(max)) AS cphone1, CAST(v.cphone2 AS nvarchar(max)) AS cphone2, CAST(v.cemail AS nvarchar(max)) AS cemail, CAST(v.cwebsite AS nvarchar(max)) AS cwebsite, CAST(v.caddr1 AS nvarchar(max)) AS caddr1, CAST(v.caddr2 AS nvarchar(max)) AS caddr2, CAST(v.ccity AS nvarchar(max)) AS ccity, CAST(v.cstate AS nvarchar(max)) AS cstate, CAST(v.czip AS nvarchar(max)) AS czip, CAST(v.ccountry AS nvarchar(max)) AS ccountry, CAST(v.cstatus AS nvarchar(max)) AS cstatus, CAST(v.cclass AS nvarchar(max)) AS cclass, CAST(v.cbuyer AS nvarchar(max)) AS cbuyer, CAST(v.cpaycode AS nvarchar(max)) AS cpaycode, CAST(v.cpayurgenc AS nvarchar(max)) AS cpayurgenc, CAST(v.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(v.cpaytono AS nvarchar(max)) AS cpaytono, CAST(v.cordfrno AS nvarchar(max)) AS cordfrno, CAST(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode, CASE WHEN v.ccurrcode IS NULL OR h.ccurrcode IS NULL OR v.ccurrcode=N'' OR h.ccurrcode=N'' THEN N'Unknown current supplier or recorded order currency; not an order snapshot' WHEN CASE WHEN v.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(v.ccurrcode AS nvarchar(max))), 2)) END=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 THEN N'Current supplier; same currency code, not order snapshot' ELSE N'Current supplier currency differs from recorded order; do not substitute or convert' END AS SupplierContext FROM Popord h INNER JOIN Apvend v ON v.cvendno=h.cvendno AND CASE WHEN v.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(v.cvendno AS nvarchar(max))), 2)) END=CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Apvend vq WHERE vq.cvendno=v.cvendno) WHERE h.cpono=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:order, 2, 2147483647), 2)) AND h.cpono IS NOT NULL AND h.cpono<>N'' AND DATALENGTH(CAST(h.cpono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Popord hq WHERE hq.cpono=h.cpono) AND CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END=:order AND CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END=:vendor AND CASE WHEN h.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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.drequest, 126) AS nvarchar(max))), 2)) END=:request_date AND CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END=:revision AND CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END=:quote 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.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cwarehouse AS nvarchar(max))), 2)) END=:warehouse AND CASE WHEN h.lmatch IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lmatch AS nvarchar(max))), 2)) END=:matching AND CASE WHEN h.ldropship IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ldropship AS nvarchar(max))), 2)) END=:drop_ship
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "AccountMate SQL/Express — authorised company database",
"id": "037FC506-905F-5615-8C03-9AF24371D7E7",
"kind": "sqlServer",
"requiredObjects": [
"Popord",
"Poptrs",
"Popork",
"Apvend"
],
"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": "AA162097-A970-5556-952B-DB0B91D65180",
"mappings": [
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Hidden full company purchase-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": "VendorToken",
"label": "Hidden order context vendor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorToken",
"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": "RequestDateToken",
"label": "Hidden order context request_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RequestDateToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RevisionToken",
"label": "Hidden order context revision",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RevisionToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QuoteToken",
"label": "Hidden order context quote",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QuoteToken",
"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": "WarehouseToken",
"label": "Hidden order context warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WarehouseToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MatchingToken",
"label": "Hidden order context matching",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MatchingToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DropShipToken",
"label": "Hidden order context drop_ship",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DropShipToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpono",
"label": "Purchase order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpono",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "crevision",
"label": "Recorded revision",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "crevision",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cvendno",
"label": "Recorded 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": "centerby",
"label": "Entered by",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "centerby",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cconfirmto",
"label": "Confirmed to",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cconfirmto",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cshortrmk",
"label": "Short remark",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cshortrmk",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cocompany",
"label": "Recorded order-from company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cocompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "coaddr1",
"label": "Order-from address 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "coaddr1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "coaddr2",
"label": "Order-from address 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "coaddr2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cocity",
"label": "Order-from city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cocity",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "costate",
"label": "Order-from state or region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "costate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cozip",
"label": "Order-from postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cozip",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cocountry",
"label": "Order-from country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cocountry",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cophone",
"label": "Order-from phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cophone",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cocontact",
"label": "Order-from contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cocontact",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "coemail",
"label": "Order-from email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "coemail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cscompany",
"label": "Recorded ship-to company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cscompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csaddr1",
"label": "Ship-to address 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csaddr1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "csaddr2",
"label": "Ship-to address 2",
"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 or 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": "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": "csono",
"label": "Customer sales-order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csono",
"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": "cfrgtcode",
"label": "Freight code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfrgtcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cfrtaxcode",
"label": "Freight tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfrtaxcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ctaxcode",
"label": "Sales 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": "cbpono",
"label": "Blanket purchase-order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbpono",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dorder",
"label": "Recorded order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dorder",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "drequest",
"label": "Recorded requested date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "drequest",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "dquoteaprv",
"label": "Recorded quote approval date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dquoteaprv",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "laccrue",
"label": "Accrued received-goods native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "laccrue",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lquote",
"label": "Order or quote native flag — verify semantics",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lquote",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lvoid",
"label": "Cancelled native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lvoid",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "lnobo",
"label": "No-backorder native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lnobo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lapplytax",
"label": "Apply-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lapplytax",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lcstinctax",
"label": "Cost-includes-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lcstinctax",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lusepartno",
"label": "Use vendor part number native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lusepartno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lmatch",
"label": "AP/PO matching native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lmatch",
"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": "ndiscday",
"label": "Terms discount days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ndiscday",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ndueday",
"label": "Terms net days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ndueday",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ntermdisc",
"label": "Terms discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ntermdisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ndiscrate",
"label": "Recorded order discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ndiscrate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nforderamt",
"label": "Recorded foreign subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nforderamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nfdiscamt",
"label": "Recorded foreign discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfdiscamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nffrtamt",
"label": "Recorded foreign freight",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nffrtamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt1",
"label": "Recorded foreign tax amount 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt2",
"label": "Recorded foreign tax amount 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt3",
"label": "Recorded foreign tax amount 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nffrttax1",
"label": "Recorded foreign freight tax 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nffrttax1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nffrttax2",
"label": "Recorded foreign freight tax 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nffrttax2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nffrttax3",
"label": "Recorded foreign freight tax 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nffrttax3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nffrtamtch",
"label": "Recorded foreign freight amount charged",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nffrtamtch",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfpoinvamt",
"label": "Recorded foreign invoiced amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfpoinvamt",
"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 order-from 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": "Purchase orders",
"primaryKey": "OrderKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cpono",
"crevision",
"cvendno",
"cbuyer",
"centerby",
"cconfirmto",
"cshortrmk",
"cocompany",
"coaddr1",
"coaddr2",
"cocity",
"costate",
"cozip",
"cocountry",
"cophone",
"cocontact",
"coemail",
"cscompany",
"csaddr1",
"csaddr2",
"cscity",
"csstate",
"cszip",
"cscountry",
"csphone",
"cscontact",
"cshipvia",
"cfob",
"csono",
"cwarehouse",
"cfrgtcode",
"cfrtaxcode",
"ctaxcode",
"cpaycode",
"ccurrcode",
"cbpono",
"laccrue",
"lquote",
"lvoid",
"lnobo",
"lapplytax",
"lcstinctax",
"lusepartno",
"lmatch",
"ldropship",
"ndiscday",
"ndueday",
"ntermdisc",
"ndiscrate",
"nforderamt",
"nfdiscamt",
"nffrtamt",
"nftaxamt1",
"nftaxamt2",
"nftaxamt3",
"nffrttax1",
"nffrttax2",
"nffrttax3",
"nffrtamtch",
"nfpoinvamt",
"nxchgrate",
"OrderRemark",
"OrderNoteContext"
],
"sourceID": "037FC506-905F-5615-8C03-9AF24371D7E7",
"sqlQuery": "SELECT CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS OrderKey, CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS OrderToken, CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AS VendorToken, CASE WHEN h.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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.drequest, 126) AS nvarchar(max))), 2)) END AS RequestDateToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.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 QuoteToken, 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.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN h.lmatch IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lmatch AS nvarchar(max))), 2)) END AS MatchingToken, CASE WHEN h.ldropship IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ldropship AS nvarchar(max))), 2)) END AS DropShipToken, CAST(h.cpono AS nvarchar(max)) AS cpono, CAST(h.crevision AS nvarchar(max)) AS crevision, CAST(h.cvendno AS nvarchar(max)) AS cvendno, CAST(h.cbuyer AS nvarchar(max)) AS cbuyer, CAST(h.centerby AS nvarchar(max)) AS centerby, CAST(h.cconfirmto AS nvarchar(max)) AS cconfirmto, CAST(h.cshortrmk AS nvarchar(max)) AS cshortrmk, CAST(h.cocompany AS nvarchar(max)) AS cocompany, CAST(h.coaddr1 AS nvarchar(max)) AS coaddr1, CAST(h.coaddr2 AS nvarchar(max)) AS coaddr2, CAST(h.cocity AS nvarchar(max)) AS cocity, CAST(h.costate AS nvarchar(max)) AS costate, CAST(h.cozip AS nvarchar(max)) AS cozip, CAST(h.cocountry AS nvarchar(max)) AS cocountry, CAST(h.cophone AS nvarchar(max)) AS cophone, CAST(h.cocontact AS nvarchar(max)) AS cocontact, CAST(h.coemail AS nvarchar(max)) AS coemail, 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.cshipvia AS nvarchar(max)) AS cshipvia, CAST(h.cfob AS nvarchar(max)) AS cfob, CAST(h.csono AS nvarchar(max)) AS csono, CAST(h.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(h.cfrgtcode AS nvarchar(max)) AS cfrgtcode, CAST(h.cfrtaxcode AS nvarchar(max)) AS cfrtaxcode, CAST(h.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(h.cpaycode AS nvarchar(max)) AS cpaycode, CAST(h.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(h.cbpono AS nvarchar(max)) AS cbpono, CONVERT(varchar(10), h.dorder, 23) AS dorder, CONVERT(varchar(10), h.drequest, 23) AS drequest, CONVERT(varchar(10), h.dquoteaprv, 23) AS dquoteaprv, CAST(h.laccrue AS nvarchar(max)) AS laccrue, CAST(h.lquote AS nvarchar(max)) AS lquote, CAST(h.lvoid AS nvarchar(max)) AS lvoid, CAST(h.lnobo AS nvarchar(max)) AS lnobo, CAST(h.lapplytax AS nvarchar(max)) AS lapplytax, CAST(h.lcstinctax AS nvarchar(max)) AS lcstinctax, CAST(h.lusepartno AS nvarchar(max)) AS lusepartno, CAST(h.lmatch AS nvarchar(max)) AS lmatch, CAST(h.ldropship AS nvarchar(max)) AS ldropship, CAST(h.ndiscday AS nvarchar(max)) AS ndiscday, CAST(h.ndueday AS nvarchar(max)) AS ndueday, CAST(h.ntermdisc AS nvarchar(max)) AS ntermdisc, CAST(h.ndiscrate AS nvarchar(max)) AS ndiscrate, CAST(h.nforderamt AS nvarchar(max)) AS nforderamt, CAST(h.nfdiscamt AS nvarchar(max)) AS nfdiscamt, CAST(h.nffrtamt AS nvarchar(max)) AS nffrtamt, CAST(h.nftaxamt1 AS nvarchar(max)) AS nftaxamt1, CAST(h.nftaxamt2 AS nvarchar(max)) AS nftaxamt2, CAST(h.nftaxamt3 AS nvarchar(max)) AS nftaxamt3, CAST(h.nffrttax1 AS nvarchar(max)) AS nffrttax1, CAST(h.nffrttax2 AS nvarchar(max)) AS nffrttax2, CAST(h.nffrttax3 AS nvarchar(max)) AS nffrttax3, CAST(h.nffrtamtch AS nvarchar(max)) AS nffrtamtch, CAST(h.nfpoinvamt AS nvarchar(max)) AS nfpoinvamt, CAST(h.nxchgrate AS nvarchar(max)) AS nxchgrate, COALESCE(NULLIF(h.cocompany,N''),NULLIF(h.cvendno,N''),N'Unknown recorded supplier') AS OrderPartyLabel, LEFT(CAST(onote.mremark AS nvarchar(max)), 4000) AS OrderRemark, CASE WHEN onote.cpono IS NULL THEN N'No unique retained order note; absence is not proof of no original note' ELSE N'Unique retained order note; preview first 4,000 characters only, inspect source for full text' END AS OrderNoteContext FROM Popord h LEFT JOIN Popork onote ON onote.cpono=h.cpono AND CASE WHEN onote.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(onote.cpono AS nvarchar(max))), 2)) END=CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Popork nq WHERE nq.cpono=onote.cpono) WHERE h.cpono IS NOT NULL AND h.cpono<>N'' AND DATALENGTH(CAST(h.cpono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Popord hq WHERE hq.cpono=h.cpono)",
"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": "9A20CEDE-035D-50C1-B2ED-8D7ABACBA1AD",
"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": "cpono",
"label": "Purchase order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpono",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cvendno",
"label": "Recorded line vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cvendno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cwarehouse",
"label": "Recorded line warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cwarehouse",
"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 code 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cspeccode1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cspeccode2",
"label": "Specification code 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cspeccode2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cdescript",
"label": "Recorded line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cdescript",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpartno",
"label": "Recorded vendor part number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpartno",
"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": "ctaxcode",
"label": "Recorded line tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ctaxcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "crefacct",
"label": "Recorded reference account — authorised reporting only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "crefacct",
"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": "lstock",
"label": "Stock-item native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lstock",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lpartno",
"label": "Vendor-part native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lpartno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ltaxable1",
"label": "Taxable 1 native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ltaxable1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ltaxable2",
"label": "Taxable 2 native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ltaxable2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nqtydec",
"label": "Recorded quantity decimal places",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nqtydec",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ndiscrate",
"label": "Recorded line discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ndiscrate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nforderamt",
"label": "Recorded foreign line subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nforderamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfdiscamt",
"label": "Recorded foreign line discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfdiscamt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt1",
"label": "Recorded foreign line tax 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt2",
"label": "Recorded foreign line tax 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nftaxamt3",
"label": "Recorded foreign line tax 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nftaxamt3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nordqty",
"label": "Recorded ordered quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nordqty",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nrecqty",
"label": "Recorded received quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nrecqty",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nitmcnvqty",
"label": "Recorded base-unit factor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nitmcnvqty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ntrscnvqty",
"label": "Recorded transaction-unit factor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ntrscnvqty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nfcost",
"label": "Recorded foreign unit cost",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfcost",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nfcstinctx",
"label": "Recorded foreign unit cost plus tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nfcstinctx",
"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": "OrderToken",
"label": "Hidden order context order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorToken",
"label": "Hidden order context vendor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorToken",
"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": "RequestDateToken",
"label": "Hidden order context request_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RequestDateToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RevisionToken",
"label": "Hidden order context revision",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RevisionToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QuoteToken",
"label": "Hidden order context quote",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QuoteToken",
"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": "WarehouseToken",
"label": "Hidden order context warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WarehouseToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MatchingToken",
"label": "Hidden order context matching",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MatchingToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DropShipToken",
"label": "Hidden order context drop_ship",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DropShipToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Recorded purchase lines",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderToken",
"id": "01460F07-D7E2-521D-BFA0-952711BA8F54",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VendorToken",
"id": "C58012BD-0266-51AC-8A61-914391CA8747",
"name": "vendor",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CurrencyToken",
"id": "073ACA83-0390-5B41-8BDD-42D6E1767E77",
"name": "currency",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderDateToken",
"id": "5D3BF45D-FABA-5FE4-9B99-16D05D146AC7",
"name": "order_date",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "RequestDateToken",
"id": "0FD8C11F-3F98-5A11-97F1-19DC438BA4AA",
"name": "request_date",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "RevisionToken",
"id": "9BDD82F7-5627-584F-8074-415F6A1ABFFB",
"name": "revision",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "QuoteToken",
"id": "CAFFD2EA-DC8D-56D2-8E21-1BD37AA07752",
"name": "quote",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CancelledToken",
"id": "00DF9D19-E1F7-55BC-9196-C6862D7AEF55",
"name": "cancelled",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "WarehouseToken",
"id": "3DF95CF1-D1FE-5B74-8033-D52496C8A366",
"name": "warehouse",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "MatchingToken",
"id": "406CD6EA-7170-588B-824C-2D58F01845EA",
"name": "matching",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DropShipToken",
"id": "1BA11EB1-9959-50D1-96CE-E1D98057004D",
"name": "drop_ship",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cpono",
"cvendno",
"cwarehouse",
"citemno",
"cspeccode1",
"cspeccode2",
"cdescript",
"cpartno",
"cmeasure",
"ctaxcode",
"crefacct",
"lstock",
"lpartno",
"ltaxable1",
"ltaxable2",
"nqtydec",
"ndiscrate",
"nforderamt",
"nfdiscamt",
"nftaxamt1",
"nftaxamt2",
"nftaxamt3",
"nordqty",
"nrecqty",
"nitmcnvqty",
"ntrscnvqty",
"nfcost",
"nfcstinctx",
"nseq",
"ParentCurrencyCode"
],
"sourceID": "037FC506-905F-5615-8C03-9AF24371D7E7",
"sqlQuery": "SELECT CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS OrderToken, CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AS VendorToken, CASE WHEN h.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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.drequest, 126) AS nvarchar(max))), 2)) END AS RequestDateToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.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 QuoteToken, 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.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN h.lmatch IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lmatch AS nvarchar(max))), 2)) END AS MatchingToken, CASE WHEN h.ldropship IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ldropship AS nvarchar(max))), 2)) END AS DropShipToken, CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono 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, CAST(l.cpono AS nvarchar(max)) AS cpono, CAST(l.cvendno AS nvarchar(max)) AS cvendno, CAST(l.cwarehouse AS nvarchar(max)) AS cwarehouse, 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.cpartno AS nvarchar(max)) AS cpartno, CAST(l.cmeasure AS nvarchar(max)) AS cmeasure, CAST(l.ctaxcode AS nvarchar(max)) AS ctaxcode, CAST(l.crefacct AS nvarchar(max)) AS crefacct, CONVERT(varchar(10), l.drequest, 23) AS drequest, CAST(l.lstock AS nvarchar(max)) AS lstock, CAST(l.lpartno AS nvarchar(max)) AS lpartno, CAST(l.ltaxable1 AS nvarchar(max)) AS ltaxable1, CAST(l.ltaxable2 AS nvarchar(max)) AS ltaxable2, CAST(l.nqtydec AS nvarchar(max)) AS nqtydec, CAST(l.ndiscrate AS nvarchar(max)) AS ndiscrate, CAST(l.nforderamt AS nvarchar(max)) AS nforderamt, CAST(l.nfdiscamt AS nvarchar(max)) AS nfdiscamt, CAST(l.nftaxamt1 AS nvarchar(max)) AS nftaxamt1, CAST(l.nftaxamt2 AS nvarchar(max)) AS nftaxamt2, CAST(l.nftaxamt3 AS nvarchar(max)) AS nftaxamt3, CAST(l.nordqty AS nvarchar(max)) AS nordqty, CAST(l.nrecqty AS nvarchar(max)) AS nrecqty, CAST(l.nitmcnvqty AS nvarchar(max)) AS nitmcnvqty, CAST(l.ntrscnvqty AS nvarchar(max)) AS ntrscnvqty, CAST(l.nfcost AS nvarchar(max)) AS nfcost, CAST(l.nfcstinctx AS nvarchar(max)) AS nfcstinctx, CAST(l.nseq AS nvarchar(max)) AS nseq, CAST(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode FROM Popord h INNER JOIN Poptrs l ON l.cpono=h.cpono AND CASE WHEN l.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cpono AS nvarchar(max))), 2)) END=CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AND CASE WHEN l.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(l.cvendno AS nvarchar(max))), 2)) END=CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END WHERE h.cpono=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:order, 2, 2147483647), 2)) AND h.cpono IS NOT NULL AND h.cpono<>N'' AND DATALENGTH(CAST(h.cpono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Popord hq WHERE hq.cpono=h.cpono) AND CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END=:order AND CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END=:vendor AND CASE WHEN h.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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.drequest, 126) AS nvarchar(max))), 2)) END=:request_date AND CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END=:revision AND CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END=:quote 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.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cwarehouse AS nvarchar(max))), 2)) END=:warehouse AND CASE WHEN h.lmatch IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lmatch AS nvarchar(max))), 2)) END=:matching AND CASE WHEN h.ldropship IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ldropship AS nvarchar(max))), 2)) END=:drop_ship AND NOT EXISTS (SELECT 1 FROM Poptrs lx WHERE lx.cpono=h.cpono AND CASE WHEN lx.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.cpono AS nvarchar(max))), 2)) END=CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AND CASE WHEN lx.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(lx.cvendno AS nvarchar(max))), 2)) END=CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AND (lx.cuid IS NULL OR lx.cuid=N'' OR DATALENGTH(CAST(lx.cuid AS nvarchar(max)))=0 OR 1<>(SELECT COUNT(*) FROM Poptrs lq WHERE lq.cuid=lx.cuid)))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "A6D42344-8C77-5253-8134-D1D2A94ED2A7",
"key": "ccompany",
"type": "text"
},
{
"direction": "ascending",
"id": "ED8350F2-8ACE-5D71-BFE9-E224C8EE103B",
"key": "SupplierKey",
"type": "text"
}
],
"id": "8F04FD61-FE3D-58FA-B19F-6FD8CA5CB355",
"mappings": [
{
"commonFieldKey": "",
"key": "SupplierKey",
"label": "Hidden parent-owned supplier identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupplierKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentKey",
"label": "Hidden full parent identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cvendno",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cvendno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccompany",
"label": "Supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccompany2",
"label": "Supplier alias",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccompany2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cvcustno",
"label": "Our account code at supplier",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cvcustno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cref",
"label": "Supplier reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cref",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cfname",
"label": "Contact first name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfname",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "clname",
"label": "Contact last name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "clname",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cphone1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cphone1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cphone2",
"label": "Phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cphone2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cemail",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cemail",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cwebsite",
"label": "Website",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cwebsite",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "caddr1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "caddr1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "caddr2",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "caddr2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccity",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccity",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cstate",
"label": "State or region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cstate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "czip",
"label": "ZIP or postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "czip",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccountry",
"label": "Country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccountry",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cstatus",
"label": "Status code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cstatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cclass",
"label": "Supplier class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cclass",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cbuyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbuyer",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpaycode",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpaycode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cpayurgenc",
"label": "Payment urgency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpayurgenc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ccurrcode",
"label": "Supplier currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ccurrcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cpaytono",
"label": "Pay-to supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpaytono",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cordfrno",
"label": "Order-from address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cordfrno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentCurrencyCode",
"label": "Recorded owning-order currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentCurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierContext",
"label": "Current supplier context — not order snapshot",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupplierContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderToken",
"label": "Hidden order context order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorToken",
"label": "Hidden order context vendor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorToken",
"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": "RequestDateToken",
"label": "Hidden order context request_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RequestDateToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RevisionToken",
"label": "Hidden order context revision",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RevisionToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QuoteToken",
"label": "Hidden order context quote",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QuoteToken",
"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": "WarehouseToken",
"label": "Hidden order context warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WarehouseToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MatchingToken",
"label": "Hidden order context matching",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MatchingToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DropShipToken",
"label": "Hidden order context drop_ship",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DropShipToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Current supplier",
"primaryKey": "SupplierKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderToken",
"id": "01460F07-D7E2-521D-BFA0-952711BA8F54",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VendorToken",
"id": "C58012BD-0266-51AC-8A61-914391CA8747",
"name": "vendor",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CurrencyToken",
"id": "073ACA83-0390-5B41-8BDD-42D6E1767E77",
"name": "currency",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderDateToken",
"id": "5D3BF45D-FABA-5FE4-9B99-16D05D146AC7",
"name": "order_date",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "RequestDateToken",
"id": "0FD8C11F-3F98-5A11-97F1-19DC438BA4AA",
"name": "request_date",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "RevisionToken",
"id": "9BDD82F7-5627-584F-8074-415F6A1ABFFB",
"name": "revision",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "QuoteToken",
"id": "CAFFD2EA-DC8D-56D2-8E21-1BD37AA07752",
"name": "quote",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CancelledToken",
"id": "00DF9D19-E1F7-55BC-9196-C6862D7AEF55",
"name": "cancelled",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "WarehouseToken",
"id": "3DF95CF1-D1FE-5B74-8033-D52496C8A366",
"name": "warehouse",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "MatchingToken",
"id": "406CD6EA-7170-588B-824C-2D58F01845EA",
"name": "matching",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DropShipToken",
"id": "1BA11EB1-9959-50D1-96CE-E1D98057004D",
"name": "drop_ship",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cvendno",
"ccompany",
"ccompany2",
"cvcustno",
"cref",
"cfname",
"clname",
"cphone1",
"cphone2",
"cemail",
"cwebsite",
"caddr1",
"caddr2",
"ccity",
"cstate",
"czip",
"ccountry",
"cstatus",
"cclass",
"cbuyer",
"cpaycode",
"cpayurgenc",
"ccurrcode",
"cpaytono",
"cordfrno",
"ParentCurrencyCode",
"SupplierContext"
],
"sourceID": "037FC506-905F-5615-8C03-9AF24371D7E7",
"sqlQuery": "SELECT CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS OrderToken, CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AS VendorToken, CASE WHEN h.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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.drequest, 126) AS nvarchar(max))), 2)) END AS RequestDateToken, CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END AS RevisionToken, CASE WHEN h.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 QuoteToken, 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.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN h.lmatch IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lmatch AS nvarchar(max))), 2)) END AS MatchingToken, CASE WHEN h.ldropship IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ldropship AS nvarchar(max))), 2)) END AS DropShipToken, CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END,N':',CASE WHEN v.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(v.cvendno AS nvarchar(max))), 2)) END) AS SupplierKey, CAST(v.cvendno AS nvarchar(max)) AS cvendno, CAST(v.ccompany AS nvarchar(max)) AS ccompany, CAST(v.ccompany2 AS nvarchar(max)) AS ccompany2, CAST(v.cvcustno AS nvarchar(max)) AS cvcustno, CAST(v.cref AS nvarchar(max)) AS cref, CAST(v.cfname AS nvarchar(max)) AS cfname, CAST(v.clname AS nvarchar(max)) AS clname, CAST(v.cphone1 AS nvarchar(max)) AS cphone1, CAST(v.cphone2 AS nvarchar(max)) AS cphone2, CAST(v.cemail AS nvarchar(max)) AS cemail, CAST(v.cwebsite AS nvarchar(max)) AS cwebsite, CAST(v.caddr1 AS nvarchar(max)) AS caddr1, CAST(v.caddr2 AS nvarchar(max)) AS caddr2, CAST(v.ccity AS nvarchar(max)) AS ccity, CAST(v.cstate AS nvarchar(max)) AS cstate, CAST(v.czip AS nvarchar(max)) AS czip, CAST(v.ccountry AS nvarchar(max)) AS ccountry, CAST(v.cstatus AS nvarchar(max)) AS cstatus, CAST(v.cclass AS nvarchar(max)) AS cclass, CAST(v.cbuyer AS nvarchar(max)) AS cbuyer, CAST(v.cpaycode AS nvarchar(max)) AS cpaycode, CAST(v.cpayurgenc AS nvarchar(max)) AS cpayurgenc, CAST(v.ccurrcode AS nvarchar(max)) AS ccurrcode, CAST(v.cpaytono AS nvarchar(max)) AS cpaytono, CAST(v.cordfrno AS nvarchar(max)) AS cordfrno, CAST(h.ccurrcode AS nvarchar(max)) AS ParentCurrencyCode, CASE WHEN v.ccurrcode IS NULL OR h.ccurrcode IS NULL OR v.ccurrcode=N'' OR h.ccurrcode=N'' THEN N'Unknown current supplier or recorded order currency; not an order snapshot' WHEN CASE WHEN v.ccurrcode IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(v.ccurrcode AS nvarchar(max))), 2)) END=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 THEN N'Current supplier; same currency code, not order snapshot' ELSE N'Current supplier currency differs from recorded order; do not substitute or convert' END AS SupplierContext FROM Popord h INNER JOIN Apvend v ON v.cvendno=h.cvendno AND CASE WHEN v.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(v.cvendno AS nvarchar(max))), 2)) END=CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END AND 1=(SELECT COUNT(*) FROM Apvend vq WHERE vq.cvendno=v.cvendno) WHERE h.cpono=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:order, 2, 2147483647), 2)) AND h.cpono IS NOT NULL AND h.cpono<>N'' AND DATALENGTH(CAST(h.cpono AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Popord hq WHERE hq.cpono=h.cpono) AND CASE WHEN h.cpono IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cpono AS nvarchar(max))), 2)) END=:order AND CASE WHEN h.cvendno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cvendno AS nvarchar(max))), 2)) END=:vendor AND CASE WHEN h.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.drequest IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(CONVERT(varchar(33), h.drequest, 126) AS nvarchar(max))), 2)) END=:request_date AND CASE WHEN h.crevision IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.crevision AS nvarchar(max))), 2)) END=:revision AND CASE WHEN h.lquote IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lquote AS nvarchar(max))), 2)) END=:quote 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.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.cwarehouse AS nvarchar(max))), 2)) END=:warehouse AND CASE WHEN h.lmatch IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.lmatch AS nvarchar(max))), 2)) END=:matching AND CASE WHEN h.ldropship IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(h.ldropship AS nvarchar(max))), 2)) END=:drop_ship",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "34949F39-872F-5FA2-AC25-4F1925932BB6",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "4B299FAF-6951-5F66-86F5-2A947A8C741E",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "9A20CEDE-035D-50C1-B2ED-8D7ABACBA1AD",
"title": "Recorded purchase lines",
"urlKey": ""
},
{
"id": "92CB2A5E-8C85-5940-899B-7B13E9948BB6",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "D9076ACD-9222-5630-A85F-4CB4DF48D09A",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8F04FD61-FE3D-58FA-B19F-6FD8CA5CB355",
"title": "Current supplier",
"urlKey": ""
}
],
"badgeKey": "ccurrcode",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "crevision",
"label": "Recorded revision",
"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": "drequest",
"label": "Recorded requested date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "lvoid",
"label": "Cancelled native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nforderamt",
"label": "Recorded foreign subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "AA162097-A970-5556-952B-DB0B91D65180",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded purchase document — native order or quote flag",
"detailRole": "information",
"isVisible": true,
"key": "cpono",
"label": "Purchase order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase document — native order or quote flag",
"detailRole": "information",
"isVisible": true,
"key": "crevision",
"label": "Recorded revision",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase document — native order or quote flag",
"detailRole": "information",
"isVisible": true,
"key": "cvendno",
"label": "Recorded vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase document — native order or quote flag",
"detailRole": "information",
"isVisible": true,
"key": "cbuyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase document — native order or quote flag",
"detailRole": "information",
"isVisible": true,
"key": "centerby",
"label": "Entered by",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase document — native order or quote flag",
"detailRole": "information",
"isVisible": true,
"key": "cconfirmto",
"label": "Confirmed to",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase document — native order or quote flag",
"detailRole": "information",
"isVisible": true,
"key": "cshortrmk",
"label": "Short remark",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase document — native order or quote flag",
"detailRole": "information",
"isVisible": true,
"key": "lquote",
"label": "Order or quote native flag — verify semantics",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded dates — not receipt or payment proof",
"detailRole": "information",
"isVisible": true,
"key": "dorder",
"label": "Recorded order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded dates — not receipt or payment proof",
"detailRole": "information",
"isVisible": true,
"key": "drequest",
"label": "Recorded requested date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded dates — not receipt or payment proof",
"detailRole": "information",
"isVisible": true,
"key": "dquoteaprv",
"label": "Recorded quote approval date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded order-from — not current supplier master",
"detailRole": "information",
"isVisible": true,
"key": "cocompany",
"label": "Recorded order-from company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded order-from — not current supplier master",
"detailRole": "information",
"isVisible": true,
"key": "coaddr1",
"label": "Order-from address 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded order-from — not current supplier master",
"detailRole": "information",
"isVisible": true,
"key": "coaddr2",
"label": "Order-from address 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded order-from — not current supplier master",
"detailRole": "information",
"isVisible": true,
"key": "cocity",
"label": "Order-from city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded order-from — not current supplier master",
"detailRole": "information",
"isVisible": true,
"key": "costate",
"label": "Order-from state or region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded order-from — not current supplier master",
"detailRole": "information",
"isVisible": true,
"key": "cozip",
"label": "Order-from postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded order-from — not current supplier master",
"detailRole": "information",
"isVisible": true,
"key": "cocountry",
"label": "Order-from country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded order-from — not current supplier master",
"detailRole": "information",
"isVisible": true,
"key": "cophone",
"label": "Order-from phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded order-from — not current supplier master",
"detailRole": "information",
"isVisible": true,
"key": "cocontact",
"label": "Order-from contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded order-from — not current supplier master",
"detailRole": "information",
"isVisible": true,
"key": "coemail",
"label": "Order-from email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current warehouse master",
"detailRole": "information",
"isVisible": true,
"key": "cscompany",
"label": "Recorded ship-to company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current warehouse master",
"detailRole": "information",
"isVisible": true,
"key": "csaddr1",
"label": "Ship-to address 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current warehouse master",
"detailRole": "information",
"isVisible": true,
"key": "csaddr2",
"label": "Ship-to address 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current warehouse master",
"detailRole": "information",
"isVisible": true,
"key": "cscity",
"label": "Ship-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current warehouse master",
"detailRole": "information",
"isVisible": true,
"key": "csstate",
"label": "Ship-to state or region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current warehouse master",
"detailRole": "information",
"isVisible": true,
"key": "cszip",
"label": "Ship-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current warehouse master",
"detailRole": "information",
"isVisible": true,
"key": "cscountry",
"label": "Ship-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current warehouse master",
"detailRole": "information",
"isVisible": true,
"key": "csphone",
"label": "Ship-to phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded ship-to — not current warehouse master",
"detailRole": "information",
"isVisible": true,
"key": "cscontact",
"label": "Ship-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cshipvia",
"label": "Shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cfob",
"label": "F.O.B. code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "csono",
"label": "Customer sales-order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cbpono",
"label": "Blanket purchase-order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cwarehouse",
"label": "Order warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cfrgtcode",
"label": "Freight code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cfrtaxcode",
"label": "Freight tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "ctaxcode",
"label": "Sales tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Shipping, warehouse and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cpaycode",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native matching, cancellation and costing flags",
"detailRole": "information",
"isVisible": true,
"key": "laccrue",
"label": "Accrued received-goods native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native matching, cancellation and costing flags",
"detailRole": "information",
"isVisible": true,
"key": "lvoid",
"label": "Cancelled native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native matching, cancellation and costing flags",
"detailRole": "information",
"isVisible": true,
"key": "lnobo",
"label": "No-backorder native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native matching, cancellation and costing flags",
"detailRole": "information",
"isVisible": true,
"key": "lapplytax",
"label": "Apply-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native matching, cancellation and costing flags",
"detailRole": "information",
"isVisible": true,
"key": "lcstinctax",
"label": "Cost-includes-tax native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native matching, cancellation and costing flags",
"detailRole": "information",
"isVisible": true,
"key": "lusepartno",
"label": "Use vendor part number native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native matching, cancellation and costing flags",
"detailRole": "information",
"isVisible": true,
"key": "lmatch",
"label": "AP/PO matching native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native matching, cancellation and costing flags",
"detailRole": "information",
"isVisible": true,
"key": "ldropship",
"label": "Drop-ship native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded payment terms — not an executed payment",
"detailRole": "information",
"isVisible": true,
"key": "ndiscday",
"label": "Terms discount days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded payment terms — not an executed payment",
"detailRole": "information",
"isVisible": true,
"key": "ndueday",
"label": "Terms net days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded payment terms — not an executed payment",
"detailRole": "information",
"isVisible": true,
"key": "ntermdisc",
"label": "Terms discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded payment terms — not an executed payment",
"detailRole": "information",
"isVisible": true,
"key": "ndiscrate",
"label": "Recorded order 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": "nforderamt",
"label": "Recorded foreign subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nfdiscamt",
"label": "Recorded foreign discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nffrtamt",
"label": "Recorded foreign freight",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt1",
"label": "Recorded foreign tax amount 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt2",
"label": "Recorded foreign tax amount 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign amounts — no total or FX formula",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt3",
"label": "Recorded foreign tax amount 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign freight taxes and invoiced context",
"detailRole": "information",
"isVisible": true,
"key": "nffrttax1",
"label": "Recorded foreign freight tax 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign freight taxes and invoiced context",
"detailRole": "information",
"isVisible": true,
"key": "nffrttax2",
"label": "Recorded foreign freight tax 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign freight taxes and invoiced context",
"detailRole": "information",
"isVisible": true,
"key": "nffrttax3",
"label": "Recorded foreign freight tax 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign freight taxes and invoiced context",
"detailRole": "information",
"isVisible": true,
"key": "nffrtamtch",
"label": "Recorded foreign freight amount charged",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign freight taxes and invoiced context",
"detailRole": "information",
"isVisible": true,
"key": "nfpoinvamt",
"label": "Recorded foreign invoiced 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": "AF0AAD00-0737-5EAE-A502-254F0428E4F8",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "91A31E26-468F-51D9-8419-34FA334EB699",
"includeAllOption": false,
"key": "dorder",
"title": "Choose recorded purchase-order 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": "Purchase orders",
"titleKey": "cpono"
},
{
"actions": [],
"badgeKey": "ParentCurrencyCode",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cpartno",
"label": "Recorded vendor part number",
"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": "nrecqty",
"label": "Recorded received quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nfcost",
"label": "Recorded foreign unit cost",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "9A20CEDE-035D-50C1-B2ED-8D7ABACBA1AD",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded purchase line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cpono",
"label": "Purchase order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cvendno",
"label": "Recorded line vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "citemno",
"label": "Recorded item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cdescript",
"label": "Recorded line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cpartno",
"label": "Recorded vendor part number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "nseq",
"label": "Line sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "number"
},
{
"detailGroup": "Recorded purchase line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cspeccode1",
"label": "Specification code 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cspeccode2",
"label": "Specification code 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase line — not current product snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cwarehouse",
"label": "Recorded line warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded purchase 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": "nqtydec",
"label": "Recorded quantity decimal places",
"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": "nrecqty",
"label": "Recorded received 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 foreign costs and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "ParentCurrencyCode",
"label": "Recorded owning-order currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign costs and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nfcost",
"label": "Recorded foreign unit cost",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign costs and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nfcstinctx",
"label": "Recorded foreign unit cost plus tax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign costs and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nforderamt",
"label": "Recorded foreign line subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign costs and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nfdiscamt",
"label": "Recorded foreign line discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign costs and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt1",
"label": "Recorded foreign line tax 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign costs and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt2",
"label": "Recorded foreign line tax 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign costs and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "nftaxamt3",
"label": "Recorded foreign line tax 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded foreign costs and amounts — owning order currency",
"detailRole": "information",
"isVisible": true,
"key": "ndiscrate",
"label": "Recorded line discount percent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Reference account — authorised reporting, not ERP permissions",
"detailRole": "information",
"isVisible": true,
"key": "crefacct",
"label": "Recorded reference account — authorised reporting only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Reference account — authorised reporting, not ERP permissions",
"detailRole": "information",
"isVisible": true,
"key": "ctaxcode",
"label": "Recorded line tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Reference account — authorised reporting, not ERP permissions",
"detailRole": "information",
"isVisible": true,
"key": "lstock",
"label": "Stock-item native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Reference account — authorised reporting, not ERP permissions",
"detailRole": "information",
"isVisible": true,
"key": "lpartno",
"label": "Vendor-part native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Reference account — authorised reporting, not ERP permissions",
"detailRole": "information",
"isVisible": true,
"key": "ltaxable1",
"label": "Taxable 1 native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Reference account — authorised reporting, not ERP permissions",
"detailRole": "information",
"isVisible": true,
"key": "ltaxable2",
"label": "Taxable 2 native flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "4EECEC4C-E06B-5D49-9237-5363D8B4765A",
"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 purchase lines",
"titleKey": "cdescript"
},
{
"actions": [],
"badgeKey": "cstatus",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cphone1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cemail",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cclass",
"label": "Supplier class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cpaycode",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ccurrcode",
"label": "Supplier currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "8F04FD61-FE3D-58FA-B19F-6FD8CA5CB355",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "cfname",
"label": "Contact first name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "clname",
"label": "Contact last name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "cphone1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "cphone2",
"label": "Phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "cemail",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current contact details",
"detailRole": "information",
"isVisible": true,
"key": "cwebsite",
"label": "Website",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "caddr1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "caddr2",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "ccity",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "cstate",
"label": "State or region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "czip",
"label": "ZIP or postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current postal address",
"detailRole": "information",
"isVisible": true,
"key": "ccountry",
"label": "Country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cbuyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cpaycode",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cpayurgenc",
"label": "Payment urgency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "ccurrcode",
"label": "Supplier currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cpaytono",
"label": "Pay-to supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing and payment codes",
"detailRole": "information",
"isVisible": true,
"key": "cordfrno",
"label": "Order-from address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not order snapshot",
"detailRole": "information",
"isVisible": true,
"key": "ccompany",
"label": "Supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not order snapshot",
"detailRole": "information",
"isVisible": true,
"key": "ccompany2",
"label": "Supplier alias",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not order snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cvendno",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not order snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cvcustno",
"label": "Our account code at supplier",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not order snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cref",
"label": "Supplier reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not order snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cstatus",
"label": "Status code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current supplier master — not order snapshot",
"detailRole": "information",
"isVisible": true,
"key": "cclass",
"label": "Supplier class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order versus current supplier currency — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "ParentCurrencyCode",
"label": "Recorded owning-order currency code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order versus current supplier currency — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "SupplierContext",
"label": "Current supplier context — not order snapshot",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "4C54A44B-DDD1-527B-A928-4F84A846E184",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "A6D42344-8C77-5253-8134-D1D2A94ED2A7",
"key": "ccompany",
"type": "text"
},
{
"direction": "ascending",
"id": "ED8350F2-8ACE-5D71-BFE9-E224C8EE103B",
"key": "SupplierKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "cvendno",
"systemImage": "doc.text",
"title": "Current supplier",
"titleKey": "ccompany"
}
],
"relations": [
{
"childDatasetID": "9A20CEDE-035D-50C1-B2ED-8D7ABACBA1AD",
"childKey": "ParentKey",
"id": "4B299FAF-6951-5F66-86F5-2A947A8C741E",
"name": "Recorded purchase lines",
"parentDatasetID": "AA162097-A970-5556-952B-DB0B91D65180",
"parentKey": "OrderKey"
},
{
"childDatasetID": "8F04FD61-FE3D-58FA-B19F-6FD8CA5CB355",
"childKey": "ParentKey",
"id": "D9076ACD-9222-5630-A85F-4CB4DF48D09A",
"name": "Current supplier",
"parentDatasetID": "AA162097-A970-5556-952B-DB0B91D65180",
"parentKey": "OrderKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "AccountMate for SQL/Express",
"changelog": "Initial Pro purchase orders with recorded delivery details, quantities and costs, recorded lines and optional current supplier. Mandatory order-date period; original fictional native cards and representative Details. Not tested on a real ERP.",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-11T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.\n\nFor purchasing, warehouse teams and managers: choose the order-date period, inspect recorded supplier and delivery details, source costs, quantities, payment terms and notes. Open the recorded purchase lines or the current supplier dossier only when you need them.\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, grouped Details and two lazy sub-buttons. 66 order, 31 line and 27 current-supplier useful Detail positions; technical identity/context tokens hidden. Mandatory native order-date period before the 2,000 root cap; children capped at 500. Local search/filters cover loaded rows. No widgets, computed totals, writes or periodic refresh. Existing workspace resources count. A cap is not a query-performance guarantee.\n\nRECORDED ORDER: current Popord/Poptrs documents, including native quote/cancelled/unknown values without silent exclusion. Keep the native Order or Quote flag: PO documentation does not give a complete 0/1 legend; do not copy SO wording. Period means recorded dorder, not creation, requested, receipt, quote or payment date. NULL dates cannot enter a date period. No automatic history, blanket-order, receipt/cancellation or accrual/matching union. No promise of complete archive, receipts, invoices, payments or order completion.\n\nUSEFUL CONTEXT: recorded revision, buyer, entered/confirmed-by, order-from/ship-to contacts and addresses, shipping/warehouse/payment/tax codes, requested dates, vendor parts, specifications, unit and costs remain document values, not current master snapshots. Non-stock/service and orphan lines remain without requiring a current inventory item.\n\nQUANTITIES AND MONEY: ordered and received quantities, both unit factors, foreign costs, subtotal/discount/freight and ordinary/freight tax amounts are separate source values, never summed or recomputed. No remaining, stock, availability, conversion, tax total, FX or financial reconciliation. Received quantity and invoiced/freight-charged amounts are not complete receipt, invoice or payment logs. Line foreign values use owning recorded order currency; no own line-currency column is invented. No ISO code, base currency or exchange-rate direction assumed. Current supplier currency never replaces recorded order currency. Source values/flags stay exact text, with textual local sorting/filtering; sequence alone is numeric. Zero, negative, NULL and unknown remain distinct. Verify semantics before financial decisions.\n\nNOTES: optional unique Popork order note, explicitly a preview of the first 4,000 characters, NOT guaranteed complete text. Missing/ambiguous notes do not drop or multiply orders. Potrmk line-note join is NOT included: its own cuid/order fields do not prove equality with Poptrs.cuid. No guessed UID join or all-order notes repeated per line. Free text and contacts may be confidential; grant access only when authorised.\n\nCURRENT SUPPLIER: optional child requires one unique current Apvend match, not an order snapshot. Missing/ambiguous suppliers leave orders and lines intact; an empty child is not proof of no original supplier. Contacts, address, class, purchasing/payment codes and currency are current master values. An explicit context distinguishes current supplier versus order currency, without conversion. No bank, check, credit-card, password or tax identifier selected.\n\nIDENTITY AND ACCESS: company-owned cpono order key, full cuid line identity; line/SO references and sequence are not primary keys. Eleven encoded order/vendor/currency/full-date/revision/native-flag/warehouse context values are revalidated before both children. NULL-aware vendor membership retains rows without inventing a master. Missing/blank/ambiguous matching line UID blocks the WHOLE line branch, not partial arbitrary selection. Encoded UTF16 context preserves NULL/blank, spaces and Unicode through app trimming. Reference account is ERP permission-gated in the manual: direct SQL does not inherit ERP ACL. Only explicitly authorised least-privilege SELECT reporting access; filters are not permissions.\n\nCOMPATIBILITY: historical AccountMate 12 SQL/Express PO, 15 February 2021, plus the separately verified AP12 supplier contract. Not Enterprise/current SQL14 certification. Required/AMTBL widths are entry metadata, not installed DDL/NOT NULL. SQL Server 2012+ for CONCAT. Owner is UNKNOWN: administrator confirms exactly one readable Popord/Poptrs/Popork/Apvend 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 reads. Check installed edition, keys/types/collation/indexes/SQL cost, date/decimal/NULL conversions and currency/unit conventions. Documentary and adapted synthetic checks are NOT real ERP, native SQL Server, iOS, security, performance or purchase-entitlement certification. No credentials, server address or business rows in the package. Unofficial, not endorsed by AccountMate.\n\nDocumentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_po_drg.pdf\nhttps://www.accountmateportal.com/xasset/techdoc/amsql12_ap_drg.pdf\n\nGallery: Eight original native Cifru DEMO images show complete purchase-order, recorded-line and current-supplier cards, both actually traversed root sub-buttons and representative Details. All values are invented; no AccountMate installation was connected. The configuration retains 124 useful Detail positions (66 order, 31 recorded line, 27 current supplier), checked in full private overlapping native continuations. This is a representative gallery, not a claim that eight images show every configured field. Recorded supplier/delivery contacts and addresses, dates, codes, native flags and additional source amounts remain in the JSON and private continuations; no field was removed or screenshot retouched to fit eight. Quote/cancellation values remain native without guessed enums or silent exclusion. Ordered/received quantities and both unit factors remain distinct; no remaining, stock, availability or unit-conversion formula. Foreign costs, subtotals, discounts, freight and taxes are separate source values in the recorded owning-order currency, not a computed total. Current supplier data and currency are not a historical order snapshot and never replace order values. Received quantity and invoiced amount are not complete receipt, invoice or payment logs. Order notes are explicit first 4,000-character previews, not complete-text claims. The unproved Potrmk line-note UID join is excluded; missing/ambiguous optional notes or suppliers do not drop or multiply documents. Reference-account access requires explicitly authorised reporting: direct SQL does not inherit ERP permissions. Original PNG/XML pairs, frozen invented input and silent RAW are retained for future videos; whole RAW/Home, the native opening summary internal last7Days label and redundant continuations are private and not video-approved. Pro requirements were checked; capture uses a Pro test entitlement, not a purchase test. This proves native synthetic UI/action traversal and constrained adapted query intent, not real ERP, SQLServer/iOS/current edition/DDL/owner/collation, connector conversion, ISO currency/FX/unit conventions, ACL, reconciliation, archive completeness or performance.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "0BB1085C-20BD-5684-A536-60CD2F29AAB3",
"rootButtonCount": 1,
"summary": "Choose an order-date period; inspect delivery details, source costs and quantities, then recorded lines and the current supplier.",
"tags": [
"AccountMate",
"SQL Server",
"Purchasing",
"Purchase orders",
"Order lines",
"Warehouse",
"Pro"
],
"title": "Purchase orders, recorded lines and supplier — Pro"
}
}