ERP Internals/Data Tables/Purchase Order/Line

This table contains one record for every line on every purchase order.

Used by: Purchasing

Key: Purchase Order Number, Line Number

Fields:

• Purchase Order Number
• Line Number (a unique number assigned by the ERP package)
• Manufacturer's Part Number
• Item Number
• Job Number
• Description (this is commonly multi-line)
• Location
• Drop Ship (Yes/No)
• Quantity
• UOM
• Price
• Tax Code
• Tax Amount
• Extended Amount (Price x Quantity - Tax)
• Weight
• Received (Yes/No)
• Notes