PeopleSoft 9
Asset Management

Table Name ALLOC_BASIS_SRC

Table Description
ALLOC_BASIS_SRC
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
BASIS_ID char(10) Yes Yes
EFFDT PSDATE Yes Yes
LINE_NBR 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
ACCOUNT char(10) No No
ALTACCT char(10) No No
DEPTID char(10) No No
CATEGORY char(5) No No
COST_TYPE char(1) No Yes
TOTAL_ALLOC_UNITS decimal(13,2) No No
Index
Name Type Unique Member
PS_ALLOC_BASIS_SRC PK Yes
Member(s) of "PS_ALLOC_BASIS_SRC" Index
SETID
BASIS_ID
EFFDT
LINE_NBR

Published December 16, 2006