...
| InTime Field Mapped | Field | Value | Example | |
|---|---|---|---|---|
| Client/Worker/Provider Accounts Ref | → | AccountNumber | Client Accounts Ref | TC0001 |
| Value from 'CashBookAccountNumber' property otherwise "CashBookAcc" | → | cashBookAccountNumber | ||
| Blank | → | daysDiscountValid | ||
| Blank | → | discountValue | ||
| Blank | → | discountPercentage | ||
| Invoice Due Date | → | dueDate | ||
| Gross amount in Client/Worker/Provider default currency | → | goodsValueInAccountCurrency | ||
| Gross amount in Agency Base currency | → | saleControlnValueInBaseCurrency | ||
| Exchange rate between Invoice currency and Agency Base currency | → | documentToBaseCurrencyRate | ||
| Exchange rate between Invoice currency and Client/Worker/Provider default currency | → | documentToAccountCurrencyRate | ||
Invoice Date | → | postedDate | ||
| Blank | → | queryCode | ||
| Invoice Number | → | transactionReference | Invoice Number | CI-00001 |
| Blank | → | secondReference | ||
1 = Sales, 2 = Purchase | → | source | 1 = sales, 2 = Purchase | |
2 = Payment line, 4 = Invoice, 5 = Credit Note | → | sYSTraderTranType | 4 = Invoice, 5 = Credit, 2 = Payment | |
| Invoice Date | → | transactionDate | ||
| Blank | → | uniqueReferenceNumber | ||
| Value from 'Sage200UserNumber' property otherwise "123" | → | userNumber | ||
| VAT amount | → | taxValue | ||
| Blank | → | sYSTraderGenerationReasonType | ||
| Gross amount in Agency Base currency | → | goodsValueInBaseCurrency | ||
| Net amount | → | nominalAnalysisTransactionValue1 | ||
Sales: Expenses: Nominal code from Expense Template Timesheets: Client Nominal Code Purchase: Expenses: Expenses Nominal code for Worker/Provider Timesheets: Nominal Code for Worker/Provider | → | nominalAnalysisNominalAccountNumber1 | Client Time/Expenses Nominal Code | 4001 |
| Placement Sales/Purchase Cost Centre if the same for all placements or 'SalesCostCentre'/'PurchaseCostCentre' if all empty. | → | nominalAnalysisNominalCostCentre1 | placement Sales CostCentre | |
| Placement Sales/Purchase Department if the same for all placements or 'SalesDept'/'PurchaseDept' if all empty. | → | nominalAnalysisNominalDepartment1 | placement Sales Department | |
| Can be overridden with a script in the 'Sage200TransDetailScript' config. | → | nominalAnalysisNominalAnalysisNarrative1 | SI / SC <client name> | SI Test Client |
| Blank | → | nominalAnalysisTransactionAnalysisCode1 | ||
| Blank | → | nominalAnalysisTransactionValue2 | ||
| Blank | → | nominalAnalysisNominalAccountNumber2 | ||
| Blank | → | nominalAnalysisNominalCostCentre2 | ||
| Blank | → | nominalAnalysisNominalDepartment2 | ||
| Blank | → | nominalAnalysisNominalAnalysisNarrative2 | ||
| Blank | → | nominalAnalysisTransactionAnalysisCode2 | ||
| Invoice VAT Code, "T" prefix removed of present. | → | taxAnalysisTaxRate1 | ||
| Net amount | → | taxAnalysisGoodsValueBeforeDiscount1 | ||
| 0 | → | taxAnalysisDiscountValue1 | ||
| 0 | → | taxAnalysisDiscountPercentage1 | ||
| VAT amount | → | taxAnalysisTaxOnGoodsValue1 | ||
| Blank | → | taxAnalysisTaxRate2 | ||
| Blank | → | taxAnalysisGoodsValueBeforeDiscount2 | ||
| Blank | → | taxAnalysisDiscountValue2 | ||
| Blank | → | taxAnalysisDiscountPercentage2 | ||
| Blank | → | taxAnalysisTaxOnGoodsValue2 | ||
Note: Contained within InTime 4.7.1 revision 35839 and above - The Sage 200 export now supports the following export modes:-
...