Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

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.

eTRM - FUN Tables and Views

TABLE - FUN.FUN_BALANCE_ACCOUNTS
TABLE - FUN.FUN_BALANCE_OPTIONS
TABLE - FUN.FUN_BAL_ERRORS_GT
TABLE - FUN.FUN_BAL_ERRORS_T
TABLE - FUN.FUN_BAL_GENERATE_LINES
TABLE - FUN.FUN_BAL_HEADERS_GT
TABLE - FUN.FUN_BAL_HEADERS_T
TABLE - FUN.FUN_BAL_INTER_BSV_MAP_T
TABLE - FUN.FUN_BAL_INTER_INT_GT
TABLE - FUN.FUN_BAL_INTER_INT_T
TABLE - FUN.FUN_BAL_INTRA_BSV_MAP_T
TABLE - FUN.FUN_BAL_INTRA_INT_GT
TABLE - FUN.FUN_BAL_INTRA_INT_T
TABLE - FUN.FUN_BAL_LE_BSV_MAP_GT
TABLE - FUN.FUN_BAL_LINES_GT
TABLE - FUN.FUN_BAL_LINES_T
TABLE - FUN.FUN_BAL_RESULTS_GT
TABLE - FUN.FUN_BAL_RESULTS_T
TABLE - FUN.FUN_BATCH_DISTS
TABLE - FUN.FUN_CONTACTUS_REQUEST_DATA
TABLE - FUN.FUN_CONTACTUS_SETUP
TABLE - FUN.FUN_CUSTOMER_MAPS
TABLE - FUN.FUN_DIST_LINES
TABLE - FUN.FUN_INTERFACE_BATCHDISTS
TABLE - FUN.FUN_INTERFACE_BATCHES
TABLE - FUN.FUN_INTERFACE_CONTROLS
TABLE - FUN.FUN_INTERFACE_DIST_LINES
TABLE - FUN.FUN_INTERFACE_HEADERS
TABLE - FUN.FUN_INTERFACE_REJECTIONS
TABLE - FUN.FUN_INTER_ACCOUNTS
TABLE - FUN.FUN_INTER_ACCOUNTS_ADDL
TABLE - FUN.FUN_NET_AGREEMENTS_ALL
TABLE - FUN.FUN_NET_AP_INVS_ALL
TABLE - FUN.FUN_NET_AP_INV_TYPES_ALL
TABLE - FUN.FUN_NET_AR_TRX_TYPES_ALL
TABLE - FUN.FUN_NET_AR_TXNS_ALL
TABLE - FUN.FUN_NET_BATCHES_ALL
TABLE - FUN.FUN_NET_CUSTOMERS_ALL
TABLE - FUN.FUN_NET_SUPPLIERS_ALL
TABLE - FUN.FUN_PERIOD_STATUSES
TABLE - FUN.FUN_RICH_MESSAGES_B
TABLE - FUN.FUN_RICH_MESSAGES_TL
TABLE - FUN.FUN_RULE_BULK_RESULT_GT
TABLE - FUN.FUN_RULE_CRITERIA
TABLE - FUN.FUN_RULE_CRIT_PARAMS_B
TABLE - FUN.FUN_RULE_CRIT_PARAMS_TL
TABLE - FUN.FUN_RULE_DETAILS
TABLE - FUN.FUN_RULE_OBJECTS_B
TABLE - FUN.FUN_RULE_OBJECTS_TL
TABLE - FUN.FUN_RULE_OBJ_ATTRIBUTES
TABLE - FUN.FUN_RULE_PARAM_VALUES
TABLE - FUN.FUN_RULE_TESTS
TABLE - FUN.FUN_RULE_TEST_MULTIRULE
TABLE - FUN.FUN_RULE_TEST_MVAL_RES
TABLE - FUN.FUN_RULE_TEST_PARAMS
TABLE - FUN.FUN_RULE_TEST_RESULTS
TABLE - FUN.FUN_SEQ_ASSIGNMENTS
TABLE - FUN.FUN_SEQ_CONTEXTS
TABLE - FUN.FUN_SEQ_ENTITIES
TABLE - FUN.FUN_SEQ_HEADERS
TABLE - FUN.FUN_SEQ_REQUESTS
TABLE - FUN.FUN_SEQ_RULES
TABLE - FUN.FUN_SEQ_VERSIONS
TABLE - FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS
TABLE - FUN.FUN_SUPPLIER_MAPS
TABLE - FUN.FUN_SYSTEM_OPTIONS
TABLE - FUN.FUN_TRADE_RELATIONS
TABLE - FUN.FUN_TRANSFERS
TABLE - FUN.FUN_TRX_ACCT_DEFINITIONS
TABLE - FUN.FUN_TRX_BATCHES
TABLE - FUN.FUN_TRX_HEADERS
TABLE - FUN.FUN_TRX_LINES
TABLE - FUN.FUN_TRX_TYPES_B
TABLE - FUN.FUN_TRX_TYPES_TL
TABLE - FUN.FUN_TRX_TYPE_AR_MAPS
TABLE - FUN.FUN_XLA_TAB_GT
VIEW - APPS.FUN_RULE_OBJECTS_VL

Table: FUN_BALANCE_ACCOUNTS

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.
Comments
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.
Indexes
Index Type Tablespace Column
FUN_BALANCE_ACCOUNTS_U1 UNIQUE APPS_TS_TX_IDX TEMPLATE_ID
DR_BSV
CR_BSV
Columns
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.

