FUN_INTERCO_SOURCE_DOCUMENTS
This table contains information of the source documents corresponding to the source document groups.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FUN_INTERCO_SOURCE_DOC_PK |
SOURCE_DOCUMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SOURCE_DOCUMENT_ID | NUMBER | 18 | Yes | Unique identifier for source document. | |
| SOURCE_DOC_GROUP_ID | NUMBER | 18 | Yes | Unique identifier for the source document group. | |
| RECEIVER_ORG_ID | NUMBER | 18 | Yes | Unique system generated identifier for the receiver organization. | |
| SOURCE_DOCUMENT_NUMBER | VARCHAR2 | 60 | Yes | Unique number for the source document. | |
| SOURCE_DOCUMENT_DATE | DATE | Yes | The date used for processing the source document. | ||
| SOURCE_DOCUMENT_AMOUNT | NUMBER | Yes | Allocated transaction amount for the source document. | ||
| SOURCE_DOCUMENT_STATUS_CODE | VARCHAR2 | 30 | Yes | Status of source document derived based on status of the transaction. | |
| ALLOCATION_PERCENTAGE | NUMBER | Yes | Allocation percentage of the total transaction amount for the receiver organization. | ||
| DESCRIPTION | VARCHAR2 | 240 | Description of the source document. | ||
| PROVIDER_CCID | NUMBER | 18 | Distribution account code combination of the provider intercompany organization | ||
| RECEIVER_CCID | NUMBER | 18 | Distribution account code combination of the receiver intercompany organization | ||
| SOURCE_DOCUMENT_REVERSAL_FLAG | VARCHAR2 | 1 | Yes | Indicator to identify the reversal of the source document | |
| 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. | |
| ORIGINAL_SOURCE_DOCUMENT_ID | NUMBER | 18 | Unique identifier for original source document for reversals. | ||
| REVERSED_SOURCE_DOCUMENT_ID | NUMBER | 18 | Unique identifier for reversed source document. | ||
| 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. | |||
| DOC_REFERENCE_ID1 | NUMBER | 18 | First source document identifier. In most cases, this is mapped to a document header ID. | ||
| DOC_REFERENCE_ID2 | NUMBER | 18 | Second source document identifier. In most cases, this is mapped to a document line id. | ||
| DOC_REFERENCE_ID3 | NUMBER | 18 | Third source document identifier. In most cases, this is mapped to a document distribution id. | ||
| DOC_REFERENCE_ID4 | NUMBER | 18 | Fourth source document identifier. | ||
| DOC_REFERENCE_ID5 | NUMBER | 18 | Fifth source document identifier. | ||
| DOC_NUMBER | VARCHAR2 | 250 | Source document number such as invoice number. | ||
| DOC_LINE_NUMBER | NUMBER | 18 | Source document line number such as invoice line number. | ||
| DOC_DISTRIBUTION_NUMBER | NUMBER | 18 | Source document distribution number such as invoice line distribution number. | ||
| DOC_ADDITIONAL_TRX_NUMBER1 | NUMBER | 18 | First additional source document number. | ||
| DOC_ADDITIONAL_TRX_NUMBER2 | NUMBER | 18 | Second additional source document number. | ||
| SOURCE_APPLICATION_ID | NUMBER | 18 | Identifies the associated source application. | ||
| DOC_TYPE_CODE | VARCHAR2 | 30 | Type of source document such as Invoice, Credit Memo, and Debit Memo. | ||
| DOC_DATE | DATE | Document or transaction date such as invoice date. | |||
| DOC_AMOUNT_TYPE_CODE | VARCHAR2 | 30 | Transaction amount type such as item, tax, and freight. | ||
| DOC_AMOUNT | NUMBER | Transaction amount for the source document. | |||
| DOC_BU_ID | NUMBER | 18 | Identifies the business unit of the source document. | ||
| DOC_SUPPLIER_ID | NUMBER | 18 | Identifies the supplier of the source document. | ||
| DOC_LE_ID | NUMBER | 18 | Identifies the legal entity of the source document. | ||
| INTERCO_TRX_SOURCE_DOC_ID | NUMBER | 18 | Identifies the document preparation transaction. | ||
| INTERCO_TRX_SOURCE_NUMBER | NUMBER | 18 | Application generated unique transaction number. | ||
| DOC_ACTION_CODE | VARCHAR2 | 30 | Indicates whether the document is for a reversal transaction. | ||
| DOC_DESCRIPTION | VARCHAR2 | 240 | Description for the source document. | ||
| DOC_ASSET_BOOK_TYPE_CODE | VARCHAR2 | 30 | Identifies the asset book of the source document. | ||
| DOC_LEDGER_ID | NUMBER | 18 | Identifies the ledger of the source document. | ||
| DOC_SUPPLIER_SITE_ID | NUMBER | 18 | Identifies the supplier site of the source document. | ||
| DOC_CUSTOMER_ID | NUMBER | 18 | Identifies the customer of the source document. | ||
| DOC_CUST_ACCOUNT_ID | NUMBER | 18 | Identifies the customer account of the source document. | ||
| DOC_CUST_BILL_TO_LOCATION_ID | NUMBER | 18 | Identifies the customer bill to location of the source document. | ||
| DOC_CCID | NUMBER | 18 | Account code combination of the source document. | ||
| REVERSED_DOC_REFERENCE_ID1 | NUMBER | 18 | Identifies the first associated reversed source document. | ||
| REVERSED_DOC_REFERENCE_ID2 | NUMBER | 18 | Identifies the second associated reversed source document. | ||
| REVERSED_DOC_REFERENCE_ID3 | NUMBER | 18 | Identifies the third associated reversed source document. | ||
| REVERSED_DOC_REFERENCE_ID4 | NUMBER | 18 | Identifies the fourth associated reversed source document. | ||
| REVERSED_DOC_REFERENCE_ID5 | NUMBER | 18 | Identifies the fifth associated reversed source document. | ||
| DOC_CURRENCY_CODE | VARCHAR2 | 15 | Transfer authorization currency. | ||
| DOC_ORIGIN | VARCHAR2 | 150 | Identifies the origin of source transaction. | ||
| DOC_SOURCE | VARCHAR2 | 150 | Identifies the associated source application. | ||
| DOC_TYPE | VARCHAR2 | 80 | Type of source document such as invoice. | ||
| DOC_AMOUNT_TYPE | VARCHAR2 | 80 | Source transaction amount type such as item and tax. | ||
| DOC_BU_NAME | VARCHAR2 | 240 | Business unit name of the source document. | ||
| DOC_SUPPLIER_NAME | VARCHAR2 | 360 | Supplier name of the source document. | ||
| DOC_LE_NAME | VARCHAR2 | 240 | Legal entity of the source document. | ||
| NOTES | VARCHAR2 | 240 | Notes associated with Transfer Authorization. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency of the transfer authorization. | ||
| STANDARD_CREDIT_MEMO_FLAG | VARCHAR2 | 1 | Indicates whether standard credit memo generation is allowed for intercompany transaction reversals. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FUN_INTERCO_SOURCE_DOCUMENTS | fun_interco_source_doc_groups | SOURCE_DOC_GROUP_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | fun_interco_organizations | RECEIVER_ORG_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | fun_interco_source_documents | ORIGINAL_SOURCE_DOCUMENT_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | fun_interco_source_documents | REVERSED_SOURCE_DOCUMENT_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | XLE_ENTITY_PROFILES | DOC_LE_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | GL_CODE_COMBINATIONS | DOC_CCID |
| FUN_INTERCO_SOURCE_DOCUMENTS | FND_CURRENCIES_B | DOC_CURRENCY_CODE |
| FUN_INTERCO_SOURCE_DOCUMENTS | HR_ALL_ORGANIZATION_UNITS_F | DOC_BU_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | FA_BOOK_CONTROLS | DOC_ASSET_BOOK_TYPE_CODE |
| FUN_INTERCO_SOURCE_DOCUMENTS | GL_LEDGERS | DOC_LEDGER_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | POZ_SUPPLIERS | DOC_SUPPLIER_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | POZ_SUPPLIER_SITES_ALL_M | DOC_SUPPLIER_SITE_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | HZ_PARTIES | DOC_CUSTOMER_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | HZ_CUST_ACCOUNTS | DOC_CUST_ACCOUNT_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | HZ_CUST_ACCT_SITES_ALL | DOC_CUST_BILL_TO_LOCATION_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | FUN_INTERCO_TRX_SOURCE_DOCS | INTERCO_TRX_SOURCE_DOC_ID |
| FUN_INTERCO_SOURCE_DOCUMENTS | FND_CURRENCIES_B | CURRENCY_CODE |
| fun_interco_source_documents | fun_interco_source_documents | ORIGINAL_SOURCE_DOCUMENT_ID |
| fun_interco_source_documents | fun_interco_source_documents | REVERSED_SOURCE_DOCUMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_INTERCO_SOURCE_DOC_N4 | Non Unique | Default | REVERSED_SOURCE_DOCUMENT_ID |
| FUN_INTERCO_SOURCE_DOC_N3 | Non Unique | Default | ORIGINAL_SOURCE_DOCUMENT_ID |
| FUN_INTERCO_SOURCE_DOC_N2 | Non Unique | Default | SOURCE_DOCUMENT_STATUS_CODE |
| FUN_INTERCO_SOURCE_DOC_N1 | Non Unique | Default | RECEIVER_ORG_ID |
| FUN_INTERCO_SOURCE_DOC_N5 | Non Unique | Default | SOURCE_DOC_GROUP_ID |
| FUN_INTERCO_SOURCE_DOC_N6 | Non Unique | Default | SOURCE_APPLICATION_ID, INTERCO_TRX_SOURCE_DOC_ID, INTERCO_TRX_SOURCE_NUMBER |
| FUN_INTERCO_SOURCE_DOC_U1 | Unique | Default | SOURCE_DOCUMENT_ID |
| FUN_INTERCO_SOURCE_DOC_U2 | Unique | Default | SOURCE_DOCUMENT_NUMBER |