Attribute Mappings for VRM_SOURCE_DOC_LINES
All eligible bill lines for the subscription product line are grouped by charge ID. A separate record is created in VRM_SOURCE_DOC_LINES for each charge ID.
This table shows the attribute mappings:
VRM_SOURCE_DOC_LINES Attribute (Target) | Value (Source) | Comments |
---|---|---|
DOCUMENT_LINE_ID | VRM_SOURCE_DOC_LINES_S.nextval | Primary Key based on VRM Sequence |
DOCUMENT_DATE | OSS_PRODUCTS.START_DATE | Product Start Date |
UOM_CODE | OSS_PRODUCTS.ITEM_UOM | Product Item Unit of Measure |
QUANTITY | NVL(OSS_PRODUCTS.QUANTITY,1) | Product Quantity |
UNIT_SELLING_PRICE | SUM(OSS_BILL_LINES.AMOUNT)/QUANTITY | Unit Price for the charge |
LINE_CREATION_DATE | sysdate | Current System Date |
LINE_LAST_UPDATE_DATE | sysdate | Current System Date |
DOCUMENT_TYPE_ID | 10 | Hard Coded |
DOC_ID_INT_1 | OSS_SUBSCRIPTION.ID | Subscription ID |
DOC_ID_INT_2 | VRM_SOURCE_DOCUMENTS.DOCUMENT_ID | Foreign Key to the parent table |
SOURCE_SYSTEM | 'FUSION' | Hard Coded |
DOC_LINE_ID_CHAR_1 | VRM_SOURCE_DOC_LINES_S.nextval | Same value as DOCUMENT_LINE_ID |
LINE_NUM | OSS_PRODUCTS.PRODUCT_NUMBER | Product Line Number |
LINE_AMOUNT | SUM(OSS_BILL_LINES.AMOUNT) | Total Bill Amount for the charge |
UNIT_SSP | SUM(OSS_BILL_LINES.LIST_PRICE)/QUANTITY | Unit Standard Selling Price for the charge. List Price (excluding automatic and manual adjustments) |
ITEM_ID | OSS_PRODUCTS.INVENTORY_ITEM_ID | Product Item Id |
INVENTORY_ORG_ID | OSS_PRODUCTS.DEFINITION_ORG_ID | Product Definition Org ID |
SATISFACTION_MEASUREMENT_MODEL |
If One Time charge then 'ORA_MEASURE_QUANTITY_SATISFIED' else 'ORA_MEASURE_PERIOD_SATISFIED' |
Hard coded based on charge price type. ONE_TIME or ORA_ONE_TIME is considered One Time charge |
RULE_START_DATE |
If One Time charge then NULL else MIN(OSS_BILL_LINES.DATE_BILLED_FROM) |
Accounting rule start date is the earliest bill from date for recurring charges. No rule dates will be passed for one-time charges as it is not applicable for immediate accounting rule. |
RULE_END_DATE |
If One Time charge then NULL else MAX(OSS_BILL_LINES.DATE_BILLED_TO) |
Accounting rule start date is the last bill to date for recurring charges. No rule dates will be passed for one time charges as it is not applicable for immediate accounting rule. |
CUST_PO_NUMBER | OSS_PRODUCTS.PO_NUMBER | Product po number |
IMMATERIAL_CHANGE_CODE | NULL | Applicable only for revisions |
VERSION_FLAG | 'N' | Hard Coded |
VERSION_NUMBER | 1 | Hard Coded |
BILL_TO_CUSTOMER_ID | OSS_PRODUCTS.BILL_TO_ACCT_ID | Product Bill-To Account ID |
BILL_TO_CUSTOMER_SITE_ID |
customer account site ID for OSS_PRODUCTS.BILL_TO_SITE_USE_ID |
hz_cust_site_uses_all.cust_acct_site_id where site_use_id = OSS_PRODUCTS.BILL_TO_SITE_USE_ID |
REVISION_INTENT_TYPE_CODE | NULL | Applicable only for revisions |
DATA_TRANSFORMATION_STATUS | 'FUSION_INIT' | Hard Coded |
SRC_ATTRIBUTE_CHAR1 | OSS_CHARGES.CHARGE_NAME | Charge Name |
SRC_ATTRIBUTE_CHAR2 | OSS_CHARGES.PRICE_TYPE | ONE_TIME, RECURRING etc. |
SRC_ATTRIBUTE_CHAR3 | OSS_CHARGES.PRICE_PERIODICITY | Price Periodicity for Recurring Charges |
SRC_ATTRIBUTE_CHAR4 | OSS_PRODUCTS.EXTERNAL_ASSET_KEY | Product External Asset Key |
SRC_ATTRIBUTE_CHAR5 | OSS_PRODUCTS.SUBSCRIPTION_PRODUCT_PUID | Product PUID |
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 |
SERVICE_DURATION
|
Duration | Duration of contract line expressed in multiples of the charge UOM |
SERVICE_UOM | Charge UOM | UOM of the Charge |
UNIT_LIST_PRICE | UNIT_LIST_PRICE | Unit list price of charge |