[top of page]

FUN.FUN_BALANCE_ACCOUNTS does not reference any database object

FUN.FUN_BALANCE_ACCOUNTS is referenced by following:

APPS
SYNONYM - FUN_BALANCE_ACCOUNTS

[top of page]

Table: FUN_BALANCE_OPTIONS

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.
Comments
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.
Indexes
Index Type Tablespace Column
FUN_BALANCE_OPTIONS_U1 UNIQUE APPS_TS_TX_IDX LEDGER_ID
LE_ID
JE_SOURCE_NAME
JE_CATEGORY_NAME
Columns
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

[top of page]

FUN.FUN_BALANCE_OPTIONS does not reference any database object

FUN.FUN_BALANCE_OPTIONS is referenced by following:

APPS
SYNONYM - FUN_BALANCE_OPTIONS

[top of page]

Table: FUN_BAL_ERRORS_GT

Description:
Comments
Indexes
Index Type Tablespace Column
FUN_BAL_ERRORS_GT_N1 NONUNIQUE ERROR_CODE
Columns
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

[top of page]

FUN.FUN_BAL_ERRORS_GT does not reference any database object

FUN.FUN_BAL_ERRORS_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_ERRORS_GT

[top of page]

Table: FUN_BAL_ERRORS_T

Description: FUN_BAL_ERRORS_T is a temporary table used internally by the Intercompany Balancing API.
Comments
FUN_BAL_ERRORS_T is a temporary table used internally by the Intercompany Balancing API.
Columns
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

[top of page]

FUN.FUN_BAL_ERRORS_T does not reference any database object

FUN.FUN_BAL_ERRORS_T is referenced by following:

APPS
SYNONYM - FUN_BAL_ERRORS_T

[top of page]

Table: FUN_BAL_GENERATE_LINES

Description: FUN_BAL_GENERATE_LINES is a temporary table used internally by the Intercompany balancing API.
Comments
FUN_BAL_GENERATE_LINES is a temporary table used internally by the Intercompany balancing API.
Columns
Name Datatype Length Mandatory Comments
VALUE VARCHAR2 (1)
Value

[top of page]

FUN.FUN_BAL_GENERATE_LINES does not reference any database object

FUN.FUN_BAL_GENERATE_LINES is referenced by following:

APPS
SYNONYM - FUN_BAL_GENERATE_LINES

[top of page]

Table: FUN_BAL_HEADERS_GT

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
Comments
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 API.
Indexes
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
Columns
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

[top of page]

FUN.FUN_BAL_HEADERS_GT does not reference any database object

FUN.FUN_BAL_HEADERS_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_HEADERS_GT

[top of page]

Table: FUN_BAL_HEADERS_T

Description: FUN_BAL_HEADERS_T is a temporary table used internally by the Intercompany Balancing API.
Comments
FUN_BAL_HEADERS_T is a temporary table used internally by the Intercompany Balancing API.
Columns
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

[top of page]

FUN.FUN_BAL_HEADERS_T does not reference any database object

FUN.FUN_BAL_HEADERS_T is referenced by following:

APPS
SYNONYM - FUN_BAL_HEADERS_T

[top of page]

Table: FUN_BAL_INTER_BSV_MAP_T

Description: FUN_BAL_INTER_BSV_MAP_T is a temporary table used internally by the Intercompany balancing API.
Comments
FUN_BAL_INTER_BSV_MAP_T is a temporary table used internally by the Intercompany balancing API.
Columns
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

[top of page]

FUN.FUN_BAL_INTER_BSV_MAP_T does not reference any database object

FUN.FUN_BAL_INTER_BSV_MAP_T is referenced by following:

APPS
SYNONYM - FUN_BAL_INTER_BSV_MAP_T

[top of page]

Table: FUN_BAL_INTER_INT_GT

Description: FUN_BAL_INTER_INT_GT is a global temporary table used internally by the Intercompany Balancing API.
Comments
FUN_BAL_INTER_INT_GT is a global temporary table used internally by the Intercompany Balancing API.
Indexes
Index Type Tablespace Column
FUN_BAL_INTER_INT_GT_N1 NONUNIQUE GROUP_ID
FUN_BAL_INTER_INT_GT_N2 NONUNIQUE INTERCOMPANY_MODE
Columns
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

[top of page]

FUN.FUN_BAL_INTER_INT_GT does not reference any database object

FUN.FUN_BAL_INTER_INT_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_INTER_INT_GT

[top of page]

Table: FUN_BAL_INTER_INT_T

Description: FUN_BAL_INTER_INT_T is a temporary table used internally by the Intercompany Balancing API.
Comments
FUN_BAL_INTER_INT_T is a temporary table used internally by the Intercompany Balancing API.
Columns
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)

[top of page]

FUN.FUN_BAL_INTER_INT_T does not reference any database object

FUN.FUN_BAL_INTER_INT_T is referenced by following:

APPS
SYNONYM - FUN_BAL_INTER_INT_T

[top of page]

Table: FUN_BAL_INTRA_BSV_MAP_T

Description: FUN_BAL_INTRA_BSV_MAP_T is a temporary table used internally by the Intercompany balancing API.
Comments
FUN_BAL_INTRA_BSV_MAP_T is a temporary table used internally by the Intercompany balancing API.
Columns
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

[top of page]

FUN.FUN_BAL_INTRA_BSV_MAP_T does not reference any database object

