Question

Data model of the sales contracts

  • 28 July 2022
  • 1 reply
  • 95 views

Userlevel 3
Badge +3

Is it possible to get a datamodel of the sales contracts (Contract Management > Sales Contract > Sales Contract) and also of the revision and items  (Contract Management > Sales Contract > Sales Contract Revision and Items)

Here need to know what are the tables use for sales contract and what is the relationship between those tables


1 reply

Userlevel 3
Badge +9

Hi Kamani

The table view names you can find in IEE via the system info:

 

In essence,

  • A sales contract has multiple revisions (CONTRACT_REVISION)
  • A revision ha multiple Lines (CONTRACT_LINE)
  • A line has multiple Items (CONTRACT_ITEM)

But a contract also has, multiple customers (CONTRACT_CUSTOMER), multiple projects connected (CONTRACT_PROJECT), multiple tasks (CONTRACT_TASK) and so on

Hope this helps a bit

Regards Erik

 

Reply