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

TABLE: AP.AP_LIABILITY_BALANCE

Object Details
Object Name: AP_LIABILITY_BALANCE
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_LIABILITY_BALANCE
Subobject Name:
Status: VALID


AP_LIABILITY_BALANCE contains denormalized information about liability accounting entry lines associated with invoices and payments that have been transferred to GL. The Accounts Payable Trial Balance report uses this information to report on outstanding invoice liability.


Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_LIABILITY_BALANCE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnVENDOR_ID
ColumnVENDOR_SITE_ID
AP_LIABILITY_BALANCE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnINVOICE_ID
Columns
Name Datatype Length Mandatory Comments
AE_LINE_ID NUMBER (15)
Accounting entry line identifier
AE_HEADER_ID NUMBER (15)
Accounting entry header identifier
INVOICE_ID NUMBER (15)
Invoice identifier
CODE_COMBINATION_ID NUMBER (15)
Accounting flexfield identifier for account associated with accounting entry line of type LIABILITY
VENDOR_ID NUMBER (15)
Supplier identifier
SET_OF_BOOKS_ID NUMBER (15)
Set of books identifier
ORG_ID NUMBER (15)
Organization identifier
ACCOUNTING_DATE DATE

Accounting date
ACCOUNTED_DR NUMBER

Debit amount in functional currency
ACCOUNTED_CR NUMBER

Credit amount in functional currency
AE_INVOICE_AMOUNT NUMBER

Invoice amount associated with the accounting entry line
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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_UPDATE_DATE DATE
Yes Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER (15) Yes 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) Yes Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
REQUEST_ID NUMBER (15) Yes Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
JOURNAL_SEQUENCE_ID NUMBER (15)
Global Accounting Engine journal sequence identifier
SLE_HEADER_ID NUMBER (15)
Value of the Global Accounting Engine journal sequence
SLE_LINE_NUM NUMBER

Global Accounting Engine accounting entry line number
VENDOR_SITE_ID NUMBER (15)
Supplier site unique identifier
Query Text

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


SELECT AE_LINE_ID
,      AE_HEADER_ID
,      INVOICE_ID
,      CODE_COMBINATION_ID
,      VENDOR_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      ACCOUNTING_DATE
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      AE_INVOICE_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      JOURNAL_SEQUENCE_ID
,      SLE_HEADER_ID
,      SLE_LINE_NUM
,      VENDOR_SITE_ID
FROM AP.AP_LIABILITY_BALANCE;

Dependencies

[top of page]

AP.AP_LIABILITY_BALANCE does not reference any database object

AP.AP_LIABILITY_BALANCE is referenced by following:

SchemaAPPS
SynonymAP_LIABILITY_BALANCE