PeopleSoft 9
Asset Management

Table Name ALLOC_DEFN_DTL

Table Description
ALLOC_DEFN_DTL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ALLOC_ID char(10) Yes Yes
EFFDT PSDATE Yes Yes
BOOK char(10) Yes Yes
OPERATING_UNIT char(8) Yes No
PRODUCT char(6) Yes No
FUND_CODE char(5) Yes No
CLASS_FLD char(5) Yes No
PROGRAM_CODE char(5) Yes No
BUDGET_REF char(8) Yes No
AFFILIATE char(5) Yes No
AFFILIATE_INTRA1 char(10) Yes No
AFFILIATE_INTRA2 char(10) Yes No
PROJECT_ID char(15) Yes No
DEPTID char(10) Yes No
CATEGORY char(5) Yes No
COST_TYPE char(1) Yes Yes
ASSET_ID char(12) Yes Yes
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
BASIS_ID char(10) No No
Index
Name Type Unique Member
PS_ALLOC_DEFN_DTL PK Yes
PSWALLOC_DEFN_DTL IE1 No
Member(s) of "PS_ALLOC_DEFN_DTL" Index
BUSINESS_UNIT
ALLOC_ID
EFFDT
BOOK
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
AFFILIATE_INTRA2
PROJECT_ID
DEPTID
CATEGORY
COST_TYPE
ASSET_ID
Member(s) of "PSWALLOC_DEFN_DTL" Index
BUSINESS_UNIT
ALLOC_ID
EFFDT
BOOK
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
AFFILIATE_INTRA2
PROJECT_ID
DEPTID
CATEGORY

Published December 16, 2006