Attribute Mappings for VRM_SOURCE_DOC_SUB_LINES
After a revenue document line is created for one-time charges, a satisfaction entry is created for it in VRM_SOURCE_DOC_SUB_LINES.
A revenue document line is created one-to-one for each revenue document line created (for
one time charges), in other words, Charge Type = ONE_TIME or
ORA_ONE_TIME.
This table shows the attribute mappings:
| VRM_SOURCE_DOC_SUB_LINES Attribute (Target) | Value (Source) | Comments |
|---|---|---|
| DOCUMENT_SUB_LINE_ID | VRM_SOURCE_DOC_SUB_LINES_S.NEXTVAL | Primary Key based on VRM Sequence |
| ORG_ID | OSS_SUBSCRIPTIONS.BUSINESS_UNIT_ID | Subscription Business Unit ID |
| DOC_SUB_LINE_LEVEL | 'L' | Hard Coded |
| SUB_LINE_CREATION_DATE | sysdate | Current System Date |
| SUB_LINE_LAST_UPDATE_DATE | sysdate | Current System Date |
| DOCUMENT_TYPE_ID | 10 | Hard Coded |
| DOC_SUB_LINE_TYPE | 'ORA_SATIS_EVENT_SMM_QUANTITY' | Hard Coded |
| DOC_LINE_ID_CHAR_1 | VRM_SOURCE_DOC_LINES.DOCUMENT_LINE_ID | Foreign Key to the parent table |
| DOC_SUB_LINE_ID_INT_1 | VRM_SOURCE_DOC_SUB_LINES_S.CURRVAL | Same value as DOCUMENT_SUB_LINE_ID |
| SOURCE_SYSTEM | 'FUSION' | Hard Coded |
| SATISFACTION_MEASUREMENT_DATE | OSS_PRODUCTS.START_DATE | Product Line Start Date |
| SATISFACTION_EVENT_QUANTITY | OSS_PRODUCTS.QUANTITY | Product Quantity |
| DATA_TRANSFORMATION_STATUS | 'FUSION_INIT' | Hard Coded |
| CREATED_BY | fnd_global.user_name | Current User |
| CREATION_DATE | sysdate | Current System Date |
| LAST_UPDATED_BY | fnd_global.user_name | Current User |
| LAST_UPDATE_DATE | sysdate | Current System Date |
| LAST_UPDATE_LOGIN | fnd_global.session_id | Current Session ID |