Unable to understand the few columns in IGN1 sheet while uploading GR document through DTW

[Underdog]

Hello Community ,

I am going to upload few transaction of Goods Receipt document and currently using the sheet for the table IGN1, here it showing in the first column showing "parent key" and the second is showing the "line number". 

Please let me know the meaning of this 2 columns 

[Simo_Anddam · Accepted solution]

Hi,

The "Parent Key" and "Line Number" columns in the sheet for the IGN1 table of SAP Business One represent specific relationships between the goods receipt document and its line items:

Parent Key: This is the unique ID of the Goods Receipt document (header). It tells which document the line belongs to.
Line Number: This is the position of each item or detail in the document, starting from 0 for the first line.

Parent Key (DocEntry)	DocNum	Line Number	Item Code	Quantity
101	GR001	0	A001	10
101	GR001	1	B002	5
102	GR002	0	C003	15

Parent Key (DocEntry): For example, 101 refers to the document with document number GR001.

Line Number: Within GR001, line 0 represents the first item (A001, quantity 10), and line 1 represents the second item (B002, quantity 5).

DocEntry 102: Refers to a separate document (GR002), with a single line item (C003, quantity 15).

Hope this helps!
Best regards,
Si mohamed ANDDAM