OSS_REVENUE_PROCESS_GT
This table stores temporary rmcs data
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_LINE_ID | NUMBER | 18 | Yes | DOCUMENT_LINE_ID | |
| DOCUMENT_ID | NUMBER | 18 | DOCUMENT_ID | ||
| DOCUMENT_TYPE_ID | NUMBER | 18 | Unique identifier of a source document type in Oracle Revenue Management Cloud. | ||
| DOCUMENT_KEY | VARCHAR2 | 120 | DOCUMENT_KEY | ||
| SUBSCRIPTION_NUMBER | VARCHAR2 | 120 | SUBSCRIPTION_NUMBER | ||
| SUBSCRIPTION_ID | NUMBER | 18 | SUBSCRIPTION_ID | ||
| SUBSCRIPTION_START_DATE | DATE | SUBSCRIPTION_START_DATE | |||
| CURRENCY | VARCHAR2 | 15 | CURRENCY | ||
| SUBSCRIPTION_PO_NUMBER | VARCHAR2 | 50 | SUBSCRIPTION_PO_NUMBER | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | BUSINESS_UNIT_ID | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | LEGAL_ENTITY_ID | ||
| SUBSCRIPTION_BILL_TO_ACCOUNT | NUMBER | 18 | SUBSCRIPTION_BILL_TO_ACCOUNT | ||
| CURR_CONVERSION_RATE | NUMBER | Currency conversion rate used for the conversion of subscription value from the subscription transactional currency to the functional currency of the business unit. | |||
| CURR_CONVERSION_RATE_TYPE | VARCHAR2 | 30 | Currency conversion rate type used for the conversion of subscription value from the subscription transactional currency to the functional currency of the business unit. | ||
| CURR_CONVERSION_RATE_DATE | DATE | The date as of which the currency conversion rate is effective. This attribute is required only for fixed date currency conversions. | |||
| DURATION | NUMBER | Subscription product duration represented in charge UOM. | |||
| SUBSCRIPTION_PRODUCT_PUID | VARCHAR2 | 120 | SUBSCRIPTION_PRODUCT_PUID | ||
| SUBSCRIPTION_PRODUCT_ID | NUMBER | 18 | SUBSCRIPTION_PRODUCT_ID | ||
| EXTERNAL_ROOT_ASSET_KEY | VARCHAR2 | 120 | EXTERNAL_ROOT_ASSET_KEY | ||
| EXTERNAL_ASSET_KEY | VARCHAR2 | 120 | EXTERNAL_ASSET_KEY | ||
| ITEM_UOM | VARCHAR2 | 15 | ITEM_UOM | ||
| QUANTITY | NUMBER | QUANTITY | |||
| PRODUCT_NUMBER | VARCHAR2 | 300 | PRODUCT_NUMBER | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | INVENTORY_ITEM_ID | ||
| DEFINITION_ORG_ID | NUMBER | 18 | DEFINITION_ORG_ID | ||
| ACCOUNTING_RULE_ID | NUMBER | 18 | ACCOUNTING_RULE_ID | ||
| PRODUCT_PO_NUMBER | VARCHAR2 | 50 | PRODUCT_PO_NUMBER | ||
| PRODUCT_BILL_TO_ACCOUNT | NUMBER | 18 | PRODUCT_BILL_TO_ACCOUNT | ||
| PRODUCT_ASSOCIATION_ID | NUMBER | 18 | PRODUCT_ASSOCIATION_ID | ||
| CHARGE_ID | NUMBER | 18 | CHARGE_ID | ||
| CHARGE_NAME | VARCHAR2 | 120 | CHARGE_NAME | ||
| PRICE_TYPE | VARCHAR2 | 30 | PRICE_TYPE | ||
| PRICE_PERIODICITY | VARCHAR2 | 30 | PRICE_PERIODICITY | ||
| SATISFACTION_MODEL | VARCHAR2 | 50 | SATISFACTION_MODEL | ||
| SUBSCRIPTION_BILL_TO_SITE | NUMBER | 18 | SUBSCRIPTION_BILL_TO_SITE | ||
| PRODUCT_BILL_TO_SITE | NUMBER | 18 | PRODUCT_BILL_TO_SITE | ||
| REVENUE_START_DATE | DATE | REVENUE_START_DATE | |||
| REVENUE_END_DATE | DATE | REVENUE_END_DATE | |||
| LIST_PRICE | NUMBER | LIST_PRICE | |||
| AMOUNT | NUMBER | AMOUNT | |||
| PERIODIC_RECOGNITION_YN | VARCHAR2 | 1 | Enable Periodic Recognition of One-Time Charges | ||
| ORDER_FULFILL_LINE_ID | NUMBER | 18 | The identifier of the source sales order fulfillment line. | ||
| CHARGE_DEFINITION | VARCHAR2 | 30 | The code defined in Pricing application for the charge of the subscription product. | ||
| SALES_ORDER_ID | NUMBER | 18 | The identifier of the source sales order. | ||
| VERSION_NUMBER | NUMBER | 9 | Version Number. | ||
| BASE_PRICE | NUMBER | Base price per unit of measure of the inventory item or memo line. | |||
| SALESREP_ID | NUMBER | 22 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Character Attribute 13 | ||
| SRC_ATTRIBUTE_NUMBER1 | NUMBER | Number Attribute 1 | |||
| SRC_ATTRIBUTE_NUMBER2 | NUMBER | Number Attribute 2 | |||
| SRC_ATTRIBUTE_NUMBER3 | NUMBER | Number Attribute 3 | |||
| SRC_ATTRIBUTE_NUMBER4 | NUMBER | Number Attribute 4 | |||
| EXTRACTION_STATUS | VARCHAR2 | 30 | Status to indicate if the revenue line from FOM has been interfaced to RMCS | ||
| DOCUMENT_DATE | DATE | Ordered date for the subscriptions originated from FOM |