[Home] [Help] [Dependency Information]
Object Name: | PSA_MF_BALANCES_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSA.PSA_MF_BALANCES_VIEW |
Subobject Name: | |
Status: | VALID |
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) | Yes | Customer transaction identifier |
CUST_TRX_LINE_GL_DIST_ID | NUMBER | (15) | Yes | Customer transaction line GL distribution Identifier |
CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Yes | Customer transaction line identifier |
LINE_NUMBER | NUMBER | Yes | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_TRX_ID
, CUST_TRX_LINE_GL_DIST_ID
, CUSTOMER_TRX_LINE_ID
, LINE_NUMBER
, AMOUNT_DUE_ORIGINAL
, AMOUNT_APPLIED
, AMOUNT_ADJUSTED
, AMOUNT_CREDITED
, AMOUNT_DISCOUNTED
, AMOUNT_DUE_REMAINING
FROM APPS.PSA_MF_BALANCES_VIEW;
|
|
|