[Home] [Help] [Dependency Information]
Object Name: | JAI_AP_RGM_PAYMENTS |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_AP_RGM_PAYMENTS |
Subobject Name: | |
Status: | VALID |
This table stores the payment information about payment made to TCS authority.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_AP_RGM_PAYMENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PAYMENT_ID |
JAI_AP_RGM_PAYMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TAX_AUTHORITY_ID
TAX_AUTHORITY_SITE_ID |
JAI_AP_RGM_PAYMENTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SETTLEMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_ID | NUMBER | (15) | Yes | Indicates the unique identifier for every record |
SETTLEMENT_ID | NUMBER | (15) | Yes | Indicates the settlement Identifier. |
CHECK_ID | NUMBER | (15) | Yes | Indicated the Check Identifier of the cheque through which payment was made. |
CHECK_DATE | DATE | Yes | Indicates the date check was issued to TCS authority. | |
CHECK_NUMBER | NUMBER | (15) | Yes | Indicates the check number through which payment was made. |
ORG_TAN_NO | VARCHAR2 | (240) | Yes | Indicates the TAN Number of the organization. |
BANK_BRANCH_ID | NUMBER | (15) | Yes | Indicates the bank branch Identifier. |
TCS_AMOUNT | NUMBER | Indicates the TCS amount to be paid. | ||
SURCHARGE_AMOUNT | NUMBER | Indicates the Surcharge Amount to be Paid | ||
CESS_AMOUNT | NUMBER | Indicates the Cess Amount to be paid. | ||
CHECK_DEPOSIT_DATE | DATE | Yes | Indicates the date when check was deposited. | |
CHALLAN_NO | NUMBER | (5) | Yes | Indicates the challan no issued by the authority. |
TAX_AUTHORITY_ID | NUMBER | (15) | Yes | Indicates the Tax Authority Identifier to whom payment is made |
TAX_AUTHORITY_SITE_ID | NUMBER | (15) | Yes | Indicates the Tax Authority Side identifier. |
VOUCHER_NUMBER | VARCHAR2 | (150) | Indicates the Voucher Number / challan number. | |
BOOK_ENTRY_DEPOSITED | VARCHAR2 | (1) | Indicates whether the book entry is deposited or not | |
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 | |
BSR_CODE | NUMBER | (7) | Yes | Indicates the BSR Code |
OBJECT_VERSION_NUMBER | NUMBER | Standard WHO column | ||
SH_CESS_AMOUNT | NUMBER | Indicates the amount of Secondary and Higher Education Cess |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_ID
, SETTLEMENT_ID
, CHECK_ID
, CHECK_DATE
, CHECK_NUMBER
, ORG_TAN_NO
, BANK_BRANCH_ID
, TCS_AMOUNT
, SURCHARGE_AMOUNT
, CESS_AMOUNT
, CHECK_DEPOSIT_DATE
, CHALLAN_NO
, TAX_AUTHORITY_ID
, TAX_AUTHORITY_SITE_ID
, VOUCHER_NUMBER
, BOOK_ENTRY_DEPOSITED
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, BSR_CODE
, OBJECT_VERSION_NUMBER
, SH_CESS_AMOUNT
FROM JA.JAI_AP_RGM_PAYMENTS;
JA.JAI_AP_RGM_PAYMENTS does not reference any database object
JA.JAI_AP_RGM_PAYMENTS is referenced by following:
|
|
|