DBA Data[Home] [Help] [Dependency Information]

TABLE: JA.JAI_AP_TDS_REPOSITORY

Object Details
Object Name: JAI_AP_TDS_REPOSITORY
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_AP_TDS_REPOSITORY
Subobject Name:
Status: VALID


This table stores TDS repository information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_AP_TDS_REPOSITORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTDS_REPOSITORY_ID
Columns
Name Datatype Length Mandatory Comments
TDS_REPOSITORY_ID NUMBER
Yes Sequence ID
INVOICE_ID NUMBER

TDS Invoice ID. Can be NULL if the associated Source Invoice did not generate any
INVOICE_NUMBER VARCHAR2 (50)
TDS Invoice Number
TDS_AUTHORITY_ID NUMBER

TDS tax authority ID
TDS_AUTHORITY_SITE_ID NUMBER

TDS tax authority site ID
TDS_INVOICE_TYPE VARCHAR2 (100)
Should be one of the following 'NORMAL', 'RTN', 'REV-RTN', 'TRANSITION', 'ROLLBACK', 'SURCHARGE', 'SURCHARGE ROLLBACK'
THRESHOLD_GRP_ID NUMBER

TDS group ID
THRESHOLD_HDR_ID NUMBER

Threshold Header ID
THRESHOLD_TYPE_ID NUMBER

Threshold Type ID
THRESHOLD_SLAB_ID NUMBER

Threshold Slab ID. To be populated only if TDS is generated by VALIDATE Event
EVENT VARCHAR2 (100)
Event that caused the TDS Invoice to be generated
SOURCE_INVOICE_ID NUMBER
Yes AP Invoice ID
SOURCE_INVOICE_TYPE VARCHAR2 (50) Yes Type of the Supplier Invoice
SOURCE_INVOICE_AMT NUMBER
Yes AP Invoice Amount
SOURCE_ID NUMBER
Yes Vendor ID of the Supplier Invoice
SOURCE_SITE_ID NUMBER
Yes Vendor Site ID of the Supplier Invoice
SOURCE_INVOICE_DATE DATE
Yes Supplier Invoice Date
ACCOUNTING_DATE DATE
Yes Supplier Invoice Accounting Date
APPLIED_FROM_INVOICE_ID NUMBER

To be populated with Prepay Invoice ID if TDS Invoice Type is RTN
APPLIED_FROM_INVOICE_TYPE VARCHAR2 (50)
Type of the Supplier Invoice
APPLIED_FROM_INVOICE_AMT NUMBER

Invoice Amount
APPLIED_FROM_SUPPLIER_ID NUMBER

Vendor ID of the Supplier Invoice
APPLIED_FROM_SUPPLIER_SITE_ID NUMBER

Vendor Site ID of the Supplier Invoice
APPLIED_FROM_INVOICE_DATE DATE

Supplier Invoice Date
APPLIED_FROM_ACCTG_DATE DATE

Supplier Invoice Accounting Date
FROM_SLAB_ID NUMBER

Slab ID prior to application or unapplication or cancellation. To be populated for Surcharge Transition / Rollback / Threshold Transition / Rollback
APPLIED_TO_INVOICE_ID NUMBER

To be populated with Standard Invoice ID if TDS Invoice Type is RTN
APPLIED_TO_INVOICE_TYPE VARCHAR2 (50)
Invoice Type
APPLIED_TO_INVOICE_AMT NUMBER

Invoice Amount
APPLIED_TO_SUPPLIER_ID NUMBER

Vendor ID of the Supplier Invoice
APPLIED_TO_SUPPLIER_SITE_ID NUMBER

Vendor Site ID of the Supplier Invoice
APPLIED_TO_INVOICE_DATE DATE

Supplier Invoice Date
APPLIED_TO_ACCTG_DATE DATE

Supplier Invoice Accounting Date
APPLIED_AMOUNT NUMBER

Applied Amount in case of RTN
TO_SLAB_ID NUMBER

Slab ID after to application or unapplication or cancellation. To be populated for Surcharge Transition / Rollback / Threshold Transition / Rollback
UNAPPLIED_AMOUNT NUMBER

Unapplied Amount
TDS_ACCOUNTING_DATE DATE

TDS Invoice Accounting Date
REGIME_ID NUMBER
Yes Tax Regime ID
REGIME_CODE VARCHAR2 (30) Yes Tax Regime Code
ORG_ID NUMBER
Yes Operating Unit ID
LEGAL_ENTITY_ID NUMBER
Yes Legal Entity ID
ORG_TAN_NUMBER VARCHAR2 (15) Yes Org TAN number
SECTION_TYPE VARCHAR2 (30)
Section Type
SECTION_CODE VARCHAR2 (30)
Section Code
TAX_RATE NUMBER

