Attribute Mappings for VRM_SOURCE_DOCUMENT
A separate revenue document (VRM_SOURCE_DOCUMENT) is created per product line.
If multiple product lines within a subscription have the same external root asset key, those product lines are grouped into one revenue document.
This table shows the attribute mappings:
| VRM_SOURCE_DOCUMENT Attribute (Target) | Value (Source) | Comments |
|---|---|---|
| APPLICATION_ID | 10563 | Hard Coded |
| BILL_TO_CUSTOMER_ID | OSS_SUBSCRIPTIONS.BILL_TO_ACCT_ID | Subscription Bill-To Account ID |
| BILL_TO_CUSTOMER_SITE_ID |
customer account site ID for OSS_SUBSCRIPTIONS.BILL_TO_SITE_USE_ID |
hz_cust_site_uses_all.cust_acct_site_id where site_use_id = OSS_SUBSCRIPTIONS.BILL_TO_SITE_USE_ID |
| CREATED_BY | fnd_global.user_name | Current User |
| CREATION_DATE | sysdate | Current System Date |
| CURRENCY_CODE | OSS_SUBSCRIPTIONS.CURRENCY | Subscription Currency |
| CUST_PO_NUMBER | OSS_SUBSCRIPTIONS.PO_NUMBER | Subscription PO Number |
| DATA_TRANSFORMATION_STATUS | 'FUSION_INIT' | Hard Coded |
| DOC_ID_INT_1 | OSS_SUBSCRIPTIONS.SUBSCRIPTION_ID | Subscription ID |
| DOC_ID_INT_2 | VRM_SOURCE_DOCUMENTS_S.currval | Same value as DOCUMENT_ID |
| DOCUMENT_CREATION_DATE | sysdate | Current System Date |
| DOCUMENT_DATE | OSS_SUBSCRIPTIONS.START_DATE | Subscription Start Date |
| DOCUMENT_ID | VRM_SOURCE_DOCUMENTS_S.nextval | Primary Key based on VRM Sequence |
| DOCUMENT_NUMBER | OSS_SUBSCRIPTIONS.SUBSCRIPTION_NUMBER | Subscription Number |
| DOCUMENT_TYPE | 'FUSION_OSS' | Hard Coded |
| DOCUMENT_TYPE_ID | 10 | Hard Coded |
| DOCUMENT_UPDATE_DATE | sysdate | Current System Date |
| LAST_UPDATE_DATE | sysdate | Current System Date |
| LAST_UPDATE_LOGIN | fnd_global.session_ID | Current Session ID |
| LAST_UPDATED_BY | fnd_global.user_name | Current User |
| LEGAL_ENTITY_ID | OSS_SUBSCRIPTIONS.LEGAL_ENTITY_ID | Subscription Legal Entity ID |
| ORG_ID | OSS_SUBSCRIPTIONS.BUSINESS_UNIT_ID | Subscription Business Unit ID |
| SOURCE_SYSTEM | 'FUSION' | Hard Coded |
| SRC_ATTRIBUTE_CHAR1 | OSS_SUBSCRIPTIONS.SUBSCRIPTION_ID | Subscription Number, Same value as DOCUMENT_NUMBER |
| EXCHANGE_RATE | CURR_CONVERSION_RATE | Conversion rate |
| EXCHANGE_DATE |
CURR_CONVERSION_RATE_DATE
|
Date considered for conversion rate |
| EXCHANGE_RATE_TYPE |
CURR_CONVERSION_RATE_TYPE
|
Conversion rate type: Daily, Fixed;etc. |