PeopleSoft 9
Asset Management

Table Name INFL_ADJ

Table Description
INFL_ADJ
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
BOOK char(10) Yes Yes
ASSET_ID char(12) Yes Yes
FISCAL_YEAR smallint Yes No
ACCOUNTING_PERIOD smallint Yes No
INFL_ADJ_TYPE char(4) Yes No
CF_SEQNO int 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
DEPTID char(10) No No
CATEGORY char(5) No No
COST_TYPE char(1) No No
GROUP_ASSET_ID char(12) No No
TRANS_TYPE char(3) No No
TRANS_IN_OUT char(1) No No
AMOUNT decimal(26,3) No No
AMOUNT_BSE decimal(26,3) No No
CALC_DIST_STATUS char(1) No No
Index
Name Type Unique Member
PS_INFL_ADJ PK Yes
Member(s) of "PS_INFL_ADJ" Index
BUSINESS_UNIT
BOOK
ASSET_ID
FISCAL_YEAR
ACCOUNTING_PERIOD
INFL_ADJ_TYPE
CF_SEQNO

Published December 16, 2006