CRMPro → Zoho CRM — Sage 50 UK: what the shipped templates set up

CRMPro → Zoho CRM — Sage 50 UK: 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/sage-50-uk.md, and that skill’s ERP table is what points at it. What follows is only what the shipped Sage 50 UK → 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_SALES_LEDGER, SF_ERP_Salesforce_Clone_SALES_DEL_ADDR
SAGE50UK Customer	The templates push sage50uk__SAGE50UK_Customer to Zoho CRM. New records are created and existing ones updated; none are deleted.	sage50uk__SAGE50UK_Customer	SF_ERP_Salesforce_Clone_SALES_LEDGER
Sage50 UK Address	The templates push sage50uk__SAGE50UK_Address to Zoho CRM. New records are created and existing ones updated; none are deleted.	sage50uk__SAGE50UK_Address	SF_ERP_Salesforce_Clone_SALES_DEL_ADDR, SF_ERP_Salesforce_Clone_SALES_LEDGER
Contacts	The templates push Contacts to Zoho CRM. New records are created and existing ones updated; none are deleted.	Contacts	SF_ERP_Salesforce_Clone_SALES_DEL_ADDR, SF_ERP_Salesforce_Clone_SALES_LEDGER, SF_ERP_Salesforce_Clone_PURCHASE_DEL_ADDR, SF_ERP_Salesforce_Clone_PURCHASE_LEDGER
Products	The templates push Products to Zoho CRM. New records are created and existing ones updated; none are deleted.	Products	SF_ERP_Salesforce_Clone_STOCK
Item Master	The templates push sage50uk__SAGE50UK_ITEM to Zoho CRM. New records are created and existing ones updated; none are deleted.	sage50uk__SAGE50UK_ITEM	SF_ERP_Salesforce_Clone_STOCK
Sales Order Header	The templates push sage50uk__SAGE50UKSalesOrder_Header to Zoho CRM. New records are created and existing ones updated; none are deleted.	sage50uk__SAGE50UKSalesOrder_Header	SF_ERP_Salesforce_Clone_SALES_ORDER, SF_ERP_Salesforce_Clone_SALES_LEDGER, SF_ERP_Salesforce_Clone_CURRENCY
Sales Order Details	The templates push sage50uk__SAGE50UKSalesOrder_Detail to Zoho CRM. New records are created and existing ones updated; none are deleted.	sage50uk__SAGE50UKSalesOrder_Detail	SF_ERP_Salesforce_Clone_SOP_ITEM
Invoice Header	The templates push sage50uk__SAGE50UK_Invoice_Header to Zoho CRM. New records are created and existing ones updated; none are deleted.	sage50uk__SAGE50UK_Invoice_Header	SF_ERP_Salesforce_Clone_INVOICE, SF_ERP_Salesforce_Clone_SALES_LEDGER, SF_ERP_Salesforce_Clone_CURRENCY
Invoice Details	The templates push sage50uk__SAGE50UK_Invoice_Detail to Zoho CRM. New records are created and existing ones updated; none are deleted.	sage50uk__SAGE50UK_Invoice_Detail	SF_ERP_Salesforce_Clone_INVOICE_ITEM, SF_ERP_Salesforce_Clone_INVOICE
Suppliers	The templates push Vendors to Zoho CRM. New records are created and existing ones updated; none are deleted.	Vendors	SF_ERP_Salesforce_Clone_PURCHASE_LEDGER
SAGE50UK Purchase Order	The templates push sage50uk__SAGE50UK_Pur_Order_Header to Zoho CRM. New records are created and existing ones updated; none are deleted.	sage50uk__SAGE50UK_Pur_Order_Header	SF_ERP_Salesforce_Clone_PURCHASE_ORDER, SF_ERP_Salesforce_Clone_SALES_LEDGER
SAGE50UK PurchaseOrderLine	The templates push sage50uk__SAGE50UK_Pur_Order_Detail to Zoho CRM. New records are created and existing ones updated; none are deleted.	sage50uk__SAGE50UK_Pur_Order_Detail	SF_ERP_Salesforce_Clone_POP_ITEM
Sales Orders	The templates push Sales_Orders to Zoho CRM. New records are created and existing ones updated; none are deleted.	Sales_Orders	SF_ERP_Salesforce_Clone_SOP_ITEM, SF_ERP_Salesforce_Clone_SALES_ORDER, SF_ERP_Salesforce_Clone_STOCK, SF_ERP_Salesforce_Clone_SALES_LEDGER, SF_ERP_Salesforce_Clone_SALES_DEL_ADDR, x
Invoices	The templates push Invoices to Zoho CRM. New records are created and existing ones updated; none are deleted.	Invoices	SF_ERP_Salesforce_Clone_INVOICE_ITEM, SF_ERP_Salesforce_Clone_STOCK, SF_ERP_Salesforce_Clone_INVOICE, SF_ERP_Salesforce_Clone_SALES_ORDER, SF_ERP_Salesforce_Clone_SALES_LEDGER, SF_ERP_Salesforce_Clone_SALES_DEL_ADDR
Purchase Order	The templates push Purchase_Orders to Zoho CRM. New records are created and existing ones updated; none are deleted.	Purchase_Orders	SF_ERP_Salesforce_Clone_POP_ITEM, SF_ERP_Salesforce_Clone_PURCHASE_ORDER, SF_ERP_Salesforce_Clone_STOCK, SF_ERP_Salesforce_Clone_SALES_DEL_ADDR, x
Products Update	The templates push Products to Zoho CRM. New records are created and existing ones updated; none are deleted.	Products	SF_ERP_Salesforce_Clone_STOCK
CRM Ownership	The templates push users to Zoho CRM. New records are created and existing ones updated; none are deleted.	users	—
Vendor	The templates push sage50uk__SAGE50UK_Vendor to Zoho CRM. New records are created and existing ones updated; none are deleted.	sage50uk__SAGE50UK_Vendor	SF_ERP_Salesforce_Clone_PURCHASE_LEDGER

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	vwAccount:	vw_SAGE50UK_Account	'' / ''
SAGE50UK Customer	sage50uk__SAGE50UK_Customer	Commercient_ExternalKey	2	vwCustomer:	vw_SAGE50UK_Customer	sage50uk__ / __c
Sage50 UK Address	sage50uk__SAGE50UK_Address	Commercient_ExternalKey	3	vwAddress:	vw_SAGE50UK_Address	sage50uk__ / __c
Contacts	Contacts	Commercient_ExternalKey	4	vw_SAGE50UK_Contact:	vw_SAGE50UK_Contact	'' / ''
Products	Products	Commercient_ExternalKey	5	vw_SAGE50UK_Product:	vw_SAGE50UK_Product_Insert	'' / ''
Item Master	sage50uk__SAGE50UK_ITEM	Commercient_ExternalKey	6	vwItem:	vw_SAGE50UK_Item	sage50uk__ / __c
Sales Order Header	sage50uk__SAGE50UKSalesOrder_Header	Commercient_ExternalKey	7	vwSalesOrderHeader:	vw_SAGE50UK_SalesOrderHeader	sage50uk__ / __c
Sales Order Details	sage50uk__SAGE50UKSalesOrder_Detail	Commercient_ExternalKey	8	vwSalesOrderDetail:	vw_SAGE50UK_SalesOrderDetail	sage50uk__ / __c
Invoice Header	sage50uk__SAGE50UK_Invoice_Header	Commercient_ExternalKey	9	vw_InvoiceHeader:	vw_SAGE50UK_InvoiceHeader	sage50uk__ / __c
Invoice Details	sage50uk__SAGE50UK_Invoice_Detail	Commercient_ExternalKey	10	vw_InvoiceDetail:	vw_SAGE50UK_InvoiceDetail	sage50uk__ / __c
Suppliers	Vendors	Commercient_ExternalKey	11	vw_SAGE50UK_Suppliers:	vw_SAGE50UK_Suppliers	'' / ''
SAGE50UK Vendor	sage50uk__SAGE50UK_Vendor	Commercient_ExternalKey	11	vw_SAGE50UK_Vendor:	vw_SAGE50UK_Vendor	sage50uk__ / __c
SAGE50UK Purchase Order	sage50uk__SAGE50UK_Pur_Order_Header	Commercient_ExternalKey	12	vw_SAGE50UK_PurchaseOrder:	vw_SAGE50UK_PurchaseOrder	sage50uk__ / __c
SAGE50UK PurchaseOrderLine	sage50uk__SAGE50UK_Pur_Order_Detail	Commercient_ExternalKey	13	vw_SAGE50UK_PurchaseOrderLine:	vw_SAGE50UK_PurchaseOrderLine	sage50uk__ / __c
Sales Orders	Sales_Orders	Commercient_ExternalKey	14	vw_SAGE50UK_DSalesOrder:	vw_SAGE50UK_DSalesOrder	'' / ''
Invoices	Invoices	Commercient_ExternalKey	15	vw_SAGE50UK_DInvoice:	vw_SAGE50UK_DInvoice	'' / ''
Purchase Order	Purchase_Orders	Commercient_ExternalKey	16	vw_SAGE50UK_DPurchaseOrder:	vw_SAGE50UK_DPurchaseOrder	'' / ''
Products Update	Products	Commercient_ExternalKey	17	vw_SAGE50UK_Product:	vw_SAGE50UK_Product_Update	'' / ''

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 — those rows read records back from Zoho CRM as well as pushing. On Products, Products Update the SQL_Query names a view the same template’s CreateViewQuery does not create (vw_SAGE50UK_Product_Insert against vw_SAGE50UK_Product; vw_SAGE50UK_Product_Update against vw_SAGE50UK_Product), so check the view exists under the name the row selects from before activating it.

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_SAGE50UK_Account	insert-only	—	SalesRep:, vwAccount:	Commercient_ExternalKey, Commercient_ArCustomer_Code	no	SF_ERP_Salesforce_Clone_SALES_LEDGER, SF_ERP_Salesforce_Clone_SALES_DEL_ADDR
vw_SAGE50UK_Customer	insert-only	—	vwAccount:, vwCustomer:	ExternalKey, Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_SALES_LEDGER
vw_SAGE50UK_Address	insert-only	—	vwAccount:, vwCustomer:, vwAddress:	Commercient_ExternalKey__c, ExternalKey, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_SALES_DEL_ADDR, SF_ERP_Salesforce_Clone_SALES_LEDGER
vw_SAGE50UK_Contact	insert-only	—	SalesRep:, vwAccount:, vw_SAGE50UK_Contact:, vw_SAGE50UK_Suppliers:, Pur:	Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_SALES_DEL_ADDR, SF_ERP_Salesforce_Clone_SALES_LEDGER, SF_ERP_Salesforce_Clone_PURCHASE_DEL_ADDR, SF_ERP_Salesforce_Clone_PURCHASE_LEDGER
vw_SAGE50UK_Product	insert-only	—	vw_SAGE50UK_Product:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_STOCK
vw_SAGE50UK_Item	insert-only	—	vw_SAGE50UK_Product:, vwItem:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_STOCK
vw_SAGE50UK_SalesOrderHeader	insert-only	—	vwAccount:, vwCustomer:, vwSalesOrderHeader:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_SALES_ORDER, SF_ERP_Salesforce_Clone_SALES_LEDGER, SF_ERP_Salesforce_Clone_CURRENCY
vw_SAGE50UK_SalesOrderDetail	insert-only	—	vwSalesOrderHeader:, vwItem:, vwSalesOrderDetail:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_SOP_ITEM
vw_SAGE50UK_InvoiceHeader	insert-only	—	vwAccount:, vwCustomer:, vw_InvoiceHeader:	ExternalKey, Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_INVOICE, SF_ERP_Salesforce_Clone_SALES_LEDGER, SF_ERP_Salesforce_Clone_CURRENCY
vw_SAGE50UK_InvoiceDetail	insert-only	—	vw_InvoiceHeader:, vwItem:, vw_InvoiceDetail:	ExternalKey, Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_INVOICE_ITEM, SF_ERP_Salesforce_Clone_INVOICE
vw_SAGE50UK_Suppliers	insert-only	—	SalesRep:, vw_SAGE50UK_Suppliers:	Commercient_ExternalKey__c, Commercient_ExternalKey	yes	SF_ERP_Salesforce_Clone_PURCHASE_LEDGER
vw_SAGE50UK_Vendor	insert-only	—	vw_SAGE50UK_Vendor:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_PURCHASE_LEDGER
vw_SAGE50UK_PurchaseOrder	insert-only	—	vw_SAGE50UK_Suppliers:, vw_SAGE50UK_Vendor:, vw_SAGE50UK_PurchaseOrder:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_PURCHASE_ORDER, SF_ERP_Salesforce_Clone_SALES_LEDGER
vw_SAGE50UK_PurchaseOrderLine	insert-only	—	vw_SAGE50UK_PurchaseOrder:, vw_SAGE50UK_Product:, vw_SAGE50UK_PurchaseOrderLine:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_POP_ITEM
vw_SAGE50UK_DSalesOrder	insert-only	—	vw_SAGE50UK_Product:, vwAccount:, vw_SAGE50UK_Contact:, vw_SAGE50UK_DSalesOrder:	ExternalKey, Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_SOP_ITEM, SF_ERP_Salesforce_Clone_SALES_ORDER, SF_ERP_Salesforce_Clone_STOCK, SF_ERP_Salesforce_Clone_SALES_LEDGER, SF_ERP_Salesforce_Clone_SALES_DEL_ADDR
vw_SAGE50UK_DInvoice	insert-only	—	vw_SAGE50UK_Product:, vwAccount:, vw_SAGE50UK_DSalesOrder:, vw_SAGE50UK_Contact:, vw_SAGE50UK_DInvoice:	ExternalKey, Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_INVOICE_ITEM, SF_ERP_Salesforce_Clone_STOCK, SF_ERP_Salesforce_Clone_INVOICE, SF_ERP_Salesforce_Clone_SALES_ORDER, SF_ERP_Salesforce_Clone_SALES_LEDGER
vw_SAGE50UK_DPurchaseOrder	insert-only	—	vw_SAGE50UK_Product:, vwAccount:, vw_SAGE50UK_Contact:, vw_SAGE50UK_Suppliers:, vw_SAGE50UK_DPurchaseOrder:, Pur:	ExternalKey, Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_POP_ITEM, SF_ERP_Salesforce_Clone_PURCHASE_ORDER, SF_ERP_Salesforce_Clone_STOCK, SF_ERP_Salesforce_Clone_SALES_DEL_ADDR, x
vw_SAGE50UK_Product	insert-only	—	vw_SAGE50UK_Product:	Commercient_ExternalKey__c, Commercient_ExternalKey	no	SF_ERP_Salesforce_Clone_STOCK

