Purchase orders, lines and current vendor — Pro
Order-date dossiers with buyer, delivery, original currency components, on-demand lines and current suppliers.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. Selected full POP10100/POP10110 projections are pinned to Microsoft source registrations from 2022-11-01, commit 1c63171e70c01aa143b5aaff427ed087cd70a9f9. The 2026 reduced projections at commit e7ed235bc979c0283306e9639ff7cd22ce78341d corroborate only their common fields and source relations. Neither is installed SQL DDL or a current complete GP database dictionary. Verify historical extra fields, company database, dbo objects, actual types/keys, GP version, financial interpretation and import read test before use. No real GP/SQL Server/iOS test, installed edition, ERP authorization or query performance is certified.
For purchasing, receiving, accounts payable and managers: choose an order-date period and optionally a vendor. Open a rich order dossier with stored vendor name, current master availability, independent status/type/hold/workflow, buyer, contract, delivery dates, own currency components and ship-to contact/address. Read the selected order's item/service lines or current supplier dossier only when needed. Lines keep vendor item references, units, ordered/canceled quantities, originating costs, dates, origin and their own ship-to details.
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 company source, one Home, three lists and two lazy sub-buttons. Explicit read-only SELECT, no SELECT *, credentials, business rows, SQL writes or executable code in this export. Native order-date start/end and optional vendor selection precede the 1,000-row read cap. Children revalidate the exact current parent and are not filtered again by the date period. No scheduled refresh. A cap/filter is not a performance guarantee or proof of complete results; test indexes, plans and Cifru wrapping on the actual authorised source. SQLite tests exercise synthetic selection logic, not installed SQL Server types or execution plans.
Current POP10100/POP10110 orders only, not separate POP30100/POP30110 history, a receipt ledger, posted vendor invoices or payments. Do not copy the Microsoft migration-only Standard/status 1–4 restriction: closed, canceled, blanket, drop-ship and unknown stored types/statuses remain visible inside the selected order-date period. NULL order dates are excluded by this mandatory date read; an empty read is not proof that the company has no orders. Native numeric codes remain alongside their own evidenced AL enum context; unknown/NULL codes are not guessed. Closed or Approved is not proof of payment, permission or effective workflow eligibility. Header hold, workflow and current vendor payment hold/status are independent states.
Blanket control and release lines must not be added together. GP control line 0 cannot be received/invoiced and is excluded from the GP subtotal; physical ORD/BRKFLD1-to-display-line mapping is not proven here, so no control/release role is guessed. Full PONUMBER+ORD+BRKFLD1 identity stays hidden, not item-code deduplication. Quantities are original QTYORDER/QTYCANCE in their own UOFM; no remaining, received, invoiced, stock or Qty-times-cost formula. Line vendor/type mismatches remain visible with an explicit comparison, not suppressed.
Only originating-labelled monetary components ORSUBTOT/ORTDISAM/ORFRTAMT/OMISCAMT/ORTAXAMT and ORUNTCST/OREXTCST are projected. Keep header and line own CURNCYID, not the current vendor's default. No currency conversion, functional-currency assignment, tax reconstruction, derived order total or cross-currency aggregation. Currency IDs need not be ISO; verify installed originating interpretation. Money and quantities use lossless source text, so local sorting/filtering is textual, not numeric aggregation. NULL, zero, negative and tiny values remain distinct. Date settings retain their native field name where physical field-to-business-role interpretation is not certified.
Order/line CMPNYNAM, CONTACT and addresses are ship-to context, not supplier master contact. VENDNAME on order is stored document context; the separate supplier is current PM00200 metadata, not a historical snapshot. Missing or ambiguous vendor metadata preserves the order with an explicit state and empty enrichment; it never chooses an arbitrary first supplier. A changed header vendor blocks an old vendor-button binding until the parent is reread. NULL/duplicate full line identity blocks that whole child and shows its reason in the parent. Invalid/duplicate order identities block the whole root read; inspect integrity rather than interpreting it as an empty purchasing module. Business codes keep leading zeros, case and leading spaces; only right padding is removed. Binary Unicode comparison and length prefixes do not certify the installed collation or SQL constraints.
Use a separately authorised least-privilege SELECT reporting login on allowed company data, not DYNAMICS, BC staging, sa, sysadmin or DYNGRP. GP application passwords are transformed; obtain an authorised SQL login. Cifru filters are not access control and do not inherit ERP permissions. Real supplier/contact/commercial data may be confidential. Captures must use native Cifru and wholly fictional DEMO data, never a live company. Unofficial, not endorsed by Microsoft.
Full historical registrations: https://raw.githubusercontent.com/microsoft/ALAppExtensions/1c63171e70c01aa143b5aaff427ed087cd70a9f9/Apps/W1/HybridGP/app/src/codeunits/GPCloudMigration.codeunit.al
Current reduced registrations: https://raw.githubusercontent.com/microsoft/ALAppExtensions/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/codeunits/GPCloudMigration.codeunit.al
Historical order fields: https://raw.githubusercontent.com/microsoft/ALAppExtensions/1c63171e70c01aa143b5aaff427ed087cd70a9f9/Apps/W1/HybridGP/app/src/Migration/Support/PurchaseOrders/GPPOPPOHeader.table.al
Historical line fields: https://raw.githubusercontent.com/microsoft/ALAppExtensions/1c63171e70c01aa143b5aaff427ed087cd70a9f9/Apps/W1/HybridGP/app/src/Migration/Support/PurchaseOrders/GPPOPPOLine.table.al
Current vendor fields: https://raw.githubusercontent.com/microsoft/ALAppExtensions/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/Migration/Vendors/GPPM00200.Table.al
Purchasing semantics: https://learn.microsoft.com/en-us/dynamics-gp/distribution/purchase-order-processing-part2-orders
Receiving semantics: https://learn.microsoft.com/en-us/dynamics-gp/distribution/purchase-order-processing-part3-receipts
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Purchase order dossier
- Details: Order lines
- Details: Current vendor
- Sub-button: Purchase order lines
- Sub-button: Current order vendor
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 RTRIM(m.PONUMBER) AS PONUMBER, m.POSTATUS AS POSTATUS, m.POTYPE AS POTYPE, m.CONFIRM1 AS CONFIRM1, m.DOCDATE AS DOCDATE, m.PRMDATE AS PRMDATE, m.PRMSHPDTE AS PRMSHPDTE, m.REQDATE AS REQDATE, m.SHIPMTHD AS SHIPMTHD, m.VENDORID AS VENDORID, m.VENDNAME AS VENDNAME, m.PRSTADCD AS PRSTADCD, m.CMPNYNAM AS CMPNYNAM, m.CONTACT AS CONTACT, m.ADDRESS1 AS ADDRESS1, m.ADDRESS2 AS ADDRESS2, m.ADDRESS3 AS ADDRESS3, m.CITY AS CITY, m.STATE AS STATE, m.ZIPCODE AS ZIPCODE, m.COUNTRY AS COUNTRY, m.PHONE1 AS PHONE1, m.PHONE2 AS PHONE2, m.PHONE3 AS PHONE3, m.FAX AS FAX, m.PYMTRMID AS PYMTRMID, m.CURNCYID AS CURNCYID, CAST(m.ORSUBTOT AS nvarchar(100)) AS ORSUBTOT, CAST(m.ORTDISAM AS nvarchar(100)) AS ORTDISAM, CAST(m.ORFRTAMT AS nvarchar(100)) AS ORFRTAMT, CAST(m.OMISCAMT AS nvarchar(100)) AS OMISCAMT, CAST(m.ORTAXAMT AS nvarchar(100)) AS ORTAXAMT, m.BUYERID AS BUYERID, m.HOLD AS HOLD, m.POPCONTNUM AS POPCONTNUM, m.CONTENDDTE AS CONTENDDTE, m.Workflow_Approval_Status AS Workflow_Approval_Status, CASE WHEN m.POSTATUS IS NULL THEN N'Unknown (NULL)' ELSE CASE m.POSTATUS WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'New' WHEN 2 THEN N'Released' WHEN 3 THEN N'Change Order' WHEN 4 THEN N'Received' WHEN 5 THEN N'Closed' WHEN 6 THEN N'Canceled' ELSE N'Unknown stored code' END END AS OrderStatus, CASE WHEN m.POTYPE IS NULL THEN N'Unknown (NULL)' ELSE CASE m.POTYPE WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'Standard' WHEN 2 THEN N'Direct shipment' WHEN 3 THEN N'Blanket' WHEN 4 THEN N'Direct-shipment blanket' ELSE N'Unknown stored code' END END AS OrderType, CASE WHEN m.Workflow_Approval_Status IS NULL THEN N'Unknown (NULL)' ELSE CASE m.Workflow_Approval_Status WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'Not Submitted' WHEN 2 THEN N'Submitted' WHEN 3 THEN N'Not Needed' WHEN 4 THEN N'Pending Approval' WHEN 5 THEN N'Pending Changes' WHEN 6 THEN N'Approved' WHEN 7 THEN N'Rejected' WHEN 8 THEN N'Ended' WHEN 9 THEN N'Not Activated' WHEN 10 THEN N'Deactivated' ELSE N'Unknown stored code' END END AS WorkflowContext, CASE WHEN m.VENDORID IS NOT NULL AND RTRIM(m.VENDORID)<>N'' THEN (SELECT CASE WHEN COUNT(1)=1 THEN MAX(v.VENDNAME) END FROM dbo.PM00200 v WHERE (RTRIM(CAST(v.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(v.VENDORID AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.VENDORID AS nvarchar(4000)))))) END AS CurrentVendorName, CASE WHEN m.VENDORID IS NULL OR RTRIM(m.VENDORID)=N'' THEN N'Missing order vendor identity' ELSE (SELECT CASE WHEN COUNT(1)=1 THEN N'Unique current metadata' WHEN COUNT(1)=0 THEN N'Missing current metadata' ELSE N'Ambiguous current metadata' END FROM dbo.PM00200 v WHERE (RTRIM(CAST(v.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(v.VENDORID AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.VENDORID AS nvarchar(4000)))))) END AS VendorState, CASE WHEN NOT EXISTS (SELECT 1 FROM dbo.POP10110 bad WHERE (RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(bad.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.PONUMBER AS nvarchar(4000))))) AND (bad.ORD IS NULL OR bad.BRKFLD1 IS NULL OR (SELECT COUNT(1) FROM dbo.POP10110 x WHERE (RTRIM(CAST(x.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(x.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))))) AND x.ORD=bad.ORD AND x.BRKFLD1=bad.BRKFLD1)<>1)) THEN N'Read on demand; may be empty' ELSE N'Blocked: NULL or duplicate full line identity' END AS LineState, CASE WHEN m.VENDORID IS NULL THEN N'NULL' ELSE CONCAT(LEN(RTRIM(CAST(m.VENDORID AS nvarchar(100)))),N':',RTRIM(CAST(m.VENDORID AS nvarchar(100)))) END AS VendorRefToken, N'Current POP order; not full receipt, invoice or payment history' AS Scope FROM dbo.POP10100 m WHERE OBJECT_ID(N'dbo.POP10100',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.POP10110',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.PM00200',N'U') IS NOT NULL AND NOT EXISTS (SELECT 1 FROM dbo.POP10100 bad WHERE bad.PONUMBER IS NULL OR RTRIM(bad.PONUMBER)=N'' OR (SELECT COUNT(1) FROM dbo.POP10100 other WHERE (RTRIM(CAST(other.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(other.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))))))<>1) AND m.DOCDATE>=:date_from AND m.DOCDATE<:date_until
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQueryWITH parent AS (SELECT p.PONUMBER,p.VENDORID,p.POTYPE FROM dbo.POP10100 p WHERE (RTRIM(CAST(p.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(:order AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(p.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(:order AS nvarchar(4000))))) AND (SELECT COUNT(1) FROM dbo.POP10100 other WHERE (RTRIM(CAST(other.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(p.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(other.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(p.PONUMBER AS nvarchar(4000))))))=1) SELECT RTRIM(l.PONUMBER) AS PONUMBER, l.POLNESTA AS POLNESTA, l.POTYPE AS POTYPE, l.ITEMNMBR AS ITEMNMBR, l.ITEMDESC AS ITEMDESC, l.VENDORID AS VENDORID, l.VNDITNUM AS VNDITNUM, l.VNDITDSC AS VNDITDSC, l.NONINVEN AS NONINVEN, l.LOCNCODE AS LOCNCODE, l.UOFM AS UOFM, CAST(l.QTYORDER AS nvarchar(100)) AS QTYORDER, CAST(l.QTYCANCE AS nvarchar(100)) AS QTYCANCE, l.REQDATE AS REQDATE, l.PRMDATE AS PRMDATE, l.PRMSHPDTE AS PRMSHPDTE, l.REQSTDBY AS REQSTDBY, l.CURNCYID AS CURNCYID, CAST(l.ORUNTCST AS nvarchar(100)) AS ORUNTCST, CAST(l.OREXTCST AS nvarchar(100)) AS OREXTCST, l.LINEORIGIN AS LINEORIGIN, l.ADRSCODE AS ADRSCODE, l.CMPNYNAM AS CMPNYNAM, l.CONTACT AS CONTACT, l.ADDRESS1 AS ADDRESS1, l.ADDRESS2 AS ADDRESS2, l.ADDRESS3 AS ADDRESS3, l.CITY AS CITY, l.STATE AS STATE, l.ZIPCODE AS ZIPCODE, l.COUNTRY AS COUNTRY, l.PHONE1 AS PHONE1, l.PHONE2 AS PHONE2, l.PHONE3 AS PHONE3, l.FAX AS FAX, CONCAT(LEN(RTRIM(CAST(l.PONUMBER AS nvarchar(100)))),N':',RTRIM(CAST(l.PONUMBER AS nvarchar(100))),LEN(RTRIM(CAST(l.ORD AS nvarchar(100)))),N':',RTRIM(CAST(l.ORD AS nvarchar(100))),LEN(RTRIM(CAST(l.BRKFLD1 AS nvarchar(100)))),N':',RTRIM(CAST(l.BRKFLD1 AS nvarchar(100)))) AS LineKey, RTRIM(m.PONUMBER) AS ParentOrderKey, CASE WHEN l.POLNESTA IS NULL THEN N'Unknown (NULL)' ELSE CASE l.POLNESTA WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'New' WHEN 2 THEN N'Released' WHEN 3 THEN N'Change Order' WHEN 4 THEN N'Received' WHEN 5 THEN N'Closed' WHEN 6 THEN N'Canceled' ELSE N'Unknown stored code' END END AS LineStatus, CASE WHEN l.POTYPE IS NULL THEN N'Unknown (NULL)' ELSE CASE l.POTYPE WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'Standard' WHEN 2 THEN N'Direct shipment' WHEN 3 THEN N'Blanket' WHEN 4 THEN N'Direct-shipment blanket' ELSE N'Unknown stored code' END END AS LineType, CASE WHEN l.LINEORIGIN IS NULL THEN N'Unknown (NULL)' ELSE CASE l.LINEORIGIN WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'Manual' WHEN 2 THEN N'e.Req.' WHEN 3 THEN N'SOP' WHEN 4 THEN N'MRP' WHEN 5 THEN N'SMS-CL' WHEN 6 THEN N'SMS-RT' WHEN 7 THEN N'SMS-DP' WHEN 8 THEN N'MOP' WHEN 9 THEN N'PO-Gen' WHEN 10 THEN N'POREQ' ELSE N'Unknown stored code' END END AS OriginContext, CASE WHEN l.VENDORID IS NULL OR m.VENDORID IS NULL THEN N'Unknown vendor comparison' WHEN (RTRIM(CAST(l.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(l.VENDORID AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.VENDORID AS nvarchar(4000))))) THEN N'Line vendor matches current order' ELSE N'Line vendor differs from current order' END AS VendorContext, CASE WHEN l.POTYPE IS NULL OR m.POTYPE IS NULL THEN N'Unknown type comparison' WHEN l.POTYPE=m.POTYPE THEN N'Line type matches current order' ELSE N'Line type differs from current order' END AS TypeContext, N'Original line, including possible blanket control/release; do not sum' AS Scope FROM dbo.POP10110 l JOIN parent m ON (RTRIM(CAST(l.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(l.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.PONUMBER AS nvarchar(4000))))) WHERE OBJECT_ID(N'dbo.POP10100',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.POP10110',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.PM00200',N'U') IS NOT NULL AND NOT EXISTS (SELECT 1 FROM dbo.POP10110 bad WHERE (RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(bad.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.PONUMBER AS nvarchar(4000))))) AND (bad.ORD IS NULL OR bad.BRKFLD1 IS NULL OR (SELECT COUNT(1) FROM dbo.POP10110 x WHERE (RTRIM(CAST(x.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(x.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))))) AND x.ORD=bad.ORD AND x.BRKFLD1=bad.BRKFLD1)<>1))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQueryWITH parent AS (SELECT p.PONUMBER,p.VENDORID,p.POTYPE FROM dbo.POP10100 p WHERE (RTRIM(CAST(p.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(:order AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(p.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(:order AS nvarchar(4000))))) AND (SELECT COUNT(1) FROM dbo.POP10100 other WHERE (RTRIM(CAST(other.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(p.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(other.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(p.PONUMBER AS nvarchar(4000))))))=1 AND (RTRIM(CAST(CASE WHEN p.VENDORID IS NULL THEN N'NULL' ELSE CONCAT(LEN(RTRIM(CAST(p.VENDORID AS nvarchar(100)))),N':',RTRIM(CAST(p.VENDORID AS nvarchar(100)))) END AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(:vendor_ref AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(CASE WHEN p.VENDORID IS NULL THEN N'NULL' ELSE CONCAT(LEN(RTRIM(CAST(p.VENDORID AS nvarchar(100)))),N':',RTRIM(CAST(p.VENDORID AS nvarchar(100)))) END AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(:vendor_ref AS nvarchar(4000)))))) SELECT RTRIM(v.VENDORID) AS VENDORID, v.VENDNAME AS VENDNAME, v.VNDCHKNM AS VNDCHKNM, v.VENDSHNM AS VENDSHNM, v.VNDCLSID AS VNDCLSID, v.VNDCNTCT AS VNDCNTCT, v.ADDRESS1 AS ADDRESS1, v.ADDRESS2 AS ADDRESS2, v.ADDRESS3 AS ADDRESS3, v.CITY AS CITY, v.STATE AS STATE, v.ZIPCODE AS ZIPCODE, v.COUNTRY AS COUNTRY, v.PHNUMBR1 AS PHNUMBR1, v.PHNUMBR2 AS PHNUMBR2, v.PHONE3 AS PHONE3, v.FAXNUMBR AS FAXNUMBR, v.VADDCDPR AS VADDCDPR, v.VADCDPAD AS VADCDPAD, v.VADCDSFR AS VADCDSFR, v.VADCDTRO AS VADCDTRO, v.SHIPMTHD AS SHIPMTHD, v.TAXSCHID AS TAXSCHID, v.UPSZONE AS UPSZONE, v.ACNMVNDR AS ACNMVNDR, v.VENDSTTS AS VENDSTTS, v.HOLD AS HOLD, v.CURNCYID AS CURNCYID, v.RATETPID AS RATETPID, v.PYMTRMID AS PYMTRMID, v.PYMNTPRI AS PYMNTPRI, v.DISGRPER AS DISGRPER, v.DUEGRPER AS DUEGRPER, v.COMMENT1 AS COMMENT1, v.COMMENT2 AS COMMENT2, RTRIM(m.PONUMBER) AS ParentOrderKey, N'Current PM00200 master; not historical order snapshot' AS MasterScope FROM dbo.PM00200 v JOIN parent m ON (RTRIM(CAST(v.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(v.VENDORID AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.VENDORID AS nvarchar(4000))))) WHERE OBJECT_ID(N'dbo.POP10100',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.POP10110',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.PM00200',N'U') IS NOT NULL AND v.VENDORID IS NOT NULL AND RTRIM(v.VENDORID)<>N'' AND (SELECT COUNT(1) FROM dbo.PM00200 other WHERE (RTRIM(CAST(other.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(v.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(other.VENDORID AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(v.VENDORID AS nvarchar(4000))))))=1
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Dynamics GP — authorised SQL company database",
"id": "5A693AFC-160D-56DE-AA63-BCA03DA5395E",
"kind": "sqlServer",
"requiredObjects": [
"dbo.POP10100",
"dbo.POP10110",
"dbo.PM00200"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "9BA8DDF4-6C48-5D38-A2BA-1E3FF9E7AE5C",
"key": "DOCDATE",
"type": "date"
},
{
"direction": "ascending",
"id": "D4D2FE5F-923B-5B02-A6C1-6026E1229CFA",
"key": "PONUMBER",
"type": "text"
}
],
"id": "37AE404D-6B67-5EEC-9508-70465D2E9C36",
"mappings": [
{
"commonFieldKey": "",
"key": "VendorRefToken",
"label": "Hidden complete source identity / binding",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorRefToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PONUMBER",
"label": "Purchase order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PONUMBER",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POSTATUS",
"label": "Stored order status code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "POSTATUS",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POTYPE",
"label": "Stored order type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "POTYPE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CONFIRM1",
"label": "Confirmation reference (CONFIRM1)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CONFIRM1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DOCDATE",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DOCDATE",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PRMDATE",
"label": "Expected receipt date (PRMDATE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRMDATE",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PRMSHPDTE",
"label": "Source ship-date setting (PRMSHPDTE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRMSHPDTE",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REQDATE",
"label": "Source requested-date setting (REQDATE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "REQDATE",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIPMTHD",
"label": "Shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHIPMTHD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDORID",
"label": "Order vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDORID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VENDNAME",
"label": "Vendor name stored on order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDNAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRSTADCD",
"label": "Ship-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PRSTADCD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CMPNYNAM",
"label": "Ship-to company / name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CMPNYNAM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CONTACT",
"label": "Ship-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CONTACT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDRESS1",
"label": "Ship-to address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDRESS2",
"label": "Ship-to address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDRESS3",
"label": "Ship-to address line 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CITY",
"label": "Ship-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CITY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STATE",
"label": "Ship-to state / region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "STATE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ZIPCODE",
"label": "Ship-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ZIPCODE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COUNTRY",
"label": "Ship-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COUNTRY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHONE1",
"label": "Ship-to phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHONE1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHONE2",
"label": "Ship-to phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHONE2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHONE3",
"label": "Ship-to phone 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHONE3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FAX",
"label": "Ship-to fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FAX",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PYMTRMID",
"label": "Order payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PYMTRMID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CURNCYID",
"label": "Order currency ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CURNCYID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ORSUBTOT",
"label": "Source originating subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ORSUBTOT",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ORTDISAM",
"label": "Source originating trade discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ORTDISAM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORFRTAMT",
"label": "Source originating freight",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ORFRTAMT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OMISCAMT",
"label": "Source originating miscellaneous amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OMISCAMT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORTAXAMT",
"label": "Source originating tax amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ORTAXAMT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BUYERID",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BUYERID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HOLD",
"label": "Stored order hold (1 = yes)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "HOLD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "POPCONTNUM",
"label": "Contract reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "POPCONTNUM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CONTENDDTE",
"label": "Source contract end-date setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CONTENDDTE",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Workflow_Approval_Status",
"label": "Stored workflow approval code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Workflow_Approval_Status",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderStatus",
"label": "Documented order status context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderType",
"label": "Documented order type context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WorkflowContext",
"label": "Documented workflow code context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WorkflowContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrentVendorName",
"label": "Current vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrentVendorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorState",
"label": "Current vendor master availability",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineState",
"label": "Line identity availability",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Scope",
"label": "Source document scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Scope",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Purchase order dossier",
"primaryKey": "PONUMBER",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DOCDATE",
"id": "0EC54E3B-415A-51C8-ACE2-1550AB08FC40",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DOCDATE",
"id": "615CB4AC-B581-5EE3-9ECE-025976026C24",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"PONUMBER",
"POSTATUS",
"POTYPE",
"CONFIRM1",
"DOCDATE",
"PRMDATE",
"PRMSHPDTE",
"REQDATE",
"SHIPMTHD",
"VENDORID",
"VENDNAME",
"PRSTADCD",
"CMPNYNAM",
"CONTACT",
"ADDRESS1",
"ADDRESS2",
"ADDRESS3",
"CITY",
"STATE",
"ZIPCODE",
"COUNTRY",
"PHONE1",
"PHONE2",
"PHONE3",
"FAX",
"PYMTRMID",
"CURNCYID",
"ORSUBTOT",
"ORTDISAM",
"ORFRTAMT",
"OMISCAMT",
"ORTAXAMT",
"BUYERID",
"HOLD",
"POPCONTNUM",
"CONTENDDTE",
"Workflow_Approval_Status",
"OrderStatus",
"OrderType",
"WorkflowContext",
"CurrentVendorName",
"VendorState",
"LineState",
"Scope"
],
"sourceID": "5A693AFC-160D-56DE-AA63-BCA03DA5395E",
"sqlQuery": "SELECT RTRIM(m.PONUMBER) AS PONUMBER, m.POSTATUS AS POSTATUS, m.POTYPE AS POTYPE, m.CONFIRM1 AS CONFIRM1, m.DOCDATE AS DOCDATE, m.PRMDATE AS PRMDATE, m.PRMSHPDTE AS PRMSHPDTE, m.REQDATE AS REQDATE, m.SHIPMTHD AS SHIPMTHD, m.VENDORID AS VENDORID, m.VENDNAME AS VENDNAME, m.PRSTADCD AS PRSTADCD, m.CMPNYNAM AS CMPNYNAM, m.CONTACT AS CONTACT, m.ADDRESS1 AS ADDRESS1, m.ADDRESS2 AS ADDRESS2, m.ADDRESS3 AS ADDRESS3, m.CITY AS CITY, m.STATE AS STATE, m.ZIPCODE AS ZIPCODE, m.COUNTRY AS COUNTRY, m.PHONE1 AS PHONE1, m.PHONE2 AS PHONE2, m.PHONE3 AS PHONE3, m.FAX AS FAX, m.PYMTRMID AS PYMTRMID, m.CURNCYID AS CURNCYID, CAST(m.ORSUBTOT AS nvarchar(100)) AS ORSUBTOT, CAST(m.ORTDISAM AS nvarchar(100)) AS ORTDISAM, CAST(m.ORFRTAMT AS nvarchar(100)) AS ORFRTAMT, CAST(m.OMISCAMT AS nvarchar(100)) AS OMISCAMT, CAST(m.ORTAXAMT AS nvarchar(100)) AS ORTAXAMT, m.BUYERID AS BUYERID, m.HOLD AS HOLD, m.POPCONTNUM AS POPCONTNUM, m.CONTENDDTE AS CONTENDDTE, m.Workflow_Approval_Status AS Workflow_Approval_Status, CASE WHEN m.POSTATUS IS NULL THEN N'Unknown (NULL)' ELSE CASE m.POSTATUS WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'New' WHEN 2 THEN N'Released' WHEN 3 THEN N'Change Order' WHEN 4 THEN N'Received' WHEN 5 THEN N'Closed' WHEN 6 THEN N'Canceled' ELSE N'Unknown stored code' END END AS OrderStatus, CASE WHEN m.POTYPE IS NULL THEN N'Unknown (NULL)' ELSE CASE m.POTYPE WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'Standard' WHEN 2 THEN N'Direct shipment' WHEN 3 THEN N'Blanket' WHEN 4 THEN N'Direct-shipment blanket' ELSE N'Unknown stored code' END END AS OrderType, CASE WHEN m.Workflow_Approval_Status IS NULL THEN N'Unknown (NULL)' ELSE CASE m.Workflow_Approval_Status WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'Not Submitted' WHEN 2 THEN N'Submitted' WHEN 3 THEN N'Not Needed' WHEN 4 THEN N'Pending Approval' WHEN 5 THEN N'Pending Changes' WHEN 6 THEN N'Approved' WHEN 7 THEN N'Rejected' WHEN 8 THEN N'Ended' WHEN 9 THEN N'Not Activated' WHEN 10 THEN N'Deactivated' ELSE N'Unknown stored code' END END AS WorkflowContext, CASE WHEN m.VENDORID IS NOT NULL AND RTRIM(m.VENDORID)<>N'' THEN (SELECT CASE WHEN COUNT(1)=1 THEN MAX(v.VENDNAME) END FROM dbo.PM00200 v WHERE (RTRIM(CAST(v.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(v.VENDORID AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.VENDORID AS nvarchar(4000)))))) END AS CurrentVendorName, CASE WHEN m.VENDORID IS NULL OR RTRIM(m.VENDORID)=N'' THEN N'Missing order vendor identity' ELSE (SELECT CASE WHEN COUNT(1)=1 THEN N'Unique current metadata' WHEN COUNT(1)=0 THEN N'Missing current metadata' ELSE N'Ambiguous current metadata' END FROM dbo.PM00200 v WHERE (RTRIM(CAST(v.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(v.VENDORID AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.VENDORID AS nvarchar(4000)))))) END AS VendorState, CASE WHEN NOT EXISTS (SELECT 1 FROM dbo.POP10110 bad WHERE (RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(bad.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.PONUMBER AS nvarchar(4000))))) AND (bad.ORD IS NULL OR bad.BRKFLD1 IS NULL OR (SELECT COUNT(1) FROM dbo.POP10110 x WHERE (RTRIM(CAST(x.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(x.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))))) AND x.ORD=bad.ORD AND x.BRKFLD1=bad.BRKFLD1)<>1)) THEN N'Read on demand; may be empty' ELSE N'Blocked: NULL or duplicate full line identity' END AS LineState, CASE WHEN m.VENDORID IS NULL THEN N'NULL' ELSE CONCAT(LEN(RTRIM(CAST(m.VENDORID AS nvarchar(100)))),N':',RTRIM(CAST(m.VENDORID AS nvarchar(100)))) END AS VendorRefToken, N'Current POP order; not full receipt, invoice or payment history' AS Scope FROM dbo.POP10100 m WHERE OBJECT_ID(N'dbo.POP10100',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.POP10110',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.PM00200',N'U') IS NOT NULL AND NOT EXISTS (SELECT 1 FROM dbo.POP10100 bad WHERE bad.PONUMBER IS NULL OR RTRIM(bad.PONUMBER)=N'' OR (SELECT COUNT(1) FROM dbo.POP10100 other WHERE (RTRIM(CAST(other.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(other.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))))))<>1) AND m.DOCDATE>=:date_from AND m.DOCDATE<:date_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "160F3CDA-456D-5A46-8993-9915BA8C750D",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Hidden complete source identity / binding",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentOrderKey",
"label": "Hidden complete source identity / binding",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentOrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PONUMBER",
"label": "Purchase order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PONUMBER",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POLNESTA",
"label": "Stored line status code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "POLNESTA",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POTYPE",
"label": "Stored line order type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "POTYPE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITEMNMBR",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ITEMNMBR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITEMDESC",
"label": "Item / service description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ITEMDESC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDORID",
"label": "Vendor code stored on line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDORID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VNDITNUM",
"label": "Vendor item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VNDITNUM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VNDITDSC",
"label": "Vendor item description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VNDITDSC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NONINVEN",
"label": "Native non-inventory flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NONINVEN",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LOCNCODE",
"label": "Line location code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LOCNCODE",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UOFM",
"label": "Unit on line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UOFM",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QTYORDER",
"label": "Source ordered quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QTYORDER",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QTYCANCE",
"label": "Source canceled quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QTYCANCE",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "REQDATE",
"label": "Source requested-date setting (REQDATE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "REQDATE",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRMDATE",
"label": "Source receipt-date setting (PRMDATE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRMDATE",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRMSHPDTE",
"label": "Source ship-date setting (PRMSHPDTE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRMSHPDTE",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REQSTDBY",
"label": "Requested-by reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "REQSTDBY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CURNCYID",
"label": "Line currency ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CURNCYID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ORUNTCST",
"label": "Source originating unit cost",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ORUNTCST",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OREXTCST",
"label": "Source originating extended cost",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OREXTCST",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LINEORIGIN",
"label": "Stored line origin code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LINEORIGIN",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADRSCODE",
"label": "Line ship-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADRSCODE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CMPNYNAM",
"label": "Line ship-to company / name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CMPNYNAM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CONTACT",
"label": "Line ship-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CONTACT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDRESS1",
"label": "Line ship-to address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDRESS2",
"label": "Line ship-to address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDRESS3",
"label": "Line ship-to address line 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CITY",
"label": "Line ship-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CITY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STATE",
"label": "Line ship-to state / region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "STATE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ZIPCODE",
"label": "Line ship-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ZIPCODE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COUNTRY",
"label": "Line ship-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COUNTRY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHONE1",
"label": "Line ship-to phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHONE1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHONE2",
"label": "Line ship-to phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHONE2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHONE3",
"label": "Line ship-to phone 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHONE3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FAX",
"label": "Line ship-to fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FAX",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineStatus",
"label": "Documented line status context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineType",
"label": "Documented line type context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginContext",
"label": "Documented line origin context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OriginContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorContext",
"label": "Line / order vendor comparison",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TypeContext",
"label": "Line / order type comparison",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TypeContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Scope",
"label": "Line scope — not an outstanding quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Scope",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Purchase order lines",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PONUMBER",
"id": "CC870647-A15A-5CF9-A8E1-97A24C31656A",
"name": "order",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"PONUMBER",
"POLNESTA",
"POTYPE",
"ITEMNMBR",
"ITEMDESC",
"VENDORID",
"VNDITNUM",
"VNDITDSC",
"NONINVEN",
"LOCNCODE",
"UOFM",
"QTYORDER",
"QTYCANCE",
"REQDATE",
"PRMDATE",
"PRMSHPDTE",
"REQSTDBY",
"CURNCYID",
"ORUNTCST",
"OREXTCST",
"LINEORIGIN",
"ADRSCODE",
"CMPNYNAM",
"CONTACT",
"ADDRESS1",
"ADDRESS2",
"ADDRESS3",
"CITY",
"STATE",
"ZIPCODE",
"COUNTRY",
"PHONE1",
"PHONE2",
"PHONE3",
"FAX",
"LineStatus",
"LineType",
"OriginContext",
"VendorContext",
"TypeContext",
"Scope"
],
"sourceID": "5A693AFC-160D-56DE-AA63-BCA03DA5395E",
"sqlQuery": "WITH parent AS (SELECT p.PONUMBER,p.VENDORID,p.POTYPE FROM dbo.POP10100 p WHERE (RTRIM(CAST(p.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(:order AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(p.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(:order AS nvarchar(4000))))) AND (SELECT COUNT(1) FROM dbo.POP10100 other WHERE (RTRIM(CAST(other.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(p.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(other.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(p.PONUMBER AS nvarchar(4000))))))=1) SELECT RTRIM(l.PONUMBER) AS PONUMBER, l.POLNESTA AS POLNESTA, l.POTYPE AS POTYPE, l.ITEMNMBR AS ITEMNMBR, l.ITEMDESC AS ITEMDESC, l.VENDORID AS VENDORID, l.VNDITNUM AS VNDITNUM, l.VNDITDSC AS VNDITDSC, l.NONINVEN AS NONINVEN, l.LOCNCODE AS LOCNCODE, l.UOFM AS UOFM, CAST(l.QTYORDER AS nvarchar(100)) AS QTYORDER, CAST(l.QTYCANCE AS nvarchar(100)) AS QTYCANCE, l.REQDATE AS REQDATE, l.PRMDATE AS PRMDATE, l.PRMSHPDTE AS PRMSHPDTE, l.REQSTDBY AS REQSTDBY, l.CURNCYID AS CURNCYID, CAST(l.ORUNTCST AS nvarchar(100)) AS ORUNTCST, CAST(l.OREXTCST AS nvarchar(100)) AS OREXTCST, l.LINEORIGIN AS LINEORIGIN, l.ADRSCODE AS ADRSCODE, l.CMPNYNAM AS CMPNYNAM, l.CONTACT AS CONTACT, l.ADDRESS1 AS ADDRESS1, l.ADDRESS2 AS ADDRESS2, l.ADDRESS3 AS ADDRESS3, l.CITY AS CITY, l.STATE AS STATE, l.ZIPCODE AS ZIPCODE, l.COUNTRY AS COUNTRY, l.PHONE1 AS PHONE1, l.PHONE2 AS PHONE2, l.PHONE3 AS PHONE3, l.FAX AS FAX, CONCAT(LEN(RTRIM(CAST(l.PONUMBER AS nvarchar(100)))),N':',RTRIM(CAST(l.PONUMBER AS nvarchar(100))),LEN(RTRIM(CAST(l.ORD AS nvarchar(100)))),N':',RTRIM(CAST(l.ORD AS nvarchar(100))),LEN(RTRIM(CAST(l.BRKFLD1 AS nvarchar(100)))),N':',RTRIM(CAST(l.BRKFLD1 AS nvarchar(100)))) AS LineKey, RTRIM(m.PONUMBER) AS ParentOrderKey, CASE WHEN l.POLNESTA IS NULL THEN N'Unknown (NULL)' ELSE CASE l.POLNESTA WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'New' WHEN 2 THEN N'Released' WHEN 3 THEN N'Change Order' WHEN 4 THEN N'Received' WHEN 5 THEN N'Closed' WHEN 6 THEN N'Canceled' ELSE N'Unknown stored code' END END AS LineStatus, CASE WHEN l.POTYPE IS NULL THEN N'Unknown (NULL)' ELSE CASE l.POTYPE WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'Standard' WHEN 2 THEN N'Direct shipment' WHEN 3 THEN N'Blanket' WHEN 4 THEN N'Direct-shipment blanket' ELSE N'Unknown stored code' END END AS LineType, CASE WHEN l.LINEORIGIN IS NULL THEN N'Unknown (NULL)' ELSE CASE l.LINEORIGIN WHEN 0 THEN N'Unspecified (code 0)' WHEN 1 THEN N'Manual' WHEN 2 THEN N'e.Req.' WHEN 3 THEN N'SOP' WHEN 4 THEN N'MRP' WHEN 5 THEN N'SMS-CL' WHEN 6 THEN N'SMS-RT' WHEN 7 THEN N'SMS-DP' WHEN 8 THEN N'MOP' WHEN 9 THEN N'PO-Gen' WHEN 10 THEN N'POREQ' ELSE N'Unknown stored code' END END AS OriginContext, CASE WHEN l.VENDORID IS NULL OR m.VENDORID IS NULL THEN N'Unknown vendor comparison' WHEN (RTRIM(CAST(l.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(l.VENDORID AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.VENDORID AS nvarchar(4000))))) THEN N'Line vendor matches current order' ELSE N'Line vendor differs from current order' END AS VendorContext, CASE WHEN l.POTYPE IS NULL OR m.POTYPE IS NULL THEN N'Unknown type comparison' WHEN l.POTYPE=m.POTYPE THEN N'Line type matches current order' ELSE N'Line type differs from current order' END AS TypeContext, N'Original line, including possible blanket control/release; do not sum' AS Scope FROM dbo.POP10110 l JOIN parent m ON (RTRIM(CAST(l.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(l.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.PONUMBER AS nvarchar(4000))))) WHERE OBJECT_ID(N'dbo.POP10100',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.POP10110',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.PM00200',N'U') IS NOT NULL AND NOT EXISTS (SELECT 1 FROM dbo.POP10110 bad WHERE (RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(bad.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.PONUMBER AS nvarchar(4000))))) AND (bad.ORD IS NULL OR bad.BRKFLD1 IS NULL OR (SELECT COUNT(1) FROM dbo.POP10110 x WHERE (RTRIM(CAST(x.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(x.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(bad.PONUMBER AS nvarchar(4000))))) AND x.ORD=bad.ORD AND x.BRKFLD1=bad.BRKFLD1)<>1))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "44EA15AF-43DA-5B5D-8A52-17FD850DB6B6",
"key": "VENDORID",
"type": "text"
}
],
"id": "8EA72616-AE37-51AF-8BCD-C8F246A46637",
"mappings": [
{
"commonFieldKey": "",
"key": "ParentOrderKey",
"label": "Hidden complete source identity / binding",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentOrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDORID",
"label": "Vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDORID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDNAME",
"label": "Vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDNAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VNDCHKNM",
"label": "Payee / check name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VNDCHKNM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDSHNM",
"label": "Short name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDSHNM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VNDCLSID",
"label": "Vendor class",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VNDCLSID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VNDCNTCT",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VNDCNTCT",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ADDRESS1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDRESS2",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDRESS3",
"label": "Address line 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CITY",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CITY",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "STATE",
"label": "State / region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "STATE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ZIPCODE",
"label": "Postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ZIPCODE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COUNTRY",
"label": "Country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COUNTRY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHNUMBR1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHNUMBR1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PHNUMBR2",
"label": "Phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHNUMBR2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHONE3",
"label": "Phone 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHONE3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FAXNUMBR",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FAXNUMBR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VADDCDPR",
"label": "Primary address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VADDCDPR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VADCDPAD",
"label": "Address default code (VADCDPAD)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VADCDPAD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VADCDSFR",
"label": "Address default code (VADCDSFR)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VADCDSFR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VADCDTRO",
"label": "Remit-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VADCDTRO",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIPMTHD",
"label": "Shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHIPMTHD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TAXSCHID",
"label": "Tax schedule code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TAXSCHID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UPSZONE",
"label": "UPS zone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UPSZONE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACNMVNDR",
"label": "Our account code with vendor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ACNMVNDR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDSTTS",
"label": "Stored vendor status code (3 = temporary)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDSTTS",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HOLD",
"label": "Stored payment hold (1 = yes)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "HOLD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CURNCYID",
"label": "Default currency ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CURNCYID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "RATETPID",
"label": "Exchange-rate type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RATETPID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PYMTRMID",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PYMTRMID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PYMNTPRI",
"label": "Payment priority code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PYMNTPRI",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DISGRPER",
"label": "Discount grace days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DISGRPER",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DUEGRPER",
"label": "Due-date grace days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DUEGRPER",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMMENT1",
"label": "Comment 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMMENT1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMMENT2",
"label": "Comment 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMMENT2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MasterScope",
"label": "Current master context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MasterScope",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Current order vendor",
"primaryKey": "VENDORID",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PONUMBER",
"id": "CC870647-A15A-5CF9-A8E1-97A24C31656A",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VendorRefToken",
"id": "75F240E0-A1B4-5F28-908E-7BF23663936B",
"name": "vendor_ref",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VENDORID",
"VENDNAME",
"VNDCHKNM",
"VENDSHNM",
"VNDCLSID",
"VNDCNTCT",
"ADDRESS1",
"ADDRESS2",
"ADDRESS3",
"CITY",
"STATE",
"ZIPCODE",
"COUNTRY",
"PHNUMBR1",
"PHNUMBR2",
"PHONE3",
"FAXNUMBR",
"VADDCDPR",
"VADCDPAD",
"VADCDSFR",
"VADCDTRO",
"SHIPMTHD",
"TAXSCHID",
"UPSZONE",
"ACNMVNDR",
"VENDSTTS",
"HOLD",
"CURNCYID",
"RATETPID",
"PYMTRMID",
"PYMNTPRI",
"DISGRPER",
"DUEGRPER",
"COMMENT1",
"COMMENT2",
"MasterScope"
],
"sourceID": "5A693AFC-160D-56DE-AA63-BCA03DA5395E",
"sqlQuery": "WITH parent AS (SELECT p.PONUMBER,p.VENDORID,p.POTYPE FROM dbo.POP10100 p WHERE (RTRIM(CAST(p.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(:order AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(p.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(:order AS nvarchar(4000))))) AND (SELECT COUNT(1) FROM dbo.POP10100 other WHERE (RTRIM(CAST(other.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(p.PONUMBER AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(other.PONUMBER AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(p.PONUMBER AS nvarchar(4000))))))=1 AND (RTRIM(CAST(CASE WHEN p.VENDORID IS NULL THEN N'NULL' ELSE CONCAT(LEN(RTRIM(CAST(p.VENDORID AS nvarchar(100)))),N':',RTRIM(CAST(p.VENDORID AS nvarchar(100)))) END AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(:vendor_ref AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(CASE WHEN p.VENDORID IS NULL THEN N'NULL' ELSE CONCAT(LEN(RTRIM(CAST(p.VENDORID AS nvarchar(100)))),N':',RTRIM(CAST(p.VENDORID AS nvarchar(100)))) END AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(:vendor_ref AS nvarchar(4000)))))) SELECT RTRIM(v.VENDORID) AS VENDORID, v.VENDNAME AS VENDNAME, v.VNDCHKNM AS VNDCHKNM, v.VENDSHNM AS VENDSHNM, v.VNDCLSID AS VNDCLSID, v.VNDCNTCT AS VNDCNTCT, v.ADDRESS1 AS ADDRESS1, v.ADDRESS2 AS ADDRESS2, v.ADDRESS3 AS ADDRESS3, v.CITY AS CITY, v.STATE AS STATE, v.ZIPCODE AS ZIPCODE, v.COUNTRY AS COUNTRY, v.PHNUMBR1 AS PHNUMBR1, v.PHNUMBR2 AS PHNUMBR2, v.PHONE3 AS PHONE3, v.FAXNUMBR AS FAXNUMBR, v.VADDCDPR AS VADDCDPR, v.VADCDPAD AS VADCDPAD, v.VADCDSFR AS VADCDSFR, v.VADCDTRO AS VADCDTRO, v.SHIPMTHD AS SHIPMTHD, v.TAXSCHID AS TAXSCHID, v.UPSZONE AS UPSZONE, v.ACNMVNDR AS ACNMVNDR, v.VENDSTTS AS VENDSTTS, v.HOLD AS HOLD, v.CURNCYID AS CURNCYID, v.RATETPID AS RATETPID, v.PYMTRMID AS PYMTRMID, v.PYMNTPRI AS PYMNTPRI, v.DISGRPER AS DISGRPER, v.DUEGRPER AS DUEGRPER, v.COMMENT1 AS COMMENT1, v.COMMENT2 AS COMMENT2, RTRIM(m.PONUMBER) AS ParentOrderKey, N'Current PM00200 master; not historical order snapshot' AS MasterScope FROM dbo.PM00200 v JOIN parent m ON (RTRIM(CAST(v.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(m.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(v.VENDORID AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(m.VENDORID AS nvarchar(4000))))) WHERE OBJECT_ID(N'dbo.POP10100',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.POP10110',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.PM00200',N'U') IS NOT NULL AND v.VENDORID IS NOT NULL AND RTRIM(v.VENDORID)<>N'' AND (SELECT COUNT(1) FROM dbo.PM00200 other WHERE (RTRIM(CAST(other.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 = RTRIM(CAST(v.VENDORID AS nvarchar(4000))) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(RTRIM(CAST(other.VENDORID AS nvarchar(4000)))) = DATALENGTH(RTRIM(CAST(v.VENDORID AS nvarchar(4000))))))=1",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "6A465DFF-AF75-5A5E-8B7D-F362EACD70DC",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "E6242D1E-485B-5D20-986C-8F5C69C9D63C",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "160F3CDA-456D-5A46-8993-9915BA8C750D",
"title": "Order lines",
"urlKey": ""
},
{
"id": "BD827919-F4BC-51B3-954B-E9A9CAEF9561",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "2819C4CC-8CCF-5B37-80BD-E5E9B850D1EA",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8EA72616-AE37-51AF-8BCD-C8F246A46637",
"title": "Current vendor",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DOCDATE",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderStatus",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderType",
"label": "Type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VENDORID",
"label": "Vendor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CURNCYID",
"label": "Own currency ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORSUBTOT",
"label": "Originating subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PRMDATE",
"label": "Receipt-date setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HOLD",
"label": "Stored hold (1=yes)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "37AE404D-6B67-5EEC-9508-70465D2E9C36",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Order and vendor context",
"detailRole": "information",
"isVisible": true,
"key": "PONUMBER",
"label": "Purchase order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order and vendor context",
"detailRole": "information",
"isVisible": true,
"key": "VENDNAME",
"label": "Vendor name stored on order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order and vendor context",
"detailRole": "information",
"isVisible": true,
"key": "VENDORID",
"label": "Order vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order and vendor context",
"detailRole": "information",
"isVisible": true,
"key": "CurrentVendorName",
"label": "Current vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order and vendor context",
"detailRole": "information",
"isVisible": true,
"key": "VendorState",
"label": "Current vendor master availability",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order and vendor context",
"detailRole": "information",
"isVisible": true,
"key": "Scope",
"label": "Source document scope",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored states",
"detailRole": "information",
"isVisible": true,
"key": "OrderStatus",
"label": "Documented order status context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored states",
"detailRole": "information",
"isVisible": true,
"key": "POSTATUS",
"label": "Stored order status code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored states",
"detailRole": "information",
"isVisible": true,
"key": "OrderType",
"label": "Documented order type context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored states",
"detailRole": "information",
"isVisible": true,
"key": "POTYPE",
"label": "Stored order type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored states",
"detailRole": "information",
"isVisible": true,
"key": "HOLD",
"label": "Stored order hold (1 = yes)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored states",
"detailRole": "information",
"isVisible": true,
"key": "WorkflowContext",
"label": "Documented workflow code context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored states",
"detailRole": "information",
"isVisible": true,
"key": "Workflow_Approval_Status",
"label": "Stored workflow approval code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored states",
"detailRole": "information",
"isVisible": true,
"key": "LineState",
"label": "Line identity availability",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order dates and commercial references",
"detailRole": "information",
"isVisible": true,
"key": "DOCDATE",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order dates and commercial references",
"detailRole": "information",
"isVisible": true,
"key": "PRMDATE",
"label": "Expected receipt date (PRMDATE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order dates and commercial references",
"detailRole": "information",
"isVisible": true,
"key": "REQDATE",
"label": "Source requested-date setting (REQDATE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order dates and commercial references",
"detailRole": "information",
"isVisible": true,
"key": "PRMSHPDTE",
"label": "Source ship-date setting (PRMSHPDTE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order dates and commercial references",
"detailRole": "information",
"isVisible": true,
"key": "BUYERID",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order dates and commercial references",
"detailRole": "information",
"isVisible": true,
"key": "CONFIRM1",
"label": "Confirmation reference (CONFIRM1)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order dates and commercial references",
"detailRole": "information",
"isVisible": true,
"key": "POPCONTNUM",
"label": "Contract reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order dates and commercial references",
"detailRole": "information",
"isVisible": true,
"key": "CONTENDDTE",
"label": "Source contract end-date setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order dates and commercial references",
"detailRole": "information",
"isVisible": true,
"key": "PYMTRMID",
"label": "Order payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order dates and commercial references",
"detailRole": "information",
"isVisible": true,
"key": "SHIPMTHD",
"label": "Shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Original monetary components — own currency",
"detailRole": "information",
"isVisible": true,
"key": "CURNCYID",
"label": "Order currency ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Original monetary components — own currency",
"detailRole": "information",
"isVisible": true,
"key": "ORSUBTOT",
"label": "Source originating subtotal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Original monetary components — own currency",
"detailRole": "information",
"isVisible": true,
"key": "ORTDISAM",
"label": "Source originating trade discount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Original monetary components — own currency",
"detailRole": "information",
"isVisible": true,
"key": "ORFRTAMT",
"label": "Source originating freight",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Original monetary components — own currency",
"detailRole": "information",
"isVisible": true,
"key": "OMISCAMT",
"label": "Source originating miscellaneous amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Original monetary components — own currency",
"detailRole": "information",
"isVisible": true,
"key": "ORTAXAMT",
"label": "Source originating tax amount",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to identity",
"detailRole": "information",
"isVisible": true,
"key": "PRSTADCD",
"label": "Ship-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to identity",
"detailRole": "information",
"isVisible": true,
"key": "CMPNYNAM",
"label": "Ship-to company / name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to identity",
"detailRole": "information",
"isVisible": true,
"key": "CONTACT",
"label": "Ship-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS1",
"label": "Ship-to address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS2",
"label": "Ship-to address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS3",
"label": "Ship-to address line 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "CITY",
"label": "Ship-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "STATE",
"label": "Ship-to state / region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "ZIPCODE",
"label": "Ship-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "COUNTRY",
"label": "Ship-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "PHONE1",
"label": "Ship-to phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "PHONE2",
"label": "Ship-to phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "PHONE3",
"label": "Ship-to phone 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "FAX",
"label": "Ship-to fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "4F229F89-293B-5C59-81D2-D2EF55ADAA34",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "FFAAF52C-6A96-54B4-9E4F-28F5F120CE71",
"includeAllOption": false,
"key": "DOCDATE",
"title": "Order-date period",
"type": "date"
},
{
"id": "E1B67C87-25D6-585A-A6D6-791B83C331F1",
"includeAllOption": true,
"key": "VENDORID",
"title": "Order vendor",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "9BA8DDF4-6C48-5D38-A2BA-1E3FF9E7AE5C",
"key": "DOCDATE",
"type": "date"
},
{
"direction": "ascending",
"id": "D4D2FE5F-923B-5B02-A6C1-6026E1229CFA",
"key": "PONUMBER",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "VENDNAME",
"systemImage": "cart",
"title": "Purchase order dossier",
"titleKey": "PONUMBER"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYORDER",
"label": "Ordered",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYCANCE",
"label": "Canceled",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UOFM",
"label": "Unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORUNTCST",
"label": "Originating unit cost",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OREXTCST",
"label": "Originating extended cost",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CURNCYID",
"label": "Own currency ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineStatus",
"label": "Line status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LOCNCODE",
"label": "Location",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "160F3CDA-456D-5A46-8993-9915BA8C750D",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Source item / service",
"detailRole": "information",
"isVisible": true,
"key": "ITEMDESC",
"label": "Item / service description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source item / service",
"detailRole": "information",
"isVisible": true,
"key": "ITEMNMBR",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source item / service",
"detailRole": "information",
"isVisible": true,
"key": "VNDITNUM",
"label": "Vendor item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source item / service",
"detailRole": "information",
"isVisible": true,
"key": "VNDITDSC",
"label": "Vendor item description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source item / service",
"detailRole": "information",
"isVisible": true,
"key": "NONINVEN",
"label": "Native non-inventory flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source item / service",
"detailRole": "information",
"isVisible": true,
"key": "LOCNCODE",
"label": "Line location code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source quantity and cost — no totals inferred",
"detailRole": "information",
"isVisible": true,
"key": "QTYORDER",
"label": "Source ordered quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source quantity and cost — no totals inferred",
"detailRole": "information",
"isVisible": true,
"key": "QTYCANCE",
"label": "Source canceled quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source quantity and cost — no totals inferred",
"detailRole": "information",
"isVisible": true,
"key": "UOFM",
"label": "Unit on line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source quantity and cost — no totals inferred",
"detailRole": "information",
"isVisible": true,
"key": "ORUNTCST",
"label": "Source originating unit cost",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source quantity and cost — no totals inferred",
"detailRole": "information",
"isVisible": true,
"key": "OREXTCST",
"label": "Source originating extended cost",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source quantity and cost — no totals inferred",
"detailRole": "information",
"isVisible": true,
"key": "CURNCYID",
"label": "Line currency ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Source quantity and cost — no totals inferred",
"detailRole": "information",
"isVisible": true,
"key": "Scope",
"label": "Line scope — not an outstanding quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored line states",
"detailRole": "information",
"isVisible": true,
"key": "LineStatus",
"label": "Documented line status context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored line states",
"detailRole": "information",
"isVisible": true,
"key": "POLNESTA",
"label": "Stored line status code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored line states",
"detailRole": "information",
"isVisible": true,
"key": "LineType",
"label": "Documented line type context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored line states",
"detailRole": "information",
"isVisible": true,
"key": "POTYPE",
"label": "Stored line order type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored line states",
"detailRole": "information",
"isVisible": true,
"key": "TypeContext",
"label": "Line / order type comparison",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored line states",
"detailRole": "information",
"isVisible": true,
"key": "LINEORIGIN",
"label": "Stored line origin code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Independent stored line states",
"detailRole": "information",
"isVisible": true,
"key": "OriginContext",
"label": "Documented line origin context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent, vendor and requested context",
"detailRole": "information",
"isVisible": true,
"key": "PONUMBER",
"label": "Purchase order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent, vendor and requested context",
"detailRole": "information",
"isVisible": true,
"key": "VENDORID",
"label": "Vendor code stored on line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent, vendor and requested context",
"detailRole": "information",
"isVisible": true,
"key": "VendorContext",
"label": "Line / order vendor comparison",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent, vendor and requested context",
"detailRole": "information",
"isVisible": true,
"key": "REQSTDBY",
"label": "Requested-by reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent, vendor and requested context",
"detailRole": "information",
"isVisible": true,
"key": "REQDATE",
"label": "Source requested-date setting (REQDATE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Parent, vendor and requested context",
"detailRole": "information",
"isVisible": true,
"key": "PRMDATE",
"label": "Source receipt-date setting (PRMDATE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Parent, vendor and requested context",
"detailRole": "information",
"isVisible": true,
"key": "PRMSHPDTE",
"label": "Source ship-date setting (PRMSHPDTE)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Line ship-to identity",
"detailRole": "information",
"isVisible": true,
"key": "ADRSCODE",
"label": "Line ship-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to identity",
"detailRole": "information",
"isVisible": true,
"key": "CMPNYNAM",
"label": "Line ship-to company / name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to identity",
"detailRole": "information",
"isVisible": true,
"key": "CONTACT",
"label": "Line ship-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS1",
"label": "Line ship-to address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS2",
"label": "Line ship-to address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS3",
"label": "Line ship-to address line 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "CITY",
"label": "Line ship-to city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "STATE",
"label": "Line ship-to state / region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "ZIPCODE",
"label": "Line ship-to postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "COUNTRY",
"label": "Line ship-to country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "PHONE1",
"label": "Line ship-to phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "PHONE2",
"label": "Line ship-to phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "PHONE3",
"label": "Line ship-to phone 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line ship-to address and contact",
"detailRole": "information",
"isVisible": true,
"key": "FAX",
"label": "Line ship-to fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "A3E73921-46C4-532E-93AF-D43AE1052DB5",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ITEMNMBR",
"systemImage": "list.bullet",
"title": "Purchase order lines",
"titleKey": "ITEMDESC"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VNDCNTCT",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PHNUMBR1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CITY",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PYMTRMID",
"label": "Payment terms",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CURNCYID",
"label": "Own currency ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HOLD",
"label": "Stored hold (1=yes)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "8EA72616-AE37-51AF-8BCD-C8F246A46637",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "VENDNAME",
"label": "Vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "VENDORID",
"label": "Vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "VENDSHNM",
"label": "Short name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "VNDCHKNM",
"label": "Payee / check name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "VNDCLSID",
"label": "Vendor class",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "ACNMVNDR",
"label": "Our account code with vendor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Primary contact",
"detailRole": "information",
"isVisible": true,
"key": "VNDCNTCT",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Primary contact",
"detailRole": "information",
"isVisible": true,
"key": "PHNUMBR1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Primary contact",
"detailRole": "information",
"isVisible": true,
"key": "PHNUMBR2",
"label": "Phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Primary contact",
"detailRole": "information",
"isVisible": true,
"key": "PHONE3",
"label": "Phone 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Primary contact",
"detailRole": "information",
"isVisible": true,
"key": "FAXNUMBR",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS2",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS3",
"label": "Address line 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "CITY",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "STATE",
"label": "State / region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "ZIPCODE",
"label": "Postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "COUNTRY",
"label": "Country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "VADDCDPR",
"label": "Primary address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "VADCDTRO",
"label": "Remit-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "VADCDPAD",
"label": "Address default code (VADCDPAD)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "VADCDSFR",
"label": "Address default code (VADCDSFR)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "SHIPMTHD",
"label": "Shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "TAXSCHID",
"label": "Tax schedule code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "UPSZONE",
"label": "UPS zone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "PYMTRMID",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "PYMNTPRI",
"label": "Payment priority code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "DISGRPER",
"label": "Discount grace days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "DUEGRPER",
"label": "Due-date grace days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "CURNCYID",
"label": "Default currency ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "RATETPID",
"label": "Exchange-rate type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored payment hold and status",
"detailRole": "information",
"isVisible": true,
"key": "HOLD",
"label": "Stored payment hold (1 = yes)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored payment hold and status",
"detailRole": "information",
"isVisible": true,
"key": "VENDSTTS",
"label": "Stored vendor status code (3 = temporary)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Business notes",
"detailRole": "information",
"isVisible": true,
"key": "COMMENT1",
"label": "Comment 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Business notes",
"detailRole": "information",
"isVisible": true,
"key": "COMMENT2",
"label": "Comment 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current master context",
"detailRole": "information",
"isVisible": true,
"key": "MasterScope",
"label": "Current master context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "462814EF-74E1-5545-B218-56A5D86476EC",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "44EA15AF-43DA-5B5D-8A52-17FD850DB6B6",
"key": "VENDORID",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "VENDORID",
"systemImage": "building.2",
"title": "Current order vendor",
"titleKey": "VENDNAME"
}
],
"relations": [
{
"childDatasetID": "160F3CDA-456D-5A46-8993-9915BA8C750D",
"childKey": "ParentOrderKey",
"id": "E6242D1E-485B-5D20-986C-8F5C69C9D63C",
"name": "Order lines",
"parentDatasetID": "37AE404D-6B67-5EEC-9508-70465D2E9C36",
"parentKey": "PONUMBER"
},
{
"childDatasetID": "8EA72616-AE37-51AF-8BCD-C8F246A46637",
"childKey": "ParentOrderKey",
"id": "2819C4CC-8CCF-5B37-80BD-E5E9B850D1EA",
"name": "Current vendor",
"parentDatasetID": "37AE404D-6B67-5EEC-9508-70465D2E9C36",
"parentKey": "PONUMBER"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Microsoft Dynamics GP",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-09T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. Selected full POP10100/POP10110 projections are pinned to Microsoft source registrations from 2022-11-01, commit 1c63171e70c01aa143b5aaff427ed087cd70a9f9. The 2026 reduced projections at commit e7ed235bc979c0283306e9639ff7cd22ce78341d corroborate only their common fields and source relations. Neither is installed SQL DDL or a current complete GP database dictionary. Verify historical extra fields, company database, dbo objects, actual types/keys, GP version, financial interpretation and import read test before use. No real GP/SQL Server/iOS test, installed edition, ERP authorization or query performance is certified.\n\nFor purchasing, receiving, accounts payable and managers: choose an order-date period and optionally a vendor. Open a rich order dossier with stored vendor name, current master availability, independent status/type/hold/workflow, buyer, contract, delivery dates, own currency components and ship-to contact/address. Read the selected order's item/service lines or current supplier dossier only when needed. Lines keep vendor item references, units, ordered/canceled quantities, originating costs, dates, origin and their own ship-to details.\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 company source, one Home, three lists and two lazy sub-buttons. Explicit read-only SELECT, no SELECT *, credentials, business rows, SQL writes or executable code in this export. Native order-date start/end and optional vendor selection precede the 1,000-row read cap. Children revalidate the exact current parent and are not filtered again by the date period. No scheduled refresh. A cap/filter is not a performance guarantee or proof of complete results; test indexes, plans and Cifru wrapping on the actual authorised source. SQLite tests exercise synthetic selection logic, not installed SQL Server types or execution plans.\n\nCurrent POP10100/POP10110 orders only, not separate POP30100/POP30110 history, a receipt ledger, posted vendor invoices or payments. Do not copy the Microsoft migration-only Standard/status 1–4 restriction: closed, canceled, blanket, drop-ship and unknown stored types/statuses remain visible inside the selected order-date period. NULL order dates are excluded by this mandatory date read; an empty read is not proof that the company has no orders. Native numeric codes remain alongside their own evidenced AL enum context; unknown/NULL codes are not guessed. Closed or Approved is not proof of payment, permission or effective workflow eligibility. Header hold, workflow and current vendor payment hold/status are independent states.\n\nBlanket control and release lines must not be added together. GP control line 0 cannot be received/invoiced and is excluded from the GP subtotal; physical ORD/BRKFLD1-to-display-line mapping is not proven here, so no control/release role is guessed. Full PONUMBER+ORD+BRKFLD1 identity stays hidden, not item-code deduplication. Quantities are original QTYORDER/QTYCANCE in their own UOFM; no remaining, received, invoiced, stock or Qty-times-cost formula. Line vendor/type mismatches remain visible with an explicit comparison, not suppressed.\n\nOnly originating-labelled monetary components ORSUBTOT/ORTDISAM/ORFRTAMT/OMISCAMT/ORTAXAMT and ORUNTCST/OREXTCST are projected. Keep header and line own CURNCYID, not the current vendor's default. No currency conversion, functional-currency assignment, tax reconstruction, derived order total or cross-currency aggregation. Currency IDs need not be ISO; verify installed originating interpretation. Money and quantities use lossless source text, so local sorting/filtering is textual, not numeric aggregation. NULL, zero, negative and tiny values remain distinct. Date settings retain their native field name where physical field-to-business-role interpretation is not certified.\n\nOrder/line CMPNYNAM, CONTACT and addresses are ship-to context, not supplier master contact. VENDNAME on order is stored document context; the separate supplier is current PM00200 metadata, not a historical snapshot. Missing or ambiguous vendor metadata preserves the order with an explicit state and empty enrichment; it never chooses an arbitrary first supplier. A changed header vendor blocks an old vendor-button binding until the parent is reread. NULL/duplicate full line identity blocks that whole child and shows its reason in the parent. Invalid/duplicate order identities block the whole root read; inspect integrity rather than interpreting it as an empty purchasing module. Business codes keep leading zeros, case and leading spaces; only right padding is removed. Binary Unicode comparison and length prefixes do not certify the installed collation or SQL constraints.\n\nUse a separately authorised least-privilege SELECT reporting login on allowed company data, not DYNAMICS, BC staging, sa, sysadmin or DYNGRP. GP application passwords are transformed; obtain an authorised SQL login. Cifru filters are not access control and do not inherit ERP permissions. Real supplier/contact/commercial data may be confidential. Captures must use native Cifru and wholly fictional DEMO data, never a live company. Unofficial, not endorsed by Microsoft.\n\nFull historical registrations: https://raw.githubusercontent.com/microsoft/ALAppExtensions/1c63171e70c01aa143b5aaff427ed087cd70a9f9/Apps/W1/HybridGP/app/src/codeunits/GPCloudMigration.codeunit.al\nCurrent reduced registrations: https://raw.githubusercontent.com/microsoft/ALAppExtensions/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/codeunits/GPCloudMigration.codeunit.al\nHistorical order fields: https://raw.githubusercontent.com/microsoft/ALAppExtensions/1c63171e70c01aa143b5aaff427ed087cd70a9f9/Apps/W1/HybridGP/app/src/Migration/Support/PurchaseOrders/GPPOPPOHeader.table.al\nHistorical line fields: https://raw.githubusercontent.com/microsoft/ALAppExtensions/1c63171e70c01aa143b5aaff427ed087cd70a9f9/Apps/W1/HybridGP/app/src/Migration/Support/PurchaseOrders/GPPOPPOLine.table.al\nCurrent vendor fields: https://raw.githubusercontent.com/microsoft/ALAppExtensions/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/Migration/Vendors/GPPM00200.Table.al\nPurchasing semantics: https://learn.microsoft.com/en-us/dynamics-gp/distribution/purchase-order-processing-part2-orders\nReceiving semantics: https://learn.microsoft.com/en-us/dynamics-gp/distribution/purchase-order-processing-part3-receipts",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "2214341D-F6AE-5371-98AC-5CB99E7DEFAF",
"rootButtonCount": 1,
"summary": "Order-date dossiers with buyer, delivery, original currency components, on-demand lines and current suppliers.",
"tags": [
"Dynamics GP",
"SQL Server",
"Purchase orders",
"Purchasing",
"Vendors",
"Receiving",
"Pro"
],
"title": "Purchase orders, lines and current vendor — Pro"
}
}