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: JA.JAI_AP_MATCH_ERS_T

Object Details

Object Name:	JAI_AP_MATCH_ERS_T
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_AP_MATCH_ERS_T
Subobject Name:
Status:	VALID

Stores Invoice details of ERS invoices, so that taxes can be carried from Purchasing to Payables. This table is used for bulk propagation of taxes by concurrent India - to insert taxes by pay on receipt.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_MATCH_ERS_T_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_ID INVOICE_LINE_NUMBER
JAI_AP_MATCH_ERS_T_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ERROR_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_ID	NUMBER	(15)		Invoice identifier.
PO_DISTRIBUTION_ID	NUMBER	(15)		Po distribution line identifier.
QUANTITY_INVOICED	NUMBER			Quantity invoiced.
SHIPMENT_HEADER_ID	NUMBER			Shipment header identifier.
RECEIPT_NUM	VARCHAR2	(30)		Receipt number.
RECEIPT_CODE	VARCHAR2	(25)		Receipt code like pay on receipt.
REMATCHING	VARCHAR2	(15)		Rematching details.
RCV_TRANSACTION_ID	NUMBER	(15)		Receipt transactions identifier.
AMOUNT	NUMBER			Amount.
ORG_ID	NUMBER	(15)	Yes	Operating unit identifier
CREATION_DATE	DATE			Standard Who column
ERROR_FLAG	VARCHAR2	(1)		If the line is not processed successfully to invoice distributions, this flag is set to Y.
PROCESSING_TIME	DATE			Time that the concurrent India - to insert taxes for pay on receipt processed this line. This will be populated only for error lines.
ERROR_MESSAGE	VARCHAR2	(1996)		Error message encountered by the concurrent India - to insert taxes for pay on receipt. This will be populated only for cases where error is encountered.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
INVOICE_LINE_NUMBER	NUMBER	(15)		Invoice line identification number
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		No longer used
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)		Invoice Distribution line number.

Query Text

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


SELECT INVOICE_ID
,      PO_DISTRIBUTION_ID
,      QUANTITY_INVOICED
,      SHIPMENT_HEADER_ID
,      RECEIPT_NUM
,      RECEIPT_CODE
,      REMATCHING
,      RCV_TRANSACTION_ID
,      AMOUNT
,      ORG_ID
,      CREATION_DATE
,      ERROR_FLAG
,      PROCESSING_TIME
,      ERROR_MESSAGE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      INVOICE_LINE_NUMBER
,      INVOICE_DISTRIBUTION_ID
,      DISTRIBUTION_LINE_NUMBER
FROM JA.JAI_AP_MATCH_ERS_T;

Dependencies

[top of page]

JA.JAI_AP_MATCH_ERS_T does not reference any database object

JA.JAI_AP_MATCH_ERS_T is referenced by following:

APPS: JAI_AP_MATCH_ERS_T