CRMPro → Zoho CRM — SYSPRO 7 and above: what the shipped templates set up

CRMPro → Zoho CRM — SYSPRO 7 and above: what the shipped templates set up

Keep this skill current. dlake ships updates often and this text is embedded in the CLI you have installed. Before relying on it, compare dlake --version with npm view @commercient/dlake version; if they differ, run npm install -g @commercient/dlake@latest and then dlake skills install, which overwrites the installed skill files with the current text.

dlake-crmpro is the parent skill and the authority for everything general: the crmpro_* tools, CRM_Configuration and CRM_FieldList, TimeStampRepository, the three kinds of source view, the NULL-cursor rule and the silent zero-record run. Read it first; this page does not repeat it. dlake-crmpro-zohocrm is the destination skill this page is a child of, and the authority for the Zoho CRM conventions that hold across every ERP: read it first, then come back here for what this source’s own templates set. This page is dlake-crmpro-zohocrm/erps/syspro-7-and-above.md, and that skill’s ERP table is what points at it. What follows is only what the shipped SYSPRO 7 and above → Zoho CRM templates themselves set, read from their Insert_Query, CreateViewQuery and MappingJson. This page grows as the catalogue does.

1. What the templates deliver

Group	Business outcome	Objects	Source tables and views
Accounts	The templates push Accounts to Zoho CRM. New records are created and existing ones updated; none are deleted.	Accounts	SF_ERP_Salesforce_Clone_ArCustomer
SYSPRO7 Terms	The templates push commercientsyspro7__Terms to Zoho CRM. New records are created and existing ones updated; none are deleted.	commercientsyspro7__Terms	SF_ERP_Salesforce_Clone_TblArTerms
Child Accounts	The templates push Accounts to Zoho CRM. New records are created and existing ones updated; none are deleted.	Accounts	SF_ERP_Salesforce_Clone_ArCustomer
SYSPRO7 SalesPerson	The templates push commercientsyspro7__Syspro7_Salesperson to Zoho CRM. New records are created and existing ones updated; none are deleted.	commercientsyspro7__Syspro7_Salesperson	SF_ERP_Salesforce_Clone_SalSalesperson, SP
SYSPRO7 Customer	The templates push commercientsyspro7__Syspro7_Customer to Zoho CRM. New records are created and existing ones updated; none are deleted.	commercientsyspro7__Syspro7_Customer	SF_ERP_Salesforce_Clone_ArCustomer
Contacts	The templates push Contacts to Zoho CRM. New records are created and existing ones updated; none are deleted.	Contacts	—
Products	The templates push Products to Zoho CRM. New records are created and existing ones updated; none are deleted.	Products	SF_ERP_Salesforce_Clone_InvMaster, SF_ERP_Salesforce_Clone_InvWarehouse, SF_ERP_Salesforce_Clone_SalProductClass
SYSPRO7 ARMultipleAddress	The templates push commercientsyspro7__Syspro7_ARMultipleAddress to Zoho CRM. New records are created and existing ones updated; none are deleted.	commercientsyspro7__Syspro7_ARMultipleAddress	SF_ERP_Salesforce_Clone_ArMultAddress, SF_ERP_Salesforce_Clone_ArCustomer
PriceBooks	The templates push Price_Books to Zoho CRM. New records are created and existing ones updated; none are deleted.	Price_Books	SF_ERP_Salesforce_Clone_InvPrice
Prodcut Pricebook	The templates push Products:Price_Books to Zoho CRM. New records are created and existing ones updated; none are deleted.	Products:Price_Books	SF_ERP_Salesforce_Clone_InvPrice
SYSPRO7 Inventory Master	The templates push commercientsyspro7__Syspro7_Inventory_Master to Zoho CRM. New records are created and existing ones updated; none are deleted.	commercientsyspro7__Syspro7_Inventory_Master	SF_ERP_Salesforce_Clone_InvMaster
SYSPRO7 Inventory Warehouse	The templates push commercientsyspro7__Syspro7_Inv_Warehouse to Zoho CRM. New records are created and existing ones updated; none are deleted.	commercientsyspro7__Syspro7_Inv_Warehouse	SF_ERP_Salesforce_Clone_InvWarehouse
SYSPRO7 SO Header	The templates push commercientsyspro7__Syspro7_SOHeader to Zoho CRM. New records are created and existing ones updated; none are deleted.	commercientsyspro7__Syspro7_SOHeader	SF_ERP_Salesforce_Clone_SorMaster
SYSPRO7 SO Detail	The templates push commercientsyspro7__Syspro7_SODetail to Zoho CRM. New records are created and existing ones updated; none are deleted.	commercientsyspro7__Syspro7_SODetail	SF_ERP_Salesforce_Clone_SorDetail
SYSPRO7 Invoice Header	The templates push commercientsyspro7__Syspro7_InvoiceHeader to Zoho CRM. New records are created and existing ones updated; none are deleted.	commercientsyspro7__Syspro7_InvoiceHeader	SF_ERP_Salesforce_Clone_ArInvoice, CommercientFlags
SYSPRO7 Invoice Detail	The templates push commercientsyspro7__Syspro7_InvoiceDetail to Zoho CRM. New records are created and existing ones updated; none are deleted.	commercientsyspro7__Syspro7_InvoiceDetail	SF_ERP_Salesforce_Clone_ArTrnDetail
CRM Ownership	The templates push users to Zoho CRM. New records are created and existing ones updated; none are deleted.	users	—

