PeopleSoft 9
Asset Management

Table Name PROPERTY_TAX

Table Description
PROPERTY_TAX
Columns
Name Datatype Is PK Is FK
OPRID char(30) Yes Yes
RUN_ID char(25) Yes Yes
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes Yes
CF_SEQNO int Yes Yes
ACCOUNT char(10) Yes Yes
ALTACCT char(10) Yes Yes
DEPTID char(10) Yes No
CATEGORY char(5) Yes No
COST_TYPE char(1) Yes No
OPERATING_UNIT char(8) No No
PRODUCT char(6) No No
FUND_CODE char(5) No No
CLASS_FLD char(5) No No
PROGRAM_CODE char(5) No No
BUDGET_REF char(8) No No
AFFILIATE char(5) No No
AFFILIATE_INTRA1 char(10) No No
AFFILIATE_INTRA2 char(10) No No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
PROJECT_ID char(15) No No
DESCR char(30) No No
COST decimal(26,3) No No
CURRENCY_CD char(3) No No
SETID char(5) No No
LOCATION char(10) No No
ASSET_CLASS char(10) No No
PROFILE_ID char(10) No No
ACCUM_DEPR decimal(26,3) No No
NET_BK_VALUE decimal(26,3) No No
AS_OF_DATE PSDATE No No
ACQUISITION_DT PSDATE No No
CAP_NUM char(15) No No
TAG_NUMBER char(12) No No
MANUFACTURER char(30) No No
MODEL char(30) No No
SERIAL_ID char(20) No No
CUSTODIAN char(30) No No
METHOD char(2) No No
LIFE smallint No No
RETIREMENT_DT PSDATE No No
DATE_TRANSFER PSDATE No No
TRANS_IN_OUT char(1) No No
LEASE_ASSET_ID char(12) No No
ORIGINAL_COST decimal(26,3) No No
DESCR1 char(30) No No
Index
Name Type Unique Member
PS_PROPERTY_TAX PK Yes
Member(s) of "PS_PROPERTY_TAX" Index
OPRID
RUN_ID
BUSINESS_UNIT
ASSET_ID
BOOK
CF_SEQNO
ACCOUNT
ALTACCT
DEPTID
CATEGORY
COST_TYPE

Published December 16, 2006