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_INV_TAXES

Object Details

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

This table stores the details of all the TDS taxes that are applicable on an invoice distribution line. This includes, TDS, WCT and ESSI taxes, attached to the 3 segments of the invoice distribution DFF.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_MATCH_INV_TAXES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID
JAI_AP_MATCH_INV_TAXES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID PO_LINE_ID LINE_LOCATION_ID
JAI_AP_MATCH_INV_TAXES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_DISTRIBUTION_ID
JAI_AP_MATCH_INV_TAXES_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_DISTRIBUTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TAX_DISTRIBUTION_ID	NUMBER		Yes	Tax distribution identifier
INVOICE_ID	NUMBER			Invoice identifier.
PO_HEADER_ID	NUMBER			PO header identifier.
PO_LINE_ID	NUMBER			PO line identifier.
LINE_LOCATION_ID	NUMBER			PO line location identifier.
CHART_OF_ACCOUNTS_ID	NUMBER			Chart of accounts identifier.
SET_OF_BOOKS_ID	NUMBER			Set of Books identifier.
EXCHANGE_RATE	NUMBER			Exchange rate.
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		No longer used
EXCHANGE_DATE	DATE			Exchange date.
CURRENCY_CODE	VARCHAR2	(15)		Invoice currency code.
DSP_CODE_COMBINATION_ID	NUMBER			No longer used
CODE_COMBINATION_ID	NUMBER			Code combination identifier of the invoice distribution.
TAX_ID	NUMBER			Tax identifier.
TAX_AMOUNT	NUMBER			Tax amount.
LINE_NO	NUMBER			No longer used
ACCT_PAY_CODE_COMBINATION_ID	NUMBER			Account pay code combination identifier of the invoice
EXCHANGE_RATE_VARIANCE	NUMBER			No longer used
BASE_AMOUNT	NUMBER			Tax amount as in Receipt / PO.
ACCOUNTING_DATE	DATE			Accounting date as populated in the invoice distributions.
MATCH_STATUS_FLAG	VARCHAR2	(1)		No longer used
RATE_VAR_CODE_COMBINATION_ID	NUMBER	(15)		No longer used
DISTRIBUTION_LINE_NUMBER	NUMBER			Distribution identifier of the tax line in the payable invoice distributions.
ASSETS_TRACKING_FLAG	VARCHAR2	(1)		Tracked as asset indicator.
REVERSAL_FLAG	VARCHAR2	(1)		No longer used
PARENT_INVOICE_ID	NUMBER			No longer used
SHIPMENT_LINE_ID	NUMBER			No longer used
SHIPMENT_HEADER_ID	NUMBER			No longer used
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
VAT_INVOICE_NO	VARCHAR2	(150)		Not currently used
VAT_INVOICE_DATE	DATE			Not currently used
VAT_INVOICE_ENTERED_DATE	DATE			Not currently used
PO_DISTRIBUTION_ID	NUMBER			PO Distribution identifier
PARENT_INVOICE_DISTRIBUTION_ID	NUMBER			Payable Invoice distribution identifier.
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes	Identifier of Invoice Distribution
RCV_TRANSACTION_ID	NUMBER	(15)		Identifier of Receiving Transaction
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Indicates the line Type
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
INVOICE_LINE_NUMBER	NUMBER	(15)		Invoice line identification number
PARENT_INVOICE_LINE_NUMBER	NUMBER	(15)		Identifies the parent invoice line number
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity identifier
RECOVERABLE_FLAG	VARCHAR2	(1)		Indicates whether a tax line is recoverable or not.

Query Text

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


SELECT TAX_DISTRIBUTION_ID
,      INVOICE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      CHART_OF_ACCOUNTS_ID
,      SET_OF_BOOKS_ID
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      CURRENCY_CODE
,      DSP_CODE_COMBINATION_ID
,      CODE_COMBINATION_ID
,      TAX_ID
,      TAX_AMOUNT
,      LINE_NO
,      ACCT_PAY_CODE_COMBINATION_ID
,      EXCHANGE_RATE_VARIANCE
,      BASE_AMOUNT
,      ACCOUNTING_DATE
,      MATCH_STATUS_FLAG
,      RATE_VAR_CODE_COMBINATION_ID
,      DISTRIBUTION_LINE_NUMBER
,      ASSETS_TRACKING_FLAG
,      REVERSAL_FLAG
,      PARENT_INVOICE_ID
,      SHIPMENT_LINE_ID
,      SHIPMENT_HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      VAT_INVOICE_NO
,      VAT_INVOICE_DATE
,      VAT_INVOICE_ENTERED_DATE
,      PO_DISTRIBUTION_ID
,      PARENT_INVOICE_DISTRIBUTION_ID
,      INVOICE_DISTRIBUTION_ID
,      RCV_TRANSACTION_ID
,      LINE_TYPE_LOOKUP_CODE
,      OBJECT_VERSION_NUMBER
,      INVOICE_LINE_NUMBER
,      PARENT_INVOICE_LINE_NUMBER
,      LEGAL_ENTITY_ID
,      RECOVERABLE_FLAG
FROM JA.JAI_AP_MATCH_INV_TAXES;

Dependencies

[top of page]

JA.JAI_AP_MATCH_INV_TAXES does not reference any database object

JA.JAI_AP_MATCH_INV_TAXES is referenced by following:

APPS: JAI_AP_MATCH_INV_TAXES