[Home] [Help] [Dependency Information]
Object Name: | JAI_AP_TDS_INV_PAYMENTS |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_AP_TDS_INV_PAYMENTS |
Subobject Name: | |
Status: | VALID |
This will have the details of all TDS invoices which has been paid
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_AP_TDS_INV_PAYMENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TDS_PAYMENT_ID |
JAI_AP_TDS_INV_PAYMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INVOICE_ID
VENDOR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TDS_PAYMENT_ID | NUMBER | (15) | Yes | TDS payment identifier |
INVOICE_ID | NUMBER | (15) | Yes | Invoice identifier |
INVOICE_DATE | DATE | Invoice date | ||
CHECK_ID | NUMBER | (15) | Check identifier | |
CHECK_DATE | DATE | Check date | ||
CHECK_AMOUNT | NUMBER | Check amount | ||
INVOICE_PAYMENT_ID | NUMBER | (15) | Invoice payment identifier | |
PREPAY_INVOICE_ID | NUMBER | Prepayment invoice identifier | ||
PAYMENT_AMOUNT | NUMBER | Payment amount | ||
PARENT_INVOICE_ID | NUMBER | (15) | Parent invoice identifier | |
PARENT_INVOICE_CANCEL_FLAG | VARCHAR2 | (1) | Parent invoice cancel status | |
THRESHOLD_TRX_ID | NUMBER | (15) | Threshold transaction identifier | |
TDS_SECTION | VARCHAR2 | (30) | TDS section | |
TDS_TAX_ID | NUMBER | (15) | Tax identifier | |
TDS_TAX_RATE | NUMBER | Tax rate | ||
TAXABLE_BASIS | NUMBER | Taxable basis | ||
TAX_AMOUNT | NUMBER | Tax amount | ||
TAX_AUTHORITY_ID | NUMBER | (15) | Tax authority identifier | |
TAX_AUTHORITY_SITE_ID | NUMBER | (15) | Tax authority site identifier | |
VENDOR_ID | NUMBER | (15) | Supplier identifier | |
VENDOR_SITE_ID | NUMBER | (15) | Supplier site identifier | |
ORG_TAN_NUM | VARCHAR2 | (50) | Organization Tan number | |
OPERATING_UNIT_ID | NUMBER | (15) | Operating unit identifier | |
FIN_YEAR | NUMBER | (9) | Financial year | |
FORM16_HDR_ID | NUMBER | (15) | Form 16 header identifier | |
CERTIFICATE_NUM | NUMBER | (15) | Certificate number | |
CERTIFICATE_LINE_NUM | NUMBER | (15) | Certificate line number | |
SOURCE | VARCHAR2 | (30) | Source | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
PROGRAM_ID | NUMBER | (15) | Program identifier | |
PROGRAM_LOGIN_ID | NUMBER | (15) | Program login identifier | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Program application identifier | |
REQUEST_ID | NUMBER | (15) | Request identifier | |
OBJECT_VERSION_NUMBER | NUMBER | Object version number | ||
TAX_CATEGORY_ID | NUMBER | Tax category id for new TDS architecture |
Cut, paste (and edit) the following text to query this object:
SELECT TDS_PAYMENT_ID
, INVOICE_ID
, INVOICE_DATE
, CHECK_ID
, CHECK_DATE
, CHECK_AMOUNT
, INVOICE_PAYMENT_ID
, PREPAY_INVOICE_ID
, PAYMENT_AMOUNT
, PARENT_INVOICE_ID
, PARENT_INVOICE_CANCEL_FLAG
, THRESHOLD_TRX_ID
, TDS_SECTION
, TDS_TAX_ID
, TDS_TAX_RATE
, TAXABLE_BASIS
, TAX_AMOUNT
, TAX_AUTHORITY_ID
, TAX_AUTHORITY_SITE_ID
, VENDOR_ID
, VENDOR_SITE_ID
, ORG_TAN_NUM
, OPERATING_UNIT_ID
, FIN_YEAR
, FORM16_HDR_ID
, CERTIFICATE_NUM
, CERTIFICATE_LINE_NUM
, SOURCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
, OBJECT_VERSION_NUMBER
, TAX_CATEGORY_ID
FROM JA.JAI_AP_TDS_INV_PAYMENTS;
JA.JAI_AP_TDS_INV_PAYMENTS does not reference any database object
JA.JAI_AP_TDS_INV_PAYMENTS is referenced by following:
|
|
|