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: ASO_SHIPMENTS

Product:	ASO - Order Capture
Description:	ASO_SHIPMENTS store shipping information for a quote at header level or line level.
Implementation/DBA Data:	ASO.ASO_SHIPMENTS

Primary Key: ASO_SHIPMENTS_PK

SHIPMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
ASO_SHIPMENTS	ASO_QUOTE_HEADERS_ALL	ASO_SHIPMENTS.QUOTE_HEADER_ID
ASO_SHIPMENTS	ASO_QUOTE_LINES_ALL	ASO_SHIPMENTS.QUOTE_LINE_ID
ASO_SHIPMENTS	HZ_PARTIES	ASO_SHIPMENTS.SHIP_TO_CUST_PARTY_ID
ASO_SHIPMENTS	HZ_PARTIES	ASO_SHIPMENTS.SHIP_TO_PARTY_ID
ASO_SHIPMENTS	HZ_PARTY_SITES	ASO_SHIPMENTS.SHIP_TO_PARTY_SITE_ID
ASO_FREIGHT_CHARGES	ASO_SHIPMENTS	ASO_FREIGHT_CHARGES.QUOTE_SHIPMENT_ID
ASO_PAYMENTS	ASO_SHIPMENTS	ASO_PAYMENTS.QUOTE_SHIPMENT_ID
ASO_PRICE_ADJUSTMENTS	ASO_SHIPMENTS	ASO_PRICE_ADJUSTMENTS.QUOTE_SHIPMENT_ID
ASO_PRICE_ADJ_RELATIONSHIPS	ASO_SHIPMENTS	ASO_PRICE_ADJ_RELATIONSHIPS.QUOTE_SHIPMENT_ID
ASO_QUOTE_LINE_ATTRIBS_EXT	ASO_SHIPMENTS	ASO_QUOTE_LINE_ATTRIBS_EXT.QUOTE_SHIPMENT_ID
ASO_QUOTE_PARTIES	ASO_SHIPMENTS	ASO_QUOTE_PARTIES.QUOTE_SHIPMENT_ID
ASO_TAX_DETAILS	ASO_SHIPMENTS	ASO_TAX_DETAILS.QUOTE_SHIPMENT_ID
CS_LINE_INST_DETAILS	ASO_SHIPMENTS	CS_LINE_INST_DETAILS.QUOTE_LINE_SHIPMENT_ID
JAI_CRM_QUOTE_TAXES	ASO_SHIPMENTS	JAI_CRM_QUOTE_TAXES.SHIPMENT_ID