Tax Rate
TAX_ID NUMBER

Populated only for migrated records
TAX_CATEGORY_ID NUMBER

Tax Category ID
TDS_PAID VARCHAR2 (1)
TDS Paid flag
INVOICE_DELETED VARCHAR2 (1)
Indicates if a TDS Invoice is deleted.
SOURCE_INVOICE_DELETED VARCHAR2 (1)
Indicates if a Supplier Invoice is deleted.
PRIOR_THRESHOLD VARCHAR2 (1)
Indicates if a record before breach any slab.
CHALLAN_NUMBER VARCHAR2 (30)
Challan Number
CHECK_DATE DATE

Check Date
CHECK_DEPOSIT_DATE DATE

Check deposit date
BSR_CODE VARCHAR2 (30)
BSR code
PAYMENT_REFERENCE_ID VARCHAR2 (30)
payment reference ID
TDS_INV_TAX_AMOUNT NUMBER

TDS Invoice Tax Amount in INR
SUPPLIER_CM_AMOUNT NUMBER

Supplier Credit Memo Amount in Entered Currency
BASE_TAX_AMOUNT NUMBER

Taxable Basis
REQUIRED_FOR_ETDS VARCHAR2 (1) Yes Indicates if this record needs to be picked for eTDS Processing
MIGRATED VARCHAR2 (1) Yes Indicates if the Record is created due to Migration
CREATION_DATE DATE
Yes Set who column
CREATED_BY NUMBER
Yes Set who column
LAST_UPDATE_DATE DATE
Yes Set who column
LAST_UPDATE_LOGIN NUMBER

Set who column
LAST_UPDATED_BY NUMBER
Yes Set who column
Query Text

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


SELECT TDS_REPOSITORY_ID
,      INVOICE_ID
,      INVOICE_NUMBER
,      TDS_AUTHORITY_ID
,      TDS_AUTHORITY_SITE_ID
,      TDS_INVOICE_TYPE
,      THRESHOLD_GRP_ID
,      THRESHOLD_HDR_ID
,      THRESHOLD_TYPE_ID
,      THRESHOLD_SLAB_ID
,      EVENT
,      SOURCE_INVOICE_ID
,      SOURCE_INVOICE_TYPE
,      SOURCE_INVOICE_AMT
,      SOURCE_ID
,      SOURCE_SITE_ID
,      SOURCE_INVOICE_DATE
,      ACCOUNTING_DATE
,      APPLIED_FROM_INVOICE_ID
,      APPLIED_FROM_INVOICE_TYPE
,      APPLIED_FROM_INVOICE_AMT
,      APPLIED_FROM_SUPPLIER_ID
,      APPLIED_FROM_SUPPLIER_SITE_ID
,      APPLIED_FROM_INVOICE_DATE
,      APPLIED_FROM_ACCTG_DATE
,      FROM_SLAB_ID
,      APPLIED_TO_INVOICE_ID
,      APPLIED_TO_INVOICE_TYPE
,      APPLIED_TO_INVOICE_AMT
,      APPLIED_TO_SUPPLIER_ID
,      APPLIED_TO_SUPPLIER_SITE_ID
,      APPLIED_TO_INVOICE_DATE
,      APPLIED_TO_ACCTG_DATE
,      APPLIED_AMOUNT
,      TO_SLAB_ID
,      UNAPPLIED_AMOUNT
,      TDS_ACCOUNTING_DATE
,      REGIME_ID
,      REGIME_CODE
,      ORG_ID
,      LEGAL_ENTITY_ID
,      ORG_TAN_NUMBER
,      SECTION_TYPE
,      SECTION_CODE
,      TAX_RATE
,      TAX_ID
,      TAX_CATEGORY_ID
,      TDS_PAID
,      INVOICE_DELETED
,      SOURCE_INVOICE_DELETED
,      PRIOR_THRESHOLD
,      CHALLAN_NUMBER
,      CHECK_DATE
,      CHECK_DEPOSIT_DATE
,      BSR_CODE
,      PAYMENT_REFERENCE_ID
,      TDS_INV_TAX_AMOUNT
,      SUPPLIER_CM_AMOUNT
,      BASE_TAX_AMOUNT
,      REQUIRED_FOR_ETDS
,      MIGRATED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM JA.JAI_AP_TDS_REPOSITORY;

Dependencies

[top of page]

JA.JAI_AP_TDS_REPOSITORY does not reference any database object

JA.JAI_AP_TDS_REPOSITORY is referenced by following:

SchemaJA
ViewJAI_AP_TDS_REPOSITORY#