PeopleSoft 9
Asset Management

Table Name ASSET_PROP_TAX

Table Description
ASSET_PROP_TAX
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
TAX_YEAR char(10) Yes No
TAX_DUE_DT PSDATE Yes No
TAX_AUTHORITY_CD char(3) Yes Yes
PROPERTY_TAX_CD char(3) Yes Yes
INSTALLMENT_NBR smallint Yes No
INSTALLMENT_AMT decimal(26,3) No No
TAX_DELINQUENCY_DT PSDATE No No
TAX_AMT decimal(26,3) No No
CURRENCY_CD char(3) No No
Index
Name Type Unique Member
PS_ASSET_PROP_TAX PK Yes
Member(s) of "PS_ASSET_PROP_TAX" Index
BUSINESS_UNIT
ASSET_ID
TAX_YEAR
TAX_DUE_DT
TAX_AUTHORITY_CD
PROPERTY_TAX_CD
INSTALLMENT_NBR

Published December 16, 2006