Important: This reference is provided as a guide and may not reflect every field imported for your specific configuration. Certain import sections, such as User Defined Fields, Price Lists, and Discount matrices, may not be fully represented here. As the integration is updated over time, this document may become out of date. If you notice any missing fields, inaccuracies, or discrepancies between this document and the data in your system, please raise this with our support team so that we can review and update this article accordingly.

Customers (Sales Ledger)

CRM Field (Friendly Name)	Financials Source	Description
Sales Ledger ID	`customerDetails.code`	Unique identifier to link the customer between Financials and CRM
Accounts ID	`customerDetails.code`	Cross-reference ID back to the Financials accounts system
Currency Code	`settings.currency.code`	Determines which currency the customer trades in
Name	`customerDetails.name`	The customer's display name in the CRM
Display Description	`customerDetails.name`	Friendly label shown in CRM list views
Address Line 1	`addressDetails.address` (line 1)	First line of the customer's postal address
Address Line 2	`addressDetails.address` (line 2)	Second line of the customer's postal address
Address Line 3	`addressDetails.address` (line 3)	Third line of the customer's postal address
Address Line 4	`addressDetails.address` (line 4)	Fourth line of the customer's postal address
Postcode	`addressDetails.postCode`	Customer's postal/zip code for address records
Country	`addressDetails.country`	Customer's country for regional reporting
Price List	`terms.priceKey`	Identifies which price list applies to this customer
Overall Discount	`terms.discount.total` + `terms.discount.line` (combined)	Combined total and line discount percentage for pricing calculations
Settlement Days 1	`terms.discount.settlementDiscount.days1`	Number of days for the first settlement discount tier
Settlement Days 2	`terms.discount.settlementDiscount.days2`	Number of days for the second settlement discount tier
Settlement Discount 1	`terms.discount.settlementDiscount.percentage1`	Discount percentage offered for payment within Settlement Days 1
Settlement Discount 2	`terms.discount.settlementDiscount.percentage2`	Discount percentage offered for payment within Settlement Days 2
Analysis Code	`userSort.sortKey`	Primary sort/analysis classification from Financials
User Analysis Code 1	`userSort.userSort1`	Additional user-defined classification (requires version check)
User Analysis Code 2	`userSort.userSort2`	Additional user-defined classification (requires version check)
User Analysis Code 3	`userSort.userSort3`	Additional user-defined classification (requires version check)
On Stop	`customerDetails.onStop`	Flags whether the customer account is on credit stop
Credit Limit	`terms.credit.creditLimit`	Maximum credit allowed for the customer

Currencies

CRM Field (Friendly Name)	Financials Source	Description
Currency Code	`code` (from rates) / `symbol` (from records)	Unique code identifying the currency
Description	`description`	Human-readable name of the currency
Home Currency	`currencyType` (= "H")	Indicates whether this is the base/home currency
Decimals	Hardcoded: `2`	Number of decimal places for this currency
Currency Rate	`rate` (× 10,000)	Exchange rate relative to base currency, stored as an integer
Obsolete	Derived (0 or 1)	Marks currencies no longer in active use but retained for history
Rounding Method	Hardcoded: `0`	How currency values are rounded
Multiply	Hardcoded: `1`	Currency rate multiplication factor
ISO Code	`isoCode`	Standard ISO 4217 code for the currency

Products (Stock Items)

CRM Field (Friendly Name)	Financials Source	Description
Product Item ID	`code`	Unique product identifier in the CRM
Accounts ID	`code`	Cross-reference ID back to Financials stock code
SKU	`code`	Stock-keeping unit code for the product
Category ID	Hardcoded: `"MAIN"`	Default product category grouping
Description	`name`	Product name/description
Sellable	Hardcoded: `true`	Indicates the product can be sold
Obsolete	Hardcoded: `0`	Whether the product is discontinued
Selling Price	`stockSellingPrices.price` (first non-zero)	Standard selling price for the product
Sell Decimals	Hardcoded: `2`	Decimal places for selling price
Cost Price	`stockPurchasePrices.price`	Purchase/cost price of the product
Cost Decimals	Hardcoded: `2`	Decimal places for cost price
Quantity Decimal	Hardcoded: `2`	Decimal places for quantity values
Stocked	Hardcoded: `1`	Indicates this is a stocked item (vs. service/price record)
Quantity Available	`freeStock`	Current available stock quantity

