[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
GML.OP_CHRG_MST does not reference any database object
GML.OP_CHRG_MST is referenced by following:
|
|
|