Foreign Keys

Contents

    Foreign Key Relationships

    _ Child File = Parent file_

    ORDERS.O_CCODE = CUSTOMERS.CCODE

    INVOICES.IN_CCODE = CUSTOMERS.CCODE

    ORDERS.O_SHIPVIA_CODE = SHIPVIA.SV_CODE

    ORDER_ITEMS.OI_ORN = ORDERS.ORN

    INVOICE_ITEMS.II_ORN = ORDERS.ORN

    Updated on October 23, 2026