[Home] [Help] [Dependency Information]
Object Name: | JAI_AR_ETCS_T |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_AR_ETCS_T |
Subobject Name: | |
Status: | VALID |
This is a temporary table used for e-tcs filing
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Yes | Batch Identifier |
CHALLAN_LINE_NUM | NUMBER | (15) | Line number of the challan record | |
DEDUCTEE_LINE_NUM | NUMBER | (15) | Line number of the deductee record | |
SOURCE_DOCUMENT_ID | NUMBER | (15) | Yes | Document Identifier of the Invoice, Receipt, CM |
SOURCE_DOCUMENT_DATE | DATE | Transaction Date of the Document | ||
SOURCE_DOCUMENT_TYPE | VARCHAR2 | (50) | Type of the Document | |
LINE_AMT | NUMBER | Line Amount of the Document | ||
EXEMPTED_FLAG | VARCHAR2 | (2) | TCS Exempted Flag | |
TCS_TAX_RATE | NUMBER | TCS Tax Rate | ||
TCS_AMT | NUMBER | Amount of TCS type tax applicable | ||
SURCHARGE_AMT | NUMBER | Amount of Surcharge applicable | ||
CESS_AMT | NUMBER | Amount of Cess applicable | ||
TCS_CHECK_ID | NUMBER | (15) | Indicates the TCS Check Identifier | |
CHALLAN_NO | VARCHAR2 | (25) | Challan Number | |
CHALLAN_DATE | DATE | Challan Date | ||
BANK_BRANCH_CODE | VARCHAR2 | (25) | Bank Branch Code | |
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_SITE_ID | NUMBER | Yes | Party Site Code | |
PARTY_CODE | VARCHAR2 | (2) | Buyer Code | |
PARTY_PAN | VARCHAR2 | (10) | Party PAN | |
CHECK_NUMBER | NUMBER | (15) | Check Number | |
CERTIFICATE_ISSUE_DATE | DATE | Certificate Issue Date | ||
TCS_CHECK_DATE | DATE | TCS Check Date | ||
COLLECTION_FLAG | VARCHAR2 | (1) | Collection Flag of TCS Item | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, CHALLAN_LINE_NUM
, DEDUCTEE_LINE_NUM
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_DATE
, SOURCE_DOCUMENT_TYPE
, LINE_AMT
, EXEMPTED_FLAG
, TCS_TAX_RATE
, TCS_AMT
, SURCHARGE_AMT
, CESS_AMT
, TCS_CHECK_ID
, CHALLAN_NO
, CHALLAN_DATE
, BANK_BRANCH_CODE
, PARTY_ID
, PARTY_SITE_ID
, PARTY_CODE
, PARTY_PAN
, CHECK_NUMBER
, CERTIFICATE_ISSUE_DATE
, TCS_CHECK_DATE
, COLLECTION_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM JA.JAI_AR_ETCS_T;
JA.JAI_AR_ETCS_T does not reference any database object
JA.JAI_AR_ETCS_T is referenced by following:
|
|
|