DBA Data[Home] [Help] [Dependency Information]

TABLE: IGI.IGI_AR_CASH_BASIS_DISTS_ALL

Object Details
Object Name: IGI_AR_CASH_BASIS_DISTS_ALL
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_AR_CASH_BASIS_DISTS_ALL
Subobject Name:
Status: VALID


IGI_AR_CASH_BASIS_DISTS_ALL stores distribution information for Combined Basis Accounting.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGI_AR_CASH_BASIS_DISTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCASH_BASIS_DISTRIBUTION_ID
IGI_AR_CASH_BASIS_DISTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECEIVABLE_APPLICATION_ID
ColumnSOURCE
ColumnSOURCE_ID
ColumnTYPE
ColumnPOSTING_CONTROL_ID
IGI_AR_CASH_BASIS_DISTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_SCHEDULE_ID
ColumnTYPE
IGI_AR_CASH_BASIS_DISTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSTING_CONTROL_ID
Columns
Name Datatype Length Mandatory Comments
CASH_BASIS_DISTRIBUTION_ID NUMBER (15) Yes Identifier of distribution item
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes 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).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
RECEIVABLE_APPLICATION_ID NUMBER (15) Yes Identifier of record used to determine the application of payments or credit memos associated with this distribution item
SOURCE VARCHAR2 (3) Yes Indicates whether this is a distribution of an ar_adjustments record or ra_cust_trx_line_gl_dist record
SOURCE_ID NUMBER (15) Yes Identifier of ar_adjustments record or ra_cust_trx_line_gl_dist
TYPE VARCHAR2 (15) Yes Indicates whether this is a distribution of Lines, Tax, Freight, Charges, or Invoice
PAYMENT_SCHEDULE_ID NUMBER (15) Yes Payment schedule to which application was made
GL_DATE DATE
Yes General Ledger date
CURRENCY_CODE VARCHAR2 (15) Yes Currency of distribution
AMOUNT NUMBER
Yes Amount posted
ACCTD_AMOUNT NUMBER
Yes Functional currency equivalent of amount
CODE_COMBINATION_ID NUMBER (15) Yes General Ledger Code Combination account
POSTING_CONTROL_ID NUMBER (15) Yes Identifier of General Ledger posting process
GL_POSTED_DATE DATE
Yes Accounting date the distribution amount was posted
RECEIVABLE_APPLICATION_ID_CASH NUMBER (15)
Application that triggered the posting of a credit memo application
ORG_ID NUMBER (15)
Organization identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CASH_BASIS_DISTRIBUTION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RECEIVABLE_APPLICATION_ID
,      SOURCE
,      SOURCE_ID
,      TYPE
,      PAYMENT_SCHEDULE_ID
,      GL_DATE
,      CURRENCY_CODE
,      AMOUNT
,      ACCTD_AMOUNT
,      CODE_COMBINATION_ID
,      POSTING_CONTROL_ID
,      GL_POSTED_DATE
,      RECEIVABLE_APPLICATION_ID_CASH
,      ORG_ID
FROM IGI.IGI_AR_CASH_BASIS_DISTS_ALL;

Dependencies

[top of page]

IGI.IGI_AR_CASH_BASIS_DISTS_ALL does not reference any database object

IGI.IGI_AR_CASH_BASIS_DISTS_ALL is referenced by following:

SchemaIGI
ViewIGI_AR_CASH_BASIS_DISTS_ALL#