...
| InTime Field Mapped | Field | Value | Size | Example | |
|---|---|---|---|---|---|
| Client/Worker/Provider Accounts Ref | → | AccountNumber | Client Accounts Ref | 8 | TC0001 |
| Value from 'CashBookAccountNumber' property otherwise "CashBookAcc" | → | cashBookAccountNumber | 8 | ||
| Blank | → | daysDiscountValid | Integer | ||
| Blank | → | discountValue | Decimal | ||
| Blank | → | discountPercentage | Decimal | ||
| Invoice Due Date | → | dueDate | dd/mm/yyyy | ||
| Gross amount in Client/Worker/Provider default currency | → | goodsValueInAccountCurrency | Decimal | ||
| Gross amount in Agency Base currency | → | saleControlnValueInBaseCurrency | Decimal | ||
| Exchange rate between Invoice currency and Agency Base currency | → | documentToBaseCurrencyRate | Decimal | ||
| Exchange rate between Invoice currency and Client/Worker/Provider default currency | → | documentToAccountCurrencyRate | Decimal | ||
Invoice Date | → | postedDate | dd/mm/yyyy | ||
| Blank | → | queryCode | 2 | ||
| Invoice Number | → | transactionReference | Invoice Number | 20 | CI-00001 |
| Blank | → | secondReference | 20 | ||
1 = Sales, 2 = Purchase | → | source | 1 = sales, 2 = Purchase | Integer | |
2 = Payment line, 4 = Invoice, 5 = Credit Note | → | sYSTraderTranType | 4 = Invoice, 5 = Credit, 2 = Payment | Integer | |
| Invoice Date | → | transactionDate | dd/mm/yyyy | ||
| Blank | → | uniqueReferenceNumber | Integer | ||
| Value from 'Sage200UserNumber' property otherwise "123" | → | userNumber | Integer | ||
| VAT amount | → | taxValue | Decimal | ||
| Blank | → | sYSTraderGenerationReasonType | Integer | ||
| Gross amount in Agency Base currency | → | goodsValueInBaseCurrency | 13 | ||
| Net amount | → | nominalAnalysisTransactionValue1 | Decimal | ||
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 | 8 | 4001 |
| Placement Sales/Purchase Cost Centre if the same for all placements or 'SalesCostCentre'/'PurchaseCostCentre' if all empty. | → | nominalAnalysisNominalCostCentre1 | placement Sales CostCentre | 3 | |
| Placement Sales/Purchase Department if the same for all placements or 'SalesDept'/'PurchaseDept' if all empty. | → | nominalAnalysisNominalDepartment1 | placement Sales Department | 3 | |
| Can be overridden with a script in the 'Sage200TransDetailScript' config. | → | nominalAnalysisNominalAnalysisNarrative1 | SI / SC <client name> | 60 | SI Test Client |
| Blank | → | nominalAnalysisTransactionAnalysisCode1 | 20 | ||
| Blank | → | nominalAnalysisTransactionValue2 | Decimal | ||
| Blank | → | nominalAnalysisNominalAccountNumber2 | 8 | ||
| Blank | → | nominalAnalysisNominalCostCentre2 | 3 | ||
| Blank | → | nominalAnalysisNominalDepartment2 | 3 | ||
| Blank | → | nominalAnalysisNominalAnalysisNarrative2 | 60 | ||
| Blank | → | nominalAnalysisTransactionAnalysisCode2 | 20 | ||
| Invoice VAT Code, "T" prefix removed of present. | → | taxAnalysisTaxRate1 | Integer | ||
| Net amount | → | taxAnalysisGoodsValueBeforeDiscount1 | Decimal | ||
| 0 | → | taxAnalysisDiscountValue1 | Decimal | ||
| 0 | → | taxAnalysisDiscountPercentage1 | Decimal | ||
| VAT amount | → | taxAnalysisTaxOnGoodsValue1 | Decimal | ||
| Blank | → | taxAnalysisTaxRate2 | Integer | ||
| Blank | → | taxAnalysisGoodsValueBeforeDiscount2 | Decimal | ||
| Blank | → | taxAnalysisDiscountValue2 | Decimal | ||
| Blank | → | taxAnalysisDiscountPercentage2 | Decimal | ||
| Blank | → | taxAnalysisTaxOnGoodsValue2 | Decimal | ||
Access Dimensions
Clients who have taken our Access Dimensions service benefit from system-to-system integration between InTime and our Access Dimensions platform.
...