Purchase orders — items and receiving Pro
Period/company to purchase orders, full operational dossiers and on-demand items with separate currencies and receiving context.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For buyers, operations teams, finance and managers: choose order period and creator company, inspect purchase order status, buyer/approval dates, vendor, payment and shipping context, then open its stored items on demand. See quantities, receiving status, expected delivery, service rates, separate transaction/functional amounts and useful notes.
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 SQL Server source, two lists and one relation; 36 order fields and 35 item fields. MasterPKey and the full MasterPKey+PODetailPKey line identity are hidden, not replaced by order number, item number or sequence. Choose the native order period (start/end-exclusive) and mandatory creator company before the order read. The SQL connector applies these native opening predicates, plus selected status/closed choices, to the projected query before its bounded read. There is no root TOP or LIMIT before the predicates, and no unresolved opening parameter is required to discover selector choices. Items are scoped by the selected master AND company before their limit. Opening selectors may discover a bounded superset of source values; an option is not proof of matching orders in the chosen period. This is not SQL access control; no count/completeness or fast-query guarantee. Live reads, up to 2,000 displayed rows per list, no automatic refresh.
TotalNetAmount is the STORED net total in the creator company FUNCTIONAL currency when multicurrency is enabled. FunctionalCurrencyCode is read from the same-edition CFGMainData.Company key, not guessed from the PO transaction CurrencyCode. Item NetAmount, estimated shipping/taxes and extra amounts use order TRANSACTION currency; NetAmountFunctionalCurrency is separate. Unit price uses the order unit; a Service order may use hours/rates. No conversion, paid/outstanding amount, grand total, sum of currencies or recomputed effective/change-order total. Unknown/blank currency remains blank and requires a real preview. Unused DiscountAmount/ReceivedAmount are not projected.
The item functional amount is documented as the active-company amount; the displayed functional currency is the PO creator-company setup. Confirm that these contexts match in the installed system before interpreting item functional amounts. This read is not a historical exchange-rate or company-context certification.
Each stored item key remains separate, including change-order-linked records. Line origin identifies only presence of a COPKey link, not approved/latest change status; change-order details, approval history and cost-distribution projects are NOT joined. Stored received quantity/status are not acceptance/rejection receipt history, stock balance or an inferred completion state. Closed order, processing status and received status are distinct; unknown codes stay visible, NULL does not become No or zero. Inventory quantities apply only when present in your inventory setup, not every service or purchasing item.
Vendor name is CURRENT enrichment only when Clendor has exactly one nonblank matching vendor business number. Ambiguous/missing names remain blank; no arbitrary first firm, duplicated orders or historical vendor snapshot. Buyer/approver/requester names use EMMain.Employee; payroll and private employee contact are not read. Company identifies the PO creator company, not automatically a purchasing company or ERP permission scope. Root shipping address/contact is exposed only for the documented OTHER ship-to case, joined from stored address parts; for configured ship-to codes this dossier shows the reference, not a guessed lookup address. Item shipping is its stored override, not automatically inherited from the root. Native payment, FOB, shipping and category codes are not invented descriptions.
Agreement start/end, description and terms are conditional for Blanket/Service. Specific PayDate is shown only for native PayTerms=Date. Excess percentage is shown only when AllowExcess=Y; no enforcement action is performed. Agreement authorization limits/extra amount ceilings are not projected until their installed monetary context is independently confirmed. Internal notes can contain confidential text: authorise source access and inspect them before sharing. This is an operational dossier, not the entire purchasing module.
Physical columns/types/keys are official 2025.1 POMaster/PODetail/EMMain/Clendor plus CFGMainData dictionary. Supplementary purchase UI meanings are frozen 7.2 help, not same-edition or installed compatibility certification. Read only an administrator-approved on-premises SQL Server database using a dedicated least-privilege SELECT account. Direct SQL does NOT inherit Deltek company/employee confidentiality, role or masking permissions. Verify DB, default schema, projected columns, company scope, currency settings, codes and timings in a real Cifru read test/preview at import. No dbo assumption, sa/sysadmin, writes, DDL, administrative actions or direct Deltek Cloud access. The schema guard refuses ambiguous resolution; it does not certify the database, query cost or authorised scope.
Not tested on a real ERP or SQL Server; SQLite adapter/native fictional DEMO captures do not prove installed compatibility. No source credentials, server address, cached business rows, executable code or vendor HTML in the download. Unofficial, not affiliated with Deltek.
Physical dictionary: https://help.deltek.com/product/Vantagepoint/2025.1/DataDictionary/index.htm
Purchase context: https://help.deltek.com/Product/Vantagepoint/7.2/browser_pur_general_tab_of_po_header.html
Item context: https://help.deltek.com/product/Vantagepoint/7.2/browser_pur_contents_of_po_line_detail_dialog.html
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Purchase orders
- Details: Purchase items
- Sub-button: Purchase items
Sources are mapped locally and verified before applying.
Custom queriesPRO2 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 p.MasterPKey AS MasterPKey, p.PONumber AS PONumber, p.ReleaseNumber AS ReleaseNumber, CASE p.Type WHEN N'R' THEN N'Standard' WHEN N'B' THEN N'Blanket' WHEN N'S' THEN N'Service' ELSE CASE WHEN p.Type IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Type)) END END AS TypeLabel, CASE p.Status WHEN N'N' THEN N'In Progress' WHEN N'S' THEN N'Submitted' WHEN N'A' THEN N'Approved' WHEN N'J' THEN N'Rejected' WHEN N'R' THEN N'Released (Blanket only)' WHEN N'P' THEN N'Printed' WHEN N'G' THEN N'Changed' WHEN N'C' THEN N'Cancelled' ELSE CASE WHEN p.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Status)) END END AS Status, CASE p.Closed WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN p.Closed IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Closed)) END END AS Closed, p.OrderDate AS OrderDate, p.Company AS Company, co.FirmName AS CompanyName, p.CurrencyCode AS CurrencyCode, co.FunctionalCurrencyCode AS FunctionalCurrencyCode, p.TotalNetAmount AS TotalNetAmount, p.Vendor AS Vendor, v.VendorName AS VendorName, p.Address AS Address, NULLIF(LTRIM(RTRIM(CONCAT(byr.FirstName,N' ',byr.LastName))),N'') AS BuyerName, NULLIF(LTRIM(RTRIM(CONCAT(apr.FirstName,N' ',apr.LastName))),N'') AS ApproverName, p.PayTerms AS PayTerms, CASE WHEN p.PayTerms=N'Date' THEN p.PayDate ELSE NULL END AS PayDate, p.SubmittedDate AS SubmittedDate, p.AuthorizedDate AS AuthorizedDate, p.FinalPrintDate AS FinalPrintDate, p.ShipTo AS ShipTo, p.BillTo AS BillTo, CASE WHEN p.ShipTo=N'OTHER' THEN CONCAT(CASE WHEN NULLIF(LTRIM(RTRIM(p.FirmName)),N'') IS NULL THEN N'' ELSE CONCAT(N'',p.FirmName) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Address1)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Address1) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Address2)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Address2) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Address3)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Address3) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Address4)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Address4) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.City)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.City) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.State)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.State) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Zip)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Zip) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Country)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Country) END) ELSE NULL END AS ShipDestination, CASE WHEN p.ShipTo=N'OTHER' THEN p.ContactName ELSE NULL END AS ContactName, CASE WHEN p.ShipTo=N'OTHER' THEN p.Phone ELSE NULL END AS Phone, CASE WHEN p.ShipTo=N'OTHER' THEN p.EMail ELSE NULL END AS EMail, CASE WHEN p.ShipTo=N'OTHER' THEN p.ShipVia ELSE NULL END AS ShipVia, CASE WHEN p.ShipTo=N'OTHER' THEN p.FOB ELSE NULL END AS FOB, CASE WHEN p.Type IN (N'B',N'S') THEN p.StartDate ELSE NULL END AS StartDate, CASE WHEN p.Type IN (N'B',N'S') THEN p.EndDate ELSE NULL END AS EndDate, CASE p.AllowExcess WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN p.AllowExcess IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.AllowExcess)) END END AS AllowExcess, CASE WHEN p.AllowExcess=N'Y' THEN p.ExcessPct ELSE NULL END AS ExcessPct, CASE WHEN p.Type IN (N'B',N'S') THEN p.Descriptions ELSE NULL END AS Descriptions, CASE WHEN p.Type IN (N'B',N'S') THEN p.Comments ELSE NULL END AS Comments, p.POInternalNotes AS POInternalNotes FROM POMaster p LEFT JOIN EMMain byr ON byr.Employee=p.Buyer LEFT JOIN EMMain apr ON apr.Employee=p.AuthorizedBy LEFT JOIN (SELECT Vendor,MAX(Name) AS VendorName FROM Clendor WHERE NULLIF(LTRIM(RTRIM(Vendor)),N'') IS NOT NULL GROUP BY Vendor HAVING COUNT(*)=1) v ON v.Vendor=p.Vendor LEFT JOIN CFGMainData co ON co.Company=p.Company WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'POMaster',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.POMaster',N'U') AND OBJECT_ID(N'PODetail',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PODetail',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'Clendor',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Clendor',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT p.MasterPKey AS MasterPKey, CONCAT(DATALENGTH(d.MasterPKey),N':',d.MasterPKey,N':',DATALENGTH(d.PODetailPKey),N':',d.PODetailPKey) AS LineKey, d.Item AS Item, d.Description AS Description, d.VendorItem AS VendorItem, d.Category AS Category, d.Qty AS Qty, d.ReceivedQty AS ReceivedQty, d.UOM AS UOM, CASE d.ReceiveStatus WHEN N'R' THEN N'Fully received' WHEN N'P' THEN N'Partially received' WHEN N'B' THEN N'Back-ordered' WHEN N'X' THEN N'Closed' ELSE CASE WHEN d.ReceiveStatus IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(d.ReceiveStatus)) END END AS ReceiveStatus, d.DueDate AS DueDate, d.UnitPrice AS UnitPrice, d.NetAmount AS NetAmount, p.CurrencyCode AS CurrencyCode, d.NetAmountFunctionalCurrency AS NetAmountFunctionalCurrency, co.FunctionalCurrencyCode AS FunctionalCurrencyCode, d.ShipAmount AS ShipAmount, d.TaxAmount AS TaxAmount, d.Tax2Amount AS Tax2Amount, d.MiscAmount1 AS MiscAmount1, d.MiscAmount2 AS MiscAmount2, d.MiscAmount3 AS MiscAmount3, d.MiscAmount4 AS MiscAmount4, d.MiscAmount5 AS MiscAmount5, CASE WHEN NULLIF(LTRIM(RTRIM(d.COPKey)),N'') IS NULL THEN N'Base order line' ELSE N'Change-order-linked line' END AS LineOrigin, d.RequisitionNo AS RequisitionNo, NULLIF(LTRIM(RTRIM(CONCAT(req.FirstName,N' ',req.LastName))),N'') AS RequesterName, d.InventoryQty AS InventoryQty, d.InventoryUOM AS InventoryUOM, d.ShipTo AS ShipTo, CONCAT(CASE WHEN NULLIF(LTRIM(RTRIM(d.FirmName)),N'') IS NULL THEN N'' ELSE CONCAT(N'',d.FirmName) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Address1)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Address1) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Address2)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Address2) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Address3)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Address3) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Address4)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Address4) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.City)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.City) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.State)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.State) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Zip)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Zip) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Country)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Country) END) AS ShipDestination, d.ContactName AS ContactName, d.Phone AS Phone, d.EMail AS EMail, d.ShipVia AS ShipVia, d.ExtraNotes AS ExtraNotes, d.InternalNotes AS InternalNotes FROM PODetail d INNER JOIN POMaster p ON p.MasterPKey=d.MasterPKey LEFT JOIN EMMain req ON req.Employee=d.RequestedBy LEFT JOIN CFGMainData co ON co.Company=p.Company WHERE p.MasterPKey=:order_id AND p.Company=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'POMaster',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.POMaster',N'U') AND OBJECT_ID(N'PODetail',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PODetail',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'Clendor',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Clendor',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Vantagepoint — authorised SQL Server database",
"id": "1BEF66DC-2A74-58E5-8D97-0F77430C59EA",
"kind": "sqlServer",
"requiredObjects": [
"POMaster",
"PODetail",
"EMMain",
"Clendor",
"CFGMainData"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "06F66C5F-BEE4-553C-95FB-23A18095B576",
"key": "OrderDate",
"type": "date"
},
{
"direction": "ascending",
"id": "CA071827-39BF-5681-8884-6E2FE9A3995A",
"key": "MasterPKey",
"type": "text"
}
],
"id": "88343429-4149-5DC2-A744-192CFF272382",
"mappings": [
{
"commonFieldKey": "",
"key": "MasterPKey",
"label": "Internal MasterPKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MasterPKey",
"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": "ReleaseNumber",
"label": "Release number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ReleaseNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TypeLabel",
"label": "Order type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TypeLabel",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Status",
"label": "Order processing status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Closed",
"label": "Order closed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Closed",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderDate",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Company",
"label": "Creator company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Company",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyName",
"label": "Company name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FunctionalCurrencyCode",
"label": "Company functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FunctionalCurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TotalNetAmount",
"label": "Stored net total — functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TotalNetAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Vendor",
"label": "Vendor number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Vendor",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VendorName",
"label": "Current unambiguous vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Address",
"label": "Vendor address reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Address",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BuyerName",
"label": "Buyer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BuyerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ApproverName",
"label": "Approver",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ApproverName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PayTerms",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PayTerms",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PayDate",
"label": "Specific payment date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PayDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SubmittedDate",
"label": "Submitted for approval",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SubmittedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AuthorizedDate",
"label": "Approval date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AuthorizedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FinalPrintDate",
"label": "Final print date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FinalPrintDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShipTo",
"label": "Ship-to reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShipTo",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BillTo",
"label": "Bill-to reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillTo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShipDestination",
"label": "Ship-to address — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShipDestination",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ContactName",
"label": "Ship-to contact — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Phone",
"label": "Ship-to phone — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Phone",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EMail",
"label": "Ship-to email — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EMail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShipVia",
"label": "Ship-via code — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShipVia",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FOB",
"label": "FOB code — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FOB",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StartDate",
"label": "Agreement starts",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StartDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EndDate",
"label": "Agreement ends",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EndDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllowExcess",
"label": "Excess receiving allowed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AllowExcess",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ExcessPct",
"label": "Allowed excess percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ExcessPct",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Descriptions",
"label": "Agreement description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Descriptions",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Comments",
"label": "Agreement terms",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Comments",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POInternalNotes",
"label": "Order internal notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "POInternalNotes",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Purchase orders",
"primaryKey": "MasterPKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"PONumber",
"ReleaseNumber",
"TypeLabel",
"Status",
"Closed",
"OrderDate",
"Company",
"CompanyName",
"CurrencyCode",
"FunctionalCurrencyCode",
"TotalNetAmount",
"Vendor",
"VendorName",
"Address",
"BuyerName",
"ApproverName",
"PayTerms",
"PayDate",
"SubmittedDate",
"AuthorizedDate",
"FinalPrintDate",
"ShipTo",
"BillTo",
"ShipDestination",
"ContactName",
"Phone",
"EMail",
"ShipVia",
"FOB",
"StartDate",
"EndDate",
"AllowExcess",
"ExcessPct",
"Descriptions",
"Comments",
"POInternalNotes"
],
"sourceID": "1BEF66DC-2A74-58E5-8D97-0F77430C59EA",
"sqlQuery": "SELECT p.MasterPKey AS MasterPKey, p.PONumber AS PONumber, p.ReleaseNumber AS ReleaseNumber, CASE p.Type WHEN N'R' THEN N'Standard' WHEN N'B' THEN N'Blanket' WHEN N'S' THEN N'Service' ELSE CASE WHEN p.Type IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Type)) END END AS TypeLabel, CASE p.Status WHEN N'N' THEN N'In Progress' WHEN N'S' THEN N'Submitted' WHEN N'A' THEN N'Approved' WHEN N'J' THEN N'Rejected' WHEN N'R' THEN N'Released (Blanket only)' WHEN N'P' THEN N'Printed' WHEN N'G' THEN N'Changed' WHEN N'C' THEN N'Cancelled' ELSE CASE WHEN p.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Status)) END END AS Status, CASE p.Closed WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN p.Closed IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Closed)) END END AS Closed, p.OrderDate AS OrderDate, p.Company AS Company, co.FirmName AS CompanyName, p.CurrencyCode AS CurrencyCode, co.FunctionalCurrencyCode AS FunctionalCurrencyCode, p.TotalNetAmount AS TotalNetAmount, p.Vendor AS Vendor, v.VendorName AS VendorName, p.Address AS Address, NULLIF(LTRIM(RTRIM(CONCAT(byr.FirstName,N' ',byr.LastName))),N'') AS BuyerName, NULLIF(LTRIM(RTRIM(CONCAT(apr.FirstName,N' ',apr.LastName))),N'') AS ApproverName, p.PayTerms AS PayTerms, CASE WHEN p.PayTerms=N'Date' THEN p.PayDate ELSE NULL END AS PayDate, p.SubmittedDate AS SubmittedDate, p.AuthorizedDate AS AuthorizedDate, p.FinalPrintDate AS FinalPrintDate, p.ShipTo AS ShipTo, p.BillTo AS BillTo, CASE WHEN p.ShipTo=N'OTHER' THEN CONCAT(CASE WHEN NULLIF(LTRIM(RTRIM(p.FirmName)),N'') IS NULL THEN N'' ELSE CONCAT(N'',p.FirmName) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Address1)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Address1) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Address2)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Address2) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Address3)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Address3) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Address4)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Address4) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.City)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.City) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.State)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.State) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Zip)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Zip) END,CASE WHEN NULLIF(LTRIM(RTRIM(p.Country)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',p.Country) END) ELSE NULL END AS ShipDestination, CASE WHEN p.ShipTo=N'OTHER' THEN p.ContactName ELSE NULL END AS ContactName, CASE WHEN p.ShipTo=N'OTHER' THEN p.Phone ELSE NULL END AS Phone, CASE WHEN p.ShipTo=N'OTHER' THEN p.EMail ELSE NULL END AS EMail, CASE WHEN p.ShipTo=N'OTHER' THEN p.ShipVia ELSE NULL END AS ShipVia, CASE WHEN p.ShipTo=N'OTHER' THEN p.FOB ELSE NULL END AS FOB, CASE WHEN p.Type IN (N'B',N'S') THEN p.StartDate ELSE NULL END AS StartDate, CASE WHEN p.Type IN (N'B',N'S') THEN p.EndDate ELSE NULL END AS EndDate, CASE p.AllowExcess WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN p.AllowExcess IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.AllowExcess)) END END AS AllowExcess, CASE WHEN p.AllowExcess=N'Y' THEN p.ExcessPct ELSE NULL END AS ExcessPct, CASE WHEN p.Type IN (N'B',N'S') THEN p.Descriptions ELSE NULL END AS Descriptions, CASE WHEN p.Type IN (N'B',N'S') THEN p.Comments ELSE NULL END AS Comments, p.POInternalNotes AS POInternalNotes FROM POMaster p LEFT JOIN EMMain byr ON byr.Employee=p.Buyer LEFT JOIN EMMain apr ON apr.Employee=p.AuthorizedBy LEFT JOIN (SELECT Vendor,MAX(Name) AS VendorName FROM Clendor WHERE NULLIF(LTRIM(RTRIM(Vendor)),N'') IS NOT NULL GROUP BY Vendor HAVING COUNT(*)=1) v ON v.Vendor=p.Vendor LEFT JOIN CFGMainData co ON co.Company=p.Company WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'POMaster',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.POMaster',N'U') AND OBJECT_ID(N'PODetail',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PODetail',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'Clendor',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Clendor',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "8096CC7D-08A7-5A46-86CE-E08D5A211BA9",
"key": "DueDate",
"type": "date"
},
{
"direction": "ascending",
"id": "73CD423B-238B-5ECB-8650-BFE252ECCAFD",
"key": "Item",
"type": "text"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "4521434F-4E89-570F-8063-71EABDBD3517",
"mappings": [
{
"commonFieldKey": "",
"key": "MasterPKey",
"label": "Internal MasterPKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MasterPKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Internal LineKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Item",
"label": "Item number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Item",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Item description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorItem",
"label": "Vendor item number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorItem",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Category",
"label": "Item category",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Category",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Qty",
"label": "Ordered quantity / service hours",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Qty",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ReceivedQty",
"label": "Stored received quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReceivedQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UOM",
"label": "Order unit of measure",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UOM",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ReceiveStatus",
"label": "Item receiving status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ReceiveStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DueDate",
"label": "Expected delivery date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UnitPrice",
"label": "Unit price / service rate — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UnitPrice",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "NetAmount",
"label": "Net amount — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NetAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "NetAmountFunctionalCurrency",
"label": "Net amount — functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NetAmountFunctionalCurrency",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FunctionalCurrencyCode",
"label": "Company functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FunctionalCurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ShipAmount",
"label": "Estimated shipping — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ShipAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TaxAmount",
"label": "Estimated tax — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TaxAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Tax2Amount",
"label": "Estimated secondary tax — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Tax2Amount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MiscAmount1",
"label": "Estimated extra amount 1 — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MiscAmount1",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MiscAmount2",
"label": "Estimated extra amount 2 — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MiscAmount2",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MiscAmount3",
"label": "Estimated extra amount 3 — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MiscAmount3",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MiscAmount4",
"label": "Estimated extra amount 4 — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MiscAmount4",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MiscAmount5",
"label": "Estimated extra amount 5 — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MiscAmount5",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineOrigin",
"label": "Stored line origin",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineOrigin",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "RequisitionNo",
"label": "Requisition number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RequisitionNo",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RequesterName",
"label": "Requester",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RequesterName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventoryQty",
"label": "Inventory quantity — inventory items only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InventoryQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventoryUOM",
"label": "Inventory unit — inventory items only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventoryUOM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShipTo",
"label": "Line ship-to reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShipTo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShipDestination",
"label": "Stored line ship-to address",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShipDestination",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ContactName",
"label": "Line ship-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Phone",
"label": "Line ship-to phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Phone",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EMail",
"label": "Line ship-to email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EMail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShipVia",
"label": "Line ship-via code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShipVia",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ExtraNotes",
"label": "Extra line notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ExtraNotes",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InternalNotes",
"label": "Internal line notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InternalNotes",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Purchase items",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "MasterPKey",
"id": "2B1246C7-A471-55FF-ABCC-104CBAF95AD7",
"name": "order_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "Company",
"id": "DF514D05-5069-50D9-80BA-EA004363954C",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Item",
"Description",
"VendorItem",
"Category",
"Qty",
"ReceivedQty",
"UOM",
"ReceiveStatus",
"DueDate",
"UnitPrice",
"NetAmount",
"CurrencyCode",
"NetAmountFunctionalCurrency",
"FunctionalCurrencyCode",
"ShipAmount",
"TaxAmount",
"Tax2Amount",
"MiscAmount1",
"MiscAmount2",
"MiscAmount3",
"MiscAmount4",
"MiscAmount5",
"LineOrigin",
"RequisitionNo",
"RequesterName",
"InventoryQty",
"InventoryUOM",
"ShipTo",
"ShipDestination",
"ContactName",
"Phone",
"EMail",
"ShipVia",
"ExtraNotes",
"InternalNotes"
],
"sourceID": "1BEF66DC-2A74-58E5-8D97-0F77430C59EA",
"sqlQuery": "SELECT p.MasterPKey AS MasterPKey, CONCAT(DATALENGTH(d.MasterPKey),N':',d.MasterPKey,N':',DATALENGTH(d.PODetailPKey),N':',d.PODetailPKey) AS LineKey, d.Item AS Item, d.Description AS Description, d.VendorItem AS VendorItem, d.Category AS Category, d.Qty AS Qty, d.ReceivedQty AS ReceivedQty, d.UOM AS UOM, CASE d.ReceiveStatus WHEN N'R' THEN N'Fully received' WHEN N'P' THEN N'Partially received' WHEN N'B' THEN N'Back-ordered' WHEN N'X' THEN N'Closed' ELSE CASE WHEN d.ReceiveStatus IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(d.ReceiveStatus)) END END AS ReceiveStatus, d.DueDate AS DueDate, d.UnitPrice AS UnitPrice, d.NetAmount AS NetAmount, p.CurrencyCode AS CurrencyCode, d.NetAmountFunctionalCurrency AS NetAmountFunctionalCurrency, co.FunctionalCurrencyCode AS FunctionalCurrencyCode, d.ShipAmount AS ShipAmount, d.TaxAmount AS TaxAmount, d.Tax2Amount AS Tax2Amount, d.MiscAmount1 AS MiscAmount1, d.MiscAmount2 AS MiscAmount2, d.MiscAmount3 AS MiscAmount3, d.MiscAmount4 AS MiscAmount4, d.MiscAmount5 AS MiscAmount5, CASE WHEN NULLIF(LTRIM(RTRIM(d.COPKey)),N'') IS NULL THEN N'Base order line' ELSE N'Change-order-linked line' END AS LineOrigin, d.RequisitionNo AS RequisitionNo, NULLIF(LTRIM(RTRIM(CONCAT(req.FirstName,N' ',req.LastName))),N'') AS RequesterName, d.InventoryQty AS InventoryQty, d.InventoryUOM AS InventoryUOM, d.ShipTo AS ShipTo, CONCAT(CASE WHEN NULLIF(LTRIM(RTRIM(d.FirmName)),N'') IS NULL THEN N'' ELSE CONCAT(N'',d.FirmName) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Address1)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Address1) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Address2)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Address2) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Address3)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Address3) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Address4)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Address4) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.City)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.City) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.State)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.State) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Zip)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Zip) END,CASE WHEN NULLIF(LTRIM(RTRIM(d.Country)),N'') IS NULL THEN N'' ELSE CONCAT(N' | ',d.Country) END) AS ShipDestination, d.ContactName AS ContactName, d.Phone AS Phone, d.EMail AS EMail, d.ShipVia AS ShipVia, d.ExtraNotes AS ExtraNotes, d.InternalNotes AS InternalNotes FROM PODetail d INNER JOIN POMaster p ON p.MasterPKey=d.MasterPKey LEFT JOIN EMMain req ON req.Employee=d.RequestedBy LEFT JOIN CFGMainData co ON co.Company=p.Company WHERE p.MasterPKey=:order_id AND p.Company=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'POMaster',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.POMaster',N'U') AND OBJECT_ID(N'PODetail',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PODetail',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'Clendor',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Clendor',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "D0D1975C-46CB-5208-B1BD-20481E19639A",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "553164CB-0A81-521B-B613-18170EA55B17",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "4521434F-4E89-570F-8063-71EABDBD3517",
"title": "Purchase items",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TypeLabel",
"label": "Order type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Order processing status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Closed",
"label": "Order closed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderDate",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CompanyName",
"label": "Company name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FunctionalCurrencyCode",
"label": "Company functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TotalNetAmount",
"label": "Stored net total — functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BuyerName",
"label": "Buyer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ShipTo",
"label": "Ship-to reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Vendor",
"label": "Vendor number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "88343429-4149-5DC2-A744-192CFF272382",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "PONumber",
"label": "Purchase order number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "VendorName",
"label": "Current unambiguous vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "TypeLabel",
"label": "Order type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Order processing status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "Closed",
"label": "Order closed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "OrderDate",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "CompanyName",
"label": "Company name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "FunctionalCurrencyCode",
"label": "Company functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "TotalNetAmount",
"label": "Stored net total — functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "BuyerName",
"label": "Buyer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "ShipTo",
"label": "Ship-to reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order status, company and native total",
"detailRole": "information",
"isVisible": true,
"key": "Vendor",
"label": "Vendor number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Vendor and approval context",
"detailRole": "information",
"isVisible": true,
"key": "ReleaseNumber",
"label": "Release number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Vendor and approval context",
"detailRole": "information",
"isVisible": true,
"key": "Company",
"label": "Creator company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Vendor and approval context",
"detailRole": "information",
"isVisible": true,
"key": "Address",
"label": "Vendor address reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Vendor and approval context",
"detailRole": "information",
"isVisible": true,
"key": "ApproverName",
"label": "Approver",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Vendor and approval context",
"detailRole": "information",
"isVisible": true,
"key": "SubmittedDate",
"label": "Submitted for approval",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vendor and approval context",
"detailRole": "information",
"isVisible": true,
"key": "AuthorizedDate",
"label": "Approval date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vendor and approval context",
"detailRole": "information",
"isVisible": true,
"key": "FinalPrintDate",
"label": "Final print date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Payment and shipping",
"detailRole": "information",
"isVisible": true,
"key": "PayTerms",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment and shipping",
"detailRole": "information",
"isVisible": true,
"key": "PayDate",
"label": "Specific payment date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Payment and shipping",
"detailRole": "information",
"isVisible": true,
"key": "BillTo",
"label": "Bill-to reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment and shipping",
"detailRole": "information",
"isVisible": true,
"key": "ShipDestination",
"label": "Ship-to address — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment and shipping",
"detailRole": "information",
"isVisible": true,
"key": "ContactName",
"label": "Ship-to contact — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment and shipping",
"detailRole": "information",
"isVisible": true,
"key": "Phone",
"label": "Ship-to phone — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment and shipping",
"detailRole": "information",
"isVisible": true,
"key": "EMail",
"label": "Ship-to email — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment and shipping",
"detailRole": "information",
"isVisible": true,
"key": "ShipVia",
"label": "Ship-via code — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment and shipping",
"detailRole": "information",
"isVisible": true,
"key": "FOB",
"label": "FOB code — OTHER only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Agreement and notes",
"detailRole": "information",
"isVisible": true,
"key": "StartDate",
"label": "Agreement starts",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Agreement and notes",
"detailRole": "information",
"isVisible": true,
"key": "EndDate",
"label": "Agreement ends",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Agreement and notes",
"detailRole": "information",
"isVisible": true,
"key": "AllowExcess",
"label": "Excess receiving allowed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Agreement and notes",
"detailRole": "information",
"isVisible": true,
"key": "ExcessPct",
"label": "Allowed excess percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Agreement and notes",
"detailRole": "information",
"isVisible": true,
"key": "Descriptions",
"label": "Agreement description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Agreement and notes",
"detailRole": "information",
"isVisible": true,
"key": "Comments",
"label": "Agreement terms",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Agreement and notes",
"detailRole": "information",
"isVisible": true,
"key": "POInternalNotes",
"label": "Order internal notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "BBF2DEF6-0318-5CC6-8E35-41665753FA1A",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "D1115789-ACA1-5F55-A8A3-D7E9683552E9",
"includeAllOption": false,
"key": "OrderDate",
"title": "Order period",
"type": "date"
},
{
"id": "5337A42C-DF49-5CF2-A8B0-30C32EA33F2B",
"includeAllOption": false,
"key": "Company",
"title": "Creator company",
"type": "text"
},
{
"id": "33A8695B-1913-5802-BA03-13F8A3AEFA41",
"includeAllOption": true,
"key": "Status",
"title": "Order status",
"type": "text"
},
{
"id": "1A838202-6E12-5ECF-97C7-9D2227C815ED",
"includeAllOption": true,
"key": "Closed",
"title": "Closed",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "06F66C5F-BEE4-553C-95FB-23A18095B576",
"key": "OrderDate",
"type": "date"
},
{
"direction": "ascending",
"id": "CA071827-39BF-5681-8884-6E2FE9A3995A",
"key": "MasterPKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "VendorName",
"systemImage": "doc.text",
"title": "Purchase orders",
"titleKey": "PONumber"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Qty",
"label": "Ordered quantity / service hours",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ReceivedQty",
"label": "Stored received quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UOM",
"label": "Order unit of measure",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ReceiveStatus",
"label": "Item receiving status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Expected delivery date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UnitPrice",
"label": "Unit price / service rate — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NetAmount",
"label": "Net amount — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NetAmountFunctionalCurrency",
"label": "Net amount — functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FunctionalCurrencyCode",
"label": "Company functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineOrigin",
"label": "Stored line origin",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "4521434F-4E89-570F-8063-71EABDBD3517",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Item description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "Item",
"label": "Item number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "Qty",
"label": "Ordered quantity / service hours",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "ReceivedQty",
"label": "Stored received quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "UOM",
"label": "Order unit of measure",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "ReceiveStatus",
"label": "Item receiving status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Expected delivery date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "UnitPrice",
"label": "Unit price / service rate — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "NetAmount",
"label": "Net amount — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "NetAmountFunctionalCurrency",
"label": "Net amount — functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "FunctionalCurrencyCode",
"label": "Company functional currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item, receiving and two native currencies",
"detailRole": "information",
"isVisible": true,
"key": "LineOrigin",
"label": "Stored line origin",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item and estimated transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "VendorItem",
"label": "Vendor item number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item and estimated transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "Category",
"label": "Item category",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item and estimated transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "ShipAmount",
"label": "Estimated shipping — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and estimated transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "TaxAmount",
"label": "Estimated tax — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and estimated transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "Tax2Amount",
"label": "Estimated secondary tax — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and estimated transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "MiscAmount1",
"label": "Estimated extra amount 1 — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and estimated transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "MiscAmount2",
"label": "Estimated extra amount 2 — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and estimated transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "MiscAmount3",
"label": "Estimated extra amount 3 — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and estimated transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "MiscAmount4",
"label": "Estimated extra amount 4 — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and estimated transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "MiscAmount5",
"label": "Estimated extra amount 5 — transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Requester, inventory and shipping",
"detailRole": "information",
"isVisible": true,
"key": "RequisitionNo",
"label": "Requisition number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Requester, inventory and shipping",
"detailRole": "information",
"isVisible": true,
"key": "RequesterName",
"label": "Requester",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Requester, inventory and shipping",
"detailRole": "information",
"isVisible": true,
"key": "InventoryQty",
"label": "Inventory quantity — inventory items only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Requester, inventory and shipping",
"detailRole": "information",
"isVisible": true,
"key": "InventoryUOM",
"label": "Inventory unit — inventory items only",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Requester, inventory and shipping",
"detailRole": "information",
"isVisible": true,
"key": "ShipTo",
"label": "Line ship-to reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Requester, inventory and shipping",
"detailRole": "information",
"isVisible": true,
"key": "ShipDestination",
"label": "Stored line ship-to address",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Requester, inventory and shipping",
"detailRole": "information",
"isVisible": true,
"key": "ContactName",
"label": "Line ship-to contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Requester, inventory and shipping",
"detailRole": "information",
"isVisible": true,
"key": "Phone",
"label": "Line ship-to phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Requester, inventory and shipping",
"detailRole": "information",
"isVisible": true,
"key": "EMail",
"label": "Line ship-to email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Requester, inventory and shipping",
"detailRole": "information",
"isVisible": true,
"key": "ShipVia",
"label": "Line ship-via code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line notes",
"detailRole": "information",
"isVisible": true,
"key": "ExtraNotes",
"label": "Extra line notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line notes",
"detailRole": "information",
"isVisible": true,
"key": "InternalNotes",
"label": "Internal line notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "9C89F938-5B1C-5534-B763-09175E5F1A3C",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "8096CC7D-08A7-5A46-86CE-E08D5A211BA9",
"key": "DueDate",
"type": "date"
},
{
"direction": "ascending",
"id": "73CD423B-238B-5ECB-8650-BFE252ECCAFD",
"key": "Item",
"type": "text"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Item",
"systemImage": "doc.text",
"title": "Purchase items",
"titleKey": "Description"
}
],
"relations": [
{
"childDatasetID": "4521434F-4E89-570F-8063-71EABDBD3517",
"childKey": "MasterPKey",
"id": "553164CB-0A81-521B-B613-18170EA55B17",
"name": "Purchase items",
"parentDatasetID": "88343429-4149-5DC2-A744-192CFF272382",
"parentKey": "MasterPKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Deltek Vantagepoint",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-08T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For buyers, operations teams, finance and managers: choose order period and creator company, inspect purchase order status, buyer/approval dates, vendor, payment and shipping context, then open its stored items on demand. See quantities, receiving status, expected delivery, service rates, separate transaction/functional amounts and useful notes. \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 SQL Server source, two lists and one relation; 36 order fields and 35 item fields. MasterPKey and the full MasterPKey+PODetailPKey line identity are hidden, not replaced by order number, item number or sequence. Choose the native order period (start/end-exclusive) and mandatory creator company before the order read. The SQL connector applies these native opening predicates, plus selected status/closed choices, to the projected query before its bounded read. There is no root TOP or LIMIT before the predicates, and no unresolved opening parameter is required to discover selector choices. Items are scoped by the selected master AND company before their limit. Opening selectors may discover a bounded superset of source values; an option is not proof of matching orders in the chosen period. This is not SQL access control; no count/completeness or fast-query guarantee. Live reads, up to 2,000 displayed rows per list, no automatic refresh.\n\nTotalNetAmount is the STORED net total in the creator company FUNCTIONAL currency when multicurrency is enabled. FunctionalCurrencyCode is read from the same-edition CFGMainData.Company key, not guessed from the PO transaction CurrencyCode. Item NetAmount, estimated shipping/taxes and extra amounts use order TRANSACTION currency; NetAmountFunctionalCurrency is separate. Unit price uses the order unit; a Service order may use hours/rates. No conversion, paid/outstanding amount, grand total, sum of currencies or recomputed effective/change-order total. Unknown/blank currency remains blank and requires a real preview. Unused DiscountAmount/ReceivedAmount are not projected.\n\nThe item functional amount is documented as the active-company amount; the displayed functional currency is the PO creator-company setup. Confirm that these contexts match in the installed system before interpreting item functional amounts. This read is not a historical exchange-rate or company-context certification.\n\nEach stored item key remains separate, including change-order-linked records. Line origin identifies only presence of a COPKey link, not approved/latest change status; change-order details, approval history and cost-distribution projects are NOT joined. Stored received quantity/status are not acceptance/rejection receipt history, stock balance or an inferred completion state. Closed order, processing status and received status are distinct; unknown codes stay visible, NULL does not become No or zero. Inventory quantities apply only when present in your inventory setup, not every service or purchasing item.\n\nVendor name is CURRENT enrichment only when Clendor has exactly one nonblank matching vendor business number. Ambiguous/missing names remain blank; no arbitrary first firm, duplicated orders or historical vendor snapshot. Buyer/approver/requester names use EMMain.Employee; payroll and private employee contact are not read. Company identifies the PO creator company, not automatically a purchasing company or ERP permission scope. Root shipping address/contact is exposed only for the documented OTHER ship-to case, joined from stored address parts; for configured ship-to codes this dossier shows the reference, not a guessed lookup address. Item shipping is its stored override, not automatically inherited from the root. Native payment, FOB, shipping and category codes are not invented descriptions.\n\nAgreement start/end, description and terms are conditional for Blanket/Service. Specific PayDate is shown only for native PayTerms=Date. Excess percentage is shown only when AllowExcess=Y; no enforcement action is performed. Agreement authorization limits/extra amount ceilings are not projected until their installed monetary context is independently confirmed. Internal notes can contain confidential text: authorise source access and inspect them before sharing. This is an operational dossier, not the entire purchasing module.\n\nPhysical columns/types/keys are official 2025.1 POMaster/PODetail/EMMain/Clendor plus CFGMainData dictionary. Supplementary purchase UI meanings are frozen 7.2 help, not same-edition or installed compatibility certification. Read only an administrator-approved on-premises SQL Server database using a dedicated least-privilege SELECT account. Direct SQL does NOT inherit Deltek company/employee confidentiality, role or masking permissions. Verify DB, default schema, projected columns, company scope, currency settings, codes and timings in a real Cifru read test/preview at import. No dbo assumption, sa/sysadmin, writes, DDL, administrative actions or direct Deltek Cloud access. The schema guard refuses ambiguous resolution; it does not certify the database, query cost or authorised scope.\n\nNot tested on a real ERP or SQL Server; SQLite adapter/native fictional DEMO captures do not prove installed compatibility. No source credentials, server address, cached business rows, executable code or vendor HTML in the download. Unofficial, not affiliated with Deltek.\n\nPhysical dictionary: https://help.deltek.com/product/Vantagepoint/2025.1/DataDictionary/index.htm\nPurchase context: https://help.deltek.com/Product/Vantagepoint/7.2/browser_pur_general_tab_of_po_header.html\nItem context: https://help.deltek.com/product/Vantagepoint/7.2/browser_pur_contents_of_po_line_detail_dialog.html",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "060827B7-A31D-5AF1-A36D-C951FF78B5F1",
"rootButtonCount": 1,
"summary": "Period/company to purchase orders, full operational dossiers and on-demand items with separate currencies and receiving context.",
"tags": [
"Deltek Vantagepoint",
"SQL Server",
"Purchasing",
"Receiving",
"Pro"
],
"title": "Purchase orders — items and receiving Pro"
}
}