add Appointment nbr in SO details.

@sujithra  It seems you created the Custom column in the SODet table to fetch the AppointmentNbr.

To get the Appointment Nbr, you need to join the below tables.

First Join:

SODet (SrvOrderType, RefNbr, SODetID) Join with FSAppointmentDet  (SrvOrderType, OrigSrvOrdNbr, SODetID)

Second Join: 

FSAppointmentDet  (SrvOrderType, RefNbr, AppointmentID) Join with FSAppointment (SrvOrderType, RefNbr,AppointmentID)

From the FSAppointment  table, you will get the Appointment Number, and you can assign it to SODet table.

Hope this helps!

@sujithra  Ok, please follow the Naveen’s comment above it will fetch the appointment No. from the appointment table. 

@sujithra  This is kind of basics, where you need to BQL query to fetch the value from the table and update the caches of the SODet table.

I would highly recommend you to go through the T series - certification, you will get good knowledge and then work on the customizations.

Thankyou so much for your help @Anacarina Calvo. This Kind of response really help the beginners.