cancel
Showing results for 
Search instead for 
Did you mean: 

Datasource

Former Member
0 Kudos

Hi All,

I would like to utilize the database field 'DataSaource found on marketing documents and Master Data.

I see that there are values associated to this field : SELECT *  FROM OCRD T0 WHERE T0.DataSource = '[%0]'

I cannot find this via the DTW, or the DI-API reference files as a field that can be used. I primarily would like to use it for new implementations.

Thanks in advance,

Kiran

Accepted Solutions (0)

Answers (2)

Answers (2)

jitin_chawla
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Datasource field is not available through DTW.

The datasource field is automatically populated with values based on the source through which the data is entered into the database.

If the 'Datasource' field shows 'I' - then its through the application.

If the 'Datasource' field shows 'O' - then its through the DTW or Add-on.

If the 'Databsource' field shows 'N' - then its through the External Source not known.

Kind Regards,

Jitin

SAP Business One Forum Team

Former Member
0 Kudos

Thank you Jitin,

If you run my query above, there is an option for 'P' = Partner Implementation.

How can this be utilized?

Thanks,

Kiran

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Kiran,

Try with OCRD -Business partner template.

Former Member
0 Kudos

Hi Naga,

I have checked this, and also via the SDK DI-API.

Regards,

Kiran

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Kiran,

So you got the answer??

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

No. The import templates do not have this column available, and neither can you do this via the SDK. Hence the reason for me starting this thread.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Kiran,

Are you looking for below information?

Former Member
0 Kudos

Hi Naga,

Correct. That is the field I require.

Please refer to my original post. It has all the relevant information.