The SalesOrder entity is a complex document entity, used to support Sales Orders.


Simple Diagram of the SalesOrder Entity

* the above diagram is NOT complete - for more information see the database schema


Tables of the SalesOrder entity:

  • SalesOrder entity -> includes the tables dbBusinessDocument, dbSalesOrder and dbBusinessDocument_ProductLine


The dbBusinessDocument table includes information about the type of Document, the transactionDate, the numbering etc, fields that are common to all the Sales entities.

Every dbBusinessDocument is linked to a dbBusinesObject record that is linked to a fixed dbSystemObject record.

The dbSystemObject defines the transactions a SalesOrder entity posts and dbBusinessObjects defines the remaining dbBusinessDocuments "behavior" - like the type of systemObject,  print forms, numbering etc


Important notes:

  • dbSalesOrder includes the field nBusinessDocumentPK that is its PK and its FK for the link with dbBusinessDocument,
  • the nPartyFK is in the dbSalesOrder table AND not in the dbBusinessDocument table,
  • dbBusinessDocument_ProductLine is linked to the dbBusinessDocument table and contains the Products of the SalesOrder,
  • the tables that supported VAT in previous releases have been removed.


* Note that SystemObjects are the most important part of the alpha360 apps and control the behavior of the apps.