Purchase Card Info AUX Record (PIR) Private Use

Field Name

L

Position

F

S

Remarks

Record Type

3

1-3

A

M

Always PIR

Data Record Sequence Number

9

4-12

N

M

Increment by 1 per data record

Line Sequence Number

3

13-15

N

M

Contains the line number for this item (001 to 010).

Valid values are 001-010 only.

Product ID

15

16-30

A

O

Contains the Product Code of the item purchased.

Item Quantity

12

31-42

N

O

Indicates the quantity of the item purchased and the associated decimal point location. Four decimal places are implied.

Item Unit of Measure

12

43-54

A

O

Indicates which unit of measure is used to convey one item.Allowed values are Liter, Kilo, Gallon, Pound, Pieces.

Unit Price

12

55-66

N

O

Contains the price per unit. Four decimal places are implied (including tax).

Extended Item Amount

12

67-78

N

O

Amount is denoted in the transaction currency. Two decimal places are implied. The net-price multiplied by quantity.

Tax Amount

12

79-90

N

C

Contains amount of sales tax or value added tax (VAT) on the purchase amount. Amount is denoted in the transaction currency. Two decimal places are implied.

Tax Rate

6

91-96

N

C

Four decimal places are implied, e.g. 25% = 250000

Line Item Total Amount

12

97-108

N

O

Attribute contains the total gross amount with discount and inclusive of tax (VAT). Amount is denoted in the transaction currency. Two decimal places are implied.

Line Item Date

8

109-116

N

O

YYYYMMDD

Corporate Contract Number

40

117-156

A

O

Attribute contains the corporate contract number.

Transaction Type

2

157-158

N

M

Value Description

00

Purchase (Debit)

01

Refund (credit)

Filler

292

159-450

A

M

Space-fill