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: AR.AR_PMTS_INTERFACE_LINE_DETAILS

Object Details

Object Name:	AR_PMTS_INTERFACE_LINE_DETAILS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_PMTS_INTERFACE_LINE_DETAILS
Subobject Name:
Status:	VALID

Table used to store Imported Lockbox line level application information that was not validated.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSMISSION_REQUEST_ID	NUMBER	(15)	Yes	Identifies original concurrent request of transmission
TRANSMISSION_RECORD_ID	NUMBER	(15)	Yes	Identifier of the transmission record
STATUS	VARCHAR2	(30)	Yes	Status of the transmission record
INVOICE_NUMBER	VARCHAR2	(50)	Yes	Matching number of invoice that a payment is applied to
APPLY_TO	VARCHAR2	(150)	Yes	Line number of the invoice or "freight" or "charges"
ALLOCATED_RECEIPT_AMOUNT	NUMBER			Amount applied in receipt currency
LINE_AMOUNT	NUMBER			Corresponding invoice line revenue amount
TAX	NUMBER			Corresponding invoice line tax amount
FREIGHT	NUMBER			Corresponding invoice freight amount
CHARGES	NUMBER			Corresponding invoice charges amount
LINE_DISCOUNT	NUMBER			Discounted revenue line amount
TAX_DISCOUNT	NUMBER			Discounted revenue tax amount
FREIGHT_DISCOUNT	NUMBER			Discounted revenue freight amount
COMMENTS	VARCHAR2	(2000)		Comment
AMOUNT_APPLIED	NUMBER			Amount applied in transaction currency.
CUSTOMER_TRX_ID	NUMBER	(20)		Customer Transaction Identifier

Query Text

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


SELECT TRANSMISSION_REQUEST_ID
,      TRANSMISSION_RECORD_ID
,      STATUS
,      INVOICE_NUMBER
,      APPLY_TO
,      ALLOCATED_RECEIPT_AMOUNT
,      LINE_AMOUNT
,      TAX
,      FREIGHT
,      CHARGES
,      LINE_DISCOUNT
,      TAX_DISCOUNT
,      FREIGHT_DISCOUNT
,      COMMENTS
,      AMOUNT_APPLIED
,      CUSTOMER_TRX_ID
FROM AR.AR_PMTS_INTERFACE_LINE_DETAILS;

Dependencies

[top of page]

AR.AR_PMTS_INTERFACE_LINE_DETAILS does not reference any database object

AR.AR_PMTS_INTERFACE_LINE_DETAILS is referenced by following:

APPS: AR_PMTS_INTERFACE_LINE_DETAILS