2. The process rows the templates create

Each template’s Insert_Query writes one CRM_Configuration row. These are the values it sets; a column the inserts never set is not listed.

Display name	CRM_Object_API_Name	CRM_PK_API_Name	Sync_Order	TimeStamp_Prefix	SQL_Query target	field prefix / postfix
Users	users	Commercient_ExternalKey	0	SalesRep:	SELECT 1	'' / ''
Accounts	Accounts	Commercient_ArCustomer_Code	1	vw_SYSPRO7_Account:	vw_SYSPRO7_Account	'' / ''
SYSPRO7 Terms	commercientsyspro7__Terms	Commercient_ExternalKey	2	vw_SYSPRO7_Terms:	vw_SYSPRO7_Terms	commercientsyspro7__ / __c
Child Accounts	Accounts	Commercient_ArCustomer_Code	3	vw_SYSPRO7_ChildAccount:	vw_SYSPRO7_ChildAccount	'' / ''
SYSPRO7 SalesPerson	commercientsyspro7__Syspro7_Salesperson	Commercient_ExternalKey	4	vw_SYSPRO7_Salesperson:	vw_SYSPRO7_Salesperson	commercientsyspro7__ / __c
SYSPRO7 Customer	commercientsyspro7__Syspro7_Customer	Commercient_ExternalKey	5	vw_SYSPRO7_Customer:	vw_SYSPRO7_Customer	commercientsyspro7__ / __c
Contacts	Contacts	Commercient_ExternalKey	6	vw_SYSPRO7_Contacts:	vw_SYSPRO7_Contact	'' / ''
Products	Products	Commercient_ExternalKey	7	vw_SYSPRO7_Product:	vw_SYSPRO7_Product	'' / ''
SYSPRO7 ARMultipleAddress	commercientsyspro7__Syspro7_ARMultipleAddress	Commercient_ExternalKey	8	vw_SYSPRO7_ARMultipleAddress:	vw_SYSPRO7_ARMultipleAddress	commercientsyspro7__ / __c
PriceBooks	Price_Books	Commercient_ExternalKey	8	vw_SYSPRO7_PriceBooks:	vw_SYSPRO7_PriceBooks	'' / ''
Prodcut Pricebook	Products:Price_Books	Commercient_ExternalKey	9	vw_SYSPRO7_ProductPriceBooks:	vw_SYSPRO7_ProductPriceBooks	'' / ''
SYSPRO7 Inventory Master	commercientsyspro7__Syspro7_Inventory_Master	Commercient_ExternalKey	9	vw_SYSPRO7_Inventory_Master:	vw_SYSPRO7_Inventory_Master	commercientsyspro7__ / __c
SYSPRO7 Inventory Warehouse	commercientsyspro7__Syspro7_Inv_Warehouse	Commercient_ExternalKey	10	vw_SYSPRO7_Inventory_Warehouse:	vw_SYSPRO7_Inventory_Warehouse	commercientsyspro7__ / __c
SYSPRO7 SO Header	commercientsyspro7__Syspro7_SOHeader	Commercient_ExternalKey	11	vw_SYSPRO7_SalesOrderHeader:	vw_SYSPRO7_SalesOrderHeader	commercientsyspro7__ / __c
SYSPRO7 SO Detail	commercientsyspro7__Syspro7_SODetail	Commercient_ExternalKey	12	vw_SYSPRO7_SalesOrderDetail:	vw_SYSPRO7_SalesOrderDetail	commercientsyspro7__ / __c
SYSPRO7 Invoice Header	commercientsyspro7__Syspro7_InvoiceHeader	Commercient_ExternalKey	13	vw_SYSPRO7_InvoiceHeader:	vw_SYSPRO7_InvoiceHeader	commercientsyspro7__ / __c
SYSPRO7 Invoice Detail	commercientsyspro7__Syspro7_InvoiceDetail	Name	14	vw_SYSPRO7_InvoiceDetail:	vw_SYSPRO7_InvoiceDetail	commercientsyspro7__ / __c

