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_INV_TAXES

Object Details

Object Name:	JAI_AP_TDS_INV_TAXES
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_AP_TDS_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_TDS_INV_TAXES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_ID INVOICE_LINE_NUMBER INVOICE_DISTRIBUTION_ID SECTION_TYPE ACTUAL_TAX_ID
JAI_AP_TDS_INV_TAXES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID INVOICE_DISTRIBUTION_ID
JAI_AP_TDS_INV_TAXES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_DISTRIBUTION_ID
JAI_AP_TDS_INV_TAXES_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TDS_INV_TAX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TDS_INV_TAX_ID	NUMBER	(15)	Yes	TDS invoice tax identifier
INVOICE_ID	NUMBER	(15)		Invoice Identifier
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Invoice Distribution Identifier
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)		Distribution Line number, this is used for synchoronizing in DFF for each distribution
AMOUNT	NUMBER			Amount
SECTION_TYPE	VARCHAR2	(30)	Yes	Section Type, there can be three possible values, TDS_SECTION, WCT_SECTION, ESSI_SECTION
DEFAULT_TYPE	VARCHAR2	(30)		Default type. Possible values are SECTION or TAX. This indicates what has been setup as the default in the additional supplier info.
DEFAULT_SECTION_CODE	VARCHAR2	(30)		Default section code, this will have values only for section type TDS_SECTION
DEFAULT_TAX_ID	NUMBER	(15)		default tax idenitifier
ACTUAL_SECTION_CODE	VARCHAR2	(30)		Actual Section Code. this will have values only for section type TDS_SECTION
ACTUAL_TAX_ID	NUMBER	(15)		actual tax identifier
USER_DELETED_TAX_FLAG	VARCHAR2	(1)		Flag to indicate if user has deleted the tax that was defaulted on to the DFF.
DEFAULT_THRESHOLD_GRP_ID	NUMBER			Default Threshold Group identifier. This will be populated only if the default type is SECTION. This indicates the threshold position that has been used to arrive at the default tax depending on the slabs.
DEFAULT_CUM_THRESHOLD_SLAB_ID	NUMBER			Default Cumulative threshold slab identifier
DEFAULT_CUM_THRESHOLD_STAGE	VARCHAR2	(30)		Threshold position at defaulting. Possible values are BEFORE THRESHOLD, AT THRESHOLD and AFTER THRESHOLD
DEFAULT_SIN_THRESHOLD_SLAB_ID	NUMBER			Default Single threshold slab identifier
DEFAULT_FROM	VARCHAR2	(30)		Default from. Possible values are PO, Receipt, Vendor Site Setup and Vendor Null Site Setup
CONSIDER_FOR_REDEFAULT	VARCHAR2	(2)		Flag to inidicate if the record should be considered for redefaulting. These are for cases where where default is because of a section setup in supplier additional info and it has not been overriden by the user.
TAX_AMOUNT	NUMBER			Tax amount
THRESHOLD_TRX_ID	NUMBER	(15)		Threshold transaction identifier
THRESHOLD_GRP_ID	NUMBER	(15)		Threshold group identifier
THRESHOLD_HDR_ID	NUMBER	(15)		Threshold header identifier
THRESHOLD_SLAB_ID	NUMBER	(15)		Threshold slab identifier
THRESHOLD_SLAB_ID_SINGLE	NUMBER	(15)		Single threshold slab identifier
PROCESS_STATUS	VARCHAR2	(2)		Process Status. Possible values are D-DEFAULTED, R-REDEFAULTED, P-PROCESSED, E-ERROR, X-NOT APPLICABLE, V-INVALID STATUS
PROCESS_MESSAGE	VARCHAR2	(255)		Process Messgae
CODEPATH	VARCHAR2	(1996)		Code path for debug
MATCH_STATUS_FLAG	VARCHAR2	(1)		Match status flag, same as that of ap_invoice_distributions_all.match_status_flag.
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number.
INVOICE_LINE_NUMBER	NUMBER	(15)		Invoice line identification number
CALC_TAX_AMOUNT	NUMBER			Calc Tax Amount
CONSIDER_AMT_FOR_TDS	VARCHAR2	(1)		Indicates if this Distribution needs to be considered for TDS Calculation
VENDOR_ID	NUMBER	(15)		Vendor ID of the Invoice
VENDOR_SITE_ID	NUMBER	(15)		Vendor Site ID of the Invoice
DIST_CODE_COMBINATION_ID	NUMBER	(15)		Distribution Code Combination ID
TAX_LINE_NO	NUMBER	(15)		Tax Line Number
TAX_TYPE	VARCHAR2	(30)		Tax Type
TAX_CATEGORY_ID	NUMBER	(15)		Tax Category to which the Tax ID in ACTUAL_TAX_ID belongs to
PRECEDENCE_1	NUMBER	(15)		Tax Precedence 1
PRECEDENCE_2	NUMBER	(15)		Tax Precedence 2
PRECEDENCE_3	NUMBER	(15)		Tax Precedence 3
PRECEDENCE_4	NUMBER	(15)		Tax Precedence 4
PRECEDENCE_5	NUMBER	(15)		Tax Precedence 5
PRECEDENCE_6	NUMBER	(15)		Tax Precedence 6
PRECEDENCE_7	NUMBER	(15)		Tax Precedence 7
PRECEDENCE_8	NUMBER	(15)		Tax Precedence 8
PRECEDENCE_9	NUMBER	(15)		Tax Precedence 9
PRECEDENCE_10	NUMBER	(15)		Tax Precedence 10
FUNC_TAX_AMOUNT	NUMBER	(15)		Functional Tax Amount
BASE_TAX_AMOUNT	NUMBER	(15)		Taxable Basis
ROUNDED_AMOUNT	NUMBER	(15)		Distribution Amounts are rounded after grouping by Section Code and prorated back
THRESHOLD_TRANSITION	VARCHAR2	(1)		Flag is marked 'Y' if the record is inserted for the purpose of calculating Threshold Transition.
JAI_DISTRIBUTION_ID	NUMBER	(15)		For Future use
TAX_CATEGORY_OVERRIDEN	VARCHAR2	(1)		Indicates of the Tax Category is overridden by user

