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: GML.OP_CHRG_MST

Object Details

Object Name:	OP_CHRG_MST
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_CHRG_MST
Subobject Name:
Status:	VALID

This table holds the definition of a charge. Charges are assigned types (freight, discount, etc.) and, optionally, a tax class. Base charge amounts or rates are also defined and the type of calculation: Per unit is based on the order or order line quantity, Percentage is based on the order or order line value/amount and Flat Amount is a flat value that is applied. Charge breaks are defined and stored in the table OP_CHRG_BRK. To automatically apply a charge to an order, a charge effectivity for an Organization (and, optionally, a customer or customer class) must be defined. This information is stored in the OP_PRCE_EFF table. To automatically apply a charge to an order line, a customer/item association is defined in the table OP_CHRG_ITM. Charges can also be manually entered on an order.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_CHRG_MSTI1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHARGE_CODE
OP_CHRG_MST_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHARGE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHARGE_ID	NUMBER	(10)	Yes	Surrogate key for charge code
CHARGE_CODE	VARCHAR2	(32)	Yes	Code which uniquely identifies a charge.
CHARGE_DESC	VARCHAR2	(70)	Yes	Ancillary charge code description
CHARGE_TYPE	NUMBER	(5)	Yes	Grouping of charges for reporting purposes; values are: 0 = miscellaneous; 1 = freight, 10 = taxes, 20 = discounts, 30 = allowances
CURRENCY_CODE	VARCHAR2	(4)	Yes	Default currency code corresponding to base_amount; FK to gl_curr_mst, optional field unless base_amount entered.
CHGTAX_CLASS	VARCHAR2	(8)		For tax calculation purposes; tax class for ancillary charges; FK to op_chrg_cls.
BASE_RATE	NUMBER			Default rate/percent, optional field
BASE_AMOUNT	NUMBER			Default flat amount, optional field. If entered, must designate currency code.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	0 means active record; 1 means "deleted" record
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
BASE_PER_UNIT	NUMBER			Default per unit amount, optional field. If entered, must enter charge uom and currency code.
CHARGE_UOM	VARCHAR2	(4)		Unit of measure which corresponds to base_per_unit amount.
BREAKPRICE_TYPE	NUMBER	(5)	Yes	Type of breakprices, if charge has pricebreaks. Value of 0 = only base amounts/percentages defined; 1 = base amount/percent for pricebreak overrides base amount for charge; 2 = percent will be added/subtracted to base amount; 3 = unit price or percentage change will be added/subtract to base amount
BREAK_TYPE	NUMBER	(5)	Yes	Indicates the type of breakpoints used. Value of 0 = there are no quantity or value breaks for this charge; 1 = quantity breaks have been established; 2 = value breaks have been established.
ALLOCATION_METHOD	NUMBER	(5)	Yes	Method to allocate charge if assigned at the total order level. Allocation rules will be established in a separate table (for future use).
CALCULATION_TYPE	NUMBER	(5)	Yes	Default calculation type for charge; valid calculation types are: 1 = percent, 2 = per unit and 3 = flat amount
LINECHARGE_IND	NUMBER	(5)	Yes	Indicates if charge is a line item charge or a total order charge. Value of 1 means charge is a line item charge and can only be added to an order or profile line. Value of 0 means charge can be applied to the entire order or profile.
BILLABLE_IND	NUMBER	(5)	Yes	Indicates if charge is billed to customer. Valid values are: 0 means that charge is not billed to bill-to customer; 1 means that charge is billed to and paid by the bill-to customer. Default is 0.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment

Query Text

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


SELECT CHARGE_ID
,      CHARGE_CODE
,      CHARGE_DESC
,      CHARGE_TYPE
,      CURRENCY_CODE
,      CHGTAX_CLASS
,      BASE_RATE
,      BASE_AMOUNT
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      BASE_PER_UNIT
,      CHARGE_UOM
,      BREAKPRICE_TYPE
,      BREAK_TYPE
,      ALLOCATION_METHOD
,      CALCULATION_TYPE
,      LINECHARGE_IND
,      BILLABLE_IND
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
FROM GML.OP_CHRG_MST;

Dependencies

[top of page]

GML.OP_CHRG_MST does not reference any database object

GML.OP_CHRG_MST is referenced by following:

GML: OP_CHRG_MST#