Every one of these inserts Is_Active as 0, so an imported process is inactive until an operator activates it. Across the set they insert Is_Create_Entity 0, Is_Create_Fields 0, Is_Active_Get_Records 0, Is_Active_Delete_Records 0. The insert column lists do not include Sync_Operation_Type, Sync_Batch_Size, IsAccountMatching, Document_Source_Path, so those columns take their CRM_Configuration defaults. Text columns a template does not use are inserted as '' rather than left NULL. Get_SOQL_Query carries a query on Accounts, Child Accounts, SYSPRO7 Invoice Detail — those rows read records back from Zoho CRM as well as pushing.

3. The views

Each template creates its view with CreateViewQuery, in the gateway dbo schema. “Change detection” names which of the three kinds dlake-crmpro defines the view’s own WHERE makes it; where a view’s shape is not one of those three the column is left empty and the view’s own WHERE is the authority.

View	Change detection	Repository key	Reads other prefixes	Identity column	Emits SFDCID	Source tables
vw_SYSPRO7_Account	insert + update	—	vw_SYSPRO7_Account:, SalesRep:, vw_SYSPRO7_Salesperson:	—	yes	SF_ERP_Salesforce_Clone_ArCustomer
vw_SYSPRO7_Terms	insert + update	—	vw_SYSPRO7_Terms:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_TblArTerms
vw_SYSPRO7_ChildAccount	insert + update	—	vw_SYSPRO7_Account:, SalesRep:, vw_SYSPRO7_Salesperson:, vw_SYSPRO7_ChildAccount:	—	yes	SF_ERP_Salesforce_Clone_ArCustomer
vw_SYSPRO7_Salesperson	insert + update	—	vw_SYSPRO7_Salesperson:	—	no	SF_ERP_Salesforce_Clone_SalSalesperson, SP
vw_SYSPRO7_Customer	insert-only	—	vw_SYSPRO7_Terms:, vw_SYSPRO7_Account:, vw_SYSPRO7_Salesperson:, vw_SYSPRO7_ChildAccount:, vw_SYSPRO7_Customer:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_ArCustomer
vw_SYSPRO7_Product	insert + update	—	vw_SYSPRO7_Product:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_InvMaster, SF_ERP_Salesforce_Clone_InvWarehouse, SF_ERP_Salesforce_Clone_SalProductClass
vw_SYSPRO7_ARMultipleAddress	insert + update	—	vw_SYSPRO7_Account:, vw_SYSPRO7_ChildAccount:, vw_SYSPRO7_Customer:, vw_SYSPRO7_User:, vw_SYSPRO7_ARMultipleAddress:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_ArMultAddress, SF_ERP_Salesforce_Clone_ArCustomer
vw_SYSPRO7_PriceBooks	insert-only	—	vw_SYSPRO7_PriceBooks:	Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_InvPrice
vw_SYSPRO7_ProductPriceBooks	insert + update	—	vw_SYSPRO7_Product:, vw_SYSPRO7_PriceBooks:, vw_SYSPRO7_ProductPriceBooks:	Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_InvPrice
vw_SYSPRO7_Inventory_Master	insert + update	—	vw_SYSPRO7_Product:, vw_SYSPRO7_Inventory_Master:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_InvMaster
vw_SYSPRO7_Inventory_Warehouse	insert + update	—	vw_SYSPRO7_Product:, vw_SYSPRO7_Inventory_Master:, vw_SYSPRO7_Inventory_Warehouse:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_InvWarehouse
vw_SYSPRO7_SalesOrderHeader	insert + update	—	vw_SYSPRO7_ChildAccount:, vw_SYSPRO7_Account:, vw_SYSPRO7_Salesperson:, vw_SYSPRO7_Customer:, vw_SYSPRO7_SalesOrderHeader:	—	no	SF_ERP_Salesforce_Clone_SorMaster
vw_SYSPRO7_SalesOrderDetail	insert + update	—	vw_SYSPRO7_SalesOrderHeader:, vw_SYSPRO7_Product:, vw_SYSPRO7_SalesOrderDetail:	—	no	SF_ERP_Salesforce_Clone_SorDetail
vw_SYSPRO7_InvoiceHeader	insert + update	—	vw_SYSPRO7_ChildAccount:, vw_SYSPRO7_Account:, vw_SYSPRO7_Customer:, vw_SYSPRO7_SalesOrderHeader:, vw_SYSPRO7_Salesperson:, vw_SYSPRO7_InvoiceHeader:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_ArInvoice, CommercientFlags
vw_SYSPRO7_InvoiceDetail	insert + update	—	vw_SYSPRO7_InvoiceHeader:, vw_SYSPRO7_Product:, vw_SYSPRO7_InvoiceDetail:	Name	no	SF_ERP_Salesforce_Clone_ArTrnDetail

