eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AP.AP_TRIAL_BALANCE

Object Details

Object Name:	AP_TRIAL_BALANCE
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_TRIAL_BALANCE
Subobject Name:
Status:	VALID

AP_TRIAL_BALANCE contains denormalized information
about invoices and payments posted to the accrual set
of books. The Accounts Payable Trial Balance report
uses this information to report on outstanding invoice
liability. There is one row for each set of invoice
distributions or payments with a single accounting date
that you post to the general ledger in a single run of
the posting program.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_TRIAL_BALANCE_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INVOICE_ID ACCOUNTING_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_ID	NUMBER		Yes	Invoice identifier
ACCOUNTING_DATE	DATE		Yes	Accounting date of invoice
PAYMENT_AMOUNT	NUMBER			Amount of posted payment for invoice
DISTRIBUTION_AMOUNT	NUMBER			Amount of posted expense for the invoice
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)		Line number for invoice distribution line

Query Text

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


SELECT INVOICE_ID
,      ACCOUNTING_DATE
,      PAYMENT_AMOUNT
,      DISTRIBUTION_AMOUNT
,      DISTRIBUTION_LINE_NUMBER
FROM AP.AP_TRIAL_BALANCE;

Dependencies

[top of page]

AP.AP_TRIAL_BALANCE does not reference any database object

AP.AP_TRIAL_BALANCE is referenced by following:

APPS: AP_TRIAL_BALANCE