Price Records

CRM Field (Friendly Name)	Financials Source	Description
Product Item ID	`code`	Unique identifier for the price record item
Accounts ID	`code`	Cross-reference back to Financials
SKU	`code`	Stock-keeping unit code
Category ID	Hardcoded: `"MAIN"`	Default category grouping
Description	`description`	Name/description of the price record
Sellable	Hardcoded: `true`	Indicates it can be sold
Obsolete	Hardcoded: `0`	Whether the item is discontinued
Selling Price	Selling prices query (`price`)	Standard selling price
Sell Decimals	Hardcoded: `2`	Decimal places for selling price
Cost Price	Cost prices query (`price`)	Purchase/cost price
Cost Decimals	Hardcoded: `2`	Decimal places for cost price
Quantity Decimal	Hardcoded: `2`	Decimal places for quantities
Stocked	Hardcoded: `0`	Indicates this is not a stocked item
Quantity Available	Hardcoded: `null`	Not applicable for non-stock items

Additionally, when the Price Key Pricing feature is enabled, per-price-key selling prices are stored in the Financials Product Prices entity.

CRM Field (Friendly Name)	Financials Source	Description
Product Item ID	`priceRecordCode`	Links the price to the product/price record
Price ID	`priceKeyCode` (analysis code)	Identifies which price key/tier this price belongs to
Price	`price`	The actual price value for this price key
Method	Hardcoded: `"F"` (Fixed)	Pricing method (always fixed for price record prices)

Sales Transactions

Sales Order Header

CRM Field (Friendly Name)	Financials Source	Description
Order Number	`headerRef`	Unique transaction reference number
Sales Ledger ID	`accountCode`	Links the transaction to the customer
Order Date	`transactionDate`	Date the transaction occurred
Accounts ID	`auditNo`	Audit number for cross-referencing in Financials
Platform	Hardcoded: `"Financials"`	Identifies the source system of the transaction
Status Flag	Hardcoded: `"A"`	Transaction status (Active)
Net Value	`currencyNet` or `net`	Net value of the transaction in transaction currency
Tax Value	`currencyTax` or `tax`	Tax amount on the transaction
Gross Value	`currencyGross` or `gross`	Total gross value including tax
Base Net Value	`net`	Net value in base/home currency
Base Gross Value	`gross`	Gross value in base/home currency
Base Tax Value	`tax`	Tax value in base/home currency
Currency Code	`currencySymbol`	Currency the transaction was raised in

Sales Transaction Lines

CRM Field (Friendly Name)	Financials Source	Description
Document ID	`headerRef` (from header)	Links the line to its parent document
Line Number	`primaryKey` (from detail)	Unique line identifier within the transaction
Invoice Number	`headerRef`	Invoice reference number
Order Number	`headerRef`	Order reference number
Product Item ID	`itemCode`	Links the line to a product
Product Description	`detail`	Description of the line item
Price	Derived (gross / quantity)	Unit price for the item
Order Quantity	`quantity`	Quantity ordered
Line Value	`currencyNet` or `net`	Net value of the line
Invoice Date	`transactionDate` (from header)	Date the invoice was raised
Account	`accountCode` (from detail)	Nominal account code
Ledger	`accountCode` (from detail)	Ledger account code
Transaction Type	`transactionType` → "I" (Invoice) or "U" (Credit Note)	Distinguishes invoices from credit notes
Gross Value	`currencyGross` or `gross`	Gross value of the line
Currency Code	`currencySymbol` (from header)	Currency of the line
Base Value	`net` (from detail)	Line net in base currency
Base Gross Value	`gross` (from detail)	Line gross in base currency
Quantity Delivered	`quantity`	Quantity that has been delivered
Invoice Quantity	`quantity`	Quantity invoiced
Warehouse Code	Hardcoded: `"MAIN"`	Default warehouse allocation

