[Home] [Help] [Dependency Information]
Object Name: | JAI_AP_TDS_F16_DTLS_ALL |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_AP_TDS_F16_DTLS_ALL |
Subobject Name: | |
Status: | VALID |
Stores the invoice information of invoices that have been considered against a particular TDS certificate.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_AP_TDS_F16_DTLS_ALL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | FORM16_DTL_ID |
JAI_AP_TDS_F16_DTLS_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INVOICE_ID |
JAI_AP_TDS_F16_DTLS_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORG_ID |
JAI_AP_TDS_F16_DTLS_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CERTIFICATE_NUM
LINE_NUM FIN_YR ORG_TAN_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Invoice identifier of the supplier invoice against which TDS has been deducted. | |
TDS_INVOICE_ID | NUMBER | (15) | Invoice identifier of the TDS invoice that has been generated to pay TDS. | |
INVOICE_AMOUNT | NUMBER | Vendor invoice amount. | ||
TDS_TAX_RATE | NUMBER | TDS rate. | ||
TDS_INVOICE_AMT | NUMBER | TDS amount. | ||
TDS_INVOICE_AMT_PAID | NUMBER | TDS amount paid. | ||
INVOICE_PAYMENT_ID | NUMBER | (15) | Invoice Payment identifier. | |
ORG_ID | NUMBER | (15) | Organization identifier. | |
IT_CERTIFICATE_NUMBER | VARCHAR2 | (100) | Concessional certificate, if any. | |
IT_CERTIFICATE_RATE | NUMBER | (15) | Concessional certificate rate. | |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
FIN_YR | NUMBER | (9) | Financial year for which the TDS certificate has been generated. | |
TDS_INV_DATE | DATE | TDS invoice generation date. | ||
ORG_TAN_NUM | VARCHAR2 | (50) | Organization TAN number. | |
FORM16_DTL_ID | NUMBER | (15) | Yes | Form 16 detail identifier |
CERTIFICATE_NUM | NUMBER | (15) | TDS certificate number | |
LINE_NUM | NUMBER | (15) | Line number of the TDS certificate. Generated by the system against every invoice that has been included in the certificate.. | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, TDS_INVOICE_ID
, INVOICE_AMOUNT
, TDS_TAX_RATE
, TDS_INVOICE_AMT
, TDS_INVOICE_AMT_PAID
, INVOICE_PAYMENT_ID
, ORG_ID
, IT_CERTIFICATE_NUMBER
, IT_CERTIFICATE_RATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, FIN_YR
, TDS_INV_DATE
, ORG_TAN_NUM
, FORM16_DTL_ID
, CERTIFICATE_NUM
, LINE_NUM
, OBJECT_VERSION_NUMBER
FROM JA.JAI_AP_TDS_F16_DTLS_ALL;
JA.JAI_AP_TDS_F16_DTLS_ALL does not reference any database object
JA.JAI_AP_TDS_F16_DTLS_ALL is referenced by following:
|
|
|