VRM_SOURCE_DOC_TYPES_B
VRM_SOURCE_DOC_TYPES_B contains definition of document types from source applications that VRM application integrates with. For examples, Sales Order from Oracle Order Management application, Service Contract from Oracle Service Contracts application. Document types can be defined in case for an integrating with deploying company's legacy applications.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
VRM_SOURCE_DOC_TYPES_B_PK |
DOCUMENT_TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_TYPE_ID | NUMBER | 18 | Yes | Unique identifier of a source document type. | |
| EXTRACT_TIME_FRAME | NUMBER | Number of days for which extract program should pull the system data prior to the end date provided for extract run. | |||
| DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Yes | Code of a document type. | |
| APPLICATION_ID | NUMBER | 18 | Identifier of the application to which the transaction entity belongs to. Foreign key to the FND applications table. | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | A yes or no flag that indicates if the document is active. | ||
| VALIDATION_STATUS | VARCHAR2 | 1 | A Yes or No flag that indicates validation status of a document type where Y indicates valid and N indicates invalid document type. | ||
| SOURCE_SYSTEM | VARCHAR2 | 30 | Document type code from the source system. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| 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. | ||
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| DEFAULT_SATIS_MEASURE_MODEL | VARCHAR2 | 30 | Default satisfaction measurement model to be used when the revenue rule is not provided from the source product. | ||
| DEFAULT_REVENUE_RULE_ID | NUMBER | 18 | Unique identifier of the revenue scheduling rule. This rule needs to be defaulted on the performance obligation line if no rule is provided by the source application. | ||
| DEFAULT_REVISION_INTENT_CODE | VARCHAR2 | 30 | Default revision intent for the source document type. Values are from the lookup type ORA_VRM_REVISION_INTENT_TYPE. | ||
| DEFAULT_IMMATERIAL_CHANGE_CODE | VARCHAR2 | 30 | Default immaterial change type for the source document type. Valid values are from the lookup type ORA_IMMATERIAL_CHANGE_TYPE. | ||
| ALLOW_REVENUE_LINE_UPDATE_FLAG | VARCHAR2 | 1 | A column heading in the Manage Source Document Types page that indicates whether the source document lines of the source document type can be updated using a REST service. Valid values are Y, N, or blank. Blank means No. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_SOURCE_DOC_TYPES_B | ra_rules | DEFAULT_REVENUE_RULE_ID |
| vrm_bill_rev_recon_history | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_document_data_objects | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_mea_rule_details | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_app_sources | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_source_doc_sub_lines | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_contract_rule_details | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_perf_oblig_grp_rule_dtls | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_doc_attributes_b_f | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| ra_interface_lines_all | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_source_documents | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_source_doc_lines | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_source_doc_lines | vrm_source_doc_types_b | REFERENCE_DOCUMENT_TYPE_ID |
| vrm_price_segment_assigns | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_new_app_sources | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_SOURCE_DOC_TYPES_B_U1 | Unique | Default | DOCUMENT_TYPE_ID, ORA_SEED_SET1 |
| VRM_SOURCE_DOC_TYPES_B_U11 | Unique | Default | DOCUMENT_TYPE_ID, ORA_SEED_SET2 |