Purchase orders — lines and account allocations Pro
Company/period to purchase orders, receiving/delivery context and nested project/account allocations in actual order currency.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For buyers, operations teams, project controllers and managers: choose company and order period, inspect purchase orders, their actual transaction totals, supplier references and stored contact. Open ordered/received/accepted lines, delivery dates and logistics, then inspect each line’s project/account/organization cost allocations on demand.
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, three lists, two nested relations, 25 order values, 28 line values and 14 allocation values. Native mandatory company and order period (start/end-exclusive) are applied before the bounded live SQL read. The immutable root projection has no unresolved opening parameters or inner row limit; selector discovery may be bounded and a missing option is not proof of no records. Every child binds order ID + release + company; allocations also bind the physical line key. Canonical joined parent keys prevent differently cased foreign keys from breaking exact native relations. Business line number is modifiable, NOT the physical line identity. Technical full keys and audit fields are hidden. Release number is visible on the order card, not only in Details, to distinguish releases of the same purchase order. Up to 1,000 rows per list, no completeness or low-server-cost guarantee. Local search after loading, live child reads only on opening, no automatic refresh.
Every displayed amount uses its stored TRN transaction field with the actual order TRN_CRNCY_CD. No functional amount is relabelled as transaction currency, current supplier defaults substituted for historical order currency, guessed conversions, cross-currency totals, or calculated balances. Order rate date is stored reference metadata, not a certificate of the effective exchange rate. Vouchered amount is NOT paid or outstanding. Purchase account allocation is not a posted expense or payment. Line total includes native extended cost, tax, charges and charge tax; it is NOT recomputed as quantity times price. Amount-only/subcontract lines may have zero quantity/no unit or unit price. Received and accepted quantities are distinct, not inferred receipt history or stock. No totals across units, blanket master and releases, or changes. Latest change number is a reference, not a change-order history. A release is kept separate by its full identity.
Only documented order types P/B/S/R, line types P/G/S/M, and statuses C/O/P/V are decoded. Additional agreement/system-closed or unknown codes remain Code plus the original value; NULL is blank, not No/zero. Header and line status may differ. Stored acknowledgment, release actions, proposed portal values and compliance controls are not inferred or implemented. Requested and promised delivery dates remain distinct. Supplier name is CURRENT enrichment from VEND_ID + COMPANY_ID, not an historical snapshot; missing names fall back to the business account reference without dropping the order. Contact is stored on the order, not borrowed from a current address. Project/account/org and configurable references are native business codes; no guessed names or labels. Allocation percentage is excluded because a 100% UI default does not prove stored 1-versus-100 scale. Delivery schedules, receipt history and related source documents are not included.
Evidence: official Costpoint 8.1.0 transaction dictionary and separately frozen 8.1 purchasing functional/input help. Oracle type spellings are NOT verified Microsoft SQL Server DDL, and this is not a 2026 schema certificate. Most physical definitions are blank. Preserve the documented conflicts: input RECVD_QTY default says Amount; input currency default names a VEND column absent from the dictionary; SALES_TAX_RT appears twice with differing defaults; brief GUI total omits charge tax included in the input definition. This package avoids those guesses and reads stored totals. Input layouts are evidence, NOT instructions to import/write. Not Deltek Vantagepoint, Vision, Planning, Time & Expense or GovWin.
Requires an administrator-authorised on-premises SQL Server transaction database and a dedicated least-privilege SELECT account. No dbo owner or Deltek Cloud direct SQL access is assumed. Confirm database/default schema, actual fields/types, all complete keys, company scope, currencies and dates. The default-schema guard refuses ambiguous object resolution but does not certify the intended database, company or source authorization. Direct SQL does NOT inherit Costpoint buyer, project, inventory, employee, ITAR/EAR, role, suppression or masking permissions. Opening filters are NOT ACLs. Use only appropriate permitted data. No sa/sysadmin, DDL, administration or writes. Pass Cifru read/compatibility checks, inspect a real preview and measure timings before using the report.
Not tested on a real ERP or SQL Server. Documentary and synthetic query/native DEMO tests do not prove installed compatibility, source ACLs, completeness or regulatory compliance. Wholly fictional captures, no credentials, source connection addresses, cached business rows or executable code in the package. Unofficial, not affiliated with Deltek.
Physical dictionary: https://help.deltek.com/product/Costpoint/Documentation/81DataDictionary.html
Purchase fields: https://help.deltek.com/Product/Costpoint/8.1/GA/POMMAIN_Contents_of_the_Manage_Purchase_Orders_Screen.html
Accounts context: https://help.deltek.com/Product/Costpoint/8.1/GA/POMMAIN_Accounts_Subtask.html
Physical bindings: https://help.deltek.com/Product/Costpoint/8.1/GA/AOPUTLPO_Detailed_Table_Specifications.html
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Purchase orders
- Details: Order lines
- Details: Account allocations
- Sub-button: Purchase lines
- Sub-button: Purchase allocations
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 CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.PO_ID,N'#')),N':',m.PO_ID,N':',LEN(CONCAT(m.PO_RLSE_NO,N'#')),N':',m.PO_RLSE_NO,N':') AS OrderKey, COALESCE(NULLIF(LTRIM(RTRIM(v.VEND_LONG_NAME)),N''),NULLIF(LTRIM(RTRIM(v.VEND_NAME)),N''),m.VEND_ID) AS SupplierName, m.PO_ID AS PO_ID, m.PO_RLSE_NO AS PO_RLSE_NO, m.PO_CHNG_ORD_NO AS PO_CHNG_ORD_NO, m.COMPANY_ID AS COMPANY_ID, m.ORD_DT AS ORD_DT, CASE m.S_PO_TYPE WHEN N'P' THEN N'Purchase order' WHEN N'B' THEN N'Blanket order' WHEN N'S' THEN N'Subcontract PO' WHEN N'R' THEN N'Release order' ELSE CASE WHEN m.S_PO_TYPE IS NULL THEN N'' ELSE CONCAT(N'Code ',m.S_PO_TYPE) END END AS OrderType, CASE m.S_PO_STATUS_TYPE WHEN N'C' THEN N'Closed' WHEN N'O' THEN N'Open' WHEN N'P' THEN N'Pending' WHEN N'V' THEN N'Void' ELSE CASE WHEN m.S_PO_STATUS_TYPE IS NULL THEN N'' ELSE CONCAT(N'Code ',m.S_PO_STATUS_TYPE) END END AS OrderStatus, m.VEND_ID AS VEND_ID, m.ADDR_DC AS ADDR_DC, m.BUYER_ID AS BUYER_ID, m.BUY_ORG_ID AS BUY_ORG_ID, m.PROCURE_TYPE_CD AS PROCURE_TYPE_CD, m.TERMS_DC AS TERMS_DC, m.FOB_FLD AS FOB_FLD, m.VEND_SO_ID AS VEND_SO_ID, LTRIM(RTRIM(CONCAT(m.CNTACT_FIRST_NAME,N' ',m.CNTACT_LAST_NAME))) AS ContactName, m.PHONE_ID AS PHONE_ID, m.CNTACT_EMAIL_ID AS CNTACT_EMAIL_ID, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, m.RATE_GRP_ID AS RATE_GRP_ID, m.TRN_CRNCY_DT AS TRN_CRNCY_DT, m.TRN_PO_TOT_AMT AS TRN_PO_TOT_AMT, m.TRN_SALES_TAX_AMT AS TRN_SALES_TAX_AMT, m.TRN_VCHRD_AMT AS TRN_VCHRD_AMT FROM PO_HDR m LEFT JOIN VEND v ON v.VEND_ID=m.VEND_ID AND v.COMPANY_ID=m.COMPANY_ID WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PO_HDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_HDR',N'U') AND OBJECT_ID(N'PO_LN',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN',N'U') AND OBJECT_ID(N'PO_LN_ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN_ACCT',N'U') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':'),CONCAT(LEN(CONCAT(l.PO_ID,N'#')),N':',l.PO_ID,N':',LEN(CONCAT(l.PO_RLSE_NO,N'#')),N':',l.PO_RLSE_NO,N':',LEN(CONCAT(l.PO_LN_KEY,N'#')),N':',l.PO_LN_KEY,N':')) AS LineKey, CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.PO_ID,N'#')),N':',m.PO_ID,N':',LEN(CONCAT(m.PO_RLSE_NO,N'#')),N':',m.PO_RLSE_NO,N':') AS ParentOrderKey, l.PO_LN_KEY AS PO_LN_KEY, l.PO_LN_DESC AS PO_LN_DESC, l.ITEM_ID AS ITEM_ID, l.ITEM_RVSN_ID AS ITEM_RVSN_ID, m.PO_ID AS PO_ID, m.PO_RLSE_NO AS PO_RLSE_NO, m.COMPANY_ID AS COMPANY_ID, l.PO_LN_NO AS PO_LN_NO, CASE l.S_PO_LN_TYPE WHEN N'P' THEN N'Part' WHEN N'G' THEN N'Good' WHEN N'S' THEN N'Service' WHEN N'M' THEN N'Miscellaneous' ELSE CASE WHEN l.S_PO_LN_TYPE IS NULL THEN N'' ELSE CONCAT(N'Code ',l.S_PO_LN_TYPE) END END AS LineType, CASE l.S_LN_STATUS_TYPE WHEN N'C' THEN N'Closed' WHEN N'O' THEN N'Open' WHEN N'P' THEN N'Pending' WHEN N'V' THEN N'Void' ELSE CASE WHEN l.S_LN_STATUS_TYPE IS NULL THEN N'' ELSE CONCAT(N'Code ',l.S_LN_STATUS_TYPE) END END AS LineStatus, l.ORD_QTY AS ORD_QTY, l.RECVD_QTY AS RECVD_QTY, l.ACCPTD_QTY AS ACCPTD_QTY, l.PO_LN_UM_CD AS PO_LN_UM_CD, l.ORD_DT AS ORD_DT, l.DUE_DT AS DUE_DT, l.DESIRED_DT AS DESIRED_DT, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, l.TRN_NET_UN_CST_AMT AS TRN_NET_UN_CST_AMT, l.TRN_PO_LN_EXT_AMT AS TRN_PO_LN_EXT_AMT, l.TRN_PO_LN_TOT_AMT AS TRN_PO_LN_TOT_AMT, l.TRN_SALES_TAX_AMT AS TRN_SALES_TAX_AMT, l.TRN_LN_CHG_AMT AS TRN_LN_CHG_AMT, l.TRN_LN_CHG_TAX_AMT AS TRN_LN_CHG_TAX_AMT, l.SHIP_ID AS SHIP_ID, l.SHIP_VIA_FLD AS SHIP_VIA_FLD, l.DEL_TO_FLD AS DEL_TO_FLD, l.WHSE_ID AS WHSE_ID, l.RQ_ID AS RQ_ID FROM PO_LN l INNER JOIN PO_HDR m ON m.PO_ID=l.PO_ID AND m.PO_RLSE_NO=l.PO_RLSE_NO WHERE m.PO_ID=:order_id AND m.PO_RLSE_NO=:release AND m.COMPANY_ID=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PO_HDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_HDR',N'U') AND OBJECT_ID(N'PO_LN',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN',N'U') AND OBJECT_ID(N'PO_LN_ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN_ACCT',N'U') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':'),CONCAT(LEN(CONCAT(a.PO_ID,N'#')),N':',a.PO_ID,N':',LEN(CONCAT(a.PO_RLSE_NO,N'#')),N':',a.PO_RLSE_NO,N':',LEN(CONCAT(a.PO_LN_KEY,N'#')),N':',a.PO_LN_KEY,N':',LEN(CONCAT(a.SUB_KEY,N'#')),N':',a.SUB_KEY,N':')) AS AllocationKey, CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':'),CONCAT(LEN(CONCAT(l.PO_ID,N'#')),N':',l.PO_ID,N':',LEN(CONCAT(l.PO_RLSE_NO,N'#')),N':',l.PO_RLSE_NO,N':',LEN(CONCAT(l.PO_LN_KEY,N'#')),N':',l.PO_LN_KEY,N':')) AS ParentLineKey, a.ACCT_ID AS ACCT_ID, a.PROJ_ID AS PROJ_ID, a.ORG_ID AS ORG_ID, m.PO_ID AS PO_ID, m.PO_RLSE_NO AS PO_RLSE_NO, m.COMPANY_ID AS COMPANY_ID, l.PO_LN_NO AS PO_LN_NO, a.TRN_CST_AMT AS TRN_CST_AMT, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, a.REF_STRUC_1_ID AS REF_STRUC_1_ID, a.REF_STRUC_2_ID AS REF_STRUC_2_ID, a.PROJ_ABBRV_CD AS PROJ_ABBRV_CD, a.ORG_ABBRV_CD AS ORG_ABBRV_CD, a.PROJ_ACCT_ABBRV_CD AS PROJ_ACCT_ABBRV_CD FROM PO_LN l INNER JOIN PO_HDR m ON m.PO_ID=l.PO_ID AND m.PO_RLSE_NO=l.PO_RLSE_NO INNER JOIN PO_LN_ACCT a ON a.PO_ID=l.PO_ID AND a.PO_RLSE_NO=l.PO_RLSE_NO AND a.PO_LN_KEY=l.PO_LN_KEY WHERE m.PO_ID=:order_id AND m.PO_RLSE_NO=:release AND m.COMPANY_ID=:company AND l.PO_LN_KEY=:line_key AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PO_HDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_HDR',N'U') AND OBJECT_ID(N'PO_LN',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN',N'U') AND OBJECT_ID(N'PO_LN_ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN_ACCT',N'U') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Costpoint 8.1 — authorised transaction SQL Server database",
"id": "763D63BF-FB7B-584A-B280-90780A554606",
"kind": "sqlServer",
"requiredObjects": [
"PO_HDR",
"PO_LN",
"PO_LN_ACCT",
"VEND"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "E4D98C97-3DE6-5B84-AD33-0182B1A6718B",
"key": "ORD_DT",
"type": "date"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"id": "E9599E57-49F5-55B9-80CA-6EFF68756DC1",
"mappings": [
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Internal OrderKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Current supplier name / account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_ID",
"label": "Purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PO_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_RLSE_NO",
"label": "Release number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PO_RLSE_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PO_CHNG_ORD_NO",
"label": "Latest change number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PO_CHNG_ORD_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMPANY_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ORD_DT",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORD_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderType",
"label": "Order type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderStatus",
"label": "Order status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VEND_ID",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VEND_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDR_DC",
"label": "Supplier address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDR_DC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BUYER_ID",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BUYER_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BUY_ORG_ID",
"label": "Buyer organization",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BUY_ORG_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROCURE_TYPE_CD",
"label": "Procurement type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROCURE_TYPE_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TERMS_DC",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TERMS_DC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FOB_FLD",
"label": "Delivery terms",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FOB_FLD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VEND_SO_ID",
"label": "Supplier order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VEND_SO_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ContactName",
"label": "Stored order contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHONE_ID",
"label": "Contact phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHONE_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CNTACT_EMAIL_ID",
"label": "Contact email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CNTACT_EMAIL_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_CRNCY_CD",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TRN_CRNCY_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "RATE_GRP_ID",
"label": "Order rate group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RATE_GRP_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_CRNCY_DT",
"label": "Order rate date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_CRNCY_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_PO_TOT_AMT",
"label": "Order total (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_PO_TOT_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_SALES_TAX_AMT",
"label": "Sales tax total (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_SALES_TAX_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_VCHRD_AMT",
"label": "Vouchered amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_VCHRD_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Purchase orders",
"primaryKey": "OrderKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"SupplierName",
"PO_ID",
"PO_RLSE_NO",
"PO_CHNG_ORD_NO",
"COMPANY_ID",
"ORD_DT",
"OrderType",
"OrderStatus",
"VEND_ID",
"ADDR_DC",
"BUYER_ID",
"BUY_ORG_ID",
"PROCURE_TYPE_CD",
"TERMS_DC",
"FOB_FLD",
"VEND_SO_ID",
"ContactName",
"PHONE_ID",
"CNTACT_EMAIL_ID",
"TRN_CRNCY_CD",
"RATE_GRP_ID",
"TRN_CRNCY_DT",
"TRN_PO_TOT_AMT",
"TRN_SALES_TAX_AMT",
"TRN_VCHRD_AMT"
],
"sourceID": "763D63BF-FB7B-584A-B280-90780A554606",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.PO_ID,N'#')),N':',m.PO_ID,N':',LEN(CONCAT(m.PO_RLSE_NO,N'#')),N':',m.PO_RLSE_NO,N':') AS OrderKey, COALESCE(NULLIF(LTRIM(RTRIM(v.VEND_LONG_NAME)),N''),NULLIF(LTRIM(RTRIM(v.VEND_NAME)),N''),m.VEND_ID) AS SupplierName, m.PO_ID AS PO_ID, m.PO_RLSE_NO AS PO_RLSE_NO, m.PO_CHNG_ORD_NO AS PO_CHNG_ORD_NO, m.COMPANY_ID AS COMPANY_ID, m.ORD_DT AS ORD_DT, CASE m.S_PO_TYPE WHEN N'P' THEN N'Purchase order' WHEN N'B' THEN N'Blanket order' WHEN N'S' THEN N'Subcontract PO' WHEN N'R' THEN N'Release order' ELSE CASE WHEN m.S_PO_TYPE IS NULL THEN N'' ELSE CONCAT(N'Code ',m.S_PO_TYPE) END END AS OrderType, CASE m.S_PO_STATUS_TYPE WHEN N'C' THEN N'Closed' WHEN N'O' THEN N'Open' WHEN N'P' THEN N'Pending' WHEN N'V' THEN N'Void' ELSE CASE WHEN m.S_PO_STATUS_TYPE IS NULL THEN N'' ELSE CONCAT(N'Code ',m.S_PO_STATUS_TYPE) END END AS OrderStatus, m.VEND_ID AS VEND_ID, m.ADDR_DC AS ADDR_DC, m.BUYER_ID AS BUYER_ID, m.BUY_ORG_ID AS BUY_ORG_ID, m.PROCURE_TYPE_CD AS PROCURE_TYPE_CD, m.TERMS_DC AS TERMS_DC, m.FOB_FLD AS FOB_FLD, m.VEND_SO_ID AS VEND_SO_ID, LTRIM(RTRIM(CONCAT(m.CNTACT_FIRST_NAME,N' ',m.CNTACT_LAST_NAME))) AS ContactName, m.PHONE_ID AS PHONE_ID, m.CNTACT_EMAIL_ID AS CNTACT_EMAIL_ID, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, m.RATE_GRP_ID AS RATE_GRP_ID, m.TRN_CRNCY_DT AS TRN_CRNCY_DT, m.TRN_PO_TOT_AMT AS TRN_PO_TOT_AMT, m.TRN_SALES_TAX_AMT AS TRN_SALES_TAX_AMT, m.TRN_VCHRD_AMT AS TRN_VCHRD_AMT FROM PO_HDR m LEFT JOIN VEND v ON v.VEND_ID=m.VEND_ID AND v.COMPANY_ID=m.COMPANY_ID WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PO_HDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_HDR',N'U') AND OBJECT_ID(N'PO_LN',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN',N'U') AND OBJECT_ID(N'PO_LN_ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN_ACCT',N'U') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "FEA3D957-0AF6-5E56-93C1-89CC4F0A18D8",
"key": "PO_LN_NO",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "81E76BD3-2AB2-550D-AEF5-BA64D2F93876",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Internal LineKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentOrderKey",
"label": "Internal ParentOrderKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentOrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_LN_KEY",
"label": "Internal PO_LN_KEY",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PO_LN_KEY",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_LN_DESC",
"label": "Stored line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PO_LN_DESC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITEM_ID",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ITEM_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITEM_RVSN_ID",
"label": "Item revision",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ITEM_RVSN_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_ID",
"label": "Purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PO_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_RLSE_NO",
"label": "Release number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PO_RLSE_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMPANY_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_LN_NO",
"label": "Business line number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PO_LN_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineType",
"label": "Line type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineStatus",
"label": "Line status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ORD_QTY",
"label": "Ordered quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORD_QTY",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "RECVD_QTY",
"label": "Received quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RECVD_QTY",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ACCPTD_QTY",
"label": "Accepted quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ACCPTD_QTY",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PO_LN_UM_CD",
"label": "Order unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PO_LN_UM_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ORD_DT",
"label": "Line order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORD_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DUE_DT",
"label": "Promised delivery date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DUE_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DESIRED_DT",
"label": "Requested delivery date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DESIRED_DT",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_CRNCY_CD",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TRN_CRNCY_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_NET_UN_CST_AMT",
"label": "Net unit cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_NET_UN_CST_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_PO_LN_EXT_AMT",
"label": "Extended cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_PO_LN_EXT_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_PO_LN_TOT_AMT",
"label": "Line total (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_PO_LN_TOT_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_SALES_TAX_AMT",
"label": "Sales tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_SALES_TAX_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_LN_CHG_AMT",
"label": "Line charges (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_LN_CHG_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRN_LN_CHG_TAX_AMT",
"label": "Charge tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_LN_CHG_TAX_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIP_ID",
"label": "Ship-to code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHIP_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIP_VIA_FLD",
"label": "Line ship via",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHIP_VIA_FLD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DEL_TO_FLD",
"label": "Line deliver to",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DEL_TO_FLD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WHSE_ID",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WHSE_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RQ_ID",
"label": "Requisition reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RQ_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Purchase lines",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PO_ID",
"id": "2C2248BC-30CC-5136-9DEB-22ADDCCF876F",
"name": "order_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PO_RLSE_NO",
"id": "67F2BE70-4193-5328-8AEE-F6DD8876569C",
"name": "release",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "COMPANY_ID",
"id": "8208601D-294B-57B0-9E7F-5F1CB9A263C9",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"PO_LN_DESC",
"ITEM_ID",
"ITEM_RVSN_ID",
"PO_ID",
"PO_RLSE_NO",
"COMPANY_ID",
"PO_LN_NO",
"LineType",
"LineStatus",
"ORD_QTY",
"RECVD_QTY",
"ACCPTD_QTY",
"PO_LN_UM_CD",
"ORD_DT",
"DUE_DT",
"DESIRED_DT",
"TRN_CRNCY_CD",
"TRN_NET_UN_CST_AMT",
"TRN_PO_LN_EXT_AMT",
"TRN_PO_LN_TOT_AMT",
"TRN_SALES_TAX_AMT",
"TRN_LN_CHG_AMT",
"TRN_LN_CHG_TAX_AMT",
"SHIP_ID",
"SHIP_VIA_FLD",
"DEL_TO_FLD",
"WHSE_ID",
"RQ_ID"
],
"sourceID": "763D63BF-FB7B-584A-B280-90780A554606",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':'),CONCAT(LEN(CONCAT(l.PO_ID,N'#')),N':',l.PO_ID,N':',LEN(CONCAT(l.PO_RLSE_NO,N'#')),N':',l.PO_RLSE_NO,N':',LEN(CONCAT(l.PO_LN_KEY,N'#')),N':',l.PO_LN_KEY,N':')) AS LineKey, CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.PO_ID,N'#')),N':',m.PO_ID,N':',LEN(CONCAT(m.PO_RLSE_NO,N'#')),N':',m.PO_RLSE_NO,N':') AS ParentOrderKey, l.PO_LN_KEY AS PO_LN_KEY, l.PO_LN_DESC AS PO_LN_DESC, l.ITEM_ID AS ITEM_ID, l.ITEM_RVSN_ID AS ITEM_RVSN_ID, m.PO_ID AS PO_ID, m.PO_RLSE_NO AS PO_RLSE_NO, m.COMPANY_ID AS COMPANY_ID, l.PO_LN_NO AS PO_LN_NO, CASE l.S_PO_LN_TYPE WHEN N'P' THEN N'Part' WHEN N'G' THEN N'Good' WHEN N'S' THEN N'Service' WHEN N'M' THEN N'Miscellaneous' ELSE CASE WHEN l.S_PO_LN_TYPE IS NULL THEN N'' ELSE CONCAT(N'Code ',l.S_PO_LN_TYPE) END END AS LineType, CASE l.S_LN_STATUS_TYPE WHEN N'C' THEN N'Closed' WHEN N'O' THEN N'Open' WHEN N'P' THEN N'Pending' WHEN N'V' THEN N'Void' ELSE CASE WHEN l.S_LN_STATUS_TYPE IS NULL THEN N'' ELSE CONCAT(N'Code ',l.S_LN_STATUS_TYPE) END END AS LineStatus, l.ORD_QTY AS ORD_QTY, l.RECVD_QTY AS RECVD_QTY, l.ACCPTD_QTY AS ACCPTD_QTY, l.PO_LN_UM_CD AS PO_LN_UM_CD, l.ORD_DT AS ORD_DT, l.DUE_DT AS DUE_DT, l.DESIRED_DT AS DESIRED_DT, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, l.TRN_NET_UN_CST_AMT AS TRN_NET_UN_CST_AMT, l.TRN_PO_LN_EXT_AMT AS TRN_PO_LN_EXT_AMT, l.TRN_PO_LN_TOT_AMT AS TRN_PO_LN_TOT_AMT, l.TRN_SALES_TAX_AMT AS TRN_SALES_TAX_AMT, l.TRN_LN_CHG_AMT AS TRN_LN_CHG_AMT, l.TRN_LN_CHG_TAX_AMT AS TRN_LN_CHG_TAX_AMT, l.SHIP_ID AS SHIP_ID, l.SHIP_VIA_FLD AS SHIP_VIA_FLD, l.DEL_TO_FLD AS DEL_TO_FLD, l.WHSE_ID AS WHSE_ID, l.RQ_ID AS RQ_ID FROM PO_LN l INNER JOIN PO_HDR m ON m.PO_ID=l.PO_ID AND m.PO_RLSE_NO=l.PO_RLSE_NO WHERE m.PO_ID=:order_id AND m.PO_RLSE_NO=:release AND m.COMPANY_ID=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PO_HDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_HDR',N'U') AND OBJECT_ID(N'PO_LN',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN',N'U') AND OBJECT_ID(N'PO_LN_ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN_ACCT',N'U') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "9885EF93-EC93-5480-8F15-88C4E9C5FFBE",
"key": "ACCT_ID",
"type": "text"
},
{
"direction": "ascending",
"id": "BF20F508-E9F4-5948-9022-A3FAD48E3124",
"key": "PROJ_ID",
"type": "text"
},
{
"direction": "ascending",
"id": "05298CA0-52AE-5059-A69C-ACE2FC4F7EFD",
"key": "AllocationKey",
"type": "text"
}
],
"id": "5EB71A5C-4448-50CA-A986-F80010A9CF99",
"mappings": [
{
"commonFieldKey": "",
"key": "AllocationKey",
"label": "Internal AllocationKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AllocationKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentLineKey",
"label": "Internal ParentLineKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentLineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACCT_ID",
"label": "Account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ACCT_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROJ_ID",
"label": "Project code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROJ_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORG_ID",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ORG_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PO_ID",
"label": "Purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PO_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_RLSE_NO",
"label": "Release number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PO_RLSE_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMPANY_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PO_LN_NO",
"label": "Business line number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PO_LN_NO",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_CST_AMT",
"label": "Allocated cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRN_CST_AMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRN_CRNCY_CD",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TRN_CRNCY_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "REF_STRUC_1_ID",
"label": "Reference 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "REF_STRUC_1_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REF_STRUC_2_ID",
"label": "Reference 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "REF_STRUC_2_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROJ_ABBRV_CD",
"label": "Project abbreviation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROJ_ABBRV_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORG_ABBRV_CD",
"label": "Organization abbreviation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ORG_ABBRV_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PROJ_ACCT_ABBRV_CD",
"label": "Project account abbreviation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PROJ_ACCT_ABBRV_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Purchase allocations",
"primaryKey": "AllocationKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PO_ID",
"id": "2C2248BC-30CC-5136-9DEB-22ADDCCF876F",
"name": "order_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PO_RLSE_NO",
"id": "67F2BE70-4193-5328-8AEE-F6DD8876569C",
"name": "release",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "COMPANY_ID",
"id": "8208601D-294B-57B0-9E7F-5F1CB9A263C9",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PO_LN_KEY",
"id": "6D210FD3-95B6-5B41-B3A5-EFEC55F5A5B2",
"name": "line_key",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ACCT_ID",
"PROJ_ID",
"ORG_ID",
"PO_ID",
"PO_RLSE_NO",
"COMPANY_ID",
"PO_LN_NO",
"TRN_CST_AMT",
"TRN_CRNCY_CD",
"REF_STRUC_1_ID",
"REF_STRUC_2_ID",
"PROJ_ABBRV_CD",
"ORG_ABBRV_CD",
"PROJ_ACCT_ABBRV_CD"
],
"sourceID": "763D63BF-FB7B-584A-B280-90780A554606",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':'),CONCAT(LEN(CONCAT(a.PO_ID,N'#')),N':',a.PO_ID,N':',LEN(CONCAT(a.PO_RLSE_NO,N'#')),N':',a.PO_RLSE_NO,N':',LEN(CONCAT(a.PO_LN_KEY,N'#')),N':',a.PO_LN_KEY,N':',LEN(CONCAT(a.SUB_KEY,N'#')),N':',a.SUB_KEY,N':')) AS AllocationKey, CONCAT(CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':'),CONCAT(LEN(CONCAT(l.PO_ID,N'#')),N':',l.PO_ID,N':',LEN(CONCAT(l.PO_RLSE_NO,N'#')),N':',l.PO_RLSE_NO,N':',LEN(CONCAT(l.PO_LN_KEY,N'#')),N':',l.PO_LN_KEY,N':')) AS ParentLineKey, a.ACCT_ID AS ACCT_ID, a.PROJ_ID AS PROJ_ID, a.ORG_ID AS ORG_ID, m.PO_ID AS PO_ID, m.PO_RLSE_NO AS PO_RLSE_NO, m.COMPANY_ID AS COMPANY_ID, l.PO_LN_NO AS PO_LN_NO, a.TRN_CST_AMT AS TRN_CST_AMT, m.TRN_CRNCY_CD AS TRN_CRNCY_CD, a.REF_STRUC_1_ID AS REF_STRUC_1_ID, a.REF_STRUC_2_ID AS REF_STRUC_2_ID, a.PROJ_ABBRV_CD AS PROJ_ABBRV_CD, a.ORG_ABBRV_CD AS ORG_ABBRV_CD, a.PROJ_ACCT_ABBRV_CD AS PROJ_ACCT_ABBRV_CD FROM PO_LN l INNER JOIN PO_HDR m ON m.PO_ID=l.PO_ID AND m.PO_RLSE_NO=l.PO_RLSE_NO INNER JOIN PO_LN_ACCT a ON a.PO_ID=l.PO_ID AND a.PO_RLSE_NO=l.PO_RLSE_NO AND a.PO_LN_KEY=l.PO_LN_KEY WHERE m.PO_ID=:order_id AND m.PO_RLSE_NO=:release AND m.COMPANY_ID=:company AND l.PO_LN_KEY=:line_key AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PO_HDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_HDR',N'U') AND OBJECT_ID(N'PO_LN',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN',N'U') AND OBJECT_ID(N'PO_LN_ACCT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PO_LN_ACCT',N'U') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "E5B4612F-712D-556F-8651-FFC23A598F43",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "A841C187-93AB-5F21-AE0E-FBEC5D4A29F3",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "81E76BD3-2AB2-550D-AEF5-BA64D2F93876",
"title": "Order lines",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORD_DT",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderType",
"label": "Order type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderStatus",
"label": "Order status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_PO_TOT_AMT",
"label": "Order total (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PO_RLSE_NO",
"label": "Release number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E9599E57-49F5-55B9-80CA-6EFF68756DC1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Order and stored totals",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Current supplier name / account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order and stored totals",
"detailRole": "information",
"isVisible": true,
"key": "PO_ID",
"label": "Purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order and stored totals",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order and stored totals",
"detailRole": "information",
"isVisible": true,
"key": "ORD_DT",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and stored totals",
"detailRole": "information",
"isVisible": true,
"key": "OrderType",
"label": "Order type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order and stored totals",
"detailRole": "information",
"isVisible": true,
"key": "OrderStatus",
"label": "Order status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order and stored totals",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Order and stored totals",
"detailRole": "information",
"isVisible": true,
"key": "TRN_PO_TOT_AMT",
"label": "Order total (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and stored totals",
"detailRole": "information",
"isVisible": true,
"key": "PO_RLSE_NO",
"label": "Release number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "PO_CHNG_ORD_NO",
"label": "Latest change number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "VEND_ID",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "ADDR_DC",
"label": "Supplier address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "BUYER_ID",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "BUY_ORG_ID",
"label": "Buyer organization",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "PROCURE_TYPE_CD",
"label": "Procurement type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Terms and stored contact",
"detailRole": "information",
"isVisible": true,
"key": "TERMS_DC",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Terms and stored contact",
"detailRole": "information",
"isVisible": true,
"key": "FOB_FLD",
"label": "Delivery terms",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Terms and stored contact",
"detailRole": "information",
"isVisible": true,
"key": "VEND_SO_ID",
"label": "Supplier order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Terms and stored contact",
"detailRole": "information",
"isVisible": true,
"key": "ContactName",
"label": "Stored order contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Terms and stored contact",
"detailRole": "information",
"isVisible": true,
"key": "PHONE_ID",
"label": "Contact phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Terms and stored contact",
"detailRole": "information",
"isVisible": true,
"key": "CNTACT_EMAIL_ID",
"label": "Contact email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Transaction amounts and rate context",
"detailRole": "information",
"isVisible": true,
"key": "TRN_SALES_TAX_AMT",
"label": "Sales tax total (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Transaction amounts and rate context",
"detailRole": "information",
"isVisible": true,
"key": "TRN_VCHRD_AMT",
"label": "Vouchered amount (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Transaction amounts and rate context",
"detailRole": "information",
"isVisible": true,
"key": "RATE_GRP_ID",
"label": "Order rate group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Transaction amounts and rate context",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_DT",
"label": "Order rate date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "D6EFE7CE-4DF2-57D5-A59D-E25E3625CD6F",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "18E7402C-C4BB-59D4-A989-A692E0888716",
"includeAllOption": false,
"key": "ORD_DT",
"title": "Order period",
"type": "date"
},
{
"id": "B353CB46-69CC-523B-B29F-BA85B3D7F702",
"includeAllOption": false,
"key": "COMPANY_ID",
"title": "Company",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "E4D98C97-3DE6-5B84-AD33-0182B1A6718B",
"key": "ORD_DT",
"type": "date"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "PO_ID",
"systemImage": "doc.text",
"title": "Purchase orders",
"titleKey": "SupplierName"
},
{
"actions": [
{
"id": "94133202-08E4-5047-A1D2-E5EE2E7B3614",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "DA3B5D61-BEAB-5B37-8CBB-948CD0C514E0",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "5EB71A5C-4448-50CA-A986-F80010A9CF99",
"title": "Account allocations",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PO_LN_NO",
"label": "Business line number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineStatus",
"label": "Line status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORD_QTY",
"label": "Ordered quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "RECVD_QTY",
"label": "Received quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ACCPTD_QTY",
"label": "Accepted quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PO_LN_UM_CD",
"label": "Order unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DUE_DT",
"label": "Promised delivery date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_PO_LN_TOT_AMT",
"label": "Line total (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "81E76BD3-2AB2-550D-AEF5-BA64D2F93876",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "PO_LN_DESC",
"label": "Stored line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "ITEM_ID",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "ITEM_RVSN_ID",
"label": "Item revision",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "PO_LN_NO",
"label": "Business line number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "LineStatus",
"label": "Line status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "ORD_QTY",
"label": "Ordered quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "RECVD_QTY",
"label": "Received quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "ACCPTD_QTY",
"label": "Accepted quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "PO_LN_UM_CD",
"label": "Order unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "DUE_DT",
"label": "Promised delivery date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Item and receiving",
"detailRole": "information",
"isVisible": true,
"key": "TRN_PO_LN_TOT_AMT",
"label": "Line total (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Document and requested delivery",
"detailRole": "information",
"isVisible": true,
"key": "PO_ID",
"label": "Purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Document and requested delivery",
"detailRole": "information",
"isVisible": true,
"key": "PO_RLSE_NO",
"label": "Release number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Document and requested delivery",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Document and requested delivery",
"detailRole": "information",
"isVisible": true,
"key": "LineType",
"label": "Line type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Document and requested delivery",
"detailRole": "information",
"isVisible": true,
"key": "ORD_DT",
"label": "Line order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Document and requested delivery",
"detailRole": "information",
"isVisible": true,
"key": "DESIRED_DT",
"label": "Requested delivery date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "TRN_NET_UN_CST_AMT",
"label": "Net unit cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "TRN_PO_LN_EXT_AMT",
"label": "Extended cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "TRN_SALES_TAX_AMT",
"label": "Sales tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "TRN_LN_CHG_AMT",
"label": "Line charges (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored transaction charges",
"detailRole": "information",
"isVisible": true,
"key": "TRN_LN_CHG_TAX_AMT",
"label": "Charge tax (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Line logistics",
"detailRole": "information",
"isVisible": true,
"key": "SHIP_ID",
"label": "Ship-to code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line logistics",
"detailRole": "information",
"isVisible": true,
"key": "SHIP_VIA_FLD",
"label": "Line ship via",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line logistics",
"detailRole": "information",
"isVisible": true,
"key": "DEL_TO_FLD",
"label": "Line deliver to",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line logistics",
"detailRole": "information",
"isVisible": true,
"key": "WHSE_ID",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Line logistics",
"detailRole": "information",
"isVisible": true,
"key": "RQ_ID",
"label": "Requisition reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "432FC9B6-1D5E-5A53-8D11-AF1EB0887D7A",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "FEA3D957-0AF6-5E56-93C1-89CC4F0A18D8",
"key": "PO_LN_NO",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ITEM_ID",
"systemImage": "doc.text",
"title": "Purchase lines",
"titleKey": "PO_LN_DESC"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORG_ID",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PO_LN_NO",
"label": "Business line number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CST_AMT",
"label": "Allocated cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "5EB71A5C-4448-50CA-A986-F80010A9CF99",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Project account allocation",
"detailRole": "information",
"isVisible": true,
"key": "ACCT_ID",
"label": "Account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project account allocation",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_ID",
"label": "Project code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project account allocation",
"detailRole": "information",
"isVisible": true,
"key": "ORG_ID",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project account allocation",
"detailRole": "information",
"isVisible": true,
"key": "PO_LN_NO",
"label": "Business line number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Project account allocation",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CRNCY_CD",
"label": "Order transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project account allocation",
"detailRole": "information",
"isVisible": true,
"key": "TRN_CST_AMT",
"label": "Allocated cost (transaction)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Parent order and business references",
"detailRole": "information",
"isVisible": true,
"key": "PO_ID",
"label": "Purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent order and business references",
"detailRole": "information",
"isVisible": true,
"key": "PO_RLSE_NO",
"label": "Release number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Parent order and business references",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent order and business references",
"detailRole": "information",
"isVisible": true,
"key": "REF_STRUC_1_ID",
"label": "Reference 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent order and business references",
"detailRole": "information",
"isVisible": true,
"key": "REF_STRUC_2_ID",
"label": "Reference 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent order and business references",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_ABBRV_CD",
"label": "Project abbreviation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent order and business references",
"detailRole": "information",
"isVisible": true,
"key": "ORG_ABBRV_CD",
"label": "Organization abbreviation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Parent order and business references",
"detailRole": "information",
"isVisible": true,
"key": "PROJ_ACCT_ABBRV_CD",
"label": "Project account abbreviation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "F8A28F6A-EAA8-5ADD-A880-975AE84504E0",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "9885EF93-EC93-5480-8F15-88C4E9C5FFBE",
"key": "ACCT_ID",
"type": "text"
},
{
"direction": "ascending",
"id": "BF20F508-E9F4-5948-9022-A3FAD48E3124",
"key": "PROJ_ID",
"type": "text"
},
{
"direction": "ascending",
"id": "05298CA0-52AE-5059-A69C-ACE2FC4F7EFD",
"key": "AllocationKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "PROJ_ID",
"systemImage": "doc.text",
"title": "Purchase allocations",
"titleKey": "ACCT_ID"
}
],
"relations": [
{
"childDatasetID": "81E76BD3-2AB2-550D-AEF5-BA64D2F93876",
"childKey": "ParentOrderKey",
"id": "A841C187-93AB-5F21-AE0E-FBEC5D4A29F3",
"name": "Order lines",
"parentDatasetID": "E9599E57-49F5-55B9-80CA-6EFF68756DC1",
"parentKey": "OrderKey"
},
{
"childDatasetID": "5EB71A5C-4448-50CA-A986-F80010A9CF99",
"childKey": "ParentLineKey",
"id": "DA3B5D61-BEAB-5B37-8CBB-948CD0C514E0",
"name": "Account allocations",
"parentDatasetID": "81E76BD3-2AB2-550D-AEF5-BA64D2F93876",
"parentKey": "LineKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Deltek Costpoint",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-08T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For buyers, operations teams, project controllers and managers: choose company and order period, inspect purchase orders, their actual transaction totals, supplier references and stored contact. Open ordered/received/accepted lines, delivery dates and logistics, then inspect each line’s project/account/organization cost allocations on demand.\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, three lists, two nested relations, 25 order values, 28 line values and 14 allocation values. Native mandatory company and order period (start/end-exclusive) are applied before the bounded live SQL read. The immutable root projection has no unresolved opening parameters or inner row limit; selector discovery may be bounded and a missing option is not proof of no records. Every child binds order ID + release + company; allocations also bind the physical line key. Canonical joined parent keys prevent differently cased foreign keys from breaking exact native relations. Business line number is modifiable, NOT the physical line identity. Technical full keys and audit fields are hidden. Release number is visible on the order card, not only in Details, to distinguish releases of the same purchase order. Up to 1,000 rows per list, no completeness or low-server-cost guarantee. Local search after loading, live child reads only on opening, no automatic refresh.\n\nEvery displayed amount uses its stored TRN transaction field with the actual order TRN_CRNCY_CD. No functional amount is relabelled as transaction currency, current supplier defaults substituted for historical order currency, guessed conversions, cross-currency totals, or calculated balances. Order rate date is stored reference metadata, not a certificate of the effective exchange rate. Vouchered amount is NOT paid or outstanding. Purchase account allocation is not a posted expense or payment. Line total includes native extended cost, tax, charges and charge tax; it is NOT recomputed as quantity times price. Amount-only/subcontract lines may have zero quantity/no unit or unit price. Received and accepted quantities are distinct, not inferred receipt history or stock. No totals across units, blanket master and releases, or changes. Latest change number is a reference, not a change-order history. A release is kept separate by its full identity.\n\nOnly documented order types P/B/S/R, line types P/G/S/M, and statuses C/O/P/V are decoded. Additional agreement/system-closed or unknown codes remain Code plus the original value; NULL is blank, not No/zero. Header and line status may differ. Stored acknowledgment, release actions, proposed portal values and compliance controls are not inferred or implemented. Requested and promised delivery dates remain distinct. Supplier name is CURRENT enrichment from VEND_ID + COMPANY_ID, not an historical snapshot; missing names fall back to the business account reference without dropping the order. Contact is stored on the order, not borrowed from a current address. Project/account/org and configurable references are native business codes; no guessed names or labels. Allocation percentage is excluded because a 100% UI default does not prove stored 1-versus-100 scale. Delivery schedules, receipt history and related source documents are not included.\n\nEvidence: official Costpoint 8.1.0 transaction dictionary and separately frozen 8.1 purchasing functional/input help. Oracle type spellings are NOT verified Microsoft SQL Server DDL, and this is not a 2026 schema certificate. Most physical definitions are blank. Preserve the documented conflicts: input RECVD_QTY default says Amount; input currency default names a VEND column absent from the dictionary; SALES_TAX_RT appears twice with differing defaults; brief GUI total omits charge tax included in the input definition. This package avoids those guesses and reads stored totals. Input layouts are evidence, NOT instructions to import/write. Not Deltek Vantagepoint, Vision, Planning, Time & Expense or GovWin.\n\nRequires an administrator-authorised on-premises SQL Server transaction database and a dedicated least-privilege SELECT account. No dbo owner or Deltek Cloud direct SQL access is assumed. Confirm database/default schema, actual fields/types, all complete keys, company scope, currencies and dates. The default-schema guard refuses ambiguous object resolution but does not certify the intended database, company or source authorization. Direct SQL does NOT inherit Costpoint buyer, project, inventory, employee, ITAR/EAR, role, suppression or masking permissions. Opening filters are NOT ACLs. Use only appropriate permitted data. No sa/sysadmin, DDL, administration or writes. Pass Cifru read/compatibility checks, inspect a real preview and measure timings before using the report.\n\nNot tested on a real ERP or SQL Server. Documentary and synthetic query/native DEMO tests do not prove installed compatibility, source ACLs, completeness or regulatory compliance. Wholly fictional captures, no credentials, source connection addresses, cached business rows or executable code in the package. Unofficial, not affiliated with Deltek.\n\nPhysical dictionary: https://help.deltek.com/product/Costpoint/Documentation/81DataDictionary.html\nPurchase fields: https://help.deltek.com/Product/Costpoint/8.1/GA/POMMAIN_Contents_of_the_Manage_Purchase_Orders_Screen.html\nAccounts context: https://help.deltek.com/Product/Costpoint/8.1/GA/POMMAIN_Accounts_Subtask.html\nPhysical bindings: https://help.deltek.com/Product/Costpoint/8.1/GA/AOPUTLPO_Detailed_Table_Specifications.html",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "5D5C0FF0-6A52-5BC9-83D8-AB0F9B17F2AE",
"rootButtonCount": 1,
"summary": "Company/period to purchase orders, receiving/delivery context and nested project/account allocations in actual order currency.",
"tags": [
"Deltek Costpoint",
"SQL Server",
"Purchasing",
"Projects",
"Receiving",
"Accounts",
"Pro"
],
"title": "Purchase orders — lines and account allocations Pro"
}
}