Reference Field Links table in SQL Database

[#1]

Hi community!

where the Reference Field Links are stored in the SQL database for SAP Business One, (the SQL table name)
Modules > Administration > Setup > General > Reference Field Links

Thanks,

[azizelmir]

Hi Kenan,

Please try to get them from ORLD and RLD1.

Thank you,

Aziz

[kenan_jaddeny]

Hi Aziz,

Thanks for your reply, I know that the Reference Field Links are stored in the ORLD but wondering about the References in the Header and Row sections, after double click on one of the references in the AR Invoices, or other stuff, as in SAP B1 9.3 PL10, by default we have 3 references for header and another 3 for rows, where are theses field stored in SQL, and how we can increase them,

Best Regards,

[azizelmir]

the References in the Row sections are stored on the table RLD1

[jitin_chawla]

Hi,

The list which you can see on the Module > Administration > Setup > General > Reference Field Links can be checked using

Select * from ORLD

You can run the query in the MSSQL and see.

regards,

Jitin C

[kenan_jaddeny]

Hi Jitin,

Thanks for your reply, I know that the Reference Field Links are stored in the ORLD but wondering about the References in the Header and Row sections, after double click on one of the references in the AR Invoices, or other stuff, as in SAP B1 9.3 PL10, by default we have 3 references for header and another 3 for rows, where are theses field stored in SQL, and how we can increase them,

Best Regards,