Navigation:  Purchasing > Technical References >   Purchasing tables

PurchaseOrder

Each Purchase Order has a record in this table. That record contains information common to the entire order.

When there are no longer any active Detail items for a Purchase Order, then that Purchase Order is set to not Active.

 

PurchaseOrderDetail

Each active Product or Service line item on a Purchase Order has a record in this table.

When its OnOrderQuantity becomes 0 then it is set to not Active.

 

PoReceipt

Master records for Purchase Order Receipts.

 

PoReceiptDetail

Detail records for Purchase Order Receipts.

 

ProductSupplier

Maintains common data for Supplier-specific Product pricing.

Supports multiple Suppliers for a Product.

 

ProductSupplierPrice

Maintains Supplier Prices for Product based on Product by Supplier by Quantity.

 

PoImport, PoImportDetail

Purchase Order import tables.