CML_TROP_DEPENDENT_CHARGES_GT
This global temporary table will be used to store the dependent charge information for charge basis PERCENTAGE OF OTHER CHARGES. This table will help to calculate the total amount in case of dependent charges.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Surrogate ID that identifies the trade operation charge line being processed. | |
DEPENDENT_TROP_CHARGE_ID | NUMBER | 18 | Surrogate ID which identifies the dependent charge associated to the charge line being processed. | ||
CHARGE_LINE_OVN | NUMBER | 9 | Object version number of the charge line being processed. | ||
ENTERED_AMOUNT | NUMBER | Charge Amount from the dependent charge in currency code of the dependent charge. | |||
NR_TAX | NUMBER | Tax on the dependent charge in estimate currency code of the dependent charges. | |||
CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the amount of dependent charge. | ||
PERCENTAGE | NUMBER | Percentage specified by the user to be applied to the charge amount. | |||
CALCULATED_AMOUNT | NUMBER | Total amount calculated after applying the percentage and converted to charge currency. | |||
CHARGE_CURRENCY_CODE | VARCHAR2 | 15 | Entered currency code fo the charge line being processed. | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | currency conversion type specified on the charge line. | ||
CURRENCY_CONVERSION_DATE | DATE | Currency conversion date specified on the charge line. | |||
CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate from currency code to charge currency code. | |||
DEP_CHRG_LINE_STATUS | VARCHAR2 | 30 | Allocation status of the dependent charge line. | ||
STATUS | VARCHAR2 | 30 | Processing status of this row. Possible values are ERROR and SUCCESS. | ||
ERROR_MESSAGE | VARCHAR2 | 30 | Error message identifying the error that occurred for this charge line. | ||
TOKEN1_NAME | VARCHAR2 | 30 | Token | ||
TOKEN1_VALUE | VARCHAR2 | 240 | Token Value | ||
TOKEN2_NAME | VARCHAR2 | 30 | Token | ||
TOKEN2_VALUE | VARCHAR2 | 240 | Token Value | ||
TOKEN3_NAME | VARCHAR2 | 30 | Token | ||
TOKEN3_VALUE | VARCHAR2 | 240 | Token Value | ||
TOKEN4_NAME | VARCHAR2 | 30 | Token | ||
TOKEN4_VALUE | VARCHAR2 | 240 | Token Value | ||
TOKEN5_NAME | VARCHAR2 | 30 | Token | ||
TOKEN5_VALUE | VARCHAR2 | 240 | Token Value | ||
TOKEN6_NAME | VARCHAR2 | 30 | Token | ||
TOKEN6_VALUE | VARCHAR2 | 240 | Token Value |