Skip to main content
Solved

Import Contract Lines on Request Contract

  • November 25, 2025
  • 5 replies
  • 29 views

Forum|alt.badge.img+1
  • Do Gooder (Customer)

Hi,

Our requirement is to add products to a contract so that we can schedule regular and ad-hoc servicing of the products.
We have imported Request Contracts and Equipment Objects but would like advice on how to import Contract Lines to link the Equipment Objects to the Request Contracts. It looks like we need to import to psc_product_service_item and psc_contr_product but I feel that there is more to it than this.
Any help much appreciated.

Best answer by anmise

The key things are probably these, but it depends a little on your requirements. 

PSC_CONTR_PRODUCT - Request Contract Line

PSC_PRODUCT_SERVICE_ITEM - This is where you define the services for the contract line

PSC_CONTR_PRODUCT_SCOPE - These are your scope lines. This is where you specify your model(s)/object(s) covered by the line.

 

5 replies

Savinda.Tennakoon
Hero (Employee)
Forum|alt.badge.img+8
  • To schedule regular and ad-hoc servicing, you need to:
    1. Create Contract Lines for each product/service item.
    2. Link Equipment Objects to these contract lines.
  • The relevant tables are:
    • PSC_PRODUCT_SERVICE_ITEM – Defines the product/service items for the contract.
    • PSC_CONTR_PRODUCT – Links the product/service item to the contract.
  • Additional steps:
    • Ensure the Equipment Object is connected via the Contract Line (not just the header).
    • Use the Contract Line Import process in IFS Data Migration or REST API to populate these tables correctly.
  • Each contract line must include:

Key Points

  • Importing only into PSC_PRODUCT_SERVICE_ITEM and PSC_CONTR_PRODUCT is not enough.
  • You also need to:
    • Create Contract Line records that reference both the product and the equipment object.
    • Validate that the contract is in Active status before scheduling services.
  • Use Data Migration Jobs or REST API for bulk imports.

  • Superhero (Employee)
  • November 25, 2025

@DaveC what tool are you using to import the data?


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • November 25, 2025

@anmise we are using DMM to migrate. I am not able to find the Contract Line Import process that ​@Savinda.Tennakoon has mentioned.


  • Superhero (Employee)
  • Answer
  • November 25, 2025

The key things are probably these, but it depends a little on your requirements. 

PSC_CONTR_PRODUCT - Request Contract Line

PSC_PRODUCT_SERVICE_ITEM - This is where you define the services for the contract line

PSC_CONTR_PRODUCT_SCOPE - These are your scope lines. This is where you specify your model(s)/object(s) covered by the line.

 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • November 25, 2025

Thanks ​@anmise will try that.