This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: | FUN_BALANCE_ACCOUNTS table stores the intracompany accounts defined between each trading and transacting balancing segment value. These accounts are used by the Intercompany Balancing API to balancing Intracompany journals. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_BALANCE_ACCOUNTS_U1 | UNIQUE | APPS_TS_TX_IDX |
TEMPLATE_ID
DR_BSV CR_BSV |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | (15) | Y | Foreign key to FUN_BALANCE_OPTIONS. |
DR_BSV | VARCHAR2 | (30) | Y | Debit Balancing Segment Value. |
CR_BSV | VARCHAR2 | (30) | Y | Credit Balancing Segment Value. |
DR_CCID | NUMBER | (15) | Y | Debit account code combination. |
CR_CCID | NUMBER | (15) | Y | Credit account code combination. |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number. | ||
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. |
FUN.FUN_BALANCE_ACCOUNTS does not reference any database object
FUN.FUN_BALANCE_ACCOUNTS is referenced by following:
Description: | FUN_BALANCE_OPTIONS table stores the ledger, journal source and category information for which the Intracompany balancing rules have been defined. These rules are used by the Intercompany Balancing API to balancing Intracompany journals. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_BALANCE_OPTIONS_U1 | UNIQUE | APPS_TS_TX_IDX |
LEDGER_ID
LE_ID JE_SOURCE_NAME JE_CATEGORY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | (15) | Y | Generated template identifier |
LEDGER_ID | NUMBER | (15) | Y | Ledger identifier |
LE_ID | NUMBER | (15) | Legal Entity identifier | |
JE_SOURCE_NAME | VARCHAR2 | (25) | Y | Journal entry source name |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Y | Journal entry category name |
CLEARING_OPTION | VARCHAR2 | (2) | Y | Clearing Balancing Segment option. Valid values are: 1D - Do not use, 2E - Enter Manually on All Journals,3A - Use for All Journals, 4M - Use for M-M Journals Only |
CLEARING_BSV | VARCHAR2 | (25) | Clearing Balancing Segment Value | |
BALANCE_BY_FLAG | VARCHAR2 | (1) | Y | Balance By option. Valid values are:D - Detail, S - Summary Net |
MANY_TO_MANY_OPTION | VARCHAR2 | (2) | Y | Many-to-Many journals option. Valid values are: 1D - Default Rule, 2C - Use Clearing BSV, 3B - Use All Balancing Rules |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number. | ||
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
STATUS_FLAG | VARCHAR2 | (1) | Status Flag |
FUN.FUN_BALANCE_OPTIONS does not reference any database object
FUN.FUN_BALANCE_OPTIONS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_BAL_ERRORS_GT_N1 | NONUNIQUE | ERROR_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ERROR_CODE | VARCHAR2 | (30) | Error Code | |
GROUP_ID | NUMBER | (15) | Group Id | |
BAL_SEG_VAL | VARCHAR2 | (25) | Bal Seg Val | |
DR_BSV | VARCHAR2 | (25) | Debit Bsv | |
CR_BSV | VARCHAR2 | (25) | Credit Bsv | |
CLEARING_BSV | VARCHAR2 | (25) | Clearing Bsv | |
LINE_REFERENCE | VARCHAR2 | (25) | Line Reference | |
FROM_LE_ID | NUMBER | (15) | From Legal Entity Identifier | |
TO_LE_ID | NUMBER | (15) | To Legal Entity Identifier | |
CCID | NUMBER | (15) | Code Combination Identifier | |
LE_ID | NUMBER | (15) | Legal Entity Identifier | |
CCID_CONCAT_DISPLAY | VARCHAR2 | (800) | Concatenated Account | |
TEMPLATE_ID | NUMBER | (15) | Template Id | |
ACCT_TYPE | VARCHAR2 | (1) | Account Type |
FUN.FUN_BAL_ERRORS_GT does not reference any database object
FUN.FUN_BAL_ERRORS_GT is referenced by following:
Description: | FUN_BAL_ERRORS_T is a temporary table used internally by the Intercompany Balancing API. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ERROR_CODE | VARCHAR2 | (30) | Error code | |
GROUP_ID | NUMBER | (15) | Group identifier | |
BAL_SEG_VAL | VARCHAR2 | (25) | Balancing segment value | |
DR_BSV | VARCHAR2 | (25) | Debit balancing segment value | |
CR_BSV | VARCHAR2 | (25) | Credit balancing segment value | |
CLEARING_BSV | VARCHAR2 | (25) | ||
LINE_REFERENCE | VARCHAR2 | (25) | Line Reference | |
FROM_LE_ID | NUMBER | (15) | From legal entity identifier | |
TO_LE_ID | NUMBER | (15) | To legal entity identifier | |
CCID | NUMBER | (15) | Code combination identifier | |
LE_ID | NUMBER | (15) | Legal entity identifier | |
CCID_CONCAT_DISPLAY | VARCHAR2 | (800) | Concatenated account | |
TEMPLATE_ID | NUMBER | (15) | Template identifier | |
ACCT_TYPE | VARCHAR2 | (1) | Account type |
FUN.FUN_BAL_ERRORS_T does not reference any database object
FUN.FUN_BAL_ERRORS_T is referenced by following:
Description: | FUN_BAL_GENERATE_LINES is a temporary table used internally by the Intercompany balancing API. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VALUE | VARCHAR2 | (1) | Value |
FUN.FUN_BAL_GENERATE_LINES does not reference any database object
FUN.FUN_BAL_GENERATE_LINES is referenced by following:
Description: | FUN_BAL_HEADERS_GT is a global temporary table used by the Intercompany Balancing API. Calling modules like SLA and GL populate this table with the details of the journals that needs to be balanced and then invoke the Intercompany Balancing |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_BAL_HEADERS_GT_U1 | UNIQUE | GROUP_ID | |
FUN_BAL_HEADERS_GT_N1 | NONUNIQUE | STATUS | |
FUN_BAL_HEADERS_GT_N2 | NONUNIQUE | INTERCOMPANY_MODE | |
FUN_BAL_HEADERS_GT_N3 | NONUNIQUE | LEDGER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Y | Group Identifier |
LEDGER_ID | NUMBER | (15) | Y | Ledger Identifier |
JE_SOURCE_NAME | VARCHAR2 | (25) | Y | Journal Source Name |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Y | Journal Category Name |
GL_DATE | DATE | Y | Gl Date | |
CLEARING_BSV | VARCHAR2 | (25) | Clearing Bsv | |
STATUS | VARCHAR2 | (5) | Y | Status |
INTERCOMPANY_MODE | NUMBER | (4) | Intercompany Mode | |
DRIVING_DR_LE_ID | NUMBER | (15) | Driving Debit Legal Entity Identifier | |
DRIVING_CR_LE_ID | NUMBER | (15) | Driving Credit Legal Entity Identifier | |
DRIVING_DR_LE_CURR_CODE | VARCHAR2 | (15) | Driving Dr Legal Entity Currency Code | |
DRIVING_CR_LE_CURR_CODE | VARCHAR2 | (15) | Driving Cr Legal Entity Currency Code | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Chart Of Accounts Id | |
BAL_SEG_COLUMN_NAME | VARCHAR2 | (25) | Balancing Segment Column Name | |
BAL_SEG_COLUMN_NUMBER | NUMBER | (2) | Bal Seg Column Number | |
INTERCOMPANY_COLUMN_NUMBER | NUMBER | (2) | Intercompany Column Number | |
LE_ID | NUMBER | (15) | Legal Entity Id | |
LE_COUNT | NUMBER | (15) | Legal Entity Count | |
UNMAPPED_BSV_LE_ID | NUMBER | (15) | Unmapped BSV Legal Entity Id | |
ERROR_CODE | VARCHAR2 | (30) | Error Code |
FUN.FUN_BAL_HEADERS_GT does not reference any database object
FUN.FUN_BAL_HEADERS_GT is referenced by following:
Description: | FUN_BAL_HEADERS_T is a temporary table used internally by the Intercompany Balancing API. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Y | Group identifier |
LEDGER_ID | NUMBER | (15) | Y | Ledger identifier |
JE_SOURCE_NAME | VARCHAR2 | (25) | Y | Journal entry source name |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Y | Journal entry category name |
GL_DATE | DATE | Y | GL Date of journal or subledger journal | |
CLEARING_BSV | VARCHAR2 | (25) | Clearing BSV for the journal or subledger journal | |
STATUS | VARCHAR2 | (5) | Y | Status |
INTERCOMPANY_MODE | NUMBER | (4) | Intercompany Mode | |
DRIVING_DR_LE_ID | NUMBER | (15) | Driving debit legal entity identifier | |
DRIVING_CR_LE_ID | NUMBER | (15) | Driving credit legal entity identifier | |
DRIVING_DR_LE_CURR_CODE | VARCHAR2 | (15) | Driving debit legal entity currency | |
DRIVING_CR_LE_CURR_CODE | VARCHAR2 | (15) | Driving debit legal entity currency | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Chart of Accounts Id | |
BAL_SEG_COLUMN_NAME | VARCHAR2 | (25) | Balancing segment column name | |
BAL_SEG_COLUMN_NUMBER | NUMBER | (2) | Balancing segment column number | |
INTERCOMPANY_COLUMN_NUMBER | NUMBER | (2) | Intercompany segment comumn number | |
LE_ID | NUMBER | (15) | Legal Entity identifier | |
LE_COUNT | NUMBER | (15) | Count of the legal entities | |
UNMAPPED_BSV_LE_ID | NUMBER | (15) | Legal Entity Identifier of unmapped BSV | |
ERROR_CODE | VARCHAR2 | (30) | Error code |
FUN.FUN_BAL_HEADERS_T does not reference any database object
FUN.FUN_BAL_HEADERS_T is referenced by following:
Description: | FUN_BAL_INTER_BSV_MAP_T is a temporary table used internally by the Intercompany balancing API. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Y | Group identifier |
LEDGER_ID | NUMBER | (15) | Y | Ledger identifier |
LE_ID | NUMBER | (15) | Legal entity identifier | |
BAL_SEG_VAL | VARCHAR2 | (25) | Y | Balancing segment value |
GL_DATE | DATE | GL Date | ||
DRIVING_DR_BSV | VARCHAR2 | (25) | Driving debit balancing segment value | |
DRIVING_CR_BSV | VARCHAR2 | (25) | Driving credit balancing segment value | |
INTRACOMPANY_MODE | NUMBER | (4) | Intracompany mode | |
TEMPLATE_ID | NUMBER | Template identifier | ||
BALANCE_BY | VARCHAR2 | (1) | Balance by | |
CLEARING_OPTION | VARCHAR2 | (2) | Clearing option | |
JE_SOURCE_NAME | VARCHAR2 | (25) | Journal source name | |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Journal category name | |
CLEARING_BSV | VARCHAR2 | (25) | Clearing balancing segment value | |
DR_CR_DEBIT_CCID | NUMBER | (15) | Debit account | |
DR_CR_CREDIT_CCID | NUMBER | (15) | Credit account | |
CR_DR_DEBIT_CCID | NUMBER | (15) | Debit account | |
CR_DR_CREDIT_CCID | NUMBER | (15) | Credit Account | |
BAL_SEG_COLUMN_NUMBER | NUMBER | (2) | Balancing segment column number | |
INTERCOMPANY_COLUMN_NUMBER | NUMBER | (2) | Intercompany segment column number | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Chart of accounts identifier | |
MANY_TO_MANY_OPTION | VARCHAR2 | (2) | Many to many option | |
DR_CR_DEBIT_COMPLETE | VARCHAR2 | (1) | Debit complete | |
DR_CR_CREDIT_COMPLETE | VARCHAR2 | (1) | Credit complete | |
CR_DR_DEBIT_COMPLETE | VARCHAR2 | (1) | Debit complete | |
CR_DR_CREDIT_COMPLETE | VARCHAR2 | (1) | Credit complete |
FUN.FUN_BAL_INTER_BSV_MAP_T does not reference any database object
FUN.FUN_BAL_INTER_BSV_MAP_T is referenced by following:
Description: | FUN_BAL_INTER_INT_GT is a global temporary table used internally by the Intercompany Balancing API. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_BAL_INTER_INT_GT_N1 | NONUNIQUE | GROUP_ID | |
FUN_BAL_INTER_INT_GT_N2 | NONUNIQUE | INTERCOMPANY_MODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Group Identifier | |
LEDGER_ID | NUMBER | (15) | Ledger Identifier | |
GL_DATE | DATE | Gl Date | ||
STATUS | VARCHAR2 | (5) | Status | |
DRIVING_DR_LE_ID | NUMBER | (15) | Driving Debit Legal Entity Identifier | |
DRIVING_CR_LE_ID | NUMBER | (15) | Driving Credit Legal Entity Identifier | |
INTERCOMPANY_MODE | NUMBER | (4) | Intercompany Mode | |
LE_ID | NUMBER | (15) | Legal Entity Identifier | |
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | Entered Currency Code | |
ACCOUNTED_AMT_CR | NUMBER | Accounted Amount Credit | ||
ACCOUNTED_AMT_DR | NUMBER | Accounted Amount Debit | ||
ENTERED_AMT_CR | NUMBER | Entered Amount Credit | ||
ENTERED_AMT_DR | NUMBER | Entered Identifier Debit | ||
REC_ACCT | NUMBER | (15) | Receivables Account | |
PAY_ACCT | NUMBER | (15) | Payables Account | |
BAL_SEG_COLUMN_NAME | VARCHAR2 | (25) | Bal Seg Column Name | |
REC_BSV | VARCHAR2 | (25) | Rec Bsv | |
PAY_BSV | VARCHAR2 | (25) | Pay Bsv | |
EXCHANGE_DATE | DATE | Exchange Date | ||
EXCHANGE_RATE | NUMBER | Exchange Rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange Rate Type | |
TYPE | VARCHAR2 | (1) | Type | |
DRIVING_DR_LE_BSV | VARCHAR2 | (25) | Driving Dr Le Bsv | |
DRIVING_CR_LE_BSV | VARCHAR2 | (25) | Driving Cr Le Bsv | |
LINE_LE_BSV | VARCHAR2 | (25) | Line Le Bsv |
FUN.FUN_BAL_INTER_INT_GT does not reference any database object
FUN.FUN_BAL_INTER_INT_GT is referenced by following:
Description: | FUN_BAL_INTER_INT_T is a temporary table used internally by the Intercompany Balancing API. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Group identifier | |
LEDGER_ID | NUMBER | (15) | Ledger identifier | |
GL_DATE | DATE | GL Date | ||
STATUS | VARCHAR2 | (5) | Status | |
DRIVING_DR_LE_ID | NUMBER | (15) | Driving debit legal entity identifier | |
DRIVING_CR_LE_ID | NUMBER | (15) | Driving credit legal entity identifier | |
INTERCOMPANY_MODE | NUMBER | (4) | Intercompany mode | |
LE_ID | NUMBER | (15) | Legal entity identifier | |
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | Entered currency code | |
ACCOUNTED_AMT_CR | NUMBER | Accounted credit amount | ||
ACCOUNTED_AMT_DR | NUMBER | Accounted debit amount | ||
ENTERED_AMT_CR | NUMBER | Entered credit amount | ||
ENTERED_AMT_DR | NUMBER | Entered debit amount | ||
REC_ACCT | NUMBER | (15) | Receivables account | |
PAY_ACCT | NUMBER | (15) | Payables account | |
BAL_SEG_COLUMN_NAME | VARCHAR2 | (25) | Balancing segment column name | |
REC_BSV | VARCHAR2 | (25) | Receivables balancing segment value | |
PAY_BSV | VARCHAR2 | (25) | Payables balancing segment value | |
EXCHANGE_DATE | DATE | Currency exchange date | ||
EXCHANGE_RATE | NUMBER | Currency exchange rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Currency exchange rate type | |
TYPE | VARCHAR2 | (1) | Type | |
DRIVING_DR_LE_BSV | VARCHAR2 | (25) | ||
DRIVING_CR_LE_BSV | VARCHAR2 | (25) | ||
LINE_LE_BSV | VARCHAR2 | (25) |
FUN.FUN_BAL_INTER_INT_T does not reference any database object
FUN.FUN_BAL_INTER_INT_T is referenced by following:
Description: | FUN_BAL_INTRA_BSV_MAP_T is a temporary table used internally by the Intercompany balancing API. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Y | Group identifier |
LEDGER_ID | NUMBER | (15) | Y | Ledger identifier |
LE_ID | NUMBER | (15) | Legal entity identifier | |
BAL_SEG_VAL | VARCHAR2 | (25) | Y | Balancing segment value |
GL_DATE | DATE | GL Date | ||
DRIVING_DR_BSV | VARCHAR2 | (25) | Driving debit balancing segment value | |
DRIVING_CR_BSV | VARCHAR2 | (25) | Driving credit balancing segment value | |
INTRACOMPANY_MODE | NUMBER | (4) | Intracompany mode | |
TEMPLATE_ID | NUMBER | Template identifier | ||
BALANCE_BY | VARCHAR2 | (1) | Balance by | |
CLEARING_OPTION | VARCHAR2 | (2) | Clearing option | |
JE_SOURCE_NAME | VARCHAR2 | (25) | Journal source name | |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Journal category name | |
CLEARING_BSV | VARCHAR2 | (25) | Clearing balancing segment value | |
DR_CR_DEBIT_CCID | NUMBER | (15) | Debit account | |
DR_CR_CREDIT_CCID | NUMBER | (15) | Credit account | |
CR_DR_DEBIT_CCID | NUMBER | (15) | Debit account | |
CR_DR_CREDIT_CCID | NUMBER | (15) | Credit account | |
BAL_SEG_COLUMN_NUMBER | NUMBER | (2) | Balancing segment column number | |
INTERCOMPANY_COLUMN_NUMBER | NUMBER | (2) | Intercompany segment column number | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Chart of accounts identifier | |
MANY_TO_MANY_OPTION | VARCHAR2 | (2) | Many to many option | |
DR_CR_DEBIT_COMPLETE | VARCHAR2 | (1) | Debit complete | |
DR_CR_CREDIT_COMPLETE | VARCHAR2 | (1) | Credit complete | |
CR_DR_DEBIT_COMPLETE | VARCHAR2 | (1) | Debit complete | |
CR_DR_CREDIT_COMPLETE | VARCHAR2 | (1) | Credit complete |
FUN.FUN_BAL_INTRA_BSV_MAP_T does not reference any database object
FUN.FUN_BAL_INTRA_BSV_MAP_T is referenced by following:
Description: | FUN_BAL_INTRA_INT_GT is a global temporary table used internally by the Intercompany Balancing API |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_BAL_INTRA_INT_GT_N1 | NONUNIQUE |
GROUP_ID
LE_ID BAL_SEG_VAL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Group Identifier | |
LE_ID | NUMBER | (15) | Le Identifier | |
BAL_SEG_VAL | VARCHAR2 | (25) | Balancing Seg Val | |
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | Entered Currency Code | |
EXCHANGE_DATE | DATE | Exchange Date | ||
EXCHANGE_RATE | NUMBER | Exchange Rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange Rate Type | |
GL_DATE | DATE | Gl Date | ||
DRIVING_DR_BSV | VARCHAR2 | (25) | Driving Dr BSV | |
DRIVING_CR_BSV | VARCHAR2 | (25) | Driving Credit BSV | |
INTRACOMPANY_MODE | NUMBER | (4) | Intracompany Mode | |
BALANCE_BY | VARCHAR2 | (1) | Balance By | |
CLEARING_BSV | VARCHAR2 | (25) | Clearing BSV | |
TEMPLATE_ID | NUMBER | (15) | Template Identifier | |
CLEARING_OPTION | VARCHAR2 | (2) | Clearing Option | |
DR_CR_DEBIT_CCID | NUMBER | (15) | Debit Credit Debit Ccid | |
DR_CR_CREDIT_CCID | NUMBER | (15) | Debit Credit Credit Ccid | |
CR_DR_DEBIT_CCID | NUMBER | (15) | Credit Debit Debit Ccid | |
CR_DR_CREDIT_CCID | NUMBER | (15) | Credit Debit Credit Ccid | |
ACCOUNTED_AMT_CR | NUMBER | Accounted Amount Credit | ||
ACCOUNTED_AMT_DR | NUMBER | Accounted Amount Debit | ||
ENTERED_AMT_CR | NUMBER | Entered Amount Credit | ||
ENTERED_AMT_DR | NUMBER | Entered Amount Debit | ||
TYPE | VARCHAR2 | (1) | Type |
FUN.FUN_BAL_INTRA_INT_GT does not reference any database object
FUN.FUN_BAL_INTRA_INT_GT is referenced by following:
Description: | FUN_BAL_IINTRA_INT_T is a temporary table used internally by the Intercompany Balancing API. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Group identifier | |
LE_ID | NUMBER | (15) | Legal entity identifier | |
BAL_SEG_VAL | VARCHAR2 | (25) | Balancing segment value | |
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | Entered currency code | |
EXCHANGE_DATE | DATE | Currency exchange date | ||
EXCHANGE_RATE | NUMBER | Currency exchange rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Currency exchange rate type | |
GL_DATE | DATE | GL Date | ||
DRIVING_DR_BSV | VARCHAR2 | (25) | Driving debit balancing segment value | |
DRIVING_CR_BSV | VARCHAR2 | (25) | Driving credit balancing segment value | |
INTRACOMPANY_MODE | NUMBER | (4) | Intracompany mode | |
BALANCE_BY | VARCHAR2 | (1) | Balance by | |
CLEARING_BSV | VARCHAR2 | (25) | Clearing balancing segment value | |
TEMPLATE_ID | NUMBER | (15) | Template identifier | |
CLEARING_OPTION | VARCHAR2 | (2) | Clearing option | |
DR_CR_DEBIT_CCID | NUMBER | (15) | Debit account | |
DR_CR_CREDIT_CCID | NUMBER | (15) | Credit account | |
CR_DR_DEBIT_CCID | NUMBER | (15) | Debit account | |
CR_DR_CREDIT_CCID | NUMBER | (15) | Credit Account | |
ACCOUNTED_AMT_CR | NUMBER | Accounted credit amount | ||
ACCOUNTED_AMT_DR | NUMBER | Accounted debit amount | ||
ENTERED_AMT_CR | NUMBER | Entered credit amount | ||
ENTERED_AMT_DR | NUMBER | Entered debit amount | ||
TYPE | VARCHAR2 | (1) | Type |
FUN.FUN_BAL_INTRA_INT_T does not reference any database object
FUN.FUN_BAL_INTRA_INT_T is referenced by following:
Description: | FUN_BAL_LE_BSV_MAP_GT is a global temporary table used internally by the Intercompany Balancing API |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_BAL_LE_BSV_MAP_GT_N1 | NONUNIQUE |
GROUP_ID
LEDGER_ID LE_ID BAL_SEG_VAL | |
FUN_BAL_LE_BSV_MAP_GT_N2 | NONUNIQUE | INTRACOMPANY_MODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Y | Group Identifier |
LEDGER_ID | NUMBER | (15) | Y | Ledger Identifier |
LE_ID | NUMBER | (15) | Le Identifier | |
BAL_SEG_VAL | VARCHAR2 | (25) | Y | Bal Seg Val |
GL_DATE | DATE | Gl Date | ||
DRIVING_DR_BSV | VARCHAR2 | (25) | Driving Debit Bsv | |
DRIVING_CR_BSV | VARCHAR2 | (25) | Driving Credit Bsv | |
INTRACOMPANY_MODE | NUMBER | (4) | Intracompany Mode | |
TEMPLATE_ID | NUMBER | Template Identifier | ||
BALANCE_BY | VARCHAR2 | (1) | Balance By | |
CLEARING_OPTION | VARCHAR2 | (2) | Clearing Option | |
JE_SOURCE_NAME | VARCHAR2 | (25) | Journal Source Name | |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Journal Category Name | |
CLEARING_BSV | VARCHAR2 | (25) | Clearing Bsv | |
DR_CR_DEBIT_CCID | NUMBER | (15) | Debit Credit Debit Ccid | |
DR_CR_CREDIT_CCID | NUMBER | (15) | Debit Credit Credit Ccid | |
CR_DR_DEBIT_CCID | NUMBER | (15) | Credit Debit Debit Ccid | |
CR_DR_CREDIT_CCID | NUMBER | (15) | Credit Debit Credit Ccid | |
BAL_SEG_COLUMN_NUMBER | NUMBER | (2) | ||
INTERCOMPANY_COLUMN_NUMBER | NUMBER | (2) | Intercompany Column Number | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Chart Of Accounts Identifier | |
MANY_TO_MANY_OPTION | VARCHAR2 | (2) | Many To Many Option | |
DR_CR_DEBIT_COMPLETE | VARCHAR2 | (1) | Debit Complete | |
DR_CR_CREDIT_COMPLETE | VARCHAR2 | (1) | Credit Complete | |
CR_DR_DEBIT_COMPLETE | VARCHAR2 | (1) | Debit Complete | |
CR_DR_CREDIT_COMPLETE | VARCHAR2 | (1) | Credit Complete |
FUN.FUN_BAL_LE_BSV_MAP_GT does not reference any database object
FUN.FUN_BAL_LE_BSV_MAP_GT is referenced by following:
Description: | FUN_BAL_LINES_GT is a global temporary table used by the Intercompany Balancing API. Calling modules like SLA and GL populate this table with the details of the journals that needs to be balanced and then invoke the Intercompany Balancing A |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_BAL_LINES_GT_N1 | NONUNIQUE |
GROUP_ID
BAL_SEG_VAL | |
FUN_BAL_LINES_GT_N2 | NONUNIQUE | GENERATED |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Y | Group Id |
BAL_SEG_VAL | VARCHAR2 | (25) | Balancing Segment Value | |
ENTERED_AMT_DR | NUMBER | Entered Amount Debit | ||
ENTERED_AMT_CR | NUMBER | Entered Amount Credit | ||
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | Entered Currency Code | |
EXCHANGE_DATE | DATE | Exchange Date | ||
EXCHANGE_RATE | NUMBER | Exchange Rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange Rate Type | |
ACCOUNTED_AMT_DR | NUMBER | Accounted Amount Debit | ||
ACCOUNTED_AMT_CR | NUMBER | Accounted Amount Credit | ||
LINE_REFERENCE | VARCHAR2 | (25) | Line Reference | |
GENERATED | VARCHAR2 | (1) | Y | Indicates whether the line has been generated by balancing API |
CCID | NUMBER | (15) | Code Combination Identifier |
FUN.FUN_BAL_LINES_GT does not reference any database object
FUN.FUN_BAL_LINES_GT is referenced by following:
Description: | FUN_BAL_LINES_T is a temporary table used internally by the Intercompany Balancing API. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Y | Group identifier |
BAL_SEG_VAL | VARCHAR2 | (25) | BSV on journal line | |
ENTERED_AMT_DR | NUMBER | Entered debit amount | ||
ENTERED_AMT_CR | NUMBER | Entered credit amount | ||
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | Entered currency code | |
EXCHANGE_DATE | DATE | Currency exchange date | ||
EXCHANGE_RATE | NUMBER | Currency exchange rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Currency exchange rate type | |
ACCOUNTED_AMT_DR | NUMBER | Accounted debit amount | ||
ACCOUNTED_AMT_CR | NUMBER | Accounted credit amount | ||
LINE_REFERENCE | VARCHAR2 | (25) | Line reference | |
GENERATED | VARCHAR2 | (1) | Y | Indicates whether the line has been generated by balancing API |
CCID | NUMBER | (15) |
FUN.FUN_BAL_LINES_T does not reference any database object
FUN.FUN_BAL_LINES_T is referenced by following:
Description: | FUN_BAL_RESULTS_GT is a global temporary table used by the Intercompany balancing API. After balancing an Intercompany journal, the Intercompany balancing API inserts the resulting balancing lines into this table. Calling modules like SLA a |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Group Id | |
BAL_SEG_VAL | VARCHAR2 | (25) | Bal Seg Val | |
ENTERED_AMT_DR | NUMBER | Entered Amt Debit | ||
ENTERED_AMT_CR | NUMBER | Entered Amt Credit | ||
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | Entered Currency Code | |
EXCHANGE_DATE | DATE | Exchange Date | ||
EXCHANGE_RATE | NUMBER | Exchange Rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange Rate Type | |
ACCOUNTED_AMT_DR | NUMBER | Accounted Amt Debit | ||
ACCOUNTED_AMT_CR | NUMBER | Accounted Amt Credit | ||
CCID | NUMBER | (15) | Ccid | |
JGZZ_RECON_STATUS | VARCHAR2 | (1) | GL Reconciliation column. Currently not used. | |
JGZZ_RECON_DATE | DATE | GL Reconciliation column. Currently not used. | ||
JGZZ_RECON_ID | NUMBER | (15) | GL Reconciliation column. Currently not used. | |
JGZZ_RECON_REF | VARCHAR2 | (240) | GL Reconciliation column. Currently not used. | |
JGZZ_RECON_CONTEXT | VARCHAR2 | (30) | GL Reconciliation column. Currently not used. | |
DR_BSV | VARCHAR2 | (25) | Debit Bsv | |
CR_BSV | VARCHAR2 | (25) | Credit Bsv | |
ACCT_TYPE | VARCHAR2 | (1) | Acct Type | |
TEMPLATE_ID | NUMBER | (15) | Template Id | |
LE_ID | NUMBER | (15) | Legal Entity Identifier | |
BALANCING_TYPE | VARCHAR2 | (1) | Balancing Type |
FUN.FUN_BAL_RESULTS_GT does not reference any database object
FUN.FUN_BAL_RESULTS_GT is referenced by following:
Description: | FUN_BAL_RESULTS_T is a temporary table used internally by the Intercompany balancing API. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Group identifier | |
BAL_SEG_VAL | VARCHAR2 | (25) | ||
ENTERED_AMT_DR | NUMBER | (15) | Entered debit amount | |
ENTERED_AMT_CR | NUMBER | (15) | Entered credit amount | |
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | Entered currency code | |
EXCHANGE_DATE | DATE | Currency exchange date | ||
EXCHANGE_RATE | NUMBER | Currency exchange rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Currency exchange rate type | |
ACCOUNTED_AMT_DR | NUMBER | Accounted debit amount | ||
ACCOUNTED_AMT_CR | NUMBER | Accounted credit amount | ||
CCID | NUMBER | (15) | Code combination identifier | |
JGZZ_RECON_STATUS | VARCHAR2 | (1) | GL Reconciliation column. Currently not used. | |
JGZZ_RECON_DATE | DATE | GL Reconciliation column. Currently not used. | ||
JGZZ_RECON_ID | NUMBER | (15) | GL Reconciliation column. Currently not used. | |
JGZZ_RECON_REF | VARCHAR2 | (240) | GL Reconciliation column. Currently not used. | |
JGZZ_RECON_CONTEXT | VARCHAR2 | (30) | GL Reconciliation column. Currently not used. | |
DR_BSV | VARCHAR2 | (25) | Debit balancing segment value | |
CR_BSV | VARCHAR2 | (25) | Credit balancing segment value | |
ACCT_TYPE | VARCHAR2 | (1) | Account Type | |
TEMPLATE_ID | NUMBER | (15) | Template identifier | |
LE_ID | NUMBER | (15) | Legal entity identifier | |
BALANCING_TYPE | VARCHAR2 | (1) | Balancing type |
FUN.FUN_BAL_RESULTS_T does not reference any database object
FUN.FUN_BAL_RESULTS_T is referenced by following:
Description: | FUN_BATCH_DISTS stores the distribution details if user has chosen to enter distributions using the automatic proration mode. The amounts entered in this case are prorated for the recipients and distributions lines created in FUN_DIST_LINES |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_DIST_ID | NUMBER | (15) | Y | System generated batch distribution identifier |
LINE_NUMBER | NUMBER | Y | Line number | |
BATCH_ID | NUMBER | (15) | Y | Batch identifier |
CCID | NUMBER | (15) | Code combination identifier | |
AMOUNT_CR | NUMBER | Debit amount | ||
AMOUNT_DR | NUMBER | Credit amount | ||
DESCRIPTION | VARCHAR2 | (240) | Description | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context |
FUN.FUN_BATCH_DISTS does not reference any database object
FUN.FUN_BATCH_DISTS is referenced by following:
Description: | This table contains information about the question or problem submitted by the end user that is stored in a prompt-value pair format. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_CONTACTUS_REQUEST_DATA_U1 | UNIQUE | APPS_TS_TX_IDX | DATA_ID |
FUN_CONTACTUS_REQUEST_DATA_N1 | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATA_ID | NUMBER | (15) | Y | Unique identifier for the request data |
REQUEST_ID | NUMBER | (15) | Y | Unique identifier for question or problem submitted by the end user |
PROMPT_CODE | VARCHAR2 | (150) | Y | Prompt; Lookup code for the FUN_CONTACTUS_REQUEST_PROMPT lookup type |
DATA | VARCHAR2 | (150) | Data for the corresponding prompt | |
CREATION_DATE | DATE | Standard WHO Column | ||
CREATED_BY | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard WHO Column |
FUN.FUN_CONTACTUS_REQUEST_DATA does not reference any database object
FUN.FUN_CONTACTUS_REQUEST_DATA is referenced by following:
Description: | This table contains the definition for the behavior of the Contact Us global button. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_CONTACTUS_SETUP_U1 | UNIQUE | APPS_TS_TX_IDX |
RULE_OBJECT_ID
RULE_DETAIL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_DETAIL_ID | NUMBER | Y | Rule detail identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
RULE_OBJECT_ID | NUMBER | (15) | Y | Rule object identifier |
FUN.FUN_CONTACTUS_SETUP does not reference any database object
FUN.FUN_CONTACTUS_SETUP is referenced by following:
Description: | FUN_CUSTOMER_MAPS stores the details of the customer to which an Intercompany organization is mapped. When an invoice is created in receivables for the Intercompany organization, the customer used will the one setup in this table. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_MAP_ID | NUMBER | (15) | Y | System generated primary key. |
RELATION_ID | NUMBER | (15) | Y | Foreign key to FUN_TRADE_RELATIONS.RELATION_ID |
CUST_ACCOUNT_ID | NUMBER | (15) | Y | Customer account identifier. Foreign key to HZ_CUST_ACCOUNTS. CUST_ACCOUNT_ID |
SITE_USE_ID | NUMBER | (15) | Customer account site use identifier. Foreign key to HZ_ACCT_SITE_USES_ALL. SITE_USE_ID | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. |
FUN.FUN_CUSTOMER_MAPS does not reference any database object
FUN.FUN_CUSTOMER_MAPS is referenced by following:
Description: | FUN_DIST_LINES stores the distributions for the Intercompany transactions. Both recipient and initiator distributions are stored in this table. Party_type_flag = I and dist_type_flag = L indicates an Initiator distribution line. Party_type_ |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_DIST_LINES_U1 | UNIQUE | APPS_TS_TX_IDX | DIST_ID |
FUN_DIST_LINES_N1 | NONUNIQUE | APPS_TS_TX_IDX | TRX_ID |
FUN_DIST_LINES_N2 | NONUNIQUE | APPS_TS_TX_IDX | LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIST_ID | NUMBER | (15) | Y | System generated primary key |
LINE_ID | NUMBER | (15) | Y | Line identifier |
DIST_NUMBER | NUMBER | Y | Distribution number | |
PARTY_ID | NUMBER | (15) | Y | Party Identifier. Stores the recipient party identifier if party_type_flag = R else stores the initiator party identifier. |
PARTY_TYPE_FLAG | VARCHAR2 | (1) | Y | Party type flag. Valid values are I, R |
DIST_TYPE_FLAG | VARCHAR2 | (1) | Y | Distribution type flag. Valid values are R, P, L |
BATCH_DIST_ID | NUMBER | (15) | Batch distribution Identifier if the distribution was created using the automatic proration method. | |
AMOUNT_CR | NUMBER | Credit amount | ||
AMOUNT_DR | NUMBER | Debit amount | ||
CCID | NUMBER | (15) | Code combination identifier | |
DESCRIPTION | VARCHAR2 | (250) | Description | |
AUTO_GENERATE_FLAG | VARCHAR2 | (1) | Y | Indicates whether this distribution line was manually entered or not. |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
TRX_ID | NUMBER | Transaction Identifier. |
FUN.FUN_DIST_LINES does not reference any database object
FUN.FUN_DIST_LINES is referenced by following:
Description: | /*# * Intercompany Batch Distributions Interface * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Batch Distributions Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_INTERFACE_BATCHDISTS_N1 | NONUNIQUE | APPS_TS_INTERFACE | BATCH_DIST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Y | /*# * System Generated Primary Key. * @rep:scope public * @rep:lifecycle active * @rep:displayname Batch Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
LINE_NUMBER | NUMBER | (15) | /*# * Line Number of the distribution. * @rep:scope public * @rep:lifecycle active * @rep:displayname Line Number * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
BATCH_DIST_ID | NUMBER | (15) | Y | /*# * Batch Distribution Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Batch Distribution Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
AMOUNT_CR | NUMBER | /*# * Credit Amount. * @rep:scope public * @rep:lifecycle active * @rep:displayname Amount CR * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
AMOUNT_DR | NUMBER | /*# * Debit Amount. * @rep:scope public * @rep:lifecycle active * @rep:displayname Amount DR * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
CCID | NUMBER | (15) | /*# * Account Code Combination Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname CCID * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
CREATED_BY | NUMBER | (15) | /*# * Who Column. * @rep:scope public * @rep:lifecycle active * @rep:displayname Created By * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
CREATION_DATE | DATE | /*# * Who Column. * @rep:scope public * @rep:lifecycle active * @rep:displayname Creation Date * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
LAST_UPDATED_BY | NUMBER | (15) | /*# * Who Column. * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Updated By * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
LAST_UPDATE_DATE | DATE | /*# * Who Column. * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Update Date * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | /*# * Who Column. * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Update Login * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
IMPORT_STATUS_CODE | VARCHAR2 | (15) | /*# * Import Program populates this with the status of Import(Accepted or Rejected). * @rep:scope public * @rep:lifecycle active * @rep:displayname Import Status Code * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) |
FUN.FUN_INTERFACE_BATCHDISTS does not reference any database object
FUN.FUN_INTERFACE_BATCHDISTS is referenced by following:
Description: | /*# * Open interface table for Intercompany Batches. * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Batches Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_INTERFACE_BATCHES_N1 | NONUNIQUE | APPS_TS_INTERFACE |
SOURCE
GROUP_ID |
FUN_INTERFACE_BATCHES_N2 | NONUNIQUE | APPS_TS_INTERFACE | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE | VARCHAR2 | (25) | Y | /*# * Source of external system from where records are imported. * @rep:scope public * @rep:lifecycle active * @rep:displayname Source * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
GROUP_ID | NUMBER | (15) | Y | /*# * Logical Grouping of Batches into Group. It should match Group Id in the fun_interface_controls table. * @rep:scope public * @rep:lifecycle active * @rep:displayname Group Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
BATCH_ID | NUMBER | (15) | Y | /*# * System Generated Primary Key. * @rep:scope public * @rep:lifecycle active * @rep:displayname Batch Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
BATCH_NUMBER | VARCHAR2 | (15) | /*# * Unique for an Initiator. * @rep:scope public * @rep:lifecycle active * @rep:displayname Batch Number * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
INITIATOR_ID | NUMBER | (15) | /*# * The Party Id of the Intercompany Organization which Initiated the batch. * @rep:scope public * @rep:lifecycle active * @rep:displayname Initiator Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
INITIATOR_NAME | VARCHAR2 | (360) | /*# * Name of the Party. * @rep:scope public * @rep:lifecycle active * @rep:displayname Initiator Name * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
FROM_LE_ID | NUMBER | (15) | /*# * xle_entity_profiles.legal_entity_id of the Initiator Legal Entity. If none is provided, the Legal Entity Id is derived using the Initiator Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname From Legal Entity Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
FROM_LE_NAME | VARCHAR2 | (240) | /*# * Name of the Initiator Legal Entity. If none is provided, the Legal Entity Id is derived using the Initiator Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname From Legal Entity Name * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
FROM_LEDGER_ID | NUMBER | (15) | /*# * Initiator Ledger Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname From Ledger Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
CONTROL_TOTAL | NUMBER | /*# * Entered by the user as a placeholder to indicate the amount they would like the batch to add up to./ * It is not the total of all the transaction amounts in the batch. * @rep:scope public * @rep:lifecycle active * @rep:displayname Control Total * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
RUNNING_TOTAL_CR | NUMBER | /*# * The total of all the transaction credit amounts in the batchNote. A batch must have all/ * credits or all debit amounts, it cannot mix both. * @rep:scope public * @rep:lifecycle active * @rep:displayname Total running credit * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
RUNNING_TOTAL_DR | NUMBER | /*# * The total of all the transaction credit amounts in the batch note. A batch must have all / * credits or all debit amounts, it cannot mix both. * @rep:scope public * @rep:lifecycle active * @rep:displayname Total running debit * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
CURRENCY_CODE | VARCHAR2 | (15) | /*# * Currency of the batch, transactions in a batch must be in the same currency. * @rep:scope public * @rep:lifecycle active * @rep:displayname Currency Code * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | /*# * Exchange rate to use if batch is not in the initiator base currency. * @rep:scope public * @rep:lifecycle active * @rep:displayname Exchange rate type * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
DESCRIPTION | VARCHAR2 | (240) | /*# * The description is what will be passed to the Initiators GL or AR as the journal or invoice description. * @rep:scope public * @rep:lifecycle active * @rep:displayname Description * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
TRX_TYPE_ID | NUMBER | (15) | /*# * Transaction type of this batch. Must be present in fun_trx_types_b.trx_type_id. Either trx_type_id or trx_type_code or trx_type_name must be provided. * @rep:scope public * @rep:lifecycle active * @rep:displayname Transaction Type Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
TRX_TYPE_CODE | VARCHAR2 | (15) | /*# * Transaction type code of this batch. Must be present in fun_trx_types_b.trx_type_code. Either trx_type_id or trx_type_code or trx_type_name must be provided. * correct Batch Id on that instance. * @rep:scope public * @rep:lifecycle active * @rep:displayname Transaction Type Code * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
TRX_TYPE_NAME | VARCHAR2 | (25) | /*# * Name of the Transaction. Must be present in fun_trx_types_b.trx_type_name. Either trx_type_id or trx_type_code or trx_type_name must be provided. * @rep:scope public * @rep:lifecycle active * @rep:displayname Transaction Type Name * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
GL_DATE | DATE | Y | /*# * GL Date of the batch. * @rep:scope public * @rep:lifecycle active * @rep:displayname GL Date * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
BATCH_DATE | DATE | Y | /*# * Batch entered date. * @rep:scope public * @rep:lifecycle active * @rep:displayname Batch Date * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
REJECT_ALLOWED_FLAG | VARCHAR2 | (1) | /*# * Whether the transactions in this batch can be rejected. * @rep:scope public * @rep:lifecycle active * @rep:displayname Reject allowed flag * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
FROM_RECURRING_BATCH_ID | NUMBER | (15) | /*# * Currently only used for transactions upgraded from GIS. * @rep:scope public * @rep:lifecycle active * @rep:displayname Recurring Batch Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
IMPORT_STATUS_CODE | VARCHAR2 | (15) | /*# * Import Program populates this with the status of Import. * @rep:scope public * @rep:lifecycle active * @rep:displayname Import Status Code * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
NOTE | VARCHAR2 | (240) |
FUN.FUN_INTERFACE_BATCHES does not reference any database object
FUN.FUN_INTERFACE_BATCHES is referenced by following:
Description: | /*# * Intercompany Open Interface Control table. * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Control Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_INTERFACE_CONTROLS_N1 | NONUNIQUE | APPS_TS_INTERFACE |
SOURCE
GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Y | /*# * Source and Group_id form the unique key. * Sequence to use for group_id is fun_interface_controls_s * @rep:scope public * @rep:lifecycle active * @rep:displayname Group Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
SOURCE | VARCHAR2 | (25) | Y | /*# * Source and Group Id form the unique key. * @rep:scope public * @rep:lifecycle active * @rep:displayname Source * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
REQUEST_ID | NUMBER | (15) | /*# * Import Program populates this column with the latest Request Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Request Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
DATE_PROCESSED | DATE | /*# * Import Program populates this column with latest date on which the request was run. * @rep:scope public * @rep:lifecycle active * @rep:displayname Date Processed * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
FUN.FUN_INTERFACE_CONTROLS does not reference any database object
FUN.FUN_INTERFACE_CONTROLS is referenced by following:
Description: | /*# * Intercompany Distributions Open Interface * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Distributions Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_INTERFACE_DIST_LINES_N1 | NONUNIQUE | APPS_TS_INTERFACE | DIST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_ID | NUMBER | (15) | Y | /*# * Transaction Id from fun_interface_headers. * @rep:scope public * @rep:lifecycle active * @rep:displayname Transaction Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
DIST_ID | NUMBER | (15) | Y | /*# * Distribution Id, system Generated through sequence. * @rep:scope public * @rep:lifecycle active * @rep:displayname Distribution Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
BATCH_DIST_ID | NUMBER | (15) | /*# * Batch Distribution Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Batch Distribution Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
DIST_NUMBER | NUMBER | (15) | /*# * Distribution number. * @rep:scope public * @rep:lifecycle active * @rep:displayname Distribution Number * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
PARTY_ID | NUMBER | Y | /*# * Party Id of the Initiator or Recipient. * @rep:scope public * @rep:lifecycle active * @rep:displayname Party Id. * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
PARTY_TYPE_FLAG | VARCHAR2 | (1) | Y | /*# * Party Type Flag. * @rep:scope public * @rep:lifecycle active * @rep:displayname Party Type Flag * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
DIST_TYPE_FLAG | VARCHAR2 | (1) | Y | /*# * Distribution Type Flag. * @rep:scope public * @rep:lifecycle active * @rep:displayname Distribution Type Flag * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
AMOUNT_CR | NUMBER | |||
AMOUNT_DR | NUMBER | |||
CCID | NUMBER | (15) | /*# * Account Code Combination Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname CCID * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | /*# * Who Column. * @rep:scope public * @rep:lifecycle active * @rep:displayname Created By * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
CREATION_DATE | DATE | /*# * Who Column. * @rep:scope public * @rep:lifecycle active * @rep:displayname Creation Date * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
LAST_UPDATED_BY | NUMBER | (15) | /*# * Who Column. * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Updated By * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
LAST_UPDATE_DATE | DATE | /*# * Who Column. * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Update Date * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | /*# * Who Column. * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Update Login * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
IMPORT_STATUS_CODE | VARCHAR2 | (15) | /*# * Import Program populates this with the status of Import(Accepted or Rejected). * @rep:scope public * @rep:lifecycle active * @rep:displayname Import Status Code * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
DESCRIPTION | VARCHAR2 | (240) |
FUN.FUN_INTERFACE_DIST_LINES does not reference any database object
FUN.FUN_INTERFACE_DIST_LINES is referenced by following:
Description: | /*# * Intercompany Transactions Open Interface * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Transaction Headers Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_INTERFACE_HEADERS_N1 | NONUNIQUE | APPS_TS_INTERFACE | TRX_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_ID | NUMBER | (15) | Y | /*# * Primary key based on sequence fun_trx_headers_s. * @rep:scope public * @rep:lifecycle active * @rep:displayname Transaction Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
TRX_NUMBER | VARCHAR2 | (15) | /*# * User entered number for the transaction. Transaction Number must be unique for the batch. * @rep:scope public * @rep:lifecycle active * @rep:displayname Transaction Number * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
RECIPIENT_ID | NUMBER | (15) | /*# * hz_party.party_id of the Recipient Organization. Recipient Id or the Recipient Name must be provided. * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
RECIPIENT_NAME | VARCHAR2 | (360) | /*# * Name of the Recipient Organization. Recipient Id or the Recipient Name must be provided. * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Name * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
TO_LE_ID | NUMBER | (15) | /*# * xle_entity_profiles.legal_entity_id assigned for the Recipient Organization. If none is provided, the Legal Entity Id will be derived from the Recipient Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Legal Entity Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
TO_LE_NAME | VARCHAR2 | (240) | /*# * Legal Entity Name of the Recipient Organization. If none is provided, the Legal Entity Id will be derived from the Recipient Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Legal Entity Name * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
TO_LEDGER_ID | NUMBER | (15) | /*# * gl_ledgers.ledger_id of the Ledger assigned to Recipient Organization. If none is provided, the Ledger Id will be derived from the Recipient Id * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Ledger Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
BATCH_ID | NUMBER | (15) | Y | /*# * Unique Id of the batch. Must be the same as fun_interface_batches.batch_id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Batch Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
INIT_AMOUNT_CR | NUMBER | /*# * Credit amount value for the Initiator * @rep:scope public * @rep:lifecycle active * @rep:displayname Initiator Amount Credit * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
INIT_AMOUNT_DR | NUMBER | /*# * Debit amount value for the Initiator * @rep:scope public * @rep:lifecycle active * @rep:displayname Initiator Amount Debit * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
INVOICING_RULE_FLAG | VARCHAR2 | (1) | Y | /*# * Flag to indicate if invoicing is required for the transaction * @rep:scope public * @rep:lifecycle active * @rep:displayname Invoicing Rule * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
FROM_RECURRING_TRX_ID | NUMBER | (15) | /*# * Recurring Transaction Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Recurring Transaction Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
INITIATOR_INSTANCE_FLAG | VARCHAR2 | (1) | /*# * Initiator Instance Flag * @rep:scope public * @rep:lifecycle active * @rep:displayname Initiator Instance Flag * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
RECIPIENT_INSTANCE_FLAG | VARCHAR2 | (1) | /*# * Recipient Instance Flag * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Instance Flag * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
DESCRIPTION | VARCHAR2 | (240) | /*# * Description for the Transaction * @rep:scope public * @rep:lifecycle active * @rep:displayname Transaction Description * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE1 | VARCHAR2 | (150) | /*# * Attribute 1 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute1 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE2 | VARCHAR2 | (150) | /*# * Attribute 2 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 2 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE3 | VARCHAR2 | (150) | /*# * Attribute 3 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 3 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE4 | VARCHAR2 | (150) | /*# * Attribute 4 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 4 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE5 | VARCHAR2 | (150) | /*# * Attribute 5 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 5 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE6 | VARCHAR2 | (150) | /*# * Attribute 6 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 6 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE7 | VARCHAR2 | (150) | /*# * Attribute 7 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 7 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE8 | VARCHAR2 | (150) | /*# * Attribute 8 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 8 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE9 | VARCHAR2 | (150) | /*# * Attribute 9 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 9 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE10 | VARCHAR2 | (150) | /*# * Attribute 10 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 10 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE11 | VARCHAR2 | (150) | /*# * Attribute 11 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 11 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE12 | VARCHAR2 | (150) | /*# * Attribute 12 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 12 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE13 | VARCHAR2 | (150) | /*# * Attribute 13 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 13 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE14 | VARCHAR2 | (150) | /*# * Attribute 14 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 14 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE15 | VARCHAR2 | (150) | /*# * Attribute 15 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 15 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | /*# * Attribute Category of the descriptive flexfield * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute Category * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
CREATED_BY | NUMBER | (15) | /*# * Created By User Id * @rep:scope public * @rep:lifecycle active * @rep:displayname Created By * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
CREATION_DATE | DATE | /*# * Creation Date * @rep:scope public * @rep:lifecycle active * @rep:displayname Creation Date * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
LAST_UPDATED_BY | NUMBER | (15) | /*# * Last Updated by User Id * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Updated By * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
LAST_UPDATE_DATE | DATE | /*# * Last Updated Date * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Update Date * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | /*# * Last Update Login * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Update Login * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ | |
IMPORT_STATUS_CODE | VARCHAR2 | (15) | /*# * Import Program populates this with the status of Import. * @rep:scope public * @rep:lifecycle active * @rep:displayname Import Status Code * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */ |
FUN.FUN_INTERFACE_HEADERS does not reference any database object
FUN.FUN_INTERFACE_HEADERS is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Y | |
TRX_ID | NUMBER | (15) | ||
DIST_ID | NUMBER | (15) | ||
BATCH_DIST_ID | NUMBER | (15) | ||
REJECT_CODE | VARCHAR2 | (30) | ||
REJECT_REASON | VARCHAR2 | (2000) |
FUN.FUN_INTERFACE_REJECTIONS does not reference any database object
FUN.FUN_INTERFACE_REJECTIONS is referenced by following:
Description: | FUN_INTER_ACCOUNTS table stores the Intercompany receivables and payables accounts defined for each transacting and trading legal entity relationship. The accounts can be defined either at the legal entity level or at the balancing segment |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_INTER_ACCOUNTS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
FROM_LE_ID
LEDGER_ID TO_LE_ID DEFAULT_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FROM_LE_ID | NUMBER | (15) | Y | Transacting or Initiating Legal Entity identifier |
LEDGER_ID | NUMBER | (15) | Y | Transacting or Originating Ledger identifier |
TO_LE_ID | NUMBER | (15) | Y | Trading or Receiving Legal Entity identifier |
CCID | NUMBER | (15) | Y | Code combination of account |
TYPE | VARCHAR2 | (30) | Y | Type of account. Valid values are - R (Intercompany Receivables) and P (Intercompany Payables) |
ACCT_DESC | VARCHAR2 | (240) | Natural account segment description. Currently not Used. | |
START_DATE | DATE | Y | Start date for accounts | |
END_DATE | DATE | End date for accounts | ||
DEFAULT_FLAG | VARCHAR2 | (1) | Flag to indicate the default account to be used in case of multiple accounts being setup for the same rule. | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
TRANS_BSV | VARCHAR2 | (150) | Transaction or Initiating balancing segment value | |
TP_BSV | VARCHAR2 | (150) | Trading or receiving balancing segment value |
FUN.FUN_INTER_ACCOUNTS does not reference any database object
FUN.FUN_INTER_ACCOUNTS is referenced by following:
Description: | FUN_INTER_ACCOUNTS_ADDL table stores the accounts generated by replacing the intercompany and balancing segment value from the defined Intercompany receivables and payables accounts with the trading partner and trasnacting BSV. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_INTER_ACCOUNTS_ADDL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
FROM_LE_ID
LEDGER_ID TO_LE_ID DEFAULT_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FROM_LE_ID | NUMBER | (15) | Y | Transacting or Initiating Legal Entity identifier |
LEDGER_ID | NUMBER | (15) | Y | Transacting or Originating Ledger identifier |
TO_LE_ID | NUMBER | (15) | Y | Trading or Receiving Legal Entity identifier |
CCID | NUMBER | (15) | Y | Code combination of account |
TYPE | VARCHAR2 | (30) | Y | Type of account. Valid values are - R (Intercompany Receivables) and P (Intercompany Payables) |
ACCT_DESC | VARCHAR2 | (240) | Natural account segment description. Currently not Used. | |
START_DATE | DATE | Y | Start date for accounts | |
END_DATE | DATE | End date for accounts | ||
DEFAULT_FLAG | VARCHAR2 | (1) | Flag to indicate the default account to be used in case of multiple accounts being setup for the same rule. | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
TRANS_BSV | VARCHAR2 | (150) | Transaction or Initiating balancing segment value | |
TP_BSV | VARCHAR2 | (150) | Trading or receiving balancing segment value |
FUN.FUN_INTER_ACCOUNTS_ADDL does not reference any database object
FUN.FUN_INTER_ACCOUNTS_ADDL is referenced by following:
Description: | FUN_NET_AGREEMENTS_ALL stores general information about Netting Agreements |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_NET_AGREEMENTS_U1 | UNIQUE | APPS_TS_TX_IDX | AGREEMENT_ID |
FUN_NET_AGREEMENTS_N1 | NONUNIQUE | APPS_TS_TX_IDX | AGREEMENT_NAME |
FUN_NET_AGREEMENTS_N2 | NONUNIQUE | APPS_TS_TX_IDX | APPROVER_NAME |
FUN_NET_AGREEMENTS_N3 | NONUNIQUE | APPS_TS_TX_IDX | BANK_ACCOUNT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGREEMENT_ID | NUMBER | (15) | Y | Netting Agreement Identifier. |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Y | Object Version Number |
AGREEMENT_NAME | VARCHAR2 | (250) | Y | Netting Agreement Name |
PARTNER_REFERENCE | VARCHAR2 | (80) | Trading Partner Reference | |
AGREEMENT_START_DATE | DATE | Y | Netting Agreement Start Date | |
AGREEMENT_END_DATE | DATE | Netting Agreement End Date | ||
IN_PROCESS_FLAG | VARCHAR2 | (1) | Y | Indicates whether the agreement is being used in the netting process |
SEL_REC_PAST_DUE_TXNS_FLAG | VARCHAR2 | (1) | Y | Indicates whether to select only Receivables past due transactions in the netting process |
DAYS_PAST_DUE | NUMBER | (4) | Number of days past due for Receivable transactions | |
NET_CURRENCY_RULE_CODE | VARCHAR2 | (30) | Y | Netting currency grouping or conversion rule |
NET_ORDER_RULE_CODE | VARCHAR2 | (30) | Y | Netting rule which determines the order to sort transactions. |
NET_BALANCE_RULE_CODE | VARCHAR2 | (30) | Y | Netting rule based on Payables and Receivables balances |
SHIKYU_RULE_CODE | VARCHAR2 | (1) | Indicates whether to include or exclude invoices based on their Shikyu value, or to disregard the value altogether .Used in Japan only | |
BANK_ACCOUNT_ID | NUMBER | (15) | Netting Bank Account Identifier | |
NET_CURRENCY_CODE | VARCHAR2 | (12) | Currency Code | |
APPROVER_NAME | VARCHAR2 | (320) | Approver Name | |
NON_RESPONSE_ACTION_CODE | VARCHAR2 | (15) | Action to non response for Netting Batch approval | |
ORG_ID | NUMBER | (15) | Y | Organization identifier. |
CREATION_DATE | DATE | Y | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment. |
FUN.FUN_NET_AGREEMENTS_ALL does not reference any database object
FUN.FUN_NET_AGREEMENTS_ALL is referenced by following:
Description: | FUN_NET_AP_INVS_ALL stores information about Payables invoices included in Netting Batch. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_NET_AP_INVS_ALL_U1 | UNIQUE | APPS_TS_TX_IDX |
BATCH_ID
INVOICE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Y | Batch Identifier. |
INVOICE_ID | NUMBER | (15) | Y | Payables Invoice Identifier. |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Y | Object Version Number. |
AP_TXN_RANK | NUMBER | (15) | Y | Rank of the Payables Invoice. |
INVOICE_AMT | NUMBER | Y | Invoice Amount. | |
NETTED_AMT | NUMBER | Netted Amount in Batch Currency | ||
OPEN_AMT | NUMBER | Y | Open Amount in Batch Currency | |
INV_CURR_NET_AMT | NUMBER | Netting Amount in Invoice Currency. | ||
INV_CURR_OPEN_AMT | NUMBER | Netting Open Amount in Invoice Currency | ||
CHECK_ID | NUMBER | (15) | Check Id or Payment identifier | |
ORG_ID | NUMBER | (15) | Y | Organization Identifier |
CREATION_DATE | DATE | Y | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment. |
FUN.FUN_NET_AP_INVS_ALL does not reference any database object
FUN.FUN_NET_AP_INVS_ALL is referenced by following:
Description: | FUN_NET_AP_INV_TYPES_ALL stores information about the Payables Invoice Types that are included in a Netting Agreement |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_NET_AP_INV_TYPES_U1 | UNIQUE | APPS_TS_TX_IDX |
AGREEMENT_ID
INVOICE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGREEMENT_ID | NUMBER | Y | Netting Agreement Identifier | |
INVOICE_TYPE | VARCHAR2 | (25) | Y | Invoice Type. |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Y | Object Version Number |
ORG_ID | NUMBER | (15) | Y | Organization Identifier |
CREATION_DATE | DATE | Y | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment. |
FUN.FUN_NET_AP_INV_TYPES_ALL does not reference any database object
FUN.FUN_NET_AP_INV_TYPES_ALL is referenced by following:
Description: | FUN_NET_AR_TRX_TYPES_ALL stores information about the ReceivablesTransaction Types that are included in a Netting Agreement. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_NET_AR_TRX_TYPES_U1 | UNIQUE | APPS_TS_TX_IDX |
AGREEMENT_ID
CUST_TRX_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGREEMENT_ID | NUMBER | (15) | Y | Netting Agreement Identifier |
CUST_TRX_TYPE_ID | NUMBER | (25) | Y | Customer Transaction Type Internal Identifier |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Y | Object Version Number |
ORG_ID | NUMBER | (15) | Y | Organization Identifier. |
CREATION_DATE | DATE | Y | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment. |
FUN.FUN_NET_AR_TRX_TYPES_ALL does not reference any database object
FUN.FUN_NET_AR_TRX_TYPES_ALL is referenced by following:
Description: | FUN_NET_AR_TXNS_ALL stores information about Receivables Transactions included in Netting Batch. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_NET_AR_TXNS_ALL_U1 | UNIQUE | APPS_TS_TX_IDX |
BATCH_ID
CUSTOMER_TRX_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Y | Batch Identifier. |
CUSTOMER_TRX_ID | NUMBER | (15) | Y | Customer Transaction Identifier. |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Y | Object Version Number. |
AR_TXN_RANK | NUMBER | (15) | Y | Rank of the Customer Transaction. |
TRANSACTION_AMT | NUMBER | Y | Transaction Amount. | |
NETTED_AMT | NUMBER | Netted Amount in Batch Currency | ||
OPEN_AMT | NUMBER | Y | Open Amount in Batch Currency. | |
TXN_CURR_NET_AMT | NUMBER | Netting Amount in Transaction Currency. | ||
TXN_CURR_OPEN_AMT | NUMBER | Netting Open Amount in Transaction Currency. | ||
CASH_RECEIPT_ID | NUMBER | (15) | Cash Receipt Identifier | |
ORG_ID | NUMBER | (15) | Y | Organization Identifier. |
CREATION_DATE | DATE | Y | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment. |
FUN.FUN_NET_AR_TXNS_ALL does not reference any database object
FUN.FUN_NET_AR_TXNS_ALL is referenced by following:
Description: | FUN_NET_BATCHES_ALL stores information about Netting Batches. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_NET_BATCHES_ALL_U1 | UNIQUE | APPS_TS_TX_IDX | BATCH_ID |
FUN_NET_BATCHES_ALL_N1 | NONUNIQUE | APPS_TS_TX_IDX | AGREEMENT_ID |
FUN_NET_BATCHES_ALL_N2 | NONUNIQUE | APPS_TS_TX_IDX | BATCH_NUMBER |
FUN_NET_BATCHES_ALL_N3 | NONUNIQUE | APPS_TS_TX_IDX | BATCH_NAME |
FUN_NET_BATCHES_ALL_N4 | NONUNIQUE | APPS_TS_TX_IDX | BATCH_STATUS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Y | Batch Identifier. System generated primary key. |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Y | Object Version Number. |
AGREEMENT_ID | NUMBER | (15) | Agreement Identifier. | |
BATCH_NAME | VARCHAR2 | (80) | Y | Batch Name. |
BATCH_NUMBER | NUMBER | (15) | Y | Batch Number. |
REVIEW_NETTING_BATCH_FLAG | VARCHAR2 | (1) | Y | Whether or not to review the Netting Batch. |
BATCH_CURRENCY | VARCHAR2 | (15) | Batch Currency Code. | |
BATCH_STATUS_CODE | VARCHAR2 | (30) | Batch Status. | |
TOTAL_NETTED_AMT | NUMBER | Total netted amount. | ||
TRANSACTION_DUE_DATE | DATE | Date up to which all transactions will be selected. | ||
SETTLEMENT_DATE | DATE | Date when netting process will take place. | ||
RESPONSE_DATE | DATE | Date when response has to be received from approver. | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange Rate Type. | |
EXCHANGE_RATE | NUMBER | Exchange Rate. | ||
GL_DATE | DATE | Accounting Date. | ||
CHECKRUN_ID | NUMBER | (15) | Checkrun Id of AP Payment Batch Identifier. | |
ORG_ID | NUMBER | (15) | Y | Organization Identifier. |
CREATION_DATE | DATE | Y | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment. |
FUN.FUN_NET_BATCHES_ALL does not reference any database object
FUN.FUN_NET_BATCHES_ALL is referenced by following:
Description: | FUN_NET_CUSTOMERS_ALL stores information about the Customers that are included in a Netting Agreement. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_NET_CUSTOMERS_U1 | UNIQUE | APPS_TS_TX_IDX | NETTING_CUSTOMER_ID |
FUN_NET_CUSTOMERS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
AGREEMENT_ID
CUST_ACCOUNT_ID CUST_SITE_USE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NETTING_CUSTOMER_ID | NUMBER | (15) | Y | Netting Customer Identifier |
AGREEMENT_ID | NUMBER | (15) | Y | Netting Agreement Identifier |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Y | Object Version Number |
CUST_PRIORITY | NUMBER | (15) | Y | Customer Priority |
CUST_ACCOUNT_ID | NUMBER | (15) | Y | Customer Account Identifier |
CUST_SITE_USE_ID | NUMBER | (15) | Customer Account Site Identifier | |
ORG_ID | NUMBER | (15) | Y | Organization Identifier |
CREATION_DATE | DATE | Y | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment. |
FUN.FUN_NET_CUSTOMERS_ALL does not reference any database object
FUN.FUN_NET_CUSTOMERS_ALL is referenced by following:
Description: | FUN_NET_SUPPLIERS_ALL stores information about the Suppliers that are included in a Netting Agreement. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_NET_SUPPLIERS_U1 | UNIQUE | APPS_TS_TX_IDX | NETTING_SUPPLIER_ID |
FUN_NET_SUPPLIERS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
AGREEMENT_ID
SUPPLIER_ID SUPPLIER_SITE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NETTING_SUPPLIER_ID | NUMBER | (15) | Y | Netting Supplier Identifier |
AGREEMENT_ID | NUMBER | (15) | Y | Netting Agreement Identifier |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Y | Object Version Number |
SUPPLIER_PRIORITY | NUMBER | (15) | Y | Supplier Priority |
SUPPLIER_ID | NUMBER | (15) | Y | Supplier Identifier |
SUPPLIER_SITE_ID | NUMBER | (15) | Supplier site Identifier | |
ORG_ID | NUMBER | (15) | Y | Organization Identifier |
CREATION_DATE | DATE | Y | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment. |
FUN.FUN_NET_SUPPLIERS_ALL does not reference any database object
FUN.FUN_NET_SUPPLIERS_ALL is referenced by following:
Description: | FUN_PERIOD_STATUSES stores the Intercompany period statuses if an Intercompany calendar has been defined in system options. Intercompany period statuses are maintained at the Intercompany Transaction Type level i.e. periods can be opened an |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_PERIOD_STATUSES_U1 | UNIQUE | APPS_TS_TX_IDX |
INTECO_CALENDAR
INTECO_PERIOD_TYPE PERIOD_NAME TRX_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_NAME | VARCHAR2 | (15) | Y | Period name |
PERIOD_YEAR | NUMBER | (15) | Y | Period Year |
START_DATE | DATE | Y | Start date | |
END_DATE | DATE | Y | End date | |
YEAR_START_DATE | DATE | Year start date | ||
QUARTER_START_DATE | DATE | Quarter start date | ||
STATUS | VARCHAR2 | (15) | Y | Period status |
TRX_TYPE_ID | NUMBER | (15) | Y | Transaction type identifier |
PERIOD_NUM | NUMBER | (15) | Y | Period number |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
CREATED_BY | NUMBER | (15) | Standard Who column. | |
CREATION_DATE | DATE | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column. | |
LAST_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
INTECO_CALENDAR | VARCHAR2 | (15) | Intercompany calendar name | |
INTECO_PERIOD_TYPE | VARCHAR2 | (15) | Intercompany period type |
FUN.FUN_PERIOD_STATUSES does not reference any database object
FUN.FUN_PERIOD_STATUSES is referenced by following:
Description: | Stores information about rich messages which may contain HTML tags for pretty formatting. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RICH_MESSAGES_U1 | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
MESSAGE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Y | Application identifier |
MESSAGE_NAME | NVARCHAR2 | (60) | Y | Message name |
OBJECT_VERSION_NUMBER | NUMBER | Y | This column is used for locking purposes | |
CREATED_BY_MODULE | VARCHAR2 | (150) | Y | Financials Who column |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column |
FUN.FUN_RICH_MESSAGES_B does not reference any database object
FUN.FUN_RICH_MESSAGES_B is referenced by following:
Description: | Stores information about rich messages which may contain HTML tags for pretty formatting. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RICH_MESSAGES_TL_U1 | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
MESSAGE_NAME LANGUAGE |
SYS_IL0000399637C00003$$ | UNIQUE | APPS_TS_SEED |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | Y | Application identifier | |
MESSAGE_NAME | VARCHAR2 | (30) | Y | Message name |
MESSAGE_TEXT | CLOB | (4000) | Y | Rich message text |
LANGUAGE | VARCHAR2 | (4) | Y | Language |
SOURCE_LANG | VARCHAR2 | (4) | Y | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
FUN.FUN_RICH_MESSAGES_TL does not reference any database object
FUN.FUN_RICH_MESSAGES_TL is referenced by following:
Description: | Global temporary table used by the bulk API to store the result values. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_RESULT_BULK_GT_N1 | NONUNIQUE | ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | (15) | Y | Identifier which uniquely identifies the row in the parameter table used by the bulk API |
RULE_DETAIL_ID | NUMBER | (15) | Rule detail identifier | |
RULE_NAME | VARCHAR2 | (80) | Rule name | |
RESULT_APPLICATION_ID | NUMBER | (15) | Application identifier | |
RESULT_VALUE | VARCHAR2 | (1024) | Result value |
FUN.FUN_RULE_BULK_RESULT_GT does not reference any database object
FUN.FUN_RULE_BULK_RESULT_GT is referenced by following:
Description: | Stores a single criteria for a rule. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_CRITERIA_U1 | UNIQUE | APPS_TS_SEED | CRITERIA_ID |
FUN_RULE_CRITERIA_N2 | NONUNIQUE | APPS_TS_SEED |
RULE_DETAIL_ID
CRITERIA_PARAM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CRITERIA_ID | NUMBER | (15) | Y | Criteria identifier |
RULE_DETAIL_ID | NUMBER | (15) | Y | Rule detail identifier |
CRITERIA_PARAM_ID | NUMBER | (15) | Y | Criteria parameter identifier |
CONDITION | VARCHAR2 | (30) | Y | Condition for the criteria |
PARAM_VALUE | VARCHAR2 | (1024) | Criteria parameter value | |
CASE_SENSITIVE_FLAG | VARCHAR2 | (1) | Y | Case sentitive. Y or N. |
OBJECT_VERSION_NUMBER | NUMBER | Y | This column is used for locking purposes | |
CREATED_BY_MODULE | VARCHAR2 | (150) | Y | Financials Who column |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
FUN.FUN_RULE_CRITERIA does not reference any database object
FUN.FUN_RULE_CRITERIA is referenced by following:
Description: | Stores the available criteria parameters for a Rule Object. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_CRITERIA_PARAMS_U1 | UNIQUE | APPS_TS_SEED | CRITERIA_PARAM_ID |
FUN_RULE_CRITERIA_PARAMS_U2 | UNIQUE | APPS_TS_SEED |
RULE_OBJECT_ID
PARAM_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CRITERIA_PARAM_ID | NUMBER | (15) | Y | Criteria parameter identifier |
RULE_OBJECT_ID | NUMBER | (15) | Y | Rule Object identifier |
PARAM_NAME | VARCHAR2 | (30) | Y | Criteria parameter name |
DATA_TYPE | VARCHAR2 | (30) | Y | Data type for criteria parameter |
FLEX_VALUE_SET_ID | NUMBER | (15) | Y | Value set identifier |
OBJECT_VERSION_NUMBER | NUMBER | Y | This column is used for locking purposes | |
CREATED_BY_MODULE | VARCHAR2 | (150) | Y | Financials Who column |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
FUN.FUN_RULE_CRIT_PARAMS_B does not reference any database object
FUN.FUN_RULE_CRIT_PARAMS_B is referenced by following:
Description: | Stores the available criteria parameters for a Rule Object. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_CRIT_PARAMS_TL_U1 | UNIQUE | APPS_TS_SEED |
CRITERIA_PARAM_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CRITERIA_PARAM_ID | NUMBER | (15) | Y | Criteria parameter identifier |
USER_PARAM_NAME | VARCHAR2 | (50) | Y | Displayed parameter name |
DESCRIPTION | VARCHAR2 | (240) | Parameter description | |
TIP_TEXT | VARCHAR2 | (240) | Additional tip text for parameter | |
LANGUAGE | VARCHAR2 | (30) | Y | Language |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
SOURCE_LANG | VARCHAR2 | (4) | Y | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
FUN.FUN_RULE_CRIT_PARAMS_TL does not reference any database object
FUN.FUN_RULE_CRIT_PARAMS_TL is referenced by following:
Description: | Stores details about a rule. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_DETAILS_U1 | UNIQUE | APPS_TS_SEED | RULE_DETAIL_ID |
FUN_RULE_DETAILS_U2 | UNIQUE | APPS_TS_SEED |
RULE_OBJECT_ID
RULE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_DETAIL_ID | NUMBER | (15) | Y | Rule detail identifier |
RULE_OBJECT_ID | NUMBER | (15) | Y | Rule Object identifier |
RULE_NAME | VARCHAR2 | (80) | Y | Rule name |
SEQ | NUMBER | Y | Rule evaluation sequence | |
OPERATOR | VARCHAR2 | (3) | Y | Evaluation operator - AND or OR. |
ENABLED_FLAG | VARCHAR2 | (1) | Y | Enabled flag |
RESULT_APPLICATION_ID | NUMBER | (15) | Result application identifier. Only used if the Rule Object type is set to either Message dictionary or Rich messages. | |
RESULT_VALUE | VARCHAR2 | (1024) | Result value | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Used for locking purposes | |
CREATED_BY_MODULE | VARCHAR2 | (150) | Y | Financials Who column |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
FUN.FUN_RULE_DETAILS does not reference any database object
FUN.FUN_RULE_DETAILS is referenced by following:
Description: | Stores information about Rule Objects. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_OBJECTS_U1 | UNIQUE | APPS_TS_SEED | RULE_OBJECT_ID |
FUN_RULE_OBJECTS_U2 | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
RULE_OBJECT_NAME INSTANCE_LABEL ORG_ID |
FUN_RULE_OBJECTS_B_N2 | NONUNIQUE | APPS_TS_SEED | PARENT_RULE_OBJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_OBJECT_ID | NUMBER | (15) | Y | Rule Object identifier |
APPLICATION_ID | NUMBER | (15) | Y | Application identifier |
RULE_OBJECT_NAME | VARCHAR2 | (30) | Y | Rule Object name |
RESULT_TYPE | VARCHAR2 | (30) | Y | Rule Object result type |
REQUIRED_FLAG | VARCHAR2 | (1) | Y | Required flag. Y or N. |
FLEX_VALUE_SET_ID | NUMBER | (15) | Value set identifier | |
FLEXFIELD_NAME | VARCHAR2 | (80) | Flexfield name | |
FLEXFIELD_APP_SHORT_NAME | VARCHAR2 | (50) | Flexfield application short name | |
MULTI_RULE_RESULT_FLAG | VARCHAR2 | (1) | Y | Flag indicating that multiple results need to be returned. Y or N. |
OBJECT_VERSION_NUMBER | NUMBER | Y | Used for locking purposes | |
CREATED_BY_MODULE | VARCHAR2 | (150) | Y | Financials Who column |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
USE_DEFAULT_VALUE_FLAG | VARCHAR2 | (1) | Use Default Value Flag. Y or N | |
USE_INSTANCE_FLAG | VARCHAR2 | (1) | Y | |
INSTANCE_LABEL | VARCHAR2 | (150) | ||
PARENT_RULE_OBJECT_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) |
FUN.FUN_RULE_OBJECTS_B does not reference any database object
FUN.FUN_RULE_OBJECTS_B is referenced by following:
Description: | Stores information about Rule Objects. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_OBJECTS_TL_U1 | UNIQUE | APPS_TS_SEED |
RULE_OBJECT_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_OBJECT_ID | NUMBER | (15) | Y | Rule object identifier |
USER_RULE_OBJECT_NAME | VARCHAR2 | (50) | Y | Displayed Rule Object name |
DESCRIPTION | VARCHAR2 | (240) | Description | |
LANGUAGE | VARCHAR2 | (30) | Y | Language |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
SOURCE_LANG | VARCHAR2 | (4) | Y | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
FUN.FUN_RULE_OBJECTS_TL does not reference any database object
FUN.FUN_RULE_OBJECTS_TL is referenced by following:
Description: | Stores additional Rule Object attributes. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_OBJ_ATTRIBUTES_U1 | UNIQUE | APPS_TS_SEED | RULE_OBJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_OBJECT_ID | NUMBER | (15) | Y | Rule Object identifier |
DEFAULT_APPLICATION_ID | NUMBER | (15) | Default application identifier | |
DEFAULT_VALUE | VARCHAR2 | (1024) | Default value | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
FUN.FUN_RULE_OBJ_ATTRIBUTES does not reference any database object
FUN.FUN_RULE_OBJ_ATTRIBUTES is referenced by following:
Description: | Stores the multiple criteria parameter values that are used in evaluation of a criteria. If a criteria uses a parameters that is based on an independent or table based value set, the parameter value is compared against multiple values to se |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_PARAM_VALUES_U1 | UNIQUE | APPS_TS_SEED | RULE_PARAM_VALUE_ID |
FUN_RULE_PARAM_VALUES_N2 | NONUNIQUE | APPS_TS_SEED | CRITERIA_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_PARAM_VALUE_ID | NUMBER | (15) | Y | Rule parameter value identifier |
CRITERIA_ID | NUMBER | (15) | Y | Criteria identifier |
RULE_DETAIL_ID | NUMBER | (15) | Y | Rule detail identifier |
PARAM_VALUE | VARCHAR2 | (1024) | Parameter value | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Used for locking purposes |
FUN.FUN_RULE_PARAM_VALUES does not reference any database object
FUN.FUN_RULE_PARAM_VALUES is referenced by following:
Description: | Stores test cases for the Financials Rules Engine |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_TESTS_U1 | UNIQUE | APPS_TS_SEED | TEST_ID |
FUN_RULE_TESTS_U2 | UNIQUE | APPS_TS_SEED |
RULE_OBJECT_ID
TEST_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEST_ID | NUMBER | (15) | Y | Test identifier |
RULE_OBJECT_ID | NUMBER | (15) | Y | Rule Object identifier |
TEST_NAME | VARCHAR2 | (80) | Y | Test name |
EXPECTED_RULE_DETAIL_ID | NUMBER | (15) | Y | Active rule detail identifier for this test |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Used for locking purposes | |
NO_RESULT_FLAG | VARCHAR2 | (1) |
FUN.FUN_RULE_TESTS does not reference any database object
FUN.FUN_RULE_TESTS is referenced by following:
Description: | Stores the test results for a test if multiple results are allowed for the Rule Object |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_TEST_MULTIRULE_U1 | UNIQUE | APPS_TS_SEED |
TEST_ID
EXPECTED_RULE_DETAIL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEST_ID | NUMBER | (15) | Y | Test identifier |
EXPECTED_RULE_DETAIL_ID | NUMBER | (15) | Y | Active rule detail identifier for this test |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Y | Used for locking purposes |
FUN.FUN_RULE_TEST_MULTIRULE does not reference any database object
FUN.FUN_RULE_TEST_MULTIRULE is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEST_RESULTS_ID | NUMBER | (15) | Y | |
TEST_ID | NUMBER | (15) | Y | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
OBJECT_VERSION_NUMBER | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
FUN.FUN_RULE_TEST_MVAL_RES does not reference any database object
FUN.FUN_RULE_TEST_MVAL_RES is referenced by following:
Description: | Stores parameter values for tests. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_RULE_TEST_PARAMS_U1 | UNIQUE | APPS_TS_SEED |
TEST_ID
CRITERIA_PARAM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEST_ID | NUMBER | (15) | Y | Test identifier |
CRITERIA_PARAM_ID | NUMBER | (15) | Y | Criteria parameter identifier |
PARAM_VALUE | VARCHAR2 | (1024) | Parameter value | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Y | Used for locking purposes |
FUN.FUN_RULE_TEST_PARAMS does not reference any database object
FUN.FUN_RULE_TEST_PARAMS is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEST_ID | NUMBER | (15) | Y | |
RESULT_VALUE | VARCHAR2 | (1024) | ||
OBJECT_VERSION_NUMBER | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
TEST_RESULTS_ID | NUMBER | (15) | Y |
FUN.FUN_RULE_TEST_RESULTS does not reference any database object
FUN.FUN_RULE_TEST_RESULTS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_SEQ_ASSIGNMENTS_U1 | UNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_ID |
FUN_SEQ_ASSIGNMENTS_N1 | NONUNIQUE | APPS_TS_TX_IDX | SEQ_CONTEXT_ID |
FUN_SEQ_ASSIGNMENTS_N2 | NONUNIQUE | APPS_TS_TX_IDX | SEQ_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | Y | ||
SEQ_CONTEXT_ID | NUMBER | Y | ||
SEQ_HEADER_ID | NUMBER | |||
LINK_TO_ASSIGNMENT_ID | NUMBER | |||
PRIORITY | NUMBER | (15) | ||
CONTROL_ATTRIBUTE_STRUCTURE | VARCHAR2 | (150) | Y | |
BALANCE_TYPE | VARCHAR2 | (150) | ||
JOURNAL_SOURCE | VARCHAR2 | (150) | ||
JOURNAL_CATEGORY | VARCHAR2 | (150) | ||
ACCOUNTING_EVENT_TYPE | VARCHAR2 | (150) | ||
ACCOUNTING_ENTRY_TYPE | VARCHAR2 | (150) | ||
DOCUMENT_CATEGORY | VARCHAR2 | (150) | ||
OBJECT_VERSION_NUMBER | NUMBER | Y | ||
START_DATE | DATE | Y | ||
END_DATE | DATE | |||
USE_STATUS_CODE | VARCHAR2 | (30) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
FUN.FUN_SEQ_ASSIGNMENTS does not reference any database object
FUN.FUN_SEQ_ASSIGNMENTS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_SEQ_CONTEXTS_U1 | UNIQUE | APPS_TS_TX_IDX | SEQ_CONTEXT_ID |
FUN_SEQ_CONTEXTS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
TABLE_NAME CONTEXT_TYPE CONTEXT_VALUE EVENT_CODE OBSOLETE_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_CONTEXT_ID | NUMBER | Y | ||
APPLICATION_ID | NUMBER | Y | ||
TABLE_NAME | VARCHAR2 | (30) | Y | |
CONTEXT_TYPE | VARCHAR2 | (30) | Y | |
CONTEXT_VALUE | VARCHAR2 | (30) | Y | |
EVENT_CODE | VARCHAR2 | (30) | Y | |
DATE_TYPE | VARCHAR2 | (30) | Y | |
NAME | VARCHAR2 | (240) | Y | |
REQUIRE_ASSIGN_FLAG | VARCHAR2 | (1) | ||
OBSOLETE_FLAG | VARCHAR2 | (1) | Y | |
SORT_OPTION | VARCHAR2 | (30) | ||
INACTIVE_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
FUN.FUN_SEQ_CONTEXTS does not reference any database object
FUN.FUN_SEQ_CONTEXTS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_SEQ_ENTITIES_U1 | UNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
TABLE_NAME |
FUN_SEQ_ENTITIES_U2 | UNIQUE | APPS_TS_TX_IDX | ENTITY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | Y | ||
TABLE_NAME | VARCHAR2 | (30) | Y | |
ENTITY_NAME | VARCHAR2 | (240) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
FUN.FUN_SEQ_ENTITIES does not reference any database object
FUN.FUN_SEQ_ENTITIES is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_SEQ_HEADERS_U1 | UNIQUE | APPS_TS_TX_IDX | SEQ_HEADER_ID |
FUN_SEQ_HEADERS_U2 | UNIQUE | APPS_TS_TX_IDX | HEADER_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_HEADER_ID | NUMBER | Y | ||
HEADER_NAME | VARCHAR2 | (120) | Y | |
GAPLESS_FLAG | VARCHAR2 | (1) | Y | |
DESCRIPTION | VARCHAR2 | (240) | ||
OBSOLETE_FLAG | VARCHAR2 | (1) | Y | |
OBJECT_VERSION_NUMBER | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
FUN.FUN_SEQ_HEADERS does not reference any database object
FUN.FUN_SEQ_HEADERS is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Y | |
SOURCE_TYPE | VARCHAR2 | (30) | Y | |
SOURCE_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
FUN.FUN_SEQ_REQUESTS does not reference any database object
FUN.FUN_SEQ_REQUESTS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_SEQ_RULES_U1 | UNIQUE | APPS_TS_TX_IDX | RULE_ID |
FUN_SEQ_RULES_U2 | UNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
TABLE_NAME CONTEXT_TYPE EVENT_CODE DATE_TYPE SORT_OPTION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | Y | ||
APPLICATION_ID | NUMBER | Y | ||
TABLE_NAME | VARCHAR2 | (30) | Y | |
CONTEXT_TYPE | VARCHAR2 | (30) | Y | |
EVENT_CODE | VARCHAR2 | (30) | Y | |
DATE_TYPE | VARCHAR2 | (30) | Y | |
SORT_OPTION_CODE | VARCHAR2 | (30) | ||
FLEX_CONTEXT_CODE | VARCHAR2 | (30) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
FUN.FUN_SEQ_RULES does not reference any database object
FUN.FUN_SEQ_RULES is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_SEQ_VERSIONS_U1 | UNIQUE | APPS_TS_TX_IDX | SEQ_VERSION_ID |
FUN_SEQ_VERSIONS_U2 | UNIQUE | APPS_TS_TX_IDX |
SEQ_HEADER_ID
VERSION_NAME |
FUN_SEQ_VERSIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX | HEADER_NAME |
FUN_SEQ_VERSIONS_N2 | NONUNIQUE | APPS_TS_TX_IDX | VERSION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_VERSION_ID | NUMBER | Y | ||
SEQ_HEADER_ID | NUMBER | Y | ||
VERSION_NAME | VARCHAR2 | (120) | Y | |
HEADER_NAME | VARCHAR2 | (120) | Y | |
INITIAL_VALUE | NUMBER | Y | ||
START_DATE | DATE | Y | ||
END_DATE | DATE | |||
CURRENT_VALUE | NUMBER | |||
USE_STATUS_CODE | VARCHAR2 | (30) | Y | |
DB_SEQUENCE_NAME | VARCHAR2 | (30) | ||
OBJECT_VERSION_NUMBER | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
FUN.FUN_SEQ_VERSIONS does not reference any database object
FUN.FUN_SEQ_VERSIONS is referenced by following:
Description: | FUN_SUBSIDIARY_PARTY_MAPPINGS is used to upgrade GL Subsidiaries as Intercompany Organizations. This table is not used once the organizations and transactions have been upgraded. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_SUBSIDIARY_PARTY_MAP_N1 | NONUNIQUE | APPS_TS_TX_IDX | SUBSIDIARY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | Party id of the newly created orgaination. Foreign key to HZ_PARTIES.PARTY_ID | ||
SUBSIDIARY_ID | NUMBER | Id of the subsidiary being upgraded | ||
CREATED_BY | NUMBER | Standard Who column. | ||
CREATION_DATE | DATE | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | Standard Who column. | ||
LAST_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column. | ||
LEDGER_ID | NUMBER | Ledger that the subsidiary is using. Upgraded from Gl_iea_subsidiaries.sets_of_books_id | ||
LEGAL_ENTITY_ID | NUMBER | Legal Entity that the Intercompany organization is associated with |
FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS does not reference any database object
FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS is referenced by following:
Description: | FUN_SUPPLIER_MAPS stores the details of the supplier to which an Intercompany organization is mapped. When an invoice is created in payables for the Intercompany organization, the supplier used will the one setup in this table. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPPLIER_MAP_ID | NUMBER | (15) | Y | System generated primary key |
RELATION_ID | NUMBER | (15) | Y | Foreign key to FUN_TRADE_RELATIONS.RELATION_ID |
VENDOR_ID | NUMBER | (15) | Y | Supplier identifier. Foreign key to PO_VENDORS.VENDOR_ID |
VENDOR_SITE_ID | NUMBER | (15) | Supplier site identifier. Foreign key to PO_VENDOR_SITES_ALL.VENDOR_SITE_ID | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. |
FUN.FUN_SUPPLIER_MAPS does not reference any database object
FUN.FUN_SUPPLIER_MAPS is referenced by following:
Description: | FUN_SYSTEM_OPTIONS stores setup options defined at the system level which applies across the whole system. This table will always contain only 1 row. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYSTEM_OPTION_ID | NUMBER | (15) | Y | An ID number: 0 |
DEFAULT_CURRENCY | VARCHAR2 | (15) | Default currency for all transactions. | |
MIN_TRX_AMT | NUMBER | Minimum transaction amount. | ||
MIN_TRX_AMT_CURRENCY | VARCHAR2 | (15) | Useful if DEFAULT_CURRENCY is undefined. | |
EXCHG_RATE_TYPE | VARCHAR2 | (30) | Y | Exchange rate type. |
NUMBERING_TYPE | VARCHAR2 | (30) | Y | "SYS" if generated by a call to sequencing API or "MAN" if user enters manually. |
ALLOW_REJECT_FLAG | VARCHAR2 | (1) | Y | "Y" for Allow, "N" for Disallow. |
GL_BATCH_FLAG | VARCHAR2 | (1) | Y | "B" for Batch, "O" for Online. |
APAR_BATCH_FLAG | VARCHAR2 | (1) | Y | "B" for Batch, "O" for Online. |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
INTECO_CALENDAR | VARCHAR2 | (15) | ||
INTECO_PERIOD_TYPE | VARCHAR2 | (15) | ||
DEFAULT_AR_TRX_TYPE_ID | NUMBER | Default AR Transaction Type to be used when the Intercompany transactions are transferred to receivables. | ||
DEFAULT_MEMO_LINE_ID | NUMBER | Default AR Memo Line to be used when the Intercompany transactions are transferred to receivables. |
FUN.FUN_SYSTEM_OPTIONS does not reference any database object
FUN.FUN_SYSTEM_OPTIONS is referenced by following:
Description: | FUN_TRADE_RELATIONS stores the association of an Intercompany organization as a customer or a supplier. These associations are used when the Intercompany transactions are transferred to Receivables and Payables as invoices. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELATION_ID | NUMBER | (15) | Y | System generated primary key. |
TRANSACTION_LE_ID | NUMBER | (15) | Y | Transacting legal entity identifier. Foreign key to XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID |
TRANSACTION_LE_PARTY_ID | NUMBER | Y | Transacting Legal entity party identifier. Foreign key to XLE_ENTITY_PROFILES.PARTY_ID | |
TRANSACTION_ORG_ID | NUMBER | (15) | Transacting Operating unit identifier. Foreign key to HR_OPERATING_UNITS.ORGANIZATION_ID | |
TRANSACTION_ORGANIZATION_ID | NUMBER | Transacting Intercompany organization identifier.Foreign key to HZ_PARTIES.PARTY_ID. | ||
TP_LE_ID | NUMBER | (15) | Y | Trading partner Legal entity identifier. Foreign key to XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID |
TP_LE_PARTY_ID | NUMBER | Y | Trading partner legal entity party identifier. Foreign key to XLE_ENTITY_PROFILES.PARTY_ID | |
TP_ORG_ID | NUMBER | (15) | Trading partner Operating unit identifier. Foreign key to HR_OPERATING_UNITS.ORGANIZATION_ID | |
TP_ORGANIZATION_ID | NUMBER | Trading partner intercompany organization identifier. Foreign key to to HZ_PARTIES.PARTY_ID. | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
SOURCE | VARCHAR2 | (30) | Source |
FUN.FUN_TRADE_RELATIONS does not reference any database object
FUN.FUN_TRADE_RELATIONS is referenced by following:
Description: | This table is no longer used. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_TRANSFERS_U1 | UNIQUE | APPS_TS_TX_IDX |
TRX_ID
PARTY_TYPE_FLAG |
FUN_TRANSFERS_N1 | NONUNIQUE | APPS_TS_TX_IDX | TRX_ID |
FUN_TRANSFERS_N2 | NONUNIQUE | APPS_TS_TX_IDX | PARTY_TYPE_FLAG |
FUN_TRANSFERS_N3 | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURRENCY | VARCHAR2 | (15) | Deprecated | |
BATCH_NUMBER | VARCHAR2 | (15) | Deprecated | |
INITIATOR_NAME | VARCHAR2 | (360) | Deprecated | |
RECIPIENT_NAME | VARCHAR2 | (360) | Deprecated | |
TRX_TYPE_NAME | VARCHAR2 | (25) | Deprecated | |
TRX_TYPE_CODE | VARCHAR2 | (15) | Deprecated | |
PERIOD_NAME | VARCHAR2 | (15) | Deprecated | |
LEDGER_NAME | VARCHAR2 | (30) | Deprecated | |
TRX_STATUS | VARCHAR2 | (30) | Deprecated | |
AMOUNT_CR | NUMBER | Deprecated | ||
AMOUNT_DR | NUMBER | Deprecated | ||
DESCRIPTION | VARCHAR2 | (240) | Deprecated | |
PARTY_TYPE_FLAG | VARCHAR2 | (1) | Deprecated | |
ERROR_MSG | VARCHAR2 | (2000) | Deprecated | |
APPROVER | VARCHAR2 | (2000) | Deprecated | |
GL_DATE | DATE | Deprecated | ||
BATCH_DATE | DATE | Deprecated | ||
CUSTOMER | VARCHAR2 | (50) | Deprecated | |
SUPPLIER | VARCHAR2 | (80) | Deprecated | |
INVOICE_NUMBER | VARCHAR2 | (50) | Deprecated | |
ORG_ID | NUMBER | (15) | Deprecated | |
ORG_NAME | VARCHAR2 | (360) | Deprecated | |
REQUEST_ID | NUMBER | (15) | Deprecated | |
TRX_ID | NUMBER | (15) | Deprecated | |
INITIATOR_ID | NUMBER | (15) | Deprecated | |
RECIPIENT_ID | NUMBER | (15) | Deprecated | |
LEDGER_ID | NUMBER | (15) | Deprecated | |
ERROR_CODE | VARCHAR2 | (30) | Deprecated | |
PAYABLES_CCID | NUMBER | (15) | Deprecated | |
BATCH_ID | NUMBER | (15) | ||
LE_ID | NUMBER | (15) |
FUN.FUN_TRANSFERS does not reference any database object
FUN.FUN_TRANSFERS is referenced by following:
Description: | FUN_TRX_ACCT_DEFINITIONS stores the association between a ledger and SLA transaction account definition. This association is used to indicate to the Intercompany transaction entry process that user has defined account derivation rules in SL |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ID | NUMBER | Ledger identifier | ||
AMB_CONTEXT_CODE | VARCHAR2 | (30) | SLA Accounting method builder context code | |
ACCOUNT_DEFINITION_CODE | VARCHAR2 | (30) | SLA Transaction account Definition code | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
CREATED_BY | NUMBER | Y | Standard Who column. | |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column. | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column. |
FUN.FUN_TRX_ACCT_DEFINITIONS does not reference any database object
FUN.FUN_TRX_ACCT_DEFINITIONS is referenced by following:
Description: | FUN_TRX_BATCHES stores information about the Intercompany transaction batches. The BATCH_NUMBER and INITIATOR_ID together form a unique key. An Intercompany transaction batch can contain many transactions for multiple recipients. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_TRX_BATCHES_U1 | UNIQUE | APPS_TS_TX_IDX | BATCH_ID |
FUN_TRX_BATCHES_U2 | UNIQUE | APPS_TS_TX_IDX |
FROM_LEDGER_ID
BATCH_ID FROM_LE_ID DESCRIPTION |
FUN_TRX_BATCHES_N1 | NONUNIQUE | APPS_TS_TX_IDX | BATCH_NUMBER |
FUN_TRX_BATCHES_N2 | NONUNIQUE | APPS_TS_TX_IDX | TRX_TYPE_ID |
FUN_TRX_BATCHES_N20 | NONUNIQUE | APPS_TS_TX_IDX | GL_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Y | System Generated primary key. |
BATCH_NUMBER | VARCHAR2 | (15) | Y | The Batch Number of the batch. |
INITIATOR_ID | NUMBER | (15) | Y | The party identifier of the Intercompany Organization which Initiated the batch. Foreign key to HZ_PARTIES.PARTY_ID. |
FROM_LE_ID | NUMBER | (15) | Y | The party identifier of the Initiators Legal Entity. Foreign key to XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID |
FROM_LEDGER_ID | NUMBER | (15) | Primary ledger of the Initiating organization. Foreign key to GL_LEDGERS.LEDGER_ID | |
CONTROL_TOTAL | NUMBER | Entered by the user as a placeholder to indicate the amount they would like the batch to add up to. It is not the total of all the transaction amounts in the batch. | ||
RUNNING_TOTAL_CR | NUMBER | Sum of INIT_AMOUNT_CR in the FUN_TRX_HEADERS table. | ||
RUNNING_TOTAL_DR | NUMBER | Sum of INIT_AMOUNT_DR in the FUN_TRX_HEADERS table. | ||
CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency of the batch, transactions in a batch must be in the same currency. |
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate to use if batch is not in the initiators base currency | |
STATUS | VARCHAR2 | (30) | Y | Batch status |
DESCRIPTION | VARCHAR2 | (240) | The description is what will be passed to the Initiators General Ledger or Receivables as the journal or invoice description. | |
NOTE | VARCHAR2 | (240) | Initiator entered comments | |
TRX_TYPE_ID | NUMBER | (15) | Y | Transaction type of this batch, all transactions in a batch must be of the same type. |
TRX_TYPE_CODE | VARCHAR2 | (15) | Transaction type code of this batch, all transactions in a batch must be of the same type. | |
GL_DATE | DATE | Y | GL Date of the batch | |
BATCH_DATE | DATE | Y | Batch entered date | |
REJECT_ALLOW_FLAG | VARCHAR2 | (1) | Y | Whether the transactions in this batch can be rejected |
ORIGINAL_BATCH_ID | NUMBER | (15) | If this batch is reversing another one, this is the id of the batch it is reversing. | |
REVERSED_BATCH_ID | NUMBER | (15) | For a reversed batch that has been reversed this is the id of the batch created to reverse it. | |
FROM_RECURRING_BATCH_ID | NUMBER | (15) | Currently only used for transactions upgraded from GIS | |
INITIATOR_SOURCE | VARCHAR2 | (30) | Identify the initiator instance: Local or Remote. Currently not used. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
AUTO_PRORATION_FLAG | VARCHAR2 | (1) | Automatic proration flag. A value of "Y" indicates that user would like to generate the distributions using proration. A value of "N" indicates the distributions will be entered manually. |
FUN.FUN_TRX_BATCHES does not reference any database object
FUN.FUN_TRX_BATCHES is referenced by following:
Description: | FUN_TRX_HEADERS stores the transactions that make up an Intercompany transaction batch. The INITIATOR_ID, RECIPIENT_ID, BATCH_ID together form a unique key. Each transaction is meant for 1 recipient however a batch can contain multiple tran |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_TRX_HEADERS_U1 | UNIQUE | APPS_TS_TX_IDX | TRX_ID |
FUN_TRX_HEADERS_N1 | NONUNIQUE | APPS_TS_TX_IDX | BATCH_ID |
FUN_TRX_HEADERS_N20 | NONUNIQUE | APPS_TS_TX_IDX |
STATUS
INVOICE_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_ID | NUMBER | (15) | Y | System Generated primary key |
TRX_NUMBER | VARCHAR2 | (15) | Transaction Number | |
INITIATOR_ID | NUMBER | (15) | Y | The party identifier of the Intercompany Organization which Initiated the transaction. Foreign key to HZ_PARTIES.PARTY_ID |
RECIPIENT_ID | NUMBER | (15) | Y | The party identifier of the Intercompany Organization which is the recipient of this transaction. Foreign key to HZ_PARTIES.PARTY_ID |
TO_LE_ID | NUMBER | (15) | Y | The party identifier of the Recipients Legal Entity. Foreign key to XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID |
TO_LEDGER_ID | NUMBER | (15) | The Recipients primary ledger ID. Foreign key to GL_LEDGERS.LEDGER_ID | |
BATCH_ID | NUMBER | (15) | Y | Batch identifier. |
STATUS | VARCHAR2 | (30) | Y | Transaction status. |
INIT_AMOUNT_CR | NUMBER | Credit amount for initiator. | ||
INIT_AMOUNT_DR | NUMBER | Debit amount for initiator. | ||
RECI_AMOUNT_CR | NUMBER | Credit amount for recipient. | ||
RECI_AMOUNT_DR | NUMBER | Debit amount for recipient. | ||
AR_INVOICE_NUMBER | VARCHAR2 | (50) | Number of the invoice generated in AR and also passed to AP when invoicing is required. | |
INVOICE_FLAG | VARCHAR2 | (1) | Y | "Y" if an Invoice is required for this transaction. "N" if it should be sent straight to GL. |
APPROVER_ID | NUMBER | (15) | Id of the recipient user who approved this transaction. If a transaction does not require approval then this column remains blank. | |
APPROVAL_DATE | DATE | Date on which the transaction was approved | ||
ORIGINAL_TRX_ID | NUMBER | (15) | If this transaction is reversing another one, this is the id of the transaction it is reversing | |
REVERSED_TRX_ID | NUMBER | (15) | For a reversed transaction that has been reversed this is the id of the transaction created to reverse it. | |
FROM_RECURRING_TRX_ID | NUMBER | (15) | Currently only used | |
INITIATOR_INSTANCE_FLAG | VARCHAR2 | (1) | Check if initiator is in this instance. Currently not used | |
RECIPIENT_INSTANCE_FLAG | VARCHAR2 | (1) | Check if recipient is in this instance. Currently not used | |
REJECT_REASON | VARCHAR2 | (240) | Rejection reason entered by the approver | |
DESCRIPTION | VARCHAR2 | (240) | The description is what will be passed to the recipients general ledger or payables as the journal or invoice description. | |
INIT_WF_KEY | VARCHAR2 | (240) | Workflow key for initiator | |
RECI_WF_KEY | VARCHAR2 | (240) | Workflow key for recipient | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. |
FUN.FUN_TRX_HEADERS does not reference any database object
FUN.FUN_TRX_HEADERS is referenced by following:
Description: | FUN_TRX_LINES stores some line level information for an intercompany transaction.Each row in FUN_TRX_HEADERS currently maps to 1 row in FUN_TRX_LINES. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_TRX_LINES_U1 | UNIQUE | APPS_TS_TX_IDX | LINE_ID |
FUN_TRX_LINES_N1 | NONUNIQUE | APPS_TS_TX_IDX | TRX_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | (15) | Y | System Generated primary key. |
TRX_ID | NUMBER | (15) | Y | Transaction identifier. |
LINE_NUMBER | NUMBER | (15) | Y | Line number. |
LINE_TYPE_FLAG | VARCHAR2 | (1) | Y | "L" for Line, "T" for Tax. Currently all the lines in this table have a line type of "L" |
INIT_AMOUNT_CR | NUMBER | Credit amount for initiator. | ||
INIT_AMOUNT_DR | NUMBER | Debit amount for initiator. | ||
RECI_AMOUNT_CR | NUMBER | Credit amount for recipient. | ||
RECI_AMOUNT_DR | NUMBER | Debit amount for recipient. | ||
DESCRIPTION | VARCHAR2 | (250) | Description. | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column. |
FUN.FUN_TRX_LINES does not reference any database object
FUN.FUN_TRX_LINES is referenced by following:
Description: | FUN_TRX_TYPES_B stores the Intercompany transaction types defined. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_TRX_TYPES_B_U1 | UNIQUE | APPS_TS_TX_IDX | TRX_TYPE_ID |
FUN_TRX_TYPES_B_U2 | UNIQUE | APPS_TS_TX_IDX | TRX_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_TYPE_ID | NUMBER | (15) | Y | System Generated primary key. |
TRX_TYPE_CODE | VARCHAR2 | (15) | Y | Transaction type code. |
MANUAL_APPROVE_FLAG | VARCHAR2 | (1) | Indicates whether manual approval is required. Valid values are "Y" or "N". | |
ENABLED_FLAG | VARCHAR2 | (1) | Indicates whether the transaction type is enabled or not. Valid values are "Y" or "N". | |
ALLOW_INVOICING_FLAG | VARCHAR2 | (1) | "Y" if AR and AP invoices need to be created for transactions of this type or "N" if they will go straight to GL. | |
VAT_TAXABLE_FLAG | VARCHAR2 | (1) | Deprecated. | |
ALLOW_INTEREST_ACCRUAL_FLAG | VARCHAR2 | (1) | Deprecated. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context. | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. |
FUN.FUN_TRX_TYPES_B does not reference any database object
FUN.FUN_TRX_TYPES_B is referenced by following:
Description: | FUN_TRX_TYPES_TL stores the translatable column details for the Intercompany transaction types. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FUN_TRX_TYPES_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX | TRX_TYPE_ID |
FUN_TRX_TYPES_TL_N2 | NONUNIQUE | APPS_TS_TX_IDX | TRX_TYPE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_TYPE_ID | NUMBER | Y | System Generated primary key. | |
LANGUAGE | VARCHAR2 | (4) | Y | Language |
SOURCE_LANG | VARCHAR2 | (4) | Y | Source language. |
TRX_TYPE_NAME | VARCHAR2 | (25) | Transaction type name. | |
DESCRIPTION | VARCHAR2 | (240) | Description. | |
CREATED_BY | NUMBER | (15) | Standard Who column. | |
CREATION_DATE | DATE | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. |
FUN.FUN_TRX_TYPES_TL does not reference any database object
FUN.FUN_TRX_TYPES_TL is referenced by following:
Description: | FUN_TRX_TYPE_AR_MAPS stores the mapping between the Intercompany transaction type and the Receivables Transaction Type and Receivables Memo Line. This mapping is used to create Receivables invoices when the Intercompany transactions are tra |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_TYPE_MAP_ID | NUMBER | (15) | Y | System generated primary key. |
TRX_TYPE_ID | NUMBER | (15) | Y | Transaction type identifier. Foreign key to FUN_TRX_TYPES.TRX_TYPE_ID |
ORG_ID | NUMBER | (15) | Y | Operating unit identifier for which the mapping has been defined. |
MEMO_LINE_ID | NUMBER | (15) | Y | Memo line identifier. Foreign key to AR_MEMO_LINES_ALL_B.MEMO_LINE_ID. |
AR_TRX_TYPE_ID | NUMBER | (15) | Y | AR Transaction type identifier. Foreign key to RA_CUST_TRX_TYPES_ALL. CUST_TRX_TYPE_ID. |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context. | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column. |
CREATION_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. |
FUN.FUN_TRX_TYPE_AR_MAPS does not reference any database object
FUN.FUN_TRX_TYPE_AR_MAPS is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_DISTRIBUTION_ID_CHAR_1 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_2 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_3 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_4 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_5 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | |||
SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | |||
SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | |||
SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | |||
SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | |||
ACCOUNT_TYPE_CODE | VARCHAR2 | (30) | Y | |
FTB_ATTRIBUTE1 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE10 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE11 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE12 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE13 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE14 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE15 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE2 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE3 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE4 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE5 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE6 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE7 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE8 | VARCHAR2 | (80) | ||
FTB_ATTRIBUTE9 | VARCHAR2 | (80) | ||
FTB_CATEGORY_CODE | VARCHAR2 | (80) | ||
FTB_CURRENCY_CODE | VARCHAR2 | (80) | ||
FTB_FROM_LEDGER_ID | NUMBER | |||
FTB_FROM_LE_ID | NUMBER | |||
FTB_INITIATOR_BSV | VARCHAR2 | (80) | ||
FTB_INITIATOR_ID | NUMBER | |||
FTH_ATTRIBUTE1 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE10 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE11 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE12 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE13 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE14 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE15 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE2 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE3 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE4 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE5 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE6 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE7 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE8 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE9 | VARCHAR2 | (80) | ||
FTH_ATTRIBUTE_CATEGORY | VARCHAR2 | (80) | ||
FTH_RECIPIENT_BSV | VARCHAR2 | (80) | ||
FTH_RECIPIENT_ID | NUMBER | |||
FTH_TO_LEDGER_ID | NUMBER | |||
FTH_TO_LE_ID | NUMBER | |||
FTT_ALLOW_INTEREST_ACCR_FLAG | VARCHAR2 | (80) | ||
FTT_ALLOW_INVOICING_FLAG | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE1 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE10 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE11 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE12 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE13 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE14 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE15 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE2 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE3 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE4 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE5 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE6 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE7 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE8 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE9 | VARCHAR2 | (80) | ||
FTT_ATTRIBUTE_CATEGORY | VARCHAR2 | (80) | ||
FTT_MANUAL_APPROVE_FLAG | VARCHAR2 | (80) | ||
FTT_TRX_TYPE_ID | NUMBER | |||
FTT_VAT_TAXABLE_FLAG | VARCHAR2 | (80) | ||
PROCESSED_FLAG | VARCHAR2 | (1) | ||
SEGMENT1 | VARCHAR2 | (30) | ||
SEGMENT2 | VARCHAR2 | (30) | ||
SEGMENT3 | VARCHAR2 | (30) | ||
SEGMENT4 | VARCHAR2 | (30) | ||
SEGMENT5 | VARCHAR2 | (30) | ||
SEGMENT6 | VARCHAR2 | (30) | ||
SEGMENT7 | VARCHAR2 | (30) | ||
SEGMENT8 | VARCHAR2 | (30) | ||
SEGMENT9 | VARCHAR2 | (30) | ||
SEGMENT10 | VARCHAR2 | (30) | ||
SEGMENT11 | VARCHAR2 | (30) | ||
SEGMENT12 | VARCHAR2 | (30) | ||
SEGMENT13 | VARCHAR2 | (30) | ||
SEGMENT14 | VARCHAR2 | (30) | ||
SEGMENT15 | VARCHAR2 | (30) | ||
SEGMENT16 | VARCHAR2 | (30) | ||
SEGMENT17 | VARCHAR2 | (30) | ||
SEGMENT18 | VARCHAR2 | (30) | ||
SEGMENT19 | VARCHAR2 | (30) | ||
SEGMENT20 | VARCHAR2 | (30) | ||
SEGMENT21 | VARCHAR2 | (30) | ||
SEGMENT22 | VARCHAR2 | (30) | ||
SEGMENT23 | VARCHAR2 | (30) | ||
SEGMENT24 | VARCHAR2 | (30) | ||
SEGMENT25 | VARCHAR2 | (30) | ||
SEGMENT26 | VARCHAR2 | (30) | ||
SEGMENT27 | VARCHAR2 | (30) | ||
SEGMENT28 | VARCHAR2 | (30) | ||
SEGMENT29 | VARCHAR2 | (30) | ||
SEGMENT30 | VARCHAR2 | (30) | ||
TARGET_CCID | NUMBER | (15) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (2000) | ||
MSG_COUNT | NUMBER | |||
MSG_DATA | VARCHAR2 | (2000) | ||
DUMMY_ROWID | UROWID | (4000) |
FUN.FUN_XLA_TAB_GT does not reference any database object
FUN.FUN_XLA_TAB_GT is referenced by following:
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
RULE_OBJECT_ID | NUMBER | (15) | Y | |
APPLICATION_ID | NUMBER | (15) | Y | |
RULE_OBJECT_NAME | VARCHAR2 | (30) | Y | |
RESULT_TYPE | VARCHAR2 | (30) | Y | |
REQUIRED_FLAG | VARCHAR2 | (1) | Y | |
USE_DEFAULT_VALUE_FLAG | VARCHAR2 | (1) | ||
DEFAULT_APPLICATION_ID | NUMBER | (15) | ||
DEFAULT_VALUE | VARCHAR2 | (1024) | ||
FLEX_VALUE_SET_ID | NUMBER | (15) | ||
FLEXFIELD_NAME | VARCHAR2 | (80) | ||
FLEXFIELD_APP_SHORT_NAME | VARCHAR2 | (50) | ||
MULTI_RULE_RESULT_FLAG | VARCHAR2 | (1) | Y | |
OBJECT_VERSION_NUMBER | NUMBER | Y | ||
CREATED_BY_MODULE | VARCHAR2 | (150) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
USE_INSTANCE_FLAG | VARCHAR2 | (1) | Y | |
INSTANCE_LABEL | VARCHAR2 | (150) | ||
PARENT_RULE_OBJECT_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
USER_RULE_OBJECT_NAME | VARCHAR2 | (50) | Y | |
DESCRIPTION | VARCHAR2 | (240) |
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |