[Home] [Help] [Dependency Information]
Object Name: | AP_TRIAL_BAL |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_TRIAL_BAL |
Subobject Name: | |
Status: | VALID |
No longer used.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Yes | Invoice identifier |
CODE_COMBINATION_ID | NUMBER | (15) | Yes | Accounting Flexfield identifier |
REMAINING_AMOUNT | NUMBER | Yes | Amount remaining as an outstanding liability | |
VENDOR_ID | NUMBER | (15) | Yes | Supplier identifier |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
ORG_ID | NUMBER | (15) | Organization identifier | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
INVOICE_AMOUNT | NUMBER | Total invoice amount for this liability account |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, CODE_COMBINATION_ID
, REMAINING_AMOUNT
, VENDOR_ID
, SET_OF_BOOKS_ID
, ORG_ID
, REQUEST_ID
, INVOICE_AMOUNT
FROM AP.AP_TRIAL_BAL;
AP.AP_TRIAL_BAL does not reference any database object
AP.AP_TRIAL_BAL is referenced by following:
|
|
|