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 |