Query Text

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


SELECT TDS_INV_TAX_ID
,      INVOICE_ID
,      INVOICE_DISTRIBUTION_ID
,      DISTRIBUTION_LINE_NUMBER
,      AMOUNT
,      SECTION_TYPE
,      DEFAULT_TYPE
,      DEFAULT_SECTION_CODE
,      DEFAULT_TAX_ID
,      ACTUAL_SECTION_CODE
,      ACTUAL_TAX_ID
,      USER_DELETED_TAX_FLAG
,      DEFAULT_THRESHOLD_GRP_ID
,      DEFAULT_CUM_THRESHOLD_SLAB_ID
,      DEFAULT_CUM_THRESHOLD_STAGE
,      DEFAULT_SIN_THRESHOLD_SLAB_ID
,      DEFAULT_FROM
,      CONSIDER_FOR_REDEFAULT
,      TAX_AMOUNT
,      THRESHOLD_TRX_ID
,      THRESHOLD_GRP_ID
,      THRESHOLD_HDR_ID
,      THRESHOLD_SLAB_ID
,      THRESHOLD_SLAB_ID_SINGLE
,      PROCESS_STATUS
,      PROCESS_MESSAGE
,      CODEPATH
,      MATCH_STATUS_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      INVOICE_LINE_NUMBER
,      CALC_TAX_AMOUNT
,      CONSIDER_AMT_FOR_TDS
,      VENDOR_ID
,      VENDOR_SITE_ID
,      DIST_CODE_COMBINATION_ID
,      TAX_LINE_NO
,      TAX_TYPE
,      TAX_CATEGORY_ID
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
,      FUNC_TAX_AMOUNT
,      BASE_TAX_AMOUNT
,      ROUNDED_AMOUNT
,      THRESHOLD_TRANSITION
,      JAI_DISTRIBUTION_ID
,      TAX_CATEGORY_OVERRIDEN
FROM JA.JAI_AP_TDS_INV_TAXES;

Dependencies

[top of page]

JA.JAI_AP_TDS_INV_TAXES does not reference any database object

JA.JAI_AP_TDS_INV_TAXES is referenced by following:

JA: JAI_AP_TDS_INV_TAXES#