Skip to content

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

VIEW: JA.JAI_AP_TDS_REPOSITORY#

Object Details
Object Name: JAI_AP_TDS_REPOSITORY#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TDS_REPOSITORY_ID NUMBER
Yes
INVOICE_ID NUMBER

INVOICE_NUMBER VARCHAR2 (50)
TDS_AUTHORITY_ID NUMBER

TDS_AUTHORITY_SITE_ID NUMBER

TDS_INVOICE_TYPE VARCHAR2 (100)
THRESHOLD_GRP_ID NUMBER

THRESHOLD_HDR_ID NUMBER

THRESHOLD_TYPE_ID NUMBER

THRESHOLD_SLAB_ID NUMBER

EVENT VARCHAR2 (100)
SOURCE_INVOICE_ID NUMBER
Yes
SOURCE_INVOICE_TYPE VARCHAR2 (50) Yes
SOURCE_INVOICE_AMT NUMBER
Yes
SOURCE_ID NUMBER
Yes
SOURCE_SITE_ID NUMBER
Yes
SOURCE_INVOICE_DATE DATE
Yes
ACCOUNTING_DATE DATE
Yes
APPLIED_FROM_INVOICE_ID NUMBER

APPLIED_FROM_INVOICE_TYPE VARCHAR2 (50)
APPLIED_FROM_INVOICE_AMT NUMBER

APPLIED_FROM_SUPPLIER_ID NUMBER

APPLIED_FROM_SUPPLIER_SITE_ID NUMBER

APPLIED_FROM_INVOICE_DATE DATE

APPLIED_FROM_ACCTG_DATE DATE

FROM_SLAB_ID NUMBER

APPLIED_TO_INVOICE_ID NUMBER

APPLIED_TO_INVOICE_TYPE VARCHAR2 (50)
APPLIED_TO_INVOICE_AMT NUMBER

APPLIED_TO_SUPPLIER_ID NUMBER

APPLIED_TO_SUPPLIER_SITE_ID NUMBER

APPLIED_TO_INVOICE_DATE DATE

APPLIED_TO_ACCTG_DATE DATE

APPLIED_AMOUNT NUMBER

TO_SLAB_ID NUMBER

UNAPPLIED_AMOUNT NUMBER

TDS_ACCOUNTING_DATE DATE

REGIME_ID NUMBER
Yes
REGIME_CODE VARCHAR2 (30) Yes
ORG_ID NUMBER
Yes
ORG_TAN_NUMBER VARCHAR2 (15) Yes
SECTION_TYPE VARCHAR2 (30)
SECTION_CODE VARCHAR2 (30)
TAX_RATE NUMBER

TAX_ID NUMBER

TAX_CATEGORY_ID NUMBER

TDS_PAID VARCHAR2 (1)
INVOICE_DELETED VARCHAR2 (1)
SOURCE_INVOICE_DELETED VARCHAR2 (1)
PRIOR_THRESHOLD VARCHAR2 (1)
CHALLAN_NUMBER VARCHAR2 (30)
CHECK_DATE DATE

CHECK_DEPOSIT_DATE DATE

BSR_CODE VARCHAR2 (30)
PAYMENT_REFERENCE_ID VARCHAR2 (30)
TDS_INV_TAX_AMOUNT NUMBER

SUPPLIER_CM_AMOUNT NUMBER

BASE_TAX_AMOUNT NUMBER

REQUIRED_FOR_ETDS VARCHAR2 (1) Yes
MIGRATED VARCHAR2 (1) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

LAST_UPDATED_BY NUMBER
Yes
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# references the following:

SchemaJA
TableJAI_AP_TDS_REPOSITORY
JA.JAI_AP_TDS_REPOSITORY# is referenced by following:

SchemaAPPS
SynonymJAI_AP_TDS_REPOSITORY