OSS_RMCS_DOC_LINES_T
This table stores RMCS source document lines data
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OSS_RMCS_DOC_LINES_T_PK |
DOCUMENT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SUBSCRIPTION_ID | NUMBER | 18 | Internal unique identifier for a subscription. | ||
| DOCUMENT_LINE_ID | NUMBER | 18 | Yes | It is a primary key | |
| DOCUMENT_DATE | DATE | Document date. | |||
| UOM_CODE | VARCHAR2 | 200 | It is product item unit of measure. | ||
| QUANTITY | NUMBER | It is Product Quantity. | |||
| UNIT_SELLING_PRICE | NUMBER | Unit selling price. | |||
| DURATION | NUMBER | Subscription product or covered level duration represented in charge UOM. | |||
| CHARGE_UOM | VARCHAR2 | 200 | Unit of measure of the charge. | ||
| UNIT_LIST_PRICE | NUMBER | List price excluding automatic and manual adjustments. | |||
| DOC_ID_INT_1 | NUMBER | 18 | Subscription Id. | ||
| DOC_ID_INT_2 | NUMBER | 18 | Document Id. Foreign Key to the parent table. | ||
| DOC_LINE_ID_CHAR_1 | VARCHAR2 | 30 | Revenue Line Id. | ||
| LINE_NUM | VARCHAR2 | 30 | Product number. | ||
| CHARGE_ID | NUMBER | 18 | Charge Id. | ||
| PRODUCT_ID | NUMBER | 18 | Subscription Product Id. | ||
| LINE_AMOUNT | NUMBER | Sum of billlines amount. | |||
| UNIT_SSP | NUMBER | Unit standard selling price. | |||
| ITEM_ID | NUMBER | 18 | Inventory item id. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Product definition org id. | ||
| SATISFACTION_MEASUREMENT_MODEL | VARCHAR2 | 30 | Charge Type. | ||
| RULE_START_DATE | DATE | Accounting rule start date. | |||
| RULE_END_DATE | DATE | Accounting rule end date. | |||
| CUST_PO_NUMBER | VARCHAR2 | 50 | PO Number. | ||
| IMMATERIAL_CHANGE_CODE | VARCHAR2 | 30 | Immeterial change code. | ||
| VERSION_FLAG | VARCHAR2 | 1 | Version Flag. | ||
| VERSION_NUMBER | NUMBER | 9 | Version Number. | ||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Bill to account id. | ||
| BILL_TO_CUSTOMER_SITE_ID | NUMBER | 18 | Bill to site id. | ||
| REVISION_INTENT_TYPE_CODE | VARCHAR2 | 30 | Revision intent type. | ||
| DOCUMENT_TYPE_ID | NUMBER | 18 | Unique identifier of a source document type in Oracle Revenue Management Cloud | ||
| DOC_LINE_ID_INT_1 | NUMBER | First numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Second character column of the key that identifies source document line in source application. | ||
| BASE_PRICE | NUMBER | Base price per unit of measure of the inventory item or memo line. | |||
| SALESREP_ID | NUMBER | 22 | Primary key of the sales person on the order line. | ||
| ACCOUNTING_RULE_ID | NUMBER | 18 | Revenue scheduling rule identifier on source document line. Revenue scheduling rule determines the timing of revenue recognition. | ||
| SRC_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Charge name. | ||
| SRC_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Price type. | ||
| SRC_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Periodicity of prices. | ||
| SRC_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | External asset key. | ||
| SRC_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Product puid. | ||
| SRC_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Source Character Attribute 13 | ||
| SRC_ATTRIBUTE_NUMBER1 | NUMBER | Source Character Attribute 1 | |||
| SRC_ATTRIBUTE_NUMBER2 | NUMBER | Source Character Attribute 2 | |||
| SRC_ATTRIBUTE_NUMBER3 | NUMBER | Source Character Attribute 3 | |||
| SRC_ATTRIBUTE_NUMBER4 | NUMBER | Source Character Attribute 4 | |||
| EXTRACTION_STATUS | VARCHAR2 | 30 | Status to indicate if the revenue line from FOM has been interfaced to RMCS | ||
| PROCESSED_FLAG | VARCHAR2 | 1 | Processed Flag. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CONTRACT_MODIFICATION_DATE | DATE | Contract modification date | |||
| ADD_TO_CONTRACT_FLAG | VARCHAR2 | 1 | Add to contract flag | ||
| ADD_TO_CONTRACT_ACTION_CODE | VARCHAR2 | 30 | Add to contract action code | ||
| INITIAL_DOCUMENT_TYPE_ID | NUMBER | 18 | Identifies the origin of subscription. | ||
| INITIAL_DOC_LINE_ID_CHAR_1 | VARCHAR2 | 30 | First reference attribute that identifies the parent source document line. | ||
| INITIAL_DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Second reference attribute that identifies source document line in source application. | ||
| INITIAL_DOC_LINE_ID_INT_1 | NUMBER | 18 | Initial First numeric column of the key that identifies source document line in source application. | ||
| BILL_REF_DOCUMENT_TYPE_ID | NUMBER | 18 | Identifies billing reference document type id. | ||
| BILL_REF_DOC_LINE_ID_CHAR_1 | VARCHAR2 | 30 | Revenue line id that is referenced for revenue billing. | ||
| BILL_REF_DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Second reference attribute that identifies the source document line in source application. | ||
| BILL_REF_DOC_LINE_ID_INT_1 | NUMBER | 18 | First reference numeric column of the key that identifies source document line id in source application. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OSS_RMCS_DOC_LINES_T_N1 | Non Unique | Default | DOC_ID_INT_2 |
| OSS_RMCS_DOC_LINES_T_N2 | Non Unique | Default | BILL_TO_CUSTOMER_ID |
| OSS_RMCS_DOC_LINES_T_N3 | Non Unique | Default | BILL_TO_CUSTOMER_SITE_ID |
| OSS_RMCS_DOC_LINES_T_N4 | Non Unique | Default | DOC_ID_INT_1 |
| OSS_RMCS_DOC_LINES_T_N5 | Non Unique | Default | ITEM_ID |
| OSS_RMCS_DOC_LINES_T_N6 | Non Unique | Default | PRODUCT_ID |
| OSS_RMCS_DOC_LINES_T_N7 | Non Unique | Default | SUBSCRIPTION_ID |
| OSS_RMCS_DOC_LINES_T_N8 | Non Unique | Default | DOC_LINE_ID_CHAR_1 |
| OSS_RMCS_DOC_LINES_T_U1 | Unique | Default | DOCUMENT_LINE_ID |