4. Order of work

The templates set Sync_Order from 0 to 14. A run processes active rows in ascending Sync_Order, which is the order the templates put them in:

• 0 — Users
• 1 — Accounts
• 2 — SYSPRO7 Terms
• 3 — Child Accounts
• 4 — SYSPRO7 SalesPerson
• 5 — SYSPRO7 Customer
• 6 — Contacts
• 7 — Products
• 8 — SYSPRO7 ARMultipleAddress, PriceBooks
• 9 — Prodcut Pricebook, SYSPRO7 Inventory Master
• 10 — SYSPRO7 Inventory Warehouse
• 11 — SYSPRO7 SO Header
• 12 — SYSPRO7 SO Detail
• 13 — SYSPRO7 Invoice Header
• 14 — SYSPRO7 Invoice Detail

Several of these rows share a Sync_Order value: each template group carries its own numbering, so give the imported processes an order across the whole set rather than taking the template values as one.

These views read another process’s repository prefix, which is what makes the order a dependency order: the row appears in the view only once the process that writes that prefix has run, so a parent flows on one run and its children on the next.

• vw_SYSPRO7_Account reads vw_SYSPRO7_Account:, SalesRep:, vw_SYSPRO7_Salesperson:; no template in this set writes vw_SYSPRO7_Account:, SalesRep:, vw_SYSPRO7_Salesperson:
• vw_SYSPRO7_Terms reads vw_SYSPRO7_Terms:; no template in this set writes vw_SYSPRO7_Terms:
• vw_SYSPRO7_ChildAccount reads vw_SYSPRO7_Account:, SalesRep:, vw_SYSPRO7_Salesperson:, vw_SYSPRO7_ChildAccount:; no template in this set writes vw_SYSPRO7_Account:, SalesRep:, vw_SYSPRO7_Salesperson:, vw_SYSPRO7_ChildAccount:
• vw_SYSPRO7_Salesperson reads vw_SYSPRO7_Salesperson:; no template in this set writes vw_SYSPRO7_Salesperson:
• vw_SYSPRO7_Customer reads vw_SYSPRO7_Terms:, vw_SYSPRO7_Account:, vw_SYSPRO7_Salesperson:, vw_SYSPRO7_ChildAccount:, vw_SYSPRO7_Customer:; no template in this set writes vw_SYSPRO7_Terms:, vw_SYSPRO7_Account:, vw_SYSPRO7_Salesperson:, vw_SYSPRO7_ChildAccount:
• vw_SYSPRO7_Product reads vw_SYSPRO7_Product:; no template in this set writes vw_SYSPRO7_Product:
• vw_SYSPRO7_ARMultipleAddress reads vw_SYSPRO7_Account:, vw_SYSPRO7_ChildAccount:, vw_SYSPRO7_Customer:, vw_SYSPRO7_User:, vw_SYSPRO7_ARMultipleAddress:; no template in this set writes vw_SYSPRO7_Account:, vw_SYSPRO7_ChildAccount:, vw_SYSPRO7_Customer:, vw_SYSPRO7_User:
• vw_SYSPRO7_PriceBooks reads vw_SYSPRO7_PriceBooks:; no template in this set writes vw_SYSPRO7_PriceBooks:
• vw_SYSPRO7_ProductPriceBooks reads vw_SYSPRO7_Product:, vw_SYSPRO7_PriceBooks:, vw_SYSPRO7_ProductPriceBooks:; no template in this set writes vw_SYSPRO7_Product:, vw_SYSPRO7_PriceBooks:, vw_SYSPRO7_ProductPriceBooks:
• vw_SYSPRO7_Inventory_Master reads vw_SYSPRO7_Product:, vw_SYSPRO7_Inventory_Master:; no template in this set writes vw_SYSPRO7_Product:, vw_SYSPRO7_Inventory_Master:
• vw_SYSPRO7_Inventory_Warehouse reads vw_SYSPRO7_Product:, vw_SYSPRO7_Inventory_Master:, vw_SYSPRO7_Inventory_Warehouse:; no template in this set writes vw_SYSPRO7_Product:, vw_SYSPRO7_Inventory_Master:, vw_SYSPRO7_Inventory_Warehouse:
• vw_SYSPRO7_SalesOrderHeader reads vw_SYSPRO7_ChildAccount:, vw_SYSPRO7_Account:, vw_SYSPRO7_Salesperson:, vw_SYSPRO7_Customer:, vw_SYSPRO7_SalesOrderHeader:; no template in this set writes vw_SYSPRO7_ChildAccount:, vw_SYSPRO7_Account:, vw_SYSPRO7_Salesperson:, vw_SYSPRO7_Customer:
• vw_SYSPRO7_SalesOrderDetail reads vw_SYSPRO7_SalesOrderHeader:, vw_SYSPRO7_Product:, vw_SYSPRO7_SalesOrderDetail:; no template in this set writes vw_SYSPRO7_SalesOrderHeader:, vw_SYSPRO7_Product:, vw_SYSPRO7_SalesOrderDetail:
• vw_SYSPRO7_InvoiceHeader reads vw_SYSPRO7_ChildAccount:, vw_SYSPRO7_Account:, vw_SYSPRO7_Customer:, vw_SYSPRO7_SalesOrderHeader:, vw_SYSPRO7_Salesperson:, vw_SYSPRO7_InvoiceHeader:; no template in this set writes vw_SYSPRO7_ChildAccount:, vw_SYSPRO7_Account:, vw_SYSPRO7_Customer:, vw_SYSPRO7_SalesOrderHeader:
• vw_SYSPRO7_InvoiceDetail reads vw_SYSPRO7_InvoiceHeader:, vw_SYSPRO7_Product:, vw_SYSPRO7_InvoiceDetail:; no template in this set writes vw_SYSPRO7_InvoiceHeader:, vw_SYSPRO7_Product:, vw_SYSPRO7_InvoiceDetail:

