This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: | This table holds the parent child relationship hierarchy of budgetary control accounting events. The hierarchy is used to link accounting lines together which are bound by allocation attributes. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_BC_ALLOC_GT_U1 | UNIQUE |
HIERARCHY_ID
AE_HEADER_ID AE_LINE_NUM EVENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | (15) | Y | Hierarchy Identifier |
AE_HEADER_ID | NUMBER | (15) | Y | Subledger journal entry identifier |
AE_LINE_NUM | NUMBER | (15) | Y | Subledger journal entry identifier |
EVENT_ID | NUMBER | (15) | Y | Event Identifier |
STATUS_CODE | VARCHAR2 | (1) | Y | Status Code |
PSA.PSA_BC_ALLOC_GT does not reference any database object
PSA.PSA_BC_ALLOC_GT is referenced by following:
Description: | This is an interface table for Budgetary Control Results Report. Product teams insert data in this table prior to invoking the report. Data can be inserted in two ways: By Packet, By Event. If event is passed, the corresponding transaction |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | Event Identifier | |
PACKET_ID | NUMBER | (15) | Packet Identifier | |
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Source Distribution Type | |
SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | (15) | Transaction source distribution identifier | |
SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | (15) | Transaction source distribution identifier | |
SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | (15) | Transaction source distribution identifier | |
SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | (15) | Transaction source distribution identifier | |
SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | (15) | Transaction source distribution identifier |
PSA.PSA_BC_REPORT_EVENTS_GT does not reference any database object
PSA.PSA_BC_REPORT_EVENTS_GT is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | ||
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | ||
APPLICATION_NAME | VARCHAR2 | (240) | ||
EVENT_ID | NUMBER | (15) | ||
LEDGER_ID | NUMBER | (15) | ||
ROW_ID | VARCHAR2 | (30) | ||
PACKET_ID | NUMBER | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
FUNDING_BUDGET_NAME | VARCHAR2 | (15) | ||
BUDGET_TYPE | VARCHAR2 | (15) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
JE_SOURCE_NAME | VARCHAR2 | (25) | ||
JE_CATEGORY_NAME | VARCHAR2 | (25) | ||
BUDGET_LEVEL | VARCHAR2 | (25) | ||
JE_BATCH_NAME | VARCHAR2 | (100) | ||
TREASURY_SYMBOL | VARCHAR2 | (100) | ||
JE_BATCH_ID | NUMBER | (15) | ||
JE_HEADER_ID | NUMBER | (15) | ||
JE_HEADER_NAME | VARCHAR2 | (100) | ||
JOURNAL_LINE_NUMBER | VARCHAR2 | (15) | ||
CCID | NUMBER | (15) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
ACCOUNT_TYPE | VARCHAR2 | (1) | ||
ACCOUNT_TYPE_MEANING | VARCHAR2 | (240) | ||
ACCOUNT_CATEGORY_CODE | VARCHAR2 | (1) | ||
ACCOUNT_SEGMENT_VALUE | VARCHAR2 | (25) | ||
ACTUAL_FLAG | VARCHAR2 | (1) | ||
ACTUAL_FLAG_MEANING | VARCHAR2 | (240) | ||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
AMOUNT_TYPE_MEANING | VARCHAR2 | (25) | ||
ENCUMBRANCE_TYPE | VARCHAR2 | (30) | ||
TEMPLATE_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
FUNDS_CHECK_STATUS_CODE | VARCHAR2 | (1) | ||
FUNDS_CHECK_STATUS | VARCHAR2 | (80) | ||
EFFECTIVE_STATUS | VARCHAR2 | (1) | ||
FUNDS_CHECK_LEVEL_CODE | VARCHAR2 | (1) | ||
FUNDS_CHECK_LEVEL_MEANING | VARCHAR2 | (25) | ||
RESULT_CODE | VARCHAR2 | (3) | ||
RESULT_MESSAGE | VARCHAR2 | (2000) | ||
BOUNDARY_CODE | VARCHAR2 | (1) | ||
BOUNDARY | VARCHAR2 | (25) | ||
DEBIT_CREDIT_INDICATOR | VARCHAR2 | (1) | ||
AMOUNT | NUMBER | |||
DEBIT_AMOUNT_ACCOUNTED | NUMBER | |||
CREDIT_AMOUNT_ACCOUNTED | NUMBER | |||
BUDGET_POSTED_BALANCE | NUMBER | |||
BUDGET_APPROVED_BALANCE | NUMBER | |||
BUDGET_PENDING_BALANCE | NUMBER | |||
BUDGET_TOTAL_BALANCE | NUMBER | |||
ENCUMBRANCE_POSTED_BALANCE | NUMBER | |||
ENCUMBRANCE_APPROVED_BALANCE | NUMBER | |||
ENCUMBRANCE_PENDING_BALANCE | NUMBER | |||
ENCUMBRANCE_TOTAL_BALANCE | NUMBER | |||
ACTUAL_POSTED_BALANCE | NUMBER | |||
ACTUAL_APPROVED_BALANCE | NUMBER | |||
ACTUAL_PENDING_BALANCE | NUMBER | |||
ACTUAL_TOTAL_BALANCE | NUMBER | |||
AVAILABLE_POSTED_BALANCE | NUMBER | |||
AVAILABLE_APPROVED_BALANCE | NUMBER | |||
AVAILABLE_PENDING_BALANCE | NUMBER | |||
AVAILABLE_TOTAL_BALANCE | NUMBER | |||
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | (38) | ||
DOCUMENT_REFERENCE | VARCHAR2 | (240) | ||
LINE_REFERENCE | VARCHAR2 | (240) | ||
BATCH_REFERENCE | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_4 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_5 | VARCHAR2 | (240) | ||
PARTY_ID | VARCHAR2 | (100) | ||
PARTY_SITE_ID | VARCHAR2 | (100) | ||
VENDOR_NAME | VARCHAR2 | (240) | ||
VENDOR_SITE_NAME | VARCHAR2 | (15) | ||
PAYMENT_FORECAST_LINE_NUMBER | VARCHAR2 | (15) | ||
PA_FLAG | VARCHAR2 | (1) | ||
ACCOUNTING_FLEXFIELD | VARCHAR2 | (2000) | ||
SUMMARY_ACCOUNT_INDICATOR | VARCHAR2 | (1) | ||
PO_LINE_NUMBER | NUMBER | |||
PO_DIST_LINE_NUMBER | NUMBER | |||
PO_SHIP_LINE_NUMBER | NUMBER | |||
REQ_LINE_NUMBER | NUMBER | |||
REQ_DIST_LINE_NUMBER | NUMBER | |||
INV_LINE_NUMBER | VARCHAR2 | (15) | ||
DOCUMENT_SEQUENCE_NUMBER | NUMBER | |||
AE_HEADER_ID | NUMBER | |||
AE_LINE_NUM | NUMBER | |||
PERIOD_NUM | NUMBER | |||
PERIOD_YEAR | NUMBER | |||
QUARTER_NUM | NUMBER | |||
COMM_ENCUM_POSTED_BAL | NUMBER | |||
COMM_ENCUM_APPROVED_BAL | NUMBER | |||
COMM_ENCUM_PENDING_BAL | NUMBER | |||
COMM_ENCUM_TOTAL_BAL | NUMBER | |||
OBLI_ENCUM_POSTED_BAL | NUMBER | |||
OBLI_ENCUM_APPROVED_BAL | NUMBER | |||
OBLI_ENCUM_PENDING_BAL | NUMBER | |||
OBLI_ENCUM_TOTAL_BAL | NUMBER | |||
ERROR_SOURCE | VARCHAR2 | (1) | ||
CURRENT_FUNDS_AVAILABLE | NUMBER | |||
DOCUMENT_STATUS | VARCHAR2 | (240) |
APPS.PSA_BC_RESULTS_GT does not reference any database object
APPS.PSA_BC_RESULTS_GT is referenced by following:
Description: | This is an interface table to invoke accounting with budgetary control. Product teams populate events in this table prior to calling the Budgetary Control API. Events inserted in this table are processed for accounting. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | Y | Event Identifier |
RESULT_CODE | VARCHAR2 | (30) | Y | Result Code |
PSA.PSA_BC_XLA_EVENTS_GT does not reference any database object
PSA.PSA_BC_XLA_EVENTS_GT is referenced by following:
Description: | This table is used to store the debug log messages |
---|
This table is used to store the debug log messages
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_DEBUG_LOG_U1 | UNIQUE | APPS_TS_NOLOGGING |
SESS_SEQ_ID
LINE_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESS_SEQ_ID | NUMBER | (15) | Session Sequence ID | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATION_DATE_CHR | VARCHAR2 | (30) | Creation Date in Character | |
LINE_NUM | NUMBER | (15) | Line Number | |
MESSAGE | VARCHAR2 | (250) | Message |
PSA.PSA_DEBUG_LOG does not reference any database object
PSA.PSA_DEBUG_LOG is referenced by following:
Description: | Enhanced Funds Check Options |
---|
This Table stores Enhanced Funds Check Options
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_EFC_OPTIONS_U1 | UNIQUE | APPS_TS_TX_IDX | SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
MULT_FUNDING_BUDGETS_FLAG | VARCHAR2 | (1) | Y | Multiple Funds Budgets Enabled? |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
PSA.PSA_EFC_OPTIONS does not reference any database object
PSA.PSA_EFC_OPTIONS is referenced by following:
Description: | Summary Budgets with Enhanced Funds Check |
---|
This table stores budget information implemented with enhanced funds check options.
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_EFC_SUMMARY_BUDGETS_U1 | UNIQUE | APPS_TS_TX_IDX |
TEMPLATE_ID
FUNDING_BUDGET_VERSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | (30) | Y | Template identifier |
FUNDING_BUDGET_VERSION_ID | NUMBER | (30) | Y | Funding budget version identifier |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
PSA.PSA_EFC_SUMMARY_BUDGETS does not reference any database object
PSA.PSA_EFC_SUMMARY_BUDGETS is referenced by following:
Description: | Public Sector Advanced Features Implementation |
---|
This table stores whether Public Sector Advanced Features is implemented for an Organization.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PSA_FEATURE | VARCHAR2 | (30) | Y | Public Sector Advanced Feature |
STATUS | VARCHAR2 | (1) | Feature Enabled? | |
ORG_ID | NUMBER | (15) | Y | Organization identifier |
ALLOCATION_METHOD | VARCHAR2 | (3) | Allocation Method | |
MAPPING_REQUIRED | VARCHAR2 | (1) | Mapping Required ? | |
PROGRAM_INSTALLED | VARCHAR2 | (1) | Program Installed ? | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
PSA.PSA_IMPLEMENTATION_ALL does not reference any database object
PSA.PSA_IMPLEMENTATION_ALL is referenced by following:
Description: | This table stores the Multi-Funds Account Mapping Details |
---|
This table stores the Multi-Funds Account Mapping Details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PSA_ACCT_MAPPING_ID | NUMBER | (15) | Y | Foreigh Key to PS_MF_ACCT_MAP_HEADER_ALL |
LOOKUP_TYPE | VARCHAR2 | (30) | ||
LOOKUP_CODE | VARCHAR2 | (30) | ||
SOURCE_ACCOUNT | VARCHAR2 | (25) | Y | Source Account |
TARGET_ACCOUNT | VARCHAR2 | (25) | Y | Target Account |
ORG_ID | NUMBER | (15) | ||
START_DATE_ACTIVE | DATE | Y | Became Active on | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
END_DATE_ACTIVE | DATE | Became inactive on | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
PSA_MF_ACCT_MAP_ID | NUMBER | (15) | Primary Key of this table |
PSA.PSA_MF_ACCOUNT_MAPPING_ALL does not reference any database object
PSA.PSA_MF_ACCOUNT_MAPPING_ALL is referenced by following:
Description: | This table stores the Multi-Funds Account Mapping Headers |
---|
This table stores the Multi-Funds Account Mapping Headers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PSA_ACCT_MAPPING_ID | NUMBER | (15) | Y | Primary Key of the table |
DOCUMENT_CODE | VARCHAR2 | (30) | Document Code | |
LOOKUP_CODE | VARCHAR2 | (30) | Lookup Code | |
ORG_ID | NUMBER | (15) | Organization identifier | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
PSA.PSA_MF_ACCT_MAP_HEADER_ALL does not reference any database object
PSA.PSA_MF_ACCT_MAP_HEADER_ALL is referenced by following:
Description: | Accounts receivable distributions for an adjustment made against a mutiple fund transaction |
---|
This table store the accounts receivable distributions for an adjustment against a multiple fund transaction. Each row includes the GL account, amount and the percent of the accounting entry.
The AMOUNT and PERCENT column in this table is required. The POSTING_CONTROL_ID column is populated by the GL Transfer program. The default value is null or -3. Rows having null POSTING_CONTROL_ID are posted to GL.
The primary key for this table is CUST_TRX_LINE_GL_DIST_ID and ADJUSTMENT_ID.
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_MF_ADJ_DIST_U1 | NONUNIQUE | APPS_TS_TX_IDX |
CUST_TRX_LINE_GL_DIST_ID
ADJUSTMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADJUSTMENT_ID | NUMBER | (15) | Y | Adjustment Identifier |
CUST_TRX_LINE_GL_DIST_ID | NUMBER | (15) | Y | Receivables Distribution Identifier |
MF_ADJUSTMENT_CCID | NUMBER | (15) | Y | General Ledger Code Combination, adjustment account |
AMOUNT | NUMBER | Y | Pro-rated amount of the adjustment | |
PERCENT | NUMBER | Y | Pro-rated percent of the application | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
PREV_CUST_TRX_LINE_ID | NUMBER | (15) | Used to identify changes in the line number of the adjustment | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
COMMENTS | VARCHAR2 | (2000) | Comments | |
POSTING_CONTROL_ID | NUMBER | (15) | Receivables posting batch identifier: -3 or Null means it was not posted | |
PREV_MF_ADJUSTMENT_CCID | NUMBER | (15) | Y | Code-Combination-ID of the previous multi-fund Adjustment |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
PSA.PSA_MF_ADJ_DIST_ALL does not reference any database object
PSA.PSA_MF_ADJ_DIST_ALL is referenced by following:
Description: | Temporary Table to store Adjustment records during GL Transfer |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_MF_ADJ_REC_BUF_N1 | NONUNIQUE | APPS_TS_ARCHIVE | PST_CTRL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADJUSTMENT_ID | NUMBER | Adjustment identifier | ||
USER_ID | NUMBER | User identifier | ||
STATUS | VARCHAR2 | (240) | Status | |
ACTUAL_FLAG | VARCHAR2 | (240) | Actual flag | |
PST_CTRL_ID | NUMBER | Posting control identifier | ||
SOB_ID | NUMBER | Set of Books identifier | ||
SOURCE | VARCHAR2 | (240) | Source | |
ADJ_CAT_NAME | VARCHAR2 | (240) | Adjustment category name | |
BATCH_PREFIX | VARCHAR2 | (240) | Batch prefix | |
SUMMARY_FLAG | VARCHAR2 | (240) | Summary flag | |
PRE_ADJCR_AR | VARCHAR2 | (240) | Precredit receivable | |
PRE_ADJDR_AR | VARCHAR2 | (240) | Predebit receivable | |
PRE_ADJDR_ADJ | VARCHAR2 | (240) | Predebit adjustment | |
PRE_ADJCR_ADJ | VARCHAR2 | (240) | Precredit adjustment | |
PRE_ADJDR | VARCHAR2 | (240) | Predebit | |
PRE_ADJCR | VARCHAR2 | (240) | Precredit | |
PRE_ADJ_NRTAX | VARCHAR2 | (240) | Preadjustment tax | |
PRE_ADJ_FINCHRG | VARCHAR2 | (240) | Preadjustment finance charge | |
PRE_ADJ_FINCHRG_NRTAX | VARCHAR2 | (240) | Pre adjsutment finance charge tax | |
PRE_ADJ_TAX | VARCHAR2 | (240) | Preadjustment tax | |
PRE_ADJ_DEFTAX | VARCHAR2 | (240) | Pre adjsutment deferred tax | |
CLASS_CB | VARCHAR2 | (240) | Class chargeback | |
CLASS_CM | VARCHAR2 | (240) | Class credit memo | |
CLASS_DEP | VARCHAR2 | (240) | Class deposit | |
CLASS_DM | VARCHAR2 | (240) | Class debit memo | |
CLASS_GUAR | VARCHAR2 | (240) | Class guarantee | |
CLASS_INV | VARCHAR2 | (240) | Class invoice | |
POST_GENERAL | VARCHAR2 | (240) | Post general | |
NXTVAL_ID | NUMBER | Next value identifier | ||
START_DATE | DATE | Start date | ||
POST_THRU_DATE | DATE | Post Thru Date | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. |
PSA.PSA_MF_ADJ_REC_BUF does not reference any database object
PSA.PSA_MF_ADJ_REC_BUF is referenced by following:
Description: | Multiple Fund Distributions Error Log |
---|
This table stores transactions, receipts, and adjustments for which multiple accounts receivable distributions were not able to be generated. Each row includes the customer_trx_id, activity_id (cash_receipt_id/adjustment_id), and the error message.
This table is populated by the Multiple Fund Distribution Error report and the Create Multiple Fund Distributions package. Each run generates a unique ERROR_ID. The ERROR_MESSAGE column holds the PL/SQL error message generated while trying to create the distribution.
The Multiple Fund Distribution Error report also deletes rows in this table which are older than five days.
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_MF_DISTRIBUTIONS_LOG_N | NONUNIQUE | APPS_TS_NOLOGGING | ERROR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ERROR_ID | NUMBER | (15) | Y | Error identifier |
ACTIVITY | VARCHAR2 | (15) | Y | Values include Transaction, Receipt, and Adjustment |
CUSTOMER_TRX_ID | NUMBER | (15) | Y | Transaction identifer |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATED_DATE | DATE | Standard Who column | ||
ACTIVITY_ID | NUMBER | (15) | Cash receipt identifier or the Adjustment identifier | |
ERROR_MESSAGE | VARCHAR2 | (2000) | Package name with the PL/SQL error message |
PSA.PSA_MF_DISTRIBUTIONS_LOG does not reference any database object
PSA.PSA_MF_DISTRIBUTIONS_LOG is referenced by following:
Description: | This table store the multi-fund distributions of a miscellaneous receipt |
---|
This table store the multi-fund distributions of a miscellaneous receipt
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MISC_MF_CASH_DIST_ID | NUMBER | (15) | Y | Primary Key of the table |
MISC_CASH_DISTRIBUTION_ID | NUMBER | (15) | Y | Miscellaneous Cash Distribution ID |
DISTRIBUTION_CCID | NUMBER | (15) | Y | Code-COmbination-ID of the Distribution |
CASH_CCID | NUMBER | (15) | Code-Combination-ID of the Cash-Account | |
COMMENTS | VARCHAR2 | (2000) | Comments | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
POSTING_CONTROL_ID | NUMBER | (15) | Posting Control ID | |
GL_DATE | DATE | GL Date | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
REFERENCE1 | VARCHAR2 | (30) | Reference Column | |
REFERENCE2 | DATE | Reference Column | ||
REFERENCE3 | DATE | Reference Column | ||
REFERENCE4 | VARCHAR2 | (30) | Reference Column | |
REFERENCE5 | VARCHAR2 | (30) | Reference Column | |
REVERSAL_CCID | NUMBER | Code-Combination ID of Remittance Account |
PSA.PSA_MF_MISC_DIST_ALL does not reference any database object
PSA.PSA_MF_MISC_DIST_ALL is referenced by following:
Description: | Accounts receivable distributions for a cash receipt or credit memo applied to mutiple fund transaction |
---|
This table store the accounts receivable distributions for a cash receipt or credit memo applied to a multiple fund transaction. Each row includes the GL account, amount and the percent of the accounting entry.
The AMOUNT and PERCENT column in this table is required. The DISCOUNT_AMOUNT and UE_DISCOUNT_AMOUNT column are populated for receipts having earned or unearned discount. These columns are used while computing the amount remaining for each multi-fund receivables account.
The POSTING_CONTROL_ID column is populated by the GL Transfer program. The default value is null or -3. Rows having null POSTING_CONTROL_ID are posted to GL.
The primary key for this table is CUST_TRX_LINE_GL_DIST_ID and RECEIVABLE_APPLICATION_ID.
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_MF_RCT_DIST_U1 | NONUNIQUE | APPS_TS_TX_IDX |
CUST_TRX_LINE_GL_DIST_ID
RECEIVABLE_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECEIVABLE_APPLICATION_ID | NUMBER | (15) | Y | Identifies the receivable application |
CUST_TRX_LINE_GL_DIST_ID | NUMBER | (15) | Y | Receivables Distribution Identifier |
MF_CASH_CCID | NUMBER | (15) | General Ledger Code Combination (cash account) | |
AMOUNT | NUMBER | Pro-rated amount of the application | ||
PERCENT | NUMBER | Pro-rated percent of the application | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
DISCOUNT_CCID | NUMBER | (15) | General Ledger Code Combination (discount) | |
UE_DISCOUNT_CCID | NUMBER | (15) | General Ledger Code Combination (unearned account) | |
DISCOUNT_AMOUNT | NUMBER | Discount amount | ||
UE_DISCOUNT_AMOUNT | NUMBER | Unearned Discount Amount | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
COMMENTS | VARCHAR2 | (2000) | Comments | |
POSTING_CONTROL_ID | NUMBER | (15) | Receivables posting batch identifier: -3 or Null means it was not posted | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
REFERENCE4 | VARCHAR2 | (240) | Receipt Status | |
REFERENCE5 | VARCHAR2 | (240) | Receipt Status | |
REVERSAL_CCID | NUMBER | (15) | Stores code combination of Remittance Account | |
REFERENCE2 | VARCHAR2 | (240) | Receipt Status | |
REFERENCE1 | VARCHAR2 | (240) | Receipt Status | |
REFERENCE3 | VARCHAR2 | (240) | Receipt Status |
PSA.PSA_MF_RCT_DIST_ALL does not reference any database object
PSA.PSA_MF_RCT_DIST_ALL is referenced by following:
Description: | Temporary Table to store Receivable-Application records during GL Transfer |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_MF_RCT_REC_BUF_N1 | NONUNIQUE | APPS_TS_ARCHIVE | PST_CTRL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RA_RECEIVABLE_APPLICATION_ID | NUMBER | Receivable Application Id | ||
USER_ID | NUMBER | User Id | ||
STATUS | VARCHAR2 | (240) | Status | |
ACTUAL_FLAG | VARCHAR2 | (240) | Actual Flag | |
PST_CTRL_ID | NUMBER | Posting Control Id | ||
SOB_ID | NUMBER | Set of Books Id | ||
SOURCE | VARCHAR2 | (240) | Source | |
TRADE_CAT_NAME | VARCHAR2 | (240) | Trade Category Name | |
CCURR_CAT_NAME | VARCHAR2 | (240) | Cross Currency Categoory Name | |
CMAPP_CAT_NAME | VARCHAR2 | (240) | Credit Memo Application Category Name | |
FUNC_CURR | VARCHAR2 | (240) | Functional Currency | |
PRE_TRADEAPP | VARCHAR2 | (240) | Pre Trade Application | |
APP_ONACC | VARCHAR2 | (240) | On Account | |
APP_UNAPP | VARCHAR2 | (240) | Unapplied | |
APP_UNID | VARCHAR2 | (240) | Unidnetified | |
APP_APPLIED | VARCHAR2 | (240) | Applied | |
PRE_ERDISC | VARCHAR2 | (240) | Earned Discount | |
PRE_REC_ERDISC_NRTAX | VARCHAR2 | (240) | Earned Discount Tax | |
PRE_UNDISC | VARCHAR2 | (240) | Unearned Discount | |
PRE_REC_UNDISC_NRTAX | VARCHAR2 | (240) | Unearned Discount Tax | |
PRE_REC_GAIN | VARCHAR2 | (240) | Gain | |
PRE_REC_LOSS | VARCHAR2 | (240) | Loss | |
PRE_REC_CURR_ROUND | VARCHAR2 | (240) | Currency Rounding | |
PRE_REC_TAX | VARCHAR2 | (240) | Tax | |
PRE_REC_DEFTAX | VARCHAR2 | (240) | Deferred Tax | |
CLASS_CB | VARCHAR2 | (240) | Chargeback | |
CLASS_CM | VARCHAR2 | (240) | Credit Memo | |
CLASS_DEP | VARCHAR2 | (240) | Deposit | |
CLASS_DM | VARCHAR2 | (240) | Debit Memo | |
CLASS_GUAR | VARCHAR2 | (240) | Guarantee | |
CLASS_INV | VARCHAR2 | (240) | Invoice | |
POST_GENERAL | VARCHAR2 | (240) | Post General | |
PRE_CMAPP | VARCHAR2 | (240) | Pre Credit Memo Application | |
PRE_CMGAIN | VARCHAR2 | (240) | Pre Credit Memo Gain | |
PRE_CMLOSS | VARCHAR2 | (240) | Pre Credit Memo Loss | |
BATCH_PREFIX | VARCHAR2 | (240) | Batch Prefix | |
SUMMARY_FLAG | VARCHAR2 | (240) | Summary Flag | |
PRE_RECEIPT | VARCHAR2 | (240) | Pre Receipt | |
POST_RECEIPT | VARCHAR2 | (240) | Post Receipt | |
NXTVAL_ID | NUMBER | Next Value Id | ||
START_DATE | DATE | Start Date | ||
POST_THRU_DATE | DATE | Post thru date | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. |
PSA.PSA_MF_RCT_REC_BUF does not reference any database object
PSA.PSA_MF_RCT_REC_BUF is referenced by following:
Description: | Accountsreceivable distributions for a mutiplefund transaction |
---|
This table store the accounts receivable distributions for a multiple fund transaction. Each row includes the GL account, amount and the percent of the accounting entry.
The AMOUNT and PERCENT column in this table is required. The POSTING_CONTROL_ID column is populated by the GL Transfer program. The default value is null or -3. Rows having null POSTING_CONTROL_ID are posted to GL.
The primary key for this table is CUST_TRX_LINE_GL_DIST_ID.
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_MF_TRX_DIST_U1 | UNIQUE | APPS_TS_TX_IDX | CUST_TRX_LINE_GL_DIST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUST_TRX_LINE_GL_DIST_ID | NUMBER | (15) | Y | Receivable distribution identifier |
MF_RECEIVABLES_CCID | NUMBER | (15) | Account identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
POSTING_CONTROL_ID | NUMBER | (15) | Receivables posting batch identifier. -3 or Null means it was not posted. | |
PREV_MF_RECEIVABLES_CCID | NUMBER | (15) | Y | Code-Combination ID of the Previous multi-fund Receivable |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
PSA.PSA_MF_TRX_DIST_ALL does not reference any database object
PSA.PSA_MF_TRX_DIST_ALL is referenced by following:
Description: | Temporary Table to store Transaction-Distribution records during GL Transfer |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_MF_TRX_REC_BUF_N1 | NONUNIQUE | APPS_TS_ARCHIVE | PST_CTRL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_TRX_ID | NUMBER | Customer transaction identifier | ||
USER_ID | NUMBER | User identifier | ||
STATUS | VARCHAR2 | (240) | Status | |
ACTUAL_FLAG | VARCHAR2 | (240) | Actual flag | |
PST_CTRL_ID | NUMBER | Posting control identifier | ||
SOB_ID | NUMBER | Set of Books identifier | ||
SOURCE | VARCHAR2 | (240) | Source | |
CM_CAT_NAME | VARCHAR2 | (240) | Credit memo category name | |
DM_CAT_NAME | VARCHAR2 | (240) | Debit memo category name | |
CB_CAT_NAME | VARCHAR2 | (240) | Chargeback category name | |
INV_CAT_NAME | VARCHAR2 | (240) | Invoice category name | |
BATCH_PREFIX | VARCHAR2 | (240) | Batch prefix | |
SUMMARY_FLAG | VARCHAR2 | (240) | Summary flag | |
PRE_CT_LINE | VARCHAR2 | (240) | Precustomer transaction line | |
POST_CT_LINE | VARCHAR2 | (240) | Postcustomer transaction line | |
CLASS_CB | VARCHAR2 | (240) | Class chargeback | |
CLASS_CM | VARCHAR2 | (240) | Class credit memo | |
CLASS_DM | VARCHAR2 | (240) | Class debit memo | |
CLASS_DEP | VARCHAR2 | (240) | Class deposit | |
CLASS_GUAR | VARCHAR2 | (240) | Class guarantee | |
CLASS_INV | VARCHAR2 | (240) | Class invoice | |
NXTVAL_ID | NUMBER | Next value identifier | ||
START_DATE | DATE | Start date | ||
POST_THRU_DATE | DATE | Post thru date | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. |
PSA.PSA_MF_TRX_REC_BUF does not reference any database object
PSA.PSA_MF_TRX_REC_BUF is referenced by following:
Description: | Thist table stores the posting details for the Misc-Receipts, with respect to their multi-fund entries |
---|
Thist table stores the posting details for the Misc-Receipts, with respect to their multi-fund entries
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CASH_RECEIPT_HISTORY_ID | NUMBER | (15) | Y | Cash Receipt History ID |
POSTING_CONTROL_ID | NUMBER | (15) | Y | Posting Control ID |
GL_DATE | DATE | GL Date |
PSA.PSA_MISC_POSTING does not reference any database object
PSA.PSA_MISC_POSTING is referenced by following:
Description: | This table is created to improve performance of funds checker. It is populated with the budgetary control parameters for each packet, journal source and journal category which are later used by funds checker during budgetary control process |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_OPTION_DETAILS_GT_U1 | UNIQUE |
PACKET_ID
JE_SOURCE_NAME JE_CATEGORY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PACKET_ID | NUMBER | Y | Packet Identifier | |
JE_SOURCE_NAME | VARCHAR2 | (25) | Y | Je Source Name |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Y | Je Category Name |
GL_BC_OPTION_SOURCE | VARCHAR2 | (25) | Y | JE Source Name |
GL_BC_OPTION_CATEGORY | VARCHAR2 | (25) | Y | JE Category Name |
FUNDS_CHECK_LEVEL_CODE | VARCHAR2 | (1) | Y | Funds Check Level Code |
OVERRIDE_AMOUNT | NUMBER | Override Amount | ||
TOLERANCE_PERCENTAGE | NUMBER | Tolerance Percentage | ||
TOLERANCE_AMOUNT | NUMBER | Tolerance Amount |
PSA.PSA_OPTION_DETAILS_GT does not reference any database object
PSA.PSA_OPTION_DETAILS_GT is referenced by following:
Description: | This table stores information whether a receivable activity is of multi-fund type or not |
---|
This table stores information whether a receivable activity is of multi-fund type or not
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PSA_RECEIVABLES_TRX_ID | NUMBER | (16) | Y | Primary Key of the table |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
PSA.PSA_RECEIVABLES_TRX_ALL does not reference any database object
PSA.PSA_RECEIVABLES_TRX_ALL is referenced by following:
Description: | Stores Public Sector Transaction Types Information |
---|
PSA_TRX_TYPES_ALL stores information about each Transaction type which is flagged as a Multi Fund transaction type .
A transaction type will be flagged as a Multi Fund Transaction Type only if there are no invoices, commitments and credit memos created against that transaction type .
The Primary key for this table is PSA_TRX_TYPE_ID
Index | Type | Tablespace | Column |
---|---|---|---|
PSA_TRX_TYPES_U1 | NONUNIQUE | APPS_TS_TX_IDX | PSA_TRX_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PSA_TRX_TYPE_ID | NUMBER | (16) | Y | Transaction type identifier |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
PSA.PSA_TRX_TYPES_ALL does not reference any database object
PSA.PSA_TRX_TYPES_ALL is referenced by following:
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUST_TRX_LINE_GL_DIST_ID | NUMBER | (15) | Y | Receivable distribution identifier |
MF_RECEIVABLES_CCID | NUMBER | (15) | Multiple Funds Receivable Account Identifier | |
CODE_COMBINATION_ID | NUMBER | (15) | Y | Receivable Account Identifier |
AMOUNT | NUMBER | Distribution Amount | ||
PERCENT | NUMBER | Distribution Percent | ||
ACCOUNT_CLASS | VARCHAR2 | (20) | Y | Freight, Receivable, Revenue, AutoInvoice Clearing, Tax, Unbilled Receivable, Unearned Revenue, or Charges account type |
CTL_LINE_NUMBER | NUMBER | Revenue Distribution Line Number | ||
PREV_MF_RECEIVABLES_CCID | NUMBER | (15) | Y | |
POSTING_CONTROL_ID | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.MFAR_TRANSACTIONS_DIST_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
NAME | VARCHAR2 | (30) | Y | Accounting books name |
MULT_FUNDING_BUDGETS_FLAG | VARCHAR2 | (1) | Multiple Funds Budgets Enabled? |
APPS.PSA_EFC_OPTIONS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
PSA_FEATURE | VARCHAR2 | (30) | Y | Public Sector Advanced Feature |
STATUS | VARCHAR2 | (1) | Feature Enabled? | |
ORG_ID | NUMBER | (15) | Y | Organization identifier |
ALLOCATION_METHOD | VARCHAR2 | (3) | Allocation Method | |
MAPPING_REQUIRED | VARCHAR2 | (1) | Mapping Required ? | |
PROGRAM_INSTALLED | VARCHAR2 | (1) | Program Installed ? | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
APPS.PSA_IMPLEMENTATION_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
In Release 11i, lookup information was moved from the PSA_LOOKUPS table to the FND_LOOKUP_TYPES and FND_LOOKUP_VALUES tables respectively. This was done to support Multi-Lingual Support enhancements. The PSA_LOOKUPS table is no longer used. The view PSA_LOOKUP_CODES in Release 11i references the new tables so that all lookup information continues to be available through this view.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Y | QuickCode lookup type |
LOOKUP_CODE | VARCHAR2 | (30) | Y | QuickCode code |
MEANING | VARCHAR2 | (80) | Y | QuickCode meaning |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.PSA_LOOKUP_CODES is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
In Release 11i, lookup information was moved from the PSA_LOOKUPS table to the FND_LOOKUP_TYPES and FND_LOOKUP_VALUES tables respectively. This was done to support Multi-Lingual Support enhancements. The PSA_LOOKUPS table is no longer used. The view PSA_LOOKUP_TYPES in Release 11i references the new tables so that all lookup information continues to be available through this view.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Y | QuickCode lookup type |
DESCRIPTION | VARCHAR2 | (240) | Description | |
USER_UPDATEABLE_FLAG | VARCHAR2 | (1) | User updateable flag | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. |
APPS.PSA_LOOKUP_TYPES is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PSA_MF_ACCT_MAP_ID | NUMBER | (15) | Primary Key of the base table | |
PSA_ACCT_MAPPING_ID | NUMBER | (15) | Y | Foreign Key to the Account Mapping Header |
SOURCE_ACCOUNT | VARCHAR2 | (25) | Y | Source Account |
TARGET_ACCOUNT | VARCHAR2 | (25) | Y | Target Account |
START_DATE_ACTIVE | DATE | Y | Enabled From | |
END_DATE_ACTIVE | DATE | Disabled from | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.PSA_MF_ACCOUNT_MAPPING_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PSA_ACCT_MAPPING_ID | NUMBER | (15) | Y | Primary Key of the base table |
DOCUMENT_CODE | VARCHAR2 | (30) | Document Code | |
LOOKUP_CODE | VARCHAR2 | (30) | Lookup Code | |
ORG_ID | NUMBER | (15) | Organization identifier | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
APPS.PSA_MF_ACCT_MAP_HEADER_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADJUSTMENT_ID | NUMBER | (15) | Y | Adjustment Identifier |
CUST_TRX_LINE_GL_DIST_ID | NUMBER | (15) | Y | Receivables Distribution Identifier |
MF_ADJUSTMENT_CCID | NUMBER | (15) | Y | General Ledger Code Combination, adjustment account |
AMOUNT | NUMBER | Y | Pro-rated amount of the adjustment | |
PERCENT | NUMBER | Y | Pro-rated percent of the application | |
POSTING_CONTROL_ID | NUMBER | (15) | Receivables posting batch identifier: -3 or Null means it was not posted | |
PREV_MF_ADJUSTMENT_CCID | NUMBER | (15) | Y | Code-Combination-ID of the previous multi-fund Adjustment |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
PREV_CUST_TRX_LINE_ID | NUMBER | (15) | Used to identify changes in the line number of the adjustment | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
COMMENTS | VARCHAR2 | (2000) | Comments | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.PSA_MF_ADJ_DIST_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
PSA_MF_BALANCES_VIEW shows the balances per transaction distribution.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_TRX_ID | NUMBER | (15) | Y | Customer transaction identifier |
CUST_TRX_LINE_GL_DIST_ID | NUMBER | (15) | Y | Customer transaction line GL distribution Identifier |
CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Y | Customer transaction line identifier |
LINE_NUMBER | NUMBER | Y | Line number | |
AMOUNT_DUE_ORIGINAL | NUMBER | Amount due original | ||
AMOUNT_APPLIED | NUMBER | Amount applied | ||
AMOUNT_ADJUSTED | NUMBER | Amount adjusted | ||
AMOUNT_CREDITED | NUMBER | Amount credited | ||
AMOUNT_DISCOUNTED | NUMBER | Amount discounted | ||
AMOUNT_DUE_REMAINING | NUMBER | Amount due remaining |
APPS.PSA_MF_BALANCES_VIEW is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
PSA_MF_CRM_DIST_V is used by Multi-Fund Accounts Receivables to view the Revenue and Receivable Accounts that are reversed by applying to a multi-fund transaction.
This View joins PSA_MF_TRX_DIST_ALL and PSA_MF_RCT_DIST_ALL tables.
This View is used for reporting purposes only.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Oracle database row identifier | |
RECEIVABLE_APPLICATION_ID | NUMBER | (15) | Y | Identifies the receivable application |
CUST_TRX_LINE_GL_DIST_ID | NUMBER | (15) | Y | Revenue distribution identifier |
MF_RECEIVABLES_CCID | NUMBER | (15) | Multi-fund transaction distribution receivable account identifier | |
MF_CASH_CCID | NUMBER | (15) | Multi-fund transaction distribution revenue account identifier | |
AMOUNT | NUMBER | Amount credited against the distribution | ||
PERCENT | NUMBER | Percent of amount credited | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
DISCOUNT_CCID | NUMBER | (15) | General Ledger Code Combination for the earned discount distribution | |
UE_DISCOUNT_CCID | NUMBER | (15) | General Ledger Code Combination for the unearned discount distribution | |
DISCOUNT_AMOUNT | NUMBER | Amount of earned discount taken towards the application | ||
UE_DISCOUNT_AMOUNT | NUMBER | Amount of unearned discount taken towards the application | ||
COMMENTS | VARCHAR2 | (2000) | Comments | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
APPS.PSA_MF_CRM_DIST_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
MISC_MF_CASH_DIST_ID | NUMBER | (15) | Y | Multi-Fund Miscellaneous Cash Distribution ID |
MISC_CASH_DISTRIBUTION_ID | NUMBER | (15) | Y | Miscellaneous Cash Distribution ID |
DISTRIBUTION_CCID | NUMBER | (15) | Y | Distribution Code-Combination-ID |
CASH_CCID | NUMBER | (15) | Cash Code-Combination-ID | |
COMMENTS | VARCHAR2 | (2000) | Comments | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
POSTING_CONTROL_ID | NUMBER | (15) | Posting Control ID | |
GL_DATE | DATE | GL Date | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
REFERENCE1 | VARCHAR2 | (30) | Reference Column | |
REFERENCE2 | DATE | Reference Column | ||
REFERENCE3 | DATE | Reference Column | ||
REFERENCE4 | VARCHAR2 | (30) | Reference Column | |
REFERENCE5 | VARCHAR2 | (30) | Reference Column | |
REVERSAL_CCID | NUMBER | Remittance Account CCI |
APPS.PSA_MF_MISC_DIST_V is not referenced by any database object
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_SCHEDULE_ID | NUMBER | (15) | Y | |
CUST_TRX_LINE_GL_DIST_ID | NUMBER | (15) | Y | |
DUE_DATE | DATE | Y | ||
AMOUNT_DUE_ORIGINAL | NUMBER | |||
AMOUNT_DUE_REMAINING | NUMBER | |||
AMOUNT_CREDITED | NUMBER | |||
AMOUNT_IN_DISPUTE | NUMBER | |||
AMOUNT_ADJUSTED_PENDING | NUMBER | |||
STATUS | VARCHAR2 | (30) | Y | |
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Y | |
CLASS | VARCHAR2 | (20) | Y | |
CUST_TRX_TYPE_ID | NUMBER | (15) | ||
CUSTOMER_ID | NUMBER | (15) | ||
CUSTOMER_SITE_USE_ID | NUMBER | (15) | ||
CUSTOMER_TRX_ID | NUMBER | (15) | ||
CASH_RECEIPT_ID | NUMBER | (15) | ||
ASSOCIATED_CASH_RECEIPT_ID | NUMBER | (15) | ||
TERM_ID | NUMBER | (15) | ||
GL_DATE_CLOSED | DATE | Y | ||
ACTUAL_DATE_CLOSED | DATE | Y | ||
AMOUNT_APPLIED | NUMBER | |||
AMOUNT_ADJUSTED | NUMBER | |||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
EXCHANGE_DATE | DATE | |||
EXCHANGE_RATE | NUMBER | |||
TRX_NUMBER | VARCHAR2 | (30) | ||
TRX_DATE | DATE | |||
REVERSED_CASH_RECEIPT_ID | NUMBER | (15) | ||
GL_DATE | DATE | Y | ||
ACCTD_AMOUNT_DUE_REMAINING | NUMBER | |||
RECEIPT_CONFIRMED_FLAG | VARCHAR2 | (1) | ||
DISPUTE_DATE | DATE | |||
ORG_ID | NUMBER | (15) | ||
CONS_INV_ID | NUMBER | (15) | ||
MF_RECEIVABLES_CCID | NUMBER | (15) |
APPS.PSA_MF_PAYMENT_SCHEDULES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
PSA_MF_RCT_DIST_V is a view used by Receipt Distribution Form and Credit Memo Distribution Form.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Oracle Database Row ID | |
RECEIVABLE_APPLICATION_ID | NUMBER | (15) | Y | Identifies the receivable application |
CUST_TRX_LINE_GL_DIST_ID | NUMBER | (15) | Y | Revenue Distribution ID |
MF_CASH_CCID | NUMBER | (15) | Multi-Fund Cash Account Identifier | |
AMOUNT | NUMBER | Amount applied against the Multi-Fund distribution | ||
PERCENT | NUMBER | Percent of amount applied | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
DISCOUNT_CCID | NUMBER | (15) | General Ledger Code Combination for the earned discount distribution | |
UE_DISCOUNT_CCID | NUMBER | (15) | General Ledger Code Combination for the un-earned discount distribution | |
DISCOUNT_AMOUNT | NUMBER | Amount of earned discount taken towards the application | ||
UE_DISCOUNT_AMOUNT | NUMBER | Amount of un-earned discount taken towards the application | ||
COMMENTS | VARCHAR2 | (2000) | Comment | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
POSTING_CONTROL_ID | NUMBER | (15) | Posting Control ID | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
REFERENCE1 | VARCHAR2 | (240) | Reference Column. | |
REFERENCE2 | VARCHAR2 | (240) | Reference Column. | |
REFERENCE3 | VARCHAR2 | (240) | Reference Column. | |
REFERENCE4 | VARCHAR2 | (240) | Reference Column. | |
REFERENCE5 | VARCHAR2 | (240) | Reference Column. | |
REVERSAL_CCID | NUMBER | (15) | Remittance Account CCID |
APPS.PSA_MF_RCT_DIST_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (50) | Y | Receivable Activity Name |
DESCRIPTION | VARCHAR2 | (240) | Receivable Activity Description | |
ORG_ID | NUMBER | (15) | Organization identifier | |
PSA_RECEIVABLES_TRX_ID | NUMBER | (16) | Y | Primary Key of the base table |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.PSA_RECEIVABLES_TRX_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (20) | ||
DESCRIPTION | VARCHAR2 | (80) | ||
ORG_ID | NUMBER | (15) | Organization identifier | |
PSA_TRX_TYPE_ID | NUMBER | (16) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
ORG_NAME | VARCHAR2 | (240) | Y | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.PSA_TRX_TYPES_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |