FUN_INTERCO_TRX_SOURCE_DOCS
The table contains source document information to prepare and create intercompany transactions.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FUN_INTERCO_TRX_SOURCE_DOCS_PK |
INTERCO_TRX_SOURCE_DOC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERCO_TRX_SOURCE_DOC_ID | NUMBER | 18 | Yes | Document preparation transaction identifier. | |
| INTERCO_TRX_SOURCE_NUMBER | NUMBER | 18 | Yes | Application generated unique transaction number. | |
| PROCESSING_STATUS_CODE | VARCHAR2 | 30 | Yes | Processing status of the intercompany transaction. | |
| ERROR_MESSAGE | VARCHAR2 | 2000 | Description for intercompany transaction processing error. | ||
| APPROVAL_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether the intercompany transaction approval is required. | ||
| SOURCE_APPLICATION_ID | NUMBER | 18 | Yes | Identifies the associated source application. | |
| DOC_ACTION_CODE | VARCHAR2 | 30 | Yes | Indicates whether the document is for a reversal transaction. | |
| DOC_TYPE_CODE | VARCHAR2 | 30 | Type of source document such as Invoice, Credit Memo, and Debit Memo. | ||
| DOC_REFERENCE_ID1 | NUMBER | 18 | Yes | 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 | Yes | 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. | ||
| DOC_DATE | DATE | Document or transaction date such as invoice date. | |||
| DOC_DESCRIPTION | VARCHAR2 | 240 | Description for the source document. | ||
| DOC_AMOUNT | NUMBER | Transaction amount for the source document. | |||
| DOC_LE_ID | NUMBER | 18 | Identifies the legal entity of the source document. | ||
| DOC_BU_ID | NUMBER | 18 | Identifies the business unit of 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_ID | NUMBER | 18 | Identifies the supplier 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_AMOUNT_TYPE_CODE | VARCHAR2 | 30 | Transaction amount type such as item, tax, and freight. | ||
| DOC_CCID | NUMBER | 18 | Account code combination of the source document. | ||
| TRX_PROVIDER_CCID | NUMBER | 18 | Provider account code combination of the intercompany transaction. | ||
| AGREEMENT_ID | NUMBER | 18 | Intercompany agreement identifier associated to the source document. | ||
| SOURCE_DOC_GROUP_ID | NUMBER | 18 | Unique identifier for intercompany source document group. | ||
| SOURCE_DOCUMENT_ID | NUMBER | 18 | Unique identifier for intercompany source document. | ||
| TA_REFERENCE | VARCHAR2 | 30 | Transfer authorization reference number. | ||
| TA_NUMBER | VARCHAR2 | 50 | Transfer authorization number generated. | ||
| TA_DESCRIPTION | VARCHAR2 | 240 | Transfer authorization description. | ||
| TA_TRX_DATE | DATE | Transaction date of the transfer authorization. | |||
| TA_AMOUNT | NUMBER | Transaction amount of the transfer authorization. | |||
| TA_AMOUNT_TYPE_CODE | VARCHAR2 | 30 | Transfer authorization amount type. | ||
| DOC_CURRENCY_CODE | VARCHAR2 | 15 | Transfer authorization currency. | ||
| REVERSED_DOC_REFERENCE_ID1 | NUMBER | 18 | First associated reversed source document identifier. | ||
| REVERSED_DOC_REFERENCE_ID2 | NUMBER | 18 | Second associated reversed source document identifier. | ||
| REVERSED_DOC_REFERENCE_ID3 | NUMBER | 18 | Third associated reversed source document identifier. | ||
| REVERSED_DOC_REFERENCE_ID4 | NUMBER | 18 | Fourth associated reversed source document identifier. | ||
| REVERSED_DOC_REFERENCE_ID5 | NUMBER | 18 | Fifth associated reversed source document identifier. | ||
| 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. | |||
| 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. | ||
| 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. | |
| NOTES | VARCHAR2 | 240 | Notes associated with Transfer Authorization from document preparation. | ||
| DOC_ACCOUNTED_CURRENCY_CODE | VARCHAR2 | 15 | Functional currency code for the source document. | ||
| DOC_ACCOUNTED_AMOUNT | NUMBER | Invoice amount of the source document in the functional currency. | |||
| STANDARD_CREDIT_MEMO_FLAG | VARCHAR2 | 1 | Indicates whether standard credit memo generation is allowed for intercompany transaction reversals. | ||
| 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_TRX_SOURCE_DOCS | XLE_ENTITY_PROFILES | DOC_LE_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS | GL_CODE_COMBINATIONS | DOC_CCID |
| FUN_INTERCO_TRX_SOURCE_DOCS | GL_CODE_COMBINATIONS | TRX_PROVIDER_CCID |
| FUN_INTERCO_TRX_SOURCE_DOCS | FUN_INTERCO_MASTER_DOCUMENTS | AGREEMENT_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS | FUN_INTERCO_SOURCE_DOC_GROUPS | SOURCE_DOC_GROUP_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS | FUN_INTERCO_SOURCE_DOCUMENTS | SOURCE_DOCUMENT_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS | FND_CURRENCIES_B | DOC_CURRENCY_CODE |
| FUN_INTERCO_TRX_SOURCE_DOCS | HR_ALL_ORGANIZATION_UNITS_F | DOC_BU_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS | FA_BOOK_CONTROLS | DOC_ASSET_BOOK_TYPE_CODE |
| FUN_INTERCO_TRX_SOURCE_DOCS | GL_LEDGERS | DOC_LEDGER_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS | POZ_SUPPLIERS | DOC_SUPPLIER_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS | POZ_SUPPLIER_SITES_ALL_M | DOC_SUPPLIER_SITE_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS | HZ_PARTIES | DOC_CUSTOMER_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS | HZ_CUST_ACCOUNTS | DOC_CUST_ACCOUNT_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS | HZ_CUST_ACCT_SITES_ALL | DOC_CUST_BILL_TO_LOCATION_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS | FND_CURRENCIES_B | DOC_ACCOUNTED_CURRENCY_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_INTERCO_TRX_SOURCE_DOCS_N1 | Non Unique | Default | SOURCE_APPLICATION_ID, DOC_NUMBER, DOC_LINE_NUMBER, DOC_DISTRIBUTION_NUMBER, DOC_ADDITIONAL_TRX_NUMBER1, DOC_ADDITIONAL_TRX_NUMBER2 |
| FUN_INTERCO_TRX_SOURCE_DOCS_N2 | Non Unique | Default | SOURCE_APPLICATION_ID, PROCESSING_STATUS_CODE, CREATION_DATE |
| FUN_INTERCO_TRX_SOURCE_DOCS_U1 | Unique | Default | INTERCO_TRX_SOURCE_DOC_ID |
| FUN_INTERCO_TRX_SOURCE_DOCS_U2 | Unique | Default | INTERCO_TRX_SOURCE_NUMBER |
| FUN_INTERCO_TRX_SOURCE_DOCS_U3 | Unique | Default | SOURCE_APPLICATION_ID, DOC_REFERENCE_ID1, DOC_REFERENCE_ID2, DOC_REFERENCE_ID3, DOC_REFERENCE_ID4, DOC_REFERENCE_ID5 |