5. Field mapping

CRM_FieldList carries one row per pushed column, with Object_Name equal to the CRM_Object_API_Name value — as dlake-crmpro puts it, an object with no CRM_FieldList rows pushes nothing and records no error. Each template carries its intended mapping in MappingJson. Read that with dlake admin crmpro_templates, then check crmpro_field_mapping on the created process before activating it.

Template	Object	Mapped fields	First ERP → Zoho CRM pairs
Accounts	Accounts	23	Customer → Commercient_ArCustomer_Code, Salesperson → Syspro7_SalesPerson, Name → Account_Name, ShortName → Account_Short_Name, SpecialInstrs → Description
SYSPRO7 Terms	commercientsyspro7__Terms	16	TermsCode → Commercient_ExternalKey__c, TermsCode → Name, AgeingCode → Ageing_Code, Description → Description, DiscDate → Disc_Date
Child Accounts	Accounts	26	Customer → Commercient_ArCustomer_Code, Name → Account_Name, ShortName → Account_Short_Name, SpecialInstrs → Description, Branch → Branch
SYSPRO7 SalesPerson	commercientsyspro7__Syspro7_Salesperson	32	Salesperson → Commercient_ExternalKey__c, Branch → Branch, CommissionPct → Commission_Pct, Name → Name, SalesActual1 → Sales_Actual1
SYSPRO7 Customer	commercientsyspro7__Syspro7_Customer	141	Customer → Commercient_ExternalKey__c, AddTelephone → Add_Telephone, AltMethodFlag → Alt_Method_Flag, ApplyLineDisc → Apply_Line_Disc, ApplyOrdDisc → Apply_Ord_Disc
Contacts	Contacts	5	CustomerID → Commercient_ExternalKey, FirstName → FirstName, LastName → LastName, Email → Email, Phone → Phone
Products	Products	13	Description → Product_Name, StockCode → Product_Code, StockCode → Commercient_ExternalKey__c, LongDesc → Description, TimeStamp → TimeStamp
SYSPRO7 ARMultipleAddress	commercientsyspro7__Syspro7_ARMultipleAddress	27	Customer,AddrCode → Commercient_ExternalKey__c, Customer,AddrCode → Name, AddrCode → Addr_Code, Area → Area, City → City
PriceBooks	Price_Books	2	PriceCode → Price_Book_Name, PriceCode → Commercient_ExternalKey
Prodcut Pricebook	Products:Price_Books	5	SFDCID → ZOHO_PriceBookID, SFDCID → PRODUCT_ID, StockCode,PriceCode → Commercient_ExternalKey, SellingPrice → list_price, TimeStamp → TimeStamp
SYSPRO7 Inventory Master	commercientsyspro7__Syspro7_Inventory_Master	134	Description → Name, StockCode → Commercient_ExternalKey__c, TimeStamp → TimeStamp, AbcAnalysisReq → Abc_Analysis_Req, AbcClass → Abc_Class
SYSPRO7 Inventory Warehouse	commercientsyspro7__Syspro7_Inv_Warehouse	126	StockCode,Warehouse → Commercient_ExternalKey__c, StockCode,Warehouse → Name, AbcClass → Abc_Class, AgedQty1 → Aged_Qty1, AgedQty2 → Aged_Qty2
SYSPRO7 SO Header	commercientsyspro7__Syspro7_SOHeader	121	SalesOrder → Commercient_ExternalKey__c, SalesOrder → Name, ActiveFlag → Active_Flag__c, AltShipAddrFlag → Alt_Ship_Addr_Flag__c, AlternateKey → Alternate_Key__c
SYSPRO7 SO Detail	commercientsyspro7__Syspro7_SODetail	135	SalesOrder,SalesOrderLine → Commercient_ExternalKey__c, SalesOrder,SalesOrderLine → Name, CreditReason → Credit_Reason, FixedQtyPer → Fixed_Qty_Per, FixedQtyPerFlag → Fixed_Qty_Per_Flag
SYSPRO7 Invoice Header	commercientsyspro7__Syspro7_InvoiceHeader	50	Customer,Invoice,DocumentType → Commercient_ExternalKey__c, Customer,Invoice,DocumentType → Name, AccConvRate → Acc_Conv_Rate__c, AccMulDiv → Acc_Mul_Div__c, AccountCur → Account_Cur__c
SYSPRO7 Invoice Detail	commercientsyspro7__Syspro7_InvoiceDetail	84	AbcUpd → Abc_Upd, AccountConvRate → Account_Conv_Rate, AccountCur → Account_Currency, AccountMulDiv → Account_Mul_Div, Area → Area

