...
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 |
Sage 200