Sage Line 50 import format

No.

Field Name

Type

Size

Validation

1

Transaction type

Char

2

PI, SI

2

Sales/Purchase Account Ref

Char

8

Lookup

3

Nominal Code

Char

8

Lookup

4

Department No

Int

3

1-999

5

Transaction Date

Date

10

Date

6

Transaction Ref (invoice no)

Char

8

7

Transaction Details

Char

60

8

Net amount

Double

11

9

Tax Code

Int

T1/T0

T1 = vat applicable

T0 = non-vatable

10

Tax Amount

Double

11

11

Extra Ref

Char

8

12

User Name

Char

32