CMR_AP_FINANCIAL_OPTIONS_GT
This table stores default exchange rate type defined in payables financial options UI. This is used to calculate the ledger amount in global procurement POs in receipt accounting. Functinal - OBSOLTE
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments | Status |
|---|---|---|---|---|---|
| DEFAULT_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Default Exchange rate Type defined in Payable Financial options | Active | |
| LEDGER_ID | NUMBER | 18 | ledger of the profit center business unit and to post general entries. | Active | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Business Unit Id of the Inventory Organization. | Active |
Indexes
| Index | Uniqueness | Columns | Status |
|---|---|---|---|
| CMR_AP_FINANCIAL_OPTIONS_GT_PK | Unique | LEDGER_ID, BUSINESS_UNIT_ID, DEFAULT_EXCHANGE_RATE_TYPE | Active |