Purchase Ledger (Suppliers)

CRM Field (Friendly Name)	Financials Source	Description
Purchase Ledger ID	`code`	Unique supplier identifier
Accounts ID	`code`	Cross-reference back to Financials
Balance	`balance`	Outstanding balance owed to the supplier
Display Description	`name`	Friendly display label for the supplier
Currency Code	`currencyCode`	Currency the supplier trades in
Name	`name`	Supplier's name
Address Line 1	`address` (line 1)	First line of supplier address
Address Line 2	`address` (line 2)	Second line of supplier address
Address Line 3	`address` (line 3)	Third line of supplier address
Address Line 4	`town`	Supplier's town
Address Line 5	`county`	Supplier's county/state
Address Block	`address` (full)	Complete address as a single block
Country	`country`	Supplier's country
Postcode	`postCode`	Supplier's postal/zip code
Email	`email`	Supplier's email address
Fax	`fax`	Supplier's fax number
Telephone	`telephone`	Supplier's phone number

Purchase Transactions

Purchase Order Header

CRM Field (Friendly Name)	Financials Source	Description
Document ID	`orderNumber`	Unique purchase order identifier
Order Number	`orderNumber`	PO reference number

Purchase Transaction Lines

CRM Field (Friendly Name)	Financials Source	Description
Document ID	`orderNumber`	Links line to parent PO
Account	`accountCode`	Supplier account code
Ledger	`accountCode`	Ledger account reference
Line Number	Auto-incremented per order	Unique line number within the PO
Order Number	`orderNumber`	Parent order reference
Gross Value	`gross`	Gross value of the line
Line Value	`netOutstanding`	Outstanding net value
Price	`costPrice`	Unit cost price
Invoice Quantity	`quantityInvoiced`	Quantity invoiced so far
Quantity Delivered	`quantityDelivered`	Quantity received/delivered
Order Quantity	`quantityOrdered`	Quantity originally ordered
Order Completed	`completionDate` (header, null check)	Whether the PO is fully completed
Due Date	`requiredDate` (line or header)	Expected delivery date
Delivery Date	`completionDate` (header)	Actual completion/delivery date
Discount Value	`lineDiscount`	Discount applied to the line
Invoice Date	`completionDate` (header)	Date of the related invoice
Product Item ID	`itemCode`	Links the line to a product
Currency	`currencySymbol`	Currency of the line
Product Description	`detail` / `description` / `itemName` (first non-empty)	Description of the ordered item

Tax Codes

CRM Field (Friendly Name)	Financials Source	Description
Tax Code	`code`	Unique tax code identifier
Description	`description`	Human-readable tax description
Rate 1	`rate`	Tax rate percentage
Country Type	Derived (Home/EU/Non-EU)	Determines which country type the tax applies to
Transaction Type	Derived from `use` (Sales/Purchase/General)	Whether tax applies to sales, purchases, or both

Price Keys

CRM Field (Friendly Name)	Financials Source	Description
Tier	`id`	Identifies the price tier/level
Name	`description`	Descriptive name for the price tier

Missing Customer Contact Creation

CRM Field (Friendly Name)	Financials Source	Description
Forename	`contactDetails.firstName`	Contact's first name
Surname	`contactDetails.surname`	Contact's last name
Title	`contactDetails.title`	Contact's title (Mr, Mrs, etc.)

Missing Supplier Contact Creation

CRM Field (Friendly Name)	Financials Source	Description
Forename	`contactDetails.firstName`	Contact's first name
Surname	`contactDetails.surname`	Contact's last name
Title	`contactDetails.title`	Contact's title (Mr, Mrs, etc.)

Full integration capabilities of the Sage 50

Full integration capabilities of Exchequer

Full integration capabilities for Pegasus Opera

Full integration capabilities for Access Dimensions

Full integration capabilities for Cin7 Omni

Full integration capabilities for Access Financials