[Home] [Help] [Dependency Information]
Object Name: | JAI_AP_TDS_REPOSITORY# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
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 | ||
LEGAL_ENTITY_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 |
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#;
|
|
|