ITEMNMBR

string

30

Y

Not applicable

Item number

VENDORID

string

15

Y

Not applicable

Vendor ID

VNDITNUM

string

30

N

<blank>

Vendor item number

QTYRQSTN

number

21

N

0

Quantity requisitioned

AVRGLDTM

i4

4

N

0

Average lead time

NORCTITM

i4

2

N

0

Number of receipts for item

MINORQTY

number

21

N

0

Minimum order quantity

MAXORDQTY

number

21

N

0

Maximum order quantity

ECORDQTY

number

21

N

0

Economic order quantity

VNDITDSC

string

100

N

<blank>

Vendor item description

Last_Originating_Cost

number

21

N

0.01

Last originating cost

Last_Currency_ID

string

15

N

<blank>

Last currency ID

FREEONBOARD

i4

2

N

1

Free on board:

1=None;

2=Origin;

3=Destination

PRCHSUOM

string

8

N

<blank>

Purchasing unit of measure

PLANNINGLEADTIME

i4

2

N

0

Planning lead time

ORDERMULTIPLE

number

21

N

1

Order multiple

MNFCTRITMNMBR

string

30

N

<blank>

Manufacturer’s item

UpdateIfExists

i4

1

N

1

Flag to allow item vendor information to be updated if it exists:

0=No;

1=Yes

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

1=True (if True, it populates requester shadow table)

USRDEFND1

string

50

N

<blank>

User-defined field—developer use only

USRDEFND2

string

50

N

<blank>

User-defined field—developer use only

USRDEFND3

string

50

N

<blank>

User-defined field—developer use only

USRDEFND4

string

8000

N

<blank>

User-defined field—developer use only

USRDEFND5

string

8000

N

<blank>

User-defined field—developer use only