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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OE.SO_FREIGHT_CHARGES

Object Details

Object Name:	SO_FREIGHT_CHARGES
Object Type:	TABLE
Owner:	OE
FND Design Data:	OE.SO_FREIGHT_CHARGES
Subobject Name:
Status:	VALID

SO_FREIGHT_CHARGES stores the freight charges you assign to a
shipment.
FREIGHT_CHARGE_TYPE_ID indicates the type of each
freight charge, and PICKING_HEADER_ID indicates the shipment to
which each freight charge has been applied. AMOUNT stores the actual
monetary charge value for the shipment and may or may not be the
original amount
associated with the freight charge type.
This table corresponds to the Freight Charges window.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SO_FREIGHT_CHARGES_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	FREIGHT_CHARGE_ID
SO_FREIGHT_CHARGES_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	PICKING_HEADER_ID
SO_FREIGHT_CHARGES_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	DELIVERY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERCO_INVOICE_STATUS	VARCHAR2	(15)		Future use
FREIGHT_CHARGE_ID	NUMBER		Yes	System-generated identifier of the freight charge
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
FREIGHT_CHARGE_TYPE_ID	NUMBER		Yes	Type of freight charge
PICKING_HEADER_ID	NUMBER			Associated picking header (pick slip)
AMOUNT	NUMBER			Actual freight amount charged on the shipment
CURRENCY_CODE	VARCHAR2	(15)		Currency of the freight charge
CONVERSION_DATE	DATE			Date of currency conversion
CONVERSION_RATE	NUMBER			Rate of currency conversion
CONVERSION_TYPE_CODE	VARCHAR2	(30)		Currency conversion type
INVOICE_STATUS	VARCHAR2	(15)		Indicates whether the freight charge has been invoiced
CONTEXT	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
DELIVERY_ID	NUMBER			Foreign key to WSH_DELIVERIES
CONTAINER_ID	NUMBER			Foreign key to WSH_PACKED_CONTAINERS
PICKING_LINE_DETAIL_ID	NUMBER			Foreign key to SO_PICKING_LINE_DETAILS
AC_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Additional Charges descriptive flexfield structure defining column
AC_ATTRIBUTE1	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE2	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE3	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE4	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE5	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE6	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE7	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE8	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE9	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE10	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE11	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE12	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE13	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE14	VARCHAR2	(150)		Additional Charges descriptive flexfield segment
AC_ATTRIBUTE15	VARCHAR2	(150)		Additional Charges descriptive flexfield segment

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERCO_INVOICE_STATUS
,      FREIGHT_CHARGE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FREIGHT_CHARGE_TYPE_ID
,      PICKING_HEADER_ID
,      AMOUNT
,      CURRENCY_CODE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CONVERSION_TYPE_CODE
,      INVOICE_STATUS
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DELIVERY_ID
,      CONTAINER_ID
,      PICKING_LINE_DETAIL_ID
,      AC_ATTRIBUTE_CATEGORY
,      AC_ATTRIBUTE1
,      AC_ATTRIBUTE2
,      AC_ATTRIBUTE3
,      AC_ATTRIBUTE4
,      AC_ATTRIBUTE5
,      AC_ATTRIBUTE6
,      AC_ATTRIBUTE7
,      AC_ATTRIBUTE8
,      AC_ATTRIBUTE9
,      AC_ATTRIBUTE10
,      AC_ATTRIBUTE11
,      AC_ATTRIBUTE12
,      AC_ATTRIBUTE13
,      AC_ATTRIBUTE14
,      AC_ATTRIBUTE15
FROM OE.SO_FREIGHT_CHARGES;

Dependencies

[top of page]

OE.SO_FREIGHT_CHARGES does not reference any database object

OE.SO_FREIGHT_CHARGES is referenced by following:

OE: SO_FREIGHT_CHARGES#