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_TDS_DEFAULT

Object Details

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

This is an intermediate table that is used to derive the TDS Section Code and Tax category based on Defaultation Setup before populating into JAI_AP_TDS_INV_TAXES

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_ID	NUMBER	(15)	Yes	Invoice ID
INVOICE_LINE_NUMBER	NUMBER	(15)	Yes	Invoice Line Number
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Yes	Distribution Line Number
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes	Invoice Distribution ID
ACCOUNTING_DATE	DATE		Yes	Accounting Date
DIST_CODE_COMBINATION_ID	NUMBER	(15)	Yes	Distribution Code Combination ID
AMOUNT	NUMBER	(15)	Yes	Distribution Amount
TDS_SECTION_CODE	VARCHAR2	(30)		TDS Section Code
NATURAL_ACCOUNT_VALUE	VARCHAR2	(30)		Natural Account Value
DESCRIPTION	VARCHAR2	(240)		Distribution Description
MATCH_STATUS_FLAG	VARCHAR2	(1)	Yes	Match Status Flag
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(30)	Yes	Line Type Lookup Code
CUMULATIVE_AMT	NUMBER	(15)		Cumulative running Total of the Invoice Distribution Amount ordered by Invoice Distribution ID
TAX_CATEGORY_ID	NUMBER			Tax category ID defaulted for this distribution
CREATION_DATE	DATE		Yes	Set who column
CREATED_BY	NUMBER	(15)	Yes	Set who column
LAST_UPDATE_DATE	DATE		Yes	Set who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Set who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Set who column
OBJECT_VERSION_NUMBER	NUMBER			Object version number

Query Text

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


SELECT INVOICE_ID
,      INVOICE_LINE_NUMBER
,      DISTRIBUTION_LINE_NUMBER
,      INVOICE_DISTRIBUTION_ID
,      ACCOUNTING_DATE
,      DIST_CODE_COMBINATION_ID
,      AMOUNT
,      TDS_SECTION_CODE
,      NATURAL_ACCOUNT_VALUE
,      DESCRIPTION
,      MATCH_STATUS_FLAG
,      LINE_TYPE_LOOKUP_CODE
,      CUMULATIVE_AMT
,      TAX_CATEGORY_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_AP_TDS_DEFAULT;

Dependencies

[top of page]

JA.JAI_AP_TDS_DEFAULT does not reference any database object

JA.JAI_AP_TDS_DEFAULT is referenced by following:

JA: JAI_AP_TDS_DEFAULT#