Skip to main content
Question

Data model of the sales contracts

  • July 28, 2022
  • 1 reply
  • 113 views

Kamani Dissanayake
Do Gooder (Employee)
Forum|alt.badge.img+5

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

Forum|alt.badge.img+9
  • Hero (Employee)
  • 79 replies
  • July 28, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings