What is the use of 'HeaderReference' field in "Vendor invoice line" data entity

Question Status

Verified
Sangram Shinde asked a question on 18 May 2018 7:43 AM

Hi Techies,

We are looking for field details of 'HeaderReference' in "Vendor invoice line" data entity, this field is mapped with "TableRefId" field of VendInvoiceInfoLine table, but we can't see this on front end (AP>Invoices>Pending vendor invoices) anywhere, when we create a record manually this field gets generated as we can see in table.

Now here is what we are checking for - what is the exact purpose of this field, where we can see this on front end and why it is mandatory in staging table? 

Does anyone have any idea?

Any response is appreciated!

Thanks.

Reply
Verified Answer
André Arnaud de Calavon responded on 18 May 2018 8:15 AM

Hi Sangram,

This value is coming from the System ID number sequence which can be setup on the Legal entity form. It is an internal reference to keep all vendor posting related tables (but also sales posting) together. In fact it is the "primary key" for a vendor invoice or other sales/purchase related update.

Reply
Sangram Shinde responded on 23 May 2018 8:18 AM

Thanks Andre for valuable reply!

Reply
Verified Answer
André Arnaud de Calavon responded on 18 May 2018 8:15 AM

Hi Sangram,

This value is coming from the System ID number sequence which can be setup on the Legal entity form. It is an internal reference to keep all vendor posting related tables (but also sales posting) together. In fact it is the "primary key" for a vendor invoice or other sales/purchase related update.

Reply