Skip to main content

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

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


Terms & ConditionsCookie settings