eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: SO_LINES_ALL

Product:	OE - Order Entry
Description:	Order lines
Implementation/DBA Data:	OE.SO_LINES_ALL

Primary Key: SO_LINES_PK

LINE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
SO_LINES_ALL	SO_HEADERS_ALL	SO_LINES_ALL.HEADER_ID
SO_LINES_ALL	%	SO_LINES_ALL.SHIP_TO_CONTACT_ID
SO_LINES_ALL	RA_CUSTOMER_TRX_ALL	SO_LINES_ALL.COMMITMENT_ID
SO_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	SO_LINES_ALL.CREDIT_INVOICE_LINE_ID
SO_LINES_ALL	SO_LINES_ALL	SO_LINES_ALL.PARENT_LINE_ID
SO_LINES_ALL	BOM_INVENTORY_COMPONENTS	SO_LINES_ALL.COMPONENT_SEQUENCE_ID
SO_LINES_ALL	SO_LINES_ALL	SO_LINES_ALL.ATO_LINE_ID
SO_LINES_ALL	SO_LINES_ALL	SO_LINES_ALL.SHIPMENT_SCHEDULE_LINE_ID
SO_LINES_ALL	SO_CYCLES	SO_LINES_ALL.CYCLE_ID
SO_LINES_ALL	SO_AGREEMENTS_B	SO_LINES_ALL.AGREEMENT_ID
SO_LINES_ALL	SO_LINES_ALL	SO_LINES_ALL.SERVICE_PARENT_LINE_ID
SO_LINES_ALL	BOM_BILL_OF_MATERIALS	SO_LINES_ALL.COMPONENT_SEQUENCE_ID
SO_LINES_ALL	SO_PRICE_LISTS_B	SO_LINES_ALL.PRICE_LIST_ID
SO_LINES_ALL	RA_TERMS_B	SO_LINES_ALL.TERMS_ID
SO_LINES_ALL	RA_SITE_USES_ALL	SO_LINES_ALL.SHIP_TO_SITE_USE_ID
SO_LINES_ALL	SO_LINES_ALL	SO_LINES_ALL.LINK_TO_LINE_ID
CST_MARGIN_TEMP	SO_LINES_ALL	CST_MARGIN_TEMP.LINE_ID
CST_MARGIN_TEMP	SO_LINES_ALL	CST_MARGIN_TEMP.PARENT_LINE_ID
CZ_ERRORS	SO_LINES_ALL	CZ_ERRORS.LINE_ID
SO_DROP_SHIP_SOURCES	SO_LINES_ALL	SO_DROP_SHIP_SOURCES.LINE_ID
SO_LINES_ALL	SO_LINES_ALL	SO_LINES_ALL.PARENT_LINE_ID
SO_LINES_ALL	SO_LINES_ALL	SO_LINES_ALL.ATO_LINE_ID
SO_LINES_ALL	SO_LINES_ALL	SO_LINES_ALL.SHIPMENT_SCHEDULE_LINE_ID
SO_LINES_ALL	SO_LINES_ALL	SO_LINES_ALL.SERVICE_PARENT_LINE_ID
SO_LINES_ALL	SO_LINES_ALL	SO_LINES_ALL.LINK_TO_LINE_ID
SO_LINE_APPROVALS	SO_LINES_ALL	SO_LINE_APPROVALS.LINE_ID
SO_LINE_DETAILS	SO_LINES_ALL	SO_LINE_DETAILS.LINE_ID
SO_NOTE_REFERENCES	SO_LINES_ALL	SO_NOTE_REFERENCES.LINE_ID
SO_ORDER_CANCELLATIONS	SO_LINES_ALL	SO_ORDER_CANCELLATIONS.LINE_ID
SO_ORDER_HOLDS_ALL	SO_LINES_ALL	SO_ORDER_HOLDS_ALL.LINE_ID
SO_PICKING_CANCELLATIONS	SO_LINES_ALL	SO_PICKING_CANCELLATIONS.LINE_ID
SO_PICKING_LINES_ALL	SO_LINES_ALL	SO_PICKING_LINES_ALL.ORDER_LINE_ID
SO_PRICE_ADJUSTMENTS	SO_LINES_ALL	SO_PRICE_ADJUSTMENTS.LINE_ID
SO_SALES_CREDITS	SO_LINES_ALL	SO_SALES_CREDITS.LINE_ID