Vendor dossier and address book — Pro
Supplier contacts, payment/delivery defaults, separate payment hold/status and on-demand addresses.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. Microsoft public GP migration code documents the selected PM00200/PM00300 source registrations, GP-shaped field names and logical staging keys at commit e7ed235bc979c0283306e9639ff7cd22ce78341d. AL staging types/keys are not SQL DDL. No real GP/SQL Server results, installed release, physical types, constraints, owner or query performance have been verified. Run the import read/compatibility test and verify your edition, schema and permissions before business use.
For purchasing, accounts payable, supplier service and managers: choose a vendor class, find a supplier and inspect a grouped 35-field dossier. See contacts, the master address, payee name, your commercial account code with that vendor, payment/delivery defaults, separate stored payment hold and vendor status, and business notes. Open the selected vendor's address book with its own contacts, phone/fax and location instead of guessing which address a code represents.
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 source, two lists, one related button and explicit read-only SQL. Reads select only 35 master fields and 10 address fields plus a hidden full row key; no SELECT *. No tax-registration or government identifiers, birth dates, bank/checkbook data, uncertain monetary limits or technical audit columns are requested. This avoids depending on the native-table reader's first-80-column projection. Each list is live and bounded to 2,000 rows, without scheduled refresh. Addresses load only on demand and are constrained by the selected vendor. Reaching a limit can mean incomplete data; filters do not guarantee a cheap server scan. SQL syntax and Cifru wrapping still require a real source test.
Vendor and address business codes preserve leading zeroes; only right-padding is removed from these keys. Hidden address identity contains both vendor and address code, keeping the same address code under different vendors separate. Use the company database, not DYNAMICS, Business Central or a migration staging database; dbo must be checked locally. The address subset is not the entire GP vendor module: country, third address line, email, shipping/tax extensions, orders, vouchers, balances and transactions are not claimed for PM00300.
Vendor hold restricts payment, not all transactions: GP can still apply vouchers and post transactions while a vendor is on hold. Hold is not inactive or customer credit hold and does not calculate effective eligibility. Stored flags use 1/true=yes and 0/false=no. Microsoft's migrator identifies VENDSTTS=3 as temporary; other numeric status values remain raw codes rather than guessed active/inactive labels. Primary and remit-to address codes are evidenced. VADCDPAD and VADCDSFR retain their native code names because their physical field-to-role mapping is not certified here. ACNMVNDR is the account code assigned to your company by the vendor, not a bank account. VNDCHKNM is the payee/check name. Payment priority, class, terms, shipping, tax schedule and rate are native codes, not invented lookup descriptions. Grace days are payment settings, not overdue days. Default currency ID need not be ISO or the company functional currency; no currency conversion or monetary aggregation is performed. Empty fields remain empty.
Use a separately authorised least-privilege SQL reporting login with SELECT only on permitted company data. GP application passwords are transformed, not ordinary SQL login passwords. Do not use sa, sysadmin or DYNGRP. Cifru filters are not access control. The package embeds no host, account, password or business rows; real contacts and commercial defaults may still be confidential. Screenshots are native Cifru with wholly fictional DEMO rows and synthetic transport, not a live GP/SQL Server connection. Unofficial and not endorsed by Microsoft.
Primary source registration: https://github.com/microsoft/ALAppExtensions/blob/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/codeunits/GPCloudMigration.codeunit.al
Vendor fields: https://raw.githubusercontent.com/microsoft/ALAppExtensions/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/Migration/Vendors/GPPM00200.Table.al
Address fields/key: https://raw.githubusercontent.com/microsoft/ALAppExtensions/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/Migration/Vendors/GPVendorAddress.table.al
Vendor role/status evidence: https://raw.githubusercontent.com/microsoft/ALAppExtensions/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/Migration/Vendors/GPVendorMigrator.codeunit.al
Functional manual: https://learn.microsoft.com/en-us/dynamics-gp/financials/payablesmanagement
Security: https://learn.microsoft.com/en-us/dynamics-gp/installation/securityplanning
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Vendors
- Details: Vendor address book
- Sub-button: Vendor addresses
Sources are mapped locally and verified before applying.
Custom queriesPRO2 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT RTRIM(m.VENDORID) AS VENDORID, m.VENDNAME, m.VNDCHKNM, m.VENDSHNM, m.VNDCLSID, m.VNDCNTCT, m.ADDRESS1, m.ADDRESS2, m.ADDRESS3, m.CITY, m.STATE, m.ZIPCODE, m.COUNTRY, m.PHNUMBR1, m.PHNUMBR2, m.PHONE3, m.FAXNUMBR, m.VADDCDPR, m.VADCDPAD, m.VADCDSFR, m.VADCDTRO, m.SHIPMTHD, m.TAXSCHID, m.UPSZONE, m.ACNMVNDR, m.VENDSTTS, m.HOLD, m.CURNCYID, m.RATETPID, m.PYMTRMID, m.PYMNTPRI, m.DISGRPER, m.DUEGRPER, m.COMMENT1, m.COMMENT2 FROM dbo.PM00200 m
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(LEN(RTRIM(a.VENDORID)),N':',RTRIM(a.VENDORID),RTRIM(a.ADRSCODE)) AS VendorAddressKey, RTRIM(a.VENDORID) AS VENDORID, RTRIM(a.ADRSCODE) AS ADRSCODE, a.VNDCNTCT, a.ADDRESS1, a.ADDRESS2, a.CITY, a.STATE, a.ZIPCODE, a.PHNUMBR1, a.FAXNUMBR FROM dbo.PM00300 a WHERE a.VENDORID=:vendor
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Dynamics GP — authorised SQL company database",
"id": "2CCD6A96-429B-5CE3-BF0E-DAFE11AB3359",
"kind": "sqlServer",
"requiredObjects": [
"dbo.PM00200",
"dbo.PM00300"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "4F40E7DE-5D5B-5A48-AF93-30EC861BFC6E",
"key": "VENDNAME",
"type": "text"
},
{
"direction": "ascending",
"id": "44EA15AF-43DA-5B5D-8A52-17FD850DB6B6",
"key": "VENDORID",
"type": "text"
}
],
"id": "DBE6FD0E-4309-584A-A867-FF3697E4675C",
"mappings": [
{
"commonFieldKey": "",
"key": "VENDORID",
"label": "Vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDORID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDNAME",
"label": "Vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDNAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VNDCHKNM",
"label": "Payee / check name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VNDCHKNM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDSHNM",
"label": "Short name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDSHNM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VNDCLSID",
"label": "Vendor class",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VNDCLSID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VNDCNTCT",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VNDCNTCT",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ADDRESS1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDRESS2",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADDRESS3",
"label": "Address line 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CITY",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CITY",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "STATE",
"label": "State / region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "STATE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ZIPCODE",
"label": "Postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ZIPCODE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COUNTRY",
"label": "Country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COUNTRY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHNUMBR1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHNUMBR1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PHNUMBR2",
"label": "Phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHNUMBR2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PHONE3",
"label": "Phone 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHONE3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FAXNUMBR",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FAXNUMBR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VADDCDPR",
"label": "Primary address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VADDCDPR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VADCDPAD",
"label": "Address default code (VADCDPAD)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VADCDPAD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VADCDSFR",
"label": "Address default code (VADCDSFR)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VADCDSFR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VADCDTRO",
"label": "Remit-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VADCDTRO",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIPMTHD",
"label": "Shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHIPMTHD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TAXSCHID",
"label": "Tax schedule code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TAXSCHID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UPSZONE",
"label": "UPS zone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UPSZONE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACNMVNDR",
"label": "Our account code with vendor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ACNMVNDR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDSTTS",
"label": "Stored vendor status code (3 = temporary)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDSTTS",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HOLD",
"label": "Stored payment hold (1 = yes)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "HOLD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CURNCYID",
"label": "Default currency ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CURNCYID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "RATETPID",
"label": "Exchange-rate type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RATETPID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PYMTRMID",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PYMTRMID",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PYMNTPRI",
"label": "Payment priority code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PYMNTPRI",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DISGRPER",
"label": "Discount grace days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DISGRPER",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DUEGRPER",
"label": "Due-date grace days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DUEGRPER",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMMENT1",
"label": "Comment 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMMENT1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMMENT2",
"label": "Comment 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "COMMENT2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Vendor dossier",
"primaryKey": "VENDORID",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VENDORID",
"VENDNAME",
"VNDCHKNM",
"VENDSHNM",
"VNDCLSID",
"VNDCNTCT",
"ADDRESS1",
"ADDRESS2",
"ADDRESS3",
"CITY",
"STATE",
"ZIPCODE",
"COUNTRY",
"PHNUMBR1",
"PHNUMBR2",
"PHONE3",
"FAXNUMBR",
"VADDCDPR",
"VADCDPAD",
"VADCDSFR",
"VADCDTRO",
"SHIPMTHD",
"TAXSCHID",
"UPSZONE",
"ACNMVNDR",
"VENDSTTS",
"HOLD",
"CURNCYID",
"RATETPID",
"PYMTRMID",
"PYMNTPRI",
"DISGRPER",
"DUEGRPER",
"COMMENT1",
"COMMENT2"
],
"sourceID": "2CCD6A96-429B-5CE3-BF0E-DAFE11AB3359",
"sqlQuery": "SELECT RTRIM(m.VENDORID) AS VENDORID, m.VENDNAME, m.VNDCHKNM, m.VENDSHNM, m.VNDCLSID, m.VNDCNTCT, m.ADDRESS1, m.ADDRESS2, m.ADDRESS3, m.CITY, m.STATE, m.ZIPCODE, m.COUNTRY, m.PHNUMBR1, m.PHNUMBR2, m.PHONE3, m.FAXNUMBR, m.VADDCDPR, m.VADCDPAD, m.VADCDSFR, m.VADCDTRO, m.SHIPMTHD, m.TAXSCHID, m.UPSZONE, m.ACNMVNDR, m.VENDSTTS, m.HOLD, m.CURNCYID, m.RATETPID, m.PYMTRMID, m.PYMNTPRI, m.DISGRPER, m.DUEGRPER, m.COMMENT1, m.COMMENT2 FROM dbo.PM00200 m",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "26CBFC00-7BC5-58BE-A1BD-3389E75104D4",
"key": "ADRSCODE",
"type": "text"
}
],
"id": "B0B2EEFF-BB16-5AED-9959-BA0C1C64E6E7",
"mappings": [
{
"commonFieldKey": "",
"key": "VendorAddressKey",
"label": "Internal full vendor/address identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorAddressKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDORID",
"label": "Vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VENDORID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ADRSCODE",
"label": "Address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADRSCODE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VNDCNTCT",
"label": "Address contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VNDCNTCT",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ADDRESS1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ADDRESS2",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ADDRESS2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CITY",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CITY",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "STATE",
"label": "State / region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "STATE",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ZIPCODE",
"label": "Postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ZIPCODE",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PHNUMBR1",
"label": "Phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PHNUMBR1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FAXNUMBR",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FAXNUMBR",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Vendor addresses",
"primaryKey": "VendorAddressKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VENDORID",
"id": "313F4053-F7B9-5755-A6AF-54AF96744ABE",
"name": "vendor",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VENDORID",
"ADRSCODE",
"VNDCNTCT",
"ADDRESS1",
"ADDRESS2",
"CITY",
"STATE",
"ZIPCODE",
"PHNUMBR1",
"FAXNUMBR"
],
"sourceID": "2CCD6A96-429B-5CE3-BF0E-DAFE11AB3359",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(a.VENDORID)),N':',RTRIM(a.VENDORID),RTRIM(a.ADRSCODE)) AS VendorAddressKey, RTRIM(a.VENDORID) AS VENDORID, RTRIM(a.ADRSCODE) AS ADRSCODE, a.VNDCNTCT, a.ADDRESS1, a.ADDRESS2, a.CITY, a.STATE, a.ZIPCODE, a.PHNUMBR1, a.FAXNUMBR FROM dbo.PM00300 a WHERE a.VENDORID=:vendor",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "8EF9C331-C22B-526F-A1B3-A0ACEBB65698",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "34AAE8F0-DDDE-508E-B492-15283242269E",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "B0B2EEFF-BB16-5AED-9959-BA0C1C64E6E7",
"title": "Vendor address book",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VNDCNTCT",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PHNUMBR1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CITY",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VNDCLSID",
"label": "Vendor class",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PYMTRMID",
"label": "Terms",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CURNCYID",
"label": "Default currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HOLD",
"label": "Payment hold (1=yes)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VENDSTTS",
"label": "Status code (3=temporary)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "DBE6FD0E-4309-584A-A867-FF3697E4675C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "VENDNAME",
"label": "Vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "VENDORID",
"label": "Vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "VENDSHNM",
"label": "Short name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "VNDCHKNM",
"label": "Payee / check name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "VNDCLSID",
"label": "Vendor class",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and classification",
"detailRole": "information",
"isVisible": true,
"key": "ACNMVNDR",
"label": "Our account code with vendor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Primary contact",
"detailRole": "information",
"isVisible": true,
"key": "VNDCNTCT",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Primary contact",
"detailRole": "information",
"isVisible": true,
"key": "PHNUMBR1",
"label": "Phone 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Primary contact",
"detailRole": "information",
"isVisible": true,
"key": "PHNUMBR2",
"label": "Phone 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Primary contact",
"detailRole": "information",
"isVisible": true,
"key": "PHONE3",
"label": "Phone 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Primary contact",
"detailRole": "information",
"isVisible": true,
"key": "FAXNUMBR",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS2",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS3",
"label": "Address line 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "CITY",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "STATE",
"label": "State / region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "ZIPCODE",
"label": "Postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Master address",
"detailRole": "information",
"isVisible": true,
"key": "COUNTRY",
"label": "Country",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "VADDCDPR",
"label": "Primary address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "VADCDTRO",
"label": "Remit-to address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "VADCDPAD",
"label": "Address default code (VADCDPAD)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "VADCDSFR",
"label": "Address default code (VADCDSFR)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "SHIPMTHD",
"label": "Shipping method code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "TAXSCHID",
"label": "Tax schedule code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address and delivery defaults",
"detailRole": "information",
"isVisible": true,
"key": "UPSZONE",
"label": "UPS zone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "PYMTRMID",
"label": "Payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "PYMNTPRI",
"label": "Payment priority code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "DISGRPER",
"label": "Discount grace days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "DUEGRPER",
"label": "Due-date grace days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "CURNCYID",
"label": "Default currency ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Payment defaults",
"detailRole": "information",
"isVisible": true,
"key": "RATETPID",
"label": "Exchange-rate type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored payment hold and status",
"detailRole": "information",
"isVisible": true,
"key": "HOLD",
"label": "Stored payment hold (1 = yes)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored payment hold and status",
"detailRole": "information",
"isVisible": true,
"key": "VENDSTTS",
"label": "Stored vendor status code (3 = temporary)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Business notes",
"detailRole": "information",
"isVisible": true,
"key": "COMMENT1",
"label": "Comment 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Business notes",
"detailRole": "information",
"isVisible": true,
"key": "COMMENT2",
"label": "Comment 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "B973BBE4-AFF9-54EC-A534-5D0DE603BB7C",
"openFilters": [
{
"id": "31A54993-C83A-5166-8908-C7CB9FF877F0",
"includeAllOption": true,
"key": "VNDCLSID",
"title": "Vendor class",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "4F40E7DE-5D5B-5A48-AF93-30EC861BFC6E",
"key": "VENDNAME",
"type": "text"
},
{
"direction": "ascending",
"id": "44EA15AF-43DA-5B5D-8A52-17FD850DB6B6",
"key": "VENDORID",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "VENDORID",
"systemImage": "building.2",
"title": "Vendors",
"titleKey": "VENDNAME"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VNDCNTCT",
"label": "Address contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PHNUMBR1",
"label": "Phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CITY",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "STATE",
"label": "State / region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ZIPCODE",
"label": "Postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "B0B2EEFF-BB16-5AED-9959-BA0C1C64E6E7",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Business identity",
"detailRole": "information",
"isVisible": true,
"key": "ADRSCODE",
"label": "Address code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Business identity",
"detailRole": "information",
"isVisible": true,
"key": "VENDORID",
"label": "Vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address contact",
"detailRole": "information",
"isVisible": true,
"key": "VNDCNTCT",
"label": "Address contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address contact",
"detailRole": "information",
"isVisible": true,
"key": "PHNUMBR1",
"label": "Phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Address contact",
"detailRole": "information",
"isVisible": true,
"key": "FAXNUMBR",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Vendor address",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS1",
"label": "Address line 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Vendor address",
"detailRole": "information",
"isVisible": true,
"key": "ADDRESS2",
"label": "Address line 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Vendor address",
"detailRole": "information",
"isVisible": true,
"key": "CITY",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Vendor address",
"detailRole": "information",
"isVisible": true,
"key": "STATE",
"label": "State / region",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Vendor address",
"detailRole": "information",
"isVisible": true,
"key": "ZIPCODE",
"label": "Postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "742C0F56-7AC0-5A02-8789-A0C535504E38",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "26CBFC00-7BC5-58BE-A1BD-3389E75104D4",
"key": "ADRSCODE",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "CITY",
"systemImage": "map",
"title": "Vendor addresses",
"titleKey": "ADRSCODE"
}
],
"relations": [
{
"childDatasetID": "B0B2EEFF-BB16-5AED-9959-BA0C1C64E6E7",
"childKey": "VENDORID",
"id": "34AAE8F0-DDDE-508E-B492-15283242269E",
"name": "Vendor address book",
"parentDatasetID": "DBE6FD0E-4309-584A-A867-FF3697E4675C",
"parentKey": "VENDORID"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Microsoft Dynamics GP",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-07T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. Microsoft public GP migration code documents the selected PM00200/PM00300 source registrations, GP-shaped field names and logical staging keys at commit e7ed235bc979c0283306e9639ff7cd22ce78341d. AL staging types/keys are not SQL DDL. No real GP/SQL Server results, installed release, physical types, constraints, owner or query performance have been verified. Run the import read/compatibility test and verify your edition, schema and permissions before business use.\n\nFor purchasing, accounts payable, supplier service and managers: choose a vendor class, find a supplier and inspect a grouped 35-field dossier. See contacts, the master address, payee name, your commercial account code with that vendor, payment/delivery defaults, separate stored payment hold and vendor status, and business notes. Open the selected vendor's address book with its own contacts, phone/fax and location instead of guessing which address a code represents.\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 source, two lists, one related button and explicit read-only SQL. Reads select only 35 master fields and 10 address fields plus a hidden full row key; no SELECT *. No tax-registration or government identifiers, birth dates, bank/checkbook data, uncertain monetary limits or technical audit columns are requested. This avoids depending on the native-table reader's first-80-column projection. Each list is live and bounded to 2,000 rows, without scheduled refresh. Addresses load only on demand and are constrained by the selected vendor. Reaching a limit can mean incomplete data; filters do not guarantee a cheap server scan. SQL syntax and Cifru wrapping still require a real source test.\n\nVendor and address business codes preserve leading zeroes; only right-padding is removed from these keys. Hidden address identity contains both vendor and address code, keeping the same address code under different vendors separate. Use the company database, not DYNAMICS, Business Central or a migration staging database; dbo must be checked locally. The address subset is not the entire GP vendor module: country, third address line, email, shipping/tax extensions, orders, vouchers, balances and transactions are not claimed for PM00300.\n\nVendor hold restricts payment, not all transactions: GP can still apply vouchers and post transactions while a vendor is on hold. Hold is not inactive or customer credit hold and does not calculate effective eligibility. Stored flags use 1/true=yes and 0/false=no. Microsoft's migrator identifies VENDSTTS=3 as temporary; other numeric status values remain raw codes rather than guessed active/inactive labels. Primary and remit-to address codes are evidenced. VADCDPAD and VADCDSFR retain their native code names because their physical field-to-role mapping is not certified here. ACNMVNDR is the account code assigned to your company by the vendor, not a bank account. VNDCHKNM is the payee/check name. Payment priority, class, terms, shipping, tax schedule and rate are native codes, not invented lookup descriptions. Grace days are payment settings, not overdue days. Default currency ID need not be ISO or the company functional currency; no currency conversion or monetary aggregation is performed. Empty fields remain empty.\n\nUse a separately authorised least-privilege SQL reporting login with SELECT only on permitted company data. GP application passwords are transformed, not ordinary SQL login passwords. Do not use sa, sysadmin or DYNGRP. Cifru filters are not access control. The package embeds no host, account, password or business rows; real contacts and commercial defaults may still be confidential. Screenshots are native Cifru with wholly fictional DEMO rows and synthetic transport, not a live GP/SQL Server connection. Unofficial and not endorsed by Microsoft.\n\nPrimary source registration: https://github.com/microsoft/ALAppExtensions/blob/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/codeunits/GPCloudMigration.codeunit.al\nVendor fields: https://raw.githubusercontent.com/microsoft/ALAppExtensions/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/Migration/Vendors/GPPM00200.Table.al\nAddress fields/key: https://raw.githubusercontent.com/microsoft/ALAppExtensions/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/Migration/Vendors/GPVendorAddress.table.al\nVendor role/status evidence: https://raw.githubusercontent.com/microsoft/ALAppExtensions/e7ed235bc979c0283306e9639ff7cd22ce78341d/Apps/W1/HybridGP/app/src/Migration/Vendors/GPVendorMigrator.codeunit.al\nFunctional manual: https://learn.microsoft.com/en-us/dynamics-gp/financials/payablesmanagement\nSecurity: https://learn.microsoft.com/en-us/dynamics-gp/installation/securityplanning",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "B2DD809B-19D2-5929-8E91-CE3258B1C162",
"rootButtonCount": 1,
"summary": "Supplier contacts, payment/delivery defaults, separate payment hold/status and on-demand addresses.",
"tags": [
"Dynamics GP",
"SQL Server",
"Vendors",
"Suppliers",
"Purchasing",
"Accounts payable",
"Address book",
"Pro"
],
"title": "Vendor dossier and address book — Pro"
}
}