FUN.FUN_BAL_INTRA_BSV_MAP_T is referenced by following:

APPS
SYNONYM - FUN_BAL_INTRA_BSV_MAP_T

[top of page]

Table: FUN_BAL_INTRA_INT_GT

Description: FUN_BAL_INTRA_INT_GT is a global temporary table used internally by the Intercompany Balancing API
Comments
FUN_BAL_INTRA_INT_GT is a global temporary table used internally by the Intercompany Balancing API
Indexes
Index Type Tablespace Column
FUN_BAL_INTRA_INT_GT_N1 NONUNIQUE GROUP_ID
LE_ID
BAL_SEG_VAL
Columns
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

[top of page]

FUN.FUN_BAL_INTRA_INT_GT does not reference any database object

FUN.FUN_BAL_INTRA_INT_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_INTRA_INT_GT

[top of page]

Table: FUN_BAL_INTRA_INT_T

Description: FUN_BAL_IINTRA_INT_T is a temporary table used internally by the Intercompany Balancing API.
Comments
FUN_BAL_IINTRA_INT_T is a temporary table used internally by the Intercompany Balancing API.
Columns
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

[top of page]

FUN.FUN_BAL_INTRA_INT_T does not reference any database object

FUN.FUN_BAL_INTRA_INT_T is referenced by following:

APPS
SYNONYM - FUN_BAL_INTRA_INT_T

[top of page]

Table: FUN_BAL_LE_BSV_MAP_GT

Description: FUN_BAL_LE_BSV_MAP_GT is a global temporary table used internally by the Intercompany Balancing API
Comments
FUN_BAL_LE_BSV_MAP_GT is a global temporary table used internally by the Intercompany Balancing API
Indexes
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
Columns
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

[top of page]

FUN.FUN_BAL_LE_BSV_MAP_GT does not reference any database object

FUN.FUN_BAL_LE_BSV_MAP_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_LE_BSV_MAP_GT

[top of page]

Table: FUN_BAL_LINES_GT

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
Comments
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 API.
Indexes
Index Type Tablespace Column
FUN_BAL_LINES_GT_N1 NONUNIQUE GROUP_ID
BAL_SEG_VAL
FUN_BAL_LINES_GT_N2 NONUNIQUE GENERATED
Columns
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

[top of page]

FUN.FUN_BAL_LINES_GT does not reference any database object

FUN.FUN_BAL_LINES_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_LINES_GT

[top of page]

Table: FUN_BAL_LINES_T

Description: FUN_BAL_LINES_T is a temporary table used internally by the Intercompany Balancing API.
Comments
FUN_BAL_LINES_T is a temporary table used internally by the Intercompany Balancing API.
Columns
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)

[top of page]

FUN.FUN_BAL_LINES_T does not reference any database object

FUN.FUN_BAL_LINES_T is referenced by following:

APPS
SYNONYM - FUN_BAL_LINES_T

[top of page]

Table: FUN_BAL_RESULTS_GT

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
Comments
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 and GL read the results from this table and take appropriate action.
Columns
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

[top of page]

FUN.FUN_BAL_RESULTS_GT does not reference any database object

FUN.FUN_BAL_RESULTS_GT is referenced by following:

APPS
SYNONYM - FUN_BAL_RESULTS_GT

[top of page]

Table: FUN_BAL_RESULTS_T

Description: FUN_BAL_RESULTS_T is a temporary table used internally by the Intercompany balancing API.
Comments
FUN_BAL_RESULTS_T is a temporary table used internally by the Intercompany balancing API.
Columns
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

[top of page]

FUN.FUN_BAL_RESULTS_T does not reference any database object

FUN.FUN_BAL_RESULTS_T is referenced by following:

APPS
SYNONYM - FUN_BAL_RESULTS_T

[top of page]

Table: FUN_BATCH_DISTS

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
Comments
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. Once the distributions have been prorated and created in FUN_DIST_LINES, the data in this table is not used by any other process.
Columns
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

[top of page]

FUN.FUN_BATCH_DISTS does not reference any database object

FUN.FUN_BATCH_DISTS is referenced by following:

APPS
SYNONYM - FUN_BATCH_DISTS

[top of page]

Table: FUN_CONTACTUS_REQUEST_DATA

Description: This table contains information about the question or problem submitted by the end user that is stored in a prompt-value pair format.
Comments
This table contains information about the question or problem submitted by the end user that is stored in a prompt-value pair format.
Indexes
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
Columns
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

[top of page]

FUN.FUN_CONTACTUS_REQUEST_DATA does not reference any database object

FUN.FUN_CONTACTUS_REQUEST_DATA is referenced by following:

APPS
SYNONYM - FUN_CONTACTUS_REQUEST_DATA

[top of page]

Table: FUN_CONTACTUS_SETUP

Description: This table contains the definition for the behavior of the Contact Us global button.
Comments
This table contains the definition for the behavior of the Contact Us global button.
Indexes
Index Type Tablespace Column
FUN_CONTACTUS_SETUP_U1 UNIQUE APPS_TS_TX_IDX RULE_OBJECT_ID
RULE_DETAIL_ID
Columns
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

[top of page]

FUN.FUN_CONTACTUS_SETUP does not reference any database object

FUN.FUN_CONTACTUS_SETUP is referenced by following:

APPS
SYNONYM - FUN_CONTACTUS_SETUP

[top of page]

Table: FUN_CUSTOMER_MAPS

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.
Comments
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.
Columns
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.

