Business Partner ID in Both Order Master and Order Line

[yuanaw]

Dear iDempiere Master

i found C_BPartner_ID appear on Both, C_Order and C_OrderLine.

C_BPartner_ID on C_Order

C_BPartner_ID on C_OrderLine

My Question is...

Why C_BPartner_ID should appear on Both, C_Order and C_OrderLine.

Like M_Product_ID only appear on C_OrderLine and not in C_Order.

i use https://demo.globalqss.com/webui/index.zul 

ThankYou

[Elio Zerpa]

Hello yuanaw

In the case of the C_Order table, the C_BPartner_ID field establishes the relationship with the C_BPartner table and in the case of the C_OrderLine table, the C_BPartner_ID and c_bpartner_location_id fields establish the relationship with the c_bpartner_location table where the shipping address is located. I deduce this from reviewing the relationship between the tables. I don't know if this helps you.

Regards

Elio

[yuanaw]

Hi Elio & iDempiere Master

Thank you for your response.

I am asking this because I intend to create a new window based on a Master/Detail structure.  

Except for Mandatory Columns, that should appears on every table:
ad_client_id => Client Identifier
ad_org_id => Organization Identifier

isactive => Flag to indicate whether the record is active

created => Time when the record was created

createdby => ID of the user who created the record

updated => Time when the record was last updated

updatedby => ID of the user who last updated the record

Our company also uses a proprietary ERP system, QAD/MFG Pro.
When reviewing the master table so_mstr and the detail table sod_det, I noticed that the customer information only appears in the master table, while the detail table contains only the part item.

From my understanding, if C_OrderLine requires information about C_BPartner, it can reference C_Order. Conversely, if C_Order requires information about the product, it can reference C_OrderLine.

Please correct me if I have misunderstood.

Best regards,