Exporter - Purchase Order Items

Field

Description

Min Sage Version

Data Type

Length

ORDER_NUMBER

Order Reference number

10

Int32

4

ITEM_NUMBER

Item number

10

Int32

2

JOB_NUMBER

Job number

10

String

60

SERVICE_FLAG

Product or Service item flag

10

Boolean

2

DESCRIPTION

Description

10

String

60

TEXT

Service item text

10

String

32767

STOCK_CODE

Stock code

10

String

30

COMMENT_1

Comment 1

10

String

60

COMMENT_2

Comment 2

10

String

60

UNIT_OF_SALE

Unit of sale

10

String

8

QTY_ORDER

Quantity ordered

10

Double

8

QTY_ALLOCATED

Quantity allocated for this order

10

Double

8

QTY_DELIVERED

Quantity previously delivered for this order

10

Double

8

QTY_DESPATCH

Quantity to despatch/despatched on this delivery

10

Double

8

QTY_LAST_DESPATCH

Quantity despatched on most recent delivery

11

Double

8

FOREIGN_UNIT_PRICE

Unit price

10

Double

8

FOREIGN_DISCOUNT_AMOUNT

Discount amount

10

Double

8

UNIT_PRICE

Unit price

10

Double

8

DISCOUNT_AMOUNT

Discount amount

10

Double

8

DISCOUNT_RATE

Discount percentage rate

10

Double

8

DELIVERY_DATE

Delivery date

10

Date

2

NOMINAL_CODE

Nominal code

10

String

8

DEPT_NUMBER

Department number

10

Int32

2

DEPT_NAME

Department name

10

String

60

TAX_CODE

Tax code (T0 to T99)

10

String

3

ADD_DISC_RATE

Additional discount percentage rate

10

Double

8

TAX_RATE

Tax rate

10

Double

8

FULL_NET_AMOUNT

Full net amount (before discount)

10

Double

8

NET_AMOUNT

Net amount (after discount)

10

Double

8

TAX_AMOUNT

Tax amount

10

Double

8

GROSS_AMOUNT

Gross amount (net after discount + tax)

10

Double

8

FOREIGN_FULL_NET_AMOUNT

Full net amount (before discount)

10

Double

8

FOREIGN_NET_AMOUNT

Net amount (after discount)

10

Double

8

FOREIGN_TAX_AMOUNT

Tax amount

10

Double

8

FOREIGN_GROSS_AMOUNT

Gross amount (net after discount + tax)

10

Double

8

THIS_RECORD

Record number

12

Int32

4

POP_ITEM_ID

Unique pop item identifier

2008

Int32

4

QTY_ALLOCATED_TO_PROJECT

Quantity allocated to project

12

Double

8

QTY_ISSUED_TO_PROJECT

Quantity issued to project

12

Double

8

DUE_DATE

Due date

12

Date

2

QTY_COMMITTED_TO_PROJECT

Quantity committed to project (for committed cost calculation)

13

Double

8

PROJECT_REF

Reference for associated project

13

String

12

PROJECT_NAME

Name of associated project

13

String

60

COST_CODE_REF

Reference for associated cost code

13

String

8

ITEMID*

Item ID

2008

Int32

4

GENERATED_MESSAGE

True if this message was automatically generated

2008

Int32

2

RECORD_CREATE_DATE

Date and time when the record was created.

2009

Date

8

RECORD_MODIFY_DATE

Date and time when the record was modified.

2009

Date

8

RECORD_DELETED

Flag denoting if the record has been deleted or not.

2009

Boolean

2

 

* Denotes the primary key field used to distinguish unique records, please not that Sage only exposes the ItemID field from version 2008 onwards. previous version had no primary key.