6. Verifying

# per-prefix counts; every synced record carries its destination id
dlake tool query --profile <tenant> --sql "SELECT LEFT([Key], CHARINDEX(':',[Key])-1) AS prefix, COUNT(*) n, COUNT(NULLIF(SFDCID,'')) withId FROM dbo.TimeStampRepository WHERE CHARINDEX(':',[Key])>0 GROUP BY LEFT([Key], CHARINDEX(':',[Key])-1)"

withId = n for every prefix is the success condition dlake-crmpro defines. The split is on the first colon, which is the prefix boundary whether the key separator is : or ::.

The prefixes these templates set:

• vw_SYSPRO7_Account:
• vw_SYSPRO7_Terms:
• vw_SYSPRO7_ChildAccount:
• vw_SYSPRO7_Salesperson:
• vw_SYSPRO7_Customer:
• vw_SYSPRO7_Contacts:
• vw_SYSPRO7_Product:
• vw_SYSPRO7_ARMultipleAddress:
• vw_SYSPRO7_PriceBooks:
• vw_SYSPRO7_ProductPriceBooks:
• vw_SYSPRO7_Inventory_Master:
• vw_SYSPRO7_Inventory_Warehouse:
• vw_SYSPRO7_SalesOrderHeader:
• vw_SYSPRO7_SalesOrderDetail:
• vw_SYSPRO7_InvoiceHeader:
• vw_SYSPRO7_InvoiceDetail:
• SalesRep:

7. Where this sits

dlake-crmpro is the general operating surface — the crmpro_* tools, the setup and transaction tables, field mapping, and the source-view contract that applies to every destination. This page adds what the shipped SYSPRO 7 and above → Zoho CRM templates set up. dlake-crmpro-zohocrm is the destination skill this page sits under: its own text is the authority for the Zoho CRM conventions that hold across every ERP, and its ERP table lists this page alongside every sibling ERP page for this destination. For the extract leg that fills the clone tables, see dlake-normalsync; for the on-premises agent that runs it, dlake-syncagent; for the writeback leg, dlake-txdownloaderpro; for standing an integration up, dlake-integration-setup.