Suppliers — addresses and contacts Pro
Company-scoped supplier dossier, purchasing/payment defaults and full address/contact drilldowns; not real ERP validation.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. Choose a company and inspect a supplier dossier: purchasing controls, commercial and payment defaults, government references and notes. Open complete Addresses and named Contacts separately 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 and two relations. 24 useful supplier values, 17 address values and eight contact values in grouped Details. Business supplier/address codes remain visible; internal composite keys, numeric contact keys and audit fields are hidden. Both children retain company + supplier scope; contacts verify their full address parent. The runtime parent key uses the joined canonical supplier spelling, not a differently cased child foreign key. Company selection is mandatory at opening; the native opening predicate reaches the live SQL read before its row limit. After-load search is local. Opening-option discovery may be bounded; a missing option does not prove absence of company records. Each list returns at most 1,000 rows and may be incomplete. Children use bound parameters and load only when opened. No scheduled refresh; row limits do not guarantee low server cost. Opening filters and schema guards are NOT an ERP authorization system.
The long supplier name and internal short name may differ; Location is a supplier reference, not the address itself. Purchase status, approval and subcontractor remain native codes because the selected documentation does not prove their SQL mappings. Only HOLD_PMT_FL and PAY_WHEN_PAID_FL are decoded as documented Y=Yes/N=No. Unknown values keep Code plus the original value; NULL is not No. Hold payments and pay-when-paid are defaults/controls, not evidence of a completed payment or actual payable balance. The pay-to supplier is a third-party payment reference, not an inferred recipient name. Payment terms are retained as a code; discount rates, calculated due dates and financial balances are not guessed. Currency and rate-group defaults may fall back to system settings or be overridden; they do not certify document currency, conversion rates or transaction amounts. UEI/CAGE are references, not a statement of registration validity.
Remittance and ordering use decode only documented D=Default, Y=Yes and N=No. These are address settings, not payment or delivery completion. ACTIVE_FL means US EFT activation, NOT general address activity, and is excluded with all bank/EFT, tax IDs and authentication information. The VEND_ADDR 8.1.0 dictionary lacks UEI/CAGE even though 8.1 functional address help displays them; these fields are therefore queried only on VEND, not invented on VEND_ADDR. SUBCTR_FL is not the distinct SM_SUBCTR_FL. The UI requires vendor IDs unique across companies, while the physical key includes company; full physical keys are retained without claiming duplicated IDs are a normal supported UI workflow.
Documentation: official Costpoint 8.1.0 Transaction Schema archive and frozen 8.1 functional help/import field definitions. Oracle type spellings in that archive are NOT verified Microsoft SQL Server DDL. Actual SQL Server types, owner, constraints and installed-release compatibility remain unverified. Most physical field definitions are blank, so separately preserved functional evidence is used for meaning. Import layouts are evidence, not instructions to run an import. This is not a 2026 schema certificate and not Deltek Vantagepoint, Vision, Planning, Time & Expense or GovWin.
Use an administrator-authorised on-premises SQL Server transaction database and a dedicated least-privilege SELECT account. Verify database/default schema, all three actual tables, every projected field, company scope and full keys before import. No dbo owner or Deltek Cloud SQL access is assumed. Queries refuse mismatched default-schema object resolution, but cannot identify the intended database/company or enforce Costpoint roles. GUI tax-ID suppression does not become a SQL SELECT ACL. An empty result is not proof of no records. Pass the Cifru read/compatibility test, inspect a real preview and measure timings. Do not use sa/sysadmin or run administrative/install/replication examples.
Not tested on a real ERP or SQL Server. Synthetic query tests and native DEMO captures contain wholly fictional data; they do not prove installed compatibility, source ACLs or statutory compliance. No credentials, connection addresses, cached business rows or vendor documents are included. Unofficial and not affiliated with Deltek.
Primary dictionary: https://help.deltek.com/product/Costpoint/Documentation/81DataDictionary.html
Supplier help (8.1): https://help.deltek.com/Product/Costpoint/8.1/GA/APMVEND.html
Physical input bindings (8.1): https://help.deltek.com/Product/Costpoint/8.1/GA/AOPUTLVU_Input_Files_and_Database_Tables.html
SQL Server installation context (8.1): https://help.deltek.com/Product/Costpoint/Documentation/Costpoint_8.1_Guides.html
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Supplier dossier
- Details: Addresses
- Details: Contacts
- Sub-button: Supplier addresses
- Sub-button: Supplier contacts
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.VEND_ID,N'#')),N':',m.VEND_ID,N':') AS VendorKey, COALESCE(NULLIF(LTRIM(RTRIM(m.VEND_LONG_NAME)),N''),LTRIM(RTRIM(m.VEND_NAME))) AS VendorName, m.VEND_ID AS VEND_ID, m.VEND_NAME AS VEND_NAME, m.VEND_NAME_EXT AS VEND_NAME_EXT, m.COMPANY_ID AS COMPANY_ID, m.S_VEND_PO_CNTL_CD AS S_VEND_PO_CNTL_CD, CASE m.HOLD_PMT_FL WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN m.HOLD_PMT_FL IS NULL THEN N'' ELSE CONCAT(N'Code ',m.HOLD_PMT_FL) END END AS PaymentHold, m.VEND_APPRVL_CD AS VEND_APPRVL_CD, m.SUBCTR_FL AS SUBCTR_FL, m.VEND_GRP_CD AS VEND_GRP_CD, m.VEND_SPCLTY AS VEND_SPCLTY, m.VEND_WEB_SITE AS VEND_WEB_SITE, m.TERMS_DC AS TERMS_DC, m.FOB_FLD AS FOB_FLD, m.SHIP_VIA_FLD AS SHIP_VIA_FLD, m.CUST_ACCT_FLD AS CUST_ACCT_FLD, m.AP_CHK_VEND_ID AS AP_CHK_VEND_ID, CASE m.PAY_WHEN_PAID_FL WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN m.PAY_WHEN_PAID_FL IS NULL THEN N'' ELSE CONCAT(N'Code ',m.PAY_WHEN_PAID_FL) END END AS PayWhenPaid, m.DFLT_TRN_CRNCY_CD AS DFLT_TRN_CRNCY_CD, m.DFLT_PAY_CRNCY_CD AS DFLT_PAY_CRNCY_CD, m.DFLT_RT_GRP_ID AS DFLT_RT_GRP_ID, m.UEI_NO AS UEI_NO, m.CAGE_CD AS CAGE_CD, m.VEND_NOTES AS VEND_NOTES FROM VEND m WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U') AND OBJECT_ID(N'VEND_ADDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR',N'U') AND OBJECT_ID(N'VEND_ADDR_CNTACT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR_CNTACT',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(LEN(CONCAT(a.COMPANY_ID,N'#')),N':',a.COMPANY_ID,N':',LEN(CONCAT(a.VEND_ID,N'#')),N':',a.VEND_ID,N':',LEN(CONCAT(a.ADDR_DC,N'#')),N':',a.ADDR_DC,N':') AS AddressKey, CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VEND_ID,N'#')),N':',m.VEND_ID,N':') AS ParentVendorKey, a.ADDR_DC AS ADDR_DC, a.LN_1_ADR AS LN_1_ADR, a.LN_2_ADR AS LN_2_ADR, a.LN_3_ADR AS LN_3_ADR, a.CITY_NAME AS CITY_NAME, a.MAIL_STATE_DC AS MAIL_STATE_DC, a.POSTAL_CD AS POSTAL_CD, a.COUNTRY_CD AS COUNTRY_CD, a.PHONE_ID AS PHONE_ID, a.FAX_ID AS FAX_ID, a.OTH_PHONE_ID AS OTH_PHONE_ID, a.EMAIL_ID AS EMAIL_ID, CASE a.S_PMT_ADDR_CD WHEN N'D' THEN N'Default' WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN a.S_PMT_ADDR_CD IS NULL THEN N'' ELSE CONCAT(N'Code ',a.S_PMT_ADDR_CD) END END AS PaymentUse, CASE a.S_ORD_ADDR_CD WHEN N'D' THEN N'Default' WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN a.S_ORD_ADDR_CD IS NULL THEN N'' ELSE CONCAT(N'Code ',a.S_ORD_ADDR_CD) END END AS OrderUse, a.SHIP_ID AS SHIP_ID, a.SALES_TAX_CD AS SALES_TAX_CD, a.CONGRESS_DISTRICT AS CONGRESS_DISTRICT FROM VEND_ADDR a INNER JOIN VEND m ON m.VEND_ID=a.VEND_ID AND m.COMPANY_ID=a.COMPANY_ID WHERE a.VEND_ID=:vendor AND a.COMPANY_ID=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U') AND OBJECT_ID(N'VEND_ADDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR',N'U') AND OBJECT_ID(N'VEND_ADDR_CNTACT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR_CNTACT',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(LEN(CONCAT(p.COMPANY_ID,N'#')),N':',p.COMPANY_ID,N':',LEN(CONCAT(p.VEND_ID,N'#')),N':',p.VEND_ID,N':',LEN(CONCAT(p.ADDR_DC,N'#')),N':',p.ADDR_DC,N':',LEN(CONCAT(p.VEND_ADDR_CNT_KEY,N'#')),N':',p.VEND_ADDR_CNT_KEY,N':') AS ContactKey, CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VEND_ID,N'#')),N':',m.VEND_ID,N':') AS ParentVendorKey, LTRIM(RTRIM(CONCAT(p.CNTACT_FIRST_NAME,N' ',p.CNTACT_LAST_NAME))) AS ContactName, p.ADDR_DC AS ADDR_DC, p.CNTACT_TITLE_NAME AS CNTACT_TITLE_NAME, p.PHONE_ID AS PHONE_ID, p.FAX_ID AS FAX_ID, p.OTH_PHONE_ID AS OTH_PHONE_ID, p.EMAIL_ID AS EMAIL_ID, p.NOTES AS NOTES FROM VEND_ADDR_CNTACT p INNER JOIN VEND_ADDR a ON a.VEND_ID=p.VEND_ID AND a.COMPANY_ID=p.COMPANY_ID AND a.ADDR_DC=p.ADDR_DC INNER JOIN VEND m ON m.VEND_ID=a.VEND_ID AND m.COMPANY_ID=a.COMPANY_ID WHERE p.VEND_ID=:vendor AND p.COMPANY_ID=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U') AND OBJECT_ID(N'VEND_ADDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR',N'U') AND OBJECT_ID(N'VEND_ADDR_CNTACT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR_CNTACT',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": "36AC8EC2-81CB-57F9-B2FA-E24B04479249",
"kind": "sqlServer",
"requiredObjects": [
"VEND",
"VEND_ADDR",
"VEND_ADDR_CNTACT"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "B3C5665E-F32F-5A05-BB03-A0E5B7192640",
"key": "VendorName",
"type": "text"
},
{
"direction": "ascending",
"id": "BC515F3F-CAEC-53F1-9967-06042027411E",
"key": "VendorKey",
"type": "text"
}
],
"id": "A1966236-3B8A-5891-97BD-84B8B708F91E",
"mappings": [
{
"commonFieldKey": "",
"key": "VendorKey",
"label": "Internal VendorKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorName",
"label": "Supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VEND_ID",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VEND_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VEND_NAME",
"label": "Internal short name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VEND_NAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VEND_NAME_EXT",
"label": "Location reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VEND_NAME_EXT",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMPANY_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "S_VEND_PO_CNTL_CD",
"label": "Purchase status code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "S_VEND_PO_CNTL_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaymentHold",
"label": "Hold payments",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymentHold",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VEND_APPRVL_CD",
"label": "Approval code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VEND_APPRVL_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SUBCTR_FL",
"label": "Subcontractor flag (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SUBCTR_FL",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VEND_GRP_CD",
"label": "Supplier group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VEND_GRP_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VEND_SPCLTY",
"label": "Specialty",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VEND_SPCLTY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VEND_WEB_SITE",
"label": "Website",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VEND_WEB_SITE",
"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": true
},
{
"commonFieldKey": "",
"key": "FOB_FLD",
"label": "Delivery terms default",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FOB_FLD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIP_VIA_FLD",
"label": "Ship via default",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHIP_VIA_FLD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CUST_ACCT_FLD",
"label": "Our account at supplier",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CUST_ACCT_FLD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AP_CHK_VEND_ID",
"label": "Pay-to supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AP_CHK_VEND_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PayWhenPaid",
"label": "Pay when paid",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PayWhenPaid",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DFLT_TRN_CRNCY_CD",
"label": "Voucher currency default",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DFLT_TRN_CRNCY_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DFLT_PAY_CRNCY_CD",
"label": "Payment currency default",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DFLT_PAY_CRNCY_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DFLT_RT_GRP_ID",
"label": "Rate group default",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DFLT_RT_GRP_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UEI_NO",
"label": "UEI reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UEI_NO",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CAGE_CD",
"label": "CAGE reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CAGE_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VEND_NOTES",
"label": "Supplier notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VEND_NOTES",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Supplier dossier",
"primaryKey": "VendorKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VendorName",
"VEND_ID",
"VEND_NAME",
"VEND_NAME_EXT",
"COMPANY_ID",
"S_VEND_PO_CNTL_CD",
"PaymentHold",
"VEND_APPRVL_CD",
"SUBCTR_FL",
"VEND_GRP_CD",
"VEND_SPCLTY",
"VEND_WEB_SITE",
"TERMS_DC",
"FOB_FLD",
"SHIP_VIA_FLD",
"CUST_ACCT_FLD",
"AP_CHK_VEND_ID",
"PayWhenPaid",
"DFLT_TRN_CRNCY_CD",
"DFLT_PAY_CRNCY_CD",
"DFLT_RT_GRP_ID",
"UEI_NO",
"CAGE_CD",
"VEND_NOTES"
],
"sourceID": "36AC8EC2-81CB-57F9-B2FA-E24B04479249",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VEND_ID,N'#')),N':',m.VEND_ID,N':') AS VendorKey, COALESCE(NULLIF(LTRIM(RTRIM(m.VEND_LONG_NAME)),N''),LTRIM(RTRIM(m.VEND_NAME))) AS VendorName, m.VEND_ID AS VEND_ID, m.VEND_NAME AS VEND_NAME, m.VEND_NAME_EXT AS VEND_NAME_EXT, m.COMPANY_ID AS COMPANY_ID, m.S_VEND_PO_CNTL_CD AS S_VEND_PO_CNTL_CD, CASE m.HOLD_PMT_FL WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN m.HOLD_PMT_FL IS NULL THEN N'' ELSE CONCAT(N'Code ',m.HOLD_PMT_FL) END END AS PaymentHold, m.VEND_APPRVL_CD AS VEND_APPRVL_CD, m.SUBCTR_FL AS SUBCTR_FL, m.VEND_GRP_CD AS VEND_GRP_CD, m.VEND_SPCLTY AS VEND_SPCLTY, m.VEND_WEB_SITE AS VEND_WEB_SITE, m.TERMS_DC AS TERMS_DC, m.FOB_FLD AS FOB_FLD, m.SHIP_VIA_FLD AS SHIP_VIA_FLD, m.CUST_ACCT_FLD AS CUST_ACCT_FLD, m.AP_CHK_VEND_ID AS AP_CHK_VEND_ID, CASE m.PAY_WHEN_PAID_FL WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN m.PAY_WHEN_PAID_FL IS NULL THEN N'' ELSE CONCAT(N'Code ',m.PAY_WHEN_PAID_FL) END END AS PayWhenPaid, m.DFLT_TRN_CRNCY_CD AS DFLT_TRN_CRNCY_CD, m.DFLT_PAY_CRNCY_CD AS DFLT_PAY_CRNCY_CD, m.DFLT_RT_GRP_ID AS DFLT_RT_GRP_ID, m.UEI_NO AS UEI_NO, m.CAGE_CD AS CAGE_CD, m.VEND_NOTES AS VEND_NOTES FROM VEND m WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U') AND OBJECT_ID(N'VEND_ADDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR',N'U') AND OBJECT_ID(N'VEND_ADDR_CNTACT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR_CNTACT',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "A30EFEC7-2218-5C07-AB43-0BB7363CAA23",
"key": "ADDR_DC",
"type": "text"
},
{
"direction": "ascending",
"id": "4FFDE6B4-2149-5A3F-9385-91284A8741BF",
"key": "AddressKey",
"type": "text"
}
],
"id": "8D6647CB-5915-5671-86CB-8090955F3A2C",
"mappings": [
{
"commonFieldKey": "",
"key": "AddressKey",
"label": "Internal AddressKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AddressKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentVendorKey",
"label": "Internal ParentVendorKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentVendorKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDR_DC",
"label": "Address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDR_DC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LN_1_ADR",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LN_1_ADR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LN_2_ADR",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LN_2_ADR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LN_3_ADR",
"label": "Address line 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LN_3_ADR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CITY_NAME",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CITY_NAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MAIL_STATE_DC",
"label": "State / province code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MAIL_STATE_DC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "POSTAL_CD",
"label": "Postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "POSTAL_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "COUNTRY_CD",
"label": "Country code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COUNTRY_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PHONE_ID",
"label": "Address phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHONE_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FAX_ID",
"label": "Address fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FAX_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OTH_PHONE_ID",
"label": "Other phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OTH_PHONE_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EMAIL_ID",
"label": "Address email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EMAIL_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaymentUse",
"label": "Remittance use",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymentUse",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderUse",
"label": "Ordering use",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderUse",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SHIP_ID",
"label": "Shipping address ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHIP_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SALES_TAX_CD",
"label": "Sales tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SALES_TAX_CD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CONGRESS_DISTRICT",
"label": "Congressional district",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CONGRESS_DISTRICT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Supplier addresses",
"primaryKey": "AddressKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VEND_ID",
"id": "FACD0B81-B536-5853-BC85-E6B83FFFA2FB",
"name": "vendor",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "COMPANY_ID",
"id": "7B25B713-A9B5-583F-8B37-75591DF5BF0F",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ADDR_DC",
"LN_1_ADR",
"LN_2_ADR",
"LN_3_ADR",
"CITY_NAME",
"MAIL_STATE_DC",
"POSTAL_CD",
"COUNTRY_CD",
"PHONE_ID",
"FAX_ID",
"OTH_PHONE_ID",
"EMAIL_ID",
"PaymentUse",
"OrderUse",
"SHIP_ID",
"SALES_TAX_CD",
"CONGRESS_DISTRICT"
],
"sourceID": "36AC8EC2-81CB-57F9-B2FA-E24B04479249",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(a.COMPANY_ID,N'#')),N':',a.COMPANY_ID,N':',LEN(CONCAT(a.VEND_ID,N'#')),N':',a.VEND_ID,N':',LEN(CONCAT(a.ADDR_DC,N'#')),N':',a.ADDR_DC,N':') AS AddressKey, CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VEND_ID,N'#')),N':',m.VEND_ID,N':') AS ParentVendorKey, a.ADDR_DC AS ADDR_DC, a.LN_1_ADR AS LN_1_ADR, a.LN_2_ADR AS LN_2_ADR, a.LN_3_ADR AS LN_3_ADR, a.CITY_NAME AS CITY_NAME, a.MAIL_STATE_DC AS MAIL_STATE_DC, a.POSTAL_CD AS POSTAL_CD, a.COUNTRY_CD AS COUNTRY_CD, a.PHONE_ID AS PHONE_ID, a.FAX_ID AS FAX_ID, a.OTH_PHONE_ID AS OTH_PHONE_ID, a.EMAIL_ID AS EMAIL_ID, CASE a.S_PMT_ADDR_CD WHEN N'D' THEN N'Default' WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN a.S_PMT_ADDR_CD IS NULL THEN N'' ELSE CONCAT(N'Code ',a.S_PMT_ADDR_CD) END END AS PaymentUse, CASE a.S_ORD_ADDR_CD WHEN N'D' THEN N'Default' WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN a.S_ORD_ADDR_CD IS NULL THEN N'' ELSE CONCAT(N'Code ',a.S_ORD_ADDR_CD) END END AS OrderUse, a.SHIP_ID AS SHIP_ID, a.SALES_TAX_CD AS SALES_TAX_CD, a.CONGRESS_DISTRICT AS CONGRESS_DISTRICT FROM VEND_ADDR a INNER JOIN VEND m ON m.VEND_ID=a.VEND_ID AND m.COMPANY_ID=a.COMPANY_ID WHERE a.VEND_ID=:vendor AND a.COMPANY_ID=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U') AND OBJECT_ID(N'VEND_ADDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR',N'U') AND OBJECT_ID(N'VEND_ADDR_CNTACT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR_CNTACT',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "0D4462F7-1B82-5940-9A03-D0B65161D699",
"key": "ContactName",
"type": "text"
},
{
"direction": "ascending",
"id": "992EF8B7-F10C-54B1-A8C7-5989E8B1BD96",
"key": "ContactKey",
"type": "text"
}
],
"id": "D7523708-A547-586C-9E41-A2D5A3B56BF4",
"mappings": [
{
"commonFieldKey": "",
"key": "ContactKey",
"label": "Internal ContactKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentVendorKey",
"label": "Internal ParentVendorKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentVendorKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ContactName",
"label": "Contact name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDR_DC",
"label": "Address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDR_DC",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CNTACT_TITLE_NAME",
"label": "Job title",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CNTACT_TITLE_NAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHONE_ID",
"label": "Primary phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHONE_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FAX_ID",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FAX_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OTH_PHONE_ID",
"label": "Other phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OTH_PHONE_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EMAIL_ID",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EMAIL_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "NOTES",
"label": "Contact comments",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NOTES",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Supplier contacts",
"primaryKey": "ContactKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VEND_ID",
"id": "FACD0B81-B536-5853-BC85-E6B83FFFA2FB",
"name": "vendor",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "COMPANY_ID",
"id": "7B25B713-A9B5-583F-8B37-75591DF5BF0F",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ContactName",
"ADDR_DC",
"CNTACT_TITLE_NAME",
"PHONE_ID",
"FAX_ID",
"OTH_PHONE_ID",
"EMAIL_ID",
"NOTES"
],
"sourceID": "36AC8EC2-81CB-57F9-B2FA-E24B04479249",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(p.COMPANY_ID,N'#')),N':',p.COMPANY_ID,N':',LEN(CONCAT(p.VEND_ID,N'#')),N':',p.VEND_ID,N':',LEN(CONCAT(p.ADDR_DC,N'#')),N':',p.ADDR_DC,N':',LEN(CONCAT(p.VEND_ADDR_CNT_KEY,N'#')),N':',p.VEND_ADDR_CNT_KEY,N':') AS ContactKey, CONCAT(LEN(CONCAT(m.COMPANY_ID,N'#')),N':',m.COMPANY_ID,N':',LEN(CONCAT(m.VEND_ID,N'#')),N':',m.VEND_ID,N':') AS ParentVendorKey, LTRIM(RTRIM(CONCAT(p.CNTACT_FIRST_NAME,N' ',p.CNTACT_LAST_NAME))) AS ContactName, p.ADDR_DC AS ADDR_DC, p.CNTACT_TITLE_NAME AS CNTACT_TITLE_NAME, p.PHONE_ID AS PHONE_ID, p.FAX_ID AS FAX_ID, p.OTH_PHONE_ID AS OTH_PHONE_ID, p.EMAIL_ID AS EMAIL_ID, p.NOTES AS NOTES FROM VEND_ADDR_CNTACT p INNER JOIN VEND_ADDR a ON a.VEND_ID=p.VEND_ID AND a.COMPANY_ID=p.COMPANY_ID AND a.ADDR_DC=p.ADDR_DC INNER JOIN VEND m ON m.VEND_ID=a.VEND_ID AND m.COMPANY_ID=a.COMPANY_ID WHERE p.VEND_ID=:vendor AND p.COMPANY_ID=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VEND',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND',N'U') AND OBJECT_ID(N'VEND_ADDR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR',N'U') AND OBJECT_ID(N'VEND_ADDR_CNTACT',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VEND_ADDR_CNTACT',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "7E4FCDBB-6850-533C-822A-B1D9AE40C71C",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "6BAEAEC1-97CB-5885-BFA1-09894AE1078D",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8D6647CB-5915-5671-86CB-8090955F3A2C",
"title": "Addresses",
"urlKey": ""
},
{
"id": "7F12C3C3-45EC-5AD0-8930-EE8EA9AD20DD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "1C3E1042-CD5B-5475-8A3A-E5F0E0684A2E",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "D7523708-A547-586C-9E41-A2D5A3B56BF4",
"title": "Contacts",
"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": "VEND_NAME_EXT",
"label": "Location reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VEND_GRP_CD",
"label": "Supplier group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "S_VEND_PO_CNTL_CD",
"label": "Purchase status code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaymentHold",
"label": "Hold payments",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TERMS_DC",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "A1966236-3B8A-5891-97BD-84B8B708F91E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Supplier account",
"detailRole": "information",
"isVisible": true,
"key": "VendorName",
"label": "Supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Supplier account",
"detailRole": "information",
"isVisible": true,
"key": "VEND_ID",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Supplier account",
"detailRole": "information",
"isVisible": true,
"key": "VEND_NAME",
"label": "Internal short name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Supplier account",
"detailRole": "information",
"isVisible": true,
"key": "VEND_NAME_EXT",
"label": "Location reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Supplier account",
"detailRole": "information",
"isVisible": true,
"key": "COMPANY_ID",
"label": "Company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchasing controls",
"detailRole": "information",
"isVisible": true,
"key": "S_VEND_PO_CNTL_CD",
"label": "Purchase status code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchasing controls",
"detailRole": "information",
"isVisible": true,
"key": "PaymentHold",
"label": "Hold payments",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchasing controls",
"detailRole": "information",
"isVisible": true,
"key": "VEND_APPRVL_CD",
"label": "Approval code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchasing controls",
"detailRole": "information",
"isVisible": true,
"key": "SUBCTR_FL",
"label": "Subcontractor flag (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Purchasing controls",
"detailRole": "information",
"isVisible": true,
"key": "VEND_GRP_CD",
"label": "Supplier group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Commercial defaults",
"detailRole": "information",
"isVisible": true,
"key": "VEND_SPCLTY",
"label": "Specialty",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Commercial defaults",
"detailRole": "information",
"isVisible": true,
"key": "VEND_WEB_SITE",
"label": "Website",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Commercial defaults",
"detailRole": "information",
"isVisible": true,
"key": "TERMS_DC",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Commercial defaults",
"detailRole": "information",
"isVisible": true,
"key": "FOB_FLD",
"label": "Delivery terms default",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Commercial defaults",
"detailRole": "information",
"isVisible": true,
"key": "SHIP_VIA_FLD",
"label": "Ship via default",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Commercial defaults",
"detailRole": "information",
"isVisible": true,
"key": "CUST_ACCT_FLD",
"label": "Our account at supplier",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "AP_CHK_VEND_ID",
"label": "Pay-to supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "PayWhenPaid",
"label": "Pay when paid",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "DFLT_TRN_CRNCY_CD",
"label": "Voucher currency default",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "DFLT_PAY_CRNCY_CD",
"label": "Payment currency default",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "DFLT_RT_GRP_ID",
"label": "Rate group default",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Government references",
"detailRole": "information",
"isVisible": true,
"key": "UEI_NO",
"label": "UEI reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Government references",
"detailRole": "information",
"isVisible": true,
"key": "CAGE_CD",
"label": "CAGE reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Context",
"detailRole": "information",
"isVisible": true,
"key": "VEND_NOTES",
"label": "Supplier notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "6860A990-334A-5555-A97B-39D04B29F6E5",
"openFilters": [
{
"id": "B353CB46-69CC-523B-B29F-BA85B3D7F702",
"includeAllOption": false,
"key": "COMPANY_ID",
"title": "Company",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "B3C5665E-F32F-5A05-BB03-A0E5B7192640",
"key": "VendorName",
"type": "text"
},
{
"direction": "ascending",
"id": "BC515F3F-CAEC-53F1-9967-06042027411E",
"key": "VendorKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "VEND_ID",
"systemImage": "building.2",
"title": "Supplier dossier",
"titleKey": "VendorName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CITY_NAME",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "POSTAL_CD",
"label": "Postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "COUNTRY_CD",
"label": "Country code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaymentUse",
"label": "Remittance use",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderUse",
"label": "Ordering use",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EMAIL_ID",
"label": "Address email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "8D6647CB-5915-5671-86CB-8090955F3A2C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Location",
"detailRole": "information",
"isVisible": true,
"key": "ADDR_DC",
"label": "Address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Location",
"detailRole": "information",
"isVisible": true,
"key": "LN_1_ADR",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Location",
"detailRole": "information",
"isVisible": true,
"key": "LN_2_ADR",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Location",
"detailRole": "information",
"isVisible": true,
"key": "LN_3_ADR",
"label": "Address line 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Location",
"detailRole": "information",
"isVisible": true,
"key": "CITY_NAME",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Location",
"detailRole": "information",
"isVisible": true,
"key": "MAIL_STATE_DC",
"label": "State / province code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Location",
"detailRole": "information",
"isVisible": true,
"key": "POSTAL_CD",
"label": "Postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Location",
"detailRole": "information",
"isVisible": true,
"key": "COUNTRY_CD",
"label": "Country code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contact channels",
"detailRole": "information",
"isVisible": true,
"key": "PHONE_ID",
"label": "Address phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contact channels",
"detailRole": "information",
"isVisible": true,
"key": "FAX_ID",
"label": "Address fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contact channels",
"detailRole": "information",
"isVisible": true,
"key": "OTH_PHONE_ID",
"label": "Other phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contact channels",
"detailRole": "information",
"isVisible": true,
"key": "EMAIL_ID",
"label": "Address email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address usage",
"detailRole": "information",
"isVisible": true,
"key": "PaymentUse",
"label": "Remittance use",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address usage",
"detailRole": "information",
"isVisible": true,
"key": "OrderUse",
"label": "Ordering use",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address usage",
"detailRole": "information",
"isVisible": true,
"key": "SHIP_ID",
"label": "Shipping address ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address usage",
"detailRole": "information",
"isVisible": true,
"key": "SALES_TAX_CD",
"label": "Sales tax code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address usage",
"detailRole": "information",
"isVisible": true,
"key": "CONGRESS_DISTRICT",
"label": "Congressional district",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "F6FB1628-CD3D-5BFF-B0B4-3D360EC3C823",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "A30EFEC7-2218-5C07-AB43-0BB7363CAA23",
"key": "ADDR_DC",
"type": "text"
},
{
"direction": "ascending",
"id": "4FFDE6B4-2149-5A3F-9385-91284A8741BF",
"key": "AddressKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "LN_1_ADR",
"systemImage": "map",
"title": "Supplier addresses",
"titleKey": "ADDR_DC"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ADDR_DC",
"label": "Address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PHONE_ID",
"label": "Primary phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EMAIL_ID",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "D7523708-A547-586C-9E41-A2D5A3B56BF4",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Contact person",
"detailRole": "information",
"isVisible": true,
"key": "ContactName",
"label": "Contact name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contact person",
"detailRole": "information",
"isVisible": true,
"key": "CNTACT_TITLE_NAME",
"label": "Job title",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contact person",
"detailRole": "information",
"isVisible": true,
"key": "ADDR_DC",
"label": "Address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contact channels",
"detailRole": "information",
"isVisible": true,
"key": "PHONE_ID",
"label": "Primary phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contact channels",
"detailRole": "information",
"isVisible": true,
"key": "FAX_ID",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contact channels",
"detailRole": "information",
"isVisible": true,
"key": "OTH_PHONE_ID",
"label": "Other phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contact channels",
"detailRole": "information",
"isVisible": true,
"key": "EMAIL_ID",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Context",
"detailRole": "information",
"isVisible": true,
"key": "NOTES",
"label": "Contact comments",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "33988768-D2A2-56AA-92F6-B038D2CEB49E",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "0D4462F7-1B82-5940-9A03-D0B65161D699",
"key": "ContactName",
"type": "text"
},
{
"direction": "ascending",
"id": "992EF8B7-F10C-54B1-A8C7-5989E8B1BD96",
"key": "ContactKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "CNTACT_TITLE_NAME",
"systemImage": "person.crop.circle",
"title": "Supplier contacts",
"titleKey": "ContactName"
}
],
"relations": [
{
"childDatasetID": "8D6647CB-5915-5671-86CB-8090955F3A2C",
"childKey": "ParentVendorKey",
"id": "6BAEAEC1-97CB-5885-BFA1-09894AE1078D",
"name": "Addresses",
"parentDatasetID": "A1966236-3B8A-5891-97BD-84B8B708F91E",
"parentKey": "VendorKey"
},
{
"childDatasetID": "D7523708-A547-586C-9E41-A2D5A3B56BF4",
"childKey": "ParentVendorKey",
"id": "1C3E1042-CD5B-5475-8A3A-E5F0E0684A2E",
"name": "Contacts",
"parentDatasetID": "A1966236-3B8A-5891-97BD-84B8B708F91E",
"parentKey": "VendorKey"
}
],
"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. Choose a company and inspect a supplier dossier: purchasing controls, commercial and payment defaults, government references and notes. Open complete Addresses and named Contacts separately 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 and two relations. 24 useful supplier values, 17 address values and eight contact values in grouped Details. Business supplier/address codes remain visible; internal composite keys, numeric contact keys and audit fields are hidden. Both children retain company + supplier scope; contacts verify their full address parent. The runtime parent key uses the joined canonical supplier spelling, not a differently cased child foreign key. Company selection is mandatory at opening; the native opening predicate reaches the live SQL read before its row limit. After-load search is local. Opening-option discovery may be bounded; a missing option does not prove absence of company records. Each list returns at most 1,000 rows and may be incomplete. Children use bound parameters and load only when opened. No scheduled refresh; row limits do not guarantee low server cost. Opening filters and schema guards are NOT an ERP authorization system.\n\nThe long supplier name and internal short name may differ; Location is a supplier reference, not the address itself. Purchase status, approval and subcontractor remain native codes because the selected documentation does not prove their SQL mappings. Only HOLD_PMT_FL and PAY_WHEN_PAID_FL are decoded as documented Y=Yes/N=No. Unknown values keep Code plus the original value; NULL is not No. Hold payments and pay-when-paid are defaults/controls, not evidence of a completed payment or actual payable balance. The pay-to supplier is a third-party payment reference, not an inferred recipient name. Payment terms are retained as a code; discount rates, calculated due dates and financial balances are not guessed. Currency and rate-group defaults may fall back to system settings or be overridden; they do not certify document currency, conversion rates or transaction amounts. UEI/CAGE are references, not a statement of registration validity.\n\nRemittance and ordering use decode only documented D=Default, Y=Yes and N=No. These are address settings, not payment or delivery completion. ACTIVE_FL means US EFT activation, NOT general address activity, and is excluded with all bank/EFT, tax IDs and authentication information. The VEND_ADDR 8.1.0 dictionary lacks UEI/CAGE even though 8.1 functional address help displays them; these fields are therefore queried only on VEND, not invented on VEND_ADDR. SUBCTR_FL is not the distinct SM_SUBCTR_FL. The UI requires vendor IDs unique across companies, while the physical key includes company; full physical keys are retained without claiming duplicated IDs are a normal supported UI workflow.\n\nDocumentation: official Costpoint 8.1.0 Transaction Schema archive and frozen 8.1 functional help/import field definitions. Oracle type spellings in that archive are NOT verified Microsoft SQL Server DDL. Actual SQL Server types, owner, constraints and installed-release compatibility remain unverified. Most physical field definitions are blank, so separately preserved functional evidence is used for meaning. Import layouts are evidence, not instructions to run an import. This is not a 2026 schema certificate and not Deltek Vantagepoint, Vision, Planning, Time & Expense or GovWin.\n\nUse an administrator-authorised on-premises SQL Server transaction database and a dedicated least-privilege SELECT account. Verify database/default schema, all three actual tables, every projected field, company scope and full keys before import. No dbo owner or Deltek Cloud SQL access is assumed. Queries refuse mismatched default-schema object resolution, but cannot identify the intended database/company or enforce Costpoint roles. GUI tax-ID suppression does not become a SQL SELECT ACL. An empty result is not proof of no records. Pass the Cifru read/compatibility test, inspect a real preview and measure timings. Do not use sa/sysadmin or run administrative/install/replication examples.\n\nNot tested on a real ERP or SQL Server. Synthetic query tests and native DEMO captures contain wholly fictional data; they do not prove installed compatibility, source ACLs or statutory compliance. No credentials, connection addresses, cached business rows or vendor documents are included. Unofficial and not affiliated with Deltek.\n\nPrimary dictionary: https://help.deltek.com/product/Costpoint/Documentation/81DataDictionary.html\nSupplier help (8.1): https://help.deltek.com/Product/Costpoint/8.1/GA/APMVEND.html\nPhysical input bindings (8.1): https://help.deltek.com/Product/Costpoint/8.1/GA/AOPUTLVU_Input_Files_and_Database_Tables.html\nSQL Server installation context (8.1): https://help.deltek.com/Product/Costpoint/Documentation/Costpoint_8.1_Guides.html",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "12A0AD23-7AAB-5BB9-9EC5-2034B8E44A16",
"rootButtonCount": 1,
"summary": "Company-scoped supplier dossier, purchasing/payment defaults and full address/contact drilldowns; not real ERP validation.",
"tags": [
"Deltek Costpoint",
"SQL Server",
"Suppliers",
"Purchasing",
"Accounts payable",
"Addresses",
"Contacts",
"Pro"
],
"title": "Suppliers — addresses and contacts Pro"
}
}