[top of page]

FUN.FUN_CUSTOMER_MAPS does not reference any database object

FUN.FUN_CUSTOMER_MAPS is referenced by following:

APPS
SYNONYM - FUN_CUSTOMER_MAPS

[top of page]

Table: FUN_DIST_LINES

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_
Comments
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_flag = I and dist_type_flag = R indicates an Initiator receivables account distribution line. Party_type_flag = R and dist_type_flag = L indicates a Recipient distribution line. Party_type_flag = R and dist_type_flag = P indicates a Recipient payables account distribution line.
Indexes
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
Columns
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.

[top of page]

FUN.FUN_DIST_LINES does not reference any database object

FUN.FUN_DIST_LINES is referenced by following:

APPS
SYNONYM - FUN_DIST_LINES

[top of page]

Table: FUN_INTERFACE_BATCHDISTS

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 */
Comments
/*# * This is the open interface table for Intercompany Batches Distributions. * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Batches Distributions Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
Indexes
Index Type Tablespace Column
FUN_INTERFACE_BATCHDISTS_N1 NONUNIQUE APPS_TS_INTERFACE BATCH_DIST_ID
Columns
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)

[top of page]

FUN.FUN_INTERFACE_BATCHDISTS does not reference any database object

FUN.FUN_INTERFACE_BATCHDISTS is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_BATCHDISTS

[top of page]

Table: FUN_INTERFACE_BATCHES

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 */
Comments
/*# * This is the 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 */
Indexes
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
Columns
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)

[top of page]

FUN.FUN_INTERFACE_BATCHES does not reference any database object

FUN.FUN_INTERFACE_BATCHES is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_BATCHES

[top of page]

Table: FUN_INTERFACE_CONTROLS

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 */
Comments
/*# * This is the open interface table for Intercompany Batches. * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Control Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
Indexes
Index Type Tablespace Column
FUN_INTERFACE_CONTROLS_N1 NONUNIQUE APPS_TS_INTERFACE SOURCE
GROUP_ID
Columns
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 */

[top of page]

FUN.FUN_INTERFACE_CONTROLS does not reference any database object

FUN.FUN_INTERFACE_CONTROLS is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_CONTROLS

[top of page]

Table: FUN_INTERFACE_DIST_LINES

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 */
Comments
/*# * This is the open interface table for Intercompany Distribution Lines. * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Batches Distributions Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
Indexes
Index Type Tablespace Column
FUN_INTERFACE_DIST_LINES_N1 NONUNIQUE APPS_TS_INTERFACE DIST_ID
Columns
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)

[top of page]

FUN.FUN_INTERFACE_DIST_LINES does not reference any database object

FUN.FUN_INTERFACE_DIST_LINES is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_DIST_LINES

[top of page]

Table: FUN_INTERFACE_HEADERS

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 */
Comments
/*# * This is the open interface table for Intercompany Transaction Headers. * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Transaction Headers Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
Indexes
Index Type Tablespace Column
FUN_INTERFACE_HEADERS_N1 NONUNIQUE APPS_TS_INTERFACE TRX_ID
Columns
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 */

[top of page]

FUN.FUN_INTERFACE_HEADERS does not reference any database object

FUN.FUN_INTERFACE_HEADERS is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_HEADERS

[top of page]

Table: FUN_INTERFACE_REJECTIONS

Description:
Comments
Columns
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)

[top of page]

FUN.FUN_INTERFACE_REJECTIONS does not reference any database object

FUN.FUN_INTERFACE_REJECTIONS is referenced by following:

APPS
SYNONYM - FUN_INTERFACE_REJECTIONS

[top of page]

Table: FUN_INTER_ACCOUNTS

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
Comments
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 value level. These accounts are used by the Intercompany balancing API to balance Intercompany journals.
Indexes
Index Type Tablespace Column
FUN_INTER_ACCOUNTS_N1 NONUNIQUE APPS_TS_TX_IDX FROM_LE_ID
LEDGER_ID
TO_LE_ID
DEFAULT_FLAG
Columns
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

[top of page]

FUN.FUN_INTER_ACCOUNTS does not reference any database object

FUN.FUN_INTER_ACCOUNTS is referenced by following:

APPS
SYNONYM - FUN_INTER_ACCOUNTS

[top of page]

Table: FUN_INTER_ACCOUNTS_ADDL

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.
Comments
FUN_INTER_ACCOUNTS_addl table stores the accounts generated by balancing API after replacing the intercompany and balancing segment value from the Intercompany receivables and payables accounts with the trading partner and transacting BSV
Indexes
Index Type Tablespace Column
FUN_INTER_ACCOUNTS_ADDL_N1 NONUNIQUE APPS_TS_TX_IDX FROM_LE_ID
LEDGER_ID
TO_LE_ID
DEFAULT_FLAG
Columns
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

[top of page]

FUN.FUN_INTER_ACCOUNTS_ADDL does not reference any database object

FUN.FUN_INTER_ACCOUNTS_ADDL is referenced by following:

APPS
SYNONYM - FUN_INTER_ACCOUNTS_ADDL

[top of page]

Table: FUN_NET_AGREEMENTS_ALL

Description: FUN_NET_AGREEMENTS_ALL stores general information about Netting Agreements
Comments
FUN_NET_AGREEMENTS_ALL stores general information about Netting Agreements
Indexes
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
Columns
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.

[top of page]

FUN.FUN_NET_AGREEMENTS_ALL does not reference any database object

