[Home] [Help] [Dependency Information]
Object Name: | PAYBV_US_COUNTY_ARCHIVE |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAYBV_US_COUNTY_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) | ||
JURISDICTION_CODE | VARCHAR2 | (30) | ||
LOCALITY_NAME | VARCHAR2 | (4000) | ||
STATE | VARCHAR2 | (4000) | ||
COUNTY_GROSS | NUMBER | |||
COUNTY_WITHHELD | NUMBER | |||
COUNTY_SUBJ_WHABLE | NUMBER | |||
COUNTY_SUBJ_NWABLE | NUMBER | |||
COUNTY_PRE_TAX_REDNS | NUMBER | |||
COUNTY_SUBJECT | NUMBER | |||
COUNTY_REDUCED_SUBJECT | NUMBER | |||
HEAD_TAX_LIABILITY | NUMBER | |||
HEAD_TAX_WITHHELD | NUMBER | |||
NON_RESIDENT_FLAG | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION_NUMBER
, TAX_UNIT_ID
, EFFECTIVE_DATE
, ASSIGNMENT_ID
, JURISDICTION_CODE
, LOCALITY_NAME
, STATE
, COUNTY_GROSS
, COUNTY_WITHHELD
, COUNTY_SUBJ_WHABLE
, COUNTY_SUBJ_NWABLE
, COUNTY_PRE_TAX_REDNS
, COUNTY_SUBJECT
, COUNTY_REDUCED_SUBJECT
, HEAD_TAX_LIABILITY
, HEAD_TAX_WITHHELD
, NON_RESIDENT_FLAG
FROM APPS.PAYBV_US_COUNTY_ARCHIVE;
APPS.PAYBV_US_COUNTY_ARCHIVE is not referenced by any database object
|
|
|