Agent skill
dlake-crmpro-zohocrm
When an agent should use it: What the shipped CRMPro Standard templates set up when Zoho CRM is the destination, stated across every source ERP that ships them: the object API names the templates push to (`Accounts`), the `TimeStampRepository` key separator they build, the view and `TimeStamp_Prefix` conventions, and which template groups every source ships versus only some. Use it when standing up or reading a Zoho CRM template set, when deciding which templates to import and activate, or when a run completes without pushing records and the answer is in the view or the configuration row. It extends `dlake-crmpro`, which covers operating CRMPro generally, and it carries one child page per source ERP under `erps/`, which is where everything ERP-specific lives.
Extends dlake-crmpro.
27 source-ERP pages: what the shipped templates set up for each (also readable with dlake skills show dlake-crmpro-zohocrm/erps/<erp>)
- acumatica
- epicor-9-and-9-5
- epicor-eagle
- epicor-prophet-21-p21
- exact-online
- globalshop
- infor-cloudsuite
- infor-visual-9
- microsoft-dynamics-ax
- microsoft-dynamics-gp-2016
- microsoft-dynamics-gp-2017
- netsuite
- quickbooks-desktop
- quickbooks-online
- sage-100-contractor-2018
- sage-100-contractor-2018-sage100c2018
- sage-100-premium
- sage-100-us
- sage-200-uk
- sage-300
- sage-50-canada
- sage-50-uk
- sage-50-us
- sage-x3
- sap-b1
- sap-business-bydesign
- syspro-7-and-above
Install with "dlake skills install" or read it in the terminal with "dlake skills show dlake-crmpro-zohocrm". Skills ship inside the CLI; the copy below mirrors the GitHub repository.
CRMPro → Zoho CRM: what the shipped templates set up
Keep this skill current.
dlakeships updates often and this text is embedded in the CLI you have installed. Before relying on it, comparedlake --versionwithnpm view @commercient/dlake version; if they differ, runnpm install -g @commercient/dlake@latestand thendlake skills install, which overwrites the installed skill files with the current text.
The source ERP has its own page under this skill. erps/<erp>.md is a child file of this
skill and describes what the shipped templates for that ERP → Zoho CRM pair set up. §6 lists every
one of them and how to pick the right row; read this page first, then that one.
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.
What follows is only what the shipped Standard templates for Zoho CRM themselves set, and only the
part of it that is the same across 24 source ERPs. Everything that belongs to one source — which
groups ship, which clone tables the views read, which view names and prefixes are paired — is on
that ERP’s own page under erps/. This page grows as the catalogue does.
1. The objects these templates push to
Every source ERP that ships Zoho CRM templates pushes to Accounts. Copy an object name from the
template or from crmpro_crm_objects; case is part of the name.
These appear in some sources’ sets and not others:
CRM_Object_API_Name | Sources whose templates push it |
|---|---|
Products | 23 of 24 |
Contacts | 19 of 24 |
Products:Price_Books | 14 of 24 |
Sales_Orders | 13 of 24 |
Invoices | 12 of 24 |
Price_Books | 10 of 24 |
users | 10 of 24 |
Quotes | 7 of 24 |
sage100premium__Ar_InvoiceHistoryDetail | 3 of 24 |
sage100premium__Ar_InvoiceHistoryHeader | 3 of 24 |
sage100premium__Ar_SalesPerson | 3 of 24 |
sage100premium__ArTransactionPaymtHistory | 3 of 24 |
sage100premium__CI_Iem | 3 of 24 |
sage100premium__CI_Item | 3 of 24 |
sage100premium__LM_Item_Warehouse | 3 of 24 |
sage100premium__SO_SalesOrderHistoryDetai | 3 of 24 |
sage100premium__SO_SalesOrdrHistoryHeader | 3 of 24 |
sage100premium__SO_ShipToAddress | 3 of 24 |
commercientmsdynamicgp__MSDYGP_Customer | 2 of 24 |
commercientmsdynamicgp__MSDYGP_CustomerAddress | 2 of 24 |
commercientmsdynamicgp__MSDYGP_InvoiceDetails | 2 of 24 |
commercientmsdynamicgp__MSDYGP_InvoiceHeader | 2 of 24 |
commercientmsdynamicgp__MSDYGP_Item_Master | 2 of 24 |
commercientmsdynamicgp__MSDYGP_Item_Warehouse | 2 of 24 |
commercientmsdynamicgp__MSDYGP_SODetails | 2 of 24 |
commercientmsdynamicgp__MSDYGP_SOHeader | 2 of 24 |
commercientmsdynamicgp__MSDYGP_Warehouse | 2 of 24 |
sage100premium__Sage_Terms | 2 of 24 |
ACUMATICA_Opportunity | 1 of 24 |
commercientacumatica__Acumatica_Customer | 1 of 24 |
commercientacumatica__Acumatica_CustomerContact | 1 of 24 |
commercientacumatica__Acumatica_InvoiceDetail | 1 of 24 |
commercientacumatica__Acumatica_InvoiceHeader | 1 of 24 |
commercientacumatica__Acumatica_SODetail | 1 of 24 |
commercientacumatica__Acumatica_SOHeader | 1 of 24 |
commercientdynamicsax__MSDYAX_Customer | 1 of 24 |
commercientdynamicsax__MSDYAX_Inventory | 1 of 24 |
commercientdynamicsax__MSDYAX_InvoiceDetail | 1 of 24 |
commercientdynamicsax__MSDYAX_InvoiceHeader | 1 of 24 |
commercientdynamicsax__MSDYAX_Payment_Terms | 1 of 24 |
commercientdynamicsax__MSDYAX_SalesOrderDetail | 1 of 24 |
commercientdynamicsax__MSDYAX_SalesOrderHeader | 1 of 24 |
commercientdynamicsax__MSDYAX_Salesperson | 1 of 24 |
commercientdynamicsax__MSDYAX_SalesQuotation | 1 of 24 |
commercientdynamicsax__MSDYAX_SalesQuotationHead | 1 of 24 |
commercientdynamicsax__MSDYAX_ShippingAddress | 1 of 24 |
commercientdynamicsax__MSDYAX_Warehouse | 1 of 24 |
commercientepicoreagle__EpicorEagle_Customer | 1 of 24 |
commercientepicoreagle__EpicorEagle_Inventory | 1 of 24 |
commercientepicoreagle__EpicorEagle_InvoiceDetail | 1 of 24 |
commercientepicoreagle__EpicorEagle_InvoiceHeader | 1 of 24 |
commercientepicoreagle__EpicorEagle_InvtryStore | 1 of 24 |
commercientepicoreagle__EpicorEagle_OpenInvoiceD | 1 of 24 |
commercientepicoreagle__EpicorEagle_OpenInvoiceH | 1 of 24 |
commercientepicoreagle__EpicorEagle_SalesPerson | 1 of 24 |
commercientepicoreagle__EpicorEagle_SODetail | 1 of 24 |
commercientepicoreagle__EpicorEagle_SOHeader | 1 of 24 |
commercientepicoreagle__EpicorEagle_TermsCode | 1 of 24 |
commercientepicorp21__EpicorP21_Address | 1 of 24 |
commercientepicorp21__Epicorp21_Branch | 1 of 24 |
commercientepicorp21__Epicorp21_Class | 1 of 24 |
commercientepicorp21__EpicorP21_Customer | 1 of 24 |
commercientepicorp21__EpicorP21_InvoiceDetails | 1 of 24 |
commercientepicorp21__EpicorP21_InvoiceHeader | 1 of 24 |
commercientepicorp21__EpicorP21_InvoicePayment | 1 of 24 |
commercientepicorp21__Epicorp21_Item_Master | 1 of 24 |
commercientepicorp21__Epicorp21_Item_Warehouse | 1 of 24 |
commercientepicorp21__Epicorp21_Sales_Person | 1 of 24 |
commercientepicorp21__Epicorp21_Serial_Number | 1 of 24 |
commercientepicorp21__EpicorP21_ShipToAddress | 1 of 24 |
commercientepicorp21__EpicorP21_SODetails | 1 of 24 |
commercientepicorp21__EpicorP21_SOHeader | 1 of 24 |
commercientepicorp21__Epicorp21_Terms | 1 of 24 |
commercientepicorp21__Epicorp21_Territory | 1 of 24 |
commercientepicorp21__Epicorp21_Warehouse | 1 of 24 |
commercientexactonline__ExactOnline_Address | 1 of 24 |
commercientexactonline__ExactOnline_Customer | 1 of 24 |
commercientexactonline__ExactOnline_Invoice | 1 of 24 |
commercientexactonline__ExactOnline_InvoiceLine | 1 of 24 |
commercientexactonline__ExactOnline_Quote | 1 of 24 |
commercientexactonline__ExactOnline_QuoteLine | 1 of 24 |
commercientexactonline__ExactOnline_SalesOrder | 1 of 24 |
commercientexactonline__ExactOnline_SO_Line | 1 of 24 |
commercientglobalshop__GlobalShop_Customer | 1 of 24 |
commercientglobalshop__GlobalShop_Invoice_Header | 1 of 24 |
commercientglobalshop__GlobalShop_Invoice_Line | 1 of 24 |
commercientglobalshop__GlobalShop_Item_List | 1 of 24 |
commercientglobalshop__GlobalShop_Item_Master | 1 of 24 |
commercientglobalshop__GlobalShop_Salespersons | 1 of 24 |
commercientglobalshop__GlobalShop_ShipToAddress | 1 of 24 |
commercientglobalshop__GlobalShop_SO_Header | 1 of 24 |
commercientglobalshop__GlobalShop_SO_Line | 1 of 24 |
commercientglobalshop__GlobalShop_Terms | 1 of 24 |
commercientinforcloudsuite__InforCloud_Customers | 1 of 24 |
commercientinforcloudsuite__InforCloud_Invoices | 1 of 24 |
commercientinforcloudsuite__InforCloud_ItemLocation | 1 of 24 |
commercientinforcloudsuite__InforCloud_ItemMaster | 1 of 24 |
commercientinforcloudsuite__InforCloud_ItemWarehouse | 1 of 24 |
commercientinforcloudsuite__InforCloud_SalesOrderLine | 1 of 24 |
commercientinforcloudsuite__InforCloud_SalesOrders | 1 of 24 |
commercientinforcloudsuite__InforCloud_Salespersons | 1 of 24 |
commercientinforcloudsuite__InforCloud_ShipToAddress | 1 of 24 |
commercientinforcloudsuite__InforCloud_Terms | 1 of 24 |
commercientinforvisual__Infor_Visual_Address | 1 of 24 |
commercientinforvisual__Infor_Visual_Customer | 1 of 24 |
commercientinforvisual__Infor_Visual_Order | 1 of 24 |
commercientinforvisual__Infor_Visual_Order_Line | 1 of 24 |
commercientinforvisual__Infor_Visual_Part | 1 of 24 |
commercientinforvisual__Infor_Visual_Quote_Line | 1 of 24 |
commercientinforvisual__Infor_Visual_Quote_Price | 1 of 24 |
commercientinforvisual__Infor_Visual_Qutoe | 1 of 24 |
commercientinforvisual__Infor_Visual_Receivable | 1 of 24 |
commercientinforvisual__Infor_Visual_Receivable_L | 1 of 24 |
commercientinforvisual__Infor_Visual_SalesPerson | 1 of 24 |
commercientinforvisual__Infor_Visual_Terms | 1 of 24 |
commercientnetsuite0__Netsuite_Address | 1 of 24 |
commercientnetsuite0__Netsuite_Customer | 1 of 24 |
commercientnetsuite0__Netsuite_Invoice | 1 of 24 |
commercientnetsuite0__Netsuite_InvoiceItem | 1 of 24 |
commercientnetsuite0__Netsuite_Item | 1 of 24 |
commercientnetsuite0__Netsuite_Item_Warehouse | 1 of 24 |
commercientnetsuite0__Netsuite_SalesOrder | 1 of 24 |
commercientnetsuite0__Netsuite_SalesOrderItem | 1 of 24 |
commercientnetsuite0__Netsuite_SalesPerson | 1 of 24 |
commercientnetsuite0__Netsuite_Terms | 1 of 24 |
commercientsage200uk__Sage200UK_Address | 1 of 24 |
commercientsage200uk__Sage200UK_Customers | 1 of 24 |
commercientsage200uk__Sage200UK_InvoiceDetail | 1 of 24 |
commercientsage200uk__Sage200UK_InvoiceHeader | 1 of 24 |
commercientsage200uk__Sage200UK_Item | 1 of 24 |
commercientsage200uk__Sage200UK_SalesOrderHeadr | 1 of 24 |
commercientsage200uk__Sage200UK_SalesOrdrDetail | 1 of 24 |
commercientsage200uk__Sage200UK_Warehouse | 1 of 24 |
commercientsage200uk__Sage200UK_Warehouse_Item | 1 of 24 |
commercientsage300__Sage300_Customer | 1 of 24 |
commercientsage300__Sage300_InvoiceDetail | 1 of 24 |
commercientsage300__Sage300_InvoiceHeader | 1 of 24 |
commercientsage300__Sage300_Item | 1 of 24 |
commercientsage300__Sage300_SalesOrderDetail | 1 of 24 |
commercientsage300__Sage300_SalesOrderHeader | 1 of 24 |
commercientsage300__Sage300_SalesPerson | 1 of 24 |
commercientsage300__Sage300_ShipToAddress | 1 of 24 |
commercientsage50ca__SAGE50CA_Customer | 1 of 24 |
commercientsage50ca__SAGE50CA_InvoiceDetail | 1 of 24 |
commercientsage50ca__SAGE50CA_InvoiceHeader | 1 of 24 |
commercientsage50ca__SAGE50CA_Item | 1 of 24 |
commercientsage50ca__SAGE50CA_ItemWarehouse | 1 of 24 |
commercientsage50ca__SAGE50CA_Salesperson | 1 of 24 |
commercientsage50ca__SAGE50CA_ShipToAddress | 1 of 24 |
commercientsage50ca__SAGE50CA_SODetail | 1 of 24 |
commercientsage50ca__SAGE50CA_SOHeader | 1 of 24 |
commercientsagex3__SageX3_Address | 1 of 24 |
commercientsagex3__SageX3_Customer | 1 of 24 |
commercientsagex3__SageX3_InvoiceDetail | 1 of 24 |
commercientsagex3__SageX3_InvoiceHeader | 1 of 24 |
commercientsagex3__SageX3_ItemMaster | 1 of 24 |
commercientsagex3__SageX3_ItemWareHouse | 1 of 24 |
commercientsagex3__SageX3_PaymentDetail | 1 of 24 |
commercientsagex3__SageX3_PaymentHeader | 1 of 24 |
commercientsagex3__SageX3_PaymentTerm | 1 of 24 |
commercientsagex3__SageX3_SalesOrderDetail | 1 of 24 |
commercientsagex3__SageX3_SalesOrderHeader | 1 of 24 |
commercientsagex3__SageX3_SalesPerson | 1 of 24 |
commercientsagex3__SageX3_Warehouse | 1 of 24 |
commercientsapb1__SAPB1_Address | 1 of 24 |
commercientsapb1__SAPB1_Customer | 1 of 24 |
commercientsapb1__SAPB1_Invoice_Detail | 1 of 24 |
commercientsapb1__SAPB1_Invoice_Header | 1 of 24 |
commercientsapb1__SAPB1_Item | 1 of 24 |
commercientsapb1__SAPB1_Item_PriceBooks | 1 of 24 |
commercientsapb1__SAPB1_PriceBooks | 1 of 24 |
commercientsapb1__SAPB1_Quotes | 1 of 24 |
commercientsapb1__SAPB1_Quotes_Details | 1 of 24 |
commercientsapb1__SAPB1_Sales_Order_Detail | 1 of 24 |
commercientsapb1__SAPB1_Sales_Order_Header | 1 of 24 |
commercientsyspro7__Syspro7_ARMultipleAddress | 1 of 24 |
commercientsyspro7__Syspro7_Customer | 1 of 24 |
commercientsyspro7__Syspro7_Inv_Warehouse | 1 of 24 |
commercientsyspro7__Syspro7_Inventory_Master | 1 of 24 |
commercientsyspro7__Syspro7_InvoiceDetail | 1 of 24 |
commercientsyspro7__Syspro7_InvoiceHeader | 1 of 24 |
commercientsyspro7__Syspro7_Salesperson | 1 of 24 |
commercientsyspro7__Syspro7_SODetail | 1 of 24 |
commercientsyspro7__Syspro7_SOHeader | 1 of 24 |
commercientsyspro7__Terms | 1 of 24 |
EpicorEagle_SerialNumber | 1 of 24 |
Infor_Visual_Notes | 1 of 24 |
MSDYAX_Cust_Pur_History | 1 of 24 |
MSDYAX_Dispatch_Shipping | 1 of 24 |
Netsuite_TaxGroup | 1 of 24 |
Netsuite_TaxType | 1 of 24 |
Purchase_Orders | 1 of 24 |
sage100contractor__SAGE100CNTR_AR_Payment | 1 of 24 |
sage100contractor__SAGE100CNTR_ARInvoice | 1 of 24 |
sage100contractor__SAGE100CNTR_ARInvoiceLine | 1 of 24 |
sage100contractor__SAGE100CNTR_Customer | 1 of 24 |
sage100contractor__SAGE100CNTR_InventoryHist | 1 of 24 |
sage100contractor__SAGE100CNTR_Job | 1 of 24 |
sage100contractor__SAGE100CNTR_Parts | 1 of 24 |
sage100contractor__SAGE100CNTR_Salesperson | 1 of 24 |
sage50uk__SAGE50UK_Address | 1 of 24 |
sage50uk__SAGE50UK_Customer | 1 of 24 |
sage50uk__SAGE50UK_Invoice_Detail | 1 of 24 |
sage50uk__SAGE50UK_Invoice_Header | 1 of 24 |
sage50uk__SAGE50UK_ITEM | 1 of 24 |
sage50uk__SAGE50UK_Pur_Order_Detail | 1 of 24 |
sage50uk__SAGE50UK_Pur_Order_Header | 1 of 24 |
sage50uk__SAGE50UK_Vendor | 1 of 24 |
sage50uk__SAGE50UKSalesOrder_Detail | 1 of 24 |
sage50uk__SAGE50UKSalesOrder_Header | 1 of 24 |
sage50ustozoho__SAGE50US_Address | 1 of 24 |
sage50ustozoho__SAGE50US_ARTerm | 1 of 24 |
sage50ustozoho__SAGE50US_Customer | 1 of 24 |
sage50ustozoho__SAGE50US_Item_Master | 1 of 24 |
sage50ustozoho__SAGE50US_SalesInvoiceDeta | 1 of 24 |
sage50ustozoho__SAGE50US_SalesInvoiceHead | 1 of 24 |
sage50ustozoho__SAGE50US_SalesOrderDetail | 1 of 24 |
sage50ustozoho__SAGE50US_SalesOrderHeader | 1 of 24 |
sage50ustozoho__SAGE50US_SalesPerson | 1 of 24 |
Vendors | 1 of 24 |
zohotoquickbooks__Quickbooks_Customer | 1 of 24 |
zohotoquickbooks__Quickbooks_Invoice_Detail | 1 of 24 |
zohotoquickbooks__Quickbooks_Invoice_Header | 1 of 24 |
zohotoquickbooks__Quickbooks_Item | 1 of 24 |
zohotoquickbooks__Quickbooks_Sales_Persons | 1 of 24 |
zohotoquickbooks__Quickbooks_Terms | 1 of 24 |
zohotoquickbooks__QuickbooksSaleOrderDetail | 1 of 24 |
zohotoquickbooks__QuickbooksSaleOrderHeader | 1 of 24 |
2. The repository key these templates build
Every one of these template sets builds its TimeStampRepository key as
<TimeStamp_Prefix>:<key>. The literal in the view and the TimeStamp_Prefix on the
configuration row have to be the same string, case included; a key built with the other separator
matches nothing the engine wrote.
The views these templates create are named with the vw_ prefix form. The TimeStamp_Prefix is
not reliably the view name — the ERP pages carry the pairings — and it is what every downstream
view joins on, so it is effectively public API between processes.
3. What the template groups deliver
The rest are shipped by some sources only:
| Template group | Sources that ship it |
|---|---|
| Contacts | 16 of 24 |
| Products | 16 of 24 |
| Invoices | 11 of 24 |
| Account | 10 of 24 |
| Accounts | 10 of 24 |
| CRM Ownership | 8 of 24 |
| Product | 7 of 24 |
| Child Account | 6 of 24 |
| Quotes | 6 of 24 |
| Sales Orders | 6 of 24 |
| Parent Account | 4 of 24 |
| PriceBooks | 4 of 24 |
| Product Pricebook | 4 of 24 |
| Contact | 3 of 24 |
| Product Pricebooks | 3 of 24 |
| Sage100 Customer | 3 of 24 |
| Sage100 Invoice Detail | 3 of 24 |
| Sage100 Invoice Header | 3 of 24 |
| Sage100 Item Master | 3 of 24 |
| Sage100 Product Price Book | 3 of 24 |
| Sage100 Sales Order Detail | 3 of 24 |
| Sage100 Sales Order Header | 3 of 24 |
| Sage100 Sales Person | 3 of 24 |
| Sage100 Ship To Address | 3 of 24 |
| Sage100 Transcation Payment History | 3 of 24 |
| Sage100 Warehouse | 3 of 24 |
| SalesOrders | 3 of 24 |
| Child Accounts | 2 of 24 |
| Invoice | 2 of 24 |
| Item Master | 2 of 24 |
| MSDYGP Customer | 2 of 24 |
| MSDYGP CustomerAddress | 2 of 24 |
| MSDYGP InvoiceDetail | 2 of 24 |
| MSDYGP InvoiceHeader | 2 of 24 |
| MSDYGP ItemMaster | 2 of 24 |
| MSDYGP ItemWareHouse | 2 of 24 |
| MSDYGP SalesOrderDetail | 2 of 24 |
| MSDYGP SalesOrderHeader | 2 of 24 |
| MSDYGP Warehouse | 2 of 24 |
| Pricebook | 2 of 24 |
That is the 40 most widely shipped; the ERP pages carry the rest.
Every one of these templates inserts Is_Active as 0, so an imported process is inactive until
an operator activates it, and the Registration API’s import does not populate CRM_FieldList — an
object with no CRM_FieldList rows pushes nothing and records no error. Read MappingJson off
the template with dlake admin crmpro_templates, then check crmpro_field_mapping on the created
process before activating it.
4. When a run pushes no records
The signature failure is the one dlake-crmpro §7d describes: every object logs a start and an
end in about 0.00 seconds, the total is zero, and no error is written anywhere. For this
destination, check in this order.
- Does the view return rows? Zero rows means the answer is in the view.
- Does
TimeStamp_Prefixequal the literal the view builds its key from, case included — and not, by reflex, the view’s own name? - Is the separator the one §2 names, in both the view literal and the prefix?
- Does
CRM_FieldListhave rows for thatObject_Name, spelled as the API name? - Any NULL nullable text column on the configuration row? The templates set
''throughout, and a NULL throws inside the engine, which catches it — so the object is skipped with no recorded error. - Is the parent’s prefix the one that actually holds the ids? A view that reads another
process’s prefix returns nothing until that process has run, which is what makes
Sync_Ordera dependency order rather than a preference. - Do the clone tables the view reads carry the prefix this ERP’s templates expect? That is on the ERP’s own page, and it differs between sources.
5. 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 ::.
6. The source ERP’s own page
One row per source ERP the catalogue carries Zoho CRM templates for. Each page is a child file of
this skill, addressed as dlake-crmpro-zohocrm/erps/<erp> — dlake skills show dlake-crmpro-zohocrm/erps/<erp> prints one, and dlake skills install writes them beside this
file.
| ERP | Page | What its templates deliver |
|---|---|---|
| Acumatica | erps/acumatica.md | 10 Standard templates in 10 groups, pushing users, Accounts, Contacts, commercientacumatica__Acumatica_Customer and more; : repository keys |
| Epicor 9 and 9.5 | erps/epicor-9-and-9-5.md | no Standard templates; 4 community templates |
| Epicor Eagle | erps/epicor-eagle.md | 18 Standard templates in 18 groups, pushing commercientepicoreagle__EpicorEagle_TermsCode, commercientepicoreagle__EpicorEagle_SalesPerson, Accounts, commercientepicoreagle__EpicorEagle_Customer and more; : repository keys; 19 community templates |
| Epicor Prophet 21 (P21) | erps/epicor-prophet-21-p21.md | 23 Standard templates in 23 groups, pushing commercientepicorp21__Epicorp21_Terms, commercientepicorp21__Epicorp21_Branch, commercientepicorp21__Epicorp21_Class, commercientepicorp21__Epicorp21_Territory and more; : repository keys; 37 community templates |
| Exact Online | erps/exact-online.md | 11 Standard templates in 11 groups, pushing Accounts, commercientexactonline__ExactOnline_Customer, commercientexactonline__ExactOnline_Address, Contacts and more; : repository keys |
| GlobalShop | erps/globalshop.md | 14 Standard templates in 14 groups, pushing users, commercientglobalshop__GlobalShop_Terms, commercientglobalshop__GlobalShop_Salespersons, Accounts and more; : repository keys |
| Infor CloudSuite | erps/infor-cloudsuite.md | 14 Standard templates in 14 groups, pushing commercientinforcloudsuite__InforCloud_Terms, commercientinforcloudsuite__InforCloud_Salespersons, Accounts, commercientinforcloudsuite__InforCloud_Customers and more; : repository keys |
| Infor Visual 9 | erps/infor-visual-9.md | 22 Standard templates in 22 groups, pushing commercientinforvisual__Infor_Visual_Terms, commercientinforvisual__Infor_Visual_SalesPerson, Accounts, commercientinforvisual__Infor_Visual_Customer and more; : repository keys; 23 community templates |
| Microsoft Dynamics AX | erps/microsoft-dynamics-ax.md | 18 Standard templates in 18 groups, pushing commercientdynamicsax__MSDYAX_Payment_Terms, Accounts, commercientdynamicsax__MSDYAX_Customer, Products and more; : repository keys |
| Microsoft Dynamics GP 2016 | erps/microsoft-dynamics-gp-2016.md | 16 Standard templates in 16 groups, pushing Accounts, commercientmsdynamicgp__MSDYGP_Customer, commercientmsdynamicgp__MSDYGP_CustomerAddress, Products and more; : repository keys |
| Microsoft Dynamics GP 2017 | erps/microsoft-dynamics-gp-2017.md | 16 Standard templates in 16 groups, pushing Accounts, commercientmsdynamicgp__MSDYGP_Customer, commercientmsdynamicgp__MSDYGP_CustomerAddress, Products and more; : repository keys; 16 community templates |
| NetSuite | erps/netsuite.md | 17 Standard templates in 17 groups, pushing commercientnetsuite0__Netsuite_Terms, commercientnetsuite0__Netsuite_SalesPerson, Accounts, commercientnetsuite0__Netsuite_Customer and more; : repository keys; 64 community templates |
| QuickBooks Desktop | erps/quickbooks-desktop.md | 15 Standard templates in 15 groups, pushing zohotoquickbooks__Quickbooks_Terms, zohotoquickbooks__Quickbooks_Sales_Persons, Accounts, zohotoquickbooks__Quickbooks_Customer and more; : repository keys |
| QuickBooks Online | erps/quickbooks-online.md | no Standard templates; 5 community templates |
| Sage 100 (US) | erps/sage-100-us.md | 18 Standard templates in 18 groups, pushing Accounts, sage100premium__CI_Iem, sage100premium__SO_ShipToAddress, sage100premium__Ar_SalesPerson and more; : repository keys; 19 community templates |
| Sage 100 Contractor 2018 | erps/sage-100-contractor-2018.md | 15 Standard templates in 15 groups, pushing sage100contractor__SAGE100CNTR_Salesperson, Accounts, sage100contractor__SAGE100CNTR_Customer, sage100contractor__SAGE100CNTR_Job and more; : repository keys; 14 community templates |
| Sage 100 Contractor 2018 (SAGE100C2018) | erps/sage-100-contractor-2018-sage100c2018.md | 19 Standard templates in 19 groups, pushing sage100premium__Ar_SalesPerson, Accounts, sage100premium__CI_Iem, sage100premium__SO_ShipToAddress and more; : repository keys; 18 community templates |
| Sage 100 Premium | erps/sage-100-premium.md | 18 Standard templates in 18 groups, pushing Accounts, sage100premium__CI_Iem, sage100premium__SO_ShipToAddress, sage100premium__Ar_SalesPerson and more; : repository keys |
| Sage 200 UK | erps/sage-200-uk.md | 17 Standard templates in 17 groups, pushing Accounts, commercientsage200uk__Sage200UK_Customers, commercientsage200uk__Sage200UK_Address, Contacts and more; : repository keys; 11 community templates |
| Sage 300 | erps/sage-300.md | 17 Standard templates in 17 groups, pushing commercientsage300__Sage300_SalesPerson, Accounts, commercientsage300__Sage300_Customer, Contacts and more; : repository keys |
| Sage 50 Canada | erps/sage-50-canada.md | 13 Standard templates in 13 groups, pushing commercientsage50ca__SAGE50CA_Salesperson, Accounts, commercientsage50ca__SAGE50CA_Customer, commercientsage50ca__SAGE50CA_ShipToAddress and more; : repository keys; 48 community templates |
| Sage 50 UK | erps/sage-50-uk.md | 19 Standard templates in 19 groups, pushing Accounts, sage50uk__SAGE50UK_Customer, sage50uk__SAGE50UK_Address, Contacts and more; : repository keys |
| Sage 50 US | erps/sage-50-us.md | 17 Standard templates in 17 groups, pushing sage50ustozoho__SAGE50US_ARTerm, sage50ustozoho__SAGE50US_SalesPerson, Accounts, sage50ustozoho__SAGE50US_Customer and more; : repository keys; 55 community templates |
| Sage X3 | erps/sage-x3.md | 19 Standard templates in 19 groups, pushing commercientsagex3__SageX3_PaymentTerm, commercientsagex3__SageX3_SalesPerson, Accounts, commercientsagex3__SageX3_Customer and more; : repository keys |
| SAP B1 | erps/sap-b1.md | 16 Standard templates in 16 groups, pushing Accounts, commercientsapb1__SAPB1_Customer, commercientsapb1__SAPB1_Address, Products and more; : repository keys |
| SAP Business ByDesign | erps/sap-business-bydesign.md | no Standard templates; 11 community templates |
| SYSPRO 7 and above | erps/syspro-7-and-above.md | 17 Standard templates in 17 groups, pushing Accounts, commercientsyspro7__Terms, commercientsyspro7__Syspro7_Salesperson, commercientsyspro7__Syspro7_Customer and more; : repository keys |
Work out which row applies before reading one. The source is the ERP the tenant was registered
with: dlake register erps lists the catalogue’s names and codes, and dlake admin crmpro_templates shows what that tenant can actually import. Match that ERP to a row above, then
read its page alongside this one — this page for the conventions that hold across every source,
that page for what this source’s own templates set. If no row matches the tenant’s ERP, this skill
alone applies: the catalogue ships no Standard templates for that pair, so there is nothing
ERP-specific to read and nothing to import.
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 skill
adds what the shipped Zoho CRM templates set up, and its erps/ pages add what each source ERP’s
own templates set. dlake-crmpro-hubspot, dlake-crmpro-salesforce and dlake-crmpro-shopify
are the hand-written destination skills for their CRMs, and the conventions genuinely differ
between destinations. 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.