FUN.FUN_NET_AGREEMENTS_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_AGREEMENTS
SYNONYM - FUN_NET_AGREEMENTS_ALL

[top of page]

Table: FUN_NET_AP_INVS_ALL

Description: FUN_NET_AP_INVS_ALL stores information about Payables invoices included in Netting Batch.
Comments
FUN_NET_AP_INVS_ALL stores information about Payables invoices included in Netting Batch.
Indexes
Index Type Tablespace Column
FUN_NET_AP_INVS_ALL_U1 UNIQUE APPS_TS_TX_IDX BATCH_ID
INVOICE_ID
Columns
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.

[top of page]

FUN.FUN_NET_AP_INVS_ALL does not reference any database object

FUN.FUN_NET_AP_INVS_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_AP_INVS
SYNONYM - FUN_NET_AP_INVS_ALL

[top of page]

Table: FUN_NET_AP_INV_TYPES_ALL

Description: FUN_NET_AP_INV_TYPES_ALL stores information about the Payables Invoice Types that are included in a Netting Agreement
Comments
FUN_NET_AP_INV_TYPES_ALL stores information about the Payables Invoice Types that are included in a Netting Agreement
Indexes
Index Type Tablespace Column
FUN_NET_AP_INV_TYPES_U1 UNIQUE APPS_TS_TX_IDX AGREEMENT_ID
INVOICE_TYPE
Columns
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.

[top of page]

FUN.FUN_NET_AP_INV_TYPES_ALL does not reference any database object

FUN.FUN_NET_AP_INV_TYPES_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_AP_INV_TYPES
SYNONYM - FUN_NET_AP_INV_TYPES_ALL

[top of page]

Table: FUN_NET_AR_TRX_TYPES_ALL

Description: FUN_NET_AR_TRX_TYPES_ALL stores information about the ReceivablesTransaction Types that are included in a Netting Agreement.
Comments
FUN_NET_AR_TRX_TYPES_ALL stores information about the ReceivablesTransaction Types that are included in a Netting Agreement.
Indexes
Index Type Tablespace Column
FUN_NET_AR_TRX_TYPES_U1 UNIQUE APPS_TS_TX_IDX AGREEMENT_ID
CUST_TRX_TYPE_ID
Columns
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.

[top of page]

FUN.FUN_NET_AR_TRX_TYPES_ALL does not reference any database object

FUN.FUN_NET_AR_TRX_TYPES_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_AR_TRX_TYPES
SYNONYM - FUN_NET_AR_TRX_TYPES_ALL

[top of page]

Table: FUN_NET_AR_TXNS_ALL

Description: FUN_NET_AR_TXNS_ALL stores information about Receivables Transactions included in Netting Batch.
Comments
FUN_NET_AR_TXNS_ALL stores information about Receivables Transactions included in Netting Batch.
Indexes
Index Type Tablespace Column
FUN_NET_AR_TXNS_ALL_U1 UNIQUE APPS_TS_TX_IDX BATCH_ID
CUSTOMER_TRX_ID
Columns
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.

[top of page]

FUN.FUN_NET_AR_TXNS_ALL does not reference any database object

FUN.FUN_NET_AR_TXNS_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_AR_TXNS
SYNONYM - FUN_NET_AR_TXNS_ALL

[top of page]

Table: FUN_NET_BATCHES_ALL

Description: FUN_NET_BATCHES_ALL stores information about Netting Batches.
Comments
FUN_NET_BATCHES_ALL stores information about Netting Batches.
Indexes
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
Columns
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.

[top of page]

FUN.FUN_NET_BATCHES_ALL does not reference any database object

FUN.FUN_NET_BATCHES_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_BATCHES
SYNONYM - FUN_NET_BATCHES_ALL

[top of page]

Table: FUN_NET_CUSTOMERS_ALL

Description: FUN_NET_CUSTOMERS_ALL stores information about the Customers that are included in a Netting Agreement.
Comments
FUN_NET_CUSTOMERS_ALL stores information about the Customers that are included in a Netting Agreement.
Indexes
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
Columns
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.

[top of page]

FUN.FUN_NET_CUSTOMERS_ALL does not reference any database object

FUN.FUN_NET_CUSTOMERS_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_CUSTOMERS
SYNONYM - FUN_NET_CUSTOMERS_ALL

[top of page]

Table: FUN_NET_SUPPLIERS_ALL

Description: FUN_NET_SUPPLIERS_ALL stores information about the Suppliers that are included in a Netting Agreement.
Comments
FUN_NET_SUPPLIERS_ALL stores information about the Suppliers that are included in a Netting Agreement.
Indexes
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
Columns
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.

[top of page]

FUN.FUN_NET_SUPPLIERS_ALL does not reference any database object

FUN.FUN_NET_SUPPLIERS_ALL is referenced by following:

APPS
SYNONYM - FUN_NET_SUPPLIERS
SYNONYM - FUN_NET_SUPPLIERS_ALL

[top of page]

Table: FUN_PERIOD_STATUSES

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
Comments
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 and closed for each Intercompany transaction type.
Indexes
Index Type Tablespace Column
FUN_PERIOD_STATUSES_U1 UNIQUE APPS_TS_TX_IDX INTECO_CALENDAR
INTECO_PERIOD_TYPE
PERIOD_NAME
TRX_TYPE_ID
Columns
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

[top of page]

FUN.FUN_PERIOD_STATUSES does not reference any database object

