[Home] [Help] [Dependency Information]
Object Name: | PAY_IE_TAX_TRAILER_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_IE_TAX_TRAILER_INTERFACE |
Subobject Name: | |
Status: | VALID |
Trailer Table to store Tax Credit upload Information
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_TYPE | VARCHAR2 | (2) | Yes | Record Type Indicator, TC for Trailer Record |
RECORD_ID | NUMBER | (8) | Record Id | |
EMPLOYER_NUMBER | VARCHAR2 | (8) | Yes | Employer Paye Reference Number |
RECORD_NO | NUMBER | (10) | Record Number | |
TOTAL_MTH_RATE_CUTOFF | NUMBER | (17) | Total Monthly Rate Cutoff | |
TOTAL_WK_RATE_CUTOFF | NUMBER | (17) | Total Weekly Rate Cutoff | |
TOTAL_MTH_TAX_CREDIT | NUMBER | (17) | Total Monthly tax Credit | |
TOTAL_WK_TAX_CREDIT | NUMBER | (17) | Total Weekly Tax Credit | |
FILLER | VARCHAR2 | (160) | Filler for Further use | |
TC_TOT_YEARLY_TAX_CRED | NUMBER | (17) | Total Yearly Tax Credit | |
TOT_YEARLY_TAX_RATE_1 | NUMBER | (17) | Total Yearly Tax Rate1 | |
TOT_YEARLY_TAX_RATE_2 | NUMBER | (17) | Total Yearly Tax Rate2 | |
TOT_MONTHLY_TAX_RATE_2 | NUMBER | (17) | Total Monthly Tax Rate2 | |
TOT_WEEKLY_TAX_RATE_2 | NUMBER | (17) | Total Weekly Tax Rate2 | |
TOT_YEARLY_TAX_RATE_3 | NUMBER | (17) | Total Yearly Tax Rate3 | |
TOT_MONTHLY_TAX_RATE_3 | NUMBER | (17) | Total Monthly Tax Rate3 | |
TOT_WEEKLY_TAX_RATE_3 | NUMBER | (17) | Total Weekly Tax Rate3 | |
TOT_YEARLY_TAX_RATE_4 | NUMBER | (17) | Total Yearly Tax Rate4 | |
TOT_MONTHLY_TAX_RATE_4 | NUMBER | (17) | Total Monthly Tax Rate4 | |
TOT_WEEKLY_TAX_RATE_4 | NUMBER | (17) | Total Weekly Tax Rate4 | |
TOT_YEARLY_USC_RATE_1 | NUMBER | (17) | Total Yearly USC Rate1 | |
TOT_YEARLY_USC_RATE_2 | NUMBER | (17) | Total Yearly USC Rate2 | |
TOT_YEARLY_USC_RATE_3 | NUMBER | (17) | Total Yearly USC Rate3 | |
TOT_YEARLY_USC_RATE_4 | NUMBER | (17) | Total Yearly USC Rate4 |
Cut, paste (and edit) the following text to query this object:
SELECT RECORD_TYPE
, RECORD_ID
, EMPLOYER_NUMBER
, RECORD_NO
, TOTAL_MTH_RATE_CUTOFF
, TOTAL_WK_RATE_CUTOFF
, TOTAL_MTH_TAX_CREDIT
, TOTAL_WK_TAX_CREDIT
, FILLER
, TC_TOT_YEARLY_TAX_CRED
, TOT_YEARLY_TAX_RATE_1
, TOT_YEARLY_TAX_RATE_2
, TOT_MONTHLY_TAX_RATE_2
, TOT_WEEKLY_TAX_RATE_2
, TOT_YEARLY_TAX_RATE_3
, TOT_MONTHLY_TAX_RATE_3
, TOT_WEEKLY_TAX_RATE_3
, TOT_YEARLY_TAX_RATE_4
, TOT_MONTHLY_TAX_RATE_4
, TOT_WEEKLY_TAX_RATE_4
, TOT_YEARLY_USC_RATE_1
, TOT_YEARLY_USC_RATE_2
, TOT_YEARLY_USC_RATE_3
, TOT_YEARLY_USC_RATE_4
FROM HR.PAY_IE_TAX_TRAILER_INTERFACE;
HR.PAY_IE_TAX_TRAILER_INTERFACE does not reference any database object
HR.PAY_IE_TAX_TRAILER_INTERFACE is referenced by following:
|
|
|