| Application Object Library - FND_APPLICATION | Applications registered with Oracle Application Object Library |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| PRODUCT_CODE | Online help base application short name, if help content is shared with another application |
| APPLICATION_SHORT_NAME | Application short name |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| BASEPATH | The variable that stores the directory path of the TOP directory for the application |
| Application Object Library - FND_COLUMNS | Columns in all the registered application tables |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application that owns the table that owns this column. Foreign key to FND_TABLE. |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| COLUMN_TYPE | Column datatype. D (Date), N (Number), V (Varchar), I (RowID), L (Long), X (Long Raw) are possible values. |
| WIDTH | Bytes of storage for column value |
| NULL_ALLOWED_FLAG | Y/N flag: Are null values allowed? |
| TRANSLATE_FLAG | Y/N flag: Is value translated? |
| FLEXFIELD_USAGE_CODE | Code that indicates how the column is used in flexfields. N (not used), K (key flexfield segment), D (descriptive flexfield attribute), Q (?), S (structure identifier), I (key flexfield identifier), and C (category) are possible values. |
| DESCRIPTION | Name of flexfield associated with this column |
| FLEXFIELD_APPLICATION_ID | Flexfield application identifier |
| FLEXFIELD_NAME | Flexfield name |
| TABLE_ID | Table to which column belongs. Foreign key to FND_TABLES. |
| FLEX_VALUE_SET_APPLICATION_ID | Flexfield value set application identifier |
| FLEX_VALUE_SET_ID | Flexfield value set identifier |
| DEFAULT_VALUE | Default value for column, if any |
| PRECISION | Precision for column, if any |
| SCALE | Scale for column, if any |
| IREP_COMMENTS | Comments from CASE |
| COLUMN_ID | Column identifier. |
| COLUMN_NAME | Actual database column name |
| USER_COLUMN_NAME | Name for column that is meaningful to users |
| COLUMN_SEQUENCE | Sequence number. Indicates order of columns in created table. |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| Application Object Library - FND_COMPILED_DESCRIPTIVE_FLEXS | Compiled information about descriptive flexfields |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| DESCRIPTIVE_FLEXFIELD_NAME | Descriptive flexfield name |
| COMPILER_VERSION_NUM | Descriptive flexfield compiler version |
| SEQUENCE | Sequence of compiled definition |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| COMPILED_DEFINITION | Compiled definition of the descriptive flexfield |
| LANGUAGE | Language |
| Application Object Library - FND_COMPILED_ID_FLEXS | Compiled information about key flexfields |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| ID_FLEX_CODE | Key flexfield code |
| COMPILER_VERSION_NUM | Flexfield compiler version |
| SEQUENCE | Sequence of compiled key flexfield definition |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| COMPILED_DEFINITION | Compiled definition of the key flexfield |
| LANGUAGE | Language |
| Application Object Library - FND_CONCURRENT_PROCESSES | Operating system and ORACLE process IDs for concurrent managers |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATE_DATE | Standard Who column |
| LOGFILE_NAME | Name of log file |
| JOB_ID | Uniquely identifies processes across nodes to control termination of a request and/or manager process on some platforms which make use of load balancing features provided by the hardware vendor for clusters |
| DB_INSTANCE | Used with parallel concurrent processing in an Oracle Parallel Server environment to identify (check the availability/status of) an instance of Database. |
| LK_HANDLE | For internal use only |
| PLSQL_LOG | Contains temporary PLSQL log file information |
| PLSQL_OUT | Contains temporary PLSQL out file information |
| LAST_TXN_START | Date last transaction ended |
| LAST_TXN_END | Date last transaction started |
| PLSQL_DIR | Directory for temporary log and out files |
| INSTANCE_NUMBER | OPS Instance number |
| LAST_UPDATED_BY | Standard Who column |
| PROCESS_CONTEXT | Process Context buffer |
| SERVICE_PARAMETERS | Service Parameters |
| GSM_INTERNAL_STATUS | gsm internal status |
| GSM_INTERNAL_INFO | gsm internal status info |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| QUEUE_APPLICATION_ID | Application identifier |
| CONCURRENT_QUEUE_ID | Concurrent manager queue identifier |
| PROCESS_STATUS_CODE | Code to reflect the status of the process |
| CONCURRENT_PROCESS_ID | Concurrent process identifier |
| SESSION_ID | Database session identifier |
| ORACLE_PROCESS_ID | Database process identifier |
| PROCESS_START_DATE | The date when the process starts running |
| OS_PROCESS_NAME | Not currently used |
| OS_PROCESS_ID | Operating system process identifier |
| MANAGER_TYPE | MANAGER_TYPE - Code that indicates the concurrent manager service type (0 - Internal Concurrent Manager; 1 - Concurrent managers; 2 - Transaction Manager; 3 - Internal Monitor; 4 - Conflict Resolution Manager; 5 - Scheduler) |
| NODE_NAME | Machine name |
| DB_NAME | Local database name |
| DB_DOMAIN | Logical location of the database |
| SQLNET_STRING | Not currently used |
| Application Object Library - FND_CONCURRENT_PROCESSORS | Immediate concurrent program libraries |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| LAST_REBUILT | Date and time when the concurrent program library was last generated |
| LIBRARY_TYPE | Library type quickcode |
| CONCURRENT_PROCESSOR_ID | Identifier of the concurrent program library |
| CONCURRENT_PROCESSOR_NAME | Name of the physical executable file name for the concurrent program library |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Description |
| Application Object Library - FND_CONCURRENT_PROGRAMS | Concurrent programs |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| EXECUTABLE_ID | Concurrent program executable identifier |
| EXECUTION_METHOD_CODE | Execution method for the concurrent program |
| ARGUMENT_METHOD_CODE | Code to indicate how program arguments are passed to the concurrent program |
| QUEUE_CONTROL_FLAG | Flag to indicate if the concurrent program controls concurrent managers |
| QUEUE_METHOD_CODE | Code to indicate whether the concurrent program is constrained |
| REQUEST_SET_FLAG | Flag to indicate whether the concurrent program is a parent of a report set |
| ENABLED_FLAG | Enabled flag |
| PRINT_FLAG | Flag to indicate whether the concurrent manager should print output of the concurrent program |
| RUN_ALONE_FLAG | Flag to indicate if this is a run alone concurrent program |
| SRS_FLAG | Flag to indicate if a request can be submitted for this concurrent program from Standard Report Submission |
| CONCURRENT_PROGRAM_ID | Concurrent program identifier |
| CLASS_APPLICATION_ID | Identifier of application for with which the request type of this program is identified |
| CONCURRENT_CLASS_ID | Request type identifier |
| EXECUTION_OPTIONS | SQL*Report or Oracle Report program running options |
| SAVE_OUTPUT_FLAG | Flag to indicate whether to save output file for the concurrent program |
| REQUIRED_STYLE | Flag to indicate if the print style associated with the concurrent program is mandatory |
| OUTPUT_PRINT_STYLE | The print style for the concurrent program output |
| PRINTER_NAME | Name of printer for printing the concurrent program output |
| MINIMUM_WIDTH | Minimum number of columns |
| MINIMUM_LENGTH | Minimum number of rows |
| REQUEST_PRIORITY | Program level priority assigned by the System Administrator to guarantee that programs run at the same level regardless of who submits them (REQUEST_PRIORITY assigned to concurrent programs overrides the user profile value) |
| CONCURRENT_PROGRAM_NAME | Internal name of the concurrent program |
| ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| IPROG_ID | Conflict resolution manager internal information |
| OUTPUT_FILE_TYPE | Format of output file |
| ENABLE_TRACE | Turns on tracing for requests |
| RESTART | Indicates program may be re-started |
| LAST_UPDATED_BY | Standard Who column |
| NLS_COMPLIANT | Indicates if the program is NLS compliant. In particular, indicates if the program accepts date and number parameters in canonical format |
| ICON_NAME | Reserved for future use |
| CD_PARAMETER | Parameter used to identify conflict domains |
| INCREMENT_PROC | Procedure name used to increment program parameters |
| MLS_EXECUTABLE_APP_ID | Application identifier for MLS language function |
| MLS_EXECUTABLE_ID | Identifier for MLS language function |
| ENABLE_TIME_STATISTICS | Y or N. Timed statistics collection is turned on for the program's session when set to Y |
| SECURITY_GROUP_ID | Security group identifier |
| STAT_COLLECT | Reserved for future use |
| RESOURCE_CONSUMER_GROUP | Resource consumer group |
| CREATION_DATE | Standard Who column |
| ROLLBACK_SEGMENT | Rollback segment for a transaction |
| OPTIMIZER_MODE | Optimization mode, such as RULE, FIRST_ROW, etc. |
| INSTANCE_ID | OPS Instance number |
| REFRESH_PORTLET | refresh portlet based on program outcome. Possible values 'N'ever/'S'uccess/'A'lways/'W'arning.(lookup type CONC_REFRESH_PORTLET) |
| PROGRAM_TYPE | Concurrent Program Type. Possible values( 'O'(ther), 'P'(urge) ) Lookup type CONC_PROGRAM_TYPE |
| ACTIVITY_SUMMARIZER | PLSQL procedure that developers can register to provide summary information what the programcan do. |
| REQUEST_SCH_INTERVAL | Oracle suggested request schedule repeat interval value in days |
| ALLOW_MULTIPLE_PENDING_REQUEST | If set to N if there is one pending request then it will not submit another request |
| DELETE_LOG_FILE | If set to Y Concurrent Manager will delete Request Log file |
| TEMPLATE_APPL_SHORT_NAME | XML Publisher default template appl short name |
| TEMPLATE_CODE | default template code |
| MULTI_ORG_CATEGORY | multi_org_category |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| EXECUTABLE_APPLICATION_ID | Identifier of the application with which the executable is registered |
| Application Object Library - FND_CONCURRENT_PROGRAM_SERIAL | Incompatible concurrent programs |
|---|---|
| Column Name | Descritpion |
| RUNNING_CONCURRENT_PROGRAM_ID | Concurrent program identifier |
| TO_RUN_APPLICATION_ID | Application identifier of the incompatible concurrent program |
| TO_RUN_CONCURRENT_PROGRAM_ID | The identifier of the incompatible concurrent program |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| RUNNING_APPLICATION_ID | Application identifier of the concurrent program |
| UPDATE_SECURITY_GROUP_ID | Not currently used |
| RUNNING_TYPE | Flag to indicate whether the concurrent program is a Program or a Report Set |
| TO_RUN_TYPE | Flag to indicate whether the incompatible concurrent program is a Program or a Report Set |
| INCOMPATIBILITY_TYPE | Global or Domain-specific incompatibility |
| Application Object Library - FND_CONCURRENT_QUEUES | Concurrent managers setup information |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| PROCESSOR_APPLICATION_ID | Application identifier of the program library |
| INSTANCE_NUMBER | Oracle Parallel System instance identifier; used for parallel concurrent processing |
| CONTEXT_BUFFER | Service instance cartridge data buffer |
| CONCURRENT_PROCESSOR_ID | Program library identifier |
| SERVICE_PARAMETERS | Service instance specific parameter |
| TIME_PERIOD_ID | Not in use |
| MAX_PROCESSES | The maximum number of concurrent requests the manager can run at a time |
| TIME_PERIOD_APP_ID | Not in use |
| CONCURRENT_TIME_PERIOD_ID | Indicates current workshift id |
| PERIOD_APPLICATION_ID | Indicates current workshift application id |
| RUNNING_PROCESSES | The number of currently active manager processes |
| CONCURRENT_QUEUE_ID | Concurrent manager identifier |
| CACHE_SIZE | Buffer size of the concurrent manager |
| MIN_PROCESSES | Not currently used |
| TARGET_PROCESSES | Not currently used |
| TARGET_NODE | Target machine |
| TARGET_QUEUE | Reserved for future use |
| SLEEP_SECONDS | The number of seconds the concurrent manager waits between checking the list of pending requests |
| CONTROL_CODE | Concurrent manager control code |
| DIAGNOSTIC_LEVEL | For internal use only |
| MANAGER_TYPE | Type of concurrent manager |
| CONCURRENT_QUEUE_NAME | Concurrent manager name |
| NODE_NAME | Machine name |
| NODE_NAME2 | Secondary machine name |
| OS_QUEUE | Platform-specific operating system queue name |
| OS_QUEUE2 | Secondary platform-specific operating system queue name |
| DATA_GROUP_ID | Data group used for transaction managers only |
| RESTART_TYPE | Not currently used |
| RESTART_INTERVAL | Not currently used |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| ATTRIBUTE_CATEGORY | Attribute category |
| ATTRIBUTE | Descriptive flexfield segment |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| CREATION_DATE | Standard Who column |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ENABLED_FLAG | Enabled flag |
| CREATED_BY | Standard Who column |
| RESOURCE_CONSUMER_GROUP | Resource consumer group |
| PMON_STAT | Count of dead processes found by the ICM during the PMON cycle |
| LAST_UPDATE_LOGIN | Standard Who column |
| LAST_VERIFIED | Time of last verify command for this manager |
| WORK_START | Time processing cycle began |
| WORK_END | Time processing cycle ended |
| PCP_FLAG | Is PCP enabled? Y or N (PCP - Parallel Concurrent Processing) |
| Application Object Library - FND_CONCURRENT_QUEUE_CONTENT | Specialization rules for concurrent managers |
|---|---|
| Column Name | Descritpion |
| QUEUE_APPLICATION_ID | Application identifier of the concurrent manager |
| LAST_UPDATE_LOGIN | Standard Who column |
| INCLUDE_FLAG | Flag to indicate if the overall rule is an include or exclude rule |
| CONCURRENT_QUEUE_ID | Concurrent manager identifier |
| TYPE_CODE | The type of specialization rule assigned to the concurrent manager |
| TYPE_APPLICATION_ID | Identifier of the application with which the type is defined (only used for Combined Rule, Program, and Request Type) |
| TYPE_ID | Type identifier |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| Application Object Library - FND_CONCURRENT_QUEUE_SIZE | Number of requests concurrent managers can process at a time within their work shifts |
|---|---|
| Column Name | Descritpion |
| CONCURRENT_QUEUE_ID | Concurrent manager identifier |
| PERIOD_APPLICATION_ID | Application identifier of the concurrent manager work shift |
| CONCURRENT_TIME_PERIOD_ID | Concurrent manager work shift identifier |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| QUEUE_APPLICATION_ID | Application identifier of the concurrent manager |
| MIN_PROCESSES | The maximum number of request the manager can process at one time during the work shift |
| MAX_PROCESSES | Not currently used |
| SLEEP_SECONDS | The number of seconds the concurrent manager waits between checking the list of pending requests |
| SERVICE_PARAMETERS | Service parameter for this work shift |
| FAILOVER_MIN | Minimum processes to be running during failover |
| FAILOVER_MAX | Minimum processes to be running during failover |
| Application Object Library - FND_CONCURRENT_REQUESTS | Concurrent requests information |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Concurrent request identifier |
| REQUESTED_START_DATE | The date and time when users want the request to start running |
| NOTIFY_ON_PP_ERROR | User to notify if post processing steps fail |
| CD_ID | Conflict domain identifier |
| REQUEST_LIMIT | Indicates maximum number of requests a user may submit at one time |
| CRM_RELEASE_DATE | Date at which conflicts were resolved |
| POST_REQUEST_STATUS | Reserved for future use |
| COMPLETION_CODE | Indicates the completion status of the request, such as success |
| INCREMENT_DATES | Flag to increment date parameters on resubmission |
| RESTART | Indicates program may be restarted |
| ENABLE_TRACE | Turns on tracing for requests |
| RESUB_COUNT | Resubmission count (for repeating requests) |
| HOLD_FLAG | Flag to indicate if concurrent request is on hold |
| NLS_CODESET | Character set |
| OFILE_SIZE | Filesize of request out in bytes |
| LFILE_SIZE | Filesize of request log in bytes |
| STALE | Used with Scheduler to indicate requests that could not be run within the specified/required period |
| SECURITY_GROUP_ID | Security group identifier |
| RESOURCE_CONSUMER_GROUP | Database Resource Manager group under which this request should be processed/run |
| EXP_DATE | Expiration date for request |
| ENFORCE_SERIALITY_FLAG | Not currently used |
| QUEUE_APP_ID | Not currently used (To associate request with a specific manager) |
| QUEUE_ID | Not currently used (To associate request with a specific manager) |
| SINGLE_THREAD_FLAG | Flag to indicate whether to run the request sequentially with other requests in the same logical database |
| OPS_INSTANCE | Oracle Parallel System instance identifier |
| INTERIM_STATUS_CODE | Developer set status code for Java Concurrent Programs |
| ROOT_REQUEST_ID | Root request id for a repeating requests |
| HAS_SUB_REQUEST | Flag to identify the current request as a parent request |
| ORIGIN | Reserved for future use |
| NLS_NUMERIC_CHARACTERS | NLS Numeric character used for this request |
| IS_SUB_REQUEST | Flag to identify the request as a child request |
| PP_START_DATE | Post Processing action start time |
| PP_END_DATE | Post Processing action end time |
| IMPLICIT_CODE | Code to specify whether the request appears in the View Request form for the request submitter |
| ORG_ID | ORG_ID |
| RUN_NUMBER | number to identify how may times it is running |
| UPDATE_PROTECTED | Flag to indicate if requestor is allowed to delete the request or update any of the request's attributes |
| NODE_NAME1 | Primary target node for request |
| NODE_NAME2 | Secondary target node for request |
| QUEUE_METHOD_CODE | Code to indicate if concurrent program is constrained |
| CONNSTR1 | Primary connection string for request |
| CONNSTR2 | Secondary connection string for request |
| ARGUMENT_INPUT_METHOD_CODE | Flag to indicate if the request uses token as argument input method |
| LAST_UPDATE_DATE | Standard Who column |
| ORACLE_ID | The ORACLE account used to run the concurrent request |
| PROGRAM_APPLICATION_ID | Identifier of application with which that concurrent program is registered |
| CONCURRENT_PROGRAM_ID | Concurrent program identifier |
| RESPONSIBILITY_APPLICATION_ID | Identifier of the application with which the responsibility is defined |
| RESPONSIBILITY_ID | Responsibility identifier |
| NUMBER_OF_ARGUMENTS | Number of arguments |
| NUMBER_OF_COPIES | Number of copies to print |
| SAVE_OUTPUT_FLAG | Flag to indicate whether to save output to a file |
| NLS_COMPLIANT | Indicates if program is NLS compliant |
| LAST_UPDATE_LOGIN | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| NLS_LANGUAGE | Language |
| NLS_TERRITORY | The territory using the language |
| PRINTER | Name of printer to print output |
| PRINT_STYLE | Output print style |
| PRINT_GROUP | Flag to indicate whether to print the request output together with other reports or programs in the report set |
| REQUEST_CLASS_APPLICATION_ID | Identifier of application with which request type is defined |
| CONCURRENT_REQUEST_CLASS_ID | Request type identifier |
| PARENT_REQUEST_ID | Request identifier of the request that submits this request |
| CONC_LOGIN_ID | Login session identifier |
| LANGUAGE_ID | Language identifier |
| REQUEST_DATE | Concurrent request submission date |
| DESCRIPTION | Description |
| REQ_INFORMATION | Miscellaneous information for the request to be used with the parent request of a report set |
| RESUBMIT_INTERVAL | The number of units to resubmit a request |
| RESUBMIT_INTERVAL_UNIT_CODE | Code to indicate whether resubmit interval unit is in Days, Hours, Minutes, or Months |
| RESUBMIT_INTERVAL_TYPE_CODE | Code indicating whether to start interval count down from the requested start time or the completion of the request |
| RESUBMIT_TIME | The time of the day to regularly resubmit the request |
| RESUBMIT_END_DATE | The end date for resubmitting the request |
| RESUBMITTED | Flag to indicate whether the request has been resubmitted |
| CONTROLLING_MANAGER | Identifier of concurrent manager that processed this request |
| ACTUAL_START_DATE | The actual time and date when the request started running |
| REQUESTED_BY | Username of the requestor |
| ACTUAL_COMPLETION_DATE | The time and date when the request was completed |
| COMPLETION_TEXT | The text message about how the request completed |
| OUTCOME_PRODUCT | Not currently used |
| OUTCOME_CODE | Not currently used |
| CPU_SECONDS | Not currently used |
| LOGICAL_IOS | Not currently used |
| PHYSICAL_IOS | Not currently used |
| LOGFILE_NAME | Logfile name |
| LOGFILE_NODE_NAME | The name of node or machine on which to create the log file |
| OUTFILE_NAME | Name of output file |
| PHASE_CODE | Code to indicate in what phase the concurrent request is |
| OUTFILE_NODE_NAME | The name of node or machine on which to create the output file |
| ARGUMENT_TEXT | Concurrent Request Argument |
| ARGUMENT1 | Concurrent Request Argument |
| ARGUMENT2 | Concurrent Request Argument |
| ARGUMENT3 | Concurrent Request Argument |
| ARGUMENT4 | Concurrent Request Argument |
| ARGUMENT5 | Concurrent Request Argument |
| ARGUMENT6 | Concurrent Request Argument |
| ARGUMENT7 | Concurrent Request Argument |
| ARGUMENT8 | Concurrent Request Argument |
| STATUS_CODE | The current status of the concurrent request |
| ARGUMENT9 | Concurrent Request Argument |
| ARGUMENT10 | Concurrent Request Argument |
| ARGUMENT11 | Concurrent Request Argument |
| ARGUMENT12 | Concurrent Request Argument |
| ARGUMENT13 | Concurrent Request Argument |
| ARGUMENT14 | Concurrent Request Argument |
| ARGUMENT15 | Concurrent Request Argument |
| ARGUMENT16 | Concurrent Request Argument |
| ARGUMENT17 | Concurrent Request Argument |
| ARGUMENT18 | Concurrent Request Argument |
| PRIORITY_REQUEST_ID | Request identifier of the oldest ancestor or parent request |
| ARGUMENT19 | Concurrent Request Argument |
| ARGUMENT20 | Concurrent Request Argument |
| ARGUMENT21 | Concurrent Request Argument |
| ARGUMENT22 | Concurrent Request Argument |
| ARGUMENT23 | Concurrent Request Argument |
| ARGUMENT24 | Concurrent Request Argument |
| ARGUMENT25 | Concurrent Request Argument |
| CRM_THRSHLD | Used internally by the conflict resolution manager |
| CRM_TSTMP | Used internally by the conflict resolution manager |
| CRITICAL | Is this a critical storage |
| PRIORITY | Priority of the concurrent request |
| REQUEST_TYPE | Specialization type |
| ORACLE_PROCESS_ID | Database process identifier |
| ORACLE_SESSION_ID | Database session identifier |
| OS_PROCESS_ID | Operating system process identifier |
| PRINT_JOB_ID | Reserved for future use |
| OUTPUT_FILE_TYPE | Format of output file |
| RELEASE_CLASS_APP_ID | Application identifier of the schedule |
| RELEASE_CLASS_ID | Schedule identifier |
| STALE_DATE | Used for advanced schedules |
| CANCEL_OR_HOLD | Used for advanced schedules |
| Application Object Library - FND_CONCURRENT_REQUEST_CLASS | Concurrent request types |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| REQUEST_CLASS_ID | Request type identifier |
| REQUEST_CLASS_NAME | Request type name |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Description |
| Application Object Library - FND_CONCURRENT_TIME_PERIODS | Concurrent processing work shifts |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| DESCRIPTION | Description |
| START_TIME | The starting time of the work shift |
| END_TIME | The time the work shift ends |
| FROM_WEEK_DAY | The day of the week the work shift starts |
| TO_WEEK_DAY | The day of the week the work shift ends |
| SPECIFIC_DATE | The date to run the work shift |
| CONCURRENT_TIME_PERIOD_ID | Concurrent processing work shift identifier |
| CONCURRENT_TIME_PERIOD_NAME | Concurrent processing work shift name |
| CONCURRENT_DAYS_SPEC_METHOD | Not currently used |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_CONC_PROCESSOR_PROGRAMS | Immediate concurrent programs included in concurrent program libraries |
|---|---|
| Column Name | Descritpion |
| PROCESSOR_APPLICATION_ID | Application identifier of the concurrent program library |
| CONCURRENT_PROCESSOR_ID | Program Library identifier |
| PROGRAM_APPLICATION_ID | Application identifier of the immediate concurrent program |
| CONCURRENT_PROGRAM_ID | Concurrent program identifier |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_DEFAULT_CONTEXT_FIELDS | Name of fields on forms that users can use as reference fields for descriptive flexfields |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| DESCRIPTION | Description |
| DESCRIPTIVE_FLEXFIELD_NAME | Descriptive flexfield name |
| DEFAULT_CONTEXT_FIELD_NAME | Name of reference field |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_DESCRIPTIVE_FLEXS | Descriptive flexfields registration information |
|---|---|
| Column Name | Descritpion |
| APPLICATION_TABLE_NAME | Table name |
| CONTEXT_OVERRIDE_VALUE_SET_ID | CONTEXT_OVERRIDE_VALUE |
| CONTEXT_RUNTIME_PROPERTY_FUNCT | CONTEXT_RUNTIME_PROPERTY_FUNCT |
| CONCATENATED_SEGS_VIEW_NAME | DFV view name |
| CONTEXT_SYNCHRONIZATION_FLAG | Synchronize Context with Reference field value |
| DESCRIPTIVE_FLEXFIELD_NAME | APPLICATION_TABLE_NAME |
| TABLE_APPLICATION_ID | Application to which table belongs |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| APPLICATION_ID | Application identifier |
| CONTEXT_REQUIRED_FLAG | Flag to indicate whether the descriptive flexfield requires a reference field |
| CONTEXT_COLUMN_NAME | The name of the structure defining column for the flexfield |
| CONTEXT_USER_OVERRIDE_FLAG | Flag to indicate if users can override the value in the reference field |
| CONCATENATED_SEGMENT_DELIMITER | The delimiter used to separate different segment values in the concatenated value |
| FREEZE_FLEX_DEFINITION_FLAG | Flag to indicate if the descriptive flexfield is frozen |
| PROTECTED_FLAG | Flag to indicate whether this is a protected descriptive flexfield |
| DEFAULT_CONTEXT_FIELD_NAME | The name of the reference field |
| DEFAULT_CONTEXT_VALUE | The default value for the reference field |
| CONTEXT_DEFAULT_TYPE | CONTEXT_DEFAULT_TYPE |
| CONTEXT_DEFAULT_VALUE | CONTEXT_DEFAULT_VALUE |
| Application Object Library - FND_DESCR_FLEX_COLUMN_USAGES | Correspondences between application table columns and descriptive flexfield segments |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| LAST_UPDATE_LOGIN | Standard Who column |
| COLUMN_SEQ_NUM | The corresponding segment number for the column |
| ENABLED_FLAG | Flag to indicate if the descriptive flexfield segment is enabled |
| REQUIRED_FLAG | Flag to indicate whether a value must be entered for this segment |
| SECURITY_ENABLED_FLAG | Flag to tell if security is enabled for this segment |
| DISPLAY_FLAG | Flag to indicate whether to display the segment |
| DISPLAY_SIZE | The display size for the segment |
| MAXIMUM_DESCRIPTION_LEN | The maximum size of the segment value description in flexfield window |
| CONCATENATION_DESCRIPTION_LEN | The number of characters in the segment value description |
| DESCRIPTIVE_FLEXFIELD_NAME | Descriptive flexfield name |
| DESCRIPTIVE_FLEX_CONTEXT_CODE | Descriptive flexfield structure name |
| FLEX_VALUE_SET_ID | Flexfield value set identifier |
| RANGE_CODE | Code to indicate if this segment is a High or Low segment |
| DEFAULT_TYPE | The type of the default value |
| DEFAULT_VALUE | The default value for the segment |
| APPLICATION_COLUMN_NAME | Column name |
| SRW_PARAM | The name of the Oracle Reports report parameter |
| RUNTIME_PROPERTY_FUNCTION | RUNTIME_PROPERTY_FUNCTION |
| END_USER_COLUMN_NAME | The segment name |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| Application Object Library - FND_DESCR_FLEX_CONTEXTS | Structure names for descriptive flexfields |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| ENABLED_FLAG | Enabled flag |
| GLOBAL_FLAG | Flag to indicate whether the context field value identifies a global segment structure |
| DESCRIPTIVE_FLEXFIELD_NAME | Descriptive flexfield name |
| DESCRIPTIVE_FLEX_CONTEXT_CODE | The context field value |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_CURRENCIES | Currencies enabled for use at your site |
|---|---|
| Column Name | Descritpion |
| CURRENCY_CODE | Currency code |
| DESCRIPTION | Description |
| ISSUING_TERRITORY_CODE | The territory code of the country issuing the currency |
| PRECISION | Maximum number of digits to the right of decimal point |
| EXTENDED_PRECISION | Extended precision |
| SYMBOL | The symbol denoting the currency |
| START_DATE_ACTIVE | The date when the currency code becomes active |
| END_DATE_ACTIVE | The date the currency code expires |
| MINIMUM_ACCOUNTABLE_UNIT | Minimum accountable unit for the currency |
| CONTEXT | Attribute category for the currency |
| LAST_UPDATE_DATE | Standard Who column |
| ISO_FLAG | Flag to indicate whether or not the currency is defined in ISO-4217 |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| LAST_UPDATED_BY | Standard Who column |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| GLOBAL_ATTRIBUTE_CATEGORY | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE1 | Reserved for country-specific functionality |
| CREATION_DATE | Standard Who column |
| GLOBAL_ATTRIBUTE2 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE3 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE4 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE5 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE6 | Reserved for country-specific functionality |
| CREATED_BY | Standard Who column |
| GLOBAL_ATTRIBUTE7 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE8 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE9 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE10 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE11 | Reserved for country-specific functionality |
| LAST_UPDATE_LOGIN | Standard Who column |
| GLOBAL_ATTRIBUTE12 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE13 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE14 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE15 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE16 | Reserved for country-specific functionality |
| ENABLED_FLAG | Enabled Flag "Y","N","X" (X=never enabled) |
| GLOBAL_ATTRIBUTE17 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE18 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE19 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE20 | Reserved for country-specific functionality |
| DERIVE_EFFECTIVE | The date from which this currency's value becomes derived from the related currency. If this value is null or later than the computation date, then the other derive_ columns are undefined. |
| CURRENCY_FLAG | Flag to indicate if the currency is a statistical unit or a currency |
| DERIVE_TYPE | Indicates whether the currency has a special relationship with other currencies. Currently, only EURO (Euro currency), EMU (European Monetary Union currency), and NULL (no special relationship) are possible values. |
| DERIVE_FACTOR | Multiple applied to the base currency to derive this currency. Only used for the derived currency in a relationship. |
| Application Object Library - FND_ENABLED_ACTIVATION | Pseudo table needed by flexfields |
|---|---|
| Column Name | Descritpion |
| ENABLED_FLAG | |
| END_DATE_ACTIVE | |
| START_DATE_ACTIVE | |
| ACTIVATION |
| Application Object Library - FND_CONCURRENT_COMPLEX_LINES | Concurrent manager complex rule lines |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| TYPE_CODE | Item type |
| TYPE_APPLICATION_ID | Identifier of application with which the item is defined |
| TYPE_ID | Type identifier |
| COMPLEX_RULE_ID | Combined specialization rule identifier |
| COMPLEX_RULE_LINE_ID | Combined specialization rule line identifier |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| INCLUDE_FLAG | Flag to indicate whether to include or exclude this line in complex rule |
| Application Object Library - FND_CONCURRENT_COMPLEX_RULES | Complex rules for specializing concurrent managers |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| COMPLEX_RULE_ID | Combined specialization rule identifier |
| COMPLEX_RULE_NAME | Combined specialization rule name |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Description |
| Application Object Library - FND_CONC_REQUEST_ARGUMENTS | Arguments 26 through 100 for concurrent requests |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Request identifier |
| ARGUMENT34 | Concurrent Request Argument |
| ARGUMENT35 | Concurrent Request Argument |
| ARGUMENT36 | Concurrent Request Argument |
| ARGUMENT37 | Concurrent Request Argument |
| ARGUMENT38 | Concurrent Request Argument |
| ARGUMENT39 | Concurrent Request Argument |
| ARGUMENT40 | Concurrent Request Argument |
| ARGUMENT41 | Concurrent Request Argument |
| ARGUMENT42 | Concurrent Request Argument |
| ARGUMENT43 | Concurrent Request Argument |
| ARGUMENT26 | Concurrent Request Argument |
| ARGUMENT44 | Concurrent Request Argument |
| ARGUMENT45 | Concurrent Request Argument |
| ARGUMENT46 | Concurrent Request Argument |
| ARGUMENT47 | Concurrent Request Argument |
| ARGUMENT48 | Concurrent Request Argument |
| ARGUMENT49 | Concurrent Request Argument |
| ARGUMENT50 | Concurrent Request Argument |
| ARGUMENT51 | Concurrent Request Argument |
| ARGUMENT52 | Concurrent Request Argument |
| ARGUMENT53 | Concurrent Request Argument |
| ARGUMENT27 | Concurrent Request Argument |
| ARGUMENT54 | Concurrent Request Argument |
| ARGUMENT55 | Concurrent Request Argument |
| ARGUMENT56 | Concurrent Request Argument |
| ARGUMENT57 | Concurrent Request Argument |
| ARGUMENT58 | Concurrent Request Argument |
| ARGUMENT59 | Concurrent Request Argument |
| ARGUMENT60 | Concurrent Request Argument |
| ARGUMENT61 | Concurrent Request Argument |
| ARGUMENT62 | Concurrent Request Argument |
| ARGUMENT63 | Concurrent Request Argument |
| ARGUMENT28 | Concurrent Request Argument |
| ARGUMENT64 | Concurrent Request Argument |
| ARGUMENT65 | Concurrent Request Argument |
| ARGUMENT66 | Concurrent Request Argument |
| ARGUMENT67 | Concurrent Request Argument |
| ARGUMENT68 | Concurrent Request Argument |
| ARGUMENT69 | Concurrent Request Argument |
| ARGUMENT70 | Concurrent Request Argument |
| ARGUMENT71 | Concurrent Request Argument |
| ARGUMENT72 | Concurrent Request Argument |
| ARGUMENT73 | Concurrent Request Argument |
| ARGUMENT29 | Concurrent Request Argument |
| ARGUMENT74 | Concurrent Request Argument |
| ARGUMENT75 | Concurrent Request Argument |
| ARGUMENT76 | Concurrent Request Argument |
| ARGUMENT77 | Concurrent Request Argument |
| ARGUMENT78 | Concurrent Request Argument |
| ARGUMENT79 | Concurrent Request Argument |
| ARGUMENT80 | Concurrent Request Argument |
| ARGUMENT81 | Concurrent Request Argument |
| ARGUMENT82 | Concurrent Request Argument |
| ARGUMENT83 | Concurrent Request Argument |
| ARGUMENT30 | Concurrent Request Argument |
| ARGUMENT84 | Concurrent Request Argument |
| ARGUMENT85 | Concurrent Request Argument |
| ARGUMENT86 | Concurrent Request Argument |
| ARGUMENT87 | Concurrent Request Argument |
| ARGUMENT88 | Concurrent Request Argument |
| ARGUMENT89 | Concurrent Request Argument |
| ARGUMENT90 | Concurrent Request Argument |
| ARGUMENT91 | Concurrent Request Argument |
| ARGUMENT92 | Concurrent Request Argument |
| ARGUMENT93 | Concurrent Request Argument |
| ARGUMENT31 | Concurrent Request Argument |
| ARGUMENT94 | Concurrent Request Argument |
| ARGUMENT95 | Concurrent Request Argument |
| ARGUMENT96 | Concurrent Request Argument |
| ARGUMENT97 | Concurrent Request Argument |
| ARGUMENT98 | Concurrent Request Argument |
| ARGUMENT99 | Concurrent Request Argument |
| ARGUMENT100 | Concurrent Request Argument |
| ARGUMENT32 | Concurrent Request Argument |
| ARGUMENT33 | Concurrent Request Argument |
| Application Object Library - FND_DATA_GROUPS | Data groups registered with Oracle Application Object Library |
|---|---|
| Column Name | Descritpion |
| DATA_GROUP_ID | Data group identifier |
| DATA_GROUP_NAME | Data group name |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DEFAULT_GROUP_FLAG | Flag to indicate whether this is an Oracle Application defined data group |
| DESCRIPTION | Description |
| Application Object Library - FND_DATA_GROUP_UNITS | ORACLE accounts for applications assigned to various data groups |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| ORACLE_ID | Oracle User identifier |
| DESCRIPTION | Description |
| DATA_GROUP_ID | Data group identifier |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_EXECUTABLES | Concurrent program executables |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| EXECUTION_METHOD_CODE | Type of execution |
| EXECUTION_FILE_NAME | Developer name for the execution file |
| EXECUTABLE_ID | Executable identifier |
| SUBROUTINE_NAME | Subroutine name for the execution |
| EXECUTABLE_NAME | Developer name for the executable |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| ICON_NAME | Reserved for future use |
| EXECUTION_FILE_PATH | package path will be stored for java concurrent programs. |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_COMPILED_ID_FLEX_STRUCTS | Compiled information about key flexfield structures |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| LANGUAGE | Language |
| ID_FLEX_CODE | Key flexfield code |
| ID_FLEX_NUM | Key flexfield structure number |
| COMPILER_VERSION_NUM | compiler version number |
| SEQUENCE | Sequence of compiled key flexfield structure definition |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| COMPILED_DEFINITION | Compiled definition |
| Application Object Library - FND_DOCUMENT_SEQUENCES | Document sequences registered with Oracle Application Object Library |
|---|---|
| Column Name | Descritpion |
| DOC_SEQUENCE_ID | Document sequence identifier |
| MESSAGE_FLAG | Flag indicating whether to display a message on the status line with the document sequence name and value |
| START_DATE | The date when the document sequence becomes active |
| TYPE | Document sequence type (either Automatic or Manaul) |
| NAME | Name of document sequence |
| DB_SEQUENCE_NAME | The name of the document sequence in the database |
| END_DATE | The date when the document sequence becomes inactive |
| INITIAL_VALUE | Initial value of the document sequence |
| TABLE_NAME | Table name |
| LAST_UPDATE_DATE | Standard Who column |
| ATTRIBUTE_CATEGORY | Attribute category |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| LAST_UPDATED_BY | Standard Who column |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| CREATION_DATE | Standard Who column |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| APPLICATION_ID | Application identifier |
| AUDIT_TABLE_NAME | Name of the audit table |
| Application Object Library - FND_DOC_SEQUENCE_ACCESS | Information about who can access a document sequence |
|---|---|
| Column Name | Descritpion |
| DOC_SEQUENCE_ID | Document sequence identifier |
| ORACLE_ID | Oracle username identifier |
| SYNONYM_CREATED_FLAG | Flag to indicate whether the necessary synonyms are created |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_DOC_SEQUENCE_ASSIGNMENTS | Assigns a sequence to a document |
|---|---|
| Column Name | Descritpion |
| DOC_SEQUENCE_ASSIGNMENT_ID | Document sequence assignment identifier |
| CATEGORY_CODE | Category code |
| START_DATE | The date when the assignment becomes active |
| END_DATE | The date when the assignment becomes inactive |
| SET_OF_BOOKS_ID | Set of books identifier |
| METHOD_CODE | Flag to indicate whether the sequence number should be automatically or manually entered |
| ATTRIBUTE_CATEGORY_DEVELOPER | Attribute category |
| LAST_UPDATE_DATE | Standard Who column |
| ATTRIBUTE_CATEGORY | Attribute category |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| LAST_UPDATED_BY | Standard Who column |
| ATTRIBUTE10 | Descriptive flexfield segment |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| APPLICATION_ID | Application identifier |
| DOC_SEQUENCE_ID | Document sequence identifier |
| Application Object Library - FND_DOC_SEQUENCE_CATEGORIES | Document category definitions |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| TABLE_NAME | Table name |
| DESCRIPTION | Description |
| CODE | Category code |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| NAME | Category name |
| Application Object Library - FND_DOC_SEQUENCE_AUDIT | Keeps track of documents |
|---|---|
| Column Name | Descritpion |
| DOC_SEQUENCE_ID | Document sequence identifier |
| DOC_SEQUENCE_VALUE | Document sequence value |
| DOC_SEQUENCE_ASSIGNMENT_ID | Document sequence assignment identifier |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| Application Object Library - FND_DUAL | Dummy base table used by a form block that does not have a real base table (for commit purposes) |
|---|---|
| Column Name | Descritpion |
| DUMMY | Dummy column |
| Application Object Library - FND_FLEXBUILDER_ASSIGNMENTS | Flexbuilder assignments |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| ASSIGNMENT_TYPE | Type of assignment |
| PROTECTED_FLAG | Flag to indicate whether this is a protected assignment |
| DESCRIPTION | Description |
| FUNCTION_CODE | Flexbuilder function code |
| CONDITIONAL_PARAMETER | Flexbuilder parameter name for conditional assignment |
| CONDITIONAL_VALUE | Value of conditional parameter |
| ID_PARAMETER | "Flexfield" type flexbuilder parameter |
| FLEXFIELD_SEGMENT_USAGES | Segment usage information for the "Flexfield" type assignments |
| SEGMENT_ATTRIBUTE_TYPE | Flexfield qualifier |
| SEGMENT_PARAMETER_PAIRINGS | Pairings of flexfield segments and flexbuilder parameters |
| SEGMENT_PARAMETER | Flexbuilder parameter to obtain segment value for segments identified by the flexfield qualifier |
| SEGMENT_CONSTANTS | Constant values for flexfield segments |
| ID_FLEX_NUM | Key flexfield structure number |
| SEQUENCE | Sequence number for the assignment |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_DEFAULT_FOLDERS | Default folder definitions |
|---|---|
| Column Name | Descritpion |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| APPLICATION_ID | Application identifier |
| OBJECT | Folder object |
| USER_ID | User identifier (positive value) or responsibility identifier (negative value) |
| BEHAVIOR_MODE | |
| FOLDER_ID | Folder identifier |
| CREATION_DATE | Standard Who column |
| Application Object Library - FND_AUDIT_COLUMNS | Table columns being audited |
|---|---|
| Column Name | Descritpion |
| TABLE_APP_ID | Application identifier with which the table is registered |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| STATE | Flag to indicate if there is a pending request on this table column |
| SEQUENCE_ID | Sequence identifier |
| TABLE_ID | Table identifier |
| COLUMN_ID | Column identifier |
| SCHEMA_ID | Schema identifier |
| Application Object Library - FND_AUDIT_TABLES | Application tables being audited |
|---|---|
| Column Name | Descritpion |
| AUDIT_GROUP_ID | Audit group identifier |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| AUDIT_GROUP_APP_ID | Audit group application identifier |
| STATE | Flag to indicate the state of database trigger or the states of requests |
| TABLE_APP_ID | Table application identifier |
| TABLE_ID | Table identifier |
| Application Object Library - FND_AUDIT_GROUPS | Application tables and columns being audited as groups |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| GROUP_NAME | Audit group name |
| STATE | Flag to indicate if the Audit Group is enabled or in one of the disabled states |
| DESCRIPTION | Description |
| AUDIT_GROUP_ID | Audit group identifier |
| Application Object Library - FND_AUDIT_SCHEMAS | Audit schema |
|---|---|
| Column Name | Descritpion |
| SCHEMA_ID | Schema identifier |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ORACLE_ID | Oracle username |
| APPLICATION_ID | Application identifier |
| STATE | Flag to indicate if the schema is enabled |
| Application Object Library - FND_DESCRIPTIVE_FLEXS_TL | Translations for FND_DESCRIPTIVE_FLEXS |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| APPLICATION_ID | Application identifier |
| FORM_CONTEXT_PROMPT | Reference field prompt |
| SOURCE_LANG | 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. |
| DESCRIPTION | Description |
| DESCRIPTIVE_FLEXFIELD_NAME | Descriptive flexfield name |
| LANGUAGE | Language |
| TITLE | Descriptive flexfield title |
| Application Object Library - FND_DESCR_FLEX_CONTEXTS_TL | Translations for FND_DESCR_FLEX_CONTEXTS |
|---|---|
| Column Name | Descritpion |
| LANGUAGE | Language |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| APPLICATION_ID | Application identifier |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Description |
| DESCRIPTIVE_FLEX_CONTEXT_NAME | Translatable name for the context |
| SOURCE_LANG | 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. |
| DESCRIPTIVE_FLEXFIELD_NAME | Descriptive flexfield name |
| DESCRIPTIVE_FLEX_CONTEXT_CODE | The context field value |
| Application Object Library - FND_DESCR_FLEX_COL_USAGE_TL | Translations for FND_DESCR_FLEX_COLUMN_USAGES |
|---|---|
| Column Name | Descritpion |
| LANGUAGE | Language |
| LAST_UPDATE_DATE | Standard Who column |
| APPLICATION_ID | Application identifier |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| FORM_LEFT_PROMPT | The left prompt for the segment in the flexfield window |
| FORM_ABOVE_PROMPT | The above prompt for the segment in the flexfield window |
| DESCRIPTION | Description |
| SOURCE_LANG | 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. |
| DESCRIPTIVE_FLEXFIELD_NAME | Descriptive flexfield name |
| DESCRIPTIVE_FLEX_CONTEXT_CODE | Descriptive flexfield structure name |
| APPLICATION_COLUMN_NAME | Column name |
| Application Object Library - FND_CURRENCIES_TL | Translations for FND_CURRENCIES |
|---|---|
| Column Name | Descritpion |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CURRENCY_CODE | Currency code |
| DESCRIPTION | Description |
| SOURCE_LANG | 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. |
| LANGUAGE | Language |
| NAME | Currency name |
| Application Object Library - FND_APPLICATION_TL | Translations for FND_APPLICATION |
|---|---|
| Column Name | Descritpion |
| LANGUAGE | Language |
| APPLICATION_NAME | Name of application |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Description |
| APPLICATION_ID | Application identifier |
| SOURCE_LANG | 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. |
| Application Object Library - FND_CONCURRENT_PROGRAMS_TL | Translations for FND_CONCURRENT_PROGRAMS |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| APPLICATION_ID | Application identifier |
| DESCRIPTION | Description |
| SOURCE_LANG | 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. |
| CONCURRENT_PROGRAM_ID | Concurrent program identifier |
| LANGUAGE | Language |
| USER_CONCURRENT_PROGRAM_NAME | Concurrent program title |
| Application Object Library - FND_CONCURRENT_QUEUES_TL | Translations for FND_CONCURRENT_QUEUES |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| APPLICATION_ID | Application identifier |
| DESCRIPTION | Description |
| SOURCE_LANG | 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. |
| USER_CONCURRENT_QUEUE_NAME | User name for the concurrent queue |
| CONCURRENT_QUEUE_ID | Concurrent manager identifier |
| LANGUAGE | Language |
| CONCURRENT_QUEUE_NAME | Concurrent manager name |
| Application Object Library - FND_DOC_SEQUENCE_USERS | User assigned document sequences |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DOC_SEQUENCE_ID | Document sequence identifier |
| GL_DATE | General ledger date |
| DOC_SEQUENCE_ASSIGNMENT_ID | Document sequence assignment identifier |
| USER_ID | ORACLE username |
| NEXTVAL | Next valid value |
| Application Object Library - FND_CONCURRENT_DEBUG_INFO | Stores debug information when certain debug mechanisms are activated at the request of an Oracle developer |
|---|---|
| Column Name | Descritpion |
| USER_ID | Applications user identifier |
| LOGIN_ID | Applications login identifier |
| FUNCTION | Calling function |
| TIME | Time of message |
| ACTION | What is happening |
| MESSAGE | Additional information |
| SECURITY_GROUP_ID | Security Group Id |
| RESP_APPL_ID | Resposibility application Id |
| SESSION_ID | Database session identifier |
| RESPONSIBILITY_ID | Responsibility Id |
| TRANSACTION_ID | Transaction Id |
| PROGRAM_APPLICATION_ID | Program Application Id |
| CONCURRENT_PROGRAM_ID | Concurrent Program Id |
| CONCURRENT_QUEUE_ID | Concurrent Queue Id |
| TIME_IN_NUMBER | time in 100th seconds |
| SOURCE_TYPE | source of this debug info lookup_type CONC_DEBUG_SOURCE_TYPE |
| Application Object Library - FND_DOCUMENTS | Documents |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| PROGRAM_UPDATE_DATE | Last update date of this record |
| APP_SOURCE_VERSION | Column to ensure R10 to 10sc compatability |
| DM_NODE | DM_NODE |
| DM_FOLDER_PATH | DM_FOLDER_PATH |
| DM_TYPE | DM_TYPE |
| DM_DOCUMENT_ID | For Document managment doc Id |
| DM_VERSION_NUMBER | DM_VERSION_NUMBER |
| URL | url for web page |
| MEDIA_ID | Identifier of the sub-table in which the document is stored |
| FILE_NAME | filename for document |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DATATYPE_ID | Datatype identifier |
| CATEGORY_ID | Unique identifier sourced from the FND_DOCUMENT_CATEGORIES_S sequence |
| SECURITY_TYPE | Method of security used for the document |
| DOCUMENT_ID | Document identifier |
| SECURITY_ID | ID associated with the security type (if security_type <>4) |
| PUBLISH_FLAG | A flag that determines if a document is shared outside it's security type |
| IMAGE_TYPE | Image format |
| STORAGE_TYPE | Indicates whether the document is stored in the database or in the file system |
| USAGE_TYPE | Indicator of how the document can be used |
| START_DATE_ACTIVE | Date on which the document is available for use |
| END_DATE_ACTIVE | Date on which the document is no longer available for use |
| REQUEST_ID | Request identifier |
| PROGRAM_APPLICATION_ID | Program application identifier |
| PROGRAM_ID | Program identifier |
| Application Object Library - FND_DOCUMENTS_LONG_TEXT | Long text documents |
|---|---|
| Column Name | Descritpion |
| MEDIA_ID | Media identifier |
| LONG_TEXT | Long text |
| APP_SOURCE_VERSION | Column to ensure R10 to 10sc compatability |
| Application Object Library - FND_DOCUMENTS_TL | Translations for FND_DOCUMENTS |
|---|---|
| Column Name | Descritpion |
| DOCUMENT_ID | Document identifier |
| FILE_NAME | File name of the document |
| MEDIA_ID | Identifier of the sub-table in which the document is stored |
| REQUEST_ID | Request identifier |
| PROGRAM_APPLICATION_ID | Program application identifier |
| PROGRAM_ID | Program identifier |
| PROGRAM_UPDATE_DATE | Last update date of this record |
| DOC_ATTRIBUTE_CATEGORY | Attribute category |
| DOC_ATTRIBUTE1 | Descriptive flexfield segment |
| DOC_ATTRIBUTE2 | Descriptive flexfield segment |
| DOC_ATTRIBUTE3 | Descriptive flexfield segment |
| CREATION_DATE | Standard Who column |
| DOC_ATTRIBUTE4 | Descriptive flexfield segment |
| DOC_ATTRIBUTE5 | Descriptive flexfield segment |
| DOC_ATTRIBUTE6 | Descriptive flexfield segment |
| DOC_ATTRIBUTE7 | Descriptive flexfield segment |
| DOC_ATTRIBUTE8 | Descriptive flexfield segment |
| DOC_ATTRIBUTE9 | Descriptive flexfield segment |
| DOC_ATTRIBUTE10 | Descriptive flexfield segment |
| DOC_ATTRIBUTE11 | Descriptive flexfield segment |
| DOC_ATTRIBUTE12 | Descriptive flexfield segment |
| DOC_ATTRIBUTE13 | Descriptive flexfield segment |
| CREATED_BY | Standard Who column |
| DOC_ATTRIBUTE14 | Descriptive flexfield segment |
| DOC_ATTRIBUTE15 | Descriptive flexfield segment |
| APP_SOURCE_VERSION | Column to ensure R10 to 10sc compatability |
| SOURCE_LANG | 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. |
| TITLE | title of document |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| LANGUAGE | Language of the current record |
| DESCRIPTION | Document description |
| SHORT_TEXT | Obsolete column |
| Application Object Library - FND_DOCUMENTS_LONG_RAW | Long raw documents |
|---|---|
| Column Name | Descritpion |
| MEDIA_ID | Media identifier |
| LONG_RAW | Image or OLE object |
| Application Object Library - FND_ATTACHED_DOCUMENTS | Attached documents |
|---|---|
| Column Name | Descritpion |
| ATTACHED_DOCUMENT_ID | Attached document identifier |
| PK1_VALUE | Part of the related entity's foreign key |
| PK2_VALUE | Part of the related entity's foreign key |
| PK3_VALUE | Part of the related entity's foreign key |
| PK4_VALUE | Part of the related entity's foreign key |
| PK5_VALUE | Part of the related entity's foreign key |
| AUTOMATICALLY_ADDED_FLAG | Flag indicating an attachment was created automatically |
| PROGRAM_APPLICATION_ID | Standard extended Who column |
| PROGRAM_ID | Standard extended Who column |
| PROGRAM_UPDATE_DATE | Standard extended Who column |
| REQUEST_ID | Standard extended Who column |
| DOCUMENT_ID | Document identifier of the long document being replicated |
| ATTRIBUTE_CATEGORY | Descriptive Flexfield segment |
| ATTRIBUTE1 | Descriptive Flexfield segment |
| ATTRIBUTE2 | Descriptive Flexfield segment |
| ATTRIBUTE3 | Descriptive Flexfield segment |
| ATTRIBUTE4 | Descriptive Flexfield segment |
| ATTRIBUTE5 | Descriptive Flexfield segment |
| ATTRIBUTE6 | Descriptive Flexfield segment |
| ATTRIBUTE7 | Descriptive Flexfield segment |
| ATTRIBUTE8 | Descriptive Flexfield segment |
| ATTRIBUTE9 | Descriptive Flexfield segment |
| CREATION_DATE | Standard Who column |
| ATTRIBUTE10 | Descriptive Flexfield segment |
| ATTRIBUTE11 | Descriptive Flexfield segment |
| ATTRIBUTE12 | Descriptive Flexfield segment |
| ATTRIBUTE13 | Descriptive Flexfield segment |
| ATTRIBUTE14 | Descriptive Flexfield segment |
| ATTRIBUTE15 | Descriptive Flexfield segment |
| COLUMN1 | Column to ensure R10 to R10sc compatibility |
| APP_SOURCE_VERSION | Column to ensure R10 to 10sc compatability |
| CREATED_BY | Standard Who column |
| CATEGORY_ID | CATEGORY_ID |
| STATUS | STATUS |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| SEQ_NUM | User-entered sequence number for displaying attachments in order |
| ENTITY_NAME | Foreign key to FND_DOCUMENT_ENTITIES indicating which application entity the document is related to |
| Application Object Library - FND_DOCUMENT_CATEGORIES | Document categories |
|---|---|
| Column Name | Descritpion |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| NAME | Developer name for the category |
| CATEGORY_ID | Unique identifier sourced from the FND_DOCUMENTS_CATEGORIES_S sequence |
| START_DATE_ACTIVE | Date on which the current category is available for use (a null value indicates the category is available immediately) |
| END_DATE_ACTIVE | Date on which the current category is no longer available for use (a null value indicates the category is available indefinitely) |
| ATTRIBUTE_CATEGORY | Attribute category |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| APPLICATION_ID | ID of the application that 'owns' the category |
| DEFAULT_DATATYPE_ID | Default datatype identifier |
| CREATION_DATE | Standard Who column |
| Application Object Library - FND_DOCUMENT_ENTITIES | Document entities |
|---|---|
| Column Name | Descritpion |
| TABLE_NAME | Database table name |
| ENTITY_NAME | Name of the entity stored in the database table |
| CREATION_DATE | Standard Who column |
| DOCUMENT_ENTITY_ID | Document entity identifier |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| PK1_COLUMN | Part of the entity's primary key |
| PK2_COLUMN | Part of the entity's primary key |
| PK3_COLUMN | Part of the entity's primary key |
| PK4_COLUMN | Part of the entity's primary key |
| PK5_COLUMN | Part of the entity's primary key |
| DATA_OBJECT_CODE | Developer key for the table |
| APPLICATION_ID | Application ID of the entity's "owner" |
| Application Object Library - FND_DOCUMENT_DATATYPES | Document datatypes |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DATATYPE_ID | Datatype identifier |
| START_DATE_ACTIVE | Date on which the current category is available for use; a null value indicates the category is available immediately (DATATYPE_IDs 1-4 must always be available) |
| END_DATE_ACTIVE | Date on which the current category is no longer available for use; a null value indicates the category is available indefinitely (DATATYPE_IDs 1-4 must always be available) |
| SOURCE_LANG | 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. |
| LANGUAGE | Language of the current record |
| NAME | Developer name for the datatype |
| USER_NAME | Username for the datatype (language specific) |
| Application Object Library - FND_DOC_CATEGORY_USAGES | Relationships between document categories and form or form functions |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DOC_CATEGORY_USAGE_ID | Unique identifier |
| FORMAT | FORMAT |
| CATEGORY_ID | Unique identifier sourced from the FND_DOCUMENTS_CATEGORIES_S sequence |
| ATTACHMENT_FUNCTION_ID | Attachment function identifier |
| ENABLED_FLAG | Flag indicating whether attachment functionality is enabled for the form or form function |
| Application Object Library - FND_ATTACHMENT_FUNCTIONS | Forms and form functions with attachments |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTACHMENT_FUNCTION_ID | Attachment function identifier |
| APPLICATION_ID | Application identifier |
| SESSION_CONTEXT_FIELD | Form field that holds the data that should be used as session context in the attachment form title |
| ENABLED_FLAG | Flag indicating whether or not attachment functionality is enabled for the form or form function |
| FUNCTION_TYPE | Function type |
| FUNCTION_ID | Foreign key to either FND_FORM_FUNCTIONS of FND_FORM, depending on the value of FUNCTION_TYPE |
| FUNCTION_NAME | Developer name for the function |
| Application Object Library - FND_ATTACHMENT_BLOCKS | Blocks with attachments |
|---|---|
| Column Name | Descritpion |
| ATTACHMENT_BLK_ID | Attachment region identifier |
| ATTACHMENT_FUNCTION_ID | Attachment function identifier |
| BLOCK_NAME | Name of the window region |
| QUERY_FLAG | Flag regarding attachments invoked from the region (see table description) |
| SECURITY_TYPE | Method of security used for the document |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ORG_CONTEXT_FIELD | Form field which holds the ORGANIZATION_ID when running in the context of organization security |
| SET_OF_BOOKS_CONTEXT_FIELD | Form field which holds the SET_OF_BOOKS_ID when running in the context of set of books security |
| BUSINESS_UNIT_CONTEXT_FIELD | Form field which holds the BUSINESS_UNIT_ID when running in the context of business unit security |
| CONTEXT1_FIELD | Form field which holds the data that should be used for the first context portion of the attachment form title |
| CONTEXT2_FIELD | Form field which holds the data that should be used for the second context portion of the attachment form title |
| CONTEXT3_FIELD | Form field which holds the data that should be used for the third context portion of the attachment form title |
| Application Object Library - FND_ATTACHMENT_BLK_ENTITIES | Document and attachment information |
|---|---|
| Column Name | Descritpion |
| ATTACHMENT_BLK_ID | Attachment region identifier |
| DISPLAY_METHOD | Indicator of how to display attachments to this entity |
| INCLUDE_IN_INDICATOR_FLAG | Indicator of whether or not the attachment toolbar is set |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| PK1_FIELD | Part of the entity's primary key |
| PK2_FIELD | Part of the entity's primary key |
| PK3_FIELD | Part of the entity's primary key |
| PK4_FIELD | Part of the entity's primary key |
| PK5_FIELD | Part of the entity's primary key |
| SQL_STATEMENT | SQL statement fragment that should be added when querying attachments to this entity |
| DATA_OBJECT_CODE | Developer key for FND_DOCUMENT_ENTITIES |
| INDICATOR_IN_VIEW_FLAG | Indicator of whether or not the view on which the window region is based includes either a column or special code to determine whether or not attachments exist for the entity |
| QUERY_PERMISSION_TYPE | Indicates if attachment to this entity can be queried from the window region |
| INSERT_PERMISSION_TYPE | Indicates if attachment to this entity can be inserted: only one entity in a region can allow inserts |
| UPDATE_PERMISSION_TYPE | Indicates if attachment to this entity can be updated |
| DELETE_PERMISSION_TYPE | Indicates if attachment to this entity can be deleted |
| CONDITION_FIELD | Field whose value should be evaluated using the condition operator and condition value(s) |
| CONDITION_OPERATOR | Condition that should be used for evaluation (=,<>,>=,<=,<,>,NOT NULL, NULL, BETWEEN, OUTSIDE) |
| CONDITION_VALUE1 | Value that contents of CONDITION_FIELD should be evaluated against using condition operator |
| CONDITION_VALUE2 | Secondary value that contents of CONDITION_FIELD should be evaluated against when CONDITION_OPERATOR is BETWEEN or OUTSIDE |
| ATTACHMENT_BLK_ENTITY_ID | Attachment region entity identifier |
| Application Object Library - FND_DOCUMENTS_SHORT_TEXT | Short text documents |
|---|---|
| Column Name | Descritpion |
| MEDIA_ID | Media identifier |
| SHORT_TEXT | Short text |
| APP_SOURCE_VERSION | Column to ensure R10 to 10sc compatability |
| Application Object Library - FND_DOCUMENT_CATEGORIES_TL | Translation table for FND_DOCUMENT_CATEGORIES |
|---|---|
| Column Name | Descritpion |
| CATEGORY_ID | Unique identifier sourced from the FND_DOCUMENTS_CATEGORIES_S sequence |
| APP_SOURCE_VERSION | Column to ensure R10 to 10sc compatability |
| SOURCE_LANG | 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. |
| LANGUAGE | Language of the current record |
| NAME | Developer name for the category |
| USER_NAME | Username for the category (language-dependent) |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_DOCUMENT_ENTITIES_TL | Translation table for FND_DOCUMENT_ENTITIES |
|---|---|
| Column Name | Descritpion |
| DOCUMENT_ENTITY_ID | Document entity identifier |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| SOURCE_LANG | 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. |
| DATA_OBJECT_CODE | Developer key for the table |
| LANGUAGE | Language of the current record |
| USER_ENTITY_NAME | Username from the entity |
| USER_ENTITY_PROMPT | Username for an instance of the entity |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| Application Object Library - FND_DBA_LOCKS_TEMP | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| SESSION_ID | - Retrofitted |
| LOCK_TYPE | - Retrofitted |
| MODE_HELD | - Retrofitted |
| MODE_REQUESTED | - Retrofitted |
| LOCK_ID1 | - Retrofitted |
| LOCK_ID2 | - Retrofitted |
| Application Object Library - FND_DESKTOP_OBJECTS | Stores Icons for Navigator objects |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| OBJECT_NAME | Developer name of the object |
| ICON_NAME | Name of Icon associated with object |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| Application Object Library - FND_EXECUTABLES_TL | Translations for FND_EXECUTABLES |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| APPLICATION_ID | Application identifier |
| USER_EXECUTABLE_NAME | User name for the executable |
| DESCRIPTION | Description |
| EXECUTABLE_ID | Executable identifier |
| LANGUAGE | Language |
| SOURCE_LANG | 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. |
| Application Object Library - FND_CONC_RELEASE_PERIODS | Concurrent Periods used in Advanced Schedules |
|---|---|
| Column Name | Descritpion |
| ENABLED_FLAG | Enabled flag |
| PERIODICITY_CODE | D = day, M = month, R = reverse month |
| PERIOD_LENGTH | Number of days or months |
| PERIOD_START_TIME | Time when period becomes active |
| APPLICATION_ID | Application identifier |
| PERIOD_STOP_TIME | Stop time for period |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| UPDATED_FLAG | Warns the scheduler that this is new information |
| START_DATE_ACTIVE | Date before which the period is not enabled |
| END_DATE_ACTIVE | Date after which the period is not enabled |
| OWNER_SCH_ID | Automatically generates scheduling |
| CONCURRENT_PERIOD_ID | Period identifier |
| OWNER_SCH_APP_ID | Applications identifier for the owner schedule |
| CONCURRENT_PERIOD_NAME | Developer name for the Period |
| OWNER_REQ_ID | Used for temporary schedules: owning request's ID |
| Application Object Library - FND_CONC_RELEASE_CLASSES | Concurrent Schedules |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| CREATED_BY | Standard Who column |
| UPDATED_FLAG | Warns the scheduler that this is new information |
| DATE1 | Date used with some schedule types |
| DATE2 | Date used with some schedule types |
| START_DATE_ACTIVE | Date before which the the release class is not enabled |
| END_DATE_ACTIVE | Date after which the the release class is not enabled |
| CLASS_TYPE | Denotes type of schedule |
| RELEASE_CLASS_ID | Schedule identifier |
| CLASS_INFO | Compiled scheduling information |
| OWNER_SCH_ID | Automatically generates scheduling |
| OWNER_SCH_APP_ID | Applications identifier for the owner schedule |
| RELEASE_CLASS_NAME | Developer name for the release class |
| OWNER_REQ_ID | Used for temporary schedules: owning request's ID |
| RESUBMIT_INTERVAL | For internal use |
| RESUBMIT_INTERVAL_UNIT_CODE | For internal use |
| ENABLED_FLAG | Enabled flag |
| RESUBMIT_INTERVAL_TYPE_CODE | For internal use |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| Application Object Library - FND_CONC_RELEASE_CLASSES_TL | Translations for FND_CONC_RELEASE_CLASSES |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| CREATED_BY | Standard Who column |
| DESCRIPTION | Description |
| RELEASE_CLASS_ID | Schedule identifier |
| LANGUAGE | Language |
| SOURCE_LANG | 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. |
| USER_RELEASE_CLASS_NAME | User name for the release class |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| Application Object Library - FND_CONC_RELEASE_DISJS | Disjunctions used in Advanced Schedules |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| CREATED_BY | Standard Who column |
| UPDATED_FLAG | Warns the scheduler that this is new information |
| START_DATE_ACTIVE | Date before which the the release disjunction is not enabled |
| END_DATE_ACTIVE | Date after which the the release disjunction is not enabled |
| OWNER_SCH_ID | Automatically generates scheduling |
| OWNER_SCH_APP_ID | Applications identifier for the owner schedule |
| DISJUNCTION_ID | Disjunction identifier |
| DISJUNCTION_NAME | Developer name for the disjunction |
| OWNER_REQ_ID | Used for temporary schedules: owning request's ID |
| ENABLED_FLAG | Enabled flag |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| Application Object Library - FND_CONC_RELEASE_DISJS_TL | Translations for FND_CONC_RELEASE_DISJS |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| CREATED_BY | Standard Who column |
| DESCRIPTION | Description |
| DISJUNCTION_ID | Disjunction identifier |
| LANGUAGE | Language |
| SOURCE_LANG | 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. |
| USER_DISJUNCTION_NAME | User name for the disjunction |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| Application Object Library - FND_CONC_RELEASE_PERIODS_TL | Translations for FND_CONC_RELEASE_PERIODS |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| CREATED_BY | Standard Who column |
| DESCRIPTION | Description |
| CONCURRENT_PERIOD_ID | Period identifier |
| LANGUAGE | Language |
| SOURCE_LANG | 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. |
| USER_CONCURRENT_PERIOD_NAME | Username for the Period |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| Application Object Library - FND_CONC_RELEASE_STATES | Concurrent States used in Advanced Schedules |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| UPDATED_FLAG | Warns the scheduler that this is new information |
| START_DATE_ACTIVE | Date before which the the release state is not enabled |
| END_DATE_ACTIVE | Date after which the the release state is not enabled |
| OWNER_SCH_ID | Automatically generates scheduling |
| OWNER_SCH_APP_ID | Applications identifier for the owner schedule |
| CONCURRENT_STATE_ID | Concurrent state identifier |
| CONCURRENT_STATE_NAME | Developer name for the Concurrent State |
| OWNER_REQ_ID | Used for temporary schedules: owning request's ID |
| ENABLED_FLAG | Enabled flag |
| STATUS | State value identifier |
| LOOKUP_TYPE_ID | State value set identifier |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| Application Object Library - FND_CONC_RELEASE_STATES_TL | Translations for FND_CONC_RELEASE_STATES |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| CREATED_BY | Standard Who column |
| DESCRIPTION | Description |
| CONCURRENT_STATE_ID | Concurrent state identifier |
| LANGUAGE | Language |
| SOURCE_LANG | 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. |
| USER_CONCURRENT_STATE_NAME | User name for the Concurrent State |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| Application Object Library - FND_CONC_PP_ACTIONS | Post Concurrent Request processing actions table |
|---|---|
| Column Name | Descritpion |
| CONCURRENT_REQUEST_ID | Identified associated requests |
| CREATED_BY | CREATED_BY |
| PROGRAM_APPLICATION_ID | Reserved for future use |
| PROGRAM_ID | Reserved for future use |
| ARGUMENTS | Concurrent Request Argument |
| SEQUENCE | Indicates order of post processing actions |
| COMPLETED | Indicates action has completed |
| NUMBER_OF_COPIES | Number of copies to print |
| ARGUMENT1 | Descriptive Flexfield segment |
| ARGUMENT2 | Descriptive Flexfield segment |
| ARGUMENT3 | Descriptive Flexfield segment |
| ACTION_TYPE | Type of action |
| ARGUMENT4 | Descriptive Flexfield segment |
| ARGUMENT5 | Descriptive Flexfield segment |
| ARGUMENT6 | Descriptive Flexfield segment |
| ARGUMENT7 | Descriptive Flexfield segment |
| ARGUMENT8 | Descriptive Flexfield segment |
| ARGUMENT9 | Descriptive Flexfield segment |
| ARGUMENT10 | Descriptive Flexfield segment |
| ORIG_SYSTEM | Notification user originating system |
| ORIG_SYSTEM_ID | Notification user originating system id |
| OPS_INSTANCE | OPS Instance id |
| PROCESSOR_ID | Output Processor Id processed this post processing action. |
| STATUS_S_FLAG | STATUS_S_FLAG |
| STATUS_W_FLAG | Perform action on warning |
| STATUS_F_FLAG | Indicates that action ended in failure |
| LAST_UPDATE_DATE | LAST_UPDATE_DATE |
| LAST_UPDATED_BY | LAST_UPDATED_BY |
| CREATION_DATE | CREATION_DATE |
| LAST_UPDATE_LOGIN | LAST_UPDATE_LOGIN |
| Application Object Library - FND_CONC_PP_TEMPLATES | Post-processing templates for the concurrent processor |
|---|---|
| Column Name | Descritpion |
| TEMPLATE_ID | - Retrofitted |
| TEMPLATE_NAME | - Retrofitted |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATED_BY | Standard Who column |
| NOTIFY_ON_PP_ERROR | User to notify if post processing steps fail |
| Application Object Library - FND_CONC_PP_TEMPLATES_TL | Translations for FND_CONC_PP_TEMPLATES |
|---|---|
| Column Name | Descritpion |
| TEMPLATE_ID | - Retrofitted |
| CREATED_BY | Standard Who column |
| LANGUAGE | Language |
| SOURCE_LANG | 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. |
| USER_TEMPLATE_NAME | - Retrofitted |
| DESCRIPTION | Description |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_CONC_PP_TEMPLATE_MEMBERS | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| TEMPLATE_ID | - Retrofitted |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| PROGRAM_APPLICATION_ID | Reserved for future use |
| PROGRAM_ID | Reserved for future use |
| ARGUMENTS | Concurrent Request Argument |
| SEQUENCE | Indicates order of post processing actions |
| START_DATE_ACTIVE | - Retrofitted |
| END_DATE_ACTIVE | - Retrofitted |
| ACTION_TYPE | Type of action |
| STATUS_S_FLAG | Perform action on success |
| STATUS_W_FLAG | Perform action on warning |
| STATUS_F_FLAG | Indicates that action ended in failure |
| ENABLED_FLAG | Enabled flag |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_CONC_REL_CONJ_MEMBERS | Members of Conjunctions |
|---|---|
| Column Name | Descritpion |
| CLASS_APPLICATION_ID | Application class identifier |
| CREATED_BY | Standard Who column |
| OWNER_SCH_ID | Automatically generates scheduling |
| OWNER_SCH_APP_ID | Applications identifier for the owner schedule |
| RELEASE_CLASS_ID | Schedule identifier |
| DISJUNCTION_APPLICATION_ID | Disjunction application identifier |
| DISJUNCTION_ID | Disjunction identifier |
| OWNER_REQ_ID | Used for temporary schedules: owning request's ID |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| Application Object Library - FND_CONC_REL_DISJ_MEMBERS | Members of Disjunctions |
|---|---|
| Column Name | Descritpion |
| DISJUNCTION_APPLICATION_ID | Disjunction application identifier |
| CREATED_BY | Standard Who column |
| STATE_APPLICATION_ID | Applications identifier for the request state |
| STATE_ID | Request state identifier |
| PERIOD_APPLICATION_ID | Application identifier for the concurrent release period |
| PERIOD_ID | Period identifier |
| STATUS_VALUE | Value to compare state to |
| OWNER_SCH_ID | Automatically generates scheduling |
| OWNER_SCH_APP_ID | Applications identifier for the owner schedule |
| DISJUNCTION_ID | Disjunction identifier |
| PERIOD_OR_STATE_FLAG | P = period, S = state |
| NEGATION_FLAG | Set to either Yes or No |
| OWNER_REQ_ID | Used for temporary schedules: owning request's ID |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| Application Object Library - FND_CONC_STATE_LOOKUPS | Values for Concurrent States |
|---|---|
| Column Name | Descritpion |
| LOOKUP_TYPE_ID | Value set identifier |
| START_DATE_ACTIVE | Date before which the state lookups are not enabled |
| END_DATE_ACTIVE | Date after which the state lookups are not enabled |
| OWNER_SCH_ID | Automatically generates scheduling |
| OWNER_SCH_APP_ID | Applications identifier for the owner schedule |
| LOOKUP_VALUE | Value identifier |
| ENABLED_FLAG | Enabled flag |
| OWNER_REQ_ID | Used for temporary schedules: owning request's ID |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| Application Object Library - FND_CONC_STATE_LOOKUPS_TL | Translations of FND_CONC_STATE_LOOKUPS |
|---|---|
| Column Name | Descritpion |
| LOOKUP_TYPE_ID | Value set identifier |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LOOKUP_VALUE | Value identifier |
| LANGUAGE | Language |
| SOURCE_LANG | 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. |
| MEANING | User value |
| DESCRIPTION | Description |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_CONC_STATE_LOOKUP_TYPES | Sets of Values for Concurrent States |
|---|---|
| Column Name | Descritpion |
| LOOKUP_TYPE_ID | Value set identifier |
| START_DATE_ACTIVE | Date before which the state lookups are not enabled |
| END_DATE_ACTIVE | Date after which the state lookups are not enabled |
| OWNER_SCH_ID | Automatically generates scheduling |
| OWNER_SCH_APP_ID | Applications identifier for the owner schedule |
| LOOKUP_TYPE_NAME | Developer name for the lookup type |
| ENABLED_FLAG | Enabled flag |
| OWNER_REQ_ID | Used for temporary schedules: owning request's ID |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| Application Object Library - FND_CONC_STATE_LOOKUP_TYPES_TL | Translations of FND_CONC_STATE_LOOKUPS_TYPES |
|---|---|
| Column Name | Descritpion |
| LOOKUP_TYPE_ID | Value set identifier |
| DESCRIPTION | Description |
| LANGUAGE | Language |
| SOURCE_LANG | 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. |
| USER_LOOKUP_TYPE_NAME | User name for the lookup type |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| Application Object Library - FND_CONC_REQ_STAT | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| REQ_ID | - Retrofitted |
| PROCESS_TYPE | - Retrofitted |
| STATISTIC# | - Retrofitted |
| VALUE | - Retrofitted |
| Application Object Library - FND_CONC_STAT_LIST | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| STATISTIC# | - Retrofitted |
| COLLECT_LEVEL | - Retrofitted |
| Application Object Library - FND_CONC_STAT_SUMMARY | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| STATISTIC# | - Retrofitted |
| SS | - Retrofitted |
| MAXVAL | - Retrofitted |
| MEAN | - Retrofitted |
| SIGMA | - Retrofitted |
| N | - Retrofitted |
| PROGRAM_NAME | - Retrofitted |
| PROCESS_TYPE | - Retrofitted |
| DAILY | - Retrofitted |
| COLLECT_DATE | - Retrofitted |
| MINVAL | - Retrofitted |
| Application Object Library - FND_CONFLICTS_DOMAIN | Stores Conflict Resolution Manager conflict domain information |
|---|---|
| Column Name | Descritpion |
| CD_NAME | Developer name for the conflict domain |
| USER_CD_NAME | User name for the conflict domain |
| RUNALONE_FLAG | Indicates a program that must run by itself |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CD_ID | Conflict domain identifier |
| DESCRIPTION | Description |
| DYNAMIC | Indicates this is a dynamically created conflict domain |
| Application Object Library - FND_CONFLICTS_DOMAIN_STATUS | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| CD_ID | Conflict domain identifier |
| APPLICATION_ID | - Retrofitted |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| LOCKED | - Retrofitted |
| REQUEST_ID | - Retrofitted |
| Application Object Library - FND_FILE_TEMP | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| FILENAME | - Retrofitted |
| NODE_NAME | - Retrofitted |
| MIME_TYPE | - Retrofitted |
| TRANSFER_MODE | - Retrofitted |
| REQUEST_ID | - Retrofitted |
| EXPIRES | - Retrofitted |
| NLS_CODESET_SOURCE | |
| NLS_CODESET_DESTINATION | |
| FILE_ID | - Retrofitted |
| FILE_SIZE | |
| DESTINATION_NODE | node name where file needs to be copied |
| DESTINATION_FILE | destination file name |
| TRANSFER_TYPE | Type of transfer('W'rite/'R'ead) |
| NATIVE_CLIENT_ENCODING | native client encoding |
| PAGE_NUMBER | page number to be displayed |
| PAGE_SIZE | page size to be displayed |
| ENABLE_LOGGING | ENABLE_LOGGING |
| Application Object Library - FND_CONC_STAT_PROG | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| NAME | - Retrofitted |
| Application Object Library - FND_ENABLED_PLSQL | List of PL/SQL packages/procedures accessible by web server |
|---|---|
| Column Name | Descritpion |
| PLSQL_NAME | Name of the PL/SQL object for which access is being controlled. Either a package name, or a package.procedure name. |
| ENABLED | Y/N flag: is procedure/package accessible by web server DCD? |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| EXTERNAL | EXTERNAL |
| PLSQL_TYPE | Type of object identified by PLSQL_NAME column. PACKAGE and PACKAGE.PROCEDURE are possible values. |
| Application Object Library - FND_APPLICATION_SERVERS | List of application servers authenticated to access this instance |
|---|---|
| Column Name | Descritpion |
| SERVER_ID | Identifier for an application server machine. Generally a randomly generated string. |
| SERVER_ADDRESS | IP address for application server machine |
| DESCRIPTION | User-friendly name or other description of application server machine |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_DM_FUNCTIONS | Document management functions supported through Open Interface |
|---|---|
| Column Name | Descritpion |
| FUNCTION_ID | Function identifier |
| FUNCTION_NAME | Function name |
| SEQUENCE | The order in which the function should be displayed when presented to the user. "1" is first, "100N" is last. |
| NEW_DOCUMENT_FUNCTION | Flag (Y|N) that indicates whether the function is available only when a new document is being created |
| EXISTING_DOCUMENT_FUNCTION | Flag (Y|N) that indicates whether the function is available only when a document has already been declared |
| RESOURCE_NAME | Name of function as it is stored in the wf_resources table. |
| ICON_NAME | File name of icon that represents the function |
| Application Object Library - FND_DM_FUNCTION_PARAMETERS | Document management system function parameters |
|---|---|
| Column Name | Descritpion |
| PARAMETER_ID | Parameter identifier |
| PARAMETER_NAME | Name of parameter |
| FUNCTION_ID | Identifier for DM function that the parameter relates to |
| Application Object Library - FND_DM_NODES | Document manager system nodes |
|---|---|
| Column Name | Descritpion |
| NODE_ID | Document manager system node identifier |
| NODE_NAME | Logical name for document manager system node |
| PRODUCT_ID | Identifier for the Document Manager software vendor and product version that isinstalled on this node (FK to fnd_dm_products.product_id) |
| CONNECT_SYNTAX | Physical 'protocol://server:port/' URL connection information.This syntax will prefix the function names and parameters required to execute the document management system specific functions. |
| NODE_DESCRIPTION | Node description |
| SHORT_NAME | SHORT_NAME |
| CONNECT_URL | CONNECT_URL |
| SEQUENCE | SEQUENCE |
| CERTIFICATE_PATH | The full path to the dm server's digital certificate in the E-business suite middle tier |
| Application Object Library - FND_DM_PRODUCTS | Supported Document Management software products |
|---|---|
| Column Name | Descritpion |
| PRODUCT_ID | Identifier for the Document Management software product |
| PRODUCT_NAME | Name of document management system product |
| VENDOR_NAME | Name of software vendor who created the product |
| VERSION | Version of the software that is supported |
| PROTOCOL | PROTOCOL |
| Application Object Library - FND_DM_PRODUCT_FUNCTION_SYNTAX | Syntaxes for Document Management product functions |
|---|---|
| Column Name | Descritpion |
| PRODUCT_FUNCTION_ID | Identifier for a function for a specific product |
| PRODUCT_ID | Identifier for document management product that implements the function |
| FUNCTION_ID | Function identifier |
| FUNCTION_SYNTAX | URL function syntax required by the DM product |
| Application Object Library - FND_DM_PRODUCT_PARM_SYNTAX | Syntaxes for function parameters of document management system products |
|---|---|
| Column Name | Descritpion |
| PRODUCT_PARAMETER_ID | Product parameter identifier |
| PRODUCT_FUNCTION_ID | Identifier for product-function combination |
| PARAMETER_ID | Parameter identifier |
| PARAMETER_SYNTAX | URL parameter syntax for the function in the product |
| FORMAT | Format mask for the URL parameter component |
| Application Object Library - FND_CONC_OS_PROCESSES | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| NODE_NAME | - Retrofitted |
| QUEUE_NAME | - Retrofitted |
| CHILD_PROCESS_ID | - Retrofitted |
| PARENT_PROCESS_ID | - Retrofitted |
| PARENT_THREAD_ID | - Retrofitted |
| CHILD_THREAD_ID | - Retrofitted |
| PARENT_EXE_NAME | - Retrofitted |
| CHILD_EXE_NAME | - Retrofitted |
| PARENT_START_TIME | - Retrofitted |
| CHILD_START_TIME | - Retrofitted |
| Application Object Library - FND_APPL_SESSIONS | Auditing information for non-Forms based applications sessions |
|---|---|
| Column Name | Descritpion |
| LOGIN_TYPE | Type of session |
| RESOURCE_CONSUMER_GROUP | Resource Consumer Group in which this session ran or was running |
| LOGIN_RESP_ID | Responsibility identifier (FK fnd_login_responsibilities.login_resp_id) |
| LOGIN_ID | Identifier of login session (FK fnd_logins.login_id) |
| AUDSID | db audsid (v$session.audsid) |
| START_TIME | Session start time |
| END_TIME | Session end time |
| Application Object Library - FND_CONCURRENT_QUEUE_PARAMS | Concurrent manager parameters |
|---|---|
| Column Name | Descritpion |
| QUEUE_APPLICATION_ID | Application identifier of concurrent manager |
| CONCURRENT_QUEUE_ID | Concurrent manager identifier |
| NAME | Parameter name |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| VALUE | Parameter value |
| Application Object Library - FND_CONC_STAT_GROUPS | |
|---|---|
| Column Name | Descritpion |
| GROUP_CODE | |
| ENABLED | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN |
| Application Object Library - FND_CONC_STAT_G_P_SUMMARY | |
|---|---|
| Column Name | Descritpion |
| STATISTIC# | |
| ROLLUP_VAR_N_1 | |
| ROLLUP_VAR_N_2 | |
| ROLLUP_VAR_C_1 | |
| GROUP_CODE | |
| COLLECT_PERIOD | |
| COLLECT_DATE | |
| PROCESS_TYPE | |
| MIN | |
| MAX | |
| MEAN | |
| N |
| Application Object Library - FND_CONC_STAT_PERIODS | |
|---|---|
| Column Name | Descritpion |
| VALUE | |
| ROTATION | |
| ROTATE_DATE | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN |
| Application Object Library - FND_CRM_HISTORY | |
|---|---|
| Column Name | Descritpion |
| REQUESTS_EXAMINED | |
| REQUESTS_STANDBY | |
| REQUESTS_RELEASED | |
| REQUESTS_RETURNED | |
| WORK_START | |
| WORK_END |
| Application Object Library - FND_EXCLUDE_TABLE_STATS | Default data for application interface tables |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier of product that owns the table. |
| TABLE_NAME | Name of application interface table. |
| PARTITION | Partition name if application interface table is partitioned. |
| APPROX_NUM_ROWS | Default statistics. |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Application Object Library - FND_EVENTS | |
|---|---|
| Column Name | Descritpion |
| EVENT_ID | |
| PROCESSED | |
| TOKENS | |
| MODULE | Exception Source Module |
| USER_ID | User that posted event |
| RESP_APPL_ID | Application ID of User's Responsibility |
| RESPONSIBILITY_ID | User's Responsibility Id |
| SEC_GROUP_ID | Users's Security Group ID |
| SESSION_ID | User's session ID |
| NODE | Node event was posted from |
| DB_INSTANCE | Database Instance event was posted from |
| SOURCE_APPLICATION_ID | |
| AUDSID | Oracle Session ID |
| SECURITY_GROUP_ID | |
| SOURCE_ID | |
| SOURCE_TYPE | |
| DEST_TYPE | |
| MESSAGE_APPL_SHORT_NAME | |
| MESSAGE_NAME | |
| TIME | |
| SEVERITY |
| Application Object Library - FND_EVENT_TOKENS | |
|---|---|
| Column Name | Descritpion |
| EVENT_ID | |
| TOKEN | |
| TYPE | |
| VALUE |
| Application Object Library - FND_ENV_CONTEXT | FND_ENV_CONTEXT stores information about environment name and value for each of the concurrent process |
|---|---|
| Column Name | Descritpion |
| CONCURRENT_PROCESS_ID | Concurrent Process identifier |
| VARIABLE_NAME | Name of the environment variable |
| VALUE | Value of the environment variable |
| Application Object Library - FND_CONC_NT_PROCESSES | FND_CONC_NT_PROCESSES stores information about processes created by the concurrent manager in the NT environment |
|---|---|
| Column Name | Descritpion |
| NODE_NAME | Name of the node (computer on the network) on which the process is created. |
| CHILD_PROCESS_ID | ID of the created process. |
| PARENT_PROCESS_ID | ID of the creating (concurrent manager) process. |
| PARENT_THREAD_ID | ID of the creating (concurrent manager) process main thread. Not currently used |
| CHILD_THREAD_ID | ID of the created process main thread. Not currently used. |
| PARENT_EXE_NAME | Name of the creating (concurrent manager) process. |
| CHILD_EXE_NAME | Name of the created process. |
| PARENT_START_TIME | Time at which the creating (concurrent manager) process started. |
| CHILD_START_TIME | Time at which the created process started. |
| Application Object Library - FND_CP_SERVICES | Service Information |
|---|---|
| Column Name | Descritpion |
| SERVICE_ID | Unique id for the service, created by using sequence |
| ALLOW_VERIFY | Indicates if the service will accept a command to verify its internal state |
| ALLOW_PARAMETER | Indicator whether the service allows a parameter string to be associated with each work shift |
| ALLOW_START | Indicates if the service can be started from the system administration user interface |
| ALLOW_RESTART | Indicates if a service process should be restarted by the ICM if that service process exits abnormally |
| PARAMETER_CHANGE_ACTION | In dicates the action that should be taken when the parameters for a service instance change when the active work shift changes |
| DEVELOPER_PARAMETERS | Service specific cartridge parameter |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| SERVICE_HANDLE | Developer key for the service |
| CREATED_BY | Standard Who column |
| ENV_FILE_NAME | Optional environment file for the service |
| ALLOW_CREATE | Indicates whether or not users should be allowed to create new service instances for this service |
| SERVICE_CLASS | If not null, this points to the display class that should be used for the right pane of the OAM instead of the default class, when the Navigator focus is on the service |
| SERVICE_INSTANCE_CLASS | If not null, this points to the display class that should be used for the right pane of the OAM instead of the default class, when the Navigator focus is on an instance of this service |
| ALLOW_RCG | Indicate whether or not the service definition user interface should allow a resource consumer group to be chosen for this service |
| OAM_DISPLAY_ORDER | Determines the order in which the services are listed in the Services branch of the OAM Navigator tree |
| ALLOW_EDIT | ALLOW_EDIT |
| ENABLED | Enabled Flag - Enabled Services can have Service Instances created |
| DEBUG_CHANGE_ACTION | Type of Action taken when debug level is changed. |
| SERVICE_NAME | Service Name |
| CARTRIDGE_APPLICATION_ID | Application Id of cartridge |
| DEBUG_TYPE | Lookup type name for diagnostic level |
| ALLOW_MULTIPLE_PROC_SI | Allow multiple processes per Service Instance |
| DEFAULT_DEBUG_LEVEL | Default value for diagnostic level |
| CARTRIDGE_HANDLE | Developer key for cartridge |
| ALLOW_MULTIPLE_PROC_INSTANCE | Indicator whether or not the service allows more than one service process tobe active for an Apps instance |
| ALLOW_MULTIPLE_PROC_NODE | Indicator whether or not the service allows more thanone service process to be active for on a given node |
| MIGRATE_ON_FAILURE | Indicator whether or not service process can be movedto a secondary node when primary mode service fails |
| SERVER_TYPE | Indicates the type of applications server upon which the service runs |
| ALLOW_SUSPEND | Allow suspend or not |
| Application Object Library - FND_CP_SERVICES_TL | FND_CP_SERVICES_TL table stores translated information about services in each of the translated languages |
|---|---|
| Column Name | Descritpion |
| SERVICE_ID | Service Id |
| DESCRIPTION | Description |
| SERVICE_PLURAL_NAME | Service name |
| LANGUAGE | Language |
| SOURCE_LANG | The Language the text will mirror. If text is not yettranslated into LANGUAGE then any chagnes to the text inthe source language row will be reflexted here as well. |
| SERVICE_NAME | Developer key for the service |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| Application Object Library - FND_CONC_PROG_ONSITE_INFO | The Fnd_Conc_Prog_OnSite_Info table stores information about Concurrent Programs on site runtime information |
|---|---|
| Column Name | Descritpion |
| PROGRAM_APPLICATION_ID | Concurrent Program Application Id |
| LAST_UPDATE_LOGIN | Standard Who Column |
| MONITOR_ENABLED | Enable Monitor critical activity in OAM or not |
| REQUEST_SCH_INTERVAL | System Admin set schedule repeat interval value in days. |
| SUCCESSFUL_COMPLETION | Number of completed with success requests from reset_date |
| WARNING_COMPLETION | Number of completed with warning requests from reset_date |
| ERROR_COMPLETION | Number of completed with error requests from reset_date |
| RESET_DATE | Date from which successful_completion,warning_completion error_completion counting started |
| MIN_RUN_TIME | Minimum amount of time in seconds it took to run request for this program. |
| MAX_RUN_TIME | Maximum amount of time in seconds it took to run request for this program. |
| AVG_RUN_TIME | Average time of Request run for this program. |
| CONCURRENT_PROGRAM_ID | Concurrent Program Id |
| ON_FAILURE_LOG_LEVEL | System Exception log level to log an event when a Request for this program completes with error status. Null value means does not log event. |
| SHELF_LIFE | Number of more days to retain the request |
| ALERT_LONG_RUNNING_ENABLED | Y/N flag to determine if program is selected for specific alerting for long running requests |
| ALERT_LONG_RUNNING_THRESHOLD | User specified threshold for the program run time in seconds |
| ALERT_LONG_RUNNING_TOLERANCE | User specified tolerance for the program run time (%) |
| ALERT_LONG_PENDING_ENABLED | Y/N flag to determine if program is selected for specific alerting for long pending requests |
| ALERT_LONG_PENDING_TOLERANCE | User specified tolerance for the program wait time in seconds |
| NODE_NAME1 | Primary target node for program |
| NODE_NAME2 | Secondary target node for program |
| CONNSTR1 | Primary connection string for program |
| CONNSTR2 | Secondary connection string for program |
| BUSINESS_EVENT_MAP | Business Event Map |
| LAST_RUN_DATE | Date when this program was last run |
| LAST_RUN_REQUEST_ID | Request Id of the last run Request |
| OUTCOME | Status code of the request |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| Application Object Library - FND_EXCEPTION_NOTES | This table allows DBAs to store notes associated with an exception |
|---|---|
| Column Name | Descritpion |
| UNIQUE_EXCEPTION_ID | Unique Exception Identifier |
| NOTES | DBA's Notes related to the exception |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| LOG_SEQUENCE | Primary Key/ Foreign key - FND_LOG_EXCEPTIONS |
| Application Object Library - FND_COMPILED_MENU_FUNCTIONS | This table compiles the information from FND_MENU_ENTRIES to facilitateruntime lookups of which functions are on which menus. |
|---|---|
| Column Name | Descritpion |
| MENU_ID | FK to FND_MENUS. Menu that has this function |
| FUNCTION_ID | FK to FND_FORM_FUNCTIONS. Function on this menu |
| GRANT_FLAG | Y= permission granted through function security. N (default)= only navigational ability. B= menu with MENU_ID has no functions. U= menu with MENU_ID needs to be recompiled |
| Application Object Library - FND_AUDIT_DISP_COLS | This table stores display columns for the Audit Query Navigator |
|---|---|
| Column Name | Descritpion |
| TABLE_ID | Table ID |
| COL_DISP_IND | 0 - for Column List, 1 - for sql query |
| SELECT_CLAUSE | This is to store column list for both options |
| FROM_CLAUSE | f col_disp_ind=1, the column stores the from clause |
| WHERE_CLAUSE | if col_disp_ind=1, the column stores the where clause |
| APPLICATION_ID | Application ID |
| Application Object Library - FND_AUDIT_LKUPS | This table stores Lookup Type information to show decoded column values in the Audit Query Navigator. |
|---|---|
| Column Name | Descritpion |
| AUDIT_COLUMN_ID | Audit column ID |
| TABLE_APP_ID | Table application ID |
| LOOKUP_TYPE | FND Lookup type |
| LOOKUP_APP_ID | Lookup App Id |
| LOOKUP_TABLE_ID | Lookup Table Id |
| LOOKUP_TABLE_NAME | Lookup Table Name |
| LOOKUP_COLUMN_NAME | Lookup Column Name |
| DISPLAY_COLUMN_NAME | Display Column Name |
| AUDIT_TABLE_ID | Audit table ID |
| Application Object Library - FND_AUDIT_REP_DTL | Data in this table is temporary and is used for Audit Trail Reporting |
|---|---|
| Column Name | Descritpion |
| TABLE_NAME | Table Name |
| AUDIT_KEY | Audit Key |
| ROW_DISP_COL | Identifier value for display |
| AUDIT_TIMESTAMP | Audit Timestamp |
| AUDIT_TRANSACTION_TYPE | Audit Transaction Type |
| AUDIT_USER_NAME | Audit username |
| COLUMN1_VALUE | Column1 display value |
| COLUMN2_VALUE | Column2 display value |
| REP_ID | Report ID |
| COLUMN3_VALUE | Column3 display value |
| COLUMN4_VALUE | Column4 display value |
| COLUMN5_VALUE | Column5 display value |
| Application Object Library - FND_AUDIT_REP_HDR | Data in this table is temporary and is used for Audit Trail Reporting |
|---|---|
| Column Name | Descritpion |
| TABLE_NAME | Table Name |
| USER_TABLE_NAME | User Table Name |
| COLUMN1_NAME | Column1 display value |
| COLUMN2_NAME | Column2 display value |
| COLUMN3_NAME | Column3 display value |
| COLUMN4_NAME | Column4 display value |
| COLUMN5_NAME | Column5 display value |
| SELECT_CLAUSE | Select Clause |
| REP_ID | Report ID |
| APPLICATION_ID | Application ID |
| TABLE_ID | Table ID |
| WHERE_CLAUSE | Where clause |
| Application Object Library - FND_AUDIT_TMPLT_DTL | This table stores the relation between Industry Templates and Audit Groups. |
|---|---|
| Column Name | Descritpion |
| AUDIT_GROUP_ID | Audit Group ID |
| APPLICATION_ID | Application ID |
| CREATION_DATE | Creation Date |
| CREATED_BY | Created By |
| LAST_UPDATE_DATE | Last Update Date |
| LAST_UPDATED_BY | Last Updated By |
| LAST_UPDATE_LOGIN | Last Update Login |
| TEMPLATE_NAME | Industry Template |
| Application Object Library - FND_AUDIT_TMPLT_MST | This table stores Industry Templates. |
|---|---|
| Column Name | Descritpion |
| TEMPLATE_DESC | Industry Template Description |
| CREATION_DATE | Creation Date |
| CREATED_BY | Created By |
| LAST_UPDATE_DATE | Last Update Date |
| LAST_UPDATED_BY | Last Updated By |
| LAST_UPDATE_LOGIN | Last Updated Login |
| TEMPLATE_NAME | Industry Template |
| Application Object Library - FND_DATABASE_INSTANCES | Fnd_Database_Instances table stores instance specific information |
|---|---|
| Column Name | Descritpion |
| DB_GUID | Foreign key to FND_DATABASES |
| DESCRIPTION | Description set by user |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| SERVER_GUID | server guid |
| INTERCONNECT_NAME | Private interconnect name, used for cluster manager |
| INSTANCE_GUID | instance id |
| SID_GUID | SID id |
| INSTANCE_NAME | Instance name set in initSID.ora file. |
| HOST | Host name for this instance. Used in tnsnames.ora file |
| INSTANCE_NUMBER | Instance number from v$instance. |
| SID | SID name for this instance. Used in tnsnames.ora file. |
| DB_ID | Database Id. Foreign Key to FND_DATABASES. |
| DEFAULT_TNS_ALIAS_GUID | Default TNS alias used to contact this instance. Key into fnd_tns_aliases. (Note: Using a GUID will make it easier to alter the alias name upon cloning.) This alias should be mapped only to this instance, and not to a service that balanc |
| TWO_TASK | TNS alias for this instance. |
| LOCAL_LISTENER_ALIAS | ID for the local TNS Listener Alias. Key into fnd_tns_aliases. Used to set the LOCAL_LISTENER initialization parameter |
| REMOTE_LISTENER_ALIAS | ID for the Remote TNS Listener Alias. Key into fnd_tns_aliases. Used to set the REMOTE_LISTENER initialization parameter. |
| PORT | Port Number for this instance. |
| CONFIGURATION | Named configuration for AD init.ora checking |
| Application Object Library - FND_DATABASE_ASSIGNMENTS | Fnd_Database_Assignments table assigns specific functions to a database |
|---|---|
| Column Name | Descritpion |
| DB_GUID | Foreign key to FND_DATABASES |
| ASSIGNMENT | Assignment type (e.g. APPS, OEM_REPOSITORY, IAS_INFRASTRUCTURE, etc.). Assignment types are defined in FND_LOOKUPS with the lookup_type 'FND_DB_ASSIGNMENT' |
| CREATED_BY | Standard "who" column |
| CREATION_DATE | Standard "who" column |
| DB_ID | Database Id |
| LAST_UPDATED_BY | Standard "who" column |
| LAST_UPDATE_DATE | Standard "who" column |
| LAST_UPDATE_LOGIN | Standard "who" column |
| Application Object Library - FND_DATABASES | This table stores information about the database that is not instance specific. |
|---|---|
| Column Name | Descritpion |
| DB_GUID | Sys_GUID() generated unique identifier for the row. Necessary because db_name may change when cloned. |
| LAST_UPDATE_DATE | Standard "who" column |
| LAST_UPDATE_LOGIN | Standard "who" column |
| SYSTEM_GUID | Global unique ID for this Apps system. Will facilitate tracking multiple systems in a central repository, if ever needed. |
| DB_NAME | Database name. Value is the same as db_name from v$parameter. Combines with the db_domain to give the global database name (i.e. Global dababase name = |
| SERVICE_PORT | Port for service connection that will be registered in tnsnames.ora |
| SERVICE_HOST | Host for service connection that will be registered in tnsnames.ora |
| DB_DOMAIN | Database domain. Value is the same as db_domain from v$parameter. Combines with the db_name to give the global database name (i.e. Global dababase name = |
| DEFAULT_TNS_ALIAS_GUID | Default TNS alias used for contacting this database. Key into fnd_tns_aliases. (Note: Using a GUID will make it easier to alter the alias name upon cloning.) Typically, this alias would point to a database service that will load balan |
| DB_ID | Databse ID, internally generated |
| IS_RAC_DB | is RAC DB (Y/N) |
| VERSION | RDBMS version |
| SERVICE_TWO_TASK | TNS alias for database service. Used for load balancing connections across multiple instances. |
| CREATED_BY | Standard "who" column |
| CREATION_DATE | Standard "who" column |
| LAST_UPDATED_BY | Standard "who" column |
| Application Object Library - FND_BUSINESS_PURPOSES_TL | |
|---|---|
| Column Name | Descritpion |
| PURPOSE_CODE | |
| LANGUAGE | |
| SOURCE_LANG | |
| SECURITY_GROUP_ID | |
| PURPOSE_NAME | |
| DESCRIPTION | |
| DESCRIPTION_INT | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN |
| Application Object Library - FND_BUSINESS_PURPOSES_B | |
|---|---|
| Column Name | Descritpion |
| PURPOSE_CODE | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| ATTRIBUTE_CATEGORY | |
| APPLICATION_ID | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN | |
| OBJECT_VERSION_NUMBER | |
| SECURITY_GROUP_ID | |
| PURPOSE_DEFAULT_CODE | |
| SEEDED_FLAG | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 |
| Application Object Library - FND_COL_PRIV_ATTRIBUTES_B | |
|---|---|
| Column Name | Descritpion |
| PRIVACY_ATTRIBUTE_CODE | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| APPLICATION_ID | |
| ATTRIBUTE15 | |
| SECURITY_GROUP_ID | |
| ATTRIBUTE_CATEGORY | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN | |
| OBJECT_VERSION_NUMBER | |
| DSCRAM_LEVEL | |
| DSCRAM_ALGO_ID | |
| TABLE_ID | |
| COLUMN_ID | |
| COLUMN_SEQUENCE | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 |
| Application Object Library - FND_COL_PRIV_ATTRIBUTES_TL | |
|---|---|
| Column Name | Descritpion |
| PRIVACY_ATTRIBUTE_CODE | |
| LAST_UPDATE_LOGIN | |
| LANGUAGE | |
| SOURCE_LANG | |
| SECURITY_GROUP_ID | |
| APPLICATION_ID | |
| TABLE_ID | |
| COLUMN_ID | |
| COMMENTS | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE |
| Application Object Library - FND_CONC_DEFERRED_ARGUMENTS | FND_CONC_DEFERRED_ARGUMENTS |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Concurrent Request ID |
| ARGUMENT2 | argument value |
| ARGUMENT92 | argument value |
| ARGUMENT93 | argument value |
| ARGUMENT94 | argument value |
| ARGUMENT95 | argument value |
| ARGUMENT96 | argument value |
| ARGUMENT97 | argument value |
| ARGUMENT98 | argument value |
| ARGUMENT99 | argument value |
| ARGUMENT100 | argument value |
| ARGUMENT3 | argument value |
| ARGUMENT4 | argument value |
| ARGUMENT5 | argument value |
| ARGUMENT6 | argument value |
| ARGUMENT7 | argument value |
| ARGUMENT8 | argument value |
| ARGUMENT9 | argument value |
| ARGUMENT10 | argument value |
| ARGUMENT11 | argument value |
| PROGRAM_APPLICATION_ID | Concurrent Program Application Id |
| ARGUMENT12 | argument value |
| ARGUMENT13 | argument value |
| ARGUMENT14 | argument value |
| ARGUMENT15 | argument value |
| ARGUMENT16 | argument value |
| ARGUMENT17 | argument value |
| ARGUMENT18 | argument value |
| ARGUMENT19 | argument value |
| ARGUMENT20 | argument value |
| ARGUMENT21 | argument value |
| CONCURRENT_PROGRAM_ID | Concurrent Program Id |
| ARGUMENT22 | argument value |
| ARGUMENT23 | argument value |
| ARGUMENT24 | argument value |
| ARGUMENT25 | argument value |
| ARGUMENT26 | argument value |
| ARGUMENT27 | argument value |
| ARGUMENT28 | argument value |
| ARGUMENT29 | argument value |
| ARGUMENT30 | argument value |
| ARGUMENT31 | argument value |
| CREATION_DATE | Standard who column |
| ARGUMENT32 | argument value |
| ARGUMENT33 | argument value |
| ARGUMENT34 | argument value |
| ARGUMENT35 | argument value |
| ARGUMENT36 | argument value |
| ARGUMENT37 | argument value |
| ARGUMENT38 | argument value |
| ARGUMENT39 | argument value |
| ARGUMENT40 | argument value |
| ARGUMENT41 | argument value |
| CREATED_BY | Standard who column |
| ARGUMENT42 | argument value |
| ARGUMENT43 | argument value |
| ARGUMENT44 | argument value |
| ARGUMENT45 | argument value |
| ARGUMENT46 | argument value |
| ARGUMENT47 | argument value |
| ARGUMENT48 | argument value |
| ARGUMENT49 | argument value |
| ARGUMENT50 | argument value |
| ARGUMENT51 | argument value |
| LAST_UPDATE_DATE | Standard who column |
| ARGUMENT52 | argument value |
| ARGUMENT53 | argument value |
| ARGUMENT54 | argument value |
| ARGUMENT55 | argument value |
| ARGUMENT56 | argument value |
| ARGUMENT57 | argument value |
| ARGUMENT58 | argument value |
| ARGUMENT59 | argument value |
| ARGUMENT60 | argument value |
| ARGUMENT61 | argument value |
| LAST_UPDATED_BY | Standard who column |
| ARGUMENT62 | argument value |
| ARGUMENT63 | argument value |
| ARGUMENT64 | argument value |
| ARGUMENT65 | argument value |
| ARGUMENT66 | argument value |
| ARGUMENT67 | argument value |
| ARGUMENT68 | argument value |
| ARGUMENT69 | argument value |
| ARGUMENT70 | argument value |
| ARGUMENT71 | argument value |
| LAST_UPDATE_LOGIN | Standard who column |
| ARGUMENT72 | argument value |
| ARGUMENT73 | argument value |
| ARGUMENT74 | argument value |
| ARGUMENT75 | argument value |
| ARGUMENT76 | argument value |
| ARGUMENT77 | argument value |
| ARGUMENT78 | argument value |
| ARGUMENT79 | argument value |
| ARGUMENT80 | argument value |
| ARGUMENT81 | argument value |
| ARGUMENT1 | argument value |
| ARGUMENT82 | argument value |
| ARGUMENT83 | argument value |
| ARGUMENT84 | argument value |
| ARGUMENT85 | argument value |
| ARGUMENT86 | argument value |
| ARGUMENT87 | argument value |
| ARGUMENT88 | argument value |
| ARGUMENT89 | argument value |
| ARGUMENT90 | argument value |
| ARGUMENT91 | argument value |
| Application Object Library - FND_CONC_PROG_ANNOTATIONS | To store annotation information for a concurrent program. |
|---|---|
| Column Name | Descritpion |
| CONCURRENT_PROGRAM_ID | Concurrent Program Id |
| PROGRAM_ANNOTATION | Annotation information for the program |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| APPLICATION_ID | Concurrent Program Application Id |
| Application Object Library - FND_COMPONENT_DEBUG_OPTIONS | FND_COMPONENT_DEBUG_OPTIONS |
|---|---|
| Column Name | Descritpion |
| COMPONENT_NAME | Component Name |
| DEBUG_OPTION_NAME | Debug Option Name from fnd_debug_options |
| ENABLED_FLAG | ENABLED_FLAG |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| Application Object Library - FND_DEBUG_OPTIONS | FND_DEBUG_OPTIONS |
|---|---|
| Column Name | Descritpion |
| DEBUG_OPTION_NAME | Debug Option Name(internal Name) |
| LAST_UPDATE_LOGIN | Standard Who Column |
| ENABLED_FLAG | Flag to indicate debug option is enabled or not |
| TYPE | TYPE |
| SEPARATOR | Separator character used |
| TRACE_FILE_TOKEN | File token name if any |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| Application Object Library - FND_DEBUG_OPTIONS_TL | FND_DEBUG_OPTIONS_TL |
|---|---|
| Column Name | Descritpion |
| DEBUG_OPTION_NAME | DEBUG_OPTION_NAME |
| DESCRIPTION | Description |
| SOURCE_LANGUAGE | SOURCE_LANGUAGE |
| LANGUAGE | LANGUAGE |
| SOURCE_LANG | SOURCE_LANGUAGE |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| Application Object Library - FND_DEBUG_OPTION_VALUES | Debug Option Values represent valid values for the debug option |
|---|---|
| Column Name | Descritpion |
| DEBUG_OPTION_NAME | DEBUG_OPTION_NAME |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| DEBUG_OPTION_VALUE | DEBUG_OPTION_VALUE |
| ENABLE_ROUTINE | PL/SQL routine that will set the initialization to enable debug option. |
| DISABLE_ROUTINE | PL/SQL routine that will be called to unset the debug option |
| IS_FILE_TOKEN | It represents that this Debug option value is a file token or not |
| TRACE_FILE_ROUTINE | pl/sql function which will return trace file |
| TRACE_FILE_NODE | pl/sql function which will return node name |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| Application Object Library - FND_DEBUG_OPTION_VALUES_TL | Debug Option Values TL table for translation purpose |
|---|---|
| Column Name | Descritpion |
| DEBUG_OPTION_NAME | DEBUG_OPTION_NAME |
| LAST_UPDATE_LOGIN | Standard Who Column |
| DEBUG_OPTION_VALUE | DEBUG_OPTION_VALUE |
| SOURCE_LANGUAGE | SOURCE_LANGUAGE |
| DESCRIPTION | DESCRIPTION |
| LANGUAGE | LANGUAGE |
| SOURCE_LANG | SOURCE_LANGUAGE |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| Application Object Library - FND_DEBUG_RULE_EXECUTIONS | FND_DEBUG_RULE_EXECUTIONS |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_ID | TRANSACTION_ID |
| DEBUG_LOG_FILE | DEBUG_LOG_FILE |
| LOG_FILE_NODE_NAME | LOG_FILE_NODE_NAME |
| USER_ID | User_ID for which this debug option has to be set |
| RESPONSIBILITY_ID | RESPONSIBILITY_ID |
| RESP_APPL_ID | Responsibility_Id,Resp_Appl_ID will be used to set for a given resp |
| DEBUG_OPTION_NAME | Debug Option Name that needs to be set |
| DEBUG_OPTION_VALUE | Debug Option value for debug option |
| COMMENTS | comments for this debug rule |
| REQUEST_ID | Request id |
| CREATION_DATE | Standard Who Column |
| RULE_ID | RULE_ID |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| LOG_REQUEST_ID | DBG Debug Information will be the output of the Concurrent Request. |
| COMPONENT_TYPE | COMPONENT_TYPE |
| COMPONENT_NAME | COMPONENT_NAME |
| COMPONENT_ID | COMPONENT_ID |
| COMPONENT_APPL_ID | If component_Id is specified then Component_Appl_Id is required |
| START_TIME | Start_Time |
| END_TIME | END_TIME |
| REPEATION_COUNTER | REPEATION_COUNTER |
| Application Object Library - FND_DEBUG_RULE_OPTIONS | 1. Removed 2 columns from fnd_debug_rules 2. Added new table as fnd_debug_rule_options |
|---|---|
| Column Name | Descritpion |
| DEBUG_OPTION_NAME | Debug Option Name |
| DEBUG_OPTION_VALUE | Debug Option Value |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| DEBUG_RULE_ID | Debug Rule Id |
| Application Object Library - FND_DEBUG_RULES | Debug Rule is a valid debug option set by System Administrator to |
|---|---|
| Column Name | Descritpion |
| DEBUG_RULE_ID | DEBUG_RULE_ID |
| RESPONSIBILITY_ID | RESPONSIBILITY_ID |
| RESP_APPL_ID | Responsibility_Id,Resp_Appl_ID will be used to set for a given resp |
| COMMENTS | comments for this debug rule |
| REQUEST_ID | Request id |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| COMPONENT_TYPE | COMPONENT_TYPE |
| LAST_UPDATE_LOGIN | Standard Who Column |
| DEBUG_OPTION_NAME | Debug Option Name |
| DEBUG_OPTION_VALUE | Debug Option Value |
| COMPONENT_NAME | COMPONENT_NAME |
| COMPONENT_ID | COMPONENT_ID |
| COMPONENT_APPL_ID | If component_Id is specified then Component_Appl_Id is required |
| START_TIME | Time at which this debug option will start |
| END_TIME | Time at which this debug option will end |
| REPEATION_COUNTER | Number of times this debug rule should be used |
| USER_ID | User_ID for which this debug option has to be set |
| Application Object Library - FND_DM_FOLDERATTACHMENTEXT | This table specifies whether the attached folder is the default folder. |
|---|---|
| Column Name | Descritpion |
| ATTACHMENT_ID | Attachment Identifier |
| DEFAULT_FOLDER | Flag indicating whether this is the default folder. |
| Application Object Library - FND_DM_DOCUMENT_ENTITIES_EXT | This table holds the security and where-used related apis/sqls for the business entity. |
|---|---|
| Column Name | Descritpion |
| ENTITY_NAME | Business entity Identifier |
| GET_ROLE_NAMES_SQL | Query that returns the roles associated to the business entity |
| GET_USER_ROLES_PLSQL_API | Additional security API for roles. |
| GET_USERS_PLSQL_API | Additional security API for users. |
| CUSTOM_ROLE_MAP_JAVA_CLASS | Additional Java security API for roles |
| GET_INSTANCE_NAME_SQL | Business Entity Instance name. |
| INSTANCE_DETAIL_PAGE_URL | Business Entity detail page URL |
| INSTANCE_WHEREUSED_PAGE_URL | Business Entity where-used page URL |
| Application Object Library - FND_DM_PRODUCTS_TL | This table holds the transalated name of the repository |
|---|---|
| Column Name | Descritpion |
| DISPLAY_NAME | Repository Name |
| PRODUCT_DESCRIPTION | Repository Description |
| LANGUAGE | LANGUAGE |
| SOURCE_LANG | SOURCE_LANG |
| PRODUCT_ID | Repository Identifier |
| Application Object Library - FND_DM_ACCESSNAMES_TL | This table holds the translatable names of the access levels/privileges that can be granted to the user on a repository item. |
|---|---|
| Column Name | Descritpion |
| ACCESS_NAME | Access Identifier |
| LAST_UPDATE_LOGIN | Standard Who column |
| DISPLAY_NAME | Access Name |
| DESCRIPTION | Access Description |
| LANGUAGE | language |
| SOURCE_LANG | source language |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| Application Object Library - FND_DM_ACCESSNAMES | This table holds the internal names of the access levels/privileges that can be granted to the user on a repository item |
|---|---|
| Column Name | Descritpion |
| ACCESS_NAME | Access Identifier |
| ACCESS_LEVEL | Access Level |
| Application Object Library - FND_DM_SECURITYMAPPINGS_TL | Translation table that stores the mapping from business object to template |
|---|---|
| Column Name | Descritpion |
| MAPPING_ID | MAPPING_ID |
| LAST_UPDATE_LOGIN | LAST_UPDATE_LOGIN |
| DISPLAY_NAME | DISPLAY_NAME |
| DESCRIPTION | DESCRIPTION |
| LANGUAGE | LANGUAGE |
| SOURCE_LANG | SOURCE_LANG |
| CREATED_BY | CREATED_BY |
| CREATION_DATE | CREATION_DATE |
| LAST_UPDATED_BY | LAST_UPDATED_BY |
| LAST_UPDATE_DATE | LAST_UPDATE_DATE |
| Application Object Library - FND_DM_SECURITYMAPPINGS | Stores the mapping from business object to template |
|---|---|
| Column Name | Descritpion |
| MAPPING_ID | MAPPING_ID |
| MAPPING_NAME | MAPPING_NAME |
| ENTITY_NAME | ENTITY_NAME |
| TEMPLATE_TYPE | TEMPLATE_TYPE |
| CREATED_BY | CREATED_BY |
| CREATION_DATE | CREATION_DATE |
| LAST_UPDATED_BY | LAST_UPDATED_BY |
| LAST_UPDATE_DATE | LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN | LAST_UPDATE_LOGIN |
| Application Object Library - FND_DM_SECURITYMAPDETAILS | Stores the mapping information from business Object security to OFO access level |
|---|---|
| Column Name | Descritpion |
| MAPPING_ID | MAPPING_ID |
| OBJECT_ACCESS | OBJECT_ACCESS |
| DOCUMENT_ACCESS | DOCUMENT_ACCESS |
| Application Object Library - FND_DM_FOLDERROLEMAPS | Stores the mapping information for a business object security to a OFO folder security |
|---|---|
| Column Name | Descritpion |
| ENTITY_NAME | ENTITY_NAME |
| CREATION_DATE | CREATION_DATE |
| LAST_UPDATED_BY | LAST_UPDATED_BY |
| LAST_UPDATE_DATE | LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN | LAST_UPDATE_LOGIN |
| PK1_VALUE | PK1_VALUE |
| PK2_VALUE | PK2_VALUE |
| PK3_VALUE | PK3_VALUE |
| PK4_VALUE | PK4_VALUE |
| PK5_VALUE | PK5_VALUE |
| DOCUMENT_ID | DOCUMENT_ID |
| MAPPING_ID | MAPPING_ID |
| CREATED_BY | CREATED_BY |
| Application Object Library - FND_DEFERRED_LOAD_FILES | The FND_DEFERRED_LOAD_FILES table stores information about files for deferred loading. |
|---|---|
| Column Name | Descritpion |
| FILE_PRODUCT | File Application Shortname |
| LOAD_TYPE_LABEL | Load_TYPE_label |
| FILE_PRIORITY | File_priority |
| ADDITIONAL_CONTEXT_INFO | Additional_context_info |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| FILE_PATH | File Path |
| FILE_NAME | File Name |
| FILE_VERSION | File Version |
| LOAD_STATUS | Load Status |
| PROGRAM_NAME | Concurrent Program_name |
| PROGRAM_APP | CP APPLICATION_SHORT_NAME |
| REQUEST_ID | Concurrent Request_ID |
| LOAD_TYPE | Load Type |
| Application Object Library - FND_DB_SERVICE_MEMBERS | The FND_DB_SERVICE_MEMBERS table tracks the instances that belong to a given DB Service. |
|---|---|
| Column Name | Descritpion |
| DB_SERVICE_GUID | Service GUID. Key into fnd_database_services |
| INSTANCE_TYPE | P referred or A vailable |
| DB_GUID | Technically not needed here, but may simplify some queries |
| CREATED_BY | Standard "who" column |
| CREATION_DATE | Standard "who" column |
| LAST_UPDATED_BY | Standard "who" column |
| LAST_UPDATE_DATE | Standard "who" column |
| LAST_UPDATE_LOGIN | Standard "who" column |
| INSTANCE_GUID | INSTANCE_GUID |
| Application Object Library - FND_DATABASE_SERVICES | FND_DATABASE_SERVICES table tracks the named database services |
|---|---|
| Column Name | Descritpion |
| DB_SERVICE_GUID | Unique idendifier. Needed, since service names typically are named after the database, and may need to change upon cloning |
| DB_GUID | Foreign key to FND_DATABASES |
| SERVICE_NAME | Service_Name |
| DESCRIPTION | Optional description set by user |
| CREATED_BY | Standard "who" column |
| CREATION_DATE | Standard "who" column |
| LAST_UPDATED_BY | Standard "who" column |
| LAST_UPDATE_DATE | Standard "who" column |
| LAST_UPDATE_LOGIN | Standard "who" column |
| Application Object Library - FND_DB_INSTANCE_PARAMS | Instance specific parameters will be saved in this table. |
|---|---|
| Column Name | Descritpion |
| PARAM_NAME | Parameter Name |
| PARAM_VALUE | parameter value |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| INSTANCE_GUID | Instance ID |
| Application Object Library - FND_APP_SERVERS | This table will track the servers used by the E-Business Suite system. This includes the internal server configured by AutoConfig, and any external servers (e.g. Portal installations, OID installations, etc.) referenced by the system. |
|---|---|
| Column Name | Descritpion |
| SERVER_GUID | Standard who column for Apps. |
| CREATION_DATE | Standard who column for Apps. |
| CREATED_BY | Standard who column for Apps |
| LAST_UPDATE_DATE | Standard who column for Apps. |
| LAST_UPDATED_BY | tandard who column for Apps. |
| LAST_UPDATE_LOGIN | Standard who column |
| NODE_ID | Key into fnd_nodes to identify the host upon which the processes for this server run. |
| INTERNAL | Y/N. Is this server internal to the E-Business Suite system (i.e. configured by AutoConfig)? |
| NAME | Unique name for the server. |
| APPL_TOP_GUID | Key into fnd_appl_tops. Only applies to application tier servers. |
| SERVER_TYPE | Type of server. There are two types of internal servers for 11i: DB and APPS. External server types TBD. |
| PRI_ORACLE_HOME | Primary ORACLE_HOME. For an 11i Applications Tier server, this would be the 8.0.6 home against which the Apps are built. For a DB tier server, this would be the DBs ORACLE_HOME. |
| AUX_ORACLE_HOME | Auxiliary ORACLE_HOME. For an 11i Applications Tier server, this is the iAS Oracle Home. Database servers do not have an auxiliary ORACLE_HOME. |
| Application Object Library - FND_APPS_SYSTEM | This lists system level attributes. There will be only one row in this table. That row represents the local system. An exact copy of this table REM could be used in a central repository (e.g. PTS repository) to track multiple systems. |
|---|---|
| Column Name | Descritpion |
| VERSION | Apps version of system. e.g. 11.5.0 |
| OWNER | Name of the Oracle customer that owns this system |
| CSI_NUMBER | CSI Number that covers this system for support. Non-numeric haracters allowed for future flexibility. |
| SYSTEM_GUID | Global unique ID for this system.Will facilitate tracking multiple systems in a central repository, if ever needed. |
| SOURCE_SYSTEM_GUID | GUID of system from which this one was cloned. Used for correlation when this information is rolled up into a central repository. |
| CREATED_BY | Standard who column. |
| CREATION_DATE | Standard who column. |
| LAST_UPDATED_BY | Standard who column. |
| NAME | Unique name for the Applications system. |
| LAST_UPDATE_DATE | Standard who column. |
| LAST_UPDATE_LOGIN | Standard who column. |
| Application Object Library - FND_APPL_TOPS | This table tracks the mount points for the APPL_TOPs in an Applications system. Each mount point has a distinct host and path. A single, physical APPL_TOP (identified by the File_System_GUID) may have multiple mount points, and thus multi |
|---|---|
| Column Name | Descritpion |
| NAME | Internal name of the APPL_TOP |
| NODE_ID | Node of this mount point. Key into fnd_nodes. |
| PATH | Full path to APPL_TOP mount point |
| CREATED_BY | Standard who column. |
| CREATION_DATE | Standard who column. |
| LAST_UPDATED_BY | Standard who column. |
| LAST_UPDATE_DATE | Standard who column. |
| LAST_UPDATE_LOGIN | Standard who column. |
| APPL_TOP_GUID | Unique ID for APPL_TOP mount point. |
| FILE_SYSTEM_GUID | This is a stamp that is written into a central directory in the APPL_TOP. This allows us to identify that two APPL_TOPs found on two different nodes are the same shared file system. |
| SHARED | Is this APPL_TOP shared with other Apps systems? |
| Application Object Library - FND_AM_POOL_STATS | This table holds information about Application Module Pool operations and is mainly intended for performance diagnostics. The data contained in the table can be purged. The table is only populated when the JVM system property FNDAMPOOLSTATS |
|---|---|
| Column Name | Descritpion |
| POOL_NAME | Application module pool name |
| STATE_PASSIVATIONS | Total count of passivations that occured. Excludes non-pool passivation activity or only include passivation that occured by the pool. |
| POOL_CHECKOUTS | Total # of AMs successfully checked out |
| POOL_CHECKINS | Total # of AMs checked in |
| REF_APP_MOD_REUSED | Total # of AMs that the session had affinity to that got checked out |
| REF_APP_MOD_RECYCLED | Total # of AMs that had affinity to another session that got checked out |
| UNREF_APP_MOD_RECYCLED | Total # of AMs that had no affinity to any session that got checked out |
| POOL_CHECK_OUT_FAILURES | Total # of AMs that errored out upon checkout |
| TOTAL_APP_MODS_IN_POOL | Total # of AMs currently in the pool |
| MAX_APP_MODS_IN_POOL | Maximum # of AMs that were in this pool for the lifetime of the pool |
| AVG_APP_MODS_IN_POOL | Average # of AMs that were in this pool for the lifetime of the pool |
| MACHINE_NAME | Middle tier machine name |
| TOTAL_AVAIL_APP_MODS_IN_POOL | Total # of available AMs in the pool for the lifetime of the pool |
| AVG_AVAIL_APP_MODS_IN_POOL | Average # of available AMs in the pool for the lifetime of the pool |
| AVG_UNAVAIL_APP_MODS_IN_POOL | Average # of unavailable AMs in the pool for the lifetime of the pool |
| TOTAL_REF_APP_MOD_INPOOL | Total # of AMs that have affinity to some session |
| REF_INST_UNUSED_FOR_10_MIN | Total # of AMs with affinity that have been inactive for more than 10 minutes (i.e. not "used" by any session) |
| REF_INST_UNUSED_FOR_5_MIN | Total # of AMs with affinity that have been inactive for more than 5 minutes (i.e. not "used" by any session) |
| REF_INST_UNUSED_FOR_1_MIN | Total # of AMs with affinity that have been inactive for more than 1 minutes (i.e. not "used" by any session) |
| REF_INST_USED_DURING_1_MIN | Total # of AMs with affinity that have been checked out within the last minute |
| INST_UNUSED_FOR_10_MIN | Total # of AMs w/out affinity that have been in the pool more than 10 minutes |
| INST_UNUSED_FOR_5_MIN | Total # of AMs w/out affinity that have been in the pool more than 5 minutes |
| JVMID | Java Virtual Machine ID specified through the -DCLIENT_PROCESSID jvm command line parameter |
| INST_UNUSED_FOR_1_MIN | Total # of AMs w/out affinity that have been in the pool more than 1 minutes |
| INST_USED_DURING_LAST_1_MIN | Total # of AMs w/out affinity that have been checked out within the last minute |
| SESS_REGISTERED_WITH_THE_POOL | Total # of SessionCookies that are registered with the pool. SessionCookies represent an ApplicationPool session. An HttpSession may reference more than one SessionCookie. |
| AVG_NUM_OF_SESS_REF_STATE | Average # sessions with affinity to AMS. |
| SESS_INACTIVE_FOR_10_MIN | Total # of sessions that has not performed a checkout for over 10 minutes |
| SESS_INACTIVE_FOR_5_MIN | Total # of sessions that has not performed a checkout for over 5 minutes |
| SESS_INACTIVE_FOR_1_MIN | Total # of sessions that has not performed a checkout for over 1 minutes |
| SESS_ACTIVE_DURING_LAST_1_MIN | Total # of session that has performed a checkout within the last minute |
| TIMESTAMP | Time record was written to table |
| FREE_MEM | Free memory in JVM at time of snapshot |
| TOTAL_MEM | Total memory reserved by JVM at time of snapshot |
| APP_MOD_CREATIONS | Total number of application modules (AMs) created in this pool |
| APP_MOD_REMOVALS | Total number of AMs removed rfom this pool |
| STATE_ACTIVATIONS | Total count of activations that occured. Excludes non-pool activations activity or only include activation that occured by the pool. |
| Application Object Library - FND_CHILD_ANNOTATIONS | Child Annotations for Integration Repository |
|---|---|
| Column Name | Descritpion |
| PARENT_ID | Parent Interface |
| PARENT_FLAG | Parent Type |
| CHILD_FLAG | Annotation Type |
| ANNOTATION_VALUE | Annotation value |
| PARENT_ID2 | Secondary Parent ID |
| Application Object Library - FND_AW_DEF_INTERFACE | |
|---|---|
| Column Name | Descritpion |
| OBJECT_NAME | |
| LAST_UPDATE_LOGIN | |
| STATUS | |
| ERROR_TEXT | |
| OBJECT_TYPE | |
| OBJECT_DEFINITION | |
| OBJECT_OWNER | |
| AW_NAME | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| CREATION_DATE | |
| CREATED_BY |
| Application Object Library - FEM_INTG_DIM_HIER_C4_GT | |
|---|---|
| Column Name | Descritpion |
| PARENT_DEPTH_NUM | |
| CHILD_LEAF_FLAG | |
| PARENT_DISPLAY_CODE | |
| PARENT_ID | |
| CHILD_DEPTH_NUM | |
| CHILD_DISPLAY_CODE | |
| CHILD_ID | |
| SINGLE_DEPTH_FLAG | |
| DISPLAY_ORDER_NUM | |
| DIMENSION_GROUP_ID |
| Application Object Library - FEM_INTG_DIM_HIER_C5_GT | |
|---|---|
| Column Name | Descritpion |
| PARENT_DEPTH_NUM | |
| CHILD_LEAF_FLAG | |
| PARENT_DISPLAY_CODE | |
| PARENT_ID | |
| CHILD_DEPTH_NUM | |
| CHILD_DISPLAY_CODE | |
| CHILD_ID | |
| SINGLE_DEPTH_FLAG | |
| DISPLAY_ORDER_NUM | |
| DIMENSION_GROUP_ID |
| Application Object Library - FND_CP_SQL_REQUESTS | |
|---|---|
| Column Name | Descritpion |
| CLIENT_PROCESS_ID | |
| REQUEST_ID | |
| MACHINE |
| Application Object Library - FND_CONC_REQ_OUTPUTS | This table stores output files created by Concurrent Request. Initial output file generated by Concurrent Request will be stored in FND_CONCURRENT_REQUESTS table and all remaining output files generated Concurrent Request including XML Publ |
|---|---|
| Column Name | Descritpion |
| OUTPUT_ID | Sequence number generated for this output file |
| FILE_TYPE | Represents the output file type |
| FILE_NAME | File name with full path |
| FILE_NODE_NAME | File Node Name |
| FILE_SIZE | File Size |
| ACTION_TYPE | PP_ACTION type will store 6 for XML Publisher output. |
| FILE_CREATION_DATE | File Creation date |
| CONCURRENT_REQUEST_ID | Concurrent Request_ID |
| Application Object Library - FII_AP_HHIST_B_MV | |
|---|---|
| Column Name | Descritpion |
| ROWID_1 | Row identifier from the fii_ap_Hold_hist_b summary table |
| HOLD_DATE | Date on which the hold was placed |
| RELEASE_DATE | Date on which the hold was released |
| MARKER | 1 denotes Hold action and 2 denotes Release action |
| ORG_ID | Operating unit identifier |
| SUPPLIER_ID | Supplier Identifier |
| INVOICE_ID | Invoice identifier |
| SEQ_ID | Sequence identifier for number of holds placed |
| HOLD_TIME_ID | Time identifier when the invoice was placed on hold |
| RELEASE_TIME_ID | Time identifier when the invoice was released. Null if it has not been released |
| PERIOD_TYPE_ID | Period type Identifier |
| Application Object Library - FII_AP_IVATY_B_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00062$ | |
| ORG_ID | Operating Unit Identifier |
| INVOICE_AMT_B | Total invoice amount in base currency |
| SYS_NC00063$ | |
| INVOICE_AMT_BC | Internal aggregation for fast MV refresh |
| PRIM_INVOICE_AMT | Total invoice amount in primary currency |
| SYS_NC00056$ | |
| PRIM_INVOICE_AMTC | Internal aggregation for fast MV refresh |
| SEC_INVOICE_AMT | Total invoice amount in secondary currency |
| SYS_NC00059$ | |
| SEC_INVOICE_AMTC | |
| INVOICE_ENTERED_COUNT | Total number of invoices entered |
| DISTRIBUTION_COUNT | Total number of distributions for each invoice |
| DISTRIBUTION_COUNTC | Internal aggregation for fast MV refresh |
| E_INVOICE_AMT_B | Total electronic invoice amount in base currency |
| SUPPLIER_ID | Supplier Identifier |
| E_INVOICE_AMT_BC | Internal aggregation for fast MV refresh |
| SYS_NC00058$ | |
| PRIM_E_INVOICE_AMT | Total electronic invoice amount in primary currency |
| PRIM_E_INVOICE_AMTC | Internal aggregation for fast MV refresh |
| SEC_E_INVOICE_AMT | Total electronic invoice amount in secondary currency |
| SEC_E_INVOICE_AMTC | Internal aggregation for fast MV refresh |
| E_INVOICE_COUNT | |
| E_INVOICE_COUNTC | |
| E_DISTRIBUTION_COUNT | Total number of distributions for each electronic invoice |
| E_DISTRIBUTION_COUNTC | Internal aggregation for fast MV refresh |
| XML_COUNT | Total number of invoices of source XML GATEWAY |
| ENT_YEAR_ID | Enterprise Year Identifier |
| XML_COUNTC | Internal aggregation for fast MV refresh |
| EDI_COUNT | Total number of invoices of source EDI GATEWAY |
| EDI_COUNTC | Internal aggregation for fast MV refresh |
| ERS_COUNT | Total number of invoices of source ERS |
| ERS_COUNTC | Internal aggregation for fast MV refresh |
| ISP_COUNT | Total number of invoices of source ISP |
| ISP_COUNTC | Internal aggregation for fast MV refresh |
| ASBN_COUNT | Total number of invoices of source ASBN |
| ASBN_COUNTC | Internal aggregation for fast MV refresh |
| OTHER_INTEGRATED_COUNT | Total number of invoices of source other than XML, EDI, ERS, ISP, ASBN |
| ENT_QTR_ID | Enterprise Quarter Identifier |
| OTHER_INTEGRATED_COUNTC | Internal aggregation for fast MV refresh |
| SYS_NC00061$ | |
| STANDARD_COUNT | Total number of invoice of type STANDARD |
| STANDARD_COUNTC | Internal aggregation for fast MV refresh |
| WITHHOLDING_COUNT | Total number of invoices of type AWT |
| WITHHOLDING_COUNTC | Internal aggregation for fast MV refresh |
| PREPAYMENT_COUNT | Total number of invoices of type PREPAYMENT |
| PREPAYMENT_COUNTC | Internal aggregation for fast MV refresh |
| CREDIT_COUNT | Total number of invoice of type CREDIT |
| CREDIT_COUNTC | Internal aggregation for fast MV refresh |
| DEBIT_COUNT | Total number of invoice of type DEBIT |
| ENT_PERIOD_ID | Enterprise Period Identifier |
| DEBIT_COUNTC | Internal aggregation for fast MV refresh |
| MIXED_COUNT | Total number of invoice of type MIXED |
| MIXED_COUNTC | Internal aggregation for fast MV refresh |
| INTEREST_COUNT | Total number of invoice of type INTEREST |
| INTEREST_COUNTC | Internal aggregation for fast MV refresh |
| GID1 | Grouping Identifier |
| WEEK_ID | FII week Identifier |
| SYS_NC00057$ | |
| REPORT_DATE_JULIAN | Reporting date in Julian format |
| TIME_ID | Time Identifier |
| SYS_NC00060$ | |
| PERIOD_TYPE_ID | Period type identifier |
| Application Object Library - FII_AP_LIA_B_MV | |
|---|---|
| Column Name | Descritpion |
| MARKER | H for Hold placed and R for Hold Released |
| UNPAID_COUNT | Total number of unpaid invoices |
| DUE_COUNT | Total number of unpaid invoices which are due |
| PAST_DUE_AMT_B | Total past due invoice amounts in base currency |
| PRIM_PAST_DUE_AMT | Total past due invoice amounts in primary currency |
| SEC_PAST_DUE_AMT | Toal past due invoice amounts in secondary currency |
| PAST_DUE_COUNT | Total number of invoices entered which are past due |
| PAYMENT_AMT_B | Total payment amount in base currency |
| PRIM_PAYMENT_AMT | Total payment amount in primary currency |
| SEC_PAYMENT_AMT | Total payment amount in secondary currency |
| DISCOUNT_OFFERED_B | Total discounts offered in base currency |
| ROW_ID | Row identifier from the fii_ap_inv_holds_b summary table |
| PRIM_DISCOUNT_OFFERED | Total discounts in primary currency |
| SEC_DISCOUNT_OFFERED | Total discounts offered in secondary currency |
| DISCOUNT_REMAINING_B | Total discounts remaining in base currency |
| PRIM_DISCOUNT_REMAINING | Total discounts remaining in primary currency |
| SEC_DISCOUNT_REMAINING | Total discounts remaining in secondary currency |
| DISCOUNT_TAKEN_B | Total discounts taken in base currency |
| PRIM_DISCOUNT_TAKEN | Total discounts taken in primary currency |
| SEC_DISCOUNT_TAKEN | Total discounts taken in secondary currency |
| DISCOUNT_LOST_B | Total discounts lost in base currency |
| PRIM_DISCOUNT_LOST | Total discounts lost in primary currency |
| PS_ROW_ID | Row identifier from the fii_ap_pay_sched_b table |
| SEC_DISCOUNT_LOST | Total discounts lost in secondary currency |
| DUE_BUCKET1_B | Total invoice amounts Due After 30 Days in base currency |
| PRIM_DUE_BUCKET1 | Total invoice amounts Due After 30 Days in primary currency |
| SEC_DUE_BUCKET1 | Total invoice amounts Due After 30 Days in secondary currency |
| DUE_BUCKET1_COUNT | Total number of invoices Due After 30 Days |
| DUE_BUCKET2_B | Total invoice amounts Due in 16 - 30 Days in base currency |
| PRIM_DUE_BUCKET2 | Total invoice amounts Due in 16 - 30 Days in primary currency |
| SEC_DUE_BUCKET2 | Total invoice amounts Due in 16 - 30 Days in secondary currency |
| DUE_BUCKET2_COUNT | Total number of invoices Due in 16 - 30 Days |
| DUE_BUCKET3_B | Total invoice amounts Due in 1 - 15 Days in base currency |
| ORG_ID | Operating Unit Identifier |
| PRIM_DUE_BUCKET3 | Total invoice amounts Due in 1 - 15 Days in primary currency |
| SEC_DUE_BUCKET3 | Total invoice amounts Due in 1 - 15 Days in secondary currency |
| DUE_BUCKET3_COUNT | Total number of invoices Due in 1 - 15 Days |
| PAST_DUE_BUCKET1_B | Total invoice amounts Past Due After 30 Days in base currency |
| PRIM_PAST_DUE_BUCKET1 | Total invoice amounts Past Due After 30 Days in primary currency |
| SEC_PAST_DUE_BUCKET1 | Total invoice amounts Past Due After 30 Days in secondary currency |
| PAST_DUE_BUCKET1_COUNT | Total number of invoices Past Due After 30 Days |
| PAST_DUE_BUCKET2_B | Total invoice amounts Past Due in 16 - 30 Days in base currency |
| PRIM_PAST_DUE_BUCKET2 | Total invoice amounts Past Due in 16 - 30 Days in primary currency |
| SEC_PAST_DUE_BUCKET2 | Total invoice amounts Past Due in 16 - 30 Days in secondary currency |
| SUPPLIER_ID | Supplier Identifier |
| PAST_DUE_BUCKET2_COUNT | Total number of invoices Past Due in 16 - 30 Days |
| PAST_DUE_BUCKET3_B | Total invoice amounts Past Due in 1 - 15 Days in base currency |
| PRIM_PAST_DUE_BUCKET3 | Total invoice amounts Past Due in 1 - 15 Days in primary currency |
| SEC_PAST_DUE_BUCKET3 | Total invoice amounts Past Due in 1 - 15 Days in secondary currency |
| PAST_DUE_BUCKET3_COUNT | Total number of invoices Past Due in 1 - 15 Days |
| ON_TIME_PAYMENT_AMT_B | Total on time payment amounts in base currency |
| PRIM_ON_TIME_PAYMENT_AMT | Total on time payment amounts in primary currency |
| SEC_ON_TIME_PAYMENT_AMT | Total on time payment amounts in secondary currency |
| LATE_PAYMENT_AMT_B | Total late payment amounts in base currency |
| PRIM_LATE_PAYMENT_AMT | Total late payment amounts in primary currency |
| TIME_ID | Time identifier |
| SEC_LATE_PAYMENT_AMT | Total late payment amounts in secondary currency |
| WT_OPEN_DUE_AMT_B | Total weighted due amount in base currency |
| WT_OPEN_DUE_AMT_PRIM_G | Total weighted due amount in primary currency |
| WT_OPEN_DUE_AMT_SEC_G | Total weighted due amount in secondary currency |
| WT_OPEN_PAST_DUE_AMT_B | Total weighted past due amount in base currency |
| WT_OPEN_PAST_DUE_AMT_PRIM_G | Total weighted past due amount in primary currency |
| WT_OPEN_PAST_DUE_AMT_SEC_G | Total weighted past due amount in secondary currency |
| UNPAID_AMT_B | Total unpaid invoice amounts in base currency |
| PRIM_UNPAID_AMT | Total unpaid invoice amounts in primary currency |
| SEC_UNPAID_AMT | Total unpaid invoice amounts in secondary currency |
| Application Object Library - FII_AP_PAID_XB_MV | |
|---|---|
| Column Name | Descritpion |
| ORG_ID | Operating Unit Identifier |
| PAID_INVOICE_AMT_MTD_B | Month to date total paid amount in base currency |
| PAID_INVOICE_AMT_QTD_B | Quarter to date total paid amount in base currency |
| PAID_INVOICE_AMT_YTD_B | Year to date total paid amount in base currency |
| PAID_INVOICE_AMT_WTD_PRIM_G | Week to date total paid amount in primary currency |
| PAID_INVOICE_AMT_MTD_PRIM_G | Month to date total paid amount in primary currency |
| PAID_INVOICE_AMT_QTD_PRIM_G | Quarter to date total paid amount in primary currency |
| PAID_INVOICE_AMT_YTD_PRIM_G | Year to date total paid amount in primary currency |
| PAID_INVOICE_AMT_WTD_SEC_G | Week to date total paid amount in secondary currency |
| PAID_INVOICE_AMT_MTD_SEC_G | Month to date total paid amount in secondary currency |
| PAID_INVOICE_AMT_QTD_SEC_G | Quarter to date total paid amount in secondary currency |
| SUPPLIER_ID | Supplier Identifier |
| PAID_INVOICE_AMT_YTD_SEC_G | Year to date total paid amount in secondary currency |
| PAID_INV_COUNT_WTD | |
| PAID_INV_COUNT_MTD | |
| PAID_INV_COUNT_QTD | |
| PAID_INV_COUNT_YTD | |
| PAYMENT_COUNT_WTD | Week to date total number of payments |
| PAYMENT_COUNT_MTD | Month to date total number of payments |
| PAYMENT_COUNT_QTD | Quarter to date total number of payments |
| PAYMENT_COUNT_YTD | Year to date total number of payments |
| PAID_ON_TIME_AMT_B | Total on time paid amount in base currency |
| TIME_ID | Time Identifier |
| PAID_ON_TIME_AMT_PRIM_G | Total on time paid amount in primary currency |
| PAID_ON_TIME_AMT_SEC_G | Total on time paid amount in secondary currency |
| PAID_LATE_AMT_B | Total late paid amount in base currency |
| PAID_LATE_AMT_PRIM_G | Total late paid amount in primary currency |
| PAID_LATE_AMT_SEC_G | Total late paid amount in secondary currency |
| E_PAYMENT_AMT_B | Total electronic paid amount in base currency |
| E_PAYMENT_AMT_PRIM_G | Total electronic paid amount in primary currency |
| E_PAYMENT_AMT_SEC_G | Total electronic paid amount in secondary currency |
| E_PAYMENT_COUNT | Total number of electronic payments |
| PAID_DIS_OFFERED_WTD_B | Week to date total discounts offered in base currency |
| PERIOD_TYPE_ID | Period Type Identifier |
| PAID_DIS_OFFERED_MTD_B | Month to date total discounts offered in base currency |
| PAID_DIS_OFFERED_QTD_B | Quarter to date total discounts offered in base currency |
| PAID_DIS_OFFERED_YTD_B | Year to date total discounts offered in base currency |
| PAID_DIS_OFFERED_WTD_PRIM_G | Week to date total discounts offered in primary currency |
| PAID_DIS_OFFERED_MTD_PRIM_G | Month to date total discounts offered in primary currency |
| PAID_DIS_OFFERED_QTD_PRIM_G | Quarter to date total discounts offered in primary currency |
| PAID_DIS_OFFERED_YTD_PRIM_G | Year to date total discounts offered in primary currency |
| PAID_DIS_OFFERED_WTD_SEC_G | Week to date total discounts offered in secondary currency |
| PAID_DIS_OFFERED_MTD_SEC_G | Month to date total discounts offered in secondary currency |
| PAID_DIS_OFFERED_QTD_SEC_G | Quarter to date total discounts offered in secondary currency |
| GID | Grouping Identifier |
| PAID_DIS_OFFERED_YTD_SEC_G | Year to date total discounts offered in secondary currency |
| PAID_DIS_TAKEN_B | Total discount taken in base currency |
| PAID_DIS_TAKEN_PRIM_G | Total discount taken in primary currency |
| PAID_DIS_TAKEN_SEC_G | Total discount taken in secondary currency |
| PAID_DIS_LOST_WTD_B | Week to date total discounts lost in base currency |
| PAID_DIS_LOST_MTD_B | Month to date total discounts lost in base currency |
| PAID_DIS_LOST_QTD_B | Quarter to date total discounts lost in base currency |
| PAID_DIS_LOST_YTD_B | Year to date total discounts lost in base currency |
| PAID_DIS_LOST_WTD_PRIM_G | Week to date total discounts lost in primary currency |
| PAID_DIS_LOST_MTD_PRIM_G | Month to date total discounts lost in primary currency |
| PAID_AMT_B | Total paid amount in base currency |
| PAID_DIS_LOST_QTD_PRIM_G | Quarter to date total discounts lost in primary currency |
| PAID_DIS_LOST_YTD_PRIM_G | Year to date total discounts lost in primary currency |
| PAID_DIS_LOST_WTD_SEC_G | Week to date total discounts lost in secondary currency |
| PAID_DIS_LOST_MTD_SEC_G | Month to date total discounts lost in secondary currency |
| PAID_DIS_LOST_QTD_SEC_G | Quarter to date total discounts lost in secondary currency |
| PAID_DIS_LOST_YTD_SEC_G | Year to date total discounts lost in secondary currency |
| INVOICE_TO_PAYMENT_DAYS | Weighted average number of days to pay the invoice |
| PAID_AMT_PRIM_G | Total paid amount in primary currency |
| PAID_AMT_SEC_G | Total paid amount in secondary currency |
| PAID_INVOICE_AMT_WTD_B | Week to date total paid amount in base currency |
| Application Object Library - FII_FA_EXP_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00036$ | |
| ENT_YEAR_ID | |
| TOT_AMOUNT_B | |
| SYS_NC00038$ | |
| TOT_AMOUNT_BC | |
| TOT_PRIM_AMOUNT_G | |
| SYS_NC00028$ | |
| TOT_PRIM_AMOUNT_GC | |
| TOT_SEC_AMOUNT_G | |
| SYS_NC00041$ | |
| TOT_SEC_AMOUNT_GC | |
| COMPANY_ID | |
| SYS_NC00031$ | |
| COST_CENTER_ID | |
| NATURAL_ACCOUNT_ID | |
| SYS_NC00034$ | |
| USER_DIM1_ID | |
| ENT_QTR_ID | |
| USER_DIM2_ID | |
| SYS_NC00037$ | |
| SYS_NC00039$ | |
| ASSET_CAT_ID | |
| ASSET_CAT_MAJOR_ID | |
| SYS_NC00027$ | |
| ASSET_CAT_MINOR_ID | |
| LEDGER_ID | |
| SYS_NC00040$ | |
| GID | |
| CNT | |
| SYS_NC00030$ | |
| SYS_NC00033$ | |
| ENT_PERIOD_ID | |
| REPORT_DATE_JULIAN | |
| SYS_NC00029$ | |
| TIME_ID | |
| PERIOD_TYPE_ID | |
| SYS_NC00032$ | |
| CURRENCY_CODE | |
| TOT_AMOUNT_T | |
| SYS_NC00035$ | |
| TOT_AMOUNT_TC |
| Application Object Library - FII_AP_PAYOL_XB_MV | |
|---|---|
| Column Name | Descritpion |
| ORG_ID | Operating Unit Identifier |
| PAID_LATE_COUNT_WTD | Week to date total number of invoices paid late |
| PAID_LATE_COUNT_MTD | Month to date total number of invoices paid late |
| PAID_LATE_COUNT_QTD | Quarter to date total number of invoices paid late |
| PAID_LATE_COUNT_YTD | Year to date total number of invoices paid late |
| SUPPLIER_ID | Supplier Identifier |
| TIME_ID | Time identifier |
| PERIOD_TYPE_ID | Period Type Identifier |
| GID | Grouping ID used by higherlevel reports |
| PAID_ON_TIME_COUNT_WTD | Week to date total number of invoices paid on time |
| PAID_ON_TIME_COUNT_MTD | Month to date total number of invoices paid on time |
| PAID_ON_TIME_COUNT_QTD | Quarter to date total number of invoices paid on time |
| PAID_ON_TIME_COUNT_YTD | Year to date total number of invoices paid on time |
| Application Object Library - FII_AR_REV_SUM_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00027$ | |
| TIME_ID | |
| PRODUCT_CATEGORY_ID | |
| SYS_NC00028$ | |
| LEDGER_ID | |
| SALES_CHANNEL_CODE | |
| SYS_NC00031$ | |
| ACCT_CURRENCY_CODE | |
| COUNT_GRP | |
| SYS_NC00023$ | |
| REV_ACTUAL_B | |
| COUNT_REV_ACTUAL_B | |
| SYS_NC00026$ | |
| REV_PRIM_ACTUAL_G | |
| COUNT_REV_PRIM_ACTUAL_G | |
| SYS_NC00029$ | |
| REV_SEC_ACTUAL_G | |
| PERIOD_TYPE_ID | |
| COUNT_REV_SEC_ACTUAL_G | |
| SYS_NC00032$ | |
| SYS_NC00030$ | |
| GID | |
| SYS_NC00024$ | |
| REPORT_DATE_JULIAN | |
| ENT_QTR_ID | |
| SYS_NC00033$ | |
| ENT_PERIOD_ID | |
| WEEK_ID | |
| SYS_NC00022$ | |
| ENT_YEAR_ID | |
| LINE_OF_BUSINESS_ID | |
| SYS_NC00025$ | |
| MANAGER_ID |
| Application Object Library - FII_GL_BASE_MAP_MV | |
|---|---|
| Column Name | Descritpion |
| UMARKER | |
| USER_DIM1_ID | |
| USER_DIM2_ID | |
| ACTUAL_B | |
| PRIM_ACTUAL_G | |
| SEC_ACTUAL_G | |
| COMMITTED_AMOUNT_PRIM | |
| OBLIGATED_AMOUNT_PRIM | |
| OTHER_AMOUNT_PRIM | |
| PRIM_BUDGET_G | |
| SEC_BUDGET_G | |
| TIME_ID | |
| PRIM_FORECAST_G | |
| SEC_FORECAST_G | |
| BASELINE_AMOUNT_PRIM | |
| ACTUAL_BCT | |
| PRIM_ACTUAL_GCT | |
| SEC_ACTUAL_GCT | |
| COMMITTED_AMOUNT_PRIMCT | |
| OBLIGATED_AMOUNT_PRIMCT | |
| OTHER_AMOUNT_PRIMCT | |
| PRIM_BUDGET_GCT | |
| PERIOD_TYPE_ID | |
| SEC_BUDGET_GCT | |
| PRIM_FORECAST_GCT | |
| SEC_FORECAST_GCT | |
| BASELINE_AMOUNT_PRIMCT | |
| CT | |
| LEDGER_ID | |
| POSTED_DATE | |
| BUDGET_VERSION_DATE | |
| FIN_CATEGORY_ID | |
| COMPANY_DIM_ID | |
| COST_CENTER_DIM_ID |
| Application Object Library - FII_TIME_CAL_DAY_MV | |
|---|---|
| Column Name | Descritpion |
| REPORT_DATE | |
| CREATION_DATE | |
| LAST_UPDATE_DATE | |
| REPORT_DATE_JULIAN | |
| CALENDAR_ID | |
| CAL_PERIOD_ID | |
| CAL_PERIOD_START_DATE | |
| CAL_QTR_ID | |
| CAL_QTR_START_DATE | |
| CAL_YEAR_ID | |
| CAL_YEAR_START_DATE |
| Application Object Library - FII_GL_BASE_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00036$ | |
| UMARKER | Union ALL marker |
| PRIM_ACTUAL_G | Actual amounts in primary global currency |
| SYS_NC00031$ | |
| SEC_ACTUAL_G | Actual amounts in secondary global currency |
| LINE_OF_BUSINESS_ID | Line of Business Identifier |
| SYS_NC00034$ | |
| FIN_CATEGORY_ID | Financial Category Identifier |
| PRIM_BUDGET_G | Budget amounts in primary global currency |
| SYS_NC00027$ | |
| SEC_BUDGET_G | Budget amounts in secondary global currency |
| PRIM_FORECAST_G | Forecast amounts in primary global currency |
| SYS_NC00030$ | |
| SEC_FORECAST_G | Forecast amounts in secondary global currency |
| FUNCTIONAL_CURRENCY | Functional currency |
| SYS_NC00033$ | |
| ACTUAL_BCT | Internal aggregation for fast refreshable materialized view |
| TIME_ID | Time Identifier |
| PRIM_ACTUAL_GCT | Internal aggregation for fast refreshable materialized view |
| SYS_NC00029$ | |
| SEC_ACTUAL_GCT | Internal aggregation for fast refreshable materialized view |
| PRIM_BUDGET_GCT | Internal aggregation for fast refreshable materialized view |
| SEC_BUDGET_GCT | Internal aggregation for fast refreshable materialized view |
| PRIM_FORECAST_GCT | Internal aggregation for fast refreshable materialized view |
| SEC_FORECAST_GCT | Internal aggregation for fast refreshable materialized view |
| CT | Internal aggregation for fast refreshable materialized view |
| PERIOD_TYPE_ID | Period Type Identifier |
| MANAGER_ID | Manager Identifier |
| SYS_NC00032$ | |
| PRODUCT_CATEGORY_ID | Product Category Identifier |
| COST_CENTER_ORG_ID | Cost Center Organization Identifier |
| SYS_NC00035$ | |
| JE_SOURCE | Journal source |
| LEDGER_ID | Ledger Identifier |
| SYS_NC00028$ | |
| ACTUAL_B | Actual amounts in base currency |
| Application Object Library - FII_AP_HCAT_B_MV | |
|---|---|
| Column Name | Descritpion |
| ROWID_1 | Row identifier from the fii_ap_inv_holds_b summary table |
| USER_DEFINED_COUNT | 1 indicates invoice placed on hold, -1 indicates hold released of category USER_DEFINED |
| OTHER_COUNT | 1 indicates invoice placed on hold, -1 indicates hold released for categories other than PO MATCHING, INVOICE, USER DEFINED, VARIANCE |
| MARKER | H for Hold placed and R for Hold Released |
| ORG_ID | Operating Unit Identifier |
| SUPPLIER_ID | Supplier Identifier |
| TIME_ID | Time identifier |
| PERIOD_TYPE_ID | Period type Identifier |
| VARIANCE_COUNT | 1 indicates invoice placed on hold, -1 indicates hold released of category VARIANCE |
| PO_MATCHING_COUNT | 1 indicates invoice placed on hold, -1 indicates hold released of category PO_MATCHING |
| INVOICE_COUNT | 1 indicates invoice placed on hold, -1 indicates hold released of category INVOICE |
| Application Object Library - FII_AP_HCAT_I_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00027$ | |
| ORG_ID | Operating unit identifier |
| HOLD_RELEASE_FLAG | Flag that indicates if on hold (H) or released (R) |
| SYS_NC00023$ | |
| VARIANCE_HOLD_COUNT | Number of holds of Category VARIANCE |
| VARIANCE_HOLD_COUNTC | Internal aggregation for fast refreshable materialized view |
| SYS_NC00026$ | |
| PO_MATCHING_HOLD_COUNT | Number of holds of Category PO_MATCHING |
| PO_MATCHING_HOLD_COUNTC | Internal aggregation for fast refreshable materialized view |
| SYS_NC00029$ | |
| INVOICE_HOLD_COUNT | Number of holds of Category INVOICE |
| INVOICE_HOLD_COUNTC | Internal aggregation for fast refreshable materialized view |
| SYS_NC00024$ | |
| USER_DEFINED_HOLD_COUNT | Number of holds of Category USER_DEFINED |
| USER_DEFINED_HOLD_COUNTC | Internal aggregation for fast refreshable materialized view |
| OTHER_HOLD_COUNT | Number of holds for categories other than PO MATCHING, INVOICE, VARIANCE, USER DEFINED |
| SUPPLIER_ID | Supplier Identifier |
| OTHER_HOLD_COUNTC | Internal aggregation for fast refreshable materialized view |
| SYS_NC00030$ | |
| CNT | Used for Fast refresh MV to be enabled |
| GID1 | Grouping Identifier |
| ENT_YEAR_ID | Enterprise Year identifier |
| ENT_QTR_ID | Enterprise Quarter identifier |
| SYS_NC00025$ | |
| ENT_PERIOD_ID | Enterprise Period identifier |
| WEEK_ID | FII Week identifier |
| SYS_NC00028$ | |
| REPORT_DATE_JULIAN | Reporting Date in Julian Format |
| TIME_ID | Time identifier |
| SYS_NC00031$ | |
| PERIOD_TYPE_ID | Period type Identifier |
| Application Object Library - FII_AP_HHIST_I_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00018$ | |
| ORG_ID | Operating unit identifier |
| RELEASE_TIME_IDC | Internal aggregation for fast refreshable materialized view |
| RELEASE_DATE | Date on which the hold was released |
| RELEASE_DATEC | Internal aggregation for fast refreshable materialized view |
| SEQ_ID | Sequence id for number of holds placed |
| CNT | Used for Fast refresh MV to be enabled |
| SUPPLIER_ID | Supplier Identifier |
| SYS_NC00016$ | |
| INVOICE_ID | Invoice identifier |
| PERIOD_TYPE_ID | Period type Identifier |
| SYS_NC00019$ | |
| HOLD_TIME_ID | Time identifier when the invoice was placed on hold. |
| HOLD_TIME_IDC | Internal aggregation for fast refreshable materialized view |
| SYS_NC00017$ | |
| HOLD_DATE | Date on which the hold was placed |
| HOLD_DATEC | Internal aggregation for fast refreshable materialized view |
| SYS_NC00015$ | |
| RELEASE_TIME_ID | Time identifier when the invoice was released |
| Application Object Library - FII_GL_AGRT_SUM_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00049$ | |
| TIME_ID | |
| COST_CENTER_DIM_ID | |
| SYS_NC00038$ | |
| PARENT_USER_DIM1_ID | |
| USER_DIM1_ID | |
| SYS_NC00041$ | |
| USER_DIM2_ID | |
| ACTUAL_B | |
| SYS_NC00044$ | |
| PRIM_ACTUAL_G | |
| SEC_ACTUAL_G | |
| SYS_NC00047$ | |
| PRIM_BUDGET_G | |
| SEC_BUDGET_G | |
| SYS_NC00037$ | |
| PRIM_FORECAST_G | |
| PERIOD_TYPE_ID | |
| SEC_FORECAST_G | |
| SYS_NC00040$ | |
| SYS_NC00039$ | |
| COMMITTED_AMOUNT_PRIM | |
| OBLIGATED_AMOUNT_PRIM | |
| SYS_NC00043$ | |
| OTHER_AMOUNT_PRIM | |
| BASELINE_AMOUNT_PRIM | |
| SYS_NC00046$ | |
| ACTUAL_BCT | |
| PRIM_ACTUAL_GCT | |
| SEC_ACTUAL_GCT | |
| PRIM_BUDGET_GCT | |
| SEC_BUDGET_GCT | |
| LEDGER_ID | |
| PRIM_FORECAST_GCT | |
| SEC_FORECAST_GCT | |
| COMMITTED_AMOUNT_PRIMCT | |
| OBLIGATED_AMOUNT_PRIMCT | |
| OTHER_AMOUNT_PRIMCT | |
| BASELINE_AMOUNT_PRIMCT | |
| CT | |
| POSTED_DATE | |
| SYS_NC00042$ | |
| PARENT_FIN_CATEGORY_ID | |
| FIN_CATEGORY_ID | |
| SYS_NC00045$ | |
| PARENT_COMPANY_DIM_ID | |
| COMPANY_DIM_ID | |
| SYS_NC00048$ | |
| PARENT_COST_CENTER_DIM_ID |
| Application Object Library - FII_AP_IVATY_XB_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00056$ | |
| ORG_ID | Operating Unit Identifier |
| INVOICE_AMT_ENTERED_SEC_G | Total invoice amount in scondary currency |
| INVOICE_AMT_ENTERED_SEC_GC | Internal aggregation for fast MV refresh |
| INVOICE_COUNT_ENTERED | Total number of invoices entered |
| INVOICE_COUNT_ENTEREDC | Aggregation function on column for fast MV refresh |
| E_INVOICE_AMT_B | Total electronic invoice amounts in base currency |
| E_INVOICE_AMT_BC | Aggregation function on above column for fast MV refresh |
| E_INVOICE_AMT_PRIM_G | Total electronic invoice amounts in primary currency |
| E_INVOICE_AMT_PRIM_GC | Internal aggregation for fast MV refresh |
| E_INVOICE_AMT_SEC_G | Total electronic invoice amounts in secondary currency |
| E_INVOICE_AMT_SEC_GC | Internal aggregation for fast MV refresh |
| SUPPLIER_ID | Supplier Identifier |
| E_INVOICE_COUNT | Total number of electronic invoices |
| SYS_NC00055$ | |
| E_INVOICE_COUNTC | Internal aggregation for fast MV refresh |
| DISTRIBUTION_COUNT | Total number of distributions of all the invoices |
| DISTRIBUTION_COUNTC | Internal aggregation for fast MV refresh |
| E_DISTRIBUTION_COUNT | Total number of distributions for each electronic invoice |
| E_DISTRIBUTION_COUNTC | Internal aggregation for fast MV refresh |
| XML_COUNT | Total number of invoices of source XML GATEWAY |
| XML_COUNTC | Internal aggregation for fast MV refresh |
| EDI_COUNT | Total number of invoices of source EDI GATEWAY |
| EDI_COUNTC | Internal aggregation for fast MV refresh |
| TIME_ID | Time identifier |
| ERS_COUNT | Total number of invoices of source ERS |
| ERS_COUNTC | Internal aggregation for fast MV refresh |
| ISP_COUNT | Total number of invoices of source ISP |
| ISP_COUNTC | Internal aggregation for fast MV refresh |
| ASBN_COUNT | Total number of invoices of source ASBN |
| ASBN_COUNTC | Internal aggregation for fast MV refresh |
| OTHER_INTEGRATED_COUNT | Total number of invoices of source other than XML, EDI, ERS, ISP, ASBN |
| OTHER_INTEGRATED_COUNTC | Internal aggregation for fast MV refresh |
| STANDARD_COUNT | Total number of invoices of type STANDARD |
| STANDARD_COUNTC | Internal aggregation for fast MV refresh |
| PERIOD_TYPE_ID | Period Type Identifier |
| WITHHOLDING_COUNT | Total number of invoices of type AWT |
| SYS_NC00054$ | |
| WITHHOLDING_COUNTC | Internal aggregation for fast MV refresh |
| PREPAYMENT_COUNT | Total number of invoices of type PREPAYMENT |
| PREPAYMENT_COUNTC | Internal aggregation for fast MV refresh |
| CREDIT_COUNT | Total number of invoices of type CREDIT |
| CREDIT_COUNTC | Internal aggregation for fast MV refresh |
| DEBIT_COUNT | Total number of invoices of type DEBIT |
| DEBIT_COUNTC | Internal aggregation for fast MV refresh |
| MIXED_COUNT | Total number of invoices of type MIXED |
| MIXED_COUNTC | Internal aggregation for fast MV refresh |
| GID | Grouping Identifier |
| INTEREST_COUNT | Total number of invoices of type INTEREST |
| INTEREST_COUNTC | Internal aggregation for fast MV refresh |
| CNT | Aggregation value for fast MV refresh |
| INVOICE_AMT_ENTERED_B | Total invoice amount in base currency |
| SYS_NC00057$ | |
| INVOICE_AMT_ENTERED_BC | Internal aggregation for fast MV refresh |
| INVOICE_AMT_ENTERED_PRIM_G | Total invoice amount in primary currency |
| SYS_NC00053$ | |
| INVOICE_AMT_ENTERED_PRIM_GC | Internal aggregation for fast MV refresh |
| Application Object Library - FII_AP_LIA_I_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00137$ | |
| ORG_ID | Operating Unit Identifier |
| COUNT_ALL | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BKT3_B_CNT | Internal aggregation for fast MV refresh |
| SYS_NC00139$ | |
| OPEN_PAST_DUE_BUCKET3_PRIM_G | Total invoice amounts Past Due in 1 - 15 Days in primary currency |
| OPEN_PAST_DUE_BKT3_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET3_SEC_G | Total invoice amounts Past Due in 1 - 15 Days in secondary currency |
| OPEN_PAST_DUE_BKT3_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET3_COUNT | Total number of invoices Past Due in 1 - 15 Days |
| OPEN_PAST_DUE_BKT3_COUNT_CNT | Internal aggregation for fast MV refresh |
| ON_TIME_PAYMENT_AMT_B | Total on time payment amount in base currency |
| ON_TIME_PAYMENT_AMT_B_CNT | Internal aggregation for fast MV refresh |
| ON_TIME_PAYMENT_AMT_PRIM_G | Total on time payment amount in primary currency |
| OPEN_AMT_B | Total unpaid invoice amount in base currency |
| ON_TIME_PAYMENT_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| ON_TIME_PAYMENT_AMT_SEC_G | Total on time payment amount in secondary currency |
| ON_TIME_PAYMENT_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| LATE_PAYMENT_AMT_B | Total late payment amount in base currency |
| LATE_PAYMENT_AMT_B_CNT | Internal aggregation for fast MV refresh |
| LATE_PAYMENT_AMT_PRIM_G | Total late payment amount in primary currency |
| LATE_PAYMENT_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| LATE_PAYMENT_AMT_SEC_G | Total late payment amount in secondary currency |
| LATE_PAYMENT_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_DUE_AMT_B | Total weighted due amount in base currency |
| OPEN_AMT_B_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_DUE_AMT_B_CNT | Internal aggregation for fast MV refresh |
| SYS_NC00132$ | |
| WT_OPEN_DUE_AMT_PRIM_G | Total weighted due amount in primary currency |
| WT_OPEN_DUE_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_DUE_AMT_SEC_G | Total weighted due amount in secondary currency |
| WT_OPEN_DUE_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_PAST_DUE_AMT_B | Total weighted past due amount in base currency |
| WT_OPEN_PAST_DUE_AMT_B_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_PAST_DUE_AMT_PRIM_G | Total weighted past due amount in primary currency |
| WT_OP_PAST_DUE_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_PAST_DUE_AMT_SEC_G | Total weighted past due amount in secondary currency |
| OPEN_AMT_PRIM_G | Total unpaid invoice amount in primary currency |
| WT_OPEN_PAST_DUE_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| GID1 | Grouping Identifier |
| OPEN_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| SYS_NC00138$ | |
| OPEN_AMT_SEC_G | Total unpaid invoice amount in secondary currency |
| OPEN_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_COUNT | Total number of unpaid invoices |
| OPEN_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_COUNT | Total number of unpaid invoices which are due |
| SUPPLIER_ID | Supplier Identifier |
| OPEN_DUE_COUNT_CNT | Internal aggregation for fast MV refresh |
| SYS_NC00136$ | |
| OPEN_PAST_DUE_AMT_B | Total past due unpaid invoice amount in base currency |
| OPEN_PAST_DUE_AMT_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_AMT_PRIM_G | Total past due unpaid invoice amount in primary currency |
| OPEN_PAST_DUE_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_AMT_SEC_G | Total past due unpaid invoice amount in secondary currency |
| OPEN_PAST_DUE_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_COUNT | Total number of past due unpaid invoices |
| OPEN_PAST_DUE_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAYMENT_AMT_B | Total payment amount on unpaid invoices in base currency |
| ENT_YEAR_ID | Enterprise Year Identifier |
| OPEN_PAYMENT_AMT_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAYMENT_AMT_PRIM_G | Total payment amount on unpaid invoices in primary currency |
| OPEN_PAYMENT_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAYMENT_AMT_SEC_G | Total payment amount on unpaid invoices in secondary currency |
| OPEN_PAYMENT_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_OFFERED_B | Total discounts offered on unpaid invoices in base currency |
| OPEN_DISCOUNT_OFFERED_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_OFFERED_PRIM_G | Total discounts offered on unpaid invoices in primary currency |
| OPEN_DIS_OFFERED_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_OFFERED_SEC_G | Total discounts offered on unpaid invoices in secondary currency |
| ENT_QTR_ID | Enterprise Quarter Identifier |
| OPEN_DIS_OFFERED_SEC_G_CNT | Internal aggregation for fast MV refresj |
| SYS_NC00135$ | |
| OPEN_DISCOUNT_REMAINING_B | Total discounts remaining on unpaid invoices in base currency |
| OPEN_DIS_REMAINING_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_REMAINING_PRIM_G | Total discounts remaining on open invoices in primary currency |
| OPEN_DIS_REMAINING_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_REMAINING_SEC_G | Total discounts remaining on open invoices in secondary currency |
| OPEN_DIS_REMAINING_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_TAKEN_B | Total discounts taken on unpaid invoices in base currency |
| OPEN_DIS_TAKEN_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_TAKEN_PRIM_G | Total discounts taken on unpaid invoices in primary currency |
| ENT_PERIOD_ID | Enterprise Period Identifier |
| OPEN_DIS_TAKEN_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_TAKEN_SEC_G | Total discounts taken on unpaid invoices in secondary currency |
| OPEN_DIS_TAKEN_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_LOST_B | Total discounts lost on unpaid invoices in base currency |
| OPEN_DIS_LOST_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_LOST_PRIM_G | Total discounts lost on unpaid invoices in primary currency |
| OPEN_DIS_LOST_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_LOST_SEC_G | Total discounts lost on unpaid invoices in secondary currency |
| OPEN_DIS_LOST_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET1_B | Total invoice amounts Due After 30 Days in base currency |
| WEEK_ID | FII week Identifier |
| OPEN_DUE_BKT1_B_CNT | Internal aggregation for fast MV refresh |
| SYS_NC00134$ | |
| OPEN_DUE_BUCKET1_PRIM_G | Total invoice amounts Due After 30 Days in primary currency |
| OPEN_DUE_BKT1_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET1_SEC_G | Total invoice amounts Due After 30 Days in secondary currency |
| OPEN_DUE_BKT1_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET1_COUNT | Total number of invoices Due After 30 Days |
| OPEN_DUE_BKT1_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET2_B | Total invoice amounts Due in 16 - 30 Days in base currency |
| OPEN_DUE_BKT2_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET2_PRIM_G | Total invoice amounts Due in 16 - 30 Days in primary currency |
| REPORT_DATE_JULIAN | Reporting date in Julian format |
| OPEN_DUE_BKT2_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET2_SEC_G | Total invoice amounts Due in 16 - 30 Days in secondary currency |
| OPEN_DUE_BKT2_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET2_COUNT | Total number of invoices Due in 16 - 30 Days |
| OPEN_DUE_BKT2_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET3_B | Total invoice amounts Due in 1 - 15 Days in base currency |
| OPEN_DUE_BKT3_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET3_PRIM_G | Total invoice amounts Due in 1 - 15 Days in primary currency |
| OPEN_DUE_BKT3_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET3_SEC_G | Total invoice amounts Due in 1 - 15 Days in secondary currency |
| TIME_ID | Time identifier |
| OPEN_DUE_BKT3_SEC_G_CNT | Internal aggregation for fast MV refresh |
| SYS_NC00133$ | |
| OPEN_DUE_BUCKET3_COUNT | Total number of invoices Due in 1 - 15 Days |
| OPEN_DUE_BKT3_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET1_B | Total invoice amounts Past Due After 30 Days in base currency |
| OPEN_PAST_DUE_BKT1_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET1_PRIM_G | Total invoice amounts Past Due After 30 Days in primary currency |
| OPEN_PAST_DUE_BKT1_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET1_SEC_G | Total invoice amounts Past Due After 30 Days in secondary currency |
| OPEN_PAST_DUE_BKT1_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET1_COUNT | Total number of invoices Past Due After 30 Days |
| PERIOD_TYPE_ID | Period type identifier |
| OPEN_PAST_DUE_BKT1_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET2_B | Total invoice amounts Past Due in 16 - 30 Days in base currency |
| OPEN_PAST_DUE_BKT2_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET2_PRIM_G | Total invoice amounts Past Due in 16 - 30 Days in primary currency |
| OPEN_PAST_DUE_BKT2_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET2_SEC_G | Total invoice amounts Past Due in 16 - 30 Days in secondary currency |
| OPEN_PAST_DUE_BKT2_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET2_COUNT | Total number of invoices Past Due in 16 - 30 Days |
| OPEN_PAST_DUE_BKT2_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET3_B | Total invoice amounts Past Due in 1 - 15 Days in base currency |
| Application Object Library - FII_GL_MGMT_PRD_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00021$ | |
| TIME_ID | Time Identifier |
| PRIM_FORECAST_G | Forecast amounts in primary global currency |
| SEC_FORECAST_G | Forecast amounts in secondary global currency |
| PRIM_ACTUAL_GCT | Internal aggregation for fast refreshable materialized view |
| SEC_ACTUAL_GCT | Internal aggregation for fast refreshable materialized view |
| PRIM_BUDGET_GCT | Internal aggregation for fast refreshable materialized view |
| SEC_BUDGET_GCT | Internal aggregation for fast refreshable materialized view |
| PRIM_FORECAST_GCT | Internal aggregation for fast refreshable materialized view |
| SEC_FORECAST_GCT | Internal aggregation for fast refreshable materialized view |
| CT | Internal aggregation for fast refreshable materialized view |
| PERIOD_TYPE_ID | Period Type Identifier |
| SYS_NC00019$ | |
| MANAGER_ID | Manager Identifier |
| PRODUCT_CATEGORY_ID | Product Category Identifier |
| SYS_NC00022$ | |
| FIN_CATEGORY_ID | Financial Category Identifier |
| PRIM_ACTUAL_G | Actual amounts in primary global currency |
| SYS_NC00020$ | |
| SEC_ACTUAL_G | Actual amounts in secondary global currency |
| PRIM_BUDGET_G | Budget amounts in primary global currency |
| SYS_NC00023$ | |
| SEC_BUDGET_G | Budget amounts in secondary global currency |
| Application Object Library - FII_GL_MGMT_CCC_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00027$ | |
| TIME_ID | Time Identifier |
| FIN_CATEGORY_ID | Financial Category Identifier |
| SYS_NC00029$ | |
| PRIM_BUDGET_G | Budget amounts in primary global currency |
| SEC_BUDGET_G | Budget amounts in secondary global currency |
| SYS_NC00024$ | |
| PRIM_FORECAST_G | Forecast amounts in primary global currency |
| SEC_FORECAST_G | Forecast amounts in secondary global currency |
| ACTUAL_BCT | Internal aggregation for fast refreshable materialized view |
| PRIM_ACTUAL_GCT | Internal aggregation for fast refreshable materialized view |
| SEC_ACTUAL_GCT | Internal aggregation for fast refreshable materialized view |
| PRIM_BUDGET_GCT | Internal aggregation for fast refreshable materialized view |
| SEC_BUDGET_GCT | Internal aggregation for fast refreshable materialized view |
| PERIOD_TYPE_ID | Period Type Identifier |
| PRIM_FORECAST_GCT | Internal aggregation for fast refreshable materialized view |
| SYS_NC00025$ | |
| SEC_FORECAST_GCT | Internal aggregation for fast refreshable materialized view |
| CT | Internal aggregation for fast refreshable materialized view |
| MANAGER_ID | Manager Identifier |
| COST_CENTER_ORG_ID | Cost Center Organization Identifier |
| SYS_NC00028$ | |
| ACTUAL_B | Actual amounts in base currency |
| PRIM_ACTUAL_G | Actual amounts in primary global currency |
| SYS_NC00023$ | |
| SEC_ACTUAL_G | Actual amounts in secondary global currency |
| LINE_OF_BUSINESS_ID | Line of Business Identifier |
| SYS_NC00026$ | |
| PARENT_FIN_CATEGORY_ID | Parent Financial Category Identifier |
| Application Object Library - FII_AP_HCAT_IB_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00021$ | |
| ORG_ID | Operating unit identifier |
| PO_MATCHING_HOLD_COUNTC | Internal aggregation for fast refreshable materialized view |
| SYS_NC00018$ | |
| INVOICE_HOLD_COUNT | Number of holds of Category INVOICE |
| INVOICE_HOLD_COUNTC | Internal aggregation for fast refreshable materialized view |
| USER_DEFINED_HOLD_COUNT | Number of holds of Category USER_DEFINED |
| USER_DEFINED_HOLD_COUNTC | Internal aggregation for fast refreshable materialized view |
| OTHER_HOLD_COUNT | Total number of holds of categories other than VARIANCE, PO MATCHING, INVOICE, USER DEFINED |
| OTHER_HOLD_COUNTC | Internal aggregation for fast refreshable materialized view |
| CNT | Used for Fast refresh MV to be enabled |
| SUPPLIER_ID | Supplier Identifier |
| SYS_NC00019$ | |
| TIME_ID | Time identifier |
| PERIOD_TYPE_ID | Period type Identifier |
| SYS_NC00022$ | |
| HOLD_RELEASE_FLAG | Flag that indicates invoice is on hold (H) or released (R) |
| GID | Grouping Identifier |
| SYS_NC00020$ | |
| VARIANCE_HOLD_COUNT | Number of holds of Category INVOICE |
| VARIANCE_HOLD_COUNTC | Internal aggregation for fast refreshable materialized view |
| SYS_NC00023$ | |
| PO_MATCHING_HOLD_COUNT | Number of holds of Category PO_MATCHING |
| Application Object Library - FII_AP_HHIST_IB_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00013$ | |
| ORG_ID | Operating unit identifier |
| SUM(1) | |
| SYS_NC00020$ | |
| COUNT(1) | |
| COUNT(*) | |
| SYS_NC00015$ | |
| SYS_NC00018$ | |
| SYS_NC00021$ | |
| SUPPLIER_ID | Supplier Identifier |
| SYS_NC00016$ | |
| INVOICE_ID | Invoice identifier |
| PERIOD_TYPE_ID | Period type Identifier |
| SYS_NC00019$ | |
| HOLD_TIME_ID | Time identifier when the invoice was placed on hold |
| HOLD_DATE | Date on which the hold was placed |
| SYS_NC00014$ | |
| RELEASE_TIME_ID | Time identifier when the invoice was released. Null if it has not been released |
| RELEASE_DATE | Date on which the hold was released. |
| SYS_NC00017$ | |
| DAYS_ON_HOLD | Number of days invoice was placed on hold |
| Application Object Library - FII_AP_LIA_IB_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00127$ | |
| ORG_ID | Operating Unit Identifier |
| OPEN_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BKT3_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET3_COUNT | Total number of unpaid invoices Past Due in 1 - 15 Days |
| OPEN_PAST_DUE_BKT3_COUNT_CNT | Internal aggregation for fast MV refresh |
| ON_TIME_PAYMENT_AMT_B | Total on time payment amounts in base currency |
| ON_TIME_PAYMENT_AMT_B_CNT | Internal aggregation for fast MV refresh |
| ON_TIME_PAYMENT_AMT_PRIM_G | Total on time payment amounts in primary currency |
| ON_TIME_PAYMENT_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| ON_TIME_PAYMENT_AMT_SEC_G | Total on time payment amounts in secondary currency |
| ON_TIME_PAYMENT_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| LATE_PAYMENT_AMT_B | Total late payment amounts in base currency |
| OPEN_AMT_SEC_G | Total unpaid invoice amounts in secondary currency |
| LATE_PAYMENT_AMT_B_CNT | Internal aggregation for fast MV refresh |
| LATE_PAYMENT_AMT_PRIM_G | Total late payment amounts in primary currency |
| LATE_PAYMENT_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| LATE_PAYMENT_AMT_SEC_G | Total late payment amounts in secondary currency |
| LATE_PAYMENT_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_DUE_AMT_B | Total weighted unpaid due amount in base currency |
| WT_OPEN_DUE_AMT_B_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_DUE_AMT_PRIM_G | Total weighted unpaid due amount in primary currency |
| WT_OPEN_DUE_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_DUE_AMT_SEC_G | Total weighted unpaid due amount in secondary currency |
| OPEN_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_DUE_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_PAST_DUE_AMT_B | Total weighted unpaid past due amount in base currency |
| WT_OPEN_PAST_DUE_AMT_B_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_PAST_DUE_AMT_PRIM_G | Total weighted unpaid past due amount in primary currency |
| WT_OP_PAST_DUE_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| WT_OPEN_PAST_DUE_AMT_SEC_G | Total weighted unpaid past due amount in secondary currency |
| WT_OPEN_PAST_DUE_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_COUNT | Total number of unpaid invoices |
| OPEN_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_COUNT | Total number of unpaid invoices which are due |
| OPEN_DUE_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_AMT_B | Total past due unpaid invoice amounts in base currency |
| OPEN_PAST_DUE_AMT_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_AMT_PRIM_G | Total past due unpaid invoice amounts in primary currency |
| SUPPLIER_ID | Supplier Identifier |
| OPEN_PAST_DUE_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| SYS_NC00130$ | |
| OPEN_PAST_DUE_AMT_SEC_G | Total past due unpaid invoice amount in secondary currency |
| OPEN_PAST_DUE_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_COUNT | Total number of unpaid invoices which are past due |
| OPEN_PAST_DUE_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAYMENT_AMT_B | Total payment amount on unpaid invoices in base currency |
| OPEN_PAYMENT_AMT_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAYMENT_AMT_PRIM_G | Total payment amount on unpaid invoices in primary currency |
| OPEN_PAYMENT_AMT_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAYMENT_AMT_SEC_G | Total payment amount on unpaid invoices in secondary currency |
| TIME_ID | Time identifier |
| OPEN_PAYMENT_AMT_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_OFFERED_B | Total discounts offered on unpaid invoices in base currency |
| OPEN_DISCOUNT_OFFERED_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_OFFERED_PRIM_G | Total discounts offered on unpaid invoices in primary currency |
| OPEN_DIS_OFFERED_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_OFFERED_SEC_G | Total discounts offered on unpaid invoices in secondary currency |
| OPEN_DIS_OFFERED_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_REMAINING_B | Total discounts remaining on unpaid invoices in base currency |
| OPEN_DIS_REMAINING_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_REMAINING_PRIM_G | Total discounts remaining on unpaid invoices in primary currency |
| PERIOD_TYPE_ID | Period Type Identifier |
| OPEN_DIS_REMAINING_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| SYS_NC00129$ | |
| OPEN_DISCOUNT_REMAINING_SEC_G | Total discounts remaining on unpaid invoices in secondary currency |
| OPEN_DIS_REMAINING_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_TAKEN_B | Total discounts taken on unpaid invoices in base currency |
| OPEN_DIS_TAKEN_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_TAKEN_PRIM_G | Total discounts taken on unpaid invoices in primary currency |
| OPEN_DIS_TAKEN_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_TAKEN_SEC_G | Total discounts taken on unpaid invoices in secondary currency |
| OPEN_DIS_TAKEN_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_LOST_B | Total discounts lost on unpaid invoices in base currency |
| GID | Grouping Identifier |
| OPEN_DIS_LOST_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_LOST_PRIM_G | Total discounts lost on unpaid invoices in primary currency |
| OPEN_DIS_LOST_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DISCOUNT_LOST_SEC_G | Total discounts lost on unpaid invoices in secondary currency |
| OPEN_DIS_LOST_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET1_B | Total unpaid invoice amounts Due After 30 Days in base currency |
| OPEN_DUE_BKT1_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET1_PRIM_G | Total unpaid invoice amount Due After 30 Days in primary currency |
| OPEN_DUE_BKT1_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET1_SEC_G | Total unpaid invoice amounts Due After 30 Days in secondary currency |
| COUNT_ALL | Internal aggregation for fast MV refresh |
| OPEN_DUE_BKT1_SEC_G_CNT | Internal aggregation for fast MV refresh |
| SYS_NC00128$ | |
| OPEN_DUE_BUCKET1_COUNT | Total number of unpaid invoices Due After 30 Days |
| OPEN_DUE_BKT1_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET2_B | Total unpaid invoice amounts Due in 16 - 30 Days in base currency |
| OPEN_DUE_BKT2_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET2_PRIM_G | Total unpaid invoice amounts Due in 16 - 30 Days in primary currency |
| OPEN_DUE_BKT2_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET2_SEC_G | Total unpaid invoice amounts Due in 16 - 30 Days in secondary currency |
| OPEN_DUE_BKT2_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET2_COUNT | Total number of unpaid invoices Due in 16 - 30 Days |
| OPEN_AMT_B | Total unpaid invoice amounts in base currency |
| OPEN_DUE_BKT2_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET3_B | Total unpaid invoice amounts Due in 1 - 15 Days in base currency |
| OPEN_DUE_BKT3_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET3_PRIM_G | Total unpaid invoice amounts Due in 1 - 15 Days in primary currency |
| OPEN_DUE_BKT3_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET3_SEC_G | Total unpaid invoice amounts Due in 1 - 15 Days in secondary currency |
| OPEN_DUE_BKT3_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_DUE_BUCKET3_COUNT | Total number of unpaid invoices Due in 1 - 15 Days |
| OPEN_DUE_BKT3_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET1_B | Total unpaid invoice amounts Past Due After 30 Days in base currency |
| OPEN_AMT_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BKT1_B_CNT | Internal aggregation for fast MV refresh |
| SYS_NC00131$ | |
| OPEN_PAST_DUE_BUCKET1_PRIM_G | Total unpaid invoice amounts Past Due After 30 Days in primary currency |
| OPEN_PAST_DUE_BKT1_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET1_SEC_G | Total unpaid invoice amounts Past Due After 30 Days in secondary currency |
| OPEN_PAST_DUE_BKT1_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET1_COUNT | Total number of unpaid invoices Past Due After 30 Days |
| OPEN_PAST_DUE_BKT1_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET2_B | Total unpaid invoice amounts Past Due in 16 - 30 Days in base currency |
| OPEN_PAST_DUE_BKT2_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET2_PRIM_G | Total unpaid invoice amounts Past Due in 16 - 30 Days in primary currency |
| OPEN_AMT_PRIM_G | Total unpaid invoice amounts in primary currency |
| OPEN_PAST_DUE_BKT2_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET2_SEC_G | Total unpaid invoice amounts Past Due in 16 - 30 Days in secondary currency |
| OPEN_PAST_DUE_BKT2_SEC_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET2_COUNT | Total number of unpaid invoices Past Due in 16 - 30 Days |
| OPEN_PAST_DUE_BKT2_COUNT_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET3_B | Total unpaid invoice amounts Past Due in 1 - 15 Days in base currency |
| OPEN_PAST_DUE_BKT3_B_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET3_PRIM_G | Total unpaid invoice amounts Past Due in 1 - 15 Days in primary currency |
| OPEN_PAST_DUE_BKT3_PRIM_G_CNT | Internal aggregation for fast MV refresh |
| OPEN_PAST_DUE_BUCKET3_SEC_G | Total unpaid invoice amounts Past Due in 1 - 15 Days in secondary currency |
| Application Object Library - FII_AP_MGT_KPI_MV | |
|---|---|
| Column Name | Descritpion |
| ORG_ID | Operating Unit Identifier |
| PAID_INVOICE_AMT_MTD_B | Month to date total paid amount in base currency |
| PAID_INVOICE_AMT_QTD_B | Quarter to date total paid amount in base currency |
| PAID_INVOICE_AMT_YTD_B | Year to date total paid amount in base currency |
| PAID_INVOICE_AMT_WTD_PRIM_G | Week to date paid amount in primary currency |
| PAID_INVOICE_AMT_MTD_PRIM_G | Month to date paid amount in primary currency |
| PAID_INVOICE_AMT_QTD_PRIM_G | Quarter to date paid amount in primary currency |
| PAID_INVOICE_AMT_YTD_PRIM_G | Year to date paid amount in primary currency |
| PAID_INVOICE_AMT_WTD_SEC_G | Week to date paid amount in secondary currency |
| PAID_INVOICE_AMT_MTD_SEC_G | Month to date paid amount in secondary currency |
| PAID_INVOICE_AMT_QTD_SEC_G | Quarter to date paid amount in secondary currency |
| TIME_ID | Time Identifier |
| PAID_INVOICE_AMT_YTD_SEC_G | Year to date paid amount in secondary currency |
| PAID_INV_COUNT_WTD | Week to date number of paid invoices |
| PAID_INV_COUNT_MTD | Month to date number of paid invoices |
| PAID_INV_COUNT_QTD | Quarter to date number of paid invoices |
| PAID_INV_COUNT_YTD | Year to date number of paid invoices |
| PAYMENT_COUNT_WTD | Week to date Total number of payments on all the invoices |
| PAYMENT_COUNT_MTD | Month to date Total number of payments on all the invoices |
| PAYMENT_COUNT_QTD | Quarter to date Total number of payments on all the invoices |
| PAYMENT_COUNT_YTD | Year to date Total number of payments on all the invoices |
| PAID_ON_TIME_AMT_B | Total on time paid amount in base currency |
| PERIOD_TYPE_ID | Period type identifier |
| PAID_ON_TIME_AMT_PRIM_G | Total on time paid amount in primary currency |
| PAID_ON_TIME_AMT_SEC_G | Total on time paid amount in secondary currency |
| PAID_LATE_AMT_B | Total late paid amount in base currency |
| PAID_LATE_AMT_PRIM_G | Total late paid amount in primary currency |
| PAID_LATE_AMT_SEC_G | Total late paid amount in secondary currency |
| PAID_DIS_OFFERED_WTD_B | Week to date total discount offered in base currency |
| PAID_DIS_OFFERED_MTD_B | Month to date discount offered in base currency |
| PAID_DIS_OFFERED_QTD_B | Quarter to date discount offered in base currency |
| PAID_DIS_OFFERED_YTD_B | Year to date discount offered in base currency |
| PAID_DIS_OFFERED_WTD_PRIM_G | Week to date discount offered in primary currency |
| INVOICE_COUNT_ENTERED | Total number of invoices entered |
| PAID_DIS_OFFERED_MTD_PRIM_G | Month to date discount offered in primary currency |
| PAID_DIS_OFFERED_QTD_PRIM_G | Quarter to date discount offered in primary currency |
| PAID_DIS_OFFERED_YTD_PRIM_G | Year to date discount offered in primary currency |
| PAID_DIS_OFFERED_WTD_SEC_G | Week to date discount offered in secondary currency |
| PAID_DIS_OFFERED_MTD_SEC_G | Month to date discount offered in secondary currency |
| PAID_DIS_OFFERED_QTD_SEC_G | Quarter to date discount offered in secondary currency |
| PAID_DIS_OFFERED_YTD_SEC_G | Year to date discount offered in secondary currency |
| PAID_DIS_TAKEN_B | Total discount taken in base currency |
| PAID_DIS_TAKEN_PRIM_G | Total discount taken in primary currency |
| PAID_DIS_TAKEN_SEC_G | Total discount taken in secondary currency |
| E_INVOICE_COUNT | Total number of electronic invoices |
| INVOICE_TO_PAYMENT_DAYS | Average of number of days to pay a invoice |
| PAID_ON_TIME_COUNT_WTD | Week to date number of invoices paid on time |
| PAID_ON_TIME_COUNT_MTD | Month to date number of invoices paid on time |
| PAID_ON_TIME_COUNT_QTD | Quarter to date number of invoices paid on time |
| PAID_ON_TIME_COUNT_YTD | Year to date number of invoices paid on time |
| PAID_LATE_COUNT_WTD | Week to date number of invoices paid late |
| PAID_LATE_COUNT_MTD | Month to date number of invoices paid late |
| PAID_LATE_COUNT_QTD | Quarter to date number of invoices paid late |
| PAID_LATE_COUNT_YTD | Year to date number of invoices paid late |
| PAID_AMT_B | Total paid amount in base currency |
| PAID_AMT_PRIM_G | Total paid amount in the primary currency |
| PAID_AMT_SEC_G | Total paid amount in the secondary currency |
| PAID_INVOICE_AMT_WTD_B | Week to date total paid amount in base currency |
| Application Object Library - FII_GL_MGMT_SUM_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00027$ | |
| TIME_ID | Time Identifier |
| FIN_CATEGORY_ID | Financial Category Identifier |
| SYS_NC00026$ | |
| GID | Group Identifier |
| PRIM_BUDGET_G | Budget amounts in primary global currency |
| SYS_NC00029$ | |
| SEC_BUDGET_G | Budget amounts in secondary global currency |
| PRIM_FORECAST_G | Forecast amounts in primary global currency |
| SYS_NC00024$ | |
| SEC_FORECAST_G | Forecast amounts in secondary global currency |
| ACTUAL_BCT | Internal aggregation for fast refreshable materialized view |
| PRIM_ACTUAL_GCT | Internal aggregation for fast refreshable materialized view |
| SEC_ACTUAL_GCT | Internal aggregation for fast refreshable materialized view |
| PRIM_BUDGET_GCT | Internal aggregation for fast refreshable materialized view |
| PERIOD_TYPE_ID | Period Type Identifier |
| SEC_BUDGET_GCT | Internal aggregation for fast refreshable materialized view |
| SYS_NC00030$ | |
| PRIM_FORECAST_GCT | Internal aggregation for fast refreshable materialized view |
| SEC_FORECAST_GCT | Internal aggregation for fast refreshable materialized view |
| CT | Internal aggregation for fast refreshable materialized view |
| MANAGER_ID | Manager Identifier |
| PERSON_ID | Person Identifier |
| SYS_NC00025$ | |
| ACTUAL_B | Actual amounts in base currency |
| PRIM_ACTUAL_G | Actual amounts in primary global currency |
| SYS_NC00028$ | |
| SEC_ACTUAL_G | Actual amounts in secondary global currency |
| LINE_OF_BUSINESS_ID | Line of Business Identifier |
| SYS_NC00031$ | |
| PARENT_FIN_CATEGORY_ID | Parent Financial Category Identifier |
| Application Object Library - FII_AP_HLIA_IB_MV | |
|---|---|
| Column Name | Descritpion |
| ORG_ID | Operating Unit Identifier |
| ON_HOLD_AMOUNT_B | Total invoices amounts on hold in base currency |
| ON_HOLD_AMOUNT_PRIM_G | Total invoices amounts on hold in primary currency |
| ON_HOLD_AMOUNT_SEC_G | Total invoices amounts on hold in secondary currency |
| ON_HOLD_PAYMENT_AMOUNT_B | Total payments for invoices on hold in base currency |
| ON_HOLD_PAYMENT_AMOUNT_PRIM_G | Total payments for invoices on hold in primary currency |
| ON_HOLD_PAYMENT_AMOUNT_SEC_G | Total payments for invoices on hold in secondary currency |
| ON_HOLD_PAST_DUE_AMOUNT_B | Total past due amount for invoices on hold in base currency |
| ON_HOLD_PAST_DUE_AMOUNT_PRIM_G | Total past due amount for invoices on hold in primary currency |
| ON_HOLD_PAST_DUE_AMOUNT_SEC_G | Total past due amount for invoices on hold in secondary currency |
| ON_HOLD_DIS_OFFERED_B | Total discount offered for invoices on hold in base currency |
| SUPPLIER_ID | Supplier Identifier |
| ON_HOLD_DIS_OFFERED_PRIM_G | Total discount offered for invoices on hold in primary currency |
| ON_HOLD_DIS_OFFERED_SEC_G | Total discount offered for invoices on hold in secondary currency |
| ON_HOLD_DIS_AVAILABLE_B | Total discount available for invoices on hold in base currency |
| ON_HOLD_DIS_AVAILABLE_PRIM_G | Total discount available for invoices on hold in primary currency |
| ON_HOLD_DIS_AVAILABLE_SEC_G | Total discount available for invoices on hold in secondary currency |
| ON_HOLD_DIS_TAKEN_B | Total discount taken for invoices on hold in base currency |
| ON_HOLD_DIS_TAKEN_PRIM_G | Total discount taken for invoices on hold in primary currency |
| ON_HOLD_DIS_TAKEN_SEC_G | Total discount taken for invoices on hold in secondary currency |
| ON_HOLD_DIS_LOST_B | Total discount lost for invoices on hold in base currency |
| ON_HOLD_DIS_LOST_PRIM_G | Total discount lost for invoices on hold in primary currency |
| INVOICE_ID | Invoice Identifier |
| ON_HOLD_DIS_LOST_SEC_G | Total discount lost for invoices on hold in secondary currency |
| NO_OF_HOLDS | Number of Holds placed on the Invoices |
| TIME_ID | Time identifier |
| PERIOD_TYPE_ID | Period Type Identifier |
| HOLD_DATE | Date on which Invoice is placed on hold |
| RELEASE_DATE | Date on which Invoice is released |
| ACTION | Action being performed on the invoice: hold, release, due, due bucket, past bucket, discount and withholding |
| DUE_DATE | Due Date for the Invoice |
| Application Object Library - FII_AP_INV_B_MV | |
|---|---|
| Column Name | Descritpion |
| ORG_ID | Operating Unit Identifier |
| TRX_CURRENCY_CODE | Transaction currency code |
| INVOICE_AMT_T | Invoice amount in transaction currency |
| INVOICE_AMT_B | Invoice amount in base currency |
| INVOICE_AMT_PRIM_G | Invoice amount in primary global currency |
| INVOICE_AMT_SEC_G | Invoice amount in secondary global currency |
| UNPAID_AMT_B | Unpaid amount in base currency |
| UNPAID_AMT_PRIM_G | Unpaid amount in primary global currency |
| UNPAID_AMT_SEC_G | Unpaid amount in secondary global currency |
| PAST_DUE_AMT_B | Past due amount in base currency |
| PAST_DUE_AMT_PRIM_G | Past due amount in primary global currency |
| SUPPLIER_ID | Supplier Identifier |
| PAST_DUE_AMT_SEC_G | Past due amount in secondary global currency |
| ON_HOLD | Flag that denotes whether the invoice is on hold or not. Y - on hold, N - not on hold |
| DAYS_ON_HOLD | Number of days the invoice was on hold throughout its lifecycle |
| DISCOUNT_LOST_B | Discount lost amount in base currency |
| DISCOUNT_LOST_PRIM_G | Discount lost amount in primary global currency |
| DISCOUNT_LOST_SEC_G | Discount lost amount in secondary global currency |
| TERMS_ID | |
| INVOICE_ID | Invoice Identifier |
| INVOICE_NUMBER | Invoice Number |
| INVOICE_TYPE | Invoice Type |
| INVOICE_DATE | Invoice Date |
| ENTERED_DATE | Invoice entered date |
| DUE_DATE | Invoice due date |
| DAYS_PAST_DUE | Number of days past due |
| Application Object Library - FII_AP_HATY_XB_MV | |
|---|---|
| Column Name | Descritpion |
| ORG_ID | Operating unit identifier |
| INV_ON_HOLD_AMT_WTD_PRIM_G | Week to date Amount of Invoices on Hold in primary currency |
| INV_ON_HOLD_AMT_MTD_PRIM_G | Month to date Amount of Invoices on Hold in primary currency |
| INV_ON_HOLD_AMT_QTD_PRIM_G | Quarter to date Amount of Invoices on Hold in primary currency |
| INV_ON_HOLD_AMT_YTD_PRIM_G | Year to date Amount of Invoices on Hold in primary currency |
| INV_ON_HOLD_AMT_WTD_SEC_G | Week to date Amount of Invoices on Hold in Secondary currency |
| INV_ON_HOLD_AMT_MTD_SEC_G | Month to date Amount of Invoices on Hold in Secondary currency |
| INV_ON_HOLD_AMT_QTD_SEC_G | Quarter to date Amount of Invoices on Hold in Secondary currency |
| INV_ON_HOLD_AMT_YTD_SEC_G | Year to date Amount of Invoices on Hold in base currency |
| INV_ON_HOLD_COUNT_WTD | Week to date number of invoices on hold |
| INV_ON_HOLD_COUNT_MTD | Month to date numberof invoices on hold |
| SUPPLIER_ID | Supplier Identifier |
| INV_ON_HOLD_COUNT_QTD | Quarter to date number of invoices on hold |
| INV_ON_HOLD_COUNT_YTD | Year to date number of invoices on hold in year |
| DAYS_ON_HOLD_WTD | Week to date days on Hold |
| DAYS_ON_HOLD_MTD | Month to date days on Hold |
| DAYS_ON_HOLD_QTD | Quarter to date days on Hold |
| DAYS_ON_HOLD_YTD | Year to date days on Hold |
| NO_OF_HOLDS_PLACED | Total number of holds placed |
| TIME_ID | Time identifier |
| PERIOD_TYPE_ID | Period type Identifier |
| GID | Grouping identifier |
| INV_ON_HOLD_AMT_WTD_B | Week to date Amount of Invoices on Hold in base currency |
| INV_ON_HOLD_AMT_MTD_B | Month to date Amount of Invoices on Hold in base currency |
| INV_ON_HOLD_AMT_QTD_B | Quarter to date Amount of Invoices on Hold in base currency |
| INV_ON_HOLD_AMT_YTD_B | Year to date Amount of Invoices on Hold in base currency |
| Application Object Library - FII_AP_HLIA_I_MV | |
|---|---|
| Column Name | Descritpion |
| ORG_ID | Operating Unit Identifier |
| ON_HOLD_DUE_COUNT | Number of Invoices on hold and are due |
| DAYS_ON_HOLD | Number of days Invoice is on hold |
| ON_HOLD_PAYMENT_AMOUNT_B | Total payment amount for invoices on hold in base currency |
| ON_HOLD_PAYMENT_AMOUNT_PRIM_G | Total payment amount for invoices on hold in primary currency |
| ON_HOLD_PAYMENT_AMOUNT_SEC_G | Total payment amount for invoices on hold in secondary currency |
| ON_HOLD_PAST_DUE_AMT_B | Total past due amount for invoices on hold in base currency |
| ON_HOLD_PAST_DUE_AMT_PRIM_G | Total past due amount for invoices on hold in primary currency |
| ON_HOLD_PAST_DUE_AMT_SEC_G | Total past due amount for invoices on hold in secondary currency |
| ON_HOLD_PAST_DUE_COUNT | Number of invoices on hold and are past due |
| ON_HOLD_DIS_REMAINING_B | Total discount remaining for invoices on hold in base currency |
| SUPPLIER_ID | Supplier Identifier |
| ON_HOLD_DIS_REMAINING_PRIM_G | Total discount remaining for invoices on hold in primary currency |
| ON_HOLD_DIS_REMAINING_SEC_G | Total discount remaining for invoices on hold in secondary currency |
| ON_HOLD_DIS_TAKEN_B | Total discount taken for invoices on hold in base currency |
| ON_HOLD_DIS_TAKEN_PRIM_G | Total discount taken for invoices on hold in primary currency |
| ON_HOLD_DIS_TAKEN_SEC_G | Total discount taken for invoices on hold in secondary currency |
| ON_HOLD_DIS_LOST_B | Total discount lost for invoices on hold in base currency |
| ON_HOLD_DIS_LOST_PRIM_G | Total discount lost for invoices on hold in primary currency |
| ON_HOLD_DIS_LOST_SEC_G | Total discount lost for invoices on hold in secondary currency |
| NO_OF_HOLDS | Number of Holds placed on the Invoices |
| TIME_ID | Time identifier |
| PERIOD_TYPE_ID | Period Type Identifier |
| GID | Grouping Identifier |
| INV_ON_HOLD_AMT_B | Total invoice amounts on hold in base currency |
| INV_ON_HOLD_AMT_PRIM_G | Total invoice amounts on hold in primary currency |
| INV_ON_HOLD_AMT_SEC_G | Total invoice amounts on hold in secondary currency |
| INV_ON_HOLD_COUNT | Number of Invoices on hold |
| Application Object Library - FII_AP_LIA_KPI_MV | |
|---|---|
| Column Name | Descritpion |
| ORG_ID | Operating Unit Identifier |
| OPEN_PAST_DUE_AMT_B | Total unpaid past due amount in base currency |
| OPEN_PAST_DUE_AMT_PRIM_G | Total unpaid past due amount in primary currency |
| OPEN_PAST_DUE_AMT_SEC_G | Total unpaid past due amount in secondary currency |
| OPEN_PAST_DUE_COUNT | Total number of unpaid past due invoices |
| OPEN_DISCOUNT_OFFERED_B | Total discounts offered in base currency |
| OPEN_DISCOUNT_OFFERED_PRIM_G | Total discounts offered in primary currency |
| OPEN_DISCOUNT_OFFERED_SEC_G | Total discounts offered in secondary currency |
| OPEN_DISCOUNT_REMAINING_B | Total discounts remaining in base currency |
| OPEN_DISCOUNT_REMAINING_PRIM_G | Total discounts remaining in primary currency |
| OPEN_DISCOUNT_REMAINING_SEC_G | Total discounts remaining in secondary currency |
| TIME_ID | Time identifier |
| INV_ON_HOLD_AMT_B | Total invoices amounts on hold in base currency |
| INV_ON_HOLD_AMT_PRIM_G | Total invoices amounts on hold in primary currency |
| INV_ON_HOLD_AMT_SEC_G | Total invoices amounts on hold in secondary currency |
| INV_ON_HOLD_COUNT | Total Number of Invoices on hold |
| DD_OPEN_DUE_AMT_B | Total weighted average unpaid due amount in base currency |
| DD_OPEN_DUE_AMT_PRIM_G | Total weighted average unpaid due amount in primary currency |
| DD_OPEN_DUE_AMT_SEC_G | Total weighted average unpaid due amount in secondary currency |
| DD_OPEN_PAST_DUE_AMT_B | Total weighted average unpaid past due amount in base currency |
| DD_OPEN_PAST_DUE_AMT_PRIM_G | Total weighted average unpaid past due amount in primary currency |
| DD_OPEN_PAST_DUE_AMT_SEC_G | Total weighted average unpaid past due amount in secondary currency |
| PERIOD_TYPE_ID | Period Type Identifier |
| DUE_DATE | Date date of the invoices |
| OPEN_COUNT | Total number of unpaid invoices |
| OPEN_AMT_B | Total unpaid invoice amounts in base currency |
| OPEN_AMT_PRIM_G | Total unpaid invoice amounts in primary currency |
| OPEN_AMT_SEC_G | Total unpaid invoice amounts in secondary currency |
| OPEN_DUE_COUNT | Total number of unpaid invoices due |
| Application Object Library - FII_AP_INV_PAYMENTS_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00107$ | |
| TIME_ID | |
| PAYMENT_NUM | |
| SEC_OT_PAYMENT_AMT_PMT_CT | |
| SYS_NC00115$ | |
| LATE_PAYMENT_AMT_PMT_CT | |
| LATE_PAYMENT_AMT_B_PMT_CT | |
| PRIM_LATE_PAYMENT_AMT_PMT_CT | |
| SEC_LATE_PAYMENT_AMT_PMT_CT | |
| CT | |
| PAYMENT_METHOD | |
| INV_PYMT_FLAG | |
| SYS_NC00114$ | |
| ORG_ID | |
| SUPPLIER_ID | |
| SYS_NC00113$ | |
| BASE_CURRENCY_CODE | |
| INVOICE_CURRENCY_CODE | |
| SYS_NC00119$ | |
| CHECK_DATE | |
| NO_DAYS_LATE | |
| SYS_NC00109$ | |
| PAYMENT_AMOUNT | |
| PERIOD_TYPE_ID | |
| PAYMENT_AMOUNT_B | |
| SYS_NC00112$ | |
| SYS_NC00120$ | |
| PRIM_PAYMENT_AMOUNT | |
| SEC_PAYMENT_AMOUNT | |
| SYS_NC00118$ | |
| DISCOUNT_TAKEN | |
| DISCOUNT_TAKEN_B | |
| SYS_NC00108$ | |
| PRIM_DISCOUNT_TAKEN | |
| SEC_DISCOUNT_TAKEN | |
| SYS_NC00121$ | |
| OT_PAYMENT_AMT | |
| OT_PAYMENT_AMT_B | |
| SYS_NC00111$ | |
| PRIM_OT_PAYMENT_AMT | |
| ENT_YEAR_ID | |
| SEC_OT_PAYMENT_AMT | |
| SYS_NC00117$ | |
| LATE_PAYMENT_AMT | |
| LATE_PAYMENT_AMT_B | |
| PRIM_LATE_PAYMENT_AMT | |
| SEC_LATE_PAYMENT_AMT | |
| NO_DAYS_LATE_PP | |
| PAYMENT_AMOUNT_PP | |
| PAYMENT_AMOUNT_B_PP | |
| PRIM_PAYMENT_AMOUNT_PP | |
| SEC_PAYMENT_AMOUNT_PP | |
| ENT_QTR_ID | |
| OT_PAYMENT_AMT_PP | |
| SYS_NC00110$ | |
| OT_PAYMENT_AMT_B_PP | |
| PRIM_OT_PAYMENT_AMT_PP | |
| SEC_OT_PAYMENT_AMT_PP | |
| LATE_PAYMENT_AMT_PP | |
| LATE_PAYMENT_AMT_B_PP | |
| PRIM_LATE_PAYMENT_AMT_PP | |
| SEC_LATE_PAYMENT_AMT_PP | |
| NO_DAYS_LATE_PMT | |
| PAYMENT_AMOUNT_PMT | |
| ENT_PERIOD_ID | |
| PAYMENT_AMOUNT_B_PMT | |
| PRIM_PAYMENT_AMOUNT_PMT | |
| SEC_PAYMENT_AMOUNT_PMT | |
| OT_PAYMENT_AMT_PMT | |
| OT_PAYMENT_AMT_B_PMT | |
| PRIM_OT_PAYMENT_AMT_PMT | |
| SEC_OT_PAYMENT_AMT_PMT | |
| LATE_PAYMENT_AMT_PMT | |
| LATE_PAYMENT_AMT_B_PMT | |
| PRIM_LATE_PAYMENT_AMT_PMT | |
| WEEK_ID | |
| SEC_LATE_PAYMENT_AMT_PMT | |
| SYS_NC00116$ | |
| GID | |
| NO_DAYS_LATE_CT | |
| PAYMENT_AMOUNT_CT | |
| PAYMENT_AMOUNT_B_CT | |
| PRIM_PAYMENT_AMOUNT_CT | |
| SEC_PAYMENT_AMOUNT_CT | |
| DISCOUNT_TAKEN_CT | |
| DISCOUNT_TAKEN_B_CT | |
| PRIM_DISCOUNT_TAKEN_CT | |
| REPORT_DATE_JULIAN | |
| SEC_DISCOUNT_TAKEN_CT | |
| OT_PAYMENT_AMT_CT | |
| OT_PAYMENT_AMT_B_CT | |
| PRIM_OT_PAYMENT_AMT_CT | |
| SEC_OT_PAYMENT_AMT_CT | |
| LATE_PAYMENT_AMT_CT | |
| LATE_PAYMENT_AMT_B_CT | |
| PRIM_LATE_PAYMENT_AMT_CT | |
| SEC_LATE_PAYMENT_AMT_CT | |
| NO_DAYS_LATE_PP_CT | |
| CHECK_ID | |
| PAYMENT_AMOUNT_PP_CT | |
| SYS_NC00106$ | |
| PAYMENT_AMOUNT_PP_B_CT | |
| PRIM_PAYMENT_AMOUNT_PP_CT | |
| SEC_PAYMENT_AMOUNT_PP_CT | |
| OT_PAYMENT_AMT_PP_CT | |
| OT_PAYMENT_AMT_B_PP_CT | |
| PRIM_OT_PAYMENT_AMT_PP_CT | |
| SEC_OT_PAYMENT_AMT_PP_CT | |
| LATE_PAYMENT_AMT_PP_CT | |
| LATE_PAYMENT_AMT_B_PP_CT | |
| INVOICE_ID | |
| PRIM_LATE_PAYMENT_AMT_PP_CT | |
| SEC_LATE_PAYMENT_AMT_PP_CT | |
| NO_DAYS_LATE_PMT_CT | |
| PAYMENT_AMOUNT_PMT_CT | |
| PAYMENT_AMOUNT_B_PMT_CT | |
| PRIM_PAYMENT_AMOUNT_PMT_CT | |
| SEC_PAYMENT_AMOUNT_PMT_CT | |
| OT_PAYMENT_AMT_PMT_CT | |
| OT_PAYMENT_AMT_B_PMT_CT | |
| PRIM_OT_PAYMENT_AMT_PMT_CT |
| Application Object Library - FII_AP_PMT_SCHEDULES_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00086$ | |
| TIME_ID | |
| INVOICE_ID | |
| SYS_NC00089$ | |
| PAYMENT_NUM | |
| BASE_CURRENCY_CODE | |
| SYS_NC00092$ | |
| DUE_DATE | |
| INVOICE_CURRENCY_CODE | |
| SYS_NC00082$ | |
| ORIGINAL_AMT | |
| ORIGINAL_AMT_B | |
| SYS_NC00088$ | |
| PRIM_ORIGINAL_AMT | |
| SEC_ORIGINAL_AMT | |
| SYS_NC00091$ | |
| PAST_DUE_AMOUNT | |
| PERIOD_TYPE_ID | |
| PAST_DUE_AMOUNT_B | |
| SYS_NC00081$ | |
| SYS_NC00085$ | |
| PRIM_PAST_DUE_AMOUNT | |
| SEC_PAST_DUE_AMOUNT | |
| SYS_NC00087$ | |
| AMOUNT_REMAINING | |
| AMOUNT_REMAINING_B | |
| SYS_NC00090$ | |
| PRIM_AMOUNT_REMAINING | |
| SEC_AMOUNT_REMAINING | |
| DISCOUNT_AVAILABLE | |
| DISCOUNT_AVAILABLE_B | |
| PRIM_DISCOUNT_AVAILABLE | |
| ENT_YEAR_ID | |
| SEC_DISCOUNT_AVAILABLE | |
| DISCOUNT_LOST | |
| DISCOUNT_LOST_B | |
| PRIM_DISCOUNT_LOST | |
| SEC_DISCOUNT_LOST | |
| DISCOUNT_TAKEN | |
| DISCOUNT_TAKEN_B | |
| PRIM_DISCOUNT_TAKEN | |
| SEC_DISCOUNT_TAKEN | |
| AMOUNT_REMAINING_PP | |
| ENT_QTR_ID | |
| AMOUNT_REMAINING_B_PP | |
| SYS_NC00084$ | |
| PRIM_AMOUNT_REMAINING_PP | |
| SEC_AMOUNT_REMAINING_PP | |
| AMOUNT_REMAINING_PMT | |
| AMOUNT_REMAINING_B_PMT | |
| PRIM_AMOUNT_REMAINING_PMT | |
| SEC_AMOUNT_REMAINING_PMT | |
| GID | |
| ORIGINAL_AMT_CT | |
| ORIGINAL_AMT_B_CT | |
| ENT_PERIOD_ID | |
| PRIM_ORIGINAL_AMT_CT | |
| SEC_ORIGINAL_AMT_CT | |
| PAST_DUE_AMOUNT_CT | |
| PAST_DUE_AMOUNT_B_CT | |
| PRIM_PAST_DUE_AMOUNT_CT | |
| SEC_PAST_DUE_AMOUNT_CT | |
| AMOUNT_REMAINING_CT | |
| AMOUNT_REMAINING_B_CT | |
| PRIM_AMOUNT_REMAINING_CT | |
| SEC_AMOUNT_REMAINING_CT | |
| WEEK_ID | |
| DISCOUNT_AVAILABLE_CT | |
| SYS_NC00093$ | |
| DISCOUNT_AVAILABLE_B_CT | |
| PRIM_DISCOUNT_AVAILABLE_CT | |
| SEC_DISCOUNT_AVAILABLE_CT | |
| DISCOUNT_LOST_CT | |
| DISCOUNT_LOST_B_CT | |
| PRIM_DISCOUNT_LOST_CT | |
| SEC_DISCOUNT_LOST_CT | |
| DISCOUNT_TAKEN_CT | |
| DISCOUNT_TAKEN_B_CT | |
| REPORT_DATE_JULIAN | |
| PRIM_DISCOUNT_TAKEN_CT | |
| SEC_DISCOUNT_TAKEN_CT | |
| AMOUNT_REMAINING_PP_CT | |
| AMOUNT_REMAINING_B_PP_CT | |
| PRIM_AMOUNT_REMAINING_PP_CT | |
| SEC_AMOUNT_REMAINING_PP_CT | |
| AMOUNT_REMAINING_PMT_CT | |
| AMOUNT_REMAINING_B_PMT_CT | |
| PRIM_AMOUNT_REMAINING_PMT_CT | |
| SEC_AMOUNT_REMAINING_PMT_CT | |
| ORG_ID | |
| CT | |
| SYS_NC00083$ | |
| SUPPLIER_ID |
| Application Object Library - FII_GL_TREND_SUM_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00036$ | |
| TIME_ID | |
| FIN_CATEGORY_DIM_ID | |
| TOP_NODE_FIN_CAT_TYPE | |
| ACTUAL_B | |
| PRIM_ACTUAL_G | |
| SEC_ACTUAL_G | |
| PRIM_BUDGET_G | |
| SEC_BUDGET_G | |
| PRIM_FORECAST_G | |
| SEC_FORECAST_G | |
| COMMITTED_AMOUNT_PRIM | |
| PERIOD_TYPE_ID | |
| OBLIGATED_AMOUNT_PRIM | |
| OTHER_AMOUNT_PRIM | |
| BASELINE_AMOUNT_PRIM | |
| ACTUAL_BCT | |
| PRIM_ACTUAL_GCT | |
| SEC_ACTUAL_GCT | |
| PRIM_BUDGET_GCT | |
| SEC_BUDGET_GCT | |
| PRIM_FORECAST_GCT | |
| SEC_FORECAST_GCT | |
| BUDGET_VERSION_DATE | |
| COMMITTED_AMOUNT_PRIMCT | |
| OBLIGATED_AMOUNT_PRIMCT | |
| OTHER_AMOUNT_PRIMCT | |
| BASELINE_AMOUNT_PRIMCT | |
| CT | |
| POSTED_DATE | |
| SYS_NC00039$ | |
| SYS_NC00042$ | |
| PARENT_COMPANY_DIM_ID | |
| SYS_NC00045$ | |
| SYS_NC00035$ | |
| SYS_NC00038$ | |
| SYS_NC00041$ | |
| SYS_NC00044$ | |
| COMPANY_DIM_ID | |
| SYS_NC00037$ | |
| SYS_NC00040$ | |
| SYS_NC00043$ | |
| PARENT_COST_CENTER_DIM_ID | |
| COST_CENTER_DIM_ID | |
| PARENT_FIN_CATEGORY_DIM_ID |
| Application Object Library - FII_GL_BASE_MAP2_MV | |
|---|---|
| Column Name | Descritpion |
| UMARKER | |
| PRIM_ACTUAL_G | |
| SEC_ACTUAL_G | |
| PRIM_BUDGET_G | |
| SEC_BUDGET_G | |
| PRIM_FORECAST_G | |
| SEC_FORECAST_G | |
| ACTUAL_BCT | |
| PRIM_ACTUAL_GCT | |
| SEC_ACTUAL_GCT | |
| PRIM_BUDGET_GCT | |
| TIME_ID | |
| SEC_BUDGET_GCT | |
| PRIM_FORECAST_GCT | |
| SEC_FORECAST_GCT | |
| CT | |
| PERIOD_TYPE_ID | |
| LEDGER_ID | |
| FIN_CAT_TYPE_CODE | |
| FIN_CATEGORY_ID | |
| COMPANY_DIM_ID | |
| COST_CENTER_DIM_ID | |
| ACTUAL_B |
| Application Object Library - FII_GL_AGRT_SUM2_MV | |
|---|---|
| Column Name | Descritpion |
| SYS_NC00027$ | |
| TIME_ID | |
| COST_CENTER_DIM_ID | |
| ACTUAL_B | |
| PRIM_ACTUAL_G | |
| SEC_ACTUAL_G | |
| PRIM_BUDGET_G | |
| SEC_BUDGET_G | |
| PRIM_FORECAST_G | |
| SEC_FORECAST_G | |
| ACTUAL_BCT | |
| PRIM_ACTUAL_GCT | |
| PERIOD_TYPE_ID | |
| SEC_ACTUAL_GCT | |
| PRIM_BUDGET_GCT | |
| SEC_BUDGET_GCT | |
| SYS_NC00030$ | |
| PRIM_FORECAST_GCT | |
| SEC_FORECAST_GCT | |
| SYS_NC00033$ | |
| CT | |
| SYS_NC00028$ | |
| SYS_NC00031$ | |
| LEDGER_ID | |
| SYS_NC00034$ | |
| SYS_NC00026$ | |
| SYS_NC00029$ | |
| SYS_NC00032$ | |
| SYS_NC00035$ | |
| FIN_CAT_TYPE_CODE | |
| PARENT_FIN_CATEGORY_ID | |
| FIN_CATEGORY_ID | |
| PARENT_COMPANY_DIM_ID | |
| COMPANY_DIM_ID | |
| PARENT_COST_CENTER_DIM_ID |
| Application Object Library - FEM_INTG_GL_WRTBK_BAL_GT | |
|---|---|
| Column Name | Descritpion |
| ROW_ID | |
| NATURAL_ACCOUNT_ID | |
| CHANNEL_ID | |
| LINE_ITEM_ID | |
| PROJECT_ID | |
| CUSTOMER_ID | |
| ENTITY_ID | |
| INTERCOMPANY_ID | |
| TASK_ID | |
| USER_DIM1_ID | |
| USER_DIM2_ID | |
| CODE_COMBINATION_ID | |
| USER_DIM3_ID | |
| USER_DIM4_ID | |
| USER_DIM5_ID | |
| USER_DIM6_ID | |
| USER_DIM7_ID | |
| USER_DIM8_ID | |
| USER_DIM9_ID | |
| USER_DIM10_ID | |
| PTD_DEBIT_BALANCE_E | |
| PTD_CREDIT_BALANCE_E | |
| COMPANY_COST_CENTER_ORG_ID | |
| VS_MAPPED_FLAG | |
| CURRENCY_CODE | |
| CURRENCY_TYPE_CODE | |
| ACTIVITY_ID | |
| COST_OBJECT_ID | |
| FINANCIAL_ELEM_ID | |
| PRODUCT_ID |
| Application Object Library - FII_AR_NET_REC_INTR_MV | |
|---|---|
| Column Name | Descritpion |
| UMARKER | |
| PARENT_PARTY_ID | |
| APP_AMOUNT_FUNC | |
| APP_AMOUNT_PRIM | |
| APP_AMOUNT_SEC | |
| APP_COUNT | |
| ON_ACCOUNT_CASH_AMOUNT_FUNC | |
| ON_ACCOUNT_CASH_AMOUNT_PRIM | |
| ON_ACCOUNT_CASH_AMOUNT_SEC | |
| PREPAYMENT_AMOUNT_FUNC | |
| PREPAYMENT_AMOUNT_PRIM | |
| PREPAYMENT_AMOUNT_SEC | |
| PARTY_ID | |
| CLAIM_AMOUNT_FUNC | |
| CLAIM_AMOUNT_PRIM | |
| CLAIM_AMOUNT_SEC | |
| REV_AMOUNT_FUNC | |
| REV_AMOUNT_PRIM | |
| REV_AMOUNT_SEC | |
| REV_COUNT | |
| TOTAL_RECEIPT_AMOUNT_FUNC | |
| TOTAL_RECEIPT_AMOUNT_PRIM | |
| TOTAL_RECEIPT_AMOUNT_SEC | |
| CUST_ACCOUNT_ID | |
| TOTAL_RECEIPT_COUNT | |
| EARNED_DISCOUNT_AMOUNT_FUNC | |
| EARNED_DISCOUNT_AMOUNT_PRIM | |
| EARNED_DISCOUNT_AMOUNT_SEC | |
| UNEARNED_DISCOUNT_AMOUNT_FUNC | |
| UNEARNED_DISCOUNT_AMOUNT_PRIM | |
| UNEARNED_DISCOUNT_AMOUNT_SEC | |
| AVG_DD_NUM_FUNC | |
| AVG_DD_NUM_PRIM | |
| AVG_DD_NUM_SEC | |
| COLLECTOR_ID | |
| WTD_DAYS_PAID_NUM_FUNC | |
| WTD_DAYS_PAID_NUM_PRIM | |
| WTD_DAYS_PAID_NUM_SEC | |
| WTD_TERMS_PAID_NUM_FUNC | |
| WTD_TERMS_PAID_NUM_PRIM | |
| WTD_TERMS_PAID_NUM_SEC | |
| BILLED_AMOUNT_FUNC | |
| BILLED_AMOUNT_PRIM | |
| BILLED_AMOUNT_SEC | |
| BILLING_ACTIVITY_AMOUNT_FUNC | |
| ORG_ID | |
| BILLING_ACTIVITY_AMOUNT_PRIM | |
| BILLING_ACTIVITY_AMOUNT_SEC | |
| BILLING_ACTIVITY_COUNT | |
| CURRENT_BUCKET_1_AMT_FUNC_CT | |
| CURRENT_BUCKET_1_AMT_PRIM_CT | |
| CURRENT_BUCKET_1_AMT_SEC_CT | |
| CURRENT_BUCKET_1_COUNT_CT | |
| CURRENT_BUCKET_2_AMT_FUNC_CT | |
| CURRENT_BUCKET_2_AMT_PRIM_CT | |
| CURRENT_BUCKET_2_AMT_SEC_CT | |
| CLASS_CODE | |
| CURRENT_BUCKET_2_COUNT_CT | |
| CURRENT_BUCKET_3_AMT_FUNC_CT | |
| CURRENT_BUCKET_3_AMT_PRIM_CT | |
| CURRENT_BUCKET_3_AMT_SEC_CT | |
| CURRENT_BUCKET_3_COUNT_CT | |
| PAST_DUE_BUCKET_1_AMT_FUNC_CT | |
| PAST_DUE_BUCKET_1_AMT_PRIM_CT | |
| PAST_DUE_BUCKET_1_AMT_SEC_CT | |
| PAST_DUE_BUCKET_1_COUNT_CT | |
| PAST_DUE_BUCKET_2_AMT_FUNC_CT | |
| CLASS_CATEGORY | |
| PAST_DUE_BUCKET_2_AMT_PRIM_CT | |
| PAST_DUE_BUCKET_2_AMT_SEC_CT | |
| PAST_DUE_BUCKET_2_COUNT_CT | |
| PAST_DUE_BUCKET_3_AMT_FUNC_CT | |
| PAST_DUE_BUCKET_3_AMT_PRIM_CT | |
| PAST_DUE_BUCKET_3_AMT_SEC_CT | |
| PAST_DUE_BUCKET_3_COUNT_CT | |
| PAST_DUE_BUCKET_4_AMT_FUNC_CT | |
| PAST_DUE_BUCKET_4_AMT_PRIM_CT | |
| PAST_DUE_BUCKET_4_AMT_SEC_CT | |
| HEADER_FILTER_DATE | |
| PAST_DUE_BUCKET_4_COUNT_CT | |
| PAST_DUE_BUCKET_5_AMT_FUNC_CT | |
| PAST_DUE_BUCKET_5_AMT_PRIM_CT | |
| PAST_DUE_BUCKET_5_AMT_SEC_CT | |
| PAST_DUE_BUCKET_5_COUNT_CT | |
| PAST_DUE_BUCKET_6_AMT_FUNC_CT | |
| PAST_DUE_BUCKET_6_AMT_PRIM_CT | |
| PAST_DUE_BUCKET_6_AMT_SEC_CT | |
| PAST_DUE_BUCKET_6_COUNT_CT | |
| PAST_DUE_BUCKET_7_AMT_FUNC_CT | |
| CURRENT_BUCKET_1_AMOUNT_FUNC | |
| PAST_DUE_BUCKET_7_AMT_PRIM_CT | |
| PAST_DUE_BUCKET_7_AMT_SEC_CT | |
| PAST_DUE_BUCKET_7_COUNT_CT | |
| CURRENT_OPEN_AMT_FUNC_CT | |
| CURRENT_OPEN_AMT_PRIM_CT | |
| CURRENT_OPEN_AMT_SEC_CT | |
| CURRENT_OPEN_COUNT_CT | |
| PAST_DUE_OPEN_AMT_FUNC_CT | |
| PAST_DUE_OPEN_AMT_PRIM_CT | |
| PAST_DUE_OPEN_AMT_SEC_CT | |
| CURRENT_BUCKET_1_AMOUNT_PRIM | |
| PAST_DUE_COUNT_CT | |
| WTD_TERMS_OUT_OPEN_NUM_FUNC_CT | |
| WTD_TERMS_OUT_OPEN_NUM_PRIM_CT | |
| WTD_TERMS_OUT_OPEN_NUM_SEC_CT | |
| WTD_TERMS_OUT_CRT_NUM_FUNC_CT | |
| WTD_TERMS_OUT_CRT_NUM_PRIM_CT | |
| WTD_TERMS_OUT_CRT_NUM_SEC_CT | |
| WTD_DDSO_DUE_NUM_FUNC_CT | |
| WTD_DDSO_DUE_NUM_PRIM_CT | |
| WTD_DDSO_DUE_NUM_SEC_CT | |
| ENT_YEAR_ID | |
| CURRENT_BUCKET_1_AMOUNT_SEC | |
| TOTAL_OPEN_AMT_FUNC_CT | |
| TOTAL_OPEN_AMT_PRIM_CT | |
| TOTAL_OPEN_AMT_SEC_CT | |
| TOTAL_OPEN_COUNT_CT | |
| INV_AMT_FUNC_CT | |
| INV_AMT_PRIM_CT | |
| INV_AMT_SEC_CT | |
| DM_AMT_FUNC_CT | |
| DM_AMT_PRIM_CT | |
| DM_AMT_SEC_CT | |
| CURRENT_BUCKET_1_COUNT | |
| CB_AMT_FUNC_CT | |
| CB_AMT_PRIM_CT | |
| CB_AMT_SEC_CT | |
| BR_AMT_FUNC_CT | |
| BR_AMT_PRIM_CT | |
| BR_AMT_SEC_CT | |
| DEP_AMT_FUNC_CT | |
| DEP_AMT_PRIM_CT | |
| DEP_AMT_SEC_CT | |
| ON_ACCOUNT_CREDIT_AMT_FUNC_CT | |
| CURRENT_BUCKET_2_AMOUNT_FUNC | |
| ON_ACCOUNT_CREDIT_AMT_PRIM_CT | |
| ON_ACCOUNT_CREDIT_AMT_SEC_CT | |
| UNAPP_DEP_AMT_FUNC_CT | |
| UNAPP_DEP_AMT_PRIM_CT | |
| UNAPP_DEP_AMT_SEC_CT | |
| APP_AMT_FUNC_CT | |
| APP_AMT_PRIM_CT | |
| APP_AMT_SEC_CT | |
| APP_COUNT_CT | |
| ON_ACCOUNT_CASH_AMT_FUNC_CT | |
| CURRENT_BUCKET_2_AMOUNT_PRIM | |
| ON_ACCOUNT_CASH_AMT_PRIM_CT | |
| ON_ACCOUNT_CASH_AMT_SEC_CT | |
| PREPAYMENT_AMT_FUNC_CT | |
| PREPAYMENT_AMT_PRIM_CT | |
| PREPAYMENT_AMT_SEC_CT | |
| CLAIM_AMT_FUNC_CT | |
| CLAIM_AMT_PRIM_CT | |
| CLAIM_AMT_SEC_CT | |
| REV_AMT_FUNC_CT | |
| REV_AMT_PRIM_CT | |
| CURRENT_BUCKET_2_AMOUNT_SEC | |
| REV_AMT_SEC_CT | |
| REV_COUNT_CT | |
| TOTAL_RECEIPT_AMT_FUNC_CT | |
| TOTAL_RECEIPT_AMT_PRIM_CT | |
| TOTAL_RECEIPT_AMT_SEC_CT | |
| TOTAL_RECEIPT_COUNT_CT | |
| EARNED_DISCOUNT_AMT_FUNC_CT | |
| EARNED_DISCOUNT_AMT_PRIM_CT | |
| EARNED_DISCOUNT_AMT_SEC_CT | |
| UNEARNED_DISCOUNT_AMT_FUNC_CT | |
| CURRENT_BUCKET_2_COUNT | |
| UNEARNED_DISCOUNT_AMT_PRIM_CT | |
| UNEARNED_DISCOUNT_AMT_SEC_CT | |
| AVG_DD_NUM_FUNC_CT | |
| AVG_DD_NUM_PRIM_CT | |
| AVG_DD_NUM_SEC_CT | |
| WTD_DAYS_PAID_NUM_FUNC_CT | |
| WTD_DAYS_PAID_NUM_PRIM_CT | |
| WTD_DAYS_PAID_NUM_SEC_CT | |
| WTD_TERMS_PAID_NUM_FUNC_CT | |
| WTD_TERMS_PAID_NUM_PRIM_CT | |
| CURRENT_BUCKET_3_AMOUNT_FUNC | |
| WTD_TERMS_PAID_NUM_SEC_CT | |
| BILLED_AMT_FUNC_CT | |
| BILLED_AMT_PRIM_CT | |
| BILLED_AMT_SEC_CT | |
| BILLING_ACTIVITY_AMT_FUNC_CT | |
| BILLING_ACTIVITY_AMT_PRIM_CT | |
| BILLING_ACTIVITY_AMT_SEC_CT | |
| BILLING_ACTIVITY_COUNT_CT | |
| CT | |
| CURRENT_BUCKET_3_AMOUNT_PRIM | |
| CURRENT_BUCKET_3_AMOUNT_SEC | |
| CURRENT_BUCKET_3_COUNT | |
| ENT_QTR_ID | |
| PAST_DUE_BUCKET_1_AMOUNT_FUNC | |
| PAST_DUE_BUCKET_1_AMOUNT_PRIM | |
| PAST_DUE_BUCKET_1_AMOUNT_SEC | |
| PAST_DUE_BUCKET_1_COUNT | |
| PAST_DUE_BUCKET_2_AMOUNT_FUNC | |
| PAST_DUE_BUCKET_2_AMOUNT_PRIM | |
| PAST_DUE_BUCKET_2_AMOUNT_SEC | |
| PAST_DUE_BUCKET_2_COUNT | |
| PAST_DUE_BUCKET_3_AMOUNT_FUNC | |
| PAST_DUE_BUCKET_3_AMOUNT_PRIM | |
| ENT_PERIOD_ID | |
| PAST_DUE_BUCKET_3_AMOUNT_SEC | |
| PAST_DUE_BUCKET_3_COUNT | |
| PAST_DUE_BUCKET_4_AMOUNT_FUNC | |
| PAST_DUE_BUCKET_4_AMOUNT_PRIM | |
| PAST_DUE_BUCKET_4_AMOUNT_SEC | |
| PAST_DUE_BUCKET_4_COUNT | |
| PAST_DUE_BUCKET_5_AMOUNT_FUNC | |
| PAST_DUE_BUCKET_5_AMOUNT_PRIM | |
| PAST_DUE_BUCKET_5_AMOUNT_SEC | |
| PAST_DUE_BUCKET_5_COUNT | |
| ENT_WEEK_ID | |
| PAST_DUE_BUCKET_6_AMOUNT_FUNC | |
| PAST_DUE_BUCKET_6_AMOUNT_PRIM | |
| PAST_DUE_BUCKET_6_AMOUNT_SEC | |
| PAST_DUE_BUCKET_6_COUNT | |
| PAST_DUE_BUCKET_7_AMOUNT_FUNC | |
| PAST_DUE_BUCKET_7_AMOUNT_PRIM | |
| PAST_DUE_BUCKET_7_AMOUNT_SEC | |
| PAST_DUE_BUCKET_7_COUNT | |
| CURRENT_OPEN_AMOUNT_FUNC | |
| CURRENT_OPEN_AMOUNT_PRIM | |
| REPORT_DATE_JULIAN | |
| CURRENT_OPEN_AMOUNT_SEC | |
| CURRENT_OPEN_COUNT | |
| PAST_DUE_OPEN_AMOUNT_FUNC | |
| PAST_DUE_OPEN_AMOUNT_PRIM | |
| PAST_DUE_OPEN_AMOUNT_SEC | |
| PAST_DUE_COUNT | |
| WTD_TERMS_OUT_OPEN_NUM_FUNC | |
| WTD_TERMS_OUT_OPEN_NUM_PRIM | |
| WTD_TERMS_OUT_OPEN_NUM_SEC | |
| WTD_TERMS_OUT_CURRENT_NUM_FUNC | |
| GID | |
| WTD_TERMS_OUT_CURRENT_NUM_PRIM | |
| WTD_TERMS_OUT_CURRENT_NUM_SEC | |
| WTD_DDSO_DUE_NUM_FUNC | |
| WTD_DDSO_DUE_NUM_PRIM | |
| WTD_DDSO_DUE_NUM_SEC | |
| TOTAL_OPEN_AMOUNT_FUNC | |
| TOTAL_OPEN_AMOUNT_PRIM | |
| TOTAL_OPEN_AMOUNT_SEC | |
| TOTAL_OPEN_COUNT | |
| INV_AMOUNT_FUNC | |
| TIME_ID | |
| INV_AMOUNT_PRIM | |
| INV_AMOUNT_SEC | |
| DM_AMOUNT_FUNC | |
| DM_AMOUNT_PRIM | |
| DM_AMOUNT_SEC | |
| CB_AMOUNT_FUNC | |
| CB_AMOUNT_PRIM | |
| CB_AMOUNT_SEC | |
| BR_AMOUNT_FUNC | |
| BR_AMOUNT_PRIM | |
| PERIOD_TYPE_ID | |
| BR_AMOUNT_SEC | |
| DEP_AMOUNT_FUNC | |
| DEP_AMOUNT_PRIM | |
| DEP_AMOUNT_SEC | |
| ON_ACCOUNT_CREDIT_AMOUNT_FUNC | |
| ON_ACCOUNT_CREDIT_AMOUNT_PRIM | |
| ON_ACCOUNT_CREDIT_AMOUNT_SEC | |
| UNAPP_DEP_AMOUNT_FUNC | |
| UNAPP_DEP_AMOUNT_PRIM | |
| UNAPP_DEP_AMOUNT_SEC |
| Application Object Library - FND_CP_IPP_PRINTERS | |
|---|---|
| Column Name | Descritpion |
| DELIVERY_ID | |
| IPP_USE_CHUNKED_BODY | |
| IPP_ATTRIBUTE_CHARSET | |
| IPP_NATURAL_LANGUAGE | |
| IPP_JOB_NAME | |
| IPP_COPIES | |
| IPP_SIDES | |
| IPP_ORIENTATIONS | |
| IPP_DOCUMENT_FORMAT | |
| IPP_PAGE_RANGES | |
| SUPPORT_FAX | |
| IPP_HOST | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_LOGIN | |
| IPP_PORT | |
| IPP_PRINTER_NAME | |
| IPP_AUTHTYPE | |
| IPP_USERNAME | |
| IPP_PASSWORD | |
| IPP_ENCTYPE | |
| IPP_USE_FULL_URL |
| Application Object Library - FND_CP_DELIVERY_OPTIONS | |
|---|---|
| Column Name | Descritpion |
| DELIVERY_ID | |
| LAST_UPDATE_LOGIN | |
| DELIVERY_NAME | |
| DELIVERY_TYPE | |
| DESCRIPTION | |
| ENABLED_FLAG | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| CREATION_DATE | |
| CREATED_BY |
No hay comentarios:
Publicar un comentario