FUN.FUN_PERIOD_STATUSES is referenced by following:

APPS
SYNONYM - FUN_PERIOD_STATUSES

[top of page]

Table: FUN_RICH_MESSAGES_B

Description: Stores information about rich messages which may contain HTML tags for pretty formatting.
Comments
Stores information about rich messages which may contain HTML tags for pretty formatting.
Indexes
Index Type Tablespace Column
FUN_RICH_MESSAGES_U1 UNIQUE APPS_TS_SEED APPLICATION_ID
MESSAGE_NAME
Columns
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

[top of page]

FUN.FUN_RICH_MESSAGES_B does not reference any database object

FUN.FUN_RICH_MESSAGES_B is referenced by following:

APPS
SYNONYM - FUN_RICH_MESSAGES_B

[top of page]

Table: FUN_RICH_MESSAGES_TL

Description: Stores information about rich messages which may contain HTML tags for pretty formatting.
Comments
Stores information about rich messages which may contain HTML tags for pretty formatting.
Indexes
Index Type Tablespace Column
FUN_RICH_MESSAGES_TL_U1 UNIQUE APPS_TS_SEED APPLICATION_ID
MESSAGE_NAME
LANGUAGE
SYS_IL0000399637C00003$$ UNIQUE APPS_TS_SEED
Columns
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

[top of page]

FUN.FUN_RICH_MESSAGES_TL does not reference any database object

FUN.FUN_RICH_MESSAGES_TL is referenced by following:

APPS
SYNONYM - FUN_RICH_MESSAGES_TL

[top of page]

Table: FUN_RULE_BULK_RESULT_GT

Description: Global temporary table used by the bulk API to store the result values.
Comments
Global temporary table used by the bulk API to store the result values.
Indexes
Index Type Tablespace Column
FUN_RULE_RESULT_BULK_GT_N1 NONUNIQUE ID
Columns
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

[top of page]

FUN.FUN_RULE_BULK_RESULT_GT does not reference any database object

FUN.FUN_RULE_BULK_RESULT_GT is referenced by following:

APPS
SYNONYM - FUN_RULE_BULK_RESULT_GT

[top of page]

Table: FUN_RULE_CRITERIA

Description: Stores a single criteria for a rule.
Comments
Stores a single criteria for a rule.
Indexes
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
Columns
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

[top of page]

FUN.FUN_RULE_CRITERIA does not reference any database object

FUN.FUN_RULE_CRITERIA is referenced by following:

APPS
SYNONYM - FUN_RULE_CRITERIA

[top of page]

Table: FUN_RULE_CRIT_PARAMS_B

Description: Stores the available criteria parameters for a Rule Object.
Comments
Stores the available criteria parameters for a Rule Object.
Indexes
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
Columns
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

[top of page]

FUN.FUN_RULE_CRIT_PARAMS_B does not reference any database object

FUN.FUN_RULE_CRIT_PARAMS_B is referenced by following:

APPS
SYNONYM - FUN_RULE_CRIT_PARAMS_B

[top of page]

Table: FUN_RULE_CRIT_PARAMS_TL

Description: Stores the available criteria parameters for a Rule Object.
Comments
Stores the available criteria parameters for a Rule Object.
Indexes
Index Type Tablespace Column
FUN_RULE_CRIT_PARAMS_TL_U1 UNIQUE APPS_TS_SEED CRITERIA_PARAM_ID
LANGUAGE
Columns
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.

[top of page]

FUN.FUN_RULE_CRIT_PARAMS_TL does not reference any database object

FUN.FUN_RULE_CRIT_PARAMS_TL is referenced by following:

APPS
SYNONYM - FUN_RULE_CRIT_PARAMS_TL

[top of page]

Table: FUN_RULE_DETAILS

Description: Stores details about a rule.
Comments
Stores details about a rule.
Indexes
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
Columns
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

[top of page]

FUN.FUN_RULE_DETAILS does not reference any database object

FUN.FUN_RULE_DETAILS is referenced by following:

APPS
SYNONYM - FUN_RULE_DETAILS

[top of page]

Table: FUN_RULE_OBJECTS_B

Description: Stores information about Rule Objects.
Comments
Stores information about Rule Objects.
Indexes
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
Columns
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)

[top of page]

FUN.FUN_RULE_OBJECTS_B does not reference any database object

FUN.FUN_RULE_OBJECTS_B is referenced by following:

APPS
SYNONYM - FUN_RULE_OBJECTS_B

[top of page]

Table: FUN_RULE_OBJECTS_TL

Description: Stores information about Rule Objects.
Comments
Stores information about Rule Objects.
Indexes
Index Type Tablespace Column
FUN_RULE_OBJECTS_TL_U1 UNIQUE APPS_TS_SEED RULE_OBJECT_ID
LANGUAGE
Columns
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.

[top of page]

FUN.FUN_RULE_OBJECTS_TL does not reference any database object

FUN.FUN_RULE_OBJECTS_TL is referenced by following:

APPS
SYNONYM - FUN_RULE_OBJECTS_TL

[top of page]

Table: FUN_RULE_OBJ_ATTRIBUTES

Description: Stores additional Rule Object attributes.
Comments
Stores additional Rule Object attributes.
Indexes
Index Type Tablespace Column
FUN_RULE_OBJ_ATTRIBUTES_U1 UNIQUE APPS_TS_SEED RULE_OBJECT_ID
Columns
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

