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