Target and base document

[Former Member]

Hi all!

In SQL table, i need to find the table storge information of Target and base document.

For example: I have Good Reciept document number 3, What table will storge information of target document is A/P invoice.

[marcella_rivi · Accepted solution]

Dear Tien,

Also, in order to find the target document you can look for the fields T0.TargetType, T0.TrgetEntry in a table of a document.

The first will tell you the type of document created, the second the document number. Please note that the type document is identified by numbers: e.g. 13 is an ar invoice.

the full list can be found in the sdk help file.

Kind Regards,

Marcella Rivi

SAP Business One Forums Team

[Former Member]

hi there,

for example u got an invoice and search for the base document. you may have a look in the INV1 table in the column "Baseref". The column "BaseRef" is in other tables the correct reference field, too.

regards