[top of page]

FUN.FUN_RULE_OBJ_ATTRIBUTES does not reference any database object

FUN.FUN_RULE_OBJ_ATTRIBUTES is referenced by following:

APPS
SYNONYM - FUN_RULE_OBJ_ATTRIBUTES

[top of page]

Table: FUN_RULE_PARAM_VALUES

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
Comments
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 see if the parameter value is or is not in this list.
Indexes
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
Columns
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

[top of page]

FUN.FUN_RULE_PARAM_VALUES does not reference any database object

FUN.FUN_RULE_PARAM_VALUES is referenced by following:

APPS
SYNONYM - FUN_RULE_PARAM_VALUES

[top of page]

Table: FUN_RULE_TESTS

Description: Stores test cases for the Financials Rules Engine
Comments
Stores test cases for the Financials Rules Engine
Indexes
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
Columns
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)

[top of page]

FUN.FUN_RULE_TESTS does not reference any database object

FUN.FUN_RULE_TESTS is referenced by following:

APPS
SYNONYM - FUN_RULE_TESTS

[top of page]

Table: FUN_RULE_TEST_MULTIRULE

Description: Stores the test results for a test if multiple results are allowed for the Rule Object
Comments
Stores the test results for a test if multiple results are allowed for the Rule Object
Indexes
Index Type Tablespace Column
FUN_RULE_TEST_MULTIRULE_U1 UNIQUE APPS_TS_SEED TEST_ID
EXPECTED_RULE_DETAIL_ID
Columns
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

[top of page]

FUN.FUN_RULE_TEST_MULTIRULE does not reference any database object

FUN.FUN_RULE_TEST_MULTIRULE is referenced by following:

APPS
SYNONYM - FUN_RULE_TEST_MULTIRULE

[top of page]

Table: FUN_RULE_TEST_MVAL_RES

Description:
Comments
Columns
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)

[top of page]

FUN.FUN_RULE_TEST_MVAL_RES does not reference any database object

FUN.FUN_RULE_TEST_MVAL_RES is referenced by following:

APPS
SYNONYM - FUN_RULE_TEST_MVAL_RES

[top of page]

Table: FUN_RULE_TEST_PARAMS

Description: Stores parameter values for tests.
Comments
Stores parameter values for tests.
Indexes
Index Type Tablespace Column
FUN_RULE_TEST_PARAMS_U1 UNIQUE APPS_TS_SEED TEST_ID
CRITERIA_PARAM_ID
Columns
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

[top of page]

FUN.FUN_RULE_TEST_PARAMS does not reference any database object

FUN.FUN_RULE_TEST_PARAMS is referenced by following:

APPS
SYNONYM - FUN_RULE_TEST_PARAMS

[top of page]

Table: FUN_RULE_TEST_RESULTS

Description:
Comments
Columns
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

[top of page]

FUN.FUN_RULE_TEST_RESULTS does not reference any database object

FUN.FUN_RULE_TEST_RESULTS is referenced by following:

APPS
SYNONYM - FUN_RULE_TEST_RESULTS

[top of page]

Table: FUN_SEQ_ASSIGNMENTS

Description:
Comments
Indexes
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
Columns
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)

[top of page]

FUN.FUN_SEQ_ASSIGNMENTS does not reference any database object

FUN.FUN_SEQ_ASSIGNMENTS is referenced by following:

APPS
SYNONYM - FUN_SEQ_ASSIGNMENTS

[top of page]

Table: FUN_SEQ_CONTEXTS

Description:
Comments
Indexes
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
Columns
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)

[top of page]

FUN.FUN_SEQ_CONTEXTS does not reference any database object

FUN.FUN_SEQ_CONTEXTS is referenced by following:

APPS
SYNONYM - FUN_SEQ_CONTEXTS

[top of page]

Table: FUN_SEQ_ENTITIES

Description:
Comments
Indexes
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
Columns
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)

[top of page]

FUN.FUN_SEQ_ENTITIES does not reference any database object

FUN.FUN_SEQ_ENTITIES is referenced by following:

APPS
SYNONYM - FUN_SEQ_ENTITIES

[top of page]

Table: FUN_SEQ_HEADERS

Description:
Comments
Indexes
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
Columns
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)

[top of page]

FUN.FUN_SEQ_HEADERS does not reference any database object

FUN.FUN_SEQ_HEADERS is referenced by following:

APPS
SYNONYM - FUN_SEQ_HEADERS

[top of page]

Table: FUN_SEQ_REQUESTS

Description:
Comments
Columns
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)

[top of page]

FUN.FUN_SEQ_REQUESTS does not reference any database object

FUN.FUN_SEQ_REQUESTS is referenced by following:

APPS
SYNONYM - FUN_SEQ_REQUESTS

[top of page]

Table: FUN_SEQ_RULES

Description:
Comments
Indexes
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
Columns
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)

[top of page]

FUN.FUN_SEQ_RULES does not reference any database object

FUN.FUN_SEQ_RULES is referenced by following:

APPS
SYNONYM - FUN_SEQ_RULES

[top of page]

Table: FUN_SEQ_VERSIONS

Description:
Comments
Indexes
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
Columns
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)

[top of page]

FUN.FUN_SEQ_VERSIONS does not reference any database object

FUN.FUN_SEQ_VERSIONS is referenced by following:

APPS
SYNONYM - FUN_SEQ_VERSIONS

[top of page]

