Part Inventory

This file relates an inventory value to existing Parts.

Column Name
Type
Max Length
Required
Values

PartNumber

text

50

Yes

Must match a valid Part Number, Revision and Location in the parts data

Revision

text

10

No

Location

text

32

No

OnHandInventory

decimal

18.5

Yes

>= 0

IssuedInventory

decimal

18.5

No

>= 0 (defaults to 0)

Date

date

No

SourceErp

text

100

No

BatchId

text

255

No

Last updated