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

TABLE: JA.JAI_AP_ETDS_T

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


This table stores the details as required by the eTDS specifications. After processing the details are stored in this table and is later used for reporting.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_AP_ETDS_T_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15)
Batch Identifier
CHALLAN_LINE_NUM NUMBER (15)
Challan line number
DEDUCTEE_LINE_NUM NUMBER (15)
Deductee Line number
BASE_INVOICE_ID NUMBER (15) Yes Base Invoivce Identifier
TDS_INVOICE_ID NUMBER (15) Yes TDS invoice identifier
TDS_INVOICE_NUM VARCHAR2 (50)
TDS invoice number
TDS_INVOICE_DATE DATE

TDS invoice Date
TDS_SECTION VARCHAR2 (50)
TDS Section
BASE_TAXABALE_AMOUNT NUMBER

Base Taxable Amount
TDS_TAX_ID NUMBER (15)
TDS Tax Identifier
TDS_TAX_RATE NUMBER

TDS Tax Rate
TDS_AMOUNT NUMBER

TDS Amount
TDS_CHECK_ID NUMBER (15)
TDS Check
CHALLAN_NUM VARCHAR2 (25)
Challan number
CHALLAN_DATE DATE

Challan Date
BANK_BRANCH_CODE VARCHAR2 (15)
Bank branch Code
BASE_INVOICE_TYPE_LOOKUP_CODE VARCHAR2 (25)
Base Invoice type identifier
PREPAYMENT_AMOUNT_APPLIED NUMBER

Amount paid through prepayment
BASE_VENDOR_ID NUMBER (15)
Supplier identifier
BASE_VENDOR_SITE_ID NUMBER (15)
Supplier Site identifier
BASE_INVOICE_CHECK_ID NUMBER (15)
Base invoice check identifier
CONSIDER_FOR_CHALLAN NUMBER (9)
Consider for Challan Flag
CONSIDER_FOR_DEDUCTEE NUMBER (9)
Consider for deductee flag
CHALLAN_ERROR VARCHAR2 (100)
Challan error
DEDUCTEE_ERROR VARCHAR2 (100)
Deductee Error
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
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
AMT_OF_TDS NUMBER

Amount of TDS deducted
AMT_OF_SURCHARGE NUMBER

Amount of Surcharge
AMT_OF_CESS NUMBER

Amount of cess applicable
BASE_INVOICE_DATE DATE

Base invoice date
CERTIFICATE_ISSUE_DATE DATE

Certificate issue date
TDS_CHECK_DATE DATE

TDS check date
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
CHECK_NUMBER NUMBER (15)
Check Number
TDS_VENDOR_CLASSIFICATION VARCHAR2 (50)
TDS Vendor Classification
Query Text

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


SELECT BATCH_ID
,      CHALLAN_LINE_NUM
,      DEDUCTEE_LINE_NUM
,      BASE_INVOICE_ID
,      TDS_INVOICE_ID
,      TDS_INVOICE_NUM
,      TDS_INVOICE_DATE
,      TDS_SECTION
,      BASE_TAXABALE_AMOUNT
,      TDS_TAX_ID
,      TDS_TAX_RATE
,      TDS_AMOUNT
,      TDS_CHECK_ID
,      CHALLAN_NUM
,      CHALLAN_DATE
,      BANK_BRANCH_CODE
,      BASE_INVOICE_TYPE_LOOKUP_CODE
,      PREPAYMENT_AMOUNT_APPLIED
,      BASE_VENDOR_ID
,      BASE_VENDOR_SITE_ID
,      BASE_INVOICE_CHECK_ID
,      CONSIDER_FOR_CHALLAN
,      CONSIDER_FOR_DEDUCTEE
,      CHALLAN_ERROR
,      DEDUCTEE_ERROR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      AMT_OF_TDS
,      AMT_OF_SURCHARGE
,      AMT_OF_CESS
,      BASE_INVOICE_DATE
,      CERTIFICATE_ISSUE_DATE
,      TDS_CHECK_DATE
,      OBJECT_VERSION_NUMBER
,      CHECK_NUMBER
,      TDS_VENDOR_CLASSIFICATION
FROM JA.JAI_AP_ETDS_T;

Dependencies

[top of page]

JA.JAI_AP_ETDS_T does not reference any database object

JA.JAI_AP_ETDS_T is referenced by following:

SchemaJA
ViewJAI_AP_ETDS_T#