Table: FUN_SUBSIDIARY_PARTY_MAPPINGS

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.
Comments
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.
Indexes
Index Type Tablespace Column
FUN_SUBSIDIARY_PARTY_MAP_N1 NONUNIQUE APPS_TS_TX_IDX SUBSIDIARY_ID
Columns
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

[top of page]

FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS does not reference any database object

FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS is referenced by following:

APPS
SYNONYM - FUN_SUBSIDIARY_PARTY_MAPPINGS

[top of page]

Table: FUN_SUPPLIER_MAPS

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.
Comments
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.
Columns
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.

[top of page]

FUN.FUN_SUPPLIER_MAPS does not reference any database object

FUN.FUN_SUPPLIER_MAPS is referenced by following:

APPS
SYNONYM - FUN_SUPPLIER_MAPS

[top of page]

Table: FUN_SYSTEM_OPTIONS

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.
Comments
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.
Columns
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.

[top of page]

FUN.FUN_SYSTEM_OPTIONS does not reference any database object

FUN.FUN_SYSTEM_OPTIONS is referenced by following:

APPS
SYNONYM - FUN_SYSTEM_OPTIONS

[top of page]

Table: FUN_TRADE_RELATIONS

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.
Comments
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.
Columns
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

[top of page]

FUN.FUN_TRADE_RELATIONS does not reference any database object

FUN.FUN_TRADE_RELATIONS is referenced by following:

APPS
SYNONYM - FUN_TRADE_RELATIONS

[top of page]

Table: FUN_TRANSFERS

Description: This table is no longer used.
Comments
This table is no longer used.
Indexes
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
Columns
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)

[top of page]

FUN.FUN_TRANSFERS does not reference any database object

FUN.FUN_TRANSFERS is referenced by following:

APPS
SYNONYM - FUN_TRANSFERS

[top of page]

Table: FUN_TRX_ACCT_DEFINITIONS

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
Comments
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 SLA which should be used to default the initiator and recipient distribution lines.
Columns
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.

[top of page]

FUN.FUN_TRX_ACCT_DEFINITIONS does not reference any database object

FUN.FUN_TRX_ACCT_DEFINITIONS is referenced by following:

APPS
SYNONYM - FUN_TRX_ACCT_DEFINITIONS

[top of page]

Table: FUN_TRX_BATCHES

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.
Comments
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.
Indexes
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
Columns
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.

[top of page]

FUN.FUN_TRX_BATCHES does not reference any database object

FUN.FUN_TRX_BATCHES is referenced by following:

APPS
SYNONYM - FUN_TRX_BATCHES

[top of page]

Table: FUN_TRX_HEADERS

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
Comments
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 transactions where each transaction is a for a different recipient.
Indexes
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
Columns
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.

[top of page]

FUN.FUN_TRX_HEADERS does not reference any database object

FUN.FUN_TRX_HEADERS is referenced by following:

APPS
SYNONYM - FUN_TRX_HEADERS

[top of page]

Table: FUN_TRX_LINES

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.
Comments
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.
Indexes
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
Columns
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.

[top of page]

FUN.FUN_TRX_LINES does not reference any database object

FUN.FUN_TRX_LINES is referenced by following:

APPS
SYNONYM - FUN_TRX_LINES

[top of page]

Table: FUN_TRX_TYPES_B

Description: FUN_TRX_TYPES_B stores the Intercompany transaction types defined.
Comments
FUN_TRX_TYPES_B stores the Intercompany transaction types defined.
Indexes
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
Columns
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.

[top of page]

FUN.FUN_TRX_TYPES_B does not reference any database object

FUN.FUN_TRX_TYPES_B is referenced by following:

APPS
SYNONYM - FUN_TRX_TYPES_B

[top of page]

Table: FUN_TRX_TYPES_TL

Description: FUN_TRX_TYPES_TL stores the translatable column details for the Intercompany transaction types.
Comments
FUN_TRX_TYPES_TL stores the translatable column details for the Intercompany transaction types.
Indexes
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
Columns
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.

[top of page]

FUN.FUN_TRX_TYPES_TL does not reference any database object

FUN.FUN_TRX_TYPES_TL is referenced by following:

APPS
SYNONYM - FUN_TRX_TYPES_TL

[top of page]

Table: FUN_TRX_TYPE_AR_MAPS

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
Comments
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 transferred into Receivables.
Columns
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.

[top of page]

FUN.FUN_TRX_TYPE_AR_MAPS does not reference any database object

FUN.FUN_TRX_TYPE_AR_MAPS is referenced by following:

APPS
SYNONYM - FUN_TRX_TYPE_AR_MAPS

[top of page]

Table: FUN_XLA_TAB_GT

Description:
Comments
Columns
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)

[top of page]

FUN.FUN_XLA_TAB_GT does not reference any database object

FUN.FUN_XLA_TAB_GT is referenced by following:

APPS
SYNONYM - FUN_XLA_TAB_GT

[top of page]

View: FUN_RULE_OBJECTS_VL

Comments
Columns
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)

[top of page]

APPS.FUN_RULE_OBJECTS_VL references the following:

APPS
SYNONYM - FUN_RULE_OBJECTS_B
SYNONYM - FUN_RULE_OBJECTS_TL
SYNONYM - FUN_RULE_OBJ_ATTRIBUTES
APPS.FUN_RULE_OBJECTS_VL is referenced by following:

APPS
PACKAGE BODY - FUN_RULE_OBJECTS_PKG

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract