Navigation:  Sales > Technical References >   Sales Orders tables

ProductPrice

Maintains standard Prices by Product by Customer Price Class by Quantity.

 

ProductCustomer

Maintains common data for Customer-specific Product pricing.

 

ProductCustomerPrice

Maintains Customer-specific Product pricing based on Product by Customer by Quantity.

 

SalesOrder

Each Sales 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 Sales Order, then that Sales Order is set to not Active.

 

SalesOrderDetail

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

When its OnOrderQuantity becomes 0 then it is not Active.

 

SalesInvoice

Master records for Sales Invoices and Sales Credit Notes generated through Sales.

Transactions remain in the SalesInvoice and SalesInvoiceDetail tables until they are Archived.

 

SalesInvoiceDetail

Detail records for Sales Invoices and Sales Credit Notes.

 

ShipTo

Each unique ShipTo location for a Customer has a record in this table.

 

SalesRep

Each Sales Representative has a record in this table.

 

SalesTax

Each unique Sales Tax category has a record in this table.

 

SalesDiscount

Sales Discount rates.

Specifies line item sales discount rate based on Customer Disount Group and Product Discount Group.

Its use is optional.

 

SalesCommission

Sales Commission rates.

Specifies line item sales commission rate based on SalesRep Commission Group and Product Commission Group.

Its use is optional.

 

SoImport, SoImportDetail

Sales Order import tables.