4. Order of work

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

• 0 — Users
• 1 — Accounts
• 2 — SAGE50UK Customer
• 3 — Sage50 UK Address
• 4 — Contacts
• 5 — Products
• 6 — Item Master
• 7 — Sales Order Header
• 8 — Sales Order Details
• 9 — Invoice Header
• 10 — Invoice Details
• 11 — Suppliers, SAGE50UK Vendor
• 12 — SAGE50UK Purchase Order
• 13 — SAGE50UK PurchaseOrderLine
• 14 — Sales Orders
• 15 — Invoices
• 16 — Purchase Order
• 17 — Products Update

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_SAGE50UK_Account reads SalesRep:, vwAccount:; no template in this set writes SalesRep:, vwAccount:
• vw_SAGE50UK_Customer reads vwAccount:, vwCustomer:; no template in this set writes vwAccount:, vwCustomer:
• vw_SAGE50UK_Address reads vwAccount:, vwCustomer:, vwAddress:; no template in this set writes vwAccount:, vwCustomer:, vwAddress:
• vw_SAGE50UK_Contact reads SalesRep:, vwAccount:, vw_SAGE50UK_Contact:, vw_SAGE50UK_Suppliers:, Pur:; no template in this set writes SalesRep:, vwAccount:, vw_SAGE50UK_Contact:, vw_SAGE50UK_Suppliers:
• vw_SAGE50UK_Product reads vw_SAGE50UK_Product:; no template in this set writes vw_SAGE50UK_Product:
• vw_SAGE50UK_Item reads vw_SAGE50UK_Product:, vwItem:; no template in this set writes vw_SAGE50UK_Product:, vwItem:
• vw_SAGE50UK_SalesOrderHeader reads vwAccount:, vwCustomer:, vwSalesOrderHeader:; no template in this set writes vwAccount:, vwCustomer:, vwSalesOrderHeader:
• vw_SAGE50UK_SalesOrderDetail reads vwSalesOrderHeader:, vwItem:, vwSalesOrderDetail:; no template in this set writes vwSalesOrderHeader:, vwItem:, vwSalesOrderDetail:
• vw_SAGE50UK_InvoiceHeader reads vwAccount:, vwCustomer:, vw_InvoiceHeader:; no template in this set writes vwAccount:, vwCustomer:, vw_InvoiceHeader:
• vw_SAGE50UK_InvoiceDetail reads vw_InvoiceHeader:, vwItem:, vw_InvoiceDetail:; no template in this set writes vw_InvoiceHeader:, vwItem:, vw_InvoiceDetail:
• vw_SAGE50UK_Suppliers reads SalesRep:, vw_SAGE50UK_Suppliers:; no template in this set writes SalesRep:, vw_SAGE50UK_Suppliers:
• vw_SAGE50UK_PurchaseOrder reads vw_SAGE50UK_Suppliers:, vw_SAGE50UK_Vendor:, vw_SAGE50UK_PurchaseOrder:; no template in this set writes vw_SAGE50UK_Suppliers:, vw_SAGE50UK_Vendor:, vw_SAGE50UK_PurchaseOrder:
• vw_SAGE50UK_PurchaseOrderLine reads vw_SAGE50UK_PurchaseOrder:, vw_SAGE50UK_Product:, vw_SAGE50UK_PurchaseOrderLine:; no template in this set writes vw_SAGE50UK_PurchaseOrder:, vw_SAGE50UK_Product:, vw_SAGE50UK_PurchaseOrderLine:
• vw_SAGE50UK_DSalesOrder reads vw_SAGE50UK_Product:, vwAccount:, vw_SAGE50UK_Contact:, vw_SAGE50UK_DSalesOrder:; no template in this set writes vw_SAGE50UK_Product:, vwAccount:, vw_SAGE50UK_Contact:, vw_SAGE50UK_DSalesOrder:
• vw_SAGE50UK_DInvoice reads vw_SAGE50UK_Product:, vwAccount:, vw_SAGE50UK_DSalesOrder:, vw_SAGE50UK_Contact:, vw_SAGE50UK_DInvoice:; no template in this set writes vw_SAGE50UK_Product:, vwAccount:, vw_SAGE50UK_DSalesOrder:, vw_SAGE50UK_Contact:
• vw_SAGE50UK_DPurchaseOrder reads vw_SAGE50UK_Product:, vwAccount:, vw_SAGE50UK_Contact:, vw_SAGE50UK_Suppliers:, vw_SAGE50UK_DPurchaseOrder:, Pur:; no template in this set writes vw_SAGE50UK_Product:, vwAccount:, vw_SAGE50UK_Contact:, vw_SAGE50UK_Suppliers:
• vw_SAGE50UK_Product reads vw_SAGE50UK_Product:; no template in this set writes vw_SAGE50UK_Product:
• vw_SAGE50UK_Vendor reads vw_SAGE50UK_Vendor:; no template in this set writes vw_SAGE50UK_Vendor:

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	31	ACCOUNT_REF → Commercient_ArCustomer_Code, ACCOUNT_REF → Commercient_ExternalKey, ACCOUNT_REF → Sage_Account_Reference, CREDIT_POSITION → Credit_Position, STATUS → Account_Status
SAGE50UK Customer	sage50uk__SAGE50UK_Customer	114	ACCOUNT_REF → Commercient_ExternalKey__c, NAME → Name, ADDRESS_1 → Address_1, ADDRESS_2 → Address_2, ADDRESS_3 → Address_3
Sage50 UK Address	sage50uk__SAGE50UK_Address	29	REFERENCE → Commercient_ExternalKey__c, REFERENCE → ExternalKey, TAX_CODE → Tax_Code, ADDRESS_TYPE → Address_Type, RECORD_DELETED → Record_Deleted
Contacts	Contacts	16	REFERENCE → Commercient_ExternalKey, ACCOUNT_REF → Account_Name, CONTACT_NAME → Last_Name, CONTACT_NAME → First_Name, E_MAIL → Email
Products	Products	18	DESCRIPTION → Product_Name, STOCK_CODE → Product_Code, STOCK_CODE → Commercient_ExternalKey__c, DESCRIPTION → Description, INACTIVE_FLAG → Product_Active
Item Master	sage50uk__SAGE50UK_ITEM	114	DESCRIPTION → Name, STOCK_CODE → Commercient_ExternalKey__c, WEB_PUBLISH → Web_Publish, WEB_SPECIAL → Web_Special, DEPT_NUMBER → Department_Number
Sales Order Header	sage50uk__SAGE50UKSalesOrder_Header	95	ORDER_NUMBER → Commercient_ExternalKey__c, DESPATCH_STATUS_CODE → Dispatch_Status_Code, ORDER_TYPE_CODE → Order_Type_Code, ALLOCATED_STATUS_CODE → Allocated_Status_Code, COURIER_NUMBER → Courier_Number
Sales Order Details	sage50uk__SAGE50UKSalesOrder_Detail	52	ITEM_NUMBER, JOB_NUMBER, ORDER_NUMBER, ITEMID → Commercient_ExternalKey__c, ITEM_NUMBER, JOB_NUMBER, ORDER_NUMBER, ITEMID → Name, ITEM_NUMBER, JOB_NUMBER, ORDER_NUMBER, ITEMID → SAGE50UKSalesOrder_Detail__Name, ORDER_NUMBER → lookupSalesOrderHeader, STOCK_CODE → lookupItem
Invoice Header	sage50uk__SAGE50UK_Invoice_Header	98	INVOICE_NUMBER → Commercient_ExternalKey__c, NAME → Name, ACCOUNT_REF → Customer, ACCOUNT_REF → Account, CURRENCY → Currency
Invoice Details	sage50uk__SAGE50UK_Invoice_Detail	48	INVOICE_NUMBER → SAGE50UK_Invoice_Header, ITEM_NUMBER → ITEM, INVOICE_NUMBER, ITEM_NUMBER, ITEMID → SAGE50UK_Invoice_Detail__Name, INVOICE_NUMBER, ITEM_NUMBER, ITEMID → Name, INVOICE_NUMBER, ITEM_NUMBER, ITEMID → ExternalKey
Suppliers	Vendors	17	ACCOUNT_REF, NAME → Commercient_ExternalKey__c, NAME → Vendor_Name, ACCOUNT_REF → Sage_Account_Ref, CONTACT_NAME → Contact_Name, E_MAIL → Email
SAGE50UK Vendor	sage50uk__SAGE50UK_Vendor	126	ACCOUNT_REF → Commercient_ExternalKey__c, NAME → Name, ACCOUNT_ON_HOLD → Account_On_Hold, ACCOUNT_REF → Account_Ref, ADDRESS_1 → Address_1
SAGE50UK Purchase Order	sage50uk__SAGE50UK_Pur_Order_Header	83	ORDER_NUMBER → Commercient_ExternalKey__c, ACCOUNT_REF → SAGE0UK_Vendor, ACCOUNT_REF → Supplier__c, ORDER_NUMBER → Name, ADDRESS_1 → Address_1
SAGE50UK PurchaseOrderLine	sage50uk__SAGE50UK_Pur_Order_Detail	54	ORDER_NUMBER, ITEMID, ITEM_NUMBER, JOB_NUMBER → Commercient_ExternalKey__c, STOCK_CODE → Products_R, ORDER_NUMBER → SAGE50UK_Purchase_Order_Header, ORDER_NUMBER, ITEMID, ITEM_NUMBER, JOB_NUMBER → Name, ADD_DISC_RATE → Add_Disc_Rate
Products Update	Products	18	DESCRIPTION → Product_Name, STOCK_CODE → Product_Code, STOCK_CODE → Commercient_ExternalKey__c, DESCRIPTION → Description, INACTIVE_FLAG → Product_Active

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:

• vwAccount:
• vwCustomer:
• vwAddress:
• vw_SAGE50UK_Contact:
• vw_SAGE50UK_Product:
• vwItem:
• vwSalesOrderHeader:
• vwSalesOrderDetail:
• vw_InvoiceHeader:
• vw_InvoiceDetail:
• vw_SAGE50UK_Suppliers:
• vw_SAGE50UK_PurchaseOrder:
• vw_SAGE50UK_PurchaseOrderLine:
• vw_SAGE50UK_DSalesOrder:
• vw_SAGE50UK_DInvoice:
• vw_SAGE50UK_DPurchaseOrder:
• SalesRep:
• vw_SAGE50UK_Vendor:

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 Sage 50 UK → 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.