[Home] [Help] [Dependency Information]
Object Name: | PAYBV_US_FEDERAL_ARCHIVE |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAYBV_US_FEDERAL_ARCHIVE |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION_NUMBER | NUMBER | (15) | Yes | |
TAX_UNIT_ID | NUMBER | (15) | ||
EFFECTIVE_DATE | DATE | |||
ASSIGNMENT_ID | NUMBER | (10) | ||
FIT_GROSS | NUMBER | |||
FIT_WITHHELD | NUMBER | |||
REGULAR_EARNINGS | NUMBER | |||
SUPPLEMENTAL_EARNINGS_FOR_FIT | NUMBER | |||
SUPP_EARNINGS_FOR_NWFIT | NUMBER | |||
PRE_TAX_DEDUCTIONS | NUMBER | |||
PRE_TAX_DEDUCTIONS_FOR_FIT | NUMBER | |||
FIT_SUBJECT_WHABLE | NUMBER | |||
FIT_REDUCED_SUBJECT | NUMBER | |||
SS_EE_TAXABLE | NUMBER | |||
SS_EE_WITHHELD | NUMBER | |||
SS_ER_LIABILITY | NUMBER | |||
SS_ER_TAXABLE | NUMBER | |||
SUPPLEMENTAL_EARNINGS_FOR_SS | NUMBER | |||
PRE_TAX_DEDUCTIONS_FOR_SS | NUMBER | |||
SS_SUBJECT | NUMBER | |||
SS_REDUCED_SUBJECT | NUMBER | |||
MEDICARE_EE_TAXABLE | NUMBER | |||
MEDICARE_EE_WITHHELD | NUMBER | |||
MEDICARE_ER_LIABILITY | NUMBER | |||
MEDICARE_ER_TAXABLE | NUMBER | |||
SUPP_EARNINGS_FOR_MEDICARE | NUMBER | |||
PRE_TAX_DEDUCT_FOR_MEDICARE | NUMBER | |||
MEDICARE_SUBJECT | NUMBER | |||
MEDICARE_REDUCED_SUBJECT | NUMBER | |||
SUPP_EARNINGS_FOR_FUTA | NUMBER | |||
PRE_TAX_DEDUCT_FOR_FUTA | NUMBER | |||
FUTA_TAXABLE | NUMBER | |||
FUTA_LIABILITY | NUMBER | |||
FUTA_SUBJECT | NUMBER | |||
FUTA_REDUCED_SUBJECT | NUMBER | |||
EIC_ADVANCE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION_NUMBER
, TAX_UNIT_ID
, EFFECTIVE_DATE
, ASSIGNMENT_ID
, FIT_GROSS
, FIT_WITHHELD
, REGULAR_EARNINGS
, SUPPLEMENTAL_EARNINGS_FOR_FIT
, SUPP_EARNINGS_FOR_NWFIT
, PRE_TAX_DEDUCTIONS
, PRE_TAX_DEDUCTIONS_FOR_FIT
, FIT_SUBJECT_WHABLE
, FIT_REDUCED_SUBJECT
, SS_EE_TAXABLE
, SS_EE_WITHHELD
, SS_ER_LIABILITY
, SS_ER_TAXABLE
, SUPPLEMENTAL_EARNINGS_FOR_SS
, PRE_TAX_DEDUCTIONS_FOR_SS
, SS_SUBJECT
, SS_REDUCED_SUBJECT
, MEDICARE_EE_TAXABLE
, MEDICARE_EE_WITHHELD
, MEDICARE_ER_LIABILITY
, MEDICARE_ER_TAXABLE
, SUPP_EARNINGS_FOR_MEDICARE
, PRE_TAX_DEDUCT_FOR_MEDICARE
, MEDICARE_SUBJECT
, MEDICARE_REDUCED_SUBJECT
, SUPP_EARNINGS_FOR_FUTA
, PRE_TAX_DEDUCT_FOR_FUTA
, FUTA_TAXABLE
, FUTA_LIABILITY
, FUTA_SUBJECT
, FUTA_REDUCED_SUBJECT
, EIC_ADVANCE
FROM APPS.PAYBV_US_FEDERAL_ARCHIVE;
APPS.PAYBV_US_FEDERAL_ARCHIVE is not referenced by any database object
|
|
|