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 |