FUN_INTERCO_SOURCE_DOC_GROUPS
This table contains information of the source document groups corresponding to the master documents.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FUN_INTERCO_SOURCE_DOC_GRP_PK |
SOURCE_DOC_GROUP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SOURCE_DOC_GROUP_ID | NUMBER | 18 | Yes | Unique identifier for the source document group. | |
| MASTER_DOCUMENT_ID | NUMBER | 18 | Yes | Unique identifier for the master document. | |
| AMOUNT_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique abbreviated name assigned to an amount type and used for reporting. | |
| SOURCE_DOC_GROUP_DATE | DATE | Yes | The date used for processing the source document group. | ||
| SOURCE_DOC_GROUP_AMOUNT | NUMBER | Yes | Total transaction amount for the source document group. | ||
| SOURCE_DOC_GROUP_STATUS_CODE | VARCHAR2 | 30 | Yes | Status of source document group derived based on the status of source document. | |
| DESCRIPTION | VARCHAR2 | 240 | Source document group description. | ||
| TEMPLATE_FLAG | VARCHAR2 | 1 | Yes | Indicate whether source document group is a template. | |
| 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. | ||
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition 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. | |||
| 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. | |||
| 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. | |
| SOURCE_DOC_GROUP_NUMBER | VARCHAR2 | 50 | Yes | Unique number to identify source document group. | |
| ALLOCATE_EVENLY_FLAG | VARCHAR2 | 1 | Yes | Identifies whether the transaction amount is evenly allocated between the receiver organizations. | |
| SOURCE_DOC_GROUP_REFERENCE | VARCHAR2 | 30 | Yes | Unique reference number for source document group. | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Rate type for conversion from transaction currency. | ||
| DUE_TO_FROM_CURR_BASIS_CODE | VARCHAR2 | 30 | Basis for currency conversion from transaction currency that's defined for master document. | ||
| EXCHANGE_RATE_DATE | DATE | Date of currency conversion from transaction currency to currency in which funds are received by receiver organization. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency of the transfer authorization group. | ||
| MANUAL_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether manual approval is enabled for transfer authorization. | ||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Classification used by a tax authority to categorize a document associated with a transaction for a tax. Use the Manage Document Fiscal Classification Codes task to identify valid values. | ||
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | 240 | Product classification used by tax authority. Use Manage Product Fiscal Classification Type Group task to identify valid values. | ||
| PRODUCT_CATEGORY | VARCHAR2 | 240 | Product fiscal classification that is used for tax purposes such as tax determination and reporting for non inventory items. Use the Manage Product Category Fiscal Classification Codes task to identify valid values. | ||
| PRODUCT_TYPE | VARCHAR2 | 240 | Product type. Valid values are GOODS and SERVICES. | ||
| OUTPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Default tax classification code for this transaction. | ||
| LINE_INTENDED_USE | VARCHAR2 | 240 | Tax classification based upon the product purpose. Use the Manage Intended Use Fiscal Classification task to identify valid values. | ||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | User defined fiscal classification. | ||
| ASSESSABLE_VALUE | NUMBER | Assessed value for tax calculation purposes. | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE21 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE22 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE23 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE24 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE25 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE26 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE27 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE28 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE29 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE30 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER6 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER7 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER8 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER9 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER10 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER11 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER12 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| STANDARD_CREDIT_MEMO_FLAG | VARCHAR2 | 1 | Indicates whether standard credit memo generation is allowed for intercompany transaction reversals. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FUN_INTERCO_SOURCE_DOC_GROUPS | fun_interco_master_documents | MASTER_DOCUMENT_ID |
| FUN_INTERCO_SOURCE_DOC_GROUPS | FND_CURRENCIES_B | CURRENCY_CODE |
| fun_interco_source_documents | fun_interco_source_doc_groups | SOURCE_DOC_GROUP_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| FUN_INTERCO_SOURCE_DOC_GRP_N2 | Non Unique | Default | SOURCE_DOC_GROUP_STATUS_CODE | |
| FUN_INTERCO_SOURCE_DOC_GRP_N1 | Non Unique | Default | MASTER_DOCUMENT_ID, TEMPLATE_FLAG | |
| FUN_INTERCO_SOURCE_DOC_GRP_U1 | Unique | Default | SOURCE_DOC_GROUP_ID | |
| FUN_INTERCO_SOURCE_DOC_GRP_U2 | Unique | Default | SOURCE_DOC_GROUP_NUMBER | |
| FUN_INTERCO_SOURCE_DOC_GRP_U3 | Unique | Default | SOURCE_DOC_GROUP_REFERENCE | Obsolete |
| FUN_INTERCO_SOURCE_DOC_GRP_N3 | Non Unique | Default | SOURCE_DOC_GROUP_REFERENCE |