Is B1 using Header and Detail Structure for database?

[Former Member]

i am a new user of B1 and have chance to read the database

Is B1 using Header and Detail Structure for database? as i see table name end with h and d

if so, why using Header and Detail structure? where is like relational database ?

Any resources about the data dictionary about describing the field name of each table?

[KennedyT21]

HI Ho Yeung Lee,

You can get thehelp file from https://websmp109.sap-ag.de/smb/sbocustomer

SAP Business One SDK 8.8 - Database Tables Reference Help file

Regards

Kennedy

[Former Member]

it need login and password, i do not know login and password, any one uploaded it to a free place

[KennedyT21]

If you are customer you can get the Login ID from your Partner

Regards

Kennedy

[former_member184718]

Hi,

The best available to find this info is from SDK help file REFDB.CHM.

You can also refer Gordon Du's  'Mastering SQL Queries for SAP Business One'  which may give you  a better hint.

Log in into SAP - Query generator, Press Tab on Yellow fields and this will display thh list of Table with its description.

Thanks.

Hari