Skip to main content
Question

Data model of the sales contracts

  • July 28, 2022
  • 1 reply
  • 118 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

E
Hero (Employee)
Forum|alt.badge.img+9
  • EriLNL
  • Hero (Employee)
  • 86 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

 


Terms & ConditionsCookie settingsAccessibility statement