[Home] [Help] [Dependency Information]
Object Name: | JAI_AP_ETDS_T# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | ||
CHALLAN_LINE_NUM | NUMBER | (15) | ||
DEDUCTEE_LINE_NUM | NUMBER | (15) | ||
BASE_INVOICE_ID | NUMBER | (15) | Yes | |
TDS_INVOICE_ID | NUMBER | (15) | Yes | |
TDS_INVOICE_NUM | VARCHAR2 | (50) | ||
TDS_INVOICE_DATE | DATE | |||
TDS_SECTION | VARCHAR2 | (50) | ||
BASE_TAXABALE_AMOUNT | NUMBER | |||
TDS_TAX_ID | NUMBER | (15) | ||
TDS_TAX_RATE | NUMBER | |||
TDS_AMOUNT | NUMBER | |||
TDS_CHECK_ID | NUMBER | (15) | ||
CHALLAN_NUM | VARCHAR2 | (25) | ||
CHALLAN_DATE | DATE | |||
BANK_BRANCH_CODE | VARCHAR2 | (15) | ||
BASE_INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | ||
PREPAYMENT_AMOUNT_APPLIED | NUMBER | |||
BASE_VENDOR_ID | NUMBER | (15) | ||
BASE_VENDOR_SITE_ID | NUMBER | (15) | ||
BASE_INVOICE_CHECK_ID | NUMBER | (15) | ||
CONSIDER_FOR_CHALLAN | NUMBER | (9) | ||
CONSIDER_FOR_DEDUCTEE | NUMBER | (9) | ||
CHALLAN_ERROR | VARCHAR2 | (100) | ||
DEDUCTEE_ERROR | VARCHAR2 | (100) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
AMT_OF_TDS | NUMBER | |||
AMT_OF_SURCHARGE | NUMBER | |||
AMT_OF_CESS | NUMBER | |||
BASE_INVOICE_DATE | DATE | |||
CERTIFICATE_ISSUE_DATE | DATE | |||
TDS_CHECK_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | |||
CHECK_NUMBER | NUMBER | (15) | ||
TDS_VENDOR_CLASSIFICATION | VARCHAR2 | (50) |
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#;
|
|
|