/
Table of expected data field definitions – Textbook & Tradebook_

Table of expected data field definitions – Textbook & Tradebook_


Field #

Name

Max Size

Description

1

Update Type Code

2

"03" = Add/Update, "05" = Delete –
default is "03" if not present

2

Title

80

Title

3

Author

45

Author (Last or Last, First) If left
blank will load as <AUTHOR>

4

ISBN

30

 

5

Binding

2

2-char binding code See Chart

6

Imprint

10

 

7

Publisher

50

Publisher Name

8

Copyright

2

2-digit copyright year

9

Edition

2

Edition Number – 1 if not present

10

Comment

25

Free form text comment

11

Cost New

6

Currency format, max 999.99

12

Suggested Retail New

6

Currency format, max 999.99

13

Currency Code

3

CAD or USD – default USD if not present

14

Status

2

Publishing Status Code See Chart

15

Status Date

8

YYYYMMDD – default 19700101,
YYYY0101 or YYYYMM01