...
Sample InTime Sage 50 export file - sage50_InTimeSample.csv.
Sage 50 Specification:-
| InTime Field Mapped | Column | Field | Type | Size | Validation | Precision | Import Type | |
| → | A | Transaction Type | text | 2 | BP, BR, CP, CR, JC, JD, PA, PC, PI, SA, SC, SI, VP, VR |
| Standard/Extended | |
| → | B | Sales/Purchase/Bank Account Ref | text | 8 | Look up |
| Standard/Extended | |
| → | C | Nominal Code | text | 8 | Look up |
| Standard/Extended | |
| → | D | Department Number | Int | 3 | 1-999 |
| Standard/Extended | |
| → | E | Transaction date | Date | 10 | Date | Xx/xx/xxxx | Standard/Extended | |
| → | F | Transaction (invoice) ref | Text | 30 |
|
| Standard/Extended | |
| → | G | Transaction detail | Text | 60 |
|
| Standard/Extended | |
| → | H | Net Amount | Decimal | 11 |
| 8 digits + 2d.p | Standard/Extended | |
| → | I | Tax code | Int | 3 | T0-T99 |
| Standard/Extended | |
| → | J | Tax amount | Decimal | 11 |
| 8 digits + 2d.p | Standard/Extended | |
| → | K | Exchange rate | Decimal | 11 |
|
| Extended | |
| → | L | Extra Ref | Text | 30 |
|
| Extended | |
| → | M | Username | text | 32 |
|
| Extended |
...